| 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 '01':
return "เภสัชกร";
case '05':
return "เจ้าพนักงานเวชสถิติ";
case '06':
return "นักวิชาการคอมพิวเตอร์";
case '03':
return "นักวิชาการคอมพิวเตอร์";
default :
return '';
}
}
function dLev($code){
switch ($code) {
case '9':
return "ชำนาญการพิเศษ";
case '8':
return "ชำนาญการพิเศษ";
case '7':
return "ชำนาญการ";
case '6':
return "ปฎิบัติการ";
case '5':
return "ชำนาญงาน";
case '4':
return "ปฏิบัติงาน";
default :
return '';
}
}
function dPos($code){
switch ($code) {
case '1':
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" >
<div align="center" id="CustomS">
<h2><span class="style107"><strong>งานเภสัชกรรม</strong></span></h2>
</div>
<tr bgcolor="#00CCFF"><td width="97" height="30" bgcolor="#00CCFF"> </td>
<td width="107"><div align="center"></div></td>
<td width="299"><div align="center"></div></td>
<td width="190"><div align="center"></div></td>
<td width="114"><div align="center"></div></td>
<td width="114"><div align="center"></div></td>
<td width="266"><div align="center"></div></td>
<td width="63"><div align="center"></div></td>
</tr>
<tr>
<td colspan="7">
<div class="tree" >
<div align="center">
<table width="500" height="300" border="0" >
<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
FROM empimage WHERE no IS NOT NULL AND no != " "AND deptcode = "03001" ');
echo "<ul>";
while($sub1 = $get_sub->fetch_array()){
$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>';
}
mysqli_free_result($get_sub);
$get_sub2 = $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) = "09" ');
echo "<ul>" ;
while($sub2 = $get_sub2->fetch_array()){
echo "<li>" ;
$numall+=1;
if ($rec0 <= 3) {
$uDept = $sub1['deptcode'];
echo '<a href="JD/'.trim($sub2['EmpName']).' '.$sub2['Empsurname'].'.pdf" target="_blank">
<img src="data:image/jpeg;base64,'.base64_encode( $sub2['EmpPicture'] ).'" width="80" height="100"><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>';
echo "</li>" ;
}
$rec0 +=1;
}
echo "</li>" ;
echo "</ul>" ;
echo "</ul>" ;
mysqli_free_result($get_sub2);
?>
</td>
</tr>
</table>
</body>
</html>