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 onInit($param)
{
parent::onInit($param);
//Globale definition f�r dieses Dokument
$this->finder = StrukturRecord::finder();
$this->MASTERRECORD = new StrukturRecord();
if (!$this->isPostBack && !$this->isCallback) {
switch ($this->Request['modus']) {
case 0:
$sql = "SELECT idta_struktur_type, struktur_type_name FROM ta_struktur_type";
$data = PFH::convertdbObjectArray(StrukturTypeRecord::finder()->findAllBySql($sql), array("idta_struktur_type", "struktur_type_name"));
$this->idta_struktur_type->DataSource = $data;
$this->idta_struktur_type->dataBind();
$HRKEYTest = new PFHierarchyPullDown();
$HRKEYTest->setStructureTable("tm_struktur");
$HRKEYTest->setRecordClass(StrukturRecord::finder());
$HRKEYTest->setPKField("idtm_struktur");
$HRKEYTest->setField("struktur_name");
$HRKEYTest->letsrun();
$this->parent_idtm_struktur->DataSource = $HRKEYTest->myTree;
$this->parent_idtm_struktur->dataBind();
$this->idtm_stammdaten->DataSource = PFH::build_SQLPullDown(StammdatenRecord::finder(), "tm_stammdaten", array("idtm_stammdaten", "stammdaten_name"));
$this->idtm_stammdaten->dataBind();
break;
case 1:
$sql = "SELECT idta_struktur_type, struktur_type_name FROM ta_struktur_type";
$data = PFH::convertdbObjectArray(StrukturTypeRecord::finder()->findAllBySql($sql), array("idta_struktur_type", "struktur_type_name"));
$this->edidta_struktur_type->DataSource = $data;
$this->edidta_struktur_type->dataBind();
if ($this->Request[$this->primarykey] != 1) {
$HRKEYTest = new PFHierarchyPullDown();
$HRKEYTest->setStructureTable("tm_struktur");
$HRKEYTest->setRecordClass(StrukturRecord::finder());
$HRKEYTest->setPKField("idtm_struktur");
$HRKEYTest->setField("struktur_name");
$HRKEYTest->letsrun();
$data = $HRKEYTest->myTree;
} else {
$data = array();
$data[0] = "START";
}
$this->edparent_idtm_struktur->DataSource = $data;
$this->edparent_idtm_struktur->dataBind();
$this->fillValues($this->getSelected($this->Request[$this->primarykey]));
$this->edidtm_stammdaten->DataSource = PFH::build_SQLPullDown(StammdatenRecord::finder(), "tm_stammdaten", array("idtm_stammdaten", "stammdaten_name"));
$this->edidtm_stammdaten->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();
break;
default:
break;
}
$this->viewPanel->ActiveViewIndex = $this->Request['modus'];
$this->StrukturStammdatenGroupContainer->RCedidtm_struktur->Text = $this->Request[$this->primarykey];
}
}
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 onInit($param)
{
parent::onInit($param);
//Globale definition fuer dieses Dokument
$this->finder = ZieleRecord::finder();
$this->MASTERRECORD = new ZieleRecord();
if (!$this->isPostBack) {
switch ($this->Request['modus']) {
case 0:
$sql = "SELECT idta_ziele_type, zie_type_name FROM ta_ziele_type";
$data = PFH::convertdbObjectArray(ZieleTypeRecord::finder()->findAllBySql($sql), array("idta_ziele_type", "zie_type_name"));
$this->idta_ziele_type->DataSource = $data;
$this->idta_ziele_type->dataBind();
$HRKEYTest = new PFHierarchyPullDown();
$HRKEYTest->setStructureTable("tm_ziele");
$HRKEYTest->setRecordClass(ZieleRecord::finder());
$HRKEYTest->setPKField("idtm_ziele");
$HRKEYTest->setField("zie_name");
$HRKEYTest->letsrun();
$this->parent_idtm_ziele->DataSource = $HRKEYTest->myTree;
$this->parent_idtm_ziele->dataBind();
$this->idtm_activity->DataSource = PFH::build_SQLPullDownAdvanced(ActivityRecord::finder(), "tm_activity", array("idtm_activity", "act_pspcode", "act_name"), "idta_activity_type = 2");
$this->idtm_activity->dataBind();
break;
case 1:
$sql = "SELECT idta_ziele_type, zie_type_name FROM ta_ziele_type";
$data = PFH::convertdbObjectArray(ZieleTypeRecord::finder()->findAllBySql($sql), array("idta_ziele_type", "zie_type_name"));
$this->edidta_ziele_type->DataSource = $data;
$this->edidta_ziele_type->dataBind();
$HRKEYTest = new PFHierarchyPullDown();
$HRKEYTest->setStructureTable("tm_ziele");
$HRKEYTest->setRecordClass(ZieleRecord::finder());
$HRKEYTest->setPKField("idtm_ziele");
$HRKEYTest->setField("zie_name");
$HRKEYTest->letsrun();
$this->edparent_idtm_ziele->DataSource = $HRKEYTest->myTree;
$this->edparent_idtm_ziele->dataBind();
$this->fillValues($this->getSelected($this->Request[$this->primarykey]));
$this->edidtm_activity->DataSource = PFH::build_SQLPullDownAdvanced(ActivityRecord::finder(), "tm_activity", array("idtm_activity", "act_pspcode", "act_name"), "idta_activity_type = 2");
$this->edidtm_activity->dataBind();
//$this->bindListed();
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()
{
$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 onLoad($param)
{
parent::onLoad($param);
if (!$this->isPostBack && !$this->isCallback) {
//$this->bindList_FilePreview();
$this->loadAvailableMappings();
$this->buildAutoMappingPullDown();
$this->buildStammdatenMapping();
$this->bindListImportMapping();
$HRKEYTest = new PFHierarchyPullDown();
$HRKEYTest->setStructureTable("tm_struktur");
$HRKEYTest->setRecordClass(StrukturRecord::finder());
$HRKEYTest->setPKField("idtm_struktur");
$HRKEYTest->setField("struktur_name");
//$HRKEYTest->StartPoint=$this->idtm_struktur->Text;
$HRKEYTest->letsrun();
$this->idtm_struktur->dataSource = $HRKEYTest->myTree;
$this->idtm_struktur->dataBind();
}
}
public function bindDropDown()
{
$this->idta_bericht_type->DataSource = PFH::build_SQLPullDown(BerichtTypeRecord::finder(), "ta_bericht_type", array("idta_bericht_type", "ber_type_name"));
$this->idta_bericht_type->dataBind();
$HRKEYTest = new PFHierarchyPullDown();
$HRKEYTest->setStructureTable("tm_organisation");
$HRKEYTest->setRecordClass(OrganisationRecord::finder());
$HRKEYTest->setPKField("idtm_organisation");
$HRKEYTest->setField("org_name");
$HRKEYTest->letsrun();
$this->rcidtm_organisation->DataSource = $HRKEYTest->myTree;
$this->rcidtm_organisation->dataBind();
$ar_ber_zyklus = array(0 => 'select', 1 => 'daily', 2 => 'weekly', 3 => 'monthly');
$ar_ber_zyklus_gap = array(1 => 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday');
// for($i=0;$i<=30;$i++){
// $ar_ber_zyklus_gap[$i]=$i+1;
// }
$this->ber_zyklus->DataSource = $ar_ber_zyklus;
$this->ber_zyklus->dataBind();
$this->ber_zyklus_gap->DataSource = $ar_ber_zyklus_gap;
$this->ber_zyklus_gap->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();
}