| Server IP : 172.67.187.206 / Your IP : 172.71.28.155 Web Server : Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/5.6.30 System : Windows NT WIN-ECQAAA40806 6.2 build 9200 (Windows Server 2012 Standard Edition) i586 User : SYSTEM ( 0) PHP Version : 5.6.30 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : E:/Inetpub/www/myschool/benjama/modules/tkk6/ |
Upload File : |
<TABLE cellSpacing=0 cellPadding=0 width=1005 height=500 border=0 align="center">
<TBODY>
<TR>
<TD vAlign=top><BR>
<!-- tkk1 -->
<BR>
<?
// CheckUser($_SESSION['user_user']);
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE username='".$_SESSION['user_user']."' ");
$arr[user] = $db->fetch($res[user]);
//ดึงค่า
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[yearla] = $db->select_query("SELECT * FROM ".TB_YEARLA_CAT." ORDER BY id ");
$arr[yearla] = $db->fetch($res[yearla]);
$_GET['id'] = intval($_GET['id']);
//แสดงข่าวสาร/ประชาสัมพันธ์
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[tkk6] = $db->select_query("SELECT * FROM ".TB_TKK6." WHERE id='$_GET[id]' ");
$arr[tkk6] = $db->fetch($res[tkk6]);
$db->closedb ();
?>
<?php
// Make สถิติลาป่วย
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT la SUM(la) FROM web_tkk6 WHERE cat='".$arr[user][id]."'and yearla='".$arr[yearla][name]."' GROUP BY id";
$sql1="select sum(la='ป่วย') as tt1 from web_tkk6 where cat='".$arr[user][id]."' and yearla='".$arr[yearla][name]."' and comment1='อนุญาต' ";
$dbquery1 = $db->select_query( $sql1);
$result1 = $db->fetch($dbquery1);
$poi=$result1[tt1];
$query = "SELECT numpoi SUM(numpoi) FROM web_tkk6 WHERE cat='".$arr[user][id]."'and yearla='".$arr[yearla][name]."' GROUP BY id";
$sql2="select sum(numpoi) as tt2 from web_tkk6 where cat='".$arr[user][id]."' and yearla='".$arr[yearla][name]."' and la='ป่วย' and comment1='อนุญาต' ";
$dbquery2 = $db->select_query( $sql2);
$result2 = $db->fetch($dbquery2);
$sumpoi=$result2[tt2];
?>
<?php
// Make สถิติลากิจ
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT la SUM(la) FROM web_tkk6 WHERE cat='".$arr[user][id]."'and yearla='".$arr[yearla][name]."' GROUP BY id";
$sql3="select sum(la='กิจส่วนตัว') as tt3 from web_tkk6 where cat='".$arr[user][id]."' and yearla='".$arr[yearla][name]."' and comment1='อนุญาต' ";
$dbquery3 = $db->select_query( $sql3);
$result3 = $db->fetch($dbquery3);
$kit=$result3[tt3];
$query = "SELECT numpoi SUM(numpoi) FROM web_tkk6 WHERE cat='".$arr[user][id]."'and yearla='".$arr[yearla][name]."' GROUP BY id";
$sql4="select sum(numpoi) as tt4 from web_tkk6 where cat='".$arr[user][id]."' and yearla='".$arr[yearla][name]."' and la='กิจส่วนตัว' and comment1='อนุญาต' ";
$dbquery4 = $db->select_query( $sql4);
$result4= $db->fetch($dbquery4);
$sumkit=$result4[tt4];
?>
<?php
// Make สถิติลาคลอด
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT la SUM(la) FROM web_tkk6 WHERE cat='".$arr[user][id]."' and yearla='".$arr[yearla][name]."' GROUP BY id";
$sql5="select sum(la='คลอดบุตร') as tt5 from web_tkk6 where cat='".$arr[user][id]."' and yearla='".$arr[yearla][name]."' and comment1='อนุญาต' ";
$dbquery5 = $db->select_query( $sql5);
$result5 = $db->fetch($dbquery5);
$klod=$result5[tt5];
$query = "SELECT numpoi SUM(numpoi) FROM web_tkk6 WHERE cat='".$arr[user][id]."'and yearla='".$arr[yearla][name]."' GROUP BY id";
$sql6="select sum(numpoi) as tt6 from web_tkk6 where cat='".$arr[user][id]."' and yearla='".$arr[yearla][name]."' and la='คลอดบุตร' and comment1='อนุญาต' ";
$dbquery6 = $db->select_query( $sql6);
$result6= $db->fetch($dbquery6);
$sumklod=$result6[tt6];
?>
<?php
// Make สถิติพักผ่อน
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT la SUM(la) FROM web_tkk6 WHERE cat='".$arr[user][id]."' and yearla='".$arr[yearla][name]."' GROUP BY id";
$sql7="select sum(la='พักผ่อน') as tt7 from web_tkk6 where cat='".$arr[user][id]."' and numpoi>0 and yearla='".$arr[yearla][name]."' and comment1='อนุญาต' ";
$dbquery7 = $db->select_query( $sql7);
$result7 = $db->fetch($dbquery7);
$rest=$result7[tt7];
$query = "SELECT numpoi SUM(numpoi) FROM web_tkk6 WHERE cat='".$arr[user][id]."'and yearla='".$arr[yearla][name]."' GROUP BY id";
$sql8="select sum(numpoi) as tt8 from web_tkk6 where cat='".$arr[user][id]."' and yearla='".$arr[yearla][name]."' and la='พักผ่อน' and comment1='อนุญาต' ";
$dbquery8 = $db->select_query( $sql8);
$result8= $db->fetch($dbquery8);
$sumrest=$result8[tt8];
$useragent=$_SERVER['HTTP_USER_AGENT'];
if(preg_match('/(android|bb\d+|meego).+mobile|avantgo|bada\/|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge |maemo|midp|mmp|netfront|opera m(ob|in)i|palm( os)?|phone|p(ixi|re)\/|plucker|pocket|psp|series(4|6)0|symbian|treo|up\.(browser|link)|vodafone|wap|windows (ce|phone)|xda|xiino/i',$useragent)||preg_match('/1207|6310|6590|3gso|4thp|50[1-6]i|770s|802s|a wa|abac|ac(er|oo|s\-)|ai(ko|rn)|al(av|ca|co)|amoi|an(ex|ny|yw)|aptu|ar(ch|go)|as(te|us)|attw|au(di|\-m|r |s )|avan|be(ck|ll|nq)|bi(lb|rd)|bl(ac|az)|br(e|v)w|bumb|bw\-(n|u)|c55\/|capi|ccwa|cdm\-|cell|chtm|cldc|cmd\-|co(mp|nd)|craw|da(it|ll|ng)|dbte|dc\-s|devi|dica|dmob|do(c|p)o|ds(12|\-d)|el(49|ai)|em(l2|ul)|er(ic|k0)|esl8|ez([4-7]0|os|wa|ze)|fetc|fly(\-|_)|g1 u|g560|gene|gf\-5|g\-mo|go(\.w|od)|gr(ad|un)|haie|hcit|hd\-(m|p|t)|hei\-|hi(pt|ta)|hp( i|ip)|hs\-c|ht(c(\-| |_|a|g|p|s|t)|tp)|hu(aw|tc)|i\-(20|go|ma)|i230|iac( |\-|\/)|ibro|idea|ig01|ikom|im1k|inno|ipaq|iris|ja(t|v)a|jbro|jemu|jigs|kddi|keji|kgt( |\/)|klon|kpt |kwc\-|kyo(c|k)|le(no|xi)|lg( g|\/(k|l|u)|50|54|\-[a-w])|libw|lynx|m1\-w|m3ga|m50\/|ma(te|ui|xo)|mc(01|21|ca)|m\-cr|me(rc|ri)|mi(o8|oa|ts)|mmef|mo(01|02|bi|de|do|t(\-| |o|v)|zz)|mt(50|p1|v )|mwbp|mywa|n10[0-2]|n20[2-3]|n30(0|2)|n50(0|2|5)|n7(0(0|1)|10)|ne((c|m)\-|on|tf|wf|wg|wt)|nok(6|i)|nzph|o2im|op(ti|wv)|oran|owg1|p800|pan(a|d|t)|pdxg|pg(13|\-([1-8]|c))|phil|pire|pl(ay|uc)|pn\-2|po(ck|rt|se)|prox|psio|pt\-g|qa\-a|qc(07|12|21|32|60|\-[2-7]|i\-)|qtek|r380|r600|raks|rim9|ro(ve|zo)|s55\/|sa(ge|ma|mm|ms|ny|va)|sc(01|h\-|oo|p\-)|sdk\/|se(c(\-|0|1)|47|mc|nd|ri)|sgh\-|shar|sie(\-|m)|sk\-0|sl(45|id)|sm(al|ar|b3|it|t5)|so(ft|ny)|sp(01|h\-|v\-|v )|sy(01|mb)|t2(18|50)|t6(00|10|18)|ta(gt|lk)|tcl\-|tdg\-|tel(i|m)|tim\-|t\-mo|to(pl|sh)|ts(70|m\-|m3|m5)|tx\-9|up(\.b|g1|si)|utst|v400|v750|veri|vi(rg|te)|vk(40|5[0-3]|\-v)|vm40|voda|vulc|vx(52|53|60|61|70|80|81|83|85|98)|w3c(\-| )|webc|whit|wi(g |nc|nw)|wmlb|wonu|x700|yas\-|your|zeto|zte\-/i',substr($useragent,0,4)))
{
echo "<font size=5 ><center>ไม่สามารถ ทำระบบ ผ่าน มือถึอ หรือ แทปเลต ได้<br>โปรดทำผ่านคอมพิวเตอร์ </center></font>";
exit;
}
?>
<table cellspacing="2" cellpadding="2" align="center"width="650" border="0">
<tbody>
<tr bgcolor="#99CC99" >
<div align="center"> สถิติการลาในปีงบประมาณนี้
<br> ของ <?=$arr[user][category_name];?></div>
<td width="350" align="center"bgcolor="#FFFFFF"><B>แบบฟอร์มคำขอ</B></td>
<td align="center">ประเภทการลา</td>
<td align="center">ครั้ง</td>
<td align="center">วัน</td>
</td>
</tr>
<tr bgcolor="#CC9966">
<td align="left"bgcolor="#FFFFFF"><img src="images/i-editor.png" ><A HREF="?name=tkk6&file=addsick&op=tkk6_add"> <B>เขียนขออนุญาตลาป่วย</B><A></td>
<td align="left">ลาป่วย</td>
<td align="center"><? echo number_format($poi),''; ?></td>
<td align="center"><?$a=$sumpoi; echo "" .round($a,1);?></td>
</tr>
<tr bgcolor="#99CCFF">
<td align="left"bgcolor="#FFFFFF"><img src="images/i-editor.png" ><A HREF="?name=tkk6&file=adddis&op=tkk6_add"> <B>เขียนขออนุญาตลากิจส่วนตัว</B></A></td>
<td align="left">ลากิจส่วนตัว</td>
<td align="center"><? echo number_format($kit),''; ?></td>
<td align="center"><?$a=$sumkit; echo "" .round($a,1);?></td>
</tr>
<tr bgcolor="#CC9900">
<td align="left"bgcolor="#FFFFFF"><img src="images/i-editor.png" ><A HREF="?name=tkk6&file=addbirth&op=tkk6_add"> <B>เขียนขออนุญาตลาคลอดบุตร</B></A></td>
<td align="left">ลาคลอดบุตร</td>
<td align="center"><? echo number_format($klod),''; ?></td>
<td align="center"><?$a=$sumklod; echo "" .round($a,1);?></td>
</tr>
<!---
<tr bgcolor="#FF99CC">
<td align="left"bgcolor="#FFFFFF">
<?
$res[category] = $db->select_query("SELECT * FROM ".TB_TKK6_CAT." WHERE cat='".$arr[user][id]."' and yearla='".$arr[yearla][name]."' ");
$arr[category] = $db->fetch($res[category]);
?>
<img src="images/i-editor.png" ><A HREF="?name=tkk6&file=addrest&op=tkk6_add"> <B>เขียนขออนุญาตลาพักผ่อน</A>
</td>
<td align="left">ลาพักผ่อน </td>
<td align="center"><? echo number_format($rest),''; ?></td>
<td align="center"><?$a=$sumrest; echo "" .round($a,1);?></td>
</tr>
--->
<td align="left"bgcolor="#FFFFFF">
<img src="images/i-editor.png" ><A HREF="?name=tkk6&file=checkone&op=tkk6_read&category=<?=$arr[user][id];?>"> <B>เขียนขอยกเลิกวันลา</B></A>
</td>
<td align="left"></td>
<td align="center"></td>
<td align="center"></td>
</tr>
</table>
</td>
</tr>
</TABLE>
</TD>
</TR>
</TBODY>
</TABLE>