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 Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["name"]["Value"] = $this->name->GetDBValue(true);
     $this->UpdateFields["taxid"]["Value"] = $this->taxid->GetDBValue(true);
     $this->UpdateFields["website"]["Value"] = $this->website->GetDBValue(true);
     $this->UpdateFields["city"]["Value"] = $this->city->GetDBValue(true);
     $this->UpdateFields["modified_iduser"]["Value"] = $this->modified_iduser->GetDBValue(true);
     $this->UpdateFields["created_iduser"]["Value"] = $this->created_iduser->GetDBValue(true);
     $this->UpdateFields["guid"]["Value"] = $this->hidguid->GetDBValue(true);
     $this->UpdateFields["phone"]["Value"] = $this->phone->GetDBValue(true);
     $this->UpdateFields["address"]["Value"] = $this->address->GetDBValue(true);
     $this->UpdateFields["assigned_to"]["Value"] = $this->assigned_to->GetDBValue(true);
     $this->UpdateFields["customertype_id"]["Value"] = $this->customertype_id->GetDBValue(true);
     $this->UpdateFields["shortname"]["Value"] = $this->shortname->GetDBValue(true);
     $this->UpdateFields["budgetdate"]["Value"] = $this->budgetdate->GetDBValue(true);
     $this->UpdateFields["assigned_to"]["Value"] = $this->assigned_to_user->GetDBValue(true);
     $this->UpdateFields["businesspartner"]["Value"] = $this->businesspartner->GetDBValue(true);
     $this->SQL = CCBuildUpdate("alm_customers", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $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 Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["username"]["Value"] = $this->username->GetDBValue(true);
     $this->UpdateFields["password"]["Value"] = $this->password->GetDBValue(true);
     $this->UpdateFields["fullname"]["Value"] = $this->fullname->GetDBValue(true);
     $this->UpdateFields["group_id"]["Value"] = $this->group_id->GetDBValue(true);
     $this->UpdateFields["jobposition"]["Value"] = $this->jobposition->GetDBValue(true);
     $this->UpdateFields["phone"]["Value"] = $this->phone->GetDBValue(true);
     $this->UpdateFields["created_userid"]["Value"] = $this->created_userid->GetDBValue(true);
     $this->UpdateFields["modified_userid"]["Value"] = $this->modified_userid->GetDBValue(true);
     $this->UpdateFields["guid"]["Value"] = $this->guid->GetDBValue(true);
     $this->UpdateFields["personal_id"]["Value"] = $this->personal_id->GetDBValue(true);
     $this->UpdateFields["email"]["Value"] = $this->email->GetDBValue(true);
     $this->SQL = CCBuildUpdate("alm_users", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $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 Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["guid"]["Value"] = $this->hidguid->GetDBValue(true);
     $this->UpdateFields["modified_iduser"]["Value"] = $this->modified_iduser->GetDBValue(true);
     $this->UpdateFields["created_iduser"]["Value"] = $this->created_iduser->GetDBValue(true);
     $this->UpdateFields["id_manufacturer"]["Value"] = $this->manufacturer->GetDBValue(true);
     $this->UpdateFields["suite_code"]["Value"] = $this->suite_code->GetDBValue(true);
     $this->UpdateFields["suite_long_description"]["Value"] = $this->suite_long_description->GetDBValue(true);
     $this->UpdateFields["id_suite_status"]["Value"] = $this->id_suite_status->GetDBValue(true);
     $this->UpdateFields["suite_description"]["Value"] = $this->suite_description->GetDBValue(true);
     $this->UpdateFields["legacy_expire_date"]["Value"] = $this->legacy_expire_date->GetDBValue(true);
     $this->SQL = CCBuildUpdate("alm_product_suites", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $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);
     }
 }
示例#5
0
 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $Where = "";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["clinic_id"]["Value"] = $this->clinic_id->GetDBValue(true);
     $this->UpdateFields["result"]["Value"] = $this->result1->GetDBValue(true);
     $this->UpdateFields["conclusion"]["Value"] = $this->conclusion->GetDBValue(true);
     $this->UpdateFields["sup_dept_id"]["Value"] = $this->sup_dept_id->GetDBValue(true);
     $this->UpdateFields["statistical_conclusion_id"]["Value"] = $this->stat_conclusion->GetDBValue(true);
     $this->SQL = CCBuildUpdate("result", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $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);
     }
 }
示例#6
0
 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $Where = "";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $SelectWhere = $this->Where;
     $this->Where = "title_id=" . $this->ToSQL($this->CachedColumns["title_id"], ccsInteger);
     $this->UpdateFields["title"]["Value"] = $this->title->GetDBValue(true);
     $this->SQL = CCBuildUpdate("title", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $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);
     }
     $this->Where = $SelectWhere;
 }
示例#7
0
 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $Where = "";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->SQL = CCBuildUpdate("users", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->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);
     }
 }
示例#8
0
 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $Where = "";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["consultant_i_c"]["Value"] = $this->consultant_i_c->GetDBValue(true);
     $this->UpdateFields["l_m_p"]["Value"] = $this->l_m_p->GetDBValue(true);
     $this->UpdateFields["clinic_id"]["Value"] = $this->clinic_id->GetDBValue(true);
     $this->UpdateFields["primary_diagnosis"]["Value"] = $this->primary_diagnosis->GetDBValue(true);
     $this->UpdateFields["clinical_notes"]["Value"] = $this->clinical_notes->GetDBValue(true);
     $this->UpdateFields["date"]["Value"] = $this->date->GetDBValue(true);
     $this->UpdateFields["sup_dept_id"]["Value"] = $this->sup_dept_id->GetDBValue(true);
     $this->UpdateFields["amount_to_pay"]["Value"] = $this->amount_to_pay->GetDBValue(true);
     $this->UpdateFields["department_id"]["Value"] = $this->department_id->GetDBValue(true);
     $this->UpdateFields["patient_id"]["Value"] = $this->patient_id->GetDBValue(true);
     $this->UpdateFields["status_id"]["Value"] = $this->status_id->GetDBValue(true);
     $this->SQL = CCBuildUpdate("result", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $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 Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->cp["restitusi_amt"] = new clsSQLParameter("ctrlrestitusi_amt", ccsFloat, "", "", $this->restitusi_amt->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["alasan"] = new clsSQLParameter("ctrlalasan", ccsText, "", "", $this->alasan->GetValue(true), NULL, false, $this->ErrorBlock);
     $wp = new clsSQLParameters($this->ErrorBlock);
     $wp->AddParameter("1", "ctrlt_bphtb_restitusi_id", ccsFloat, "", "", $this->t_bphtb_restitusi_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["restitusi_amt"]->GetValue()) and !strlen($this->cp["restitusi_amt"]->GetText()) and !is_bool($this->cp["restitusi_amt"]->GetValue())) {
         $this->cp["restitusi_amt"]->SetValue($this->restitusi_amt->GetValue(true));
     }
     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));
     }
     $wp->Criterion[1] = $wp->Operation(opEqual, "t_bphtb_restitusi_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["restitusi_amt"]["Value"] = $this->cp["restitusi_amt"]->GetDBValue(true);
     $this->UpdateFields["alasan"]["Value"] = $this->cp["alasan"]->GetDBValue(true);
     $this->SQL = CCBuildUpdate("t_bphtb_restitusi", $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 Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["id_suite"]["Value"] = $this->suite_code->GetDBValue(true);
     $this->UpdateFields["guid"]["Value"] = $this->hidguid->GetDBValue(true);
     $this->UpdateFields["modified_iduser"]["Value"] = $this->modified_iduser->GetDBValue(true);
     $this->UpdateFields["created_iduser"]["Value"] = $this->created_iduser->GetDBValue(true);
     $this->UpdateFields["channel_sku"]["Value"] = $this->channel_sku->GetDBValue(true);
     $this->UpdateFields["msrp_price"]["Value"] = $this->msrp_price->GetDBValue(true);
     $this->UpdateFields["product_content"]["Value"] = $this->product_content->GetDBValue(true);
     $this->UpdateFields["description"]["Value"] = $this->detaileddescription->GetDBValue(true);
     $this->UpdateFields["id_product_type"]["Value"] = $this->id_product_type->GetDBValue(true);
     $this->UpdateFields["id_product_tag"]["Value"] = $this->id_product_tag->GetDBValue(true);
     $this->UpdateFields["id_licensed_by"]["Value"] = $this->id_licensed_by->GetDBValue(true);
     $this->UpdateFields["licensed_amount"]["Value"] = $this->licensed_amount->GetDBValue(true);
     $this->UpdateFields["range_min"]["Value"] = $this->range_min->GetDBValue(true);
     $this->UpdateFields["range_max"]["Value"] = $this->range_max->GetDBValue(true);
     $this->UpdateFields["id_license_sector"]["Value"] = $this->id_license_sector->GetDBValue(true);
     $this->UpdateFields["id_license_granttype"]["Value"] = $this->id_license_granttype->GetDBValue(true);
     $this->UpdateFields["id_license_type"]["Value"] = $this->id_license_type->GetDBValue(true);
     $this->SQL = CCBuildUpdate("alm_products", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $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);
     }
 }
示例#11
0
 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $Where = "";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["appointment_date"]["Value"] = $this->appointment_date->GetDBValue(true);
     $this->UpdateFields["appointment_time"]["Value"] = $this->appointment_time->GetDBValue(true);
     $this->UpdateFields["user_id"]["Value"] = $this->doctor_name->GetDBValue(true);
     $this->SQL = CCBuildUpdate("result", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $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);
     }
 }
示例#12
0
 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $Where = "";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["last_name"]["Value"] = $this->last_name->GetDBValue(true);
     $this->UpdateFields["middle_name"]["Value"] = $this->middle_name->GetDBValue(true);
     $this->UpdateFields["group_id"]["Value"] = $this->group_id->GetDBValue(true);
     $this->UpdateFields["department_id"]["Value"] = $this->department_id->GetDBValue(true);
     $this->UpdateFields["title_id"]["Value"] = $this->title_id->GetDBValue(true);
     $this->UpdateFields["first_name"]["Value"] = $this->first_name->GetDBValue(true);
     $this->UpdateFields["user_status_id"]["Value"] = $this->Hidden1->GetDBValue(true);
     $this->UpdateFields["user_id"]["Value"] = $this->user_id->GetDBValue(true);
     $this->SQL = CCBuildUpdate("users", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $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 Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["holidays"]["Value"] = $this->holidays->GetDBValue(true);
     $this->UpdateFields["created_iduser"]["Value"] = $this->created_iduser->GetDBValue(true);
     $this->UpdateFields["modified_iduser"]["Value"] = $this->modified_iduser->GetDBValue(true);
     $this->UpdateFields["guid"]["Value"] = $this->hidguid->GetDBValue(true);
     $this->UpdateFields["message"]["Value"] = $this->message->GetDBValue(true);
     $this->UpdateFields["day_position"]["Value"] = $this->day_position->GetDBValue(true);
     $this->UpdateFields["day_month"]["Value"] = $this->hiddaymonth->GetDBValue(true);
     $this->SQL = CCBuildUpdate("alm_customers_contacts_holidays", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $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);
     }
 }
示例#14
0
 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->cp["created_by"] = new clsSQLParameter("ctrlcreated_by", ccsText, "", "", $this->created_by->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["updated_by"] = new clsSQLParameter("ctrlupdated_by", ccsText, "", "", $this->updated_by->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["creation_date"] = new clsSQLParameter("ctrlcreation_date", ccsText, "", "", $this->creation_date->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["updated_date"] = new clsSQLParameter("ctrlupdated_date", ccsText, "", "", $this->updated_date->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["latitude"] = new clsSQLParameter("ctrllatitude", ccsFloat, "", "", $this->latitude->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["longitude"] = new clsSQLParameter("ctrllongitude", ccsFloat, "", "", $this->longitude->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["file_name"] = new clsSQLParameter("ctrlfile_name", ccsText, "", "", $this->file_name->GetValue(true), NULL, false, $this->ErrorBlock);
     $wp = new clsSQLParameters($this->ErrorBlock);
     $wp->AddParameter("1", "ctrlpic_id", ccsFloat, "", "", $this->pic_id->GetValue(true), "", 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["created_by"]->GetValue()) and !strlen($this->cp["created_by"]->GetText()) and !is_bool($this->cp["created_by"]->GetValue())) {
         $this->cp["created_by"]->SetValue($this->created_by->GetValue(true));
     }
     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($this->updated_by->GetValue(true));
     }
     if (!is_null($this->cp["creation_date"]->GetValue()) and !strlen($this->cp["creation_date"]->GetText()) and !is_bool($this->cp["creation_date"]->GetValue())) {
         $this->cp["creation_date"]->SetValue($this->creation_date->GetValue(true));
     }
     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($this->updated_date->GetValue(true));
     }
     if (!is_null($this->cp["latitude"]->GetValue()) and !strlen($this->cp["latitude"]->GetText()) and !is_bool($this->cp["latitude"]->GetValue())) {
         $this->cp["latitude"]->SetValue($this->latitude->GetValue(true));
     }
     if (!is_null($this->cp["longitude"]->GetValue()) and !strlen($this->cp["longitude"]->GetText()) and !is_bool($this->cp["longitude"]->GetValue())) {
         $this->cp["longitude"]->SetValue($this->longitude->GetValue(true));
     }
     if (!is_null($this->cp["file_name"]->GetValue()) and !strlen($this->cp["file_name"]->GetText()) and !is_bool($this->cp["file_name"]->GetValue())) {
         $this->cp["file_name"]->SetValue($this->file_name->GetValue(true));
     }
     $wp->Criterion[1] = $wp->Operation(opEqual, "pic_id", $wp->GetDBValue("1"), $this->ToSQL($wp->GetDBValue("1"), ccsFloat), false);
     $Where = $wp->Criterion[1];
     $this->UpdateFields["created_by"]["Value"] = $this->cp["created_by"]->GetDBValue(true);
     $this->UpdateFields["updated_by"]["Value"] = $this->cp["updated_by"]->GetDBValue(true);
     $this->UpdateFields["creation_date"]["Value"] = $this->cp["creation_date"]->GetDBValue(true);
     $this->UpdateFields["updated_date"]["Value"] = $this->cp["updated_date"]->GetDBValue(true);
     $this->UpdateFields["latitude"]["Value"] = $this->cp["latitude"]->GetDBValue(true);
     $this->UpdateFields["longitude"]["Value"] = $this->cp["longitude"]->GetDBValue(true);
     $this->UpdateFields["file_name"]["Value"] = $this->cp["file_name"]->GetDBValue(true);
     $this->SQL = CCBuildUpdate("tb_pic_gis", $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);
     }
 }
示例#15
0
 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $Where = "";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["code"]["Value"] = $this->code->GetDBValue(true);
     $this->UpdateFields["client_name"]["Value"] = $this->client_name->GetDBValue(true);
     $this->UpdateFields["description"]["Value"] = $this->description->GetDBValue(true);
     $this->UpdateFields["creation_date"]["Value"] = $this->creation_date->GetDBValue(true);
     $this->UpdateFields["updated_date"]["Value"] = $this->updated_date->GetDBValue(true);
     $this->UpdateFields["updated_by"]["Value"] = $this->updated_by->GetDBValue(true);
     $this->UpdateFields["created_by"]["Value"] = $this->created_by->GetDBValue(true);
     $this->SQL = CCBuildUpdate("p_client", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $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 Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->cp["password"] = new clsSQLParameter("ctrlpassword_Shadow", ccsText, "", "", $this->password_Shadow->GetValue(true), NULL, false, $this->ErrorBlock);
     $wp = new clsSQLParameters($this->ErrorBlock);
     $wp->AddParameter("1", "expr13", ccsInteger, "", "", CCGetUserID(), "", 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["password"]->GetValue()) and !strlen($this->cp["password"]->GetText()) and !is_bool($this->cp["password"]->GetValue())) {
         $this->cp["password"]->SetValue($this->password_Shadow->GetValue(true));
     }
     $wp->Criterion[1] = $wp->Operation(opEqual, "id", $wp->GetDBValue("1"), $this->ToSQL($wp->GetDBValue("1"), ccsInteger), false);
     $Where = $wp->Criterion[1];
     $this->UpdateFields["password"]["Value"] = $this->cp["password"]->GetDBValue(true);
     $this->SQL = CCBuildUpdate("alm_users", $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 Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["contact"]["Value"] = $this->contact->GetDBValue(true);
     $this->UpdateFields["modified_iduser"]["Value"] = $this->modified_iduser->GetDBValue(true);
     $this->UpdateFields["created_iduser"]["Value"] = $this->created_iduser->GetDBValue(true);
     $this->UpdateFields["contact_dob"]["Value"] = $this->contact_dob->GetDBValue(true);
     $this->UpdateFields["jobposition"]["Value"] = $this->jobposition->GetDBValue(true);
     $this->UpdateFields["phone"]["Value"] = $this->phone->GetDBValue(true);
     $this->UpdateFields["extension"]["Value"] = $this->extension->GetDBValue(true);
     $this->UpdateFields["mobile"]["Value"] = $this->mobile->GetDBValue(true);
     $this->UpdateFields["workemail"]["Value"] = $this->workemail->GetDBValue(true);
     $this->UpdateFields["personalemail"]["Value"] = $this->personalemail->GetDBValue(true);
     $this->UpdateFields["customer_id"]["Value"] = $this->customer_id->GetDBValue(true);
     $this->UpdateFields["maincontact"]["Value"] = $this->maincontact->GetDBValue(true);
     $this->UpdateFields["preferred_color"]["Value"] = $this->preferred_color->GetDBValue(true);
     $this->UpdateFields["guid"]["Value"] = $this->hidguid->GetDBValue(true);
     $this->UpdateFields["twitter"]["Value"] = $this->twitter->GetDBValue(true);
     $this->UpdateFields["gender"]["Value"] = $this->contact_gender->GetDBValue(true);
     $this->UpdateFields["notify_holidays"]["Value"] = $this->notify_holidays->GetDBValue(true);
     $this->UpdateFields["hobbies"]["Value"] = $this->hidhobbies->GetDBValue(true);
     $this->UpdateFields["allow_notifications"]["Value"] = $this->allow_notifications->GetDBValue(true);
     $this->SQL = CCBuildUpdate("alm_customers_contacts", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $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 Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["name"]["Value"] = $this->name->GetDBValue(true);
     $this->UpdateFields["taxid"]["Value"] = $this->taxid->GetDBValue(true);
     $this->UpdateFields["website"]["Value"] = $this->website->GetDBValue(true);
     $this->UpdateFields["city"]["Value"] = $this->city->GetDBValue(true);
     $this->UpdateFields["os_workstations"]["Value"] = $this->os_workstations->GetDBValue(true);
     $this->UpdateFields["os_servers"]["Value"] = $this->os_servers->GetDBValue(true);
     $this->UpdateFields["os_servers_qty"]["Value"] = $this->os_servers_qty->GetDBValue(true);
     $this->UpdateFields["os_workstations_qty"]["Value"] = $this->os_workstations_qty->GetDBValue(true);
     $this->UpdateFields["servers_type"]["Value"] = $this->servers_type->GetDBValue(true);
     $this->UpdateFields["mailservers"]["Value"] = $this->mailservers->GetDBValue(true);
     $this->UpdateFields["proxyserver"]["Value"] = $this->proxyserver->GetDBValue(true);
     $this->UpdateFields["modified_iduser"]["Value"] = $this->modified_iduser->GetDBValue(true);
     $this->UpdateFields["created_iduser"]["Value"] = $this->created_iduser->GetDBValue(true);
     $this->UpdateFields["guid"]["Value"] = $this->hidguid->GetDBValue(true);
     $this->UpdateFields["content_filter"]["Value"] = $this->content_filter->GetDBValue(true);
     $this->UpdateFields["branches_connectivity"]["Value"] = $this->branches_connectivity->GetDBValue(true);
     $this->UpdateFields["branches_bandwith"]["Value"] = $this->branches_bandwidth->GetDBValue(true);
     $this->UpdateFields["os_workstations_hw"]["Value"] = $this->os_workstations_hw->GetDBValue(true);
     $this->UpdateFields["os_servers_hw"]["Value"] = $this->os_servers_hw->GetDBValue(true);
     $this->UpdateFields["database_security"]["Value"] = $this->database_security->GetDBValue(true);
     $this->UpdateFields["security_events"]["Value"] = $this->security_events->GetDBValue(true);
     $this->UpdateFields["changecontrol"]["Value"] = $this->changecontrol->GetDBValue(true);
     $this->UpdateFields["notes"]["Value"] = $this->notes->GetDBValue(true);
     $this->UpdateFields["customertype_id"]["Value"] = $this->customertype_id->GetDBValue(true);
     $this->UpdateFields["phone"]["Value"] = $this->phone->GetDBValue(true);
     $this->UpdateFields["address"]["Value"] = $this->address->GetDBValue(true);
     $this->UpdateFields["businesspartner"]["Value"] = $this->businesspartner->GetDBValue(true);
     $this->UpdateFields["virtualization"]["Value"] = $this->virtualization->GetDBValue(true);
     $this->UpdateFields["email_protection"]["Value"] = $this->email_protection->GetDBValue(true);
     $this->UpdateFields["vurnerability"]["Value"] = $this->vurnerabilities->GetDBValue(true);
     $this->UpdateFields["firewalls"]["Value"] = $this->firewalls->GetDBValue(true);
     $this->UpdateFields["backupsystem"]["Value"] = $this->backupsystem->GetDBValue(true);
     $this->UpdateFields["antivirus"]["Value"] = $this->antivirus->GetDBValue(true);
     $this->UpdateFields["encryption"]["Value"] = $this->encryption->GetDBValue(true);
     $this->UpdateFields["app_control"]["Value"] = $this->app_control->GetDBValue(true);
     $this->UpdateFields["mobility"]["Value"] = $this->mobility->GetDBValue(true);
     $this->UpdateFields["networkips"]["Value"] = $this->networkips->GetDBValue(true);
     $this->UpdateFields["networkac"]["Value"] = $this->networkac->GetDBValue(true);
     $this->UpdateFields["wireless_security"]["Value"] = $this->wireless_security->GetDBValue(true);
     $this->UpdateFields["socialmedia_security"]["Value"] = $this->socialmedia_security->GetDBValue(true);
     $this->UpdateFields["branches_qty"]["Value"] = $this->branches_qty->GetDBValue(true);
     $this->UpdateFields["isp"]["Value"] = $this->isp->GetDBValue(true);
     $this->UpdateFields["isp_bandwidth"]["Value"] = $this->isp_bandwidth->GetDBValue(true);
     $this->UpdateFields["datalostprevention"]["Value"] = $this->datalostprevention->GetDBValue(true);
     $this->UpdateFields["network_monitor"]["Value"] = $this->network_monitor->GetDBValue(true);
     $this->UpdateFields["networking"]["Value"] = $this->networking->GetDBValue(true);
     $this->UpdateFields["databases"]["Value"] = $this->databases->GetDBValue(true);
     $this->SQL = CCBuildUpdate("alm_customers", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $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 Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["variable"]["Value"] = $this->variable->GetDBValue(true);
     $this->UpdateFields["value"]["Value"] = $this->value->GetDBValue(true);
     $this->UpdateFields["style"]["Value"] = $this->style->GetDBValue(true);
     $this->UpdateFields["modified_iduser"]["Value"] = $this->modified_iduser->GetDBValue(true);
     $this->UpdateFields["created_iduser"]["Value"] = $this->created_iduser->GetDBValue(true);
     $this->UpdateFields["guid"]["Value"] = $this->hidguid->GetDBValue(true);
     $this->SQL = CCBuildUpdate("options", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $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);
     }
 }
示例#20
0
 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $Where = "";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["surname"]["Value"] = $this->surname->GetDBValue(true);
     $this->UpdateFields["other_names"]["Value"] = $this->other_names->GetDBValue(true);
     $this->UpdateFields["sex_id"]["Value"] = $this->sex_id->GetDBValue(true);
     $this->UpdateFields["occupation_id"]["Value"] = $this->occupation_id->GetDBValue(true);
     $this->UpdateFields["hospital_no"]["Value"] = $this->hospital_no->GetDBValue(true);
     $this->UpdateFields["age"]["Value"] = $this->age->GetDBValue(true);
     $this->SQL = CCBuildUpdate("patient", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $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 Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $Where = "";
     $this->cp["attribut_type"] = new clsSQLParameter("ctrlattribut_type", ccsText, "", "", $this->attribut_type->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["p_user_attribut_id"] = new clsSQLParameter("ctrlp_user_attribut_id", ccsFloat, "", "", $this->p_user_attribut_id->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["created_by"] = new clsSQLParameter("ctrlcreated_by", ccsText, "", "", $this->created_by->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["creation_date"] = new clsSQLParameter("ctrlcreation_date", ccsDate, array("dd", "-", "mmm", "-", "yyyy"), $this->DateFormat, $this->creation_date->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["updated_by"] = new clsSQLParameter("ctrlupdated_by", ccsText, "", "", $this->updated_by->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["updated_date"] = new clsSQLParameter("ctrlupdated_date", ccsDate, array("dd", "-", "mmm", "-", "yyyy"), $this->DateFormat, $this->updated_date->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["user_name"] = new clsSQLParameter("ctrluser_name", ccsText, "", "", $this->user_name->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["p_user_attribute_type_id"] = new clsSQLParameter("ctrlp_user_attribute_type_id", ccsText, "", "", $this->p_user_attribute_type_id->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["p_user_id"] = new clsSQLParameter("ctrlp_user_id", ccsText, "", "", $this->p_user_id->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["attribut_list_code"] = new clsSQLParameter("ctrlattribut_list_code", ccsText, "", "", $this->attribut_list_code->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["p_user_attribute_list_id"] = new clsSQLParameter("ctrlp_user_attribute_list_id", ccsText, "", "", $this->p_user_attribute_list_id->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["user_attribute_value"] = new clsSQLParameter("ctrluser_attribute_value", ccsText, "", "", $this->user_attribute_value->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["valid_from"] = new clsSQLParameter("ctrlvalid_from", ccsDate, array("dd", "-", "mmm", "-", "yyyy"), $this->DateFormat, $this->valid_from->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["valid_to"] = new clsSQLParameter("ctrlvalid_to", ccsDate, array("dd", "-", "mmm", "-", "yyyy"), $this->DateFormat, $this->valid_to->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["description"] = new clsSQLParameter("ctrldescription", ccsText, "", "", $this->description->GetValue(true), NULL, false, $this->ErrorBlock);
     $wp = new clsSQLParameters($this->ErrorBlock);
     $wp->AddParameter("1", "ctrlp_user_attribute_id", ccsFloat, "", "", $this->p_user_attribute_id->GetValue(true), "", 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["attribut_type"]->GetValue()) and !strlen($this->cp["attribut_type"]->GetText()) and !is_bool($this->cp["attribut_type"]->GetValue())) {
         $this->cp["attribut_type"]->SetValue($this->attribut_type->GetValue(true));
     }
     if (!is_null($this->cp["p_user_attribut_id"]->GetValue()) and !strlen($this->cp["p_user_attribut_id"]->GetText()) and !is_bool($this->cp["p_user_attribut_id"]->GetValue())) {
         $this->cp["p_user_attribut_id"]->SetValue($this->p_user_attribut_id->GetValue(true));
     }
     if (!is_null($this->cp["created_by"]->GetValue()) and !strlen($this->cp["created_by"]->GetText()) and !is_bool($this->cp["created_by"]->GetValue())) {
         $this->cp["created_by"]->SetValue($this->created_by->GetValue(true));
     }
     if (!is_null($this->cp["creation_date"]->GetValue()) and !strlen($this->cp["creation_date"]->GetText()) and !is_bool($this->cp["creation_date"]->GetValue())) {
         $this->cp["creation_date"]->SetValue($this->creation_date->GetValue(true));
     }
     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($this->updated_by->GetValue(true));
     }
     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($this->updated_date->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($this->user_name->GetValue(true));
     }
     if (!is_null($this->cp["p_user_attribute_type_id"]->GetValue()) and !strlen($this->cp["p_user_attribute_type_id"]->GetText()) and !is_bool($this->cp["p_user_attribute_type_id"]->GetValue())) {
         $this->cp["p_user_attribute_type_id"]->SetValue($this->p_user_attribute_type_id->GetValue(true));
     }
     if (!is_null($this->cp["p_user_id"]->GetValue()) and !strlen($this->cp["p_user_id"]->GetText()) and !is_bool($this->cp["p_user_id"]->GetValue())) {
         $this->cp["p_user_id"]->SetValue($this->p_user_id->GetValue(true));
     }
     if (!is_null($this->cp["attribut_list_code"]->GetValue()) and !strlen($this->cp["attribut_list_code"]->GetText()) and !is_bool($this->cp["attribut_list_code"]->GetValue())) {
         $this->cp["attribut_list_code"]->SetValue($this->attribut_list_code->GetValue(true));
     }
     if (!is_null($this->cp["p_user_attribute_list_id"]->GetValue()) and !strlen($this->cp["p_user_attribute_list_id"]->GetText()) and !is_bool($this->cp["p_user_attribute_list_id"]->GetValue())) {
         $this->cp["p_user_attribute_list_id"]->SetValue($this->p_user_attribute_list_id->GetValue(true));
     }
     if (!is_null($this->cp["user_attribute_value"]->GetValue()) and !strlen($this->cp["user_attribute_value"]->GetText()) and !is_bool($this->cp["user_attribute_value"]->GetValue())) {
         $this->cp["user_attribute_value"]->SetValue($this->user_attribute_value->GetValue(true));
     }
     if (!is_null($this->cp["valid_from"]->GetValue()) and !strlen($this->cp["valid_from"]->GetText()) and !is_bool($this->cp["valid_from"]->GetValue())) {
         $this->cp["valid_from"]->SetValue($this->valid_from->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["description"]->GetValue()) and !strlen($this->cp["description"]->GetText()) and !is_bool($this->cp["description"]->GetValue())) {
         $this->cp["description"]->SetValue($this->description->GetValue(true));
     }
     $wp->Criterion[1] = $wp->Operation(opEqual, "p_user_attribute_id", $wp->GetDBValue("1"), $this->ToSQL($wp->GetDBValue("1"), ccsFloat), false);
     $Where = $wp->Criterion[1];
     $this->UpdateFields["attribut_type"]["Value"] = $this->cp["attribut_type"]->GetDBValue(true);
     $this->UpdateFields["p_user_attribut_id"]["Value"] = $this->cp["p_user_attribut_id"]->GetDBValue(true);
     $this->UpdateFields["created_by"]["Value"] = $this->cp["created_by"]->GetDBValue(true);
     $this->UpdateFields["creation_date"]["Value"] = $this->cp["creation_date"]->GetDBValue(true);
     $this->UpdateFields["updated_by"]["Value"] = $this->cp["updated_by"]->GetDBValue(true);
     $this->UpdateFields["updated_date"]["Value"] = $this->cp["updated_date"]->GetDBValue(true);
     $this->UpdateFields["user_name"]["Value"] = $this->cp["user_name"]->GetDBValue(true);
     $this->UpdateFields["p_user_attribute_type_id"]["Value"] = $this->cp["p_user_attribute_type_id"]->GetDBValue(true);
     $this->UpdateFields["p_user_id"]["Value"] = $this->cp["p_user_id"]->GetDBValue(true);
     $this->UpdateFields["attribut_list_code"]["Value"] = $this->cp["attribut_list_code"]->GetDBValue(true);
     $this->UpdateFields["p_user_attribute_list_id"]["Value"] = $this->cp["p_user_attribute_list_id"]->GetDBValue(true);
     $this->UpdateFields["user_attribute_value"]["Value"] = $this->cp["user_attribute_value"]->GetDBValue(true);
     $this->UpdateFields["valid_from"]["Value"] = $this->cp["valid_from"]->GetDBValue(true);
     $this->UpdateFields["valid_to"]["Value"] = $this->cp["valid_to"]->GetDBValue(true);
     $this->UpdateFields["description"]["Value"] = $this->cp["description"]->GetDBValue(true);
     $this->SQL = CCBuildUpdate("p_user_attribute", $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);
     }
 }
示例#22
0
 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $Where = "";
     $this->cp["code"] = new clsSQLParameter("ctrlcode", ccsText, "", "", $this->code->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["is_active"] = new clsSQLParameter("ctrlis_active", ccsText, "", "", $this->is_active->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["description"] = new clsSQLParameter("ctrldescription", ccsText, "", "", $this->description->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["creation_date"] = new clsSQLParameter("ctrlcreation_date", ccsDate, array("dd", "-", "mmm", "-", "yyyy"), $this->DateFormat, $this->creation_date->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["created_by"] = new clsSQLParameter("ctrlcreated_by", ccsText, "", "", $this->created_by->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["updated_date"] = new clsSQLParameter("ctrlupdated_date", ccsDate, array("dd", "-", "mmm", "-", "yyyy"), $this->DateFormat, $this->updated_date->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["updated_by"] = new clsSQLParameter("ctrlupdated_by", ccsText, "", "", $this->updated_by->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["p_module_id"] = new clsSQLParameter("ctrlp_module_id", ccsFloat, "", "", $this->p_module_id->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["tooltip_text"] = new clsSQLParameter("ctrltooltip_text", ccsText, "", "", $this->tooltip_text->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["listing_no"] = new clsSQLParameter("ctrllisting_no", ccsText, "", "", $this->listing_no->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["user_status_id"] = new clsSQLParameter("ctrluser_status_id", ccsText, "", "", $this->user_status_id->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["p_user_id"] = new clsSQLParameter("ctrlp_user_id", ccsFloat, "", "", $this->p_user_id->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["full_name"] = new clsSQLParameter("ctrlfull_name", ccsText, "", "", $this->full_name->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["ip_address_4"] = new clsSQLParameter("ctrlip_address_4", ccsText, "", "", $this->ip_address_4->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["user_name"] = new clsSQLParameter("ctrluser_name", ccsText, "", "", $this->user_name->GetValue(true), NULL, false, $this->ErrorBlock);
     $wp = new clsSQLParameters($this->ErrorBlock);
     $wp->AddParameter("1", "urlp_user_id", ccsFloat, "", "", CCGetFromGet("p_user_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["code"]->GetValue()) and !strlen($this->cp["code"]->GetText()) and !is_bool($this->cp["code"]->GetValue())) {
         $this->cp["code"]->SetValue($this->code->GetValue(true));
     }
     if (!is_null($this->cp["is_active"]->GetValue()) and !strlen($this->cp["is_active"]->GetText()) and !is_bool($this->cp["is_active"]->GetValue())) {
         $this->cp["is_active"]->SetValue($this->is_active->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["creation_date"]->GetValue()) and !strlen($this->cp["creation_date"]->GetText()) and !is_bool($this->cp["creation_date"]->GetValue())) {
         $this->cp["creation_date"]->SetValue($this->creation_date->GetValue(true));
     }
     if (!is_null($this->cp["created_by"]->GetValue()) and !strlen($this->cp["created_by"]->GetText()) and !is_bool($this->cp["created_by"]->GetValue())) {
         $this->cp["created_by"]->SetValue($this->created_by->GetValue(true));
     }
     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($this->updated_date->GetValue(true));
     }
     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($this->updated_by->GetValue(true));
     }
     if (!is_null($this->cp["p_module_id"]->GetValue()) and !strlen($this->cp["p_module_id"]->GetText()) and !is_bool($this->cp["p_module_id"]->GetValue())) {
         $this->cp["p_module_id"]->SetValue($this->p_module_id->GetValue(true));
     }
     if (!is_null($this->cp["tooltip_text"]->GetValue()) and !strlen($this->cp["tooltip_text"]->GetText()) and !is_bool($this->cp["tooltip_text"]->GetValue())) {
         $this->cp["tooltip_text"]->SetValue($this->tooltip_text->GetValue(true));
     }
     if (!is_null($this->cp["listing_no"]->GetValue()) and !strlen($this->cp["listing_no"]->GetText()) and !is_bool($this->cp["listing_no"]->GetValue())) {
         $this->cp["listing_no"]->SetValue($this->listing_no->GetValue(true));
     }
     if (!is_null($this->cp["user_status_id"]->GetValue()) and !strlen($this->cp["user_status_id"]->GetText()) and !is_bool($this->cp["user_status_id"]->GetValue())) {
         $this->cp["user_status_id"]->SetValue($this->user_status_id->GetValue(true));
     }
     if (!is_null($this->cp["p_user_id"]->GetValue()) and !strlen($this->cp["p_user_id"]->GetText()) and !is_bool($this->cp["p_user_id"]->GetValue())) {
         $this->cp["p_user_id"]->SetValue($this->p_user_id->GetValue(true));
     }
     if (!is_null($this->cp["full_name"]->GetValue()) and !strlen($this->cp["full_name"]->GetText()) and !is_bool($this->cp["full_name"]->GetValue())) {
         $this->cp["full_name"]->SetValue($this->full_name->GetValue(true));
     }
     if (!is_null($this->cp["ip_address_4"]->GetValue()) and !strlen($this->cp["ip_address_4"]->GetText()) and !is_bool($this->cp["ip_address_4"]->GetValue())) {
         $this->cp["ip_address_4"]->SetValue($this->ip_address_4->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($this->user_name->GetValue(true));
     }
     $wp->Criterion[1] = $wp->Operation(opEqual, "p_user_id", $wp->GetDBValue("1"), $this->ToSQL($wp->GetDBValue("1"), ccsFloat), false);
     $Where = $wp->Criterion[1];
     $this->UpdateFields["code"]["Value"] = $this->cp["code"]->GetDBValue(true);
     $this->UpdateFields["is_active"]["Value"] = $this->cp["is_active"]->GetDBValue(true);
     $this->UpdateFields["description"]["Value"] = $this->cp["description"]->GetDBValue(true);
     $this->UpdateFields["creation_date"]["Value"] = $this->cp["creation_date"]->GetDBValue(true);
     $this->UpdateFields["created_by"]["Value"] = $this->cp["created_by"]->GetDBValue(true);
     $this->UpdateFields["updated_date"]["Value"] = $this->cp["updated_date"]->GetDBValue(true);
     $this->UpdateFields["updated_by"]["Value"] = $this->cp["updated_by"]->GetDBValue(true);
     $this->UpdateFields["p_module_id"]["Value"] = $this->cp["p_module_id"]->GetDBValue(true);
     $this->UpdateFields["tooltip_text"]["Value"] = $this->cp["tooltip_text"]->GetDBValue(true);
     $this->UpdateFields["listing_no"]["Value"] = $this->cp["listing_no"]->GetDBValue(true);
     $this->UpdateFields["user_status_id"]["Value"] = $this->cp["user_status_id"]->GetDBValue(true);
     $this->UpdateFields["p_user_id"]["Value"] = $this->cp["p_user_id"]->GetDBValue(true);
     $this->UpdateFields["full_name"]["Value"] = $this->cp["full_name"]->GetDBValue(true);
     $this->UpdateFields["ip_address_4"]["Value"] = $this->cp["ip_address_4"]->GetDBValue(true);
     $this->UpdateFields["user_name"]["Value"] = $this->cp["user_name"]->GetDBValue(true);
     $this->SQL = CCBuildUpdate("p_user", $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);
     }
 }