<?php function get_total_customers($id){ $CI = & get_instance(); $CI->db->select("COUNT(*) AS tot_customers"); $CI->db->where('status','1'); $rs = $CI->db->get('users'); // echo $CI->db->last_query(); // die(); return $rs->row()->tot_customers; } function get_total_bookings($id){ $CI = & get_instance(); $rs = $CI->db->select('COUNT(*) AS tot_bookings')->get('booking'); // echo $CI->db->last_query(); // die(); return $rs->row()->tot_bookings; } function get_onprocess($id){ $CI = & get_instance(); $rs = $CI->db->select('COUNT(*) AS processing')->where('status',4)->get('booking'); //$rs = $CI->db->select('type')->where('id',$id)->get('verification')->row(); // echo $CI->db->last_query(); // die(); return $rs->row()->processing; } function get_completed($id){ $CI = & get_instance(); $rs = $CI->db->select('COUNT(*) AS completed')->where('status',2)->get('booking_approve'); //$rs = $CI->db->select('type')->where('id',$id)->get('verification')->row(); // echo $CI->db->last_query(); // die(); return $rs->row()->completed; } function get_total_drivers($id){ $CI = & get_instance(); $rs = $CI->db->select('COUNT(*) AS tot_drivers')->where('status',1)->get('booking_approve'); //$rs = $CI->db->select('type')->where('id',$id)->get('verification')->row(); // echo $CI->db->last_query(); // die(); return $rs->row()->tot_drivers; } function get_customername($id){ $CI = & get_instance(); $rs = $CI->db->select("TRIM(concat(users.first_name,' ',IFNULL(users.last_name,''))) as first_name")->where('id',$id)->get('users')->row(); return $rs->first_name; } function get_doc_name($id){ $CI = & get_instance(); // $rs = $CI->db->where('help_id',$id)->get('help_review')->row(); //$rs = $CI->db->select('('*') AS likes')->where('id',$id)->where('type','1')->get('help_review');\ $rs = $CI->db->select('type')->where('id',$id)->get('verification')->row(); if($rs->type == '1'){ return "Government Id"; }elseif($rs->type == '2'){ return "Pan Card"; }elseif($rs->type == '3'){ return "Passport"; } //return $rs->type; } function get_status($status){ $array = array('1'=>'Booking', '2'=>'Rejected', '3'=>'User Cancelled', '4'=>'Owner Cancelled', '4'=>'Completed', '0'=>'Pending'); return $array[$status]; } function get_color($status){ $array = array('1'=>'success', '2'=>'info', '3'=>'danger', '4'=>'info', //'5'=>'success', '0'=>'danger'); return $array[$status]; } // function get_statusdoc($status){ // $array = array('1'=>'Approved', // '2'=>'Pending', // '3'=>'Rejected', // '4'=>'Not Uploaded' // ); // return $array[$status]; // } function get_statusdoc($status){ $array = array('1'=>'Approved', '2'=>'Pending', '3'=>'Rejected', '4'=>'Pending', '0'=>'Not Uploaded' ); return $array[$status]; } function get_drivername($id){ $CI = & get_instance(); $rs = $CI->db->select('first_name')->where('id',$id)->get('users')->row(); return $rs->first_name; } function get_driveremail($id){ $CI = & get_instance(); $rs = $CI->db->select('email')->where('id',$id)->get('users')->row(); return $rs->email; } function get_driverdob($id){ $CI = & get_instance(); $rs = $CI->db->select('date_of_birth')->where('id',$id)->get('users')->row(); return $rs->date_of_birth; } function get_drivergender($id){ $CI = & get_instance(); $rs = $CI->db->select('gender')->where('id',$id)->get('users')->row(); return $rs->gender; } function get_tripsource($id){ $CI = & get_instance(); $rs = $CI->db->select('source')->where('id',$id)->get('ride')->row(); // echo $CI->db->last_query(); // die(); return $rs->source; } function get_tripdestination($id){ $CI = & get_instance(); $rs = $CI->db->select('destination')->where('id',$id)->get('ride')->row(); return $rs->destination; } function get_tripdriver($id){ $CI = & get_instance(); $rs = $CI->db->select('driver_id')->where('ride_id',$id)->get('booking_approve')->row(); $rs1 = $CI->db->select('first_name')->where('id',$rs->driver_id)->get('users')->row(); return $rs1->first_name; } function get_amnt($id){ $CI = & get_instance(); $rs = $CI->db->select('sum(amount) as total ')->where('ride_id',$id)->get('booking_approve')->row(); //$rs1 = $CI->db->select('first_name')->where('id',$rs->driver_id)->get('users')->row(); //echo $CI->db->last_query(); // die(); // $rs); return $rs->total; } function get_admincharge($id){ $CI = & get_instance(); $rs = $CI->db->select('sum(amount) as total ')->where('ride_id',$id)->get('booking_approve')->row(); //$rs1 = $CI->db->select('first_name')->where('id',$rs->driver_id)->get('users')->row(); //echo $CI->db->last_query(); // die(); // $rs); $price = $rs->total; $rs1 = $CI->db->select('admin_charge')->get('settings')->row(); $adminpercent = $rs1->admin_charge; $fincharge = $price*$adminpercent/100; return $fincharge; } function get_drivercharge($id){ $CI = & get_instance(); $rs = $CI->db->select('sum(amount) as total ')->where('ride_id',$id)->get('booking_approve')->row(); $price = $rs->total; $rs1 = $CI->db->select('admin_charge')->get('settings')->row(); $adminpercent = $rs1->admin_charge; $fincharge = $price*$adminpercent/100; $drivercharge = $price-$fincharge; return $drivercharge; } function get_bookid($id){ $CI = & get_instance(); $rs = $CI->db->select('booking_id')->where('ride_id',$id)->get('booking')->row(); return $rs->booking_id; } function get_deppoint($id){ $CI = & get_instance(); $rs = $CI->db->select('departure_point')->where('ride_id',$id)->get('booking')->row(); return $rs->departure_point; } function get_droppoint($id){ $CI = & get_instance(); $rs = $CI->db->select('drop_point')->where('ride_id',$id)->get('booking')->row(); return $rs->drop_point; } function get_custname($id){ $CI = & get_instance(); $rs = $CI->db->select('user_id')->where('ride_id',$id)->get('booking')->row(); $rs1 = $CI->db->select('first_name')->where('id',$rs->user_id)->get('users')->row(); return $rs1->first_name; } function get_bookdate($id){ $CI = & get_instance(); $rs = $CI->db->select('booking_date')->where('ride_id',$id)->get('booking')->row(); return $rs->booking_date; } function settings(){ $CI = & get_instance(); $rs = $CI->db->get('settings')->row(); return $rs; } ?>