PHP clsDBConnSIKP类代码示例

function grafik_pembayaran_form_Button2_OnClick(&$sender)
{
    $grafik_pembayaran_form_Button2_OnClick = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $grafik_pembayaran_form;
    //Compatibility
    //End grafik_pembayaran_form_Button2_OnClick
    //Custom Code @71-2A29BDB7
    // -------------------------
    // Write your own code here.
    $app_user_name = $grafik_pembayaran_form->app_user_name->GetValue();
    $mobile_no = $grafik_pembayaran_form->mobile_no->GetValue();
    $message = $grafik_pembayaran_form->message->GetValue();
    $dbConn = new clsDBConnSIKP();
    $query = "INSERT INTO t_sms_outbox(\r\n\t\t\t            npwpd, mobile_no, message, is_sent, date_added, message_type)\r\n\t\t\t    VALUES ('" . $app_user_name . "', '" . $mobile_no . "', '" . $message . "', 'N', sysdate, 'SMS_BLAST')";
    $dbConn->query($query);
    echo '<script>
				alert ("SMS akan segera dikirim.");
				location.href="t_send_sms_to_app_user.php";
			</script>
			
			';
    return;
    // -------------------------
    //End Custom Code
    //Close grafik_pembayaran_form_Button2_OnClick @20-8AF2D859
    return $grafik_pembayaran_form_Button2_OnClick;
}

function GetSurvey($param_arr)
{
    $output = '';
    $dbConn = new clsDBConnSIKP();
    $query = "select * from t_vat_registration where npwpd = '" . $param_arr['npwpd'] . "'";
    //echo $query;exit;
    $dbConn->query($query);
    if ($dbConn->next_record()) {
        $data = $dbConn->Record;
        $query2 = "select * from p_survey_question WHERE p_survey_type_id=1 and sequence_no =1";
        $dbConn2 = new clsDBConnSIKP();
        $dbConn2->query($query2);
        if ($dbConn2->next_record()) {
            $data2 = $dbConn2->Record;
            echo '<script language="javascript">';
            echo 'location.href="t_survey_kepuasan_pelanggan_pendaftaran_pertanyaan.php?t_vat_registration_id=' . $data["t_vat_registration_id"] . '&p_survey_question_id=' . $data2["p_survey_question_id"] . '"';
            echo '</script>';
        } else {
            echo '<script language="javascript">';
            echo 'alert("Pertanyaan tidak ditemukan.")';
            echo '</script>';
        }
    } else {
        $output = '<table class="Record" cellspacing="0" cellpadding="5" style="font-size:15px;padding-left:15px;" border="0">
		<tr>
			<td colspan="3">NPWPD : <b>' . $param_arr['npwpd'] . '</b> <b style="color:#FF0000;">TIDAK DITEMUKAN</b></td>
		</tr>
		</table>';
    }
    $dbConn->close();
    return $output;
}

function t_vat_reg_dtl_restaurantForm_BeforeSelect(&$sender)
{
    $t_vat_reg_dtl_restaurantForm_BeforeSelect = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $t_vat_reg_dtl_restaurantForm;
    //Compatibility
    //End t_vat_reg_dtl_restaurantForm_BeforeSelect
    //Custom Code @819-2A29BDB7
    // -------------------------
    // Write your own code here.
    $idVat = $t_vat_reg_dtl_restaurantForm->t_cust_account_id->GetValue();
    $dbConn = new clsDBConnSIKP();
    $sql = "select a.p_vat_type_dtl_id, b.vat_code as rest_service_type_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 a.t_cust_account_id = " . $idVat;
    $dbConn->query($sql);
    while ($dbConn->next_record()) {
        $restId = $dbConn->f("p_vat_type_dtl_id");
        $restCode = $dbConn->f("rest_service_type_code");
    }
    $t_vat_reg_dtl_restaurantForm->service_type_desc->SetValue($restCode);
    $t_vat_reg_dtl_restaurantForm->p_rest_service_type_id->SetValue($restId);
    // -------------------------
    //End Custom Code
    //Close t_vat_reg_dtl_restaurantForm_BeforeSelect @94-6EBC2391
    return $t_vat_reg_dtl_restaurantForm_BeforeSelect;
}

function GetSurvey($param_arr)
{
    $output = '';
    $dbConn = new clsDBConnSIKP();
    $query = "select * from p_survey_question WHERE p_survey_question_id=" . $param_arr['p_survey_question_id'];
    //echo $query;exit;
    $dbConn->query($query);
    if ($dbConn->next_record()) {
        $data = $dbConn->Record;
        $query2 = "select * from p_survey_question WHERE p_survey_type_id=" . $data["p_survey_type_id"] . " and sequence_no =" . ($data["sequence_no"] + 1);
        $dbConn2 = new clsDBConnSIKP();
        $dbConn2->query($query2);
        if ($dbConn2->next_record()) {
            $data2 = $dbConn2->Record;
            echo '<script language="javascript">';
            echo 'location.href="t_survey_kepuasan_pelanggan_pendaftaran_pertanyaan.php?t_vat_registration_id=' . $data["t_vat_registration_id"] . '&p_survey_question_id=' . $data2["p_survey_question_id"] . '"';
            echo '</script>';
        } else {
            echo '<script language="javascript">';
            echo 'location.href="t_survey_kepuasan_pelanggan_pendaftaran_terima_kasih.php?t_vat_registration_id=' . $data["t_vat_registration_id"] . '&p_survey_question_id=' . $data2["p_survey_question_id"] . '"';
            echo '</script>';
        }
    } else {
        echo '<script language="javascript">';
        echo 'alert("Pertanyaan tidak ditemukan.")';
        echo '</script>';
    }
    $dbConn->close();
    return $output;
}

function t_vat_registrationForm_Button4_OnClick(&$sender)
{
    $t_vat_registrationForm_Button4_OnClick = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $t_vat_registrationForm;
    //Compatibility
    //End t_vat_registrationForm_Button4_OnClick
    //Custom Code @909-2A29BDB7
    // -------------------------
    // Write your own code here.
    $CusId = CCGetFromGet("CURR_DOC_ID", "");
    $dbConn = new clsDBConnSIKP();
    $sql = "select f_gen_npwpd(" . $CusId . ")as npwpd from dual";
    $dbConn->query($sql);
    while ($dbConn->next_record()) {
        $val = $dbConn->f("npwpd");
    }
    $t_vat_registrationForm->npwpd->SetValue($val);
    return;
    // -------------------------
    //End Custom Code
    //Close t_vat_registrationForm_Button4_OnClick @908-D8012444
    return $t_vat_registrationForm_Button4_OnClick;
}

function LOV_Button1_OnClick(&$sender)
{
    $LOV_Button1_OnClick = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $LOV;
    //Compatibility
    //End LOV_Button1_OnClick
    //Custom Code @24-2A29BDB7
    // -------------------------
    // Write your own code here.
    $t_bphtb_registration_id = CCGetFromGet("t_bphtb_registration_id");
    $alasan = $LOV->alasan->GetValue();
    $user = CCGetUserLogin();
    $dbConn = new clsDBConnSIKP();
    if ($t_bphtb_registration_id != "" && $alasan != "" && $user != "") {
        $query = "select f_delete_bphtb from \r\n\t\t\tf_delete_bphtb(" . $t_bphtb_registration_id . ",'" . $alasan . "','" . $user . "')";
        //echo $query;exit;
        $dbConn->query($query);
        $dbConn->next_record();
        $result = $dbConn->f("f_delete_bphtb");
    } else {
        $result = "id bphtb, alasan atau user login tidak boleh kosong";
    }
    echo "<script> \r\n\t\talert('" . $result . "');\r\n\t\twindow.opener.location.reload();\r\n\t\twindow.close();\r\n\t</script>";
    exit;
    // -------------------------
    //End Custom Code
    //Close LOV_Button1_OnClick @16-408DE5C8
    return $LOV_Button1_OnClick;
}

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 LOV_BeforeShow(&$sender)
{
    $LOV_BeforeShow = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $LOV;
    //Compatibility
    //End LOV_BeforeShow
    //Custom Code @8-2A29BDB7
    // -------------------------
    // Write your own code here.
    $i_vat_setllement = CCGetFromGet('i_vat_setllement_id');
    $ubah = CCGetFromGet('ubah');
    $in_flag_numeric = CCGetFromGet('in_flag_numeric');
    $is_desc = CCGetFromGet('is_desc');
    if ($ubah == 'T') {
        $user = CCGetUserLogin();
        $data = array();
        $dbConn = new clsDBConnSIKP();
        $query = "select f_update_increasing_amt({$i_vat_setllement},{$in_flag_numeric},'{$is_desc}','{$user}') as msg";
        $dbConn->query($query);
        while ($dbConn->next_record()) {
            echo "<script> \r\n\t\t\talert('" . $dbConn->f('msg') . "');\r\n\t\t\twindow.close();\r\n\t\t</script>";
            exit;
        }
    }
    // -------------------------
    //End Custom Code
    //Close LOV_BeforeShow @3-91C2A156
    return $LOV_BeforeShow;
}

function deleteAll($t_vat_registration)
{
    $dbConn = new clsDBConnSIKP();
    $sql = "delete from t_license_letter where t_vat_registration_id=" . $t_vat_registration . ";" . "delete from t_vat_reg_employee where t_vat_registration_id=" . $t_vat_registration . ";" . "delete from t_vat_reg_dtl_restaurant where t_vat_registration_id=" . $t_vat_registration . ";" . "delete from t_vat_reg_dtl_entertaintment where t_vat_registration_id=" . $t_vat_registration . ";" . "delete from t_vat_reg_dtl_parking where t_vat_registration_id=" . $t_vat_registration . ";" . "delete from t_vat_reg_dtl_hotel where t_vat_registration_id=" . $t_vat_registration . ";" . "delete from t_vat_registration where t_vat_registration_id=" . $t_vat_registration . ";";
    if ($dbConn->query($sql)) {
    } else {
        //do something here
    }
}

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 GetCetakHTML($param_arr)
{
    $output = '';
    $DBConn = new clsDBConnSIKP();
    $SQL = "select replace(replace(f_monitor_tipro_daftar_v2(1," . $param_arr['nilai'] . "," . $param_arr['p_finance_period_id'] . "," . $param_arr['p_vat_type_id'] . "),'(\"',''),'\")','') from dual";
    //die($SQL);
    $DBConn->query($SQL);
    return create_table_grid($DBConn, "INFORMASI MONITORING", "", $qs, "Y", $arrJml, "2");
}

function GetCetakHTML($param_arr)
{
    $output = '';
    $dbConn = new clsDBConnSIKP();
    $query = "select * from t_payment_receipt where npwd = '" . $param_arr['npwpd'] . "'\r\n\t\tORDER BY payment_date desc limit 1";
    //echo $query;exit;
    $dbConn->query($query);
    if ($dbConn->next_record()) {
        $data = $dbConn->Record;
        $output = '';
        $output .= '<table class="grid-table" cellspacing="0" cellpadding="0" border="0"> 
	                  <tr>
	                    <td class="HeaderLeft"><img border="0" alt="" src="../Styles/sikp/Images/Spacer.gif"></td> 
	                    <td class="th"><strong>INFORMASI PEMBAYARAN</strong></td> 
	                    <td class="HeaderRight"><img border="0" alt="" src="../Styles/sikp/Images/Spacer.gif"></td>
	                  </tr>
	                </table>';
        $output .= '<table class="Record" cellspacing="0" cellpadding="5" style="font-size:15px;padding-left:15px;" border="0">
				<tr> 
					<td colspan="3">Pembayaran Terakhir untuk NPWPD : <b>' . $param_arr['npwpd'] . '</td>
				</tr>
				<tr>
					<td colspan="3">&nbsp;</td>
				</tr>
				<tr>
					<td colspan="3"><u><b>INFO DETAIL : </b></u></td>
				</tr>';
        $output .= '<tr>';
        $output .= '<td width="150"> NPWPD';
        $output .= '</td>';
        $output .= '<td> : ' . $data['npwd'];
        $output .= '</td>';
        $output .= '</tr>';
        $output .= '<tr>';
        $output .= '<td> Periode Pajak';
        $output .= '</td>';
        $output .= '<td> : ' . $data['finance_period_code'];
        $output .= '</td>';
        $output .= '</tr>';
        $output .= '<tr>';
        $output .= '<td> Total Pajak';
        $output .= '</td>';
        $output .= '<td> : Rp. ' . number_format($data['payment_vat_amount'], 2, ',', '.');
        $output .= '</td>';
        $output .= '</tr>';
        $output .= '</table>';
    } else {
        $output = '<table class="Record" cellspacing="0" cellpadding="5" style="font-size:15px;padding-left:15px;" border="0">
		<tr>
			<td colspan="3">NPWPD : <b>' . $param_arr['npwpd'] . '</b> <b style="color:#FF0000;">TIDAK DITEMUKAN</b></td>
		</tr>
		</table>';
    }
    $dbConn->close();
    return $output;
}

function t_ppatForm_Button_Insert_OnClick(&$sender)
{
    $t_ppatForm_Button_Insert_OnClick = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $t_ppatForm;
    //Compatibility
    //End t_ppatForm_Button_Insert_OnClick
    //Custom Code @374-2A29BDB7
    // -------------------------
    // Write your own code here.
    $dbConn = new clsDBConnSIKP();
    $company_brand = $t_ppatForm->company_brand->GetValue();
    $p_rqst_type_id = $t_ppatForm->p_rqst_type_id->GetValue();
    $p_vat_type_dtl_id = $t_ppatForm->p_vat_type_dtl_id->GetValue();
    $brand_address_name = $t_ppatForm->brand_address_name->GetValue();
    $brand_address_no = $t_ppatForm->brand_address_no->GetValue();
    $brand_address_rt = $t_ppatForm->brand_address_rt->GetValue();
    $brand_address_rw = $t_ppatForm->brand_address_rw->GetValue();
    $company_additional_addr = $t_ppatForm->company_additional_addr->GetValue();
    $brand_p_region_id = $t_ppatForm->brand_p_region_id->GetValue();
    $brand_p_region_id_kec = $t_ppatForm->brand_p_region_id_kec->GetValue();
    $brand_p_region_id_kel = $t_ppatForm->brand_p_region_id_kel->GetValue();
    $brand_phone_no = $t_ppatForm->brand_phone_no->GetValue();
    $brand_mobile_no = $t_ppatForm->brand_mobile_no->GetValue();
    $brand_fax_no = $t_ppatForm->brand_fax_no->GetValue();
    $brand_zip_code = $t_ppatForm->brand_zip_code->GetValue();
    $user = $t_ppatForm->created_by->GetValue();
    $sql = "select * from f_insert_vat_reg_npwpd_jabatan(\r\n\t\t\t'{$user}', \r\n\t\t\t'{$company_brand}',\r\n\t\t\t'{$company_additional_addr}',\r\n\t\t\t'{$brand_address_name}',\r\n\t\t\t'{$brand_address_no}',\r\n\t\t\t'{$brand_address_rt}',\r\n\t\t\t'{$brand_address_rw}',\r\n\t\t\t{$brand_p_region_id_kel},\r\n\t\t\t{$brand_p_region_id_kec},\r\n\t\t\t{$brand_p_region_id},\r\n\t\t\t'{$brand_phone_no}',\r\n\t\t\t'{$brand_mobile_no}',\r\n\t\t\t'{$brand_fax_no}',\r\n\t\t\t'{$brand_zip_code}',\r\n\t\t\t{$p_rqst_type_id},\r\n\t\t\t{$p_vat_type_dtl_id}\r\n\t\t\t)";
    //die($sql);
    $dbConn->query($sql);
    $dbConn->next_record();
    $cust_id = $dbConn->f("v_customer_order_id");
    $mess = $dbConn->f("o_result_msg");
    if ($cust_id != 0 && $cust_id != "") {
        echo '<script language="javascript">';
        echo "window.open('../report/cetak_surat_pengukuhan_npwpd_jabatan.php?CURR_DOC_ID={$cust_id}', \r\n\t\t\t\t'pengukuhan', 'height=,width=,left=0,top=0');";
        echo "window.open('../report/cetak_form_pemutakhiran_data_npwpd_jabatan.php?t_customer_order_id={$cust_id}', \r\n\t\t\t\t'pemutakhiran', 'height=,width=,left=0,top=0');";
        echo '</script>';
    } else {
        $mess = str_replace('"', '', $mess);
        echo '<script language="javascript">';
        echo 'alert("' . $mess . '");';
        echo '</script>';
    }
    echo '<script language="javascript">';
    echo "location.href='t_vat_registration_npwpd_jabatan.php';";
    echo '</script>';
    return;
    // -------------------------
    //End Custom Code
    //Close t_ppatForm_Button_Insert_OnClick @24-EE087F7F
    return $t_ppatForm_Button_Insert_OnClick;
}

function create_info_ama()
{
    $DBConn = new clsDBConnSIKP();
    $nilai = CCGetFromGet("nilai", "");
    if (empty($nilai)) {
    } else {
        $SQL = "select replace(replace(f_monitor_tipro_daftar(1," . $nilai . "),'(\"',''),'\")','') from dual";
        //die($SQL);
        $DBConn->query($SQL);
        return create_table_grid($DBConn, "INFORMASI MONITORING", "", $qs, "Y", $arrJml, "2");
    }
}

 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");
 }