public static function InitDBValues($idtm_struktur, $idta_variante, $idta_perioden = '10001')
{
//Step One, find all relevant IDs
$StartRecord = StrukturRecord::finder()->findByidtm_struktur($idtm_struktur);
if (count($StartRecord) == 1) {
$sql = "SELECT idta_struktur_type FROM tm_struktur WHERE struktur_lft BETWEEN " . $StartRecord->struktur_lft . " AND " . $StartRecord->struktur_rgt . " GROUP BY idta_struktur_type";
//here I recieve the array of values containing the elements to be changed
$GroupsToChange = StrukturRecord::finder()->findAllBySQL($sql);
foreach ($GroupsToChange as $Group) {
$checker = FeldfunktionRecord::finder()->count("idta_struktur_type = ?", $Group->idta_struktur_type);
if ($checker > 0) {
$sqlElemente = "SELECT idtm_struktur,idta_struktur_type FROM tm_struktur WHERE (struktur_lft BETWEEN " . $StartRecord->struktur_lft . " AND " . $StartRecord->struktur_rgt . ") AND idta_struktur_type=" . $Group->idta_struktur_type;
$ElementsToChange = StrukturRecord::finder()->findAllBySQL($sqlElemente);
foreach ($ElementsToChange as $Element) {
echo $Element->idtm_struktur;
$ObjSaver = new PFBackCalculator();
$ObjSaver->setStartPeriod($idta_perioden);
$ObjSaver->setVariante($idta_variante);
$ObjSaver->setStartNode($Element->idtm_struktur);
$ObjSaver->build_DIMKEY($Element->idtm_struktur);
$ObjSaver->initTTWerte($Element->idtm_struktur, $Element->idta_struktur_type);
unset($ObjSaver);
}
empty($checker);
}
}
unset($ElementsToChange);
}
}
public function buildStrukturStrukturPullDown()
{
$this->SSedidta_feldfunktion->DataSource = PFH::build_SQLPullDown(FeldfunktionRecord::finder(), "ta_feldfunktion", array("idta_feldfunktion", "ff_name"), "idta_struktur_type = " . $this->page->idta_struktur_type->Text);
$this->SSedidta_feldfunktion->DataBind();
$StrukRec = StrukturRecord::finder()->findByidtm_struktur($this->user->getStartNode($this->user->getUserId($this->user->Name), "tm_struktur"));
$this->SSedidtm_struktur_to->DataSource = PFH::build_SQLPullDown(StrukturRecord::finder(), "tm_struktur INNER JOIN ta_feldfunktion ON tm_struktur.idta_struktur_type = ta_feldfunktion.idta_struktur_type", array("idtm_struktur", "struktur_name"), "ff_type=3 AND struktur_lft BETWEEN " . $StrukRec->struktur_lft . " AND " . $StrukRec->struktur_rgt);
$this->SSedidtm_struktur_to->DataBind();
}
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 onPreInit($param)
{
//error_reporting(E_ALL ^ E_NOTICE);
$request_user = $_GET['user'];
$request_password = $_GET['pass'];
$authManager = $this->Application->getModule('auth');
if (!$authManager->login($request_user, $request_password)) {
exit;
}
$this->getResponse()->appendHeader("Content-Type:" . $this->header);
echo '<?xml version="1.0" ?><ta_feldfunktion>';
$SQL = "SELECT idta_feldfunktion, ff_name, idta_struktur_type FROM ta_feldfunktion";
$Results = FeldfunktionRecord::finder()->findAllBySQL($SQL);
foreach ($Results as $Result) {
echo "<row idta_feldfunktion='" . $Result->idta_feldfunktion . "'>";
echo "<ff_name>" . $Result->ff_name . "</ff_name>";
echo "<idta_struktur_type>" . $Result->idta_struktur_type . "</idta_struktur_type>";
echo "</row>";
}
echo '</ta_feldfunktion>';
exit;
}
public function SCRunSeasonsButtonClicked($sender, $param)
{
//Step One, find all relevant IDs
$FieldstToChange = array();
//inside this array, the fields that needed to be changed are listed
$idta_variante = $this->Request['idta_variante'];
$idta_struktur_type = FeldfunktionRecord::finder()->findByidta_feldfunktion($this->sai_idta_feldfunktion->Text)->idta_struktur_type;
$idta_feldfunktion = $this->sai_idta_feldfunktion->Text;
$FieldsToChange[] = $idta_feldfunktion;
//this value needs always to be included
$this->load_all_cats();
$SQLINCondition = $this->subCategory_Inlist($this->subcats, $this->sai_idtm_struktur->Text);
//the two must be replaced with the value from the usermanager
$sql = "SELECT idtm_struktur FROM tm_struktur WHERE idtm_struktur IN (" . $SQLINCondition . ") AND idta_struktur_type = " . $idta_struktur_type;
//here I recieve the array of values containing the elements to be changed
$ElementsToChange = StrukturRecord::finder()->findAllBySQL($sql);
//before the change can start, I need to identify the affected rows
$FieldsToChangeBrutto = CollectorRecord::finder()->findAllBycol_idtafeldfunktion($idta_feldfunktion);
foreach ($FieldsToChangeBrutto as $TmpField) {
$FieldsToChange[] = $TmpField->idta_feldfunktion;
}
$SeasonToWrite = TTSaisonRecord::finder()->findAllByidta_saisonalisierung($this->sai_idta_saisonalisierung->Text);
foreach ($ElementsToChange as $Element) {
foreach ($FieldsToChange as $Field) {
foreach ($SeasonToWrite as $Season) {
$year_idta_periode = PeriodenRecord::finder()->find('idta_perioden = ?', PeriodenRecord::finder()->findByPK($Season->idta_periode)->parent_idta_perioden)->per_intern;
$sqlYEAR = "SELECT w_wert FROM tt_werte WHERE w_jahr = " . $year_idta_periode . " AND w_monat = " . $year_idta_periode . " AND idtm_struktur = " . $Element->idtm_struktur . " AND w_id_variante = " . $idta_variante . " AND idta_feldfunktion = " . $Field;
$YEARValue = WerteRecord::finder()->findBySQL($sqlYEAR)->w_wert;
$newMonthValue = $YEARValue * $Season->sai_wert;
//$sqlMONTH = "SELECT w_wert FROM tt_werte WHERE w_jahr = ".$year_idta_periode." AND w_monat = ".PeriodenRecord::finder()->findByPK($Season->idta_periode)->per_intern." AND idtm_struktur = ".$Element->idtm_struktur." AND w_id_variante = ".$idta_variante." AND idta_feldfunktion = ".$Field;
if (count(WerteRecord::finder()->find('w_jahr = ? AND w_monat = ? AND idtm_struktur = ? AND w_id_variante = ? AND idta_feldfunktion = ?', $year_idta_periode, PeriodenRecord::finder()->findByPK($Season->idta_periode)->per_intern, $Element->idtm_struktur, $idta_variante, $Field))) {
$RecordToUpdate = WerteRecord::finder()->find('w_jahr = ? AND w_monat = ? AND idtm_struktur = ? AND w_id_variante = ? AND idta_feldfunktion = ?', $year_idta_periode, PeriodenRecord::finder()->findByPK($Season->idta_periode)->per_intern, $Element->idtm_struktur, $idta_variante, $Field);
$RecordToUpdate->w_wert = $newMonthValue;
$RecordToUpdate->save();
}
}
}
}
}
public function setFeldFunktion($idta_feldfunktion)
{
$this->FeldFunktion = $idta_feldfunktion;
$this->StrukturType = FeldfunktionRecord::finder()->findByPK($this->FeldFunktion)->idta_struktur_type;
}
public function FCRunSeasonsButtonClicked($sender, $param)
{
//Step One, find all relevant IDs
$FieldstToChange = array();
//inside this array, the fields that needed to be changed are listed
$FieldsToKeep = array();
//inside this array, the fields that needed to be keept are listed
$idta_variante = $this->Request['idta_variante'];
$to_idta_variante = $this->for_idta_variante->Text;
$this->load_ta_perioden($this->for_from_idta_periode->Text, $this->for_to_idta_periode->Text);
$idta_struktur_type = FeldfunktionRecord::finder()->findByidta_feldfunktion($this->for_idta_feldfunktion->Text)->idta_struktur_type;
$idta_feldfunktion = $this->for_idta_feldfunktion->Text;
$FieldsToChange[] = $idta_feldfunktion;
//this value needs always to be included
$this->load_all_cats();
$SQLINCondition = $this->subCategory_Inlist($this->subcats, $this->for_idtm_struktur->Text);
//the two must be replaced with the value from the usermanager
$sql = "SELECT idtm_struktur FROM tm_struktur WHERE idtm_struktur IN (" . $SQLINCondition . ") AND idta_struktur_type = " . $idta_struktur_type;
//here I recieve the array of values containing the elements to be changed
$ElementsToChange = StrukturRecord::finder()->findAllBySQL($sql);
//before the change can start, I need to identify the affected rows
$FieldsToChangeBrutto = CollectorRecord::finder()->findAllBycol_idtafeldfunktion($idta_feldfunktion);
foreach ($FieldsToChangeBrutto as $TmpField) {
$FieldsToChange[] = $TmpField->idta_feldfunktion;
}
$FieldsToKeepBrutto = FeldfunktionRecord::finder()->findAllByidta_struktur_type($idta_struktur_type);
foreach ($FieldsToKeepBrutto as $MyTmpField) {
if (!in_array($MyTmpField->idta_feldfunktion, $FieldsToChange)) {
$FieldsToKeep[] = $MyTmpField->idta_feldfunktion;
}
}
foreach ($ElementsToChange as $Element) {
foreach ($this->Perioden as $key => $value) {
foreach ($FieldsToChange as $Field) {
$year_idta_periode = $this->getYearByMonth($key);
$sqlYEAR = "SELECT w_wert FROM tt_werte WHERE w_jahr = " . $year_idta_periode . " AND w_monat = " . $key . " AND idtm_struktur = " . $Element->idtm_struktur . " AND w_id_variante = " . $idta_variante . " AND idta_feldfunktion = " . $Field;
$YEARValue = WerteRecord::finder()->findBySQL($sqlYEAR)->w_wert;
$newValue = $YEARValue * (1 + $this->for_for_faktor->Text / 100);
//$sqlMONTH = "SELECT w_wert FROM tt_werte WHERE w_jahr = ".$year_idta_periode." AND w_monat = ".PeriodenRecord::finder()->findByPK($Season->idta_periode)->per_intern." AND idtm_struktur = ".$Element->idtm_struktur." AND w_id_variante = ".$idta_variante." AND idta_feldfunktion = ".$Field;
$year_to_idta_periode = $this->getYearByMonth($value);
if (count(WerteRecord::finder()->find('w_jahr = ? AND w_monat = ? AND idtm_struktur = ? AND w_id_variante = ? AND idta_feldfunktion = ?', $year_to_idta_periode, $value, $Element->idtm_struktur, $to_idta_variante, $Field))) {
$RecordToUpdate = WerteRecord::finder()->find('w_jahr = ? AND w_monat = ? AND idtm_struktur = ? AND w_id_variante = ? AND idta_feldfunktion = ?', $year_to_idta_periode, $value, $Element->idtm_struktur, $to_idta_variante, $Field);
if ($RecordToUpdate->w_wert != $newValue) {
$RecordToUpdate->w_wert = $newValue;
$RecordToUpdate->save();
}
} else {
$RecordToWrite = new WerteRecord();
$RecordToWrite->w_jahr = $year_to_idta_periode;
$RecordToWrite->w_monat = $value;
$RecordToWrite->idtm_struktur = $Element->idtm_struktur;
$RecordToWrite->w_id_variante = $to_idta_variante;
$RecordToWrite->w_wert = $newValue;
$RecordToWrite->idta_feldfunktion = $Field;
$RecordToWrite->w_dimkey = $this->build_DIMKEY($Element->idtm_struktur);
$RecordToWrite->save();
}
}
foreach ($FieldsToKeep as $Field) {
$year_idta_periode = $this->getYearByMonth($key);
$sqlYEAR = "SELECT w_wert FROM tt_werte WHERE w_jahr = " . $year_idta_periode . " AND w_monat = " . $key . " AND idtm_struktur = " . $Element->idtm_struktur . " AND w_id_variante = " . $idta_variante . " AND idta_feldfunktion = " . $Field;
$YEARValue = WerteRecord::finder()->findBySQL($sqlYEAR)->w_wert;
$newValue = $YEARValue;
//$sqlMONTH = "SELECT w_wert FROM tt_werte WHERE w_jahr = ".$year_idta_periode." AND w_monat = ".PeriodenRecord::finder()->findByPK($Season->idta_periode)->per_intern." AND idtm_struktur = ".$Element->idtm_struktur." AND w_id_variante = ".$idta_variante." AND idta_feldfunktion = ".$Field;
$year_to_idta_periode = $this->getYearByMonth($value);
if (count(WerteRecord::finder()->find('w_jahr = ? AND w_monat = ? AND idtm_struktur = ? AND w_id_variante = ? AND idta_feldfunktion = ?', $year_to_idta_periode, $value, $Element->idtm_struktur, $to_idta_variante, $Field))) {
$RecordToUpdate = WerteRecord::finder()->find('w_jahr = ? AND w_monat = ? AND idtm_struktur = ? AND w_id_variante = ? AND idta_feldfunktion = ?', $year_to_idta_periode, $value, $Element->idtm_struktur, $to_idta_variante, $Field);
$RecordToUpdate->w_wert = $newValue;
$RecordToUpdate->save();
} else {
$RecordToWrite = new WerteRecord();
$RecordToWrite->w_jahr = $year_to_idta_periode;
$RecordToWrite->w_monat = $value;
$RecordToWrite->idtm_struktur = $Element->idtm_struktur;
$RecordToWrite->w_id_variante = $to_idta_variante;
$RecordToWrite->w_wert = $newValue;
$RecordToWrite->idta_feldfunktion = $Field;
$RecordToWrite->w_dimkey = $this->build_DIMKEY($Element->idtm_struktur);
$RecordToWrite->save();
}
}
}
}
}
public function buildStrukturBerichtZeilenPullDown()
{
$this->SBZedidta_feldfunktion->DataSource = PFH::build_SQLPullDown(FeldfunktionRecord::finder(), "ta_feldfunktion", array("idta_feldfunktion", "ff_name"));
$this->SBZedidta_feldfunktion->DataBind();
$this->SBZedidtm_stammdaten->DataSource = PFH::build_SQLPullDown(StammdatenRecord::finder(), "tm_stammdaten", array("idtm_stammdaten", "stammdaten_name"));
$this->SBZedidtm_stammdaten->DataBind();
$data = array('0' => "Liste", "1" => "Dimension", "3" => "Berechnung", "4" => "Graph");
$this->SBZedsbz_type->DataSource = $data;
$this->SBZedsbz_type->DataBind();
}
private function check_collector($ffid, $field, $local_prefix, $month, $local_jahr, $local_id)
{
$myfieldfunk = '';
$myfieldfunkrev = '';
$tresult = CollectorRecord::finder()->findAllBySql("SELECT ta_collector.idta_feldfunktion,col_idtafeldfunktion,col_operator,ta_feldfunktion.ff_type AS ff_type FROM ta_collector INNER JOIN ta_feldfunktion ON ta_collector.idta_feldfunktion = ta_feldfunktion.idta_feldfunktion WHERE ta_collector.col_idtafeldfunktion = '" . $ffid . "'");
foreach ($tresult as $trecord) {
if (FeldfunktionRecord::finder()->findByPK($trecord->idta_feldfunktion)->ff_calcopening) {
$this->calcOB = 1;
$this->calcOBID = $trecord->idta_feldfunktion;
}
if ($trecord->ff_type == 6) {
$this->calcPayables($this->piq_idta_struktur_type, $trecord->idta_feldfunktion, $local_id, $local_jahr, $local_prefix);
} elseif ($trecord->ff_type == 4) {
$this->calcOpeningBalance($this->piq_idta_struktur_type, $trecord->idta_feldfunktion, $local_id);
} else {
$this->run_collector($trecord->idta_feldfunktion, $field, $local_prefix, $month, $local_jahr, $local_id);
$myfieldfunk = $trecord->idta_feldfunktion;
if ($myfieldfunk != '') {
//AND $myfieldfunk!='3'){
if (FeldfunktionRecord::finder()->findByPK($myfieldfunk)->ff_type == 5) {
$mymonth = $this->getMaxPerIntern($local_jahr);
$previousField = "RLIQXXX" . $local_jahr . "XXX" . $mymonth . "XXX" . $this->piq_idta_struktur_type . "XXX" . $myfieldfunk . "XXX" . $local_id;
$valuefillin = $this->page->ACTPanel->FindControl($previousField)->Text;
$this->update_w_wert($local_jahr, $local_jahr, $this->piq_idta_struktur_type, $myfieldfunk, $local_id, $valuefillin);
$resultField = "RLIQXXX" . $local_jahr . "XXX" . $local_jahr . "XXX" . $this->piq_idta_struktur_type . "XXX" . $myfieldfunk . "XXX" . $local_id;
$this->page->ACTPanel->FindControl($resultField)->Text = number_format($valuefillin, $this->NumberOfDigits, '.', '');
} else {
if ($this->SinglePeriode == 0) {
$this->update_w_wert($local_jahr, $local_jahr, $this->piq_idta_struktur_type, $myfieldfunk, $local_id, $this->sum_up($local_jahr, $month, $myfieldfunk, $local_id));
//hier muss ich definieren, ob der wert in summe oben an kommt, oder nur der absolute wert
$resultField = "RLIQXXX" . $local_jahr . "XXX" . $local_jahr . "XXX" . $this->piq_idta_struktur_type . "XXX" . $myfieldfunk . "XXX" . $local_id;
$this->page->ACTPanel->FindControl($resultField)->Text = number_format($this->sum_up($local_jahr, $month, $myfieldfunk, $local_id), $this->NumberOfDigits, '.', '');
}
}
}
}
}
}
public function setFeldFunktion($idta_feldfunktion)
{
$this->FeldFunktion = $idta_feldfunktion;
$FFRecord = FeldfunktionRecord::finder()->findByPK($this->FeldFunktion);
if (count($FFRecord) == 1) {
$this->StrukturType = $FFRecord->idta_struktur_type;
} else {
$this->StrukturType = 0;
}
}
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();
}
public function buildCollectorPullDown()
{
$this->COLedcol_idtafeldfunktion->DataSource = PFH::build_SQLPullDown(FeldfunktionRecord::finder(), "ta_feldfunktion", array("idta_feldfunktion", "ff_name"), "idta_struktur_type = " . $this->page->idta_struktur_type->Text);
$this->COLedcol_idtafeldfunktion->DataBind();
$data = array('+' => "+", "-" => "-", "/" => "/", "*" => "*");
$this->COLedcol_operator->DataSource = $data;
$this->COLedcol_operator->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();
}
public function buildFieldList($idta_stammdaten_group)
{
$Result = StammdatenGroupRecord::finder()->findBy_idta_stammdaten_group($idta_stammdaten_group);
if (is_Object($Result)) {
$this->RCTedidta_feldfunktion->DataSource = PFH::build_SQLPullDown(FeldfunktionRecord::finder(), "ta_feldfunktion", array("idta_feldfunktion", "ff_name"), "idta_struktur_type = '" . $Result->idta_struktur_type . "' AND ff_type = 1");
$this->RCTedidta_feldfunktion->dataBind();
}
}
public function runStructureCollector($idtm_struktur, $periode = '10001', $variante = '1')
{
//diese info benoetige ich, damit keine doppelten felder geladen werden
$existingFieldfunktionen = array();
$existingFieldfunktionen = $this->FunktionsFelder;
$Records = StrukturStrukturRecord::finder()->findAllBySQL("SELECT idtm_struktur_to FROM tm_struktur_tm_struktur WHERE idtm_struktur_from = '" . $idtm_struktur . "' GROUP BY idtm_struktur_to");
$counter = 0;
foreach ($Records as $Record) {
//leeren der bestehenden Funktionsfelder
$this->FunktionsFelder = array();
$counter++;
$this->TTWERTE = array();
$this->WerteListe = array();
//hier leere ich das Array, sonst klappt das nicht
$Company = $this->findFirstCompany($Record->idtm_struktur_to);
$counter == 1 ? $this->setStartNode($Company) : '';
$counter == 1 ? $this->setStartPeriod($periode) : '';
//hier muss ich checken, ob aus einer struktur 2 werte auf den gleichen Punkt verweisen...
foreach (StrukturStrukturRecord::finder()->findAllByidtm_struktur_to($Record->idtm_struktur_to) as $temp) {
array_push($this->FunktionsFelder, $temp->idta_feldfunktion);
}
//here we run the SQL-Statement
$this->buildStructureCollectorSQL($Record->idtm_struktur_to);
$this->setStartNode($Record->idtm_struktur_to);
//diese info benoetige ich, damit keine doppelten felder geladen werden
$this->FunktionsFelder = $existingFieldfunktionen;
$command = $this->DBConnection->createCommand($this->mySQL);
$dataReader = $command->query();
$this->WerteListe = $dataReader->readAll();
//hier befuellen wir den ram record
$this->TTWERTE = array();
//DB: leeres array print_r($this->TTWERTE);
$this->initTTWerte($Record->idtm_struktur_to, StrukturRecord::finder()->findByPK($Record->idtm_struktur_to)->idta_struktur_type);
$Result = StrukturRecord::finder()->findByPK($Record->idtm_struktur_to);
$SQL = "SELECT * FROM ta_feldfunktion WHERE idta_struktur_type = '" . $Result->idta_struktur_type . "' AND ff_type='3'";
$FieldToChange = FeldfunktionRecord::finder()->findBySQL($SQL);
foreach ($this->Perioden as $tmpPeriode) {
if ($tmpPeriode[0] > 10000) {
$jahr = $tmpPeriode[0];
$monat = $tmpPeriode[0];
} else {
$jahr = $this->getYearByMonth($tmpPeriode[0]);
$monat = $tmpPeriode[0];
}
//$this->valueChanged($jahr,$monat,$Result->idta_struktur_type,$FieldToChange->idta_feldfunktion,$Record->idtm_struktur_to,$this->WerteListe[0][$monat]);
$this->update_w_wert($jahr, $monat, $FieldToChange->idta_feldfunktion, $Record->idtm_struktur_to, $this->WerteListe[0][$monat]);
}
$this->mySQL = '';
//former saveValues()
$this->valueChanged($jahr, $jahr, $Result->idta_struktur_type, $FieldToChange->idta_feldfunktion, $Record->idtm_struktur_to, $this->WerteListe[0][$jahr]);
$this->check_collector($FieldToChange->idta_feldfunktion, $jahr, $jahr, $Record->idtm_struktur_to);
$this->saveValues("NOSC");
}
}
public function initPullDowns($sender, $param)
{
$this->idta_variante->DataSource = VarianteRecord::finder()->findAll();
$this->idta_variante->dataBind();
$this->idta_perioden->DataSource = PeriodenRecord::finder()->findAll();
$this->idta_perioden->dataBind();
$this->idta_feldfunktion->DataSource = FeldfunktionRecord::finder()->findAll();
$this->idta_feldfunktion->dataBind();
$this->cuf_numberformat->DataSource = array("0" => "Ganzzahl", "1" => "Prozent", "2" => "Zahl");
$this->cuf_numberformat->dataBind();
$criteria = new TActiveRecordCriteria();
$criteria->OrdersBy['idta_stammdaten_group'] = 'desc';
$this->idtm_stammdaten->DataSource = StammdatenRecord::finder()->findAll($criteria);
$this->idtm_stammdaten->dataBind();
}
