| Server IP : 182.53.201.61 / Your IP : 216.73.217.175 Web Server : Apache/2.2.15 (Fedora) System : Linux km10.dyndns.org 2.6.31.5-127.fc12.i686.PAE #1 SMP Sat Nov 7 21:25:57 EST 2009 i686 User : apache ( 48) PHP Version : 5.3.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/stockcom/ |
Upload File : |
<?php
session_start();
$ebits = ini_get('error_reporting');
error_reporting($ebits ^ E_NOTICE);
$date = date("Y-m-d H:i:s");
//$date = date('Y-m-d',time());
//echo $date.'<br>';
$datey = substr($date,0,4)+543;
$datem = substr($date,5,2);
$dated = substr($date,8,2);
$datenow =$dated."-".$datem."-".$datey ;
$time =substr($date,10,6);
?>
<script src="https://unpkg.com/xlsx/dist/xlsx.full.min.js" ></script>
<script src="https://unpkg.com/file-saver@1.3.3/FileSaver.js" ></script>
<script>
function ExcelReport()//function สำหรับสร้าง ไฟล์ excel จากตาราง
{
var sheet_name="excel_sheet";/* กำหหนดชื่อ sheet ให้กับ excel โดยต้องไม่เกิน 31 ตัวอักษร */
var elt = document.getElementById('myTable');/*กำหนดสร้างไฟล์ excel จาก table element ที่มี id ชื่อว่า myTable*/
/*------สร้างไฟล์ excel------*/
var wb = XLSX.utils.table_to_book(elt, {sheet: sheet_name});
XLSX.writeFile(wb,'report.xlsx');//Download ไฟล์ excel จากตาราง html โดยใช้ชื่อว่า report.xlsx
}
</script>
<html>
<head>
<title>ตรวจสอบเอกสาร</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<?php
function formatDateshow($date)
{
if ($date == NULL) $newdata ='';
else {
$data = $date->format('Y-m-d ');
$data = explode("-", $data);
$newdata = $data[2]."-".$data[1]."-".($data[0]+543);
}
return $newdata;
}
?>
</head>
<body>
<?php
//echo '<br>'.'<p align="center">'.$docid.'</p>';
//echo $AssID.'<br>';
$serverName = "localhost"; //serverName\instanceName
$connectionInfo = array( "Database"=>"stockcom", "UID"=>"root",
"PWD"=>"123456", "CharacterSet" => "UTF-8");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
$query2 = "SELECT * FROM dbo.DimGood ";
echo $query2.'<br>';
$result2 = sqlsrv_query($conn, $query2);
echo $result2.'<br>';
?>
<table align="center" border="1" width="90%" id="myTable">
<tr align="center"><td>GoodID</td>
<td>Good</td>
<td>spec</td>
<td>bUnit</td>
<td>ItemID</td>
<td>MinStock</td>
</tr>
<?php
while($row2=sqlsrv_fetch_array($result2,SQLSRV_FETCH_ASSOC)){
//formatDateshow($row2['checkdate'])
//echo'h'.formatDateshow($row2['CheckDate']);
//$ID=$row2['GoodID'];
$G=$row2['GoodID'];
echo'<tr>';
echo'<td>'. $row2['GoodID'].'</td>';
echo'<td>'. $row2['Good'].'</td>';
echo'<td>'. $row2['spec'].'</td>';
echo'<td>'. $row2['bUnit'].'</td>';
echo'<td>'. $row2['ItemID'].'</td>';
if($row2['MinStock']=='0'){
echo '<td></td>';
}else
echo'<td>'. $row2['MinStock'].'</td>';
?>
<?php
}
?>
</tr>
</table>
<?php
echo "<p align='center'><a href='#' id='download_link' class='btn btn-primary'
onClick='javascript:ExcelReport();'>Excel</a>";
echo ' <a href=""><input name="submit" type="submit" style="width:150px; height:25px; font-size:16px;" value="แก้ไข สถานะ"><a></p>'.'<br>';
?>
</body>
</html>