public function get_PivotChildren($Node) { $SQL = "SELECT * FROM tm_pivot WHERE parent_idtm_pivot = '" . $Node->idtm_pivot . "'"; $Result = count(PivotRecord::finder()->findAllBySQL($SQL)); $SSQL = "SELECT * FROM tm_pivot WHERE "; $counter = 0; if ($Result >= 1) { foreach (PivotRecord::finder()->findAllBySQL($SQL) as $Results) { $counter == 0 ? $SSQL .= "idtm_pivot = '" . $Results->idtm_pivot . "'" : ($SSQL .= " OR idtm_pivot = '" . $Results->idtm_pivot . "'"); $counter++; } } else { $SSQL .= "idtm_pivot = '0'"; } return PivotRecord::finder()->findAllBySQL($SSQL); }
public function PBDSavedButtonClicked($sender, $param) { $tempus = 'PBDed' . $this->PBprimarykey; if ($this->PBDedPivot_edit_status->Text == '1') { $PBDeditRecord = PivotRecord::finder()->findByPK($this->{$tempus}->Text); } else { $PBDeditRecord = new PivotRecord(); } //HIDDEN foreach ($this->PBhiddenfields as $recordfield) { $edrecordfield = 'PBDed' . $recordfield; $PBDeditRecord->{$recordfield} = $this->{$edrecordfield}->Value; } //DATUM foreach ($this->PBdatfields as $recordfield) { $edrecordfield = 'PBDed' . $recordfield; $PBDeditRecord->{$recordfield} = date('Y-m-d', $this->{$edrecordfield}->TimeStamp); } //BOOL foreach ($this->PBboolfields as $recordfield) { $edrecordfield = 'PBDed' . $recordfield; $PBDeditRecord->{$recordfield} = $this->{$edrecordfield}->Checked ? 1 : 0; } foreach ($this->PBfields as $recordfield) { $edrecordfield = 'PBDed' . $recordfield; $PBDeditRecord->{$recordfield} = $this->{$edrecordfield}->Text; } $PBDeditRecord->save(); $this->bindListPivotValue(); }