Gecko [ 122.154.134.11 ]

Name	Size	Permission
css	[ DIR ]	drwxr-xr-x
e-budget	[ DIR ]	drwxr-xr-x
.DS_Store	6 KB	-rw-r--r--
index.php	15.62 KB	-rw-r--r--
menu.php	1.46 KB	-rw-r--r--
report_e-asset_detail.php	9.63 KB	-rw-r--r--
report_e-budget_Expense.php	17.02 KB	-rw-r--r--
report_e-budget_group.php	15.64 KB	-rw-r--r--
report_e-budget_stregic.php	15.65 KB	-rw-r--r--

Code Editor : report_e-asset_detail.php

$sql = "SELECT * FROM asset_main WHERE id='$id' ";
	$dbquery = mysqli_query($connect,$sql);
	$result = mysqli_fetch_array($dbquery);
	$unit				=$result['unit'];
	$price			=$result['price'];
	$code_asset	=$result['code_asset'];
	$building		=$result['building'];
	$floor			=$result['floor'];
	$room			=$result['room'];
	$remark_status=$result['remark_status'];
	$photo			=$result['photo'];
	$photo_qrcode=$result['photo_qrcode'];

$code_type		=$result['code_type'];
		$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'];

$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'];

$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'];
 
	$company_id		=$result['company_id'];
		$sql_company = "SELECT * FROM asset_company WHERE id='$company_id' ";
		$dbquery_company = mysqli_query($connect,$sql_company);
		$result_company = mysqli_fetch_array($dbquery_company);
		if($result_company['tel']!=''){ $tel="โทร.".$result_company['tel']; }
		$name_company=$result_company['name'];
		$address_company=$result_company['address']." ".$tel;

$officer_person		=$result['officer_person'];
		$sql_person = "SELECT * FROM person_main WHERE person_id='$officer_person' ";
		$dbquery_person = mysqli_query($connect,$sql_person);
		$result_person = mysqli_fetch_array($dbquery_person);
		$officer_person_name=$result_person['prename']."".$result_person['name']."  ".$result_person['surname'];

$officer_date	= thai_date_2($result['officer_date']);
	$asset_date	= thai_date_2($result['asset_date']);

$budget_type_id		=$result['budget_type_id'];
		$sql_budget = "SELECT * FROM asset_budget_type WHERE id='$budget_type_id' ";
		$dbquery_budget = mysqli_query($connect,$sql_budget);
		$result_budget = mysqli_fetch_array($dbquery_budget);
		$budget_type_name=$result_budget['name'];

$method_id			=$result['method_id'];
		$sql_method = "SELECT * FROM asset_method WHERE id='$method_id' ";
		$dbquery_method = mysqli_query($connect,$sql_method);
		$result_method = mysqli_fetch_array($dbquery_method);
		$method_name=$result_method['name'];

$status					=$result['status'];
	switch ($status){
		case 1 : $status_name="ใช้งาน"; break;
		case 2 : $status_name="ยืม"; break;
		case 3 : $status_name="โอน"; break;
		case 4 : $status_name="จำหน่าย"; break;
		case 10 : $status_name="ส่งงานซ่อมบำรุง"; break;
		case 40 : $status_name="รอจำหน่าย"; break;
	}
	//แสดงข้อมูล
	echo "<div align=right>
		<a href='javascript:window.print();'><img src='../images/my-icons/print.png' border='0' alt='พิมพ์' title='พิมพ์' width=38 height=38></a>
		</div>";
	
	echo "<table align=center>";
	echo "<tr>";
		echo "<td valign=top><img src='../$photo_qrcode' width='100' border=0> &nbsp;&nbsp; <img src='../$photo' width='100' border=0> &nbsp;&nbsp; </td>";
		echo "<td width=10>&nbsp;</td>";
		echo "<td valign=top>";
			echo "ประเภท ".$name_type." (".$code_type.")".str_repeat("&nbsp;", 10)."รายการ ".$name_list." (".$code_list.") ";
			echo "รหัส ".$code_asset." ";
			echo "ลักษณะ/คุณสมบัติ ".$result['property']."".str_repeat("&nbsp;", 10)."รุ่น/แบบ ".$result['model']." ";
			echo "สถานที่ตั้ง/หน่วยงานที่รับผิดชอบ ".$workgroup_desc."".str_repeat("&nbsp;", 10)."อาคาร ".$building."".str_repeat("&nbsp;", 10)."ชั้น ".$floor."".str_repeat("&nbsp;", 10)."ห้อง ".$room." ";
			echo "ผู้ถือครอง ".$officer_person_name."".str_repeat("&nbsp;", 10)." ".$officer_date." ";
			echo "ชื่อผู้ขาย/ผู้รับจ้าง/ผู้บริจาค ".$name_company."".str_repeat("&nbsp;", 10)."ที่อยู่ ".$address_company." ";
			echo "ประเภทเงิน ".$budget_type_name."".str_repeat("&nbsp;", 10)."วิธีการได้มา ".$method_name."".str_repeat("&nbsp;", 10)."สถานะ ".$status_name." ";
			if ($status!='1'){
				echo "สาเหตุ ".$remark_status." ";
			}
			echo "ที่เอกสาร ".$result['book']."".str_repeat("&nbsp;", 10)." ".$asset_date."".str_repeat("&nbsp;", 10)."จำนวนหน่วย ".$unit."".str_repeat("&nbsp;", 10)."ราคาต่อหน่วย/ชุด/กลุ่ม ".number_format($price,2)." บาท ";
			echo "อายุการใช้งาน ".$life." ปี".str_repeat("&nbsp;", 10)."อัตราค่าเสื่อมราคาต่อปี ".$depreciation_rate."%";
		echo "</td>";
	echo "</tr>";
	echo "</table>";

echo "<table class='myTableAcc'>";
	echo "<tr>
		<th>ปีงบประมาณ</th>
		<th colspan=2>วัน เดือน ปี</th>
		<Th align=center width='120'>มูลค่ารวม</Th>
		<Th align=center width='200'>อายุใช้งาน</Th>
		<Th align=center width='135'>ค่าเสื่อมราคาประจำปี</Th>
		<Th align=center width='120'>ค่าเสื่อมราคาสะสม</Th>
		<Th align=center width='120'>มูลค่าสุทธิ</Th>
		</tr>";

$sql_dep = "SELECT * FROM asset_depreciation WHERE asset_id='$id' ORDER BY depreciation_year";
	$dbquery_dep = mysqli_query($connect,$sql_dep);
	while($result_dep = mysqli_fetch_array($dbquery_dep)){
		echo "<tr>
			<th>".($result_dep['depreciation_year']+543)."</th>
			<td align=center width='10%'>".thai_date_short_1($result_dep['start_period'])."</td>
			<td align=center width='10%'>".thai_date_short_1($result_dep['end_period'])."</td>
			<td align=center width='15%'>".number_format($result_dep['cost'], 2)."</td>
			<td align=center width='10%'>".$result_dep['life_inyear_budget']."</td>
			<td align=center width='15%'>".number_format($result_dep['depreciation'],2)."</td>
			<td align=center width='15%'>".number_format($result_dep['depreciation_plus'],2)."</td>
			<td align=center width='15%'>".number_format($result_dep['net_value'],2)."</td>
		</tr>";
	}
	//$asset_date	=thai_date_3($result['asset_date']);		//แสดงรูปแบบวันที่ Y-m-d เป็นวันที่ไทย
	echo "</table>";
	//สิ้นสุด - คำนวณค่าเสื่อมราคา

echo " ";
	$sql_noti = "SELECT * FROM asset_notification WHERE asset_id='$id' ORDER BY order_no";
	$dbquery_noti = mysqli_query($connect,$sql_noti);
	$num_rows = mysqli_num_rows($dbquery_noti);
	if($num_rows=='0'){
		echo "<center>ไม่มี - ประวัติการซ่อมบำรุงรักษาทรัพย์สิน</center>";
	}else{
		echo "<center>ประวัติการซ่อมบำรุงรักษาทรัพย์สิน</center>";
		echo "<table class='myTableGray'>";
		echo "<tr>
			<th width=50>ครั้งที่</th>
			<Th width=200>วัน เดือน ปี</Th>
			<Th>รายการ</Th>
			<Th width=100>จำนวนเงิน</Th>
			<Th nowrap>หมายเหตุ</Th>
			</tr>";
		$N=1;
		while($result_noti = mysqli_fetch_array($dbquery_noti)){
			$note=$result_noti['note'];
	//		$note_len=Strlen($note);
	//		if ( $note_len > 200 ){ $dot = ".."; }else{ $dot = ""; }
	//		$note=substr($note,0,200)."".$dot;
			echo "<tr>";
				echo "<td align=center valign=top width=50>".$N."</td>";
				echo "<td align=center valign=top width=200>".thai_date_5($result_noti['order_datetime'])."</td>";
				echo "<td valign=top>".$result_noti['subject']."</td>";
				echo "<td align=right valign=top width=100>".number_format($result_noti['budget'],2)."</td>";
				echo "<td valign=top width=250>".$note."</td>";
			echo "</tr>";
			$N++;
		}
		echo "</table>";
	}
	echo " ";
?>

${this.title}

Code Editor : report_e-asset_detail.php