<?php
if (!defined('WEB_ROOT')) {
exit;
}
if (!isset($_GET['oid']) || (int)$_GET['oid'] <= 0) {
header('Location: index.php');
}
$orderId = (int)$_GET['oid'];
// get ordered items
$sql = "SELECT pd_name, pd_price, od_qty
FROM tbl_order_item oi, tbl_product p
WHERE oi.pd_id = p.pd_id and oi.od_id = $orderId
ORDER BY od_id ASC";
$result = dbQuery($sql);
$orderedItem = array();
while ($row = dbFetchAssoc($result)) {
$orderedItem[] = $row;
}
// get order information
$sql = "SELECT od_date, od_last_update, od_status, od_shipping_first_name, od_shipping_last_name, od_shipping_address1,
od_shipping_address2, od_shipping_phone, od_shipping_state, od_shipping_city, od_shipping_postal_code, od_shipping_cost,
od_payment_first_name, od_payment_last_name, od_payment_address1, od_payment_address2, od_payment_phone,
od_payment_state, od_payment_city , od_payment_postal_code,
od_memo
FROM tbl_order
WHERE od_id = $orderId";
$result = dbQuery($sql);
extract(dbFetchAssoc($result));
$orderStatus = array('New', 'Paid', 'Shipped', 'Completed', 'Cancelled');
$orderOption = '';
foreach ($orderStatus as $status) {
$orderOption .= "<option value=\"$status\"";
if ($status == $od_status) {
$orderOption .= " selected";
}
$orderOption .= ">$status</option>rn";
}
?>
<p> </p>
<form action="" method="get" name="frmOrder" id="frmOrder">
<table width="550" border="0" align="center" cellpadding="5" cellspacing="1" class="detailTable">
<tr>
<td colspan="2" align="center" id="infoTableHeader">Order Detail</td>
</tr>
<tr>
<td width="150" class="label">Order Number</td>
<td class="content"><?php echo $orderId; ?></td>
</tr>
<tr>
<td width="150" class="label">Order Date</td>
<td class="content"><?php echo $od_date; ?></td>
</tr>
<tr>
<td width="150" class="label">Last Update</td>
<td class="content"><?php echo $od_last_update; ?></td>
</tr>
<tr>
<td class="label">Status</td>
<td class="content"> <select name="cboOrderStatus" id="cboOrderStatus" class="box">
<?php echo $orderOption; ?> </select> <input name="btnModify" type="button" id="btnModify" value="Modify Status" class="box" onClick="modifyOrderStatus(<?php echo $orderId; ?>);"></td>
</tr>
</table>
</form>
<p> </p>
<table width="550" border="0" align="center" cellpadding="5" cellspacing="1" class="detailTable">
<tr id="infoTableHeader">
<td colspan="3">Ordered Item</td>
</tr>
<tr align="center" class="label">
<td>Item</td>
<td>Unit Price</td>
<td>Total</td>
</tr>
<?php
$numItem = count($orderedItem);
$subTotal = 0;
for ($i = 0; $i < $numItem; $i++) {
extract($orderedItem[$i]);
$subTotal += $pd_price * $od_qty;
?>
<tr class="content">
<td><?php echo "$od_qty X $pd_name"; ?></td>
<td align="right"><?php echo displayAmount($pd_price); ?></td>
<td align="right"><?php echo displayAmount($od_qty * $pd_price); ?></td>
</tr>
<?php
}
?>
<tr class="content">
<td colspan="2" align="right">Sub-total</td>
<td align="right"><?php echo displayAmount($subTotal); ?></td>
</tr>
<tr class="content">
<td colspan="2" align="right">Shipping</td>
<td align="right"><?php echo displayAmount($od_shipping_cost); ?></td>
</tr>
<tr class="content">
<td colspan="2" align="right">Total</td>
<td align="right"><?php echo displayAmount($od_shipping_cost + $subTotal); ?></td>
</tr>
</table>
<p> </p>
<table width="550" border="0" align="center" cellpadding="5" cellspacing="1" class="detailTable">
<tr id="infoTableHeader">
<td colspan="2">Shipping Information</td>
</tr>
<tr>
<td width="150" class="label">First Name</td>
<td class="content"><?php echo $od_shipping_first_name; ?> </td>
</tr>
<tr>
<td width="150" class="label">Last Name</td>
<td class="content"><?php echo $od_shipping_last_name; ?> </td>
</tr>
<tr>
<td width="150" class="label">Address1</td>
<td class="content"><?php echo $od_shipping_address1; ?> </td>
</tr>
<tr>
<td width="150" class="label">Address2</td>
<td class="content"><?php echo $od_shipping_address2; ?> </td>
</tr>
<tr>
<td width="150" class="label">Phone Number</td>
<td class="content"><?php echo $od_shipping_phone; ?> </td>
</tr>
<tr>
<td width="150" class="label">Province / State</td>
<td class="content"><?php echo $od_shipping_state; ?> </td>
</tr>
<tr>
<td width="150" class="label">City</td>
<td class="content"><?php echo $od_shipping_city; ?> </td>
</tr>
<tr>
<td width="150" class="label">Postal Code</td>
<td class="content"><?php echo $od_shipping_postal_code; ?> </td>
</tr>
</table>
<p> </p>
<table width="550" border="0" align="center" cellpadding="5" cellspacing="1" class="detailTable">
<tr id="infoTableHeader">
<td colspan="2">Payment Information</td>
</tr>
<tr>
<td width="150" class="label">First Name</td>
<td class="content"><?php echo $od_payment_first_name; ?> </td>
</tr>
<tr>
<td width="150" class="label">Last Name</td>
<td class="content"><?php echo $od_payment_last_name; ?> </td>
</tr>
<tr>
<td width="150" class="label">Address1</td>
<td class="content"><?php echo $od_payment_address1; ?> </td>
</tr>
<tr>
<td width="150" class="label">Address2</td>
<td class="content"><?php echo $od_payment_address2; ?> </td>
</tr>
<tr>
<td width="150" class="label">Phone Number</td>
<td class="content"><?php echo $od_payment_phone; ?> </td>
</tr>
<tr>
<td width="150" class="label">Province / State</td>
<td class="content"><?php echo $od_payment_state; ?> </td>
</tr>
<tr>
<td width="150" class="label">City</td>
<td class="content"><?php echo $od_payment_city; ?> </td>
</tr>
<tr>
<td width="150" class="label">Postal Code</td>
<td class="content"><?php echo $od_payment_postal_code; ?> </td>
</tr>
</table>
<p> </p>
<table width="550" border="0" align="center" cellpadding="5" cellspacing="1" class="detailTable">
<tr id="infoTableHeader">
<td colspan="2">Buyer's Memo</td>
</tr>
<tr>
<td colspan="2" class="label"><?php echo nl2br($od_memo); ?> </td>
</tr>
</table>
<p> </p>
<p align="center">
<input name="btnBack" type="button" id="btnBack" value="Back" class="box" onClick="window.history.back();">
</p>
<p> </p>
<p> </p>
|