Visible = true; $this->Parent = & $Parent; $this->RelativePath = $RelativePath; $this->Errors = new clsErrors(); $this->ErrorBlock = "Record repules/Error"; $this->DataSource = new clsrepulesDataSource($this); $this->ds = & $this->DataSource; $this->InsertAllowed = true; $this->UpdateAllowed = true; $this->DeleteAllowed = true; $this->ReadAllowed = true; if($this->Visible) { $this->ComponentName = "repules"; $this->Attributes = new clsAttributes($this->ComponentName . ":"); $CCSForm = explode(":", CCGetFromGet("ccsForm", ""), 2); if(sizeof($CCSForm) == 1) $CCSForm[1] = ""; list($FormName, $FormMethod) = $CCSForm; $this->EditMode = ($FormMethod == "Edit"); $this->FormEnctype = "multipart/form-data"; $this->FormSubmitted = ($FormName == $this->ComponentName); $Method = $this->FormSubmitted ? ccsPost : ccsGet; $this->LNev = new clsControl(ccsListBox, "LNev", "LNev", ccsText, "", CCGetRequestParam("LNev", $Method, NULL), $this); $this->LNev->DSType = dsSQL; $this->LNev->DataSource = new clsDBConnection1(); $this->LNev->ds = & $this->LNev->DataSource; list($this->LNev->BoundColumn, $this->LNev->TextColumn, $this->LNev->DBFormat) = array("id", "concat(sportolo.nev,' (',cast(sportolo.mrsz_szam as char),' ',klub.klub_rov,') ',right(concat('0000',cast(sportolo.klubid as char)),4))", ""); $this->LNev->DataSource->SQL = "select sportolo.id, concat(sportolo.nev,' (',cast(sportolo.mrsz_szam as char),' ',klub.klub_rov,') ',right(concat('0000',cast(sportolo.klubid as char)),4)), sportolo.KlubID\n" . "from sportolo, klub\n" . "where sportolo.klubid=klub.id and sportolo.elfogadva=1 {SQL_OrderBy}"; $this->LNev->DataSource->Order = "nev"; $this->LNev->Required = true; $this->Sorszam = new clsControl(ccsTextBox, "Sorszam", $CCSLocales->GetText("Sorszam"), ccsInteger, "", CCGetRequestParam("Sorszam", $Method, NULL), $this); $this->Sorszam->Required = true; $this->SportoloID = new clsControl(ccsHidden, "SportoloID", $CCSLocales->GetText("SportoloID"), ccsInteger, "", CCGetRequestParam("SportoloID", $Method, NULL), $this); $this->SportoloKlub_azon = new clsControl(ccsHidden, "SportoloKlub_azon", $CCSLocales->GetText("SportoloKlub_azon"), ccsInteger, "", CCGetRequestParam("SportoloKlub_azon", $Method, NULL), $this); $this->LlAJSTROM = new clsControl(ccsListBox, "LlAJSTROM", "LlAJSTROM", ccsText, "", CCGetRequestParam("LlAJSTROM", $Method, NULL), $this); $this->LlAJSTROM->DSType = dsSQL; $this->LlAJSTROM->DataSource = new clsDBConnection1(); $this->LlAJSTROM->ds = & $this->LlAJSTROM->DataSource; list($this->LlAJSTROM->BoundColumn, $this->LlAJSTROM->TextColumn, $this->LlAJSTROM->DBFormat) = array("ID", "concat(cast(LJ_BETU as char),'-',cast(LJ_SZAM as char),' (',cast(geptipus as char),') (',rpad(cast(index1 as char),4,'0'),' - ',rpad(cast(index2 as char),4,'0'),')')", ""); $this->LlAJSTROM->DataSource->SQL = "SELECT lajstrom.ID, concat(cast(LJ_BETU as char),'-',cast(LJ_SZAM as char),' (',cast(geptipus as char),') (',rpad(cast(index1 as char),4,'0'),' - ',rpad(cast(index2 as char),4,'0'),')'), TipusID \n" . "FROM lajstrom INNER JOIN tipus ON\n" . "lajstrom.TipusID = tipus.ID {SQL_OrderBy}"; $this->LlAJSTROM->DataSource->Order = "LJ_BETU, LJ_SZAM"; $this->LlAJSTROM->Required = true; $this->Button1 = new clsButton("Button1", $Method, $this); $this->TipusIndex = new clsControl(ccsTextBox, "TipusIndex", $CCSLocales->GetText("TipusIndex"), ccsText, "", CCGetRequestParam("TipusIndex", $Method, NULL), $this); $this->TipusIndex->Required = true; $this->LajstromID = new clsControl(ccsHidden, "LajstromID", $CCSLocales->GetText("LajstromID"), ccsInteger, "", CCGetRequestParam("LajstromID", $Method, NULL), $this); $this->Datum = new clsControl(ccsTextBox, "Datum", "Datum", ccsText, "", CCGetRequestParam("Datum", $Method, NULL), $this); $this->Datum->Required = true; $this->DatePicker_Datum1 = new clsDatePicker("DatePicker_Datum1", "repules", "Datum", $this); $this->ListBox1 = new clsControl(ccsListBox, "ListBox1", "ListBox1", ccsText, "", CCGetRequestParam("ListBox1", $Method, NULL), $this); $this->ListBox1->DSType = dsListOfValues; $this->ListBox1->Values = array(array("C", "Céltáv"), array("S", "Szabad táv")); $this->ListBox1->Required = true; $this->Hidden1 = new clsControl(ccsHidden, "Hidden1", "Hidden1", ccsText, "", CCGetRequestParam("Hidden1", $Method, NULL), $this); $this->TAVHOSSZ = new clsControl(ccsTextBox, "TAVHOSSZ", $CCSLocales->GetText("TAVHOSSZ"), ccsFloat, array(False, 1, Null, "", False, "", "", 1, True, ""), CCGetRequestParam("TAVHOSSZ", $Method, NULL), $this); $this->TAVHOSSZ->Required = true; $this->INDULAS = new clsControl(ccsTextBox, "INDULAS", $CCSLocales->GetText("INDULAS"), ccsDate, array("H", ":", "nn", ":", "ss"), CCGetRequestParam("INDULAS", $Method, NULL), $this); $this->INDULAS->Required = true; $this->ERKEZES = new clsControl(ccsTextBox, "ERKEZES", $CCSLocales->GetText("ERKEZES"), ccsDate, array("H", ":", "nn", ":", "ss"), CCGetRequestParam("ERKEZES", $Method, NULL), $this); $this->Buntetes = new clsControl(ccsListBox, "Buntetes", $CCSLocales->GetText("BuntetesID"), ccsInteger, "", CCGetRequestParam("Buntetes", $Method, NULL), $this); $this->Buntetes->DSType = dsSQL; $this->Buntetes->DataSource = new clsDBConnection1(); $this->Buntetes->ds = & $this->Buntetes->DataSource; list($this->Buntetes->BoundColumn, $this->Buntetes->TextColumn, $this->Buntetes->DBFormat) = array("", "", ""); $this->Buntetes->DataSource->SQL = "SELECT ID, concat(rpad(cast(LEVONAS as char),5,\" \"),\" (\",LEVONAS_OKA,\")\") \n" . "FROM buntetes {SQL_OrderBy}"; $this->Buntetes->DataSource->Order = "LEVONAS,LEVONAS_OKA"; $this->Button2 = new clsButton("Button2", $Method, $this); $this->Sebesseg = new clsControl(ccsTextBox, "Sebesseg", "Sebesseg", ccsFloat, array(False, 2, Null, "", False, "", "", 1, True, ""), CCGetRequestParam("Sebesseg", $Method, NULL), $this); $this->PONT = new clsControl(ccsTextBox, "PONT", $CCSLocales->GetText("PONT"), ccsInteger, "", CCGetRequestParam("PONT", $Method, NULL), $this); $this->OSSZPONT = new clsControl(ccsTextBox, "OSSZPONT", $CCSLocales->GetText("OSSZPONT"), ccsInteger, "", CCGetRequestParam("OSSZPONT", $Method, NULL), $this); $this->FileUpload1 = new clsFileUpload("FileUpload1", "FileUpload1", "../mvkweb/temp/", "../mvkweb/upfiles/", "*", "", 10000000, $this); $this->Label6 = new clsControl(ccsLink, "Label6", "Label6", ccsText, "", CCGetRequestParam("Label6", $Method, NULL), $this); $this->Label6->Parameters = CCGetQueryString("QueryString", array("klub_lajstrom_repules_spoOrder", "klub_lajstrom_repules_spoDir", "ID", "ccsForm")); $this->FileUpload2 = new clsFileUpload("FileUpload2", "FileUpload2", "../mvkweb/temp/", "../mvkweb/upfiles/", "*", "", 10000000, $this); $this->Label5 = new clsControl(ccsLink, "Label5", "Label5", ccsText, "", CCGetRequestParam("Label5", $Method, NULL), $this); $this->Label5->Parameters = CCGetQueryString("QueryString", array("klub_lajstrom_repules_spoOrder", "klub_lajstrom_repules_spoDir", "ID", "ccsForm")); $this->IandO = new clsControl(ccsListBox, "IandO", $CCSLocales->GetText("IandO"), ccsText, "", CCGetRequestParam("IandO", $Method, NULL), $this); $this->IandO->DSType = dsListOfValues; $this->IandO->Values = array(array("Z", "Zárt"), array("N", "Nyitott")); $this->Status = new clsControl(ccsListBox, "Status", $CCSLocales->GetText("Status"), ccsText, "", CCGetRequestParam("Status", $Method, NULL), $this); $this->Status->DSType = dsListOfValues; $this->Status->Values = array(array("E", "Előzetes"), array("J", "Jóváhagyott"), array("T", "Törölt")); $this->Megjegyzes = new clsControl(ccsTextBox, "Megjegyzes", $CCSLocales->GetText("Megjegyzes"), ccsText, "", CCGetRequestParam("Megjegyzes", $Method, NULL), $this); $this->TimeStampInsert = new clsControl(ccsTextBox, "TimeStampInsert", $CCSLocales->GetText("TimeStampInsert"), ccsDate, array("yyyy", "-", "mm", "-", "dd", " ", "HH", ":", "nn", ":", "ss"), CCGetRequestParam("TimeStampInsert", $Method, NULL), $this); $this->TimeStampInsert->Visible = false; $this->Insert_User_ID = new clsControl(ccsTextBox, "Insert_User_ID", $CCSLocales->GetText("Insert_User_ID"), ccsInteger, "", CCGetRequestParam("Insert_User_ID", $Method, NULL), $this); $this->Insert_User_ID->Visible = false; $this->TimeStampUpdate = new clsControl(ccsTextBox, "TimeStampUpdate", $CCSLocales->GetText("TimeStampUpdate"), ccsDate, array("yyyy", "-", "mm", "-", "dd", " ", "HH", ":", "nn", ":", "ss"), CCGetRequestParam("TimeStampUpdate", $Method, NULL), $this); $this->TimeStampUpdate->Visible = false; $this->Update_User_ID = new clsControl(ccsTextBox, "Update_User_ID", $CCSLocales->GetText("Update_User_ID"), ccsInteger, "", CCGetRequestParam("Update_User_ID", $Method, NULL), $this); $this->Update_User_ID->Visible = false; $this->Label1 = new clsControl(ccsLabel, "Label1", "Label1", ccsText, "", CCGetRequestParam("Label1", $Method, NULL), $this); $this->Label2 = new clsControl(ccsLabel, "Label2", "Label2", ccsText, "", CCGetRequestParam("Label2", $Method, NULL), $this); $this->Label3 = new clsControl(ccsLabel, "Label3", "Label3", ccsText, "", CCGetRequestParam("Label3", $Method, NULL), $this); $this->Label4 = new clsControl(ccsLabel, "Label4", "Label4", ccsText, "", CCGetRequestParam("Label4", $Method, NULL), $this); $this->Panel1 = new clsPanel("Panel1", $this); $this->Button_Update = new clsButton("Button_Update", $Method, $this); $this->Button_Insert = new clsButton("Button_Insert", $Method, $this); $this->Button_Delete = new clsButton("Button_Delete", $Method, $this); $this->Button_Cancel = new clsButton("Button_Cancel", $Method, $this); $this->Panel1->Visible = false; if(!$this->FormSubmitted) { if(!is_array($this->ListBox1->Value) && !strlen($this->ListBox1->Value) && $this->ListBox1->Value !== false) $this->ListBox1->SetText("S"); if(!is_array($this->Status->Value) && !strlen($this->Status->Value) && $this->Status->Value !== false) $this->Status->SetText("E"); } } } //End Class_Initialize Event //Initialize Method @36-D6CB1C94 function Initialize() { if(!$this->Visible) return; $this->DataSource->Parameters["urlID"] = CCGetFromGet("ID", NULL); } //End Initialize Method //Validate Method @36-7E4DD64A function Validate() { global $CCSLocales; $Validation = true; $Where = ""; $Validation = ($this->LNev->Validate() && $Validation); $Validation = ($this->Sorszam->Validate() && $Validation); $Validation = ($this->SportoloID->Validate() && $Validation); $Validation = ($this->SportoloKlub_azon->Validate() && $Validation); $Validation = ($this->LlAJSTROM->Validate() && $Validation); $Validation = ($this->TipusIndex->Validate() && $Validation); $Validation = ($this->LajstromID->Validate() && $Validation); $Validation = ($this->Datum->Validate() && $Validation); $Validation = ($this->ListBox1->Validate() && $Validation); $Validation = ($this->Hidden1->Validate() && $Validation); $Validation = ($this->TAVHOSSZ->Validate() && $Validation); $Validation = ($this->INDULAS->Validate() && $Validation); $Validation = ($this->ERKEZES->Validate() && $Validation); $Validation = ($this->Buntetes->Validate() && $Validation); $Validation = ($this->Sebesseg->Validate() && $Validation); $Validation = ($this->PONT->Validate() && $Validation); $Validation = ($this->OSSZPONT->Validate() && $Validation); $Validation = ($this->FileUpload1->Validate() && $Validation); $Validation = ($this->FileUpload2->Validate() && $Validation); $Validation = ($this->Status->Validate() && $Validation); $Validation = ($this->Megjegyzes->Validate() && $Validation); $Validation = ($this->TimeStampInsert->Validate() && $Validation); $Validation = ($this->Insert_User_ID->Validate() && $Validation); $Validation = ($this->TimeStampUpdate->Validate() && $Validation); $Validation = ($this->Update_User_ID->Validate() && $Validation); $Validation = ($this->IandO->Validate() && $Validation); $this->CCSEventResult = CCGetEvent($this->CCSEvents, "OnValidate", $this); $Validation = $Validation && ($this->LNev->Errors->Count() == 0); $Validation = $Validation && ($this->Sorszam->Errors->Count() == 0); $Validation = $Validation && ($this->SportoloID->Errors->Count() == 0); $Validation = $Validation && ($this->SportoloKlub_azon->Errors->Count() == 0); $Validation = $Validation && ($this->LlAJSTROM->Errors->Count() == 0); $Validation = $Validation && ($this->TipusIndex->Errors->Count() == 0); $Validation = $Validation && ($this->LajstromID->Errors->Count() == 0); $Validation = $Validation && ($this->Datum->Errors->Count() == 0); $Validation = $Validation && ($this->ListBox1->Errors->Count() == 0); $Validation = $Validation && ($this->Hidden1->Errors->Count() == 0); $Validation = $Validation && ($this->TAVHOSSZ->Errors->Count() == 0); $Validation = $Validation && ($this->INDULAS->Errors->Count() == 0); $Validation = $Validation && ($this->ERKEZES->Errors->Count() == 0); $Validation = $Validation && ($this->Buntetes->Errors->Count() == 0); $Validation = $Validation && ($this->Sebesseg->Errors->Count() == 0); $Validation = $Validation && ($this->PONT->Errors->Count() == 0); $Validation = $Validation && ($this->OSSZPONT->Errors->Count() == 0); $Validation = $Validation && ($this->FileUpload1->Errors->Count() == 0); $Validation = $Validation && ($this->FileUpload2->Errors->Count() == 0); $Validation = $Validation && ($this->Status->Errors->Count() == 0); $Validation = $Validation && ($this->Megjegyzes->Errors->Count() == 0); $Validation = $Validation && ($this->TimeStampInsert->Errors->Count() == 0); $Validation = $Validation && ($this->Insert_User_ID->Errors->Count() == 0); $Validation = $Validation && ($this->TimeStampUpdate->Errors->Count() == 0); $Validation = $Validation && ($this->Update_User_ID->Errors->Count() == 0); $Validation = $Validation && ($this->IandO->Errors->Count() == 0); return (($this->Errors->Count() == 0) && $Validation); } //End Validate Method //CheckErrors Method @36-C25DB458 function CheckErrors() { $errors = false; $errors = ($errors || $this->LNev->Errors->Count()); $errors = ($errors || $this->Sorszam->Errors->Count()); $errors = ($errors || $this->SportoloID->Errors->Count()); $errors = ($errors || $this->SportoloKlub_azon->Errors->Count()); $errors = ($errors || $this->LlAJSTROM->Errors->Count()); $errors = ($errors || $this->TipusIndex->Errors->Count()); $errors = ($errors || $this->LajstromID->Errors->Count()); $errors = ($errors || $this->Datum->Errors->Count()); $errors = ($errors || $this->DatePicker_Datum1->Errors->Count()); $errors = ($errors || $this->ListBox1->Errors->Count()); $errors = ($errors || $this->Hidden1->Errors->Count()); $errors = ($errors || $this->TAVHOSSZ->Errors->Count()); $errors = ($errors || $this->INDULAS->Errors->Count()); $errors = ($errors || $this->ERKEZES->Errors->Count()); $errors = ($errors || $this->Buntetes->Errors->Count()); $errors = ($errors || $this->Sebesseg->Errors->Count()); $errors = ($errors || $this->PONT->Errors->Count()); $errors = ($errors || $this->OSSZPONT->Errors->Count()); $errors = ($errors || $this->FileUpload1->Errors->Count()); $errors = ($errors || $this->Label6->Errors->Count()); $errors = ($errors || $this->FileUpload2->Errors->Count()); $errors = ($errors || $this->Label5->Errors->Count()); $errors = ($errors || $this->Status->Errors->Count()); $errors = ($errors || $this->Megjegyzes->Errors->Count()); $errors = ($errors || $this->TimeStampInsert->Errors->Count()); $errors = ($errors || $this->Insert_User_ID->Errors->Count()); $errors = ($errors || $this->TimeStampUpdate->Errors->Count()); $errors = ($errors || $this->Update_User_ID->Errors->Count()); $errors = ($errors || $this->Label1->Errors->Count()); $errors = ($errors || $this->Label2->Errors->Count()); $errors = ($errors || $this->Label3->Errors->Count()); $errors = ($errors || $this->Label4->Errors->Count()); $errors = ($errors || $this->IandO->Errors->Count()); $errors = ($errors || $this->Errors->Count()); $errors = ($errors || $this->DataSource->Errors->Count()); return $errors; } //End CheckErrors Method //MasterDetail @36-ED598703 function SetPrimaryKeys($keyArray) { $this->PrimaryKeys = $keyArray; } function GetPrimaryKeys() { return $this->PrimaryKeys; } function GetPrimaryKey($keyName) { return $this->PrimaryKeys[$keyName]; } //End MasterDetail //Operation Method @36-7A7583DA function Operation() { if(!$this->Visible) return; global $Redirect; global $FileName; $this->DataSource->Prepare(); if(!$this->FormSubmitted) { $this->EditMode = $this->DataSource->AllParametersSet; return; } $this->FileUpload1->Upload(); $this->FileUpload2->Upload(); if($this->FormSubmitted) { $this->PressedButton = $this->EditMode ? "Button_Update" : "Button_Insert"; if($this->Button1->Pressed) { $this->PressedButton = "Button1"; } else if($this->Button2->Pressed) { $this->PressedButton = "Button2"; } else if($this->Button_Update->Pressed) { $this->PressedButton = "Button_Update"; } else if($this->Button_Insert->Pressed) { $this->PressedButton = "Button_Insert"; } else if($this->Button_Delete->Pressed) { $this->PressedButton = "Button_Delete"; } else if($this->Button_Cancel->Pressed) { $this->PressedButton = "Button_Cancel"; } } $Redirect = "repules_list.php" . "?" . CCGetQueryString("QueryString", array("ccsForm")); if($this->PressedButton == "Button_Delete") { if(!CCGetEvent($this->Button_Delete->CCSEvents, "OnClick", $this->Button_Delete) || !$this->DeleteRow()) { $Redirect = ""; } } else if($this->PressedButton == "Button_Cancel") { if(!CCGetEvent($this->Button_Cancel->CCSEvents, "OnClick", $this->Button_Cancel)) { $Redirect = ""; } } else if($this->Validate()) { if($this->PressedButton == "Button1") { if(!CCGetEvent($this->Button1->CCSEvents, "OnClick", $this->Button1)) { $Redirect = ""; } } else if($this->PressedButton == "Button2") { if(!CCGetEvent($this->Button2->CCSEvents, "OnClick", $this->Button2)) { $Redirect = ""; } } else if($this->PressedButton == "Button_Update") { if(!CCGetEvent($this->Button_Update->CCSEvents, "OnClick", $this->Button_Update) || !$this->UpdateRow()) { $Redirect = ""; } } else if($this->PressedButton == "Button_Insert") { if(!CCGetEvent($this->Button_Insert->CCSEvents, "OnClick", $this->Button_Insert) || !$this->InsertRow()) { $Redirect = ""; } } } else { $Redirect = ""; } if ($Redirect) $this->DataSource->close(); } //End Operation Method //InsertRow Method @36-2C4A0C3F function InsertRow() { $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeInsert", $this); if(!$this->InsertAllowed) return false; $this->DataSource->LNev->SetValue($this->LNev->GetValue(true)); $this->DataSource->Sorszam->SetValue($this->Sorszam->GetValue(true)); $this->DataSource->SportoloID->SetValue($this->SportoloID->GetValue(true)); $this->DataSource->SportoloKlub_azon->SetValue($this->SportoloKlub_azon->GetValue(true)); $this->DataSource->LlAJSTROM->SetValue($this->LlAJSTROM->GetValue(true)); $this->DataSource->TipusIndex->SetValue($this->TipusIndex->GetValue(true)); $this->DataSource->LajstromID->SetValue($this->LajstromID->GetValue(true)); $this->DataSource->Datum->SetValue($this->Datum->GetValue(true)); $this->DataSource->ListBox1->SetValue($this->ListBox1->GetValue(true)); $this->DataSource->Hidden1->SetValue($this->Hidden1->GetValue(true)); $this->DataSource->TAVHOSSZ->SetValue($this->TAVHOSSZ->GetValue(true)); $this->DataSource->INDULAS->SetValue($this->INDULAS->GetValue(true)); $this->DataSource->ERKEZES->SetValue($this->ERKEZES->GetValue(true)); $this->DataSource->Buntetes->SetValue($this->Buntetes->GetValue(true)); $this->DataSource->Sebesseg->SetValue($this->Sebesseg->GetValue(true)); $this->DataSource->PONT->SetValue($this->PONT->GetValue(true)); $this->DataSource->OSSZPONT->SetValue($this->OSSZPONT->GetValue(true)); $this->DataSource->FileUpload1->SetValue($this->FileUpload1->GetValue(true)); $this->DataSource->Label6->SetValue($this->Label6->GetValue(true)); $this->DataSource->FileUpload2->SetValue($this->FileUpload2->GetValue(true)); $this->DataSource->Label5->SetValue($this->Label5->GetValue(true)); $this->DataSource->Status->SetValue($this->Status->GetValue(true)); $this->DataSource->Megjegyzes->SetValue($this->Megjegyzes->GetValue(true)); $this->DataSource->TimeStampInsert->SetValue($this->TimeStampInsert->GetValue(true)); $this->DataSource->Insert_User_ID->SetValue($this->Insert_User_ID->GetValue(true)); $this->DataSource->TimeStampUpdate->SetValue($this->TimeStampUpdate->GetValue(true)); $this->DataSource->Update_User_ID->SetValue($this->Update_User_ID->GetValue(true)); $this->DataSource->Label1->SetValue($this->Label1->GetValue(true)); $this->DataSource->Label2->SetValue($this->Label2->GetValue(true)); $this->DataSource->Label3->SetValue($this->Label3->GetValue(true)); $this->DataSource->Label4->SetValue($this->Label4->GetValue(true)); $this->DataSource->IandO->SetValue($this->IandO->GetValue(true)); $this->DataSource->Insert(); $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterInsert", $this); if($this->DataSource->Errors->Count() == 0) { $this->FileUpload1->Move(); $this->FileUpload2->Move(); } return (!$this->CheckErrors()); } //End InsertRow Method //UpdateRow Method @36-FA661357 function UpdateRow() { $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeUpdate", $this); if(!$this->UpdateAllowed) return false; $this->DataSource->LNev->SetValue($this->LNev->GetValue(true)); $this->DataSource->Sorszam->SetValue($this->Sorszam->GetValue(true)); $this->DataSource->SportoloID->SetValue($this->SportoloID->GetValue(true)); $this->DataSource->SportoloKlub_azon->SetValue($this->SportoloKlub_azon->GetValue(true)); $this->DataSource->LlAJSTROM->SetValue($this->LlAJSTROM->GetValue(true)); $this->DataSource->TipusIndex->SetValue($this->TipusIndex->GetValue(true)); $this->DataSource->LajstromID->SetValue($this->LajstromID->GetValue(true)); $this->DataSource->Datum->SetValue($this->Datum->GetValue(true)); $this->DataSource->ListBox1->SetValue($this->ListBox1->GetValue(true)); $this->DataSource->Hidden1->SetValue($this->Hidden1->GetValue(true)); $this->DataSource->TAVHOSSZ->SetValue($this->TAVHOSSZ->GetValue(true)); $this->DataSource->INDULAS->SetValue($this->INDULAS->GetValue(true)); $this->DataSource->ERKEZES->SetValue($this->ERKEZES->GetValue(true)); $this->DataSource->Buntetes->SetValue($this->Buntetes->GetValue(true)); $this->DataSource->Sebesseg->SetValue($this->Sebesseg->GetValue(true)); $this->DataSource->PONT->SetValue($this->PONT->GetValue(true)); $this->DataSource->OSSZPONT->SetValue($this->OSSZPONT->GetValue(true)); $this->DataSource->FileUpload1->SetValue($this->FileUpload1->GetValue(true)); $this->DataSource->Label6->SetValue($this->Label6->GetValue(true)); $this->DataSource->FileUpload2->SetValue($this->FileUpload2->GetValue(true)); $this->DataSource->Label5->SetValue($this->Label5->GetValue(true)); $this->DataSource->Status->SetValue($this->Status->GetValue(true)); $this->DataSource->Megjegyzes->SetValue($this->Megjegyzes->GetValue(true)); $this->DataSource->TimeStampInsert->SetValue($this->TimeStampInsert->GetValue(true)); $this->DataSource->Insert_User_ID->SetValue($this->Insert_User_ID->GetValue(true)); $this->DataSource->TimeStampUpdate->SetValue($this->TimeStampUpdate->GetValue(true)); $this->DataSource->Update_User_ID->SetValue($this->Update_User_ID->GetValue(true)); $this->DataSource->Label1->SetValue($this->Label1->GetValue(true)); $this->DataSource->Label2->SetValue($this->Label2->GetValue(true)); $this->DataSource->Label3->SetValue($this->Label3->GetValue(true)); $this->DataSource->Label4->SetValue($this->Label4->GetValue(true)); $this->DataSource->IandO->SetValue($this->IandO->GetValue(true)); $this->DataSource->Update(); $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterUpdate", $this); if($this->DataSource->Errors->Count() == 0) { $this->FileUpload1->Move(); $this->FileUpload2->Move(); } return (!$this->CheckErrors()); } //End UpdateRow Method //DeleteRow Method @36-B5000756 function DeleteRow() { $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeDelete", $this); if(!$this->DeleteAllowed) return false; $this->DataSource->Delete(); $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterDelete", $this); if($this->DataSource->Errors->Count() == 0) { $this->FileUpload1->Delete(); $this->FileUpload2->Delete(); } return (!$this->CheckErrors()); } //End DeleteRow Method //Show Method @36-A6BC7BDB function Show() { global $CCSUseAmp; global $Tpl; global $FileName; global $CCSLocales; $Error = ""; if(!$this->Visible) return; $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeSelect", $this); $this->LNev->Prepare(); $this->LlAJSTROM->Prepare(); $this->ListBox1->Prepare(); $this->Buntetes->Prepare(); $this->Status->Prepare(); $this->IandO->Prepare(); $RecordBlock = "Record " . $this->ComponentName; $ParentPath = $Tpl->block_path; $Tpl->block_path = $ParentPath . "/" . $RecordBlock; $this->EditMode = $this->EditMode && $this->ReadAllowed; if($this->EditMode) { if($this->DataSource->Errors->Count()){ $this->Errors->AddErrors($this->DataSource->Errors); $this->DataSource->Errors->clear(); } $this->DataSource->Open(); if($this->DataSource->Errors->Count() == 0 && $this->DataSource->next_record()) { $this->DataSource->SetValues(); $this->Label6->SetValue($this->DataSource->Label6->GetValue()); $this->Label6->Page = $this->DataSource->f("LoggerFileNeve"); $this->Label5->SetValue($this->DataSource->Label5->GetValue()); $this->Label5->Page = $this->DataSource->f("TaskoltFileNeve"); $this->Label1->SetValue($this->DataSource->Label1->GetValue()); $this->Label2->SetValue($this->DataSource->Label2->GetValue()); $this->Label3->SetValue($this->DataSource->Label3->GetValue()); $this->Label4->SetValue($this->DataSource->Label4->GetValue()); if(!$this->FormSubmitted){ $this->LNev->SetValue($this->DataSource->LNev->GetValue()); $this->Sorszam->SetValue($this->DataSource->Sorszam->GetValue()); $this->SportoloID->SetValue($this->DataSource->SportoloID->GetValue()); $this->SportoloKlub_azon->SetValue($this->DataSource->SportoloKlub_azon->GetValue()); $this->LlAJSTROM->SetValue($this->DataSource->LlAJSTROM->GetValue()); $this->TipusIndex->SetValue($this->DataSource->TipusIndex->GetValue()); $this->LajstromID->SetValue($this->DataSource->LajstromID->GetValue()); $this->Datum->SetValue($this->DataSource->Datum->GetValue()); $this->ListBox1->SetValue($this->DataSource->ListBox1->GetValue()); $this->Hidden1->SetValue($this->DataSource->Hidden1->GetValue()); $this->TAVHOSSZ->SetValue($this->DataSource->TAVHOSSZ->GetValue()); $this->INDULAS->SetValue($this->DataSource->INDULAS->GetValue()); $this->ERKEZES->SetValue($this->DataSource->ERKEZES->GetValue()); $this->Buntetes->SetValue($this->DataSource->Buntetes->GetValue()); $this->Sebesseg->SetValue($this->DataSource->Sebesseg->GetValue()); $this->PONT->SetValue($this->DataSource->PONT->GetValue()); $this->OSSZPONT->SetValue($this->DataSource->OSSZPONT->GetValue()); $this->FileUpload1->SetValue($this->DataSource->FileUpload1->GetValue()); $this->FileUpload2->SetValue($this->DataSource->FileUpload2->GetValue()); $this->Status->SetValue($this->DataSource->Status->GetValue()); $this->Megjegyzes->SetValue($this->DataSource->Megjegyzes->GetValue()); $this->TimeStampInsert->SetValue($this->DataSource->TimeStampInsert->GetValue()); $this->Insert_User_ID->SetValue($this->DataSource->Insert_User_ID->GetValue()); $this->TimeStampUpdate->SetValue($this->DataSource->TimeStampUpdate->GetValue()); $this->Update_User_ID->SetValue($this->DataSource->Update_User_ID->GetValue()); $this->IandO->SetValue($this->DataSource->IandO->GetValue()); } } else { $this->EditMode = false; } } if($this->FormSubmitted || $this->CheckErrors()) { $Error = ""; $Error = ComposeStrings($Error, $this->LNev->Errors->ToString()); $Error = ComposeStrings($Error, $this->Sorszam->Errors->ToString()); $Error = ComposeStrings($Error, $this->SportoloID->Errors->ToString()); $Error = ComposeStrings($Error, $this->SportoloKlub_azon->Errors->ToString()); $Error = ComposeStrings($Error, $this->LlAJSTROM->Errors->ToString()); $Error = ComposeStrings($Error, $this->TipusIndex->Errors->ToString()); $Error = ComposeStrings($Error, $this->LajstromID->Errors->ToString()); $Error = ComposeStrings($Error, $this->Datum->Errors->ToString()); $Error = ComposeStrings($Error, $this->DatePicker_Datum1->Errors->ToString()); $Error = ComposeStrings($Error, $this->ListBox1->Errors->ToString()); $Error = ComposeStrings($Error, $this->Hidden1->Errors->ToString()); $Error = ComposeStrings($Error, $this->TAVHOSSZ->Errors->ToString()); $Error = ComposeStrings($Error, $this->INDULAS->Errors->ToString()); $Error = ComposeStrings($Error, $this->ERKEZES->Errors->ToString()); $Error = ComposeStrings($Error, $this->Buntetes->Errors->ToString()); $Error = ComposeStrings($Error, $this->Sebesseg->Errors->ToString()); $Error = ComposeStrings($Error, $this->PONT->Errors->ToString()); $Error = ComposeStrings($Error, $this->OSSZPONT->Errors->ToString()); $Error = ComposeStrings($Error, $this->FileUpload1->Errors->ToString()); $Error = ComposeStrings($Error, $this->Label6->Errors->ToString()); $Error = ComposeStrings($Error, $this->FileUpload2->Errors->ToString()); $Error = ComposeStrings($Error, $this->Label5->Errors->ToString()); $Error = ComposeStrings($Error, $this->Status->Errors->ToString()); $Error = ComposeStrings($Error, $this->Megjegyzes->Errors->ToString()); $Error = ComposeStrings($Error, $this->TimeStampInsert->Errors->ToString()); $Error = ComposeStrings($Error, $this->Insert_User_ID->Errors->ToString()); $Error = ComposeStrings($Error, $this->TimeStampUpdate->Errors->ToString()); $Error = ComposeStrings($Error, $this->Update_User_ID->Errors->ToString()); $Error = ComposeStrings($Error, $this->Label1->Errors->ToString()); $Error = ComposeStrings($Error, $this->Label2->Errors->ToString()); $Error = ComposeStrings($Error, $this->Label3->Errors->ToString()); $Error = ComposeStrings($Error, $this->Label4->Errors->ToString()); $Error = ComposeStrings($Error, $this->IandO->Errors->ToString()); $Error = ComposeStrings($Error, $this->Errors->ToString()); $Error = ComposeStrings($Error, $this->DataSource->Errors->ToString()); $Tpl->SetVar("Error", $Error); $Tpl->Parse("Error", false); } $CCSForm = $this->EditMode ? $this->ComponentName . ":" . "Edit" : $this->ComponentName; $this->HTMLFormAction = $FileName . "?" . CCAddParam(CCGetQueryString("QueryString", ""), "ccsForm", $CCSForm); $Tpl->SetVar("Action", !$CCSUseAmp ? $this->HTMLFormAction : str_replace("&", "&", $this->HTMLFormAction)); $Tpl->SetVar("HTMLFormName", $this->ComponentName); $Tpl->SetVar("HTMLFormEnctype", $this->FormEnctype); $this->Button_Update->Visible = $this->EditMode && $this->UpdateAllowed; $this->Button_Insert->Visible = !$this->EditMode && $this->InsertAllowed; $this->Button_Delete->Visible = $this->EditMode && $this->DeleteAllowed; $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeShow", $this); $this->Attributes->Show(); if(!$this->Visible) { $Tpl->block_path = $ParentPath; return; } $this->LNev->Show(); $this->Sorszam->Show(); $this->SportoloID->Show(); $this->SportoloKlub_azon->Show(); $this->LlAJSTROM->Show(); $this->Button1->Show(); $this->TipusIndex->Show(); $this->LajstromID->Show(); $this->Datum->Show(); $this->DatePicker_Datum1->Show(); $this->ListBox1->Show(); $this->Hidden1->Show(); $this->TAVHOSSZ->Show(); $this->INDULAS->Show(); $this->ERKEZES->Show(); $this->Buntetes->Show(); $this->Button2->Show(); $this->Sebesseg->Show(); $this->PONT->Show(); $this->OSSZPONT->Show(); $this->FileUpload1->Show(); $this->Label6->Show(); $this->FileUpload2->Show(); $this->Label5->Show(); $this->Status->Show(); $this->Megjegyzes->Show(); $this->TimeStampInsert->Show(); $this->Insert_User_ID->Show(); $this->TimeStampUpdate->Show(); $this->Update_User_ID->Show(); $this->Label1->Show(); $this->Label2->Show(); $this->Label3->Show(); $this->Label4->Show(); $this->Panel1->Show(); $this->Button_Update->Show(); $this->Button_Insert->Show(); $this->Button_Delete->Show(); $this->Button_Cancel->Show(); $this->IandO->Show(); $Tpl->parse(); $Tpl->block_path = $ParentPath; $this->DataSource->close(); } //End Show Method } //End repules Class @36-FCB6E20C class clsrepulesDataSource extends clsDBConnection1 { //repulesDataSource Class @36-89038C6B //DataSource Variables @36-A3B8B9B1 public $Parent = ""; public $CCSEvents = ""; public $CCSEventResult; public $ErrorBlock; public $CmdExecution; public $InsertParameters; public $UpdateParameters; public $DeleteParameters; public $wp; public $AllParametersSet; public $InsertFields = array(); public $UpdateFields = array(); // Datasource fields public $LNev; public $Sorszam; public $SportoloID; public $SportoloKlub_azon; public $LlAJSTROM; public $TipusIndex; public $LajstromID; public $Datum; public $ListBox1; public $Hidden1; public $TAVHOSSZ; public $INDULAS; public $ERKEZES; public $Buntetes; public $Sebesseg; public $PONT; public $OSSZPONT; public $FileUpload1; public $Label6; public $FileUpload2; public $Label5; public $Status; public $Megjegyzes; public $TimeStampInsert; public $Insert_User_ID; public $TimeStampUpdate; public $Update_User_ID; public $Label1; public $Label2; public $Label3; public $Label4; public $IandO; //End DataSource Variables //DataSourceClass_Initialize Event @36-C9077B9F function clsrepulesDataSource(& $Parent) { $this->Parent = & $Parent; $this->ErrorBlock = "Record repules/Error"; $this->Initialize(); $this->LNev = new clsField("LNev", ccsText, ""); $this->Sorszam = new clsField("Sorszam", ccsInteger, ""); $this->SportoloID = new clsField("SportoloID", ccsInteger, ""); $this->SportoloKlub_azon = new clsField("SportoloKlub_azon", ccsInteger, ""); $this->LlAJSTROM = new clsField("LlAJSTROM", ccsText, ""); $this->TipusIndex = new clsField("TipusIndex", ccsText, ""); $this->LajstromID = new clsField("LajstromID", ccsInteger, ""); $this->Datum = new clsField("Datum", ccsText, ""); $this->ListBox1 = new clsField("ListBox1", ccsText, ""); $this->Hidden1 = new clsField("Hidden1", ccsText, ""); $this->TAVHOSSZ = new clsField("TAVHOSSZ", ccsFloat, ""); $this->INDULAS = new clsField("INDULAS", ccsDate, array("H", ":", "nn", ":", "ss")); $this->ERKEZES = new clsField("ERKEZES", ccsDate, array("H", ":", "nn", ":", "ss")); $this->Buntetes = new clsField("Buntetes", ccsInteger, ""); $this->Sebesseg = new clsField("Sebesseg", ccsFloat, ""); $this->PONT = new clsField("PONT", ccsInteger, ""); $this->OSSZPONT = new clsField("OSSZPONT", ccsInteger, ""); $this->FileUpload1 = new clsField("FileUpload1", ccsText, ""); $this->Label6 = new clsField("Label6", ccsText, ""); $this->FileUpload2 = new clsField("FileUpload2", ccsText, ""); $this->Label5 = new clsField("Label5", ccsText, ""); $this->Status = new clsField("Status", ccsText, ""); $this->Megjegyzes = new clsField("Megjegyzes", ccsText, ""); $this->TimeStampInsert = new clsField("TimeStampInsert", ccsDate, array("yyyy", "-", "mm", "-", "dd", " ", "HH", ":", "nn", ":", "ss")); $this->Insert_User_ID = new clsField("Insert_User_ID", ccsInteger, ""); $this->TimeStampUpdate = new clsField("TimeStampUpdate", ccsDate, array("yyyy", "-", "mm", "-", "dd", " ", "HH", ":", "nn", ":", "ss")); $this->Update_User_ID = new clsField("Update_User_ID", ccsInteger, ""); $this->Label1 = new clsField("Label1", ccsText, ""); $this->Label2 = new clsField("Label2", ccsText, ""); $this->Label3 = new clsField("Label3", ccsText, ""); $this->Label4 = new clsField("Label4", ccsText, ""); $this->IandO = new clsField("IandO", ccsText, ""); $this->InsertFields["SportoloID"] = array("Name" => "SportoloID", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); $this->InsertFields["Sorszam"] = array("Name" => "Sorszam", "Value" => "", "DataType" => ccsInteger, "OmitIfEmpty" => 1); $this->InsertFields["SportoloID"] = array("Name" => "SportoloID", "Value" => "", "DataType" => ccsInteger, "OmitIfEmpty" => 1); $this->InsertFields["SportoloKlub_azon"] = array("Name" => "SportoloKlub_azon", "Value" => "", "DataType" => ccsInteger, "OmitIfEmpty" => 1); $this->InsertFields["LajstromID"] = array("Name" => "LajstromID", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); $this->InsertFields["TipusIndex"] = array("Name" => "TipusIndex", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); $this->InsertFields["LajstromID"] = array("Name" => "LajstromID", "Value" => "", "DataType" => ccsInteger, "OmitIfEmpty" => 1); $this->InsertFields["DATUM"] = array("Name" => "DATUM", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); $this->InsertFields["CELSZAB"] = array("Name" => "CELSZAB", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); $this->InsertFields["TipusIndex"] = array("Name" => "TipusIndex", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); $this->InsertFields["TAVHOSSZ"] = array("Name" => "TAVHOSSZ", "Value" => "", "DataType" => ccsFloat, "OmitIfEmpty" => 1); $this->InsertFields["INDULAS"] = array("Name" => "INDULAS", "Value" => "", "DataType" => ccsDate, "OmitIfEmpty" => 1); $this->InsertFields["ERKEZES"] = array("Name" => "ERKEZES", "Value" => "", "DataType" => ccsDate, "OmitIfEmpty" => 1); $this->InsertFields["BuntetesID"] = array("Name" => "BuntetesID", "Value" => "", "DataType" => ccsInteger, "OmitIfEmpty" => 1); $this->InsertFields["SEBESSEG"] = array("Name" => "SEBESSEG", "Value" => "", "DataType" => ccsFloat, "OmitIfEmpty" => 1); $this->InsertFields["PONT"] = array("Name" => "PONT", "Value" => "", "DataType" => ccsInteger, "OmitIfEmpty" => 1); $this->InsertFields["OSSZPONT"] = array("Name" => "OSSZPONT", "Value" => "", "DataType" => ccsInteger, "OmitIfEmpty" => 1); $this->InsertFields["LoggerFileNeve"] = array("Name" => "LoggerFileNeve", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); $this->InsertFields["TaskoltFileNeve"] = array("Name" => "TaskoltFileNeve", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); $this->InsertFields["Status"] = array("Name" => "Status", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); $this->InsertFields["Megjegyzes"] = array("Name" => "Megjegyzes", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); $this->InsertFields["TimeStampInsert"] = array("Name" => "TimeStampInsert", "Value" => "", "DataType" => ccsDate, "OmitIfEmpty" => 1); $this->InsertFields["Insert_User_ID"] = array("Name" => "Insert_User_ID", "Value" => "", "DataType" => ccsInteger, "OmitIfEmpty" => 1); $this->InsertFields["TimeStampUpdate"] = array("Name" => "TimeStampUpdate", "Value" => "", "DataType" => ccsDate, "OmitIfEmpty" => 1); $this->InsertFields["Update_User_ID"] = array("Name" => "Update_User_ID", "Value" => "", "DataType" => ccsInteger, "OmitIfEmpty" => 1); $this->InsertFields["IandO"] = array("Name" => "IandO", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); $this->UpdateFields["SportoloID"] = array("Name" => "SportoloID", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); $this->UpdateFields["Sorszam"] = array("Name" => "Sorszam", "Value" => "", "DataType" => ccsInteger, "OmitIfEmpty" => 1); $this->UpdateFields["SportoloID"] = array("Name" => "SportoloID", "Value" => "", "DataType" => ccsInteger, "OmitIfEmpty" => 1); $this->UpdateFields["SportoloKlub_azon"] = array("Name" => "SportoloKlub_azon", "Value" => "", "DataType" => ccsInteger, "OmitIfEmpty" => 1); $this->UpdateFields["LajstromID"] = array("Name" => "LajstromID", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); $this->UpdateFields["TipusIndex"] = array("Name" => "TipusIndex", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); $this->UpdateFields["LajstromID"] = array("Name" => "LajstromID", "Value" => "", "DataType" => ccsInteger, "OmitIfEmpty" => 1); $this->UpdateFields["DATUM"] = array("Name" => "DATUM", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); $this->UpdateFields["CELSZAB"] = array("Name" => "CELSZAB", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); $this->UpdateFields["TipusIndex"] = array("Name" => "TipusIndex", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); $this->UpdateFields["TAVHOSSZ"] = array("Name" => "TAVHOSSZ", "Value" => "", "DataType" => ccsFloat, "OmitIfEmpty" => 1); $this->UpdateFields["INDULAS"] = array("Name" => "INDULAS", "Value" => "", "DataType" => ccsDate, "OmitIfEmpty" => 1); $this->UpdateFields["ERKEZES"] = array("Name" => "ERKEZES", "Value" => "", "DataType" => ccsDate, "OmitIfEmpty" => 1); $this->UpdateFields["BuntetesID"] = array("Name" => "BuntetesID", "Value" => "", "DataType" => ccsInteger, "OmitIfEmpty" => 1); $this->UpdateFields["SEBESSEG"] = array("Name" => "SEBESSEG", "Value" => "", "DataType" => ccsFloat, "OmitIfEmpty" => 1); $this->UpdateFields["PONT"] = array("Name" => "PONT", "Value" => "", "DataType" => ccsInteger, "OmitIfEmpty" => 1); $this->UpdateFields["OSSZPONT"] = array("Name" => "OSSZPONT", "Value" => "", "DataType" => ccsInteger, "OmitIfEmpty" => 1); $this->UpdateFields["LoggerFileNeve"] = array("Name" => "LoggerFileNeve", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); $this->UpdateFields["TaskoltFileNeve"] = array("Name" => "TaskoltFileNeve", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); $this->UpdateFields["Status"] = array("Name" => "Status", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); $this->UpdateFields["Megjegyzes"] = array("Name" => "Megjegyzes", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); $this->UpdateFields["TimeStampInsert"] = array("Name" => "TimeStampInsert", "Value" => "", "DataType" => ccsDate, "OmitIfEmpty" => 1); $this->UpdateFields["Insert_User_ID"] = array("Name" => "Insert_User_ID", "Value" => "", "DataType" => ccsInteger, "OmitIfEmpty" => 1); $this->UpdateFields["TimeStampUpdate"] = array("Name" => "TimeStampUpdate", "Value" => "", "DataType" => ccsDate, "OmitIfEmpty" => 1); $this->UpdateFields["Update_User_ID"] = array("Name" => "Update_User_ID", "Value" => "", "DataType" => ccsInteger, "OmitIfEmpty" => 1); $this->UpdateFields["IandO"] = array("Name" => "IandO", "Value" => "", "DataType" => ccsText, "OmitIfEmpty" => 1); } //End DataSourceClass_Initialize Event //Prepare Method @36-C6736E1B function Prepare() { global $CCSLocales; global $DefaultDateFormat; $this->wp = new clsSQLParameters($this->ErrorBlock); $this->wp->AddParameter("1", "urlID", ccsInteger, "", "", $this->Parameters["urlID"], "", false); $this->AllParametersSet = $this->wp->AllParamsSet(); $this->wp->Criterion[1] = $this->wp->Operation(opEqual, "ID", $this->wp->GetDBValue("1"), $this->ToSQL($this->wp->GetDBValue("1"), ccsInteger),false); $this->Where = $this->wp->Criterion[1]; } //End Prepare Method //Open Method @36-58A71CF5 function Open() { $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent); $this->SQL = "SELECT * \n\n" . "FROM repules {SQL_Where} {SQL_OrderBy}"; $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent); $this->PageSize = 1; $this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order))); $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent); } //End Open Method //SetValues Method @36-19F4F664 function SetValues() { $this->LNev->SetDBValue($this->f("SportoloID")); $this->Sorszam->SetDBValue(trim($this->f("Sorszam"))); $this->SportoloID->SetDBValue(trim($this->f("SportoloID"))); $this->SportoloKlub_azon->SetDBValue(trim($this->f("SportoloKlub_azon"))); $this->LlAJSTROM->SetDBValue($this->f("LajstromID")); $this->TipusIndex->SetDBValue($this->f("TipusIndex")); $this->LajstromID->SetDBValue(trim($this->f("LajstromID"))); $this->Datum->SetDBValue($this->f("DATUM")); $this->ListBox1->SetDBValue($this->f("CELSZAB")); $this->Hidden1->SetDBValue($this->f("TipusIndex")); $this->TAVHOSSZ->SetDBValue(trim($this->f("TAVHOSSZ"))); $this->INDULAS->SetDBValue(trim($this->f("INDULAS"))); $this->ERKEZES->SetDBValue(trim($this->f("ERKEZES"))); $this->Buntetes->SetDBValue(trim($this->f("BuntetesID"))); $this->Sebesseg->SetDBValue(trim($this->f("SEBESSEG"))); $this->PONT->SetDBValue(trim($this->f("PONT"))); $this->OSSZPONT->SetDBValue(trim($this->f("OSSZPONT"))); $this->FileUpload1->SetDBValue($this->f("LoggerFileNeve")); $this->Label6->SetDBValue($this->f("LoggerFileNeve")); $this->FileUpload2->SetDBValue($this->f("TaskoltFileNeve")); $this->Label5->SetDBValue($this->f("TaskoltFileNeve")); $this->Status->SetDBValue($this->f("Status")); $this->Megjegyzes->SetDBValue($this->f("Megjegyzes")); $this->TimeStampInsert->SetDBValue(trim($this->f("TimeStampInsert"))); $this->Insert_User_ID->SetDBValue(trim($this->f("Insert_User_ID"))); $this->TimeStampUpdate->SetDBValue(trim($this->f("TimeStampUpdate"))); $this->Update_User_ID->SetDBValue(trim($this->f("Update_User_ID"))); $this->Label1->SetDBValue($this->f("TimeStampInsert")); $this->Label2->SetDBValue($this->f("Insert_User_ID")); $this->Label3->SetDBValue($this->f("TimeStampUpdate")); $this->Label4->SetDBValue($this->f("Update_User_ID")); $this->IandO->SetDBValue($this->f("IandO")); } //End SetValues Method //Insert Method @36-2B774C56 function Insert() { global $CCSLocales; global $DefaultDateFormat; $this->CmdExecution = true; $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $this->Parent); $this->InsertFields["SportoloID"]["Value"] = $this->LNev->GetDBValue(true); $this->InsertFields["Sorszam"]["Value"] = $this->Sorszam->GetDBValue(true); $this->InsertFields["SportoloID"]["Value"] = $this->SportoloID->GetDBValue(true); $this->InsertFields["SportoloKlub_azon"]["Value"] = $this->SportoloKlub_azon->GetDBValue(true); $this->InsertFields["LajstromID"]["Value"] = $this->LlAJSTROM->GetDBValue(true); $this->InsertFields["TipusIndex"]["Value"] = $this->TipusIndex->GetDBValue(true); $this->InsertFields["LajstromID"]["Value"] = $this->LajstromID->GetDBValue(true); $this->InsertFields["DATUM"]["Value"] = $this->Datum->GetDBValue(true); $this->InsertFields["CELSZAB"]["Value"] = $this->ListBox1->GetDBValue(true); $this->InsertFields["TipusIndex"]["Value"] = $this->Hidden1->GetDBValue(true); $this->InsertFields["TAVHOSSZ"]["Value"] = $this->TAVHOSSZ->GetDBValue(true); $this->InsertFields["INDULAS"]["Value"] = $this->INDULAS->GetDBValue(true); $this->InsertFields["ERKEZES"]["Value"] = $this->ERKEZES->GetDBValue(true); $this->InsertFields["BuntetesID"]["Value"] = $this->Buntetes->GetDBValue(true); $this->InsertFields["SEBESSEG"]["Value"] = $this->Sebesseg->GetDBValue(true); $this->InsertFields["PONT"]["Value"] = $this->PONT->GetDBValue(true); $this->InsertFields["OSSZPONT"]["Value"] = $this->OSSZPONT->GetDBValue(true); $this->InsertFields["LoggerFileNeve"]["Value"] = $this->FileUpload1->GetDBValue(true); $this->InsertFields["TaskoltFileNeve"]["Value"] = $this->FileUpload2->GetDBValue(true); $this->InsertFields["Status"]["Value"] = $this->Status->GetDBValue(true); $this->InsertFields["Megjegyzes"]["Value"] = $this->Megjegyzes->GetDBValue(true); $this->InsertFields["TimeStampInsert"]["Value"] = $this->TimeStampInsert->GetDBValue(true); $this->InsertFields["Insert_User_ID"]["Value"] = $this->Insert_User_ID->GetDBValue(true); $this->InsertFields["TimeStampUpdate"]["Value"] = $this->TimeStampUpdate->GetDBValue(true); $this->InsertFields["Update_User_ID"]["Value"] = $this->Update_User_ID->GetDBValue(true); $this->InsertFields["IandO"]["Value"] = $this->IandO->GetDBValue(true); $this->SQL = CCBuildInsert("repules", $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); } } //End Insert Method //Update Method @36-0FC837DB function Update() { global $CCSLocales; global $DefaultDateFormat; $this->CmdExecution = true; $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent); $this->UpdateFields["SportoloID"]["Value"] = $this->LNev->GetDBValue(true); $this->UpdateFields["Sorszam"]["Value"] = $this->Sorszam->GetDBValue(true); $this->UpdateFields["SportoloID"]["Value"] = $this->SportoloID->GetDBValue(true); $this->UpdateFields["SportoloKlub_azon"]["Value"] = $this->SportoloKlub_azon->GetDBValue(true); $this->UpdateFields["LajstromID"]["Value"] = $this->LlAJSTROM->GetDBValue(true); $this->UpdateFields["TipusIndex"]["Value"] = $this->TipusIndex->GetDBValue(true); $this->UpdateFields["LajstromID"]["Value"] = $this->LajstromID->GetDBValue(true); $this->UpdateFields["DATUM"]["Value"] = $this->Datum->GetDBValue(true); $this->UpdateFields["CELSZAB"]["Value"] = $this->ListBox1->GetDBValue(true); $this->UpdateFields["TipusIndex"]["Value"] = $this->Hidden1->GetDBValue(true); $this->UpdateFields["TAVHOSSZ"]["Value"] = $this->TAVHOSSZ->GetDBValue(true); $this->UpdateFields["INDULAS"]["Value"] = $this->INDULAS->GetDBValue(true); $this->UpdateFields["ERKEZES"]["Value"] = $this->ERKEZES->GetDBValue(true); $this->UpdateFields["BuntetesID"]["Value"] = $this->Buntetes->GetDBValue(true); $this->UpdateFields["SEBESSEG"]["Value"] = $this->Sebesseg->GetDBValue(true); $this->UpdateFields["PONT"]["Value"] = $this->PONT->GetDBValue(true); $this->UpdateFields["OSSZPONT"]["Value"] = $this->OSSZPONT->GetDBValue(true); $this->UpdateFields["LoggerFileNeve"]["Value"] = $this->FileUpload1->GetDBValue(true); $this->UpdateFields["TaskoltFileNeve"]["Value"] = $this->FileUpload2->GetDBValue(true); $this->UpdateFields["Status"]["Value"] = $this->Status->GetDBValue(true); $this->UpdateFields["Megjegyzes"]["Value"] = $this->Megjegyzes->GetDBValue(true); $this->UpdateFields["TimeStampInsert"]["Value"] = $this->TimeStampInsert->GetDBValue(true); $this->UpdateFields["Insert_User_ID"]["Value"] = $this->Insert_User_ID->GetDBValue(true); $this->UpdateFields["TimeStampUpdate"]["Value"] = $this->TimeStampUpdate->GetDBValue(true); $this->UpdateFields["Update_User_ID"]["Value"] = $this->Update_User_ID->GetDBValue(true); $this->UpdateFields["IandO"]["Value"] = $this->IandO->GetDBValue(true); $this->SQL = CCBuildUpdate("repules", $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); } } //End Update Method //Delete Method @36-B3D13D6F function Delete() { global $CCSLocales; global $DefaultDateFormat; $this->CmdExecution = true; $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildDelete", $this->Parent); $this->SQL = "DELETE FROM repules"; $this->SQL = CCBuildSQL($this->SQL, $this->Where, ""); if (!strlen($this->Where) && $this->Errors->Count() == 0) $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters")); $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteDelete", $this->Parent); if($this->Errors->Count() == 0 && $this->CmdExecution) { $this->query($this->SQL); $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteDelete", $this->Parent); } } //End Delete Method } //End repulesDataSource Class @36-FCB6E20C //Initialize Page @1-40452BDC // Variables $FileName = ""; $Redirect = ""; $Tpl = ""; $TemplateFileName = ""; $BlockToParse = ""; $ComponentName = ""; $Attributes = ""; // Events; $CCSEvents = ""; $CCSEventResult = ""; $FileName = FileName; $Redirect = ""; $TemplateFileName = "repules_maint.html"; $BlockToParse = "main"; $TemplateEncoding = "UTF-8"; $ContentType = "text/html"; $PathToRoot = "./"; $Charset = $Charset ? $Charset : "utf-8"; //End Initialize Page //Authenticate User @1-16D2EFE2 CCSecurityRedirect("90;70;60;50", ""); //End Authenticate User //Include events file @1-63BE5334 include_once("./repules_maint_events.php"); //End Include events file //Before Initialize @1-E870CEBC $CCSEventResult = CCGetEvent($CCSEvents, "BeforeInitialize", $MainPage); //End Before Initialize //Initialize Objects @1-3E0A92E9 $DBConnection1 = new clsDBConnection1(); $MainPage->Connections["Connection1"] = & $DBConnection1; $Attributes = new clsAttributes("page:"); $MainPage->Attributes = & $Attributes; // Controls $repules = new clsRecordrepules("", $MainPage); $MainPage->repules = & $repules; $repules->Initialize(); BindEvents(); $CCSEventResult = CCGetEvent($CCSEvents, "AfterInitialize", $MainPage); if ($Charset) { header("Content-Type: " . $ContentType . "; charset=" . $Charset); } else { header("Content-Type: " . $ContentType); } //End Initialize Objects //Initialize HTML Template @1-A06E9207 $CCSEventResult = CCGetEvent($CCSEvents, "OnInitializeView", $MainPage); $Tpl = new clsTemplate($FileEncoding, $TemplateEncoding); $Tpl->LoadTemplate(PathToCurrentPage . $TemplateFileName, $BlockToParse, "UTF-8", "replace"); $Tpl->block_path = "/$BlockToParse"; $CCSEventResult = CCGetEvent($CCSEvents, "BeforeShow", $MainPage); $Attributes->SetValue("pathToRoot", ""); $Attributes->Show(); //End Initialize HTML Template //Execute Components @1-A952DCA6 $repules->Operation(); //End Execute Components //Go to destination page @1-A1CE5D80 if($Redirect) { $CCSEventResult = CCGetEvent($CCSEvents, "BeforeUnload", $MainPage); $DBConnection1->close(); header("Location: " . $Redirect); unset($repules); unset($Tpl); exit; } //End Go to destination page //Show Page @1-A482ED5A $repules->Show(); $Tpl->block_path = ""; $Tpl->Parse($BlockToParse, false); if (!isset($main_block)) $main_block = $Tpl->GetVar($BlockToParse); $OTPOHDLL8L2K0R7A = "