%PDF- <> %âãÏÓ endobj 2 0 obj <> endobj 3 0 obj <>/ExtGState<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI] >>/Annots[ 28 0 R 29 0 R] /MediaBox[ 0 0 595.5 842.25] /Contents 4 0 R/Group<>/Tabs/S>> endobj ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµùÕ5sLOšuY>endobj 2 0 obj<>endobj 2 0 obj<>endobj 2 0 obj<>endobj 2 0 obj<> endobj 2 0 obj<>endobj 2 0 obj<>es 3 0 R>> endobj 2 0 obj<> ox[ 0.000000 0.000000 609.600000 935.600000]/Fi endobj 3 0 obj<> endobj 7 1 obj<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]>>/Subtype/Form>> stream
<?php if (!defined('BASEPATH')) { exit('No direct script access allowed'); } class Bookings extends ADMIN_Controller { private $num_rows = 10; public function __construct() { parent::__construct(); $this->load->model(array('Bookings_model', 'Languages_model', 'Categories_model')); } public function index($page = 0) { $this->login_check(); $data = array(); $head = array(); $head['title'] = 'Administration - View products'; $head['description'] = '!'; $head['keywords'] = ''; if (isset($_GET['delete'])) { $this->Bookings_model->deleteProduct($_GET['delete']); $this->session->set_flashdata('result_delete', 'feedback is deleted!'); $this->saveHistory('Delete feedback id - ' . $_GET['delete']); redirect('admin/feedback'); } if (isset($_POST['submit'])) { unset($_POST['submit']); $_POST['report_name'] = $this->uploadReport(); $members_id = explode(',',$_POST['member_id']); $data = array( 'member_id' => $members_id[0], 'order_id' => $members_id[1], 'test_package_name' => $_POST['test_package_name'], 'user_id' => $_POST['user_id'], 'booking_date' => $_POST['booking_date'], 'booking_time' => $_POST['booking_time'], 'report_name' => $_POST['report_name'], 'status' => $_POST['status'] ); $this->Bookings_model->uploadreport($data); $this->session->set_flashdata('report_upload', 'Report Uploaded!'); $this->saveHistory('Report Uploaded - ' . $_POST['submit']); redirect('admin/bookings'); } unset($_SESSION['filter']); $search_title = null; if ($this->input->get('search_title') !== NULL) { $search_title = $this->input->get('search_title'); $_SESSION['filter']['search_title'] = $search_title; $this->saveHistory('Search for product title - ' . $search_title); } $orderby = null; if ($this->input->get('order_by') !== NULL) { $orderby = $this->input->get('order_by'); $_SESSION['filter']['order_by '] = $orderby; } $category = null; if ($this->input->get('category') !== NULL) { $category = $this->input->get('category'); $_SESSION['filter']['category '] = $category; $this->saveHistory('Search for product code - ' . $category); } $to_date = null; if ($this->input->get('to_date') !== NULL) { $to_date = $this->input->get('to_date'); $_SESSION['filter']['to_date '] = $to_date; $this->saveHistory('Search for user - ' . $to_date); } $from_date = null; if ($this->input->get('from_date') !== NULL) { $from_date = $this->input->get('from_date'); $_SESSION['filter']['from_date '] = $from_date; $this->saveHistory('Search for user - ' . $from_date); } $vendor = null; if ($this->input->get('show_vendor') !== NULL) { $vendor = $this->input->get('show_vendor'); } if (isset($_POST['export'])) { header("Content-Disposition: attachment; filename=ShardaDiagnostics-bookings-".date('Y-m-d').".csv"); $all_bookings = $this->Bookings_model->getproducts('', '', $search_title, $orderby, $category,'',$to_date,$from_date); //print_r($all_bookings);die; $file = fopen('php://output', 'w'); $order_status = unserialize(ORDER_STATUS); $header = array("Order Id","User Name","Contact Number","Booking Date","Order Status","Total Payment","Payment Method"); fputcsv($file, $header); foreach($all_bookings as $bookings){ $package_id = unserialize($bookings->packsge_id); foreach($package_id as $package) { $total=0; foreach($package as $packagedetails) { $total=$total+$packagedetails['price'];}} $data=array($bookings->order_id, $bookings->first_name .' '.$bookings->last_name,$bookings->phone,$bookings->booking_date,$order_status[$bookings->status],$total,$bookings->payment_type); fputcsv($file,$data); } fclose($file); exit; } $data['products_lang'] = $products_lang = $this->session->userdata('admin_lang_products'); $rowscount = $this->Bookings_model->productsCount($search_title, $category); $page = $_GET['per_page']; $data['products'] = $this->Bookings_model->getproducts($this->num_rows, $page, $search_title, $orderby, $category, '',$to_date,$from_date); $data['links_pagination'] = pagination('admin/bookings', $rowscount, $this->num_rows, 3); $data['num_shop_art'] = $this->Bookings_model->numShopproducts(); $data['languages'] = $this->Languages_model->getLanguages(); $data['shop_categories'] = $this->Categories_model->getShopCategories(null, null, 2); /*********************** own code *********/ /*$products = $this->Bookings_model->getProducts(); foreach($products as $row) { $orderId = $row->order_id; $package_id = unserialize($row->packsge_id); foreach($package_id as $package) { foreach($package as $packagedetails) { $data['flagreport'] = $this->Bookings_model->reportactive($packagedetails['member_id'],$orderId,$packagedetails['title']); } } }*/ /********************* END code***********/ $data['page']=$page; $this->saveHistory('Go to bookings'); $this->load->view('_parts/header', $head); $this->load->view('bookings', $data); $this->load->view('_parts/footer'); } private function uploadReport() { $config['upload_path'] = './attachments/user_report/'; $config['allowed_types'] = 'png|jpg|jpeg|txt|xls|xlsx|doc|docx|pdf'; $this->load->library('upload', $config); $this->upload->initialize($config); if (!$this->upload->do_upload('report')) { echo $this->upload->display_errors(); log_message('error', 'Image Upload Error: ' . $this->upload->display_errors()); } $report = $this->upload->data(); return $report['file_name']; } public function getProductInfo($id) { $this->login_check(); return $this->Bookings_model->getOneProduct($id); } /* * called from ajax */ /*public function ajax_get_test($kname) { echo $kname; $this->login_check(); $data['products'] = $this->Bookings_model->getproducts($this->num_rows, $page, $search_title, $orderby, $category, $vendor); return $this->load->view('ajax_get_test', $kname,$data); public function ajax_get_test() }*/ /* * Function : ajax_get_test * */ public function ajax_get_test($kname) { $new_member = $_POST['new_member']; $STID = explode(',',$new_member); $member_id = $STID[0]; $orderID = $STID[1]; if($member_id) { $products = $this->Bookings_model->getProducts(); echo "<option value=''>------- Select --------</option>"; //print_r($products); foreach ($products as $row) { if($row->order_id==$orderID){ $package_id = unserialize($row->packsge_id); foreach($package_id as $package) { //$package=array_unique(array_column($package, 'member_id')); foreach($package as $packagedetails) { if($member_id==$packagedetails['member_id']){ echo "<option value='".$packagedetails['title']."'>".$packagedetails['title']."</option>"; } } } } } } } public function productStatusChange() { $this->login_check(); $result = $this->Bookings_model->productStatusChange($_POST); if ($result == true) { $this->session->set_flashdata('report_upload', 'Order Status Has Changed!'); redirect('admin/bookings'); } else { $this->session->set_flashdata('report_upload', 'Some Problem Occurred!'); redirect('admin/bookings'); } } /* * function : assignrider * */ public function assignrider() { $head = array(); $data = array(); $head['title'] = 'Assign Rider'; $order_id =$_GET['order_id']; if($order_id>0) { $data['orderDetails'] = $this->Bookings_model->getSingleDetail('orders',array('order_id'=>$order_id)); } if (isset($_POST['submit'])) { unset($_POST['submit']); $this->Bookings_model->setRecords('orders',$_POST); $this->session->set_flashdata('result_add', 'Rider\s Assigned successfully!'); $this->saveHistory('Rider\s Assigned successfully!'); redirect('admin/bookings'); } $data['riderDetails'] = $this->Bookings_model->getAllDetails('tbl_rider_master',array('status'=>'1', 'is_deleted'=>'0')); $this->saveHistory('Go to Assign rider '); $this->load->view('_parts/header', $head); $this->load->view('bookings/assignrider', $data); $this->load->view('_parts/footer'); } public function getassignrider() { $order_id =$_POST['id']; if($order_id>0){ $orderDetails = $this->Bookings_model->getSingleDetail('orders',array('id'=>$order_id)); } } }