Gecko [ 122.154.134.11 ]

Name	Size	Permission
asset.php	89.73 KB	-rw-r--r--
asset_budget_type.php	6.99 KB	-rw-r--r--
asset_building.php	7.37 KB	-rw-r--r--
asset_code_model.php	7.75 KB	-rw-r--r--
asset_company.php	9.95 KB	-rw-r--r--
asset_form_upload.php	4.74 KB	-rw-r--r--
asset_list.php	12.23 KB	-rw-r--r--
asset_method.php	6.91 KB	-rw-r--r--
asset_notification.php	38.37 KB	-rw-r--r--
asset_permission.php	13.12 KB	-rw-r--r--
asset_print.php	9.88 KB	-rw-r--r--
asset_print1.php	8.43 KB	-rw-r--r--
asset_print_lend.php	3.49 KB	-rw-r--r--
asset_print_lend1.php	9.59 KB	-rw-r--r--
asset_print_lend2.php	8.85 KB	-rw-r--r--
asset_print_lendAll.php	3.27 KB	-rw-r--r--
asset_print_lendAll1.php	9.84 KB	-rw-r--r--
asset_print_qrcode.php	10.28 KB	-rw-r--r--
asset_print_qrcode1.php	1.45 KB	-rw-r--r--
asset_report1.php	20 KB	-rw-r--r--
asset_report23.php	20.09 KB	-rw-r--r--
asset_report4.php	19.76 KB	-rw-r--r--
asset_report_to_excell.php	6.54 KB	-rw-r--r--
asset_set.php	8.43 KB	-rw-r--r--
asset_status3.php	85.25 KB	-rw-r--r--
asset_status40.php	85.27 KB	-rw-r--r--
asset_type.php	9.5 KB	-rw-r--r--
index.php	5.76 KB	-rw-r--r--
livesearch.php	2.11 KB	-rw-r--r--
livesearch_notification.php	954 B	-rw-r--r--
manual.php	1.38 KB	-rw-r--r--

Code Editor : asset_print_qrcode.php

//ส่วนหัว
echo "<br />";
if(!(($index==1) or ($index==2) or ($index==5))){
echo "<table width='50%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>พิมพ์  QR-Code รหัสทรัพย์สิน</strong></font></td></tr>";
echo "</table>";
}

//ส่วนแสดงผล
if(!(($index==1) or ($index==2) or ($index==4) or ($index==5) or ($index==6) or ($index==7))){
if($workgroup!=''){
	$sql = "SELECT * FROM asset_main WHERE workgroup='$workgroup' AND status!='4' ORDER BY id ";
}else if( ($code_type!='') AND ($code_list!='') ){
	$sql = "SELECT * FROM asset_main WHERE code_type='$code_type' AND code_list='$code_list' AND status!='4' ORDER BY id ";
}else if($code_type!=''){
	$sql = "SELECT * FROM asset_main WHERE code_type='$code_type' AND status!='4' ORDER BY id ";
}else{
	$sql = "SELECT * FROM asset_main WHERE status!='4' ORDER BY id ";
}
$dbquery = mysqli_query($connect,$sql);
$num_rows=mysqli_num_rows($dbquery); //นำไปแยกหน้า
if($num_rows!='0'){
//ส่วนของการแยกหน้า
$pagelen=50 ; // 1.กำหนดแถวต่อหน้า
$url_link="option=asset&task=main/asset_print_qrcode";  // 2_กำหนดลิงค์ฺ
$totalpages=ceil($num_rows/$pagelen);
if(!(isset($_REQUEST['page']))){
$_REQUEST['page']="";
}
if($_REQUEST['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<7)){
	//echo "<div align=center>";
	//echo "หน้า	";
	echo "<nav><ul class='pagination'>";
	echo "<li><a>หน้า $page จาก $totalpages</a></li>";
		for($i=1; $i<=$totalpages; $i++)	{
			if($i==$page){
				//echo "[<b><font size=+1 color=#990000>$i</font></b>]";
				echo " <li><a href=''><font color=#990000>$i</font></a></li> ";
			}
			else {
				//echo "<a href=$PHP_SELF?$url_link&page=$i>[$i]</a>";
				echo "<li><a href=$PHP_SELF?$url_link&page=$i> $i </a></li>";
			}
		}
	//echo "</div>";
	echo "</nav>";
}		
if($totalpages>6){
	if($page <=3){
		$e_page=6;
		$s_page=1;
	}
	if($page>3){
		if($totalpages-$page>=3){
			$e_page=$page+3;
			$s_page=$page-3;
		}
		else{
			$e_page=$totalpages;
			$s_page=$totalpages-6;
		}
	}
	//echo "<div align=center>";
	echo "<nav><ul class='pagination'>";
	echo "<li><a>หน้า $page จาก $totalpages</a></li>";
	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>";
		echo "<li><a href=$PHP_SELF?$url_link&page=1 aria-label='หน้าแรก'>
		<span aria-hidden='true'>หน้าแรก</span></a></li>";
		echo "<li><a href=$PHP_SELF?$url_link&page=$f_page1 aria-label='หน้าก่อน'>
		<span aria-hidden='true'>หน้าก่อน</span></a></li>";

}
	else {
	//echo "หน้า	";
	}					
	for($i=$s_page; $i<=$e_page; $i++){
		if($i==$page){
			//echo "[<b><font size=+1 color=#990000>$i</font></b>]";
			echo " <li><a href=''><font color=#990000><strong>$i</strong></font></a></li> ";
		}
		else {
			//echo "<a href=$PHP_SELF?$url_link&page=$i>[$i]</a>";
			echo "<li><a href=$PHP_SELF?$url_link&page=$i>$i</a></li>";
		}
	}
	if($page<$totalpages)	{
		$f_page2=$page+1;
		echo "<li><a href=$PHP_SELF?$url_link&page=$f_page2 aria-label='หน้าถัดไป'>
		<span aria-hidden='true'>หน้าถัดไป</span></a></li>";
		echo "<li><a href=$PHP_SELF?$url_link&page=$totalpages aria-label='หน้าสุดท้าย'>
		<span aria-hidden='true'>หน้าสุดท้าย>$totalpages</span></a></li>";
		//echo "<a href=$PHP_SELF?$url_link&page=$f_page2> หน้าถัดไป</a>>>";
		//echo "<a href=$PHP_SELF?$url_link&page=$totalpages> หน้าสุดท้าย</a>>";
	}
	echo "&nbsp;<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 "</nav>";  
}					
//จบแยกหน้า

if($workgroup!=''){
	$sql = "SELECT * FROM asset_main WHERE workgroup='$workgroup' AND status!='4' ORDER BY id limit $start,$pagelen";
}else if( ($code_type!='') AND ($code_list!='') ){
	$sql = "SELECT * FROM asset_main WHERE code_type='$code_type' AND code_list='$code_list' AND status!='4' ORDER BY id limit $start,$pagelen";
}else if($code_type!=''){
	$sql = "SELECT * FROM asset_main WHERE code_type='$code_type' AND status!='4' ORDER BY id limit $start,$pagelen";
}else{
	$sql = "SELECT * FROM asset_main WHERE status!='4' ORDER BY id limit $start,$pagelen";
}
$dbquery = mysqli_query($connect,$sql);
}
echo "<form id='frm1' name='frm1'>";
echo "<table class='myTableGreen'>";
	echo "<Tr>";
	echo "<Td colspan='11' align='right'>ค้นหาประเภททรัพย์สิน&nbsp;&nbsp;";
	echo "<Select name='code_type' id='code_type' onChange=location.href='index.php?option=asset&task=main/asset_print_qrcode&code_type='+this.options[this.selectedIndex].value;>";
	echo  "<option value=''>เลือก - ทุกประเภท</option>" ;
	$sql_type = "SELECT * FROM asset_type ORDER BY code";
	$dbquery_type = mysqli_query($connect,$sql_type);
	While ($result_type = mysqli_fetch_array($dbquery_type)){
		$code_type = $result_type['code']; 
		$name_type = $result_type['name'];
		if($code_type==$_GET['code_type']){
			echo  "<option value='$code_type' selected>$code_type $name_type</option>" ;
		}else{
			echo  "<option value='$code_type'>$code_type $name_type</option>" ;
		}
	}
	echo "</select>";
	echo " <INPUT TYPE='button' name='smb' value='ยกเลิกการค้นหา' onclick='location.href=\"?option=asset&task=main/asset_print_qrcode\"'>";
	echo "</Td></Tr>";
	echo "<Tr>";
	echo "<Td colspan='11' align='right'>";
	//echo "<img src='images/my-icons/print-3.png' width='32' height='32' border='0'> ";
	echo "<Input Type='button' name='smb' value='พิมพ์ QR-Code รหัสทรัพย์สินตามที่เลือก' onclick='goto_url_update(1)' class='button'>";
	echo "</td></tr>";
echo "<Tr>
	<Th nowrap>ที่</Th>
	<Th nowrap>วัน เดือน ปี</Th>
	<Th nowrap>รหัสทรัพย์สิน</Th>
	<Th>รายการ</Th>
	<Th nowrap>สถานที่ตั้ง</Th>
	<Th nowrap><input name=\"allbox\" onClick=\"selectall();\" type=\"checkbox\">  เลือก/ไม่เลือกทั้งหมด</Th>
</Tr>";

if($num_rows!='0'){
$N=(($page-1)*$pagelen)+1;  //*เกี่ยวข้องกับการแยกหน้า
$M=1;
While ($result = mysqli_fetch_array($dbquery)) {
	$id		=$result['id'];
	$code_type		=$result['code_type'];
	$code_list		=$result['code_list'];
	$code_asset	=$result['code_asset'];
	$asset_date	=thai_date_3($result['asset_date']);		//แสดงรูปแบบวันที่ Y-m-d เป็นวันที่ไทย
	$officer_person = $result['officer_person'];
	echo "<Tr>";
		echo "<td align=center valign=top nowrap>$N</td>";
		echo "<td align=center valign=top nowrap>$asset_date</td>";
		echo "<td align=center valign=top nowrap>".$code_asset."<br>";
		echo "<a href='$result[photo]'><img src='$result[photo_qrcode]' width=100></a>";
		echo "</td>";

$sql_list = "SELECT * FROM asset_list WHERE code_type='$code_type' AND code='$code_list' ";
		$dbquery_list = mysqli_query($connect,$sql_list);
		$result_list = mysqli_fetch_array($dbquery_list);
		$list="<a href='?option=asset&task=main/asset_print_qrcode&code_type=$code_type&code_list=$code_list'>".$result_list['name']."</a>";
		if($result['model']!=''){ $list=$list."<br><font color=gray>รุ่น/แบบ</font> ".$result['model'] ; }
		if($result['property']!=''){ $list=$list."<br><font color=gray>คุณสมบัติ</font> ".$result['property']; }
		echo "<td valign=top>".$list."</td>";
		$sql_type = "SELECT * FROM asset_type WHERE code='$code_type' ";
		$dbquery_type = mysqli_query($connect,$sql_type);
		$result_type = mysqli_fetch_array($dbquery_type);
		$life=$result_type['life'];
		$depreciation_rate=$result_type['depreciation_rate'];
		$sql_company = "SELECT * FROM asset_company WHERE id='$company_id' ";
		$dbquery_company = mysqli_query($connect,$sql_company);
		$result_company = mysqli_fetch_array($dbquery_company);
		$workgroup		=$result['workgroup'];
			if($workgroup=='0'){ $workgroup_desc=$office_name; }
			$sql_workgroup = "SELECT * FROM system_workgroup WHERE workgroup='$workgroup' ";
			$dbquery_workgroup = mysqli_query($connect,$sql_workgroup);
			$result_workgroup = mysqli_fetch_array($dbquery_workgroup);
			$workgroup_desc=$result_workgroup['workgroup_desc'];
			$workgroup_descx=Strlen($workgroup_desc);
			if ( $workgroup_descx > 100 ){ $dot = ".."; }else{ $dot = ""; }
			$workgroup_desc=substr($workgroup_desc,0,100)."".$dot;

echo "<td align=center valign=top><a href='?option=asset&task=main/asset_print_qrcode&workgroup=$workgroup'>".$workgroup_desc."</a></td>";
		echo "<td align='center' valign=top>";
		echo "<input type=\"checkbox\" name=\"id_array[]\" id='id_array' value=\"$id\">";
		echo "</Td>";
	echo "</Tr>";
	$M++;
	$N++; //*เกี่ยวข้องกับการแยกหน้า
}

}
echo "</table>";
echo "</form>";
}
?>
<script language="JavaScript">
<!--
function goto_url_update(val){
	if(val==1){ 
		if (confirm("ยืนยันต้องพิมพ์ ใบยืมทรัพย์สิน? \nDo you want to PRINT Lend of Asset?") == true){
		callfrm("modules/asset/main/asset_print_qrcode1.php?id_array=&id_array=<?php echo $id_array;?>"); }
	}
}

function selectall(){
	for (var i=0;i<document.frm1.elements.length;i++)
	{
		var e = document.frm1.elements[i];
		if (e.name != 'allbox')
			e.checked = document.frm1.allbox.checked;
	}
}
//-->
</script>

${this.title}

Code Editor : asset_print_qrcode.php