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