$a->SetAligns(array("C", "L", "C", "R", "R")); $a->SetFillColor(225, 225, 225); /* $kol=$zn->Count('stokopname',$nfile); $a->Cell(10,8,'No.',1,0,'C',true); for ($i=1;$i<=$kol;$i++){ $d=explode(',',$zn->rContent('stokopname',"$i",$nfile)); $a->Cell($d[9],8,$d[0],1,0,'C',true); } $a->Ln();*/ $a->SetFont('Arial', '', 10); // $rec = $temp_rec->result(); $n = 0; foreach ($temp_rec as $r) { $n++; $a->Row(array($n, $r->Nama_Barang, $r->Satuan, '', '')); // } $a->Ln(5); $a->Cell(50, 8, 'Counting by', 0, 0, 'C'); $a->Ln(20); $a->Cell(50, 8, '(______________________)', 0, 0, 'C'); $a->Output('application/logs/' . $this->session->userdata('userid') . '_countsheet.pdf', 'F'); $path = 'application/views/_laporan'; $img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>"; link_js('lap_beli.js,jquery.fixedheader.js', $path . '/js,asset/js'); panel_begin('Print Preview', '', 'Back' . $img); ?> <iframe src="<?php echo base_url(); ?>
$harga = 0; $hgb = 0; $hargaj = 0; $ppn = 0; $tppn = 0; $opr = 0; $lab = 0; $kotor = 0; // print_r($temp_rec); foreach ($temp_rec as $r) { $n++; $opr = rdb('mst_kas_trans', 'jumlah', 'sum(jumlah) as jumlah', "where tgl_trans='" . $r->Tanggal . "' group by tgl_trans"); $kotor = $pajak == 'ok' ? $r->Jual - $r->Harga_Beli - ($r->Jual - $r->Harga_Beli) * $pajake : $r->Jual - $r->Harga_Beli; $ppn = $pajak == 'ok' ? $kotor * 10 / 100 : 0; $lab = $kotor - $opr - $ppn; $a->Row(array($n, tglfromSql($r->Tanggal), number_format(round($kotor, -2), 2), number_format((int) $opr, 2), number_format($ppn, 2), number_format($lab, 2))); //sub tlot $tppn = $tppn + $ppn; $harga = $harga + round($kotor, -2); //($r->Jual-$r->Harga_Beli)); $hgb = $hgb + $opr; $hargaj = $hargaj + $lab; } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225); $a->Cell(40, 8, "TOTAL", 1, 0, 'R', true); $a->Cell(30, 8, number_format($harga, 2), 1, 0, 'R', true); $a->Cell(30, 8, number_format($hgb, 2), 1, 0, 'R', true); $a->Cell(25, 8, number_format($tppn, 2), 1, 0, 'R', true); $a->Cell(30, 8, number_format($hargaj, 2), 1, 1, 'R', true); /* $a->Cell(140,8,"SALDO",1,0,'R',true);
$a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi $a->SetWidths(array(10, 25, 15, 25, 112, 32, 32, 25)); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "C", "C", "C", "L", "R", "R", "R", "R")); $a->SetFont('Arial', 'B', 10); //$a->Ln(1); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $s_pokok = 0; $s_wajib = 0; $s_kusus = 0; foreach ($temp_rec as $r) { $n++; $a->Row(array($n, tglfromSql($r->Tanggal), rdb('unit_jurnal', 'unit', 'unit', "where ID='" . $r->ID_Unit . "'"), $r->Nomor, $r->Ket, number_format($r->Debet, 2), number_format($r->Kredit, 2), number_format($r->Debet - $r->Kredit, 2))); $s_pokok = $s_pokok + $r->Debet; $s_wajib = $s_wajib + $r->Kredit; } /**/ $a->SetFont('Arial', 'B', 9); $a->SetFillColor(225, 225, 225); $a->Cell(187, 8, "TOTAL", 1, 0, 'R', true); $a->Cell(32, 8, number_format($s_pokok, 2), 1, 0, 'R', true); $a->Cell(32, 8, number_format($s_wajib, 2), 1, 0, 'R', true); $a->Cell(25, 8, number_format($s_pokok - $s_wajib, 2), 1, 0, 'R', true); $a->Output('application/logs/' . $this->session->userdata('userid') . '_jurnal.pdf', 'F'); //show pdf output in frame $path = 'application/views/_laporan'; $img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>"; link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js');
$a->SetWidths($detail == '' ? array(10, 20, 22, 60, 30, 40) : array(10, 20, 20, 50, 22, 18, 25, 27)); // set align tiap kolom tabel transaksi $a->SetAligns($detail == '' ? array("C", "C", "C", "L", "R", "L") : array("R", "C", "C", "L", "R", "L", "R", "R")); $a->SetFont('Arial', 'B', 10); $a->SetFont('Arial', '', 9); $dataz = array(); $n = 0; $harga = 0; $hargaj = 0; $jml = 0; $hgb = 0; foreach ($temp_rec as $r) { $n++; $nn = 0; if ($detail == '') { $a->Row(array($n, tglfromSql($r->Tanggal), $r->Nomor, ucwords($r->Nama), number_format($r->Harga_Beli, 2), $r->Jenis_Beli)); } else { if ($detail == 'detail') { //laproan detail pembelian $a->SetFont('Arial', 'B', 9); $a->SetFillColor(210, 210, 010); $a->Cell(10, 8, $n, 1, 0, 'C', true); $a->Cell(90, 8, $r->Nama, 1, 0, 'L', true); $a->Cell(65, 8, $r->Catatan . " " . $r->Alamat . " " . $r->Kota, 1, 0, "L", true); $a->Cell(27, 8, '', 1, 1, 'R', true); $a->SetFont('Arial', '', 9); $ID_P = " and p.ID_Pemasok='" . $r->ID_Pemasok . "'"; $dataz = $this->kasir_model->detail_trans_beli($where, $ID_P, $orderby); foreach ($dataz as $r2) { $nn++; $a->Row(array($nn, tglfromSql($r2->Tanggal), $r2->Nomor, ucwords($r2->Nama_Barang), number_format($r2->Jumlah, 2), $r2->Satuan, number_format($r2->Harga_Beli, 2), number_format($r2->Harga_Beli * $r2->Jumlah, 2)));
// set lebar tiap kolom tabel transaksi // $a->SetWidths(array(10,25,60,20,15,25)); $a->SetWidths(array(10, 28, 52, 25, 15, 20, 20, 15)); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "C", "L", "L", "R", "L", "R", "L")); $a->SetFont('Arial', 'B', 10); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; $hgb = 0; $hargaj = 0; $jml = 0; foreach ($temp_rec as $r) { $n++; $a->Row(array($n, strtoupper($r->Kode), ucwords(strtolower($r->Nama_Barang)), rdb('inv_barang_kategori', 'Kategori', 'Kategori', "where ID='" . $r->ID_Kategori . "'"), number_format($r->stock, 0), rdb('inv_barang_satuan', 'Satuan', 'Satuan', "where ID='" . $r->ID_Satuan . "'"), number_format($r->harga_beli, 2), $r->Status)); } $a->Output('application/logs/' . $this->session->userdata('userid') . '_mutasi.pdf', 'F'); //show pdf output in frame $path = 'application/views/laporan'; $img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>"; link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js'); panel_begin('Print Preview', '', 'Back' . $img); ?> <iframe src="<?php echo base_url(); ?> application/logs/<?php echo $this->session->userdata('userid'); ?> _mutasi.pdf" height="100%" width="100%" frameborder="0" allowtransparency="1" style="z-index:100"></iframe>
$a->setFilename('asset/bin/zetro_master.frm'); $a->AliasNbPages(); $a->AddPage("P", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi // set align tiap kolom tabel transaksi $a->SetWidths(array(10, 22, 78, 30, 30)); $a->SetAligns(array("C", "C", "L", "R", "R")); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $kredit = 0; $debit = 0; foreach ($temp_rec->result_object() as $r) { $n++; $a->Row(array($n, tglfromSql($r->tgl), $r->no_trans == '' ? $r->uraian : $r->uraian . " reff :" . $r->no_trans, number_format($r->kredit, 2), number_format($r->debit, 2))); //sub tlot $kredit = $kredit + $r->kredit; $debit = $debit + $r->debit; } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225); $a->Cell(110, 8, "TOTAL", 1, 0, 'R', true); $a->Cell(30, 8, number_format($kredit, 2), 1, 0, 'R', true); $a->Cell(30, 8, number_format($debit, 2), 1, 0, 'R', true); $a->ln(); $a->Cell(140, 8, "Saldo Kas", 1, 0, 'R', true); $a->Cell(30, 8, number_format($kredit - $debit, 2), 1, 0, 'R', true); $a->Output('application/logs/' . $this->session->userdata('userid') . '_laporan_beli.pdf', 'F'); //show pdf output in frame $path = 'application/views/laporan';
//echo $a->getColWidth(); // set lebar tiap kolom tabel transaksi $a->SetWidths(array(10, 70, 60, 15, 30)); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "L", "L", "C", "R")); $a->SetFont('Arial', 'B', 10); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; $hgb = 0; $hargaj = 0; $jml = 0; foreach ($temp_rec as $r) { $n++; $a->Row(array($n, $r->Nama, rdb('mst_departemen', 'Departemen', 'Departemen', "where ID='" . $r->ID_Dept . "'"), $r->Cicilan, number_format($r->Total, 2))); //sub tlot $harga = $harga + $r->Total; } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225); $a->Cell(155, 8, "TOTAL", 1, 0, 'R', true); $a->Cell(30, 8, number_format($harga, 2), 1, 0, 'R', true); $a->Output('application/logs/' . $this->session->userdata('userid') . '_rekap_penjualan.pdf', 'F'); //show pdf output in frame $path = 'application/views/laporan'; $img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>"; link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js'); panel_begin('Print Preview', '', 'Back' . $img); ?> <iframe src="<?php
$a->SetFont('Arial', '', 10); $a->SetWidths(array(100, 30, 30)); // set lebar tiap kolom tabel transaksi $a->SetAligns(array("L", "R", "R")); // set align tiap kolom tabel transaksi $a->SetFont('Arial', 'B', 10); $data = array(); $n = 0; $ax = 0; $k = 0; $saldo = 0; $where = $sampai == '' ? "where tgl_kas='" . tgltoSql($dari) . "'" : "where tgl_kas between '" . tgltoSql($dari) . "' and '" . tgltoSql($sampai) . "'"; foreach ($temp_rec as $r) { $n++; $tot = 0; $r->ID == 5 ? '' : $a->Row(array($r->Kode . '.' . $r->Nama_Kas), false); $data = $this->report_model->lap_sub_cash($r->ID); $a->SetFont('Arial', '', 10); foreach ($data as $row) { $valued = 0; if ($row->ID_CC == 0) { $valued = rdb('mst_kas_harian', 'saldo', 'sum(sa_kas) as saldo', $where . " group by tgl_kas"); $tot = rdb('mst_kas_harian', 'saldo', 'sum(sa_kas) as saldo', $where . " group by tgl_kas"); } else { if ($row->ID_CC != 4) { $datax = $this->report_model->get_cash_flow($row->ID_CC, $dari, $sampai); foreach ($datax as $d) { $valued = $d->Total; $tot = $tot + $d->Total; } if ($row->ID_Calc == 1) {
//$rec = $temp_rec->result(); $n = 0; $harga = 0; $hgb = 0; $hargaj = 0; $terima = 0; foreach ($temp_rec as $r) { $n++; $dibayar = 0; $tobayar = 0; $terima = 0; $des = $r->Deskripsi != '' ? " No.: " . $r->ID_Post . " " . $r->Deskripsi . " [ " . tglfromSql($r->Tgl_Cicilan) . " ]" : ''; $terima = rdb('pinjaman_bayar', 'totalbayar', 'sum(kredit) as totalbayar', "where id_pinjaman='" . $r->NoUrut . "' and year(tanggal)='" . substr($r->Tanggal, 0, 4) . "'"); //$tobayar=rdb('inv_pembayaran','total_bayar','sum(total_bayar) as total_bayar',"where /*no_transaksi='".$r->NoUrut."' and*/ date(doc_date)='".$r->Tanggal."' and ID_Jenis='".$r->ID_Jenis."' group by concat(ID_Jenis,date(doc_date))"); //$terima=(($dibayar-$tobayar)>0)?(int)$dibayar:(int)$tobayar; $a->Row(array($n, $r->Nomor, tglfromSql($r->Tanggal), number_format($r->tBayar, 2), number_format($r->diBayar + $terima, 2), rdb('inv_penjualan_jenis', 'Jenis_Jual', 'Jenis_Jual', "where ID='" . $r->ID_Jenis . "'") . $des)); //sub tlot $harga = $harga + $r->tBayar; $hargaj = $hargaj + ($r->diBayar + $terima); } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225); $a->Cell(55, 8, "TOTAL", 1, 0, 'R', true); $a->Cell(30, 8, number_format($harga, 2), 1, 0, 'R', true); $a->Cell(30, 8, number_format($hargaj, 2), 1, 0, 'R', true); $a->Cell(75, 8, '', 1, 1, 'R', true); /* $a->Cell(140,8,"SALDO",1,0,'R',true); $a->Cell(30,8,number_format(($harga-$hargaj),2),1,0,'R',true); */ $a->Output('application/logs/' . $this->session->userdata('userid') . '_kas_masuk.pdf', 'F'); //show pdf output in frame
// set align tiap kolom tabel transaksi $width = ''; $jml_record = $zn->Count($a->getSection(), $a->getFilename()); for ($i = 1; $i <= $jml_record; $i++) { $d = explode(',', $zn->rContent($a->getSection(), $i, $a->getFilename())); $width .= $d[9] . ","; } $a->SetWidths(array(10, 20, 25, 35, 75, 20, 18, 22, 30)); $a->SetAligns(array("C", "L", "L", "L", "L", "R", "C", "C", "R")); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; foreach ($temp_rec->result_object() as $r) { $n++; $a->Row(array($n, $r->nm_jenis, $r->nm_kategori, $r->nm_golongan, $r->nm_barang, number_format($r->stock, 2), $r->nm_satuan, tglfromSql($r->expired), number_format($r->stock * $r->harga_beli, 2))); //sub tlot $harga = $harga + $r->stock * $r->harga_beli; } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225); $a->Cell(225, 8, "TOTAL", 1, 0, 'R', true); $a->Cell(30, 8, number_format($harga, 2), 1, 0, 'R', true); $a->Output('application/logs/' . $this->session->userdata('userid') . '_laporan_beli.pdf', 'F'); //show pdf output in frame $path = 'application/views/laporan'; $img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>"; link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js'); panel_begin('Print Preview', '', 'Back' . $img); ?> <iframe src="<?php
$lebar = width_kol_pdf('pemakaian', $nfile); echo $lebar; $a->SetWidths(array(10, 20, 30, 60, 20, 20, 25, 30, 60)); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "C", "C", "L", "L", "R", "R", "R", "L")); $a->SetFont('Arial', 'B', 10); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; $hgb = 0; $hargaj = 0; $jml = 0; foreach ($temp_rec as $r) { $n++; $a->Row(array($n, tglfromSql($r->Tanggal), rdb('inv_barang', 'Kode', 'Kode', "where ID='" . $r->ID_Barang . "'"), rdb('inv_barang', 'Nama_Barang', 'Nama_Barang', "where ID='" . $r->ID_Barang . "'"), rdb('inv_barang_satuan', 'Satuan', 'Satuan', "where ID='" . rdb('inv_barang', 'ID_Satuan', 'ID_Satuan', "where ID='" . $r->ID_Barang . "'") . "'"), number_format($r->Jumlah, 2), number_format($r->Harga, 2), number_format($r->Jumlah * $r->Harga, 2), $r->Keterangan)); //sub tlot $jml = $jml + $r->Jumlah; $harga = $harga + $r->Harga; $hargaj = $hargaj + $r->Harga * $r->Jumlah; } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225); $a->Cell(140, 8, "TOTAL", 1, 0, 'R', true); $a->Cell(20, 8, number_format($jml, 2), 1, 0, 'R', true); $a->Cell(25, 8, number_format($harga, 2), 1, 0, 'R', true); $a->Cell(30, 8, number_format($hargaj, 2), 1, 0, 'R', true); $a->Cell(60, 8, '', 1, 0, 'R', true); $a->Output('application/logs/' . $this->session->userdata('userid') . '_mutasi.pdf', 'F'); //show pdf output in frame $path = 'application/views/laporan';
// set lebar tiap kolom tabel transaksi // $a->SetWidths(array(10,25,60,20,15,25)); $a->SetWidths(array(10, 30, 60, 25, 25, 30)); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "L", "L", "R", "R", "L")); $a->SetFont('Arial', 'B', 10); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; $hgb = 0; $hargaj = 0; $jml = 0; foreach ($temp_rec as $r) { $n++; (int) $r->stock <= $r->minstok ? $a->Row(array($n, strtoupper($r->Kode), $r->Nama_Barang, number_format($r->minstok, 0), number_format($r->stock, 0), rdb('inv_barang_satuan', 'Satuan', 'Satuan', "where ID='" . $r->ID_Satuan . "'"))) : ''; } $a->Output('application/logs/' . $this->session->userdata('userid') . '_mutasi.pdf', 'F'); //show pdf output in frame $path = 'application/views/laporan'; $img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>"; link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js'); panel_begin('Print Preview', '', 'Back' . $img); ?> <iframe src="<?php echo base_url(); ?> application/logs/<?php echo $this->session->userdata('userid'); ?> _mutasi.pdf" height="100%" width="100%" frameborder="0" allowtransparency="1" style="z-index:100"></iframe>
$a->Ln(2); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi $a->SetWidths(array(7, 40, 25, 40, 35, 40, 22, 22, 18, 25)); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "L", "C", "L", "L", "L", "R", "R", "C", "C")); $a->SetFont('Arial', 'B', 10); $a->Ln(2); // set nama header tabel transaksi $a->SetFillColor(225, 225, 225); $a->Cell(7, 7, 'No.', 1, 0, 'C', true); $a->Cell(40, 7, 'NO. SPB', 1, 0, 'C', true); $a->Cell(25, 7, 'TGL SPB', 1, 0, 'C', true); $a->Cell(40, 7, 'NAMA PEMILIK', 1, 0, 'C', true); $a->Cell(35, 7, 'NO.KTP/SIM', 1, 0, 'C', true); $a->Cell(40, 7, 'JENIS BARANG', 1, 0, 'C', true); $a->Cell(22, 7, 'TAKSIR', 1, 0, 'C', true); $a->Cell(22, 7, 'NILAI TAKS', 1, 0, 'C', true); $a->Cell(18, 7, 'JK.WAKTU', 1, 0, 'C', true); $a->Cell(25, 7, 'JT TEMPO', 1, 0, 'C', true); $a->Ln(7); $a->SetFont('Arial', '', 10); $rec = $temp_rec->result(); $n = 0; foreach ($rec as $r) { $n++; $a->Row(array($n, $r->no_spb, tglfromSql($r->tgl_spb), $r->nama_spb, $r->ktp_spb, $r->id_barang, number_format($r->taksir_spb), number_format($r->nilai_spb), $r->jw_spb, tglfromSql($r->jt_spb))); //$a->Ln(5); } //print_r($a); $a->Output();
$datax = array(); foreach ($temp_rec as $r) { $hgb = 0; $n++; $x = 0; $a->SetFont('Arial', 'BI', 9); $a->Cell(10, 8, $n, 1, 0, 'C'); $a->Cell(22, 8, tglfromSql($r->tgl_kas), 1, 0, 'C'); $a->Cell(108, 8, 'Saldo Awal ' . tglfromSql($r->tgl_kas), 1, 0, 'L'); $a->Cell(30, 8, number_format($r->sa_kas, 2), 1, 1, 'R'); $a->SetFont('Arial', '', 9); $where = "where tgl_trans='" . $r->tgl_kas . "' and jumlah!='0'"; $datax = $this->kasir_model->operasional($where, $orderby); foreach ($datax as $row) { $x++; $a->Row(array('', $x, $row->uraian_trans, number_format($row->jumlah, 2), '')); $hgb = $hgb + $row->jumlah; } $a->SetFont('Arial', 'I', 9); $a->Cell(32, 8, '', 1, 0, 'C'); $a->Cell(108, 8, 'Saldo Akhir ' . tglfromSql($r->tgl_kas), 1, 0, 'L'); $a->Cell(30, 8, number_format($r->sa_kas - $hgb, 2), 1, 1, 'R'); } /* $a->SetFont('Arial','B',10); $a->SetFillColor(225,225,225); $a->Cell(110,8,"TOTAL",1,0,'R',true); $a->Cell(30,8,number_format($harga,2),1,0,'R',true); $a->Cell(30,8,number_format($hargaj,2),1,1,'R',true); $a->Cell(140,8,"SALDO",1,0,'R',true); $a->Cell(30,8,number_format(($harga-$hargaj),2),1,0,'R',true); */
$a->setReferer(array('Tanggal', 'Jenis Obat', 'Nama Dokter')); $a->setFilename('asset/bin/zetro_beli.frm'); $a->AliasNbPages(); $a->AddPage("L", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi // set align tiap kolom tabel transaksi $a->SetWidths(array(10, 22, 65, 15, 25, 25, 30, 40, 45)); $a->SetAligns(array("C", "C", "L", "C", "R", "C", "R", "L", "L")); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; foreach ($temp_rec->result_object() as $r) { $n++; $a->Row(array($n, tglfromSql($r->tgl_transaksi), $r->nm_barang, $r->nm_satuan, $r->jml_transaksi, !empty($r->expired) ? tglfromSql($r->expired) : '', number_format($r->jml_transaksi * $r->harga_beli, 2), $r->nm_produsen, 'Ref.:' . $r->faktur_transaksi)); //sub tlot $harga = $harga + $r->jml_transaksi * $r->harga_beli; } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225); $a->Cell(162, 8, "TOTAL", 1, 0, 'R', true); $a->Cell(30, 8, number_format($harga, 2), 1, 0, 'R', true); $a->Cell(85, 8, '', 1, 0, 'R', true); $a->Output('application/logs/' . $this->session->userdata('userid') . '_laporan_beli.pdf', 'F'); //show pdf output in frame $path = 'application/views/laporan'; $img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>"; link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js'); panel_begin('Print Preview', '', 'Back' . $img); ?>
// set lebar tiap kolom tabel transaksi $a->SetWidths(array(10, 60, 20, 18, 25, 25, 40, 79)); //$a->SetWidths(); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "L", "R", "L", "R", "R", "L", "L")); $a->SetFont('Arial', 'B', 10); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; $hgb = 0; $hargaj = 0; $jml = 0; foreach ($temp_rec as $r) { $n++; $a->Row(array($n, $r->Nama_Barang, number_format($r->Jumlah, 2), $r->Satuan, number_format($r->Harga, 2), number_format($r->Jumlah * $r->Harga, 2), $r->Nama, $r->Jenis_Jual . " - No. Faktur : " . $r->Nomor)); //sub tlot $jml = $jml + $r->Jumlah; $hargaj = $hargaj + $r->Harga; $harga = $harga + $r->Jumlah * $r->Harga; } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225); $a->Cell(108, 8, "TOTAL", 1, 0, 'R', true); /* $a->Cell(20,8,number_format($jml,2),1,0,'R',true); $a->Cell(18,8,'',1,0,'C',true); */ $a->Cell(25, 8, number_format($hargaj, 2), 1, 0, 'R', true); $a->Cell(25, 8, number_format($harga, 2), 1, 0, 'R', true); $a->Cell(119, 8, '', 1, 0, 'C', true); $a->Output('application/logs/' . $this->session->userdata('userid') . '_detail_penjualan.pdf', 'F');
foreach ($dataz as $r2) { $nn++; $x = 0; $a->SetFont('Arial', 'I', 9); $a->SetFillColor(247, 240, 213); $a->Cell(10, 8, $nn, 1, 0, 'R', true); $a->cell(20, 8, tglfromSql($r2->Tanggal), 1, 0, 'C', true); $a->cell(20, 8, $r2->Nomor, 1, 0, 'C', true); $a->Cell(70, 8, $r2->ID_Jenis == '1' || $r2->ID_Jenis == '5' ? $r2->Jenis_Jual : $r2->Jenis_Jual . " : " . $r2->ID_Post . " - " . $r2->Deskripsi, 1, 0, "L", true); $a->Cell(73, 8, $r2->ID_Jenis == '1' || $r2->ID_Jenis == '5' ? "" : "Jatuh Tempo Tanggal : " . tglfromSql($r2->Tgl_Cicilan), 1, 1, 'L', true); $a->SetFont('Arial', '', 9); $Grp = " and p.ID_Anggota='" . $r2->ID_Anggota . "' and dt.ID_Jual='" . $r2->ID_Jual . "'"; $dataz = $this->kasir_model->detail_trans_jual($where, $Grp, $orderby); foreach ($dataz as $rr2) { $x++; $a->Row(array('', $x, $rr2->Kode, ucwords($rr2->Nama_Barang), number_format($rr2->Jumlah, 2), $r2->Satuan, number_format($rr2->Harga, 2), number_format($rr2->Harga * $rr2->Jumlah, 2))); $hgb = $r2->ID_Jenis == '5' ? $hgb - $rr2->Harga * $rr2->Jumlah : $hgb + $rr2->Harga * $rr2->Jumlah; } } //sub tlot $hargaj = rdb('inv_pembayaran', 'ppn', 'sum(ppn) as ppn', "where no_transaksi='" . $r->NoUrut . "' and year(doc_date)='" . $r->Tahun . "'"); $harga = $harga + ($hgb - $hargaj); if ($hargaj != 0) { $a->SetFont('Arial', 'I', 10); $a->SetFillColor(242, 239, 219); $a->Cell(163, 8, "Potongan", 1, 0, 'R', true); $a->Cell(30, 8, number_format($hargaj, 2), 1, 1, 'R', true); } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(242, 239, 219); $a->Cell(163, 8, "Sub Total", 1, 0, 'R', true);
$a->setFilename('asset/bin/zetro_master.frm'); $a->AliasNbPages(); $a->AddPage("P", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi // set align tiap kolom tabel transaksi $a->SetWidths(array(10, 75, 30, 12, 30, 30)); $a->SetAligns(array("C", "L", "R", "C", "R", "R")); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $kredit = 0; $debit = 0; foreach ($temp_rec->result_object() as $r) { $n++; $a->Row(array($n, $r->nm_barang, number_format($r->jml_transaksi, 2), $r->nm_satuan, number_format($r->harga_beli, 2), number_format($r->jml_transaksi * $r->harga_beli, 2))); //sub tlot $kredit = $kredit + $r->jml_transaksi * $r->harga_beli; //$debit =($debit+($r->debit)); } if ($n < 15) { $h = 6 * (15 - $n); $a->MultiCell(187, $h, '', 1, 0, 'L'); } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225); $a->Cell(157, 8, "Sub Total", 1, 0, 'R', true); $a->Cell(30, 8, number_format($kredit, 2), 1, 1, 'R', true); $a->Cell(157, 8, "PPN 10%", 1, 0, 'R', true); $a->Cell(30, 8, number_format(round($kredit * 10 / 100, 0), 2), 1, 1, 'R', true); $a->Cell(157, 8, "Total", 1, 0, 'R', true);
// set lebar tiap kolom tabel transaksi $a->SetWidths(array(10, 20, 20, 50, 25, 18, 30, 30, 69)); //$a->SetWidths(); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "C", "C", "L", "R", "L", "R", "R", "L")); $a->SetFont('Arial', 'B', 10); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; $hgb = 0; $hargaj = 0; $jml = 0; foreach ($temp_rec as $r) { $n++; $a->Row(array($n, tglfromSql($r->Tanggal), $r->Nomor, $r->Nama_Barang, number_format($r->Jumlah, 2), $r->Satuan, number_format($r->Harga_Beli, 2), number_format($r->Jumlah * $r->Harga_Beli, 2), $r->Jenis_Beli . " - No. Faktur : " . $r->Nomor)); //sub tlot $jml = $jml + $r->Jumlah; $hargaj = $hargaj + $r->Harga_Beli; $harga = $harga + $r->Jumlah * $r->Harga_Beli; } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225); $a->Cell(143, 8, "TOTAL", 1, 0, 'R', true); /* $a->Cell(20,8,number_format($jml,2),1,0,'R',true); $a->Cell(18,8,'',1,0,'C',true); */ $a->Cell(30, 8, number_format($hargaj, 2), 1, 0, 'R', true); $a->Cell(30, 8, number_format($harga, 2), 1, 0, 'R', true); $a->Cell(69, 8, '', 1, 0, 'C', true); $a->Output('application/logs/' . $this->session->userdata('userid') . '_detail_penjualan.pdf', 'F');
$a->SetWidths(array(10, 30, 60, 20, 18, 25, 25)); //$a->SetWidths(); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "L", "L", "R", "L", "R", "R")); $a->SetFont('Arial', 'B', 10); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; $hgb = 0; $hargaj = 0; $jml = 0; $corting = 0; foreach ($temp_rec as $r) { $n++; $orient == 'P' ? $a->Row(array($n, rdb('inv_barang', 'Kode', 'Kode', "where ID='" . $r->ID_Barang . "'"), ucwords(rdb('inv_barang', 'Nama_Barang', 'Nama_Barang', "where ID='" . $r->ID_Barang . "'")), number_format($r->Jumlah, 2), rdb('inv_barang_satuan', 'Satuan', 'Satuan', "where ID='" . rdb('inv_barang', 'ID_Satuan', 'ID_Satuan', "where ID='" . $r->ID_Barang . "'") . "'"), number_format($r->Harga, 2), number_format($r->Jumlah * $r->Harga, 2))) : $a->Row(array($n, ucwords($r->Nama_Barang), number_format($r->Jumlah, 2), $r->Satuan, number_format($r->Harga, 2), number_format($r->Jumlah * $r->Harga, 2), $r->Nama, $r->Jenis_Jual . " - " . $r->Nomor)); //sub tlot $corting = rdb('inv_pembayaran', 'ppn', 'sum(ppn) as ppn', "where no_transaksi='" . $r->NoUrut . "' and year(doc_date)='" . $r->Tahun . "'"); $jml = $jml + $r->Jumlah; $hargaj = $hargaj + $r->Harga; $harga = $harga + ($r->Jumlah * $r->Harga - $corting); } if ($corting != 0) { $a->SetFont('Arial', 'I', 10); $a->SetFillColor(225, 225, 225); $a->Cell(100, 8, "Potongan", 1, 0, 'R', true); $a->Cell(20, 8, '', 1, 0, 'R', true); $a->Cell(18, 8, '', 1, 0, 'C', true); $a->Cell(25, 8, '', 1, 0, 'R', true); $a->Cell(25, 8, number_format($corting, 2), 1, 1, 'R', true); }
$a->setFilename('asset/bin/zetro_master.frm'); $a->AliasNbPages(); $a->AddPage("P", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi // set align tiap kolom tabel transaksi $a->SetWidths(array(10, 77, 25, 18, 30, 30)); $a->SetAligns(array("C", "L", "R", "C", "R", "R")); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $kredit = 0; $debit = 0; foreach ($temp_rec->result_object() as $r) { $n++; $a->Row(array($n, $r->Nama_Barang, number_format($r->Jumlah, 2), $r->Satuan, number_format($r->Harga, 2), number_format($r->Jumlah * $r->Harga, 2))); //sub tlot $kredit = $kredit + $r->Jumlah * $r->Harga; //$debit =($debit+($r->debit)); } if ($n < 15) { $h = 6 * (15 - $n); $a->MultiCell(190, $h, '', 1, 0, 'L'); } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225); $a->Cell(160, 8, "Sub Total", 1, 0, 'R', true); $a->Cell(30, 8, number_format($kredit, 2), 1, 1, 'R', true); $a->Cell(160, 8, "PPN 10%", 1, 0, 'R', true); $a->Cell(30, 8, number_format(round($kredit * 10 / 100, 0), 2), 1, 1, 'R', true); $a->Cell(160, 8, "Total", 1, 0, 'R', true);
$a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi $a->SetWidths(array(10, 25, 90, 31, 31, 90)); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "C", "L", "R", "R", "L")); $a->SetFont('Arial', 'B', 10); //$a->Ln(1); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $s_pokok = 0; $s_wajib = 0; $s_kusus = 0; foreach ($temp_rec as $r) { $n++; $a->Row(array($n, $r->Kode, $r->Perkiraan, number_format($r->Debet, 2), number_format($r->Kredit, 2), $r->Keterangan)); $s_pokok = $s_pokok + $r->Debet; $s_wajib = $s_wajib + $r->Kredit; } /**/ $a->SetFont('Arial', 'B', 9); $a->SetFillColor(225, 225, 225); $a->Cell(125, 8, "TOTAL", 1, 0, 'R', true); $a->Cell(31, 8, number_format($s_pokok, 2), 1, 0, 'R', true); $a->Cell(31, 8, number_format($s_wajib, 2), 1, 0, 'R', true); $a->Cell(90, 8, '', 1, 0, 'R', true); $a->Output('application/logs/' . $this->session->userdata('userid') . '_jurnal.pdf', 'F'); //show pdf output in frame $path = 'application/views/_laporan'; $img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>"; link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js');
// set align tiap kolom tabel transaksi $width = ''; $jml_record = $zn->Count($a->getSection(), $a->getFilename()); for ($i = 1; $i <= $jml_record; $i++) { $d = explode(',', $zn->rContent($a->getSection(), $i, $a->getFilename())); $width .= $d[9] . ","; } $a->SetWidths(array(10, 20, 20, 25, 55, 20, 15, 25)); $a->SetAligns(array("C", "L", "L", "L", "L", "R", "C", "R")); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; foreach ($temp_rec->result_object() as $r) { $n++; $a->Row(array($n, $r->nm_jenis, $r->nm_kategori, $r->nm_golongan, $r->nm_barang, number_format($r->stock, 2), $r->nm_satuan, number_format($r->harga_beli, 2))); //sub tlot $harga = $harga + $r->harga_beli; } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225); $a->Cell(165, 8, "TOTAL", 1, 0, 'R', true); $a->Cell(25, 8, number_format($harga, 2), 1, 0, 'R', true); $a->Output('application/logs/' . $this->session->userdata('userid') . '_laporan_beli.pdf', 'F'); //show pdf output in frame $path = 'application/views/laporan'; $img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>"; link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js'); panel_begin('Print Preview', '', 'Back' . $img); ?> <iframe src="<?php
//echo $a->getColWidth(); // set lebar tiap kolom tabel transaksi $a->SetWidths(array(10, 90, 25, 25, 25, 18)); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "L", "R", "R", "R", "C")); $a->SetFont('Arial', 'B', 10); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; $hgb = 0; $hargaj = 0; $jml = 0; foreach ($temp_rec as $r) { $n++; $a->Row(array($n, $r->Nama . ' [ ' . $r->Catatan . ' ]', number_format($r->Debet, 2), number_format($r->Kredit, 2), number_format($r->Saldo, 2), tglfromSql($r->mulai_bayar))); //sub tlot $jml = $jml + $r->Debet; $harga = $harga + $r->Kredit; $hargaj = $hargaj + $r->Saldo; } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225); $a->Cell(100, 8, "TOTAL", 1, 0, 'R', true); $a->Cell(25, 8, number_format($jml, 2), 1, 0, 'R', true); $a->Cell(25, 8, number_format($harga, 2), 1, 0, 'R', true); $a->Cell(25, 8, number_format($hargaj, 2), 1, 0, 'R', true); $a->Cell(18, 8, '', 1, 0, 'R', true); $a->Output('application/logs/' . $this->session->userdata('userid') . '_rekap_tagihan.pdf', 'F'); //show pdf output in frame $path = 'application/views/laporan';