<?php if (!defined('BASEPATH')) exit('No direct script access allowed');

use Google\Cloud\Firestore\FirestoreClient;

class Trips_model extends CI_Model
{
	public function add_trips($data)
	{
		unset($data['bookingemail']);
		$insertdata = $data;
		$insertdata['t_trackingcode'] = uniqid();
		$this->db->insert('trips', $insertdata);
		//echo $this->db->last_query();
		return $this->db->insert_id();
	}
	public function getall_customer()
	{
		return $this->db->select('*')->from('customers')->order_by('c_name', 'asc')->get()->result_array();
	}
	public function getall_vechicle()
	{
		return $this->db->select('*')->from('vehicles')->get()->result_array();
	}
	public function getall_mybookings($c_id)
	{
		return $this->db->select('*')->from('trips')->where('t_customer_id', $c_id)->order_by('t_id', 'asc')->get()->result_array();
	}
	public function getall_driverlist()
	{
		return $this->db->select('*')->from('drivers')->get()->result_array();
	}
	public function getall_trips_expense($t_id)
	{
		return $this->db->select('*')->from('trips_expense')->where('e_trip_id', $t_id)->get()->result_array();
	}
	public function get_paymentdetails($t_id)
	{
		return $this->db->select('*')->from('trip_payments')->where('tp_trip_id', $t_id)->get()->result_array();
	}

	public function getall_trips($trackingcode = false)
	{
		$x = $this->config->item('firebase_app_key');
		$db = new FirestoreClient([
			'projectId' => 'staff-checkin-b4972',
			'keyFile' => json_decode(file_get_contents($x), true)
		]);

		$bookingsRef = $db->collection('Bookings');
		$documents = $bookingsRef->documents();
		$output = array();
		foreach ($documents as $document) {
			if ($document->exists()) {
				//echo json_encode($document->data(), JSON_PRETTY_PRINT);
				$output[$document->id()] = $document->data();
			}
		}
		$da['trips'] = $output;

		return $da;
	}

	public function getscheduled_trips($trackingcode = false)
	{
		$x = $this->config->item('firebase_app_key');
		$db = new FirestoreClient([
			'projectId' => 'staff-checkin-b4972',
			'keyFile' => json_decode(file_get_contents($x), true)
		]);

		$bookingsRef = $db->collection('ScheduledRides');
		$documents = $bookingsRef->documents();
		$output = array();
		foreach ($documents as $document) {
			if ($document->exists()) {
				//echo json_encode($document->data(), JSON_PRETTY_PRINT);
				$output[$document->id()] = $document->data();
			}
		}
		$da['trips'] = $output;

		return $da;
	}

	public function getaddress($lat, $lng)
	{
		$google_api_key = $this->config->item('google_api_key');
		$url = 'https://maps.googleapis.com/maps/api/geocode/json?key=' . $google_api_key . '&latlng=' . trim($lat) . ',' . trim($lng) . '&sensor=false';
		$json = @file_get_contents($url);
		$data = json_decode($json);
		if (!empty($data)) {
			$status = $data->status;
			if ($status == "OK") {
				return $data->results[1]->formatted_address;
			} else {
				return false;
			}
		} else {
			return '';
		}
	}
	public function get_tripdetails($t_id)
	{
		return $this->db->select('*')->from('trips')->where('t_id', $t_id)->get()->result_array();
	}
	public function update_trips($data)
	{
		$this->db->where('t_id', $this->input->post('t_id'));
		$this->db->update('trips', $data);
		return $this->input->post('t_id');
	}
	public function trip_reports($from, $to, $v_id)
	{
		$newtripdata = array();
		if ($v_id == 'all') {
			$where = array('t_start_date>=' => $from, 't_start_date<=' => $to);
		} else {
			$where = array('t_start_date>=' => $from, 't_start_date<=' => $to, 't_vechicle' => $v_id);
		}

		$tripdata = $this->db->select('*')->from('trips')->where($where)->order_by('t_id', 'desc')->get()->result_array();
		if (!empty($tripdata)) {
			foreach ($tripdata as $key => $tripdataval) {
				$newtripdata[$key] = $tripdataval;
				$newtripdata[$key]['t_customer_details'] =  $this->db->select('*')->from('customers')->where('c_id', $tripdataval['t_customer_id'])->get()->row();
				$newtripdata[$key]['t_vechicle_details'] =  $this->db->select('*')->from('vehicles')->where('v_id', $tripdataval['t_vechicle'])->get()->row();
				$newtripdata[$key]['t_driver_details'] =   $this->db->select('*')->from('drivers')->where('d_id', $tripdataval['t_driver'])->get()->row();
			}
			return $newtripdata;
		} else {
			return array();
		}
	}
}
