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

class Shipment_express_m extends MY_Model {

    function __construct() {
        parent::__construct();      
    }

    function get2hr_delivery(){
        $this->db->select("*");
        $this->db->from("shipment_express_setting");
        $this->db->where("shipment_method_id",2);

        $data = $this->db->get()->result();

        return $data;
    }

    function getsameday_delivery(){
        $this->db->select("*");
        $this->db->from("shipment_express_setting");
        $this->db->where("shipment_method_id",7);

        $data = $this->db->get()->result();

        return $data;
    }

    function getDestination($length=0,$start=0, $id='', $idwh=''){
        $query = "select a.id,f.name `warehouse` ,e.province,d.district, c.subdistrict, a.destination, a.jarak ";
        $query = $query . " from shipment_express_distance a ";
        $query = $query . " left join indonesia_subdistricts c on c.id_indonesia_subdistricts=a.id_indonesia_subdistricts ";
        $query = $query . " left join indonesia_districts d on d.rajaongkir_id_district=c.indonesia_id_district ";
        $query = $query . " left join indonesia_provinces e on e.rajaongkir_province_id=d.indonesia_id_province ";
        $query = $query . " left join warehouse f on f.id=a.warehouse_id ";
        $query = $query . " where 1=1 ";

        if($id<>0){
            $query = $query . " and a.id = '" . $id . "'";
        }

        if($idwh<>0){
            $query = $query . " and a.warehouse_id = '" . $idwh . "'";
        }

		$row = $this->db->query($query)->num_rows();
		$data['return']['row'] = $row;

		if($length > 0){
			$query = $query . "LIMIT ".$start.",".$length;
        }
		$exec = $this->db->query($query)->result();
        $data['return']['data'] = $exec;
        
		return array('row' => $row, 'data' => $exec);
    }

    function getDestinationByName($destination='', $idwh=''){
        $query = "select a.id,f.name `warehouse` ,e.province,d.district, c.subdistrict, a.destination, a.jarak ";
        $query = $query . " from shipment_express_distance a ";
        $query = $query . " left join indonesia_subdistricts c on c.id_indonesia_subdistricts=a.id_indonesia_subdistricts ";
        $query = $query . " left join indonesia_districts d on d.rajaongkir_id_district=c.indonesia_id_district ";
        $query = $query . " left join indonesia_provinces e on e.rajaongkir_province_id=d.indonesia_id_province ";
        $query = $query . " left join warehouse f on f.id=a.warehouse_id ";
        $query = $query . " where a.destination is not null ";
        $query = $query . " and a.destination = '" . $destination . "'";
        $query = $query . " and a.warehouse_id = '" . $idwh . "'";

		$row = $this->db->query($query)->num_rows();
		$data['return']['row'] = $row;
		$exec = $this->db->query($query)->result();
        $data['return']['data'] = $exec;
        
		return array('row' => $row, 'data' => $exec);
    }

    function getComboExpress($id) {

        $query = "select distinct a.destination ";
        $query = $query . " from shipment_express_distance a ";
        $query = $query . " left join indonesia_subdistricts c on c.id_indonesia_subdistricts=a.id_indonesia_subdistricts ";
        $query = $query . " left join indonesia_districts d on d.rajaongkir_id_district=c.indonesia_id_district ";
        $query = $query . " left join indonesia_provinces e on e.rajaongkir_province_id=d.indonesia_id_province ";
		$query = $query . " left join warehouse f on f.id=a.warehouse_id ";
		$query = $query . " where c.rajaongkir_id_subdistrict = '".$id."' ";
		$query = $query . " and c.subdistrict <> a.destination ";
		$results = $this->db->query($query)->result();
        
		return $results;
    }

    function getJarak($id){
        $this->db->select("*")->from("shipment_express_distance")->where("id",$id);

        return $this->db->get()->row();
    }
}