|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /var/www/html/pathumthani_vc/report/pdir_v1/ |
Upload File : |
<?
#START
#This Program is copyrigth by Sapphire R&D co.,ltd
#TableMaster=office_detail
#TableValue=officer
#KeyinCode=pdir
#uptodate=yes
#DateModified=21-08-2005
#CreateBy=Pairoj
#END
# ALTER TABLE `officer` ADD `owner_add` VARCHAR( 12 ) NOT NULL ;
include ("../../config/conndb.qpass.php");
$keyword_original = $keyword ;
if (trim($keyword) != ""){
$keyword = "%". $keyword ."%" ;
$keyword_se = "or office_detail.th_name like '$keyword' or officer.th_name like '$keyword' or officer.position like '$keyword' " ;
$keyword_se = $keyword_se ."or officer.th_sname like '$keyword' ";
}
if (trim($dep_sc) != ""){
$keyword = "%". $dep_sc ."%" ;
$keyword_se = $keyword_se . " or office_detail.th_name like '$keyword' " ;
}
if (trim($position_sc) != ""){
$keyword = "%". $position_sc ."%" ;
$keyword_se =$keyword_se . "or officer.position like '$keyword' " ;
}
if (trim($people_sc) != ""){
$keyword = "%". $people_sc ."%" ;
$keyword_se = $keyword_se . "or officer.th_name like '$keyword' " ;
}
switch ($chs) {
case 0:
if ($keyword == "" and $order_by == "" ){ $keyword_se = $keyword_se . " or office_detail.th_name like '%' "; }
break;
case 1:
$keyword_se = $keyword_se . " or office_detail.th_name like 'ก%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ข%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ฃ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ค%' ";
break;
case 2:
$keyword_se = $keyword_se . " or office_detail.th_name like 'ฅ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ฆ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ง%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'จ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ฉ%' ";
break;
case 3:
$keyword_se = $keyword_se . " or office_detail.th_name like 'ช%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ซ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ฌ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ญ%' ";
break;
case 4:
$keyword_se = $keyword_se . " or office_detail.th_name like 'ฎ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ฏ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ฐ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ฑ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ฒ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ณ%' ";
break;
case 5:
$keyword_se = $keyword_se . " or office_detail.th_name like 'ด%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ต%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ถ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ท%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ธ%' ";
break;
case 6:
$keyword_se = $keyword_se . " or office_detail.th_name like 'น%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'บ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ป%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ผ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ฝ%' ";
break;
case 7:
$keyword_se = $keyword_se . " or office_detail.th_name like 'พ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ฟ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ภ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ม%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ย%' ";
break;
case 8:
$keyword_se = $keyword_se . " or office_detail.th_name like 'ร%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ฤ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ฤา%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ล%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ฦ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ฦา%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ว%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ศ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ษ%' ";
break;
case 9:
$keyword_se = $keyword_se . " or office_detail.th_name like 'ส%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ห%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ฬ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'อ%' ";
$keyword_se = $keyword_se . " or office_detail.th_name like 'ฮ%' ";
break;
}
$keyword_se = stripslashes(substr($keyword_se , 4)) ;
if ($col_sel == ""){ $col_sel = "office_detail.th_name" ; }
$sql = " SELECT officer.id, officer.title, officer.th_name, officer.th_sname, officer.position, office_detail.id, office_detail.th_name, ";
$sql = $sql ." office_detail.tel1, office_detail.tel2, office_detail.tel3,mobile FROM office_detail ";
$sql = $sql ." LEFT OUTER JOIN officer ON ( office_detail.id = officer.office_id ) ";
$sql = $sql ." where $keyword_se ORDER BY $col_sel , groupid ASC ";
if ($order_by == "ASC"){ $order_by = " DESC " ; }else { $order_by = " ASC " ; }
$keyword_se = " ".$keyword_se ;
$query_result=mysql_db_query($db_dataentry,$sql);
echo " <!---------------------------------------------------- $db_dataentry -------------------------------------------------------> ";
if ($query_result){
$num_rows = mysql_num_rows($query_result); // จำนวนแถวที่มีทั้งหมด
if ($page_size == "") { $page_size = 25 ; } // จำนวนแถวที่แสดงในแต่่ละหน้า
if ($show_page == "") { $show_page = 1 ; } // หน้าที่ต้องการแสดงผล
$total_page = (($num_rows / $page_size) +1 ) ; // จำนวนหน้าที่แสดงผลทั้งหมด
$first_row = ($page_size * ($show_page-1)) ;
if ($first_row != 0 ){
mysql_data_seek($query_result,$first_row); // กระโดดไป row ที่ต้องการ
}
$i = $first_row ; $j= $first_row ;
$str_show_page = "";
for ($ii = 1 ; $ii < $total_page ; $ii++){
if ($ii == $show_page) {
$str_show_page =$str_show_page . " | <a href=officer.php?ord=0&chs=$chs&show_page=$ii&page_size=$page_size><b>$ii</b></a> " ;
}else{
$str_show_page =$str_show_page . " | <a href=officer.php?ord=0&chs=$chs&show_page=$ii&page_size=$page_size>$ii</a> " ;
}
}
$str_show_page =$str_show_page . " | ";
} // end if ($query_result){
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE>ทำเนียบส่วนราชการ</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<META content="MSHTML 5.00.2614.3500" name=GENERATOR>
<script src="../../common/functions.js" type="text/javascript" language="javascript"></script>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</script>
<SCRIPT LANGUAGE="JavaScript">
<!--Start
function chk_confirm(name01) {
if (!(confirm("ต้องการลบ "+ name01 +" หรือไ่ม่"))){
return false;
}
}
function chk_confirm_person(name01) {
if (!(confirm("ต้องการลบ "+ name01 +" หรือไ่ม่"))){
return false;
}
}
//-->
</SCRIPT>
<script src="../../common/javaopenwin.js" type="text/javascript" language="javascript"> </script>
<link href="../../common/style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
a:link {
color: #000000;
}
a:visited {
color: #000000;
}
-->
</style></HEAD>
<form action="officer.php" method="post" name="form1" target="_self">
<table width="795" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="20" colspan="2"><table width="795" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><img src="../../images_sys/p_direc.jpg" width="795" height="58"></td>
</tr>
<tr>
<td background="../../images_sys/bg_02.jpg"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="4%"> </td>
<td width="5%"> </td>
<td width="74%"> </td>
<td width="17%" align="right"> <a href='#' onClick = show_modify("V9.02C01.03.2005"); >version</a> </td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td width="549" height="20"><font size="2" color="#336699"> <strong><a href ="#" onClick="openwin('Advance_Search.php',450,320);" title="ค้นหาแบบพิเศษ">Advance Search</a>
<input name="keyword" type="text" id="keyword" value="<?=$keyword_original?>">
<input type="submit" name="Submit" value="Go"> <a href="../../pdf/pdir.pdf" target="_blank">ช่วยเหลือ</a></strong></font></td>
<td width="246" align="right"><strong><a href="officer.php?chs=0">All</a>
</strong><a href="officer.php?chs=1">ก-ค</a> <a href="officer.php?chs=2">ฆ-ฉ</a>
<a href="officer.php?chs=3">ช-ญ</a> <a href="officer.php?chs=4">ฎ-ณ</a>
<a href="officer.php?chs=5">ด-ธ</a> <a href="officer.php?chs=6">น-ฝ</a>
<a href="officer.php?chs=7">พ-ย</a> <a href="officer.php?chs=8">ร-ษ</a>
<a href="officer.php?chs=9">ส-ฮ</a> </td>
</tr>
<tr align="right">
<td height="20" colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="23%">ค้นพบทั้งหมด <?=mysql_num_rows($query_result)?> รายการ</td>
<td width="77%" align="right">
<?
// if ($total_page < 2 ){ $str_show_page = "" ; }
if (($ord != 1) and ($keyword == "")){ echo $str_show_page; }
?></td>
</tr>
</table></td>
</tr>
<tr>
<td height="10" colspan="2"><table width="100%" border="0" cellspacing="2" cellpadding="2">
<? //===================================================================================
if (!($query_result)){ echo "<tr><td colspan = 5> ไม่มีรายการ </td></tr>"; die;}
while ($result=mysql_fetch_array($query_result)){
if ($flag_id != $result[id] ) {
$flag_id = $result[id] ;
echo " <tr> <td colspan=5 bgcolor =#AABBCC class= indexbold > ";
?>
<a href ="#" title="รายละเอียด" onClick="openwin3('officer_department.php?id=<?=$result[id]?>',750,480,<?=$result[id]?>);"; >
<strong><?=$result[th_name]?></strong> </a>
<?
echo " </td></tr> ";
if ($result[2] == "") { continue; }
}
$i++; $j++;
if ($bgcolor1 == "DDDDDD"){ $bgcolor1 = "EFEFEF" ; } else {$bgcolor1 = "DDDDDD" ;}
?>
<tr bgcolor =#<?=$bgcolor1?> onmouseover="setPointer(this, <?=$j?>, 'over', '#<?=$bgcolor1?>','#8086B4', ',','#FFCC99');"
onmouseout="setPointer(this, <?=$j?>, 'out', '#<?=$bgcolor1?>', '#8086B4', '#FFCC99');" >
<td width="6%" height="20" align="center">
<a href ="officer_del.php?id=<?=$result[id]?>" target="_blank" onClick="return chk_confirm('<?=$result[6]?>'); " > </a>
<?=$j?>
<a href ="officer_del.php?id=<?=$result[0]?>" target="_blank" onClick="return chk_confirm_person('<?=$full_name?>'); " > </a> </td>
<? $full_name = $result[title] ."" . $result[2] ." " . $result[th_sname] ?>
<td width="41%">
<a href ="#" onClick="openwin3('officer_edit_form.php?id=<?=$result[0]?>',710,300);" title="แก้ไข"><?=$result[title]?>
<?=$result[2]?>
<?=$result[th_sname]?>
</a></td>
<td width="33%"> <a href ="#" onClick="openwin3('officer_edit_form.php?id=<?=$result[0]?>',710,300);" title="แก้ไข">
</a>
<?=$result[position]?></td>
<td width="20%">
<?
if (strlen($result[home_tel]) > 7 ){
$tel_no = $result[home_tel] ;
}else if (strlen($result[mobile]) > 7 ) {
$tel_no = $result[mobile] ;
}else{
$tel_no = $result[tel1] ;
}
?>
<?=$tel_no?> </td>
</tr>
<?
if (($ord != 1) and ($keyword == "")){
if ($i > ($first_row + $page_size - 1)){ exit ; }
}
}
?>
</table>
<!-- =============================================================================== --></td>
</tr>
<tr><td colspan="2"></td></tr>
</table>
</form>