public function SyncWithDimension($sender, $param)
{
$cleanmodul = '';
$SQL = "SELECT * FROM " . $this->Tedsend_tabelle->Text . " WHERE parent_id" . $this->Tedsend_tabelle->Text . " = " . $this->Tedsend_id->Text;
$cleanmodul = preg_replace("/(^t[a-z]\\_)/", "", $this->Tedsend_tabelle->Text);
preg_match("/(_[a-z])/", $cleanmodul, $matches);
if (count($matches) >= 1) {
$cleanmodul = preg_replace("/(_[a-z])/", ucfirst(substr($matches[1], 1, 1)), $cleanmodul);
}
$finderclass = ucfirst($cleanmodul) . "Record";
$AllRecordsToWrite = TActiveRecord::finder($finderclass)->findAllBySql($SQL);
$fieldToTransfer = $this->Tedsend_field->Text;
if (count($AllRecordsToWrite) > 0) {
foreach ($AllRecordsToWrite as $SingleRecord) {
$criteria = new TActiveRecordCriteria();
$criteria->Condition = 'idta_stammdaten_group = :stammdaten_group AND stammdaten_key_extern = :key_extern';
$criteria->Parameters[':stammdaten_group'] = $this->Tedidta_stammdaten_group->Text;
$criteria->Parameters[':key_extern'] = $this->Tedsend_tabelle->Text . $SingleRecord->{'id' . $this->Tedsend_tabelle->Text};
$RecordToChange = StammdatenRecord::finder()->find($criteria);
if (count($RecordToChange) == 0) {
$RecordToChange = new StammdatenRecord();
}
$RecordToChange->idta_stammdaten_group = $this->Tedidta_stammdaten_group->Text;
$RecordToChange->stammdaten_key_extern = $this->Tedsend_tabelle->Text . $SingleRecord->{'id' . $this->Tedsend_tabelle->Text};
$RecordToChange->stammdaten_name = $SingleRecord->{$fieldToTransfer};
$RecordToChange->save();
unset($RecordToChange);
}
}
}
public function transferCSVFile($sender, $param)
{
//check ob dimension schon besteht
if ($sender->Id == "CSVUploadFile") {
$idta_stammdaten_group = StammdatenGroupRecord::finder()->findBy_parent_idta_stammdaten_group($this->dim_idta_stammdaten_group->Text)->idta_stammdaten_group;
} else {
$idta_stammdaten_group = StammdatenGroupRecord::finder()->findBy_idta_stammdaten_group($this->dim_idta_stammdaten_group->Text)->idta_stammdaten_group;
}
//laden des Wertearrays
foreach ($this->ImportedValues as $row) {
foreach ($row as $key => $value) {
$MyCheckRecord = StammdatenRecord::finder()->findAll('stammdaten_name = ? AND idta_stammdaten_group = ?', $value, $idta_stammdaten_group);
if (count($MyCheckRecord) == 0) {
$NewStammdatenRecord = new StammdatenRecord();
$NewStammdatenRecord->idta_stammdaten_group = $idta_stammdaten_group;
$NewStammdatenRecord->stammdaten_name = $value;
$NewStammdatenRecord->stammdaten_key_extern = $value;
$NewStammdatenRecord->save();
}
}
}
$this->linkStammdaten($sender, $param);
}
public function createDimension($sender, $param)
{
$NewDimension = new StammdatenRecord();
$NewDimension->idta_stammdaten_group = $this->idta_stammdaten_group->Text;
$NewDimension->stammdaten_name = AutoMappingRecord::finder()->findByPK($sender->CommandParameter)->ti_label;
$NewDimension->save();
$this->bindListStammdatenValue();
}
public function RCSavedButtonClicked($sender, $param)
{
$tempus = 'RCed' . $this->RCprimarykey;
if ($this->RCedstammdaten_edit_status->Text == '1') {
$RCEditRecord = StammdatenRecord::finder()->findByPK($this->{$tempus}->Text);
} else {
$RCEditRecord = new StammdatenRecord();
}
//HIDDEN
foreach ($this->RChiddenfields as $recordfield) {
$edrecordfield = 'RCed' . $recordfield;
$RCEditRecord->{$recordfield} = $this->{$edrecordfield}->Value;
}
//DATUM
foreach ($this->RCdatfields as $recordfield) {
$edrecordfield = 'RCed' . $recordfield;
$RCEditRecord->{$recordfield} = date('Y-m-d', $this->{$edrecordfield}->TimeStamp);
}
//BOOL
foreach ($this->RCboolfields as $recordfield) {
$edrecordfield = 'RCed' . $recordfield;
$RCEditRecord->{$recordfield} = $this->{$edrecordfield}->Checked ? 1 : 0;
}
foreach ($this->RCfields as $recordfield) {
$edrecordfield = 'RCed' . $recordfield;
$RCEditRecord->{$recordfield} = $this->{$edrecordfield}->Text;
}
$RCEditRecord->save();
$this->RCTedidtm_stammdaten->Text = $RCEditRecord->idtm_stammdaten;
$this->bindListStammdatenValue();
}
