|
 |
| |
พี่ๆ ครับ ผมขอถามเรื่อง insert timestamp หรือ time เวลา ณ ปัจจุบันหน่อยครับ ควรใส่ตรงไหนดี |
| |
 |
|
|
 |
 |
|
insert timestamp หรือ time เวลา ณ ปัจจุบัน อ่ะ ครับควรใส่ตรงไหนดีครับ
DB = My_calendar
TB = events
Field = custom_TextBox2
ช่วยบอกเด็กน้อยหน่อยครับ ขอบคุณครับ 
<<events.php>>
<?php
//Include Common Files @1-BF44B150
define("RelativePath", ".");
define("PathToCurrentPage", "/");
define("FileName", "events.php");
include(RelativePath . "/Common.php");
include(RelativePath . "/Template.php");
include(RelativePath . "/Sorter.php");
include(RelativePath . "/Navigator.php");
include(RelativePath . "/invite.php");
//End Include Common Files
//Include Page implementation @2-8EACA429
include_once(RelativePath . "/header.php");
//End Include Page implementation
//Include Page implementation @4-D3FCB384
include_once(RelativePath . "/vertical_menu.php");
//End Include Page implementation
class clsRecordevents_rec { //events_rec Class @5-048CC98A
//Variables @5-0DF9B1C2
// Public variables
var $ComponentType = "Record";
var $ComponentName;
var $Parent;
var $HTMLFormAction;
var $PressedButton;
var $Errors;
var $ErrorBlock;
var $FormSubmitted;
var $FormEnctype;
var $Visible;
var $IsEmpty;
var $CCSEvents = "";
var $CCSEventResult;
var $RelativePath = "";
var $InsertAllowed = false;
var $UpdateAllowed = false;
var $DeleteAllowed = false;
var $ReadAllowed = false;
var $EditMode = false;
var $ds;
var $DataSource;
var $ValidatingControls;
var $Controls;
// Class variables
//End Variables
//Class_Initialize Event @5-FB244E51
function clsRecordevents_rec($RelativePath, & $Parent)
{
global $FileName;
global $CCSLocales;
global $DefaultDateFormat;
$this->Visible = true;
$this->Parent = & $Parent;
$this->RelativePath = $RelativePath;
$this->Errors = new clsErrors();
$this->ErrorBlock = "Record events_rec/Error";
$this->DataSource = new clsevents_recDataSource($this);
$this->ds = & $this->DataSource;
$this->InsertAllowed = true;
$this->UpdateAllowed = true;
$this->DeleteAllowed = true;
$this->ReadAllowed = true;
if($this->Visible)
{
$this->ComponentName = "events_rec";
$CCSForm = split(":", CCGetFromGet("ccsForm", ""), 2);
if(sizeof($CCSForm) == 1)
$CCSForm[1] = "";
list($FormName, $FormMethod) = $CCSForm;
$this->EditMode = ($FormMethod == "Edit");
$this->FormEnctype = "application/x-www-form-urlencoded";
$this->FormSubmitted = ($FormName == $this->ComponentName);
$Method = $this->FormSubmitted ? ccsPost : ccsGet;
$this->category_id = & new clsControl(ccsListBox, "category_id", $CCSLocales->GetText("cal_category"), ccsInteger, "", CCGetRequestParam("category_id", $Method, NULL), $this);
$this->category_id->Required = true;
$this->category_id->DSType = dsTable;
list($this->category_id->BoundColumn, $this->category_id->TextColumn, $this->category_id->DBFormat) = array("category_id", "category_name", "");
$this->category_id->DataSource = new clsDBcalendar();
$this->category_id->ds = & $this->category_id->DataSource;
$this->category_id->DataSource->SQL = "SELECT category_id, category_name FROM categories_langs {SQL_Where} {SQL_OrderBy}";
$this->category_id->DataSource->Order = "seq";
$this->category_id->DataSource->Parameters["seslocale"] = CCGetSession("locale", NULL);
$this->category_id->DataSource->wp = new clsSQLParameters();
$this->category_id->DataSource->wp->AddParameter("1", "seslocale", ccsText, "", "", $this->category_id->DataSource->Parameters["seslocale"], "", false);
$this->category_id->DataSource->wp->Criterion[1] = $this->category_id->DataSource->wp->Operation(opEqual, "language_id", $this->category_id->DataSource->wp->GetDBValue("1"), $this->category_id->DataSource->ToSQL($this->category_id->DataSource->wp->GetDBValue("1"), ccsText),false);
$this->category_id->DataSource->Where = $this->category_id->DataSource->wp->Criterion[1];
$this->event_title = & new clsControl(ccsTextBox, "event_title", $CCSLocales->GetText("event_title"), ccsText, "", CCGetRequestParam("event_title", $Method, NULL), $this);
$this->event_title->Required = true;
$this->event_desc = & new clsControl(ccsTextArea, "event_desc", $CCSLocales->GetText("event_desc"), ccsMemo, "", CCGetRequestParam("event_desc", $Method, NULL), $this);
$this->event_desc->Required = true;
$this->event_time_hrs = & new clsControl(ccsListBox, "event_time_hrs", "event_time_hrs", ccsText, "", CCGetRequestParam("event_time_hrs", $Method, NULL), $this);
$this->event_time_hrs->DSType = dsListOfValues;
$this->event_time_hrs->Values = array(array("00", "12 AM"), array("01", "01 AM"), array("02", "02 AM"), array("03", "03 AM"), array("04", "04 AM"), array("05", "05 AM"), array("06", "06 AM"), array("07", "07 AM"), array("08", "08 AM"), array("09", "09 AM"), array("10", "10 AM"), array("11", "11 AM"), array("12", "12 PM"), array("13", "01 PM"), array("14", "02 PM"), array("15", "03 PM"), array("16", "04 PM"), array("17", "05 PM"), array("18", "06 PM"), array("19", "07 PM"), array("20", "08 PM"), array("21", "09 PM"), array("22", "10 PM"), array("23", "11 PM"));
$this->event_time_mns = & new clsControl(ccsListBox, "event_time_mns", "event_time_mns", ccsText, "", CCGetRequestParam("event_time_mns", $Method, NULL), $this);
$this->event_time_mns->DSType = dsListOfValues;
$this->event_time_mns->Values = array(array("00", "00"), array("05", "05"), array("10", "10"), array("15", "15"), array("20", "20"), array("25", "25"), array("30", "30"), array("35", "35"), array("40", "40"), array("45", "45"), array("50", "50"), array("55", "55"));
$this->time_hrs_end = & new clsControl(ccsListBox, "time_hrs_end", "time_hrs_end", ccsText, "", CCGetRequestParam("time_hrs_end", $Method, NULL), $this);
$this->time_hrs_end->DSType = dsListOfValues;
$this->time_hrs_end->Values = array(array("00", "12 AM"), array("01", "01 AM"), array("02", "02 AM"), array("03", "03 AM"), array("04", "04 AM"), array("05", "05 AM"), array("06", "06 AM"), array("07", "07 AM"), array("08", "08 AM"), array("09", "09 AM"), array("10", "10 AM"), array("11", "11 AM"), array("12", "12 PM"), array("13", "01 PM"), array("14", "02 PM"), array("15", "03 PM"), array("16", "04 PM"), array("17", "05 PM"), array("18", "06 PM"), array("19", "07 PM"), array("20", "08 PM"), array("21", "09 PM"), array("22", "10 PM"), array("23", "11 PM"));
$this->time_mns_end = & new clsControl(ccsListBox, "time_mns_end", "time_mns_end", ccsText, "", CCGetRequestParam("time_mns_end", $Method, NULL), $this);
$this->time_mns_end->DSType = dsListOfValues;
$this->time_mns_end->Values = array(array("00", "00"), array("05", "05"), array("10", "10"), array("15", "15"), array("20", "20"), array("25", "25"), array("30", "30"), array("35", "35"), array("40", "40"), array("45", "45"), array("50", "50"), array("55", "55"));
$this->allday = & new clsControl(ccsCheckBox, "allday", "allday", ccsInteger, "", CCGetRequestParam("allday", $Method, NULL), $this);
$this->allday->CheckedValue = $this->allday->GetParsedValue(1);
$this->allday->UncheckedValue = $this->allday->GetParsedValue(0);
$this->event_date = & new clsControl(ccsTextBox, "event_date", $CCSLocales->GetText("event_date"), ccsDate, array("ShortDate"), CCGetRequestParam("event_date", $Method, NULL), $this);
$this->event_date->Required = true;
$this->DatePicker_event_date = & new clsDatePicker("DatePicker_event_date", "events_rec", "event_date", $this);
$this->RepeatEvent = & new clsControl(ccsCheckBox, "RepeatEvent", "RepeatEvent", ccsInteger, "", CCGetRequestParam("RepeatEvent", $Method, NULL), $this);
$this->RepeatEvent->CheckedValue = $this->RepeatEvent->GetParsedValue(1);
$this->RepeatEvent->UncheckedValue = $this->RepeatEvent->GetParsedValue(0);
$this->RepeatNum = & new clsControl(ccsTextBox, "RepeatNum", $CCSLocales->GetText("Every"), ccsText, "", CCGetRequestParam("RepeatNum", $Method, NULL), $this);
$this->RepeatType = & new clsControl(ccsListBox, "RepeatType", "RepeatType", ccsText, "", CCGetRequestParam("RepeatType", $Method, NULL), $this);
$this->RepeatType->DSType = dsListOfValues;
$this->RepeatType->Values = array(array("0", "Day"), array("8", "Week"), array("30", "Month"), array("1", "Sunday"), array("2", "Monday"), array("3", "Tuesday"), array("4", "Wednesday"), array("5", "Thursday"), array("6", "Friday"), array("7", "Saturday"));
$this->event_todate = & new clsControl(ccsTextBox, "event_todate", $CCSLocales->GetText("End_By"), ccsDate, array("ShortDate"), CCGetRequestParam("event_todate", $Method, NULL), $this);
$this->DatePicker_event_todate = & new clsDatePicker("DatePicker_event_todate", "events_rec", "event_todate", $this);
$this->event_is_public = & new clsControl(ccsCheckBox, "event_is_public", $CCSLocales->GetText("event_is_public"), ccsInteger, "", CCGetRequestParam("event_is_public", $Method, NULL), $this);
$this->event_is_public->CheckedValue = $this->event_is_public->GetParsedValue(1);
$this->event_is_public->UncheckedValue = $this->event_is_public->GetParsedValue(0);
$this->PanelLocation = & new clsPanel("PanelLocation", $this);
$this->LabelLocation = & new clsControl(ccsLabel, "LabelLocation", "LabelLocation", ccsText, "", CCGetRequestParam("LabelLocation", $Method, NULL), $this);
$this->event_location = & new clsControl(ccsTextArea, "event_location", $CCSLocales->GetText("event_location"), ccsText, "", CCGetRequestParam("event_location", $Method, NULL), $this);
$this->event_location->Required = true;
$this->PanelCost = & new clsPanel("PanelCost", $this);
$this->LabelCost = & new clsControl(ccsLabel, "LabelCost", "LabelCost", ccsText, "", CCGetRequestParam("LabelCost", $Method, NULL), $this);
$this->event_cost = & new clsControl(ccsTextBox, "event_cost", "event_cost", ccsText, "", CCGetRequestParam("event_cost", $Method, NULL), $this);
$this->PanelURL = & new clsPanel("PanelURL", $this);
$this->LabelURL = & new clsControl(ccsLabel, "LabelURL", "LabelURL", ccsText, "", CCGetRequestParam("LabelURL", $Method, NULL), $this);
$this->event_URL = & new clsControl(ccsTextBox, "event_URL", "event_URL", ccsText, "", CCGetRequestParam("event_URL", $Method, NULL), $this);
$this->Public = & new clsPanel("Public", $this);
$this->PanelTextBox1 = & new clsPanel("PanelTextBox1", $this);
$this->LabelTextBox1 = & new clsControl(ccsLabel, "LabelTextBox1", "LabelTextBox1", ccsText, "", CCGetRequestParam("LabelTextBox1", $Method, NULL), $this);
$this->TextBox1 = & new clsControl(ccsTextBox, "TextBox1", $CCSLocales->GetText("textbox1"), ccsText, "", CCGetRequestParam("TextBox1", $Method, NULL), $this);
$this->TextBox1->Required = true;
$this->PanelTextBox2 = & new clsPanel("PanelTextBox2", $this);
$this->LabelTextBox2 = & new clsControl(ccsLabel, "LabelTextBox2", "LabelTextBox2", ccsDate, "", CCGetRequestParam("LabelTextBox2", $Method, NULL), $this);
$this->TextBox2 = & new clsControl(ccsDate, "TextBox2", "TextBox2", ccsDate, "", CCGetRequestParam("TextBox2", $Method, NULL), $this);
$this->PanelTextBox3 = & new clsPanel("PanelTextBox3", $this);
$this->LabelTextBox3 = & new clsControl(ccsLabel, "LabelTextBox3", "LabelTextBox3", ccsText, "", CCGetRequestParam("LabelTextBox3", $Method, NULL), $this);
$this->TextBox3 = & new clsControl(ccsTextBox, "TextBox3", "TextBox3", ccsText, "", CCGetRequestParam("TextBox3", $Method, NULL), $this);
$this->PanelTextArea1 = & new clsPanel("PanelTextArea1", $this);
$this->LabelTextArea1 = & new clsControl(ccsLabel, "LabelTextArea1", "LabelTextArea1", ccsText, "", CCGetRequestParam("LabelTextArea1", $Method, NULL), $this);
$this->TextArea1 = & new clsControl(ccsTextArea, "TextArea1", "TextArea1", ccsText, "", CCGetRequestParam("TextArea1", $Method, NULL), $this);
$this->PanelTextArea2 = & new clsPanel("PanelTextArea2", $this);
$this->LabelTextArea2 = & new clsControl(ccsLabel, "LabelTextArea2", "LabelTextArea2", ccsText, "", CCGetRequestParam("LabelTextArea2", $Method, NULL), $this);
$this->TextArea2 = & new clsControl(ccsTextArea, "TextArea2", "TextArea2", ccsText, "", CCGetRequestParam("TextArea2", $Method, NULL), $this);
$this->PanelTextArea3 = & new clsPanel("PanelTextArea3", $this);
$this->LabelTextArea3 = & new clsControl(ccsLabel, "LabelTextArea3", "LabelTextArea3", ccsText, "", CCGetRequestParam("LabelTextArea3", $Method, NULL), $this);
$this->TextArea3 = & new clsControl(ccsTextArea, "TextArea3", "TextArea3", ccsText, "", CCGetRequestParam("TextArea3", $Method, NULL), $this);
$this->PanelCheckBox1 = & new clsPanel("PanelCheckBox1", $this);
$this->LabelCheckBox1 = & new clsControl(ccsLabel, "LabelCheckBox1", "LabelCheckBox1", ccsText, "", CCGetRequestParam("LabelCheckBox1", $Method, NULL), $this);
$this->CheckBox1 = & new clsControl(ccsCheckBox, "CheckBox1", "CheckBox1", ccsInteger, "", CCGetRequestParam("CheckBox1", $Method, NULL), $this);
$this->CheckBox1->CheckedValue = $this->CheckBox1->GetParsedValue(1);
$this->CheckBox1->UncheckedValue = $this->CheckBox1->GetParsedValue(0);
$this->PanelCheckBox2 = & new clsPanel("PanelCheckBox2", $this);
$this->LabelCheckBox2 = & new clsControl(ccsLabel, "LabelCheckBox2", "LabelCheckBox2", ccsText, "", CCGetRequestParam("LabelCheckBox2", $Method, NULL), $this);
$this->CheckBox2 = & new clsControl(ccsCheckBox, "CheckBox2", "CheckBox2", ccsInteger, "", CCGetRequestParam("CheckBox2", $Method, NULL), $this);
$this->CheckBox2->CheckedValue = $this->CheckBox2->GetParsedValue(1);
$this->CheckBox2->UncheckedValue = $this->CheckBox2->GetParsedValue(0);
$this->PanelCheckBox3 = & new clsPanel("PanelCheckBox3", $this);
$this->LabelCheckBox3 = & new clsControl(ccsLabel, "LabelCheckBox3", "LabelCheckBox3", ccsText, "", CCGetRequestParam("LabelCheckBox3", $Method, NULL), $this);
$this->CheckBox3 = & new clsControl(ccsCheckBox, "CheckBox3", "CheckBox3", ccsInteger, "", CCGetRequestParam("CheckBox3", $Method, NULL), $this);
$this->CheckBox3->CheckedValue = $this->CheckBox3->GetParsedValue(1);
$this->CheckBox3->UncheckedValue = $this->CheckBox3->GetParsedValue(0);
$this->PanelRecurrentSubmit = & new clsPanel("PanelRecurrentSubmit", $this);
$this->RecurrentApply = & new clsControl(ccsCheckBox, "RecurrentApply", "RecurrentApply", ccsInteger, "", CCGetRequestParam("RecurrentApply", $Method, NULL), $this);
$this->RecurrentApply->CheckedValue = $this->RecurrentApply->GetParsedValue(1);
$this->RecurrentApply->UncheckedValue = $this->RecurrentApply->GetParsedValue(0);
$this->event_parent_id = & new clsControl(ccsHidden, "event_parent_id", "event_parent_id", ccsText, "", CCGetRequestParam("event_parent_id", $Method, NULL), $this);
$this->user_id = & new clsControl(ccsHidden, "user_id", "user_id", ccsInteger, "", CCGetRequestParam("user_id", $Method, NULL), $this);
$this->event_time = & new clsControl(ccsHidden, "event_time", "event_time", ccsDate, array("HH", ":", "nn"), CCGetRequestParam("event_time", $Method, NULL), $this);
$this->event_time_end = & new clsControl(ccsHidden, "event_time_end", "event_time_end", ccsDate, array("HH", ":", "nn"), CCGetRequestParam("event_time_end", $Method, NULL), $this);
$this->Button_Insert = & new clsButton("Button_Insert", $Method, $this);
$this->Button_Update = & new clsButton("Button_Update", $Method, $this);
$this->Button_Delete = & new clsButton("Button_Delete", $Method, $this);
$this->Button_Cancel = & new clsButton("Button_Cancel", $Method, $this);
$this->PanelLocation->AddComponent("LabelLocation", $this->LabelLocation);
$this->PanelLocation->AddComponent("event_location", $this->event_location);
$this->PanelCost->AddComponent("LabelCost", $this->LabelCost);
$this->PanelCost->AddComponent("event_cost", $this->event_cost);
$this->PanelURL->AddComponent("LabelURL", $this->LabelURL);
$this->PanelURL->AddComponent("event_URL", $this->event_URL);
$this->PanelTextBox1->AddComponent("LabelTextBox1", $this->LabelTextBox1);
$this->PanelTextBox1->AddComponent("TextBox1", $this->TextBox1);
$this->PanelTextBox2->AddComponent("LabelTextBox2", $this->LabelTextBox2);
$this->PanelTextBox2->AddComponent("TextBox2", $this->TextBox2);
$this->PanelTextBox3->AddComponent("LabelTextBox3", $this->LabelTextBox3);
$this->PanelTextBox3->AddComponent("TextBox3", $this->TextBox3);
$this->PanelTextArea1->AddComponent("LabelTextArea1", $this->LabelTextArea1);
$this->PanelTextArea1->AddComponent("TextArea1", $this->TextArea1);
$this->PanelTextArea2->AddComponent("LabelTextArea2", $this->LabelTextArea2);
$this->PanelTextArea2->AddComponent("TextArea2", $this->TextArea2);
$this->PanelTextArea3->AddComponent("LabelTextArea3", $this->LabelTextArea3);
$this->PanelTextArea3->AddComponent("TextArea3", $this->TextArea3);
$this->PanelCheckBox1->AddComponent("LabelCheckBox1", $this->LabelCheckBox1);
$this->PanelCheckBox1->AddComponent("CheckBox1", $this->CheckBox1);
$this->PanelCheckBox2->AddComponent("LabelCheckBox2", $this->LabelCheckBox2);
$this->PanelCheckBox2->AddComponent("CheckBox2", $this->CheckBox2);
$this->PanelCheckBox3->AddComponent("LabelCheckBox3", $this->LabelCheckBox3);
$this->PanelCheckBox3->AddComponent("CheckBox3", $this->CheckBox3);
$this->PanelRecurrentSubmit->AddComponent("RecurrentApply", $this->RecurrentApply);
$this->PanelRecurrentSubmit->AddComponent("event_parent_id", $this->event_parent_id);
/* begin bank update 18-03-2011 */
$this->users = & new clsControl(ccsListBox, "users", "users", ccsInteger, "", CCGetRequestParam("users", $Method, NULL), $this);
$this->users->Multiple = true;
$this->users->DSType = dsTable;
list($this->users->BoundColumn, $this->users->TextColumn, $this->users->DBFormat) = array("user_id", "user_alias", "");
$this->users->DataSource = new clsDBcalendar();
$this->users->ds = & $this->users->DataSource;
$this->categories->DataSource->wp = new clsSQLParameters();
/*$this->users->DataSource->SQL = "SELECT user_alias, user_id FROM users {SQL_Where} {SQL_OrderBy}";
$this->users->DataSource->wp->Criterion[1] = $this->categories->DataSource->wp->Operation(opNotEqual, "user_id", 1, 1,false);
$this->users->DataSource->Where = $this->users->DataSource->wp->Criterion[1];
$this->users->DataSource->Order = "seq, user_alias";
*/
$this->users->DataSource->SQL = "SELECT user_alias, user_id, user_type FROM users where user_type ='A' AND user_id<>1";
$this->users->DataSource->Order = "seq, user_alias";
if(!$this->FormSubmitted) {
if(!is_array($this->RepeatNum->Value) && !strlen($this->RepeatNum->Value) && $this->RepeatNum->Value !== false)
$this->RepeatNum->SetText(1);
if(!is_array($this->event_is_public->Value) && !strlen($this->event_is_public->Value) && $this->event_is_public->Value !== false)
$this->event_is_public->SetValue(true);
}
}
}
//End Class_Initialize Event
//Initialize Method @5-DBAE778D
function Initialize()
{
if(!$this->Visible)
return;
$this->DataSource->Parameters["urlevent_id"] = CCGetFromGet("event_id", NULL);
}
//End Initialize Method
//Validate Method @5-A61C073A
function Validate()
{
global $CCSLocales;
$Validation = true;
$Where = "";
$Validation = ($this->category_id->Validate() && $Validation);
$Validation = ($this->event_title->Validate() && $Validation);
$Validation = ($this->event_desc->Validate() && $Validation);
$Validation = ($this->event_time_hrs->Validate() && $Validation);
$Validation = ($this->event_time_mns->Validate() && $Validation);
$Validation = ($this->time_hrs_end->Validate() && $Validation);
$Validation = ($this->time_mns_end->Validate() && $Validation);
$Validation = ($this->allday->Validate() && $Validation);
$Validation = ($this->event_date->Validate() && $Validation);
$Validation = ($this->RepeatEvent->Validate() && $Validation);
$Validation = ($this->RepeatNum->Validate() && $Validation);
$Validation = ($this->RepeatType->Validate() && $Validation);
$Validation = ($this->event_todate->Validate() && $Validation);
$Validation = ($this->event_is_public->Validate() && $Validation);
$Validation = ($this->event_location->Validate() && $Validation);
$Validation = ($this->event_cost->Validate() && $Validation);
$Validation = ($this->event_URL->Validate() && $Validation);
$Validation = ($this->TextBox1->Validate() && $Validation);
$Validation = ($this->TextBox2->Validate() && $Validation);
$Validation = ($this->TextBox3->Validate() && $Validation);
$Validation = ($this->TextArea1->Validate() && $Validation);
$Validation = ($this->TextArea2->Validate() && $Validation);
$Validation = ($this->TextArea3->Validate() && $Validation);
$Validation = ($this->CheckBox1->Validate() && $Validation);
$Validation = ($this->CheckBox2->Validate() && $Validation);
$Validation = ($this->CheckBox3->Validate() && $Validation);
$Validation = ($this->RecurrentApply->Validate() && $Validation);
$Validation = ($this->event_parent_id->Validate() && $Validation);
$Validation = ($this->user_id->Validate() && $Validation);
$Validation = ($this->event_time->Validate() && $Validation);
$Validation = ($this->event_time_end->Validate() && $Validation);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "OnValidate", $this);
$Validation = $Validation && ($this->category_id->Errors->Count() == 0);
$Validation = $Validation && ($this->event_title->Errors->Count() == 0);
$Validation = $Validation && ($this->event_desc->Errors->Count() == 0);
$Validation = $Validation && ($this->event_time_hrs->Errors->Count() == 0);
$Validation = $Validation && ($this->event_time_mns->Errors->Count() == 0);
$Validation = $Validation && ($this->time_hrs_end->Errors->Count() == 0);
$Validation = $Validation && ($this->time_mns_end->Errors->Count() == 0);
$Validation = $Validation && ($this->allday->Errors->Count() == 0);
$Validation = $Validation && ($this->event_date->Errors->Count() == 0);
$Validation = $Validation && ($this->RepeatEvent->Errors->Count() == 0);
$Validation = $Validation && ($this->RepeatNum->Errors->Count() == 0);
$Validation = $Validation && ($this->RepeatType->Errors->Count() == 0);
$Validation = $Validation && ($this->event_todate->Errors->Count() == 0);
$Validation = $Validation && ($this->event_is_public->Errors->Count() == 0);
$Validation = $Validation && ($this->event_location->Errors->Count() == 0);
$Validation = $Validation && ($this->event_cost->Errors->Count() == 0);
$Validation = $Validation && ($this->event_URL->Errors->Count() == 0);
$Validation = $Validation && ($this->TextBox1->Errors->Count() == 0);
$Validation = $Validation && ($this->TextBox2->Errors->Count() == 0);
$Validation = $Validation && ($this->TextBox3->Errors->Count() == 0);
$Validation = $Validation && ($this->TextArea1->Errors->Count() == 0);
$Validation = $Validation && ($this->TextArea2->Errors->Count() == 0);
$Validation = $Validation && ($this->TextArea3->Errors->Count() == 0);
$Validation = $Validation && ($this->CheckBox1->Errors->Count() == 0);
$Validation = $Validation && ($this->CheckBox2->Errors->Count() == 0);
$Validation = $Validation && ($this->CheckBox3->Errors->Count() == 0);
$Validation = $Validation && ($this->RecurrentApply->Errors->Count() == 0);
$Validation = $Validation && ($this->event_parent_id->Errors->Count() == 0);
$Validation = $Validation && ($this->user_id->Errors->Count() == 0);
$Validation = $Validation && ($this->event_time->Errors->Count() == 0);
$Validation = $Validation && ($this->event_time_end->Errors->Count() == 0);
return (($this->Errors->Count() == 0) && $Validation);
}
//End Validate Method
//CheckErrors Method @5-C3316752
function CheckErrors()
{
$errors = false;
$errors = ($errors || $this->category_id->Errors->Count());
$errors = ($errors || $this->event_title->Errors->Count());
$errors = ($errors || $this->event_desc->Errors->Count());
$errors = ($errors || $this->event_time_hrs->Errors->Count());
$errors = ($errors || $this->event_time_mns->Errors->Count());
$errors = ($errors || $this->time_hrs_end->Errors->Count());
$errors = ($errors || $this->time_mns_end->Errors->Count());
$errors = ($errors || $this->allday->Errors->Count());
$errors = ($errors || $this->event_date->Errors->Count());
$errors = ($errors || $this->DatePicker_event_date->Errors->Count());
$errors = ($errors || $this->RepeatEvent->Errors->Count());
$errors = ($errors || $this->RepeatNum->Errors->Count());
$errors = ($errors || $this->RepeatType->Errors->Count());
$errors = ($errors || $this->event_todate->Errors->Count());
$errors = ($errors || $this->DatePicker_event_todate->Errors->Count());
$errors = ($errors || $this->event_is_public->Errors->Count());
$errors = ($errors || $this->LabelLocation->Errors->Count());
$errors = ($errors || $this->event_location->Errors->Count());
$errors = ($errors || $this->LabelCost->Errors->Count());
$errors = ($errors || $this->event_cost->Errors->Count());
$errors = ($errors || $this->LabelURL->Errors->Count());
$errors = ($errors || $this->event_URL->Errors->Count());
$errors = ($errors || $this->LabelTextBox1->Errors->Count());
$errors = ($errors || $this->TextBox1->Errors->Count());
$errors = ($errors || $this->LabelTextBox2->Errors->Count());
$errors = ($errors || $this->TextBox2->Errors->Count());
$errors = ($errors || $this->LabelTextBox3->Errors->Count());
$errors = ($errors || $this->TextBox3->Errors->Count());
$errors = ($errors || $this->LabelTextArea1->Errors->Count());
$errors = ($errors || $this->TextArea1->Errors->Count());
$errors = ($errors || $this->LabelTextArea2->Errors->Count());
$errors = ($errors || $this->TextArea2->Errors->Count());
$errors = ($errors || $this->LabelTextArea3->Errors->Count());
$errors = ($errors || $this->TextArea3->Errors->Count());
$errors = ($errors || $this->LabelCheckBox1->Errors->Count());
$errors = ($errors || $this->CheckBox1->Errors->Count());
$errors = ($errors || $this->LabelCheckBox2->Errors->Count());
$errors = ($errors || $this->CheckBox2->Errors->Count());
$errors = ($errors || $this->LabelCheckBox3->Errors->Count());
$errors = ($errors || $this->CheckBox3->Errors->Count());
$errors = ($errors || $this->RecurrentApply->Errors->Count());
$errors = ($errors || $this->event_parent_id->Errors->Count());
$errors = ($errors || $this->user_id->Errors->Count());
$errors = ($errors || $this->event_time->Errors->Count());
$errors = ($errors || $this->event_time_end->Errors->Count());
$errors = ($errors || $this->Errors->Count());
$errors = ($errors || $this->DataSource->Errors->Count());
return $errors;
}
//End CheckErrors Method
//Operation Method @5-AF47A9F6
function Operation()
{
if(!$this->Visible)
return;
global $Redirect;
global $FileName;
$this->DataSource->Prepare();
if(!$this->FormSubmitted) {
$this->EditMode = $this->DataSource->AllParametersSet;
return;
}
if($this->FormSubmitted) {
$this->PressedButton = $this->EditMode ? "Button_Update" : "Button_Insert";
if($this->Button_Insert->Pressed) {
$this->PressedButton = "Button_Insert";
} else if($this->Button_Update->Pressed) {
$this->PressedButton = "Button_Update";
} else if($this->Button_Delete->Pressed) {
$this->PressedButton = "Button_Delete";
} else if($this->Button_Cancel->Pressed) {
$this->PressedButton = "Button_Cancel";
}
}
$Redirect = "index.php";
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 == "Button_Insert") {
if(!CCGetEvent($this->Button_Insert->CCSEvents, "OnClick", $this->Button_Insert) || !$this->InsertRow()) {
$Redirect = "";
}
} else if($this->PressedButton == "Button_Update") {
if(!CCGetEvent($this->Button_Update->CCSEvents, "OnClick", $this->Button_Update) || !$this->UpdateRow()) {
$Redirect = "";
}
}
} else {
$Redirect = "";
}
if ($Redirect)
$this->DataSource->close();
}
//End Operation Method
//InsertRow Method @5-B982C1D1
function InsertRow()
{
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeInsert", $this);
if(!$this->InsertAllowed) return false;
$this->DataSource->category_id->SetValue($this->category_id->GetValue(true));
$this->DataSource->event_title->SetValue($this->event_title->GetValue(true));
$this->DataSource->event_desc->SetValue($this->event_desc->GetValue(true));
$this->DataSource->event_time_hrs->SetValue($this->event_time_hrs->GetValue(true));
$this->DataSource->event_time_mns->SetValue($this->event_time_mns->GetValue(true));
$this->DataSource->time_hrs_end->SetValue($this->time_hrs_end->GetValue(true));
$this->DataSource->time_mns_end->SetValue($this->time_mns_end->GetValue(true));
$this->DataSource->allday->SetValue($this->allday->GetValue(true));
$this->DataSource->event_date->SetValue($this->event_date->GetValue(true));
$this->DataSource->RepeatEvent->SetValue($this->RepeatEvent->GetValue(true));
$this->DataSource->RepeatNum->SetValue($this->RepeatNum->GetValue(true));
$this->DataSource->RepeatType->SetValue($this->RepeatType->GetValue(true));
$this->DataSource->event_todate->SetValue($this->event_todate->GetValue(true));
$this->DataSource->event_is_public->SetValue($this->event_is_public->GetValue(true));
$this->DataSource->LabelLocation->SetValue($this->LabelLocation->GetValue(true));
$this->DataSource->event_location->SetValue($this->event_location->GetValue(true));
$this->DataSource->LabelCost->SetValue($this->LabelCost->GetValue(true));
$this->DataSource->event_cost->SetValue($this->event_cost->GetValue(true));
$this->DataSource->LabelURL->SetValue($this->LabelURL->GetValue(true));
$this->DataSource->event_URL->SetValue($this->event_URL->GetValue(true));
$this->DataSource->LabelTextBox1->SetValue($this->LabelTextBox1->GetValue(true));
$this->DataSource->TextBox1->SetValue($this->TextBox1->GetValue(true));
$this->DataSource->LabelTextBox2->SetValue($this->LabelTextBox2->GetValue(true));
$this->DataSource->TextBox2->SetValue($this->TextBox2->GetValue(true));
$this->DataSource->LabelTextBox3->SetValue($this->LabelTextBox3->GetValue(true));
$this->DataSource->TextBox3->SetValue($this->TextBox3->GetValue(true));
$this->DataSource->LabelTextArea1->SetValue($this->LabelTextArea1->GetValue(true));
$this->DataSource->TextArea1->SetValue($this->TextArea1->GetValue(true));
$this->DataSource->LabelTextArea2->SetValue($this->LabelTextArea2->GetValue(true));
$this->DataSource->TextArea2->SetValue($this->TextArea2->GetValue(true));
$this->DataSource->LabelTextArea3->SetValue($this->LabelTextArea3->GetValue(true));
$this->DataSource->TextArea3->SetValue($this->TextArea3->GetValue(true));
$this->DataSource->LabelCheckBox1->SetValue($this->LabelCheckBox1->GetValue(true));
$this->DataSource->CheckBox1->SetValue($this->CheckBox1->GetValue(true));
$this->DataSource->LabelCheckBox2->SetValue($this->LabelCheckBox2->GetValue(true));
$this->DataSource->CheckBox2->SetValue($this->CheckBox2->GetValue(true));
$this->DataSource->LabelCheckBox3->SetValue($this->LabelCheckBox3->GetValue(true));
$this->DataSource->CheckBox3->SetValue($this->CheckBox3->GetValue(true));
$this->DataSource->RecurrentApply->SetValue($this->RecurrentApply->GetValue(true));
$this->DataSource->event_parent_id->SetValue($this->event_parent_id->GetValue(true));
$this->DataSource->user_id->SetValue($this->user_id->GetValue(true));
$this->DataSource->event_time->SetValue($this->event_time->GetValue(true));
$this->DataSource->event_time_end->SetValue($this->event_time_end->GetValue(true));
$this->DataSource->Insert();
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterInsert", $this);
return (!$this->CheckErrors());
}
//End InsertRow Method
//UpdateRow Method @5-C7C8D0FE
function UpdateRow()
{
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeUpdate", $this);
if(!$this->UpdateAllowed) return false;
$this->DataSource->category_id->SetValue($this->category_id->GetValue(true));
$this->DataSource->event_title->SetValue($this->event_title->GetValue(true));
$this->DataSource->event_desc->SetValue($this->event_desc->GetValue(true));
$this->DataSource->event_time_hrs->SetValue($this->event_time_hrs->GetValue(true));
$this->DataSource->event_time_mns->SetValue($this->event_time_mns->GetValue(true));
$this->DataSource->time_hrs_end->SetValue($this->time_hrs_end->GetValue(true));
$this->DataSource->time_mns_end->SetValue($this->time_mns_end->GetValue(true));
$this->DataSource->allday->SetValue($this->allday->GetValue(true));
$this->DataSource->event_date->SetValue($this->event_date->GetValue(true));
$this->DataSource->RepeatEvent->SetValue($this->RepeatEvent->GetValue(true));
$this->DataSource->RepeatNum->SetValue($this->RepeatNum->GetValue(true));
$this->DataSource->RepeatType->SetValue($this->RepeatType->GetValue(true));
$this->DataSource->event_todate->SetValue($this->event_todate->GetValue(true));
$this->DataSource->event_is_public->SetValue($this->event_is_public->GetValue(true));
$this->DataSource->LabelLocation->SetValue($this->LabelLocation->GetValue(true));
$this->DataSource->event_location->SetValue($this->event_location->GetValue(true));
$this->DataSource->LabelCost->SetValue($this->LabelCost->GetValue(true));
$this->DataSource->event_cost->SetValue($this->event_cost->GetValue(true));
$this->DataSource->LabelURL->SetValue($this->LabelURL->GetValue(true));
$this->DataSource->event_URL->SetValue($this->event_URL->GetValue(true));
$this->DataSource->LabelTextBox1->SetValue($this->LabelTextBox1->GetValue(true));
$this->DataSource->TextBox1->SetValue($this->TextBox1->GetValue(true));
$this->DataSource->LabelTextBox2->SetValue($this->LabelTextBox2->GetValue(true));
$this->DataSource->TextBox2->SetValue($this->TextBox2->GetValue(true));
$this->DataSource->LabelTextBox3->SetValue($this->LabelTextBox3->GetValue(true));
$this->DataSource->TextBox3->SetValue($this->TextBox3->GetValue(true));
$this->DataSource->LabelTextArea1->SetValue($this->LabelTextArea1->GetValue(true));
$this->DataSource->TextArea1->SetValue($this->TextArea1->GetValue(true));
$this->DataSource->LabelTextArea2->SetValue($this->LabelTextArea2->GetValue(true));
$this->DataSource->TextArea2->SetValue($this->TextArea2->GetValue(true));
$this->DataSource->LabelTextArea3->SetValue($this->LabelTextArea3->GetValue(true));
$this->DataSource->TextArea3->SetValue($this->TextArea3->GetValue(true));
$this->DataSource->LabelCheckBox1->SetValue($this->LabelCheckBox1->GetValue(true));
$this->DataSource->CheckBox1->SetValue($this->CheckBox1->GetValue(true));
$this->DataSource->LabelCheckBox2->SetValue($this->LabelCheckBox2->GetValue(true));
$this->DataSource->CheckBox2->SetValue($this->CheckBox2->GetValue(true));
$this->DataSource->LabelCheckBox3->SetValue($this->LabelCheckBox3->GetValue(true));
$this->DataSource->CheckBox3->SetValue($this->CheckBox3->GetValue(true));
$this->DataSource->RecurrentApply->SetValue($this->RecurrentApply->GetValue(true));
$this->DataSource->event_parent_id->SetValue($this->event_parent_id->GetValue(true));
$this->DataSource->user_id->SetValue($this->user_id->GetValue(true));
$this->DataSource->event_time->SetValue($this->event_time->GetValue(true));
$this->DataSource->event_time_end->SetValue($this->event_time_end->GetValue(true));
$this->DataSource->Update();
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterUpdate", $this);
return (!$this->CheckErrors());
}
//End UpdateRow Method
//DeleteRow Method @5-299D98C3
function DeleteRow()
{
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeDelete", $this);
if(!$this->DeleteAllowed) return false;
$this->DataSource->Delete();
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterDelete", $this);
return (!$this->CheckErrors());
}
//End DeleteRow Method
//Show Method @5-EA4858F7
function Show()
{
global $Tpl;
global $FileName;
global $CCSLocales;
$Error = "";
if(!$this->Visible)
return;
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeSelect", $this);
$this->category_id->Prepare();
$this->event_time_hrs->Prepare();
$this->event_time_mns->Prepare();
$this->time_hrs_end->Prepare();
$this->time_mns_end->Prepare();
$this->RepeatType->Prepare();
$this->users->Prepare(); //bank update 18-03-2011
$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();
if(!$this->FormSubmitted){
$this->category_id->SetValue($this->DataSource->category_id->GetValue());
$this->event_title->SetValue($this->DataSource->event_title->GetValue());
$this->event_desc->SetValue($this->DataSource->event_desc->GetValue());
$this->event_date->SetValue($this->DataSource->event_date->GetValue());
$this->event_is_public->SetValue($this->DataSource->event_is_public->GetValue());
$this->event_location->SetValue($this->DataSource->event_location->GetValue());
$this->event_cost->SetValue($this->DataSource->event_cost->GetValue());
$this->event_URL->SetValue($this->DataSource->event_URL->GetValue());
$this->TextBox1->SetValue($this->DataSource->TextBox1->GetValue());
$this->TextBox2->SetValue($this->DataSource->TextBox2->GetValue());
$this->TextBox3->SetValue($this->DataSource->TextBox3->GetValue());
$this->TextArea1->SetValue($this->DataSource->TextArea1->GetValue());
$this->TextArea2->SetValue($this->DataSource->TextArea2->GetValue());
$this->TextArea3->SetValue($this->DataSource->TextArea3->GetValue());
$this->CheckBox1->SetValue($this->DataSource->CheckBox1->GetValue());
$this->CheckBox2->SetValue($this->DataSource->CheckBox2->GetValue());
$this->CheckBox3->SetValue($this->DataSource->CheckBox3->GetValue());
$this->event_parent_id->SetValue($this->DataSource->event_parent_id->GetValue());
$this->user_id->SetValue($this->DataSource->user_id->GetValue());
$this->event_time->SetValue($this->DataSource->event_time->GetValue());
$this->event_time_end->SetValue($this->DataSource->event_time_end->GetValue());
}
} else {
$this->EditMode = false;
}
}
if (!$this->FormSubmitted) {
}
if($this->FormSubmitted || $this->CheckErrors()) {
$Error = "";
$Error = ComposeStrings($Error, $this->category_id->Errors->ToString());
$Error = ComposeStrings($Error, $this->TextBox1->Errors->ToString());
$Error = ComposeStrings($Error, $this->event_location->Errors->ToString());
$Error = ComposeStrings($Error, $this->event_title->Errors->ToString());
$Error = ComposeStrings($Error, $this->event_desc->Errors->ToString());
$Error = ComposeStrings($Error, $this->event_time_hrs->Errors->ToString());
$Error = ComposeStrings($Error, $this->event_time_mns->Errors->ToString());
$Error = ComposeStrings($Error, $this->time_hrs_end->Errors->ToString());
$Error = ComposeStrings($Error, $this->time_mns_end->Errors->ToString());
$Error = ComposeStrings($Error, $this->allday->Errors->ToString());
$Error = ComposeStrings($Error, $this->event_date->Errors->ToString());
$Error = ComposeStrings($Error, $this->DatePicker_event_date->Errors->ToString());
$Error = ComposeStrings($Error, $this->RepeatEvent->Errors->ToString());
$Error = ComposeStrings($Error, $this->RepeatNum->Errors->ToString());
$Error = ComposeStrings($Error, $this->RepeatType->Errors->ToString());
$Error = ComposeStrings($Error, $this->event_todate->Errors->ToString());
$Error = ComposeStrings($Error, $this->DatePicker_event_todate->Errors->ToString());
$Error = ComposeStrings($Error, $this->event_is_public->Errors->ToString());
$Error = ComposeStrings($Error, $this->LabelLocation->Errors->ToString());
$Error = ComposeStrings($Error, $this->LabelCost->Errors->ToString());
$Error = ComposeStrings($Error, $this->event_cost->Errors->ToString());
$Error = ComposeStrings($Error, $this->LabelURL->Errors->ToString());
$Error = ComposeStrings($Error, $this->event_URL->Errors->ToString());
$Error = ComposeStrings($Error, $this->LabelTextBox1->Errors->ToString());
$Error = ComposeStrings($Error, $this->LabelTextBox2->Errors->ToString());
$Error = ComposeStrings($Error, $this->TextBox2->Errors->ToString());
$Error = ComposeStrings($Error, $this->LabelTextBox3->Errors->ToString());
$Error = ComposeStrings($Error, $this->TextBox3->Errors->ToString());
$Error = ComposeStrings($Error, $this->LabelTextArea1->Errors->ToString());
$Error = ComposeStrings($Error, $this->TextArea1->Errors->ToString());
$Error = ComposeStrings($Error, $this->LabelTextArea2->Errors->ToString());
$Error = ComposeStrings($Error, $this->TextArea2->Errors->ToString());
$Error = ComposeStrings($Error, $this->LabelTextArea3->Errors->ToString());
$Error = ComposeStrings($Error, $this->TextArea3->Errors->ToString());
$Error = ComposeStrings($Error, $this->LabelCheckBox1->Errors->ToString());
$Error = ComposeStrings($Error, $this->CheckBox1->Errors->ToString());
$Error = ComposeStrings($Error, $this->LabelCheckBox2->Errors->ToString());
$Error = ComposeStrings($Error, $this->CheckBox2->Errors->ToString());
$Error = ComposeStrings($Error, $this->LabelCheckBox3->Errors->ToString());
$Error = ComposeStrings($Error, $this->CheckBox3->Errors->ToString());
$Error = ComposeStrings($Error, $this->RecurrentApply->Errors->ToString());
$Error = ComposeStrings($Error, $this->event_parent_id->Errors->ToString());
$Error = ComposeStrings($Error, $this->user_id->Errors->ToString());
$Error = ComposeStrings($Error, $this->event_time->Errors->ToString());
$Error = ComposeStrings($Error, $this->event_time_end->Errors->ToString());
$Error = ComposeStrings($Error, $this->Errors->ToString());
$Error = ComposeStrings($Error, $this->DataSource->Errors->ToString());
$Error = ComposeStrings($Error, $this->users->Errors->ToString()); //bank update 18-03-2011
$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", $this->HTMLFormAction);
$Tpl->SetVar("HTMLFormName", $this->ComponentName);
$Tpl->SetVar("HTMLFormEnctype", $this->FormEnctype);
$this->Button_Insert->Visible = !$this->EditMode && $this->InsertAllowed;
$this->Button_Update->Visible = $this->EditMode && $this->UpdateAllowed;
$this->Button_Delete->Visible = $this->EditMode && $this->DeleteAllowed;
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeShow", $this);
if(!$this->Visible) {
$Tpl->block_path = $ParentPath;
return;
}
$this->category_id->Show();
$this->event_title->Show();
$this->event_desc->Show();
$this->event_time_hrs->Show();
$this->event_time_mns->Show();
$this->time_hrs_end->Show();
$this->time_mns_end->Show();
$this->allday->Show();
$this->event_date->Show();
$this->DatePicker_event_date->Show();
$this->RepeatEvent->Show();
$this->RepeatNum->Show();
$this->RepeatType->Show();
$this->event_todate->Show();
$this->DatePicker_event_todate->Show();
//$this->event_is_public->Show(); bank update 19-03-2011
$this->PanelLocation->Show();
//$this->PanelCost->Show(); bank update 19-03-2011
//$this->PanelURL->Show(); bank update 19-03-2011
//$this->Public->Show(); bank update 19-03-2011
$this->PanelTextBox1->Show();
$this->PanelTextBox2->Show();
$this->PanelTextBox3->Show();
$this->PanelTextArea1->Show();
$this->PanelTextArea2->Show();
$this->PanelTextArea3->Show();
$this->PanelCheckBox1->Show();
$this->PanelCheckBox2->Show();
$this->PanelCheckBox3->Show();
$this->PanelRecurrentSubmit->Show();
$this->user_id->Show();
$this->event_time->Show();
$this->event_time_end->Show();
$this->Button_Insert->Show();
$this->Button_Update->Show();
$this->Button_Delete->Show();
$this->Button_Cancel->Show();
$this->users->Show(); //bank update 18-03-2011
$Tpl->parse();
$Tpl->block_path = $ParentPath;
$this->DataSource->close();
}
//End Show Method
} //End events_rec Class @5-FCB6E20C
class clsevents_recDataSource extends clsDBcalendar { //events_recDataSource Class @5-5FCBDF1C
//DataSource Variables @5-4C559B2F
var $Parent = "";
var $CCSEvents = "";
var $CCSEventResult;
var $ErrorBlock;
var $CmdExecution;
var $InsertParameters;
var $UpdateParameters;
var $DeleteParameters;
var $wp;
var $AllParametersSet;
// Datasource fields
var $category_id;
var $event_title;
var $event_desc;
var $event_time_hrs;
var $event_time_mns;
var $time_hrs_end;
var $time_mns_end;
var $allday;
var $event_date;
var $RepeatEvent;
var $RepeatNum;
var $RepeatType;
var $event_todate;
var $event_is_public;
var $LabelLocation;
var $event_location;
var $LabelCost;
var $event_cost;
var $LabelURL;
var $event_URL;
var $LabelTextBox1;
var $TextBox1;
var $LabelTextBox2;
var $TextBox2;
var $LabelTextBox3;
var $TextBox3;
var $LabelTextArea1;
var $TextArea1;
var $LabelTextArea2;
var $TextArea2;
var $LabelTextArea3;
var $TextArea3;
var $LabelCheckBox1;
var $CheckBox1;
var $LabelCheckBox2;
var $CheckBox2;
var $LabelCheckBox3;
var $CheckBox3;
var $RecurrentApply;
var $event_parent_id;
var $user_id;
var $event_time;
var $event_time_end;
//End DataSource Variables
//DataSourceClass_Initialize Event @5-8E16046B
function clsevents_recDataSource(& $Parent)
{
$this->Parent = & $Parent;
$this->ErrorBlock = "Record events_rec/Error";
$this->Initialize();
$this->category_id = new clsField("category_id", ccsInteger, "");
$this->event_title = new clsField("event_title", ccsText, "");
$this->event_desc = new clsField("event_desc", ccsMemo, "");
$this->event_time_hrs = new clsField("event_time_hrs", ccsText, "");
$this->event_time_mns = new clsField("event_time_mns", ccsText, "");
$this->time_hrs_end = new clsField("time_hrs_end", ccsText, "");
$this->time_mns_end = new clsField("time_mns_end", ccsText, "");
$this->allday = new clsField("allday", ccsInteger, "");
$this->event_date = new clsField("event_date", ccsDate, array("yyyy", "-", "mm", "-", "dd"));
$this->RepeatEvent = new clsField("RepeatEvent", ccsInteger, "");
$this->RepeatNum = new clsField("RepeatNum", ccsText, "");
$this->RepeatType = new clsField("RepeatType", ccsText, "");
$this->event_todate = new clsField("event_todate", ccsDate, array("yyyy", "-", "mm", "-", "dd", " ", "HH", ":", "nn", ":", "ss"));
$this->event_is_public = new clsField("event_is_public", ccsInteger, "");
$this->LabelLocation = new clsField("LabelLocation", ccsText, "");
$this->event_location = new clsField("event_location", ccsText, "");
$this->LabelCost = new clsField("LabelCost", ccsText, "");
$this->event_cost = new clsField("event_cost", ccsText, "");
$this->LabelURL = new clsField("LabelURL", ccsText, "");
$this->event_URL = new clsField("event_URL", ccsText, "");
$this->LabelTextBox1 = new clsField("LabelTextBox1", ccsText, "");
$this->TextBox1 = new clsField("TextBox1", ccsText, "");
$this->LabelTextBox2 = new clsField("LabelTextBox2", ccsDate, "");
$this->TextBox2 = new clsField("TextBox2", ccsDate, "");
$this->LabelTextBox3 = new clsField("LabelTextBox3", ccsText, "");
$this->TextBox3 = new clsField("TextBox3", ccsText, "");
$this->LabelTextArea1 = new clsField("LabelTextArea1", ccsText, "");
$this->TextArea1 = new clsField("TextArea1", ccsText, "");
$this->LabelTextArea2 = new clsField("LabelTextArea2", ccsText, "");
$this->TextArea2 = new clsField("TextArea2", ccsText, "");
$this->LabelTextArea3 = new clsField("LabelTextArea3", ccsText, "");
$this->TextArea3 = new clsField("TextArea3", ccsText, "");
$this->LabelCheckBox1 = new clsField("LabelCheckBox1", ccsText, "");
$this->CheckBox1 = new clsField("CheckBox1", ccsInteger, "");
$this->LabelCheckBox2 = new clsField("LabelCheckBox2", ccsText, "");
$this->CheckBox2 = new clsField("CheckBox2", ccsInteger, "");
$this->LabelCheckBox3 = new clsField("LabelCheckBox3", ccsText, "");
$this->CheckBox3 = new clsField("CheckBox3", ccsInteger, "");
$this->RecurrentApply = new clsField("RecurrentApply", ccsInteger, "");
$this->event_parent_id = new clsField("event_parent_id", ccsText, "");
$this->user_id = new clsField("user_id", ccsInteger, "");
$this->event_time = new clsField("event_time", ccsDate, array("HH", ":", "nn", ":", "ss"));
$this->event_time_end = new clsField("event_time_end", ccsDate, array("HH", ":", "nn", ":", "ss"));
$this->InsertFields["category_id"] = array("Name" => "category_id", "Value" => "", "DataType" => ccsInteger);
$this->InsertFields["event_title"] = array("Name" => "event_title", "Value" => "", "DataType" => ccsText);
$this->InsertFields["event_desc"] = array("Name" => "event_desc", "Value" => "", "DataType" => ccsMemo);
$this->InsertFields["event_date"] = array("Name" => "event_date", "Value" => "", "DataType" => ccsDate);
$this->InsertFields["event_is_public"] = array("Name" => "event_is_public", "Value" => "", "DataType" => ccsInteger);
$this->InsertFields["event_location"] = array("Name" => "event_location", "Value" => "", "DataType" => ccsText);
$this->InsertFields["event_cost"] = array("Name" => "event_cost", "Value" => "", "DataType" => ccsText);
$this->InsertFields["event_url"] = array("Name" => "event_url", "Value" => "", "DataType" => ccsText);
$this->InsertFields["custom_TextBox1"] = array("Name" => "custom_TextBox1", "Value" => "", "DataType" => ccsText);
$this->InsertFields["custom_TextBox2"] = array("Name" => "custom_TextBox2", "Value" => "", "DataType" => ccsDate);
$this->InsertFields["custom_TextBox3"] = array("Name" => "custom_TextBox3", "Value" => "", "DataType" => ccsText);
$this->InsertFields["custom_TextArea1"] = array("Name" => "custom_TextArea1", "Value" => "", "DataType" => ccsText);
$this->InsertFields["custom_TextArea2"] = array("Name" => "custom_TextArea2", "Value" => "", "DataType" => ccsText);
$this->InsertFields["custom_TextArea3"] = array("Name" => "custom_TextArea3", "Value" => "", "DataType" => ccsText);
$this->InsertFields["custom_CheckBox1"] = array("Name" => "custom_CheckBox1", "Value" => "", "DataType" => ccsInteger);
$this->InsertFields["custom_CheckBox2"] = array("Name" => "custom_CheckBox2", "Value" => "", "DataType" => ccsInteger);
$this->InsertFields["custom_CheckBox3"] = array("Name" => "custom_CheckBox3", "Value" => "", "DataType" => ccsInteger);
$this->InsertFields["event_parent_id"] = array("Name" => "event_parent_id", "Value" => "", "DataType" => ccsText);
$this->InsertFields["user_id"] = array("Name" => "user_id", "Value" => "", "DataType" => ccsInteger);
$this->InsertFields["event_time"] = array("Name" => "event_time", "Value" => "", "DataType" => ccsDate);
$this->InsertFields["event_time_end"] = array("Name" => "event_time_end", "Value" => "", "DataType" => ccsDate);
$this->UpdateFields["category_id"] = array("Name" => "category_id", "Value" => "", "DataType" => ccsInteger);
$this->UpdateFields["event_title"] = array("Name" => "event_title", "Value" => "", "DataType" => ccsText);
$this->UpdateFields["event_desc"] = array("Name" => "event_desc", "Value" => "", "DataType" => ccsMemo);
$this->UpdateFields["event_date"] = array("Name" => "event_date", "Value" => "", "DataType" => ccsDate);
$this->UpdateFields["event_is_public"] = array("Name" => "event_is_public", "Value" => "", "DataType" => ccsInteger);
$this->UpdateFields["event_location"] = array("Name" => "event_location", "Value" => "", "DataType" => ccsText);
$this->UpdateFields["event_cost"] = array("Name" => "event_cost", "Value" => "", "DataType" => ccsText);
$this->UpdateFields["event_url"] = array("Name" => "event_url", "Value" => "", "DataType" => ccsText);
$this->UpdateFields["custom_TextBox1"] = array("Name" => "custom_TextBox1", "Value" => "", "DataType" => ccsText);
$this->UpdateFields["custom_TextBox2"] = array("Name" => "custom_TextBox2", "Value" => "", "DataType" => ccsDate);
$this->UpdateFields["custom_TextBox3"] = array("Name" => "custom_TextBox3", "Value" => "", "DataType" => ccsText);
$this->UpdateFields["custom_TextArea1"] = array("Name" => "custom_TextArea1", "Value" => "", "DataType" => ccsText);
$this->UpdateFields["custom_TextArea2"] = array("Name" => "custom_TextArea2", "Value" => "", "DataType" => ccsText);
$this->UpdateFields["custom_TextArea3"] = array("Name" => "custom_TextArea3", "Value" => "", "DataType" => ccsText);
$this->UpdateFields["custom_CheckBox1"] = array("Name" => "custom_CheckBox1", "Value" => "", "DataType" => ccsInteger);
$this->UpdateFields["custom_CheckBox2"] = array("Name" => "custom_CheckBox2", "Value" => "", "DataType" => ccsInteger);
$this->UpdateFields["custom_CheckBox3"] = array("Name" => "custom_CheckBox3", "Value" => "", "DataType" => ccsInteger);
$this->UpdateFields["event_parent_id"] = array("Name" => "event_parent_id", "Value" => "", "DataType" => ccsText);
$this->UpdateFields["user_id"] = array("Name" => "user_id", "Value" => "", "DataType" => ccsInteger);
$this->UpdateFields["event_time"] = array("Name" => "event_time", "Value" => "", "DataType" => ccsDate);
$this->UpdateFields["event_time_end"] = array("Name" => "event_time_end", "Value" => "", "DataType" => ccsDate);
}
//End DataSourceClass_Initialize Event
//Prepare Method @5-FD6E473D Update get Value Event
function Prepare()
{
global $CCSLocales;
global $DefaultDateFormat;
$this->wp = new clsSQLParameters($this->ErrorBlock);
$this->wp->AddParameter("1", "urlevent_id", ccsInteger, "", "", $this->Parameters["urlevent_id"], "", false);
$this->AllParametersSet = $this->wp->AllParamsSet();
$this->wp->Criterion[1] = $this->wp->Operation(opEqual, "event_id", $this->wp->GetDBValue("1"), $this->ToSQL($this->wp->GetDBValue("1"), ccsInteger),false);
$this->Where =
$this->wp->Criterion[1];
}
//End Prepare Method
//Open Method @5-1A1A785B
function Open()
{
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
$this->SQL = "SELECT * \n\n" .
"FROM events {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 @5-F794D616
function SetValues()
{
$this->category_id->SetDBValue(trim($this->f("category_id")));
$this->event_title->SetDBValue($this->f("event_title"));
$this->event_desc->SetDBValue($this->f("event_desc"));
$this->event_date->SetDBValue(trim($this->f("event_date")));
$this->event_is_public->SetDBValue(trim($this->f("event_is_public")));
$this->event_location->SetDBValue($this->f("event_location"));
$this->event_cost->SetDBValue($this->f("event_cost"));
$this->event_URL->SetDBValue($this->f("event_url"));
$this->TextBox1->SetDBValue($this->f("custom_TextBox1"));
$this->TextBox2->SetDBValue($this->f("custom_TextBox2"));
$this->TextBox3->SetDBValue($this->f("custom_TextBox3"));
$this->TextArea1->SetDBValue($this->f("custom_TextArea1"));
$this->TextArea2->SetDBValue($this->f("custom_TextArea2"));
$this->TextArea3->SetDBValue($this->f("custom_TextArea3"));
$this->CheckBox1->SetDBValue(trim($this->f("custom_CheckBox1")));
$this->CheckBox2->SetDBValue(trim($this->f("custom_CheckBox2")));
$this->CheckBox3->SetDBValue(trim($this->f("custom_CheckBox3")));
$this->event_parent_id->SetDBValue($this->f("event_parent_id"));
$this->user_id->SetDBValue(trim($this->f("user_id")));
$this->event_time->SetDBValue(trim($this->f("event_time")));
$this->event_time_end->SetDBValue(trim($this->f("event_time_end")));
}
//End SetValues Method
//Insert Method @5-CB5036FC
function Insert()
{
global $CCSLocales;
global $DefaultDateFormat;
$this->CmdExecution = true;
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildInsert", $this->Parent);
$this->InsertFields["category_id"]["Value"] = $this->category_id->GetDBValue(true);
$this->InsertFields["event_title"]["Value"] = $this->event_title->GetDBValue(true);
$this->InsertFields["event_desc"]["Value"] = $this->event_desc->GetDBValue(true);
$this->InsertFields["event_date"]["Value"] = $event_date = $this->event_date->GetDBValue(true);
$this->InsertFields["event_is_public"]["Value"] = $this->event_is_public->GetDBValue(true);
$this->InsertFields["event_location"]["Value"] = $this->event_location->GetDBValue(true);
$this->InsertFields["event_cost"]["Value"] = $this->event_cost->GetDBValue(true);
$this->InsertFields["event_url"]["Value"] = $this->event_URL->GetDBValue(true);
$this->InsertFields["custom_TextBox1"]["Value"] = $this->TextBox1->GetDBValue(true);
$this->InsertFields["custom_TextBox2"]["Value"] = $this->TextBox2->GetDBValue(true);
$this->InsertFields["custom_TextBox3"]["Value"] = $this->TextBox3->GetDBValue(true);
$this->InsertFields["custom_TextArea1"]["Value"] = $this->TextArea1->GetDBValue(true);
$this->InsertFields["custom_TextArea2"]["Value"] = $this->TextArea2->GetDBValue(true);
$this->InsertFields["custom_TextArea3"]["Value"] = $this->TextArea3->GetDBValue(true);
$this->InsertFields["custom_CheckBox1"]["Value"] = $this->CheckBox1->GetDBValue(true);
$this->InsertFields["custom_CheckBox2"]["Value"] = $this->CheckBox2->GetDBValue(true);
$this->InsertFields["custom_CheckBox3"]["Value"] = $this->CheckBox3->GetDBValue(true);
$this->InsertFields["event_parent_id"]["Value"] = $this->event_parent_id->GetDBValue(true);
$this->InsertFields["user_id"]["Value"] = $user_id = $this->user_id->GetDBValue(true);
$this->InsertFields["event_time"]["Value"] = $event_time = $this->event_time->GetDBValue(true);
$this->InsertFields["event_time_end"]["Value"] = $this->event_time_end->GetDBValue(true);
$this->SQL = CCBuildInsert("events", $this->InsertFields, $this);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteInsert", $this->Parent);
if($this->Errors->Count() == 0 && $this->CmdExecution) {
$this->query($this->SQL);
if (is_array($_POST["users"])) invite(md5($event_date.$user_id), $_POST["users"]); //bank
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteInsert", $this->Parent);
}
}
//End Insert Method
//Update Method @5-4B62A5ED
function Update()
{
global $CCSLocales;
global $DefaultDateFormat;
$this->CmdExecution = true;
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
$this->UpdateFields["category_id"]["Value"] = $this->category_id->GetDBValue(true);
$this->UpdateFields["event_title"]["Value"] = $this->event_title->GetDBValue(true);
$this->UpdateFields["event_desc"]["Value"] = $this->event_desc->GetDBValue(true);
$this->UpdateFields["event_date"]["Value"] = $this->event_date->GetDBValue(true);
$this->UpdateFields["event_is_public"]["Value"] = $this->event_is_public->GetDBValue(true);
$this->UpdateFields["event_location"]["Value"] = $this->event_location->GetDBValue(true);
$this->UpdateFields["event_cost"]["Value"] = $this->event_cost->GetDBValue(true);
$this->UpdateFields["event_url"]["Value"] = $this->event_URL->GetDBValue(true);
$this->UpdateFields["custom_TextBox1"]["Value"] = $this->TextBox1->GetDBValue(true);
$this->UpdateFields["custom_TextBox2"]["Value"] = $this->TextBox2->GetDBValue(true);
$this->UpdateFields["custom_TextBox3"]["Value"] = $this->TextBox3->GetDBValue(true);
$this->UpdateFields["custom_TextArea1"]["Value"] = $this->TextArea1->GetDBValue(true);
$this->UpdateFields["custom_TextArea2"]["Value"] = $this->TextArea2->GetDBValue(true);
$this->UpdateFields["custom_TextArea3"]["Value"] = $this->TextArea3->GetDBValue(true);
$this->UpdateFields["custom_CheckBox1"]["Value"] = $this->CheckBox1->GetDBValue(true);
$this->UpdateFields["custom_CheckBox2"]["Value"] = $this->CheckBox2->GetDBValue(true);
$this->UpdateFields["custom_CheckBox3"]["Value"] = $this->CheckBox3->GetDBValue(true);
$this->UpdateFields["event_parent_id"]["Value"] = $this->event_parent_id->GetDBValue(true);
$this->UpdateFields["user_id"]["Value"] = $this->user_id->GetDBValue(true);
$this->UpdateFields["event_time"]["Value"] = $this->event_time->GetDBValue(true);
$this->UpdateFields["event_time_end"]["Value"] = $this->event_time_end->GetDBValue(true);
$this->SQL = CCBuildUpdate("events", $this->UpdateFields, $this);
$this->SQL = CCBuildSQL($this->SQL, $this->Where, "");
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
if($this->Errors->Count() == 0 && $this->CmdExecution) {
$this->query($this->SQL);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
}
}
//End Update Method
//Delete Method @5-4A7849B6
function Delete()
{
global $CCSLocales;
global $DefaultDateFormat;
$this->CmdExecution = true;
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildDelete", $this->Parent);
$this->SQL = "DELETE FROM events";
$this->SQL = CCBuildSQL($this->SQL, $this->Where, "");
$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 events_recDataSource Class @5-FCB6E20C
//Include Page implementation @3-EBA5EA16
include_once(RelativePath . "/footer.php");
//End Include Page implementation
//Initialize Page @1-B9A1924C
// Variables
$FileName = "";
$Redirect = "";
$Tpl = "";
$TemplateFileName = "";
$BlockToParse = "";
$ComponentName = "";
// Events;
$CCSEvents = "";
$CCSEventResult = "";
$FileName = FileName;
$Redirect = "";
$TemplateFileName = "events.html";
$BlockToParse = "main";
$TemplateEncoding = "UTF-8";
$PathToRoot = "./";
//End Initialize Page
//Include events file @1-B9C6B0FB
include("./events_events.php");
//End Include events file
//Initialize Objects @1-19CDD8B0
$DBcalendar = new clsDBcalendar();
$MainPage->Connections["calendar"] = & $DBcalendar;
// Controls
$header = & new clsheader("", "header", $MainPage);
$header->Initialize();
$vertical_menu = & new clsvertical_menu("", "vertical_menu", $MainPage);
$vertical_menu->Initialize();
$events_rec = & new clsRecordevents_rec("", $MainPage);
$footer = & new clsfooter("", "footer", $MainPage);
$footer->Initialize();
$MainPage->header = & $header;
$MainPage->vertical_menu = & $vertical_menu;
$MainPage->events_rec = & $events_rec;
$MainPage->footer = & $footer;
$events_rec->Initialize();
BindEvents();
$CCSEventResult = CCGetEvent($CCSEvents, "AfterInitialize", $MainPage);
$Charset = $Charset ? $Charset : "utf-8";
if ($Charset)
header("Content-Type: text/html; charset=" . $Charset);
//End Initialize Objects
//Initialize HTML Template @1-885748E0
$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);
//End Initialize HTML Template
//Execute Components @1-231767AF
$header->Operations();
$vertical_menu->Operations();
$events_rec->Operation();
$footer->Operations();
//End Execute Components
//Go to destination page @1-BBB7FCAE
if($Redirect)
{
$CCSEventResult = CCGetEvent($CCSEvents, "BeforeUnload", $MainPage);
$DBcalendar->close();
header("Location: " . $Redirect);
$header->Class_Terminate();
unset($header);
$vertical_menu->Class_Terminate();
unset($vertical_menu);
unset($events_rec);
$footer->Class_Terminate();
unset($footer);
unset($Tpl);
exit;
}
//End Go to destination page
//Show Page @1-3A84DFED
$header->Show();
$vertical_menu->Show();
$events_rec->Show();
$footer->Show();
$Tpl->block_path = "";
$Tpl->Parse($BlockToParse, false);
$main_block = $Tpl->GetVar($BlockToParse);
$CCSEventResult = CCGetEvent($CCSEvents, "BeforeOutput", $MainPage);
if ($CCSEventResult) echo $main_block;
//End Show Page
//Unload Page @1-670D438E
$CCSEventResult = CCGetEvent($CCSEvents, "BeforeUnload", $MainPage);
$DBcalendar->close();
$header->Class_Terminate();
unset($header);
$vertical_menu->Class_Terminate();
unset($vertical_menu);
unset($events_rec);
$footer->Class_Terminate();
unset($footer);
unset($Tpl);
//End Unload Page
?>
events.html
<!-- begin bank update 18-03-2011 -->
<script language="javascript" type="text/javascript" src="images/upload/jquery.js"></script>
<script language="javascript" type="text/javascript" src="images/upload/jquery-ui.js"></script>
<script language="javascript" type="text/javascript" src="images/upload/jquery.multiselect.min.js"></script>
<link rel="stylesheet" type="text/css" href="images/upload/jquery.multiselect.css" />
<link rel="stylesheet" href="images/upload/ui-lightness/jquery-ui-1.8.10.custom.css">
<!-- end bank update 18-03-2011 -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<title>{res:CCS_RecordFormPrefix} {res:events}</title>
<script language="JavaScript" type="text/javascript">
var AllDayState;
var RepeatState;
window.onload = function() {
AllDayState = document.getElementById("AllDayEvent").checked;
changestate();
document.getElementById("AllDayEvent").onclick = function() {
AllDayState = !AllDayState;
changestate();
}
if (document.getElementById("RepeatEvent")) {
RepeatState = document.getElementById("RepeatEvent").checked;
HideShowRepeat();
document.getElementById("RepeatEvent").onclick = function() {
RepeatState = !RepeatState;
HideShowRepeat();
}
}
CorrectEndTime("hour");
}
function changestate() {
if (AllDayState) {
document.getElementById("hour_start").disabled = true;
document.getElementById("minute_start").disabled = true;
document.getElementById("hour_end").disabled = true;
document.getElementById("minute_end").disabled = true;
} else {
document.getElementById("hour_start").disabled = false;
document.getElementById("minute_start").disabled = false;
document.getElementById("hour_end").disabled = false;
document.getElementById("minute_end").disabled = false;
}
}
function HideShowRepeat() {
if (RepeatState) {
document.getElementById("RepeatRow1").style.display = "";
document.getElementById("RepeatRow2").style.display = "";
} else {
document.getElementById("RepeatRow1").style.display = "none";
document.getElementById("RepeatRow2").style.display = "none";
}
}
function CorrectListBoxVal(Type, flag) {
var HourStartComp = document.getElementById(Type + "_start");
var HourEndComp = document.getElementById(Type + "_end");
var CurrStartTime = flag? HourStartComp.selectedIndex : 0;
var SelEndTime = HourEndComp.selectedIndex;
var EndTimeLength = HourEndComp.options.length;
var StartTimeLength = HourStartComp.options.length;
for (var i=0; i<EndTimeLength; i++)
HourEndComp.options[0] = null;
for (i = CurrStartTime; i<StartTimeLength; i++)
HourEndComp.options[i-CurrStartTime] = new Option(HourStartComp.options[i].text, HourStartComp.options[i].value);
if (SelEndTime-CurrStartTime+StartTimeLength-EndTimeLength < 0)
HourEndComp.options[0].selected = true;
else
HourEndComp.options[SelEndTime-CurrStartTime+StartTimeLength-EndTimeLength].selected = true;
}
function CorrectEndTime(Type) {
if (Type == "hour");
CorrectListBoxVal("hour", true);
var HourStartComp = document.getElementById("hour_start");
var HourEndComp = document.getElementById("hour_end");
var CurrStartHour = HourStartComp.options.length - HourStartComp.selectedIndex;
var CurrEndHour = HourEndComp.options.length - HourEndComp.selectedIndex;
CorrectListBoxVal("minute", CurrStartHour == CurrEndHour);
}
</script>
<script language="JavaScript" type="text/javascript">
//Begin CCS script
//Include Common JSFunctions @1-CD196667
</script>
<script language="JavaScript" src="ClientI18N.php?file=DatePicker.js&locale={res:CCS_LocaleID}" type="text/javascript" charset="utf-8"></script>
<script language="JavaScript" type="text/javascript">
//End Include Common JSFunctions
//Date Picker Object Definitions @1-B949F285
var events_rec_DatePicker_event_date = new Object();
events_rec_DatePicker_event_date.format = "ShortDate";
events_rec_DatePicker_event_date.style = "Styles/{CCS_Style}/Style.css";
events_rec_DatePicker_event_date.relativePathPart = "";
events_rec_DatePicker_event_date.themeVersion = "3.0";
var events_rec_DatePicker_event_todate = new Object();
events_rec_DatePicker_event_todate.format = "ShortDate";
events_rec_DatePicker_event_todate.style = "Styles/{CCS_Style}/Style.css";
events_rec_DatePicker_event_todate.relativePathPart = "";
events_rec_DatePicker_event_todate.themeVersion = "3.0";
//End Date Picker Object Definitions
//End CCS script
</script>
<link href="Styles/{CCS_Style}/Style.css" type="text/css" rel="stylesheet">
</head>
<body>
{header}
<table cellspacing="5" cellpadding="0" border="0" align="center">
<tr>
<td valign="top">
<!-- Left column -->
{vertical_menu}</td>
<td valign="top">
<!-- Right column -->
<!-- BEGIN Record events_rec -->
<form name="{HTMLFormName}" action="{Action}" method="post">
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td valign="top">
<table class="Header" cellspacing="0" cellpadding="0" border="0">
<tr>
<td class="HeaderLeft"><img src="Styles/{CCS_Style}/Images/Spacer.gif" border="0"></td>
<th>{res:CCS_RecordFormPrefix} {res:events}
{res:CCS_RecordFormSuffix}</th>
<td class="HeaderRight"><img src="Styles/{CCS_Style}/Images/Spacer.gif" border="0"></td>
</tr>
</table>
<table class="Record" cellspacing="0" cellpadding="0">
<!-- BEGIN Error -->
<tr class="Error">
<td colspan="2">{Error}</td>
</tr>
<!-- END Error -->
<tr class="Controls">
<th>{res:cal_category} <font color="#FF0000" size="+1"><b>* </b></font></th>
<td>
<select name="{category_id_Name}">
<option value="" selected>{res:CCS_SelectValue}</option>
{category_id_Options}
</select> </td>
</tr>
<!-- BEGIN Panel PanelTextBox1 -->
<tr class="Controls">
<th>{LabelTextBox1} <font color="#FF0000" size="+1"><b>* </b></font></th>
<td><input maxlength="10" size="10" value="{TextBox1}" name="{TextBox1_Name}">
<a href="javascript:void(0);" onClick="return openPopup()">
<img src="images/upload/s_info.png" width="16" height="16" border="0"></a> (* ใส่ รหัสโครงการ)</td>
</tr>
<!-- END Panel PanelTextBox1 -->
<!-- BEGIN Panel PanelLocation -->
<tr class="Controls">
<th>{LabelLocation} <font color="#FF0000" size="+1"><b>* </b></font> </th>
<td><textarea name="{event_location_Name}" cols="50">{event_location}</textarea></td>
</tr>
<!-- END Panel PanelLocation -->
<tr class="Controls">
<!--<th>{res:event_title} *</th> bank update 19-03-2011 add whom-->
<th>{res:event_whom} <font color="#FF0000" size="+1"><b>* </b></font></th>
<td><input maxlength="100" size="50" value="{event_title}" name="{event_title_Name}"></td>
</tr>
<tr class="Controls">
<th>{res:event_desc} <font color="#FF0000" size="+1"><b>* </b></font></th>
<td><textarea name="{event_desc_Name}" rows="5" cols="50">{event_desc}</textarea></td>
</tr>
<tr class="Controls">
<th>{res:event_time}</th>
<td>
<select id="hour_start" name="{event_time_hrs_Name}" onChange="CorrectEndTime('hour');">
{event_time_hrs_Options}
</select>
:
<select id="minute_start" name="{event_time_mns_Name}" onChange="CorrectEndTime('');">
{event_time_mns_Options}
</select> </td>
</tr>
<tr class="Controls" valign="top">
<th>{res:cal_time_end}</th>
<td>
<select id="hour_end" name="{time_hrs_end_Name}" onChange="CorrectEndTime('');">
{time_hrs_end_Options}
</select>
:
<select id="minute_end" name="{time_mns_end_Name}">
{time_mns_end_Options}
</select>
<br>
<span nowrap><input id="AllDayEvent" type="checkbox" value="1" name="{allday_Name}" {allday}>{res:cal_all_day} </span></td>
</tr>
<tr class="Controls">
<th>{res:event_date} *</th>
<td><input maxlength="10" size="10" value="{event_date}" name="{event_date_Name}">
<!-- BEGIN DatePicker DatePicker_event_date --><a href="javascript:showDatePicker('{Name}','{FormName}','{DateControl}');"><img src="Styles/{CCS_Style}/Images/DatePicker.gif" border="0"></a><!-- END DatePicker DatePicker_event_date --><br> </td>
</tr>
<!-- BEGIN CheckBox RepeatEvent -->
<tr class="Controls">
<th>{res:Recurrence} </th>
<td><input id="RepeatEvent" type="checkbox" value="1" name="{RepeatEvent_Name}" {RepeatEvent}></td>
</tr>
<!-- END CheckBox RepeatEvent -->
<tr id="RepeatRow1" class="Controls" style="display:none">
<th style="border-bottom:none;text-align:right"> {res:Every}</th>
<td style="border-bottom:none"><span nowrap><input type="text" name="{RepeatNum_Name}" value="{RepeatNum}" size="5" maxlength="5">
<select name="{RepeatType_Name}">
{RepeatType_Options}
</select>
</span> </td>
</tr>
<tr id="RepeatRow2" class="Controls" style="display:none">
<th style="border-top:none;text-align:right"> {res:End_By}</th>
<td style="border-top:none"><span nowrap><input maxlength="10" size="10" value="{event_todate}" name="{event_todate_Name}">
<!-- BEGIN DatePicker DatePicker_event_todate --><a href="javascript:showDatePicker('{Name}','{FormName}','{DateControl}');"><img src="Styles/{CCS_Style}/Images/DatePicker.gif" border="0"></a><!-- END DatePicker DatePicker_event_todate --></span></td>
</tr>
<!-- BEGIN Panel Public -->
<!-- bank update 19-03-2011 -->
<tr class="Controls">
<th>{res:event_is_public}</th>
<td><input type="checkbox" value="1" name="{event_is_public_Name}" {event_is_public}>{res:event_is_public_desc} </td>
</tr>
<!-- END Panel Public -->
<tr class="Controls">
<th>{res:event_invite}</th>
<td>
<!-- BEGIN ListBox users -->
<!-- bank update 18-03-2011 <list all user> -->
<select name="{users_Name}" style="margin-bottom:3px" id="usersx" multiple="multiple">
<option value="" selected>-- {res:cal_users} --</option>
{users_Options}
</select>
<!-- END ListBox users -->
ทดลองใช้งาน</td>
</tr>
<!-- BEGIN Panel PanelCost -->
<tr class="Controls">
<th>{LabelCost}</th>
<td><input value="{event_cost}" name="{event_cost_Name}"></td>
</tr>
<!-- END Panel PanelCost -->
<!-- BEGIN Panel PanelURL -->
<tr class="Controls">
<th>{LabelURL}</th>
<td><input size="40" value="{event_URL}" name="{event_URL_Name}"></td>
</tr>
<!-- END Panel PanelURL -->
<!-- BEGIN Panel PanelTextBox2 -->
<tr class="Controls">
<th>{LabelTextBox2}</th>
<td><input name="{TextBox2_Name}" value="{TextBox2}" size="50" maxlength="100"></td>
</tr>
<!-- END Panel PanelTextBox2 -->
<!-- BEGIN Panel PanelTextBox3 -->
<tr class="Controls">
<th>{LabelTextBox3}</th>
<td><input maxlength="100" size="50" value="{TextBox3}" name="{TextBox3_Name}"></td>
</tr>
<!-- END Panel PanelTextBox3 -->
<!-- BEGIN Panel PanelTextArea1 -->
<tr class="Controls">
<th>{LabelTextArea1}</th>
<td><input name="{TextArea1_Name}" type="hidden" value="{TextArea1}" size="50"></td>
</tr>
<!-- END Panel PanelTextArea1 -->
<!-- BEGIN Panel PanelTextArea2 -->
<tr class="Controls">
<th>{LabelTextArea2}</th>
<td><textarea name="{TextArea2_Name}" cols="50">{TextArea2}</textarea></td>
</tr>
<!-- END Panel PanelTextArea2 -->
<!-- BEGIN Panel PanelTextArea3 -->
<tr class="Controls">
<th>{LabelTextArea3}</th>
<td><textarea name="{TextArea3_Name}" cols="50">{TextArea3}</textarea></td>
</tr>
<!-- END Panel PanelTextArea3 -->
<!-- BEGIN Panel PanelCheckBox1 -->
<tr class="Controls">
<th>{LabelCheckBox1}</th>
<td><input type="checkbox" value="1" name="{CheckBox1_Name}" {CheckBox1}></td>
</tr>
<!-- END Panel PanelCheckBox1 -->
<!-- BEGIN Panel PanelCheckBox2 -->
<tr class="Controls">
<th>{LabelCheckBox2}</th>
<td><input type="checkbox" value="1" name="{CheckBox2_Name}" {CheckBox2}></td>
</tr>
<!-- END Panel PanelCheckBox2 -->
<!-- BEGIN Panel PanelCheckBox3 -->
<tr class="Controls">
<th>{LabelCheckBox3}</th>
<td><input type="checkbox" value="1" name="{CheckBox3_Name}" {CheckBox3}></td>
</tr>
<!-- END Panel PanelCheckBox3 -->
<!-- BEGIN Panel PanelRecurrentSubmit -->
<tr class="Controls">
<th> </th>
<td><input type="checkbox" value="1" name="{RecurrentApply_Name}" {RecurrentApply}><b>{res:cal_RecurrentApply}</b><input type="hidden" name="{event_parent_id_Name}" value="{event_parent_id}"></td>
</tr>
<!-- END Panel PanelRecurrentSubmit -->
<tr class="Bottom">
<td align="right" colspan="2"><input type="show" value="{user_id}" name="{user_id_Name}"><input type="show" value="{event_time}" name="{event_time_Name}"><input type="show" value="{event_time_end}" name="{event_time_end_Name}">
<!-- BEGIN Button Button_Insert --><input type="image" src="Styles/{CCS_Style}/Images/{res:CCS_LanguageID}/ButtonInsert.gif" value="{res:CCS_Insert}" border="0" name="{Button_Name}"><!-- END Button Button_Insert -->
<!-- BEGIN Button Button_Update --><input type="image" src="Styles/{CCS_Style}/Images/{res:CCS_LanguageID}/ButtonUpdate.gif" value="{res:CCS_Update}" border="0" name="{Button_Name}"><!-- END Button Button_Update -->
<!-- BEGIN Button Button_Delete --><input type="image" src="Styles/{CCS_Style}/Images/{res:CCS_LanguageID}/ButtonDelete.gif" value="{res:CCS_Delete}" border="0" name="{Button_Name}"><!-- END Button Button_Delete -->
<!-- BEGIN Button Button_Cancel --><input type="image" src="Styles/{CCS_Style}/Images/{res:CCS_LanguageID}/ButtonCancel.gif" value="{res:CCS_Cancel}" border="0" name="{Button_Name}"><!-- END Button Button_Cancel --></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
<!-- END Record events_rec --><br>
</td>
</tr>
</table>
{footer}
<div id="popup" style="display:none;">
<iframe id="pop" width="100%" height="100%" marginWidth="0" marginHeight="0" frameBorder="0" scrolling="auto">Not work!</iframe>
</div>
</body>
</html>
<script>
function openPopup(){
$("#popup").dialog({
autoOpen: false,
modal: true,
height: 480,
width: 640,
title: "Project Data"
});
$("#popup").dialog("open");
$("#pop").attr("src","projects.php");
return false;
}
$(document).ready(function(){
$("#usersx").multiselect({
noneSelectedText: 'Invite user(s)'
});
});
</script>
Tag : PHP, MySQL
|
ประวัติการแก้ไข
2012-11-01 10:00:16
|
 |
 |
 |
 |
| Date :
2012-11-01 09:58:23 |
By :
Chinn |
View :
992 |
Reply :
6 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
มันประมาณว่า add event จากหน้า calendar ครับ
แล้วอยากให้มันแอดเวลา ณ ตอนนั้นไปด้วย
|
| |
|
|
| |
| Date :
2012-11-01 10:16:56 |
By :
Chinn |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ถ้าใช้ Data type ใน DB เป็น Timestamp อยุ่แล้ว ตอน insert ไม่ต้องระบุอะไร มันจะใช้เวลาบน Server ยัดลงไปให้เอง
แต่ถ้าเวลาอัพเดทแล้วจะให้อัพเดทเวลาด้วย ให้ไปปรับ DB เป็น On update ด้วย
|
| |
|
|
| |
| Date :
2012-11-01 10:17:57 |
By :
adaaugusta |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 05
|
