function update_so_header() { $ERROR = 1; $id = $this->input->post('NO_BUKTI'); unset($_POST['NAMA_WILAYAH']); unset($_POST['NAMA_SALES']); unset($_POST['NO_URUT']); //*************************** //VALIDATION $record_hdr = $this->model_so->get_so_header(array('no_bukti' => $id)); if ($this->_is_so_approved($record_hdr)) { $message = lang('ErrorTxApproved'); die(sprintf('@@%s@@%s', 0, lang('ErrorTxApproved'))); } if ($this->_is_tx_canceled($record_hdr)) { $message = lang('ErrorTxCanceled'); die(sprintf('@@%s@@%s', 0, lang('ErrorTxCanceled'))); } //**************************** if ($id) { //unset($_POST['strseq']); $_POST['TGL'] = formatdatemon($_POST['TGL']); $_POST['TGL_KIRIM'] = formatdatemon($_POST['TGL_KIRIM']); $this->model_so->add_so_header($_POST, $id); die(sprintf('@@%s@@%s', $ERROR, lang('message_success_update'))); } else { die(sprintf('@@%s@@%s', $ERROR, lang('message_ErrorIdIsNull'))); } }
function get_so_header_detail($params = array()) { $datefrom = $dateto = null; $dateFlag = True; $usrBasePeriode = date('m-Y'); // get user information $user_id = $this->session->userdata('user_info')->id; $user_name = $this->session->userdata('user_info')->username; $user_rank = $this->session->userdata('user_info')->rank_id; $rank_priority = $this->get_user_rank_priority($user_rank); $user_location_id = $this->get_user_location_id($user_id); $ids = array(); // untuk simpan location user yang bersangkutan.. /* Search by dateto dan datefrom belum 100% */ if (isset($params['NO_BUKTI']) and $params['NO_BUKTI'] != '') { $this->db->where('a.NO_BUKTI', $params['NO_BUKTI']); $dateFlag = False; } if (isset($params['NO_PO_CUST']) and $params['NO_PO_CUST'] != '') { $this->db->where('a.NO_PO_CUST', $params['NO_PO_CUST']); $dateFlag = False; } //if( isset( $params['NAMA_CUST']) and $params['NAMA_CUST']!='') if (isset($params['customer_code']) and $params['customer_code'] != '') { //$this->db->where('a.NAMA_CUST', $params['NAMA_CUST']); $this->db->where('a.CUST', $params['customer_code']); $dateFlag = False; } if (isset($params['sales_code']) and $params['sales_code'] != '') { $this->db->where('a.KODE_SALES', $params['sales_code']); } if (isset($params['KODE_WIL']) and $params['KODE_WIL'] != '') { if ($params['KODE_WIL'] != 'ALL') { $this->db->where('a.KODE_WIL', $params['KODE_WIL']); } } //item related if (isset($params['item_no']) and $params['item_no'] != '') { $this->db->where('b.BRG', $params['item_no']); } if ($dateFlag) { if (isset($params['datefrom']) and $params['datefrom'] != '') { $datefrom = formatdatemon($params['datefrom']); } else { $datefrom = date('d-M-Y', COMPILE_iFIRSTDATE($usrBasePeriode)); } if (isset($params['dateto']) and $params['dateto'] != '') { $dateto = formatdatemon($params['dateto']); } else { $dateto = date('d-M-Y', COMPILE_iLASTDATE($usrBasePeriode)); } } if (!is_null($datefrom)) { $this->db->where('a.TGL >=', $datefrom); } if (!is_null($dateto)) { $this->db->where('a.TGL <=', $dateto); } /*$this->db->select( 'a.NO_BUKTI, a.TGL, a.TGL_KIRIM, a.STATUS, a.NO_PO_CUST, a.NAMA_CUST, a.VLT, a.KET, a.TGL_INPUT, b.NO_URUT, b.BRG, u.username, u.rank_id, ul.location_id, sl.NAMA' ); */ /*$this->db->select( 'a.NO_BUKTI, a.TGL, a.TGL_KIRIM, a.STATUS, a.NO_PO_CUST, a.NAMA_CUST, a.VLT, a.KET, a.TGL_INPUT, b.NO_URUT, b.BRG, u.username, u.rank_id, ul.location_id, sl.NAMA' );*/ $this->db->select('a.*, b.NO_URUT, b.BRG, sl.NAMA, brg.NAMA as NAMABARANG'); // refer to model_po's model $this->db->join($this->prefix . '_AR..ARF08 sl', 'sl.SLM = a.KODE_SALES', 'left'); $this->db->join($this->prefix . '_SO..SOT01B b', 'b.NO_BUKTI = a.NO_BUKTI', 'left'); $this->db->join($this->prefix . '_ST..STF02 brg', 'brg.BRG = b.BRG', 'left'); $this->db->join('[user] u', 'a.USER_NAME = u.username', 'left'); $this->db->join('[user_location] ul', 'ul.user_id = u.id', 'left'); $this->db->order_by("a.NO_BUKTI", "asc"); //if($user_rank > 30){ if ($rank_priority > 30) { foreach ($user_location_id as $id) { $ids[] = $id->location_id; } //$this->db->where('ul.location_id', $user_location_id); // hanya pilih lokasi user nya aja //$this->db->where_in('ul.location_id', $ids); $this->db->where_in('a.KODE_WIL', $ids); } $query = $this->db->get($this->prefix . '_SO..SOT01A a')->result(); return $query; }