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 onLoad($param) { parent::onLoad($param); if (!$this->isPostBack && !$this->isCallback) { if ($this->Request['rqidtm_ziele'] != '') { $this->rqidtm_ziele = $this->Request['rqidtm_ziele']; } $HRKEYtop = new PFHierarchyPullDown(); $HRKEYtop->setStructureTable("tm_ziele"); $HRKEYtop->setRecordClass(ZieleRecord::finder()); $HRKEYtop->setPKField("idtm_ziele"); $HRKEYtop->setField("zie_name"); $HRKEYtop->setSQLCondition("idta_ziele_type=1"); $HRKEYtop->letsrun(); $this->idtm_ziele->DataSource = $HRKEYtop->myTree; $this->idtm_ziele->dataBind(); $NEWRECORD = $this->NewRecord; $NEWRECORD->setText("neues Element anlegen"); $NEWRECORD->setToPage("ziele.zieleview"); $NEWRECORD->setGetVariables('modus=0'); $NEWSTRECORD = $this->NewStepRecord; $NEWSTRECORD->setText("operatives Ziel anlegen"); $NEWSTRECORD->setToPage("ziele.ttzieleview"); $NEWSTRECORD->setGetVariables('modus=0'); $this->bindListOrgListe(); } }
public function onLoad($param) { parent::onLoad($param); //Globale definition f�r dieses Dokument $this->finder = TTZieleRecord::finder(); $this->MASTERRECORD = new TTZieleRecord(); if (!$this->isPostBack && !$this->isCallback) { switch ($this->Request['modus']) { case 0: //hier checken wir, wieviele schritte noch den gleichen Vater haben $myPreStepOne = TTZieleRecord::finder()->findAllBySql("SELECT idtm_prozess FROM tt_ziele WHERE idtt_ziele = '" . $this->Request[$this->primarykey] . "'"); $prozess_counter = count(TTZieleRecord::finder()->findAllBySql("SELECT idtt_ziele FROM tt_ziele WHERE idtm_ziele = '" . $myPreStepOne[0]->idtm_ziele . "'")); $this->idtm_prozess->DataSource = PFH::build_SQLPullDown(ProzessRecord::finder(), "tm_prozess", array("idtm_prozess", "pro_name"), "idta_prozess_type = 3"); $this->idtm_prozess->dataBind(); $HRKEYTest = new PFHierarchyPullDown(); $HRKEYTest->setStructureTable("tm_ziele"); $HRKEYTest->setRecordClass(ZieleRecord::finder()); $HRKEYTest->setPKField("idtm_ziele"); $HRKEYTest->setField("zie_name"); $HRKEYTest->setSQLCondition("idta_ziele_type = 3 OR idta_ziele_type=1 OR idta_ziele_type=2"); $HRKEYTest->letsrun(); $this->idtm_ziele->DataSource = $HRKEYTest->myTree; $this->idtm_ziele->dataBind(); $sql = "SELECT idtm_organisation, org_name FROM tm_organisation WHERE idta_organisation_type = 4"; $data = PFH::convertdbObjectArray(OrganisationRecord::finder()->findAllBySql($sql), array("idtm_organisation", "org_name")); $this->idtm_organisation->DataSource = $data; $this->idtm_organisation->dataBind(); break; case 1: //hier checken wir, wieviele schritte noch den gleichen Vater haben $myPreStepOne = TTZieleRecord::finder()->findAllBySql("SELECT idtm_ziele FROM tt_ziele WHERE idtt_ziele = '" . $this->Request[$this->primarykey] . "'"); $prozess_counter = count(TTZieleRecord::finder()->findAllBySql("SELECT * FROM tt_ziele WHERE idtm_ziele = '" . $myPreStepOne[0]->idtm_ziele . "'")); $this->edidtm_prozess->DataSource = PFH::build_SQLPullDown(ProzessRecord::finder(), "tm_prozess", array("idtm_prozess", "pro_name"), "idta_prozess_type = 3"); $this->edidtm_prozess->dataBind(); $this->edidtm_organisation->DataSource = PFH::build_SQLPullDown(OrganisationRecord::finder(), "tm_organisation", array("idtm_organisation", "org_name"), "idta_organisation_type=4"); $this->edidtm_organisation->dataBind(); $HRKEYTest = new PFHierarchyPullDown(); $HRKEYTest->setStructureTable("tm_ziele"); $HRKEYTest->setRecordClass(ZieleRecord::finder()); $HRKEYTest->setPKField("idtm_ziele"); $HRKEYTest->setField("zie_name"); $HRKEYTest->setSQLCondition("idta_ziele_type = 3 OR idta_ziele_type=1 OR idta_ziele_type=2"); $HRKEYTest->letsrun(); $this->edidtm_ziele->DataSource = $HRKEYTest->myTree; $this->edidtm_ziele->dataBind(); $this->fillValues($this->getSelected($this->Request[$this->primarykey])); $this->Tedauf_id->Text = $this->Request[$this->primarykey]; //the parameters for the RiskValueContainer $this->RiskValueContainer->RCedrcv_tabelle->Text = "tt_ziele"; $this->RiskValueContainer->RCedrcv_id->Text = $this->Request[$this->primarykey]; break; default: break; } $this->viewPanel->ActiveViewIndex = $this->Request['modus']; } }
public function onLoad($param) { parent::onLoad($param); if (!$this->isPostBack && !$this->isCallback) { $HRKEYtop = new PFHierarchyPullDown(); $HRKEYtop->setStructureTable("tm_struktur"); $HRKEYtop->setRecordClass(StrukturRecord::finder()); $HRKEYtop->setPKField("idtm_struktur"); $HRKEYtop->setField("struktur_name"); $HRKEYtop->setSQLCondition("idta_struktur_type=1"); $HRKEYtop->letsrun(); $this->idtm_struktur->DataSource = $HRKEYtop->myTree; $this->idtm_struktur->dataBind(); $this->bindListOrgListe(); } }
public function initPullDown() { $HRKEYTest = new PFHierarchyPullDown(); $HRKEYTest->setStructureTable("tm_activity"); $HRKEYTest->setRecordClass(ActivityRecord::finder()); $HRKEYTest->setPKField("idtm_activity"); $HRKEYTest->setField("act_name"); $HRKEYTest->setSQLCondition("idta_activity_type = 2"); $HRKEYTest->setStartNode($this->user->getStartNode($this->user->getUserId($this->user->Name), "tm_activity")); $HRKEYTest->letsrun(); $this->FFidtm_activity->DataSource = $HRKEYTest->myTree; //PFH::build_SQLPullDownAdvanced(ActivityRecord::finder(),"tm_activity",array("idtm_activity","act_name","act_pspcode"),"idta_activity_type = 2","idtm_activity ASC, act_name ASC"); $this->FFidtm_activity->dataBind(); $this->CBAufgabeDone->DataSource = $this->auf_done; $this->CBAufgabeDone->dataBind(); $this->CBidta_organisation_art->DataSource = $this->idta_organisation_art; $this->CBidta_organisation_art->dataBind(); }
public function filterActivity($sender, $param) { $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 AND UPPER(act_name) LIKE '%" . strtoupper($this->FFact_name->Text) . "%'"); $HRKEYTest->letsrun(); $this->RCedidtm_activity->DataSource = $HRKEYTest->myTree; $this->RCedidtm_activity->dataBind(); }