Guest User

Untitled

a guest
May 26th, 2015
275
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.16 KB | None | 0 0
  1. <?php
  2. public function proses_barangmasuk(){
  3.     $id_barang =$this->input->post("id_barang");
  4.     $jumlah =$this->input->post("jumlah");
  5.     $data = array(     
  6.                   'id_supliyer' => $this->input->post('id_supliyer') ,               
  7.                   'id_barang' => $id_barang,
  8.                   'imey' => $this->input->post('imey') ,
  9.                   'harga_beli' => $this->input->post('harga_beli') ,
  10.                   'jumlah' => $jumlah
  11.                 );
  12.     $this->mcoba->insertbarangmasuk($data);
  13.    
  14.     //cek apakah sudah ada record di barang_detail
  15.     $cek = $this->db->get_where('barang_detail', array('id_barang' => $id_barang))->num_rows();
  16.     if ($cek > 0){
  17.         //kalau sudah ada lakukan update
  18.         //biar lebih pasti, lakukan query untuk mendapatkan total jumlah barang
  19.         $row = $this->db->query("SELECT SUM(jumlah) AS total FROM barang_masuk WHERE id_barang = ?", array($id_barang))->row();
  20.         $this->db->where(array('id_barang' => $id_barang));
  21.         $this->db->update('barang_detail', array('jumlah' => $row->total));
  22.     }else{
  23.         //kalau belum ada lakukan insert
  24.         $in = array(
  25.                 'id_barang' => $id_barang,
  26.                 'id_toko' => 'G01',
  27.                 'jumlah' => $jumlah,
  28.                );
  29.         $this->mcoba->insertbarangdetail($in);
  30.     }
  31.    
  32.     redirect("coba/bm");
  33. }
Advertisement
Add Comment
Please, Sign In to add comment