|
='".$_REQUEST['search_from_date']."' and a.subscription_date<='".$_REQUEST['search_to_date']."' ";
}
if($_REQUEST['subscription_status'] || $_REQUEST['subscription_status']=='0'){
$name=$_REQUEST['subscription_status'];
$where.=" and a.subscription_status='".$name."'";
}
$where.=" and f.order_status!=9 ";
$start=0;
if(isset($_GET['start'])) $start=$_GET['start'];
$pagesize=50;
if(isset($_GET['pagesize'])) $pagesize=$_GET['pagesize'];
$order_by='a.sub_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 a.user_id,a.subscription_date,a.order_id,sub_id,a.subscription_status,a.reason_for_cancel,a.cancel_status,a.next_order_date,b.*,c.* FROM `tbl_quicklly_pass_subscription` as a left join tbl_quicklly_pass_plan as b on b.id=a.plan_id left join tbl_user as c on a.user_id=c.id left join tbl_quicklly_pass_subscription_order as f on f.id=a.order_id where 1=1 $where order by $order_by $order_by2 limit $start, $pagesize");
$sql2=$obj->query("SELECT a.user_id,a.subscription_date,a.order_id,sub_id,a.subscription_status,a.reason_for_cancel,a.cancel_status,a.next_order_date,b.*,c.* FROM `tbl_quicklly_pass_subscription` as a left join tbl_quicklly_pass_plan as b on b.id=a.plan_id left join tbl_user as c on a.user_id=c.id left join tbl_quicklly_pass_subscription_order as f on f.id=a.order_id 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 |
Customer Details |
Subsciption Details |
Reason For Cancel |
Status |
Action |
fetchNextObject($sql))
{
$i++;
$m=0;
?>
| . |
subscription_date));
?>
|
order_id);
?>
|
Name:fname );?> ship_lname );?> (lname);?>)
Email:email;?>
Mobile:mobile;?>
|
Subsciption Type:plan_name);?>
subscription_status==1){?>
Next Order Date:next_order_date);?>
|
reason_for_cancel);?>
|
subscription_status==1 && $line->cancel_status==0){
echo ' Active';
} else {
echo ' Canceled';
}
?>
|
subscription_status==1 && $line->cancel_status==0){?>
Cancel Subscription
Update
|
|
|
| |
|
|
| |
|
|
|
|
Admin: View User Subscription Report