/**
  * get all activ discount
  * @return array discount
  */
 public function getDiscount()
 {
     $locale = \MY_Controller::getCurrentLocale();
     $time = time();
     $sql = "select *, mod_shop_discounts.id as ids, mod_shop_discounts.id as id\n                from mod_shop_discounts\n                left join mod_shop_discounts_i18n on mod_shop_discounts_i18n.id = mod_shop_discounts.id and mod_shop_discounts_i18n.locale = '{$locale}'\n                where (max_apply > count_apply \n                        or max_apply is null \n                        or (max_apply is null and count_apply is null)\n                        or (count_apply is null and max_apply > 0))\n                      and \n                      (date_begin < '{$time}' and date_end > '{$time}' \n                          or date_begin < '{$time}' and date_end is Null \n                           or date_begin is Null and date_end is Null\n                           or date_begin < '{$time}' and date_end = '0'\n                           or date_begin is null and date_end = '0')\n                      and \n                       active = 1";
     return $this->db->query($sql)->result_array();
 }

 function __construct()
 {
     parent::__construct();
     $this->load->model('queue_model');
     $this->load->library('rest');
     Requests::register_autoloader();
 }

 public function __construct()
 {
     parent::__construct();
     $this->load->model('index_model', 'index_model', TRUE);
     $this->load->model('upload_model', 'upload_model', TRUE);
     $this->data['pelajaran_result'] = $this->index_model->get_pelajaran();
 }

 public function __construct()
 {
     parent::__construct();
     $this->module = 'dashboard';
     $this->cname = 'dashboard';
     $this->load->model('mdl_grafik', 'mg');
 }

 function __construct()
 {
     parent::__construct();
     $this->no_cache();
     $this->load->model('user_modelsupllier');
     $this->load->library('session');
 }

 public function __construct()
 {
     parent::__construct();
     $this->load->model('usuario_model');
     $this->load->model('paginador_model');
     $this->load->library('pagination');
 }

 public function __construct()
 {
     parent::__construct();
     $log_details = new stdClass();
     stdlog($log_details);
     unset($log_details);
 }

 public function __construct()
 {
     parent::__construct();
     $this->load->model(array('MOrder', 'MCustomer', 'MWorkflow_log', 'MLocation'));
     $this->load->helper(array('money_helper'));
     $this->load->library(array('form_validation', 'filter_orders', 'order_split'));
 }

 /**
  * 
  */
 public function __construct()
 {
     parent::__construct();
     $this->load->model("usuario_model", "_usuario_model");
     $this->load->model("usuario2_model", "_usuario2_model");
     $this->load->model("usuario_region_model", "_usuario_region_model");
 }

 public function __construct()
 {
     parent::__construct();
     $this->load->database();
     $this->load->helper('url');
     $this->load->library('session');
 }

 function __construct()
 {
     parent::__construct();
     $this->session->set_userdata("link_id", "index");
     $this->session->set_userdata("linkSub", "visit_management");
     $this->session->set_userdata("linkTitle", "Visit Purpose Management");
 }

 public function __construct()
 {
     parent::__construct();
     $admin_info = $this->session->userdata('admin_session');
     $params['admin_info'] = $admin_info;
     $this->load->vars($params);
 }

 function __construct()
 {
     parent::__construct();
     $this->load->model('penukaran_point_member_model');
     $this->load->model('setting_penukaran_point_model');
     $this->offset = isset($_POST['start']) ? $this->db->escape_str($this->input->post('start', TRUE)) : 0;
     $this->limit = isset($_POST['limit']) ? $this->db->escape_str($this->input->post('limit', TRUE)) : $this->config->item("length_records");
     $this->search = isset($_POST['query']) ? $this->db->escape_str($this->input->post('query', TRUE)) : '';
     $this->kdMember = isset($_POST['kd_member']) ? $this->db->escape_str($this->input->post('kd_member', TRUE)) : FALSE;
     $this->jumlahPointTukar = isset($_POST['jumlah_point_ditukar']) ? $this->db->escape_str($this->input->post('jumlah_point_ditukar', TRUE)) : FALSE;
     $this->pointMember = isset($_POST['point_member']) ? $this->db->escape_str($this->input->post('point_member', TRUE)) : FALSE;
     $this->tanggal = date('Y-m-d H:i:s');
     $this->keterangan = 'keterangan';
     $this->createdBy = $this->session->userdata('username');
     $this->createdDate = date('Y-m-d H:i:s');
     $this->updatedBy = $this->session->userdata('username');
     $this->updatedDate = date('Y-m-d H:i:s');
     $this->data = isset($_POST['data']) ? json_decode($this->input->post('data', TRUE)) : array();
     //generate no bukti
     $current_date = date('Ym');
     $no_ret = 'TP' . $current_date . '-';
     $sequence = $this->penukaran_point_member_model->get_kode_sequence($no_ret, 3);
     $this->noBukti = $no_ret . $sequence;
     //end of generate no bukti
 }

 public function __construct()
 {
     parent::__construct();
     $this->load->model('house_model');
     $this->load->model('financials_model');
     $this->load->model('projects_model');
 }

 public function __construct()
 {
     parent::__construct();
     $this->module = 'stok_bahan';
     $this->cname = $this->module . '/input';
     $this->load->model('mdl_input', 'mp');
 }

 function __construct()
 {
     parent::__construct();
     $this->_check_permissions();
     $this->form_validation->set_error_delimiters('<p class="help-block">', '</p>');
     $this->data['folder_name'] = 'admin/gateways/';
 }

 function __construct()
 {
     parent::__construct();
     //session_start();
     $this->lang->load("title", "english");
     $this->load->helper('breadcrumb_helper');
 }

 public function __construct()
 {
     parent::__construct();
     $this->load->helper("url");
     $this->load->helper('mail_helper');
     $this->load->model("mcontact");
 }

 function __construct()
 {
     parent::__construct();
     $this->load->model('ProjectModel');
     $this->load->model('ProfileModel');
     //$this->load->model('LoggerModel');
 }

 public function __construct()
 {
     parent::__construct();
     $this->load->model('attendance_model');
     $this->load->helper('form');
     $this->load->library('validation');
 }