示例#1
1
 function Insert()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $this->Parent);
     $this->InsertFields["last_name"]["Value"] = $this->last_name->GetDBValue(true);
     $this->InsertFields["middle_name"]["Value"] = $this->middle_name->GetDBValue(true);
     $this->InsertFields["group_id"]["Value"] = $this->group_id->GetDBValue(true);
     $this->InsertFields["department_id"]["Value"] = $this->department_id->GetDBValue(true);
     $this->InsertFields["title_id"]["Value"] = $this->title_id->GetDBValue(true);
     $this->InsertFields["first_name"]["Value"] = $this->first_name->GetDBValue(true);
     $this->InsertFields["user_status_id"]["Value"] = $this->Hidden1->GetDBValue(true);
     $this->InsertFields["user_id"]["Value"] = $this->user_id->GetDBValue(true);
     $this->SQL = CCBuildInsert("users", $this->InsertFields, $this);
     $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 Insert()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $this->Parent);
     $this->InsertFields["name"]["Value"] = $this->name->GetDBValue(true);
     $this->InsertFields["taxid"]["Value"] = $this->taxid->GetDBValue(true);
     $this->InsertFields["website"]["Value"] = $this->website->GetDBValue(true);
     $this->InsertFields["city"]["Value"] = $this->city->GetDBValue(true);
     $this->InsertFields["os_workstations"]["Value"] = $this->os_workstations->GetDBValue(true);
     $this->InsertFields["os_servers"]["Value"] = $this->os_servers->GetDBValue(true);
     $this->InsertFields["os_servers_qty"]["Value"] = $this->os_servers_qty->GetDBValue(true);
     $this->InsertFields["os_workstations_qty"]["Value"] = $this->os_workstations_qty->GetDBValue(true);
     $this->InsertFields["servers_type"]["Value"] = $this->servers_type->GetDBValue(true);
     $this->InsertFields["mailservers"]["Value"] = $this->mailservers->GetDBValue(true);
     $this->InsertFields["proxyserver"]["Value"] = $this->proxyserver->GetDBValue(true);
     $this->InsertFields["modified_iduser"]["Value"] = $this->modified_iduser->GetDBValue(true);
     $this->InsertFields["created_iduser"]["Value"] = $this->created_iduser->GetDBValue(true);
     $this->InsertFields["guid"]["Value"] = $this->hidguid->GetDBValue(true);
     $this->InsertFields["content_filter"]["Value"] = $this->content_filter->GetDBValue(true);
     $this->InsertFields["branches_connectivity"]["Value"] = $this->branches_connectivity->GetDBValue(true);
     $this->InsertFields["branches_bandwith"]["Value"] = $this->branches_bandwidth->GetDBValue(true);
     $this->InsertFields["os_workstations_hw"]["Value"] = $this->os_workstations_hw->GetDBValue(true);
     $this->InsertFields["os_servers_hw"]["Value"] = $this->os_servers_hw->GetDBValue(true);
     $this->InsertFields["database_security"]["Value"] = $this->database_security->GetDBValue(true);
     $this->InsertFields["security_events"]["Value"] = $this->security_events->GetDBValue(true);
     $this->InsertFields["changecontrol"]["Value"] = $this->changecontrol->GetDBValue(true);
     $this->InsertFields["notes"]["Value"] = $this->notes->GetDBValue(true);
     $this->InsertFields["customertype_id"]["Value"] = $this->customertype_id->GetDBValue(true);
     $this->InsertFields["phone"]["Value"] = $this->phone->GetDBValue(true);
     $this->InsertFields["address"]["Value"] = $this->address->GetDBValue(true);
     $this->InsertFields["businesspartner"]["Value"] = $this->businesspartner->GetDBValue(true);
     $this->InsertFields["virtualization"]["Value"] = $this->virtualization->GetDBValue(true);
     $this->InsertFields["email_protection"]["Value"] = $this->email_protection->GetDBValue(true);
     $this->InsertFields["vurnerability"]["Value"] = $this->vurnerabilities->GetDBValue(true);
     $this->InsertFields["firewalls"]["Value"] = $this->firewalls->GetDBValue(true);
     $this->InsertFields["backupsystem"]["Value"] = $this->backupsystem->GetDBValue(true);
     $this->InsertFields["antivirus"]["Value"] = $this->antivirus->GetDBValue(true);
     $this->InsertFields["encryption"]["Value"] = $this->encryption->GetDBValue(true);
     $this->InsertFields["app_control"]["Value"] = $this->app_control->GetDBValue(true);
     $this->InsertFields["mobility"]["Value"] = $this->mobility->GetDBValue(true);
     $this->InsertFields["networkips"]["Value"] = $this->networkips->GetDBValue(true);
     $this->InsertFields["networkac"]["Value"] = $this->networkac->GetDBValue(true);
     $this->InsertFields["wireless_security"]["Value"] = $this->wireless_security->GetDBValue(true);
     $this->InsertFields["socialmedia_security"]["Value"] = $this->socialmedia_security->GetDBValue(true);
     $this->InsertFields["branches_qty"]["Value"] = $this->branches_qty->GetDBValue(true);
     $this->InsertFields["isp"]["Value"] = $this->isp->GetDBValue(true);
     $this->InsertFields["isp_bandwidth"]["Value"] = $this->isp_bandwidth->GetDBValue(true);
     $this->InsertFields["datalostprevention"]["Value"] = $this->datalostprevention->GetDBValue(true);
     $this->InsertFields["network_monitor"]["Value"] = $this->network_monitor->GetDBValue(true);
     $this->InsertFields["networking"]["Value"] = $this->networking->GetDBValue(true);
     $this->InsertFields["databases"]["Value"] = $this->databases->GetDBValue(true);
     $this->SQL = CCBuildInsert("alm_customers", $this->InsertFields, $this);
     $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);
     }
 }
示例#3
0
 function Insert()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $this->Parent);
     $this->InsertFields["title"]["Value"] = $this->title->GetDBValue(true);
     $this->SQL = CCBuildInsert("title", $this->InsertFields, $this);
     $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 Insert()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $this->Parent);
     $this->InsertFields["contact"]["Value"] = $this->contact->GetDBValue(true);
     $this->InsertFields["modified_iduser"]["Value"] = $this->modified_iduser->GetDBValue(true);
     $this->InsertFields["created_iduser"]["Value"] = $this->created_iduser->GetDBValue(true);
     $this->InsertFields["contact_dob"]["Value"] = $this->contact_dob->GetDBValue(true);
     $this->InsertFields["jobposition"]["Value"] = $this->jobposition->GetDBValue(true);
     $this->InsertFields["phone"]["Value"] = $this->phone->GetDBValue(true);
     $this->InsertFields["extension"]["Value"] = $this->extension->GetDBValue(true);
     $this->InsertFields["mobile"]["Value"] = $this->mobile->GetDBValue(true);
     $this->InsertFields["workemail"]["Value"] = $this->workemail->GetDBValue(true);
     $this->InsertFields["personalemail"]["Value"] = $this->personalemail->GetDBValue(true);
     $this->InsertFields["customer_id"]["Value"] = $this->customer_id->GetDBValue(true);
     $this->InsertFields["maincontact"]["Value"] = $this->maincontact->GetDBValue(true);
     $this->InsertFields["preferred_color"]["Value"] = $this->preferred_color->GetDBValue(true);
     $this->InsertFields["guid"]["Value"] = $this->hidguid->GetDBValue(true);
     $this->InsertFields["twitter"]["Value"] = $this->twitter->GetDBValue(true);
     $this->InsertFields["gender"]["Value"] = $this->contact_gender->GetDBValue(true);
     $this->InsertFields["notify_holidays"]["Value"] = $this->notify_holidays->GetDBValue(true);
     $this->InsertFields["hobbies"]["Value"] = $this->hidhobbies->GetDBValue(true);
     $this->InsertFields["allow_notifications"]["Value"] = $this->allow_notifications->GetDBValue(true);
     $this->SQL = CCBuildInsert("alm_customers_contacts", $this->InsertFields, $this);
     $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 Insert()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $this->Parent);
     $this->InsertFields["username"]["Value"] = $this->username->GetDBValue(true);
     $this->InsertFields["password"]["Value"] = $this->password->GetDBValue(true);
     $this->InsertFields["fullname"]["Value"] = $this->fullname->GetDBValue(true);
     $this->InsertFields["group_id"]["Value"] = $this->group_id->GetDBValue(true);
     $this->InsertFields["jobposition"]["Value"] = $this->jobposition->GetDBValue(true);
     $this->InsertFields["phone"]["Value"] = $this->phone->GetDBValue(true);
     $this->InsertFields["created_userid"]["Value"] = $this->created_userid->GetDBValue(true);
     $this->InsertFields["modified_userid"]["Value"] = $this->modified_userid->GetDBValue(true);
     $this->InsertFields["guid"]["Value"] = $this->guid->GetDBValue(true);
     $this->InsertFields["personal_id"]["Value"] = $this->personal_id->GetDBValue(true);
     $this->InsertFields["email"]["Value"] = $this->email->GetDBValue(true);
     $this->SQL = CCBuildInsert("alm_users", $this->InsertFields, $this);
     $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 Insert()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $this->Parent);
     $this->InsertFields["name"]["Value"] = $this->name->GetDBValue(true);
     $this->InsertFields["taxid"]["Value"] = $this->taxid->GetDBValue(true);
     $this->InsertFields["website"]["Value"] = $this->website->GetDBValue(true);
     $this->InsertFields["city"]["Value"] = $this->city->GetDBValue(true);
     $this->InsertFields["modified_iduser"]["Value"] = $this->modified_iduser->GetDBValue(true);
     $this->InsertFields["created_iduser"]["Value"] = $this->created_iduser->GetDBValue(true);
     $this->InsertFields["guid"]["Value"] = $this->hidguid->GetDBValue(true);
     $this->InsertFields["phone"]["Value"] = $this->phone->GetDBValue(true);
     $this->InsertFields["address"]["Value"] = $this->address->GetDBValue(true);
     $this->InsertFields["assigned_to"]["Value"] = $this->assigned_to->GetDBValue(true);
     $this->InsertFields["customertype_id"]["Value"] = $this->customertype_id->GetDBValue(true);
     $this->InsertFields["shortname"]["Value"] = $this->shortname->GetDBValue(true);
     $this->InsertFields["budgetdate"]["Value"] = $this->budgetdate->GetDBValue(true);
     $this->InsertFields["assigned_to"]["Value"] = $this->assigned_to_user->GetDBValue(true);
     $this->InsertFields["businesspartner"]["Value"] = $this->businesspartner->GetDBValue(true);
     $this->SQL = CCBuildInsert("alm_customers", $this->InsertFields, $this);
     $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 Insert()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->cp["penjelasan"] = new clsSQLParameter("ctrlpenjelasan", ccsText, "", "", $this->penjelasan->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["permasalahan"] = new clsSQLParameter("ctrlpermasalahan", ccsText, "", "", $this->permasalahan->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["kesimpulan"] = new clsSQLParameter("ctrlkesimpulan", ccsText, "", "", $this->kesimpulan->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["saran"] = new clsSQLParameter("ctrlsaran", ccsText, "", "", $this->saran->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["p_vat_type_id"] = new clsSQLParameter("ctrlp_vat_type_id", ccsText, "", "", $this->p_vat_type_id->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["p_finance_period_id"] = new clsSQLParameter("ctrlp_finance_period_id", ccsText, "", "", $this->p_finance_period_id->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["period_type"] = new clsSQLParameter("ctrlperiod_type", ccsText, "", "", $this->period_type->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["triwulan"] = new clsSQLParameter("ctrltriwulan", ccsText, "", "", $this->triwulan->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["semester"] = new clsSQLParameter("ctrlsemester", ccsText, "", "", $this->semester->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["created_by"] = new clsSQLParameter("sescreated_by", ccsText, "", "", CCGetSession("created_by", NULL), NULL, false, $this->ErrorBlock);
     $this->cp["updated_by"] = new clsSQLParameter("sesupdated_by", ccsText, "", "", CCGetSession("updated_by", NULL), NULL, false, $this->ErrorBlock);
     $this->cp["p_year_period_id"] = new clsSQLParameter("ctrlp_year_period_id", ccsFloat, "", "", $this->p_year_period_id->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $this->Parent);
     if (!is_null($this->cp["penjelasan"]->GetValue()) and !strlen($this->cp["penjelasan"]->GetText()) and !is_bool($this->cp["penjelasan"]->GetValue())) {
         $this->cp["penjelasan"]->SetValue($this->penjelasan->GetValue(true));
     }
     if (!is_null($this->cp["permasalahan"]->GetValue()) and !strlen($this->cp["permasalahan"]->GetText()) and !is_bool($this->cp["permasalahan"]->GetValue())) {
         $this->cp["permasalahan"]->SetValue($this->permasalahan->GetValue(true));
     }
     if (!is_null($this->cp["kesimpulan"]->GetValue()) and !strlen($this->cp["kesimpulan"]->GetText()) and !is_bool($this->cp["kesimpulan"]->GetValue())) {
         $this->cp["kesimpulan"]->SetValue($this->kesimpulan->GetValue(true));
     }
     if (!is_null($this->cp["saran"]->GetValue()) and !strlen($this->cp["saran"]->GetText()) and !is_bool($this->cp["saran"]->GetValue())) {
         $this->cp["saran"]->SetValue($this->saran->GetValue(true));
     }
     if (!is_null($this->cp["p_vat_type_id"]->GetValue()) and !strlen($this->cp["p_vat_type_id"]->GetText()) and !is_bool($this->cp["p_vat_type_id"]->GetValue())) {
         $this->cp["p_vat_type_id"]->SetValue($this->p_vat_type_id->GetValue(true));
     }
     if (!is_null($this->cp["p_finance_period_id"]->GetValue()) and !strlen($this->cp["p_finance_period_id"]->GetText()) and !is_bool($this->cp["p_finance_period_id"]->GetValue())) {
         $this->cp["p_finance_period_id"]->SetValue($this->p_finance_period_id->GetValue(true));
     }
     if (!is_null($this->cp["period_type"]->GetValue()) and !strlen($this->cp["period_type"]->GetText()) and !is_bool($this->cp["period_type"]->GetValue())) {
         $this->cp["period_type"]->SetValue($this->period_type->GetValue(true));
     }
     if (!is_null($this->cp["triwulan"]->GetValue()) and !strlen($this->cp["triwulan"]->GetText()) and !is_bool($this->cp["triwulan"]->GetValue())) {
         $this->cp["triwulan"]->SetValue($this->triwulan->GetValue(true));
     }
     if (!is_null($this->cp["semester"]->GetValue()) and !strlen($this->cp["semester"]->GetText()) and !is_bool($this->cp["semester"]->GetValue())) {
         $this->cp["semester"]->SetValue($this->semester->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(CCGetSession("created_by", NULL));
     }
     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("updated_by", NULL));
     }
     if (!is_null($this->cp["p_year_period_id"]->GetValue()) and !strlen($this->cp["p_year_period_id"]->GetText()) and !is_bool($this->cp["p_year_period_id"]->GetValue())) {
         $this->cp["p_year_period_id"]->SetValue($this->p_year_period_id->GetValue(true));
     }
     $this->InsertFields["penjelasan"]["Value"] = $this->cp["penjelasan"]->GetDBValue(true);
     $this->InsertFields["permasalahan"]["Value"] = $this->cp["permasalahan"]->GetDBValue(true);
     $this->InsertFields["kesimpulan"]["Value"] = $this->cp["kesimpulan"]->GetDBValue(true);
     $this->InsertFields["saran"]["Value"] = $this->cp["saran"]->GetDBValue(true);
     $this->InsertFields["p_vat_type_id"]["Value"] = $this->cp["p_vat_type_id"]->GetDBValue(true);
     $this->InsertFields["p_finance_period_id"]["Value"] = $this->cp["p_finance_period_id"]->GetDBValue(true);
     $this->InsertFields["period_type"]["Value"] = $this->cp["period_type"]->GetDBValue(true);
     $this->InsertFields["triwulan"]["Value"] = $this->cp["triwulan"]->GetDBValue(true);
     $this->InsertFields["semester"]["Value"] = $this->cp["semester"]->GetDBValue(true);
     $this->InsertFields["created_by"]["Value"] = $this->cp["created_by"]->GetDBValue(true);
     $this->InsertFields["updated_by"]["Value"] = $this->cp["updated_by"]->GetDBValue(true);
     $this->InsertFields["p_year_period_id"]["Value"] = $this->cp["p_year_period_id"]->GetDBValue(true);
     $this->SQL = CCBuildInsert("t_executive_summary", $this->InsertFields, $this);
     $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);
     }
 }
示例#8
0
 function Insert()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $this->Parent);
     $this->InsertFields["surname"]["Value"] = $this->surname->GetDBValue(true);
     $this->InsertFields["other_names"]["Value"] = $this->other_names->GetDBValue(true);
     $this->InsertFields["sex_id"]["Value"] = $this->sex_id->GetDBValue(true);
     $this->InsertFields["occupation_id"]["Value"] = $this->occupation_id->GetDBValue(true);
     $this->InsertFields["hospital_no"]["Value"] = $this->hospital_no->GetDBValue(true);
     $this->InsertFields["age"]["Value"] = $this->age->GetDBValue(true);
     $this->SQL = CCBuildInsert("patient", $this->InsertFields, $this);
     $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 Insert()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $this->Parent);
     $this->InsertFields["guid"]["Value"] = $this->hidguid->GetDBValue(true);
     $this->InsertFields["modified_iduser"]["Value"] = $this->modified_iduser->GetDBValue(true);
     $this->InsertFields["created_iduser"]["Value"] = $this->created_iduser->GetDBValue(true);
     $this->InsertFields["id_manufacturer"]["Value"] = $this->manufacturer->GetDBValue(true);
     $this->InsertFields["suite_code"]["Value"] = $this->suite_code->GetDBValue(true);
     $this->InsertFields["suite_long_description"]["Value"] = $this->suite_long_description->GetDBValue(true);
     $this->InsertFields["id_suite_status"]["Value"] = $this->id_suite_status->GetDBValue(true);
     $this->InsertFields["suite_description"]["Value"] = $this->suite_description->GetDBValue(true);
     $this->InsertFields["legacy_expire_date"]["Value"] = $this->legacy_expire_date->GetDBValue(true);
     $this->SQL = CCBuildInsert("alm_product_suites", $this->InsertFields, $this);
     $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);
     }
 }
示例#10
0
 function Insert()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $this->Parent);
     $this->InsertFields["consultant_i_c"]["Value"] = $this->consultant_i_c->GetDBValue(true);
     $this->InsertFields["l_m_p"]["Value"] = $this->l_m_p->GetDBValue(true);
     $this->InsertFields["clinic_id"]["Value"] = $this->clinic_id->GetDBValue(true);
     $this->InsertFields["primary_diagnosis"]["Value"] = $this->primary_diagnosis->GetDBValue(true);
     $this->InsertFields["clinical_notes"]["Value"] = $this->clinical_notes->GetDBValue(true);
     $this->InsertFields["date"]["Value"] = $this->date->GetDBValue(true);
     $this->InsertFields["sup_dept_id"]["Value"] = $this->sup_dept_id->GetDBValue(true);
     $this->InsertFields["amount_to_pay"]["Value"] = $this->amount_to_pay->GetDBValue(true);
     $this->InsertFields["department_id"]["Value"] = $this->department_id->GetDBValue(true);
     $this->InsertFields["patient_id"]["Value"] = $this->patient_id->GetDBValue(true);
     $this->InsertFields["status_id"]["Value"] = $this->status_id->GetDBValue(true);
     $this->SQL = CCBuildInsert("result", $this->InsertFields, $this);
     $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 Insert()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $this->Parent);
     $this->InsertFields["guid"]["Value"] = $this->hidguid->GetDBValue(true);
     $this->InsertFields["modified_iduser"]["Value"] = $this->modified_iduser->GetDBValue(true);
     $this->InsertFields["created_iduser"]["Value"] = $this->created_iduser->GetDBValue(true);
     $this->InsertFields["reseller_name"]["Value"] = $this->reseller_name->GetDBValue(true);
     $this->InsertFields["contact"]["Value"] = $this->contact->GetDBValue(true);
     $this->InsertFields["contact_email"]["Value"] = $this->contact_email->GetDBValue(true);
     $this->InsertFields["contact_phone"]["Value"] = $this->contact_phone->GetDBValue(true);
     $this->InsertFields["contact_mobile"]["Value"] = $this->contact_mobile->GetDBValue(true);
     $this->SQL = CCBuildInsert("alm_resellers", $this->InsertFields, $this);
     $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 Insert()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $this->Parent);
     $this->InsertFields["modified_iduser"]["Value"] = $this->modified_iduser->GetDBValue(true);
     $this->InsertFields["created_iduser"]["Value"] = $this->created_iduser->GetDBValue(true);
     $this->InsertFields["hobbie_id"]["Value"] = $this->hobbie_id->GetDBValue(true);
     $this->InsertFields["subhobbi"]["Value"] = $this->subhobbi->GetDBValue(true);
     $this->InsertFields["guid"]["Value"] = $this->hidguid->GetDBValue(true);
     $this->SQL = CCBuildInsert("alm_customers_contacts_subhobbies", $this->InsertFields, $this);
     $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);
     }
 }
示例#13
0
 function Insert()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $this->Parent);
     $this->InsertFields["p_role_id"]["Value"] = $this->p_role_id->GetDBValue(true);
     $this->InsertFields["code"]["Value"] = $this->code->GetDBValue(true);
     $this->InsertFields["listing_no"]["Value"] = $this->listing_no->GetDBValue(true);
     $this->InsertFields["valid_from"]["Value"] = $this->valid_from->GetDBValue(true);
     $this->InsertFields["valid_to"]["Value"] = $this->valid_to->GetDBValue(true);
     $this->InsertFields["description"]["Value"] = $this->description->GetDBValue(true);
     $this->InsertFields["creation_date"]["Value"] = $this->creation_date->GetDBValue(true);
     $this->InsertFields["created_by"]["Value"] = $this->created_by->GetDBValue(true);
     $this->InsertFields["updated_date"]["Value"] = $this->updated_date->GetDBValue(true);
     $this->InsertFields["updated_by"]["Value"] = $this->updated_by->GetDBValue(true);
     $this->SQL = CCBuildInsert("p_role", $this->InsertFields, $this);
     $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 Insert()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $this->Parent);
     $this->InsertFields["id_suite"]["Value"] = $this->suite_code->GetDBValue(true);
     $this->InsertFields["guid"]["Value"] = $this->hidguid->GetDBValue(true);
     $this->InsertFields["modified_iduser"]["Value"] = $this->modified_iduser->GetDBValue(true);
     $this->InsertFields["created_iduser"]["Value"] = $this->created_iduser->GetDBValue(true);
     $this->InsertFields["channel_sku"]["Value"] = $this->channel_sku->GetDBValue(true);
     $this->InsertFields["msrp_price"]["Value"] = $this->msrp_price->GetDBValue(true);
     $this->InsertFields["product_content"]["Value"] = $this->product_content->GetDBValue(true);
     $this->InsertFields["description"]["Value"] = $this->detaileddescription->GetDBValue(true);
     $this->InsertFields["id_product_type"]["Value"] = $this->id_product_type->GetDBValue(true);
     $this->InsertFields["id_product_tag"]["Value"] = $this->id_product_tag->GetDBValue(true);
     $this->InsertFields["id_licensed_by"]["Value"] = $this->id_licensed_by->GetDBValue(true);
     $this->InsertFields["licensed_amount"]["Value"] = $this->licensed_amount->GetDBValue(true);
     $this->InsertFields["range_min"]["Value"] = $this->range_min->GetDBValue(true);
     $this->InsertFields["range_max"]["Value"] = $this->range_max->GetDBValue(true);
     $this->InsertFields["id_license_sector"]["Value"] = $this->id_license_sector->GetDBValue(true);
     $this->InsertFields["id_license_granttype"]["Value"] = $this->id_license_granttype->GetDBValue(true);
     $this->InsertFields["id_license_type"]["Value"] = $this->id_license_type->GetDBValue(true);
     $this->SQL = CCBuildInsert("alm_products", $this->InsertFields, $this);
     $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 Insert()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $this->Parent);
     $this->InsertFields["variable"]["Value"] = $this->variable->GetDBValue(true);
     $this->InsertFields["value"]["Value"] = $this->value->GetDBValue(true);
     $this->InsertFields["style"]["Value"] = $this->style->GetDBValue(true);
     $this->InsertFields["modified_iduser"]["Value"] = $this->modified_iduser->GetDBValue(true);
     $this->InsertFields["created_iduser"]["Value"] = $this->created_iduser->GetDBValue(true);
     $this->InsertFields["guid"]["Value"] = $this->hidguid->GetDBValue(true);
     $this->SQL = CCBuildInsert("options", $this->InsertFields, $this);
     $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 Insert()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $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);
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $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));
     }
     $this->InsertFields["attribut_type"]["Value"] = $this->cp["attribut_type"]->GetDBValue(true);
     $this->InsertFields["p_user_attribut_id"]["Value"] = $this->cp["p_user_attribut_id"]->GetDBValue(true);
     $this->InsertFields["created_by"]["Value"] = $this->cp["created_by"]->GetDBValue(true);
     $this->InsertFields["creation_date"]["Value"] = $this->cp["creation_date"]->GetDBValue(true);
     $this->InsertFields["updated_by"]["Value"] = $this->cp["updated_by"]->GetDBValue(true);
     $this->InsertFields["updated_date"]["Value"] = $this->cp["updated_date"]->GetDBValue(true);
     $this->InsertFields["user_name"]["Value"] = $this->cp["user_name"]->GetDBValue(true);
     $this->InsertFields["p_user_attribute_type_id"]["Value"] = $this->cp["p_user_attribute_type_id"]->GetDBValue(true);
     $this->InsertFields["p_user_id"]["Value"] = $this->cp["p_user_id"]->GetDBValue(true);
     $this->InsertFields["attribut_list_code"]["Value"] = $this->cp["attribut_list_code"]->GetDBValue(true);
     $this->InsertFields["p_user_attribute_list_id"]["Value"] = $this->cp["p_user_attribute_list_id"]->GetDBValue(true);
     $this->InsertFields["user_attribute_value"]["Value"] = $this->cp["user_attribute_value"]->GetDBValue(true);
     $this->InsertFields["valid_from"]["Value"] = $this->cp["valid_from"]->GetDBValue(true);
     $this->InsertFields["valid_to"]["Value"] = $this->cp["valid_to"]->GetDBValue(true);
     $this->InsertFields["description"]["Value"] = $this->cp["description"]->GetDBValue(true);
     $this->SQL = CCBuildInsert("p_user_attribute", $this->InsertFields, $this);
     $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);
     }
 }
示例#17
0
 function Insert()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $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);
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $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));
     }
     $this->InsertFields["code"]["Value"] = $this->cp["code"]->GetDBValue(true);
     $this->InsertFields["is_active"]["Value"] = $this->cp["is_active"]->GetDBValue(true);
     $this->InsertFields["description"]["Value"] = $this->cp["description"]->GetDBValue(true);
     $this->InsertFields["creation_date"]["Value"] = $this->cp["creation_date"]->GetDBValue(true);
     $this->InsertFields["created_by"]["Value"] = $this->cp["created_by"]->GetDBValue(true);
     $this->InsertFields["updated_date"]["Value"] = $this->cp["updated_date"]->GetDBValue(true);
     $this->InsertFields["updated_by"]["Value"] = $this->cp["updated_by"]->GetDBValue(true);
     $this->InsertFields["p_module_id"]["Value"] = $this->cp["p_module_id"]->GetDBValue(true);
     $this->InsertFields["tooltip_text"]["Value"] = $this->cp["tooltip_text"]->GetDBValue(true);
     $this->InsertFields["listing_no"]["Value"] = $this->cp["listing_no"]->GetDBValue(true);
     $this->InsertFields["user_status_id"]["Value"] = $this->cp["user_status_id"]->GetDBValue(true);
     $this->InsertFields["p_user_id"]["Value"] = $this->cp["p_user_id"]->GetDBValue(true);
     $this->InsertFields["full_name"]["Value"] = $this->cp["full_name"]->GetDBValue(true);
     $this->InsertFields["ip_address_4"]["Value"] = $this->cp["ip_address_4"]->GetDBValue(true);
     $this->InsertFields["user_name"]["Value"] = $this->cp["user_name"]->GetDBValue(true);
     $this->SQL = CCBuildInsert("p_user", $this->InsertFields, $this);
     $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);
     }
 }