MINI SHELL

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/admin/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /var/www/html/pathumthani_vc/report/pdir/admin/office_xls.php
<?
	include ("../../inc/conndb.qpass.php");
?>	

<!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>
<table width="98%" height="20" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td background="../../../images_sys/bg_02.jpg">
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="5%"><div align="center"><a href ="#" onClick="openwin('officer_add_form.php',690,210);"> <img src="../../../images_sys/members.gif" alt="เพิ่มหัวหน้าส่วนราชการ" name="officer_p" width="20" height="20" border="0" id="officer_p"></a></div></td>
          <td width="5%"><div align="center"><a href ="#" onClick="openwin('officer_add_form_admin.php',690,300);"> <img src="../../../images_sys/home.gif" alt="เพิ่มส่วนราชการ" width="20" height="20" border="0"></a></div></td>
          <td width="5%" align="center"> <a href="office_xls.php"><img src="../../../images_sys/xls_logo.gif" width="16" height="16" border="0"></a></td>
          <td width="37%">&nbsp;</td>
          <td width="74%">&nbsp;</td>
          <td width="17%" align="right"> <a href='#' onClick = show_modify("V9.02C23.11.2005"); >version</a>&nbsp;&nbsp;&nbsp;&nbsp;</td>
        </tr>
    </table></td>
  </tr>
</table>
<br>
<table width="98%"  border="0" align="center" cellpadding="4" cellspacing="1">
  <tr bgcolor="#CCCCCC"     class="indexbold"        >
    <td rowspan="3" align="center" bgcolor="#A3B2CC">ชื่อ - สกุล </td>
    <td colspan="5" align="center" bgcolor="#A3B2CC">หมายเลขโทรศัพท์ / โทรสาร </td>
  </tr>
  <tr     class="indexbold"        >
    <td colspan="3" align="center" bgcolor="#A3B2CC">ที่ทำงาน</td>
    <td width="12%" rowspan="2" align="center" bgcolor="#A3B2CC">บ้านพัก</td>
    <td width="12%" rowspan="2" align="center" bgcolor="#A3B2CC">มือถือ</td>
  </tr>
  <tr     class="indexbold"        >
    <td width="12%" align="center" bgcolor="#A3B2CC">ทศท</td>
    <td width="12%" align="center" bgcolor="#A3B2CC">ภายใน / สื่อสาร มท. </td>
    <td width="12%" align="center" bgcolor="#A3B2CC">โทรสาร</td>
  </tr>
<?

$sql =  " SELECT      " ;   
$sql =  $sql . "  office_beunder.beunder_id, office_beunder.beunder_name, office_beunder.beunder_ref,    " ;   
$sql =  $sql . "  office_beunder.seq, office_detail.office_beunder, office_detail.id, office_detail.th_name,    " ;   
$sql =  $sql . "  office_detail.tel1, office_detail.tel2, office_detail.FX,  groupid ,   " ;   
$sql =  $sql . "  officer.ID, officer.th_name, officer.title, officer.th_sname,    " ;   
$sql =  $sql . "  officer.`position`, officer.home_tel, officer.mobile   " ;   
$sql =  $sql . "  From office_detail    " ;   
$sql =  $sql . "  Left Join office_beunder ON office_detail.office_beunder = office_beunder.beunder_id    " ;   
$sql =  $sql . "  Inner Join officer ON officer.office_id = office_detail.id   " ;   
$sql =  $sql . "  ORDER   BY   office_beunder , seq  ,   groupid   ASC   " ;

//  echo $sql  ; 
$query_result = mysql_db_query($dbname,$sql);
 while($result = mysql_fetch_array($query_result)){    
		if ($bgcolor1 == "DDDDDD"){  $bgcolor1 = "EFEFEF"  ; } else {$bgcolor1 = "DDDDDD" ;}
		$beunder_id = $result[beunder_id]  ; 
		$beunder_name = $result[beunder_name]  ; 
		$beunder_ref = $result[beunder_ref]  ; 
		$seq = $result[seq]  ; 
		$office_beunder = $result[office_beunder]  ; 
		$id = $result[id]  ; 
		$th_name = $result[th_name]  ; 
		$tel1 = $result[tel1]  ; 
		$tel2 = $result[tel2]  ; 
		$fax = $result[FX]  ; 
		$ID = $result[ID]  ; 
		$th_name = $result[th_name]  ; 
		$title = $result[title]  ; 
		$th_sname = $result[th_sname]  ; 
		$position = $result[position]  ; 
		$home_tel = $result[home_tel]  ; 
		$mobile = $result[mobile]  ; 

		if (($beunder_name  != $old_beunder_name ) and ($beunder_name  != "") ) {
?>
  <tr  bgcolor="#<?=$bgcolor1?>"   >
    <td align="center">  <strong><u><?=$beunder_name?></u></strong> &nbsp;</td>
    <td>&nbsp;</td>	<td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td> 
  </tr>
<?   
  }  //  END =>if ($position  != $old_position ) { 		
		if ($position  != $old_position ) {
?>
  <tr  bgcolor="#<?=$bgcolor1?>"   >
    <td> <strong><u><?=$position?></u></strong>&nbsp;</td>
    <td>&nbsp;</td>	<td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td> 
  </tr>
<?   
  }  //  END =>if ($position  != $old_position ) { 
?>  
  <tr  bgcolor="#<?=$bgcolor1?>"   >
    <td  ><?=$title?>  <?=$th_name?> <?=$th_sname?>&nbsp;</td>
    <td><?=$tel1?> &nbsp;</td>
    <td><?=$tel2?> &nbsp;</td>
    <td><?=$fax?> &nbsp;</td>
    <td><?=$home_tel?> &nbsp;</td>
    <td><?=$mobile?> &nbsp;</td>
  </tr>
<?   
		$old_beunder_name =  $beunder_name    ; 
		$old_position =  $position    ; 		
}   
?>  
</table>
<br>
<br>
<br>

Anon7 - 2021