<?php
// Status Package Module
$status_module=select_query("status_module","cms_status_module","id","18");
if($status_module[0]!=1)	{	
	fieldset_no_module();
}
if($_SESSION[dbname]!= "nversion_62"){
$navig['project']="ผลงานของเรา";
navigator($navig);
echo"<br>";
bar_header("ผลงานของเรา"); // Bar_Header
fieldset_top("ผลงานของเรา");
}else{
$navig['project']="สินค้า/บริการ";
navigator($navig);
echo"<br>";
bar_header("สินค้า/บริการ"); // Bar_Header
fieldset_top("สินค้า/บริการ");
}

if($p_id_hide!="")						{	     $id_hide=trim($p_id_hide);									}
if($p_id_show!="")					{	     $id_show=trim($p_id_show);								}
if($p_id_del!="")						{		 $id_del=trim($p_id_del);										}

if($_SESSION[admin_web]=="admin" or (id_top_permission("a"))){
	echo"<table align='center'>";
		echo "<tr bgcolor='ffcc00' height='1'>";
					echo"<td><img src='coremain/images/add.gif' border=0><a href='index.php?path=project&mod=project_add' title='เพิ่มข้อมูล'> เพิ่มข้อมูล</a></td>";
					echo"</td>";
		echo"</tr>";
	echo"</table>";
}

//###################### สำหรับ Admin #######################
// Hide - Show project
		if($id_hide!="")				{		update_query("cms_project","status","0","id",$id_hide);		}
		if($id_show!="")				{		update_query("cms_project","status","1","id",$id_show);		}

// Delete project
		if($id_del!="")					{		delete_query("pic1","pic2","pic3","pic4","files","cms_project","id",$id_del);		}

// ########################แสดงข่าวประชาสัมพันธ์ ###################
echo"<table width='98%' border='0' cellpadding='0' cellspacing='0' align=center>";

$count_project=0;
if($_SESSION[admin_web]=="admin" or (id_top_permission("a"))){
	$sql="select id, topic  ,LEFT(fulltexts, 255) as b,pic1,status from cms_project order by id desc"; 
}else{
	$sql="select id, topic  ,LEFT(fulltexts, 255) as b,pic1,status from cms_project WHERE status='1' order by id desc"; 
}

$result=mysql_query($sql);
while($data = mysql_fetch_array($result)){
$count_project++;
// ######################## แสดงหัวข้อข่าว และเนื้อหาข่าว
echo"<tr height='100'>";
	echo"	<td width='20%' valign='top'>";
				if($data[pic1]!="")		{ 		box_picture_firstpage($data[pic1],"index.php?mod=project_full&id_project=$data[id]&path=project");			}
				else								{		box_nopicture_firstpage("index.php?mod=project_full&id_project=$data[id]&path=project");							}
	echo"</td>";
	echo"<td width='3%' valign='top'></td>";
	echo"<td width='75%' height='100'  valign='top'>";
			echo"<img SRC='coremain/images/marker.gif'> ";
			echo"<a href='index.php?mod=project_full&id_project=$data[id]&path=project'><b>$data[topic]</b></a>&nbsp; ";
						if($count_project==1) echo"<img SRC='coremain/images/news.gif'>";
			echo"<br>&nbsp; &nbsp; &nbsp; ";
			echo strip_tags($data[b]);
	echo"</td>";
echo"</tr>";

// ################## สำหรับ Admin ####################
if($_SESSION[admin_web]=="admin" or (id_top_permission("a"))){
				echo"<tr>";
							echo "<td colspan='3' align=left>&nbsp; &nbsp; &nbsp; &nbsp; ";
										// show - hide
												if($data[status]=='1')		{		box_hide("index.php?mod=project&path=project&id_hide=$data[id]");			}
												else										{		box_show("index.php?mod=project&path=project&id_show=$data[id]");			}
										// update
												box_update("index.php?path=project&mod=project_update&id_update=$data[id]&path=project");					
										// delete
										
												box_delete("index.php?mod=project&path=project&id_del=$data[id]","del_popup");
										// จำนวนผู้เข้าชม
											//	box_counter($data[state]);
															echo "<br><br>";
							echo"</td>";
				echo "</tr>";
		}

}
echo"</table>";
fieldset_down();

?>