ASK

--ini model nya--
// untuk update stok (fancpu) koding nya sama dengan update stok PSU
    function av_fancpu($fancpu,$av_fancpu) {
    $this->db->set('qty_available_fancpu', 'qty_available_fancpu + ' . (int) $av_fancpu, FALSE);
    $this->db->where('tipe_fancpu', $fancpu);
    $this->db->update('tbl_fancpu');
    }


--di view form nya--
//ini dropdown untuk insert (psu)
          <div class="form-group">
          <label for="int">Merk <?php echo form_error('merk') ?></label>
            <select name="merk" id="merk" class="form-control">
                <option value="">Pilih Merk</option>
                <?php
                    $psu = $this->db->get('tbl_psu')->result();
                    foreach ($psu as $row){
                    echo "<option value='$row->tipe_psu' ";
                    echo $row->tipe_psu==$merk?'selected':'';
                    echo ">".  strtoupper($row->tipe_psu)."</option>";
                    }
                ?>
            </select>
      </div>
//ini untuk insert jumlah stok nya.
          <div class="form-group">
            <label for="varchar">Av Psu <?php echo form_error('av_psu') ?></label>
            <input type="text" class="form-control" name="av_psu" id="av_psu" placeholder="Av Psu" value="<?php echo $av_psu; ?>" />
          </div>
        </div>

//ini dropdown untuk insert nya (fancpu)
      <div class="form-group">
          <label for="int">Merk <?php echo form_error('merk') ?></label>
            <select name="merk" id="merk" class="form-control">
                <option value="">Pilih Merk</option>
                <?php
                    $prc = $this->db->get('tbl_fancpu')->result();
                    foreach ($prc as $row){
                    echo "<option value='$row->tipe_fancpu' ";
                    echo $row->tipe_fancpu==$merk?'selected':'';
                    echo ">".  strtoupper($row->tipe_fancpu)."</option>";
                    }
                ?>
            </select>
      </div>
//ini untuk insert integer stok nya
      <div class="form-group">
            <label for="varchar">Av Fancpu <?php echo form_error('av_fancpu') ?></label>
            <input type="text" class="form-control" name="av_fancpu" id="av_fancpu" placeholder="Av Fancpu" value="<?php echo $av_fancpu; ?>" />
        </div>

--Controller nya--
public function create_action()
    {
        $this->_rules();

        if ($this->form_validation->run() == FALSE) {
            $this->create();
        } else {
            $data = array(
        'av_psu' => $this->input->post('av_psu',TRUE),              //untuk update ke log transaksinya
        'av_fancpu' => $this->input->post('av_fancpu',TRUE),
    );
        $fancpu = $this->input->post('merk', TRUE);                 //untuk nambah stok di tabel fancpu
        $av_fancpu = $this->input->post('av_fancpu', TRUE);

        $psu = $this->input->post('merk', TRUE);                    //untuk nambah stok di tabel psu
        $av_psu = $this->input->post('av_psu', TRUE);

        $this->M_fancpu->av_fancpu($fancpu,$av_fancpu);             //model fancpu
        $this->M_psu->av_psu($psu,$av_psu);                         //model psu
        $this->M_trans_tmbhqty->insert($data);                      //model log transaksinya