Gecko [ 122.154.134.11 ]

Name	Size	Permission
manual	[ DIR ]	drwxr-xr-x
add_user.php	14.38 KB	-rw-r--r--
add_user_sch.php	13.54 KB	-rw-r--r--
data_requester.php	17.74 KB	-rwxr-xr-x
data_requester_log.php	6.2 KB	-rw-r--r--
index.php	81 B	-rwxr-xr-x
menugroup.php	10.35 KB	-rw-r--r--
module.php	33.28 KB	-rw-r--r--
module_admin.php	11.9 KB	-rw-r--r--
office_name.php	2.91 KB	-rw-r--r--
register.php	1.53 KB	-rwxr-xr-x
reset_pwd.php	6.33 KB	-rw-r--r--
reset_pwd_sch.php	6.44 KB	-rw-r--r--
school.php	9.37 KB	-rw-r--r--
school_detail.php	8.51 KB	-rw-r--r--
school_group.php	8.97 KB	-rw-r--r--
show_name_th.php	514 B	-rwxr-xr-x
smss_permission.php	2.81 KB	-rw-r--r--
sync_code.php	2.85 KB	-rwxr-xr-x
sync_other_code.php	11.12 KB	-rw-r--r--
sync_smss_code.php	7.16 KB	-rwxr-xr-x
user_change_pwd.php	2.51 KB	-rwxr-xr-x
workgroup.php	10.37 KB	-rw-r--r--

Code Editor : data_requester_log.php

<?php
/** ensure this file is being included by a parent file */
defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' );

//ส่วนหัว
echo "<br />";
if(!(($index==1) or ($index==2) or ($index==5) or ($index==7))){
echo "<table width='50%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>รายงานการเข้าใช้ข้อมูล AMSS++ จากหน่วยงานภายนอก</strong></font></td></tr>";
echo "</table>";
}

//ส่วนยืนยันการลบข้อมูล
if($index==2) {
echo "<table width='500' border='0' align='center'>";
echo "<tr><td align='center'><font color='#990000' size='4'>โปรดยืนยันความต้องการลบข้อมูลอีกครั้ง</font><br></td></tr>";
echo "<tr><td align=center>";
echo "<INPUT TYPE='button' name='smb' value='ยืนยัน' onclick='location.href=\"?file=data_requester_log&index=3\"'>
		&nbsp;&nbsp;<INPUT TYPE='button' name='back' value='ยกเลิก' onclick='location.href=\"?file=data_requester_log\"'";
echo "</td></tr></table>";
}

//ส่วนลบข้อมูล
if($index==3){
$sql = "delete from system_export_log";
$dbquery = mysqli_query($connect,$sql);
}

//ส่วนแสดงผล
if(!(($index==1) or ($index==2) or ($index==5) or ($index==7))){

//ส่วนของการแยกหน้า
$pagelen=20;  // 1_กำหนดแถวต่อหน้า
$url_link="file=data_requester_log";  // 2_กำหนดลิงค์
$sql = "select * from system_export_log"; // 3_กำหนด sql

$dbquery = mysqli_query($connect,$sql);
$num_rows = mysqli_num_rows($dbquery);  
$totalpages=ceil($num_rows/$pagelen);

if(isset($_REQUEST['page']))
	{
	$page=$_REQUEST['page'];
	}else{$page="";}

if($page==""){
	$page=$totalpages;
			if($page<2){
			$page=1;
			}
	}
	else{
			if($totalpages<$_REQUEST['page']){
			$page=$totalpages;
						if($page<1){
						$page=1;
						}
			}
			else{
			$page=$_REQUEST['page'];
			}
	}

$start=($page-1)*$pagelen;

if(($totalpages>1) and ($totalpages<16)){
	echo "<div align=center>";
	echo "หน้า	";
				for($i=1; $i<=$totalpages; $i++)	{
						if($i==$page){
						echo "[<b><font size=+1 color=#990000>$i</font></b>]";
						}
						else {
						echo "<a href=$PHP_SELF?$url_link&page=$i>[$i]</a>";
						}
				}
	echo "</div>";
	}			
	if($totalpages>15){
				if($page <=8){
				$e_page=15;
				$s_page=1;
				}
				if($page>8){
						if($totalpages-$page>=7){
						$e_page=$page+7;
						$s_page=$page-7;
						}
						else{
						$e_page=$totalpages;
						$s_page=$totalpages-15;
						}
				}
				echo "<div align=center>";
				if($page!=1){
				$f_page1=$page-1;
				echo "<<a href=$PHP_SELF?$url_link&page=1>หน้าแรก </a>";
				echo "<<<a href=$PHP_SELF?$url_link&page=$f_page1>หน้าก่อน </a>";
				}
				else {
				echo "หน้า	";
				}					
				for($i=$s_page; $i<=$e_page; $i++){
						if($i==$page){
						echo "[<b><font size=+1 color=#990000>$i</font></b>]";
						}
						else {
						echo "<a href=$PHP_SELF?$url_link&page=$i>[$i]</a>";
						}
				}
				if($page<$totalpages)	{
				$f_page2=$page+1;
				echo "<a href=$PHP_SELF?$url_link&page=$f_page2> หน้าถัดไป</a>>>";
				echo "<a href=$PHP_SELF?$url_link&page=$totalpages> หน้าสุดท้าย</a>>";
				}
				echo " <select onchange=\"location.href=this.options[this.selectedIndex].value;\" size=\"1\" name=\"select\">";
				echo "<option  value=\"\">หน้า</option>";
					for($p=1;$p<=$totalpages;$p++){
					echo "<option  value=\"?$url_link&page=$p\">$p</option>";
					}
				echo "</select>";
	echo "</div>";  
	}					
	//จบแยกหน้า

echo  "<table width='65%' border='0' align='center'>";
	echo "<Tr><Td colspan='7' align='left'><INPUT TYPE='button' name='smb' value='ลบข้อมูลทั้งหมด' onclick='location.href=\"?file=data_requester_log&index=2\"'</Td></Tr>";
    echo "</Table>";
	echo  "<table width='65%' border='1' align='center' style='border-collapse: collapse'>";
	echo "<Tr bgcolor='#E6E6E6'><Td align='center' width='50'>ที่</Td><Td align='center' width='150'>วัน เวลา</Td><Td align='center'>ชื่อหน่วยงาน</Td><Td align='center' width='150'>computer ip</Td><Td align='center' width='200'>ข้อมูล</Td></Tr>";
	
	$sql = "select * from system_export_log left join system_export_requester on system_export_log.requester=system_export_requester.requester left join system_export_list on system_export_log.data=	system_export_list.data_name order by system_export_log.id limit $start,$pagelen";
	$dbquery = mysqli_query($connect,$sql);

$N=(($page-1)*$pagelen)+1;  //*เกี่ยวข้องกับการแยกหน้า
	$M=1;

While ($result = mysqli_fetch_array($dbquery))
		{
			$id = $result['id'];
			$computer_ip= $result['computer_ip'];
			$thai_requester = $result['thai_requester'];
			$login_time= $result['login_time'];
			$thai_dataname= $result['thai_dataname'];
			
			if(($M%2) == 0)
				$color="#FFFFC";
				else  	$color="#FFFFFF";
			echo "<Tr bgcolor=$color><Td align='center'>$N</Td><Td align='left'>";
			echo thai_date_4($login_time);
			echo "</Td><Td align='left'>$thai_requester</Td><Td align='left'>$computer_ip</Td><Td align='left'>$thai_dataname</Td>";
		echo "</Tr>";
	$M++;
	$N++;  //*เกี่ยวข้องกับการแยกหน้า
		}
	echo "</Table>";
	}

${this.title}

Code Editor : data_requester_log.php