Search
Order ID: Email: View All
User ID: Store:
From Date: To Date:
Subscription Status:
Admin: View User Subscription Report
='".$_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."'"; } $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.sub_id,a.order_id,a.userid,a.subscription_date,a.next_order_date,a.subscription_status,a.subscription_cancel_date,a.reason_for_cancel,b.store_id,b.subscription_type,b.product_name,b.section,c.ship_fname,c.ship_lname,c.ship_email,c.ship_mobile FROM `user_subscription` as a left join user_subscription_order_details as b on b.subs_id=a.sub_id left join tbl_order as c on a.order_id=c.id where 1=1 $where order by $order_by $order_by2 limit $start, $pagesize"); $sql2=$obj->query("SELECT a.sub_id,a.order_id,a.subscription_date,a.subscription_status,a.subscription_cancel_date,a.reason_for_cancel,b.store_id,b.subscription_type,b.product_name,b.section,c.ship_fname,c.ship_lname,c.ship_email,c.ship_mobile FROM `user_subscription` as a left join user_subscription_order_details as b on b.subs_id=a.sub_id left join tbl_order as c on a.order_id=c.id 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; ?>
S No. Order Date Order ID Customer Details Subsciption Details Store Name Reason For Cancel Status Action
. subscription_date)); ?> order_id); ?>

Name:ship_fname );?> ship_lname );?> (userid);?>)

Email:ship_email;?>

Mobile:ship_mobile;?>

Subsciption Type:subscription_type);?>

Product Name:product_name);?> subscription_status==1){?>

Next Order Date:next_order_date);?>

store_id);?> reason_for_cancel);?> subscription_status==1){ echo '  Active'; } else { echo '  Canceled'; } ?> subscription_status==1){?> Cancel Subscription