Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- public function proses_barangmasuk(){
- $id_barang =$this->input->post("id_barang");
- $jumlah =$this->input->post("jumlah");
- $data = array(
- 'id_supliyer' => $this->input->post('id_supliyer') ,
- 'id_barang' => $id_barang,
- 'imey' => $this->input->post('imey') ,
- 'harga_beli' => $this->input->post('harga_beli') ,
- 'jumlah' => $jumlah
- );
- $this->mcoba->insertbarangmasuk($data);
- //cek apakah sudah ada record di barang_detail
- $cek = $this->db->get_where('barang_detail', array('id_barang' => $id_barang))->num_rows();
- if ($cek > 0){
- //kalau sudah ada lakukan update
- //biar lebih pasti, lakukan query untuk mendapatkan total jumlah barang
- $row = $this->db->query("SELECT SUM(jumlah) AS total FROM barang_masuk WHERE id_barang = ?", array($id_barang))->row();
- $this->db->where(array('id_barang' => $id_barang));
- $this->db->update('barang_detail', array('jumlah' => $row->total));
- }else{
- //kalau belum ada lakukan insert
- $in = array(
- 'id_barang' => $id_barang,
- 'id_toko' => 'G01',
- 'jumlah' => $jumlah,
- );
- $this->mcoba->insertbarangdetail($in);
- }
- redirect("coba/bm");
- }
Advertisement
Add Comment
Please, Sign In to add comment