Beispiel #1
0
 public function onLoad($param)
 {
     parent::onLoad($param);
     date_default_timezone_set('Europe/Berlin');
     if (!$this->IsPostBack || !$this->IsCallBack) {
         $sql = "SELECT idta_organisation_type, org_type_name FROM ta_organisation_type";
         $data = PFH::convertdbObjectArray(OrganisationTypeRecord::finder()->findAllBySql($sql), array("idta_organisation_type", "org_type_name"));
         $this->RCedidta_organisation_type->DataSource = $data;
         $this->RCedidta_organisation_type->dataBind();
         $this->RCedidta_organisation_art->DataSource = $this->idta_organisation_art;
         $this->RCedidta_organisation_art->dataBind();
         $this->RCedorg_idtm_user_role->DataSource = PFH::build_SQLPullDown(UserRoleRecord::finder(), "tm_user_role", array("idtm_user_role", "user_role_name"));
         $this->RCedorg_idtm_user_role->dataBind();
         $this->RCedidta_branche->DataSource = PFH::build_SQLPullDown(BrancheRecord::finder(), "ta_branche", array("idta_branche", "bra_name"));
         $this->RCedidta_branche->dataBind();
         $this->RCedidtm_ressource->DataSource = PFH::build_SQLPullDown(RessourceRecord::finder(), "tm_ressource", array("idtm_ressource", "res_name"));
         $this->RCedidtm_ressource->dataBind();
         $this->RCedidtm_country->DataSource = PFH::build_SQLPullDown(CountryRecord::finder(), "tm_country", array("idtm_country", "country_iso"));
         $this->RCedidtm_country->dataBind();
         $this->RCedkom_type->DataSource = array(1 => "Telefon", "Fax", "Mail");
         $this->RCedkom_type->dataBind();
         $this->RCedorg_status->DataSource = array(0 => "offen", "interessant", "nicht interessant", "Kunde", "EX-Kunde");
         $this->RCedorg_status->dataBind();
         if (isset($_GET['idtm_organisation'])) {
             $this->view_Organisation($_GET['idtm_organisation']);
         } else {
             $this->view_Organisation(1);
         }
         //$this->bindListOrgListe();
     }
 }
Beispiel #2
0
 public function onLoad($param)
 {
     date_default_timezone_set('Europe/Berlin');
     $this->setUserStartId($this->user->getStartNode($this->user->getUserId($this->user->Name), "tm_activity"));
     if (!$this->isPostBack && !$this->isCallback) {
         $this->edidta_activity_type->DataSource = PFH::build_SQLPullDown(ActivityTypeRecord::finder(), "ta_activity_type", array("idta_activity_type", "act_type_name"));
         $this->edidta_activity_type->dataBind();
         $this->ttedidtt_ziele->DataSource = PFH::build_SQLPullDown(TTZieleRecord::finder(), "tt_ziele", array("idtt_ziele", "ttzie_name"));
         $this->ttedidtt_ziele->dataBind();
         //los interfaces input
         $this->ttedidtm_inoutput->DataSource = PFH::build_SQLPullDown(ActivityInoutputView::finder(), "vv_activity_inoutput", array("idtm_inoutput", "ino_name"), "ino_link_type=0");
         $this->ttedidtm_inoutput->dataBind();
         //los interfaces
         $this->Iedidta_inoutput_type->DataSource = PFH::build_SQLPullDown(InoutputTypeRecord::finder(), "ta_inoutput_type", array("idta_inoutput_type", "ino_type_name"));
         $this->Iedidta_inoutput_type->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();
         $this->CCProtokollDetailGroupListPageSize->DataSource = array(5 => "5", 10 => "10", 15 => "15", 20 => "20");
         $this->CCProtokollDetailGroupListPageSize->dataBind();
         $this->CCProtokollDetailGroupListPageSize->Text = "5";
         $this->CBAufgabeDone->DataSource = $this->auf_done;
         $this->CBAufgabeDone->dataBind();
         $this->CBidta_organisation_art->DataSource = $this->idta_organisation_art;
         $this->CBidta_organisation_art->dataBind();
         $data = array(0 => "Normalfolge(E/A)", 1 => "Anfangsfolge(A/A)", 2 => "Sprungfolge(A/E)", 3 => "Endfolge(E/E)");
         $this->edactact_type->DataSource = $data;
         $this->edactact_type->dataBind();
         $this->getPage()->getClientScript()->registerEndScript('XACTCF', "constructCollapsableFieldsets();");
         $this->generateZeitVerlaufImage(0);
     }
 }
 private function generateListFields()
 {
     $this->idtm_organisation->DataSource = PFH::build_SQLPullDown(OrganisationRecord::finder(), "tm_organisation", array("idtm_organisation", "org_name"), "idta_organisation_type = 4");
     $this->idtm_organisation->dataBind();
     $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();
 }
Beispiel #4
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();
     }
 }
 public function initPullDowns()
 {
     $this->ttidtm_ressource->DataSource = PFH::build_SQLPullDown(RessourceRecord::finder(), "tm_ressource", array("idtm_ressource", "res_name"));
     $this->ttidtm_ressource->dataBind();
     $this->Tedidta_aufgaben_type->DataSource = PFH::build_SQLPullDown(AufgabenTypeRecord::finder(), "ta_aufgaben_type", array("idta_aufgaben_type", "auf_type_name"));
     $this->Tedidta_aufgaben_type->dataBind();
 }
 public function buildPivotPullDown()
 {
     $this->PBDedidta_stammdaten_group->DataSource = PFH::build_SQLPullDown(StammdatenGroupRecord::finder(), "ta_stammdaten_group", array("idta_stammdaten_group", "stammdaten_group_name"));
     $this->PBDedidta_stammdaten_group->dataBind();
     $this->PBDedparent_idtm_pivot->DataSource = PFH::build_SQLPullDown(PivotRecord::finder(), "tm_pivot", array("idtm_pivot", "idtm_pivot"), "idta_pivot_bericht = " . $this->page->idta_pivot_bericht->Text);
     $this->PBDedparent_idtm_pivot->DataBind();
 }
Beispiel #7
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];
     }
 }
 public function buildStrukturStrukturPullDown()
 {
     $this->SSedidta_feldfunktion->DataSource = PFH::build_SQLPullDown(FeldfunktionRecord::finder(), "ta_feldfunktion", array("idta_feldfunktion", "ff_name"), "idta_struktur_type = " . $this->page->idta_struktur_type->Text);
     $this->SSedidta_feldfunktion->DataBind();
     $StrukRec = StrukturRecord::finder()->findByidtm_struktur($this->user->getStartNode($this->user->getUserId($this->user->Name), "tm_struktur"));
     $this->SSedidtm_struktur_to->DataSource = PFH::build_SQLPullDown(StrukturRecord::finder(), "tm_struktur INNER JOIN ta_feldfunktion ON tm_struktur.idta_struktur_type = ta_feldfunktion.idta_struktur_type", array("idtm_struktur", "struktur_name"), "ff_type=3 AND struktur_lft BETWEEN " . $StrukRec->struktur_lft . " AND " . $StrukRec->struktur_rgt);
     $this->SSedidtm_struktur_to->DataBind();
 }
Beispiel #9
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'];
     }
 }
 public function reloadStammdatensichtPullDown($sender, $param)
 {
     $item = $param->item;
     if ($item->ItemType === 'Item' || $item->ItemType === 'AlternatingItem') {
         $values = PFH::build_SQLPullDown(StammdatenGroupRecord::finder(), "ta_stammdaten_group", array("idta_stammdaten_group", "stammdaten_group_name"));
         array_push($values, array("no values", "0"));
         $item->parent_idta_stammdaten_group->DataSource = $values;
         $item->parent_idta_stammdaten_group->dataBind();
     }
 }
 public function createRiskPullDown()
 {
     //risiko oder chance
     $data = array(0 => "Risiko", 1 => "Chance");
     $this->RCedrcv_type->DataSource = $data;
     $this->RCedrcv_type->DataBind();
     //die Risikoklasse
     $this->RCedidtm_risiko->DataSource = PFH::build_SQLPullDown(RisikoRecord::finder(), "tm_risiko", array("idtm_risiko", "ris_name"));
     $this->RCedidtm_risiko->dataBind();
 }
 private function initPullDowns()
 {
     $this->dim_idta_stammdaten_group->DataSource = PFH::build_SQLPullDown(StammdatenGroupRecord::finder(), "ta_stammdaten_group", array("idta_stammdaten_group", "stammdaten_group_name"));
     $this->dim_idta_stammdaten_group->dataBind();
     $this->dim_idta_stammdatensicht->DataSource = StammdatensichtRecord::finder()->findAll();
     $this->dim_idta_stammdatensicht->dataBind();
     $sender = 0;
     $param = 0;
     $this->linkStammdaten($sender, $param);
 }
 public function buildPivotBerichtPullDown()
 {
     $this->PBedidta_feldfunktion->DataSource = PFH::build_SQLPullDownAdvanced(FeldfunktionRecord::finder(), "ta_feldfunktion", array("idta_feldfunktion", "idta_struktur_type", "ff_name"));
     $this->PBedidta_feldfunktion->dataBind();
     $this->PBedidta_variante->DataSource = PFH::build_SQLPullDown(VarianteRecord::finder(), "ta_variante", array("idta_variante", "var_descr"));
     $this->PBedidta_variante->dataBind();
     $data = array('SUM' => "SUM", "AVG" => "AVG", "MAX" => "MAX", "MIN" => "MIN");
     $this->PBedpivot_bericht_operator->DataSource = $data;
     $this->PBedpivot_bericht_operator->DataBind();
 }
 public function initPullDowns()
 {
     $this->CBAufgabeDone->DataSource = $this->auf_done;
     $this->CBAufgabeDone->dataBind();
     $this->ttidtm_ressource->DataSource = PFH::build_SQLPullDown(RessourceRecord::finder(), "tm_ressource", array("idtm_ressource", "res_name"));
     $this->ttidtm_ressource->dataBind();
     $this->Tedidta_aufgaben_type->DataSource = PFH::build_SQLPullDown(AufgabenTypeRecord::finder(), "ta_aufgaben_type", array("idta_aufgaben_type", "auf_type_name"));
     $this->Tedidta_aufgaben_type->dataBind();
     $this->CCAufgabenContainerPageSize->DataSource = array(5 => "5", 10 => "10", 25 => "25", 50 => "50");
     $this->CCAufgabenContainerPageSize->dataBind();
 }
Beispiel #15
0
 public function createRfCPullDown()
 {
     //Als erstes die Organisation
     $this->RfCedsuggest_idtm_organisation->DataSource = PFH::build_SQLPullDown(OrganisationRecord::finder(), "tm_organisation", array("idtm_organisation", "org_name"), "idta_organisation_type = 4");
     $this->RfCedsuggest_idtm_organisation->dataBind();
     //Als erstes die Organisation
     $this->RfCedgenemigt_idtm_organisation->DataSource = PFH::build_SQLPullDown(OrganisationRecord::finder(), "tm_organisation", array("idtm_organisation", "org_name"), "idta_organisation_type = 4");
     $this->RfCedgenemigt_idtm_organisation->dataBind();
     //einlesen der aktivitaeten
     $this->RfCedidtm_activity->DataSource = PFH::build_SQLPullDownAdvanced(ActivityRecord::finder(), "tm_activity", array("idtm_activity", "act_pspcode", "act_name"));
     $this->RfCedidtm_activity->dataBind();
 }
 public function onLoad($param)
 {
     //Globale definition f�r dieses Dokument
     $this->finder = VerteilerRecord::finder();
     $this->MASTERRECORD = new VerteilerRecord();
     parent::onLoad($param);
     if (!$this->isPostBack && !$this->isCallback) {
         $this->ttidtm_organisation->DataSource = PFH::build_SQLPullDown(OrganisationRecord::finder(), "tm_organisation", array("idtm_organisation", "org_name"), "idta_organisation_type=4");
         $this->ttidtm_organisation->dataBind();
         $this->bindListVerteiler();
     }
 }
 public function onLoad($param)
 {
     date_default_timezone_set('Europe/Berlin');
     parent::onLoad($param);
     if (!$this->page->isPostBack && !$this->page->isCallback) {
         $tmpstartdate = new DateTime();
         $this->res_selected_date->setDate($tmpstartdate->format("Y-m-d"));
         $this->idta_ressource_type->DataSource = PFH::build_SQLPullDown(RessourceTypeRecord::finder(), "ta_ressource_type", array("idta_ressource_type", "res_type_name"));
         $this->idta_ressource_type->dataBind();
         $this->idta_ressource_type->Text = 4;
         $this->bindListBelegungsplan();
     }
 }
 public function onLoad($param)
 {
     parent::onLoad($param);
     //if(!$this->isPostBack && !$this->isCallback){
     $this->DWH_idta_variante->DataSource = PFH::build_SQLPullDown(VarianteRecord::finder(), "ta_variante", array("idta_variante", "var_descr"));
     $this->DWH_idta_variante->dataBind();
     $this->DWH_idta_perioden->DataSource = PFH::build_SQLPullDown(PeriodenRecord::finder(), "ta_perioden", array("per_intern", "per_extern"));
     $this->DWH_idta_perioden->dataBind();
     $tree = $this->MyTree;
     //$this->addContextMenu($tree->getID());
     $node = new StrukturRecord();
     $this->fullInTreeStrukturRecord($tree, $node);
     //}
 }
 public function onLoad($param)
 {
     if (!$this->page->IsPostBack && !$this->page->isCallback) {
         $this->DWH_idta_variante->DataSource = PFH::build_SQLPullDown(VarianteRecord::finder(), "ta_variante", array("idta_variante", "var_descr"));
         $this->DWH_idta_variante->dataBind();
         $this->DWH_idta_stammdatensicht->DataSource = PFH::build_SQLPullDown(StammdatensichtRecord::finder(), "ta_stammdatensicht", array("idta_stammdatensicht", "sts_name"));
         $this->DWH_idta_stammdatensicht->dataBind();
         $this->DWH_idta_struktur_bericht->DataSource = PFH::build_SQLPullDownAdvanced(StrukturBerichtRecord::finder(), "ta_struktur_bericht", array("idta_struktur_bericht", "sb_order", "pivot_struktur_name"), '', 'sb_order');
         $this->DWH_idta_struktur_bericht->dataBind();
         //first we need to check the szenario, because we recieve the startperiod from the variante...
         if ($this->Request['idta_variante'] != "") {
             $this->DWH_idta_variante->Text = $this->Request['idta_variante'];
         } else {
             $this->DWH_idta_variante->Text = VarianteRecord::finder()->findByvar_default(1)->idta_variante;
             $this->DWH_idta_variante->Text == "" ? $this->DWH_idta_variante->Text = 1 : '';
         }
         if ($this->Request['idta_stammdatensicht'] != "") {
             $this->DWH_idta_stammdatensicht->Text = $this->Request['idta_stammdatensicht'];
         } else {
             $this->DWH_idta_stammdatensicht->Text == "" ? $this->DWH_idta_stammdatensicht->Text = 1 : '';
         }
         if ($this->Request['periode'] != "") {
             $this->DWH_idta_perioden->Text = $this->Request['periode'];
         } else {
             $sec_per = "10001";
             $this->DWH_idta_perioden->Text = VarianteRecord::finder()->findByidta_variante($this->DWH_idta_variante->Text)->idta_perioden;
             $this->DWH_idta_perioden->Text == '' ? $this->DWH_idta_perioden->Text = $sec_per : '';
         }
         $this->Request['per_single'] != "" ? $this->DWH_per_single->setChecked($this->Request['per_single']) : $this->DWH_per_single->setChecked(0);
         if ($this->Request['idta_struktur_bericht'] != '') {
             $this->DWH_idta_struktur_bericht->Text = $this->Request['idta_struktur_bericht'];
         } else {
             $this->DWH_idta_struktur_bericht->Text = StrukturBerichtRecord::finder()->findBysb_startbericht(1)->idta_struktur_bericht;
         }
         if ($this->checkPeriodeArea($this->DWH_idta_struktur_bericht->Text)) {
             $this->DWH_PERIODAREA->setVisible($this->checkPeriodeArea($this->DWH_idta_struktur_bericht->Text));
         } else {
             $this->DWH_PERIODAREA->setVisible($this->checkPeriodeArea($this->DWH_idta_struktur_bericht->Text));
             //$this->getPage()->getClientScript()->registerEndScript('XXX','dhxinTab.hideTab("tab2",true);');
         }
         $this->Request['idta_struktur_type'] != "" ? $this->Request['idta_struktur_type'] = 1 : '';
         if ($this->Request['idtm_struktur'] != '') {
             $this->DWH_idtm_struktur->Text = $this->Request['idtm_struktur'];
         } else {
             $this->DWH_idtm_struktur->Text = $this->user->getStartNode($this->user->getUserId($this->user->Name), "tm_struktur");
             $this->DWH_idtm_struktur->Text == '' ? $this->DWH_idtm_struktur->Text = 1 : '';
         }
     }
 }
Beispiel #20
0
 public function edbuildZielePullDown()
 {
     foreach ($this->edProtokollDetailGroupList->Items as $Gitem) {
         //if($Gitem->ItemType==='Item' || $Gitem->ItemType==='AlternatingItem'){
         foreach ($Gitem->edProtokollDetailList->Items as $item) {
             $item->edidtm_activity->DataSource = PFH::build_SQLPullDown(TTZieleRecord::finder(), "tt_ziele", array("idtm_activity", "ttzie_name"));
             $item->edidtm_activity->dataBind();
             $item->edidta_protokoll_ergebnistype->DataSource = PFH::build_SQLPullDown(ProtokollErgebnistypeRecord::finder(), "ta_protokoll_ergebnistype", array("idta_protokoll_ergebnistype", "prt_ergtype_name"));
             $item->edidta_protokoll_ergebnistype->dataBind();
             $item->Aedidtm_organisation->DataSource = PFH::build_SQLPullDown(OrganisationRecord::finder(), "tm_organisation", array("idtm_organisation", "org_name"), "idta_organisation_type = 4");
             $item->Aedidtm_organisation->dataBind();
         }
         //}
     }
 }
 public function bindListBox()
 {
     $this->for_idta_feldfunktion->DataSource = PFH::build_SQLPullDownAdvanced(FeldfunktionRecord::finder(), "ta_feldfunktion", array("idta_feldfunktion", "ff_name", "idta_struktur_type"));
     $this->for_idta_feldfunktion->DataBind();
     $this->for_from_idta_periode->DataSource = PFH::build_SQLPullDown(PeriodenRecord::finder(), "ta_perioden", array("per_intern", "per_extern"));
     $this->for_from_idta_periode->dataBind();
     $this->for_to_idta_periode->DataSource = PFH::build_SQLPullDown(PeriodenRecord::finder(), "ta_perioden", array("per_intern", "per_extern"));
     $this->for_to_idta_periode->dataBind();
     $this->for_idta_variante->DataSource = PFH::build_SQLPullDown(VarianteRecord::finder(), "ta_variante", array("idta_variante", "var_descr"));
     $this->for_idta_variante->dataBind();
     //definition der wachstumstypen...
     // 1 = year to year
     $growthtypes = array(1 => 'year to year');
     $this->for_idta_fortschreibungs_type->DataSource = $growthtypes;
     $this->for_idta_fortschreibungs_type->dataBind();
 }
 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();
 }
Beispiel #23
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();
                 $this->idtm_ziele->DataSource = PFH::build_SQLPullDown(ZieleRecord::finder(), "tm_ziele", array("idtm_ziele", "zie_name"), "(idta_ziele_type = 1 OR idta_ziele_type = 3)");
                 $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();
                 $this->edidtm_ziele->DataSource = PFH::build_SQLPullDown(ZieleRecord::finder(), "tm_ziele", array("idtm_ziele", "zie_name"), "(idta_ziele_type = 1 OR idta_ziele_type = 3)");
                 $this->edidtm_ziele->dataBind();
                 $this->Aedidtm_organisation->DataSource = PFH::build_SQLPullDown(OrganisationRecord::finder(), "tm_organisation", array("idtm_organisation", "org_name"), "idta_organisation_type=4");
                 $this->Aedidtm_organisation->dataBind();
                 $this->fillValues($this->getSelected($this->Request[$this->primarykey]));
                 $this->Aedauf_id->Text = $this->Request[$this->primarykey];
                 $this->bindListAufgaben();
                 break;
             default:
                 break;
         }
         $this->viewPanel->ActiveViewIndex = $this->Request['modus'];
     }
 }
 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();
 }
Beispiel #25
0
 public function onLoad($param)
 {
     parent::onLoad($param);
     if ($this->Request['periode'] != '') {
         $this->Periode = $this->Request['periode'];
     }
     if (!$this->isPostBack && !$this->isCallback) {
         $this->DWH_idta_perioden->DataSource = PFH::build_SQLPullDown(PeriodenRecord::finder(), "ta_perioden", array("per_intern", "per_extern"));
         $this->DWH_idta_perioden->dataBind();
         $this->DWH_idta_perioden->Text = $this->Periode;
         $this->idta_pivot_bericht->Text = $this->Request['idta_pivot_bericht'];
         $this->PivotBerichtRecord = PivotBerichtRecord::finder()->findByPK($this->Request['idta_pivot_bericht']);
         $this->pivot_bericht_name->Text = $this->PivotBerichtRecord->pivot_bericht_name;
         //hier berechne ich die Anzahl der Elemente auf der untersten Ebene
         if (count(PivotRecord::finder()->findByidta_pivot_bericht($this->PivotBerichtRecord->idta_pivot_bericht)) > 0) {
             $this->calc_NumberOfElements(PivotRecord::finder()->findByidta_pivot_bericht($this->PivotBerichtRecord->idta_pivot_bericht));
             $this->calc_NumerOfAllElements();
             $this->buildPivotReport();
             //$this->generateGraph($this->zwischenergebnisse);
         }
     }
 }
 public function onLoad($param)
 {
     date_default_timezone_set('Europe/Berlin');
     parent::onLoad($param);
     if (!$this->isPostBack && !$this->isCallback) {
         $this->RCedidtm_organisation->Text = $this->User->getUserOrgId($this->User->getUserId());
         $tmpstartdate = new DateTime();
         $tmpstartdate->modify("-30days");
         $this->zeiterfassung_datestart->setDate($tmpstartdate->format("Y-m-d"));
         $tmpstartdate->modify("45days");
         $this->zeiterfassung_dateende->setDate($tmpstartdate->format("Y-m-d"));
         $this->bindListRCValue();
         $idta_kostenstatus = PFH::build_SQLPullDown(KostenStatusRecord::finder(), "ta_kosten_status", array("idta_kosten_status", "kst_status_name"));
         $idta_kostenstatus["Alle"] = "Alle anzeigen";
         $this->idta_kosten_status->DataSource = $idta_kostenstatus;
         $this->idta_kosten_status->dataBind();
         $this->idta_kosten_status->Text = "Alle";
         $idtm_activity = PFH::build_SQLPullDownAdvanced(ActivityRecord::finder(), "tm_activity", array("idtm_activity", "act_name", "act_pspcode"), "idta_activity_type = 2", "act_name ASC");
         $idtm_activity["Alle"] = "Alle anzeigen";
         $this->idtm_activity->DataSource = $idtm_activity;
         $this->idtm_activity->dataBind();
         $this->idtm_activity->Text = "Alle";
     }
 }
 public function createZeitPullDown()
 {
     //Als erstes die Organisation
     if ($this->User->getIsAdmin()) {
         $this->RCedidtm_organisation->Text = "";
     } else {
         $this->RCedidtm_organisation->Text = $this->User->getUserOrgId($this->User->getUserId());
     }
     $this->RCedidta_kosten_status->DataSource = PFH::build_SQLPullDown(KostenStatusRecord::finder(), "ta_kosten_status", array("idta_kosten_status", "kst_status_name"));
     $this->RCedidta_kosten_status->dataBind();
     $PRTREE = new PFHierarchyPullDown();
     $PRTREE->setStructureTable("tm_prozess");
     $PRTREE->setRecordClass(ProzessRecord::finder());
     $PRTREE->setPKField("idtm_prozess");
     $PRTREE->setField("pro_name");
     $PRTREE->letsrun();
     $this->RCedidtm_prozess->DataSource = $PRTREE->myTree;
     $this->RCedidtm_prozess->dataBind();
     $fahrt_status = array(1 => "abbrechenbar", 2 => "ausweisbar", 3 => "privat");
     $this->fahrt_status->DataSource = $fahrt_status;
     $this->fahrt_status->dataBind();
     $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();
     $this->FFidtm_activity->Text = $this->UserStartId;
     $this->RCedzeit_date->setDate(date('Y-m-d', time()));
     //        $this->RCedidtm_activity->DataSource=PFH::build_SQLPullDownAdvanced(ActivityRecord::finder(),"tm_activity",array("idtm_activity","act_name","act_pspcode"),"idta_activity_type = 2","act_name ASC");
     //        $this->RCedidtm_activity->dataBind();
 }
 public function buildCollectorPullDown()
 {
     $this->COLedcol_idtafeldfunktion->DataSource = PFH::build_SQLPullDown(FeldfunktionRecord::finder(), "ta_feldfunktion", array("idta_feldfunktion", "ff_name"), "idta_struktur_type = " . $this->page->idta_struktur_type->Text);
     $this->COLedcol_idtafeldfunktion->DataBind();
     $data = array('+' => "+", "-" => "-", "/" => "/", "*" => "*");
     $this->COLedcol_operator->DataSource = $data;
     $this->COLedcol_operator->DataBind();
 }
 public function initPullDowns()
 {
     $this->from_idta_stammdaten_group->DataSource = PFH::build_SQLPullDown(StammdatenGroupRecord::finder(), "ta_stammdaten_group", array("idta_stammdaten_group", "stammdaten_group_name"));
     $this->from_idta_stammdaten_group->dataBind();
     $this->to_idta_stammdaten_group->DataSource = PFH::build_SQLPullDown(StammdatenGroupRecord::finder(), "ta_stammdaten_group", array("idta_stammdaten_group", "stammdaten_group_name"));
     $this->to_idta_stammdaten_group->dataBind();
     $this->from_idta_feldfunktion->DataSource = PFH::build_SQLPullDown(FeldfunktionRecord::finder(), "ta_feldfunktion", array("idta_feldfunktion", "ff_name"));
     $this->from_idta_feldfunktion->dataBind();
     $this->to_idta_feldfunktion->DataSource = PFH::build_SQLPullDown(FeldfunktionRecord::finder(), "ta_feldfunktion", array("idta_feldfunktion", "ff_name"));
     $this->to_idta_feldfunktion->dataBind();
     $PeriodPullDown = new PFPeriodPullDown();
     $PeriodPullDown->setStructureTable("ta_perioden");
     $PeriodPullDown->setRecordClass(PeriodenRecord::finder());
     $PeriodPullDown->setPKField("idta_perioden");
     $PeriodPullDown->setSQLCondition("per_intern > 9999");
     $PeriodPullDown->setField("per_extern");
     $PeriodPullDown->letsrun();
     $this->DWH_idta_perioden->DataSource = $PeriodPullDown->myTree;
     $this->DWH_idta_perioden->dataBind();
     $this->DWH_idta_variante->DataSource = PFH::build_SQLPullDown(VarianteRecord::finder(), "ta_variante", array("idta_variante", "var_descr"));
     $this->DWH_idta_variante->dataBind();
 }
 public function buildSBZCollectorPullDown()
 {
     $this->SBZCOLedrow_idta_struktur_bericht_zeilen->DataSource = PFH::build_SQLPullDown(StrukturBerichtZeilenRecord::finder(), "ta_struktur_bericht_zeilen", array("idta_struktur_bericht_zeilen", "sbz_label"), "idta_struktur_bericht = " . $this->SBedidta_struktur_bericht->Text);
     $this->SBZCOLedrow_idta_struktur_bericht_zeilen->DataBind();
     $data = array('+' => "+", "-" => "-", "/" => "/", "*" => "*");
     $this->SBZCOLedsbz_collector_operator->DataSource = $data;
     $this->SBZCOLedsbz_collector_operator->DataBind();
 }