001.<?php
002.session_start();
003.?>
004.<html>
005.<head>
006.<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
007.<title>สรุปการขายประจำวัน</title>
008.</head>
009.
010.<body>
011.<?
012.include "dbconn.inc.php";
013.
014.$years=date("Y") + 543;
015.$months=date("m");
016.$days=date("d");
017.$datenow=$days . "/" . $months . "/" . $years;
018.
019.if ($_REQUEST['ref_date_id']=="") {
020. $daten=$datenow;
021.} elseif ($_REQUEST['ref_date_id']=="0") {
022. $daten="วันที่ทั้งหมด";
023.} else {
024. $daten=$_REQUEST['ref_date_id'];
025.}
026.?>
027.
028.<table width="76%" border="0" align="center" cellpadding="1" cellspacing="1">
029. <tr>
030. <td colspan="4" align="center"><h1>สรุปการขายประจำวันที่ <?=$daten;?></h1><br>
031. <FORM name=searchDate action=showsell_date.php method="post"> ค้นหายอดขายตาม..
032. <select name="ref_date_id">
033. <option value="0">วันที่ทั้งหมด</option>
034. <?
035. $sqlc="SELECT * FROM tb_order GROUP BY od_date ORDER BY od_date DESC";
036. $resultc = mysql_query($sqlc);
037. while($dbarr_cat=mysql_fetch_array($resultc)) {
038. echo "<option value=" . $dbarr_cat['od_date'] . ">" . $dbarr_cat['od_date'] . "</option>";
039. }
040. ?>
041. </select>
042. <INPUT type=submit value="ค้นหา" name=BtnSearch>
043. </FORM>
044. </td>
045. </tr>
046. <tr bgcolor="#FF9900">
047. <td width="15%" height="30" align="center"><b>รหัสพระเครื่อง</b></td>
048. <td width="55%" height="30" align="center"><b>รายการพระเครื่อง</b></td>
049. <td width="15%" height="30" align="center"><b>จำนวนพระเครื่อง</b></td>
050. <td width="15%" height="30" align="center"><b>จำนวนเงิน</b></td>
051. </tr>
052.<?
053.if ($_REQUEST['ref_date_id']=="") {
054.$result_cat=mysql_query ("SELECT tb_product.pd_id, tb_product.pd_name,tb_category.cg_name,tb_orderview.odb_price,
055.tb_orderview.odv_amount, sum(tb_orderview.odv_amount) AS SUMQTY FROM tb_orderview,tb_order,tb_product,tb_category WHERE (tb_order.od_status<>'1') AND (tb_order.od_status<>'2') AND (tb_order.od_status<>'3')
056.AND (tb_order.od_id=tb_orderview.od_id) AND (tb_product.cg_id= tb_category.cg_id)
057.and (tb_orderview.pd_id= tb_product.pd_id) and (tb_order.od_date='$datenow')
058.GROUP BY tb_orderview.pd_id ORDER BY tb_product.pd_id")or die (mysql_error());
059.}
060.elseif ($_REQUEST['ref_date_id']=="0") {
061.$result_cat=mysql_query ("SELECT tb_product.pd_id, tb_product.pd_name,tb_category.cg_name,tb_orderview.odb_price,
062.tb_orderview.odv_amount, sum(tb_orderview.odv_amount) AS SUMQTY FROM tb_orderview,
063.tb_order,tb_product,tb_category WHERE (tb_order.od_status<>'1') AND (tb_order.od_status<>'2') AND (tb_order.od_status<>'3')
064.AND (tb_order.od_id= tb_orderview.od_id) AND (tb_product.cg_id= tb_category.cg_id)
065.AND(tb_orderview.pd_id= tb_product.pd_id) GROUP BY tb_orderview.pd_id ORDER BY tb_product.pd_id")or die (mysql_error());
066.}
067.else
068.{
069.$result_cat = mysql_query("SELECT tb_product.pd_id, tb_product.pd_name,tb_category.cg_name,tb_orderview.odb_price,
070.tb_orderview.odv_amount, sum(tb_orderview.odv_amount) AS SUMQTY FROM tb_orderview,
071.tb_order , tb_product ,tb_category WHERE (tb_order.od_status<>'1') AND (tb_order.od_status<>'2') AND (tb_order.od_status<>'3')
072.AND (tb_order.od_id= tb_orderview.od_id) AND (tb_product.cg_id= tb_category.cg_id)
073.AND (tb_orderview.pd_id= tb_product.pd_id) and (tb_order.od_date='$_REQUES[ref_date_id]')
074.GROUP BY tb_orderview.pd_id ORDER BY tb_product.pd_id") or die (mysql_error());
075.}
076.
077.$totalrecord=mysql_num_rows($result_cat);
078.while ($dbarr_cat = mysql_fetch_array($result_cat)) {
079.$total=$dbarr_cat['odv_amount']*$dbarr_cat['odb_price'];
080.$mtotal=$mtotal+$dbarr_cat['SUMTOTAL'];
081.$ctotal=$ctotal+$dbarr_cat['SUMQTY'];
082.?>
083. <tr>
084. <td align="center"> <?=$dbarr_cat['pd_id'] ?></td>
085. <td align="left"><?=$dbarr_cat['pd_name']?> - <?=$dbarr_cat['cg_name']?></td>
086. <td align="center"><?=$dbarr_cat['SUMQTY']?></td>
087. <td align="right"> <?=number_format($total,2,'.',','); ?></td>
088. </tr>
089.<?
090.}
091.?>
092. <tr bgcolor="#CC6600">
093. <td colspan="2" align="right"><b>รวมทั้งหมด</b></td>
094. <td align="center"><?=$ctotal;?></td>
095. <td align="right"><b><?=number_format($mtotal,2,'.',','); ?></b></td>
096. </tr>
097.</table>
098.
099.</body>
100.</html>
Quote:
