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 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(); }