function Overtredingen($_deregel = null, $_decardinaliteitseigenschap = null, $_dehomogeneeigenschap = null) { $this->_deregel = $_deregel; $this->_decardinaliteitseigenschap = $_decardinaliteitseigenschap; $this->_dehomogeneeigenschap = $_dehomogeneeigenschap; if (!isset($_deregel)) { // get a Overtredingen based on its identifier // fill the attributes $me = array(); $me['de regel'] = DB_doquer("SELECT DISTINCT `f1`.`UserRule` AS `id`\r\n FROM ( SELECT DISTINCT fst.`UserRule`\r\n FROM \r\n ( SELECT DISTINCT F0.`I`, F1.`UserRule`\r\n FROM \r\n ( SELECT DISTINCT TODO.`I`, TODO.`I` AS i1 FROM `Violation` AS TODO WHERE TODO.`User`='" . $GLOBALS['ctxenv']['User'] . "'AND TODO.`Script`='" . $GLOBALS['ctxenv']['Script'] . "'\r\n ) AS F0, `violates2` AS F1\r\n WHERE F0.`I1`=F1.`Violation`\r\n ) AS fst\r\n WHERE fst.`UserRule` IS NOT NULL\r\n ) AS f1"); $me['de cardinaliteitseigenschap'] = DB_doquer("SELECT DISTINCT `f1`.`MultiplicityRule` AS `id`\r\n FROM ( SELECT DISTINCT fst.`MultiplicityRule`\r\n FROM \r\n ( SELECT DISTINCT F0.`I`, F1.`MultiplicityRule`\r\n FROM \r\n ( SELECT DISTINCT TODO.`I`, TODO.`I` AS i1 FROM `Violation` AS TODO WHERE TODO.`User`='" . $GLOBALS['ctxenv']['User'] . "'AND TODO.`Script`='" . $GLOBALS['ctxenv']['Script'] . "'\r\n ) AS F0, `violates3` AS F1\r\n WHERE F0.`I1`=F1.`Violation`\r\n ) AS fst\r\n WHERE fst.`MultiplicityRule` IS NOT NULL\r\n ) AS f1"); $me['de homogene eigenschap'] = DB_doquer("SELECT DISTINCT `f1`.`HomogeneousRule` AS `id`\r\n FROM ( SELECT DISTINCT fst.`HomogeneousRule`\r\n FROM \r\n ( SELECT DISTINCT F0.`I`, F1.`HomogeneousRule`\r\n FROM \r\n ( SELECT DISTINCT TODO.`I`, TODO.`I` AS i1 FROM `Violation` AS TODO WHERE TODO.`User`='" . $GLOBALS['ctxenv']['User'] . "'AND TODO.`Script`='" . $GLOBALS['ctxenv']['Script'] . "'\r\n ) AS F0, `violates4` AS F1\r\n WHERE F0.`I1`=F1.`Violation`\r\n ) AS fst\r\n WHERE fst.`HomogeneousRule` IS NOT NULL\r\n ) AS f1"); foreach ($me['de regel'] as $i0 => &$v0) { $v0['wordt overtreden door'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`display` AS `wordt overtreden door`\r\n FROM `UserRule`\r\n JOIN ( SELECT DISTINCT F0.`UserRule`, F1.`display`\r\n FROM `violates2` AS F0, `Violation` AS F1\r\n WHERE F0.`Violation`=F1.`I`\r\n ) AS f1\r\n ON `f1`.`UserRule`='" . addslashes($v0['id']) . "'\r\n WHERE `UserRule`.`I`='" . addslashes($v0['id']) . "'")); } unset($v0); foreach ($me['de cardinaliteitseigenschap'] as $i0 => &$v0) { $v0 = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0['id']) . "' AS `id`\r\n , `f2`.`display` AS `eigenschap`\r\n , `f3`.`on` AS `van relatie`\r\n FROM `MultiplicityRule`\r\n LEFT JOIN ( SELECT DISTINCT F0.`I`, F1.`display`\r\n FROM `MultiplicityRule` AS F0, `Prop` AS F1\r\n WHERE F0.`property`=F1.`I`\r\n ) AS f2\r\n ON `f2`.`I`='" . addslashes($v0['id']) . "'\r\n LEFT JOIN `MultiplicityRule` AS f3 ON `f3`.`I`='" . addslashes($v0['id']) . "'\r\n WHERE `MultiplicityRule`.`I`='" . addslashes($v0['id']) . "'")); $v0['wordt overtreden door'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`display` AS `wordt overtreden door`\r\n FROM `MultiplicityRule`\r\n JOIN ( SELECT DISTINCT F0.`MultiplicityRule`, F1.`display`\r\n FROM `violates3` AS F0, `Violation` AS F1\r\n WHERE F0.`Violation`=F1.`I`\r\n ) AS f1\r\n ON `f1`.`MultiplicityRule`='" . addslashes($v0['id']) . "'\r\n WHERE `MultiplicityRule`.`I`='" . addslashes($v0['id']) . "'")); } unset($v0); foreach ($me['de homogene eigenschap'] as $i0 => &$v0) { $v0 = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0['id']) . "' AS `id`\r\n , `f2`.`display` AS `eigenschap`\r\n , `f3`.`on` AS `van relatie`\r\n FROM `HomogeneousRule`\r\n LEFT JOIN ( SELECT DISTINCT F0.`I`, F1.`display`\r\n FROM `HomogeneousRule` AS F0, `Prop` AS F1\r\n WHERE F0.`property`=F1.`I`\r\n ) AS f2\r\n ON `f2`.`I`='" . addslashes($v0['id']) . "'\r\n LEFT JOIN `HomogeneousRule` AS f3 ON `f3`.`I`='" . addslashes($v0['id']) . "'\r\n WHERE `HomogeneousRule`.`I`='" . addslashes($v0['id']) . "'")); $v0['wordt overtreden door'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`display` AS `wordt overtreden door`\r\n FROM `HomogeneousRule`\r\n JOIN ( SELECT DISTINCT F0.`HomogeneousRule`, F1.`display`\r\n FROM `violates4` AS F0, `Violation` AS F1\r\n WHERE F0.`Violation`=F1.`I`\r\n ) AS f1\r\n ON `f1`.`HomogeneousRule`='" . addslashes($v0['id']) . "'\r\n WHERE `HomogeneousRule`.`I`='" . addslashes($v0['id']) . "'")); } unset($v0); $this->set_deregel($me['de regel']); $this->set_decardinaliteitseigenschap($me['de cardinaliteitseigenschap']); $this->set_dehomogeneeigenschap($me['de homogene eigenschap']); } }
function Session($id = null, $court = null, $panel = null, $city = null, $judge = null, $clerk = null, $scheduled = null, $dateofoccurence = null, $cases = null) { $this->_id = $id; $this->_court = $court; $this->_panel = $panel; $this->_city = $city; $this->_judge = $judge; $this->_clerk = $clerk; $this->_scheduled = $scheduled; $this->_dateofoccurence = $dateofoccurence; $this->_cases = $cases; if (!isset($court) && isset($id)) { // get a Session based on its identifier // check if it exists: $ctx = DB_doquer('SELECT DISTINCT fst.`AttSession` AS `i` FROM ( SELECT DISTINCT `i` AS `AttSession`, `i` FROM `session` ) AS fst WHERE fst.`AttSession` = \'' . addSlashes($id) . '\''); if (count($ctx) == 0) { $this->_new = true; } else { $this->_new = false; // fill the attributes $me = firstRow(DB_doquer("SELECT DISTINCT `judge`.`session` AS `id`\n , `session`.`location` AS `court`\n , `session`.`panel`\n , `session`.`clerk`\n , `session`.`scheduled`\n , `session`.`occured` AS `date of occurence`\n , `f1`.`seatedin` AS `city`\n FROM `judge`\n LEFT JOIN `session` ON `session`.`i`='" . addslashes($id) . "'\n LEFT JOIN ( SELECT DISTINCT F0.`i`, F1.`seatedin`\n FROM `session` AS F0, `court` AS F1\n WHERE F0.`location`=F1.`i`\n ) AS f1\n ON `f1`.`i`='" . addslashes($id) . "'\n WHERE `judge`.`session`='" . addslashes($id) . "'")); $me['judge'] = firstCol(DB_doquer("SELECT DISTINCT `judge`.`party` AS `judge`\n FROM `judge`\n WHERE `judge`.`session`='" . addslashes($id) . "'")); $me['cases'] = DB_doquer("SELECT DISTINCT `process`.`legalcase` AS `id`\n FROM `process`\n WHERE `process`.`session`='" . addslashes($id) . "'"); foreach ($me['cases'] as $i0 => &$v0) { $v0 = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0['id']) . "' AS `id`\n , '" . addslashes($v0['id']) . "' AS `nr`\n FROM `legalcase`\n WHERE `legalcase`.`i`='" . addslashes($v0['id']) . "'")); $v0['plaintiff'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`party` AS `plaintiff`\n FROM `legalcase`\n JOIN `plaintiff` AS f1 ON `f1`.`legalcase`='" . addslashes($v0['id']) . "'\n WHERE `legalcase`.`i`='" . addslashes($v0['id']) . "'")); $v0['defendant'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`party` AS `defendant`\n FROM `legalcase`\n JOIN `defendant` AS f1 ON `f1`.`LegalCase`='" . addslashes($v0['id']) . "'\n WHERE `legalcase`.`i`='" . addslashes($v0['id']) . "'")); } unset($v0); $this->set_court($me['court']); $this->set_panel($me['panel']); $this->set_city($me['city']); $this->set_judge($me['judge']); $this->set_clerk($me['clerk']); $this->set_scheduled($me['scheduled']); $this->set_dateofoccurence($me['date of occurence']); $this->set_cases($me['cases']); } } else { if (isset($id)) { // just check if it exists $ctx = DB_doquer('SELECT DISTINCT fst.`AttSession` AS `i` FROM ( SELECT DISTINCT `i` AS `AttSession`, `i` FROM `session` ) AS fst WHERE fst.`AttSession` = \'' . addSlashes($id) . '\''); $this->_new = count($ctx) == 0; } } }
function UserRule($id = null, $_uitleg = null, $_overtredingen = null, $_populatievansubexpressies = null, $_relaties = null, $_source = null, $_target = null, $_ganaarpattern = null, $_ganaarvorigeregel = null, $_ganaarvolgenderegel = null, $_Conceptueeldiagram = null) { $this->id = $id; $this->_uitleg = $_uitleg; $this->_overtredingen = $_overtredingen; $this->_populatievansubexpressies = $_populatievansubexpressies; $this->_relaties = $_relaties; $this->_source = $_source; $this->_target = $_target; $this->_ganaarpattern = $_ganaarpattern; $this->_ganaarvorigeregel = $_ganaarvorigeregel; $this->_ganaarvolgenderegel = $_ganaarvolgenderegel; $this->_Conceptueeldiagram = $_Conceptueeldiagram; if (!isset($_uitleg) && isset($id)) { // get a UserRule based on its identifier // check if it exists: $ctx = DB_doquer('SELECT DISTINCT fst.`AttUserRule` AS `I` FROM ( SELECT DISTINCT `I` AS `AttUserRule`, `I` FROM `UserRule` ) AS fst WHERE fst.`AttUserRule` = \'' . addSlashes($id) . '\''); if (count($ctx) == 0) { $this->_new = true; } else { $this->_new = false; // fill the attributes $me = firstRow(DB_doquer("SELECT DISTINCT `UserRule`.`I` AS `id`\r\n , `UserRule`.`pattern` AS `ga naar pattern`\r\n , `UserRule`.`previous` AS `ga naar vorige regel`\r\n , `UserRule`.`next` AS `ga naar volgende regel`\r\n , `f1`.`display` AS `uitleg`\r\n , `f2`.`source`\r\n , `f3`.`target`\r\n , `f4`.`display` AS `Conceptueel diagram`\r\n FROM `UserRule`\r\n LEFT JOIN ( SELECT DISTINCT F0.`I`, F1.`display`\r\n FROM `UserRule` AS F0, `Explanation` AS F1\r\n WHERE F0.`explanation`=F1.`I`\r\n ) AS f1\r\n ON `f1`.`I`='" . addslashes($id) . "'\r\n LEFT JOIN ( SELECT DISTINCT F0.`I`, F1.`source`\r\n FROM `UserRule` AS F0, `Type` AS F1\r\n WHERE F0.`type`=F1.`I`\r\n ) AS f2\r\n ON `f2`.`I`='" . addslashes($id) . "'\r\n LEFT JOIN ( SELECT DISTINCT F0.`I`, F1.`target`\r\n FROM `UserRule` AS F0, `Type` AS F1\r\n WHERE F0.`type`=F1.`I`\r\n ) AS f3\r\n ON `f3`.`I`='" . addslashes($id) . "'\r\n LEFT JOIN ( SELECT DISTINCT F0.`I`, F1.`display`\r\n FROM `UserRule` AS F0, `Picture` AS F1\r\n WHERE F0.`picture`=F1.`I`\r\n ) AS f4\r\n ON `f4`.`I`='" . addslashes($id) . "'\r\n WHERE `UserRule`.`I`='" . addslashes($id) . "'")); $me['overtredingen'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`display` AS `overtredingen`\r\n FROM `UserRule`\r\n JOIN ( SELECT DISTINCT F0.`UserRule`, F1.`display`\r\n FROM `violates2` AS F0, `Violation` AS F1\r\n WHERE F0.`Violation`=F1.`I`\r\n ) AS f1\r\n ON `f1`.`UserRule`='" . addslashes($id) . "'\r\n WHERE `UserRule`.`I`='" . addslashes($id) . "'")); $me['populatie van subexpressies'] = firstCol(DB_doquer("SELECT DISTINCT `SubExpression`.`I` AS `populatie van subexpressies`\r\n FROM `SubExpression`\r\n WHERE `SubExpression`.`subexpressionOf`='" . addslashes($id) . "'")); $me['relaties'] = firstCol(DB_doquer("SELECT DISTINCT `morphisms1`.`Relation` AS `relaties`\r\n FROM `UserRule`\r\n JOIN `morphisms1` ON `morphisms1`.`UserRule`='" . addslashes($id) . "'\r\n WHERE `UserRule`.`I`='" . addslashes($id) . "'")); $this->set_uitleg($me['uitleg']); $this->set_overtredingen($me['overtredingen']); $this->set_populatievansubexpressies($me['populatie van subexpressies']); $this->set_relaties($me['relaties']); $this->set_source($me['source']); $this->set_target($me['target']); $this->set_ganaarpattern($me['ga naar pattern']); $this->set_ganaarvorigeregel($me['ga naar vorige regel']); $this->set_ganaarvolgenderegel($me['ga naar volgende regel']); $this->set_Conceptueeldiagram($me['Conceptueel diagram']); } } else { if (isset($id)) { // just check if it exists $ctx = DB_doquer('SELECT DISTINCT fst.`AttUserRule` AS `I` FROM ( SELECT DISTINCT `I` AS `AttUserRule`, `I` FROM `UserRule` ) AS fst WHERE fst.`AttUserRule` = \'' . addSlashes($id) . '\''); $this->_new = count($ctx) == 0; } } }
function Magistrate($id = null, $court = null, $panel = null, $role = null, $Sessions = null) { $this->_id = $id; $this->_court = $court; $this->_panel = $panel; $this->_role = $role; $this->_Sessions = $Sessions; if (!isset($court) && isset($id)) { // get a Magistrate based on its identifier // check if it exists: $ctx = DB_doquer('SELECT DISTINCT fst.`AttParty` AS `i` FROM ( SELECT DISTINCT `i` AS `AttParty`, `i` FROM `party` ) AS fst WHERE fst.`AttParty` = \'' . addSlashes($id) . '\''); if (count($ctx) == 0) { $this->_new = true; } else { $this->_new = false; // fill the attributes $me = firstRow(DB_doquer("SELECT DISTINCT `party`.`i` AS `id`\n , `party`.`actsas` AS `role`\n FROM `party`\n WHERE `party`.`i`='" . addslashes($id) . "'")); $me['court'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`court`\n FROM `party`\n JOIN ( \n (SELECT DISTINCT Party, Court AS `court`\n FROM `clerk`\n ) UNION (SELECT DISTINCT F0.`party` AS `Party`, F1.`court`\n FROM `members` AS F0, `panel` AS F1\n WHERE F0.`Panel`=F1.`i`\n \n )\n ) AS f1\n ON `f1`.`Party`='" . addslashes($id) . "'\n WHERE `party`.`i`='" . addslashes($id) . "'")); $me['panel'] = firstCol(DB_doquer("SELECT DISTINCT `members`.`panel`\n FROM `members`\n WHERE `members`.`party`='" . addslashes($id) . "'")); $me['Sessions'] = DB_doquer("SELECT DISTINCT `f1`.`session` AS `id`\n FROM `party`\n JOIN ( \n (SELECT DISTINCT party, session\n FROM `judge`\n ) UNION (SELECT DISTINCT clerk AS `party`, i AS `session`\n FROM `session`\n \n )\n ) AS f1\n ON `f1`.`party`='" . addslashes($id) . "'\n WHERE `party`.`i`='" . addslashes($id) . "'"); foreach ($me['Sessions'] as $i0 => &$v0) { $v0 = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0['id']) . "' AS `id`\n , `f2`.`clerk`\n , `f3`.`scheduled`\n , `f4`.`seatedin` AS `city`\n , `f5`.`location`\n , `f6`.`panel`\n FROM `session`\n LEFT JOIN `session` AS f2 ON `f2`.`i`='" . addslashes($v0['id']) . "'\n LEFT JOIN `session` AS f3 ON `f3`.`i`='" . addslashes($v0['id']) . "'\n LEFT JOIN ( SELECT DISTINCT F0.`i`, F1.`seatedin`\n FROM `session` AS F0, `court` AS F1\n WHERE F0.`location`=F1.`i`\n ) AS f4\n ON `f4`.`i`='" . addslashes($v0['id']) . "'\n LEFT JOIN `session` AS f5 ON `f5`.`i`='" . addslashes($v0['id']) . "'\n LEFT JOIN `session` AS f6 ON `f6`.`i`='" . addslashes($v0['id']) . "'\n WHERE `session`.`i`='" . addslashes($v0['id']) . "'")); $v0['judge'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`party` AS `judge`\n FROM `session`\n JOIN `judge` AS f1 ON `f1`.`session`='" . addslashes($v0['id']) . "'\n WHERE `session`.`i`='" . addslashes($v0['id']) . "'")); $v1 = $v0['panel']; $v0['panel'] = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v1) . "' AS `id`\n , `f2`.`court`\n FROM `panel`\n LEFT JOIN `panel` AS f2 ON `f2`.`i`='" . addslashes($v1) . "'\n WHERE `panel`.`i`='" . addslashes($v1) . "'")); } unset($v0); $this->set_court($me['court']); $this->set_panel($me['panel']); $this->set_role($me['role']); $this->set_Sessions($me['Sessions']); } } else { if (isset($id)) { // just check if it exists $ctx = DB_doquer('SELECT DISTINCT fst.`AttParty` AS `i` FROM ( SELECT DISTINCT `i` AS `AttParty`, `i` FROM `party` ) AS fst WHERE fst.`AttParty` = \'' . addSlashes($id) . '\''); $this->_new = count($ctx) == 0; } } }
function Signal($id = null, $_source = null, $_target = null, $_relations = null, $_explanation = null, $_previous = null, $_next = null, $_pattern = null, $_contains = null) { $this->id = $id; $this->_source = $_source; $this->_target = $_target; $this->_relations = $_relations; $this->_explanation = $_explanation; $this->_previous = $_previous; $this->_next = $_next; $this->_pattern = $_pattern; $this->_contains = $_contains; if (!isset($_source) && isset($id)) { // get a Signal based on its identifier // check if it exists: $ctx = DB_doquer('SELECT DISTINCT fst.`AttSignal` AS `I` FROM ( SELECT DISTINCT `I` AS `AttSignal`, `I` FROM `Signal` ) AS fst WHERE fst.`AttSignal` = \'' . addSlashes($id) . '\''); if (count($ctx) == 0) { $this->_new = true; } else { $this->_new = false; // fill the attributes $me = firstRow(DB_doquer("SELECT DISTINCT `Signal`.`I` AS `id`\r\n , `Signal`.`previous`\r\n , `Signal`.`next`\r\n , `Signal`.`pattern`\r\n , `f1`.`source`\r\n , `f2`.`target`\r\n , `f3`.`display` AS `explanation`\r\n FROM `Signal`\r\n LEFT JOIN ( SELECT DISTINCT F0.`I`, F1.`source`\r\n FROM `Signal` AS F0, `Type` AS F1\r\n WHERE F0.`type`=F1.`I`\r\n ) AS f1\r\n ON `f1`.`I`='" . addslashes($id) . "'\r\n LEFT JOIN ( SELECT DISTINCT F0.`I`, F1.`target`\r\n FROM `Signal` AS F0, `Type` AS F1\r\n WHERE F0.`type`=F1.`I`\r\n ) AS f2\r\n ON `f2`.`I`='" . addslashes($id) . "'\r\n LEFT JOIN ( SELECT DISTINCT F0.`I`, F1.`display`\r\n FROM `Signal` AS F0, `Explanation` AS F1\r\n WHERE F0.`explanation`=F1.`I`\r\n ) AS f3\r\n ON `f3`.`I`='" . addslashes($id) . "'\r\n WHERE `Signal`.`I`='" . addslashes($id) . "'")); $me['relations'] = firstCol(DB_doquer("SELECT DISTINCT `morphisms2`.`Relation` AS `relations`\r\n FROM `Signal`\r\n JOIN `morphisms2` ON `morphisms2`.`Signal`='" . addslashes($id) . "'\r\n WHERE `Signal`.`I`='" . addslashes($id) . "'")); $me['contains'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`display` AS `contains`\r\n FROM `Signal`\r\n JOIN ( SELECT DISTINCT F0.`Signal`, F1.`display`\r\n FROM `contains3` AS F0, `Pair` AS F1\r\n WHERE F0.`Pair`=F1.`I`\r\n ) AS f1\r\n ON `f1`.`Signal`='" . addslashes($id) . "'\r\n WHERE `Signal`.`I`='" . addslashes($id) . "'")); $this->set_source($me['source']); $this->set_target($me['target']); $this->set_relations($me['relations']); $this->set_explanation($me['explanation']); $this->set_previous($me['previous']); $this->set_next($me['next']); $this->set_pattern($me['pattern']); $this->set_contains($me['contains']); } } else { if (isset($id)) { // just check if it exists $ctx = DB_doquer('SELECT DISTINCT fst.`AttSignal` AS `I` FROM ( SELECT DISTINCT `I` AS `AttSignal`, `I` FROM `Signal` ) AS fst WHERE fst.`AttSignal` = \'' . addSlashes($id) . '\''); $this->_new = count($ctx) == 0; } } }
function Party($id = null, $cases = null, $role = null, $authorized = null) { $this->_id = $id; $this->_cases = $cases; $this->_role = $role; $this->_authorized = $authorized; if (!isset($cases) && isset($id)) { // get a Party based on its identifier // check if it exists: $ctx = DB_doquer('SELECT DISTINCT fst.`AttParty` AS `i` FROM ( SELECT DISTINCT `i` AS `AttParty`, `i` FROM `party` ) AS fst WHERE fst.`AttParty` = \'' . addSlashes($id) . '\''); if (count($ctx) == 0) { $this->_new = true; } else { $this->_new = false; // fill the attributes $me = firstRow(DB_doquer("SELECT DISTINCT `party`.`i` AS `id`\n , `party`.`actsas` AS `role`\n FROM `party`\n WHERE `party`.`i`='" . addslashes($id) . "'")); $me['cases'] = DB_doquer("SELECT DISTINCT `f1`.`legalcase` AS `id`\n FROM `party`\n JOIN ( \n (SELECT DISTINCT party, legalcase\n FROM `plaintiff`\n ) UNION (SELECT DISTINCT party, legalcase\n FROM `defendant`\n \n )\n ) AS f1\n ON `f1`.`party`='" . addslashes($id) . "'\n WHERE `party`.`i`='" . addslashes($id) . "'"); $me['authorized'] = DB_doquer("SELECT DISTINCT `f1`.`document` AS `id`\n FROM `party`\n JOIN `authby` AS f1 ON `f1`.`Party`='" . addslashes($id) . "'\n WHERE `party`.`i`='" . addslashes($id) . "'"); foreach ($me['cases'] as $i0 => &$v0) { $v0 = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0['id']) . "' AS `id`\n , '" . addslashes($v0['id']) . "' AS `nr`\n , `f3`.`areaoflaw` AS `area of law`\n FROM `legalcase`\n LEFT JOIN `legalcase` AS f3 ON `f3`.`i`='" . addslashes($v0['id']) . "'\n WHERE `legalcase`.`i`='" . addslashes($v0['id']) . "'")); $v0['type of case'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`casetype` AS `type of case`\n FROM `legalcase`\n JOIN ( \n (SELECT DISTINCT F0.`legalcase`, F1.`casetype`\n FROM `appeal` AS F0, `legalcase` AS F1\n WHERE F0.`legalcase1`=F1.`i`\n ) UNION (SELECT DISTINCT F0.`legalcase`, F1.`casetype`\n FROM `appealtoadmincourt` AS F0, `legalcase` AS F1\n WHERE F0.`legalcase1`=F1.`i`\n ) UNION (SELECT DISTINCT F0.`legalcase`, F1.`casetype`\n FROM `objection` AS F0, `legalcase` AS F1\n WHERE F0.`legalcase1`=F1.`i`\n \n \n )\n ) AS f1\n ON `f1`.`legalcase`='" . addslashes($v0['id']) . "'\n WHERE `legalcase`.`i`='" . addslashes($v0['id']) . "'")); } unset($v0); foreach ($me['authorized'] as $i0 => &$v0) { $v0['representative'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`Party` AS `representative`\n FROM `document`\n JOIN `writtenauthof` AS f1 ON `f1`.`document`='" . addslashes($v0['id']) . "'\n WHERE `document`.`i`='" . addslashes($v0['id']) . "'")); } unset($v0); $this->set_cases($me['cases']); $this->set_role($me['role']); $this->set_authorized($me['authorized']); } } else { if (isset($id)) { // just check if it exists $ctx = DB_doquer('SELECT DISTINCT fst.`AttParty` AS `i` FROM ( SELECT DISTINCT `i` AS `AttParty`, `i` FROM `party` ) AS fst WHERE fst.`AttParty` = \'' . addSlashes($id) . '\''); $this->_new = count($ctx) == 0; } } }
function Relaties($_Relatielijst = null) { $this->_Relatielijst = $_Relatielijst; if (!isset($_Relatielijst)) { // get a Relaties based on its identifier // fill the attributes $me = array(); $me['Relatielijst'] = DB_doquer("SELECT DISTINCT `f1`.`I` AS `id`\r\n FROM ( SELECT DISTINCT fst.`I`\r\n FROM \r\n ( SELECT DISTINCT TODO.`I`, TODO.`I` AS i1 FROM `Relation` AS TODO WHERE TODO.`User`='" . $GLOBALS['ctxenv']['User'] . "'AND TODO.`Script`='" . $GLOBALS['ctxenv']['Script'] . "'\r\n ) AS fst\r\n WHERE fst.`I` IS NOT NULL\r\n ) AS f1"); foreach ($me['Relatielijst'] as $i0 => &$v0) { $v0 = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0['id']) . "' AS `id`\r\n , `f2`.`display` AS `voorbeeld`\r\n FROM `Relation`\r\n LEFT JOIN ( SELECT DISTINCT F0.`I`, F1.`display`\r\n FROM `Relation` AS F0, `PragmaExample` AS F1\r\n WHERE F0.`example`=F1.`I`\r\n ) AS f2\r\n ON `f2`.`I`='" . addslashes($v0['id']) . "'\r\n WHERE `Relation`.`I`='" . addslashes($v0['id']) . "'")); } unset($v0); $this->set_Relatielijst($me['Relatielijst']); } }
function Schedule($Process = null) { $this->_Process = $Process; if (!isset($Process)) { // get a Schedule based on its identifier // fill the attributes $me = array(); $me['Process'] = DB_doquer("SELECT DISTINCT `f1`.`Process` AS `id`\n FROM ( SELECT DISTINCT csnd.i AS `Process`\n FROM `process` AS csnd\n ) AS f1"); foreach ($me['Process'] as $i0 => &$v0) { $v0 = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0['id']) . "' AS `id`\n , '" . addslashes($v0['id']) . "' AS `nr`\n , `f3`.`session`\n , `f4`.`legalcase` AS `case`\n , `f5`.`scheduled`\n FROM `process`\n LEFT JOIN `process` AS f3 ON `f3`.`i`='" . addslashes($v0['id']) . "'\n LEFT JOIN `process` AS f4 ON `f4`.`i`='" . addslashes($v0['id']) . "'\n LEFT JOIN ( SELECT DISTINCT F0.`i`, F1.`scheduled`\n FROM `process` AS F0, `session` AS F1\n WHERE F0.`session`=F1.`i`\n ) AS f5\n ON `f5`.`i`='" . addslashes($v0['id']) . "'\n WHERE `process`.`i`='" . addslashes($v0['id']) . "'")); } unset($v0); $this->set_Process($me['Process']); } }
function Sessions($_Session = null) { $this->_Session = $_Session; if (!isset($_Session)) { // get a Sessions based on its identifier // fill the attributes $me = array(); $me['Session'] = DB_doquer("SELECT DISTINCT `f1`.`Id` AS `id`\r\n FROM ( SELECT DISTINCT csnd.Id\r\n FROM `SessieTbl` AS csnd\r\n ) AS f1"); foreach ($me['Session'] as $i0 => &$v0) { $v0 = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0['id']) . "' AS `id`\r\n , '" . addslashes($v0['id']) . "' AS `id`\r\n , `f3`.`ip`\r\n , `f4`.`Id` AS `file`\r\n FROM `SessieTbl`\r\n LEFT JOIN `SessieTbl` AS f3 ON `f3`.`Id`='" . addslashes($v0['id']) . "'\r\n LEFT JOIN `SessieTbl` AS f4 ON `f4`.`bestand`='" . addslashes($v0['id']) . "'\r\n WHERE `SessieTbl`.`Id`='" . addslashes($v0['id']) . "'")); } unset($v0); $this->set_Session($me['Session']); } }
function Ops($_Operations = null) { $this->_Operations = $_Operations; if (!isset($_Operations)) { // get a Ops based on its identifier // fill the attributes $me = array(); $me['Operations'] = DB_doquer("SELECT DISTINCT `f1`.`Id` AS `id`\r\n FROM ( SELECT DISTINCT csnd.Id\r\n FROM `OperationTbl` AS csnd\r\n ) AS f1"); foreach ($me['Operations'] as $i0 => &$v0) { $v0 = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0['id']) . "' AS `id`\r\n , `f2`.`name`\r\n , `f3`.`call`\r\n , `f4`.`output` AS `outputURL`\r\n FROM `OperationTbl`\r\n LEFT JOIN `OperationTbl` AS f2 ON `f2`.`Id`='" . addslashes($v0['id']) . "'\r\n LEFT JOIN `OperationTbl` AS f3 ON `f3`.`Id`='" . addslashes($v0['id']) . "'\r\n LEFT JOIN `OperationTbl` AS f4 ON `f4`.`Id`='" . addslashes($v0['id']) . "'\r\n WHERE `OperationTbl`.`Id`='" . addslashes($v0['id']) . "'")); } unset($v0); $this->set_Operations($me['Operations']); } }
function ISArelaties($_ISarelaties = null) { $this->_ISarelaties = $_ISarelaties; if (!isset($_ISarelaties)) { // get a ISArelaties based on its identifier // fill the attributes $me = array(); $me['IS-a relaties'] = DB_doquer("SELECT DISTINCT `f1`.`i` AS `id`\r\n FROM ( SELECT DISTINCT fst.`i`\r\n FROM \r\n ( SELECT DISTINCT TODO.`i`, TODO.`i` AS i1 FROM `isarelation` AS TODO WHERE TODO.`user`='" . $GLOBALS['ctxenv']['User'] . "'AND TODO.`script`='" . $GLOBALS['ctxenv']['Script'] . "'\r\n ) AS fst\r\n WHERE fst.`i` IS NOT NULL\r\n ) AS f1"); foreach ($me['IS-a relaties'] as $i0 => &$v0) { $v0 = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0['id']) . "' AS `id`\r\n , `f2`.`specific` AS `het specifieke concept`\r\n , `f3`.`general` AS `is een`\r\n , `f4`.`display` AS `pattern`\r\n FROM `isarelation`\r\n LEFT JOIN `isarelation` AS f2 ON `f2`.`i`='" . addslashes($v0['id']) . "'\r\n LEFT JOIN `isarelation` AS f3 ON `f3`.`i`='" . addslashes($v0['id']) . "'\r\n LEFT JOIN ( SELECT DISTINCT F0.`i`, F1.`display`\r\n FROM `isarelation` AS F0, `pattern` AS F1\r\n WHERE F0.`pattern`=F1.`i`\r\n ) AS f4\r\n ON `f4`.`i`='" . addslashes($v0['id']) . "'\r\n WHERE `isarelation`.`i`='" . addslashes($v0['id']) . "'")); } unset($v0); $this->set_ISarelaties($me['IS-a relaties']); } }
function Panels($Panels = null) { $this->_Panels = $Panels; if (!isset($Panels)) { // get a Panels based on its identifier // fill the attributes $me = array(); $me['Panels'] = DB_doquer("SELECT DISTINCT `f1`.`Panel` AS `id`\n FROM ( SELECT DISTINCT csnd.i AS `Panel`\n FROM `panel` AS csnd\n ) AS f1"); foreach ($me['Panels'] as $i0 => &$v0) { $v0 = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0['id']) . "' AS `id`\n , '" . addslashes($v0['id']) . "' AS `panel`\n , `f3`.`court`\n FROM `panel`\n LEFT JOIN `panel` AS f3 ON `f3`.`i`='" . addslashes($v0['id']) . "'\n WHERE `panel`.`i`='" . addslashes($v0['id']) . "'")); $v0['members'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`party` AS `members`\n FROM `panel`\n JOIN `members` AS f1 ON `f1`.`Panel`='" . addslashes($v0['id']) . "'\n WHERE `panel`.`i`='" . addslashes($v0['id']) . "'")); } unset($v0); $this->set_Panels($me['Panels']); } }
function InterestedParties($Interestedparties = null) { $this->_Interestedparties = $Interestedparties; if (!isset($Interestedparties)) { // get a InterestedParties based on its identifier // fill the attributes $me = array(); $me['Interested parties'] = DB_doquer("SELECT DISTINCT `f1`.`party` AS `id`\n FROM ( SELECT DISTINCT fst.`party`\n FROM \n ( \n (SELECT DISTINCT F0.`party` AS `party1`, F1.`party`\n FROM `plaintiff` AS F0, `plaintiff` AS F1\n WHERE F0.`legalcase`=F1.`legalcase`\n ) UNION (SELECT DISTINCT F0.`party` AS `party1`, F1.`party`\n FROM `defendant` AS F0, `defendant` AS F1\n WHERE F0.`LegalCase`=F1.`LegalCase`\n \n )\n ) AS fst\n WHERE fst.`party` IS NOT NULL\n ) AS f1"); foreach ($me['Interested parties'] as $i0 => &$v0) { $v0 = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0['id']) . "' AS `id`\n , '" . addslashes($v0['id']) . "' AS `name`\n , `f3`.`actsas` AS `role`\n FROM `party`\n LEFT JOIN `party` AS f3 ON `f3`.`i`='" . addslashes($v0['id']) . "'\n WHERE `party`.`i`='" . addslashes($v0['id']) . "'")); $v0['representative'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`Party` AS `representative`\n FROM `party`\n JOIN ( SELECT DISTINCT F0.`Party`\n FROM `authby` AS F0, `writtenauthof` AS F1\n WHERE F0.`document`=F1.`document`\n ) AS f1\n ON `f1`.`Party`='" . addslashes($v0['id']) . "'\n WHERE `party`.`i`='" . addslashes($v0['id']) . "'")); } unset($v0); $this->set_Interestedparties($me['Interested parties']); } }
function Sessions($Sessions = null) { $this->_Sessions = $Sessions; if (!isset($Sessions)) { // get a Sessions based on its identifier // fill the attributes $me = array(); $me['Sessions'] = DB_doquer("SELECT DISTINCT `f1`.`Session` AS `id`\n FROM ( SELECT DISTINCT csnd.i AS `Session`\n FROM `session` AS csnd\n ) AS f1"); foreach ($me['Sessions'] as $i0 => &$v0) { $v0 = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0['id']) . "' AS `id`\n , '" . addslashes($v0['id']) . "' AS `nr`\n , `f3`.`panel`\n , `f4`.`location` AS `court`\n , `f5`.`seatedin` AS `city`\n , `f6`.`clerk`\n , `f7`.`scheduled`\n , `f8`.`occured` AS `date of occurence`\n FROM `session`\n LEFT JOIN `session` AS f3 ON `f3`.`i`='" . addslashes($v0['id']) . "'\n LEFT JOIN `session` AS f4 ON `f4`.`i`='" . addslashes($v0['id']) . "'\n LEFT JOIN ( SELECT DISTINCT F0.`i`, F1.`seatedin`\n FROM `session` AS F0, `court` AS F1\n WHERE F0.`location`=F1.`i`\n ) AS f5\n ON `f5`.`i`='" . addslashes($v0['id']) . "'\n LEFT JOIN `session` AS f6 ON `f6`.`i`='" . addslashes($v0['id']) . "'\n LEFT JOIN `session` AS f7 ON `f7`.`i`='" . addslashes($v0['id']) . "'\n LEFT JOIN `session` AS f8 ON `f8`.`i`='" . addslashes($v0['id']) . "'\n WHERE `session`.`i`='" . addslashes($v0['id']) . "'")); $v0['judge'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`party` AS `judge`\n FROM `session`\n JOIN `judge` AS f1 ON `f1`.`session`='" . addslashes($v0['id']) . "'\n WHERE `session`.`i`='" . addslashes($v0['id']) . "'")); } unset($v0); $this->set_Sessions($me['Sessions']); } }
function City($id = null, $courtoffice = null, $jurisdiction = null, $courtofappeal = null, $sessions = null) { $this->_id = $id; $this->_courtoffice = $courtoffice; $this->_jurisdiction = $jurisdiction; $this->_courtofappeal = $courtofappeal; $this->_sessions = $sessions; if (!isset($courtoffice) && isset($id)) { // get a City based on its identifier // check if it exists: $ctx = DB_doquer('SELECT DISTINCT fst.`AttCity` AS `i` FROM ( SELECT DISTINCT `i` AS `AttCity`, `i` FROM `city` ) AS fst WHERE fst.`AttCity` = \'' . addSlashes($id) . '\''); if (count($ctx) == 0) { $this->_new = true; } else { $this->_new = false; // fill the attributes $me = firstRow(DB_doquer("SELECT DISTINCT `city`.`i` AS `id`\n , `city`.`jurisdiction`\n , `f1`.`district` AS `court of appeal`\n FROM `city`\n LEFT JOIN ( SELECT DISTINCT F0.`i`, F1.`district`\n FROM `city` AS F0, `court` AS F1\n WHERE F0.`jurisdiction`=F1.`i`\n ) AS f1\n ON `f1`.`i`='" . addslashes($id) . "'\n WHERE `city`.`i`='" . addslashes($id) . "'")); $me['court office'] = firstCol(DB_doquer("SELECT DISTINCT `court`.`i` AS `court office`\n FROM `court`\n WHERE `court`.`seatedin`='" . addslashes($id) . "'")); $me['sessions'] = DB_doquer("SELECT DISTINCT `f1`.`i` AS `id`\n FROM `city`\n JOIN ( SELECT DISTINCT F0.`seatedin`, F1.`i`\n FROM `court` AS F0, `session` AS F1\n WHERE F0.`i`=F1.`location`\n ) AS f1\n ON `f1`.`seatedin`='" . addslashes($id) . "'\n WHERE `city`.`i`='" . addslashes($id) . "'"); foreach ($me['sessions'] as $i0 => &$v0) { $v0 = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0['id']) . "' AS `id`\n , '" . addslashes($v0['id']) . "' AS `Session`\n , `f3`.`scheduled`\n , `f4`.`panel`\n FROM `session`\n LEFT JOIN `session` AS f3 ON `f3`.`i`='" . addslashes($v0['id']) . "'\n LEFT JOIN `session` AS f4 ON `f4`.`i`='" . addslashes($v0['id']) . "'\n WHERE `session`.`i`='" . addslashes($v0['id']) . "'")); $v0['judge'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`party` AS `judge`\n FROM `session`\n JOIN `judge` AS f1 ON `f1`.`session`='" . addslashes($v0['id']) . "'\n WHERE `session`.`i`='" . addslashes($v0['id']) . "'")); } unset($v0); $this->set_courtoffice($me['court office']); $this->set_jurisdiction($me['jurisdiction']); $this->set_courtofappeal($me['court of appeal']); $this->set_sessions($me['sessions']); } } else { if (isset($id)) { // just check if it exists $ctx = DB_doquer('SELECT DISTINCT fst.`AttCity` AS `i` FROM ( SELECT DISTINCT `i` AS `AttCity`, `i` FROM `city` ) AS fst WHERE fst.`AttCity` = \'' . addSlashes($id) . '\''); $this->_new = count($ctx) == 0; } } }
function Documents($Documents = null) { $this->_Documents = $Documents; if (!isset($Documents)) { // get a Documents based on its identifier // fill the attributes $me = array(); $me['Documents'] = DB_doquer("SELECT DISTINCT `f1`.`document` AS `id`\n FROM ( SELECT DISTINCT fst.`document`\n FROM \n ( SELECT DISTINCT isect0.`i` AS `document1`, isect0.`i` AS `document`\n FROM `document` AS isect0\n WHERE NOT EXISTS (SELECT *\n FROM \n ( SELECT DISTINCT F0.`document`, F1.`document` AS `document1`\n FROM `writtenauthof` AS F0, `writtenauthof` AS F1\n WHERE F0.`Party`=F1.`Party`\n ) AS cp\n WHERE isect0.`i`=cp.`document` AND isect0.`i`=cp.`document1`) AND isect0.`i` IS NOT NULL AND isect0.`i` IS NOT NULL\n ) AS fst\n WHERE fst.`document` IS NOT NULL\n ) AS f1"); foreach ($me['Documents'] as $i0 => &$v0) { $v0 = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0['id']) . "' AS `id`\n , '" . addslashes($v0['id']) . "' AS `nr`\n , `f3`.`documenttype` AS `type`\n FROM `document`\n LEFT JOIN `document` AS f3 ON `f3`.`i`='" . addslashes($v0['id']) . "'\n WHERE `document`.`i`='" . addslashes($v0['id']) . "'")); $v0['area of law'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`areaoflaw` AS `area of law`\n FROM `document`\n JOIN ( SELECT DISTINCT F0.`document`, F1.`areaoflaw`\n FROM `casefile` AS F0, `legalcase` AS F1\n WHERE F0.`LegalCase`=F1.`i`\n ) AS f1\n ON `f1`.`document`='" . addslashes($v0['id']) . "'\n WHERE `document`.`i`='" . addslashes($v0['id']) . "'")); $v0['type of case'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`casetype` AS `type of case`\n FROM `document`\n JOIN ( SELECT DISTINCT F0.`document`, F1.`casetype`\n FROM `casefile` AS F0, \n ( \n (SELECT DISTINCT F0.`legalcase`, F1.`casetype`\n FROM `appeal` AS F0, `legalcase` AS F1\n WHERE F0.`legalcase1`=F1.`i`\n ) UNION (SELECT DISTINCT F0.`legalcase`, F1.`casetype`\n FROM `appealtoadmincourt` AS F0, `legalcase` AS F1\n WHERE F0.`legalcase1`=F1.`i`\n ) UNION (SELECT DISTINCT F0.`legalcase`, F1.`casetype`\n FROM `objection` AS F0, `legalcase` AS F1\n WHERE F0.`legalcase1`=F1.`i`\n \n \n )\n ) AS F1\n WHERE F0.`LegalCase`=F1.`legalcase`\n ) AS f1\n ON `f1`.`document`='" . addslashes($v0['id']) . "'\n WHERE `document`.`i`='" . addslashes($v0['id']) . "'")); } unset($v0); $this->set_Documents($me['Documents']); } }
function Representatives($Representatives = null) { $this->_Representatives = $Representatives; if (!isset($Representatives)) { // get a Representatives based on its identifier // fill the attributes $me = array(); $me['Representatives'] = DB_doquer("SELECT DISTINCT `f1`.`Party` AS `id`\n FROM ( SELECT DISTINCT fst.`Party`\n FROM \n ( SELECT DISTINCT F0.`Party` AS `Party1`, F1.`Party`\n FROM `writtenauthof` AS F0, `writtenauthof` AS F1\n WHERE F0.`document`=F1.`document`\n ) AS fst\n WHERE fst.`Party` IS NOT NULL\n ) AS f1"); foreach ($me['Representatives'] as $i0 => &$v0) { $v0 = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0['id']) . "' AS `id`\n , '" . addslashes($v0['id']) . "' AS `name`\n , `f3`.`actsas` AS `rol`\n FROM `party`\n LEFT JOIN `party` AS f3 ON `f3`.`i`='" . addslashes($v0['id']) . "'\n WHERE `party`.`i`='" . addslashes($v0['id']) . "'")); $v0['represents'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`Party` AS `represents`\n FROM `party`\n JOIN ( SELECT DISTINCT F0.`Party`\n FROM `writtenauthof` AS F0, `authby` AS F1\n WHERE F0.`document`=F1.`document`\n ) AS f1\n ON `f1`.`Party`='" . addslashes($v0['id']) . "'\n WHERE `party`.`i`='" . addslashes($v0['id']) . "'")); $v0['cases'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`LegalCase` AS `cases`\n FROM `party`\n JOIN ( SELECT DISTINCT F0.`Party`, F1.`LegalCase`\n FROM `writtenauthof` AS F0, `authfor` AS F1\n WHERE F0.`document`=F1.`document`\n ) AS f1\n ON `f1`.`Party`='" . addslashes($v0['id']) . "'\n WHERE `party`.`i`='" . addslashes($v0['id']) . "'")); } unset($v0); $this->set_Representatives($me['Representatives']); } }
function Cases($Cases = null) { $this->_Cases = $Cases; if (!isset($Cases)) { // get a Cases based on its identifier // fill the attributes $me = array(); $me['Cases'] = DB_doquer("SELECT DISTINCT `f1`.`LegalCase` AS `id`\n FROM ( SELECT DISTINCT csnd.i AS `LegalCase`\n FROM `legalcase` AS csnd\n ) AS f1"); foreach ($me['Cases'] as $i0 => &$v0) { $v0 = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0['id']) . "' AS `id`\n , '" . addslashes($v0['id']) . "' AS `nr`\n , `f3`.`areaoflaw` AS `area of law`\n FROM `legalcase`\n LEFT JOIN `legalcase` AS f3 ON `f3`.`i`='" . addslashes($v0['id']) . "'\n WHERE `legalcase`.`i`='" . addslashes($v0['id']) . "'")); $v0['session'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`session`\n FROM `legalcase`\n JOIN ( SELECT DISTINCT F0.`legalcase`, F1.`session`\n FROM `process` AS F0, `process` AS F1\n WHERE F0.`i`=F1.`i`\n ) AS f1\n ON `f1`.`legalcase`='" . addslashes($v0['id']) . "'\n WHERE `legalcase`.`i`='" . addslashes($v0['id']) . "'")); $v0['type of case'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`casetype` AS `type of case`\n FROM `legalcase`\n JOIN ( \n (SELECT DISTINCT F0.`legalcase`, F1.`casetype`\n FROM `appeal` AS F0, `legalcase` AS F1\n WHERE F0.`legalcase1`=F1.`i`\n ) UNION (SELECT DISTINCT F0.`legalcase`, F1.`casetype`\n FROM `appealtoadmincourt` AS F0, `legalcase` AS F1\n WHERE F0.`legalcase1`=F1.`i`\n ) UNION (SELECT DISTINCT F0.`legalcase`, F1.`casetype`\n FROM `objection` AS F0, `legalcase` AS F1\n WHERE F0.`legalcase1`=F1.`i`\n \n \n )\n ) AS f1\n ON `f1`.`legalcase`='" . addslashes($v0['id']) . "'\n WHERE `legalcase`.`i`='" . addslashes($v0['id']) . "'")); $v0['court'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`Court` AS `court`\n FROM `legalcase`\n JOIN `broughtbefore` AS f1 ON `f1`.`legalcase`='" . addslashes($v0['id']) . "'\n WHERE `legalcase`.`i`='" . addslashes($v0['id']) . "'")); } unset($v0); $this->set_Cases($me['Cases']); } }
function Authorizations($Authorizations = null) { $this->_Authorizations = $Authorizations; if (!isset($Authorizations)) { // get a Authorizations based on its identifier // fill the attributes $me = array(); $me['Authorizations'] = DB_doquer("SELECT DISTINCT `f1`.`document` AS `id`\n FROM ( SELECT DISTINCT fst.`document`\n FROM \n ( SELECT DISTINCT F0.`document` AS `document1`, F1.`document`\n FROM `writtenauthof` AS F0, `writtenauthof` AS F1\n WHERE F0.`Party`=F1.`Party`\n ) AS fst\n WHERE fst.`document` IS NOT NULL\n ) AS f1"); foreach ($me['Authorizations'] as $i0 => &$v0) { $v0 = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0['id']) . "' AS `id`\n , '" . addslashes($v0['id']) . "' AS `document`\n FROM `document`\n WHERE `document`.`i`='" . addslashes($v0['id']) . "'")); $v0['for'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`LegalCase` AS `for`\n FROM `document`\n JOIN `authfor` AS f1 ON `f1`.`document`='" . addslashes($v0['id']) . "'\n WHERE `document`.`i`='" . addslashes($v0['id']) . "'")); $v0['by'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`Party` AS `by`\n FROM `document`\n JOIN `authby` AS f1 ON `f1`.`document`='" . addslashes($v0['id']) . "'\n WHERE `document`.`i`='" . addslashes($v0['id']) . "'")); $v0['representative'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`Party` AS `representative`\n FROM `document`\n JOIN `writtenauthof` AS f1 ON `f1`.`document`='" . addslashes($v0['id']) . "'\n WHERE `document`.`i`='" . addslashes($v0['id']) . "'")); } unset($v0); $this->set_Authorizations($me['Authorizations']); } }
function Correspondence($id = null, $case = null, $type = null, $remark = null, $sentat = null, $receivedat = null) { $this->_id = $id; $this->_case = $case; $this->_type = $type; $this->_remark = $remark; $this->_sentat = $sentat; $this->_receivedat = $receivedat; if (!isset($case) && isset($id)) { // get a Correspondence based on its identifier // check if it exists: $ctx = DB_doquer('SELECT DISTINCT fst.`AttDocument` AS `i` FROM ( SELECT DISTINCT `i` AS `AttDocument`, `i` FROM `document` ) AS fst WHERE fst.`AttDocument` = \'' . addSlashes($id) . '\''); if (count($ctx) == 0) { $this->_new = true; } else { $this->_new = false; // fill the attributes $me = firstRow(DB_doquer("SELECT DISTINCT `document`.`i` AS `id`\n , `document`.`documenttype` AS `type`\n , `document`.`sent` AS `sent at`\n , `document`.`received` AS `received at`\n FROM `document`\n WHERE `document`.`i`='" . addslashes($id) . "'")); $me['case'] = firstCol(DB_doquer("SELECT DISTINCT `casefile`.`legalcase` AS `case`\n FROM `casefile`\n WHERE `casefile`.`document`='" . addslashes($id) . "'")); $me['remark'] = firstCol(DB_doquer("SELECT DISTINCT `remark`.`text` AS `remark`\n FROM `remark`\n WHERE `remark`.`document`='" . addslashes($id) . "'")); $this->set_case($me['case']); $this->set_type($me['type']); $this->set_remark($me['remark']); $this->set_sentat($me['sent at']); $this->set_receivedat($me['received at']); } } else { if (isset($id)) { // just check if it exists $ctx = DB_doquer('SELECT DISTINCT fst.`AttDocument` AS `i` FROM ( SELECT DISTINCT `i` AS `AttDocument`, `i` FROM `document` ) AS fst WHERE fst.`AttDocument` = \'' . addSlashes($id) . '\''); $this->_new = count($ctx) == 0; } } }
function Process($id = null, $session = null, $case = null) { $this->_id = $id; $this->_session = $session; $this->_case = $case; if (!isset($session) && isset($id)) { // get a Process based on its identifier // check if it exists: $ctx = DB_doquer('SELECT DISTINCT fst.`AttProcess` AS `i` FROM ( SELECT DISTINCT `i` AS `AttProcess`, `i` FROM `process` ) AS fst WHERE fst.`AttProcess` = \'' . addSlashes($id) . '\''); if (count($ctx) == 0) { $this->_new = true; } else { $this->_new = false; // fill the attributes $me = firstRow(DB_doquer("SELECT DISTINCT `process`.`i` AS `id`\n , `process`.`session`\n , `process`.`legalcase` AS `case`\n FROM `process`\n WHERE `process`.`i`='" . addslashes($id) . "'")); $v0 = $me['session']; $me['session'] = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0) . "' AS `id`\n , `f2`.`location` AS `court`\n , `f3`.`clerk`\n , `f4`.`scheduled`\n , `f5`.`occured` AS `date of occurence`\n FROM `session`\n LEFT JOIN `session` AS f2 ON `f2`.`i`='" . addslashes($v0) . "'\n LEFT JOIN `session` AS f3 ON `f3`.`i`='" . addslashes($v0) . "'\n LEFT JOIN `session` AS f4 ON `f4`.`i`='" . addslashes($v0) . "'\n LEFT JOIN `session` AS f5 ON `f5`.`i`='" . addslashes($v0) . "'\n WHERE `session`.`i`='" . addslashes($v0) . "'")); $me['session']['judge'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`party` AS `judge`\n FROM `session`\n JOIN `judge` AS f1 ON `f1`.`session`='" . addslashes($v0) . "'\n WHERE `session`.`i`='" . addslashes($v0) . "'")); $v0 = $me['case']; $me['case'] = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0) . "' AS `id`\n , `f2`.`areaoflaw` AS `area of law`\n FROM `legalcase`\n LEFT JOIN `legalcase` AS f2 ON `f2`.`i`='" . addslashes($v0) . "'\n WHERE `legalcase`.`i`='" . addslashes($v0) . "'")); $me['case']['type of case'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`casetype` AS `type of case`\n FROM `legalcase`\n JOIN ( \n (SELECT DISTINCT F0.`legalcase`, F1.`casetype`\n FROM `appeal` AS F0, `legalcase` AS F1\n WHERE F0.`legalcase1`=F1.`i`\n ) UNION (SELECT DISTINCT F0.`legalcase`, F1.`casetype`\n FROM `appealtoadmincourt` AS F0, `legalcase` AS F1\n WHERE F0.`legalcase1`=F1.`i`\n ) UNION (SELECT DISTINCT F0.`legalcase`, F1.`casetype`\n FROM `objection` AS F0, `legalcase` AS F1\n WHERE F0.`legalcase1`=F1.`i`\n \n \n )\n ) AS f1\n ON `f1`.`legalcase`='" . addslashes($v0) . "'\n WHERE `legalcase`.`i`='" . addslashes($v0) . "'")); $me['case']['session'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`session`\n FROM `legalcase`\n JOIN ( SELECT DISTINCT F0.`legalcase`, F1.`session`\n FROM `process` AS F0, `process` AS F1\n WHERE F0.`i`=F1.`i`\n ) AS f1\n ON `f1`.`legalcase`='" . addslashes($v0) . "'\n WHERE `legalcase`.`i`='" . addslashes($v0) . "'")); $this->set_session($me['session']); $this->set_case($me['case']); } } else { if (isset($id)) { // just check if it exists $ctx = DB_doquer('SELECT DISTINCT fst.`AttProcess` AS `i` FROM ( SELECT DISTINCT `i` AS `AttProcess`, `i` FROM `process` ) AS fst WHERE fst.`AttProcess` = \'' . addSlashes($id) . '\''); $this->_new = count($ctx) == 0; } } }
function Rule($id = null, $_source = null, $_target = null, $_overtredingen = null, $_uitleg = null, $_pattern = null) { $this->id = $id; $this->_source = $_source; $this->_target = $_target; $this->_overtredingen = $_overtredingen; $this->_uitleg = $_uitleg; $this->_pattern = $_pattern; if (!isset($_source) && isset($id)) { // get a Rule based on its identifier // check if it exists: $ctx = DB_doquer('SELECT DISTINCT fst.`AttRule` AS `I` FROM ( SELECT DISTINCT `I` AS `AttRule`, `I` FROM `Rule` ) AS fst WHERE fst.`AttRule` = \'' . addSlashes($id) . '\''); if (count($ctx) == 0) { $this->_new = true; } else { $this->_new = false; // fill the attributes $me = firstRow(DB_doquer("SELECT DISTINCT `Rule`.`I` AS `id`\r\n , `Rule`.`pattern`\r\n , `f1`.`source`\r\n , `f2`.`target`\r\n , `f3`.`display` AS `uitleg`\r\n FROM `Rule`\r\n LEFT JOIN ( SELECT DISTINCT F0.`I`, F1.`source`\r\n FROM `Rule` AS F0, `Type` AS F1\r\n WHERE F0.`type`=F1.`I`\r\n ) AS f1\r\n ON `f1`.`I`='" . addslashes($id) . "'\r\n LEFT JOIN ( SELECT DISTINCT F0.`I`, F1.`target`\r\n FROM `Rule` AS F0, `Type` AS F1\r\n WHERE F0.`type`=F1.`I`\r\n ) AS f2\r\n ON `f2`.`I`='" . addslashes($id) . "'\r\n LEFT JOIN ( SELECT DISTINCT F0.`I`, F1.`display`\r\n FROM `Rule` AS F0, `Explanation` AS F1\r\n WHERE F0.`explanation`=F1.`I`\r\n ) AS f3\r\n ON `f3`.`I`='" . addslashes($id) . "'\r\n WHERE `Rule`.`I`='" . addslashes($id) . "'")); $me['overtredingen'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`display` AS `overtredingen`\r\n FROM `Rule`\r\n JOIN ( SELECT DISTINCT F0.`Rule`, F1.`display`\r\n FROM `violates1` AS F0, `Violation` AS F1\r\n WHERE F0.`Violation`=F1.`I`\r\n ) AS f1\r\n ON `f1`.`Rule`='" . addslashes($id) . "'\r\n WHERE `Rule`.`I`='" . addslashes($id) . "'")); $this->set_source($me['source']); $this->set_target($me['target']); $this->set_overtredingen($me['overtredingen']); $this->set_uitleg($me['uitleg']); $this->set_pattern($me['pattern']); } } else { if (isset($id)) { // just check if it exists $ctx = DB_doquer('SELECT DISTINCT fst.`AttRule` AS `I` FROM ( SELECT DISTINCT `I` AS `AttRule`, `I` FROM `Rule` ) AS fst WHERE fst.`AttRule` = \'' . addSlashes($id) . '\''); $this->_new = count($ctx) == 0; } } }
function Bestand($id = null, $_path = null, $_filesession = null, $_compilations = null) { $this->id = $id; $this->_path = $_path; $this->_filesession = $_filesession; $this->_compilations = $_compilations; if (!isset($_path) && isset($id)) { // get a Bestand based on its identifier // check if it exists: $ctx = DB_doquer('SELECT DISTINCT fst.`AttBestand` AS `Id` FROM ( SELECT DISTINCT `Id` AS `AttBestand`, `Id` FROM `BestandTbl` ) AS fst WHERE fst.`AttBestand` = \'' . addSlashes($id) . '\''); if (count($ctx) == 0) { $this->_new = true; } else { $this->_new = false; // fill the attributes $me = firstRow(DB_doquer("SELECT DISTINCT `BestandTbl`.`Id` AS `id`\r\n , `BestandTbl`.`path`\r\n , `SessieTbl`.`Id` AS `filesession`\r\n FROM `BestandTbl`\r\n LEFT JOIN `SessieTbl` ON `SessieTbl`.`bestand`='" . addslashes($id) . "'\r\n WHERE `BestandTbl`.`Id`='" . addslashes($id) . "'")); $me['compilations'] = DB_doquer("SELECT DISTINCT `ActieTbl`.`Id` AS `id`\r\n FROM `ActieTbl`\r\n WHERE `ActieTbl`.`object`='" . addslashes($id) . "'"); foreach ($me['compilations'] as $i0 => &$v0) { $v0 = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0['id']) . "' AS `id`\r\n , '" . addslashes($v0['id']) . "' AS `id`\r\n , `f3`.`type` AS `operatie`\r\n FROM `ActieTbl`\r\n LEFT JOIN `ActieTbl` AS f3 ON `f3`.`Id`='" . addslashes($v0['id']) . "'\r\n WHERE `ActieTbl`.`Id`='" . addslashes($v0['id']) . "'")); } unset($v0); $this->set_path($me['path']); $this->set_filesession($me['filesession']); $this->set_compilations($me['compilations']); } } else { if (isset($id)) { // just check if it exists $ctx = DB_doquer('SELECT DISTINCT fst.`AttBestand` AS `Id` FROM ( SELECT DISTINCT `Id` AS `AttBestand`, `Id` FROM `BestandTbl` ) AS fst WHERE fst.`AttBestand` = \'' . addSlashes($id) . '\''); $this->_new = count($ctx) == 0; } } }
function Concept($id = null, $_beschrijving = null, $_populatie = null, $_toepassinginregels = null, $_Conceptueeldiagram = null) { $this->id = $id; $this->_beschrijving = $_beschrijving; $this->_populatie = $_populatie; $this->_toepassinginregels = $_toepassinginregels; $this->_Conceptueeldiagram = $_Conceptueeldiagram; if (!isset($_beschrijving) && isset($id)) { // get a Concept based on its identifier // check if it exists: $ctx = DB_doquer('SELECT DISTINCT fst.`AttConcept` AS `I` FROM ( SELECT DISTINCT `I` AS `AttConcept`, `I` FROM `Concept` ) AS fst WHERE fst.`AttConcept` = \'' . addSlashes($id) . '\''); if (count($ctx) == 0) { $this->_new = true; } else { $this->_new = false; // fill the attributes $me = firstRow(DB_doquer("SELECT DISTINCT `Concept`.`I` AS `id`\r\n , `f1`.`display` AS `beschrijving`\r\n , `f2`.`display` AS `Conceptueel diagram`\r\n FROM `Concept`\r\n LEFT JOIN ( SELECT DISTINCT F0.`I`, F1.`display`\r\n FROM `Concept` AS F0, `Explanation` AS F1\r\n WHERE F0.`description`=F1.`I`\r\n ) AS f1\r\n ON `f1`.`I`='" . addslashes($id) . "'\r\n LEFT JOIN ( SELECT DISTINCT F0.`I`, F1.`display`\r\n FROM `Concept` AS F0, `Picture` AS F1\r\n WHERE F0.`picture`=F1.`I`\r\n ) AS f2\r\n ON `f2`.`I`='" . addslashes($id) . "'\r\n WHERE `Concept`.`I`='" . addslashes($id) . "'")); $me['populatie'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`display` AS `populatie`\r\n FROM `Concept`\r\n JOIN ( SELECT DISTINCT F0.`Concept`, F1.`display`\r\n FROM `contains2` AS F0, `Atom` AS F1\r\n WHERE F0.`Atom`=F1.`I`\r\n ) AS f1\r\n ON `f1`.`Concept`='" . addslashes($id) . "'\r\n WHERE `Concept`.`I`='" . addslashes($id) . "'")); $me['toepassing in regel(s)'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`UserRule` AS `toepassing in regel(s)`\r\n FROM `Concept`\r\n JOIN ( SELECT DISTINCT F0.`source`, F2.`UserRule`\r\n FROM \r\n ( \r\n (SELECT DISTINCT source, I\r\n FROM `Type`\r\n ) UNION (SELECT DISTINCT target AS `source`, I\r\n FROM `Type`\r\n \r\n )\r\n ) AS F0, `relvar` AS F1, `morphisms1` AS F2\r\n WHERE F0.`I`=F1.`Type`\r\n AND F1.`Relation`=F2.`Relation`\r\n ) AS f1\r\n ON `f1`.`source`='" . addslashes($id) . "'\r\n WHERE `Concept`.`I`='" . addslashes($id) . "'")); $this->set_beschrijving($me['beschrijving']); $this->set_populatie($me['populatie']); $this->set_toepassinginregels($me['toepassing in regel(s)']); $this->set_Conceptueeldiagram($me['Conceptueel diagram']); } } else { if (isset($id)) { // just check if it exists $ctx = DB_doquer('SELECT DISTINCT fst.`AttConcept` AS `I` FROM ( SELECT DISTINCT `I` AS `AttConcept`, `I` FROM `Concept` ) AS fst WHERE fst.`AttConcept` = \'' . addSlashes($id) . '\''); $this->_new = count($ctx) == 0; } } }
function Document($id = null, $type = null, $case = null) { $this->_id = $id; $this->_type = $type; $this->_case = $case; if (!isset($type) && isset($id)) { // get a Document based on its identifier // check if it exists: $ctx = DB_doquer('SELECT DISTINCT fst.`AttDocument` AS `i` FROM ( SELECT DISTINCT `i` AS `AttDocument`, `i` FROM `document` ) AS fst WHERE fst.`AttDocument` = \'' . addSlashes($id) . '\''); if (count($ctx) == 0) { $this->_new = true; } else { $this->_new = false; // fill the attributes $me = firstRow(DB_doquer("SELECT DISTINCT `document`.`i` AS `id`\n , `document`.`documenttype` AS `type`\n FROM `document`\n WHERE `document`.`i`='" . addslashes($id) . "'")); $me['case'] = DB_doquer("SELECT DISTINCT `casefile`.`legalcase` AS `id`\n FROM `casefile`\n WHERE `casefile`.`document`='" . addslashes($id) . "'"); foreach ($me['case'] as $i0 => &$v0) { $v0 = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0['id']) . "' AS `id`\n , `f2`.`areaoflaw` AS `area of law`\n FROM `legalcase`\n LEFT JOIN `legalcase` AS f2 ON `f2`.`i`='" . addslashes($v0['id']) . "'\n WHERE `legalcase`.`i`='" . addslashes($v0['id']) . "'")); $v0['type of case'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`casetype` AS `type of case`\n FROM `legalcase`\n JOIN ( \n (SELECT DISTINCT F0.`legalcase`, F1.`casetype`\n FROM `appeal` AS F0, `legalcase` AS F1\n WHERE F0.`legalcase1`=F1.`i`\n ) UNION (SELECT DISTINCT F0.`legalcase`, F1.`casetype`\n FROM `appealtoadmincourt` AS F0, `legalcase` AS F1\n WHERE F0.`legalcase1`=F1.`i`\n ) UNION (SELECT DISTINCT F0.`legalcase`, F1.`casetype`\n FROM `objection` AS F0, `legalcase` AS F1\n WHERE F0.`legalcase1`=F1.`i`\n \n \n )\n ) AS f1\n ON `f1`.`legalcase`='" . addslashes($v0['id']) . "'\n WHERE `legalcase`.`i`='" . addslashes($v0['id']) . "'")); } unset($v0); $this->set_type($me['type']); $this->set_case($me['case']); } } else { if (isset($id)) { // just check if it exists $ctx = DB_doquer('SELECT DISTINCT fst.`AttDocument` AS `i` FROM ( SELECT DISTINCT `i` AS `AttDocument`, `i` FROM `document` ) AS fst WHERE fst.`AttDocument` = \'' . addSlashes($id) . '\''); $this->_new = count($ctx) == 0; } } }
function AreaOfLaw($id = null, $Cases = null) { $this->_id = $id; $this->_Cases = $Cases; if (!isset($Cases) && isset($id)) { // get a AreaOfLaw based on its identifier // check if it exists: $ctx = DB_doquer('SELECT DISTINCT fst.`AttAreaOfLaw` AS `i` FROM ( SELECT DISTINCT `i` AS `AttAreaOfLaw`, `i` FROM `areaoflaw` ) AS fst WHERE fst.`AttAreaOfLaw` = \'' . addSlashes($id) . '\''); if (count($ctx) == 0) { $this->_new = true; } else { $this->_new = false; // fill the attributes $me = array(); $me['Cases'] = DB_doquer("SELECT DISTINCT `legalcase`.`i` AS `id`\n FROM `legalcase`\n WHERE `legalcase`.`areaoflaw`='" . addslashes($id) . "'"); foreach ($me['Cases'] as $i0 => &$v0) { $v0 = firstRow(DB_doquer("SELECT DISTINCT '" . addslashes($v0['id']) . "' AS `id`\n , '" . addslashes($v0['id']) . "' AS `nr`\n FROM `legalcase`\n WHERE `legalcase`.`i`='" . addslashes($v0['id']) . "'")); $v0['type of case'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`casetype` AS `type of case`\n FROM `legalcase`\n JOIN ( \n (SELECT DISTINCT F0.`legalcase`, F1.`casetype`\n FROM `appeal` AS F0, `legalcase` AS F1\n WHERE F0.`legalcase1`=F1.`i`\n ) UNION (SELECT DISTINCT F0.`legalcase`, F1.`casetype`\n FROM `appealtoadmincourt` AS F0, `legalcase` AS F1\n WHERE F0.`legalcase1`=F1.`i`\n ) UNION (SELECT DISTINCT F0.`legalcase`, F1.`casetype`\n FROM `objection` AS F0, `legalcase` AS F1\n WHERE F0.`legalcase1`=F1.`i`\n \n \n )\n ) AS f1\n ON `f1`.`legalcase`='" . addslashes($v0['id']) . "'\n WHERE `legalcase`.`i`='" . addslashes($v0['id']) . "'")); } unset($v0); $this->set_Cases($me['Cases']); } } else { if (isset($id)) { // just check if it exists $ctx = DB_doquer('SELECT DISTINCT fst.`AttAreaOfLaw` AS `i` FROM ( SELECT DISTINCT `i` AS `AttAreaOfLaw`, `i` FROM `areaoflaw` ) AS fst WHERE fst.`AttAreaOfLaw` = \'' . addSlashes($id) . '\''); $this->_new = count($ctx) == 0; } } }
function Actie($id = null, $_file = null, $_operatie = null, $_compiled = null, $_error = null) { $this->id = $id; $this->_file = $_file; $this->_operatie = $_operatie; $this->_compiled = $_compiled; $this->_error = $_error; if (!isset($_file) && isset($id)) { // get a Actie based on its identifier // check if it exists: $ctx = DB_doquer('SELECT DISTINCT fst.`AttActie` AS `Id` FROM ( SELECT DISTINCT `Id` AS `AttActie`, `Id` FROM `ActieTbl` ) AS fst WHERE fst.`AttActie` = \'' . addSlashes($id) . '\''); if (count($ctx) == 0) { $this->_new = true; } else { $this->_new = false; // fill the attributes $me = firstRow(DB_doquer("SELECT DISTINCT `ActieTbl`.`Id` AS `id`\r\n , `ActieTbl`.`object` AS `file`\r\n , `ActieTbl`.`type` AS `operatie`\r\n , `ActieTbl`.`done` AS `compiled`\r\n , `ActieTbl`.`error`\r\n FROM `ActieTbl`\r\n WHERE `ActieTbl`.`Id`='" . addslashes($id) . "'")); $this->set_file($me['file']); $this->set_operatie($me['operatie']); $this->set_compiled($me['compiled']); $this->set_error($me['error']); } } else { if (isset($id)) { // just check if it exists $ctx = DB_doquer('SELECT DISTINCT fst.`AttActie` AS `Id` FROM ( SELECT DISTINCT `Id` AS `AttActie`, `Id` FROM `ActieTbl` ) AS fst WHERE fst.`AttActie` = \'' . addSlashes($id) . '\''); $this->_new = count($ctx) == 0; } } }
function Panel($id = null, $court = null, $members = null, $sessions = null) { $this->_id = $id; $this->_court = $court; $this->_members = $members; $this->_sessions = $sessions; if (!isset($court) && isset($id)) { // get a Panel based on its identifier // check if it exists: $ctx = DB_doquer('SELECT DISTINCT fst.`AttPanel` AS `i` FROM ( SELECT DISTINCT `i` AS `AttPanel`, `i` FROM `panel` ) AS fst WHERE fst.`AttPanel` = \'' . addSlashes($id) . '\''); if (count($ctx) == 0) { $this->_new = true; } else { $this->_new = false; // fill the attributes $me = firstRow(DB_doquer("SELECT DISTINCT `panel`.`i` AS `id`\n , `panel`.`court`\n FROM `panel`\n WHERE `panel`.`i`='" . addslashes($id) . "'")); $me['members'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`party` AS `members`\n FROM `panel`\n JOIN `members` AS f1 ON `f1`.`Panel`='" . addslashes($id) . "'\n WHERE `panel`.`i`='" . addslashes($id) . "'")); $me['sessions'] = firstCol(DB_doquer("SELECT DISTINCT `session`.`i` AS `sessions`\n FROM `session`\n WHERE `session`.`panel`='" . addslashes($id) . "'")); $this->set_court($me['court']); $this->set_members($me['members']); $this->set_sessions($me['sessions']); } } else { if (isset($id)) { // just check if it exists $ctx = DB_doquer('SELECT DISTINCT fst.`AttPanel` AS `i` FROM ( SELECT DISTINCT `i` AS `AttPanel`, `i` FROM `panel` ) AS fst WHERE fst.`AttPanel` = \'' . addSlashes($id) . '\''); $this->_new = count($ctx) == 0; } } }
function Pattern($id = null, $_regels = null, $_relaties = null, $_Conceptueeldiagram = null) { $this->id = $id; $this->_regels = $_regels; $this->_relaties = $_relaties; $this->_Conceptueeldiagram = $_Conceptueeldiagram; if (!isset($_regels) && isset($id)) { // get a Pattern based on its identifier // check if it exists: $ctx = DB_doquer('SELECT DISTINCT fst.`AttPattern` AS `I` FROM ( SELECT DISTINCT `I` AS `AttPattern`, `I` FROM `Pattern` ) AS fst WHERE fst.`AttPattern` = \'' . addSlashes($id) . '\''); if (count($ctx) == 0) { $this->_new = true; } else { $this->_new = false; // fill the attributes $me = firstRow(DB_doquer("SELECT DISTINCT `Pattern`.`I` AS `id`\r\n , `f1`.`display` AS `Conceptueel diagram`\r\n FROM `Pattern`\r\n LEFT JOIN ( SELECT DISTINCT F0.`I`, F1.`display`\r\n FROM `Pattern` AS F0, `Picture` AS F1\r\n WHERE F0.`picture`=F1.`I`\r\n ) AS f1\r\n ON `f1`.`I`='" . addslashes($id) . "'\r\n WHERE `Pattern`.`I`='" . addslashes($id) . "'")); $me['regels'] = firstCol(DB_doquer("SELECT DISTINCT `UserRule`.`I` AS `regels`\r\n FROM `UserRule`\r\n WHERE `UserRule`.`pattern`='" . addslashes($id) . "'")); $me['relaties'] = firstCol(DB_doquer("SELECT DISTINCT `Relation`.`I` AS `relaties`\r\n FROM `Relation`\r\n WHERE `Relation`.`pattern`='" . addslashes($id) . "'")); $this->set_regels($me['regels']); $this->set_relaties($me['relaties']); $this->set_Conceptueeldiagram($me['Conceptueel diagram']); } } else { if (isset($id)) { // just check if it exists $ctx = DB_doquer('SELECT DISTINCT fst.`AttPattern` AS `I` FROM ( SELECT DISTINCT `I` AS `AttPattern`, `I` FROM `Pattern` ) AS fst WHERE fst.`AttPattern` = \'' . addSlashes($id) . '\''); $this->_new = count($ctx) == 0; } } }
function Populatie($id = null, $_voorbeeld = null, $_uitleg = null, $_populatie = null) { $this->id = $id; $this->_voorbeeld = $_voorbeeld; $this->_uitleg = $_uitleg; $this->_populatie = $_populatie; if (!isset($_voorbeeld) && isset($id)) { // get a Populatie based on its identifier // check if it exists: $ctx = DB_doquer('SELECT DISTINCT fst.`AttRelation` AS `I` FROM ( SELECT DISTINCT `I` AS `AttRelation`, `I` FROM `Relation` ) AS fst WHERE fst.`AttRelation` = \'' . addSlashes($id) . '\''); if (count($ctx) == 0) { $this->_new = true; } else { $this->_new = false; // fill the attributes $me = firstRow(DB_doquer("SELECT DISTINCT `Relation`.`I` AS `id`\r\n , `f1`.`display` AS `voorbeeld`\r\n , `f2`.`display` AS `uitleg`\r\n FROM `Relation`\r\n LEFT JOIN ( SELECT DISTINCT F0.`I`, F1.`display`\r\n FROM `Relation` AS F0, `PragmaExample` AS F1\r\n WHERE F0.`example`=F1.`I`\r\n ) AS f1\r\n ON `f1`.`I`='" . addslashes($id) . "'\r\n LEFT JOIN ( SELECT DISTINCT F0.`I`, F1.`display`\r\n FROM `Relation` AS F0, `Explanation` AS F1\r\n WHERE F0.`description`=F1.`I`\r\n ) AS f2\r\n ON `f2`.`I`='" . addslashes($id) . "'\r\n WHERE `Relation`.`I`='" . addslashes($id) . "'")); $me['populatie'] = firstCol(DB_doquer("SELECT DISTINCT `f1`.`display` AS `populatie`\r\n FROM `Relation`\r\n JOIN ( SELECT DISTINCT F0.`Relation`, F1.`display`\r\n FROM `contains1` AS F0, `Pair` AS F1\r\n WHERE F0.`Pair`=F1.`I`\r\n ) AS f1\r\n ON `f1`.`Relation`='" . addslashes($id) . "'\r\n WHERE `Relation`.`I`='" . addslashes($id) . "'")); $this->set_voorbeeld($me['voorbeeld']); $this->set_uitleg($me['uitleg']); $this->set_populatie($me['populatie']); } } else { if (isset($id)) { // just check if it exists $ctx = DB_doquer('SELECT DISTINCT fst.`AttRelation` AS `I` FROM ( SELECT DISTINCT `I` AS `AttRelation`, `I` FROM `Relation` ) AS fst WHERE fst.`AttRelation` = \'' . addSlashes($id) . '\''); $this->_new = count($ctx) == 0; } } }