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

<?php
ob_start();
$strExcelFileName="Member-All.xls";
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); 
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");
header("Content-Type: application/x-msexcel; name=\"$strExcelFileName\"");
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: inline; filename=\"$strExcelFileName\"");

require_once "../../../amssplus_connect.php";	
require_once("../time_inc.php");

$officer=$_SESSION['login_user_id'];
	$sql_type = "SELECT * FROM asset_type WHERE code='$code_type' ";
	$dbquery_type = mysqli_query($connect,$sql_type);
	$result_type = mysqli_fetch_array($dbquery_type);
		$code_type = $result_type['code']; 
		$name_type = $result_type['name'];
	if($code_type==''){
		$title = "รายงาน ทรัพย์สินและค่าเสื่อมราคาทรัพยสิน - ทุกประเภท";
	}else{
		$title = "รายงาน ทรัพย์สินและค่าเสื่อมราคาทรัพย์สินประเภท - ".$name_type." (".$code_type.")";
	}
	if($workgroup!=''){
		$sql = "SELECT * FROM asset_main WHERE workgroup='$workgroup' 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' ORDER BY id ";
	}else if($code_type!=''){
		$sql = "SELECT * FROM asset_main WHERE code_type='$code_type' ORDER BY id ";
	}else{
		$sql = "SELECT * FROM asset_main ORDER BY id ";
	}
	$dbquery = mysqli_query($connect,$sql);
	$num=mysqli_num_rows($dbquery);
?>
<html xmlns:o="urn:schemas-microsoft-com:office:office"xmlns:x="urn:schemas-microsoft-com:office:excel"xmlns="http://www.w3.org/TR/REC-html40">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>
<div id="SiXhEaD_Excel" align=center x:publishsource="Excel">
<?php
echo "<TABLE x:str BORDER=1>";
echo "<tr><td colspan=6>$title</td></tr>";
echo "<tr>
    <td>ที่</td>
    <td>ที่เอกสาร</td>
    <td>วัน เดือน ปี</td>
    <td>รหัสทรัพย์สิน</td>
    <td>ประเภท</td>
    <td>ชนิด</td>
    <td>คุณสมบัติ/ลักษณะ</td>
    <td>ผู้ขาย/ผู้รับจ้าง/ผู้บริจาค</td>
    <td>จำนวน</td>
    <td>ราคา</td>
    <td>มูลค่ารวม</td>
    <td>อายุการใช้งาน</td>
    <td>อัตราค่าเสื่อมราคา</td>
    <td>ปีงบประมาณ</td>
    <td>ค่าเสื่อมประจำปี</td>
    <td>ค่าเสื่อมราคาสะสม</td>
    <td>มูลค่าสุทธิ</td>
    <td>สถานที่ตั้ง</td>
    <td>สถานะ</td>
   </tr>";
While ($result = mysqli_fetch_array($dbquery)) {
	$asset_id		=$result['id'];
	$code_type		=$result['code_type'];
	$code_list		=$result['code_list'];
	$property		=$result['property'];
	$code_asset	=$result['code_asset'];
	$company_id	=$result['company_id'];
	$asset_date	=thai_date_3($result['asset_date']);		//แสดงรูปแบบวันที่ Y-m-d เป็นวันที่ไทย
	$unit		=$result['unit'];
	$price	=$result['price'];
	$cost		=$unit * $price;
	$officer_person = $result['officer_person'];
	$budget_year	=$result['budget_year'];

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

$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);

$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);

$status			=$result['status'];
	switch ($status){
		case '1': $status_name="ใช้งาน"; break;
		case '10': $status_name="<font color=red>ส่งงานซ่อมบำรุง</font>"; break;
		case '2': $status_name="ยืม"; break;
		case '3': $status_name="โอน"; break;
		case '4': $status_name="จำหน่าย"; break;
		case '40': $status_name="<font color=red>รอจำหน่าย</font>"; break;
	}
	echo "<tr>
    <td valign=top>$asset_id</td>
    <td valign=top>$result[book]</td>
    <td valign=top>$asset_date</td>
    <td valign=top>$code_asset</td>
    <td valign=top>$result_type[name]</td>
    <td valign=top>$result_list[name]</td>
	<td valign=top>$property</td>
    <td valign=top>$result_company[name]</td>
    <td valign=top>$unit</td>
    <td valign=top>$price</td>
    <td valign=top>$cost</td>
    <td valign=top>$life</td>
    <td valign=top>$depreciation_rate</td>
    <td valign=top>$budget_year</td>
    <td valign=top>$result_depreciation[depreciation]</td>
    <td valign=top>$result_depreciation[depreciation_plus]</td>
    <td valign=top>$result_depreciation[net_value]</td>
    <td valign=top>$result_workgroup[workgroup_desc]</td>
    <td valign=top>$status_name</td>
   </tr>";

$sql_depreciation = "SELECT * FROM asset_depreciation WHERE asset_id='$asset_id' ";
	$dbquery_depreciation = mysqli_query($connect,$sql_depreciation);
	while($result_depreciation = mysqli_fetch_array($dbquery_depreciation)){
		echo "<tr>
		<td></td>
		<td></td>
		<td></td>
		<td></td>
		<td></td>
		<td></td>
		<td></td>
		<td></td>
		<td></td>
		<td></td>
		<td></td>
		<td></td>
		<td></td>
		<td valign=top>".$result_depreciation[depreciation_year]."</td>
		<td valign=top>".$result_depreciation[depreciation]."</td>
		<td valign=top>".$result_depreciation[depreciation_plus]."</td>
		<td valign=top>".$result_depreciation[net_value]."</td>
		<td></td>
		<td></td>
	   </tr>";
	}

}
echo "</table>";
echo "</div>";
?>
<script>
window.onbeforeunload = function(){return false;};
setTimeout(function(){window.close();}, 10000);
</script>
</body>
</html>

${this.title}

Code Editor : asset_report_to_excell.php