| Server IP : 172.67.187.206 / Your IP : 172.71.28.156 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/nongplamor_new/modules/personal/ |
Upload File : |
<div align="left">
<table cellspacing="0" cellpadding="0" width="100%" height=450 border="0">
<tbody>
<tr>
<td valign="top" width="100%" >
<table width="100%">
<tr>
<td align="center"">
<font color=red><b>แสดงข้อมูลการพัฒนาจำแนกรายบุคคล<?=WEB_TITLE;?></b></font>
</td>
</tr>
</table>
<table cellspacing="0" cellpadding="0" width="100%" 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">
<!-- แสดงผลรายการสมาชิกเว็บ -->
<?
//////////////////////////////////////////// แสดงรายชื่อสมาชิกเว็บ
if($_GET[op] == ""){
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 100 ;
$SUMPAGE = $db->num_rows(TB_user,"id","");
$page=$_GET[page];
if (empty($page)){
$page=1;
}
$rt = $SUMPAGE%$limit ;
$totalpage = ($rt!=0) ? floor($SUMPAGE/$limit)+1 : floor($SUMPAGE/$limit);
$goto = ($page-1)*$limit ;
?>
<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="#336633" height=25>
<td rowspan="2" width="5%" align=center ><font color="#FFFFFF"><B>ที่</B></font></td>
<td rowspan="2" width="15%" align=center ><font color="#FFFFFF"><B>ชื่อ- สกุล</B></font></td>
<td rowspan="2" width="5%" align=center ><font color="#FFFFFF"><B>ครั้ง</B></font></td>
<td rowspan="2" width="5%" align=center ><font color="#FFFFFF"><B>ชั่วโมง</B></font></td>
<td colspan="12" align=center ><font color="#FFFFFF"><B>กลุ่มสาระการเรียนรู้</B></font></td>
</tr>
<tr bgcolor="#336633">
<?
/*
<td width="5%" align=center ><font color="#FFFFFF"><B>สนับสนุน</B></font></td>
<td width="5%" align=center ><font color="#FFFFFF"><B>ไทย</B></font></td>
<td width="5%" align=center ><font color="#FFFFFF"><B>คณิต</B></font></td>
<td width="5%" align=center ><font color="#FFFFFF"><B>วิทย์</B></font></td>
<td width="5%" align=center ><font color="#FFFFFF"><B>สังคม</B></font></td>
<td width="5%" align=center ><font color="#FFFFFF"><B>ตปท.</B></font></td>
<td width="5%" align=center ><font color="#FFFFFF"><B>การงาน</B></font></td>
<td width="5%" align=center ><font color="#FFFFFF"><B>สุขศึกษา</B></font></td>
<td width="5%" align=center ><font color="#FFFFFF"><B>ศิลป</B></font></td>
<td width="5%" align=center ><font color="#FFFFFF"><B>กิจกรรมฯ</B></font></td>
*/
$res[sara] = $db->select_query("SELECT * FROM ".TB_SARA_CAT." order by id ");
while($arr[sara] = $db->fetch($res[sara])){
echo '<td width="55" align=center ><font color="#FFFFFF"><B>' .$arr[sara][name] . '</B></font></td>';
}
?>
<td width="25" align=center ><font color="#FFFFFF"><B>ดู</B></font></td>
</tr>
<?
$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE status='1' ORDER BY id ASC LIMIT $goto, $limit ");
$i=1;
while($arr[user] = $db->fetch($res[user])){
$res[groups] = $db->select_query("SELECT * FROM ".TB_ADMIN_GROUP." WHERE id='".$arr[user][level]."' ");
$arr[groups] = $db->fetch($res[groups]);
?>
<tr>
<td align="center"><? echo"".$i?></td>
<td ><a href="javascript:NewWindow('popup2.php?name=guide&file=readperson&id= <?=$arr[user][id];?>','acepopup','1024','720','center','front');"><?echo $arr[user][category_name];?></A>
</td>
<?
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[course] = $db->select_query("SELECT * FROM ".TB_COURSE." WHERE user_id='".$arr[user][id]."' ORDER BY id DESC LIMIT 1");
$count=0;
while($arr[course] = $db->fetch($res[course]))
{
?>
<td align=center >
<?php
// Make สถิติ ครั้ง
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT name SUM(user_id) FROM web_course WHERE user_id='".$arr[user][id]."' GROUP BY id";
$sql1="select sum(user_id='".$arr[user][id]."') as tt1 from web_course where user_id='".$arr[user][id]."' ";
$dbquery1 = $db->select_query( $sql1);
$result1 = $db->fetch($dbquery1);
$total1=$result1[tt1];
?>
<? echo ( $total1 ),''; ?>
</td>
<td align=center >
<?php
// Make สถิติ ชั่วโมง
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT name SUM(hour) FROM web_course WHERE user_id='".$arr[user][id]."' GROUP BY id";
$sql19="select sum(hour) as tt19 from web_course where user_id='".$arr[user][id]."' ";
$dbquery19 = $db->select_query( $sql19);
$result19 = $db->fetch($dbquery19);
$total19=$result19[tt19];
?>
<? echo ( $total19 ),''; ?>
</td>
<?php
// Make สถิติสนับสนุน
/*
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT name SUM(sara) FROM web_course where user_id='".$arr[user][id]."' GROUP BY id";
$sql2="select sum(sara='15') as tt2 from web_course where user_id='".$arr[user][id]."' ";
$dbquery2 = $db->select_query( $sql2);
$result2 = $db->fetch($dbquery2);
$total2=$result2[tt2];
?>
<? echo ( $total2),''; ?>
</B>
</td>
<td align=center >
<?php
// Make สถิติไทย
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT name SUM(sara) FROM web_course where user_id='".$arr[user][id]."' GROUP BY id";
$sql3="select sum(sara='2') as tt3 from web_course where user_id='".$arr[user][id]."' ";
$dbquery3 = $db->select_query( $sql3);
$result3 = $db->fetch($dbquery3);
$total3=$result3[tt3];
?>
<? echo ( $total3),''; ?>
</td>
<td align=center >
<?php
// Make สถิติไทย
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT name SUM(sara) FROM web_course where user_id='".$arr[user][id]."' GROUP BY id";
$sql4="select sum(sara='3') as tt4 from web_course where user_id='".$arr[user][id]."' ";
$dbquery4 = $db->select_query( $sql4);
$result4 = $db->fetch($dbquery4);
$total4=$result4[tt4];
?>
<? echo ($total4),''; ?>
</td>
<td align=center >
<?php
// Make สถิติไทย
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT name SUM(sara) FROM web_course where user_id='".$arr[user][id]."' GROUP BY id";
$sql5="select sum(sara='4') as tt5 from web_course where user_id='".$arr[user][id]."' ";
$dbquery5 = $db->select_query( $sql5);
$result5 = $db->fetch($dbquery5);
$total5=$result5[tt5];
?>
<? echo ($total5),''; ?>
</td>
<td align=center ><?php
// Make สถิติลาป่วย
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT name SUM(sara) FROM web_course where user_id='".$arr[user][id]."' GROUP BY id";
$sql6="select sum(sara='5') as tt6 from web_course where user_id='".$arr[user][id]."' ";
$dbquery6 = $db->select_query( $sql6);
$result6 = $db->fetch($dbquery6);
$total6=$result6[tt6];
?>
<? echo ( $total6 ),''; ?></td>
<td align=center > <?php
// Make สถิติลาป่วย
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT name SUM(sara FROM web_course where user_id='".$arr[user][id]."' GROUP BY id";
$sql7="select sum(sara='6') as tt7 from web_course where user_id='".$arr[user][id]."' ";
$dbquery7 = $db->select_query( $sql7);
$result7 = $db->fetch($dbquery7);
$total7=$result7[tt7];
?>
<? echo ( $total7 ),''; ?>
</td>
<td align=center > <?php
// Make สถิติลาป่วย
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT name SUM(sara FROM web_course where user_id='".$arr[user][id]."' GROUP BY id";
$sql8="select sum(sara='7') as tt8 from web_course where user_id='".$arr[user][id]."' ";
$dbquery8 = $db->select_query( $sql8);
$result8 = $db->fetch($dbquery8);
$total8=$result8[tt8];
?>
<? echo ( $total8 ),''; ?>
</td>
<td align=center > <?php
// Make สถิติลาป่วย
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT name SUM(sara FROM web_course where user_id='".$arr[user][id]."' GROUP BY id";
$sql9="select sum(sara='8') as tt9 from web_course where user_id='".$arr[user][id]."' ";
$dbquery9 = $db->select_query( $sql9);
$result9 = $db->fetch($dbquery9);
$total9=$result9[tt9];
?>
<? echo ( $total9 ),''; ?>
</td>
<td align=center > <?php
// Make สถิติลาป่วย
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT name SUM(sara FROM web_course where user_id='".$arr[user][id]."' GROUP BY id";
$sql10="select sum(sara='9') as tt10 from web_course where user_id='".$arr[user][id]."' ";
$dbquery10 = $db->select_query( $sql10);
$result10 = $db->fetch($dbquery10);
$total10=$result10[tt10];
?>
<? echo ( $total10 ),''; ?>
</td>
<td align=center > <?php
// Make สถิติลาป่วย
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$query = "SELECT name SUM(sara FROM web_course where user_id='".$arr[user][id]."' GROUP BY id";
$sql11="select sum(sara='10') as tt11 from web_course where user_id='".$arr[user][id]."' ";
$dbquery11 = $db->select_query( $sql11);
$result11 = $db->fetch($dbquery11);
$total11=$result11[tt11];
?>
<? echo ( $total7 ),''; ?>
</td>
*/
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[sara] = $db->select_query("SELECT * FROM ".TB_SARA_CAT." order by id ");
while($arr[sara] = $db->fetch($res[sara])){
$sql = "select sum(sara='".$arr[sara][level] ."') as ttt from web_course where user_id='".$arr[user][id]."' ";
$dbquery = $db->select_query($sql);
$result = $db->fetch($dbquery);
echo "<td align=center >". $result[ttt] ."</td>";
}
?>
<td align=center><a href="?name=personal&file=readcourse&id= <?=$arr[user][id];?>"><img src="images/View.png" width="20" height="20"align="middle" border="0" /></a></td>
</tr>
<?
}
?>
<?
$i++;
}
?>
</table>
</form>
<BR>
<div align="left">
<?
SplitPage($page,$totalpage,"?name=personal&file=reportcourse");
echo $ShowSumPages ;
echo "<BR>";
echo $ShowPages ;
echo "<BR><BR>";
//$res[groupstext] = $db->select_query("SELECT * FROM ".TB_ADMIN_GROUP." ORDER BY id ");
//while ($arr[groupstext] = $db->fetch($res[groupstext]))
// {
//echo "<LI>".$arr[groupstext][name]." : ".$arr[groupstext][description]."</LI>";
// }
//$db->closedb ();
}
?>
</div>
<br />
</td>
</tr>
</table>
</td>
</tr>
</table>
<br /></td>
</tr>
</table></td>
</tr>
</tbody>
</table>