 |
|
<?
include "../include/ConnectionDb.php";
include "../include/convert.php";
if ($page=="") {
$page=1;
} else {
$page=$_REQUEST['page'];
}
if ($_REQUEST['ref_cat_id']=="A") {
$sql_bank = "SELECT * FROM tbl_orderdetail, tblcar, tbl_order, tbl_member WHERE tbl_orderdetail.carCode=tblcar.carCode and tbl_order.email=tbl_member.email and tbl_order.od_id=tbl_orderdetail.od_id";
$result_bank = mysql_query($sql_bank);
} else {
$sql_bank = "SELECT * FROM tbl_orderdetail, tblcar, tbl_order, tbl_member WHERE tbl_orderdetail.carCode=tblcar.carCode and tblcar.ref_brandCode='$_REQUEST[ref_cat_id]' and tbl_order.email=tbl_member.email and tbl_order.od_id=tbl_orderdetail.od_id ;";
$result_bank = mysql_query($sql_bank);
}
$totals = mysql_num_rows($result_bank);
$each=30;
$totalpages=ceil($totals/$each);
$goto = ($page-1)*$each;
if ($_REQUEST['ref_cat_id']=="A") {
$sql= "SELECT * FROM tbl_orderdetail, tblcar, tbl_order, tbl_member WHERE tbl_orderdetail.carCode=tblcar.carCode and tbl_order.email=tbl_member.email and tbl_order.od_id=tbl_orderdetail.od_id ORDER BY tblcar.carCode asc limit $goto,$each;";
$result = mysql_query($sql);
} else {
$sql= "SELECT * FROM tbl_orderdetail, tblcar, tbl_order, tbl_member WHERE tbl_orderdetail.carCode=tblcar.carCode and tblcar.ref_brandCode='$_REQUEST[ref_cat_id]' and tbl_order.email=tbl_member.email and tbl_order.od_id=tbl_orderdetail.od_id ORDER BY tbl_orderdetail.od_id desc limit $goto,$each;";
$result = mysql_query($sql);
}
?>
<link href="include/webstyle.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="include/supernote.js"></script>
<link rel="stylesheet" type="text/css" href="include/supernote.css" />
<STYLE type=text/css>
.unnamed1 {
FONT-SIZE: 14px; FONT-FAMILY: "MS Sans Serif", AngsanaUPC, CordiaUPC
}
.unnamed11 {
FONT-SIZE: 14px; FONT-FAMILY: "MS Sans Serif", Tahoma, sans-serif
}
body,td,th {
font-size: 14px;
font-family: MS Sans Serif, Tahoma, sans-serif;
}
</STYLE>
<link href="../include/webstyle.css" rel="stylesheet" type="text/css" />
<table width="600" border="0" align="center" cellpadding="1" cellspacing="1" class="GridPanel SortableGrid AutoExpand" id="IndexGrid">
<tr>
<td align="center"><h3>รายงานการจองรถยนต์
<?
if ($_REQUEST['ref_cat_id']=="A") {
$word="ยี่ห้อรถยนต์ทั้งหมด";
} else {
$sqln="select tblcar.ref_brandCode, tblbrand.brandName from tblcar, tblbrand WHERE tblcar.ref_brandCode=tblbrand.brandCode and tblbrand.brandCode ='$_REQUEST[ref_cat_id]' ";
$resultn = mysql_query($sqln);
$dbarrn=mysql_fetch_array($resultn) ;
$word="ยี่ห้อรถยนต์ : " . $dbarrn[brandName];
}
?>
<br />จำแนกตาม <?=$word;?></h3></td>
</tr>
</table>
<br>
<table width="600" border="0" align="center" cellpadding="1" cellspacing="1" class="GridPanel SortableGrid AutoExpand" id="IndexGrid">
<tr>
<td align="center" colspan="2"></td>
<td align="center" colspan="3">
<FORM action=viewSellbyCat.php method="post">
จำแนกตาม..
<select name="ref_cat_id">
<option value="A">ยี่ห้อรถทั้งหมด</option>
<?
$sqlc="select * from tblbrand";
$resultc = mysql_query($sqlc);
while($dbarr_cat=mysql_fetch_array($resultc)) {
echo "<option value=" . $dbarr_cat['brandCode'] . ">" . $dbarr_cat['brandName'] . "</option>";
}
?>
</select>
<INPUT type=submit value="ค้นหา" name=B1>
</FORM>
</td>
</tr>
</table>
<table width="600" border="0" align="center" cellpadding="1" cellspacing="1" class="GridPanel SortableGrid AutoExpand" id="IndexGrid">
<tr>
<td align="center" colspan="2"></td>
<td align="center" colspan="3">
<FORM action=viewSellbyMem.php method="post">
จำแนกตาม..
<select name="ref_mem_id">
<option value="A">ชื่อสมาชิกทั้งหมด</option>
<?
$sqlc="select * from tbl_member, tbl_order WHERE tbl_member.email=tbl_order.email GROUP BY tbl_order.email ";
$resultc = mysql_query($sqlc);
while($dbarr_cat=mysql_fetch_array($resultc)) {
echo "<option value=" . $dbarr_cat['email'] . ">" . $dbarr_cat['fname'] . " " . $dbarr_cat['lname'] . "</option>";
}
?>
</select>
<INPUT type=submit value="ค้นหา" name=B1>
</FORM>
</td>
</tr>
</table>
<table width="600" border="0" align="center" cellpadding="1" cellspacing="1" class="GridPanel SortableGrid AutoExpand" id="IndexGrid">
<tr>
<td align="center" colspan="2"></td>
<td align="center" colspan="3">
<FORM action=viewSellbyDate.php method="post">
จำแนกตาม..
<select name="ref_status_id">
<option value="A">วันที่จองทั้งหมด</option>
<?
$sqlc="select * from tbl_order GROUP BY od_date ORDER BY od_date desc";
$resultc = mysql_query($sqlc);
while($dbarr_cat=mysql_fetch_array($resultc)) {
echo "<option value=" . $dbarr_cat['od_id'] . ">" . $dbarr_cat['od_date'] . "</option>";
}
?>
</select>
<INPUT type=submit value="ค้นหา" name=B1>
</FORM>
</td>
</tr>
</table>
<table width="600" border="1" align="center" cellpadding="1" cellspacing="1" class="GridPanel SortableGrid AutoExpand" id="IndexGrid" >
<tr>
<td align="center" background="images/bg.jpg" height="30" width="17%"> <b>รหัสสินค้า</b></td>
<td align="center" background="images/bg.jpg" height="30" width="17%"> <b>เลขที่ใบจอง</b></td>
<td align="center" background="images/bg.jpg" height="30" width="14%"> <b>วันที่จอง</b></td>
<td width="33%" height="30" align="center" background="images/bg.jpg"> <b>สมาชิก</b></td>
<td width="17%" height="30" align="center" background="images/bg.jpg"> <b>จำนวน</b></td>
</tr>
<tr>
<td colspan="5" bgcolor="#CCCCCC"><hr></td>
</tr>
<?
while ($dbarr = mysql_fetch_array($result)) {
?>
<tr bgcolor="#FFFFFF" onMouseOver="bgColor='#d8dacf'" onMouseOut="bgColor='White'">
<td valign="top" align="center" bgcolor="<?=$bgcolor;?>" style="text-align: center;"> <?=$dbarr['carCode'];?></td>
<td valign="top" align="center" bgcolor="<?=$bgcolor;?>" style="text-align: center;"> <?=$dbarr['od_id'];?></td>
<?
$sql_m="Select * from tblbrand where brandCode='$dbarr[Cat_id]' ";
$result_m=mysql_db_query($dbname, $sql_m);
$dbarr_m=mysql_fetch_array($result_m);
?>
<td bgcolor="<?=$bgcolor;?>" style="text-align: center;" valign="top"><?=$dbarr['od_date'];?></td>
<td bgcolor="<?=$bgcolor;?>" style="text-align: left;" valign="top"> <?=$dbarr['fname'];?> <?=$dbarr['lname'];?></td>
<td bgcolor="<?=$bgcolor;?>" style="text-align: right;" valign="top"> <?=$dbarr['qty'];?> </td>
</tr>
<?
}
?>
<tr>
<td align="left" colspan="2"><input type="button" value="พิมพ์รายงานสรุป" onClick="window.print();"></td>
<td align="right" colspan="3">จำนวน <?=$totals?> รายการ :
<?
if ($totalpages>1) {
for ($i=1;$i<=$totalpages;$i++) {
if ($i == $page) {
echo "<b>หน้า $page</b>";
} else {
if (($_REQUEST['do']=="All") || ($_REQUEST['ref_cat_id']=="00")){
echo " | <a href=\"viewSell.php?do=All&page=$i\">$i</a> ";
} else {
echo " | <a href=\"viewSell.php?do=byCat&page=$i\">$i</a> ";
}
}
}
}
?> </td>
</tr>
</table>
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
2010-03-04 10:03:02 |
By :
Max77 |
View :
902 |
Reply :
0 |
|
 |
 |
 |
 |
|
|
|
|
 |
