 |
|
export_report_take_out_to_excel.php ไม่รู้ว่าเป็นเพราะ อะไร มือใหม่หัดเขียน [Export to Php]
Code.php
Code (PHP)
<?php
putenv("NLS_LANG=AMERICAN_AMERICA.TH8TISASCII");
iconv_substr($text, 0,100, "UTF-8");
header('Content-Type: text/html; charset=utf-8');
include("include/db_connect.php");
?>
<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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<form action="#" method="post" enctype="multipart/form-data" name="send">
<img src="img/zoom_in.png" width="20" height="20" class="non-printable" /> :
<input type="date" name="DateStart1" value="<?php echo $DateStart1?>" />
To DateEnd
<img src="img/zoom_in.png" width="20" height="20" class="non-printable" /> :
<input type="date" name="DateEnd1" value="<?php echo $DateEnd1 ?>" />
Department <img src="img/zoom_in.png" width="20" height="20" class="non-printable"/> :
<select name="DeptName" id="DeptName" class="StyleSrch" >
<option value="0">ກະລຸນາເລືອກພະແນກ " <?php echo $DeptName; ?> "</option>
<?php
$cdquerys="SELECT distinct bill_id.DeptName FROM stock_supplies.bill_id";
$cdresults=mysql_query($cdquerys) or die
("Query to get data from firsttable failed: ".mysql_error());
while ($cdrows=mysql_fetch_array($cdresults))
{
$nTitles=$cdrows["DeptName"];
?>
<option value="<?php echo $nTitles; ?>">
<?php echo $nTitles; ?> </option>
<?php } ?>
</select>
<input type="submit" name="search" id="search" value="search" class="non-printable" />
</form>
<?php
include("include/db_connect.php");
if(isset($_POST['search']))
{
$DateStart1=$_POST['DateStart1'];
$DateEnd1=$_POST['DateEnd1'];
$DeptName=$_POST['DeptName'];
$filName = "customer.csv";
$objWrite = fopen("customer.csv", "w");
$Do="SELECT distinct bill_out.CodeAuto,
bill_out.BillNo,
bill_out.ProductID,
bill_out.Name,
bill_out.AmountOut,
bill_out.Price,
bill_out.Total,
bill_out.Remark,
bill_out.TypeID,
hight.HightID,
hight.HightName,
location.LocationID,
location.LocationName,
group_asset.GroupID,
group_asset.GroupName,
brand.BrandID,
brand.BrandName,
size.SizeID,
size.SizeName,
IF(bill_out.CurrencyID=1,bill_out.Total,0) AS KIP,
IF(bill_out.CurrencyID=2,bill_out.Total,0) AS BATH,
IF(bill_out.CurrencyID=3,bill_out.Total,0) AS USD,
currency.CurrencyID,
currency.CurrencyName,
using.UseID,
using.UseName,
bill_id.BillNoAuto,
bill_id.BillNo,
bill_id.DateBill,
bill_id.IssueDate,
bill_id.DeptName,
bill_id.DeptID,
bill_id.Useby,
bill_id.AssetName,
bill_id.StatusBill
FROM stock_supplies.bill_out
LEFT JOIN stock_supplies.bill_id ON bill_id.BillNo = bill_out.BillNo
LEFT JOIN stock_supplies.hight ON hight.HightID = bill_out.HightID
LEFT JOIN stock_supplies.location ON location.LocationID = bill_out.LocationID
LEFT JOIN stock_supplies.group_asset ON group_asset.GroupID = bill_out.GroupID
LEFT JOIN stock_supplies.brand ON brand.BrandID = bill_out.BrandID
LEFT JOIN stock_supplies.size ON size.SizeID = bill_out.SizeID
LEFT JOIN stock_supplies.using ON using.UseID = bill_out.UseID
LEFT JOIN stock_supplies.currency ON currency.CurrencyID = bill_out.CurrencyID
WHERE (bill_id.DateBill BETWEEN '$DateStart1' AND '$DateEnd1')
AND (bill_id.DeptName = '$DeptName')
AND (bill_id.StatusBill = 'Y')
ORDER BY bill_id.BillNo,bill_id.DateBill,bill_out.ProductID ASC";
$Bw=mysql_query($Do) or die("Show Errors $Do ::".mysql_error());
mysql_query("SET NAME UTF-8");
mysql_query("SET character_set_results=utf8");
mysql_query("SET character_set_client='utf8'");
mysql_query("SET character_set_connection='utf8'");
mysql_query("collation_connection = utf8_unicode_ci");
mysql_query("collation_database = utf8_unicode_ci");
mysql_query("collation_server = utf8_unicode_ci");
iconv_substr($text, 0,100, "UTF-8");
}
?>
<?php
$i=0;
while($objResult = mysql_fetch_array($Bw))
{
++$i;
fwrite($objWrite, "\"$i\",\"$objResult[BillNo]\",\"$objResult[ProductID]\",");
fwrite($objWrite, "\"$objResult[Name]\",\"$objResult[TypeID]\",\"$objResult[BrandName]\",");
fwrite($objWrite, "\"$objResult[LocationName]\",\"$objResult[GroupName]\",\"$objResult[AmountOut]\",");
fwrite($objWrite, "\"$objResult[Price]\",\"$objResult[KIP]\",\"$objResult[BATH]\",");
fwrite($objWrite,"\"$objResult[USD]\",\"$objResult[DateBill]\",\"$objResult[IssueDate]\",");
fwrite($objWrite, "\"$objResult[AssetName]\",\"$objResult[Useby]\",\"$objResult[DeptName]\" ,");
fwrite($objWrite,"\"$objResult[DeptID]\",\"$objResult[Remark]\"\n");
}
fclose($objWrite);
echo "<br>Generate CSV Done.<br><a href=$filName>Download</a>";
?>
</table>
</body>
</html>
Tag : PHP, MySQL, HTML, CSS, Apache, XAMPP
|
|
|
 |
 |
 |
 |
| Date :
2017-08-29 09:00:37 |
By :
Bouasavanh HararRock |
View :
5469 |
Reply :
6 |
|
 |
 |
 |
 |
|
|
|
|
 |
