本文整理汇总了PHP中clsDBConnSIKP类的典型用法代码示例。如果您正苦于以下问题：PHP clsDBConnSIKP类的具体用法？PHP clsDBConnSIKP怎么用？PHP clsDBConnSIKP使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
在下文中一共展示了clsDBConnSIKP类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: grafik_pembayaran_form_Button2_OnClick
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;
}
开发者ID:rayminami，项目名称:mpd-online，代码行数:29，代码来源:t_send_sms_to_app_user_events.php
示例2: GetSurvey
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;
}
开发者ID:rayminami，项目名称:mpd-online，代码行数:32，代码来源:t_survey_kepuasan_pelanggan_pendaftaran_events.php
示例3: t_vat_reg_dtl_restaurantForm_BeforeSelect
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;
}
开发者ID:rayminami，项目名称:mpd-online，代码行数:26，代码来源:data_potensi_restaurant_edit_events.php
示例4: GetSurvey
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;
}
开发者ID:rayminami，项目名称:mpd-online，代码行数:30，代码来源:t_survey_kepuasan_pelanggan_pendaftaran_terima_kasih_events.php
示例5: t_vat_registrationForm_Button4_OnClick
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;
}
开发者ID:rayminami，项目名称:mpd-online，代码行数:25，代码来源:t_customer_order_ro_kasi_events.php
示例6: LOV_Button1_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;
}
开发者ID:rayminami，项目名称:mpd-online，代码行数:31，代码来源:t_bphtb_delete_events.php
示例7: t_vat_setllementGrid_BeforeShowRow
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;
}
开发者ID:rayminami，项目名称:mpd-online，代码行数:60，代码来源:t_vat_setllement_edit_ro_events.php
示例8: LOV_BeforeShow
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;
}
开发者ID:rayminami，项目名称:mpd-online，代码行数:31，代码来源:t_vat_setllement_ubah_kenaikan_events.php
示例9: deleteAll
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
}
}
开发者ID:rayminami，项目名称:mpd-online，代码行数:9，代码来源:submit_registration.php
示例10: t_vat_setllementGrid_cetak_sptpd_BeforeShow
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;
}
开发者ID:rayminami，项目名称:mpd-online，代码行数:57，代码来源:t_vat_setllement_ro_new_events.php
示例11: GetCetakHTML
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");
}
开发者ID:rayminami，项目名称:mpd-online，代码行数:9，代码来源:t_monitoring_pendaftaran_new_events.php
示例12: GetCetakHTML
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"> </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;
}
开发者ID:rayminami，项目名称:mpd-online，代码行数:56，代码来源:t_pembayaran_terakhir_wp_events.php
示例13: t_ppatForm_Button_Insert_OnClick
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;
}
开发者ID:rayminami，项目名称:mpd-online，代码行数:54，代码来源:t_vat_registration_npwpd_jabatan_events.php
示例14: create_info_ama
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");
}
}
开发者ID:rayminami，项目名称:mpd-online，代码行数:12，代码来源:monitoring_titik_proses_pendaftaran.php
示例15: PageCetak
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");
}
开发者ID:rayminami，项目名称:mpd-online，代码行数:52，代码来源:cetak_duplikat_kwitansi_bphtb.php
示例16: t_vat_setllementForm_Button1_OnClick
function t_vat_setllementForm_Button1_OnClick(&$sender)
{
$t_vat_setllementForm_Button1_OnClick = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_vat_setllementForm;
//Compatibility
//End t_vat_setllementForm_Button1_OnClick
//Custom Code @165-2A29BDB7
// -------------------------
// Write your own code here.
// -------------------------
//End Custom Code
// -------------------------
// Write your own code here.
$dbConn = new clsDBConnSIKP();
$cusAccId = $t_vat_setllementForm->t_cust_account_id->GetValue();
$User = CCGetUserLogin();
$p_account_status_id = $t_vat_setllementForm->p_account_status_id->GetValue();
$reason_status_id = $t_vat_setllementForm->reason_status_id->GetValue();
$reason_description = $t_vat_setllementForm->reason_description->GetValue();
$errorMsg = '';
//new fix
if (!isset($p_vat_type_dtl_cls_id) || $p_vat_type_dtl_cls_id == '') {
$p_vat_type_dtl_cls_id = 'NULL';
}
if (empty($kamar)) {
$kamar = 0;
}
//cek alasan lainnya
if ($reason_status_id == 4 and !isset($reason_description) || $reason_description == '') {
echo "<script> \r\n\t\t\talert('Keterangan harus diisi jika memilih alasan Lainnya');\r\n\t\t</script>";
} else {
$sql = "select * from f_entry_mutasi_status_wp(" . $cusAccId . ",15," . $p_account_status_id . "," . $reason_status_id . ",'" . $reason_description . "','" . $User . "')";
//echo $sql;
//die($sql);
$dbConn->query($sql);
$dbConn->next_record();
$cust_id = $dbConn->f("o_cust_order_id");
$mess = $dbConn->f("o_mess");
//modified by wiliam
echo "<script> \r\n\t\t\talert('" . $mess . "');\r\n\t\t\twindow.opener.location.reload();\r\n\t\t\twindow.close();\r\n\t\t</script>";
exit;
}
// -------------------------
//Close t_vat_setllementForm_Button1_OnClick @164-6DBB2532
//return $t_vat_setllementForm_Button1_OnClick;
}
开发者ID:rayminami，项目名称:mpd-online，代码行数:48，代码来源:t_entry_penutupan_events.php
示例17: Page_BeforeShow
function Page_BeforeShow(&$sender)
{
$Page_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_bphtb_registration_list_update;
//Compatibility
//End Page_BeforeShow
//Custom Code @703-2A29BDB7
// -------------------------
// Write your own code here.
if (CCGetFromGet("submit_bphtb") == 1) {
$dbConn = new clsDBConnSIKP();
$sql = "select count(*) as jml from t_product_order_control where doc_id = " . CCGetFromGet('t_customer_order_id') . "and and p_w_doc_type_id = 505";
$dbConn->query($sql);
$jumlah_data;
if ($dbConn->next_record()) {
$jumlah_data = $dbConn->f('jml');
}
if ($jumlah_data == 0) {
$sql = "select sikp.f_first_submit_engine(505," . CCGetFromGet('t_customer_order_id') . ",'" . CCGetSession('UserLogin') . "')";
$dbConn->query($sql);
} else {
echo "\r\n\t\t\t\t<script>\r\n\t\t\t\t\talert('Data BPHTB Sudah Tersubmit');\r\n\t\t\t\t</script>\r\n\t\t\t";
//exit;
}
$dbConn->close();
header('Location:t_bphtb_registration_list.php');
exit;
}
// -------------------------
//End Custom Code
//Close Page_BeforeShow @1-4BC230CD
return $Page_BeforeShow;
}
开发者ID:rayminami，项目名称:mpd-online，代码行数:35，代码来源:t_bphtb_registration_list_update_events.php
示例18: t_vat_setllementGrid_cetak_sptpd_BeforeShow
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;
}
开发者ID:rayminami，项目名称:mpd-online，代码行数:46，代码来源:t_vat_setllement_ro_events.php
示例19: GetCetakHTML
function GetCetakHTML($param_arr)
{
$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 class="HeaderLeft"><img border="0" alt="" src="../Styles/sikp/Images/Spacer.gif"></td>
<td class="th"><strong>DAFTAR PENDAFTARAN WP</strong></td>
<td class="HeaderRight"><img border="0" alt="" src="../Styles/sikp/Images/Spacer.gif"></td>
</tr>
</table>';
$output .= '<table id="table-piutang-detil" class="Grid" border="1" cellspacing="0" cellpadding="3px" width="100%">
<tr >';
$output .= '<th align="center" >NO</th>';
$output .= '<th align="center" >NPWPD</th>';
$output .= '<th align="center" >NAMA WP</th>';
$output .= '<th align="center" >MERK DAGANG</th>';
$output .= '<th align="center" >ALAMAT MERK DAGANG</th>';
$output .= '<th align="center" >KARTU NPWPD</th>';
$output .= '</tr>';
$dbConn = new clsDBConnSIKP();
$query = "select * from t_cust_account where \r\n\tnpwd ilike '%" . $param_arr['search'] . "%'\r\n\tor wp_name ilike '%" . $param_arr['search'] . "%'\r\n\tor company_brand ilike '%" . $param_arr['search'] . "%'\r\n\tORDER BY wp_name";
//echo $query;exit;
$data = array();
$dbConn->query($query);
while ($dbConn->next_record()) {
$data[] = $dbConn->Record;
}
$dbConn->close();
for ($i = 0; $i < count($data); $i++) {
$output .= '<tr><td align="center" >' . ($i + 1) . '</td>';
$output .= '<td align="left" >' . $data[$i]['npwd'] . '</td>';
$output .= '<td align="left" >' . $data[$i]['wp_name'] . '</td>';
$output .= '<td align="left" >' . $data[$i]['company_brand'] . '</td>';
$output .= '<td align="left" >' . $data[$i]['brand_address_name'] . ' ' . $data[$i]['brand_address_no'] . '</td>';
$output .= '<td align="center" ><input id="cetak_kartu_npwpd_v2" class="btn_tambah" onclick="cetak_kartu_npwpd_v2(' . $data[$i]['t_cust_account_id'] . '); return false;" value="cetak_kartu_npwpd_v2" type="button"></td>';
$output .= '</tr>';
}
$output .= '</table>';
return $output;
}
开发者ID:rayminami，项目名称:mpd-online，代码行数:43，代码来源:t_cetak_kartu_npwpd_dr_t_cust_account_events.php
示例20: t_vat_registrationForm_Button7_OnClick
function t_vat_registrationForm_Button7_OnClick(&$sender)
{
$t_vat_registrationForm_Button7_OnClick = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_vat_registrationForm;
//Compatibility
//End t_vat_registrationForm_Button7_OnClick
$sql = &qu
|
客服电话
APP下载
官方微信
请发表评论