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();
}
