Search
Order ID:
Stores:
All
query("select storeid,storename from stores where tab_store = 1 order by storename"); while ($storenumrec = $obj->fetchNextObject($storenum)) { ?>
storeid == $_REQUEST['search_storename']) { ?>selected>storename); ?>
View All
Order Status:
-Select-
query("select * from $tbl_order_status where status=1 order by id"); while($resultOrder=$obj->fetchNextObject($orderArr)){?>
id){?>selected >order_status); ?>
Payment Status
-Select-
selected> Successful
selected> Unsuccessful
From Date:
To Date:
Admin: View Amount Breakup Report
Note: Reporting will be supported after March 2021
='".$_REQUEST['search_from_date']."' and o.order_date<='".$_REQUEST['search_to_date']."' "; } if($_REQUEST['payment_status']!=''){ $name=$_REQUEST['payment_status']; $where.=" and o.payment_status='".$name."'"; } $start=0; if(isset($_GET['start'])) $start=$_GET['start']; $pagesize=100; if (isset($_GET['pagesize'])) $pagesize = $_GET['pagesize']; if($_REQUEST['search_storename']==''){ echo "
Please select store!
"; }else{ //echo "select o.id, sum(ot.wh_price*qty) as cartamt, sum(ot.wh_price*qty)-((sum(ot.wh_price*qty)*8)/100)-(((sum(ot.wh_price*qty)+sum(ot.wh_tax_value*qty))*3)/100) as paistoStore, (sum(ot.wh_price*qty)*8)/100 as comm, sum(ot.wh_tax_value*qty) as totaltax,((sum(ot.wh_price*qty)+sum(ot.wh_tax_value*qty))*3)/100 as ccfee, o.delivery_type,o.order_date from tbl_order o left join tbl_order_itmes ot on o.id=ot.order_id where $where o.order_date>='2021-03-01' and o.order_date<='2021-03-31' group by o.id order by o.id"; //$storesql=$obj->query("select storename,tbl_store_zip.commission from stores left join tbl_store_zip on stores.storeid=tbl_store_zip.storeid where stores.storeid='".$_REQUEST['search_storename']."'"); //$resultstore=$obj->fetchNextObject($storesql); $storesql=$obj->query("select storename from stores where stores.storeid='".$_REQUEST['search_storename']."'"); $resultstore=$obj->fetchNextObject($storesql); $sql=$obj->Query("select o.id, sum(ot.wh_price*qty) as cartamt, sum(ot.wh_price*qty)-((sum(ot.wh_price*qty))/100)-(((sum(ot.wh_price*qty)+sum(ot.wh_tax_value*qty))*3)/100) as paistoStore, (sum(ot.wh_price*qty))/100 as comm, sum(ot.wh_tax_value*qty) as totaltax,((sum(ot.wh_price*qty)+sum(ot.wh_tax_value*qty))*3)/100 as ccfee, o.delivery_type,o.order_date from go_order o left join go_order_itmes ot on o.id=ot.order_id where o.order_date>'2020-04-01' $where group by o.id order by o.id"); $sql2=$obj->Query("select o.id from go_order o left join go_order_itmes ot on o.id=ot.order_id where o.order_date>'2020-04-01' $where group by o.id order by o.id"); $reccnt=$obj->numRows($sql2); if($reccnt==0) { ?>
No Record
Records Found.
S No.
Order ID
Cart Amount
Refund Processed (due to items unavailability)
Quicklly Commission
Total Sales Tax
CC Fees
Order Date & Time
fetchNextObject($sql)) { $i++; if($i%2==0) { $bgcolor = "#f3f4f6"; } else { $bgcolor = ""; } ?>
.
id); ?>
cartamt,2); ?>
comm,2); ?>
totaltax,2); ?>
ccfee,2); ?>
order_date)); ?>
Admin: View Amount Breakup Report Note: Reporting will be supported after March 2021