public function onLoad($param) { parent::onLoad($param); date_default_timezone_set('Europe/Berlin'); if (!$this->IsPostBack || !$this->IsCallBack) { $sql = "SELECT idta_organisation_type, org_type_name FROM ta_organisation_type"; $data = PFH::convertdbObjectArray(OrganisationTypeRecord::finder()->findAllBySql($sql), array("idta_organisation_type", "org_type_name")); $this->RCedidta_organisation_type->DataSource = $data; $this->RCedidta_organisation_type->dataBind(); $this->RCedidta_organisation_art->DataSource = $this->idta_organisation_art; $this->RCedidta_organisation_art->dataBind(); $this->RCedorg_idtm_user_role->DataSource = PFH::build_SQLPullDown(UserRoleRecord::finder(), "tm_user_role", array("idtm_user_role", "user_role_name")); $this->RCedorg_idtm_user_role->dataBind(); $this->RCedidta_branche->DataSource = PFH::build_SQLPullDown(BrancheRecord::finder(), "ta_branche", array("idta_branche", "bra_name")); $this->RCedidta_branche->dataBind(); $this->RCedidtm_ressource->DataSource = PFH::build_SQLPullDown(RessourceRecord::finder(), "tm_ressource", array("idtm_ressource", "res_name")); $this->RCedidtm_ressource->dataBind(); $this->RCedidtm_country->DataSource = PFH::build_SQLPullDown(CountryRecord::finder(), "tm_country", array("idtm_country", "country_iso")); $this->RCedidtm_country->dataBind(); $this->RCedkom_type->DataSource = array(1 => "Telefon", "Fax", "Mail"); $this->RCedkom_type->dataBind(); $this->RCedorg_status->DataSource = array(0 => "offen", "interessant", "nicht interessant", "Kunde", "EX-Kunde"); $this->RCedorg_status->dataBind(); if (isset($_GET['idtm_organisation'])) { $this->view_Organisation($_GET['idtm_organisation']); } else { $this->view_Organisation(1); } //$this->bindListOrgListe(); } }
public function initPullDowns() { $this->ttidtm_ressource->DataSource = PFH::build_SQLPullDown(RessourceRecord::finder(), "tm_ressource", array("idtm_ressource", "res_name")); $this->ttidtm_ressource->dataBind(); $this->Tedidta_aufgaben_type->DataSource = PFH::build_SQLPullDown(AufgabenTypeRecord::finder(), "ta_aufgaben_type", array("idta_aufgaben_type", "auf_type_name")); $this->Tedidta_aufgaben_type->dataBind(); }
public function onLoad($param) { //Globale definition f�r dieses Dokument $this->finder = TerminRecord::finder(); $this->MASTERRECORD = new TerminRecord(); $this->setUserStartId($this->user->getStartNode($this->user->getUserId($this->user->Name), "tm_activity")); date_default_timezone_set('Europe/Berlin'); parent::onLoad($param); if (!$this->isPostBack && !$this->isCallback) { $HRKEYTest = new PFHierarchyPullDown(); $HRKEYTest->setStructureTable("tm_activity"); $HRKEYTest->setRecordClass(ActivityRecord::finder()); $HRKEYTest->setPKField("idtm_activity"); $HRKEYTest->setField("act_name"); $HRKEYTest->setStartNode($this->UserStartId); $HRKEYTest->setSQLCondition("idta_activity_type = 2"); $HRKEYTest->letsrun(); $this->FFidtm_activity->DataSource = $HRKEYTest->myTree; $this->FFidtm_activity->dataBind(); $tmpstartdate = new DateTime(); $this->ter_startdate->setDate($tmpstartdate->format("Y-m-d")); $this->ter_enddate->setDate($tmpstartdate->format("Y-m-d")); $this->ttidtm_ressource->DataSource = PFH::build_SQLPullDown(RessourceRecord::finder(), "tm_ressource", array("idtm_ressource", "res_name"), "idta_ressource_type>1"); $this->ttidtm_ressource->dataBind(); $this->bindListTermin(); } }
public function initPullDowns() { $this->CBAufgabeDone->DataSource = $this->auf_done; $this->CBAufgabeDone->dataBind(); $this->ttidtm_ressource->DataSource = PFH::build_SQLPullDown(RessourceRecord::finder(), "tm_ressource", array("idtm_ressource", "res_name")); $this->ttidtm_ressource->dataBind(); $this->Tedidta_aufgaben_type->DataSource = PFH::build_SQLPullDown(AufgabenTypeRecord::finder(), "ta_aufgaben_type", array("idta_aufgaben_type", "auf_type_name")); $this->Tedidta_aufgaben_type->dataBind(); $this->CCAufgabenContainerPageSize->DataSource = array(5 => "5", 10 => "10", 25 => "25", 50 => "50"); $this->CCAufgabenContainerPageSize->dataBind(); }
public function bindListBelegungsplan() { $criteria = new TActiveRecordCriteria(); if ($this->page->isPostBack) { $criteria->Condition = "idta_ressource_type = :suchtext1"; $criteria->Parameters[':suchtext1'] = $this->idta_ressource_type->Text; } else { $criteria->Condition = "idta_ressource_type = :suchtext1"; $criteria->Parameters[':suchtext1'] = $this->idta_ressource_type->Text; } $this->Belegungsplan->DataSource = RessourceRecord::finder()->findAll($criteria); $this->Belegungsplan->dataBind(); }
public function RSTSavedButtonClicked($sender, $param) { $tempus = $this->RSprimarykey; if ($this->ressource_edit_status->Text == '1') { $AEditRecord = RessourceRecord::finder()->findByPK($this->{$tempus}->Text); } else { $AEditRecord = new RessourceRecord(); } //HIDDEN foreach ($this->RShiddenfields as $recordfield) { $edrecordfield = $this->RSPrefix . $recordfield; $AEditRecord->{$recordfield} = $this->{$edrecordfield}->Value; } //DATUM foreach ($this->RSdatfields as $recordfield) { $edrecordfield = $this->RSPrefix . $recordfield; $AEditRecord->{$recordfield} = date('Y-m-d', $this->{$edrecordfield}->TimeStamp); } //LIST foreach ($this->RSlistfields as $recordfield) { $edrecordfield = $this->RSPrefix . $recordfield; $AEditRecord->{$recordfield} = $this->{$edrecordfield}->Text; } //BOOL foreach ($this->RSboolfields as $recordfield) { $edrecordfield = $this->RSPrefix . $recordfield; $AEditRecord->{$recordfield} = $this->{$edrecordfield}->Checked ? 1 : 0; } foreach ($this->RSfields as $recordfield) { $edrecordfield = $this->RSPrefix . $recordfield; $AEditRecord->{$recordfield} = $this->{$edrecordfield}->Text; } $AEditRecord->save(); $this->bindListRessource(); //$this->ParticipantbindList(); $this->idtm_ressource->Text = $AEditRecord->idtm_ressource; }