<?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;
}







	
?>