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(); } }
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']; } }
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]; } }
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(); }
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]; } }
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(); } }
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(); } }
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; }
/** * 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(); } }
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(); }