| Server IP : 134.236.49.22 / Your IP : 216.73.216.114 Web Server : Apache/2.2.15 (Fedora) System : Linux km10.dyndns.org 2.6.31.5-127.fc12.i686.PAE #1 SMP Sat Nov 7 21:25:57 EST 2009 i686 User : apache ( 48) PHP Version : 5.3.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/workgroup/กลุ่มงานทันตกรรม_bak/ |
Upload File : |
<?php
$numall =0;
//ตั้งค่าการเชื่อมต่อฐานข้อมูล
$database_host = '192.168.1.39';
$database_port = '3306';
$database_username = 'root';
$database_password = '090407';
$database_name = 'mit';
$mysqli = new mysqli($database_host, $database_username, $database_password, $database_name, $database_port);
$mysqli->set_charset("utf8");
if ($mysqli->connect_error) {
die('Error : ('. $mysqli->connect_errno .') '. $mysqli->connect_error);
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="//maxcdn.bootstrapcdn.com/bootstrap/3.3.0/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
<script src="//maxcdn.bootstrapcdn.com/bootstrap/3.3.0/js/bootstrap.min.js"></script>
<script src="//code.jquery.com/jquery-1.11.1.min.js"></script>
<!------ Include the above in your HEAD tag ---------->
<title>กลุ่มงานทันตกรรม</title>
</head>
<body>
<!--
We will create a family tree using just CSS(3)
The markup will be simple nested lists
-->
<link rel="stylesheet" type="text/css" href="css/style.css">
<div align="center">
<table width="1200" border="1">
<tr>
<td>
<img src="headerdental.jpg" width="1200" height="117" align="middle" />
<div class="tree" >
<?php
$numall=0;
$rec0 = 1;
$get_sub = $mysqli->query('SELECT empimage.EmpID,empimage.EmpTitle,empimage.EmpName,empimage.Empsurname ,
empimage.no ,empimage.EmpPicture ,empimage.deptcode ,empimage.con,empimage.lev
FROM empimage WHERE no IS NOT NULL AND no != " " AND substr(empimage.DeptCode,1,2) = "03" group by substr(empimage.deptcode,1,4) ');
while($sub1 = $get_sub->fetch_array()){
if ($rec0 <= 2) echo "<ul>";
$numall+=1;
echo "<li>";
$uDept = $sub1['deptcode'];
echo '<a href="#"> <img src="data:image/jpeg;base64,'.base64_encode( $sub1['EmpPicture'] ).'" width="113" height="146"><br>';
echo trim($sub1['EmpTitle']).trim($sub1['EmpName']).' '.$sub1['Empsurname'].'<br>';
$procode = $sub1['con'];
switch ($procode) {
case '01':
echo "ทันตแพทย์";
break;
case '02':
echo "ทันตาภิบาล";
break;
case '03':
echo "ผู้ช่วยทันตแพทย์";
break;
}
$procode=$sub1['lev'];
switch ($procode) {
case '9':
echo "เชี่ยวชาญ";
break;
case '8':
echo "ชำนาญการพิเศษ";
break;
case '7':
echo "ชำนาญการ";
break;
default :
break;
}
echo '<br>';
$procode = substr($uDept,4,1);
switch ($procode) {
case '1':
echo "หัวหน้ากลุ่มงาน";
break;
case '2':
echo "รองหัวหน้ากลุ่มงาน";
break;
case '3':
echo "หัวหน้างาน";
break;
case '4':
echo "รองหัวหน้างาน";
break;
default :
break;
}
echo '<br></a>';
if ($rec0 >= 2) {
$SQL = 'SELECT empimage.EmpID,empimage.EmpTitle,empimage.EmpName,empimage.Empsurname ,
empimage.no ,empimage.EmpPicture ,empimage.deptcode,empimage.con,empimage.lev
FROM empimage WHERE no IS NOT NULL AND no != " " AND substr(empimage.DeptCode,1,4) = "'.SUBSTR($uDept,0,4).'"';
//if ($uDept=='0901'){
$get_sub2 = $mysqli->query($SQL);
$row_cnt = $get_sub2->num_rows;
if ($row_cnt > 1){
$rec = 1;
echo "<ul>";
while($sub2 = $get_sub2->fetch_array()){
if ($rec > 1){
$numall+=1;
echo "<li>";
$uDept = $sub2['deptcode'];
echo '<a href="#"> <img src="data:image/jpeg;base64,'.base64_encode( $sub2['EmpPicture'] ).'" width="113" height="146"><br>';
echo trim($sub2['EmpTitle']).trim($sub2['EmpName']).' '.$sub2['Empsurname'].'<br>';
$procode = $sub2['con'];
switch ($procode) {
case '01':
echo "ทันตแพทย์";
break;
case '02':
echo "ทันตาภิบาล";
break;
case '03':
echo "ผู้ช่วยทันตแพทย์";
break;
}
$procode=$sub2['lev'];
switch ($procode) {
case '9':
echo "เชี่ยวชาญ";
break;
case '8':
echo "ชำนาญการพิเศษ";
break;
case '7':
echo "ชำนาญการ";
break;
default :
break;
}
echo '<br>';
$procode = substr($uDept,4,1);
switch ($procode) {
case '1':
echo "หัวหน้ากลุ่มงาน";
break;
case '2':
echo "รองหัวหน้ากลุ่มงาน";
break;
case '3':
echo "หัวหน้างาน";
break;
case '4':
echo "รองหัวหน้างาน";
break;
default :
break;
}
echo '<br></a>';
echo "</li>";
}
$rec += 1;
}
echo "</ul>";
}
mysqli_free_result($get_sub2);
echo "</li>";
}
$rec0 +=1;
}
if ( $rec0 >= 2) echo "</li>";
echo "</li>";
echo "</ul>";
mysqli_free_result($get_sub);
?>
</div>
</td>
</tr>
<tr>
<td>
<?php
echo "จำนวนเจ้าหน้าที่ ".$numall;
?>
</td>
</tr>
</table>
</body>
</html>