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']; }