location)); $userziparr=array(); $userzip=$obj->query("select zip from tbl_store_zip where state in ('$user_location') and zip!='' group by zip"); while($resuserZip=$obj->fetchNextObject($userzip)){ array_push($userziparr,$resuserZip->zip); } $userLocationZip=implode(',',$userziparr); if($user_location!=''){ $userlocationWhere='and tbl_order.ship_pincode in('.$userLocationZip.')'; } } ?>
Search
Order ID: Email: Customer Type: Store Name:
Order Status: Order Type: Payment Status: Ordered Device:
User ID: From Date: To Date: View All
='" . $_REQUEST['search_from_date'] . "' and tbl_order.order_date<='" . $_REQUEST['search_to_date'] . "' "; } $start = 0; if (isset($_GET['start'])) $start = $_GET['start']; $pagesize = 30; if (isset($_GET['pagesize'])) $pagesize = $_GET['pagesize']; $qry = "select tbl_order_itmes.storeid,tbl_order_itmes.section,tbl_order.id,tbl_order.ship_email,tbl_order.user_id,tbl_order.order_via,tbl_order.order_type,tbl_order.total_amount,tbl_order.order_date,tbl_order.tracking_no,tbl_order_status.order_status,tbl_order.payment_status,tbl_order.ship_full_address,tbl_order.usps_expected_delivery,tbl_order.delivery_note,tbl_order.delivery_day,tbl_order.deliverby,tbl_order.sub_id,ship_fname,ship_lname,ship_house_no,ship_street,ship_complex,ship_landmark,ship_pincode,ship_area,ship_state,ship_city_id,ship_mobile,tbl_order.is_send_to_vendor,tbl_order.vendor_sync_comments from tbl_order inner join tbl_order_itmes on tbl_order.id=tbl_order_itmes.order_id left join tbl_order_status on tbl_order_status.id=tbl_order.order_status where 1=1 $userlocationWhere $where group by tbl_order.id order by tbl_order.id desc limit $start,$pagesize"; $sql = $objmithaas->Query($qry); $sql2 = $objmithaas->query("select tbl_order.id from tbl_order inner join tbl_order_itmes on tbl_order.id=tbl_order_itmes.order_id where 1=1 $userlocationWhere $where group by tbl_order_itmes.order_id"); $reccnt = $objmithaas->numRows($sql2); ?>
Admin: View Orders Export Order
No Record
Records Found.
fetchNextObject($sql)) { $i++; $cuArr = $objmithaas->query("select count(order_date) as usrorders from tbl_order where user_id='$line->user_id' and id<'$line->id' order by id desc"); $urs = $objmithaas->fetchNextObject($cuArr); if ($urs->usrorders > 0) { $usercount = "Existing"; $usrorders=$urs->usrorders+1; } else { $usercount = "New"; $usrorders=1; } $prosub=''; if($line->sub_id){ $subArr=explode(",",$line->sub_id); if(count($subArr)>0){ foreach($subArr as $value){ $sqlsubs=$objmithaas->query("SELECT b.product_id,b.subscription_type FROM user_subscription as a inner join user_subscription_order_details as b on a.sub_id=b.subs_id WHERE a.userid='" . $line->user_id . "' and a.sub_id=$value"); $Subresult = $objmithaas->fetchNextObject($sqlsubs); $prosub.=$Subresult->subscription_type.','; } $prosub=trim($prosub,','); } } if ($line->delivery_day != '') { $bgcolor = "#66CCFF"; } else { if ($i % 2 == 0) { $bgcolor = "#f3f4f6"; } else { $bgcolor = ""; } } ?>
Sl. Order Date / Order Time Order ID User Id / Email Total Amount Order via Customer type (no. of Orders) Order Status Payment Status Order Type Customer Details Details Print Stores Comments
. order_date)); ?> / order_date); ?> id); ?> Subscription:'.$prosub; }?> user_id) . "
" . stripslashes($line->ship_email) . " "; ?> 		total_amount, 2); ?> order_via); ?> ($usrorders)"; ?> order_status; ?> payment_status == 1) { ?> usps_expected_delivery == '' && $line->order_type !== 'Suburb' && $line->order_type !== 'Wholesale') { echo "Local"; } elseif ($line->order_type == 'UPS') { echo "UPS"; ?>
Edit Detailorder_type; } ?> 		ship_fname . " " . $line->ship_lname); ?>
ship_mobile; ?>
Add: ship_full_address==''){ echo $line->ship_house_no . ", " . $line->ship_street . ", " . $line->ship_complex . ", " . $line->ship_area . " " . $line->ship_city_id . " " . $line->ship_state . ", " . $line->ship_pincode; } else { echo $line->ship_full_address. ", ".$line->ship_complex .", " . $line->ship_pincode; }?>		 View Detail Query("select i.courier, i.ups_tracking_no as tracking_no,storeid from tbl_order_itmes i where i.order_id ='".$line->id."' and i.courier !='' "); $x = 0; $tracking_nos = array(); $driverarr=array(); $partnerarr=array(); while ($orderItems = $objmithaas->fetchNextObject($itemSql)) { if($orderItems->storeid==184){ array_push($driverarr,$orderItems->courier); array_push($partnerarr,$orderItems->tracking_no); } if($orderItems->tracking_no !='' && strtolower($orderItems->courier)=='ups'){ $tracking_nos[$orderItems->tracking_no] =$orderItems->courier.' Tracking :'.$orderItems->tracking_no.'
'; } else if($orderItems->tracking_no !='' && strtolower($orderItems->courier)=='dhl'){ $tracking_nos[$orderItems->tracking_no] =$orderItems->courier.' Tracking :'.$orderItems->tracking_no.'
'; } else if($orderItems->tracking_no !='' && strtolower($orderItems->courier)=='fedex'){ $tracking_nos[$orderItems->tracking_no] =$orderItems->courier.' Tracking :'.$orderItems->tracking_no.'
'; } $i++; } if(count($tracking_nos)>0){ echo "
"; foreach ($tracking_nos as $tracking_no){ echo "
".$tracking_no; } } ?> 		query("select ot.storeid,storename from tbl_order_itmes ot inner join stores s on s.storeid=ot.storeid where order_id='$line->id' group by s.storeid"); while ($storeres = $objmithaas->fetchNextObject($sqlstore)) { echo ucwords($storeres->storename)."
"; array_push($storearr,$storeres->storeid); array_push($storenamearr,$storeres->storename); } $storecount=$objmithaas->numRows($sqlstore); $storearr=array_values(array_unique($storearr)); $storenamearr=array_values(array_unique($storenamearr)); ?>