function add() { permissionUser(); $gudang = $this->input->post('gudang_id'); //print_mz($this->input->post('deskripsi')); $list = array('list_id' => $this->input->post('list'), 'jumlah' => $this->input->post('jumlah'), 'satuan' => $this->input->post('satuan'), 'jumlah_po' => $this->input->post('jumlah_po'), 'kode_barang' => $this->input->post('brg'), 'deskripsi' => $this->input->post('deskripsi'), 'catatan' => $this->input->post('catatan')); $data = array('no' => $this->input->post('no'), 'ref_type' => $this->input->post('ref_type'), 'ref_id' => $this->input->post('ref_id'), 'ref' => GetValue('po', 'purchase_order', array('id' => 'where/' . $this->input->post('ref'))), 'gudang_to' => $gudang, 'tgl' => date('Y-m-d', strtotime($this->input->post('tgl'))), 'keterangan' => $this->input->post('keterangan'), 'created_on' => date("Y-m-d"), 'created_by' => sessId()); $this->db->insert($this->module . '_' . $this->file_name, $data); $insert_id = $this->db->insert_id(); $sisaan = 0; for ($i = 1; $i <= sizeof($list['kode_barang']); $i++) { $barang = $list['kode_barang'][$i]; $qty = $list['jumlah'][$i]; $satuan = $list['satuan'][$i]; $hasil = konversi($barang, $qty, $satuan); $sisa = $list['jumlah_po'][$i] - $hasil; $data2 = array($this->file_name . '_id' => $insert_id, 'order_id' => $this->input->post('ref_id'), 'list_id' => $list['list_id'][$i], 'barang_id' => $list['kode_barang'][$i], 'deskripsi' => $list['deskripsi'][$i], 'catatan' => $list['catatan'][$i], 'jumlah' => str_replace(',', '', $list['jumlah'][$i]), 'satuan_id' => $list['satuan'][$i], 'sisa' => $sisa); $this->db->insert($this->module . '_' . $this->file_name . '_list', $data2); $sisaan = +$sisa; masukstok($gudang, $list['kode_barang'][$i], str_replace(',', '', $list['jumlah'][$i]), $data2['satuan_id'], $data['ref_type'], $data['ref_id'], $data['tgl'], $data['ref']); $this->insert_po_status($this->input->post('ref_id')); } //echo $sisaan; $this->send_notification($insert_id); if ($sisaan == 0) { $this->db->query("UPDATE purchase_order SET is_closed=1 WHERE id='" . $this->input->post('ref_id') . "'"); } redirect($this->module . '/' . $this->file_name, 'refresh'); }
<td><?php echo $k->tanggal; ?> </td> <td> <img src="<?php echo asset_url('uploads/' . $k->foto); ?> " width="200px" height="200px"> </td> <td><?php echo $k->deskripsi; ?> </td> <td><?php echo konversi('status_kerusakan', $k->status); ?> </td> <td> <!-- pegawai kantor --> <?php if ($this->session->userdata('status') == 5) { ?> <?php if ($k->id_prasarana == '') { ?> <a href="<?php echo site_url('kerusakan/edit_prasarana/' . $k->id); ?> " class="btn btn-flat btn-info">Masukan ke Prasarana</a> <?php
function add() { permissionUser(); $id = $this->input->post('id'); $is_update = $this->input->post('is_update'); $list = array('list_id' => $this->input->post('list'), 'jumlah' => $this->input->post('jumlah'), 'satuan' => $this->input->post('satuan'), 'jumlah_po' => $this->input->post('jumlah_po'), 'ref_id' => $this->input->post('idtrx'), 'kode_barang' => $this->input->post('brg'), 'deskripsi' => $this->input->post('deskripsi'), 'catatan' => $this->input->post('catatan_barang')); $data = array('no' => $this->input->post('no'), 'ref' => '', 'ref_type' => 'sales_order', 'kontak_id' => $this->input->post('kontak_id'), 'alamat' => $this->input->post('alamat'), 'ref_id' => $is_update == 0 ? implode(',', $this->input->post('ref_id')) : $this->input->post('ref_id'), 'tgl' => date('Y-m-d', strtotime($this->input->post('tgl'))), 'gudang_to' => $this->input->post('gudang_id'), 'driver' => $this->input->post('driver'), 'plat' => $this->input->post('plat'), 'keterangan' => $this->input->post('catatan'), 'created_on' => date("Y-m-d"), 'created_by' => sessId()); if ($is_update == 0) { $this->db->insert($this->module . '_' . $this->file_name, $data); $insert_id = $this->db->insert_id(); } else { $this->db->where('id', $id)->update($this->module . '_' . $this->file_name, $data); $insert_id = $id; $this->db->delete($this->module . '_' . $this->file_name . '_list', array('pengeluaran_id' => $id)); } $sisaan = 0; $ref = ''; for ($i = 0; $i < sizeof($list['kode_barang']); $i++) { $qtysisa = konversi($list['kode_barang'][$i], $list['jumlah'][$i], $list['satuan'][$i]); $sisa = $list['jumlah_po'][$i] - $qtysisa; if (!isset($ref[$list['ref_id'][$i]])) { $ref[$list['ref_id'][$i]] = 0; } else { $ref[$list['ref_id'][$i]] = +$sisa; } $data2 = array($this->file_name . '_id' => $insert_id, 'ref_type' => $data['ref_type'], 'order_id' => $list['ref_id'][$i], 'ref' => GetValue('so', 'sales_order', array('id' => 'where/' . $list['ref_id'][$i])), 'list_id' => $list['list_id'][$i], 'barang_id' => $list['kode_barang'][$i], 'deskripsi' => $list['deskripsi'][$i], 'catatan' => $list['catatan'][$i], 'jumlah' => str_replace(',', '', $list['jumlah'][$i]), 'satuan_id' => $list['satuan'][$i], 'sisa' => $sisa); $this->db->insert($this->module . '_' . $this->file_name . '_list', $data2); $sisaan = +$sisa; //if($sisaan==0){$this->db->query("UPDATE sales_order SET is_closed=1 WHERE id='".$this->input->post('ref_id')."'");} keluarstok($this->input->post('gudang_id'), $list['kode_barang'][$i], str_replace(',', '', $list['jumlah'][$i]), $data2['satuan_id'], $data['ref_type'], $list['ref_id'][$i], $data['tgl'], $data['ref']); $this->insert_so_status($list['ref_id'][$i]); } //echo $sisaan; //foreach($ref as $key=>$val){ //if($val==0){$this->db->query("UPDATE sales_order SET is_closed=1 WHERE id='".$key."'");} //} $this->send_notification($insert_id); redirect($this->module . '/' . $this->file_name, 'refresh'); }
?> <tr> <td><?php echo $k->nama; ?> </td> <td><?php echo $k->alamat; ?> </td> <td><?php echo $k->email; ?> </td> <td><?php echo konversi('status_pengguna', $k->status); ?> </td> <td> <button class="btn btn-sm btn-info btn-flat" onclick="EditKaryawan(<?php echo $k->id; ?> )">Edit</button> <button class="btn btn-sm btn-danger btn-flat" onclick="deleteFunc(<?php echo $k->id; ?> )">Delete</button> </td> </tr> <?php }