Search
Order ID: Email: View All
User ID: Store:
From Date: To Date:
Event Status:
Payment Status: Event:
Admin: View Events Order Report
='".$_REQUEST['search_from_date']."' and Date(o.order_date)<='".$_REQUEST['search_to_date']."' "; } if($_REQUEST['search_payment_status'] || $_REQUEST['search_payment_status']=='0'){ $name=$_REQUEST['search_payment_status'] ; $where.=" and o.payment_status ='".$name."'"; } if($_REQUEST['event_status'] || $_REQUEST['event_status']=='0'){ if($_REQUEST['event_status']=='0'){ $where.=" and e.event_cancel_reason!='' "; } else { $where.=" and e.event_cancel_reason='' "; } } if($_REQUEST['search_pid']!=''){ $name=$_REQUEST['search_pid'] ; $where.=" and p.id='".$name."'"; } $start=0; if(isset($_GET['start'])) $start=$_GET['start']; $pagesize=50; if(isset($_GET['pagesize'])) $pagesize=$_GET['pagesize']; $order_by='o.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 e.id, e.event_product_id, e.order_id, e.user_name,e.user_id,e.event_store_id, e.event_name, e.total_qty, e.total_amount, e.event_time, e.event_from_date, e.event_to_date, e.event_address, e.latitude, e.longitude, e.event_qr_code_image, e.event_cancel_date, e.event_cancel_reason,e.event_remarks,e.event_status,o.payment_status, o.order_date,o.ship_fname,o.ship_lname,o.ship_email,o.ship_mobile, p.photo_wide, m.last_event_cancel_date, m.cancel_duduction_type, m.cancel_duduction_amount,event_visit_status,event_visit_date_time,e.service_fee_amount, i.tax_value,e.convenience_fee_amount FROM tbl_order_event e INNER JOIN tbl_order o ON e.order_id = o.id INNER JOIN tbl_order_itmes i ON i.order_id = e.order_id AND i.product_id = e.event_product_id INNER JOIN tbl_product p ON p.id = e.event_product_id INNER JOIN tbl_event_meta m ON m.id = e.event_id where 1=1 $where order by $order_by $order_by2 limit $start, $pagesize"); $sql2=$obj->query("SELECT e.id, e.event_product_id, e.order_id, e.user_name, e.event_name, e.total_qty, e.total_amount, e.event_time, e.event_from_date, e.event_to_date, e.event_address, e.latitude, e.longitude, e.event_qr_code_image, e.event_cancel_date, e.event_cancel_reason,e.event_remarks,e.event_status,o.payment_status, o.order_date,o.ship_fname,o.ship_lname,o.ship_email,o.ship_mobile, p.photo_wide, m.last_event_cancel_date, m.cancel_duduction_type, m.cancel_duduction_amount,e.service_fee_amount, i.tax_value,e.convenience_fee_amount FROM tbl_order_event e INNER JOIN tbl_order o ON e.order_id = o.id INNER JOIN tbl_order_itmes i ON i.order_id = e.order_id AND i.product_id = e.event_product_id INNER JOIN tbl_product p ON p.id = e.event_product_id INNER JOIN tbl_event_meta m ON m.id = e.event_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++; $currDate = new DateTime(); $fromDate = strtotime($line->event_from_date); $toDate = strtotime($line->event_to_date); $datecanel=''; if($line->event_cancel_date=='0000-00-00 00:00:00'){ $datecanel=''; } else { $datecanel = $line->event_cancel_date; } if($fromDate == $toDate) $fromDate = date('d M Y', $fromDate); else $fromDate = date('d M Y', $fromDate) . ' - ' . date('d M Y', $toDate); $isUpcoming = false; if($line->event_to_date > $currDate->format("Y-m-d")) $isUpcoming = true; $allowCancel = true; if($currDate->format("Y-m-d") > $line->last_event_cancel_date) $allowCancel = false; $isCancelled = false; if($line->event_cancel_reason != null && $line->event_cancel_reason != ''){ $isCancelled = true; $allowCancel = false; } $photoWide = 'https://www.dev.goquicklly.com/upload_images/product/wide/' . $line->photo_wide; $qr = 'https://www.dev.goquicklly.com/upload_images/events/qrcode/' . $line->event_qr_code_image; $cancelCharge = 0; $total = $line->total_amount + $line->tax_value + $line->service_fee_amount+$line->convenience_fee_amount; $cancelCharge = number_format((float)$line->service_fee_amount,2); $refundAmt = number_format((float)$total - (float)$cancelCharge,2); $m=0; ?>
S No. Order Date Order ID Customer Details Events Details Store Name Reason For Cancel Payment Status Ticket Status Visit Status Action
. order_date)); ?> order_id); ?>

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

Email:ship_email;?>

Mobile:ship_mobile;?>

Upcoming Events

Past Events

Product Name:event_name);?>

Event Date Time: I event_time);?>

Last Allowed cancel Date:last_event_cancel_date);?>

Qty:total_qty);?> Tickets(event_remarks);?>)

Total Amount:$

Refundable Amount:$

Cancel Charge:$

 event_store_id);?> event_cancel_reason);?> payment_status==1){ echo '  Success'; } else { echo '  Declined'; } ?>   Active'; } else { echo '  Canceled'; } ?> event_visit_status==1){ ?>  Visited

Event Visit Date event_visit_date_time); echo date('d M Y', $event_visit_date_time);?>

 Not Visited 		payment_status==1 && $line->event_visit_status==0){?> Cancel Subscription