<?php
// --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="merk">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="av_psu">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>

<!-- //ini dropdown untuk insert nya (fancpu) -->
<div class="form-group">
  <label for="merk">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="av_fancpu">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>

<?php
--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