$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;
}
Example #2
1
 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";
     }
 }
Example #3
0
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;
}
Example #4
0
					<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>
Example #5
0
 function fterbilang()
 {
     $angka = $this->input->post("angka");
     $terbilang = terbilang($angka);
     $data["terbilang"] = $terbilang;
     $this->_built_json(json_encode($data));
 }
Example #6
0
 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);
 }
Example #7
0
 function terbilang()
 {
     $v = $_POST['v'];
     echo terbilang($v, 3) . ' Rupiah';
 }
Example #8
0
$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);
Example #9
0
                        </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>
Example #10
0
 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);
 }
Example #11
0
            <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>
    
Example #12
0
function terbilang_rupiah($x)
{
    $terbilang = terbilang($x);
    return trim($terbilang . " rupiah");
}
Example #13
0
 $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);
Example #15
0
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";
    }
}
Example #16
0
 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 ";
     }
 }
Example #17
0
    ?>
    <?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">&nbsp;</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">
Example #18
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...';
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}
Example #19
0
    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...';
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}
Example #21
0
                </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>
Example #22
0
$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();
Example #24
0
 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);
 }
Example #25
0
 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);
 }
Example #26
0
    <?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">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</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.&nbsp;".uangIndo($data_kw[$i][mampu_bayar])."&nbsp;-&nbsp;".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;
	}
Example #28
0
	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;
	}
Example #29
0
<?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();
Example #30
-2
	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;
	}