private function load_header()
{
//lets init the label row
$FirstRow = new TActiveTableRow();
$FirstRow->setCssClass('thead');
$this->resulttable->Rows[] = $FirstRow;
$ControlListCell = array();
//clean the children
$ControlListCellChildren = array();
//clean the children
$cell = new TActiveTableCell();
$cell->Text = "Zeit";
$FirstRow->Cells[] = $cell;
$ControlListCell[] = array("class" => "TActiveTableCell", "id" => "R" . $this->sheetrow . "C0G", "OnCallback" => "", "CommandParameter" => "", "children" => $ControlListCellChildren);
$ii = 1;
foreach ($this->TableHeaderRL as $key => $value) {
$ControlListCellChildren = array();
//clean the children
$cell = new TActiveTableCell();
$activeLabel = new TActiveLabel();
$activeLabel->setID("R" . $this->sheetrow . "C" . $ii . "GAL");
$activeLabel->setText("<b> " . $value . "</b>");
$cell->Controls->add($activeLabel);
$ControlListCellChildren[] = array("class" => "TActiveLabel", "id" => "R" . $this->sheetrow . "C" . $ii . "GAL", "OnCallback" => "", "CommandParameter" => "");
$ControlListCell[] = array("class" => "TActiveTableCell", "id" => "R" . $this->sheetrow . "C" . $ii . "G", "OnCallback" => "", "CommandParameter" => "", "children" => $ControlListCellChildren);
$FirstRow->Cells[] = $cell;
$ii++;
}
$this->dynamicControlList[] = array("class" => "TActiveTableRow", "id" => "R" . $this->sheetrow . "G", "OnCallback" => "", "CommandParameter" => "", "children" => $ControlListCell);
$this->sheetrow++;
}
private function draw_spacer($PFCALCULATOR, $title = "Graph")
{
$FirstRow = new TActiveTableRow();
$FirstRow->setID("R" . $this->sheetrow . "G");
//new for grouping
$this->resulttable->Rows[] = $FirstRow;
$ControlListCell = array();
//clean the children
$ControlListCellChildren = array();
//clean the children
$cell = new TActiveTableCell();
//id and button to expand and collapse
$cell->setID("R" . $this->sheetrow . "C1G");
$imagebutton = new TActiveImageButton();
$imagebutton->setID("R" . $this->sheetrow . "C1GIB");
$imagebutton->setImageUrl("/rliq/themes/basic/gfx/group-collapse.gif");
$imagebutton->setText("collapse");
$imagebutton->onCallback = "page.hideRowGroup";
$imagebutton->setCommandParameter($this->sheetrow);
$cell->Controls->add($imagebutton);
$ControlListCellChildren[] = array("class" => "TActiveImageButton", "id" => "R" . $this->sheetrow . "C1GIB", "OnCallback" => "page.hideRowGroup", "CommandParameter" => $this->sheetrow);
//$cell->Text=$title;
$activeLabel = new TActiveLabel();
$activeLabel->setID("R" . $this->sheetrow . "C1GAL");
$activeLabel->setText(" " . $title);
$cell->Controls->add($activeLabel);
$ControlListCellChildren[] = array("class" => "TActiveLabel", "id" => "R" . $this->sheetrow . "C1GAL", "OnCallback" => "", "CommandParameter" => "");
$cell->EnableViewState = true;
$cell->setCssClass('listheader');
//echo (count($PFCALCULATOR->Perioden)*$PFCALCULATOR->NumberOfColumns)+1;
$cell->setColumnSpan($PFCALCULATOR->NumberOfColumns + 1);
$FirstRow->Cells[] = $cell;
$ControlListCell[] = array("class" => "TActiveTableCell", "id" => "R" . $this->sheetrow . "C1G", "OnCallback" => "", "CommandParameter" => "", "children" => $ControlListCellChildren);
$this->dynamicControlList[] = array("class" => "TActiveTableRow", "id" => "R" . $this->sheetrow . "G", "OnCallback" => "", "CommandParameter" => "", "children" => $ControlListCell);
$this->sheetrow++;
//inccrement of the sheetrow
}
public function load_splasher_table($sender, $param)
{
//init des von bezuges
if ($sender->ID == "From_StammdatenGroupListe") {
$this->From_idtm_stammdaten->Text = $param->Item->lst_idtm_stammdaten->Data;
$this->load_splasher_values();
}
//alternierende werte
$Alternating = 1;
//holen der perioden
$Taschenrechner = new PFCalculator();
$Taschenrechner->setStartPeriod($this->DWH_idta_perioden->Text);
//holen der detialwerte der zielperiode
$MyRecords = StammdatenRecord::finder()->findAll('idta_stammdaten_group = ? AND stammdaten_aktiv = 0', $this->to_idta_stammdaten_group->Text);
//kopfzeile
$WorkRow = new TActiveTableRow();
$this->resulttable->Rows[] = $WorkRow;
$WorkRow->setCssClass('thead');
//Beschriftung
$ii = 1;
$cell = new TActiveTableCell();
$cell->setID("R" . $this->sheetrow . "C" . $ii . "GA");
$cell->Text = "<b>Name</b>";
$WorkRow->Cells[] = $cell;
$ii++;
//Datum als Titel
foreach ($Taschenrechner->Perioden as $Periode) {
$cell = new TActiveTableCell();
$cell->setID("R" . $this->sheetrow . "C" . $ii . "A");
$activeLabel = new TActiveLabel();
$activeLabel->setID("R" . $this->sheetrow . "C" . $ii . "AL");
$activeLabel->setText($Periode[0]);
$cell->Controls->add($activeLabel);
$WorkRow->Cells[] = $cell;
$ii++;
}
foreach ($MyRecords as $StammdatenRC) {
$ControlListCell = array();
//clean the children
$WorkRow = new TActiveTableRow();
$this->resulttable->Rows[] = $WorkRow;
//Beschriftung
$cell = new TActiveTableCell();
$cell->Text = "<b>" . $StammdatenRC->stammdaten_name . "</b>";
$ControlListCell[] = array("class" => "TActiveTableCell", "id" => "R" . $this->sheetrow . "C1", "OnCallback" => "", "CommandParameter" => "", "children" => "");
$WorkRow->Cells[] = $cell;
//Datenfelder
$jj = 2;
foreach ($Taschenrechner->Perioden as $Periode) {
$ControlListCellChildren = array();
//clean the children
$cell = new TActiveTableCell();
//eingabefeld
$inputfield = new TActiveTextBox();
$inputfield->setCssClass("inputgrid");
$UniqueID = 'xxx' . $Taschenrechner->getYearByMonth($Periode[0]) . 'xxx' . $Periode[0] . 'xxx' . $this->From_idtm_stammdaten->Text . 'xxx' . $StammdatenRC->idtm_stammdaten;
$inputfield->setId($UniqueID);
$inputfield->Text = $this->RAMRecord[$UniqueID];
$inputfield->AutoPostback = true;
$inputfield->OnCallback = "page.onTextChanged";
$cell->Controls->add($inputfield);
$ControlListCellChildren[] = array("class" => "TActiveTextBox", "id" => $UniqueID, "OnCallback" => "page.onTextChanged", "CommandParameter" => "");
$WorkRow->Cells[] = $cell;
$ControlListCell[] = array("class" => "TActiveTableCell", "id" => "R" . $this->sheetrow . "C" . $jj, "OnCallback" => "", "CommandParameter" => "", "children" => $ControlListCellChildren);
$jj++;
}
//alternieren der zeilen
fmod($ALTERNATING, 2) == 0 ? $WorkRow->setCssClass('listalternating') : $WorkRow->setCssClass('listnonealternating');
$this->dynamicControlList[] = array("class" => "TActiveTableRow", "id" => "R" . $this->sheetrow, "OnCallback" => "", "CommandParameter" => "", "children" => $ControlListCell);
$ALTERNATING++;
$this->sheetrow++;
}
$this->bindList_From_StammdatenGroupList();
$param->Item->CssClass = "PSPFAZ";
unset($Taschenrechner);
$this->session['dynamicControlList'] = $this->dynamicControlList;
}