public function proses()
{
$setting_model = new Setting_model();
$data = array();
$data['idsharingproduct'] = $setting_model->_getId('sharingproduct');
$data['idrefbarang'] = $this->input->post('idrefbarang');
$data['jumlah_barang'] = $this->input->post('jumlah_barang');
$data['idrefstore_pengirim'] = $_SESSION['user']['idrefstore'];
$data['idrefstore_penerima'] = $this->input->post('idrefstore_penerima');
$data['status_konfirmasi'] = 'N';
$data['tanggal_kirim'] = Tanggal::sqlDate($this->input->post('tanggal_kirim'));
$sharingproduct = $this->orm->sharingproduct();
$ress = $sharingproduct->insert($data);
Message::_set(isset($ress['idsharingproduct']) ? TRUE : FALSE, 'Berhasil', 'Gagal');
redirect('sharing/sharing');
}
function cetakPDF($tanggal_dari, $tanggal_sampai, $idRefBarang1 = 0)
{
ini_set('memory_limit', '512M');
$this->output->enable_profiler(FALSE);
$this->load->library('TCPDF');
$stock = new stock_model();
$store = $this->orm->refstore->where('idrefstore', $_SESSION['user']['idrefstore'])->fetch();
$image_store = ($store['image_file'] == "" or $store['image_file'] == NULL) ? "./front_assets/img/bizon_inventory.jpg" : "./uploads/stores/" . $store['image_file'];
if ($idRefBarang1 != 0) {
$data = $stock->_loadMutasiStock($tanggal_dari, $tanggal_sampai, $idRefBarang1);
} else {
$data = $stock->_loadMutasiStock($tanggal_dari, $tanggal_sampai);
}
// print_r(json_encode($data)); exit;
// create new PDF document
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, 'A4', true, 'UTF-8', false);
// set document information
$pdf->SetCreator(WEB_TITLE);
$pdf->SetAuthor($this->session->userdata('username'));
$pdf->SetTitle("Laporan Surat Jalan");
$pdf->SetSubject('Laporan Surat Jalan');
$pdf->tanggal_dari = $tanggal_dari;
$pdf->tanggal_sampai = $tanggal_sampai;
// set header and footer fonts
$pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
//set margins
$pdf->SetMargins(5, 10, 5);
$pdf->SetHeaderMargin(5);
$pdf->SetFooterMargin(5);
//set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
//set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
// ---------------------------------------------------------
// set default font subsetting mode
$pdf->setFontSubsetting(true);
// Set font
// dejavusans is a UTF-8 Unicode font, if you only need to
// print standard ASCII chars, you can use core fonts like
// helvetica or times to reduce file size.
// use the font
$pdf->SetFont("Times", '', 11, '', false);
// Add a page
// This method has several options, check the source code documentation for more information.
$pdf->AddPage('L');
// Set some content to print
$html = '
<body> ';
$no = 1;
$html .= '
<table><tr><td>
<h3>Daftar Delivery Order - ' . $store['nama'] . '</h3>
</td><td style="text-align:right">
<img src="' . $image_store . '" width="150"><br/></td></tr></table>
<table width="100%">
<tr>
<td width="100%" style="text-align: center; vertical-align:text-top;"><h2>LAPORAN MUTASI STOCK</h2>
<p><b>PERIODE : ' . Tanggal::formatDate(Tanggal::sqlDate($tanggal_dari)) . ' s/d ' . Tanggal::formatDate(Tanggal::sqlDate($tanggal_sampai)) . '</b></p>
</td>
</tr>
</table>
<table cellpadding="5" cellspacing="1" class="border" border="1" width="100%">
<tr style="text-align:center"><td width="70">No</td><td width="400">Nama Barang</td><td width="90">Stock Awal</td><td width="90">Barang Masuk</td><td width="90">Barang Keluar</td><td width="90">Saldo</td><td width="100">Satuan</td></tr>
';
if (!empty($data)) {
foreach ($data as $row) {
$idrefbarang = $row['idrefbarang'];
$row['jumlahKirim'] = $stock->_getJumlahKirim($idrefbarang, $tanggal_dari, $tanggal_sampai);
$row['jumlahTerima'] = $stock->_getJumlahTerima($idrefbarang, $tanggal_dari, $tanggal_sampai);
// $saw = $master->_getSaldoAwalBarang($idBarang, $tanggal_dari, $tanggal_sampai, $row['idTransaksiBarang']);
$kirim = $row['jumlahKirim'] == null ? 0 : $row['jumlahKirim'];
$terima = $row['jumlahTerima'] == null ? 0 : $row['jumlahTerima'];
$saldo = $row['stockawal'];
$saldo = $saldo + $terima;
$saldo = $saldo - $kirim;
$html .= '<tr>' . '<td class="border" style="text-align: center;" > ' . $no . ' </td>' . '<td class="border" style="text-align: left;"> ' . $row['namabarang'] . '</td>' . '<td class="border" style="text-align: right;"> ' . $row['stockawal'] . ' </td>' . '<td class="border" style="text-align: right;"> ' . $terima . ' </td>' . '<td class="border" style="text-align: right;"> ' . $kirim . '</td>' . '<td class="border" style="text-align: right;"> ' . $saldo . '</td>' . '<td class="border" style="text-align: right;"> ' . $row['namasatuan'] . '</td></tr>';
$no++;
}
}
$html .= '</table>';
$html .= '<br/> <br/> <br/> <hr/> <div style="text-align: center"> Akhir Laporan </div> </body>';
//print_r($html); exit;
// Print text using writeHTMLCell()
$pdf->writeHTMLCell($w = 0, $h = 0, $x = '', $y = '', $html, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = '', $autopadding = true);
// ---------------------------------------------------------
// Close and output PDF document
// This method has several options, check the source code documentation for more information.
$pdf->Output("Laporan Mutasi Stock {$tanggal_dari} _ {$tanggal_sampai}.pdf", 'I');
//============================================================+
// END OF FILE
//============================================================+
}
public function proses($idpengadaan = null)
{
Account::_valLogin();
$setting_model = new Setting_model();
$transaksi_model = new Transaksi_model();
$this->orm->debug = true;
$data = array();
$data['idpengadaan'] = $idpengadaan == null ? $setting_model->_getMaxId('idpengadaan', 'pengadaan') : $idpengadaan;
$data['nomorpengadaan'] = $this->input->post('nomorpengadaan', true);
$data['tanggalpengadaan'] = Tanggal::sqlDate($this->input->post('tanggalpengadaan', true));
$data['nomorreff'] = $this->input->post('nomorreff', true);
$data['idsupplier'] = $this->input->post('idsupplier', true);
$data['insertby'] = $_SESSION['user']['email'];
$data['idrefstore'] = $_SESSION['user']['idrefstore'];
$data['flag_app'] = "WEB";
if ($idpengadaan == null) {
$idpengadaan = $data['idpengadaan'];
$pengadaan = $this->orm->pengadaan();
$ress = $pengadaan->insert($data);
Message::_set(isset($ress['idpengadaan']) ? TRUE : FALSE, 'Tambah Data Barang Berhasil', 'Tambah Data Barang Gagal');
$redirect = 'transaksi/pengadaan';
} else {
$pengadaan = $this->orm->pengadaan->where('idpengadaan', $idpengadaan);
$ress = $pengadaan->update($data);
Message::_set($idpengadaan != null ? TRUE : FALSE, 'Edit Data Barang Berhasil', 'Edit Data Barang Gagal');
$redirect = 'transaksi/pengadaan/edit/' . $idpengadaan;
}
$this->orm->pengadaandetail->where('idpengadaan', $idpengadaan)->delete();
$this->orm->transaksibarang->where('idpengadaan', $idpengadaan)->delete();
$idRefBarang = $this->input->post('idrefbarang');
$idRefGudang = $this->input->post('idrefgudang');
$jumlahBarang = $this->input->post('jumlahbarang');
$keterangan = $this->input->post('keterangan');
foreach ($idRefBarang as $key => $value) {
$dataDetilBarang = array();
$dataDetilBarang['idpengadaandetail'] = $setting_model->_getMaxId('idpengadaandetail', 'pengadaandetail');
$dataDetilBarang['idpengadaan'] = $idpengadaan;
$dataDetilBarang['idrefbarang'] = $idRefBarang[$key];
$dataDetilBarang['idrefgudang'] = $idRefGudang[$key];
$dataDetilBarang['jumlahbarang'] = $jumlahBarang[$key];
$dataDetilBarang['keterangan'] = $keterangan[$key];
if ($dataDetilBarang['idrefbarang'] != 0) {
$result = $this->orm->pengadaandetail->insert($dataDetilBarang);
$idPengadaanDetail = $result['idpengadaandetail'];
$dataTransaksiBarang = array();
$dataTransaksiBarang['idtransaksibarang'] = $setting_model->_getMaxId('idtransaksibarang', 'transaksibarang');
$dataTransaksiBarang['transaksi'] = 'TERIMA';
$dataTransaksiBarang['tanggaltransaksi'] = Tanggal::sqlDate($this->input->post('tanggalpengadaan'));
$dataTransaksiBarang['idpengadaandetail'] = $idPengadaanDetail;
$dataTransaksiBarang['iddeliveryorderdetail'] = 0;
$dataTransaksiBarang['idpengadaan'] = $idpengadaan;
$this->orm->transaksibarang->insert($dataTransaksiBarang);
}
}
$transaksi_model->proccessBarangMasuk($idpengadaan);
redirect($redirect);
}
public function update($idquotationsales = null)
{
$setting_model = new Setting_model();
$this->orm->debug = true;
$dataUpdateQuotation = array('nomor' => $this->input->post('nomor', true), 'dibuat_oleh' => $this->input->post('dibuat_oleh', true), 'tanggal' => Tanggal::sqlDate($this->input->post('tanggal', true)), 'idpelanggan' => $this->input->post('idpelanggan', true), 'idrefjenispembayaran' => $this->input->post('idrefjenispembayaran', true), 'status' => 'KIRIM', 'insertby' => $_SESSION['user']['email'], 'idrefstore' => $_SESSION['user']['idrefstore'], 'idrefstatus' => 1);
$this->quotationsales->update($idquotationsales, $dataUpdateQuotation);
$idrefbarang = $this->input->post('idrefbarang');
$jumlahbarang = $this->input->post('jumlahbarang');
$hargasatuan = $this->input->post('hargasatuan');
$keterangan = $this->input->post('keterangan');
$idquotationsalesdetail = $this->input->post('idquotationsalesdetail');
foreach ($idrefbarang as $key => $value) {
$dataUpdateQuotationDetail = array('jumlahbarang' => $jumlahbarang[$key], 'hargasatuan' => $hargasatuan[$key], 'keterangan' => trim($keterangan[$key]));
$this->quotationsalesdetail->update($idquotationsalesdetail[$key], $dataUpdateQuotationDetail);
}
$redirect = 'quotation/quotation';
redirect($redirect);
}
public function _getJumlahTerima($idrefbarang, $dari, $sampai)
{
$dari = Tanggal::sqlDate($dari);
$sampai = Tanggal::sqlDate($sampai);
$sql = "select SUM(jumlahbarang) as jumlahterima from pengadaandetail a LEFT JOIN transaksibarang b ON (a.idpengadaandetail = b.idpengadaandetail)" . "where idrefbarang = {$idrefbarang} AND " . '(tanggaltransaksi BETWEEN ' . "'" . $dari . "'" . ' AND ' . "'" . $sampai . "'" . ' OR tanggaltransaksi BETWEEN ' . "'" . $dari . "'" . ' AND ' . "'" . $sampai . "'" . ' )';
$ress = $this->db->query($sql)->row_array();
return $ress['jumlahterima'];
}
