function charges_AfterInsert()
{
//charges_AfterInsert @4-B46BA208
//Custom Code @13-2A29BDB7
if (CCGetSession("RecentItemNum")) {
$ItemNum = CCGetSession("RecentItemNum");
}
startlistingnow($ItemNum, CCGetUserID());
}
function Page_BeforeShow()
{
//Page_BeforeShow @1-66DC429C
//Set Tag @4-E60AFC09
global $Tpl;
$userlog = CCGetSession("RecentUserSign");
$userem = CCGetSession("RecentUserEmail");
$Tpl->SetVar("userlogin", $userlog);
$Tpl->SetVar("useremail", $userem);
CCSetSession("RecentUserSign", "");
CCSetSession("RecentUserEmail", "");
//End Set Tag
}
function buynowPayPal($ItemNum)
{
global $Tpl;
global $EP;
$Tpl->SetBlockVar("Confirm_PayPal", "");
$iteminfo = new clsDBNetConnect();
$query = "Select * from items where ItemNum={$ItemNum}";
$iteminfo->query($query);
$iteminfo->next_record();
$sellerid = $iteminfo->f("user_id");
$sellerinfo = new clsDBNetConnect();
$query = "select first_name, last_name, email, user_login from users where user_id={$sellerid}";
$sellerinfo->query($query);
$sellerinfo->next_record();
$userinfo = new clsDBNetConnect();
$from_user_id = CCGetSession("UserID");
$query = "select first_name, last_name, email, user_login from users where user_id={$from_user_id}";
$userinfo->query($query);
$userinfo->next_record();
$shipoption = 1;
while ($iteminfo->f("ship" . $shipoption) != "") {
if ($shipoption == 1) {
$Tpl->setVar("checked", "checked");
} else {
$Tpl->setVar("checked", "");
}
if ($iteminfo->f("shipfee" . $shipoption) == 0 || $iteminfo->f("shipfee" . $shipoption) == "") {
$price = "0.00";
} else {
$price = $iteminfo->f("shipfee" . $shipoption);
}
$Tpl->setVar("method", $iteminfo->f("ship" . $shipoption));
$Tpl->setVar("option", $shipoption);
$Tpl->setVar("price", "\$" . $price);
$Tpl->Parse("Row", True);
$shipoption++;
}
if (!$iteminfo->f("ship1")) {
$Tpl->setVar("method", "No Shipping Specified");
$Tpl->setVar("option", "999999");
$Tpl->setVar("price", "\$" . "0.00");
$Tpl->setVar("checked", "checked");
$Tpl->Parse("Row", True);
}
$Tpl->setVar("ItemNum", $ItemNum);
$Tpl->setVar("title", $iteminfo->f("title"));
$Tpl->setVar("asking_price", $iteminfo->f("asking_price"));
$Tpl->Parse("Confirm_PayPal", True);
}
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 MasterPage_llMenu_BeforeShow(&$sender)
{
$MasterPage_llMenu_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $llMenu;
//Compatibility
//End MasterPage_llMenu_BeforeShow
//Custom Code @12-2A29BDB7
// -------------------------
// Write your own code here.
$Component->Text = CCGetSession("lmenu");
// -------------------------
//End Custom Code
//Close MasterPage_llMenu_BeforeShow @10-0267086D
return $MasterPage_llMenu_BeforeShow;
}
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();
$User = CCGetUserLogin();
$t_bphtb_registration_id = $t_vat_setllementForm->t_bphtb_registration_id->GetValue();
$alasan = $t_vat_setllementForm->alasan->GetValue();
$njop_pbb = $t_vat_setllementForm->njop_pbb->GetValue();
$bphtb_amt_final = $t_vat_setllementForm->bphtb_amt_final->GetValue();
$bphtb_amt_final_keberatan = $t_vat_setllementForm->bphtb_amt_final_keberatan->GetValue();
$errorMsg = '';
$sql = "select * from f_insert_bphtb_keberatan(" . $t_bphtb_registration_id . ",19," . $bphtb_amt_final_keberatan . "," . $bphtb_amt_final . ",'" . $alasan . "','" . $User . "')";
//echo $sql;
//die($sql);
$dbConn->query($sql);
$dbConn->next_record();
$t_bphtb_keberatan_id = $dbConn->f("o_t_bphtb_keberatan_id");
$t_customer_order_id = $dbConn->f("o_t_customer_order_id");
$mess = $dbConn->f("o_mess");
$sql = "select sikp.f_first_submit_engine(511," . $t_customer_order_id . ",'" . CCGetSession('UserLogin') . "')";
$dbConn->query($sql);
//modified by wiliam
echo "<script> \r\n\t\talert('" . $mess . "');\r\n\t\twindow.opener.location.reload();\r\n\t\twindow.close();\r\n\t</script>";
// -------------------------
//Close t_vat_setllementForm_Button1_OnClick @164-6DBB2532
//return $t_vat_setllementForm_Button1_OnClick;
}
function roleForm_Button_Insert_OnClick(&$sender)
{
$roleForm_Button_Insert_OnClick = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $roleForm;
//Compatibility
//End roleForm_Button_Insert_OnClick
//Custom Code @73-2A29BDB7
// -------------------------
global $CCSLocales;
global $Redirect;
//CCLogoutUser();
$db = new clsDBhrcon();
$SQL = "select * from f_changeuserpwd(" . $db->ToSQL($Container->user_name->Value, ccsText) . "," . $db->ToSQL(CCGetSession("is_new_user"), ccsText) . "," . $db->ToSQL($Container->old_password->Value, ccsText) . "," . $db->ToSQL($Container->new_password->Value, ccsText) . "," . $db->ToSQL($Container->new_password2->Value, ccsText) . ")";
$db->query($SQL);
$Result = $db->next_record();
if (!$Result) {
return;
}
//
if ($db->f('o_result_int') != 1) {
//print_r("test");exit;
$Container->Errors->addError($db->f('o_result_msg'));
$db->close();
} else {
CCLogoutUser();
$db->close();
print_r("<script language='JavaScript'>alert('Sukses');top.location.href='../';</script>");
}
//header('location:'.ServerURL . "main/login.php");
//exit;
// -------------------------
//End Custom Code
//Close roleForm_Button_Insert_OnClick @5-CEA01FFE
return;
//$roleForm_Button_Insert_OnClick;
}
function t_executive_summary_form_AfterInsert(&$sender)
{
$t_executive_summary_form_AfterInsert = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_executive_summary_form;
//Compatibility
//End t_executive_summary_form_AfterInsert
//Custom Code @132-2A29BDB7
// -------------------------
// Write your own code here.
$t_executive_summary_form->DataSource->next_record();
$records = $t_executive_summary_form->DataSource->Record;
if ($t_executive_summary_form->DataSource->Errors->ErrorsCount == 0) {
$dbConn = new clsDBConnSIKP();
$sql = "select sikp.f_first_submit_engine(508," . $records['o_t_customer_order_id'] . ",'" . CCGetSession('UserLogin') . "')";
$dbConn->query($sql);
}
// -------------------------
//End Custom Code
//Close t_executive_summary_form_AfterInsert @25-96DE34DB
return $t_executive_summary_form_AfterInsert;
}
function Show()
{
global $Tpl;
if (!$this->Visible) {
return;
}
$ShownRecords = 0;
$this->ds->Parameters["sesUserID"] = CCGetSession("UserID");
$this->ds->Prepare();
$this->ds->Open();
$GridBlock = "Grid " . $this->ComponentName;
$Tpl->block_path = $GridBlock;
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeShow");
$is_next_record = $this->ds->next_record();
if ($is_next_record && $ShownRecords < $this->PageSize) {
do {
$this->ds->SetValues();
$Tpl->block_path = $GridBlock . "/Row";
$this->ItemNum->SetValue($this->ds->ItemNum->GetValue());
$this->title->SetValue($this->ds->title->GetValue());
$twodays = $this->ds->started->GetValue();
$theday = getdate($twodays);
$lastofyear = substr($theday["year"], -2);
$enddate = $theday["mon"] . "/" . $theday["mday"] . "/" . $lastofyear;
$this->started->SetValue($enddate);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeShowRow");
$this->ItemNum->Show();
$this->title->Show();
$this->started->Show();
$Tpl->block_path = $GridBlock;
$Tpl->parse("Row", true);
$ShownRecords++;
$is_next_record = $this->ds->next_record();
} while ($is_next_record && $ShownRecords < $this->PageSize);
} else {
$Tpl->parse("NoRecords", false);
}
$this->Navigator->TotalPages = $this->ds->PageCount();
$this->Sorter_ItemNum->Show();
$this->Sorter_title->Show();
$this->Sorter_started->Show();
$this->Navigator->Show();
$Tpl->parse("", false);
$Tpl->block_path = "";
}
function users_reassignuser_content_BeforeShow(&$sender)
{
$users_reassignuser_content_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $users_reassignuser_content;
//Compatibility
//End users_reassignuser_content_BeforeShow
//Custom Code @53-2A29BDB7
// -------------------------
// Write your own code here.
//Settingup saved message popup
$sourceuser = (int) CCGetFromPost("lbsourceuser", 0);
$targetuser = (int) CCGetFromPost("lbtargetuser", 0);
$companies = CCGetFromPost("companies", array());
$o = trim(CCGetFromPost("o", ""));
if ($o == "reassignuser") {
if ($sourceuser != $targetuser) {
if (count($companies) > 0) {
global $FileName;
$params = array();
$params["sourceuser"] = $sourceuser;
$params["targetuser"] = $targetuser;
$params["companies"] = $companies;
$customers = new Customers();
$reassigned = $customers->reassignUser($params);
$total_updated = $reassigned["result"]["total_updated"];
if ($total_updated > 0) {
CCSetSession("showalert", "show");
//$users_reassignuser_content->lbsourceuser->setvalue($targetuser);
}
}
}
} else {
//Default param value
$sourceuserid = (int) CCGetFromGet("sourceuserid", "0");
if ($sourceuserid <= 0) {
$users_reassignuser_content->lbsourceuser->setvalue("1");
} else {
$users_reassignuser_content->lbsourceuser->setvalue($sourceuserid);
}
}
global $MainPage;
$showalert = CCGetSession("showalert", "hide");
$MainPage->Attributes->SetValue("showalert", $showalert);
if ($showalert == "show") {
CCSetSession("showalert", "hide");
}
// -------------------------
//End Custom Code
//Close users_reassignuser_content_BeforeShow @1-90D76575
return $users_reassignuser_content_BeforeShow;
}
function Show()
{
global $Tpl;
if (!$this->Visible) {
return;
}
$ShownRecords = 0;
$this->ds->Parameters["sesUserID"] = CCGetSession("UserID");
$this->ds->Prepare();
$this->ds->Open();
$GridBlock = "Grid " . $this->ComponentName;
$Tpl->block_path = $GridBlock;
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeShow");
$is_next_record = $this->ds->next_record();
if ($is_next_record && $ShownRecords < $this->PageSize) {
do {
$this->ds->SetValues();
$Tpl->block_path = $GridBlock . "/Row";
$this->value->SetValue($this->ds->value->GetValue());
$this->results->SetValue($this->ds->results->GetValue());
$this->id->SetValue($this->ds->id->GetValue());
$this->date->SetValue(date("F j, Y, g:i a", $this->ds->date->GetValue()));
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeShowRow");
$this->value->Show();
$this->results->Show();
$this->id->Show();
$this->date->Show();
$array = explode(" :!:!:: ", $this->ds->value->GetValue());
$i = 0;
$output = "";
while ($array[$i]) {
$temp = explode(" ::!:!: ", $array[$i]);
if ($temp[1] != "") {
$output .= "<b>" . $temp[0] . "</b> = <i>\"" . $temp[1] . "\"</i><hr width=\"25\" align=\"left\">";
}
$i++;
}
$Tpl->SetVar("summery", $output);
$array = explode(" :!:!:: ", $this->ds->results->GetValue());
$i = 0;
$output = "";
while ($array[$i]) {
$temp = explode(" ::!:!: ", $array[$i]);
if ($temp[1] != "") {
$output .= "<a href=\"ViewItem.php?ItemNum=" . $temp[0] . "\"><b>" . $temp[1] . "</b>: <i>ItemNumber-" . $temp[0] . "</i><hr width=\"25\" align=\"left\">";
}
$i++;
}
$Tpl->SetVar("results", $output);
$Tpl->SetVar("count", $i);
$Tpl->block_path = $GridBlock;
$Tpl->parse("Row", true);
$ShownRecords++;
$is_next_record = $this->ds->next_record();
} while ($is_next_record && $ShownRecords < $this->PageSize);
}
$this->Navigator->TotalPages = $this->ds->PageCount();
$this->Sorter_value->Show();
$this->Sorter_results->Show();
$this->Sorter_date->Show();
$this->Navigator->Show();
$Tpl->parse("", false);
$Tpl->block_path = "";
}
function customers_assessment_maintcontent_BeforeShow(&$sender)
{
$customers_assessment_maintcontent_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $customers_assessment_maintcontent;
//Compatibility
//End customers_assessment_maintcontent_BeforeShow
//Custom Code @9-2A29BDB7
// -------------------------
// Write your own code here.
global $MainPage;
$params = array();
$customers = new Customers();
$tab = CCGetFromGet("tab", "tab_9");
$guid = CCGetFromGet("guid", "");
$o_post = CCGetFromPost("o", "");
switch ($o_post) {
case "insert":
$typeid_post = (int) CCGetFromPost("hidtype_id", "0");
$option_title = trim(CCGetFromPost("title", ""));
$tab = trim(CCGetFromPost("hidtab", ""));
$params["type_id"] = $typeid_post;
$params["title"] = $option_title;
$newOption = $customers->addAssessmentType($params);
$newOption = $newOption["options"];
$guid = $newOption["guid"];
//Will show saved pop and disable button
CCSetSession("showalert", "show");
//Redirect after submit
header("Location: customers_assessment.php?tab={$tab}");
break;
case "update":
$typeid_post = (int) CCGetFromPost("hidtype_id", "0");
$option_title = trim(CCGetFromPost("title", ""));
$tab = trim(CCGetFromPost("hidtab", ""));
$guid = trim(CCGetFromPost("hidguid", ""));
$params["type_id"] = $typeid_post;
$params["title"] = $option_title;
$params["guid"] = $guid;
$customers->editAssessmentType($params);
//Will show saved pop and disable button
CCSetSession("showalert", "show");
//Redirect after submit
header("Location: customers_assessment.php?tab={$tab}");
break;
}
$guid = trim($guid, "guid=");
$type_id = trim($tab, "tab_");
if (strlen($guid) > 0) {
$params["guid"] = $guid;
$option = $customers->getAssessmentOptionsByGuid($params);
$option = $option["options"][0];
$customers_assessment_maintcontent->hidguid->SetValue($option["guid"]);
$customers_assessment_maintcontent->title->SetValue($option["title"]);
$customers_assessment_maintcontent->o->SetValue("update");
}
$customers_assessment_maintcontent->hidtype_id->SetValue($type_id);
$customers_assessment_maintcontent->hidtab->SetValue($tab);
$params["type_id"] = $type_id;
$type_detail = $customers->getAssessmentTypeByID($params);
$type_detail = $type_detail["types"][0];
$typeid_title = $type_detail["type"];
$customers_assessment_maintcontent->lbtype->setvalue($typeid_title);
//Settingup saved message popup
$showalert = CCGetSession("showalert", "hide");
$MainPage->Attributes->SetValue("showalert", $showalert);
if ($showalert == "show") {
CCSetSession("showalert", "hide");
}
// -------------------------
//End Custom Code
//Close customers_assessment_maintcontent_BeforeShow @1-BC8E08EE
return $customers_assessment_maintcontent_BeforeShow;
}
function Update()
{
global $CCSLocales;
global $DefaultDateFormat;
$this->CmdExecution = true;
$this->cp["updated_by"] = new clsSQLParameter("sesUserLogin", ccsText, "", "", CCGetSession("UserLogin", NULL), NULL, false, $this->ErrorBlock);
$this->cp["updated_date"] = new clsSQLParameter("expr739", ccsText, "", "", date("Y-m-d H:i:s"), NULL, false, $this->ErrorBlock);
$this->cp["wp_p_region_id"] = new clsSQLParameter("ctrlwp_p_region_id", ccsFloat, "", "", $this->wp_p_region_id->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["wp_p_region_id_kel"] = new clsSQLParameter("ctrlwp_p_region_id_kel", ccsFloat, "", "", $this->wp_p_region_id_kel->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["wp_name"] = new clsSQLParameter("ctrlwp_name", ccsText, "", "", $this->wp_name->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["wp_address_name"] = new clsSQLParameter("ctrlwp_address_name", ccsText, "", "", $this->wp_address_name->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["npwp"] = new clsSQLParameter("ctrlnpwp", ccsText, "", "", $this->npwp->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["object_p_region_id_kec"] = new clsSQLParameter("ctrlobject_p_region_id_kec", ccsText, "", "", $this->object_p_region_id_kec->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["object_p_region_id"] = new clsSQLParameter("ctrlobject_p_region_id", ccsText, "", "", $this->object_p_region_id->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["land_area"] = new clsSQLParameter("ctrlland_area", ccsFloat, "", "", $this->land_area->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["land_price_per_m"] = new clsSQLParameter("ctrlland_price_per_m", ccsFloat, "", "", $this->land_price_per_m->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["land_total_price"] = new clsSQLParameter("ctrlland_total_price", ccsFloat, "", "", $this->land_total_price->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["building_area"] = new clsSQLParameter("ctrlbuilding_area", ccsFloat, "", "", $this->building_area->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["building_price_per_m"] = new clsSQLParameter("ctrlbuilding_price_per_m", ccsFloat, "", "", $this->building_price_per_m->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["building_total_price"] = new clsSQLParameter("ctrlbuilding_total_price", ccsFloat, "", "", $this->building_total_price->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["wp_rt"] = new clsSQLParameter("ctrlwp_rt", ccsText, "", "", $this->wp_rt->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["wp_rw"] = new clsSQLParameter("ctrlwp_rw", ccsText, "", "", $this->wp_rw->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["object_rt"] = new clsSQLParameter("ctrlobject_rt", ccsText, "", "", $this->object_rt->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["object_rw"] = new clsSQLParameter("ctrlobject_rw", ccsText, "", "", $this->object_rw->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["njop_pbb"] = new clsSQLParameter("ctrlnjop_pbb", ccsText, "", "", $this->njop_pbb->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["object_address_name"] = new clsSQLParameter("ctrlobject_address_name", ccsText, "", "", $this->object_address_name->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["p_bphtb_legal_doc_type_id"] = new clsSQLParameter("ctrlp_bphtb_legal_doc_type_id", ccsText, "", "", $this->p_bphtb_legal_doc_type_id->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["npop"] = new clsSQLParameter("ctrlnpop", ccsFloat, "", "", $this->npop->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["npop_tkp"] = new clsSQLParameter("ctrlnpop_tkp", ccsFloat, "", "", $this->npop_tkp->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["npop_kp"] = new clsSQLParameter("ctrlnpop_kp", ccsFloat, "", "", $this->npop_kp->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["bphtb_amt"] = new clsSQLParameter("ctrlbphtb_amt", ccsFloat, "", "", $this->bphtb_amt->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["bphtb_amt_final"] = new clsSQLParameter("ctrlbphtb_amt_final", ccsFloat, "", "", $this->bphtb_amt_final->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["bphtb_discount"] = new clsSQLParameter("ctrlbphtb_discount", ccsFloat, "", "", $this->bphtb_discount->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["description"] = new clsSQLParameter("ctrldescription", ccsText, "", "", $this->description->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["market_price"] = new clsSQLParameter("ctrlmarket_price", ccsFloat, "", "", $this->market_price->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["mobile_phone_no"] = new clsSQLParameter("ctrlmobile_phone_no", ccsText, "", "", $this->mobile_phone_no->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["wp_p_region_id_kec"] = new clsSQLParameter("ctrlwp_p_region_id_kec", ccsFloat, "", "", $this->wp_p_region_id_kec->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["object_p_region_id_kel"] = new clsSQLParameter("ctrlobject_p_region_id_kel", ccsFloat, "", "", $this->object_p_region_id_kel->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["jenis_harga_bphtb"] = new clsSQLParameter("ctrljenis_harga_bphtb", ccsText, "", "", $this->jenis_harga_bphtb->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["jenis_harga_bphtb"] = new clsSQLParameter("ctrljenis_harga_bphtb", ccsText, "", "", $this->jenis_harga_bphtb->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["bphtb_legal_doc_description"] = new clsSQLParameter("ctrlbphtb_legal_doc_description", ccsText, "", "", $this->bphtb_legal_doc_description->GetValue(true), NULL, false, $this->ErrorBlock);
$this->cp["add_disc_percent"] = new clsSQLParameter("ctrladd_disc_percent", ccsSingle, "", "", $this->add_disc_percent->GetValue(true), NULL, false, $this->ErrorBlock);
$wp = new clsSQLParameters($this->ErrorBlock);
$wp->AddParameter("1", "ctrlt_bphtb_registration_id", ccsFloat, "", "", $this->t_bphtb_registration_id->GetValue(true), "", false);
if (!$wp->AllParamsSet()) {
$this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
}
$wp->AddParameter("2", "urlt_bphtb_registration_id", ccsFloat, "", "", CCGetFromGet("t_bphtb_registration_id", NULL), "", false);
if (!$wp->AllParamsSet()) {
$this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
}
$wp->AddParameter("3", "urlt_bphtb_registration_id", ccsFloat, "", "", CCGetFromGet("t_bphtb_registration_id", NULL), "", false);
if (!$wp->AllParamsSet()) {
$this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
}
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
if (!is_null($this->cp["updated_by"]->GetValue()) and !strlen($this->cp["updated_by"]->GetText()) and !is_bool($this->cp["updated_by"]->GetValue())) {
$this->cp["updated_by"]->SetValue(CCGetSession("UserLogin", NULL));
}
if (!is_null($this->cp["updated_date"]->GetValue()) and !strlen($this->cp["updated_date"]->GetText()) and !is_bool($this->cp["updated_date"]->GetValue())) {
$this->cp["updated_date"]->SetValue(date("Y-m-d H:i:s"));
}
if (!is_null($this->cp["wp_p_region_id"]->GetValue()) and !strlen($this->cp["wp_p_region_id"]->GetText()) and !is_bool($this->cp["wp_p_region_id"]->GetValue())) {
$this->cp["wp_p_region_id"]->SetValue($this->wp_p_region_id->GetValue(true));
}
if (!is_null($this->cp["wp_p_region_id_kel"]->GetValue()) and !strlen($this->cp["wp_p_region_id_kel"]->GetText()) and !is_bool($this->cp["wp_p_region_id_kel"]->GetValue())) {
$this->cp["wp_p_region_id_kel"]->SetValue($this->wp_p_region_id_kel->GetValue(true));
}
if (!is_null($this->cp["wp_name"]->GetValue()) and !strlen($this->cp["wp_name"]->GetText()) and !is_bool($this->cp["wp_name"]->GetValue())) {
$this->cp["wp_name"]->SetValue($this->wp_name->GetValue(true));
}
if (!is_null($this->cp["wp_address_name"]->GetValue()) and !strlen($this->cp["wp_address_name"]->GetText()) and !is_bool($this->cp["wp_address_name"]->GetValue())) {
$this->cp["wp_address_name"]->SetValue($this->wp_address_name->GetValue(true));
}
if (!is_null($this->cp["npwp"]->GetValue()) and !strlen($this->cp["npwp"]->GetText()) and !is_bool($this->cp["npwp"]->GetValue())) {
$this->cp["npwp"]->SetValue($this->npwp->GetValue(true));
}
if (!is_null($this->cp["object_p_region_id_kec"]->GetValue()) and !strlen($this->cp["object_p_region_id_kec"]->GetText()) and !is_bool($this->cp["object_p_region_id_kec"]->GetValue())) {
$this->cp["object_p_region_id_kec"]->SetValue($this->object_p_region_id_kec->GetValue(true));
}
if (!is_null($this->cp["object_p_region_id"]->GetValue()) and !strlen($this->cp["object_p_region_id"]->GetText()) and !is_bool($this->cp["object_p_region_id"]->GetValue())) {
$this->cp["object_p_region_id"]->SetValue($this->object_p_region_id->GetValue(true));
}
if (!is_null($this->cp["land_area"]->GetValue()) and !strlen($this->cp["land_area"]->GetText()) and !is_bool($this->cp["land_area"]->GetValue())) {
$this->cp["land_area"]->SetValue($this->land_area->GetValue(true));
}
if (!is_null($this->cp["land_price_per_m"]->GetValue()) and !strlen($this->cp["land_price_per_m"]->GetText()) and !is_bool($this->cp["land_price_per_m"]->GetValue())) {
$this->cp["land_price_per_m"]->SetValue($this->land_price_per_m->GetValue(true));
}
if (!is_null($this->cp["land_total_price"]->GetValue()) and !strlen($this->cp["land_total_price"]->GetText()) and !is_bool($this->cp["land_total_price"]->GetValue())) {
$this->cp["land_total_price"]->SetValue($this->land_total_price->GetValue(true));
}
if (!is_null($this->cp["building_area"]->GetValue()) and !strlen($this->cp["building_area"]->GetText()) and !is_bool($this->cp["building_area"]->GetValue())) {
$this->cp["building_area"]->SetValue($this->building_area->GetValue(true));
}
if (!is_null($this->cp["building_price_per_m"]->GetValue()) and !strlen($this->cp["building_price_per_m"]->GetText()) and !is_bool($this->cp["building_price_per_m"]->GetValue())) {
$this->cp["building_price_per_m"]->SetValue($this->building_price_per_m->GetValue(true));
}
if (!is_null($this->cp["building_total_price"]->GetValue()) and !strlen($this->cp["building_total_price"]->GetText()) and !is_bool($this->cp["building_total_price"]->GetValue())) {
$this->cp["building_total_price"]->SetValue($this->building_total_price->GetValue(true));
}
if (!is_null($this->cp["wp_rt"]->GetValue()) and !strlen($this->cp["wp_rt"]->GetText()) and !is_bool($this->cp["wp_rt"]->GetValue())) {
$this->cp["wp_rt"]->SetValue($this->wp_rt->GetValue(true));
}
if (!is_null($this->cp["wp_rw"]->GetValue()) and !strlen($this->cp["wp_rw"]->GetText()) and !is_bool($this->cp["wp_rw"]->GetValue())) {
$this->cp["wp_rw"]->SetValue($this->wp_rw->GetValue(true));
}
if (!is_null($this->cp["object_rt"]->GetValue()) and !strlen($this->cp["object_rt"]->GetText()) and !is_bool($this->cp["object_rt"]->GetValue())) {
$this->cp["object_rt"]->SetValue($this->object_rt->GetValue(true));
}
if (!is_null($this->cp["object_rw"]->GetValue()) and !strlen($this->cp["object_rw"]->GetText()) and !is_bool($this->cp["object_rw"]->GetValue())) {
$this->cp["object_rw"]->SetValue($this->object_rw->GetValue(true));
}
if (!is_null($this->cp["njop_pbb"]->GetValue()) and !strlen($this->cp["njop_pbb"]->GetText()) and !is_bool($this->cp["njop_pbb"]->GetValue())) {
$this->cp["njop_pbb"]->SetValue($this->njop_pbb->GetValue(true));
}
if (!is_null($this->cp["object_address_name"]->GetValue()) and !strlen($this->cp["object_address_name"]->GetText()) and !is_bool($this->cp["object_address_name"]->GetValue())) {
$this->cp["object_address_name"]->SetValue($this->object_address_name->GetValue(true));
}
if (!is_null($this->cp["p_bphtb_legal_doc_type_id"]->GetValue()) and !strlen($this->cp["p_bphtb_legal_doc_type_id"]->GetText()) and !is_bool($this->cp["p_bphtb_legal_doc_type_id"]->GetValue())) {
$this->cp["p_bphtb_legal_doc_type_id"]->SetValue($this->p_bphtb_legal_doc_type_id->GetValue(true));
}
if (!is_null($this->cp["npop"]->GetValue()) and !strlen($this->cp["npop"]->GetText()) and !is_bool($this->cp["npop"]->GetValue())) {
$this->cp["npop"]->SetValue($this->npop->GetValue(true));
}
if (!is_null($this->cp["npop_tkp"]->GetValue()) and !strlen($this->cp["npop_tkp"]->GetText()) and !is_bool($this->cp["npop_tkp"]->GetValue())) {
$this->cp["npop_tkp"]->SetValue($this->npop_tkp->GetValue(true));
}
if (!is_null($this->cp["npop_kp"]->GetValue()) and !strlen($this->cp["npop_kp"]->GetText()) and !is_bool($this->cp["npop_kp"]->GetValue())) {
$this->cp["npop_kp"]->SetValue($this->npop_kp->GetValue(true));
}
if (!is_null($this->cp["bphtb_amt"]->GetValue()) and !strlen($this->cp["bphtb_amt"]->GetText()) and !is_bool($this->cp["bphtb_amt"]->GetValue())) {
$this->cp["bphtb_amt"]->SetValue($this->bphtb_amt->GetValue(true));
}
if (!is_null($this->cp["bphtb_amt_final"]->GetValue()) and !strlen($this->cp["bphtb_amt_final"]->GetText()) and !is_bool($this->cp["bphtb_amt_final"]->GetValue())) {
$this->cp["bphtb_amt_final"]->SetValue($this->bphtb_amt_final->GetValue(true));
}
if (!is_null($this->cp["bphtb_discount"]->GetValue()) and !strlen($this->cp["bphtb_discount"]->GetText()) and !is_bool($this->cp["bphtb_discount"]->GetValue())) {
$this->cp["bphtb_discount"]->SetValue($this->bphtb_discount->GetValue(true));
}
if (!is_null($this->cp["description"]->GetValue()) and !strlen($this->cp["description"]->GetText()) and !is_bool($this->cp["description"]->GetValue())) {
$this->cp["description"]->SetValue($this->description->GetValue(true));
}
if (!is_null($this->cp["market_price"]->GetValue()) and !strlen($this->cp["market_price"]->GetText()) and !is_bool($this->cp["market_price"]->GetValue())) {
$this->cp["market_price"]->SetValue($this->market_price->GetValue(true));
}
if (!is_null($this->cp["mobile_phone_no"]->GetValue()) and !strlen($this->cp["mobile_phone_no"]->GetText()) and !is_bool($this->cp["mobile_phone_no"]->GetValue())) {
$this->cp["mobile_phone_no"]->SetValue($this->mobile_phone_no->GetValue(true));
}
if (!is_null($this->cp["wp_p_region_id_kec"]->GetValue()) and !strlen($this->cp["wp_p_region_id_kec"]->GetText()) and !is_bool($this->cp["wp_p_region_id_kec"]->GetValue())) {
$this->cp["wp_p_region_id_kec"]->SetValue($this->wp_p_region_id_kec->GetValue(true));
}
if (!is_null($this->cp["object_p_region_id_kel"]->GetValue()) and !strlen($this->cp["object_p_region_id_kel"]->GetText()) and !is_bool($this->cp["object_p_region_id_kel"]->GetValue())) {
$this->cp["object_p_region_id_kel"]->SetValue($this->object_p_region_id_kel->GetValue(true));
}
if (!is_null($this->cp["jenis_harga_bphtb"]->GetValue()) and !strlen($this->cp["jenis_harga_bphtb"]->GetText()) and !is_bool($this->cp["jenis_harga_bphtb"]->GetValue())) {
$this->cp["jenis_harga_bphtb"]->SetValue($this->jenis_harga_bphtb->GetValue(true));
}
if (!is_null($this->cp["jenis_harga_bphtb"]->GetValue()) and !strlen($this->cp["jenis_harga_bphtb"]->GetText()) and !is_bool($this->cp["jenis_harga_bphtb"]->GetValue())) {
$this->cp["jenis_harga_bphtb"]->SetValue($this->jenis_harga_bphtb->GetValue(true));
}
if (!is_null($this->cp["bphtb_legal_doc_description"]->GetValue()) and !strlen($this->cp["bphtb_legal_doc_description"]->GetText()) and !is_bool($this->cp["bphtb_legal_doc_description"]->GetValue())) {
$this->cp["bphtb_legal_doc_description"]->SetValue($this->bphtb_legal_doc_description->GetValue(true));
}
if (!is_null($this->cp["add_disc_percent"]->GetValue()) and !strlen($this->cp["add_disc_percent"]->GetText()) and !is_bool($this->cp["add_disc_percent"]->GetValue())) {
$this->cp["add_disc_percent"]->SetValue($this->add_disc_percent->GetValue(true));
}
$wp->Criterion[1] = $wp->Operation(opEqual, "t_bphtb_registration_id", $wp->GetDBValue("1"), $this->ToSQL($wp->GetDBValue("1"), ccsFloat), false);
$wp->Criterion[2] = $wp->Operation(opEqual, "t_bphtb_registration_id", $wp->GetDBValue("2"), $this->ToSQL($wp->GetDBValue("2"), ccsFloat), false);
$wp->Criterion[3] = $wp->Operation(opEqual, "t_bphtb_registration_id", $wp->GetDBValue("3"), $this->ToSQL($wp->GetDBValue("3"), ccsFloat), false);
$Where = $wp->opAND(false, $wp->opAND(false, $wp->Criterion[1], $wp->Criterion[2]), $wp->Criterion[3]);
$this->UpdateFields["updated_by"]["Value"] = $this->cp["updated_by"]->GetDBValue(true);
$this->UpdateFields["updated_date"]["Value"] = $this->cp["updated_date"]->GetDBValue(true);
$this->UpdateFields["wp_p_region_id"]["Value"] = $this->cp["wp_p_region_id"]->GetDBValue(true);
$this->UpdateFields["wp_p_region_id_kel"]["Value"] = $this->cp["wp_p_region_id_kel"]->GetDBValue(true);
$this->UpdateFields["wp_name"]["Value"] = $this->cp["wp_name"]->GetDBValue(true);
$this->UpdateFields["wp_address_name"]["Value"] = $this->cp["wp_address_name"]->GetDBValue(true);
$this->UpdateFields["npwp"]["Value"] = $this->cp["npwp"]->GetDBValue(true);
$this->UpdateFields["object_p_region_id_kec"]["Value"] = $this->cp["object_p_region_id_kec"]->GetDBValue(true);
$this->UpdateFields["object_p_region_id"]["Value"] = $this->cp["object_p_region_id"]->GetDBValue(true);
$this->UpdateFields["land_area"]["Value"] = $this->cp["land_area"]->GetDBValue(true);
$this->UpdateFields["land_price_per_m"]["Value"] = $this->cp["land_price_per_m"]->GetDBValue(true);
$this->UpdateFields["land_total_price"]["Value"] = $this->cp["land_total_price"]->GetDBValue(true);
$this->UpdateFields["building_area"]["Value"] = $this->cp["building_area"]->GetDBValue(true);
$this->UpdateFields["building_price_per_m"]["Value"] = $this->cp["building_price_per_m"]->GetDBValue(true);
$this->UpdateFields["building_total_price"]["Value"] = $this->cp["building_total_price"]->GetDBValue(true);
$this->UpdateFields["wp_rt"]["Value"] = $this->cp["wp_rt"]->GetDBValue(true);
$this->UpdateFields["wp_rw"]["Value"] = $this->cp["wp_rw"]->GetDBValue(true);
$this->UpdateFields["object_rt"]["Value"] = $this->cp["object_rt"]->GetDBValue(true);
$this->UpdateFields["object_rw"]["Value"] = $this->cp["object_rw"]->GetDBValue(true);
$this->UpdateFields["njop_pbb"]["Value"] = $this->cp["njop_pbb"]->GetDBValue(true);
$this->UpdateFields["object_address_name"]["Value"] = $this->cp["object_address_name"]->GetDBValue(true);
$this->UpdateFields["p_bphtb_legal_doc_type_id"]["Value"] = $this->cp["p_bphtb_legal_doc_type_id"]->GetDBValue(true);
$this->UpdateFields["npop"]["Value"] = $this->cp["npop"]->GetDBValue(true);
$this->UpdateFields["npop_tkp"]["Value"] = $this->cp["npop_tkp"]->GetDBValue(true);
$this->UpdateFields["npop_kp"]["Value"] = $this->cp["npop_kp"]->GetDBValue(true);
$this->UpdateFields["bphtb_amt"]["Value"] = $this->cp["bphtb_amt"]->GetDBValue(true);
$this->UpdateFields["bphtb_amt_final"]["Value"] = $this->cp["bphtb_amt_final"]->GetDBValue(true);
$this->UpdateFields["bphtb_discount"]["Value"] = $this->cp["bphtb_discount"]->GetDBValue(true);
$this->UpdateFields["description"]["Value"] = $this->cp["description"]->GetDBValue(true);
$this->UpdateFields["market_price"]["Value"] = $this->cp["market_price"]->GetDBValue(true);
$this->UpdateFields["mobile_phone_no"]["Value"] = $this->cp["mobile_phone_no"]->GetDBValue(true);
$this->UpdateFields["wp_p_region_id_kec"]["Value"] = $this->cp["wp_p_region_id_kec"]->GetDBValue(true);
$this->UpdateFields["object_p_region_id_kel"]["Value"] = $this->cp["object_p_region_id_kel"]->GetDBValue(true);
$this->UpdateFields["jenis_harga_bphtb"]["Value"] = $this->cp["jenis_harga_bphtb"]->GetDBValue(true);
$this->UpdateFields["jenis_harga_bphtb"]["Value"] = $this->cp["jenis_harga_bphtb"]->GetDBValue(true);
$this->UpdateFields["bphtb_legal_doc_description"]["Value"] = $this->cp["bphtb_legal_doc_description"]->GetDBValue(true);
$this->UpdateFields["add_disc_percent"]["Value"] = $this->cp["add_disc_percent"]->GetDBValue(true);
$this->SQL = CCBuildUpdate("t_bphtb_registration", $this->UpdateFields, $this);
$this->SQL .= strlen($Where) ? " WHERE " . $Where : $Where;
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
if ($this->Errors->Count() == 0 && $this->CmdExecution) {
$this->query($this->SQL);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
}
}
function Initialize()
{
if (!$this->Visible) {
return;
}
$this->ds->Parameters["sesUserID"] = CCGetSession("UserID");
}
function licensing_customerscontent_BeforeShow(&$sender)
{
$licensing_customerscontent_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $licensing_customerscontent;
//Compatibility
//End licensing_customerscontent_BeforeShow
//Custom Code @152-2A29BDB7
// -------------------------
// Write your own code here.
global $Tpl;
$tab = CCGetFromGet("tab", "tab1_active");
switch ($tab) {
default:
case "details":
$Tpl->setvar("tab1_active", "active");
break;
case "licensing":
$Tpl->setvar("tab2_active", "active");
break;
case "licenselist":
$Tpl->setvar("tab3_active", "active");
break;
case "licensearchive":
$Tpl->setvar("tab4_active", "active");
break;
case "competitor_renewals":
$Tpl->setvar("tab5_active", "active");
break;
case "product_displacement":
$Tpl->setvar("tab6_active", "active");
break;
}
//Setting the active tab for licensing when the cssForm is present and has licensing as the form submitted
$cssForm = trim(CCGetFromGet("ccsForm", ""));
if ($cssForm == "licensing") {
//Whichever tab set will be reset to avoid more than 1 tab active
$Tpl->setvar("tab1_active", "");
$Tpl->setvar("tab2_active", "active");
$Tpl->setvar("tab3_active", "");
$Tpl->setvar("tab4_active", "");
$Tpl->setvar("tab5_active", "");
$Tpl->setvar("tab6_active", "");
}
//Settingup saved message popup
global $MainPage;
$showalert = CCGetSession("showalert", "hide");
$MainPage->Attributes->SetValue("showalert", $showalert);
if ($showalert == "show") {
CCSetSession("showalert", "hide");
}
//Setting up alerts to let user know the customer has not contacts yet
$customers = new Customers();
$customer_guid = CCGetFromGet("guid", "");
$params = array();
$params["customer_guid"] = $customer_guid;
$hasContacts = $customers->customerHasContacts($params);
if ($hasContacts["hasContacts"] == "1") {
$MainPage->Attributes->SetValue("showalert_contacterror", "hide");
} else {
$MainPage->Attributes->SetValue("showalert_contacterror", "show");
}
//Setting up alerts to let user know the license may need support
$license_guid = trim(CCGetFromGet("license_guid", ""));
if (strlen($license_guid) > 0) {
$products = new Alm\Products();
$params = array();
$params["license_guid"] = $license_guid;
$hasSupport = $products->licenseHasSupport($params);
if ($hasSupport["hasSupport"] == "1") {
$MainPage->Attributes->SetValue("showalert_addsupport", "hide");
} else {
$MainPage->Attributes->SetValue("showalert_addsupport", "show");
}
} else {
$MainPage->Attributes->SetValue("showalert_addsupport", "hide");
}
//Check if session variable showalert_addsupport has a show value
$showalert_addsupport = CCGetSession("showalert_addsupport", "");
if ($showalert_addsupport == "show") {
CCSetSession("showalert_addsupport", "hide");
$MainPage->Attributes->SetValue("showalert_addsupport", $showalert);
}
//Procesing file uploading
$hidlicense_guid = trim(CCGetFromPost("hidlicense_guid", ""));
if (!empty($_FILES) && strlen($hidlicense_guid) > 0) {
$params = array();
$params["license_guid"] = $hidlicense_guid;
$products = new \Alm\Products();
$products->uploadLicenseFile($_FILES, $params);
//Finishing script execution for file uploads because its asyncronous
exit;
}
$license_guid = trim(CCGetFromGet("license_guid", ""));
$licensefile_guid = trim(CCGetFromGet("licensefile_guid", ""));
$o = trim(CCGetFromGet("o", ""));
//Delete licensing operation
if (strlen($licensefile_guid) > 0 && $o == "dellicense") {
$params = array();
$params["licensefile_guid"] = $licensefile_guid;
$products = new \Alm\Products();
$products->deleteLicenseFileByGuid($params);
$querystring = CCGetQueryString("QueryString", array("licensefile_guid", "o"));
global $FileName;
$urlRedirect = $FileName . "?{$querystring}";
header("Location: {$urlRedirect}");
}
//Delete full licensing operation
if (strlen($license_guid) > 0 && $o == "delfulllicense") {
$params = array();
$params["license_guid"] = $license_guid;
$products = new \Alm\Products();
$products->deleteFullLicenseByGuid($params);
$querystring = CCGetQueryString("QueryString", array("license_guid", "o"));
global $FileName;
$urlRedirect = $FileName . "?{$querystring}";
header("Location: {$urlRedirect}");
}
if (strlen($license_guid) > 0) {
//License files grid
$params = array();
$params["license_guid"] = $license_guid;
$products = new \Alm\Products();
$licenseFiles = $products->getLicenseFiles($params);
$licenseFiles = $licenseFiles["licensefiles"];
$querystring = CCGetQueryString("QueryString", array("o", "licensefile_guid", "tab"));
foreach ($licenseFiles as $licenseFile) {
$licensefile_guid = $licenseFile["guid"];
$linkdelete = "";
if (CCGetGroupID() == "4") {
//Moved linkdelete to code because issues displaying panels inside custom template blocks
$linkdelete = "<a href='licensing_customers.php?o=dellicense&licensefile_guid={$licensefile_guid}&tab=licenselist&{$querystring}' class='dellicense' ><li class='icon-trash bigger-150 red'></li></a>";
}
$Tpl->setvar("linkdelete", $linkdelete);
$Tpl->setvar("licensefile_guid", $licensefile_guid);
$Tpl->setvar("getparams", "&" . $querystring);
$Tpl->Parse("licensefile_list", true);
}
}
// -------------------------
//End Custom Code
//Close licensing_customerscontent_BeforeShow @1-0B488567
return $licensing_customerscontent_BeforeShow;
}
function companies_viewcontent_BeforeShow(&$sender)
{
$companies_viewcontent_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $companies_viewcontent;
//Compatibility
//End companies_viewcontent_BeforeShow
//Custom Code @32-2A29BDB7
// -------------------------
// Write your own code here.
global $Tpl;
$tab = CCGetFromGet("tab", "tab1_active");
switch ($tab) {
default:
case "details":
$Tpl->setvar("tab1_active", "active");
break;
case "evaluation":
$Tpl->setvar("tab3_active", "active");
break;
case "addcontact":
$Tpl->setvar("tab2_active", "active");
break;
}
//Settingup saved message popup
global $MainPage;
$showalert = CCGetSession("showalert", "hide");
$MainPage->Attributes->SetValue("showalert", $showalert);
if ($showalert == "show") {
CCSetSession("showalert", "hide");
}
// -------------------------
//End Custom Code
//Close companies_viewcontent_BeforeShow @1-AEB03160
return $companies_viewcontent_BeforeShow;
}
function Update()
{
global $CCSLocales;
global $DefaultDateFormat;
$this->CmdExecution = true;
$this->cp["t_cust_account_id"] = new clsSQLParameter("ctrlt_cust_account_id", ccsInteger, "", "", $this->t_cust_account_id->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["p_account_status_id"] = new clsSQLParameter("ctrlp_account_status_id", ccsInteger, "", "", $this->p_account_status_id->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["description"] = new clsSQLParameter("ctrldescription", ccsText, "", "", $this->description->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["valid_to"] = new clsSQLParameter("ctrlvalid_to", ccsText, "", "", $this->valid_to->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["user_name"] = new clsSQLParameter("sesUserLogin", ccsText, "", "", CCGetSession("UserLogin", NULL), "", false, $this->ErrorBlock);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
if (!is_null($this->cp["t_cust_account_id"]->GetValue()) and !strlen($this->cp["t_cust_account_id"]->GetText()) and !is_bool($this->cp["t_cust_account_id"]->GetValue())) {
$this->cp["t_cust_account_id"]->SetValue($this->t_cust_account_id->GetValue(true));
}
if (!strlen($this->cp["t_cust_account_id"]->GetText()) and !is_bool($this->cp["t_cust_account_id"]->GetValue(true))) {
$this->cp["t_cust_account_id"]->SetText(0);
}
if (!is_null($this->cp["p_account_status_id"]->GetValue()) and !strlen($this->cp["p_account_status_id"]->GetText()) and !is_bool($this->cp["p_account_status_id"]->GetValue())) {
$this->cp["p_account_status_id"]->SetValue($this->p_account_status_id->GetValue(true));
}
if (!strlen($this->cp["p_account_status_id"]->GetText()) and !is_bool($this->cp["p_account_status_id"]->GetValue(true))) {
$this->cp["p_account_status_id"]->SetText(0);
}
if (!is_null($this->cp["description"]->GetValue()) and !strlen($this->cp["description"]->GetText()) and !is_bool($this->cp["description"]->GetValue())) {
$this->cp["description"]->SetValue($this->description->GetValue(true));
}
if (!is_null($this->cp["valid_to"]->GetValue()) and !strlen($this->cp["valid_to"]->GetText()) and !is_bool($this->cp["valid_to"]->GetValue())) {
$this->cp["valid_to"]->SetValue($this->valid_to->GetValue(true));
}
if (!is_null($this->cp["user_name"]->GetValue()) and !strlen($this->cp["user_name"]->GetText()) and !is_bool($this->cp["user_name"]->GetValue())) {
$this->cp["user_name"]->SetValue(CCGetSession("UserLogin", NULL));
}
$this->SQL = "select f_update_acc_status(" . $this->SQLValue($this->cp["t_cust_account_id"]->GetDBValue(), ccsInteger) . "," . $this->SQLValue($this->cp["p_account_status_id"]->GetDBValue(), ccsInteger) . ",'" . $this->SQLValue($this->cp["description"]->GetDBValue(), ccsText) . "','" . $this->SQLValue($this->cp["valid_to"]->GetDBValue(), ccsText) . "', '" . $this->SQLValue($this->cp["user_name"]->GetDBValue(), ccsText) . "')";
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
if ($this->Errors->Count() == 0 && $this->CmdExecution) {
$this->query($this->SQL);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
}
}
function CCGetUserLogin()
{
return CCGetSession("UserLogin");
}
function Insert()
{
global $CCSLocales;
global $DefaultDateFormat;
$this->CmdExecution = true;
$this->cp["t_vat_setllement_id"] = new clsSQLParameter("ctrlt_vat_setllement_id", ccsInteger, "", "", $this->t_vat_setllement_id->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["nilai_denda"] = new clsSQLParameter("ctrlnilai_denda", ccsFloat, "", "", $this->nilai_denda->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["deskripsi"] = new clsSQLParameter("ctrldeskripsi", ccsText, "", "", $this->deskripsi->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["user_name"] = new clsSQLParameter("sesUserLogin", ccsText, "", "", CCGetSession("UserLogin", NULL), "", false, $this->ErrorBlock);
$this->cp["flag_piutang"] = new clsSQLParameter("ctrlflag_piutang", ccsText, "", "", $this->flag_piutang->GetValue(true), "", false, $this->ErrorBlock);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $this->Parent);
if (!is_null($this->cp["t_vat_setllement_id"]->GetValue()) and !strlen($this->cp["t_vat_setllement_id"]->GetText()) and !is_bool($this->cp["t_vat_setllement_id"]->GetValue())) {
$this->cp["t_vat_setllement_id"]->SetValue($this->t_vat_setllement_id->GetValue(true));
}
if (!strlen($this->cp["t_vat_setllement_id"]->GetText()) and !is_bool($this->cp["t_vat_setllement_id"]->GetValue(true))) {
$this->cp["t_vat_setllement_id"]->SetText(0);
}
if (!is_null($this->cp["nilai_denda"]->GetValue()) and !strlen($this->cp["nilai_denda"]->GetText()) and !is_bool($this->cp["nilai_denda"]->GetValue())) {
$this->cp["nilai_denda"]->SetValue($this->nilai_denda->GetValue(true));
}
if (!strlen($this->cp["nilai_denda"]->GetText()) and !is_bool($this->cp["nilai_denda"]->GetValue(true))) {
$this->cp["nilai_denda"]->SetText(0);
}
if (!is_null($this->cp["deskripsi"]->GetValue()) and !strlen($this->cp["deskripsi"]->GetText()) and !is_bool($this->cp["deskripsi"]->GetValue())) {
$this->cp["deskripsi"]->SetValue($this->deskripsi->GetValue(true));
}
if (!is_null($this->cp["user_name"]->GetValue()) and !strlen($this->cp["user_name"]->GetText()) and !is_bool($this->cp["user_name"]->GetValue())) {
$this->cp["user_name"]->SetValue(CCGetSession("UserLogin", NULL));
}
if (!is_null($this->cp["flag_piutang"]->GetValue()) and !strlen($this->cp["flag_piutang"]->GetText()) and !is_bool($this->cp["flag_piutang"]->GetValue())) {
$this->cp["flag_piutang"]->SetValue($this->flag_piutang->GetValue(true));
}
$this->SQL = "SELECT f_update_penalty_new(" . $this->SQLValue($this->cp["t_vat_setllement_id"]->GetDBValue(), ccsInteger) . "," . $this->SQLValue($this->cp["flag_piutang"]->GetDBValue(), ccsText) . "," . $this->SQLValue($this->cp["nilai_denda"]->GetDBValue(), ccsFloat) . ", '" . $this->SQLValue($this->cp["deskripsi"]->GetDBValue(), ccsText) . "', '" . $this->SQLValue($this->cp["user_name"]->GetDBValue(), ccsText) . "') AS msg";
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteInsert", $this->Parent);
if ($this->Errors->Count() == 0 && $this->CmdExecution) {
//$this->query($this->SQL);
$this->itemResult = $this->query($this->SQL);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteInsert", $this->Parent);
}
}
function Page_BeforeShow()
{
//Page_BeforeShow @1-66DC429C
//Custom Code @32-2A29BDB7
global $Tpl;
$finalcat = CCGetFromGet("finalcat", "");
$ItemNum = CCGetFromGet("Item_Number", "");
if (CCGetSession("RecentPreviewItem")) {
$ItemNum = CCGetSession("RecentPreviewItem");
}
$cats = "(";
$db = new clsDBNetConnect();
$query = "select * from categories where cat_id='" . $finalcat . "'";
$db->query($query);
$db->next_record();
$Tpl->SetVar("category", $finalcat);
$Tpl->SetVar("cat_name", $db->f("name"));
$cats .= "cat_id=" . $db->f("cat_id");
if ($db->f("sub_cat_id") > 0) {
$cats .= " or ";
$sub = $db->f("sub_cat_id");
$query = "select * from categories where cat_id={$sub}";
$db->query($query);
$db->next_record();
$cats .= "cat_id=" . $db->f("cat_id");
if ($db->f("sub_cat_id") > 0) {
$cats .= " or ";
$sub = $db->f("sub_cat_id");
$query = "select * from categories where cat_id={$sub}";
$db->query($query);
$db->next_record();
$cats .= "cat_id=" . $db->f("cat_id");
if ($db->f("sub_cat_id") > 0) {
$cats .= " or ";
$sub = $db->f("sub_cat_id");
$query = "select * from categories where cat_id={$sub}";
$db->query($query);
$db->next_record();
$cats .= "cat_id=" . $db->f("cat_id");
if ($db->f("sub_cat_id") > 0) {
$cats .= " or ";
$sub = $db->f("sub_cat_id");
$query = "select * from categories where cat_id={$sub}";
$db->query($query);
$db->next_record();
$cats .= "cat_id=" . $db->f("cat_id");
if ($db->f("sub_cat_id") > 0) {
$cats .= " or ";
$sub = $db->f("sub_cat_id");
$query = "select * from categories where cat_id={$sub}";
$db->query($query);
$db->next_record();
$cats .= "cat_id=" . $db->f("cat_id");
if ($db->f("sub_cat_id") > 0) {
$cats .= " or ";
$sub = $db->f("sub_cat_id");
$query = "select * from categories where cat_id={$sub}";
$db->query($query);
$db->next_record();
$cats .= "cat_id=" . $db->f("cat_id");
} else {
$cats .= ")";
}
} else {
$cats .= ")";
}
} else {
$cats .= ")";
}
} else {
$cats .= ")";
}
} else {
$cats .= ")";
}
} else {
$cats .= ")";
}
$Tpl->SetBlockVar("Custom_TextArea", "");
$custtxt = new clsDBNetConnect();
$query = "select * from custom_textarea where {$cats}";
$custtxt->query($query);
if ($custtxt->next_record()) {
$custtxt->seek();
$queryfields = "(";
$count = 0;
while ($custtxt->next_record()) {
if ($count > 0) {
$queryfields .= " or ";
}
$queryfields .= "field_id='" . $custtxt->f("id") . "'";
$textvar[$custtxt->f("id")] = $custtxt->f("template_var");
$textdesc[$custtxt->f("id")] = $custtxt->f("description");
$textname[$custtxt->f("id")] = $custtxt->f("name");
$count++;
}
$custtxt->seek();
$queryfields .= ") and";
if (!$_POST["closes"] && $_GET["Item_Number"]) {
$custtxtvalues = new clsDBNetConnect();
$query = "select * from custom_textarea_values where {$queryfields} ItemNum=" . $ItemNum;
$custtxtvalues->query($query);
while ($custtxtvalues->next_record()) {
$fieldvalues[$custtxtvalues->f("field_id")] = $custtxtvalues->f("value");
}
}
if ($_POST && !$_GET["Item_Number"]) {
$custtxt->seek();
while ($custtxt->next_record()) {
$fieldvalues[$custtxt->f("id")] = $_POST["custtxt_area::" . $textvar[$custtxt->f("id")] . "::" . $custtxt->f("id")];
}
}
$custtxt->seek();
while ($custtxt->next_record()) {
$Tpl->SetVar("ta_name", multiline($textname[$custtxt->f("id")]));
$Tpl->SetVar("ta_description", multiline($textdesc[$custtxt->f("id")]));
$Tpl->SetVar("ta_var", "custtxt_area::" . $textvar[$custtxt->f("id")] . "::" . $custtxt->f("id"));
$Tpl->SetVar("ta_value", stripslashes($fieldvalues[$custtxt->f("id")]));
$Tpl->SetVar("ta_name_" . $custtxt->f("id"), multiline($textname[$custtxt->f("id")]));
$Tpl->SetVar("ta_description_" . $custtxt->f("id"), multiline($textdesc[$custtxt->f("id")]));
$Tpl->SetVar("ta_var_" . $custtxt->f("id"), "custtxt_area::" . $textvar[$custtxt->f("id")] . "::" . $custtxt->f("id"));
$Tpl->SetVar("ta_value_" . $custtxt->f("id"), stripslashes($fieldvalues[$custtxt->f("id")]));
$Tpl->Parse("Row", True);
}
$Tpl->Parse("Custom_TextArea", True);
}
//////////////////////////////
//Custom TextBox
//////////////////////////////
$txtvar = "";
$txtdesc = "";
$txtname = "";
$custtxtvalues = "";
$custtxt = "";
$fieldvalues = "";
$Tpl->SetBlockVar("Custom_TextBox", "");
$custtxt = new clsDBNetConnect();
$query = "select * from custom_textbox where {$cats}";
$custtxt->query($query);
if ($custtxt->next_record()) {
$custtxt->seek();
$queryfields = "(";
$count = 0;
while ($custtxt->next_record()) {
if ($count > 0) {
$queryfields .= " or ";
}
$queryfields .= "field_id='" . $custtxt->f("id") . "'";
$textvar[$custtxt->f("id")] = $custtxt->f("template_var");
$textdesc[$custtxt->f("id")] = $custtxt->f("description");
$textname[$custtxt->f("id")] = $custtxt->f("name");
$count++;
}
$custtxt->seek();
$queryfields .= ") and";
if ($_GET["Item_Number"] && !$_POST["closes"]) {
$custtxtvalues = new clsDBNetConnect();
$query = "select * from custom_textbox_values where {$queryfields} ItemNum=" . $ItemNum;
$custtxtvalues->query($query);
while ($custtxtvalues->next_record()) {
$fieldvalues[$custtxtvalues->f("field_id")] = $custtxtvalues->f("value");
}
}
if ($_POST && !$_GET["Item_Number"]) {
$custtxt->seek();
while ($custtxt->next_record()) {
$fieldvalues[$custtxt->f("id")] = $_POST["custtxt_box::" . $textvar[$custtxt->f("id")] . "::" . $custtxt->f("id")];
}
}
$custtxt->seek();
while ($custtxt->next_record()) {
$Tpl->SetVar("tb_name", multiline($textname[$custtxt->f("id")]));
$Tpl->SetVar("tb_description", multiline($textdesc[$custtxt->f("id")]));
$Tpl->SetVar("tb_value", stripslashes($fieldvalues[$custtxt->f("id")]));
$Tpl->SetVar("tb_var", "custtxt_box::" . $textvar[$custtxt->f("id")] . "::" . $custtxt->f("id"));
$Tpl->SetVar("tb_name_" . $custtxt->f("id"), multiline($textname[$custtxt->f("id")]));
$Tpl->SetVar("tb_description_" . $custtxt->f("id"), multiline($textdesc[$custtxt->f("id")]));
$Tpl->SetVar("tb_value_" . $custtxt->f("id"), stripslashes($fieldvalues[$custtxt->f("id")]));
$Tpl->SetVar("tb_var_" . $custtxt->f("id"), "custtxt_box::" . $textvar[$custtxt->f("id")] . "::" . $custtxt->f("id"));
$Tpl->Parse("tb_Row", True);
}
$Tpl->Parse("Custom_TextBox", True);
}
/////////////////////////////////////////////////////////////////
//Custom DropDown Fields
/////////////////////////////////////////////////////////////////
$txtvar = "";
$txtdesc = "";
$txtname = "";
$custtxtvalues = "";
$custtxt = "";
$fieldvalues = "";
$optionlist = "";
$checked = "";
$selected = "";
$Tpl->SetBlockVar("Custom_DropDown", "");
$custtxt = new clsDBNetConnect();
$custoptions = new clsDBNetConnect();
$query = "select * from custom_dropdown where {$cats}";
$custtxt->query($query);
if ($custtxt->next_record()) {
$custtxt->seek();
$queryfields = "(";
$count = 0;
while ($custtxt->next_record()) {
if ($count > 0) {
$queryfields .= " or ";
}
$query = "select * from custom_dropdown_options where field_id = '" . $custtxt->f("id") . "'";
$custoptions->query($query);
if ($_GET["Item_Number"] && !$_POST["custddbox::" . $custtxt->f("template_var") . "::" . $custtxt->f("id")]) {
$dvalue = new clsDBNetConnect();
$query = "select * from custom_dropdown_values where ItemNum = {$ItemNum} and field_id = " . $custtxt->f("id");
$dvalue->query($query);
if ($dvalue->next_record()) {
$selected[$custtxt->f("id")] = $dvalue->f("option_id");
} else {
$selected[$custtxt->f("id")] = "default";
}
} elseif ($_POST["custddbox::" . $custtxt->f("template_var") . "::" . $custtxt->f("id")]) {
$selected[$custtxt->f("id")] = $_POST["custddbox::" . $custtxt->f("template_var") . "::" . $custtxt->f("id")];
}
while ($custoptions->next_record()) {
$checked = "";
if (!$_GET["Item_Number"] && !$_POST["custddbox::" . $custtxt->f("template_var") . "::" . $custtxt->f("id")] && $custoptions->f("default") == 1 || $custoptions->f("default") == 1 && $selected[$custtxt->f("id")] == "default") {
$checked = " selected ";
} elseif ($custoptions->f("id") == $selected[$custtxt->f("id")]) {
$checked = " selected ";
} else {
$checked = "";
}
$optionlist[$custtxt->f("id")][] = "<option value=\"" . $custoptions->f("id") . "\"{$checked}>" . $custoptions->f("option") . "</option>\n";
}
$queryfields .= "field_id='" . $custtxt->f("id") . "'";
$textvar[$custtxt->f("id")] = $custtxt->f("template_var");
$textdesc[$custtxt->f("id")] = $custtxt->f("description");
$textname[$custtxt->f("id")] = $custtxt->f("name");
$count++;
}
$custtxt->seek();
$count = 0;
while ($custtxt->next_record()) {
$i = 0;
$builtoptions = "";
while ($optionlist[$custtxt->f("id")][$i]) {
$builtoptions .= $optionlist[$custtxt->f("id")][$i];
$i++;
}
$Tpl->SetVar("dd_name", multiline($textname[$custtxt->f("id")]));
$Tpl->SetVar("dd_description", multiline($textdesc[$custtxt->f("id")]));
$Tpl->SetVar("dd_var", "custddbox::" . $textvar[$custtxt->f("id")] . "::" . $custtxt->f("id"));
$Tpl->SetVar("dropdown_Options", $builtoptions);
$Tpl->SetVar("dd_name_" . $custtxt->f("id"), multiline($textname[$custtxt->f("id")]));
$Tpl->SetVar("dd_description_" . $custtxt->f("id"), multiline($textdesc[$custtxt->f("id")]));
$Tpl->SetVar("dd_var_" . $custtxt->f("id"), "custddbox::" . $textvar[$custtxt->f("id")] . "::" . $custtxt->f("id"));
$Tpl->SetVar("dropdown_Options_" . $custtxt->f("id"), $builtoptions);
$Tpl->Parse("dd_Row", True);
}
$Tpl->Parse("Custom_DropDown", True);
}
//////////////////////////////////
//End Custom Vars/////////////////
//////////////////////////////////
global $regcharges;
$sql = "SELECT * FROM categories WHERE sub_cat_id > '0' ORDER BY weight, name";
$db = new clsDBNetConnect();
$db->connect();
$db->query($sql);
while ($db->next_record()) {
$catid = $db->f(0);
$subid = $db->f(1);
$name = $db->f(2);
if ($subid == 1) {
$inis .= "<OPTION value=\"" . $catid . "\">" . $name . "</OPTION>";
}
$dsper .= "catlist[" . $catid . "] = new Array(" . $subid . " , \"" . $name . "\");\r\n";
}
$closestCat = getparents($_GET["finalcat"]);
if (!$closestCat) {
$closestCat = 1;
}
$db2 = new clsDBNetConnect();
$db2->connect();
$db2->query("SELECT * FROM lookup_listing_dates WHERE charge_for='1' and cat_id={$closestCat}");
$dayfees = "";
while ($db2->next_record()) {
$dayfees = $dayfees . $db2->f("days") . " Days - <font color='red'>" . $regcharges["currency"] . $db2->f("fee") . "</font><br>";
}
$Tpl->SetVar("cats", $dsper);
$Tpl->SetVar("catbuild", $inis);
$Tpl->SetVar("dayfees", $dayfees);
unset($db);
//End Custom Code
}
function Show()
{
global $Tpl;
global $CCSLocales;
if (!$this->Visible) {
return;
}
$this->RowNumber = 0;
$this->DataSource->Parameters["sesUserID"] = CCGetSession("UserID", NULL);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeSelect", $this);
$this->DataSource->Prepare();
$this->DataSource->Open();
$this->HasRecord = $this->DataSource->has_next_record();
$this->IsEmpty = !$this->HasRecord;
$this->Attributes->Show();
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeShow", $this);
if (!$this->Visible) {
return;
}
$GridBlock = "Grid " . $this->ComponentName;
$ParentPath = $Tpl->block_path;
$Tpl->block_path = $ParentPath . "/" . $GridBlock;
if (!$this->IsEmpty) {
$this->ControlsVisible["DLink"] = $this->DLink->Visible;
$this->ControlsVisible["message_status"] = $this->message_status->Visible;
$this->ControlsVisible["creation_date"] = $this->creation_date->Visible;
$this->ControlsVisible["message_type"] = $this->message_type->Visible;
$this->ControlsVisible["t_message_inbox_bphtb_id"] = $this->t_message_inbox_bphtb_id->Visible;
$this->ControlsVisible["status_view"] = $this->status_view->Visible;
$this->ControlsVisible["ppat_name"] = $this->ppat_name->Visible;
while ($this->ForceIteration || $this->RowNumber < $this->PageSize && ($this->HasRecord = $this->DataSource->has_next_record())) {
$this->RowNumber++;
if ($this->HasRecord) {
$this->DataSource->next_record();
$this->DataSource->SetValues();
}
$Tpl->block_path = $ParentPath . "/" . $GridBlock . "/Row";
$this->DLink->Parameters = CCGetQueryString("QueryString", array("FLAG", "ccsForm"));
$this->DLink->Parameters = CCAddParam($this->DLink->Parameters, "t_message_inbox_id", $this->DataSource->f("t_message_inbox_bphtb_id"));
$this->message_status->SetValue($this->DataSource->message_status->GetValue());
$this->creation_date->SetValue($this->DataSource->creation_date->GetValue());
$this->message_type->SetValue($this->DataSource->message_type->GetValue());
$this->t_message_inbox_bphtb_id->SetValue($this->DataSource->t_message_inbox_bphtb_id->GetValue());
$this->status_view->SetValue($this->DataSource->status_view->GetValue());
$this->ppat_name->SetValue($this->DataSource->ppat_name->GetValue());
$this->Attributes->SetValue("rowNumber", $this->RowNumber);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeShowRow", $this);
$this->Attributes->Show();
$this->DLink->Show();
$this->message_status->Show();
$this->creation_date->Show();
$this->message_type->Show();
$this->t_message_inbox_bphtb_id->Show();
$this->status_view->Show();
$this->ppat_name->Show();
$Tpl->block_path = $ParentPath . "/" . $GridBlock;
$Tpl->parse("Row", true);
}
} else {
// Show NoRecords block if no records are found
$this->Attributes->Show();
$Tpl->parse("NoRecords", false);
}
$errors = $this->GetErrors();
if (strlen($errors)) {
$Tpl->replaceblock("", $errors);
$Tpl->block_path = $ParentPath;
return;
}
$this->Navigator->PageNumber = $this->DataSource->AbsolutePage;
$this->Navigator->PageSize = $this->PageSize;
if ($this->DataSource->RecordsCount == "CCS not counted") {
$this->Navigator->TotalPages = $this->DataSource->AbsolutePage + ($this->DataSource->next_record() ? 1 : 0);
} else {
$this->Navigator->TotalPages = $this->DataSource->PageCount();
}
if ($this->Navigator->TotalPages <= 1) {
$this->Navigator->Visible = false;
}
$this->Navigator->Show();
$Tpl->parse();
$Tpl->block_path = $ParentPath;
$this->DataSource->close();
}
function Insert()
{
global $CCSLocales;
global $DefaultDateFormat;
$this->CmdExecution = true;
$this->cp["sender_message_id"] = new clsSQLParameter("urlt_message_inbox_bphtb_id", ccsFloat, "", "", CCGetFromGet("t_message_inbox_bphtb_id", NULL), 0, false, $this->ErrorBlock);
$this->cp["user_name"] = new clsSQLParameter("sesUserLogin", ccsText, "", "", CCGetSession("UserLogin", NULL), "", false, $this->ErrorBlock);
$this->cp["message_body"] = new clsSQLParameter("ctrlmessage_body", ccsText, "", "", $this->message_body->GetValue(true), "", false, $this->ErrorBlock);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $this->Parent);
if (!is_null($this->cp["sender_message_id"]->GetValue()) and !strlen($this->cp["sender_message_id"]->GetText()) and !is_bool($this->cp["sender_message_id"]->GetValue())) {
$this->cp["sender_message_id"]->SetText(CCGetFromGet("t_message_inbox_bphtb_id", NULL));
}
if (!strlen($this->cp["sender_message_id"]->GetText()) and !is_bool($this->cp["sender_message_id"]->GetValue(true))) {
$this->cp["sender_message_id"]->SetText(0);
}
if (!is_null($this->cp["user_name"]->GetValue()) and !strlen($this->cp["user_name"]->GetText()) and !is_bool($this->cp["user_name"]->GetValue())) {
$this->cp["user_name"]->SetValue(CCGetSession("UserLogin", NULL));
}
if (!is_null($this->cp["message_body"]->GetValue()) and !strlen($this->cp["message_body"]->GetText()) and !is_bool($this->cp["message_body"]->GetValue())) {
$this->cp["message_body"]->SetValue($this->message_body->GetValue(true));
}
$this->SQL = "SELECT f_send_message_to_ppat(" . $this->SQLValue($this->cp["sender_message_id"]->GetDBValue(), ccsFloat) . ",'" . $this->SQLValue($this->cp["user_name"]->GetDBValue(), ccsText) . "','" . $this->SQLValue($this->cp["message_body"]->GetDBValue(), ccsText) . "',null) as pesan";
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteInsert", $this->Parent);
if ($this->Errors->Count() == 0 && $this->CmdExecution) {
$this->query($this->SQL);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteInsert", $this->Parent);
}
}
function products_maintcontent_BeforeShow(&$sender)
{
$products_maintcontent_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $products_maintcontent;
//Compatibility
//End products_maintcontent_BeforeShow
//Custom Code @41-2A29BDB7
// -------------------------
// Write your own code here.
//Settingup saved message popup
global $MainPage;
$showalert = CCGetSession("showalert", "hide");
$MainPage->Attributes->SetValue("showalert", $showalert);
if ($showalert == "show") {
CCSetSession("showalert", "hide");
}
//There is some code duplication regarding show duplicate message info, session storage is read after some events
//has being fired and therefore not read.
$o = trim(CCGetFromGet("o", ""));
if ($o == "duplicate") {
$showglobal_alert = CCGetSession("showglobal_alert", "hide");
//$MainPage->Attributes->SetValue("showglobal_alert",$showglobal_alert);
$products_maintcontent->alm_products->showglobal_alert->SetValue($showglobal_alert);
if ($showglobal_alert == "show") {
CCSetSession("showglobal_alert", "hide");
}
} else {
$products_maintcontent->alm_products->showglobal_alert->SetValue("hide");
CCSetSession("showglobal_alert", "hide");
}
// -------------------------
//End Custom Code
//Close products_maintcontent_BeforeShow @1-86B6A4EF
return $products_maintcontent_BeforeShow;
}
$charges->Operation();
$charges1->Operation();
$Footer->Operations();
//End Execute Components
//Go to destination page @1-BEB91355
if ($Redirect) {
$CCSEventResult = CCGetEvent($CCSEvents, "BeforeUnload");
header("Location: " . $Redirect);
exit;
}
//End Go to destination page
//Initialize HTML Template @1-A0111C9D
$CCSEventResult = CCGetEvent($CCSEvents, "OnInitializeView");
$Tpl = new clsTemplate();
include './Lang/lang_class.php';
$Tpl->LoadTemplate(TemplatePath . $TemplateFileName, "main");
$CCSEventResult = CCGetEvent($CCSEvents, "BeforeShow");
//End Initialize HTML Template
$Tpl->setVar("ItemNum", CCGetSession("RecentItemNum"));
$Tpl->setVar("finalcat", $finalcat);
//Show Page @1-C99B99CD
$Header->Show("Header");
$charges->Show();
$charges1->Show();
$Footer->Show("Footer");
$Tpl->PParse("main", false);
//End Show Page
//Unload Page @1-AB7622EF
$CCSEventResult = CCGetEvent($CCSEvents, "BeforeUnload");
unset($Tpl);
//End Unload Page
function Delete()
{
global $CCSLocales;
global $DefaultDateFormat;
$this->CmdExecution = true;
$Where = "";
$this->cp["p_role_id"] = new clsSQLParameter("ctrlp_role_id", ccsInteger, "", "", $this->p_role_id->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["struser"] = new clsSQLParameter("sesUserName", ccsText, "", "", CCGetSession("UserName", NULL), "", false, $this->ErrorBlock);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildDelete", $this->Parent);
if (!is_null($this->cp["p_role_id"]->GetValue()) and !strlen($this->cp["p_role_id"]->GetText()) and !is_bool($this->cp["p_role_id"]->GetValue())) {
$this->cp["p_role_id"]->SetValue($this->p_role_id->GetValue(true));
}
if (!strlen($this->cp["p_role_id"]->GetText()) and !is_bool($this->cp["p_role_id"]->GetValue(true))) {
$this->cp["p_role_id"]->SetText(0);
}
if (!is_null($this->cp["struser"]->GetValue()) and !strlen($this->cp["struser"]->GetText()) and !is_bool($this->cp["struser"]->GetValue())) {
$this->cp["struser"]->SetValue(CCGetSession("UserName", NULL));
}
$this->SQL = "select * from f_crud_p_role\n" . "(" . $this->SQLValue($this->cp["p_role_id"]->GetDBValue(), ccsInteger) . ", \n" . "null,\n" . "null,\n" . "null,\n" . "null,\n" . "null,\n" . "'" . $this->SQLValue($this->cp["struser"]->GetDBValue(), ccsText) . "',\n" . "'D')";
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteDelete", $this->Parent);
if ($this->Errors->Count() == 0 && $this->CmdExecution) {
$this->query($this->SQL);
//begin-tambahan
$Result = $this->next_record();
if ($this->f('oint_result') != 1) {
$this->Errors->AddError($this->f('ostr_msg'));
return;
}
//end-tambahan
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteDelete", $this->Parent);
}
}
<?php
define("RelativePath", "..");
define("PathToCurrentPage", "/report/");
define("FileName", "cetak_registrasi.php");
include_once RelativePath . "/Common.php";
$dbConn = new clsDBConnSIKP();
$t_customer_order_id = CCGetFromGet("t_customer_order_id");
$user = CCGetSession('UserLogin');
$sql = "select f_print_register_new({$t_customer_order_id}, '{$user}')";
$dbConn->query($sql);
$dbConn->next_record();
echo $dbConn->f('f_print_register_new');
function Insert()
{
global $CCSLocales;
global $DefaultDateFormat;
$this->CmdExecution = true;
$this->cp["t_vat_setllement_id"] = new clsSQLParameter("ctrlt_vat_setllement_id", ccsInteger, "", "", $this->t_vat_setllement_id->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["alasan"] = new clsSQLParameter("ctrlalasan", ccsText, "", "", $this->alasan->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["user_name"] = new clsSQLParameter("sesUserLogin", ccsText, "", "", CCGetSession("UserLogin", NULL), "", false, $this->ErrorBlock);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $this->Parent);
if (!is_null($this->cp["t_vat_setllement_id"]->GetValue()) and !strlen($this->cp["t_vat_setllement_id"]->GetText()) and !is_bool($this->cp["t_vat_setllement_id"]->GetValue())) {
$this->cp["t_vat_setllement_id"]->SetValue($this->t_vat_setllement_id->GetValue(true));
}
if (!strlen($this->cp["t_vat_setllement_id"]->GetText()) and !is_bool($this->cp["t_vat_setllement_id"]->GetValue(true))) {
$this->cp["t_vat_setllement_id"]->SetText(0);
}
if (!is_null($this->cp["alasan"]->GetValue()) and !strlen($this->cp["alasan"]->GetText()) and !is_bool($this->cp["alasan"]->GetValue())) {
$this->cp["alasan"]->SetValue($this->alasan->GetValue(true));
}
if (!is_null($this->cp["user_name"]->GetValue()) and !strlen($this->cp["user_name"]->GetText()) and !is_bool($this->cp["user_name"]->GetValue())) {
$this->cp["user_name"]->SetValue(CCGetSession("UserLogin", NULL));
}
$this->SQL = "SELECT f_reject_trans(" . $this->SQLValue($this->cp["t_vat_setllement_id"]->GetDBValue(), ccsInteger) . ",'" . $this->SQLValue($this->cp["user_name"]->GetDBValue(), ccsText) . "','" . $this->SQLValue($this->cp["alasan"]->GetDBValue(), ccsText) . "', 0, '') AS msg";
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteInsert", $this->Parent);
if ($this->Errors->Count() == 0 && $this->CmdExecution) {
$this->itemResult = $this->query($this->SQL);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteInsert", $this->Parent);
}
}
function products_suite_maintcontent_BeforeShow(&$sender)
{
$products_suite_maintcontent_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $products_suite_maintcontent;
//Compatibility
//End products_suite_maintcontent_BeforeShow
//Custom Code @14-2A29BDB7
// -------------------------
// Write your own code here.
//Settingup saved message popup
global $MainPage;
$showalert = CCGetSession("showalert", "hide");
$MainPage->Attributes->SetValue("showalert", $showalert);
if ($showalert == "show") {
CCSetSession("showalert", "hide");
}
// -------------------------
//End Custom Code
//Close products_suite_maintcontent_BeforeShow @1-CA363294
return $products_suite_maintcontent_BeforeShow;
}
function Show()
{
global $Tpl;
global $now;
if (!$this->Visible) {
return;
}
$ShownRecords = 0;
$this->ds->Parameters["sesUserID"] = CCGetSession("UserID");
$this->ds->Prepare();
$this->ds->Open();
$GridBlock = "Grid " . $this->ComponentName;
$Tpl->block_path = $GridBlock;
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeShow");
$is_next_record = $this->ds->next_record();
if ($is_next_record && $ShownRecords < $this->PageSize) {
do {
$this->ds->SetValues();
$Tpl->block_path = $GridBlock . "/Row";
$this->comment->SetValue($this->ds->comment->GetValue());
$twodays = $this->ds->date->GetValue();
$theday = getdate($twodays);
$lastofyear = substr($theday["year"], -2);
$enddate = $theday["mon"] . "/" . $theday["mday"] . "/" . $lastofyear;
$this->date->SetValue(date("F j, Y, g:i a", $this->ds->date->GetValue()));
if ($this->ds->doing_rating->GetValue() != "" && is_numeric($this->ds->doing_rating->GetValue()) && $this->ds->doing_rating->GetValue() != 1000000000) {
$lookupdb = new clsDBNetConnect();
$lookupdb->connect();
$thename = CCDLookUp("user_login", "users", "user_id='" . $this->ds->doing_rating->GetValue() . "'", $lookupdb);
$this->doing_rating->SetValue($thename);
unset($lookupdb);
} else {
$this->doing_rating->SetValue($now["sitename"]);
}
$this->id->SetValue($this->ds->id->GetValue());
$this->ItemNum->SetValue($this->ds->ItemNum->GetValue());
if ($this->ds->rating->GetValue() == 1) {
$this->rating->SetValue("<img src=\"images/positive.gif\">");
}
if ($this->ds->rating->GetValue() == 0) {
$this->rating->SetValue("<img src=\"images/neutral.gif\">");
}
if ($this->ds->rating->GetValue() == -1) {
$this->rating->SetValue("<img src=\"images/negative.gif\">");
}
if ($this->ds->buysell->GetValue() == 1) {
$this->buysell->SetValue("Buyer");
}
if ($this->ds->buysell->GetValue() == 0) {
$this->buysell->SetValue("Seller");
}
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeShowRow");
$this->comment->Show();
$this->date->Show();
$this->doing_rating->Show();
$this->buysell->Show();
$this->id->Show();
$this->ItemNum->Show();
$this->rating->Show();
$counter = new clsDBNetConnect();
$query = "select * from feedback where `counter` = '" . $this->ds->id->GetValue() . "'";
$counter->query($query);
if ($counter->next_record()) {
$Tpl->SetBlockVar("counter", "");
$Tpl->setVar("countercomment", stripslashes($counter->f("comment")));
$Tpl->setVar("countericon", "<img src=\"images/CounterComment.gif\">");
$Tpl->setVar("counterlink", "");
$Tpl->parse("counter", "");
} else {
$Tpl->SetBlockVar("counter", "");
$Tpl->setVar("countercomment", "");
$Tpl->setVar("countericon", "");
if (CCGetUserID() == $_GET["user_id"]) {
$Tpl->setVar("counterlink", "<a href=\"RateUser.php?id=" . $this->ds->id->GetValue() . "\"> <i>Comment on this rating</i></a>");
}
}
$Tpl->block_path = $GridBlock;
$Tpl->parse("Row", true);
$ShownRecords++;
$is_next_record = $this->ds->next_record();
} while ($is_next_record && $ShownRecords < $this->PageSize);
} else {
$Tpl->parse("NoRecords", false);
}
$this->Navigator->TotalPages = $this->ds->PageCount();
$this->Sorter_doing_rating->Show();
$this->Sorter_date->Show();
$this->Navigator->Show();
$Tpl->parse("", false);
$Tpl->block_path = "";
}
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;
}
