本文整理汇总了PHP中clsDBConnSIKP::query方法的典型用法代码示例。如果您正苦于以下问题:PHP clsDBConnSIKP::query方法的具体用法?PHP clsDBConnSIKP::query怎么用?PHP clsDBConnSIKP::query使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类clsDBConnSIKP
的用法示例。
在下文中一共展示了clsDBConnSIKP::query方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: t_vat_registrationForm_Button1_OnClick
function t_vat_registrationForm_Button1_OnClick(&$sender)
{
$t_vat_registrationForm_Button1_OnClick = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_vat_registrationForm;
//Compatibility
//End t_vat_registrationForm_Button1_OnClick
//Custom Code @862-2A29BDB7
// -------------------------
// Write your own code here.
// -------------------------
//End Custom Code
// -------------------------
// Write your own code here.
$dbConn1 = new clsDBConnSIKP();
$order = $t_vat_registrationForm->order_no->GetValue();
$mobile = $t_vat_registrationForm->mobile_no_owner->GetValue();
$cari = "select t_customer_order_id from t_customer_order where order_no = '" . $order . "'";
$dbConn1->query($cari);
while ($dbConn1->next_record()) {
$kode = $dbConn1->f("t_customer_order_id");
}
$sql_url = "select f_send_sms('" . $mobile . "','Kode Verifikasi Anda : " . $kode . "')from dual";
$dbConn1->query($sql_url);
/*
$sql_url = "select value from p_global_param where code = 'SMSG_URL'";
$dbConn1->query($sql_url);
while($dbConn1->next_record()){
$val = $dbConn1->f("value");
}
$ch = curl_init();
$url = $val."recipient=".$mobile."&messagetype=SMS:TEXT&messagedata=Kode+Verifikasi+Anda:+".$kode."";
curl_setopt($ch, CURLOPT_URL,$url);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query(array('body' => json_encode($postdata))));
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$server_output = curl_exec ($ch);
curl_close ($ch);
*/
$sql = "INSERT INTO verifikasi(id_verifikasi,order_no,code) VALUES " . "(generate_id('sikp','verifikasi','id_verifikasi'),'" . $order . "','" . $kode . "')";
$dbConn1->query($sql);
$dbConn1->close;
$t_vat_registrationForm->pesan->SetValue("Data Telah Terkirim");
return;
// -------------------------
//Close t_vat_registrationForm_Button1_OnClick @851-A9568806
return $t_vat_registrationForm_Button1_OnClick;
}
示例2: t_vat_reg_dtl_parkingForm_BeforeSelect
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;
}
示例3: 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;
}
示例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: 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;
}
示例6: 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;
}
示例7: 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;
}
示例8: 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;
}
示例9: 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;
}
示例10: 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;
}
示例11: print_laporan
function print_laporan($param_arr)
{
include "../include/fpdf17/mc_table.php";
$_BORDER = 0;
$_FONT = 'Times';
$_FONTSIZE = 10;
$pdf = new PDF_MC_Table();
$size = $pdf->_getpagesize('Legal');
$pdf->DefPageSize = $size;
$pdf->CurPageSize = $size;
$pdf->AddPage('Landscape', 'Legal');
$pdf->SetFont('helvetica', '', $_FONTSIZE);
$pdf->SetRightMargin(5);
$pdf->SetLeftMargin(9);
$pdf->SetAutoPageBreak(false, 0);
$pdf->SetFont('helvetica', '', 12);
$pdf->SetWidths(array(200));
$pdf->ln(1);
$pdf->RowMultiBorderWithHeight(array("Laporan pencetakan bulanan penerimaan sptpd"), array('', ''), 6);
//$pdf->ln(8);
$pdf->SetWidths(array(40, 200));
$pdf->ln(4);
$pdf->RowMultiBorderWithHeight(array("DAFTAR SPTPD", ": "), array('', ''), 6);
$pdf->RowMultiBorderWithHeight(array("TAHUN", ": " . $param_arr['year_code']), array('', ''), 6);
$pdf->RowMultiBorderWithHeight(array("TANGGAL", ": " . dateToString($param_arr['date_start']) . " s/d " . dateToString($param_arr['date_end'])), array('', ''), 6);
$dbConn = new clsDBConnSIKP();
$query = "select * from sikp.f_laporan_pencetakan_bulanan(1," . $param_arr['year_code'] . ",'" . $param_arr['date_start'] . "', '" . $param_arr['date_end'] . "')";
//print_r($query);
//exit;
$dbConn->query($query);
$items = array();
$pdf->SetFont('helvetica', '', 9);
$pdf->ln(2);
$pdf->SetWidths(array(10, 24, 20, 15, 40, 18, 22, 25, 20, 61, 61, 27));
$pdf->SetAligns(array('C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C'));
$pdf->SetWidths(array(10, 40, 35, 15, 40, 18, 18, 18, 18, 18, 18, 18, 18, 18, 18, 18, 18));
$pdf->SetFont('arial', '', 7);
$pdf->RowMultiBorderWithHeight(array("NO", "NAMA", "ALAMAT", "NPWPD", "DESEMBER THN SEBELUMNYA", "JANUARI", "FEBRUARI", "MARET", "APRIL", "MEI", "JUNI", "JULI", "AGUSTUS", "SEPTEMBER", "OKTOBER", "NOVEMBER"), array('LTB', 'LTB', 'LBT', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'TLB', 'TLB', 'TLB', 'TLB', 'TLB', 'TLBR'), 9);
$pdf->SetFont('arial', '', 8);
$no = 1;
$pdf->SetAligns(array('C', 'L', 'L', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C'));
$jumlah = 0;
$jumlah = 0;
while ($dbConn->next_record()) {
$items[] = $item = array('nama' => $dbConn->f("nama"), 'alamat' => $dbConn->f("alamat"), 'npwpd' => $dbConn->f("npwpd"), 'last_desember' => $dbConn->f("last_desember"), 'januari' => $dbConn->f("januari"), 'februari' => $dbConn->f("februari"), 'maret' => $dbConn->f("maret"), 'april' => $dbConn->f("april"), 'mei' => $dbConn->f("mei"), 'juni' => $dbConn->f("juni"), 'juli' => $dbConn->f("juli"), 'agustus' => $dbConn->f("agustus"), 'september' => $dbConn->f("september"), 'oktober' => $dbConn->f("oktober"), 'november' => $dbConn->f("november"));
$pdf->RowMultiBorderWithHeight(array($no, $item['nama'], $item['alamat'], $item['npwpd'], $item['last_desember'], $item['januari'], $item['februari'], $item['maret'], $item['april'], $item['mei'], $item['juni'], $item['juli'], $item['agustus'], $item['september'], $item['oktober'], $item['november']), array('LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LBR'), 6);
$jumlah += $dbConn->f("amount");
// $jumlah_wp+=$dbConn->f("jumlah_wp");
$no++;
}
//print_r($items);
//exit;
$pdf->SetWidths(array(250, 70));
$pdf->ln(8);
$pdf->RowMultiBorderWithHeight(array("", "KASIE VOP"), array('', '', '', '', '', '', ''), 6);
$pdf->Output("", "I");
exit;
}
示例12: PageCetak
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++;
}
}
示例13: 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
}
}
示例14: 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;
}
示例15: sendSms
function sendSms()
{
include 'save_excel_2.php';
include '../../gammu/send_sms.php';
$SendSms = new SendSms();
$dbConn = new clsDBConnSIKP();
$query = "SELECT * FROM t_sms_outbox where is_sent = 'N'";
$dbConn->query($query);
$data = array();
while ($dbConn->next_record()) {
$data[] = $item = array('t_sms_outbox_id' => $dbConn->f("t_sms_outbox_id"), 'npwpd' => $dbConn->f("npwpd"), 'mobile_no' => $dbConn->f("mobile_no"), 'message' => $dbConn->f("message"), 'is_sent' => $dbConn->f("is_sent"), 'date_sent' => $dbConn->f("date_sent"), 'date_addded' => $dbConn->f("date_addded"));
$SendSms->send($item["mobile_no"], $item["message"]);
}
for ($counter = 0; $counter < sizeof($data); $counter++) {
$query = " UPDATE t_sms_outbox\r\n\t \t\tSET is_sent='Y',date_sent=sysdate\r\n\t \t\tWHERE t_sms_outbox_id=" . $data[$counter]['t_sms_outbox_id'];
$dbConn->query($query);
}
}