public function show_data_field($section, $table, $where) { $data = array(); $jml = $this->zn->Count($section, $this->nfiles); for ($i = 1; $i < $jml; $i++) { $fld = explode(",", $this->zn->rContent($section, $i, $this->nfiles)); $fld[2] == 'date' ? $result = tglfromSql($this->Admin_model->show_single_field($table, $fld[3], $where)) : ($result = $this->Admin_model->show_single_field($table, $fld[3], $where)); $data[$fld[3]] = $result; } return $data; }
$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();
$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))); $hgb = $hgb + $r2->Harga_Beli * $r2->Jumlah; } //sub tlot $a->SetFont('Arial', 'B', 9); $a->SetFillColor(242, 239, 219); $a->Cell(165, 8, "Sub Total", 1, 0, 'R', true); $a->Cell(27, 8, number_format($hgb, 2), 1, 1, 'R', true); } } //grand total $harga = $harga + $r->Harga_Beli; } $a->SetFont('Arial', 'B', 9); $a->SetFillColor(225, 225, 225); $a->Cell($detail == '' ? 112 : 165, 8, "GRAND TOTAL", 1, 0, 'R', true);
function get_transaksi() { $data = array(); $ID_Dept = empty($_POST['ID_Dept']) ? '' : $_POST['ID_Dept']; $ID_Aktif = empty($_POST['ID_Aktif']) ? '' : $_POST['ID_Aktif']; $data = $this->member_model->get_transaksi($ID_Dept, $ID_Aktif); $n = 0; $t_debet = 0; $t_kredit = 0; foreach ($data as $r) { $n++; echo "<tr class='xx' align='center'>\r\n\t\t\t\t <td class='kotak'>{$n}</td>\r\n\t\t\t\t <td class='kotak'>" . tglfromSql(substr($r->Tanggal, 0, 10)) . "</td>\r\n\t\t\t\t <td class='kotak'>" . $r->Kode . "</td>\r\n\t\t\t\t <td class='kotak' align='left' nowrap>" . $r->Perkiraan . "</td>\r\n\t\t\t\t <td class='kotak' align='right'>" . number_format($r->Debet, 2) . "</td>\r\n\t\t\t\t <td class='kotak' align='right'>" . number_format($r->Kredit, 2) . "</td>\r\n\t\t\t\t <td class='kotak' align='left' nowrap>" . $r->Keterangan . "</td>\r\n\t\t\t\t <td class='kotak'>"; echo $r->ID_Stat == '0' ? "<img title='hapus transaksi' src='" . base_url() . "asset/images/no.png' onclick=\"hapus('" . $r->ID . "');\">" : "<img title='sudah terjurnal' src='" . base_url() . "asset/images/5.png'>"; echo "</td>\r\n\t\t\t\t </tr>"; $t_debet = $t_debet + $r->Debet; $t_kredit = $t_kredit + $r->Kredit; } echo "<tr class='list_genap'>\r\n\t\t\t <td class='kotak' colspan='4' align='right'>TOTAL</td>\r\n\t\t\t <td class='kotak' align='right'><b>" . number_format($t_debet, 2) . "</td>\r\n\t\t\t <td class='kotak' align='right'><b>" . number_format($t_kredit, 2) . "</td>\r\n\t\t\t <td class='kotak' align='right'></td>\r\n\t\t\t <td class='kotak' align='right'></td>\r\n\t\t\t </tr>"; }
function print_label() { $data = array(); $datax = array(); $kolom = 2; $n = 0; $nn = 0; $datax['list'] = $this->Admin_model->show_list('labeling', "where pp_stat='Y' order by no_spb"); $data = $this->Admin_model->show_list('labeling', "where pp_stat='Y' order by no_spb"); //print_r($data->result_array()); foreach ($data->result_array() as $row) { $nama_spb = ''; $no_spb = ''; $jw = ''; $jt_tmpo = ''; $nilai_spb = ''; $barang = ''; $nama_spb = substr(rdb('spb', 'nama_spb', 'nama_spb', "where no_spb='" . $row['no_spb'] . "'"), 0, 10); $no_spb = substr($row['no_spb'], 0, 5); $jw = $row['jw_spb']; $jt_tmpo = tglfromSql($row['jt_spb']); $nilai_spb = number_format($row['nilai_spb'], 0); $barang = $row['id_barang']; $datane = array($nama_spb, $no_spb, $jw, $jt_tmpo, $nilai_spb, $barang); $this->print_slip($n, $datane); $n++; $this->Admin_model->upd_data("labeling", "set pp_stat='P'", "where no_spb='" . $row['no_spb'] . "'"); } $n > 1 ? $z = $n % ($n / 2) : ($z = ''); $z == 1 || ($z = '') ? $zz = 1 : ($zz = 0); $this->print_slip($n + $zz, ''); $this->print_slip($n + $zz + 1, ''); $this->load->view('master/print_label', $datax); }
$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';
$a->Cell(93, 8, $r->Catatan . " " . $r->Alamat . " " . $r->Kota, 1, 1, "L", true); $a->SetFont('Arial', '', 9); $ID_P = " and p.ID_Anggota='" . $r->ID_Anggota . "' group by dt.ID_Jual"; $orderby .= ",p.Tanggal"; //$a->Cell(193,8,$where.' '.$ID_P.' '.$orderby,1,1,'L',true); $dataz = $this->kasir_model->detail_trans_jual($where, $ID_P, $orderby); 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);
function vendor_detailed() { $data = array(); $n = 0; $total = 0; $ID = $_POST['id']; $data = $this->purch_model->detail_trans_vendor("where p.ID_Pemasok='" . $ID . "' order by p.Tanggal limit 500"); foreach ($data as $r) { $n++; echo tr() . td($n, 'center') . td(tglfromSql($r->Tanggal)) . td($r->Nomor) . td($r->Nama_Barang) . td(number_format($r->Jumlah, 2), 'right') . td($r->Satuan) . td(number_format($r->Jumlah * $r->Harga_Beli, 2), 'right') . _tr(); $total = $total + $r->Jumlah * $r->Harga_Beli; } echo tr() . td('<b>Total</b>', 'right\' colspan=\'6', 'kotak list_genap') . td('<b>' . number_format($total, 2) . '</b>', 'right') . _tr(); }
//$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
<div class='contents'> <div class="j_panel judul" style="width:20%">List DO</div> <div class="pn_content"> <hr> <?php $zb = new zetro_listBuilder('asset/bin/zetro_form.cfg'); $zb->ListHeader('Invoice', '100%'); $no = 1; foreach ($invoice->result_array() as $lst) { echo "<tr class='xx' align='center' id='" . $lst['iddo'] . "'>\n\r\n\t\t\t\t\t\t <td class='kotak'>{$no}</td>\n\r\n\t\t\t\t\t\t <td class='kotak'>" . $lst['iddo'] . "</td>\n\r\n\t\t\t\t\t\t <td class='kotak' align='left'>" . rdb("customer", "nmcus", "nmcus", "where idcus='" . rdb("transaksi", "idcus", "idcus", "where iddo='" . $lst['iddo'] . "'") . "'") . "</td>\n\r\n\t\t\t\t\t\t <td class='kotak' align='left'>" . rdb("client", "nmclient", "nmclient", "where idclient='" . rdb("transaksi", "idclient", "idclient", "where iddo='" . $lst['iddo'] . "'") . "'") . "</td>\n\r\n\t\t\t\t\t\t <td class='kotak' align='center'>" . tglfromSql($lst['tgldo']) . "</td>\n\r\n\t\t\t\t\t\t <td class='kotak' align='center'>" . tglfromSql($lst["doc_date"]) . "</td>\n\r\n\t\t\t\t\t\t <td class='kotak' align='left'>" . $lst['statusdo'] . "</td>\n\r\n\t\t\t\t\t\t <td class='kotak'>"; /*if($oto['e']=='Y'){$zb->event($lst['iddo'],'','process');//}*/ echo "<td></tr>"; $no++; } echo "</table>"; //<table align='center' width='100%'><tr><td>$paginator</td></tr></table>"; ?> </div> </div>
$n = 0; $hgb = 0; $hargaj = 0; $jml = 0; foreach ($temp_rec as $r) { $n++; $nn = 0; $harga = 0; $corting = 0; $a->SetFont('Arial', 'I', 9); $a->SetFillColor(210, 210, 010); $a->Cell(10, 8, $n, 1, 0, 'C', true); $a->Cell(20, 8, tglfromSql($r->Tanggal), 1, 0, 'L', true); $a->Cell(20, 8, $r->Nomor, 1, 0, 'L', true); $a->Cell(70, 8, $r->Jenis_Jual . " " . $r->ID_Post . " - " . $r->Deskripsi, 1, 0, "L", true); $a->Cell(70, 8, "Tanggal Jatuh Tempo : " . tglfromSql($r->Tgl_Cicilan), 1, 1, "L", true); $a->SetFont('Arial', '', 9); $ID = " and ID_Jual='" . $r->ID_Jual . "'"; $dataz = $this->kasir_model->detail_trans_jual($where, $ID, $orderby); foreach ($dataz as $rr) { $nn++; $a->Row(array('', $nn, $rr->Kode, $rr->Nama_Barang, number_format($rr->Jumlah, 2), $r->Satuan, number_format($rr->Harga, 2), number_format($rr->Jumlah * $rr->Harga, 2))); //sub tlot $jml = $jml + $rr->Jumlah; $hargaj = $hargaj + $rr->Harga; $harga = $harga + $rr->Jumlah * $rr->Harga; } //potongan $corting = rdb('inv_pembayaran', 'ppn', 'sum(ppn) as ppn', "where no_transaksi='" . $r->NoUrut . "' and year(doc_date)='" . $r->Tahun . "'"); if ($corting != 0) { $a->SetFont('Arial', 'I', 10);
function _set_pinjaman($ID_Agt) { //penjualan selain tunai akan masuk table pinjaman $data = array(); $jmlPinj = 0; $jmlPinj = rdb('inv_pembayaran', 'total', "(total_bayar-jml_dibayar) as total", "where no_transaksi='" . $this->no_trans . "'"); $data['ID'] = $this->no_trans; $data['ID_Agt'] = $ID_Agt; $data['ID_Unit'] = rdb('jenis_simpanan', 'ID_Unit', 'ID_Unit', "where ID='" . $this->id_jenis . "'"); $data['Tanggal'] = tglToSql($this->tgl); $data['Tahun'] = substr($this->tgl, 6, 4); $data['jml_pinjaman'] = $jmlPinj; //rdb('inv_penjualan','Total','Total',"where NoUrut='".$this->no_trans."' and Tanggal='".tglToSql($this->tgl)."'"); $data['cara_bayar'] = $this->id_jenis; $data['mulai_bayar'] = rdb('inv_penjualan', 'Tgl_Cicilan', 'Tgl_Cicilan', "where NoUrut='" . $this->no_trans . "' and Tanggal='" . tglToSql($this->tgl) . "'"); $data['keterangan'] = rdb('jenis_simpanan', 'Jenis', 'Jenis', "where ID='" . $this->id_jenis . "'") . ' No: ' . rdb('inv_penjualan', 'ID_Post', "ID_Post", "where NoUrut='" . $this->no_trans . "' and Tanggal='" . tglToSql($this->tgl) . "'") . "-" . rdb('inv_penjualan', 'Deskripsi', 'Deskripsi', "where NoUrut='" . $this->no_trans . "' and Tanggal='" . tglToSql($this->tgl) . "'") . '[ ' . tglfromSql(rdb('inv_penjualan', 'Tgl_Cicilan', 'Tgl_Cicilan', "where NoUrut='" . $this->no_trans . "' and Tanggal='" . tglToSql($this->tgl) . "'")) . ' ]'; $this->Admin_model->replace_data('pinjaman', $data); }
$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 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
function perpanjang($no_spb, $pp_ke = 1, $showtgl = false, $bayar = false) { $jtspb = rdb('spb', 'tgl_spb', 'tgl_spb', "where no_spb='{$no_spb}'"); $nextjtspb = getNextDays($jtspb, $pp_ke * 30); $nextjtspb2 = getNextDays($jtspb, ($pp_ke + 1) * 30); $bataslelang = getNextDays($nextjtspb, 13); $today = date('Y-m-d'); $stat = rdb('perpanjang_spb', 'pp_ke', 'pp_ke', "where no_spb='" . $no_spb . "' and pp_ke='{$pp_ke}'"); $action = rdb('perpanjang_spb', 'pp_stat', 'pp_stat', "where no_spb='" . $no_spb . "' and pp_ke='{$pp_ke}'"); $bayare = $bayar == true && $pp_ke > 1 ? rdb('perpanjang_spb', 'pp_stat', 'pp_stat', "where no_spb='" . $no_spb . "' and pp_ke='" . ($pp_ke - 1) . "'") : ''; $bunga = rdb('spb', 'taksir_spb', 'taksir_spb', "where no_spb='{$no_spb}'"); $bunga = $bunga * 10 / 100; if ($stat == '') { if (compare_date($today, $bataslelang) == true && compare_date($today, $nextjtspb) == false) { return "<img class='aksi' src='" . base_url() . "/asset/images/icon-25.gif' width='20' height='20' title='Klik untuk process perpanjang' onclick=\"aksi_click('{$no_spb}','{$pp_ke}','{$bunga}')\";>"; } else { return compare_date($nextjtspb2, $today) == false ? $bayar == true && $bayare == 'Y' || $pp_ke == '1' ? "<img src='" . base_url() . "/asset/images/checkout.gif' title='Click untuk transaksi bayar' onclick=\"aksi_click('{$no_spb}','{$pp_ke}','{$bunga}')\">" : false : "<img src='" . base_url() . "/asset/images/8.png' title='Tidak di perpanjang lanjut untuk process lelang'>"; } } else { if ($action == 'Y') { return $showtgl == false ? "<img src='" . base_url() . "/asset/images/iconic.png' ondblclick=\"reset_upd('{$no_spb}','{$pp_ke}','');\" title='Telah di perpanjang " . $stat . " kali.\nTanggal Jatuh Tempo berikutnya :" . tglfromSql(getNextDays($jtspb, ($stat + 1) * 30)) . "'>" : ShortTgl($nextjtspb2); } else { if ($action == 'N') { return "<img src='" . base_url() . "/asset/images/8.png' ondblclick=\"reset_upd('{$no_spb}','{$pp_ke}','Y');\" title='Tidak di perpanjang lanjut untuk process lelang'>"; } else { if ($action == 'L') { return "<img src='" . base_url() . "/asset/images/bullet.png' title='Lunas'>"; } else { return false; } } } } }
$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');
function get_transaksi() { $data = array(); $no_transaksi = $_POST['no_transaksi']; $this->inv_model->tabel('detail_transaksi'); $data['tgl_transaksi'] = tglfromSql($this->Admin_model->show_single_field('detail_transaksi', 'tgl_transaksi', "where no_transaksi='{$no_transaksi}'")); $data['faktur_transaksi'] = $this->Admin_model->show_single_field('detail_transaksi', 'faktur_transaksi', "where no_transaksi='{$no_transaksi}'"); $data['nm_nasabah'] = $this->Admin_model->show_single_field('detail_transaksi', 'nm_produsen', "where no_transaksi='{$no_transaksi}'"); echo json_encode($data); }
link_js('jquery_print.js', 'application/views/admin/js'); link_js('zetro_number.js,lap_list_spb.js', 'asset/js,application/views/laporan/js'); $user_aktiv = $this->session->userdata("userid"); $blnj = "<select id='bulan' name='bulan'></select>"; $thnj = "<select id='thn' name='thn'></select>"; $img = "<img src='" . base_url() . "asset/images/printer.png' id='printing' title='Print Report' class='xx'>"; echo "<form id='frm1' name='frm1' action='' method='post'>"; panel_begin('Daftar SPB,Perpanjang SPB', '', "Filter by Bulan :," . $blnj . ",Tahun :," . $thnj . ", ", "{$img}"); panel_multi('daftarspb', 'block'); $zb = new zetro_listBuilder('asset/bin/zetro_form.cfg'); $zb->ListHeader('Spb', '100%', 'listTable'); $no = 0; //($page+1); foreach ($list->result_array() as $lst) { $no++; echo "<tr class='xx' id='" . $lst['no_spb'] . "' align='center'>\r\n\t\t <td class='kotak'>{$no}</td>\r\n\t \t <td class='kotak'>" . $lst['no_spb'] . "</td>\r\n\t\t <td class='kotak'>" . tglfromSql($lst['tgl_spb']) . "</td>\r\n\t\t <td class='kotak' align='left'>" . $lst['nama_spb'] . "</td>\r\n\t\t <td class='kotak' align='left'>" . $lst['ktp_spb'] . "</td>\r\n\t\t <td class='kotak' align='left'>" . $lst['id_barang'] . "</td>\r\n\t\t <td class='kotak' align='right'>" . number_format($lst['taksir_spb'], 2) . "</td>\r\n\t\t <td class='kotak' align='right'>" . number_format($lst['nilai_spb'], 2) . "</td>\r\n\t\t <td class='kotak'>" . $lst['jw_spb'] . "</td>\r\n\t\t <td class='kotak'>" . tglfromSql($lst['jt_spb']) . "</td>"; $ppke = rdb("perpanjang_spb", "pp_ke", 'pp_ke', "where no_spb='" . $lst['no_spb'] . "'"); echo compare_date($lst['jt_spb'], date('Y-m-d')) ? "<td class='kotak' width='5%'>" . perpanjang($lst['no_spb'], $ppke) . "<td>" : "<td class='kotak' width='5%'> </td></tr>"; } echo "</tbody></table>\n"; panel_multi_end(); panel_multi('perpanjangspb'); ?> <table id='listdata' style='border-collapse:collapse'> <thead> <tr class='header'> <th class='kotak' rowspan='2' width='20%'>URAIAN</th> <th class='kotak' colspan='2' width='12%'>PENJUALAN</th> <th class='kotak' rowspan='2' width='10%'>NAMA NASABAH</th> <th class='kotak' rowspan='2' width='10%'>TAKSIR</th> <th class='kotak' rowspan='2' width='10%'>NILAI TAKSIR</th>
$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); ?>
function laporan_pembelian() { //process filter $data = array(); $where = ''; $datax = array(); $n = 0; empty($_POST['smp_tanggal']) ? $where = "where Tanggal='" . tgltoSql($_POST['dari_tanggal']) . "' and ID_Bayar IS NOT NULL" : ($where = "where (Tanggal between '" . tgltoSql($_POST['dari_tanggal']) . "' and '" . tgltoSql($_POST['smp_tanggal']) . "') and ID_Bayar IS NOT NULL"); //echo $where; $data = $this->Admin_model->show_list('inv_pembelian', $where . " order by NoUrut"); foreach ($data as $r) { $n++; $x = 0; echo tr('xx list_genap') . td($n . nbs(3), 'center') . td($r->Nomor, 'center') . td(tglfromSql($r->Tanggal), 'center') . td(strtoupper(rdb('inv_pemasok', 'Pemasok', 'Pemasok', "where ID='" . $r->ID_Pemasok . "'")), 'left\' colspan=\'3\'') . td(rdb('inv_pembelian_jenis', 'Jenis_Beli', 'Jenis_Beli', "where ID='" . $r->ID_Jenis . "'")) . td('<b>' . number_format($r->ID_Bayar, 2) . '</b>', 'right') . _tr(); $datax = $this->Admin_model->show_list('inv_pembelian_detail', "where ID_Beli='" . $r->ID . "'"); foreach ($datax as $row) { $x++; echo tr() . td(nbs(2) . $x, 'center') . td(rdb('inv_barang', 'Kode', 'Kode', "where ID='" . $row->ID_Barang . "'") . nbs(5), 'right\' colspan=\'2\'') . td(nbs(2) . rdb('inv_barang', 'Nama_Barang', 'Nama_Barang', "where ID='" . $row->ID_Barang . "'")) . td(rdb('inv_barang_satuan', 'Satuan', 'Satuan', "where ID='" . $row->ID_Satuan . "'")) . td(number_format($row->Jml_Faktur, 2), 'right') . td(number_format($row->Harga_Beli, 2), 'right') . td(number_format($row->Jml_Faktur * $row->Harga_Beli, 2), 'right') . _tr(); } } }
function get_no_jurnal($str, $limit) { $data = array(); $sql = "select * from jurnal where Nomor like '%{$str}%' order by NoUrut desc limit {$limit}"; $rs = mysql_query($sql) or die(mysql_error()); while ($rw = mysql_fetch_object($rs)) { $data[] = array('data' => $rw->Nomor, 'description' => $rw->Keterangan, 'NoUrut' => $rw->NoUrut, 'ID_Bulan' => $rw->ID_Bulan, 'Tahun' => $rw->Tahun, 'ID' => $rw->ID, 'Nomor' => $rw->Nomor, 'Tahun' => $rw->Tahun, 'Tanggal' => tglfromSql($rw->Tanggal), 'ID_Unit' => rdb('unit_jurnal', 'Unit', 'Unit', "where ID='" . $rw->ID_Unit . "'")); } return $data; }
function print_faktur() { $data = array(); $no_trans = $this->input->post('no_transaksi'); $data['nm_nasabah'] = rdb('mst_anggota', 'Nama', 'Nama', "where ID='" . rdb("inv_penjualan", 'ID_Anggota', 'ID_Anggota', "where NoUrut='{$no_trans}' and Tahun='" . date('Y') . "'") . "'"); $data['alamat'] = rdb('mst_anggota', 'Alamat', 'Alamat', "where ID='" . rdb("inv_penjualan", 'ID_Anggota', 'ID_Anggota', "where NoUrut='{$no_trans}' and Tahun='" . date('Y') . "'") . "'"); $data['telp'] = rdb('mst_anggota', 'Telepon', 'Telepon', "where ID='" . rdb("inv_penjualan", 'ID_Anggota', 'ID_Anggota', "where NoUrut='{$no_trans}' and Tahun='" . date('Y') . "'") . "'"); $data['Company'] = rdb('mst_anggota', 'Catatan', 'Catatan', "where ID='" . rdb("inv_penjualan", 'ID_Anggota', 'ID_Anggota', "where NoUrut='{$no_trans}' and Tahun='" . date('Y') . "'") . "'"); $data['faktur'] = rdb("inv_penjualan", 'Nomor', 'Nomor', "where NoUrut='{$no_trans}' and Tahun='" . date('Y') . "'"); $data['tanggal'] = tglfromSql(rdb("inv_penjualan", 'Tanggal', 'Tanggal', "where NoUrut='{$no_trans}' and Tahun='" . date('Y') . "'")); //$data['terbilang'] =$this->zetro_terbilang->terbilang(rdb("inv_penjualan",'Total','Total',"where NoUrut='$no_trans' and Tahun='".date('Y')."'")); $data['temp_rec'] = $this->report_model->laporan_faktur($no_trans); $this->zetro_auth->menu_id(array('trans_beli')); $this->list_data($data); $this->View("laporan/lap_" . $this->input->post('lap') . "_print"); }
// 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');
$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);
function BuildListData($pk = '', $nuberInFirstColumn = true) { $n = 0; $flds = array(); //echo $this->sql; $rs = mysql_query($this->sql) or die(mysql_error()); if (mysql_num_rows($rs)) { $fldx = ""; while ($rw = mysql_fetch_array($rs)) { $n++; if ($this->statu == true) { foreach ($this->fields as $fld) { empty($flds[$fld]) ? $flds[$fld] = $rw[$fld] : ($flds[$fld] = $flds[$fld] + $rw[$fld]); } } $pk == '' ? $id = $rw['id'] : ($id = $rw[$pk]); echo "<tr class='xx' id='nm-" . str_replace(' ', '_', $id) . "'>\n"; echo $nuberInFirstColumn == true ? "<td class='kotak' align='center'>{$n}</td>\n" : ""; for ($i = 0; $i < count($this->data); $i++) { $jenis = explode('.', $this->data[$i]); $this->nom(str_replace(' ', '_', $id)); if ($jenis[1] == 't') { echo "<td class='kotak' align='center'>" . tglfromSql($rw[$jenis[0]]) . "</td>\n"; } else { if ($jenis[1] == 'd') { echo "<td class='kotak' align='right'>" . number_format($rw[$jenis[0]], 2, '.', ',') . "</td>\n"; } else { if ($jenis[1] == 'dn') { echo $this->edit == 'y' ? "<td class='kotak' align='left' nowrap>" . $this->field_inline($i + 1, number_format($rw[$jenis[0]], 2)) . "</td>\n" : "<td class='kotak' align='right'>" . number_format($rw[$jenis[0]], 2, '.', ',') . "</td>\n"; } else { echo !empty($this->kolom) && $this->kolom == $jenis[0] ? "<td class='kotak' align='left'>" . rdb($this->tabel, $this->field, '', "where " . $this->kolom . "='" . $rw[$jenis[0]] . "'") . "</td>\n" : "<td class='kotak' align='left'>" . $rw[$jenis[0]] . "</td>\n"; } } } } //add icon action eq; edit icon, delete icon, process icon echo $this->aksi == true ? "<td class='kotak' align='center' >" . $this->event($this->section . '-' . str_replace(' ', '_', $id), '', $this->jenis) . "</td></tr>\n" : "</tr>\n"; } } else { //if data not found in database echo "<tr class='xx'><td class='kotak' align='center'><img src='" . base_url() . "asset/images/16/warning_16.png'></td>\r\n\t\t\t\t<td class='kotak' colspan='" . (count($this->data) + 1) . "'>\r\n\t\t\t\tData not found in database...(0)</td></tr>"; } //add sub total if ($this->statu == true) { $clm = explode(",", $this->kol); echo "<tr class='xx j_info' align='right'>\r\n\t\t\t\t <td colspan='" . ($clm[0] - 1) . "' class='kotak'><b>TOTAL</b></td>"; // for ($z=0;$z<count($clm);$z++){ foreach ($flds as $z) { echo !empty($flds) ? "<td class='kotak'>" . number_format($z, 2) . "</td>" : "<td class='kotak'>" . $z . "</td>"; } $jmlkolom = $clm[0] + count($clm) - 1; $totalkolom = count($this->data) + 1; if ($totalkolom - $jmlkolom > 0) { for ($n = 1; $n <= $totalkolom - $jmlkolom; $n++) { echo "<td class='kotak'> </td>"; } } echo "</tr>"; } }
function get_buku_besar() { $datax = array(); $saldo_awal = 0; $data = array(); $n = 0; $saldo = 0; $t_kredit = 0; $t_debet = 0; $ip_temp = ''; $id_Calc = ''; $saldo_akhir = 0; $akun = $_POST['Akun']; $ID_Simp = $_POST['ID_SubKlas']; $perkiraan = $_POST['ID_P']; $mulai = tgltoSql($_POST['Start']); $sampai = empty($_POST['Stop']) ? tgltoSql($_POST['Start']) : tgltoSql($_POST['Stop']); //konversi ke id perkiraan $toAkun = $ID_Simp != '4' && $ID_Simp != '17' && $ID_Simp != '18' && $ID_Simp != '19' && $ID_Simp != '28' ? $perkiraan : $this->akun_model->get_nomor_akun("where ID_Agt='{$perkiraan}' and id_subklas='{$ID_Simp}'"); //dapatkan data saldoawal if (is_array($toAkun)) { foreach ($toAkun as $t) { $ip_temp = $t->ID; $id_Calc = $t->ID_Calc; } } else { $ip_temp = $toAkun; $id_Calc = $this->Admin_model->show_single_field('perkiraan', 'id_calc', "where ID='{$ip_temp}'"); } $datax = $this->akun_model->get_saldo_awal($ip_temp); foreach ($datax as $sa) { $saldo_awal = $sa->saldoawal; } echo "<tr class='xx list_genap'>\r\n\t\t\t <td class='kotak' align='center'>•••</td>\r\n\t\t\t <td class='kotak' colspan='3'>Saldo Awal</td>\r\n\t\t\t <td class='kotak'> </td>\r\n\t\t\t <td class='kotak'> </td>\r\n\t\t\t <td class='kotak' align='right'><b>" . number_format($saldo_awal, 2) . "</b></td>\r\n\t\t\t </tr>"; $saldo = $saldo_awal; $data = $this->akun_model->buku_besar_byDate($ip_temp, $mulai, $sampai); foreach ($data as $r) { $n++; $saldo = $id_Calc == 2 ? $saldo + $r->Kredit - $r->Debet : $saldo + $r->Debet - $r->Kredit; echo "<tr class='xx'>\r\n\t\t\t\t\t <td class='kotak' align='center'>{$n}</td>\r\n\t\t\t\t\t <td class='kotak' align='center'>" . tglfromSql($r->Tanggal) . "</td>\r\n\t\t\t\t\t <td class='kotak'>" . $r->Nomor . "</td>\r\n\t\t\t\t\t <td class='kotak'>" . $r->Keterangan . "</td>\r\n\t\t\t\t\t <td class='kotak' align='right'>" . number_format($r->Debet, 2) . "</td>\t\r\n\t\t\t\t\t <td class='kotak' align='right'>" . number_format($r->Kredit, 2) . "</td>\t\r\n\t\t\t\t\t <td class='kotak' align='right'>" . number_format($saldo, 2) . "</td>\r\n\t\t\t\t\t </tr>"; $t_kredit = $t_kredit + $r->Kredit; $t_debet = $t_debet + $r->Debet; } $saldo_akhir = $id_Calc == 2 ? $saldo_awal + $t_kredit - $t_debet : $saldo_awal + $t_debet - $t_kredit; if ($n >= 1) { echo "<tr class='list_genap'>\r\n\t\t\t\t\t <td class='kotak'>•••</td>\r\n\t\t\t\t\t <td class='kotak' colspan='3'><b>Saldo Akhir</b>\r\n\t\t\t\t\t <td class='kotak' align='right'><b>" . number_format($t_debet, 2) . "</b></td>\r\n\t\t\t\t\t <td class='kotak' align='right'><b>" . number_format($t_kredit, 2) . "</b></td>\r\n\t\t\t\t\t <td class='kotak' align='right'><b>" . number_format($saldo_akhir, 2) . "</b></td>\r\n\t\t\t\t\t </tr>"; } if ($n == 0) { echo "<tr class='xx'>\r\n\t\t\t\t\t<td colspan='7' class='kotak'><b>• Belum ada data....</td>\r\n\t\t\t\t\t</tr>"; } }
function show_detail_kreditur_jurnal() { $data = array(); $nx = 0; $debet = 0; $kredit = 0; $ID_Agt = $_POST['ID_Agt']; $data = $this->kasir_model->get_trans_jurnal($ID_Agt); foreach ($data as $rx) { $nx++; echo tr() . td($nx, 'center') . td(tglfromSql($rx->Tanggal), 'center') . td($rx->Nomor) . td($rx->Keterangan) . td(number_format($rx->Debet, 2), 'right') . td(number_format($rx->Kredit, 2), 'right') . _tr(); $debet = $debet + $rx->Debet; $kredit = $kredit + $rx->Kredit; } echo tr() . td('<b>Total</b>', 'right\' colspan=\'4', 'kotak list_genap') . td('<b>' . number_format($debet, 2) . '</b>', 'right', 'kotak list_genap') . td('<b>' . number_format($kredit, 2) . '</b>', 'right', 'kotak list_genap') . _tr() . tr() . td('<b>Balance</b>', 'right\' colspan=\'5', 'kotak list_ganjil') . td('<b>' . number_format((int) $debet - (int) $kredit, 2) . '</b>', 'right', 'kotak list_genap') . _tr(); }
function get_pemakaian() { $data = array(); $n = 0; $dari = tglToSql($_POST['dari_tgl']); $sampai = empty($_POST['sampai_tgl']) ? $dari : tglToSql($_POST['sampai_tgl']); $where = empty($_POST['sampai_tgl']) ? "where Tanggal='" . $dari . "'" : "where Tanggal between '" . $dari . "' and '" . $sampai . "'"; $where .= " and ID_Jenis='" . $_POST['id_jenis'] . "'"; $where .= " order by Tanggal"; $data = $this->Admin_model->show_list('z_inv_pemakaian', $where); foreach ($data as $r) { $n++; echo tr() . td($n, 'center') . td(tglfromSql($r->Tanggal), 'center') . td(rdb('inv_barang', 'Kode', 'Kode', "where ID='" . $r->ID_Barang . "'")) . td(rdb('inv_barang', 'Nama_Barang', 'Nama_Barang', "where ID='" . $r->ID_Barang . "'")) . td(rdb('inv_barang_satuan', 'Satuan', 'Satuan', "where ID='" . rdb('inv_barang', 'ID_Satuan', 'ID_Satuan', "where ID='" . $r->ID_Barang . "'") . "'")) . td(number_format($r->Jumlah, 2), 'right') . td(number_format($r->Harga, 2), 'right') . td(number_format($r->Jumlah * $r->Harga, 2), 'right') . td($r->Keterangan) . td(img_aksi($r->ID, true), 'center') . _tr(); } }
function get_member_kredit() { $data = array(); $n = 0; $where = $_POST['status'] == '' ? '' : "where p.stat_pinjaman='" . $_POST['status'] . "'"; $where = empty($_POST['cari']) ? $where : "where a.Nama like '" . $_POST['cari'] . "%'"; $orderby = " order by " . $_POST['orderby']; $orderby .= empty($_POST['urutan']) ? '' : ' ' . $_POST['urutan']; //echo $where; $data = $this->member_model->get_data_pinjaman($where, $orderby); foreach ($data as $r) { $n++; echo tr() . td($n, 'center') . td($r->Nama . ' [ <i> ' . $r->Catatan . ' </i> ] - ' . $r->NIP) . td(number_format($r->Debet, 2), 'right') . td(number_format($r->Kredit, 2), 'right') . td(number_format($r->Saldo, 2), 'right') . td(tglfromSql($r->mulai_bayar), 'center') . td($r->Kredit == '0' ? img_aksi($r->ID . '-' . $r->Tahun, true, 'del') : '') . _tr(); } }
$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->Output('application/logs/' . $this->session->userdata('userid') . '_kas_keluar.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');