public function onLoad($param) { date_default_timezone_set('Europe/Berlin'); $this->setUserStartId($this->user->getStartNode($this->user->getUserId($this->user->Name), "tm_activity")); if (!$this->isPostBack && !$this->isCallback) { $this->edidta_activity_type->DataSource = PFH::build_SQLPullDown(ActivityTypeRecord::finder(), "ta_activity_type", array("idta_activity_type", "act_type_name")); $this->edidta_activity_type->dataBind(); $this->ttedidtt_ziele->DataSource = PFH::build_SQLPullDown(TTZieleRecord::finder(), "tt_ziele", array("idtt_ziele", "ttzie_name")); $this->ttedidtt_ziele->dataBind(); //los interfaces input $this->ttedidtm_inoutput->DataSource = PFH::build_SQLPullDown(ActivityInoutputView::finder(), "vv_activity_inoutput", array("idtm_inoutput", "ino_name"), "ino_link_type=0"); $this->ttedidtm_inoutput->dataBind(); //los interfaces $this->Iedidta_inoutput_type->DataSource = PFH::build_SQLPullDown(InoutputTypeRecord::finder(), "ta_inoutput_type", array("idta_inoutput_type", "ino_type_name")); $this->Iedidta_inoutput_type->dataBind(); $Usersql = "SELECT idtm_user, user_name FROM tm_user"; $Userdata = PFH::convertdbObjectArray(UserRecord::finder()->findAllBySql($Usersql), array("idtm_user", "user_name")); $this->idtm_user->DataSource = $Userdata; $this->idtm_user->dataBind(); $this->loadBerechtigung(); $this->CCProtokollDetailGroupListPageSize->DataSource = array(5 => "5", 10 => "10", 15 => "15", 20 => "20"); $this->CCProtokollDetailGroupListPageSize->dataBind(); $this->CCProtokollDetailGroupListPageSize->Text = "5"; $this->CBAufgabeDone->DataSource = $this->auf_done; $this->CBAufgabeDone->dataBind(); $this->CBidta_organisation_art->DataSource = $this->idta_organisation_art; $this->CBidta_organisation_art->dataBind(); $data = array(0 => "Normalfolge(E/A)", 1 => "Anfangsfolge(A/A)", 2 => "Sprungfolge(A/E)", 3 => "Endfolge(E/E)"); $this->edactact_type->DataSource = $data; $this->edactact_type->dataBind(); $this->getPage()->getClientScript()->registerEndScript('XACTCF', "constructCollapsableFieldsets();"); $this->generateZeitVerlaufImage(0); } }
public function edbuildZielePullDown() { foreach ($this->edProtokollDetailGroupList->Items as $Gitem) { //if($Gitem->ItemType==='Item' || $Gitem->ItemType==='AlternatingItem'){ foreach ($Gitem->edProtokollDetailList->Items as $item) { $item->edidtm_activity->DataSource = PFH::build_SQLPullDown(TTZieleRecord::finder(), "tt_ziele", array("idtm_activity", "ttzie_name")); $item->edidtm_activity->dataBind(); $item->edidta_protokoll_ergebnistype->DataSource = PFH::build_SQLPullDown(ProtokollErgebnistypeRecord::finder(), "ta_protokoll_ergebnistype", array("idta_protokoll_ergebnistype", "prt_ergtype_name")); $item->edidta_protokoll_ergebnistype->dataBind(); $item->Aedidtm_organisation->DataSource = PFH::build_SQLPullDown(OrganisationRecord::finder(), "tm_organisation", array("idtm_organisation", "org_name"), "idta_organisation_type = 4"); $item->Aedidtm_organisation->dataBind(); } //} } }
public function update_ListBox($sender, $param) { $parent_value = $this->edidtm_ziele->selectedValue; //hier checken wir, wieviele schritte noch den gleichen Vater haben $myPreStepOne = TTZieleRecord::finder()->findAllBySql("SELECT idtm_ziele FROM tt_ziele WHERE idtt_ziele = '" . $parent_value . "'"); $prozess_counter = count(TTZieleRecord::finder()->findAllBySql("SELECT idtt_ziele FROM tt_ziele WHERE idtm_ziele = '" . $myPreStepOne[0]->idtm_ziele . "'")); $sql = "SELECT idtt_ziele, ttzie_name FROM tt_ziele WHERE idtm_ziele = '" . $myPreStepOne[0]->idtm_ziele . "'"; $data = PFH::convertdbObjectArray(TTZieleRecord::finder()->findAllBySql($sql), array("idtt_ziele", "ttzie_name")); $data[0] = "START"; $this->idtm_ziele->DataSource = $data; $this->idtm_ziele->dataBind(); }
public function bindRepeaterZiele4($sender, $param) { $item = $param->Item; if ($item->ItemType === 'Item' || $item->ItemType === 'AlternatingItem') { $criteria = new TActiveRecordCriteria(); $criteria->Condition = "idtm_ziele = :suchtext2"; $criteria->Parameters[':suchtext2'] = $item->Data->idtm_ziele; $item->RepZiele4->DataSource = TTZieleRecord::finder()->findAll($criteria); $item->RepZiele4->dataBind(); } }
public function clearProStep($agent_x) { $criteria = new TActiveRecordCriteria(); $criteria->Condition = "idtm_ziele = :suchtext"; $criteria->Parameters[':suchtext'] = $agent_x; $criteria->setLimit($this->ProStepListe->PageSize); $criteria->setOffset($this->ProStepListe->PageSize * $this->ProStepListe->CurrentPageIndex); $this->ProStepListe->DataKeyField = 'idtt_ziele'; $this->ProStepListe->VirtualItemCount = count(TTZieleRecord::finder()->find($criteria)); $this->ProStepListe->DataSource = TTZieleRecord::finder()->findAll($criteria); $this->ProStepListe->dataBind(); }