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 onLoad($param)
{
parent::onLoad($param);
if (!$this->isPostBack && !$this->isCallback) {
$this->idtm_activity->DataSource = PFH::build_SQLPullDownAdvanced(ActivityRecord::finder(), "tm_activity", array("idtm_activity", "act_name", "act_pspcode"), "idta_activity_type = 2", "act_name ASC");
$this->idtm_activity->dataBind();
$this->idtm_activity->Text = ActivityRecord::finder()->findByparent_idtm_activity('0')->idtm_activity;
$this->loadGridValues($sender, $param);
}
}
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)
{
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 : '';
}
}
}
public function onLoad($param)
{
parent::onLoad($param);
if (!$this->isPostBack && !$this->isCallback) {
//here comes the part for gantt 1 MUST BE DONE FIRST
$tmpstartdate = new DateTime();
$this->gantt_datestart->setDate($tmpstartdate->format("Y-m-d"));
$tmpstartdate->modify("30days");
$this->gantt_dateende->setDate($tmpstartdate->format("Y-m-d"));
$this->idtm_activity->DataSource = PFH::build_SQLPullDownAdvanced(ActivityRecord::finder(), "tm_activity", array("idtm_activity", "act_name", "act_pspcode"), "idta_activity_type = 2", "act_name ASC");
$this->idtm_activity->dataBind();
$this->idtm_activity->Text = ActivityRecord::finder()->findByparent_idtm_activity('0')->idtm_activity;
$this->bindTerminListe();
}
}
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 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 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 bindListBox()
{
$this->sai_idta_feldfunktion->DataSource = PFH::build_SQLPullDownAdvanced(FeldfunktionRecord::finder(), "ta_feldfunktion", array("idta_feldfunktion", "ff_name", "idta_struktur_type"));
$this->sai_idta_feldfunktion->DataBind();
}
public function buildAutoMappingPullDown()
{
$listSource = array();
for ($i = 1; $i <= $this->NumberID->Text; $i++) {
$listSource[$i] = "Level " . $i;
}
$this->SelectAMLevel->dataSource = $listSource;
$this->SelectAMLevel->dataBind();
$this->Selectidta_feldfunktion->DataSource = PFH::build_SQLPullDownAdvanced(FeldfunktionRecord::finder(), "ta_feldfunktion", array("idta_feldfunktion", "ff_name", "idta_struktur_type"));
$this->Selectidta_feldfunktion->dataBind();
}
