PHP clsDBConnSIKP::close方法代码示例

function t_vat_setllementGrid_cetak_stpd_BeforeShow(&$sender)
{
    $t_vat_setllementGrid_cetak_stpd_BeforeShow = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $t_vat_setllementGrid;
    //Compatibility
    //End t_vat_setllementGrid_cetak_stpd_BeforeShow
    //Custom Code @342-2A29BDB7
    // -------------------------
    // Write your own code here.
    $nilai = $t_vat_setllementGrid->t_vat_setllement_id->GetValue();
    $dbConn = new clsDBConnSIKP();
    $sql = "select count(*)as ada from t_vat_penalty where t_vat_setllement_id = " . $nilai;
    $dbConn->query($sql);
    $dbConn->next_record();
    $ada = $dbConn->f("ada");
    $dbConn->close();
    if ($ada > 0) {
        $t_vat_setllementGrid->cetak_stpd->SetValue("<input type='button' value='CETAK' style='WIDTH: 57px; HEIGHT: 22px' class='Button' onclick=\"" . "cetakStpd(" . $nilai . ")\">");
    } else {
        $t_vat_setllementGrid->cetak_stpd->SetValue("");
    }
    // -------------------------
    //End Custom Code
    //Close t_vat_setllementGrid_cetak_stpd_BeforeShow @341-625FE229
    return $t_vat_setllementGrid_cetak_stpd_BeforeShow;
}

function t_vat_reg_dtl_parkingForm_BeforeSelect(&$sender)
{
    $t_vat_reg_dtl_parkingForm_BeforeSelect = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $t_vat_reg_dtl_parkingForm;
    //Compatibility
    //End t_vat_reg_dtl_parkingForm_BeforeSelect
    //Custom Code @822-2A29BDB7
    // -------------------------
    // Write your own code here.
    $CustId = $t_vat_reg_dtl_parkingForm->t_cust_account_id->GetValue();
    $dbConn = new clsDBConnSIKP();
    $query = "select a.p_vat_type_dtl_id, b.vat_code as parking_classification_code " . "from t_cust_account a, p_vat_type_dtl b " . "where a.p_vat_type_dtl_id = b.p_vat_type_dtl_id " . "and t_cust_account_id = " . $CustId;
    $dbConn->query($query);
    while ($dbConn->next_record()) {
        $idd = $dbConn->f("p_vat_type_dtl_id");
        $code = $dbConn->f("parking_classification_code");
    }
    $dbConn->close();
    $t_vat_reg_dtl_parkingForm->p_parking_classification_id->SetValue($idd);
    $t_vat_reg_dtl_parkingForm->classification_desc->SetValue($code);
    // -------------------------
    //End Custom Code
    //Close t_vat_reg_dtl_parkingForm_BeforeSelect @94-79EB8A58
    return $t_vat_reg_dtl_parkingForm_BeforeSelect;
}

function t_vat_setllementGrid_BeforeShowRow(&$sender)
{
    $t_vat_setllementGrid_BeforeShowRow = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $t_vat_setllementGrid;
    //Compatibility
    //End t_vat_setllementGrid_BeforeShowRow
    //Set Row Style @315-982C9472
    $styles = array("Row", "AltRow");
    if (count($styles)) {
        $Style = $styles[($Component->RowNumber - 1) % count($styles)];
        if (strlen($Style) && !strpos($Style, "=")) {
            $Style = (strpos($Style, ":") ? 'style="' : 'class="') . $Style . '"';
        }
        $Component->Attributes->SetValue("rowStyle", $Style);
    }
    //End Set Row Style
    // Start Bdr
    global $t_vat_setllementForm;
    global $selected_id;
    global $add_flag;
    global $is_show_form;
    if ($selected_id < 0 && $add_flag != "ADD") {
        $selected_id = $Component->DataSource->t_vat_setllement_id->GetValue();
        $t_vat_setllementForm->DataSource->Parameters["urlt_vat_setllement_id"] = $selected_id;
        $t_vat_setllementForm->DataSource->Prepare();
        $t_vat_setllementForm->EditMode = $t_vat_setllementForm->DataSource->AllParametersSet;
    }
    $flag_delete = CCGetFromGet("flag_delete", "");
    if ($flag_delete == "true") {
        $selected_id = CCGetFromGet("t_vat_setllement_id", $selected_id);
        $dbConn = new clsDBConnSIKP();
        $dbConn->query("select f_del_vat_setllement({$selected_id}, 0, 'x')");
        $dbConn->close();
        header("Location: t_vat_setllement_edit_ro.php");
    }
    // End Bdr
    $styles = array("Row", "AltRow");
    // Start Bdr
    $img_radio = "<img border=\"0\" src=\"../images/radio.gif\">";
    $Style = $styles[0];
    if ($Component->DataSource->t_vat_setllement_id->GetValue() == $selected_id) {
        $img_radio = "<img border=\"0\" src=\"../images/radio_s.gif\">";
        $Style = $styles[1];
        $is_show_form = 1;
    }
    // End Bdr
    if (count($styles)) {
        //$Style = $styles[($Component->RowNumber - 1) % count($styles)];
        if (strlen($Style) && !strpos($Style, "=")) {
            $Style = (strpos($Style, ":") ? 'style="' : 'class="') . $Style . '"';
        }
        $Component->Attributes->SetValue("rowStyle", $Style);
    }
    $Component->DLink->SetValue($img_radio);
    // Bdr
    //Close t_vat_setllementGrid_BeforeShowRow @2-CAEE8B40
    return $t_vat_setllementGrid_BeforeShowRow;
}

 function PageCetak($data, $user, $tahun, $tgl_penerimaan, $tgl_penerimaan_last, $npwpd)
 {
     $this->AliasNbPages();
     $this->AddPage("L");
     $this->SetFont('Arial', 'B', 12);
     $lheader = $this->lengthCell / 8;
     $lheader1 = $lheader * 1;
     $lheader2 = $lheader - 15;
     $lheader3 = $lheader * 3;
     $lheader4 = $lheader * 4;
     $dbConn = new clsDBConnSIKP();
     $query = "SELECT a.*,\r\n                    c.region_name AS nama_kota,\r\n                    d.region_name AS nama_kecamatan,\r\n                    e.region_name AS nama_kelurahan\r\n                    FROM t_cust_account a\r\n                    LEFT JOIN p_region c ON a.brand_p_region_id = c.p_region_id\r\n                    LEFT JOIN p_region d ON a.brand_p_region_id_kec = d.p_region_id\r\n                    LEFT JOIN p_region e ON a.brand_p_region_id_kel = e.p_region_id\r\n                    where a.npwd = '" . $npwpd . "'";
     $dbConn->query($query);
     $alamat = '';
     while ($dbConn->next_record()) {
         //$alamat = $dbConn->f("brand_address_name")." .No ". $dbConn->f("brand_address_no")." RT/RW: ".$dbConn->f("brand_address_rt")."/".$dbConn->f("brand_address_rw"). ". KEC.".$dbConn->f("nama_kecamatan")." KEL.".$dbConn->f("nama_kelurahan");
         $alamat = $dbConn->f("brand_address_name") . " .No " . $dbConn->f("brand_address_no");
     }
     $dbConn->close();
     $this->Cell($lheader2, $this->height, "NPWPD :");
     $this->Cell($lheader1, $this->height, $npwpd);
     $this->Ln();
     $this->Cell($lheader2, $this->height, "Alamat :");
     $this->Cell($lheader1, $this->height, $alamat);
     $this->SetFont('Arial', '', 10);
     $this->Ln();
     $this->Ln();
     $ltable = $this->lengthCell / 26;
     $ltable1 = $ltable * 1;
     $ltable2 = $ltable * 2;
     $ltable3 = $ltable * 3;
     $ltable4 = $ltable * 4;
     $ltable5 = $ltable * 5;
     $ltable6 = $ltable * 6;
     $ltable7 = $ltable * 7;
     $ltable8 = $ltable * 8;
     $this->Cell($ltable4, $this->height + 2, "NAMA BADAN", "TBLR", 0, 'C');
     $this->Cell($ltable3, $this->height + 2, "JENIS KETETAPAN", "TBLR", 0, 'C');
     $this->Cell($ltable6, $this->height + 2, "PERIODE TRANSAKSI", "TBLR", 0, 'C');
     $this->Cell($ltable3, $this->height + 2, "TGL PELAPORAN", "TBLR", 0, 'C');
     $this->Cell($ltable3, $this->height + 2, "TOTAL PAJAK", "TBLR", 0, 'C');
     $this->Cell($ltable5, $this->height + 2, "NO. KWITANSI", "TBLR", 0, 'C');
     $this->Ln();
     //isi kolom
     $this->SetWidths(array($ltable4, $ltable3, $ltable6, $ltable3, $ltable3, $ltable5));
     $this->SetAligns(array("L", "C", "C", "C", "R", "L"));
     $no = 1;
     $jumlahperayat = array();
     $jumlahperwaktu = array();
     $jumlahtemp = 0;
     $i = 0;
     $total = 0;
     foreach ($data as $item) {
         //print data
         $this->RowMultiBorderWithHeight(array($item["company_name"], $item["type_code"], $item["periode_awal_laporan"] . " s.d " . $item["periode_akhir_laporan"], $item["tgl_pelaporan"], number_format($item["total_pajak"], 0, ',', '.'), $item["kuitansi_pembayaran"]), array('TBLR', 'TBLR', 'TBLR', 'TBLR', 'TBLR', 'TBLR'), $this->height);
         $no++;
     }
 }

function t_vat_setllementGrid_cetak_sptpd_BeforeShow(&$sender)
{
    $t_vat_setllementGrid_cetak_sptpd_BeforeShow = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $t_vat_setllementGrid;
    //Compatibility
    //End t_vat_setllementGrid_cetak_sptpd_BeforeShow
    //Custom Code @301-2A29BDB7
    // -------------------------
    // Write your own code here.
    // -------------------------
    //End Custom Code
    //DEL  // -------------------------
    //DEL      // Write your own code here.
    $nilai = $t_vat_setllementGrid->t_vat_setllement_id->GetValue();
    $dbConn = new clsDBConnSIKP();
    $sql = "select count(*)as ada from t_vat_penalty where t_vat_setllement_id = " . $nilai;
    $dbConn->query($sql);
    $dbConn->next_record();
    $ada = $dbConn->f("ada");
    $dbConn->close();
    if ($ada > 0) {
        //$nilai2 = $t_vat_setllementGrid->p_vat_type_id->GetValue();
        $t_vat_setllementGrid->cetak_sptpd->SetValue("<input type='button' value='CETAK' style='WIDTH: 57px; HEIGHT: 22px' class='Button' onclick=\"" . "cetakStpd(" . $nilai . ",'tgl_tap')\">");
        $t_vat_setllementGrid->cetak_sptpd2->SetValue("<input type='button' value='CETAK' style='WIDTH: 57px; HEIGHT: 22px' class='Button' onclick=\"" . "cetakStpd(" . $nilai . ",'tgl_bayar')\">");
    } else {
        $t_vat_setllementGrid->cetak_sptpd->SetValue("");
        $t_vat_setllementGrid->cetak_sptpd2->SetValue("");
    }
    /*
    $action_button = CCGetFromGet("action_button","");
    $action_button2 = CCGetFromGet("action_button2","");
    if($action_button=='flag_payment' && $action_button2!='cetak_register'){
    	$dbConn = new clsDBConnSIKP();
    	$sql="select sikp.f_payment_manual(".CCGetFromGet('t_customer_order_id').",'".CCGetSession('UserLogin')."')";
    	$dbConn->query($sql);
    	$dbConn->next_record();
    	echo "
    	<script>
    	alert('".$dbConn->f('f_payment_manual')."');
    	</script>
    	";
    	$dbConn->close();	
    }else if($action_button2=='cetak_register'){
    	$dbConn = new clsDBConnSIKP();
    	$sql="select sikp.f_print_register(".CCGetFromGet('t_customer_order_id').",'".CCGetSession('UserLogin')."')";
    	$dbConn->query($sql);
    	$dbConn->next_record();
    	print_laporan($dbConn->f('f_print_register'));
    	$dbConn->close();
    }
    */
    // -------------------------
    //Close t_vat_setllementGrid_cetak_sptpd_BeforeShow @300-BF0BB7F2
    return $t_vat_setllementGrid_cetak_sptpd_BeforeShow;
}

function Page_BeforeShow(&$sender)
{
    $Page_BeforeShow = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $t_wp_registration_list;
    //Compatibility
    //End Page_BeforeShow
    //Custom Code @562-2A29BDB7
    // -------------------------
    // Write your own code here.
    global $Label1;
    $tampil = CCGetFromGet('tampil');
    if ($tampil == 'T') {
        $Label1->SetText("<table border=1><tr><td>tes</td></tr></table>");
        $tgl_penerimaan = CCGetFromGet("tgl_penerimaan", "");
        //'15-12-2013';
        $tgl_penerimaan_last = CCGetFromGet("tgl_penerimaan_last", "");
        //'15-12-2013';
        $jenis_pajak = CCGetFromGet("jenis_pajak", 0);
        // $tgl_penerimaan		= '15-12-2013';
        $user = CCGetUserLogin();
        $data = array();
        $dbConn = new clsDBConnSIKP();
        if ($jenis_pajak == 0 || $jenis_pajak == "") {
            $query = "select a.*, b.vat_code, c.code as account_status from t_vat_registration a\r\n\t\t\tleft join p_vat_type_dtl z on z.p_vat_type_dtl_id = a.p_vat_type_dtl_id\r\n\t\t\tleft join p_vat_type b on b.p_vat_type_id = z.p_vat_type_id\r\n\t\t\tleft join t_customer_order y on y.t_customer_order_id = a.t_customer_order_id\r\n\t\t\tLEFT JOIN p_order_status C ON C .p_order_status_id = y .p_order_status_id\r\n\t\t\twhere trunc(registration_date) >= to_date('{$tgl_penerimaan}')\r\n\t\t\tAND trunc(registration_date) <= to_date('{$tgl_penerimaan_last}')\r\n\t\t\tORDER BY registration_date ASC";
        } else {
            $query = "select a.*, b.vat_code, c.code as account_status from t_vat_registration a\r\n\t\t\tleft join p_vat_type_dtl z on z.p_vat_type_dtl_id = a.p_vat_type_dtl_id\r\n\t\t\tleft join p_vat_type b on b.p_vat_type_id = z.p_vat_type_id\r\n\t\t\tleft join t_customer_order y on y.t_customer_order_id = a.t_customer_order_id\r\n\t\t\tLEFT JOIN p_order_status C ON C .p_order_status_id = y .p_order_status_id\r\n\t\t\twhere trunc(registration_date) >= to_date('{$tgl_penerimaan}')\r\n\t\t\tAND trunc(registration_date) <= to_date('{$tgl_penerimaan_last}')\r\n\t\t\tAND a.p_vat_type_dtl_id in (select p_vat_type_dtl_id from p_vat_type_dtl\r\n\t\t\t\twhere p_vat_type_id = {$jenis_pajak})\r\n\t\t\tORDER BY registration_date ASC";
        }
        //echo $query;
        //exit;
        $tgl_penerimaan = str_replace("'", "", $tgl_penerimaan);
        $dbConn->query($query);
        while ($dbConn->next_record()) {
            $data["t_cust_account_id"][] = $dbConn->f("t_cust_account_id");
            $data["t_customer_id"][] = $dbConn->f("t_customer_id");
            $data["npwd"][] = $dbConn->f("npwpd");
            $data["vat_code"][] = $dbConn->f("vat_code");
            $data["registration_date"][] = $dbConn->f("registration_date");
            $data["wp_name"][] = $dbConn->f("wp_name");
            $data["wp_address_name"][] = $dbConn->f("wp_address_name");
            $data["company_name"][] = $dbConn->f("company_name");
            $data["address_name"][] = $dbConn->f("address_name");
            $data["account_status"][] = $dbConn->f("account_status");
        }
        $dbConn->close();
        $Label1->SetText(PageCetak($data, $user, $tgl_penerimaan, $tgl_penerimaan_last));
    }
    // -------------------------
    //End Custom Code
    //Close Page_BeforeShow @1-4BC230CD
    return $Page_BeforeShow;
}

 function PageCetak($data)
 {
     $this->AddPage();
     // $this->Cell(0, $this->height, $data["f_bphtb_receipt_duplicate"], 0, 0, "L");
     $exp_data = explode("\n", $data["f_bphtb_receipt_duplicate"]);
     //get no kuitansi
     $exp_data1 = explode(":", $exp_data[0]);
     $encImageData = '';
     $dbConn = new clsDBConnSIKP();
     $query = "select f_encrypt_str('" . trim($exp_data1[1]) . "') AS enc_data";
     $dbConn->query($query);
     while ($dbConn->next_record()) {
         $encImageData = $dbConn->f("enc_data");
     }
     $dbConn->close();
     if (empty($encImageData)) {
         $encImageData = "EmptyData";
     }
     $this->Image('../images/logo_pemda.png', 37, 13, 25, 25);
     $this->Image('http://' . $_SERVER['HTTP_HOST'] . '/mpd/include/qrcode/generate-qr.php?param=' . $encImageData, 179, 13, 25, 25, 'PNG');
     //$this->Image('http://172.16.20.2:81/mpd/include/qrcode/generate-qr.php?param='.encImageData,179,13,25,25,'PNG');
     $this->SetFont('Arial', '', 11);
     $this->Cell(40, $this->height, "", "", 0, 'L');
     $this->Cell(101, $this->height, "PEMERINTAH KOTA BANDUNG", "", 0, 'C');
     $this->Cell(40, $this->height, "", "", 0, 'L');
     $this->Ln();
     $this->Cell(40, $this->height, "", "", 0, 'L');
     $this->Cell(101, $this->height, "DINAS PELAYANAN PAJAK", "", 0, 'C');
     $this->Cell(40, $this->height, "", "", 0, 'L');
     $this->Ln();
     $this->Cell(40, $this->height, "", "", 0, 'L');
     $this->Cell(101, $this->height, "Jalan Wastukancana No 2", "", 0, 'C');
     $this->Cell(40, $this->height, "", "", 0, 'L');
     $this->Ln();
     $this->Cell(40, $this->height, "", "", 0, 'L');
     $this->Cell(101, $this->height, "Telp. 022 4235052 - Bandung", "", 0, 'C');
     $this->Cell(40, $this->height, "", "", 0, 'L');
     $this->Ln();
     $this->SetFont('Arial', 'B', 14);
     $this->Cell(40, $this->height + 7, "", "B", 0, 'L');
     $this->Cell(101, $this->height + 7, "Bukti Pembayaran Pajak BPHTB", "B", 0, 'C');
     $this->Cell(40, $this->height + 7, "", "B", 0, 'L');
     $this->Ln(5);
     $this->Ln();
     $this->SetFont('Courier', '', 10);
     $data = explode("\n", $data["f_bphtb_receipt_duplicate"]);
     foreach ($data as $datum) {
         $this->Cell(241.3, $this->height, $datum, 0, 0, "L");
         $this->Ln();
     }
     $this->Cell(180, $this->height, "", "B", 0, "C");
 }

function t_vat_setllementGrid_cetak_sptpd_BeforeShow(&$sender)
{
    $t_vat_setllementGrid_cetak_sptpd_BeforeShow = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $t_vat_setllementGrid;
    //Compatibility
    //End t_vat_setllementGrid_cetak_sptpd_BeforeShow
    // -------------------------
    // Write your own code here.
    $pajak = $t_vat_setllementGrid->total_vat_amount->GetValue();
    $denda = $t_vat_setllementGrid->total_penalty_amount->GetValue();
    $totaltotal = $pajak + $denda;
    $t_vat_setllementGrid->total_total->SetValue($totaltotal);
    $nilai = $t_vat_setllementGrid->t_vat_setllement_id->GetValue();
    $nilai2 = $t_vat_setllementGrid->p_vat_type_id->GetValue();
    $t_vat_setllementGrid->cetak_sptpd->SetValue("<input type='button' style='display:none;' value='CETAK' style='WIDTH: 57px; HEIGHT: 22px' class='Button' onclick=\"" . "cetakSptpd(" . $nilai . "," . $nilai2 . ")\">");
    $action_button = CCGetFromGet("action_button", "");
    $action_button2 = CCGetFromGet("action_button2", "");
    if ($action_button == 'flag_payment' && $action_button2 != 'cetak_register') {
        $dbConn = new clsDBConnSIKP();
        $sql = "select sikp.f_payment_manual(" . CCGetFromGet('t_customer_order_id') . ",'" . CCGetSession('UserLogin') . "')";
        $dbConn->query($sql);
        $dbConn->next_record();
        echo "\r\n  \t\t<script>\r\n  \t\talert('" . $dbConn->f('f_payment_manual') . "');\r\n  \t\t</script>\r\n  \t\t";
        $dbConn->close();
    } else {
        if ($action_button2 == 'cetak_register') {
            $dbConn = new clsDBConnSIKP();
            $sql = "select sikp.f_print_register(" . CCGetFromGet('t_customer_order_id') . ",'" . CCGetSession('UserLogin') . "')";
            $dbConn->query($sql);
            $dbConn->next_record();
            print_laporan($dbConn->f('f_print_register'));
            /*echo "
            			<script>
            				window.open('../services/print_string.php?input_number=".$dbConn->f('f_print_register')."', '_blank', 'location=yes,height=570,width=520,scrollbars=yes,status=yes');
            			</script>
            		";*/
            $dbConn->close();
            exit;
        }
    }
    // -------------------------
    //Close t_vat_setllementGrid_cetak_sptpd_BeforeShow @300-BF0BB7F2
    return $t_vat_setllementGrid_cetak_sptpd_BeforeShow;
}

function Page_BeforeShow(&$sender)
{
    $Page_BeforeShow = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $t_rep_lap_bpps_piutang2;
    //Compatibility
    //End Page_BeforeShow
    global $Label1;
    // -------------------------
    // Write your own code here.
    $doAction = CCGetFromGet('doAction');
    if ($doAction == 'view_html') {
        $p_vat_type_id = CCGetFromGet("p_vat_type_id", "");
        //$year_code = CCGetFromGet("year_code", "");
        $tgl_penerimaan = "'01-01-2010'";
        $tgl_penerimaan_last = "'31-12-2014'";
        $i_flag_setoran = 1;
        $p_year_period_id = 4;
        //year_period_id 4 = 2013
        //year_period_id 16 = 2014
        $date_start = str_replace("'", "", $year_code);
        //$year_date = DateTime::createFromFormat('d-m-Y', $date_start)->format('Y');
        $year_date = $year_code;
        $user = CCGetUserLogin();
        $data = array();
        $dbConn = new clsDBConnSIKP();
        $jenis_laporan = "all";
        $query = "select *,trunc(payment_date) \r\n\t\t\tfrom f_rep_bpps_piutang2new_rm_masuk_resto({$p_vat_type_id}, {$p_year_period_id}, {$tgl_penerimaan}, to_char(sysdate,'dd-mm-yyyy'), {$i_flag_setoran}) \r\n\t\t\torder by p_vat_type_dtl_id, wp_name,npwpd, payment_date";
        //echo $query; exit;
        $dbConn->query($query);
        $tgl_penerimaan = str_replace("'", "", $tgl_penerimaan);
        $tgl_penerimaan_last = str_replace("'", "", $tgl_penerimaan_last);
        $tahun = date("Y", strtotime($tgl_penerimaan));
        while ($dbConn->next_record()) {
            $data[] = array("address" => $dbConn->f("address"), "company_name" => $dbConn->f("company_name"), "kode_jns_trans" => $dbConn->f("kode_jns_trans"), "jns_trans" => $dbConn->f("jns_trans"), "kode_jns_pajak" => $dbConn->f("kode_jns_pajak"), "kode_ayat" => $dbConn->f("kode_ayat"), "jns_pajak" => $dbConn->f("jns_pajak"), "jns_ayat" => $dbConn->f("jns_ayat"), "nama_ayat" => $dbConn->f("nama_ayat"), "no_kohir" => $dbConn->f("no_kohir"), "wp_name" => $dbConn->f("wp_name"), "wp_address_name" => $dbConn->f("wp_address_name"), "wp_address_no" => $dbConn->f("wp_address_no"), "npwpd" => $dbConn->f("npwpd"), "jumlah_terima" => $dbConn->f("jumlah_terima"), "masa_pajak" => $dbConn->f("masa_pajak"), "kd_tap" => $dbConn->f("kd_tap"), "keterangan" => $dbConn->f("keterangan"), "payment_date" => $dbConn->f("payment_date"), "jam" => $dbConn->f("jam"));
        }
        $dbConn->close();
        $Label1->SetText(GetCetakHTML($data));
    }
    // -------------------------
    //Close Page_BeforeShow @1-4BC230CD
    return $Page_BeforeShow;
}

function Page_BeforeShow(&$sender)
{
    $Page_BeforeShow = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $t_rep_lap_harian_v2;
    //Compatibility
    //End Page_BeforeShow
    //Custom Code @562-2A29BDB7
    // -------------------------
    // Write your own code here.
    global $Label1;
    $tampil = CCGetFromGet('tampil');
    if ($tampil == 'T') {
        $Label1->SetText("<table border=1><tr><td>tes</td></tr></table>");
        $tgl_penerimaan = CCGetFromGet("tgl_penerimaan", "");
        //'15-12-2013';
        // $tgl_penerimaan		= '15-12-2013';
        $user = CCGetUserLogin();
        $data = array();
        $dbConn = new clsDBConnSIKP();
        $tgl_penerimaan = str_replace("'", "", $tgl_penerimaan);
        $query = " \r\n\t\t\t\tselect\r\n\t\t\t\t\tnama_jns_pajak,sum(jml_sd_hari_ini) as realisasi,p_vat_type_id \r\n\t\t\t\tfrom f_rep_lap_harian_bdhr_mod_1('" . $tgl_penerimaan . "') \r\n\t\t\t\twhere p_vat_type_id in (1,2,3,4,5,6)\r\n\t\t\t\tGROUP BY nama_jns_pajak,p_vat_type_id\r\n\t\t\t\tORDER BY p_vat_type_id";
        //echo $query;exit;
        $tgl_penerimaan = str_replace("'", "", $tgl_penerimaan);
        $dbConn->query($query);
        while ($dbConn->next_record()) {
            $data['nama_jns_pajak'][] = $dbConn->f('nama_jns_pajak');
            $data['realisasi'][] = $dbConn->f('realisasi');
            $data['p_vat_type_id'][] = $dbConn->f('p_vat_type_id');
        }
        $dbConn->close();
        $excel = CCGetFromGet('excel');
        if ($excel == 'T') {
            GetCetakExcel($data, $user, $tgl_penerimaan);
        } else {
            $Label1->SetText(PageCetak($data, $user, $tgl_penerimaan));
        }
    }
    // -------------------------
    //End Custom Code
    //Close Page_BeforeShow @1-4BC230CD
    return $Page_BeforeShow;
}

function Page_BeforeShow(&$sender)
{
    $Page_BeforeShow = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $t_bphtb_registration_list_check_date;
    //Compatibility
    //End Page_BeforeShow
    //Custom Code @703-2A29BDB7
    // -------------------------
    // Write your own code here.
    global $Label1;
    if (CCGetFromGet("doAction") == "html") {
        $s_keyword = CCGetFromGet("s_keyword", "");
        $date_start_laporan = CCGetFromGet("date_start_laporan", "");
        $date_end_laporan = CCGetFromGet("date_end_laporan", "");
        $user = CCGetUserLogin();
        $data = array();
        $dbConn = new clsDBConnSIKP();
        $query = "SELECT * FROM t_payment_receipt_bphtb x\r\n\t\t\tLEFT JOIN t_bphtb_registration y ON y.t_bphtb_registration_id = x.t_bphtb_registration_id\r\n\t\t\tLEFT JOIN t_customer_order z ON y.t_customer_order_id = z.t_customer_order_id\r\n\t\t\tWHERE\r\n\t\t\t\tcheck_date IS NOT NULL\r\n\t\t\tAND wp_name ILIKE '%{$s_keyword}%'";
        if ($date_end_laporan != "" && $date_start_laporan != "") {
            $query .= "AND(check_date BETWEEN to_date ('{$date_start_laporan}') AND ('{$date_end_laporan}'))";
        } else {
            if ($date_end_laporan != "") {
                $query .= "AND(check_date <= to_date ('{$date_end_laporan}') )";
            }
            if ($date_start_laporan != "") {
                $query .= "AND(check_date >= to_date ('{$date_start_laporan}') )";
            }
        }
        $dbConn->query($query);
        while ($dbConn->next_record()) {
            $data[] = array("wp_name" => $dbConn->f("wp_name"), "order_no" => $dbConn->f("order_no"), "receipt_no" => $dbConn->f("receipt_no"), "check_date" => $dbConn->f("check_date"), "wp_address_name" => $dbConn->f("wp_address_name"), "t_payment_receipt_id" => $dbConn->f("t_payment_receipt_id"), "t_bphtb_registration_id" => $dbConn->f("t_bphtb_registration_id"), "bphtb_registration_no" => $dbConn->f("bphtb_registration_no"), "t_customer_order_id" => $dbConn->f("t_customer_order_id"), "payment_date" => $dbConn->f("payment_date"), "payment_vat_amount" => $dbConn->f("payment_vat_amount"));
        }
        $dbConn->close();
        $Label1->SetText(GetCetakHTML($data));
    }
    // -------------------------
    //End Custom Code
    //Close Page_BeforeShow @1-4BC230CD
    return $Page_BeforeShow;
}

function t_vat_registrationForm_BeforeSelect(&$sender)
{
    $t_vat_registrationForm_BeforeSelect = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $t_vat_registrationForm;
    //Compatibility
    //End t_vat_registrationForm_BeforeSelect
    //Custom Code @686-2A29BDB7
    // -------------------------
    // Write your own code here.
    $CustId = CCGetFromGet("CURR_DOC_ID", "");
    $dbConn = new clsDBConnSIKP();
    $sql = "select p_settlement_type_id from t_vat_setllement where t_customer_order_id = " . $CustId;
    $dbConn->query($sql);
    $dbConn->next_record();
    $nilai = $dbConn->f("p_settlement_type_id");
    $dbConn->close();
    $t_vat_registrationForm->Hidden1->SetValue($nilai);
    // -------------------------
    //End Custom Code
    //Close t_vat_registrationForm_BeforeSelect @629-D64E68A4
    return $t_vat_registrationForm_BeforeSelect;
}

function p_pass_byadminForm_Button_Ubah_OnClick(&$sender)
{
    $p_pass_byadminForm_Button_Ubah_OnClick = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $p_pass_byadminForm;
    //Compatibility
    //End p_pass_byadminForm_Button_Ubah_OnClick
    //Custom Code @104-2A29BDB7
    // -------------------------
    // Write your own code here.
    global $FileName;
    global $PathToCurrentPage;
    $param = CCGetQueryString("QueryString", "");
    $dbConn = new clsDBConnSIKP();
    $old_pwd = $p_pass_byadminForm->o_user_pwd->GetValue();
    $new_pwd1 = $p_pass_byadminForm->n_user_pwd1->GetValue();
    $new_pwd2 = $p_pass_byadminForm->n_user_pwd2->GetValue();
    $idUser = $p_pass_byadminForm->p_app_user_id->GetValue();
    $sql = "select * from f_change_pass(" . $idUser . ",'" . $old_pwd . "','" . $new_pwd1 . "','" . $new_pwd2 . "')";
    $dbConn->query($sql);
    $dbConn->next_record();
    $mess = $dbConn->f("f_change_pass");
    $dbConn->close();
    echo '<script language="javascript">';
    echo 'alert("' . $mess . '");';
    echo '</script>';
    $p_pass_byadminForm->o_user_pwd->SetValue("");
    $p_pass_byadminForm->n_user_pwd1->SetValue("");
    $p_pass_byadminForm->n_user_pwd2->SetValue("");
    return;
    // -------------------------
    //End Custom Code
    //Close p_pass_byadminForm_Button_Ubah_OnClick @26-C74BD412
    return $p_pass_byadminForm_Button_Ubah_OnClick;
}

    }
    //barcode
    $bcr = "select f_gen_barcode('test')";
    $dbConn->query($bcr);
    while ($dbConn->next_record()) {
        $data["barcode"] = $dbConn->f("f_gen_barcode");
    }
    //nip & nama
    $ttd = "SELECT value as nama_kadin, value_2 as nip_kadin " . "FROM p_global_param " . "WHERE code = 'TTD KADIN'";
    $dbConn->query($ttd);
    while ($dbConn->next_record()) {
        $data["nama_kadin"] = $dbConn->f("nama_kadin");
        $data["nip_kadin"] = $dbConn->f("nip_kadin");
    }
    //end barcode
    $dbConn->close();
}
class FormCetak extends FPDF
{
    var $fontSize = 10;
    var $fontFam = 'Arial';
    var $yearId = 0;
    var $yearCode = "";
    var $paperWSize = 210;
    var $paperHSize = 297;
    var $height = 5;
    var $currX;
    var $currY;
    var $widths;
    var $aligns;
    function FormCetak()

function GetCetakExcel($param_arr)
{
    startExcel("rekap_skpdkb_jabatan.xls");
    $output = '';
    $output .= '<table id="table-piutang" class="grid-table-container" border="0" cellspacing="0" cellpadding="0">
          		<tr>
            		<td valign="top">';
    $output .= '<table class="grid-table" border="0" cellspacing="0" cellpadding="0" width="900">
                	<tr>
                  		<td colspan=5 class="th"><strong>LAPORAN REKAP SURAT TEGURAN PERBULAN</strong></td> 
                	</tr>
					<tr>
              		</table>';
    $output .= '<table id="table-piutang-detil" class="Grid" border="1" cellspacing="0" cellpadding="3px" width="100%">
                <tr >';
    $output .= '<th rowspan=2 align="center" >NO</th>';
    $output .= '<th rowspan=2 align="center" >BULAN</th>';
    $output .= '<th colspan=3 align="center" >JUMLAH TEGURAN KE</th></tr>';
    $output .= '<tr><th align="center" >1</th>';
    $output .= '<th align="center" >2</th>';
    $output .= '<th align="center" >3</th>';
    $output .= '</tr>';
    $dbConn = new clsDBConnSIKP();
    $query = "select t_debt_letter_id,t_customer_order_id,letter_date, sequence_no, code, \r\n\t\t\t\t\t(select count(*)\r\n\t\t\t\t\tfrom f_debt_letter_list(a.t_customer_order_id) x\r\n\t\t\t\t\tLEFT JOIN t_cust_account as y ON x.t_cust_account_id = y.t_cust_account_id\r\n\t\t\t\t\twhere y.p_vat_type_dtl_id NOT IN (11, 15, 17, 21, 27, 30, 41, 42, 43)) as jml\r\n\t\t\tfrom t_debt_letter a\r\n\t\t\tLEFT JOIN p_finance_period b on a.p_finance_period_id=b.p_finance_period_id\r\n\t\t\t where \r\n\t\t\t\ta.p_finance_period_id in (select p_finance_period_id \r\n\t\t\t\t\tfrom p_finance_period where p_year_period_id = " . $param_arr['p_year_period_id'] . ")\r\n\t\t\tORDER BY letter_date";
    //echo $query;exit;
    $data = array();
    $dbConn->query($query);
    while ($dbConn->next_record()) {
        $data[] = $dbConn->Record;
    }
    $dbConn->close();
    $no = 1;
    for ($i = 0; $i < count($data); $i++) {
        if ($data[$i]['code'] == $data[$i - 1]['code'] && $i != 0) {
            $output .= '<td align="left" >' . $data[$i]['jml'] . '</td>';
        } else {
            $output .= '<tr><td align="center" >' . $no . '</td>';
            $output .= '<td align="left" >' . $data[$i]['code'] . '</td>';
            $output .= '<td align="left" >' . $data[$i]['jml'] . '</td>';
            $no++;
        }
    }
    $output .= '</table>';
    echo $output;
    exit;
}