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