<?php
defined('BASEPATH') or exit('No direct script access allowed');
class ModelBantuan extends CI_Model
{
	public function create($table, $data, $batch = false)
	{
		if ($batch === false) {
			$insert = $this->db->insert($table, $data);
		} else {
			$insert = $this->db->insert_batch($table, $data);
		}
		return $insert;
	}

	public function update($table, $data, $pk, $id = null, $batch = false)
	{
		if ($batch === false) {
			$insert = $this->db->update($table, $data, array($pk => $id));
		} else {
			$insert = $this->db->update_batch($table, $data, $pk);
		}
		return $insert;
	}

	public function delete($table, $data, $pk)
	{
		$this->db->where_in($pk, $data);
		return $this->db->delete($table);
	}

	//Model addTempo
	public function addTimeMinutes($time, $minutes)
	{
		$sum = strtotime(date("H:i:s", strtotime("$time")) . " +$minutes minutes");
		$dateTo = date('H:i:s', $sum);
		return $dateTo;
	}

	//Model getCount
	public function getCount_CetakDokumen_Service()
	{
		$this->db->select('ID_CD');
		$this->db->from('cetak_dokumen');
		$this->db->where('SERVICE_ID is NOT NULL');
		$this->db->where('LP_KARYAWAN is NULL');
		return $this->db->count_all_results();
	}

	public function getCount_KlaimService_0_2()
	{
		$this->db->select('ID_KSV');
		$this->db->from('klaim_service');
		$this->db->where('STATUS_KSV=0 OR STATUS_KSV=2');
		return $this->db->count_all_results();
	}

	public function getCount_OrderService_NonDATANG()
	{
		$this->db->select('ID_OS');
		$this->db->from('order_service');
		$this->db->where('DATANG_OS is NULL');
		return $this->db->count_all_results();
	}

	public function getCount_Service_0()
	{
		$this->db->select('ID_SERVICE');
		$this->db->from('service');
		$this->db->where('STATUS_SERVICE=0');
		return $this->db->count_all_results();
	}

	//Model getData
	public function getData_Agen_byID($id = null)
	{
		if ($id == null) {
			$this->db->select('*');
			$this->db->from('agen');
		} else {
			$this->db->select('*');
			$this->db->from('agen');
			$this->db->where('ID_AGEN=', $id);
		}
		return $this->db->get()->result_array();
	}

	public function getData_CetakDokumen_forSERVICE_Null()
	{
		$this->db->select('*,DATE_FORMAT(b.TGL_SERVICE,"%d/%m/%Y") as TANGGAL');
		$this->db->from('cetak_dokumen a');
		$this->db->join('service b', 'b.ID_SERVICE=a.SERVICE_ID');
		$this->db->join('sn_service c', 'c.SERVICE_ID=b.ID_SERVICE');
		$this->db->join('pelanggan d', 'd.ID_PELANGGAN=b.PELANGGAN_ID');
		$this->db->join('kota e', 'e.ID_KOTA=d.KOTA_ID');
		$this->db->join('brgsv f', 'f.ID_BRGSV=c.BRGSV_ID');
		$this->db->where('a.STATUS_CD is NULL');
		return $this->db->get()->result_array();
	}

	public function getData_CetakDokumen_forSERVICE_0_1()
	{
		$this->db->select('*,DATE_FORMAT(b.TGL_SERVICE,"%d/%m/%Y") as TANGGAL');
		$this->db->from('cetak_dokumen a');
		$this->db->join('service b', 'b.ID_SERVICE=a.SERVICE_ID');
		$this->db->join('sn_service c', 'c.SERVICE_ID=b.ID_SERVICE');
		$this->db->join('pelanggan d', 'd.ID_PELANGGAN=b.PELANGGAN_ID');
		$this->db->join('kota e', 'e.ID_KOTA=d.KOTA_ID');
		$this->db->join('brgsv f', 'f.ID_BRGSV=c.BRGSV_ID');
		$this->db->where('a.STATUS_CD=0 OR a.STATUS_CD=1');
		$this->db->order_by('a.ID_CD DESC');
		$this->db->limit('100');
		return $this->db->get()->result_array();
	}

	public function getData_CetakDokumen_byID($id)
	{
		$this->db->select('*,DATE_FORMAT(b.TGL_SERVICE,"%d/%m/%Y") as TANGGAL');
		$this->db->from('cetak_dokumen a');
		$this->db->join('service b', 'b.ID_SERVICE=a.SERVICE_ID');
		$this->db->join('sn_service c', 'c.SERVICE_ID=b.ID_SERVICE');
		$this->db->join('pelanggan d', 'd.ID_PELANGGAN=b.PELANGGAN_ID');
		$this->db->join('kota e', 'e.ID_KOTA=d.KOTA_ID');
		$this->db->join('brgsv f', 'f.ID_BRGSV=c.BRGSV_ID');
		$this->db->where('a.ID_CD=', $id);
		return $this->db->get()->result_array();
	}

	public function getData_Karyawan_forLogin($username, $password)
	{
		$this->db->select('*');
		$this->db->from('karyawan a');
		$this->db->join('jabatan b', 'b.ID_JABATAN=a.JABATAN_ID');
		$this->db->where('a.USERNAME=', $username);
		$this->db->where('a.PASSWORD=', $password);
		return $this->db->get()->result_array();
	}

	public function getData_KlaimService_0_2($id = null)
	{
		if ($id == null) {
			$this->db->select('*,DATE_FORMAT(a.TGL_KSV,"%d/%m/%Y") as TANGGAL');
			$this->db->from('klaim_service a');
			$this->db->join('service b', 'b.ID_SERVICE=a.SERVICE_ID');
			$this->db->join('agen c', 'c.ID_AGEN=a.AGEN_ID');
			$this->db->join('sn_service d', 'd.SERVICE_ID=b.ID_SERVICE');
			$this->db->join('pelanggan e', 'e.ID_PELANGGAN=b.PELANGGAN_ID', 'left');
			$this->db->join('kota f', 'f.ID_KOTA=e.KOTA_ID', 'left');
			$this->db->join('karyawan g', 'g.ID_KARYAWAN=b.GUDANG_ID_1', 'left');
			$this->db->join('brgsv h', 'h.ID_BRGSV=d.BRGSV_ID', 'left');
			$this->db->where('a.STATUS_KSV=0 OR a.STATUS_KSV=2');
		} else {
			$this->db->select('*');
			$this->db->from('klaim_service a');
			$this->db->join('service b', 'b.ID_SERVICE=a.SERVICE_ID');
			$this->db->join('agen c', 'c.ID_AGEN=a.AGEN_ID');
			$this->db->join('sn_service d', 'd.SERVICE_ID=b.ID_SERVICE');
			$this->db->join('pelanggan e', 'e.ID_PELANGGAN=b.PELANGGAN_ID', 'left');
			$this->db->join('kota f', 'f.ID_KOTA=e.KOTA_ID', 'left');
			$this->db->join('karyawan g', 'g.ID_KARYAWAN=b.GUDANG_ID_1', 'left');
			$this->db->join('brgsv h', 'h.ID_BRGSV=d.BRGSV_ID', 'left');
			$this->db->where('a.STATUS_KSV=0 OR a.STATUS_KSV=2');
			$this->db->where('a.ID_KSV=', $id);
		}
		return $this->db->get()->result_array();
	}

	public function getData_KlaimService_1_3($id = null)
	{
		if ($id == null) {
			$this->db->select('*,DATE_FORMAT(a.TGL_KSV,"%d/%m/%Y") as TANGGAL');
			$this->db->from('klaim_service a');
			$this->db->join('service b', 'b.ID_SERVICE=a.SERVICE_ID');
			$this->db->join('agen c', 'c.ID_AGEN=a.AGEN_ID');
			$this->db->join('sn_service d', 'd.SERVICE_ID=b.ID_SERVICE');
			$this->db->join('pelanggan e', 'e.ID_PELANGGAN=b.PELANGGAN_ID', 'left');
			$this->db->join('kota f', 'f.ID_KOTA=e.KOTA_ID', 'left');
			$this->db->join('karyawan g', 'g.ID_KARYAWAN=b.GUDANG_ID_1', 'left');
			$this->db->join('brgsv h', 'h.ID_BRGSV=d.BRGSV_ID', 'left');
			$this->db->where('a.STATUS_KSV=1 OR a.STATUS_KSV=3');
		} else {
			$this->db->select('*');
			$this->db->from('klaim_service a');
			$this->db->join('service b', 'b.ID_SERVICE=a.SERVICE_ID');
			$this->db->join('agen c', 'c.ID_AGEN=a.AGEN_ID');
			$this->db->join('sn_service d', 'd.SERVICE_ID=b.ID_SERVICE');
			$this->db->join('pelanggan e', 'e.ID_PELANGGAN=b.PELANGGAN_ID', 'left');
			$this->db->join('kota f', 'f.ID_KOTA=e.KOTA_ID', 'left');
			$this->db->join('karyawan g', 'g.ID_KARYAWAN=b.GUDANG_ID_1', 'left');
			$this->db->join('brgsv h', 'h.ID_BRGSV=d.BRGSV_ID', 'left');
			$this->db->where('a.STATUS_KSV=1 OR a.STATUS_KSV=3');
			$this->db->where('a.ID_KSV=', $id);
		}
		return $this->db->get()->result_array();
	}

	public function getData_LogService_byID($id)
	{
		$this->db->select('*');
		$this->db->from('log_service a');
		$this->db->join('sn_service b', 'b.ID_SNS=a.SNS_ID');
		$this->db->join('service c', 'c.ID_SERVICE=b.SERVICE_ID');
		$this->db->join('karyawan d', 'd.ID_KARYAWAN=a.TEKNISI_ID', 'left');
		$this->db->where('a.ID_LSV=', $id);
		return $this->db->get()->result_array();
	}

	public function getData_LogService_bySNS($id)
	{
		$this->db->select('*,DATE_FORMAT(a.TGL_LSV,"%d/%m/%Y") as TANGGAL');
		$this->db->from('log_service a');
		$this->db->join('sn_service b', 'b.ID_SNS=a.SNS_ID');
		$this->db->join('service c', 'c.ID_SERVICE=b.SERVICE_ID');
		$this->db->join('karyawan d', 'd.ID_KARYAWAN=a.TEKNISI_ID', 'left');
		$this->db->where('a.SNS_ID=', $id);
		return $this->db->get()->result_array();
	}

	public function getData_OrderService_forInput()
	{
		$this->db->select('*, c.NAMA_KOTA AS NAMA_KOTA_SUPPLIER, e.NAMA_KOTA AS NAMA_KOTA_PELANGGAN,
				   CONCAT("Rp ",FORMAT(a.HARGA_OS,2)) as HARGA,DATE_FORMAT(a.REQUEST_OS,"%d/%m/%Y") as REQUEST');
		$this->db->from('order_service a');
		$this->db->join('supplier b', 'b.ID_SUPPLIER=a.SUPPLIER_ID');
		$this->db->join('kota c', 'c.ID_KOTA=b.KOTA_ID');
		$this->db->join('pelanggan d', 'd.ID_PELANGGAN=a.PELANGGAN_ID');
		$this->db->join('kota e', 'e.ID_KOTA=d.KOTA_ID');
		$this->db->where('a.DATANG_OS is NULL');
		return $this->db->get()->result_array();
	}

	public function getData_OrderService_forRevisi()
	{
		$this->db->select('*,c.NAMA_KOTA AS NAMA_KOTA_SUPPLIER, e.NAMA_KOTA AS NAMA_KOTA_PELANGGAN,
				   CONCAT("Rp ",FORMAT(a.HARGA_OS,2)) as HARGA,DATE_FORMAT(a.REQUEST_OS,"%d/%m/%Y") as REQUEST,
				   DATE_FORMAT(a.DATANG_OS,"%d/%m/%Y") as DATANG');
		$this->db->from('order_service a');
		$this->db->join('supplier b', 'b.ID_SUPPLIER=a.SUPPLIER_ID');
		$this->db->join('kota c', 'c.ID_KOTA=b.KOTA_ID');
		$this->db->join('pelanggan d', 'd.ID_PELANGGAN=a.PELANGGAN_ID');
		$this->db->join('kota e', 'e.ID_KOTA=d.KOTA_ID');
		$this->db->where('a.DATANG_OS is NOT NULL');
		return $this->db->get()->result_array();
	}

	public function getData_Pelanggan_byID($id = null)
	{
		if ($id == null) {
			$this->db->select('*');
			$this->db->from('pelanggan a');
			$this->db->join('kota b', 'b.ID_KOTA=a.KOTA_ID');
			$this->db->order_by('a.TYPE_PELANGGAN ASC');
		} else {
			$this->db->select('*');
			$this->db->from('pelanggan a');
			$this->db->join('kota b', 'b.ID_KOTA=a.KOTA_ID');
			$this->db->where('a.ID_PELANGGAN=', $id);
		}
		return $this->db->get()->result_array();
	}

	public function getData_SalesOrder_forService()
	{
		$this->db->select('*,DATE_FORMAT(TGL_SO,"%d/%m/%Y") as TANGGAL');
		$this->db->from('sales_order');
		$this->db->where('STATUS_SO=1');
		return $this->db->get()->result_array();
	}

	public function getData_Service_byID($id)
	{
		$this->db->select('*');
		$this->db->from('service');
		$this->db->where('ID_SERVICE=', $id);
		return $this->db->get()->result_array();
	}

	public function getData_Service_forKlaimService()
	{
		$this->db->select('*');
		$this->db->from('service a');
		$this->db->join('pelanggan b', 'b.ID_PELANGGAN=a.PELANGGAN_ID', 'left');
		$this->db->join('karyawan c', 'c.ID_KARYAWAN=a.GUDANG_ID_1', 'left');
		$this->db->order_by('a.ID_SERVICE DESC');
		$this->db->limit('100');
		return $this->db->get()->result_array();
	}

	public function getData_SnService_byID($id)
	{
		$this->db->select('*');
		$this->db->from('sn_service a');
		$this->db->join('service b', 'b.ID_SERVICE=a.SERVICE_ID');
		$this->db->where('a.ID_SNS=', $id);
		return $this->db->get()->result_array();
	}

	public function getData_SnService_bySERVICE_Not1($id = null)
	{
		if ($id == null) {
			$this->db->select('*,DATE_FORMAT(b.TGL_SERVICE,"%d/%m/%Y") as TANGGAL');
			$this->db->from('sn_service a');
			$this->db->join('service b', 'b.ID_SERVICE=a.SERVICE_ID');
			$this->db->join('karyawan c', 'c.ID_KARYAWAN=b.GUDANG_ID_1', 'left');
			$this->db->join('pelanggan d', 'd.ID_PELANGGAN=b.PELANGGAN_ID', 'left');
			$this->db->join('kota e', 'e.ID_KOTA=d.KOTA_ID', 'left');
			$this->db->join('daftar_service f', 'f.ID_DFS=a.DFS_ID', 'left');
			$this->db->join('barang g', 'g.ID_BARANG=f.BARANG_ID', 'left');
			$this->db->join('brgsv h', 'h.ID_BRGSV=a.BRGSV_ID', 'left');
			$this->db->group_by('a.ID_SNS');
			$this->db->where('a.STATUS_SNS!="2" OR a.STATUS_SNS is NULL');
		} else {
			$this->db->select('*');
			$this->db->from('sn_service a');
			$this->db->join('service b', 'b.ID_SERVICE=a.SERVICE_ID');
			$this->db->join('karyawan c', 'c.ID_KARYAWAN=b.GUDANG_ID_1', 'left');
			$this->db->join('pelanggan d', 'd.ID_PELANGGAN=b.PELANGGAN_ID', 'left');
			$this->db->join('kota e', 'e.ID_KOTA=d.KOTA_ID', 'left');
			$this->db->join('daftar_service f', 'f.ID_DFS=a.DFS_ID', 'left');
			$this->db->join('barang g', 'g.ID_BARANG=f.BARANG_ID', 'left');
			$this->db->join('brgsv h', 'h.ID_BRGSV=a.BRGSV_ID', 'left');
			$this->db->group_by('a.ID_SNS');
			$this->db->where('a.STATUS_SNS!="2" OR a.STATUS_SNS is NULL');
			$this->db->where('a.SERVICE_ID=', $id);
		}
		return $this->db->get()->result_array();
	}

	public function getData_SnService_bySERVICE_1($id = null)
	{
		if ($id == null) {
			$this->db->select('*,DATE_FORMAT(b.TGL_SERVICE,"%d/%m/%Y") as TANGGAL');
			$this->db->from('sn_service a');
			$this->db->join('service b', 'b.ID_SERVICE=a.SERVICE_ID');
			$this->db->join('karyawan c', 'c.ID_KARYAWAN=b.GUDANG_ID_1', 'left');
			$this->db->join('pelanggan d', 'd.ID_PELANGGAN=b.PELANGGAN_ID', 'left');
			$this->db->join('kota e', 'e.ID_KOTA=d.KOTA_ID', 'left');
			$this->db->join('daftar_service f', 'f.ID_DFS=a.DFS_ID', 'left');
			$this->db->join('barang g', 'g.ID_BARANG=f.BARANG_ID', 'left');
			$this->db->join('brgsv h', 'h.ID_BRGSV=a.BRGSV_ID', 'left');
			$this->db->group_by('a.ID_SNS');
			$this->db->where('a.STATUS_SNS="2"');
		} else {
			$this->db->select('*');
			$this->db->from('sn_service a');
			$this->db->join('service b', 'b.ID_SERVICE=a.SERVICE_ID');
			$this->db->join('karyawan c', 'c.ID_KARYAWAN=b.GUDANG_ID_1', 'left');
			$this->db->join('pelanggan d', 'd.ID_PELANGGAN=b.PELANGGAN_ID', 'left');
			$this->db->join('kota e', 'e.ID_KOTA=d.KOTA_ID', 'left');
			$this->db->join('daftar_service f', 'f.ID_DFS=a.DFS_ID', 'left');
			$this->db->join('barang g', 'g.ID_BARANG=f.BARANG_ID', 'left');
			$this->db->join('brgsv h', 'h.ID_BRGSV=a.BRGSV_ID', 'left');
			$this->db->group_by('a.ID_SNS');
			$this->db->where('a.STATUS_SNS="2"');
			$this->db->where('a.SERVICE_ID=', $id);
		}
		return $this->db->get()->result_array();
	}

	public function getData_Supplier_byID($id = null)
	{
		if ($id == null) {
			$this->db->select('*');
			$this->db->from('supplier a');
			$this->db->join('kota b', 'b.ID_KOTA=a.KOTA_ID');
			$this->db->order_by('a.NAMA_SUPPLIER', 'ASC');
		} else {
			$this->db->select('*');
			$this->db->from('supplier a');
			$this->db->join('kota b', 'b.ID_KOTA=a.KOTA_ID');
			$this->db->where('a.ID_SUPPLIER=', $id);
		}
		return $this->db->get()->result_array();
	}


	public function getDataService($id = null)
	{
		if ($id === null) {
			$this->db->select('*,CONCAT(DATE_FORMAT(a.TANGGAL_SERVICE,"%d %M %Y %H:%i")) AS WAKTU,CONCAT(DATE_FORMAT(a.TANGGAL_SERVICE,"%d/%m/%Y")) AS TERIMA');
			$this->db->from('service a');
			$this->db->join('pelanggan b', 'b.ID_PELANGGAN=a.PELANGGAN_ID');
			$this->db->join('barang c', 'c.ID_BARANG=a.BARANG_ID');
			$this->db->join('operator d', 'd.ID_OPERATOR=a.OPERATOR_ID');
			$this->db->order_by('ID_SERVICE', 'ASC');
		} else {
			$this->db->select('*,CONCAT(DATE_FORMAT(a.TANGGAL_SERVICE,"%d %M %Y %H:%i")) AS WAKTU,CONCAT(DATE_FORMAT(a.TANGGAL_SERVICE,"%d/%m/%Y")) AS TERIMA');
			$this->db->from('service a');
			$this->db->join('pelanggan b', 'b.ID_PELANGGAN=a.PELANGGAN_ID');
			$this->db->join('barang c', 'c.ID_BARANG=a.BARANG_ID');
			$this->db->join('operator d', 'd.ID_OPERATOR=a.OPERATOR_ID');
			$this->db->where(['ID_SERVICE' => $id]);
			$this->db->order_by('ID_SERVICE', 'ASC');
		}

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

	public function getDataServiceNull($id = null)
	{
		if ($id === null) {
			$this->db->select('*,CONCAT(DATE_FORMAT(a.TANGGAL_SERVICE,"%d %M %Y %H:%i")) AS WAKTU');
			$this->db->from('service a');
			$this->db->join('pelanggan b', 'b.ID_PELANGGAN=a.PELANGGAN_ID');
			$this->db->join('barang c', 'c.ID_BARANG=a.BARANG_ID');
			$this->db->join('operator d', 'd.ID_OPERATOR=a.OPERATOR_ID');
			$this->db->order_by('ID_SERVICE', 'ASC');
			$this->db->where('a.PROGRESS_ID is NULL', NULL, FALSE);
		} else {
			$this->db->select('*,CONCAT(DATE_FORMAT(a.TANGGAL_SERVICE,"%d %M %Y %H:%i")) AS WAKTU');
			$this->db->from('service a');
			$this->db->join('pelanggan b', 'b.ID_PELANGGAN=a.PELANGGAN_ID');
			$this->db->join('barang c', 'c.ID_BARANG=a.BARANG_ID');
			$this->db->join('operator d', 'd.ID_OPERATOR=a.OPERATOR_ID');
			$this->db->where(['ID_SERVICE' => $id]);
			$this->db->order_by('ID_SERVICE', 'ASC');
			$this->db->where('a.PROGRESS_ID is NULL', NULL, FALSE);
		}

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

	public function getDataClaimNull($id = null)
	{
		if ($id === null) {
			$this->db->select('*,CONCAT(DATE_FORMAT(a.TANGGAL_SERVICE,"%d %M %Y %H:%i")) AS WAKTU');
			$this->db->from('service a');
			$this->db->join('pelanggan b', 'b.ID_PELANGGAN=a.PELANGGAN_ID');
			$this->db->join('barang c', 'c.ID_BARANG=a.BARANG_ID');
			$this->db->join('operator d', 'd.ID_OPERATOR=a.OPERATOR_ID');
			$this->db->join('progress e', 'e.ID_PROGRESS=a.PROGRESS_ID', 'left');
			$this->db->join('garansi f', 'f.ID_GARANSI=e.GARANSI_ID', 'left');
			$this->db->order_by('ID_SERVICE', 'ASC');
			$this->db->where('e.GARANSI_ID is null');
			$this->db->or_where('e.STATUS_PROGRESS="Claim Garansi"');
		}
		return $this->db->get()->result_array();
	}

	public function getDataUpClaimNull($id = null)
	{
		if ($id === null) {
			$this->db->select('*,CONCAT(DATE_FORMAT(a.TANGGAL_SERVICE,"%d %M %Y %H:%i")) AS WAKTU');
			$this->db->from('service a');
			$this->db->join('pelanggan b', 'b.ID_PELANGGAN=a.PELANGGAN_ID');
			$this->db->join('barang c', 'c.ID_BARANG=a.BARANG_ID');
			$this->db->join('operator d', 'd.ID_OPERATOR=a.OPERATOR_ID');
			$this->db->join('progress e', 'e.ID_PROGRESS=a.PROGRESS_ID', 'left');
			$this->db->join('claimdell f', 'f.ID_CLAIMDELL=a.CLAIMDELL_ID', 'left');
			$this->db->order_by('ID_SERVICE', 'ASC');
			$this->db->where('e.STATUS_PROGRESS="Claim Garansi"');
			$this->db->where('f.NOSER_CLAIMDELL is null');
		}
		return $this->db->get()->result_array();
	}

	public function getDataServiceID($id = null)
	{
		if ($id === null) {
			$this->db->select('a.ID_SERVICE');
			$this->db->from('service a');
			$this->db->join('pelanggan b', 'b.ID_PELANGGAN=a.PELANGGAN_ID');
			$this->db->join('barang c', 'c.ID_BARANG=a.BARANG_ID');
			$this->db->join('operator d', 'd.ID_OPERATOR=a.OPERATOR_ID');
			$this->db->where('a.PROGRESS_ID is NULL', NULL, FALSE);
		} else {
			$this->db->select('a.ID_SERVICE');
			$this->db->from('service a');
			$this->db->join('pelanggan b', 'b.ID_PELANGGAN=a.PELANGGAN_ID');
			$this->db->join('barang c', 'c.ID_BARANG=a.BARANG_ID');
			$this->db->join('operator d', 'd.ID_OPERATOR=a.OPERATOR_ID');
			$this->db->where('a.PROGRESS_ID is NULL', NULL, FALSE);
		}

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

	public function getDataServiceClaim($id = null)
	{
		if ($id === null) {
			$this->db->select('*');
			$this->db->from('service a');
			$this->db->join('pelanggan b', 'b.ID_PELANGGAN=a.PELANGGAN_ID');
			$this->db->join('barang c', 'c.ID_BARANG=a.BARANG_ID');
			$this->db->join('operator d', 'd.ID_OPERATOR=a.OPERATOR_ID');
			$this->db->join('progress e', 'e.ID_PROGRESS=a.PROGRESS_ID', 'left');
			$this->db->join('garansi f', 'f.ID_GARANSI=e.GARANSI_ID', 'left');
		}
		return $this->db->get()->result_array();
	}

	public function getDataClaimdellID($id = null)
	{
		if ($id === null) {
			$this->db->select_max('ID_CLAIMDELL');
			$this->db->from('claimdell');
		} else {
			$this->db->select_max('ID_CLAIMDELL');
			$this->db->from('claimdell');
		}

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

	public function getIDService($id = null)
	{
		if ($id === null) {
			$this->db->select_max('ID_SERVICE');
			$this->db->from('service');
		} else {
			$this->db->select_max('ID_SERVICE');
			$this->db->from('service');
		}

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

	public function getIDProgress($id = null)
	{
		if ($id === null) {
			$this->db->select_max('ID_PROGRESS');
			$this->db->from('progress');
		} else {
			$this->db->select_max('ID_PROGRESS');
			$this->db->from('progress');
		}

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

	public function getIDGaransi($id = null)
	{
		if ($id === null) {
			$this->db->select_max('ID_GARANSI');
			$this->db->from('garansi');
		} else {
			$this->db->select_max('ID_GARANSI');
			$this->db->from('garansi');
		}

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

	public function getIDInternal($id = null)
	{
		if ($id === null) {
			$this->db->select_max('ID_INTERNAL');
			$this->db->from('internal');
		} else {
			$this->db->select_max('ID_INTERNAL');
			$this->db->from('internal');
		}

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

	public function getIDOutlet($id = null)
	{
		if ($id === null) {
			$this->db->select_max('ID_OUTLET');
			$this->db->from('outlet');
		} else {
			$this->db->select_max('ID_OUTLET');
			$this->db->from('outlet');
		}

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

	public function getGaransiID($id = null)
	{
		if ($id === null) {
			$this->db->select('GARANSI_ID');
			$this->db->from('progress');
		} else {
			$this->db->select('GARANSI_ID');
			$this->db->from('progress');
			$this->db->where(['ID_PROGRESS' => $id]);
		}

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

	public function getOutletID($id = null)
	{
		if ($id === null) {
			$this->db->select('OUTLET_ID');
			$this->db->from('service');
		} else {
			$this->db->select('c.ID_OUTLET');
			$this->db->from('service a');
			$this->db->join('progress b', 'b.ID_PROGRESS=a.PROGRESS_ID');
			$this->db->join('outlet c', 'c.ID_OUTLET=a.OUTLET_ID');
			$this->db->where(['b.ID_PROGRESS' => $id]);
		}
		return $this->db->get()->result_array();
	}

	public function getInternalID($id = null)
	{
		if ($id === null) {
			$this->db->select('INTERNAL_ID');
			$this->db->from('service');
		} else {
			$this->db->select('c.ID_INTERNAL');
			$this->db->from('service a');
			$this->db->join('progress b', 'b.ID_PROGRESS=a.PROGRESS_ID');
			$this->db->join('internal c', 'c.ID_INTERNAL=a.INTERNAL_ID');
			$this->db->where(['b.ID_PROGRESS' => $id]);
		}
		return $this->db->get()->result_array();
	}

	public function getCountService($id = null)
	{
		if ($id === null) {
			$this->db->select('ID_SERVICE');
			$this->db->from('service');
		} else {
			$this->db->select('ID_SERVICE');
			$this->db->from('service');
		}

		return $this->db->count_all_results();
	}

	public function getDataProgressService($id = null)
	{
		if ($id === null) {
			$this->db->select_max('ID_PROGRESS');
			$this->db->from('progress');
		} else {
			$this->db->select_max('ID_PROGRESS');
			$this->db->from('progress');
		}

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

	public function cekPass($id, $pass)
	{
		$this->db->select('*');
		$this->db->from('karyawan');
		$this->db->where(['ID_KARYAWAN' => $id]);
		$this->db->where(['PASSWORD' => $pass]);
		return $this->db->get()->result_array();
	}

	public function getExcel_OrderService_All($start, $end)
	{
		$this->db->select('*, c.NAMA_KOTA AS NAMA_KOTA_SUPPLIER,CONCAT("Rp ",FORMAT(a.HARGA_OS,2)) as HARGA, 
				   e.NAMA_KOTA AS NAMA_KOTA_PELANGGAN,DATE_FORMAT(a.REQUEST_OS, "%d/%m/%Y") AS REQUEST,DATE_FORMAT(a.DATANG_OS, "%d/%m/%Y") AS DATANG');
		$this->db->from('order_service a');
		$this->db->join('supplier b', 'b.ID_SUPPLIER=a.SUPPLIER_ID');
		$this->db->join('kota c', 'c.ID_KOTA=b.KOTA_ID');
		$this->db->join('pelanggan d', 'd.ID_PELANGGAN=a.PELANGGAN_ID');
		$this->db->join('kota e', 'e.ID_KOTA=d.KOTA_ID');
		$this->db->where('a.DATANG_OS is NULL');
		$this->db->where('a.REQUEST_OS>=', $start);
		$this->db->where('a.REQUEST_OS<=', $end);

		return $this->db->get()->result_array();
	}
	
	public function getExcel_OrderService_bySupplier($start, $end, $m_supplier)
	{
		$this->db->select('*,c.NAMA_KOTA AS NAMA_KOTA_SUPPLIER,CONCAT("Rp ",FORMAT(a.HARGA_OS,2)) as HARGA, 
				   e.NAMA_KOTA AS NAMA_KOTA_PELANGGAN,DATE_FORMAT(a.REQUEST_OS, "%d/%m/%Y") AS REQUEST,DATE_FORMAT(a.DATANG_OS, "%d/%m/%Y") AS DATANG');
		$this->db->from('order_service a');
		$this->db->join('supplier b', 'b.ID_SUPPLIER=a.SUPPLIER_ID');
		$this->db->join('kota c', 'c.ID_KOTA=b.KOTA_ID');
		$this->db->join('pelanggan d', 'd.ID_PELANGGAN=a.PELANGGAN_ID');
		$this->db->join('kota e', 'e.ID_KOTA=d.KOTA_ID');
		$this->db->where('a.DATANG_OS is NULL');
		$this->db->where('a.REQUEST_OS>=', $start);
		$this->db->where('a.REQUEST_OS<=', $end);
		$this->db->where(['b.ID_SUPPLIER' => $m_supplier]);

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