| Server IP : 104.21.80.248 / Your IP : 162.159.115.42 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 : /Inetpub/www/myschool/queencollege/modules123456/approval - Copy/ |
Upload File : |
<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<div align="left">
<table bgcolor="#ffffff"cellspacing="0" cellpadding="0" width="100%" height=500 border="0">
<tbody>
<tr>
<td valign="top" width="100%" > <div align="center">
<table width="100%">
<tr>
<td align="center""><font color=red><b>แสดงข้อมูลการไปราชการจำแนกรายโรง</b></font></td>
</tr>
</table>
<table cellspacing="0" cellpadding="0" width="98%" border="0">
<tbody>
<tr>
<td><table width="100%">
<tr>
<td align="center">
<table width="100%" align="center" cellspacing="0" cellpadding="0" border="0">
<tr>
<td align="center">
<!-- แสดงผลรายการสมาชิกเว็บ -->
<form action="?name=user&file=user_cp&op=user_del&action=multidel" method="post" name="myform" id="myform">
<table width="100%" cellspacing="2" cellpadding="1" >
<tr bgcolor="#00FFFF" height=25>
<td rowspan="2" align=center>ที่</td>
<td rowspan="2" align=center>โรงเรียน</td>
<td rowspan="2"align=center bgcolor="#00FFFF">ผู้บริหาร</td>
<td height="37" colspan="13" align=center>สถิติการไปราชการจำแนกรายโรงรายเดือน</td>
</tr>
<tr bgcolor="#336633" height=25>
<td align=center bgcolor="#00FFFF">ม.ค.</td>
<td align=center bgcolor="#00FFFF">ก.พ.</td>
<td align=center bgcolor="#00FFFF">มี.ค.</td>
<td align=center bgcolor="#00FFFF">เม.ย.</td>
<td align=center bgcolor="#00FFFF">พ.ค.</td>
<td align=center bgcolor="#00FFFF">มิ.ย.</td>
<td align=center bgcolor="#00FFFF">ก.ค.</td>
<td align=center bgcolor="#00FFFF">ส.ค.</td>
<td align=center bgcolor="#00FFFF">ก.ย.</td>
<td align=center bgcolor="#00FFFF">ต.ค.</td>
<td align=center bgcolor="#00FFFF">พ.ย.</td>
<td align=center bgcolor="#00FFFF">ธ.ค.</td>
<td align=center bgcolor="#00FFFF">ดู</td>
</tr>
<?
//////////////////////////////////////////// แสดงรายชื่อสมาชิกเว็บ
if($_GET[op] == ""){
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
if($_GET[id]){
$SQLwhere = " id='".$_GET[id]."' ";
$SQLwhere = " WHERE id='".$_GET[id]."' ";
}
$res[usersch] = $db->select_query("SELECT * FROM ".TB_usersch." WHERE radab='1' and status='1' ORDER BY id DESC ");
$i=1;
while($arr[usersch] = $db->fetch($res[usersch])){
$res[groups] = $db->select_query("SELECT * FROM ".TB_ADMIN_GROUP." WHERE id='".$arr[user][level]."' ");
$arr[groups] = $db->fetch($res[groups]);
$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE sangkad='".$arr[usersch][id]."' and working='12' ");
$arr[user] = $db->fetch($res[user]);
if ($count==0) { echo "<TR>"; }
?>
<td width="5%" align=center><? echo"".$i?></td>
<td width="15%" ><? echo $arr[user][category_name];?></td>
<td width="16%" ><? echo $arr[usersch][name];?></td>
<td width="4%" align=center><A HREF="?name=approval&file=mount1&op=approval_read&id=<?=$arr[user][id];?> ">
<?php
// Make สถิต
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT cat SUM(cat) FROM web_approval cat='".$arr[user][id]."' GROUP BY id";
$sql3="select sum(cat='".$arr[user][id]."') as tt3 from web_approval where cat='".$arr[user][id]."' and comment='อนุมัติ' and date LIKE '____-01-__' ORDER BY id ";
$dbquery3 = mysql_db_query($dbname, $sql3);
$result3 = mysql_fetch_array($dbquery3);
$jan3=$result3[tt3];
?>
<font color=red><? echo number_format($jan3),''; ?></a></font>
</td>
<td width="4%" align=center><A HREF="?name=approval&file=mount2&op=approval_read&id=<?=$arr[user][id];?> ">
<?php
// Make สถิติ
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT school SUM(school) FROM web_approval school='".$arr[usersch][id]."'GROUP BY id";
$query = "SELECT cat SUM(cat) FROM web_approval cat='".$arr[user][id]."' GROUP BY id";
$sql4="select sum(cat='".$arr[user][id]."') as tt4 from web_approval where cat='".$arr[user][id]."' and comment='อนุมัติ' and date LIKE '____-02-__' ORDER BY id ";
$dbquery4 = mysql_db_query($dbname, $sql4);
$result4 = mysql_fetch_array($dbquery4);
$jan4=$result4[tt4];
?>
<font color=red><? echo number_format($jan4),''; ?></a>
</td>
<td width="4%" align=center><A HREF="?name=approval&file=mount3&op=approval_read&id=<?=$arr[user][id];?> ">
<?php
// Make สถิติ
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT cat SUM(cat) FROM web_approval cat='".$arr[user][id]."' GROUP BY id";
$sql5="select sum(cat='".$arr[user][id]."') as tt5 from web_approval where cat='".$arr[user][id]."' and comment='อนุมัติ' and date LIKE '____-03-__' ORDER BY id ";
$dbquery5 = mysql_db_query($dbname, $sql5);
$result5 = mysql_fetch_array($dbquery5);
$jan5=$result5[tt5];
?>
<font color=red><? echo number_format($jan5),''; ?></font></a></td>
<td width="4%" align=center><A HREF="?name=approval&file=mount4&op=approval_read&id=<?=$arr[user][id];?> ">
<?php
// Make สถิติ
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT cat SUM(cat) FROM web_approval cat='".$arr[user][id]."' GROUP BY id";
$sql6="select sum(cat='".$arr[user][id]."') as tt6 from web_approval where cat='".$arr[user][id]."' and comment='อนุมัติ' and date LIKE '____-04-__' ORDER BY id ";
$dbquery6 = mysql_db_query($dbname, $sql6);
$result6 = mysql_fetch_array($dbquery6);
$jan6=$result6[tt6];
?>
<font color=red><? echo number_format($jan6),''; ?></a>
</td>
<td width="4%" align=center><A HREF="?name=approval&file=mount5&op=approval_read&id=<?=$arr[user][id];?> ">
<?php
// Make สถิติ
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT cat SUM(cat) FROM web_approval cat='".$arr[user][id]."' GROUP BY id";
$sql7="select sum(cat='".$arr[user][id]."') as tt7 from web_approval where cat='".$arr[user][id]."' and comment='อนุมัติ' and date LIKE '____-05-__' ORDER BY id ";
$dbquery7 = mysql_db_query($dbname, $sql7);
$result7 = mysql_fetch_array($dbquery7);
$jan7=$result7[tt7];
?>
<font color=red><? echo number_format($jan7),''; ?></a>
</td>
<td width="4%" align=center><A HREF="?name=approval&file=mount6&op=approval_read&id=<?=$arr[user][id];?> ">
<?php
// Make สถิติ
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT cat SUM(cat) FROM web_approval cat='".$arr[user][id]."' GROUP BY id";
$sql8="select sum(cat='".$arr[user][id]."') as tt8 from web_approval where cat='".$arr[user][id]."' and comment='อนุมัติ' and date LIKE '____-06-__' ORDER BY id ";
$dbquery8 = mysql_db_query($dbname, $sql8);
$result8 = mysql_fetch_array($dbquery8);
$jan8=$result8[tt8];
?>
<font color=red><? echo number_format($jan8),''; ?></a>
</td>
<td width="4%" align=center><A HREF="?name=approval&file=mount7&op=approval_read&id=<?=$arr[user][id];?> ">
<?php
// Make สถิติ
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT cat SUM(cat) FROM web_approval cat='".$arr[user][id]."' GROUP BY id";
$sql9="select sum(cat='".$arr[user][id]."') as tt9 from web_approval where cat='".$arr[user][id]."' and comment='อนุมัติ' and date LIKE '____-07-__' ORDER BY id ";
$dbquery9 = mysql_db_query($dbname, $sql9);
$result9 = mysql_fetch_array($dbquery9);
$jan9=$result9[tt9];
?>
<font color=red><? echo number_format($jan9),''; ?></a>
</td>
<td width="4%" align=center><A HREF="?name=approval&file=mount8&op=approval_read&id=<?=$arr[user][id];?> ">
<?php
// Make สถิติ
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT cat SUM(cat) FROM web_approval cat='".$arr[user][id]."' GROUP BY id";
$sql10="select sum(cat='".$arr[user][id]."') as tt10 from web_approval where cat='".$arr[user][id]."' and comment='อนุมัติ' and date LIKE '____-08-__' ORDER BY id ";
$dbquery10 = mysql_db_query($dbname, $sql10);
$result10 = mysql_fetch_array($dbquery10);
$jan10=$result10[tt10];
?>
<font color=red><? echo number_format($jan10),''; ?></a>
</td>
<td width="4%" align=center><A HREF="?name=approval&file=mount9&op=approval_read&id=<?=$arr[user][id];?> ">
<?php
// Make สถิติ
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT cat SUM(cat) FROM web_approval cat='".$arr[user][id]."' GROUP BY id";
$sql11="select sum(cat='".$arr[user][id]."') as tt11 from web_approval where cat='".$arr[user][id]."' and comment='อนุมัติ' and date LIKE '____-9-__' ORDER BY id ";
$dbquery11 = mysql_db_query($dbname, $sql11);
$result11 = mysql_fetch_array($dbquery11);
$jan11=$result11[tt11];
?>
<font color=red><? echo number_format($jan11),''; ?></a>
</td>
<td width="4%" align=center><A HREF="?name=approval&file=mount10&op=approval_read&id=<?=$arr[user][id];?> ">
<?php
// Make สถิติ
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT cat SUM(cat) FROM web_approval cat='".$arr[user][id]."' GROUP BY id";
$sql12="select sum(cat='".$arr[user][id]."') as tt12 from web_approval where cat='".$arr[user][id]."' and comment='อนุมัติ' and date LIKE '____-10-__' ORDER BY id ";
$dbquery12 = mysql_db_query($dbname, $sql12);
$result12 = mysql_fetch_array($dbquery12);
$jan12=$result12[tt12];
?>
<font color=red><? echo number_format($jan12),''; ?></a>
</td>
<td width="4%" align=center><A HREF="?name=approval&file=mount11&op=approval_read&id=<?=$arr[user][id];?> ">
<?php
// Make สถิติ
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT cat SUM(cat) FROM web_approval cat='".$arr[user][id]."' GROUP BY id";
$sql13="select sum(cat='".$arr[user][id]."') as tt13 from web_approval where cat='".$arr[user][id]."' and comment='อนุมัติ' and date LIKE '____-11-__' ORDER BY id ";
$dbquery13 = mysql_db_query($dbname, $sql13);
$result13 = mysql_fetch_array($dbquery13);
$jan13=$result13[tt13];
?>
<font color=red><? echo number_format($jan13),''; ?></a>
</td>
<td width="4%" align=center><A HREF="?name=approval&file=mount12&op=approval_read&id=<?=$arr[user][id];?> ">
<?php
// Make สถิติ
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT cat SUM(cat) FROM web_approval cat='".$arr[user][id]."' GROUP BY id";
$sql14="select sum(cat='".$arr[user][id]."') as tt14 from web_approval where cat='".$arr[user][id]."' and comment='อนุมัติ' and date LIKE '____-12-__' ORDER BY id ";
$dbquery14 = mysql_db_query($dbname, $sql14);
$result14 = mysql_fetch_array($dbquery14);
$jan14=$result14[tt14];
?>
<font color=red><? echo number_format($jan14),''; ?></a>
</td>
<td width="4%" align=center><a href="?name=approval&file=mount1&op=approval_read&id=<?=$arr[user][id];?>"><img src="images/View.png" width="15" height="15"align="middle" border="0" /></a></td>
</tr>
<tr bgcolor=FFFFFF>
<td colspan="16" height="1" class="dotline">
</td>
</tr>
<?
$i++;
$count++;
if (($count%1) == 0) { echo ""; $count=0; }
}
?>
</table>
</form>
<div align="left">
<?
SplitPage($page,$totalpage,"?name=approval&file=report");
echo $ShowSumPages ;
echo $ShowPages ;
?>
<?
}
?>
</div>
<br />
</td>
</tr>
</table>
</td>
</tr>
</table>
<br /></td>
</tr>
</table></td>
</tr>
</tbody>
</table>