|
='".$_REQUEST['search_from_date']."' and order_date<='".$_REQUEST['search_to_date']."' ";
}
if($_REQUEST['payment_status']!=''){
$name=$_REQUEST['payment_status'];
$where.=" and payment_status='".$name."'";
}
$start=0;
if(isset($_GET['start'])) $start=$_GET['start'];
$pagesize=100;
if(isset($_GET['pagesize'])) $pagesize=$_GET['pagesize'];
$order_by='id';
if(isset($_GET['order_by'])) $order_by=$_GET['order_by'];
$order_by2='desc';
if(isset($_GET['order_by2'])) $order_by2=$_GET['order_by2'];
$sql=$obj->Query("select * from $tbl_order where 1=1 $where order by $order_by $order_by2 limit $start, $pagesize");
$sql2=$obj->query("select * from $tbl_order where 1=1 $where order by $order_by $order_by2",$debug=-1);
$reccnt=$obj->numRows($sql2);
if($reccnt==0)
{
?>
| S No. |
Order ID |
Order Amount |
Cart Amount |
Refund Processed (due to items unavaialability) |
Discount |
Discount Via |
Commision |
Low Tax | High Tax | City of Chicago/Soda Tax | Total Tax Value | Delivert Type |
Delivery Charge |
CC Fees |
Order Date & Time |
fetchNextObject($sql))
{
$i++;
if($i%2==0)
{
$bgcolor = "#f3f4f6";
}
else
{
$bgcolor = "";
}
?>
| . |
id);
?>
|
total_amount,2);
?>
|
amount,2);
?>
|
|
discount,2);
?>
|
discount_via;
?>
|
total_amount*4/100),2);
?>
|
lowtax,2);
?>
|
hightax,2);
?>
|
cityofchicago_sodatax,2);
?>
|
tax_value,2);
?>
|
delivery_type;
?>
|
shipping_amount,2);
?>
|
total_amount*2.99/100),2);
?>
|
order_date));
?>
|
|
|
| |
|
|
| |
|
|
|
|
Admin: View Amount Breakup Report