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 : index.php

<?php
require_once("include/time_inc.php");
	$officer=$_SESSION['login_user_id'];
	echo "<div style='background-image:url(modules/asset/images/asset.png); background-repeat:no-repeat; -webkit-background-size: cover; background-size: cover; height:150vh; width:100% '>";
	echo "<br>";

echo "<table class='myTableGreen' style='opacity:0.8; filter:alpha(opacity=90); '>";
	echo "<tr><td colspan='8' align='right'><a href='modules/asset/main/asset_print_lend2.php' target='_blank'>
		<INPUT TYPE='button' value='พิมพ์ ใบยืมพัสดุ'></a>
		</td></tr>";
	echo "<tr>
		<th nowrap>รหัสทรัพย์สิน</th>
		<th nowrap>วันที่ถือครอง</th>
		<th>ประเภททรัพย์สิน</th>
		<th>รายการ/คุณสมบัติ</th>
		<th>ราคา</th>
		<th nowrap>อายุการใช้งาน</th>
		<th colspan=2>สถานะ/แจ้งซ่อม</th>
		</tr>";
	$sql = "SELECT * FROM asset_main WHERE officer_person='$officer' AND status!='4' ";
	$dbquery = mysqli_query($connect,$sql);
	$num_rows = mysqli_num_rows($dbquery);
	if ($num_rows == '0'){ $tr_status_no='<tr><td colspan=7>ท่านไม่ข้อมูลการถือครองทรัพย์สินของทางราชการ</td></tr>'; }else{ $tr_status_no=''; }
	echo $tr_status_no;
	while($result = mysqli_fetch_array($dbquery)){
		$id				=$result['id'];
		$property		=$result['property'];
		$model			=$result['model'];
		$unit				=$result['unit'];
		$price			=$result['price'];
		$code_asset	=$result['code_asset'];
		$code_type		=$result['code_type'];
		$code_list		=$result['code_list'];
			$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);
			$name_list		=$result_list['name'];
			$sql_type = "SELECT * FROM asset_type WHERE code='$code_type' ";
			$dbquery_type = mysqli_query($connect,$sql_type);
			$result_type = mysqli_fetch_array($dbquery_type);
			$name_type	=$result_type['name'];
		$life	=$result_type['life'];
		$depreciation_rate	=$result_type['depreciation_rate'];
		$officer_date	= thai_date_3($result['officer_date']);
		$list='';
		if($result['model']!=''){ $list=$list."<font color=gray>รุ่น/แบบ</font> ".$result['model'] ; }
		if($result['property']!=''){ $list=$list."<br><font color=gray>คุณสมบัติ</font> ".$result['property']; }

$sql_notification = "SELECT * FROM asset_notification WHERE asset_id='$id' ";
		$dbquery_notification = mysqli_query($connect,$sql_notification);
		$result_notification = mysqli_fetch_array($dbquery_notification);
		$notification_id = $result_notification['id'];
		$status_notification = $result_notification['status'];
		$status					=$result['status'];
		switch ($status){
			case 1 : 
				if( ($status_notification=='') or ($status_notification=='4') ){
					$status_name="ใช้งาน"; 
					$status_link="<a href='?option=asset&task=main/asset_notification&index=1&asset_id=$id'><img src='images/my-icons/service-1.png' width='24' height='24' alt='แจ้งซ่อม' title='แจ้งซ่อม'></a>";
				}else{
					$status_name="<font color=red>รอคิว</font>"; 
					$status_link="<a href='?option=asset&task=main/asset_notification&index=7&id=$notification_id'>
						<img src='images/my-icons/service-status-0.png' width='24' height='24' alt='ส่งงานซ่อมบำรุง' title='ส่งงานซ่อมบำรุง'>
						</a>"; 
				}
			break;
			case 2 : 
				$status_name="ยืม"; 
				$status_link="<img src='images/my-icons/service-2.png' width='24' height='24' alt='ยืม' title='ยืม'>";
			break;
			case 3 : 
				$status_name="โอน"; 
				$status_link="<img src='images/my-icons/service-3.png' width='24' height='24' alt='โอน' title='โอน'>"; 
			break;
			case 4 : 
				$status_name="จำหน่าย"; $status_link="<img src='images/my-icons/service-4.png' width='24' height='24' alt='จำหน่าย' title='จำหน่าย'>"; break;
			case 10 : 
				$status_name="<font color=red>ส่งงานซ่อมบำรุง</font>"; 
				$status_link="<a href='?option=asset&task=main/asset_notification&index=7&id=$notification_id'>
					<img src='images/my-icons/service-status-0.png' width='24' height='24' alt='ส่งงานซ่อมบำรุง' title='ส่งงานซ่อมบำรุง'>
					</a>"; 
			break;
			case 40 : 
				$status_name="<font color=red>รอจำหน่าย</font>"; 
				$status_link="<a href='?option=asset&task=main/asset_notification&index=7&id=$notification_id'>
					<img src='images/my-icons/service-status-3.png' width='24' height='24' alt='รอจำหน่าย' title='รอจำหน่าย'></a>"; 
			break;
		}
		echo "<tr>";
			echo "<td valign=top align=center nowrap>".$code_asset."</td>";
			echo "<td valign=top align=center nowrap>".$officer_date."</td>";
			echo "<td valign=top>".$name_type." : ".$name_list."</td>";
			echo "<td valign=top>".$list."</td>";
			echo "<td valign=top align=right nowrap>".number_format($price,2)."</td>";
			echo "<td valign=top align=center>".$life." ปี / ".$depreciation_rate." %</td>";
			echo "<td valign=top align=center nowrap>".$status_name."</td>";
			echo "<td valign=top align=center nowrap>".$status_link." <a href='?option=asset&task=main/asset&index=7&id=$id'><img src='images/my-icons/browse.png' width='24' height='24' alt='ดูรายละเอียด' title='ดูรายละเอียด'></a></td>";
		echo "</tr>";
	}
	echo "</table>";
	echo "</div>";
?>

${this.title}

Code Editor : index.php