Model

//! FUNGSI TAMBAH DATA & UPDATE BBP 
  function add_data_cutting()
  {
    $no_konsep   =    $this->security->xss_clean($this->input->post('no_konsep'));
    $nama_bb   =    $this->security->xss_clean($this->input->post('nama_bb'));
    $jmlh_pakai_roll   =    $this->security->xss_clean($this->input->post('jmlh_pakai_roll'));
    $jmlh_pakai_kg   =    $this->security->xss_clean($this->input->post('jmlh_pakai_kg'));
    $estimasi_hasil   =    $this->security->xss_clean($this->input->post('estimasi_hasil'));
    $keterangan_cutting   =    $this->security->xss_clean($this->input->post('keterangan_cutting'));
    $dibuat   =    $this->security->xss_clean($this->input->post('dibuat'));
    /** MENGHITUNG TOTAL STOK */
    // Total Stok Roll
    $sqltotalstok = $this->db->query("SELECT *,SUM(jmlh_roll) AS totalroll FROM tb_bahanbaku2 WHERE kode_bb=kode_bb GROUP BY kode_bb");
    $data = $sqltotalstok->row_array();
    $stok_roll = $data['totalroll'];
    // Total Stok KG
    $sqltotalstokkg = $this->db->query("SELECT *,SUM(jmlh_kg) AS totalkg FROM tb_bahanbaku2 WHERE kode_bb=kode_bb GROUP BY kode_bb");
    $data = $sqltotalstokkg->row_array();
    $stok_allkg = $data['totalkg'];
    /** MEMILIH STOK TABLE */
    //sql pilih stok Roll
    $sqlpilihroll = $this->db->query("SELECT * FROM tb_bahanbaku2 WHERE kode_bb=kode_bb AND jmlh_roll > 0 order by kode_bb ASC")->result_array();
    //sql pilih stok kg
    $sqlpilihkg = $this->db->query("SELECT * FROM tb_bahanbaku2 WHERE kode_bb=kode_bb AND jmlh_kg > 0 order by kode_bb ASC")->result_array();

    /** PROSES PENGURANGAN TOTAL STOK ROLL */
    if ($jmlh_pakai_kg <= $stok_allkg) {
      echo 'masuk';

      foreach ($sqlpilihkg as $roww) {
        $id_bb = $roww['id_bb'];
        $kode_bb = $roww['kode_bb'];
        $jmlh_kg = $roww['jmlh_kg'];
      }
      if ($jmlh_pakai_kg > 0) {
        // buat var $temp sbg. pengurang Jumlah KG
        $temp = $jmlh_pakai_kg;

        //proses pengurangan kg
        $jmlh_pakai_kg = $jmlh_pakai_kg - $jmlh_kg;
        $jmlh_kg - $temp;

        if ($jmlh_pakai_kg > 0) {
          $stok_updatekg = 0;
          $stok_updatekg1 = $jmlh_kg;
        } else {
          $stok_updatekg = $jmlh_kg - $temp;
          $stok_updatekg1 = $temp;
        }
        $this->db->set('jmlh_roll', $stok_updatekg);
        $this->db->where('kode_bb', $kode_bb);
        $this->db->update('tb_bahanbaku2');
      }

      $data3 = array(
        'no_konsep' => $no_konsep,
        'nama_bb' => $nama_bb,
        'jmlh_roll' => $jmlh_pakai_roll,
        'jmlh_kg' => $jmlh_pakai_kg,
        'estimasi_hasil' => $estimasi_hasil,
        'keterangan_cutting' => $keterangan_cutting,
        'dibuat' => $dibuat,
        'status' => 'OPEN'

      );
      $this->db->insert('tb_subcutting', $data3);
    } else {
      echo 'gagal';
    }

    return $this->db->affected_rows();
  }