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