Example #1
0
 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();
     }
 }
Example #2
0
 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();
     }
 }
Example #3
0
 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];
     }
 }
Example #4
0
 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'];
     }
 }
Example #5
0
 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'];
     }
 }
Example #6
0
 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();
 }
Example #8
0
 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();
 }