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 initPullDown()
{
$this->idta_protokoll_ergebnistype->dataSource = PFH::build_SQLPullDown(ProtokollErgebnistypeRecord::finder(), "ta_protokoll_ergebnistype", array("idta_protokoll_ergebnistype", "prt_ergtype_name"));
$this->idta_protokoll_ergebnistype->dataBind();
$HRKEYTest = new PFHierarchyPullDown();
$HRKEYTest->setStructureTable("tm_activity");
$HRKEYTest->setRecordClass(ActivityRecord::finder());
$HRKEYTest->setPKField("idtm_activity");
$HRKEYTest->setField("act_name");
$CheckStart = TerminRecord::finder()->findByPK($this->page->edidtm_termin->Text)->idtm_activity;
if ($CheckStart > 0) {
$HRKEYTest->setStartNode($CheckStart);
}
$HRKEYTest->letsrun();
$this->idtm_activity->DataSource = $HRKEYTest->myTree;
$this->idtm_activity->dataBind();
}
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();
}