query("select distinct(zip) as zip from tbl_store_zip where state in ('$user_location') and 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.')'; } $_REQUEST['search_storename'] = '294'; ?>

Search Order ID: Email: Customer Type: All selected>New selected>Existing query("select storeid,storename from stores where storename = 'Quicklly Gift Card' "); while ($storenumrec = $obj->fetchNextObject($storenum)) { ?> storeid == $_REQUEST['search_storename']) { ?>selected>storename); ?> Ordered Device: All selected>Mobile selected>Tablet selected>Desktop User ID: From Date: To Date: View All ='" . trim($_REQUEST['search_from_date']) . "' and tbl_order.order_date<='" . trim($_REQUEST['search_to_date']) . "' "; } $start = 0; if (isset($_GET['start'])) $start = $_GET['start']; $pagesize = 15; if (isset($_GET['pagesize'])) $pagesize = $_GET['pagesize']; $sql = $obj->Query("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.tax_value,tbl_order.delivery_type,tbl_order.order_type,tbl_order.total_amount,tbl_order.ship_type,tbl_order.order_date,tbl_order.usps_expected_delivery,tbl_order.tracking_no,tbl_order.payment_method,tbl_order.order_status,tbl_order.payment_status,tbl_order.delivery_note,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.deliverby,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 where 1=1 $userlocationWhere $where group by tbl_order.id order by tbl_order.id desc limit $start,$pagesize"); $sql2 = $obj->query("select tbl_order_itmes.storeid,tbl_order.id,tbl_order.ship_email,tbl_order.user_id,tbl_order.order_via,tbl_order.tax_value,tbl_order.delivery_type,tbl_order.delivery_day,tbl_order.total_amount,tbl_order.ship_type,tbl_order.order_date,tbl_order.order_status,tbl_order.payment_status,tbl_order.delivery_note 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.id", $debug = -1); // exit; $reccnt = $obj->numRows($sql2); $gc_join = " JOIN tbl_giftcard_orders ON tbl_giftcard_orders.order_id = tbl_order.id JOIN " ?> Today :  Total Order : numRows($obj->query("select tbl_order.id,tbl_order_itmes.storeid,tbl_order.order_date from $tbl_order inner join tbl_order_itmes on tbl_order.id=tbl_order_itmes.order_id where tbl_order.order_date like '%" . date('Y-m-d') . "%' $where group by tbl_order.id", $debug = -1)); ?>   Orders :  Total Order : numRows($obj->query("select tbl_order.id,tbl_order_itmes.storeid,tbl_order.order_date from $tbl_order inner join tbl_order_itmes on tbl_order.id=tbl_order_itmes.order_id where 1=1 $where group by tbl_order.id", $debug = -1)); ?>   Admin: View Gift Card Report No Record Query("select tbl_order_itmes.storeid,tbl_order.id,tbl_order.ship_email,tbl_order.user_id,tbl_order.order_via,tbl_order.tax_value,tbl_order.delivery_type,tbl_order.delivery_day,tbl_order.total_amount,tbl_order.ship_type,tbl_order.order_date,tbl_order.payment_method,tbl_order.order_status,tbl_order.payment_status,tbl_order.delivery_note from $tbl_order inner join tbl_order_itmes on tbl_order.id=tbl_order_itmes.order_id where 1=1 $where group by tbl_order.id order by tbl_order.id desc"); $x = 0; while ($line3 = $obj->fetchNextObject($sql3)) { $cuArr = $obj->query("select count(*) as ucs from $tbl_order where user_id='$line3->user_id' and id<='$line3->id'"); $urs = $obj->fetchNextObject($cuArr); if ($urs->ucs > 1) { $usercount = "Existing"; } else { $usercount = "New"; } if ($_REQUEST['search_customer_type'] == $usercount) { $x++; } } $reccnt = $x; } if ($reccnt == 0) { ?> No Record Records Found. fetchNextObject($sql)) { $sql_gc = $obj->query("select * from $tbl_giftcard_orders gc JOIN $tbl_giftcard_order_emails gce ON gc.id = gce.giftcard_order_id where gc.order_id=".$line->id); $record_gc = $obj->numRows($sql_gc); $prosub=''; /*if ($_REQUEST['search_customer_type'] != '') { $cuArr = $obj->query("select count(*) as ucs from $tbl_order where user_id='$line->user_id' and id<='$line->id'"); $urs = $obj->fetchNextObject($cuArr); if ($urs->ucs > 1) { $usercount = "Existing"; } else { $usercount = "New"; } }*/ if($record_gc > 0){ while($result_gc = $obj->fetchNextObject($sql_gc)) { if ($_REQUEST['search_customer_type'] == $usercount) { $i++; if ($line->delivery_day != '') { $bgcolor = "#66CCFF"; } else { if ($i % 2 == 0) { $bgcolor = "#f3f4f6"; } else { $bgcolor = ""; } } ?> S No. Order ID User Id / Email Card Name Sender Receiver Receiver Email Delivery Date Store Details Email Sent Wallet Added Total Amount Order Details Payment Status Customer Details id){ $new_order_id = $line->id; echo $i + $start; } else{ echo " "; } ?> id); ?> user_id) . " " . stripslashes($line->ship_email) . " "; ?> card_type))." ".ucfirst(stripslashes($result_gc->card_cat)); ?> sender); ?> receiver); ?> receiver_email); ?> delivery_date)); ?> storename)." ".stripslashes($result_gc->store_location); ?> email_flag == 1 ? 'Yes' : 'No'); ?> wallet_flag == 1 ? 'Yes' : 'No'); ?> total_amount, 2); ?> order_date)); ?> order_via); ?> order_status); ?> payment_status == 1) { ?> 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; }?>