$pdf->Cell(7 / 100 * $width, $height, $tglBapb, 1, 1, 'C', 1); //if($limit==46) // { // $limit=0; // $pdf->AddPage(); // } } $totalAll['totalSemua'] += $grandTot['total']; $pdf->Cell(76 / 100 * $width, $height, "Sub Total", 1, 0, 'C', 1); $pdf->Cell(10 / 100 * $width, $height, number_format($grandTot['total'], 2), 1, 0, 'R', 1); $pdf->Cell(14 / 100 * $width, $height, '', 1, 1, 'R', 1); } $pdf->Cell(76 / 100 * $width, $height, "Total", 1, 0, 'C', 1); $pdf->Cell(10 / 100 * $width, $height, number_format($totalAll['totalSemua'], 2), 1, 0, 'R', 1); $pdf->Cell(14 / 100 * $width, $height, '', 1, 1, 'R', 1); $pdf->Cell($width, $height, terbilang($totalAll['totalSemua'], 2), 1, 1, 'C', 1); $pdf->Output(); break; case 'getSupplierNm': echo "<fieldset><legend>" . $_SESSION['lang']['result'] . "</legend>\r\n <div style=\"overflow:auto;height:295px;width:455px;\">\r\n <table cellpading=1 border=0 class=sortbale>\r\n <thead>\r\n <tr class=rowheader>\r\n <td>No.</td>\r\n <td>" . $_SESSION['lang']['kodesupplier'] . "</td>\r\n <td>" . $_SESSION['lang']['namasupplier'] . "</td>\r\n </tr><tbody>\r\n "; $sSupplier = "select namasupplier,supplierid from " . $dbname . ".log_5supplier where namasupplier like '%" . $nmSupplier . "%' and namasupplier!=''"; $qSupplier = mysql_query($sSupplier) or die(mysql_error($conn)); while ($rSupplier = mysql_fetch_assoc($qSupplier)) { $no += 1; echo "<tr class=rowcontent onclick=setData('" . $rSupplier['supplierid'] . "')>\r\n <td>" . $no . "</td>\r\n <td>" . $rSupplier['supplierid'] . "</td>\r\n <td>" . $rSupplier['namasupplier'] . "</td>\r\n </tr>"; } echo "</tbody></table></div>"; break; default: break; }
function terbilang($angkanya) { $huruf = array("", "Satu", "Dua", "Tiga", "Empat", "Lima", "Enam", "Tujuh", "Delapan", "Sembilan", "Sepuluh", "Sebelas"); if ($angkanya < 12) { return $huruf[$angkanya]; } elseif ($angkanya < 20) { return terbilang($angkanya - 10) . "Belas "; } elseif ($angkanya < 100) { return terbilang($angkanya / 10) . " Puluh " . terbilang($angkanya % 10); } elseif ($angkanya < 200) { return " seratus " . terbilang($angkanya - 100); } elseif ($angkanya < 1000) { return terbilang($angkanya / 100) . " Ratus " . terbilang($angkanya % 100); } elseif ($angkanya < 2000) { return " seribu " . terbilang($angkanya - 1000); } elseif ($angkanya < 1000000) { return terbilang($angkanya / 1000) . " Ribu " . terbilang($angkanya % 1000); } elseif ($angkanya < 1000000000) { return terbilang($angkanya / 1000000) . " Juta " . terbilang($angkanya % 1000000); } elseif ($angkanya >= 1000000000) { return "Uang terlalu Besar"; } }
function terbilang($bilangan) { $bilangan = abs($bilangan); $angka = array("Nol", "satu", "dua", "tiga", "empat", "lima", "enam", "tujuh", "delapan", "sembilan", "sepuluh", "sebelas"); $temp = ""; if ($bilangan < 12) { $temp = " " . $angka[$bilangan]; } else { if ($bilangan < 20) { $temp = terbilang($bilangan - 10) . " belas"; } else { if ($bilangan < 100) { $temp = terbilang($bilangan / 10) . " puluh" . terbilang($bilangan % 10); } else { if ($bilangan < 200) { $temp = " seratus" . terbilang($bilangan - 100); } else { if ($bilangan < 1000) { $temp = terbilang($bilangan / 100) . " ratus" . terbilang($bilangan % 100); } else { if ($bilangan < 2000) { $temp = " seribu" . terbilang($bilangan - 1000); } else { if ($bilangan < 1000000) { $temp = terbilang($bilangan / 1000) . " ribu" . terbilang($bilangan % 1000); } else { if ($bilangan < 1000000000) { $temp = terbilang($bilangan / 1000000) . " juta" . terbilang($bilangan % 1000000); } } } } } } } } return $temp; }
<td width="20" align="left"><font size="-4">:</font></td> <td width="300" align="left"><font size="-4">' . $no_passport . '</font></td> </tr> <tr> <td width="80" align="left"><font size="-4"></font></td> <td width="20" align="left"><font size="-4"></font></td> <td width="120" align="left"><font size="-4">Untuk mengisi jabatan</font></td> <td width="20" align="left"><font size="-4">:</font></td> <td width="300" align="left"><font size="-4">' . $jabatan . '</font></td> </tr> <tr> <td width="80" align="left"><font size="-4">KEDUA</font></td> <td width="20" align="left"><font size="-4">:</font></td> <td width="120" align="left"><font size="-4">Berlaku</font></td> <td width="20" align="left"><font size="-4">:</font></td> <td width="300" align="left"><font size="-4">' . tgl_biasa($berlaku_dari1) . ' s.d ' . tgl_biasa($berlaku_sampai1) . ' (Tanggal ' . terbilang(hari($berlaku_dari1)) . ' bulan ' . getbulan(bln($berlaku_dari1)) . ' tahun ' . terbilang(thn($berlaku_dari1)) . ' s.d tanggal ' . terbilang(hari($berlaku_sampai1)) . ' bulan ' . getbulan(bln($berlaku_sampai1)) . ' tahun ' . terbilang(thn($berlaku_sampai1)) . '). </font></td> </tr> <tr> <td width="80" align="left"><font size="-4">KETIGA</font></td> <td width="20" align="left"><font size="-4">:</font></td> <td width="400" align="left"><font size="-4">Menentukan syarat-syarat berikut :<br/> 1. Memberikan pendidikan/Pelatihan kepada tenaga-tenaga warga Negara Indonesia sehingga mereka itu dapat menduduki jabatan yang membutuhkan tanggung jawab dan keahlian/keterampilan tertentu dalam perusahaan tersebut, dengan melaporkan hasilnya kepada Depnakertrans RI dan Disnakertrans Propinsi Sumatera Utara dan Walikota Medan secara periodik 6(enam) bulan sekali.<br/> 2. Tidak akan memindahkan jabatan atau mempekerjakan dalam jabatan lain, tanpa izin Menakertrans.<br/> 3. Jika kemudian hari ternyata bahwa keterangan-keterangan yang diberikan/disebut dalam daftar permohonan yang bersangkutan tidak benar ataupun syarat-syarat yang kami tentukan ini tidak dipenuhi, maka surat keputusan ini dapat dicabut.<br/> 4. Setelah menerima IMTA, Pemohon wajib melaporkan Pengguanaan TKA dan Pendamping TKA di perusahaan kepada Kantor Dinas Pendapatan Daerah dan Kantor Kependudukan Kota Medan</font></td> </tr> <tr> <td width="80" align="left"><font size="-4">KEEMPAT</font></td> <td width="20" align="left"><font size="-4">:</font></td> <td width="400" align="left"><font size="-4">Apabila dalam surat keputusan ini di kemudian hari ternyata terdapat kekeliruan/kekurangan akan dibetulkan sebagaimana mestinya.</font></td> </tr>
function fterbilang() { $angka = $this->input->post("angka"); $terbilang = terbilang($angka); $data["terbilang"] = $terbilang; $this->_built_json(json_encode($data)); }
function cetak() { $type = 'pdf'; //$this->uri->segment(4); $rptx = $this->uri->segment(5); if ($rptx == 'bphtb_ppat_register') { $from = date('Y-m-d', strtotime($this->uri->segment(6))); $to = date('Y-m-d', strtotime($this->uri->segment(7))); $src = $this->uri->segment(8); $where = " where (date(bphtb_sspd.tgl_transaksi) between '{$from}' and '{$to}') "; if ($this->session->userdata('isppat')) { $where .= " and (bphtb_sspd.ppat_id=" . $this->session->userdata('ppat_id') . ") "; } if ($src != '') { $src = strtolower($src); $where .= " and ((lower(bphtb_ppat.kode) like '%" . $src . "%') or (lower(bphtb_ppat.nama) like '" . $src . "%') or\r\n (lower(bphtb_sspd.wp_nama) like '%" . $src . "%') or\r\n (lower(cast(bphtb_sspd.kd_propinsi || '.' || bphtb_sspd.kd_dati2 || '.' || bphtb_sspd.kd_kecamatan || '.' ||\r\n bphtb_sspd.kd_kelurahan || '.' || bphtb_sspd.kd_blok || '-' || bphtb_sspd.no_urut || '.' ||\r\n bphtb_sspd.kd_jns_op as varchar)) like '%" . $src . "%')) "; } $order = " order by bphtb_sspd.tgl_transaksi, bphtb_sspd.ppat_id, bphtb_sspd.tahun, bphtb_sspd.kode, bphtb_sspd.no_sspd "; $params = array("kondisi" => $where, "order" => $order, "daerah" => LICENSE_TO, "ibu_kota" => LICENSE_TO_SUB, "dinas" => LICENSE_TO_SUB); } else { $id = $this->uri->segment(6); $get = $this->sspd_model->get($id); $terbilang = terbilang($get->bphtb_harus_dibayarkan, 3) . " Rupiah"; $params = array("daerah" => LICENSE_TO, "kondisi" => " where bphtb_sspd.id = {$id} ", "terbilang" => $terbilang, "logo" => $_SERVER["DOCUMENT_ROOT"] . "/assets/img/logorpt__.jpg", "dinas" => LICENSE_TO_SUB); } //print_r($params);die(); $jasper = $this->load->library('Jasper'); echo $jasper->cetak($rptx, $params, $type, false); // echo $jasper->query_debug($rptx, $params); }
function terbilang() { $v = $_POST['v']; echo terbilang($v, 3) . ' Rupiah'; }
$pdf->Ln(); $pdf->SetX(3); $pdf->SetFont('Arial', 'I', 10); $pdf->SetTextColor(20, 150, 220); $pdf->Cell(0, 0.25, 'Type of Sample', 0, 0, 'L'); $pdf->SetTextColor(0, 0, 0); $pdf->Ln(0.5); //jumlah conto $pdf->SetX(3); $pdf->SetFont('Arial', 'U', 10); $pdf->Cell(0, 0.75, 'Jumlah Conto', 0, 0, 'L'); $pdf->SetX(9); $pdf->SetFont('Arial', '', 10); $pdf->Cell(0, 0.75, ':', 0, 0, 'L'); $pdf->SetX(10); $pdf->Cell(0, 0.75, $analisis->jumlah_conto . ' (' . terbilang($analisis->jumlah_conto) . ')', 0, 0, 'L'); $pdf->Ln(); $pdf->SetX(3); $pdf->SetFont('Arial', 'I', 10); $pdf->SetTextColor(20, 150, 220); $pdf->Cell(0, 0.25, 'Amount of Sample', 0, 0, 'L'); $pdf->SetTextColor(0, 0, 0); $pdf->Ln(0.5); //asal conto $pdf->SetX(3); $pdf->SetFont('Arial', 'U', 10); $pdf->Cell(0, 0.75, 'Asal Conto', 0, 0, 'L'); $pdf->SetX(9); $pdf->SetFont('Arial', '', 10); $pdf->Cell(0, 0.75, ':', 0, 0, 'L'); $pdf->SetX(10);
</td> </tr> <tr> <td style="padding: 3px;"> <br> <br> <br> <br> <br> <br> <br> </td> </tr> </table> </table> </div> <script> $(document).ready(function () { $("#penerimaan").html("<?php echo number_format($tPenerimaan, 0, ',', '.'); ?> <br>"); $("#penerimaanterbilang").html("(<?php echo strtoupper(terbilang($tPenerimaan)); ?> )<br>"); }); </script> </body> </html>
function cetak() { $type = $this->uri->segment(4); $qs = urldecode($_SERVER['QUERY_STRING']); parse_str($qs, $qs_data); $params = array(); // foreach ($qs_data as $key => $val) // $params[$key] = $val; $cu = $this->load->model('objek_pajak_model')->get($this->input->get('id')); $report = $this->load->model('report_model')->get_report($cu->usaha_id, 0); //untuk reklame niy $sptpd = $this->load->model('sptpd_model')->get($this->input->get('sid')); switch ($this->input->get('rpt')) { case 'kartudt': $rpt = $report->kartudtnm; $params = array('cuid' => intval($cu->id), 'terbilang' => strtoupper(terbilang($sptpd->pajak_terhutang)), 'sptid' => intval($this->input->get('sid'))); break; } $params = array_merge($params, array("tahun" => pad_tahun_anggaran(), "daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama(), "logo" => base_url('assets/img/logorpt__.jpg'))); $rpt = $rpt; // $rpt = $this->module.'/'.$rpt; $jasper = $this->load->library('Jasper'); echo $jasper->cetak($rpt, $params, $type, false); }
<td colspan="8" class="style6"><hr /></td> </tr> <?php $no++; $jumlah += $data['jumlah']; $jumlah_harga_satuan += $data['harga']; $jumlah_subtotal += $data['total']; ?> <?php } ?> <tr> <td colspan="4"><div class="style6" id="terbilang"> <?php echo strtoupper(terbilang($jumlah_subtotal) . " Rupiah"); ?> </div> </td> <td class="style6">Jumlah</td> <td align="center" class="style9"><?php echo number_format($jumlah, 0, ',', '.'); ?> </td> <td class="style6"></td> <td align="right" class="style9"><?php echo 'Rp ' . number_format($jumlah_subtotal, 0, ',', '.'); ?> </td> </tr>
function terbilang_rupiah($x) { $terbilang = terbilang($x); return trim($terbilang . " rupiah"); }
$pdf->Ln(); # Jumlah /*$pdf->Cell($lenJudul/100*$width,$height,$_SESSION['lang']['jumlah'],'LR',0,'C',1); $pdf->SetFont('Arial','',9); $pdf->Cell($length[4]/100*$width,$height,$saldoKM,'BLR',0,$align[3],1); $pdf->Cell($length[5]/100*$width,$height,'','BLR',0,$align[4],1); $pdf->Cell($length[6]/100*$width,$height,$saldoKM,'BLR',0,$align[5],1); $pdf->Ln(); $pdf->Cell($lenJudul/100*$width,$height,'','L',0,$align[4],1); $pdf->Cell((100-$lenJudul)/100*$width,$height,'','TR',0,$align[4],1); */ $pdf->Ln(); # Terbilang $pdf->SetFont('Arial', 'I', 9); $pdf->MultiCell($width, $height, 'Terbilang : [ ' . terbilang($saldoTerbilang, 0) . " rupiah. ]", 'LR', 'L'); $pdf->Cell($width, $height, '', 'LR', 0, $align[4], 0); $pdf->Ln(); # Tempat, Tanggal $pdf->SetFont('Arial', '', 9); $pdf->Cell(2 / 3 * $width, $height, '', 'L', 0, $align[4], 0); $pdf->Cell(1 / 3 * $width, $height, $periode1, 'R', 0, 'C', 0); $pdf->Ln(); # Mengetahui dll $pdf->Cell(1 / 3 * $width, $height, $_SESSION['lang']['mengetahui'], 'L', 0, 'C', 0); $pdf->Cell(1 / 3 * $width, $height, $_SESSION['lang']['diperiksa'], 0, 0, 'C', 0); $pdf->Cell(1 / 3 * $width, $height, $_SESSION['lang']['disetujui'], 'R', 0, 'C', 0); $pdf->Ln(); # Add few line $pdf->Cell($width, $height, '', 'LR', 1, $align[4], 0); $pdf->Cell($width, $height, '', 'LR', 1, $align[4], 0);
$pdf->Cell(40, 0.2 * $height, '', LB, 0, 'R'); $pdf->Cell(10, 0.2 * $height, '', RB, 1, 'R'); $grandTotal = $subTot - $subTotKlaim; $pdf->SetTextColor(0, 0, 0); $pdf->Cell(15, 1.5 * $height, '', RLB, 0, 'C'); $pdf->Cell(125, 1.5 * $height, 'Total : ', LRB, 0, 'R'); $pdf->Cell(40, 1.5 * $height, number_format($grandTotal), 'BL', 0, 'R'); $pdf->Cell(10, 1.5 * $height, '', RB, 1, 'R'); $pdf->Ln(); $pdf->SetFont('Arial', '', 8); $akhirYTerbilang = $pdf->GetY(); $pdf->Cell(30, $height, 'Dalam huruf :', 0, 0, 'L'); if ($bar->matauang == 'IDR') { $pdf->MultiCell(100, $height, terbilang(round($grandTotal, 0), '') . ' Rupiah', 0, 'J'); } else { $pdf->MultiCell(100, $height, terbilang(round($grandTotal, 2), '') . ' ', 0, 'J'); } $pdf->SetFont('Arial', 'B', 8); $pdf->SetXY(150, $akhirYTerbilang); $pdf->Cell(30, $height, 'Hormat Kami,', 0, 1, 'L'); $pdf->SetX(150); $pdf->Cell(50, 2 * $height, $nmPt[$bar->kodept], 0, 1, 'C'); //$pdf->SetFont('Arial','',8); $iAkunBank = " select * from " . $dbname . ".keu_5akunbank where pemilik='" . $bar->kodept . "' "; $nAkunBank = mysql_query($iAkunBank) or die(mysql_error($conn)); $dAkunBank = mysql_fetch_assoc($nAkunBank); $pdf->Cell(45, $height, 'Mohon Ditransfer ke Acc.', 0, 0, 'L'); $nmPtS = explode(".", $nmPt[$bar->kodept]); $nmPtBawah = $nmPtS[0] . " " . ucwords(strtolower($nmPtS[1])); $pdf->Cell(90, $height, $nmPtBawah . ' Acc: ' . $dAkunBank['rekening'], 1, 1, 'C'); $pdf->SetFont('Arial', '', 8);
function terbilang($satuan) { $huruf = array("", "Satu", "Dua", "Tiga", "Empat", "Lima", "Enam", "Tujuh", "Delapan", "Sembilan", "Sepuluh", "Sebelas"); if ($satuan < 12) { return " " . $huruf[$satuan]; } elseif ($satuan < 20) { return terbilang($satuan - 10) . " Belas"; } elseif ($satuan < 100) { return terbilang($satuan / 10) . " Puluh" . terbilang($satuan % 10); } elseif ($satuan < 200) { return "Seratus" . terbilang($satuan - 100); } elseif ($satuan < 1000) { return terbilang($satuan / 100) . " Ratus" . terbilang($satuan % 100); } elseif ($satuan < 2000) { return "seribu" . terbilang($satuan - 1000); } elseif ($satuan < 1000000) { return terbilang($satuan / 1000) . " Ribu" . terbilang($satuan % 1000); } elseif ($satuan < 1000000000) { return terbilang($satuan / 1000000) . " Juta" . terbilang($satuan % 1000000); } elseif ($satuan >= 1000000000) { echo "Angka yang Anda masukkan terlalu besar"; } }
function terbilang($satuan) { $huruf = array("", "Satu", "Dua", "Tiga", "Empat", "Lima", "Enam", "Tujuh", "Delapan", "Sembilan", "Sepuluh", "Sebelas"); if ($satuan < 12) { return " " . $huruf[$satuan]; } elseif ($satuan < 20) { return terbilang($satuan - 10) . "Belas"; } elseif ($satuan < 100) { return terbilang($satuan / 10) . " Puluh" . terbilang($satuan % 10); } elseif ($satuan < 200) { return " seratus" . terbilang($satuan - 100); } elseif ($satuan < 1000) { return terbilang($satuan / 100) . " Ratus" . terbilang($satuan % 100); } elseif ($satuan < 2000) { return " seribu" . terbilang($satuan - 1000); } elseif ($satuan < 1000000) { return terbilang($satuan / 1000) . " Ribu" . terbilang($satuan % 1000); } elseif ($satuan < 1000000000) { return terbilang($satuan / 1000000) . " Juta" . terbilang($satuan % 1000000); } elseif ($satuan <= 1000000000) { echo "Maaf Tidak Dapat di Prose Karena Jumlah Uang Terlalu Besar "; } }
?> <?php } ?> </table> <table width="98%" align="center"> <tr> <td width="94"><label for="name"></label> <label for="name"></label> <label for="name"><span class="style6">TERBILANG</span></label></td> <td width="14">:</td> <td width="566"><div class="style6" id="terbilang"> <?php echo strtoupper(terbilang($supplier->total_penjualan) . " Rupiah"); ?> </td> <td width="25"> </td> <td width="155" class="style6"><div align="right">GRAND TOTAL</div></td> <td width="149" class="style6"><div id="total" align="center"> <?php echo 'Rp. ' . number_format($supplier->total_penjualan, 0, ',', '.'); ?> </div></td> </tr> </table> <div style="margin-bottom:40px;"></div> <table width="98%" border="0">
function terbilang($angka) { // pastikan kita hanya berususan dengan tipe data numeric $angka = (double) $angka; // array bilangan // sepuluh dan sebelas merupakan special karena awalan 'se' $bilangan = array('', 'satu', 'dua', 'tiga', 'empat', 'lima', 'enam', 'tujuh', 'delapan', 'sembilan', 'sepuluh', 'sebelas'); // pencocokan dimulai dari satuan angka terkecil if ($angka < 12) { // mapping angka ke index array $bilangan return $bilangan[$angka]; } else { if ($angka < 20) { // bilangan 'belasan' // misal 18 maka 18 - 10 = 8 return $bilangan[$angka - 10] . ' belas'; } else { if ($angka < 100) { // bilangan 'puluhan' // misal 27 maka 27 / 10 = 2.7 (integer => 2) 'dua' // untuk mendapatkan sisa bagi gunakan modulus // 27 mod 10 = 7 'tujuh' $hasil_bagi = (int) ($angka / 10); $hasil_mod = $angka % 10; return trim(sprintf('%s puluh %s', $bilangan[$hasil_bagi], $bilangan[$hasil_mod])); } else { if ($angka < 200) { // bilangan 'seratusan' (itulah indonesia knp tidak satu ratus saja? :)) // misal 151 maka 151 = 100 = 51 (hasil berupa 'puluhan') // daripada menulis ulang rutin kode puluhan maka gunakan // saja fungsi rekursif dengan memanggil fungsi terbilang(51) return sprintf('seratus %s', terbilang($angka - 100)); } else { if ($angka < 1000) { // bilangan 'ratusan' // misal 467 maka 467 / 100 = 4,67 (integer => 4) 'empat' // sisanya 467 mod 100 = 67 (berupa puluhan jadi gunakan rekursif terbilang(67)) $hasil_bagi = (int) ($angka / 100); $hasil_mod = $angka % 100; return trim(sprintf('%s ratus %s', $bilangan[$hasil_bagi], terbilang($hasil_mod))); } else { if ($angka < 2000) { // bilangan 'seribuan' // misal 1250 maka 1250 - 1000 = 250 (ratusan) // gunakan rekursif terbilang(250) return trim(sprintf('seribu %s', terbilang($angka - 1000))); } else { if ($angka < 1000000) { // bilangan 'ribuan' (sampai ratusan ribu $hasil_bagi = (int) ($angka / 1000); // karena hasilnya bisa ratusan jadi langsung digunakan rekursif $hasil_mod = $angka % 1000; return sprintf('%s ribu %s', terbilang($hasil_bagi), terbilang($hasil_mod)); } else { if ($angka < 1000000000) { // bilangan 'jutaan' (sampai ratusan juta) // 'satu puluh' => SALAH // 'satu ratus' => SALAH // 'satu juta' => BENAR // @#$%^ WT* // hasil bagi bisa satuan, belasan, ratusan jadi langsung kita gunakan rekursif $hasil_bagi = (int) ($angka / 1000000); $hasil_mod = $angka % 1000000; return trim(sprintf('%s juta %s', terbilang($hasil_bagi), terbilang($hasil_mod))); } else { if ($angka < 1000000000000.0) { // bilangan 'milyaran' $hasil_bagi = (int) ($angka / 1000000000); // karena batas maksimum integer untuk 32bit sistem adalah 2147483647 // maka kita gunakan fmod agar dapat menghandle angka yang lebih besar $hasil_mod = fmod($angka, 1000000000); return trim(sprintf('%s milyar %s', terbilang($hasil_bagi), terbilang($hasil_mod))); } else { if ($angka < 1000000000000000.0) { // bilangan 'triliun' $hasil_bagi = $angka / 1000000000000.0; $hasil_mod = fmod($angka, 1000000000000.0); return trim(sprintf('%s triliun %s', terbilang($hasil_bagi), terbilang($hasil_mod))); } else { return 'Wow...'; } } } } } } } } } } }
foreach (tampilData($stmt3) as $grid1) { $pdf->MultiCell(10, 7, $i, 0, 'C', false, 0, '', '', false, 0, false, false, 7, 'TB'); $pdf->MultiCell(20, 6, $grid1['no_so'], 0, 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(20, 6, $grid1['no_seri_produk'], 0, 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(40, 6, $grid1['nama_produk'], 0, 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(22, 6, number_format($grid1['harga'], 2, ',', '.'), 0, 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(5, 6, "x", 0, 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(17, 6, $grid1['persentase'], 0, 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(5, 6, "x", 0, 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(7, 6, $grid1['quantity'], 0, 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(5, 6, "=", 0, 'C', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(25, 6, number_format($grid1['komisi'], 2, ',', '.'), 0, 'C', false, 1, '', '', false, 0, false, false, '', 'M'); $i++; } $stmt2 = "select sum(komisi) as total from komisi where no_nis_sales = '{$nis}' AND cabang = '{$cabang}' AND tanggal_so BETWEEN '{$begin}' AND '{$end}'"; foreach (tampilData($stmt2) as $total) { } $pdf->SetFont('helvetica', 'BI', 7); $pdf->MultiCell(151, 7, "Total Komisi", 'TB', 'C', false, 0, '', '', false, 0, false, false, 7, 'TB'); $pdf->MultiCell(25, 6, number_format($total['total'], 2, ',', '.'), 'TB', 'C', false, 1, '', '', false, 0, false, false, '', 'M'); $pdf->MultiCell(15, 7, "Terbilang", 0, 'L', false, 0, '', '', false, 0, false, false, 7, 'T'); $pdf->MultiCell(175, 7, ": " . terbilang($total['total'], 4) . " rupiah", 0, 'L', false, 0, '', '', false, 0, false, false, '', 'M'); $pdf->setXY($pdf->getX(), $pdf->getY() + 10); $pdf->Line(0, $pdf->getY(), 215, $pdf->getY()); $pdf->setXY($pdf->getX(), $pdf->getY() + 10); $y = 297 - $pdf->getY(); if ($y <= 40) { $pdf->AddPage(); } } $pdf->Output($cabang . " - " . $dataCabang['nama_cabang'] . " (" . $begin . " s.d " . $end . ")-KOMISI.pdf", 'I');
function terbilang($angka) { $angka = (double) $angka; $bilangan = array('', 'satu', 'dua', 'tiga', 'empat', 'lima', 'enam', 'tujuh', 'delapan', 'sembilan', 'sepuluh', 'sebelas'); if ($angka < 12) { return $bilangan[$angka]; } else { if ($angka < 20) { return $bilangan[$angka - 10] . ' belas'; } else { if ($angka < 100) { $hasil_bagi = (int) ($angka / 10); $hasil_mod = $angka % 10; return trim(sprintf('%s puluh %s', $bilangan[$hasil_bagi], $bilangan[$hasil_mod])); } else { if ($angka < 200) { return sprintf('seratus %s', terbilang($angka - 100)); } else { if ($angka < 1000) { $hasil_bagi = (int) ($angka / 100); $hasil_mod = $angka % 100; return trim(sprintf('%s ratus %s', $bilangan[$hasil_bagi], terbilang($hasil_mod))); } else { if ($angka < 2000) { return trim(sprintf('seribu %s', terbilang($angka - 1000))); } else { if ($angka < 1000000) { $hasil_bagi = (int) ($angka / 1000); // karena hasilnya bisa ratusan jadi langsung digunakan rekursif $hasil_mod = $angka % 1000; return sprintf('%s ribu %s', terbilang($hasil_bagi), terbilang($hasil_mod)); } else { if ($angka < 1000000000) { // hasil bagi bisa satuan, belasan, ratusan jadi langsung kita gunakan rekursif $hasil_bagi = (int) ($angka / 1000000); $hasil_mod = $angka % 1000000; return trim(sprintf('%s juta %s', terbilang($hasil_bagi), terbilang($hasil_mod))); } else { if ($angka < 1000000000000) { // bilangan 'milyaran' $hasil_bagi = (int) ($angka / 1000000000); $hasil_mod = fmod($angka, 1000000000); return trim(sprintf('%s milyar %s', terbilang($hasil_bagi), terbilang($hasil_mod))); } else { if ($angka < 1000000000000000) { // bilangan 'triliun' $hasil_bagi = $angka / 1000000000000; $hasil_mod = fmod($angka, 1000000000000); return trim(sprintf('%s triliun %s', terbilang($hasil_bagi), terbilang($hasil_mod))); } else { return 'Wow...'; } } } } } } } } } } }
</td> </tr> </table> <center><h2><u>BUKTI PEMBAYARAN</u></h2></center> <br/> <table width="100%"> <tr><td>Sudah terima dari</td><td>:</td><td>Bendahara <?php echo $attr->nama; ?> </td></tr> <tr><td>Jumlah Uang</td><td>:</td><td><?php echo currency($value->nominal); ?> </td></tr> <tr><td>Terbilang</td><td>:</td><td><?php echo terbilang($value->nominal); ?> RUPIAH</td></tr> <tr><td>Untuk Pembayaran</td><td>:</td><td><?php echo $value->uraian; ?> </td></tr> </table><br/><br/> <table align="right" width="100%"> <tr><td width="55%" align="right"></td><td width="45%"><?php echo $attr->kabupaten; ?> , <?php echo indo_tgl($value->tanggal); ?> </td> </tr>
$pdf->Cell(5, 5, ':', '', 0, 'L'); $pdf->SetFont('Arial', '', '10'); $pdf->MultiCell(150, 5, $ktTermin, 0, 'L', 0); $nilKontrak = $bar['hargasatuan'] * $bar['kuantitaskontrak']; $pdf->SetFont('Arial', 'B', '10'); $pdf->Cell(39, 5, $_SESSION['lang']['nilkontrak'], '', 0, 'L'); $pdf->Cell(5, 5, ':', '', 0, 'L'); $pdf->SetFont('Arial', '', '10'); $pdf->Cell(100, 5, $optMtSim[$bar['matauang']] . " " . number_format($nilKontrak, 0) . " (" . $arrStatPPn[$bar['ppn']] . " PPn)", '', 1, 'L'); $pdf->SetFont('Arial', 'B', '10'); $pdf->Cell(39, 5, '', '', 0, 'L'); $pdf->Cell(5, 5, '', '', 0, 'L'); $pdf->SetFont('Arial', '', '10'); $nilKontrak = number_format($nilKontrak); $nilKontrak = str_replace(',', '', $nilKontrak); $pdf->MultiCell(130, 5, "(" . ucfirst(terbilang($nilKontrak, 2)) . " " . $optMtuang[$bar['matauang']] . ")", 0, 'L', 0); $pdf->Ln(150); $toleransi = $bar['toleransi'] . "\n"; $pdf->SetFont('Arial', 'B', '10'); $pdf->Cell(39, 5, '', '', 1, ''); $pdf->Cell(39, 5, '', '', 1, ''); $pdf->Cell(39, 5, '', '', 1, ''); $pdf->Cell(39, 5, $_SESSION['lang']['catatanlain'], '', 0, 'L'); $pdf->Cell(5, 5, ':', '', 0, 'L'); $pdf->SetFont('Arial', '', '10'); //$bar['catatanlain'] = str_replace('≤',chr(163),$bar['catatanlain']); $pdf->MultiCell(130, 5, $toleransi . $bar['catatanlain'], 0, 'L', 0); $pdf->Ln(5); $pdf->Cell(20, 5, '', 0, 'L'); $tglTtd = explode("-", $tlgKontrk); $tglnya = $tglTtd[0];
} } } $pdf->Cell(25, 4, $_SESSION['lang']['totalPendapatan'], 'TB', 0, 'L'); $pdf->Cell(5, 4, ":Rp.", 'TB', 0, 'L'); $pdf->Cell(18, 4, number_format($arrPlus[$dtKary], 2, '.', ','), 'TB', 0, 'R'); $pdf->Cell(25, 4, $_SESSION['lang']['totalPotongan'], 'TB', 0, 'L'); $pdf->Cell(5, 4, ":Rp.", 'TB', 0, 'L'); $pdf->Cell(18, 4, number_format($arrMin[$dtKary], 2, '.', ','), 'TB', 1, 'R'); $pdf->SetFont('Arial', 'B', 7); $pdf->Cell(23, 4, $_SESSION['lang']['gajiBersih'], 0, 0, 'L'); $pdf->Cell(5, 4, ":Rp.", 0, 0, 'L'); $pdf->Cell(18, 4, number_format($arrPlus[$dtKary] - $arrMin[$dtKary], 2, '.', ','), 0, 0, 'R'); $pdf->Cell(47, 4, "", 0, 1, 'L'); $terbilang = $arrPlus[$dtKary] - $arrMin[$dtKary]; $blng = terbilang($terbilang, 2) . " rupiah"; $pdf->SetFont('Arial', '', 7); $pdf->Cell(23, 4, 'Terbilang', 0, 0, 'L'); $pdf->Cell(5, 4, ":", 0, 0, 'L'); //$pdf->MultiCell(58,4,$blng,0,'L'); $awalY = $pdf->GetY(); $pdf->MultiCell(58, 4, $blng, 0, 'L'); $akhirY = $pdf->GetY(); $tinggiY = $akhirY - $awalY; if ($tinggiY <= 5) { $pdf->Ln(); } $pdf->SetFont('Arial', 'I', 5); $pdf->Cell(96, 4, 'Note: This is computer generated system, signature is not required', 'T', 1, 'L'); $pdf->SetFont('Arial', '', 6); $pdf->Ln();
function cetak() { $type = $this->uri->segment(4); $rpt = $this->input->get('rpt'); $kondisi = ""; if ($rpt == 'sptpd_tr') { $wp_id = $this->input->get('w'); if (!empty($wp_id)) { $kondisi .= " AND c.id={$wp_id} "; } $type_id = $this->input->get('t'); if ($type_id != 999) { $kondisi .= " AND st.id={$type_id} "; } $usaha_id = $this->input->get('u'); if ($usaha_id != 999) { $kondisi .= " AND u.id={$usaha_id} "; } $kondisi .= " AND s.tahun=" . pad_tahun_anggaran(); $params = array("daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama(), 'kondisi' => (string) $kondisi); } elseif ($rpt == 'sptpd_omset') { $rpt = 'sptpd_rincian_omset'; $sptpd_id = $this->input->get('no'); $terbilang = terbilang(pad_to_decimal($this->input->get('val')), 3) . " Rupiah"; $params = array('sptpd_id' => (int) $sptpd_id, "terbilang" => $terbilang, "alamat" => pad_pemda_alamat(), "telp" => pad_pemda_telp(), "fax" => pad_pemda_fax(), "website" => pad_pemda_website(), "email" => pad_pemda_email(), "alamat_lengkap" => pad_pemda_alamat_lengkap(), "daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama(), "logo" => $_SERVER["DOCUMENT_ROOT"] . "/assets/img/logorpt__.jpg", "logobjb" => $_SERVER["DOCUMENT_ROOT"] . "/assets/img/bank-bjb.jpg"); } else { $rpt = 'sptpd_slip'; $sptpd_id = $this->input->get('no'); $terbilang = terbilang(pad_to_decimal($this->input->get('val')), 3) . " Rupiah"; $params = array('sptpd_id' => (int) $sptpd_id, "terbilang" => $terbilang, "alamat" => pad_pemda_alamat(), "telp" => pad_pemda_telp(), "fax" => pad_pemda_fax(), "website" => pad_pemda_website(), "email" => pad_pemda_email(), "alamat_lengkap" => pad_pemda_alamat_lengkap(), "daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama(), "logo" => $_SERVER["DOCUMENT_ROOT"] . "/assets/img/logorpt__.jpg", "logobjb" => $_SERVER["DOCUMENT_ROOT"] . "/assets/img/bank-bjb.jpg"); } $ignore_html_pg = TRUE; $rpt = 'wp/' . $rpt; $db_pad = $this->load->database('pad', TRUE); $jasper = $this->load->library('Jasper'); $jasper->db = $db_pad->database; $jasper->usr = $db_pad->username; $jasper->pwd = $db_pad->password; $jasper->port = $db_pad->port; echo $jasper->cetak($rpt, $params, $type, $ignore_html_pg); }
function cetak() { $type = $this->uri->segment(4); $qs = urldecode($_SERVER['QUERY_STRING']); parse_str($qs, $qs_data); $params = array(); // foreach ($qs_data as $key => $val) // $params[$key] = $val; $sptpd = $this->load->model('sptpd_model')->get($this->input->get('id')); $sspd = $this->load->model('sspd_model')->get_by_spt($this->input->get('id')); $cu = $this->load->model('objek_pajak_model')->get($sptpd->customer_usaha_id); $report = $this->load->model('report_model')->get_report($cu->usaha_id, $sptpd->type_id); // $bayar = $sptpd->pajak_terhutang+$sspd->bunga; // $bayar = ($sptpd->pajak_terhutang-$sptpd->bunga)+$sspd->bunga; $bayar = $sspd->jml_bayar; switch ($this->input->get('rpt')) { case 'sspd': $rpt = $report->sspdnm; $params = array('spt_id' => intval($sptpd->id)); break; case 'validasi': $rpt = 'validasi_00'; $params = array('spt_id' => intval($sptpd->id)); break; } $params = array_merge($params, array("alamat" => pad_pemda_alamat(), "telp" => pad_pemda_telp(), "fax" => pad_pemda_fax(), "website" => pad_pemda_website(), "email" => pad_pemda_email(), "alamat_lengkap" => pad_pemda_alamat_lengkap(), "terbilang" => strtoupper(terbilang($bayar)), "pad_bunga" => (double) pad_bunga(), "daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama(), "logo" => base_url('assets/img/logorpt__.jpg'))); $rpt = $rpt; // $rpt = $this->module.'/'.$rpt; $jasper = $this->load->library('Jasper'); echo $jasper->cetak($rpt, $params, $type, false); }
<?php } ?> </table> <table width="98%" align="center" border="0"> <tr> <!-- <td width="94"><label for="name"></label> <label for="name"></label> <label for="name"><span class="style6">TERBILANG</span></label></td> <td width="14">:</td> <td width="566"><div class="style6" id="terbilang"> <?php echo strtoupper(terbilang($detail->total_penjualan) . " Rupiah"); ?> </td> --> <td align="right" class="style9"></td> <td align="center" class="style9"> </td> <td align="center" class="style9"><b>Jumlah</b></td> <td align="center" class="style9"><?php echo number_format($jumlah, 0, ',', '.'); ?> </td> </tr> </table> <div style="margin-bottom:40px;"></div>
function buka_langsung_bayar($idkw) { unset($_SESSION[kasir][kunjungan][jasa_cetak]); $kon = new Konek; //$kon->debug = 1; $objResponse = new xajaxResponse; //get data pasien $sql = " SELECT k.id as kunjungan_id, CONCAT_WS('-', SUBSTRING(p.id, 1,2), SUBSTRING(p.id, 3,2), SUBSTRING(p.id, 5,2), SUBSTRING(p.id, 7,2)) as id_display, p.nama as nama, p.tgl_lahir as tgl_lahir, CONCAT(p.alamat, ' ', IF(p.rt = '','',CONCAT(' RT ', p.rt)), IF(p.rw = '','',CONCAT(' RW ', p.rw)), ', ', des.nama, ', ', kec.nama, ', ', kab.nama) as alamat, kk.tgl_daftar as tgl_daftar, kk.tgl_periksa as tgl_periksa, pel.nama as nama_pelayanan, p.sex as jk, CONCAT_WS(' - ', kk.cara_bayar, kk.jenis_askes, rper.nama) as cara_bayar, kk.nomor as nomor FROM kunjungan_kamar kk JOIN kunjungan k ON (k.id = kk.kunjungan_id) JOIN pasien p ON (p.id = k.pasien_id) JOIN kamar kmr ON (kmr.id = kk.kamar_id) JOIN pelayanan pel ON (pel.id = kmr.pelayanan_id) JOIN kunjungan_bayar kb ON (kb.kunjungan_kamar_id = kk.id) JOIN kwitansi_detil kwd ON (kwd.kunjungan_bayar_id = kb.id) JOIN kwitansi kw ON (kw.id = kwd.kwitansi_id) JOIN ref_desa des ON (des.id = p.desa_id) JOIN ref_kecamatan kec ON (kec.id = des.kecamatan_id) JOIN ref_kabupaten kab ON (kab.id = kec.kabupaten_id) JOIN ref_propinsi prop ON (prop.id = kab.propinsi_id) LEFT JOIN ref_perusahaan rper ON (rper.id = kk.perusahaan_id) WHERE kw.id = '".$idkw."' GROUP BY p.id "; //$objResponse->addAssign("debug", "innerHTML", $sql); $kon->sql = $sql; $kon->execute(); $data_pasien = $kon->getOne(); $arr_usia = hitungUmur($data_pasien[tgl_lahir], $data_pasien[tgl_periksa]); $data_pasien[usia] = empty($arr_usia[tahun])?"":$arr_usia[tahun] . " thn "; $data_pasien[usia] .= empty($arr_usia[bulan])?"":$arr_usia[bulan] . " bln "; $data_pasien[usia] .= empty($arr_usia[hari])?"":$arr_usia[hari] . " hr "; $objResponse->addClear("modal_lb", "style.display"); $objResponse->addAssign("lb_id_kunjungan", "value", $data_pasien[kunjungan_id]); $objResponse->addAssign("lb_id_kwitansi", "value", $idkw); $objResponse->addAssign("lb_no_rm", "innerHTML", $data_pasien[id_display]); $objResponse->addAssign("lb_pasien", "innerHTML", $data_pasien[nama]); $objResponse->addAssign("lb_sex", "innerHTML", $data_pasien[jk]); $objResponse->addAssign("lb_usia", "innerHTML", $data_pasien[usia]); $objResponse->addAssign("lb_alamat", "innerHTML", $data_pasien[alamat]); $objResponse->addAssign("lb_tgl_daftar", "innerHTML", tanggalIndo($data_pasien[tgl_daftar], 'j F Y')); $objResponse->addAssign("lb_cara_bayar", "innerHTML", $data_pasien[cara_bayar]); $objResponse->addAssign("lb_nomor", "innerHTML", empty($data_pasien[nomor])?"-":$data_pasien[nomor]); //BIKIN SESSION UNTUK DICETAK $_SESSION[igd][langsung_bayar][data_px] = $data_pasien; $tabel = new Table; $tabel->cellspacing = "0"; $tabel->scroll = false; $tabel->extra_table = "style=\"width:9cm;\""; $tabel->addTh("No", "Jasa", "Biaya"); $tabel->addExtraTh("style=\"width:0.7cm;\"", "style=\"width:6.5cm;\"", ""); //get data karcis $kon->sql = " SELECT kb.nama as nama, kb.bayar_bhp+kb.bayar_jasa as bayar, kb.mampu_bayar_bhp+kb.mampu_bayar_jasa as mampu_bayar, kwd.kwitansi_id as kwitansi_id FROM kunjungan_bayar kb JOIN kwitansi_detil kwd ON (kwd.kunjungan_bayar_id = kb.id) JOIN kunjungan_kamar kk ON (kk.id = kb.kunjungan_kamar_id) WHERE kb.karcis_id IS NOT NULL AND kwd.kwitansi_id = '".$idkw."' GROUP BY kb.id ORDER BY kb.id "; $kon->execute(); $data_karcis = $kon->getAll(); if(!empty($data_karcis)) { $tabel->addRow("","<b>Karcis</b>",""); for($i=0;$i<sizeof($data_karcis);$i++) { $tabel->addRow( ($i+1), $data_karcis[$i][nama], uangIndo($data_karcis[$i][bayar]) ); $total += $data_karcis[$i][bayar]; $sudah_dibayar += $data_karcis[$i][mampu_bayar]; //belum bayar $kurang += $data_karcis[$i][bayar]-$data_karcis[$i][mampu_bayar]; } } //get data tindakan $kon->sql = " SELECT kki.nama as nama, SUM(kb.bayar_jasa) as bayar, SUM(kb.mampu_bayar_jasa) as mampu_bayar, kwd.kwitansi_id as kwitansi_id FROM kunjungan_kamar_icopim kki JOIN kunjungan_bayar kb ON (kb.kunjungan_kamar_icopim_id = kki.id) JOIN kwitansi_detil kwd ON (kwd.kunjungan_bayar_id = kb.id) JOIN kunjungan_kamar kk ON (kk.id = kki.kunjungan_kamar_id) WHERE kb.icopim_detil_id IS NOT NULL AND kwd.kwitansi_id = '".$idkw."' GROUP BY kki.id ORDER BY kki.id "; $kon->execute(); $data_tindakan = $kon->getAll(); if(!empty($data_tindakan)) { $tabel->addRow("","<b>Tindakan</b>",""); for($i=0;$i<sizeof($data_tindakan);$i++) { $tabel->addRow( ($i+1), $data_tindakan[$i][nama], uangIndo($data_tindakan[$i][bayar]) ); $total += $data_tindakan[$i][bayar]; $sudah_dibayar += $data_tindakan[$i][mampu_bayar]; //belum bayar $kurang += $data_tindakan[$i][bayar]-$data_tindakan[$i][mampu_bayar]; } } //get data specimen $kon->sql = " SELECT kb.nama as nama, kb.bayar_bhp+kb.bayar_jasa as bayar, kb.mampu_bayar_bhp+kb.mampu_bayar_jasa as mampu_bayar, kwd.kwitansi_id as kwitansi_id FROM kunjungan_bayar kb JOIN lab_kunjungan lk ON (lk.id = kb.lab_kunjungan_id) JOIN kunjungan_kamar kk ON (kk.id = lk.kunjungan_kamar_id) JOIN kwitansi_detil kwd ON (kwd.kunjungan_bayar_id = kb.id) WHERE kb.lab_specimen_id IS NOT NULL AND kwd.kwitansi_id = '".$idkw."' GROUP BY kb.id ORDER BY kb.id "; $kon->execute(); $data_specimen = $kon->getAll(); if(!empty($data_specimen)) { $tabel->addRow("","<b>Pemeriksaan Specimen</b>",""); for($i=0;$i<sizeof($data_specimen);$i++) { $tabel->addRow( ($i+1), $data_specimen[$i][nama], uangIndo($data_specimen[$i][bayar]) ); $total += $data_specimen[$i][bayar]; $sudah_dibayar += $data_specimen[$i][mampu_bayar]; //belum bayar $kurang += $data_specimen[$i][bayar]-$data_specimen[$i][mampu_bayar]; } } //get data radio $kon->sql = " SELECT kb.nama as nama, kb.bayar_bhp+kb.bayar_jasa as bayar, kb.mampu_bayar_bhp+kb.mampu_bayar_jasa as mampu_bayar, kwd.kwitansi_id as kwitansi_id FROM kunjungan_bayar kb JOIN radio_kunjungan lk ON (lk.id = kb.lab_kunjungan_id) JOIN kunjungan_kamar kk ON (kk.id = lk.kunjungan_kamar_id) JOIN kwitansi_detil kwd ON (kwd.kunjungan_bayar_id = kb.id) WHERE kb.radio_specimen_id IS NOT NULL AND kwd.kwitansi_id = '".$idkw."' GROUP BY kb.id ORDER BY kb.id "; $kon->execute(); $data_radio = $kon->getAll(); if(!empty($data_radio)) { $tabel->addRow("","<b>Pemeriksaan Radiologi</b>",""); for($i=0;$i<sizeof($data_radio);$i++) { $tabel->addRow( ($i+1), $data_radio[$i][nama], uangIndo($data_radio[$i][bayar]) ); $total += $data_radio[$i][bayar]; $sudah_dibayar += $data_radio[$i][mampu_bayar]; //belum bayar $kurang += $data_radio[$i][bayar]-$data_radio[$i][mampu_bayar]; } } //get data bhp $kon->sql = " SELECT kb.nama as nama, kb.bayar_bhp as bayar, kb.mampu_bayar_bhp as mampu_bayar, kwd.kwitansi_id as kwitansi_id FROM kunjungan_bayar kb JOIN kunjungan_kamar kk ON (kk.id = kb.kunjungan_kamar_id) JOIN kwitansi_detil kwd ON (kwd.kunjungan_bayar_id = kb.id) WHERE kb.bhp_id IS NOT NULL AND kwd.kwitansi_id = '".$idkw."' GROUP BY kb.id ORDER BY kb.id "; $kon->execute(); $data_bhp = $kon->getAll(); if(!empty($data_bhp)) { $tabel->addRow("","<b>Bahan Habis Pakai</b>",""); for($i=0;$i<sizeof($data_bhp);$i++) { $tabel->addRow( ($i+1), $data_bhp[$i][nama], uangIndo($data_bhp[$i][bayar]) ); $total += $data_bhp[$i][bayar]; $sudah_dibayar += $data_bhp[$i][mampu_bayar]; //belum bayar $kurang += $data_bhp[$i][bayar]-$data_bhp[$i][mampu_bayar]; } } //get data kendaraan $kon->sql = " SELECT kkd.nama as nama, SUM(kb.bayar_bhp+kb.bayar_jasa) as bayar, SUM(kb.mampu_bayar_bhp+kb.mampu_bayar_jasa) as mampu_bayar, kwd.kwitansi_id as kwitansi_id FROM kunjungan_kendaraan kkd JOIN kunjungan_bayar kb ON (kb.kunjungan_kendaraan_id = kkd.id) JOIN kwitansi_detil kwd ON (kwd.kunjungan_bayar_id = kb.id) JOIN kunjungan_kamar kk ON (kk.id = kb.kunjungan_kamar_id) WHERE kwd.kwitansi_id = '".$idkw."' GROUP BY kkd.id ORDER BY kkd.id "; $kon->execute(); $data_kendaraan = $kon->getAll(); if(!empty($data_kendaraan)) { $tabel->addRow("","<b>Sewa Kendaraan</b>",""); for($i=0;$i<sizeof($data_kendaraan);$i++) { $tabel->addRow( ($i+1), $data_kendaraan[$i][nama], uangIndo($data_kendaraan[$i][bayar]) ); $total += $data_kendaraan[$i][bayar]; $sudah_dibayar += $data_kendaraan[$i][mampu_bayar]; //belum bayar $kurang += $data_kendaraan[$i][bayar]-$data_kendaraan[$i][mampu_bayar]; } } $tabel->addRow("","<b>Total</b>", uangIndo($total)); $tabel_jasa = $tabel->build(); $objResponse->addAssign("lb_list_jasa", "innerHTML", $tabel_jasa); $objResponse->addAssign("lb_total_display", "value", uangIndo($total)); $objResponse->addAssign("lb_total_display", "title", terbilang($total)); $objResponse->addAssign("lb_sudah_dibayar", "value", $sudah_dibayar); $objResponse->addAssign("lb_sudah_dibayar_display", "value", uangIndo($sudah_dibayar)); $objResponse->addAssign("lb_sudah_dibayar_display", "title", terbilang($sudah_dibayar)); $objResponse->addAssign("lb_kurang_display", "value", uangIndo($kurang)); $objResponse->addAssign("lb_kurang", "value", $kurang); $objResponse->addAssign("lb_kurang_display", "title", terbilang($kurang)); $objResponse->addAssign("lb_mampu_bayar", "value", $kurang); $objResponse->addAssign("mampu_terbilang", "innerHTML", terbilang($kurang)); $objResponse->addScriptCall("disable_mainbar", "#E5E6E1"); $objResponse->addScriptCall("fokus", "lb_mampu_bayar"); //get data kwitansi : $kon->sql = " SELECT CONCAT_WS('-', kw.tempat_pembayaran, kw.id) as no_kwitansi, kw.bayar as mampu_bayar, kw.tgl as tgl FROM kunjungan_bayar kb JOIN kwitansi_detil kwd ON (kwd.kunjungan_bayar_id = kb.id) JOIN kwitansi kw ON (kw.id = kwd.kwitansi_id) JOIN kunjungan_kamar kk ON (kk.id = kb.kunjungan_kamar_id) WHERE kw.id = '".$idkw."' GROUP BY kw.id ORDER BY kw.id "; $kon->execute(); $data_kw = $kon->getAll(); if($kurang) { //ada yang belum dibayar $objResponse->addAssign("lb_simpan", "style.display", ""); } if(!empty($data_kw)) { //ada yang sudah dibayar for($i=0;$i<sizeof($data_kw);$i++) { $kw .= "<br /><input type=\"button\" name=\"lb_cetak\" id=\"lb_cetak\" value=\"Cetak Kwitansi ".$data_kw[$i][no_kwitansi]."\" class=\"inputan\" onclick=\"cetak_kwitansi('".$data_kw[$i][no_kwitansi]."');\" /> <br /> <em>Rp. ".uangIndo($data_kw[$i][mampu_bayar])." - ".tanggalIndo($data_kw[$i][tgl], "j F Y H:i")."</em><br />"; } $objResponse->addAssign("fieldset_lb_button_kwitansi", "style.display", ""); $objResponse->addAssign("lb_button_kwitansi", "innerHTML", $kw); if(!$kurang) $objResponse->addAssign("lb_simpan", "style.display", "none"); } else { $objResponse->addAssign("fieldset_lb_button_kwitansi", "style.display", "none"); } return $objResponse; }
function buka_langsung_bayar($idkk) { unset($_SESSION[igd][langsung_bayar]); $kon = new Konek; //$kon->debug = 1; $objResponse = new xajaxResponse; //get data pasien $kon->sql = " SELECT CONCAT_WS('-', SUBSTRING(p.id, 1,2), SUBSTRING(p.id, 3,2), SUBSTRING(p.id, 5,2), SUBSTRING(p.id, 7,2)) as id_display, p.nama as nama, p.tgl_lahir as tgl_lahir, CONCAT(p.alamat, ' ', IF(p.rt = '','',CONCAT(' RT ', p.rt)), IF(p.rw = '','',CONCAT(' RW ', p.rw)), ', ', des.nama, ', ', kec.nama, ', ', kab.nama) as alamat, kk.tgl_periksa as tgl_periksa, CONCAT_WS(' - ', pel.jenis, pel.nama) as nama_pelayanan, p.sex as jk, CONCAT_WS(' - ', kk.cara_bayar, kk.jenis_askes, rper.nama) as cara_bayar, kk.nomor as nomor FROM kunjungan_kamar kk JOIN kunjungan k ON (k.id = kk.kunjungan_id) JOIN pasien p ON (p.id = k.pasien_id) JOIN kamar kmr ON (kmr.id = kk.kamar_id) JOIN pelayanan pel ON (pel.id = kmr.pelayanan_id) JOIN ref_desa des ON (des.id = p.desa_id) JOIN ref_kecamatan kec ON (kec.id = des.kecamatan_id) JOIN ref_kabupaten kab ON (kab.id = kec.kabupaten_id) JOIN ref_propinsi prop ON (prop.id = kab.propinsi_id) LEFT JOIN ref_perusahaan rper ON (rper.id = kk.perusahaan_id) WHERE kk.id = '".$idkk."' GROUP BY p.id "; $kon->execute(); $data_pasien = $kon->getOne(); $arr_usia = hitungUmur($data_pasien[tgl_lahir], $data_pasien[tgl_periksa]); $data_pasien[usia] = empty($arr_usia[tahun])?"":$arr_usia[tahun] . " thn "; $data_pasien[usia] .= empty($arr_usia[bulan])?"":$arr_usia[bulan] . " bln "; $data_pasien[usia] .= empty($arr_usia[hari])?"":$arr_usia[hari] . " hr "; $objResponse->addClear("modal_lb", "style.display"); $objResponse->addAssign("lb_id_kunjungan_kamar", "value", $idkk); $objResponse->addAssign("lb_no_rm", "innerHTML", $data_pasien[id_display]); $objResponse->addAssign("lb_pasien", "innerHTML", $data_pasien[nama]); $objResponse->addAssign("lb_sex", "innerHTML", $data_pasien[jk]); $objResponse->addAssign("lb_usia", "innerHTML", $data_pasien[usia]); $objResponse->addAssign("lb_alamat", "innerHTML", $data_pasien[alamat]); $objResponse->addAssign("lb_tgl_periksa", "innerHTML", tanggalIndo($data_pasien[tgl_periksa], 'j F Y')); $objResponse->addAssign("lb_cara_bayar", "innerHTML", $data_pasien[cara_bayar]); $objResponse->addAssign("lb_pelayanan", "innerHTML", $data_pasien[nama_pelayanan]); $objResponse->addAssign("lb_nomor", "innerHTML", empty($data_pasien[nomor])?"-":$data_pasien[nomor]); //BIKIN SESSION UNTUK DICETAK $_SESSION[igd][langsung_bayar][data_px] = $data_pasien; $tabel = new Table; $tabel->cellspacing = "0"; $tabel->scroll = false; $tabel->extra_table = "style=\"width:9cm;\""; $tabel->addTh("No", "Jasa", "Biaya"); $tabel->addExtraTh("style=\"width:0.7cm;\"", "style=\"width:6.5cm;\"", ""); //get data karcis $kon->sql = " SELECT kb.nama as nama, kb.bayar_bhp+kb.bayar_jasa as bayar, kb.mampu_bayar_bhp+kb.mampu_bayar_jasa as mampu_bayar, kwd.kwitansi_id as kwitansi_id FROM kunjungan_bayar kb JOIN kunjungan_kamar kk ON (kk.id = kb.kunjungan_kamar_id) LEFT JOIN kwitansi_detil kwd ON (kwd.kunjungan_bayar_id = kb.id) WHERE kb.karcis_id IS NOT NULL AND kk.id = '".$idkk."' GROUP BY kb.id ORDER BY kb.id "; $kon->execute(); $data_karcis = $kon->getAll(); if(!empty($data_karcis)) { $tabel->addRow("","<b>Karcis</b>",""); for($i=0;$i<sizeof($data_karcis);$i++) { $tabel->addRow( ($i+1), $data_karcis[$i][nama], uangIndo($data_karcis[$i][bayar]) ); $total += $data_karcis[$i][bayar]; $sudah_dibayar += $data_karcis[$i][mampu_bayar]; //belum bayar if(!$data_karcis[$i][kwitansi_id]) $kurang += $data_karcis[$i][bayar]; } } //get data tindakan $kon->sql = " SELECT kki.nama as nama, SUM(kb.bayar_jasa) as bayar, SUM(kb.mampu_bayar_jasa) as mampu_bayar, kwd.kwitansi_id as kwitansi_id FROM kunjungan_kamar_icopim kki JOIN kunjungan_bayar kb ON (kb.kunjungan_kamar_icopim_id = kki.id) LEFT JOIN kwitansi_detil kwd ON (kwd.kunjungan_bayar_id = kb.id) WHERE kb.icopim_detil_id IS NOT NULL AND kki.kunjungan_kamar_id = '".$idkk."' GROUP BY kki.id ORDER BY kki.id "; $kon->execute(); $data_tindakan = $kon->getAll(); if(!empty($data_tindakan)) { $tabel->addRow("","<b>Tindakan</b>",""); for($i=0;$i<sizeof($data_tindakan);$i++) { $tabel->addRow( ($i+1), $data_tindakan[$i][nama], uangIndo($data_tindakan[$i][bayar]) ); $total += $data_tindakan[$i][bayar]; $sudah_dibayar += $data_tindakan[$i][mampu_bayar]; //belum bayar if(!$data_tindakan[$i][kwitansi_id]) $kurang += $data_tindakan[$i][bayar]; } } //get data bhp $kon->sql = " SELECT kb.nama as nama, kb.bayar_bhp as bayar, kb.mampu_bayar_bhp as mampu_bayar, kwd.kwitansi_id as kwitansi_id FROM kunjungan_bayar kb JOIN kunjungan_kamar kk ON (kk.id = kb.kunjungan_kamar_id) LEFT JOIN kwitansi_detil kwd ON (kwd.kunjungan_bayar_id = kb.id) WHERE kb.bhp_id IS NOT NULL AND kk.id = '".$idkk."' GROUP BY kb.id ORDER BY kb.id "; $kon->execute(); $data_bhp = $kon->getAll(); if(!empty($data_bhp)) { $tabel->addRow("","<b>Bahan Habis Pakai</b>",""); for($i=0;$i<sizeof($data_bhp);$i++) { $tabel->addRow( ($i+1), $data_bhp[$i][nama], uangIndo($data_bhp[$i][bayar]) ); $total += $data_bhp[$i][bayar]; $sudah_dibayar += $data_bhp[$i][mampu_bayar]; //belum bayar if(!$data_bhp[$i][kwitansi_id]) $kurang += $data_bhp[$i][bayar]; } } $tabel->addRow("","<b>Total</b>", uangIndo($total)); $tabel_jasa = $tabel->build(); $tabel_jasa .= "<br />Terbilang : <i>" . terbilang($total) . "</i>"; $objResponse->addAssign("lb_list_jasa", "innerHTML", $tabel_jasa); $objResponse->addScriptCall("disable_mainbar", "#E5E6E1"); return $objResponse; }
<?php if (!defined('BASEPATH')) { exit('No direct script access allowed'); } $zfm = new zetro_frmBuilder('asset/bin/zetro_inv.frm'); $zlb = new zetro_buildlist(); $zlb->config_file('asset/bin/zetro_inv.frm'); $path = 'application/views/akuntansi/kas'; calender(); link_css('jquery.coolautosuggest.css', 'asset/css'); link_js('jquery.coolautosuggest.js,jquery_terbilang.js', 'asset/js,asset/js'); link_js('jquery.fixedheader.js,laba_rugi.js', 'asset/js,' . $path . '/js'); panel_begin('Laba Rugi'); panel_multi('labarugi', 'block', false); if ($all_labarugi != '') { addText(array('Periode Tanggal : ', ' s/d ', '', ''), array("<input type='text' id='dari_tgl' name='dari_tgl' value=''/>", "<input type='text' id='sampai_tgl' name='sampai_tgl' value=''/>", "<input type='button' id='okedech' value='OK'/>", "<input type='checkbox' id='pajak' name='pajak' value='ok' style='display:none'>"), true, 'frm1'); } else { no_auth(); } panel_multi_end(); panel_end(); terbilang();
function get_total($val = array(), $simpan_dulu = true) { $objResponse = new xajaxResponse; $kon = new Konek; //disimpan dulu jika //$objResponse->addScriptCall("xajax_buka_kunjungan", $val[input_id_kunjungan_kamar]); if($simpan_dulu == true) { //$objResponse->addScriptCall("xajax_simpan_kunjungan", $val, false); } /* $kon->sql = "SELECT kwitansi_id, SUM(bayar) as bayar, SUM(mampu_bayar) as mampu_bayar FROM kunjungan_bayar WHERE kunjungan_kamar_id = '".$val[input_id_kunjungan_kamar]."' GROUP BY id"; $kon->execute(); $data = $kon->getAll(); for($i=0;$i<sizeof($data);$i++) { if(!$data[$i][kwitansi_id]) { //belum dibayar $belum += $data[$i][bayar]; } else { //sudah dibayar $sudah += $data[$i][bayar]; } } */ $kon->sql = "SELECT SUM(bayar) as bayar, SUM(mampu_bayar) as mampu_bayar FROM kunjungan_bayar WHERE kunjungan_kamar_id = '".$val[input_id_kunjungan_kamar]."' GROUP BY kunjungan_kamar_id"; $kon->execute(); $data = $kon->getOne(); $total = $data[bayar]; $sudah_dibayar = $data[mampu_bayar]; $belum_dibayar = $data[bayar] - $data[mampu_bayar]; $objResponse->addAssign("total", "value", ($total)); $objResponse->addAssign("total_terbilang", "innerHTML", terbilang($total)); $objResponse->addAssign("sudah", "value", ($sudah_dibayar)); $objResponse->addAssign("sudah_terbilang", "innerHTML", terbilang($sudah_dibayar)); $objResponse->addAssign("belum", "value", ($belum_dibayar)); $objResponse->addAssign("belum_terbilang", "innerHTML", terbilang($belum_dibayar)); $objResponse->addAssign("mampu", "value", $total); $objResponse->addAssign("mampu_terbilang", "innerHTML", terbilang($total)); return $objResponse; }