public static function angka($angka)
{
$bilang = array("", "satu", "dua", "tiga", "empat", "lima", "enam", "tujuh", "delapan", "sembilan", "sepuluh", "sebelas");
if ($angka < 12) {
return " " . $bilang[$angka];
} elseif ($angka < 20) {
return Terbilang::angka($angka - 10) . "belas";
} elseif ($angka < 100) {
return Terbilang::angka($angka / 10) . " puluh" . Terbilang::angka($angka % 10);
} elseif ($angka < 200) {
return " seratus" . Terbilang::angka($angka - 100);
} elseif ($angka < 1000) {
return Terbilang::angka($angka / 100) . " ratus" . Terbilang::angka($angka % 100);
} elseif ($angka < 2000) {
return " seribu" . Terbilang::angka($angka - 1000);
} elseif ($angka < 1000000) {
return Terbilang::angka($angka / 1000) . " ribu" . Terbilang::angka($angka % 1000);
} elseif ($angka < 1000000000) {
return Terbilang::angka($angka / 1000000) . " juta" . Terbilang::angka($angka % 1000000);
} elseif ($angka >= 1000000000) {
return "Tidak Terhingga!!!";
}
}
public function bend29()
{
$id = Input::get('nomor');
if (substr($id, 0, 3) == 'ALO') {
$data = DB::table('pkm_alokasi')->where('nomor', $id)->first();
$dtl = DB::table('pkm_alokasidtl')->join('aset_data', 'pkm_alokasidtl.id_inventori', '=', 'aset_data.id')->where('nomor', $id)->where('tipe', 'aset')->get();
} else {
$data = DB::table('aset_keluar')->where('nomor', $id)->first();
$dtl = DB::table('aset_keluardtl')->join('aset_data', 'aset_keluardtl.id_inventori', '=', 'aset_data.id')->where('nomor', $id)->select('aset_data.*')->get();
}
$ka1 = DB::table('pkm_pegawai')->where('id_unit', $data->id_puskesmas)->where('jabatan', 1)->first();
$ka2 = DB::table('pkm_pegawai')->where('id_unit', $data->id_unit)->where('jabatan', 1)->first();
$pb1 = DB::table('pkm_pegawai')->where('id', Input::get('pihak1'))->first();
$pb2 = DB::table('pkm_pegawai')->where('id', Input::get('pihak2'))->first();
$header = '
<table>
<tr style="font-weight: bold">
<td colspan="7" style="text-align: left"><br><br><br><br><br><br><br><br><br></td>
</tr>
<tr style="font-weight: bold">
<td colspan="4" style="text-align: left">PEMERINTAH KOTA SURABAYA</td>
<td colspan="3" style="text-align: right">BEND. 29</td>
</tr>
<tr style="font-weight: bold">
<td colspan="4" style="text-align: left"> </td>
<td colspan="3" style="text-align: right">NOMOR JURNAL : ' . $id . '</td>
</tr>
<tr style="font-size: large;font-weight: bold">
<td colspan="7" style="text-align: center">BUKTI PENYERAHAN BARANG DARI DAERAH/UNIT: ' . $data->nama_puskesmas . '</td>
</tr>
<tr style="font-size: large;font-weight: bold">
<td colspan="7" style="text-align: center">KEPADA DAERAH:UNIT : ' . $data->nama_unit . '</td>
</tr>
<tr style="font-size: large;font-weight: bold">
<td colspan="7" style="text-align: center">NO BERITA ACARA SERAH TERIMA: 028/ .24/436.6.3/2014</td>
</tr>
<tr style="font-size: large;font-weight: bold">
<td colspan="7" style="text-align: center"> </td>
</tr>
</table>
<table border="1" cellspacing="3">
<thead>
<tr style="font-weight: bold;text-align: center;">
<th rowspan="2" style="width: 10%">NO</th>
<th rowspan="2" style="width: 10%">TANGGAL</th>
<th rowspan="2" style="width: 30%">Nama & Spesifikasi Barang <br> (Merk, Tipe, Kode, Kode Neraca, No Reg Induk)</th>
<th rowspan="2" style="width: 10%">SATUAN</th>
<th colspan="2" style="width: 20%">JUMLAH</th>
<th rowspan="2" style="width: 20%">NILAI (Rp)</th>
</tr>
<tr style="font-weight: bold;text-align: center;">
<th style="width: 10%">ANGKA</th>
<th style="width: 10%">HURUF</th>
</tr>
</thead>
';
$footer = '</table>';
$content = '';
for ($i = 0; $i < count($dtl); $i++) {
$jml = $dtl[$i]->jumlah * $dtl[$i]->h_satuan;
$content .= '
<tr style="text-align: center;">
<td style="width: 10%">' . ($i + 1) . '</td>
<td style="width: 10%">' . $data->tanggal . '</td>
<td style="width: 30%;text-align: left;"> ' . $dtl[$i]->nama . '<br> ' . $dtl[$i]->kode_bidang . '<br> ' . $dtl[$i]->kode_perwali . '<br> ' . $dtl[$i]->no_register . '</td>
<td style="width: 10%">' . $dtl[$i]->satuan . '</td>
<td style="width: 10%">' . $dtl[$i]->jumlah . '</td>
<td style="width: 10%">' . Terbilang::rupiah($dtl[$i]->jumlah) . '</td>
<td style="width: 20%;text-align: right;">' . number_format($jml + $jml * $dtl[$i]->ppn / 100) . '</td>
</tr>
';
}
//$peg1 = DB::table('pkm_pegawai')->where('id_unit', $data->id_unit)->where('jabatan', 2)->first();
if (Auth::user()->id_puskesmas == '0999') {
$tt = '<tr>
<td style="width: 20%"></td>
<td style="width: 60%">
<table cellpadding="5">
<tr><td colspan="3"> </td></tr>
<tr>
<td style="text-align: right">Mengetahui,</td>
<td style="width: 2%"></td>
<td></td>
</tr>
<tr><td colspan="3"> </td></tr>
<tr><td colspan="3"> </td></tr>
<tr><td colspan="3"> </td></tr>
<tr>
<td>Tanda Tangan</td>
<td style="width: 2%">:</td>
<td>............................</td>
</tr>
<tr>
<td>NAMA</td>
<td style="width: 2%">:</td>
<td>NANIK SUKRISTINA, SKM</td>
</tr>
<tr>
<td>NIP</td>
<td style="width: 2%">:</td>
<td>19700117 199403 2 008</td>
</tr>
<tr>
<td>PANGKAT</td>
<td style="width: 2%">:</td>
<td>PEMBINA / IV A</td>
</tr>
</table>
</td>
<td style="width: 20%"></td>
</tr>';
} else {
$tt = '<tr>
<td colspan="3" style="width: 48%">
<table cellpadding="5">
<tr>
<td colspan="3">Mengetahui,</td>
</tr>
<tr>
<td>Tanda Tangan</td>
<td style="width: 2%">:</td>
<td>............................</td>
</tr>
<tr>
<td>NAMA</td>
<td style="width: 2%">:</td>
<td>' . $ka2->nama_pegawai . '</td>
</tr>
<tr>
<td>NIP</td>
<td style="width: 2%">:</td>
<td>' . $ka2->nip . '</td>
</tr>
<tr>
<td>PANGKAT</td>
<td style="width: 2%">:</td>
<td>' . $ka2->pangkat . '</td>
</tr>
</table>
</td>
<td style="width: 5%"> </td>
<td colspan="3" style="width: 47%">
<table cellpadding="5">
<tr>
<td colspan="3">Yang Menyerahkan,</td>
</tr>
<tr>
<td>Tanda Tangan</td>
<td style="width: 2%">:</td>
<td>............................</td>
</tr>
<tr>
<td>NAMA</td>
<td style="width: 2%">:</td>
<td>' . $ka1->nama_pegawai . '</td>
</tr>
<tr>
<td>NIP</td>
<td style="width: 2%">:</td>
<td>' . $ka1->nip . '</td>
</tr>
<tr>
<td>PANGKAT</td>
<td style="width: 2%">:</td>
<td>' . $ka1->pangkat . '</td>
</tr>
</table>
</td>
</tr>';
}
$ttd = '
<table>
<tr><td colspan="7"> </td></tr>
<tr><td colspan="7"> </td></tr>
<tr>
<td colspan="3" style="width: 48%">
<table cellpadding="5">
<tr>
<td>DAERAH</td>
<td style="width: 2%">:</td>
<td style="width: 90%">KOTA SURABAYA</td>
</tr>
<tr>
<td>UNIT</td>
<td style="width: 2%">:</td>
<td>' . $data->nama_puskesmas . '</td>
</tr>
<tr>
<td>TANGGAL</td>
<td style="width: 2%">:</td>
<td>' . date("d/m/Y") . '</td>
</tr>
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td colspan="3">Yang Menerima,</td>
</tr>
<tr>
<td>Tanda Tangan</td>
<td style="width: 2%">:</td>
<td>............................</td>
</tr>
<tr>
<td>NAMA</td>
<td style="width: 2%">:</td>
<td>' . $pb2->nama_pegawai . '</td>
</tr>
<tr>
<td>NIP</td>
<td style="width: 2%">:</td>
<td>' . $pb2->nip . '</td>
</tr>
<tr>
<td>PANGKAT</td>
<td style="width: 2%">:</td>
<td>' . $pb2->pangkat . '</td>
</tr>
</table>
</td>
<td style="width: 5%"> </td>
<td colspan="3" style="width: 47%">
<table cellpadding="5">
<tr>
<td></td><td></td><td></td>
</tr>
<tr>
<td>Dibuat di</td>
<td style="width: 2%">:</td>
<td>SURABAYA</td>
</tr>
<tr>
<td>TANGGAL</td>
<td style="width: 2%">:</td>
<td>' . date("d/m/Y") . '</td>
</tr>
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td colspan="3">Yang Menyerahkan,</td>
</tr>
<tr>
<td>Tanda Tangan</td>
<td style="width: 2%">:</td>
<td>............................</td>
</tr>
<tr>
<td>NAMA</td>
<td style="width: 2%">:</td>
<td>' . $pb1->nama_pegawai . '</td>
</tr>
<tr>
<td>NIP</td>
<td style="width: 2%">:</td>
<td>' . $pb1->nip . '</td>
</tr>
<tr>
<td>PANGKAT</td>
<td style="width: 2%">:</td>
<td>' . $pb1->pangkat . '</td>
</tr>
</table>
</td>
</tr>
' . $tt . '
</table>
';
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor(PDF_AUTHOR);
$pdf->SetTitle('Gudang DKK');
$pdf->SetSubject('Laporan Penerimaan Barang Pengadaan');
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
$pdf->SetMargins(PDF_MARGIN_LEFT, 10, PDF_MARGIN_RIGHT);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
$pdf->SetAutoPageBreak(TRUE, 8);
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
// CONTENT-------------------------------------------
$pdf->AddPage('P', 'A4');
/*$pdf->SetFont('helvetica', 'B', 10);
$pdf->Write(0, "PEMERINTAH KOTA SURABAYA", '', 0, 'C', true, 0, false, false, 0);
$pdf->SetFont('helvetica', 'B', 12);
$pdf->Write(0, "DINAS KESEHATAN KOTA SURABAYA", '', 0, 'C', true, 0, false, false, 0);
$pdf->SetFont('helvetica', 'U', 10);
$pdf->Write(0, "JL. JEMURSARI NO 197 Tlp (031)8439473, 8439372, Fax. (031)8494965", '', 0, 'C', true, 0, false, false, 0);
$pdf->SetFont('helvetica', 'B', 10);
$pdf->Write(0, , '', 0, 'C', true, 0, false, false, 0);*/
$pdf->ln();
$pdf->SetFont('helvetica', '', 8);
$pdf->writeHTML($header . $content . $footer . $ttd, true, false, false, false, '');
$pdf->Output('ben29' . date('d-m-Y') . ' . pdf', 'I');
}
<?php
include '../../../../../plugin/PHPWord.php';
require_once '../../../../../config/config.php';
require_once '../../../../../config/terbilang.php';
$terbilang = new Terbilang();
ob_clean();
die_login();
$conn = conn($sess_db);
die_conn($conn);
$act = isset($_REQUEST['act']) ? clean($_REQUEST['act']) : '';
$id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : '';
$cb_data = array();
$cb_data = isset($_REQUEST['cb_data']) ? $_REQUEST['cb_data'] : '';
$tanggal_tempo = isset($_REQUEST['tanggal_tempo']) ? clean($_REQUEST['tanggal_tempo']) : '';
$tgl_tempo = fm_date(date("Y-m-d", strtotime($tanggal_tempo)));
$array_bulan = array(1 => 'Januari', 'Februari', 'Maret', 'April', 'Mei', 'Juni', 'Juli', 'Agustus', 'September', 'Oktober', 'November', 'Desember');
if ($act == 'Surat') {
$act = array();
foreach ((array) $cb_data as $id) {
$query = "SELECT *, B.TANGGAL AS TGL_TEMPO FROM SPP A JOIN RENCANA B ON A.KODE_BLOK = B.KODE_BLOK\n\t\t\t\tWHERE A.KODE_BLOK = '{$id}'";
$obj = $conn->execute($query);
$nama_pembeli = $obj->fields['NAMA_PEMBELI'];
$alamat = $obj->fields['ALAMAT_SURAT'];
$TELP_KANTOR = trim($obj->fields["TELP_KANTOR"]) != "" ? trim(strtoupper($obj->fields["TELP_KANTOR"])) : "";
$TELP_LAIN = trim($obj->fields["TELP_LAIN"]) != "" ? "," . trim(strtoupper($obj->fields["TELP_LAIN"])) : "";
$TELP_RUMAH = trim($obj->fields["TELP_RUMAH"]) != "" ? "," . trim(strtoupper($obj->fields["TELP_RUMAH"])) : "";
$telepon = $TELP_KANTOR . $TELP_LAIN . $TELP_RUMAH;
$tanggal_spp = fm_date(date("Y-m-d", strtotime($obj->fields['TANGGAL_SPP'])));
$bulan = $array_bulan[date("n", strtotime($tanggal_tempo))];
$nomor_spp = $obj->fields['NOMOR_SPP'];
<?php
require_once 'kuitansi_lain_proses.php';
require_once '../../../../../config/terbilang.php';
$terbilang = new Terbilang();
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<!-- CSS -->
<link type="text/css" href="../../../../../config/css/style.css" rel="stylesheet">
<link type="text/css" href="../../../../../plugin/css/zebra/default.css" rel="stylesheet">
<!-- JS -->
<script type="text/javascript" src="../../../../../plugin/js/jquery-1.10.2.min.js"></script>
<script type="text/javascript" src="../../../../../plugin/js/jquery-migrate-1.2.1.min.js"></script>
<script type="text/javascript" src="../../../../../plugin/js/jquery.inputmask.custom.js"></script>
<script type="text/javascript" src="../../../../../plugin/js/keymaster.js"></script>
<script type="text/javascript" src="../../../../../plugin/js/zebra_datepicker.js"></script>
<script type="text/javascript" src="../../../../../config/js/main.js"></script>
<script type="text/javascript" src="../../../../../config/js/terbilang_js.js"></script>
<script type="text/javascript">
function calculate(){
var sel_jenis_pembayaran = jQuery('#jenis_pembayaran option:selected');
jenis_pembayaran = sel_jenis_pembayaran.data('jenis');
kode_bayar = jQuery('#jenis_pembayaran').val();
tanah_bangunan = '<?php
echo tanah_bangunan($luas_bangunan);
<?php
require_once '../../../config/config.php';
require_once '../../../config/terbilang.php';
$terbilang = new Terbilang();
die_login();
$conn = conn($sess_db);
die_conn($conn);
//pengembalian stok yang lewat masa reserve
$tgl = f_tgl(date("Y-m-d"));
$query = "\nSELECT *\nFROM \nRESERVE\nWHERE\nBERLAKU_SAMPAI < CONVERT(DATETIME,'{$tgl}',105)\n";
$obj = $conn->execute($query);
while (!$obj->EOF) {
$id = $obj->fields['KODE_BLOK'];
$query2 = "\n\tUPDATE STOK\n\tSET STATUS_STOK = 1, TERJUAL = 0\n\tWHERE\n\tKODE_BLOK = '{$id}'\n\t";
$obj2 = $conn->execute($query2);
$obj->movenext();
}
//penghapusan reserve yang telah lewat masa pembuatan SPP
$conn->Execute("DELETE FROM RESERVE\n\tWHERE\n\tBERLAKU_SAMPAI < CONVERT(DATETIME,'{$tgl}',105)\n\t");
//pengembalian stok yang spp lewat masa tenggang
$tgl = f_tgl(date("Y-m-d"));
$obj = $conn->Execute("SELECT BATAS_DISTRIBUSI FROM CS_PARAMETER_MARK");
$query_batas = $obj->fields['BATAS_DISTRIBUSI'];
$obj = $conn->Execute("SELECT TENGGANG_DISTRIBUSI FROM CS_PARAMETER_MARK");
$query_tenggang = $obj->fields['TENGGANG_DISTRIBUSI'];
$total_hari = $query_batas + $query_tenggang;
$query = "\nSELECT *\nFROM \nSPP\nWHERE\nDATEADD(dd,{$total_hari},TANGGAL_SPP) < CONVERT(DATETIME,'{$tgl}',105)\nAND STATUS_SPP = 2\n";
$obj = $conn->execute($query);
while (!$obj->EOF) {
$id = $obj->fields['KODE_BLOK'];
$NAMA_FILE = $obj->fields['NAMA_FILE'];
//query update status cetak PPJB
$query2 = "\n\tUPDATE CS_PPJB SET {$status}='1' WHERE KODE_BLOK='{$id}';\n\t";
$obj = $conn->execute($query2);
//Format Tanggal Berbahasa Indonesia
// Array Hari
$array_hari = array(1 => 'Senin', 'Selasa', 'Rabu', 'Kamis', 'Jumat', 'Sabtu', 'Minggu');
$hari = $array_hari[date('N')];
//Format Tanggal
$tanggal = date('j');
//Array Bulan
$array_bulan = array(1 => 'Januari', 'Februari', 'Maret', 'April', 'Mei', 'Juni', 'Juli', 'Agustus', 'September', 'Oktober', 'November', 'Desember');
$bulan = $array_bulan[date('n')];
//Format Tahun
$tahun = date('Y');
$bilangan = new Terbilang();
// Include the PHPWord.php, all other classes were loaded by an autoloader
include '../../../../../plugin/PHPWord.php';
// Create a new PHPWord Object
$PHPWord = new PHPWord();
$template = '../../../../../config/Template/' . $NAMA_FILE;
$nama_template = $NAMA_JENIS;
if (file_exists($template)) {
$template = $template;
$document = $PHPWord->loadTemplate($template);
$document->setValue('nomor_ppjb', $nomor);
$document->setValue('hari', $hari);
$document->setValue('tanggal', $tanggal);
$document->setValue('bulan', $bulan);
$document->setValue('tahun', $tahun);
$document->setValue('tahun_terbilang', $bilangan->eja($tahun));
public function report_terima()
{
set_time_limit(60);
$kat = array('cKdSupplier' => 'SUPPLIER', 'cKdSumber' => 'SUMBER ANGGARAN', 'cTahunPengadaan' => 'TAHUN');
$field = array('cKdSupplier' => 'cSupplier', 'cKdSumber' => 'cSumber', 'cTahunPengadaan' => 'cTahunPengadaan');
$awal = Input::get('awal');
$akhir = Input::get('akhir');
$val = array();
if ($awal == '') {
$awal = date('Y-m-d');
}
if ($akhir == '') {
$akhir = date('Y-m-d');
}
if (Input::get('p_sup') != '0') {
$j = explode('-', Input::get('p_sup'));
$tmp = array('cKdSupplier' => $j[0]);
$val += $tmp;
//array_push($val, $tmp);
}
if (Input::get('p_sumber') != '0') {
$j = explode('-', Input::get('p_sumber'));
$tmp = array('cKdSumber' => $j[0]);
$val += $tmp;
//array_push($val, $tmp);
}
if (Input::get('p_tahun') != '') {
$tmp = array('cTahunPengadaan' => Input::get('p_tahun'));
$val += $tmp;
//array_push($val, $tmp);
}
if (Input::get('jns') != '0') {
$barang = DB::table('tbterima')->join('tbterimadtl', 'tbterima.cNomor', '=', 'tbterimadtl.cNomor')->where($val)->where($field[Input::get('jns')], '<>', '')->where('dTanggal', '>=', $awal)->where('dTanggal', '<=', $akhir)->orderBy(Input::get('jns'), 'asc')->orderBy('dTanggal', 'asc')->get();
$data = 'LAPORAN DATA' . count($barang) . ' PENGELUARAN BARANG PER ' . $kat[Input::get('jns')] . ' PERIODE ' . date('d-m-Y', strtotime($awal)) . ' s / d ' . date('d-m-Y', strtotime($akhir));
$header = '
<table cellpadding = "10">
<thead>
<tr style = "font-weight: bold;text-align: center">
<th style = "width: 3%;border-bottom: solid"> </th>
<th style = "width: 5%;border-bottom: solid">NoID</th>
<th style = "width: 10%;border-bottom: solid">Tanggal</th>
<th style = "width: 40%;border-bottom: solid;text-align: left">Nama Barang</th>
<th style = "width: 11%;border-bottom: solid;text-align: right">Harga</th>
<th style = "width: 8%;border-bottom: solid;text-align: right">Qty</th>
<th style = "width: 12%;border-bottom: solid">Satuan</th>
<th style = "width: 11%;border-bottom: solid;text-align: right">Total</th>
</tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
</thead>
';
} else {
$barang = DB::table('tbterima')->join('tbterimadtl', 'tbterima.cNomor', '=', 'tbterimadtl.cNomor')->where($val)->where('dTanggal', '>=', $awal)->where('dTanggal', '<=', $akhir)->orderBy('dTanggal', 'asc')->orderBy('tbterima.cNomor', 'asc')->get();
$data = 'LAPORAN PENERIMAAN BARANG PERIODE ' . date('d-m-Y', strtotime($awal)) . ' s / d ' . date('d-m-Y', strtotime($akhir));
$header = '
<table cellpadding = "10">
<thead>
<tr style = "font-weight: bold;text-align: center;">
<th rowspan="2" style = "width: 3%;border-bottom: solid;border-top: solid;border-right: solid">No</th>
<th rowspan="2" style = "width: 8%;border-bottom: solid;border-top: solid;border-left: solid;border-right: solid">Nomor</th>
<th rowspan="2" style = "width: 6%;border-bottom: solid;border-top: solid;border-left: solid;border-right: solid">Tanggal</th>
<th rowspan="2" style = "width: 22%;border-bottom: solid;border-top: solid;border-left: solid;border-right: solid;text-align: left"> Supplier</th>
<th colspan="2" style = "width: 18%;border-top: solid;border-left: solid;border-right: solid">Bukti Penerimaan</th>
<th colspan="3" style = "width: 26%;border-top: solid;border-left: solid;border-right: solid">Dasar Penerimaan</th>
<th colspan="2" style = "width: 18%;border-top: solid;border-left: solid;">Berita Acara</th>
</tr>
<tr style = "font-weight: bold;text-align: center">
<th style = "width: 12%;border-bottom: solid;border-left: solid;">Nomor</th>
<th style = "width: 6%;border-bottom: solid;border-right: solid">Tanggal</th>
<th style = "width: 8%;border-bottom: solid;border-left: solid">Jenis</th>
<th style = "width: 12%;border-bottom: solid;">Nomor</th>
<th style = "width: 6%;border-bottom: solid;border-right: solid">Tanggal</th>
<th style = "width: 12%;border-bottom: solid;border-left: solid">Nomor</th>
<th style = "width: 6%;border-bottom: solid">Tanggal</th>
</tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
</thead>
';
}
$content = '';
$jenis = '';
$n = 1;
$sum = array(0, 0, 0);
$m = 1;
for ($i = 0; $i < count($barang); $i++) {
if (Input::get('jns') != '0') {
if ($jenis != $barang[$i]->{$field}[Input::get('jns')]) {
if ($i != 0) {
$content .= '
<tr style = "vertical-align: middle;font-weight: bold">
<td style = "width: 3%;"> </td>
<td style = "width: 5%;"> </td>
<td style = "width: 10%;"> </td>
<td style = "width: 40%;text-align: right"> Jumlah </td>
<td style = "width: 11%;text-align: right">' . Terbilang::format_no_sign($sum[0]) . '</td>
<td style = "width: 8%;text-align: right">' . number_format($sum[1]) . '</td>
<td style = "width: 12%;"> </td>
<td style = "width: 11%;text-align: right">' . Terbilang::format_no_sign($sum[2]) . '</td>
</tr> ';
}
$sum = array(0, 0, 0);
$content .= '
<tr style = "vertical-align: middle">
<td style = "width: 3%;text-align: center;font-weight: bold"> ' . $n . ' </td>
<td colspan = "7" style = "font-weight: bold"> ' . $barang[$i]->{$field}[Input::get('jns')] . ' </td>
</tr> ';
$jenis = $barang[$i]->{$field}[Input::get('jns')];
$m = 1;
$n++;
}
$content .= '
<tr style = "vertical-align: middle;text-align: center">
<td style = "width: 3%;"> </td>
<td style = "width: 5%;">' . sprintf("%03d", $m) . '</td>
<td style = "width: 10%;">' . date('d-m-Y', strtotime($barang[$i]->dTanggal)) . '</td>
<td style = "width: 40%;text-align: left">' . $barang[$i]->cNama . '</td>
<td style = "width: 11%;text-align: right">' . Terbilang::format_no_sign($barang[$i]->nHarga) . '</td>
<td style = "width: 8%;text-align: right">' . number_format($barang[$i]->nQty) . '</td>
<td style = "width: 12%;">' . $barang[$i]->cSatuan . '</td>
<td style = "width: 11%;text-align: right">' . Terbilang::format_no_sign($barang[$i]->nSTotal) . '</td>
</tr>';
$m++;
$sum = array($sum[0] + $barang[$i]->nHarga, $sum[1] + $barang[$i]->nQty, $sum[2] + $barang[$i]->nSTotal);
} else {
if ($jenis != $barang[$i]->cNomor) {
$sum = 0;
$content .= '
<tr style = "font-weight: bold;text-align: center">
<td style = "width: 3%;">' . $n . '</td>
<td style = "width: 8%;">' . $barang[$i]->cNomor . '</td>
<td style = "width: 6%;">' . date('d-m-Y', strtotime($barang[$i]->dTanggal)) . '</td>
<td style = "width: 22%;text-align: left">' . $barang[$i]->cSupplier . '</td>
<td style = "width: 12%;">' . $barang[$i]->cNoBukti . '</td>
<td style = "width: 6%;">' . date('d-m-Y', strtotime($barang[$i]->dTglBukti)) . '</td>
<td style = "width: 8%;">' . $barang[$i]->cJnsSurat . '</td>
<td style = "width: 12%;">' . $barang[$i]->cNoSurat . '</td>
<td style = "width: 6%;">' . date('d-m-Y', strtotime($barang[$i]->dTglSurat)) . '</td>
<td style = "width: 12%;">' . $barang[$i]->cNoAcara . '</td>
<td style = "width: 6%;">' . date('d-m-Y', strtotime($barang[$i]->dTglAcara)) . '</td>
</tr>';
$jenis = $barang[$i]->cNomor;
$m = 1;
$n++;
}
$content .= '
<tr style="text-align: center">
<td style="width: 3%"> </td>
<td style="width: 5%">' . sprintf("%03d", $m) . '</td>
<td style = "width: 30%;text-align: left">' . $barang[$i]->cNama . '</td>
<td style = "width: 11%;text-align: right">' . Terbilang::format_no_sign($barang[$i]->nHarga) . '</td>
<td style = "width: 8%;text-align: right">' . number_format($barang[$i]->nQty) . '</td>
<td style = "width: 10%;text-align: left">' . $barang[$i]->cSatuan . '</td>
<td style = "width: 11%;text-align: right">' . Terbilang::format_no_sign($barang[$i]->nSTotal) . '</td>
</tr>';
$m++;
}
}
if (Input::get('jns') != '0') {
$content .= '
<tr style = "vertical-align: middle;font-weight: bold">
<td style = "width: 3%;"> </td>
<td style = "width: 5%;"> </td>
<td style = "width: 10%;"> </td>
<td style = "width: 40%;text-align: right"> Jumlah </td>
<td style = "width: 11%;text-align: right"> ' . Terbilang::format_no_sign($sum[0]) . '</td>
<td style = "width: 8%;text-align: right"> ' . number_format($sum[1]) . '</td>
<td style = "width: 12%;"> </td>
<td style = "width: 11%;text-align: right"> ' . Terbilang::format_no_sign($sum[2]) . '</td>
</tr> ';
}
$footer = "</table>";
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor(PDF_AUTHOR);
$pdf->SetTitle('Gudang DKK');
$pdf->SetSubject('Laporan Stok Barang');
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
$pdf->SetMargins(PDF_MARGIN_LEFT, 10, PDF_MARGIN_RIGHT);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
$pdf->SetAutoPageBreak(TRUE, 8);
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
// CONTENT-------------------------------------------
$pdf->SetFont('helvetica', 'B', 10);
if (Input::get('jns') != '0') {
$pdf->AddPage('P', 'A4');
} else {
$pdf->AddPage('L', 'A4');
}
$pdf->Write(0, "PEMERINTAH KOTA SURABAYA", '', 0, 'C', true, 0, false, false, 0);
$pdf->SetFont('helvetica', 'B', 12);
$pdf->Write(0, "DINAS KESEHATAN KOTA SURABAYA", '', 0, 'C', true, 0, false, false, 0);
$pdf->SetFont('helvetica', 'U', 10);
$pdf->Write(0, "JL. JEMURSARI NO 197 Tlp (031)8439473, 8439372, Fax. (031)8494965", '', 0, 'C', true, 0, false, false, 0);
$pdf->SetFont('helvetica', 'B', 10);
$pdf->Write(0, $data, '', 0, 'C', true, 0, false, false, 0);
$pdf->ln();
$pdf->SetFont('helvetica', '', 8);
$pdf->writeHTML($header . $content . $footer, true, false, false, false, '');
$pdf->Output('laporan_penerimaan' . date('d-m-Y') . ' . pdf', 'I');
//return '';
}
<?php
require_once '../../../../../config/config.php';
require_once '../../../../../config/terbilang.php';
die_login();
//die_app('');
//die_mod('');
$conn = conn($sess_db);
die_conn($conn);
$terbilang = new Terbilang();
$id = isset($_REQUEST['id']) ? base64_decode(clean($_REQUEST['id'])) : '';
$catatan_kwt = isset($_REQUEST['catatan_kwt']) ? clean($_REQUEST['catatan_kwt']) : '';
$query = "\n\tSELECT * \n\tFROM KWITANSI_LAIN_LAIN\n\tWHERE NOMOR_KWITANSI = '{$id}'\n";
$obj = $conn->execute($query);
$nama_pembayar = $obj->fields['NAMA_PEMBAYAR'];
$keterangan = $obj->fields['KETERANGAN'];
$nilai = $obj->fields['NILAI'];
$tanggal = kontgl(tgltgl(date("d M Y", strtotime($obj->fields['TANGGAL']))));
$query = "\n\t\tUPDATE KWITANSI_LAIN_LAIN SET \n\t\t\tSTATUS_KWT = '1',\n\t\t\tCATATAN_KWT = '{$catatan_kwt}'\n\t\tWHERE NOMOR_KWITANSI = '{$id}'\n\t\t";
ex_false($conn->Execute($query), $query);
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<style type="text/css">
@page {
size: A4;
margin: 0;
}
<?php
require_once 'spp_proses.php';
require_once '../../../../../config/config.php';
require_once '../../../../../config/terbilang.php';
$terbilang = new Terbilang();
die_login();
//die_app('');
//die_mod('');
$conn = conn($sess_db);
die_conn($conn);
$kode_blok = $id;
$blok = explode("-", $kode_blok);
$no_unit = $blok[1];
$jml = strlen($blok[0]);
if ($jml > 2) {
$tower = substr($blok[0], 0, 1);
$tower = $terbilang->tower($tower);
$lantai = substr($blok[0], 1, 2);
} else {
$tower = substr($blok[0], 0, 1);
$tower = $terbilang->tower($tower);
$lantai = "0" . substr($blok[0], 1, 3);
}
$costumer_id = "SF" . $tower . $lantai . $no_unit;
?>
<!DOCTYPE HTML>
<html>
<head>
<style>
.error {color: #FF0000;}
echo $salaryallowance->values;
?>
</td></tr>
<?php
}
?>
</tbody>
</table>
</td>
</tr>
</tbody>
<tfoot>
<table class="table">
<tbody>
<tr><td colspan="2" width="50%"><span class="terbilang"><?php
echo Terbilang::write($model->total_salary);
?>
</span></td>
<th><?php
echo at('Take Home Pay');
?>
</th>
<td><?php
echo $model->total_salary;
?>
</td>
</tr>
</tbody>
</table>
</tfoot>
</table>
<?php
require_once 'tanda_terima_proses.php';
require_once '../../../../../config/terbilang.php';
$terbilang = new Terbilang();
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<!-- CSS -->
<link type="text/css" href="../../../../../config/css/style.css" rel="stylesheet">
<link type="text/css" href="../../../../../plugin/css/zebra/default.css" rel="stylesheet">
<link type="text/css" href="../../../../../plugin/window/themes/default.css" rel="stylesheet">
<link type="text/css" href="../../../../../plugin/window/themes/mac_os_x.css" rel="stylesheet">
<!-- JS -->
<script type="text/javascript" src="../../../../../plugin/js/jquery-1.10.2.min.js"></script>
<script type="text/javascript" src="../../../../../plugin/js/jquery-migrate-1.2.1.min.js"></script>
<script type="text/javascript" src="../../../../../plugin/js/jquery.inputmask.custom.js"></script>
<script type="text/javascript" src="../../../../../plugin/js/keymaster.js"></script>
<script type="text/javascript" src="../../../../../plugin/js/zebra_datepicker.js"></script>
<script type="text/javascript" src="../../../../../plugin/window/javascripts/prototype.js"></script>
<script type="text/javascript" src="../../../../../plugin/window/javascripts/window.js"></script>
<script type="text/javascript" src="../../../../../config/js/main.js"></script>
<script type="text/javascript" src="../../../../../config/js/terbilang_js.js"></script>
<script type="text/javascript">
jQuery(function($) {
if ('<?php
echo $act;
public function lap_keluar()
{
set_time_limit(300);
$awal = Input::get('awal');
$akhir = Input::get('akhir');
if ($awal == '') {
$awal = date('Y-m-d');
}
if ($akhir == '') {
$akhir = date('Y-m-d');
}
$jenis = Input::get('jns');
$format = Input::get('format');
switch ($jenis) {
case "0":
$barang = DB::table('pkm_alokasi')->join('pkm_alokasidtl', 'pkm_alokasi.nomor', '=', 'pkm_alokasidtl.nomor')->join('pkm_inventori', 'pkm_alokasidtl.id_inventori', '=', 'pkm_inventori.id')->where('pkm_alokasi.tanggal', '>=', $awal)->where('pkm_alokasi.tanggal', '<=', $akhir)->select('pkm_alokasi.*', 'pkm_alokasidtl.harga', 'pkm_alokasidtl.jumlah', 'nama_barang', 'nama_satuan')->orderBy('pkm_alokasi.tanggal', 'asc')->orderBy('id_puskesmas', 'asc')->get();
$data = 'LAPORAN PENGELUARAN BARANG PERIODE ' . date('d-m-Y', strtotime($awal)) . ' s / d ' . date('d-m-Y', strtotime($akhir));
$header = '
<table cellpadding = "10">
<thead>
<tr style = "font-weight: bold;text-align: center;">
<th style = "width: 5%;">No</th>
<th style = "width: 15%;">Nomor</th>
<th style = "width: 10%;">Tanggal</th>
<th style = "width: 35%;text-align: left"> Puskesmas</th>
<th style = "width: 35%;text-align: left"> Unit</th>
</tr>
<tr><td></td><td></td><td></td><td></td><td></td></tr>
</thead>
';
$content = '';
$jenis = '';
$n = 1;
$m = 1;
for ($i = 0; $i < count($barang); $i++) {
if ($jenis != $barang[$i]->nomor) {
$content .= '
<tr style = "font-weight: bold;text-align: left">
<td style = "width: 5%;text-align: center">' . $n . '</td>
<td style = "width: 15%;">' . $barang[$i]->nomor . '</td>
<td style = "width: 10%;text-align: center">' . $barang[$i]->tanggal . '</td>
<td style = "width: 35%;">' . $barang[$i]->id_puskesmas . '-' . $barang[$i]->nama_puskesmas . '</td>
<td style = "width: 35%;">' . $barang[$i]->id_unit . '-' . $barang[$i]->nama_unit . '</td>
</tr>';
$jenis = $barang[$i]->nomor;
$m = 1;
$n++;
}
$content .= '
<tr style="text-align: center">
<td style="width: 5%"> </td>
<td style="width: 5%">' . sprintf("%03d", $m) . '</td>
<td style = "width: 30%;text-align: left">' . $barang[$i]->nama_barang . '</td>
<td style = "width: 10%;text-align: right">' . Terbilang::format_no_sign($barang[$i]->harga) . '</td>
<td style = "width: 10%;text-align: right">' . number_format($barang[$i]->jumlah) . '</td>
<td style = "width: 10%;text-align: left">' . $barang[$i]->nama_satuan . '</td>
<td style = "width: 10%;text-align: right">' . Terbilang::format_no_sign($barang[$i]->harga * $barang[$i]->jumlah) . '</td>
</tr>';
$m++;
}
break;
case "id_unit":
$sup = Input::get('p_unit');
if ($sup == '') {
$op = '<>';
} else {
$op = '=';
}
$barang = DB::table('pkm_alokasi')->join('pkm_alokasidtl', 'pkm_alokasi.nomor', '=', 'pkm_alokasidtl.nomor')->join('pkm_inventori', 'pkm_alokasidtl.id_inventori', '=', 'pkm_inventori.id')->where('pkm_alokasi.id_unit', $op, $sup)->where('pkm_alokasi.tanggal', '>=', $awal)->where('pkm_alokasi.tanggal', '<=', $akhir)->select('pkm_alokasi.*', 'pkm_alokasidtl.harga', 'pkm_alokasidtl.jumlah', 'nama_barang', 'nama_satuan')->orderBy('pkm_alokasi.id_unit', 'asc')->orderBy('pkm_alokasi.tanggal', 'asc')->get();
$data = 'LAPORAN PENGELUARAN PUSKESMAS PER UNIT PERIODE ' . date('d-m-Y', strtotime($awal)) . ' s / d ' . date('d-m-Y', strtotime($akhir));
$header = '
<table cellpadding = "10">
<thead>
<tr style = "font-weight: bold;text-align: center">
<th style = "width: 3%;"> </th>
<th style = "width: 5%;">NoID</th>
<th style = "width: 10%">Tanggal</th>
<th style = "width: 40%;text-align: left">Nama Barang</th>
<th style = "width: 11%;text-align: right">Harga</th>
<th style = "width: 8%;text-align: right">Qty</th>
<th style = "width: 12%;">Satuan</th>
<th style = "width: 11%;text-align: right">Total</th>
</tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
</thead>
';
$content = '';
$jenis = '';
$n = 1;
$sum = array(0, 0, 0);
$m = 1;
for ($i = 0; $i < count($barang); $i++) {
if ($jenis != $barang[$i]->id_unit) {
if ($i != 0) {
$content .= '
<tr style = "vertical-align: middle;font-weight: bold">
<td style = "width: 3%;"> </td>
<td style = "width: 5%;"> </td>
<td style = "width: 10%;"> </td>
<td style = "width: 40%;text-align: right"> Jumlah </td>
<td style = "width: 11%;text-align: right">' . Terbilang::format_no_sign($sum[0]) . '</td>
<td style = "width: 8%;text-align: right">' . number_format($sum[1]) . '</td>
<td style = "width: 12%;"> </td>
<td style = "width: 11%;text-align: right">' . Terbilang::format_no_sign($sum[2]) . '</td>
</tr> ';
}
$sum = array(0, 0, 0);
$content .= '
<tr style = "vertical-align: middle">
<td style = "width: 3%;text-align: center;font-weight: bold"> ' . $n . ' </td>
<td colspan = "7" style = "font-weight: bold"> ' . $barang[$i]->nama_unit . ' </td>
</tr> ';
$jenis = $barang[$i]->id_unit;
$m = 1;
$n++;
}
$content .= '
<tr style = "vertical-align: middle;text-align: center">
<td style = "width: 3%;"> </td>
<td style = "width: 5%;">' . sprintf("%03d", $m) . '</td>
<td style = "width: 10%;">' . date('d-m-Y', strtotime($barang[$i]->tanggal)) . '</td>
<td style = "width: 40%;text-align: left">' . $barang[$i]->nama_barang . '</td>
<td style = "width: 11%;text-align: right">' . Terbilang::format_no_sign($barang[$i]->harga) . '</td>
<td style = "width: 8%;text-align: right">' . number_format($barang[$i]->jumlah) . '</td>
<td style = "width: 12%;">' . $barang[$i]->nama_satuan . '</td>
<td style = "width: 11%;text-align: right">' . Terbilang::format_no_sign($barang[$i]->harga * $barang[$i]->jumlah) . '</td>
</tr>';
$m++;
$sum = array($sum[0] + $barang[$i]->harga, $sum[1] + $barang[$i]->jumlah, $sum[2] + $barang[$i]->harga * $barang[$i]->jumlah);
}
$content .= '
<tr style = "vertical-align: middle;font-weight: bold">
<td style = "width: 3%;"> </td>
<td style = "width: 5%;"> </td>
<td style = "width: 10%;"> </td>
<td style = "width: 40%;text-align: right"> Jumlah </td>
<td style = "width: 11%;text-align: right"> ' . Terbilang::format_no_sign($sum[0]) . '</td>
<td style = "width: 8%;text-align: right"> ' . number_format($sum[1]) . '</td>
<td style = "width: 12%;"> </td>
<td style = "width: 11%;text-align: right"> ' . Terbilang::format_no_sign($sum[2]) . '</td>
</tr> ';
break;
case "id_puskesmas":
$sup = explode('-', Input::get('p_pkm'));
if ($sup[0] == '') {
$op = '<>';
} else {
$op = '=';
}
$barang = DB::table('pkm_alokasi')->join('pkm_alokasidtl', 'pkm_alokasi.nomor', '=', 'pkm_alokasidtl.nomor')->join('pkm_inventori', 'pkm_alokasidtl.id_inventori', '=', 'pkm_inventori.id')->where('pkm_alokasi.id_puskesmas', $op, $sup[0])->where('pkm_alokasi.tanggal', '>=', $awal)->where('pkm_alokasi.tanggal', '<=', $akhir)->select('pkm_alokasi.*', 'pkm_alokasidtl.harga', 'pkm_alokasidtl.jumlah', 'nama_barang', 'nama_satuan')->orderBy('pkm_alokasi.id_puskesmas', 'asc')->orderBy('pkm_alokasi.tanggal', 'asc')->get();
$data = 'LAPORAN PENGELUARAN PUSKESMAS PER PUSKESMAS PERIODE ' . date('d-m-Y', strtotime($awal)) . ' s / d ' . date('d-m-Y', strtotime($akhir));
$header = '
<table cellpadding = "10">
<thead>
<tr style = "font-weight: bold;text-align: center">
<th style = "width: 3%;"> </th>
<th style = "width: 5%;">NoID</th>
<th style = "width: 10%">Tanggal</th>
<th style = "width: 40%;text-align: left">Nama Barang</th>
<th style = "width: 11%;text-align: right">Harga</th>
<th style = "width: 8%;text-align: right">Qty</th>
<th style = "width: 12%;">Satuan</th>
<th style = "width: 11%;text-align: right">Total</th>
</tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
</thead>
';
$content = '';
$jenis = '';
$n = 1;
$sum = array(0, 0, 0);
$m = 1;
for ($i = 0; $i < count($barang); $i++) {
if ($jenis != $barang[$i]->id_puskesmas) {
if ($i != 0) {
$content .= '
<tr style = "vertical-align: middle;font-weight: bold">
<td style = "width: 3%;"> </td>
<td style = "width: 5%;"> </td>
<td style = "width: 10%;"> </td>
<td style = "width: 40%;text-align: right"> Jumlah </td>
<td style = "width: 11%;text-align: right">' . Terbilang::format_no_sign($sum[0]) . '</td>
<td style = "width: 8%;text-align: right">' . number_format($sum[1]) . '</td>
<td style = "width: 12%;"> </td>
<td style = "width: 11%;text-align: right">' . Terbilang::format_no_sign($sum[2]) . '</td>
</tr> ';
}
$sum = array(0, 0, 0);
$content .= '
<tr style = "vertical-align: middle">
<td style = "width: 3%;text-align: center;font-weight: bold"> ' . $n . ' </td>
<td colspan = "7" style = "font-weight: bold"> ' . $barang[$i]->nama_puskesmas . ' </td>
</tr> ';
$jenis = $barang[$i]->id_puskesmas;
$m = 1;
$n++;
}
$content .= '
<tr style = "vertical-align: middle;text-align: center">
<td style = "width: 3%;"> </td>
<td style = "width: 5%;">' . sprintf("%03d", $m) . '</td>
<td style = "width: 10%;">' . date('d-m-Y', strtotime($barang[$i]->tanggal)) . '</td>
<td style = "width: 40%;text-align: left">' . $barang[$i]->nama_barang . '</td>
<td style = "width: 11%;text-align: right">' . Terbilang::format_no_sign($barang[$i]->harga) . '</td>
<td style = "width: 8%;text-align: right">' . number_format($barang[$i]->jumlah) . '</td>
<td style = "width: 12%;">' . $barang[$i]->nama_satuan . '</td>
<td style = "width: 11%;text-align: right">' . Terbilang::format_no_sign($barang[$i]->harga * $barang[$i]->jumlah) . '</td>
</tr>';
$m++;
$sum = array($sum[0] + $barang[$i]->harga, $sum[1] + $barang[$i]->jumlah, $sum[2] + $barang[$i]->harga * $barang[$i]->jumlah);
}
$content .= '
<tr style = "vertical-align: middle;font-weight: bold">
<td style = "width: 3%;"> </td>
<td style = "width: 5%;"> </td>
<td style = "width: 10%;"> </td>
<td style = "width: 40%;text-align: right"> Jumlah </td>
<td style = "width: 11%;text-align: right"> ' . Terbilang::format_no_sign($sum[0]) . '</td>
<td style = "width: 8%;text-align: right"> ' . number_format($sum[1]) . '</td>
<td style = "width: 12%;"> </td>
<td style = "width: 11%;text-align: right"> ' . Terbilang::format_no_sign($sum[2]) . '</td>
</tr> ';
break;
case "id_barang":
$sup1 = Input::get('p_jb');
if ($sup1 == '') {
$op = '<>';
} else {
$op = '=';
}
$sup = Input::get('p_b');
if ($sup == '') {
$barang = DB::table('pkm_alokasi')->join('pkm_alokasidtl', 'pkm_alokasi.nomor', '=', 'pkm_alokasidtl.nomor')->join('pkm_inventori', 'pkm_alokasidtl.id_inventori', '=', 'pkm_inventori.id')->where('jenis', $op, $sup1)->where('pkm_alokasi.tanggal', '>=', $awal)->where('pkm_alokasi.tanggal', '<=', $akhir)->select('pkm_alokasi.*', 'pkm_alokasidtl.harga', 'pkm_alokasidtl.jumlah', 'id_barang', 'nama_barang', 'nama_satuan')->orderBy('id_barang', 'asc')->orderBy('pkm_alokasi.tanggal', 'asc')->get();
} else {
$barang = DB::table('pkm_alokasi')->join('pkm_alokasidtl', 'pkm_alokasi.nomor', '=', 'pkm_alokasidtl.nomor')->join('pkm_inventori', 'pkm_alokasidtl.id_inventori', '=', 'pkm_inventori.id')->where('id_barang', $sup)->where('pkm_alokasi.tanggal', '>=', $awal)->where('pkm_alokasi.tanggal', '<=', $akhir)->select('pkm_alokasi.*', 'pkm_alokasidtl.harga', 'pkm_alokasidtl.jumlah', 'id_barang', 'nama_barang', 'nama_satuan')->orderBy('id_barang', 'asc')->orderBy('pkm_alokasi.tanggal', 'asc')->get();
}
$data = 'LAPORAN PENGELUARAN PUSKESMAS PER BARANG PERIODE ' . date('d-m-Y', strtotime($awal)) . ' s / d ' . date('d-m-Y', strtotime($akhir));
$header = '
<table cellpadding = "10">
<thead>
<tr style = "font-weight: bold;text-align: center">
<th style = "width: 3%;"> </th>
<th style = "width: 5%;">NoID</th>
<th style = "width: 10%">Tanggal</th>
<th style = "width: 20%;text-align: left">Puskesmas</th>
<th style = "width: 20%;text-align: left">Unit</th>
<th style = "width: 11%;text-align: right">Harga</th>
<th style = "width: 8%;text-align: right">Qty</th>
<th style = "width: 12%;">Satuan</th>
<th style = "width: 11%;text-align: right">Total</th>
</tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
</thead>
';
$content = '';
$jenis = '';
$n = 1;
$sum = array(0, 0, 0);
$m = 1;
for ($i = 0; $i < count($barang); $i++) {
if ($jenis != $barang[$i]->id_barang) {
if ($i != 0) {
$content .= '
<tr style = "vertical-align: middle;font-weight: bold">
<td style = "width: 3%;"> </td>
<td style = "width: 5%;"> </td>
<td style = "width: 10%;"> </td>
<td style = "width: 20%;text-align: right"> </td>
<td style = "width: 20%;text-align: right"> Jumlah </td>
<td style = "width: 11%;text-align: right">' . Terbilang::format_no_sign($sum[0]) . '</td>
<td style = "width: 8%;text-align: right">' . number_format($sum[1]) . '</td>
<td style = "width: 12%;"> </td>
<td style = "width: 11%;text-align: right">' . Terbilang::format_no_sign($sum[2]) . '</td>
</tr> ';
}
$sum = array(0, 0, 0);
$content .= '
<tr style = "vertical-align: middle">
<td style = "width: 3%;text-align: center;font-weight: bold"> ' . $n . ' </td>
<td colspan = "7" style = "font-weight: bold"> ' . $barang[$i]->nama_barang . ' </td>
</tr> ';
$jenis = $barang[$i]->id_barang;
$m = 1;
$n++;
}
$content .= '
<tr style = "vertical-align: middle;text-align: center">
<td style = "width: 3%;"> </td>
<td style = "width: 5%;">' . sprintf("%03d", $m) . '</td>
<td style = "width: 10%;">' . date('d-m-Y', strtotime($barang[$i]->tanggal)) . '</td>
<td style = "width: 20%;text-align: left">' . $barang[$i]->nama_puskesmas . '</td>
<td style = "width: 20%;text-align: left">' . $barang[$i]->nama_unit . '</td>
<td style = "width: 11%;text-align: right">' . Terbilang::format_no_sign($barang[$i]->harga) . '</td>
<td style = "width: 8%;text-align: right">' . number_format($barang[$i]->jumlah) . '</td>
<td style = "width: 12%;">' . $barang[$i]->nama_satuan . '</td>
<td style = "width: 11%;text-align: right">' . Terbilang::format_no_sign($barang[$i]->harga * $barang[$i]->jumlah) . '</td>
</tr>';
$m++;
$sum = array($sum[0] + $barang[$i]->harga, $sum[1] + $barang[$i]->jumlah, $sum[2] + $barang[$i]->harga * $barang[$i]->jumlah);
}
$content .= '
<tr style = "vertical-align: middle;font-weight: bold">
<td style = "width: 3%;"> </td>
<td style = "width: 5%;"> </td>
<td style = "width: 10%;"> </td>
<td style = "width: 20%;text-align: right"> </td>
<td style = "width: 20%;text-align: right"> Jumlah </td>
<td style = "width: 11%;text-align: right"> ' . Terbilang::format_no_sign($sum[0]) . '</td>
<td style = "width: 8%;text-align: right"> ' . number_format($sum[1]) . '</td>
<td style = "width: 12%;"> </td>
<td style = "width: 11%;text-align: right"> ' . Terbilang::format_no_sign($sum[2]) . '</td>
</tr> ';
break;
default:
echo "Your favorite color is neither red, blue, or green!";
}
$footer = '</table>';
switch ($format) {
case "0":
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor(PDF_AUTHOR);
$pdf->SetTitle('Gudang DKK');
$pdf->SetSubject('Laporan Pengeluaran Barang');
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
$pdf->SetMargins(PDF_MARGIN_LEFT, 10, PDF_MARGIN_RIGHT);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
$pdf->SetAutoPageBreak(TRUE, 8);
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
// CONTENT-------------------------------------------
$pdf->SetFont('helvetica', 'B', 10);
if (Input::get('jns') != '0') {
$pdf->AddPage('P', 'A4');
} else {
$pdf->AddPage('P', 'A4');
}
$pdf->Write(0, "PEMERINTAH KOTA SURABAYA", '', 0, 'C', true, 0, false, false, 0);
$pdf->SetFont('helvetica', 'B', 12);
$pdf->Write(0, "DINAS KESEHATAN KOTA SURABAYA", '', 0, 'C', true, 0, false, false, 0);
$pdf->SetFont('helvetica', 'U', 10);
$pdf->Write(0, "JL. JEMURSARI NO 197 Tlp (031)8439473, 8439372, Fax. (031)8494965", '', 0, 'C', true, 0, false, false, 0);
$pdf->SetFont('helvetica', 'B', 10);
$pdf->Write(0, $data, '', 0, 'C', true, 0, false, false, 0);
$pdf->ln();
$pdf->SetFont('helvetica', '', 8);
$pdf->writeHTML($header . $content . $footer, true, false, false, false, '');
$pdf->Output('lap_keluar_all' . date('d-m-Y') . ' . pdf', 'I');
break;
case "1":
$header1 = '
<table cellpadding = "10" border="1">
<tr style="font-weight: bold;"><td colspan="7" style="text-align: center">PEMERINTAH KOTA SURABAYA</td></tr>
<tr style="font-weight: bold;"><td colspan="7" style="text-align: center">DINAS KESEHATAN KOTA SURABAYA</td></tr>
<tr style="font-weight: bold;"><td colspan="7" style="text-align: center">JL. JEMURSARI NO 197 Tlp (031)8439473, 8439372, Fax. (031)8494965</td></tr>
<tr style="font-weight: bold;"><td colspan="7" style="text-align: center">' . $data . '</td></tr>
<tr style="font-weight: bold;"><td colspan="7"></td></tr>
</table>
';
$tabel = $header1 . $header . $content . $footer;
//return View::make('excel', compact('tabel'));
Excel::create('Lapkeluarall_' . date('d-m-Y'), function ($excel) use($tabel) {
$excel->sheet('Pengeluaran', function ($sheet) use($tabel) {
$sheet->loadView('excel', array('tabel' => $tabel));
});
})->export('xls');
break;
default:
echo "Eror Value!!";
}
}
$kode_kelurahan = $obj->fields['KODE_KELURAHAN'];
$nama_kelurahan = $obj->fields['NAMA_KELURAHAN'];
$kode_kecamatan = $obj->fields['KODE_KECAMATAN'];
$nama_kecamatan = $obj->fields['NAMA_KECAMATAN'];
//Format Tanggal Berbahasa Indonesia
// Array Hari
$array_hari = array(1 => 'Senin', 'Selasa', 'Rabu', 'Kamis', 'Jumat', 'Sabtu', 'Minggu');
$hari = $array_hari[date('N')];
//Format Tanggal
$tanggal = date('j');
//Array Bulan
$array_bulan = array(1 => 'Januari', 'Februari', 'Maret', 'April', 'Mei', 'Juni', 'Juli', 'Agustus', 'September', 'Oktober', 'November', 'Desember');
$bulan = $array_bulan[date('n')];
//Format Tahun
$tahun = date('Y');
$bilangan = new Terbilang();
// Include the PHPWord.php, all other classes were loaded by an autoloader
include '../../../../../plugin/PHPWord.php';
// Create a new PHPWord Object
$PHPWord = new PHPWord();
$template = '../../../../../config/Template/PPJB_Pengalihan_Hak.docx';
if (file_exists($template)) {
$template = $template;
$document = $PHPWord->loadTemplate($template);
$document->setValue('kode_blok', $kode_blok);
$pecah = explode("/", $kode_blok);
$pecah2 = explode("-", $pecah[1]);
$nomor_unit = $pecah2[1];
$document->setValue('nomor_unit', $nomor_unit);
$document->setValue('no_ppjb_ph', $no_ppjb_ph);
$document->setValue('no_ppjb_awal', $no_ppjb_awal);
<?php
require_once '../../../../../config/config.php';
require_once '../../../../../config/terbilang.php';
require_once 'ppjb_proses.php';
?>
<?php
$bilangan = new Terbilang();
//echo $bilangan -> eja(100000000000000012);
//Format Tanggal Berbahasa Indonesia
// Array Hari
$array_hari = array(1 => 'Senin', 'Selasa', 'Rabu', 'Kamis', 'Jumat', 'Sabtu', 'Minggu');
$hari = $array_hari[date('N')];
//Format Tanggal
$tanggal = date('j');
//Array Bulan
$array_bulan = array(1 => 'Januari', 'Februari', 'Maret', 'April', 'Mei', 'Juni', 'Juli', 'Agustus', 'September', 'Oktober', 'November', 'Desember');
$bulan = $array_bulan[date('n')];
//Format Tahun
$tahun = date('Y');
$nama_file = "PPJB " . $nama_pembeli . " " . $tanggal . " " . $bulan . " " . $tahun . ".doc";
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"" . basename($nama_file) . "\"");
header("Pragma: no-cache");
header("Expires: 0");
?>
<?php
$query = "\n\tSELECT *\n\tFROM\n\tCS_PARAMETER_PPJB";
$obj = $conn->execute($query);
<?php
require_once '../../../../config/config.php';
require_once '../../../../config/terbilang.php';
require_once 'spp_proses.php';
$terbilang = new Terbilang();
//Format Tanggal Berbahasa Indonesia
// Array Hari
$array_hari = array(1 => 'Senin', 'Selasa', 'Rabu', 'Kamis', 'Jumat', 'Sabtu', 'Minggu');
$hari = $array_hari[date('N')];
//Format Tanggal
$tanggal = date('j');
//Array Bulan
$array_bulan = array(1 => 'Januari', 'Februari', 'Maret', 'April', 'Mei', 'Juni', 'Juli', 'Agustus', 'September', 'Oktober', 'November', 'Desember');
$bulan = $array_bulan[date('n')];
//Format Tahun
$tahun = date('Y');
$query = "SELECT *,s.NPWP AS CS_NPWP FROM SPP S\nLEFT JOIN BANK B ON S.KODE_BANK = B.KODE_BANK\nWHERE S.KODE_BLOK = '{$id}'";
$obj = $conn->execute($query);
$tgl_spp = tgltgl(f_tgl($obj->fields['TANGGAL_SPP']));
$no_customer = $obj->fields['NOMOR_CUSTOMER'];
$no_spp = $obj->fields['NOMOR_SPP'];
$nama = $obj->fields['NAMA_PEMBELI'];
$alamat_rumah = $obj->fields['ALAMAT_RUMAH'];
$alamat_surat = $obj->fields['ALAMAT_SURAT'];
$alamat_npwp = $obj->fields['ALAMAT_NPWP'];
$email = $obj->fields['ALAMAT_EMAIL'];
$tlp_rumah = $obj->fields['TELP_RUMAH'];
$tlp_kantor = $obj->fields['TELP_KANTOR'];
$tlp_lain = $obj->fields['TELP_LAIN'];
$identitas = $obj->fields['IDENTITAS'];
