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

<?php
session_start();
?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="../../../css/mm_training.css">
<?php
require_once "../../../amssplus_connect.php";	
include("../../../include/time_inc.php");
//ส่วนหัว
echo "<div align=right>
	&nbsp;|&nbsp;<a href='javascript:window.print();'>พิมพ์</a>
	&nbsp;|&nbsp;<a href='javascript:window.close();'>ปิด</a>
	&nbsp;&nbsp; </div>";
echo " ";
echo "<table width='98%' border='0' align='center'>";
echo "<tr align='center'><td>ทะเบียนคุมทรัพย์สิน</td></tr>";
echo "<tr align='right'>
	<td>ส่วนราชการ&nbsp; ".$office."
	 หน่วยงาน&nbsp; งานพัสดุ
	</td></tr>";
echo "</table>";
//ส่วนแสดงรายละเอียด
	$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'];

$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;
	}
	$remark_status		=$result['remark_status'];
	$photo	=$result['photo'];
	$photo_qrcode	=$result['photo_qrcode'];

//แสดงข้อมูล
	echo "<table align=center>";
	echo "<tr>";
		echo "<td valign=top><img src='../../../$photo' width='120' border=0> <img src='../../../$photo_qrcode' width='120' border=0></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 "<DIV style=\"page-break-after:always\"></DIV>";
		echo " ";
		echo "<center>ประวัติการซ่อมบำรุงรักษาทรัพย์สิน</center>";

echo "<table class='myTableAcc'>";
		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)){
			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=300>".$result_noti['note']."</td>";
			echo "</tr>";
			$N++;
		}
		echo "</table>";
	}
	echo " ";

${this.title}

Code Editor : asset_print.php