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
}
