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'];