Search Order ID: Email: Payment Method: Select Method selected>Cash On Delivery selected>Online Payment View All User ID: Order Status: -Select- query("select * from $tbl_order_status where status=1 order by id"); while($resultOrder=$obj->fetchNextObject($orderArr)){?> id){?>selected >order_status); ?> Order Via: -Select- selected>Website selected>App Payment Status -Select- selected> Successful selected> Unsuccessful From Date: To Date: Store: -Select- query("SELECT storeid,storename FROM `stores` where status=1"); while($resultStore=$obj->fetchNextObject($storeArr)){?> storeid){?>selected >storename); ?> Rating Status: -Select- selected >Pending selected >Skipped selected >Rated Overall Rating: selected>-Select- selected >0 selected >1 selected >2 selected >3 selected >4 selected >5 State: -Select- query("SELECT DISTINCT stateCode,state FROM `tbl_us_zipcodes` WHERE stateCode IS not null and state is not null"); while($resultState=$obj->fetchNextObject($stateArr)){?> stateCode){?>selected >state);?>(stateCode);?>) Admin: View Overall Order Rating Report ='".$_REQUEST['search_from_date']."'"; } else { $where.=" and order_date>='".$_REQUEST['search_from_date']."' and order_date<='".$_REQUEST['search_to_date']."' "; } } if($_REQUEST['payment_status']!=''){ $name=$_REQUEST['payment_status']; $where.=" and payment_status='".$name."'"; } if($_REQUEST['storename']){ $name=$_REQUEST['storename'] ; $where.=" and storeid='".$name."'"; } if($_REQUEST['raitingstatus']){ $name=$_REQUEST['raitingstatus'] ; $where.=" and rating_status like '%$name%' "; } else { $name="Rated"; $where.=" and rating_status like '%$name%' "; } if($_REQUEST['overallrating'] || $_REQUEST['overallrating']=='0'){ $name=$_REQUEST['overallrating']; $where.=" and overall_rating='".$name."'"; } if($_REQUEST['state']!=''){ $name=$_REQUEST['state'] ; $where.=" and d.stateCode like '%$name%' "; } $start=0; if(isset($_GET['start'])) $start=$_GET['start']; $pagesize=50; 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 c.*,d.stateCode,d.state from $tbl_order as c left join tbl_us_zipcodes as d on d.zipCode=c.ship_pincode where 1=1 $where order by $order_by $order_by2 limit $start, $pagesize"); $sql2=$obj->query("select c.* ,d.stateCode,d.state from $tbl_order as c left join tbl_us_zipcodes as d on d.zipCode=c.ship_pincode where 1=1 $where order by $order_by $order_by2",$debug=-1); $reccnt=$obj->numRows($sql2); if($reccnt==0) { ?> No Record Records Found. fetchNextObject($sql)) { $i++; $m=0; if($line->overall_rating <4 ){ if($line->overall_rating!=''){ $m=1; } else { } } if($i%2==0) { if($m==1){ $bgcolor = "#f5d8d8"; } else { $bgcolor = "#f3f4f6"; } } else { if($m==1){ $bgcolor = "#f5d8d8"; } else { $bgcolor = ""; } } ?> S No. Order Date Order ID Store ID User Id / Email State Rating status Overall Rating Overall review Order Status Payment Status . order_date)); ?> id); ?> storeid); ?> user_id)." ".stripslashes($line->ship_email)." "; ?> state); if($line->stateCode){?> (stateCode);?>) rating_status); ?> overall_rating);?> overall_review);?> order_status); ?> payment_status==1){ ?>