SHOW:
|
|
- or go back to the newest paste.
| 1 | - | --ini model nya-- |
| 1 | + | <?php |
| 2 | // --ini model nya-- | |
| 3 | - | function av_fancpu($fancpu,$av_fancpu) {
|
| 3 | + | |
| 4 | function av_fancpu($fancpu, $av_fancpu) {
| |
| 5 | $this->db->set('qty_available_fancpu', 'qty_available_fancpu + ' . (int) $av_fancpu, FALSE);
| |
| 6 | $this->db->where('tipe_fancpu', $fancpu);
| |
| 7 | - | } |
| 7 | + | |
| 8 | } | |
| 9 | ?> | |
| 10 | - | --di view form nya-- |
| 10 | + | |
| 11 | - | //ini dropdown untuk insert (psu) |
| 11 | + | <!-- --di view form nya-- --> |
| 12 | - | <div class="form-group"> |
| 12 | + | <!-- //ini dropdown untuk insert (psu) --> |
| 13 | - | <label for="int">Merk <?php echo form_error('merk') ?></label>
|
| 13 | + | <div class="form-group"> |
| 14 | - | <select name="merk" id="merk" class="form-control"> |
| 14 | + | <label for="merk">Merk <?php echo form_error('merk') ?></label>
|
| 15 | - | <option value="">Pilih Merk</option> |
| 15 | + | <select name="merk" id="merk" class="form-control"> |
| 16 | - | <?php |
| 16 | + | <option value="">Pilih Merk</option> |
| 17 | - | $psu = $this->db->get('tbl_psu')->result();
|
| 17 | + | <?php |
| 18 | - | foreach ($psu as $row){
|
| 18 | + | $psu = $this->db->get('tbl_psu')->result();
|
| 19 | - | echo "<option value='$row->tipe_psu' "; |
| 19 | + | foreach ($psu as $row) {
|
| 20 | - | echo $row->tipe_psu==$merk?'selected':''; |
| 20 | + | echo "<option value='$row->tipe_psu' "; |
| 21 | - | echo ">". strtoupper($row->tipe_psu)."</option>"; |
| 21 | + | echo $row->tipe_psu == $merk ? 'selected' : ''; |
| 22 | - | } |
| 22 | + | echo ">" . strtoupper($row->tipe_psu) . "</option>"; |
| 23 | - | ?> |
| 23 | + | } |
| 24 | - | </select> |
| 24 | + | ?> |
| 25 | - | </div> |
| 25 | + | </select> |
| 26 | - | //ini untuk insert jumlah stok nya. |
| 26 | + | </div> |
| 27 | - | <div class="form-group"> |
| 27 | + | |
| 28 | - | <label for="varchar">Av Psu <?php echo form_error('av_psu') ?></label>
|
| 28 | + | <!-- //ini untuk insert jumlah stok nya. --> |
| 29 | - | <input type="text" class="form-control" name="av_psu" id="av_psu" placeholder="Av Psu" value="<?php echo $av_psu; ?>" /> |
| 29 | + | <div class="form-group"> |
| 30 | - | </div> |
| 30 | + | <label for="av_psu">Av Psu <?php echo form_error('av_psu') ?></label>
|
| 31 | - | </div> |
| 31 | + | <input type="text" class="form-control" name="av_psu" id="av_psu" placeholder="Av Psu" value="<?php echo $av_psu; ?>" /> |
| 32 | </div> | |
| 33 | - | //ini dropdown untuk insert nya (fancpu) |
| 33 | + | |
| 34 | - | <div class="form-group"> |
| 34 | + | <!-- //ini dropdown untuk insert nya (fancpu) --> |
| 35 | - | <label for="int">Merk <?php echo form_error('merk') ?></label>
|
| 35 | + | <div class="form-group"> |
| 36 | - | <select name="merk" id="merk" class="form-control"> |
| 36 | + | <label for="merk">Merk <?php echo form_error('merk') ?></label>
|
| 37 | - | <option value="">Pilih Merk</option> |
| 37 | + | <select name="merk" id="merk" class="form-control"> |
| 38 | - | <?php |
| 38 | + | <option value="">Pilih Merk</option> |
| 39 | - | $prc = $this->db->get('tbl_fancpu')->result();
|
| 39 | + | <?php |
| 40 | - | foreach ($prc as $row){
|
| 40 | + | $prc = $this->db->get('tbl_fancpu')->result();
|
| 41 | - | echo "<option value='$row->tipe_fancpu' "; |
| 41 | + | foreach ($prc as $row) {
|
| 42 | - | echo $row->tipe_fancpu==$merk?'selected':''; |
| 42 | + | echo "<option value='$row->tipe_fancpu' "; |
| 43 | - | echo ">". strtoupper($row->tipe_fancpu)."</option>"; |
| 43 | + | echo $row->tipe_fancpu == $merk ? 'selected' : ''; |
| 44 | - | } |
| 44 | + | echo ">" . strtoupper($row->tipe_fancpu) . "</option>"; |
| 45 | - | ?> |
| 45 | + | } |
| 46 | - | </select> |
| 46 | + | ?> |
| 47 | - | </div> |
| 47 | + | </select> |
| 48 | - | //ini untuk insert integer stok nya |
| 48 | + | </div> |
| 49 | - | <div class="form-group"> |
| 49 | + | |
| 50 | - | <label for="varchar">Av Fancpu <?php echo form_error('av_fancpu') ?></label>
|
| 50 | + | <!-- //ini untuk insert integer stok nya --> |
| 51 | - | <input type="text" class="form-control" name="av_fancpu" id="av_fancpu" placeholder="Av Fancpu" value="<?php echo $av_fancpu; ?>" /> |
| 51 | + | <div class="form-group"> |
| 52 | - | </div> |
| 52 | + | <label for="av_fancpu">Av Fancpu <?php echo form_error('av_fancpu') ?></label>
|
| 53 | <input type="text" class="form-control" name="av_fancpu" id="av_fancpu" placeholder="Av Fancpu" value="<?php echo $av_fancpu; ?>" /> | |
| 54 | </div> | |
| 55 | ||
| 56 | - | {
|
| 56 | + | <?php |
| 57 | - | $this->_rules(); |
| 57 | + | |
| 58 | public function create_action() | |
| 59 | - | if ($this->form_validation->run() == FALSE) {
|
| 59 | + | {
|
| 60 | - | $this->create(); |
| 60 | + | $this->_rules(); |
| 61 | - | } else {
|
| 61 | + | |
| 62 | - | $data = array( |
| 62 | + | if ($this->form_validation->run() == FALSE) {
|
| 63 | - | 'av_psu' => $this->input->post('av_psu',TRUE), //untuk update ke log transaksinya
|
| 63 | + | $this->create(); |
| 64 | - | 'av_fancpu' => $this->input->post('av_fancpu',TRUE),
|
| 64 | + | } else {
|
| 65 | - | ); |
| 65 | + | $data = array( |
| 66 | - | $fancpu = $this->input->post('merk', TRUE); //untuk nambah stok di tabel fancpu
|
| 66 | + | 'av_psu' => $this->input->post('av_psu', TRUE), //untuk update ke log transaksinya
|
| 67 | 'av_fancpu' => $this->input->post('av_fancpu', TRUE),
| |
| 68 | ); | |
| 69 | - | $psu = $this->input->post('merk', TRUE); //untuk nambah stok di tabel psu
|
| 69 | + | $fancpu = $this->input->post('merk', TRUE); //untuk nambah stok di tabel fancpu
|
| 70 | $av_fancpu = $this->input->post('av_fancpu', TRUE);
| |
| 71 | ||
| 72 | - | $this->M_fancpu->av_fancpu($fancpu,$av_fancpu); //model fancpu |
| 72 | + | $psu = $this->input->post('merk', TRUE); //untuk nambah stok di tabel psu
|
| 73 | - | $this->M_psu->av_psu($psu,$av_psu); //model psu |
| 73 | + | |
| 74 | - | $this->M_trans_tmbhqty->insert($data); //model log transaksinya |
| 74 | + | |
| 75 | $this->M_fancpu->av_fancpu($fancpu,$av_fancpu); //model fancpu | |
| 76 | $this->M_psu->av_psu($psu,$av_psu); //model psu | |
| 77 | $this->M_trans_tmbhqty->insert($data); //model log transaksinya |