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);
     }
 }
 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();
     }
 }
Exemple #3
0
 public function onInit($param)
 {
     parent::onInit($param);
     if (!$this->isPostBack) {
         switch ($this->Request['modus']) {
             case 0:
                 $sql = "SELECT idtm_country, country_ful FROM tm_country";
                 $data = PFH::convertdbObjectArray(CountryRecord::finder()->findAllBySql($sql), array("idtm_country", "country_ful"));
                 $this->Country->DataSource = $data;
                 $this->Country->dataBind();
                 $this->idta_partei->Data = $this->Request['idta_partei'];
                 break;
             case 1:
                 $sql = "SELECT idtm_country, country_ful FROM tm_country";
                 $data = PFH::convertdbObjectArray(CountryRecord::finder()->findAllBySql($sql), array("idtm_country", "country_ful"));
                 $this->edCountry->DataSource = $data;
                 $this->edCountry->dataBind();
                 $this->fillValues($this->getSelected($this->Request['idta_adresse']));
                 break;
             default:
                 break;
         }
         $this->viewPanel->ActiveViewIndex = $this->Request['modus'];
     }
 }
Exemple #4
0
 public function onInit($param)
 {
     parent::onInit($param);
     if (!$this->isPostBack) {
         switch ($this->Request['modus']) {
             case 0:
                 $sql = "SELECT idtm_waren_kategorie, waren_kategorie_name FROM tm_waren_kategorie";
                 $data = PFH::convertdbObjectArray(WarenKategorieRecord::finder()->findAllBySql($sql), array("idtm_waren_kategorie", "waren_kategorie_name"));
                 $this->idtm_waren_kategorie->DataSource = $data;
                 $this->idtm_waren_kategorie->dataBind();
                 $sql = "SELECT idtm_preis_kategorie, preis_kategorie_name FROM tm_preis_kategorie";
                 $data = PFH::convertdbObjectArray(PreisKategorieRecord::finder()->findAllBySql($sql), array("idtm_preis_kategorie", "preis_kategorie_name"));
                 $this->idtm_preis_kategorie->DataSource = $data;
                 $this->idtm_preis_kategorie->dataBind();
                 $this->bindList();
                 break;
             case 1:
                 $sql = "SELECT idtm_waren_kategorie, waren_kategorie_name FROM tm_waren_kategorie";
                 $data = PFH::convertdbObjectArray(WarenKategorieRecord::finder()->findAllBySql($sql), array("idtm_waren_kategorie", "waren_kategorie_name"));
                 $this->edidtm_waren_kategorie->DataSource = $data;
                 $this->edidtm_waren_kategorie->dataBind();
                 $sql = "SELECT idtm_preis_kategorie, preis_kategorie_name FROM tm_preis_kategorie";
                 $data = PFH::convertdbObjectArray(PreisKategorieRecord::finder()->findAllBySql($sql), array("idtm_preis_kategorie", "preis_kategorie_name"));
                 $this->edidtm_preis_kategorie->DataSource = $data;
                 $this->edidtm_preis_kategorie->dataBind();
                 $this->fillValues($this->getSelected($this->Request['idta_waren']));
                 $this->bindListed();
                 break;
             default:
                 break;
         }
         $this->viewPanel->ActiveViewIndex = $this->Request['modus'];
     }
 }
 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];
     }
 }
Exemple #6
0
 public function onLoad($param)
 {
     parent::onLoad($param);
     $sql = "SELECT idtm_user_role, user_role_name FROM tm_user_role WHERE user_role_name = 'Benutzer'";
     $data = PFH::convertdbObjectArray(UserRoleRecord::finder()->findAllBySql($sql), array("idtm_user_role", "user_role_name"));
     $this->Role->DataSource = $data;
     $this->Role->dataBind();
 }
 public function initPullDown()
 {
     $sql = "SELECT idta_organisation_type, org_type_name FROM ta_organisation_type ORDER BY org_type_name";
     $data = PFH::convertdbObjectArray(OrganisationTypeRecord::finder()->findAllBySql($sql), array("idta_organisation_type", "org_type_name"));
     $data[-1] = "alle";
     $this->WINOrgaidta_organisation_type->DataSource = $data;
     $this->WINOrgaidta_organisation_type->dataBind();
 }
 public function buildStammdatenGroupPullDown()
 {
     $this->RCedidta_struktur_type->DataSource = PFH::build_SQLPullDown(StrukturTypeRecord::finder(), "ta_struktur_type", array("idta_struktur_type", "struktur_type_name"));
     $this->RCedidta_struktur_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();
 }
Exemple #9
0
 public function onInit($param)
 {
     parent::onInit($param);
     //Globale definition f�r dieses Dokument
     $this->finder = RisikoRecord::finder();
     $this->MASTERRECORD = new RisikoRecord();
     if (!$this->isPostBack) {
         switch ($this->Request['modus']) {
             case 0:
                 $sql = "SELECT idta_risiko_type, ris_type_name FROM ta_risiko_type";
                 $data = PFH::convertdbObjectArray(RisikoTypeRecord::finder()->findAllBySql($sql), array("idta_risiko_type", "ris_type_name"));
                 $this->idta_risiko_type->DataSource = $data;
                 $this->idta_risiko_type->dataBind();
                 if ($this->Request[$this->primarykey] != 1) {
                     $sql = "SELECT idtm_risiko, ris_name FROM tm_risiko ORDER BY idta_risiko_type";
                     $data = PFH::convertdbObjectArray(RisikoRecord::finder()->findAllBySql($sql), array("idtm_risiko", "ris_name"));
                 } else {
                     $data = array();
                     $data[0] = "START";
                 }
                 $this->parent_idtm_risiko->DataSource = $data;
                 $this->parent_idtm_risiko->dataBind();
                 break;
             case 1:
                 $sql = "SELECT idta_risiko_type, ris_type_name FROM ta_risiko_type";
                 $data = PFH::convertdbObjectArray(RisikoTypeRecord::finder()->findAllBySql($sql), array("idta_risiko_type", "ris_type_name"));
                 $this->edidta_risiko_type->DataSource = $data;
                 $this->edidta_risiko_type->dataBind();
                 if ($this->Request[$this->primarykey] != 1) {
                     $sql = "SELECT idtm_risiko, ris_name FROM tm_risiko ORDER BY idta_risiko_type";
                     $data = PFH::convertdbObjectArray(RisikoRecord::finder()->findAllBySql($sql), array("idtm_risiko", "ris_name"));
                 } else {
                     $data = array();
                     $data[0] = "START";
                 }
                 $this->edparent_idtm_risiko->DataSource = $data;
                 $this->edparent_idtm_risiko->dataBind();
                 $this->fillValues($this->getSelected($this->Request[$this->primarykey]));
                 //$this->bindListed();
                 break;
             default:
                 break;
         }
         $this->viewPanel->ActiveViewIndex = $this->Request['modus'];
         //the parameters for the RiskValueContainer
         $this->RCedrcv_tabelle->Text = "tm_risiko";
         $this->RCedrcv_id->Text = $this->Request[$this->primarykey];
     }
 }
Exemple #10
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'];
     }
 }
 public function onLoad($param)
 {
     parent::onLoad($param);
     date_default_timezone_set('Europe/Berlin');
     //$this->SBedidta_struktur_type->Text = $this->page->idta_struktur_type->Text;
     if (!$this->page->isPostBack && !$this->page->isCallback) {
         //$this->buildStrukturBerichtPullDown();
         $this->bindListStrukturBerichtValue();
         $this->buildStrukturBerichtZeilenPullDown();
         $this->buildStrukturBerichtSpaltenPullDown();
         $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();
     }
 }
Exemple #12
0
 public function onInit($param)
 {
     parent::onInit($param);
     //Globale definition f�r dieses Dokument
     $this->finder = ProzessRecord::finder();
     $this->MASTERRECORD = new ProzessRecord();
     if (!$this->isPostBack) {
         switch ($this->Request['modus']) {
             case 0:
                 $sql = "SELECT idta_prozess_type, pro_type_name FROM ta_prozess_type";
                 $data = PFH::convertdbObjectArray(ProzessTypeRecord::finder()->findAllBySql($sql), array("idta_prozess_type", "pro_type_name"));
                 $this->idta_prozess_type->DataSource = $data;
                 $this->idta_prozess_type->dataBind();
                 if ($this->Request[$this->primarykey] != 1) {
                     $sql = "SELECT idtm_prozess, pro_name FROM tm_prozess ORDER BY idta_prozess_type";
                     $data = PFH::convertdbObjectArray(ProzessRecord::finder()->findAllBySql($sql), array("idtm_prozess", "pro_name"));
                 } else {
                     $data = array();
                     $data[0] = "START";
                 }
                 $this->parent_idtm_prozess->DataSource = $data;
                 $this->parent_idtm_prozess->dataBind();
                 break;
             case 1:
                 $sql = "SELECT idta_prozess_type, pro_type_name FROM ta_prozess_type";
                 $data = PFH::convertdbObjectArray(ProzessTypeRecord::finder()->findAllBySql($sql), array("idta_prozess_type", "pro_type_name"));
                 $this->edidta_prozess_type->DataSource = $data;
                 $this->edidta_prozess_type->dataBind();
                 if ($this->Request[$this->primarykey] != 1) {
                     $sql = "SELECT idtm_prozess, pro_name FROM tm_prozess ORDER BY idta_prozess_type";
                     $data = PFH::convertdbObjectArray(ProzessRecord::finder()->findAllBySql($sql), array("idtm_prozess", "pro_name"));
                 } else {
                     $data = array();
                     $data[0] = "START";
                 }
                 $this->edparent_idtm_prozess->DataSource = $data;
                 $this->edparent_idtm_prozess->dataBind();
                 $this->fillValues($this->getSelected($this->Request[$this->primarykey]));
                 //$this->bindListed();
                 break;
             default:
                 break;
         }
         $this->viewPanel->ActiveViewIndex = $this->Request['modus'];
     }
 }
 public function onLoad($param)
 {
     parent::onLoad($param);
     if (!$this->page->IsPostBack && !$this->page->IsCallback) {
         $PeriodPullDown = new PFPeriodPullDown();
         $PeriodPullDown->setStructureTable("ta_perioden");
         $PeriodPullDown->setRecordClass(PeriodenRecord::finder());
         $PeriodPullDown->setPKField("idta_perioden");
         $PeriodPullDown->setField("per_extern");
         $PeriodPullDown->letsrun();
         $this->RCedidta_perioden->DataSource = $PeriodPullDown->myTree;
         $this->RCedidta_perioden->dataBind();
         $Usersql = "SELECT idtm_user, user_name FROM tm_user";
         $Userdata = PFH::convertdbObjectArray(UserRecord::finder()->findAllBySql($Usersql), array("idtm_user", "user_name"));
         $this->var_idtm_user->DataSource = $Userdata;
         $this->var_idtm_user->dataBind();
         $this->bindListVariantenValue();
     }
 }
Exemple #14
0
 public static function build_SQLPullDownAdvanced($finder, $tabelle, $array_fields, $criteria = '', $order = '')
 {
     //deklarieren der variablen
     $meinSQL = '';
     $ttdata = array();
     $meinSQL = "SELECT " . $array_fields[0] . ", CONCAT(" . $array_fields[1] . ",'::'," . $array_fields[2] . ") AS " . $array_fields[1] . " FROM " . $tabelle;
     if ($criteria != '') {
         $meinSQL .= ' WHERE ' . $criteria;
     }
     if ($order != '') {
         $meinSQL .= ' ORDER BY ' . $order;
     }
     if (count($finder->findAllBySQL($meinSQL)) >= 1) {
         $ttdata = PFH::convertdbObjectArray($finder->findAllBySQL($meinSQL), $array_fields);
     } else {
         $ttdata[0] = 'no values';
     }
     //array_push($ttdata,array(0=>'no values'));
     return $ttdata;
 }
Exemple #15
0
 /**
  * Initializes the inputs with existing user data.
  * This method is invoked by the framework when the page is being initialized.
  * @param mixed event parameter
  */
 public function onInit($param)
 {
     parent::onInit($param);
     if (!$this->IsPostBack && !$this->isCallback) {
         $sql = "SELECT idtm_user_role, user_role_name FROM tm_user_role";
         $this->User->isInRole('Administrator') ? '' : ($sql .= " WHERE user_role_name = 'Benutzer'");
         $data = PFH::convertdbObjectArray(UserRoleRecord::finder()->findAllBySql($sql), array("idtm_user_role", "user_role_name"));
         $this->Role->DataSource = $data;
         $this->Role->dataBind();
         // Retrieves the existing user data. This is equivalent to:
         $userRecord = $this->getUserRecord();
         //$userRecord=$this->UserRecord;
         // Populates the input controls with the existing user data
         $this->Username->Text = $userRecord->user_username;
         $this->Email->Text = $userRecord->user_mail;
         $this->Role->SelectedValue = $userRecord->idtm_user_role;
         $this->FirstName->Text = $userRecord->user_vorname;
         $this->LastName->Text = $userRecord->user_name;
         $parteiRecord = ParteiRecord::finder()->findBy_idtm_user($userRecord->idtm_user);
         $this->idta_partei->Text = $parteiRecord->idta_partei;
         $this->bind_lstAdress();
     }
 }
Exemple #16
0
 public function update_ListBox($sender, $param)
 {
     $parent_value = $this->edidtm_ziele->selectedValue;
     //hier checken wir, wieviele schritte noch den gleichen Vater haben
     $myPreStepOne = TTZieleRecord::finder()->findAllBySql("SELECT idtm_ziele FROM tt_ziele WHERE idtt_ziele = '" . $parent_value . "'");
     $prozess_counter = count(TTZieleRecord::finder()->findAllBySql("SELECT idtt_ziele FROM tt_ziele WHERE idtm_ziele = '" . $myPreStepOne[0]->idtm_ziele . "'"));
     $sql = "SELECT idtt_ziele, ttzie_name FROM tt_ziele WHERE idtm_ziele = '" . $myPreStepOne[0]->idtm_ziele . "'";
     $data = PFH::convertdbObjectArray(TTZieleRecord::finder()->findAllBySql($sql), array("idtt_ziele", "ttzie_name"));
     $data[0] = "START";
     $this->idtm_ziele->DataSource = $data;
     $this->idtm_ziele->dataBind();
 }
 public function load_fields_mapped_idtm_stammdaten($sender, $param)
 {
     $this->linkStammdaten($sender, $param);
     $sgIndecies = $this->fields_idtm_stammdaten->SelectedIndices;
     $idtm_stammdaten_group = 0;
     foreach ($sgIndecies as $index) {
         $idtm_stammdaten_group = $this->fields_idtm_stammdaten->Items[$index]->Value;
     }
     $Usersql = "SELECT tm_stammdaten.idtm_stammdaten, tm_stammdaten.stammdaten_name FROM tm_stammdaten INNER JOIN tt_stammdaten_stammdaten ON tm_stammdaten.idtm_stammdaten = tt_stammdaten_stammdaten.idtm_stammdaten WHERE tt_stammdaten_stammdaten.idtm_stammdaten_group = '" . $idtm_stammdaten_group . "' AND tt_stammdaten_stammdaten.idta_stammdatensicht = '" . $this->dim_idta_stammdatensicht->Text . "'";
     $Userdata = PFH::convertdbObjectArray(StammdatenRecord::finder()->findAllBySql($Usersql), array("idtm_stammdaten", "stammdaten_name"));
     if (count($Userdata) < 1) {
         $Userdata = array("0" => "leer");
     }
     $this->fields_mapped_idtm_stammdaten->DataSource = $Userdata;
     $this->fields_mapped_idtm_stammdaten->dataBind();
 }
 public function update_ListBox($sender, $param)
 {
     $parent_value = $this->edidtm_prozess->selectedValue;
     //hier checken wir, wieviele schritte noch den gleichen Vater haben
     $myPreStepOne = ProzessStepRecord::finder()->findAllBySql("SELECT idtm_prozess FROM tm_prozess_step WHERE idtm_prozess_step = '" . $parent_value . "'");
     $prozess_counter = count(ProzessStepRecord::finder()->findAllBySql("SELECT idtm_prozess_step FROM tm_prozess_step WHERE idtm_prozess = '" . $myPreStepOne[0]->idtm_prozess . "'"));
     $sql = "SELECT idtm_prozess_step, prostep_name FROM tm_prozess_step WHERE idtm_prozess = '" . $myPreStepOne[0]->idtm_prozess . "'";
     $data = PFH::convertdbObjectArray(ProzessStepRecord::finder()->findAllBySql($sql), array("idtm_prozess_step", "prostep_name"));
     $data[0] = "START";
     $this->parent_idtm_prozess_step->DataSource = $data;
     $this->parent_idtm_prozess_step->dataBind();
     $this->error_idtm_prozess_step->DataSource = $data;
     $this->error_idtm_prozess_step->dataBind();
 }