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 go_order.ship_pincode in('.$userLocationZip.')';
}
}
?>
Search
='" . $_REQUEST['search_from_date'] . "' and go_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 go_order_itmes.storeid,go_order_itmes.section,go_order.id,go_order.ship_email,go_order.user_id,go_order.order_via,go_order.order_type,go_order.total_amount,go_order.order_date,go_order.tracking_no,tbl_order_status.order_status,go_order.payment_status,go_order.ship_full_address,go_order.usps_expected_delivery,go_order.delivery_note,go_order.delivery_day,go_order.deliverby,go_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,go_order.is_send_to_vendor,go_order.vendor_sync_comments from go_order inner join go_order_itmes on go_order.id=go_order_itmes.order_id left join tbl_order_status on tbl_order_status.id=go_order.order_status where 1=1 $userlocationWhere $where group by go_order.id order by go_order.id desc limit $start,$pagesize";
$sql = $obj->Query($qry);
$sql2 = $obj->query("select go_order.id from go_order inner join go_order_itmes on go_order.id=go_order_itmes.order_id where 1=1 $userlocationWhere $where group by go_order_itmes.order_id");
$reccnt = $obj->numRows($sql2);
?>
Admin: View Orders