| Server IP : 182.53.201.61 / Your IP : 216.73.217.175 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/Menu กลุ่มงานเภสัช/ |
Upload File : |
<?php
function dCon($code){
switch ($code) {
case '07':
return "เภสัชกร";
case '08':
return "เจ้าพนักงานเภสัชกรรม";
case '09':
return "ลูกจ้างงานบริการ";
default :
return '';
}
}
function dLev($code){
switch ($code) {
case '8':
return "ชำนาญการพิเศษ";
case '7':
return "ชำนาญการ";
case '6':
return "ปฎิบัติการ";
case '5':
return "ชำนาญงาน";
case '4':
return "ปฏิบัติงาน";
case '3':
return "จ่ายยา";
case '2':
return "คลังเวชภัณฑ์";
default :
return '';
}
}
function dPos($code){
switch ($code) {
case '1':
return "หัวหน้ากลุ่มงาน";
case '2':
return "หัวหน้างานบริการเภสัชกรรมผู้ป่วยนอก";
case '4':
return "หัวหน้างานบริการเภสัชกรรมผู้ป่วยใน";
case '6':
return "หัวหน้างานคลังเวชภัณฑ์";
default :
return '';
}
}
$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>
<style type="text/css">
#CustomS {
border: 2px none;
padding: 25px;
background: url(image/Header.png);
background-repeat: no-repeat;
background-size: 545px 100px;
background-position: center;
}
.style107 {
font-family: "TH SarabunPSK";
font-size: 40px;
color: #CC3333;
}
</style>
</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">
<table width="100%" border="0" align="center">
<div align="center" id="CustomS">
<h2><span class="style107"><strong>งานเภสัชกรรม</strong></span></h2>
</div>
<tr>
<td colspan="7">
<div class="tree" align="center" >
<div align="center">
<table width="100%" height="100%" border="0" align="center">
<tr>
<td>
<?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,empimage.Active
FROM empimage WHERE no IS NOT NULL AND no != " " AND Active="A" AND substr(empimage.DeptCode,1,2) = "05" group by substr(empimage.deptcode,1,4) '); //HEAD
while($sub1 = $get_sub->fetch_array()){
if ($rec0 <= 2) echo "<ul>";
$numall+=1;
echo "<li>";
$uDept = $sub1['deptcode'];
echo '<a href="JD/'.trim($sub1['EmpName']).' '.$sub1['Empsurname'].'.pdf" target="_blank">
<img src="data:image/jpeg;base64,'.base64_encode( $sub1['EmpPicture'] ).'" width="80" height="100"><br>';
echo trim($sub1['EmpTitle']).trim($sub1['EmpName']).' '.$sub1['Empsurname'].'<br>';
echo dCon($sub1['con']).dLev($sub1['lev']).'<br>';
echo dPos(substr($uDept,4,1)).'<br></a>';
if ($rec0 >= 3) {
$SQL = 'SELECT empimage.EmpID,empimage.EmpTitle,empimage.EmpName,empimage.Empsurname ,
empimage.no ,empimage.EmpPicture ,empimage.deptcode,empimage.con,empimage.lev,empimage.Active
FROM empimage WHERE no IS NOT NULL AND no != " " AND Active="A" AND substr(empimage.DeptCode,1,4) = "'.SUBSTR($uDept,0,4).'"';
$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="JD/'.trim($sub2['EmpName']).' '.$sub2['Empsurname'].'.pdf" target="_blank">
<img src="data:image/jpeg;base64,'.base64_encode( $sub2['EmpPicture'] ).'" width="50" height="60"><br>';
echo trim($sub2['EmpTitle']).trim($sub2['EmpName']).' '.$sub2['Empsurname'].'<br>';
echo dCon($sub2['con']).dLev($sub2['lev']).'<br>';
echo dPos( substr($uDept,4,1)).'<br></a></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>
<td ><br /> <?php
echo "จำนวนเจ้าหน้าที่ ".$numall;
?></td>
</table>
</div>
</div>
</td>
</tr>
</table></td></tr></table>
</body>
</html>