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

class Sheetmkios extends CI_Model {

    private $table = "kjnt_form_2";
    public function __construct()
    {
        parent::__construct();
    }

    public function get_data_cell($dari,$sampai)
    {
        if($dari != null && $sampai != null)
        {
            $this->db->where('substr(TGLTRX,1,10) >=',$dari);
            $this->db->where('substr(TGLTRX,1,10) <=',$sampai);
        } //else {
            // $this->db->where('substr(TGLTRX,1,10) >=',date("Y-m-d"));
   //      }
   //      if($this->input->post('NMRS'))
   //      {
   //          $this->db->where('NMRS', $this->input->post('NMRS'));
   //      }
   //      if($this->input->post('NMSAL'))
   //      {
   //          $this->db->where('NMSAL', $this->input->post('NMSAL'));
   //      }
   //      if($this->input->post('KOTA'))
   //      {
   //      $this->db->where('KOTA', $this->input->post('KOTA'));
   //      }
   //      if($this->input->post('CLUSTER'))
   //      {
   //          $this->db->where('CLUSTER', $this->input->post('CLUSTER'));
   //      }

        $query = $this->db->get($this->table);
        return $query->result();
    }
}