|
='".$_REQUEST['search_from_date']."' and order_date<='".$_REQUEST['search_to_date']."' ";
}
if($_REQUEST['payment_status']!=''){
$name=$_REQUEST['payment_status'];
$where.=" and payment_status='".$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 * from $tbl_order where 1=1 $where order by $order_by $order_by2 limit $start, $pagesize");
$sql2=$obj->query("select * from $tbl_order where 1=1 $where order by $order_by $order_by2",$debug=-1);
$reccnt=$obj->numRows($sql2);
if($reccnt==0)
{
?>
| S No. |
Order Date |
Order ID |
User Id / Email |
Total Amount |
Order via |
Payment Method |
Order Status | Payment Status |
fetchNextObject($sql))
{
$i++;
if($i%2==0)
{
$bgcolor = "#f3f4f6";
}
else
{
$bgcolor = "";
}
$prosub='';
if($line->sub_id){
$subArr=explode(",",$line->sub_id);
if(count($subArr)>0){
foreach($subArr as $value){
$sqlsubs=$obj->query("SELECT b.product_id,b.subscription_type FROM user_subscription as a left 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 = $obj->fetchNextObject($sqlsubs);
$prosub.=$Subresult->subscription_type.',';
}
$prosub=trim($prosub,',');
}
}
?>
| . |
order_date));
?>
|
id);
if($prosub){
echo '
Subscription:'.$prosub;
}
?>
|
user_id)."
".stripslashes($line->ship_email)." ";
?>
|
total_amount,2);
?>
|
order_via);?>
|
payment_method);?>
|
order_status);
?>
|
payment_status==1){ ?>
|
|
|
| |
|
|
| |
|
|
|
|
Admin: View Order Report