function save()
{
DB_doquer('START TRANSACTION');
/**************************\
* All attributes are saved *
\**************************/
$me = array("id" => 1, "IS-a relaties" => $this->_ISarelaties);
foreach ($me['IS-a relaties'] as $i0 => $v0) {
if (isset($v0['id'])) {
DB_doquer("UPDATE `isarelation` SET `specific`='" . addslashes($v0['het specifieke concept']) . "', `general`='" . addslashes($v0['is een']) . "' WHERE `i`='" . addslashes($v0['id']) . "'", 5);
}
}
// no code for het specifieke concept,i in concept
// no code for is een,i in concept
foreach ($me['IS-a relaties'] as $i0 => $v0) {
DB_doquer("DELETE FROM `string` WHERE `i`='" . addslashes($v0['pattern']) . "'", 5);
}
foreach ($me['IS-a relaties'] as $i0 => $v0) {
$res = DB_doquer("INSERT IGNORE INTO `string` (`i`) VALUES ('" . addslashes($v0['pattern']) . "')", 5);
}
foreach ($me['IS-a relaties'] as $i0 => $v0) {
$res = DB_doquer("INSERT IGNORE INTO `containsconcept` (`i`) VALUES ('" . addslashes($v0['het specifieke concept']) . "')", 5);
}
foreach ($me['IS-a relaties'] as $i0 => $v0) {
$res = DB_doquer("INSERT IGNORE INTO `containsconcept` (`i`) VALUES ('" . addslashes($v0['is een']) . "')", 5);
}
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
DB_doquer('ROLLBACK');
return false;
}
function save()
{
DB_doquer('START TRANSACTION');
/**************************\
* All attributes are saved *
\**************************/
$me = array("id" => 1, "Session" => $this->_Session);
// no code for file,Id in BestandTbl
foreach ($me['Session'] as $i0 => $v0) {
if (isset($v0['id'])) {
DB_doquer("UPDATE `SessieTbl` SET `Id`='" . addslashes($v0['id']) . "', `ip`='" . addslashes($v0['ip']) . "', `bestand`=" . (null != $v0['file'] ? "'" . addslashes($v0['file']) . "'" : "NULL") . " WHERE `Id`='" . addslashes($v0['id']) . "'", 5);
}
}
// no code for id,Id in SessieTbl
// no code for file,bestand in SessieTbl
foreach ($me['Session'] as $i0 => $v0) {
DB_doquer("DELETE FROM `Text` WHERE `I`='" . addslashes($v0['ip']) . "'", 5);
}
foreach ($me['Session'] as $i0 => $v0) {
$res = DB_doquer("INSERT IGNORE INTO `Text` (`I`) VALUES ('" . addslashes($v0['ip']) . "')", 5);
}
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
DB_doquer('ROLLBACK');
return false;
}
function del()
{
DB_doquer('START TRANSACTION');
$me = array("id" => $this->getId(), "sessies" => $this->_sessies);
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
DB_doquer('ROLLBACK');
return false;
}
function del()
{
DB_doquer('START TRANSACTION');
$me = array("id" => $this->getId(), "populatie" => $this->_populatie);
foreach ($me['populatie'] as $i0 => $v0) {
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($v0) . "'", 5);
}
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
DB_doquer('ROLLBACK');
return false;
}
function save()
{
DB_doquer('START TRANSACTION');
/**************************\
* All attributes are saved *
\**************************/
$me = array("id" => 1, "Conceptenlijst" => $this->_Conceptenlijst);
// no code for Conceptenlijst,I in Concept
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
DB_doquer('ROLLBACK');
return false;
}
function save()
{
DB_doquer('START TRANSACTION');
/**************************\
* All attributes are saved *
\**************************/
$me = array("id" => 1, "Patternlijst" => $this->_Patternlijst);
// no code for regels die overtreden worden,I in UserRule
// no code for relaties waarvan een eigenschap overtreden wordt,I in Relation
// no code for Patternlijst,I in Pattern
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
DB_doquer('ROLLBACK');
return false;
}
function save()
{
DB_doquer('START TRANSACTION');
/**************************\
* All attributes are saved *
\**************************/
$me = array("id" => 1, "Operations" => $this->_Operations);
foreach ($me['Operations'] as $i0 => $v0) {
DB_doquer("DELETE FROM `OperationTbl` WHERE `Id`='" . addslashes($v0['id']) . "'", 5);
}
foreach ($me['Operations'] as $i0 => $v0) {
$res = DB_doquer("INSERT IGNORE INTO `OperationTbl` (`Id`,`name`,`call`,`output`) VALUES (" . (null != $v0['id'] ? "'" . addslashes($v0['id']) . "'" : "NULL") . ", '" . addslashes($v0['name']) . "', '" . addslashes($v0['call']) . "', '" . addslashes($v0['outputURL']) . "')", 5);
if ($res !== false && !isset($v0['id'])) {
$v0['id'] = mysql_insert_id();
}
}
foreach ($me['Operations'] as $i0 => $v0) {
DB_doquer("DELETE FROM `Text` WHERE `I`='" . addslashes($v0['name']) . "'", 5);
}
foreach ($me['Operations'] as $i0 => $v0) {
DB_doquer("DELETE FROM `Text` WHERE `I`='" . addslashes($v0['call']) . "'", 5);
}
foreach ($me['Operations'] as $i0 => $v0) {
$res = DB_doquer("INSERT IGNORE INTO `Text` (`I`) VALUES ('" . addslashes($v0['name']) . "')", 5);
}
foreach ($me['Operations'] as $i0 => $v0) {
$res = DB_doquer("INSERT IGNORE INTO `Text` (`I`) VALUES ('" . addslashes($v0['call']) . "')", 5);
}
foreach ($me['Operations'] as $i0 => $v0) {
DB_doquer("DELETE FROM `Compilation` WHERE `I`='" . addslashes($v0['outputURL']) . "'", 5);
}
foreach ($me['Operations'] as $i0 => $v0) {
$res = DB_doquer("INSERT IGNORE INTO `Compilation` (`I`) VALUES ('" . addslashes($v0['outputURL']) . "')", 5);
}
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
DB_doquer('ROLLBACK');
return false;
}
function save()
{
DB_doquer('START TRANSACTION');
/**************************\
* All attributes are saved *
\**************************/
$me = array("id" => 1, "Relatielijst" => $this->_Relatielijst);
// no code for Relatielijst,I in Relation
foreach ($me['Relatielijst'] as $i0 => $v0) {
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($v0['voorbeeld']) . "'", 5);
}
foreach ($me['Relatielijst'] as $i0 => $v0) {
$res = DB_doquer("INSERT IGNORE INTO `String` (`I`) VALUES ('" . addslashes($v0['voorbeeld']) . "')", 5);
}
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
DB_doquer('ROLLBACK');
return false;
}
function save()
{
DB_doquer('START TRANSACTION');
/****************************************\
* Attributes that will not be saved are: *
* -------------------------------------- *
\****************************************/
$me = array("id" => 1, "Cases" => $this->_Cases);
// no code for session,i in session
foreach ($me['Cases'] as $i0 => $v0) {
if (isset($v0['id'])) {
DB_doquer("UPDATE `legalcase` SET `i`='" . addslashes($v0['id']) . "', `areaoflaw`='" . addslashes($v0['area of law']) . "' WHERE `i`='" . addslashes($v0['nr']) . "'", 5);
}
}
// no code for nr,i in legalcase
// no code for Cases,legalcase in process
// no code for court,i in court
foreach ($me['Cases'] as $i0 => $v0) {
DB_doquer("DELETE FROM `areaoflaw` WHERE `i`='" . addslashes($v0['area of law']) . "'", 5);
}
foreach ($me['Cases'] as $i0 => $v0) {
$res = DB_doquer("INSERT IGNORE INTO `areaoflaw` (`i`) VALUES ('" . addslashes($v0['area of law']) . "')", 5);
}
foreach ($me['Cases'] as $i0 => $v0) {
foreach ($v0['type of case'] as $i1 => $v1) {
DB_doquer("DELETE FROM `casetype` WHERE `i`='" . addslashes($v1) . "'", 5);
}
}
foreach ($me['Cases'] as $i0 => $v0) {
foreach ($v0['type of case'] as $i1 => $v1) {
$res = DB_doquer("INSERT IGNORE INTO `casetype` (`i`) VALUES ('" . addslashes($v1) . "')", 5);
}
}
// no code for Cases,legalcase in plaintiff
// no code for nr,legalcase in plaintiff
// no code for session,session in judge
foreach ($me['Cases'] as $i0 => $v0) {
DB_doquer("DELETE FROM `broughtbefore` WHERE `legalcase`='" . addslashes($v0['id']) . "'", 5);
}
foreach ($me['Cases'] as $i0 => $v0) {
foreach ($v0['court'] as $court) {
$res = DB_doquer("INSERT IGNORE INTO `broughtbefore` (`court`,`legalcase`) VALUES ('" . addslashes($court) . "', '" . addslashes($v0['id']) . "')", 5);
}
}
if (!checkRule3()) {
$DB_err = '\\"Written authorizations for representatives of a case are not put in the case file\\"';
} else {
if (!checkRule4()) {
$DB_err = '\\"Every administrative case is either an appeal or an objection or an appeal to an administrative court. (Art.6:4 Awb)\\"';
} else {
if (!checkRule7()) {
$DB_err = '\\"a session can be identified by its panel, its city and its date.\\"';
} else {
if (!checkRule12()) {
$DB_err = '\\"An appeal lodged against a decision of an administrative authority of a province or municipality, or a water management board, or a region as referred to in article 21 of the 1993 Police Act, or of a joint body or public body established under the Joint Arrangements Act, falls within the jurisdiction of the district court within whose district the administrative authority has its seat. (art. 8:7 par.1 Awb.)\\"';
} else {
if (!checkRule13()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule14()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule15()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule18()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule19()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule20()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule21()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule22()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule23()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule24()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule25()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule34()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule35()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule36()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule37()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule39()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule40()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule42()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule44()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule48()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule53()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule56()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule57()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule59()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule60()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule61()) {
$DB_err = '\\"\\"';
} else {
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
DB_doquer('ROLLBACK');
return false;
}
function del()
{
DB_doquer('START TRANSACTION');
$me = array("id" => $this->getId(), "court office" => $this->_courtoffice, "jurisdiction" => $this->_jurisdiction, "court of appeal" => $this->_courtofappeal, "sessions" => $this->_sessions);
foreach ($me['sessions'] as $i0 => $v0) {
DB_doquer("DELETE FROM `date` WHERE `i`='" . addslashes($v0['scheduled']) . "'", 5);
}
foreach ($me['sessions'] as $i0 => $v0) {
DB_doquer("DELETE FROM `judge` WHERE `session`='" . addslashes($v0['id']) . "'", 5);
}
if (!checkRule1()) {
$DB_err = '\\"The plaintiff in an administrative case is a juristic person\\"';
} else {
if (!checkRule2()) {
$DB_err = '\\"The defendant in an administrative case is an administrative authority as referred to in art.1:1 Awb.\\"';
} else {
if (!checkRule5()) {
$DB_err = '\\"Every party is either a person or an organization or an administrative authority.\\"';
} else {
if (!checkRule7()) {
$DB_err = '\\"a session can be identified by its panel, its city and its date.\\"';
} else {
if (!checkRule8()) {
$DB_err = '\\"A judge at a session is a member of the panel that runs the session.\\"';
} else {
if (!checkRule9()) {
$DB_err = '\\"The clerk of a session must be the clerk of the court where the session is held.\\"';
} else {
if (!checkRule10()) {
$DB_err = '\\"All sessions are scheduled\\"';
} else {
if (!checkRule12()) {
$DB_err = '\\"An appeal lodged against a decision of an administrative authority of a province or municipality, or a water management board, or a region as referred to in article 21 of the 1993 Police Act, or of a joint body or public body established under the Joint Arrangements Act, falls within the jurisdiction of the district court within whose district the administrative authority has its seat. (art. 8:7 par.1 Awb.)\\"';
} else {
if (!checkRule27()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule29()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule31()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule33()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule34()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule38()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule39()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule40()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule41()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule42()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule43()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule44()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule46()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule47()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule48()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule49()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule51()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule52()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule53()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule54()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule55()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule56()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule57()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule58()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule59()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule60()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule61()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule62()) {
$DB_err = '\\"\\"';
} else {
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
DB_doquer('ROLLBACK');
return false;
}
function save()
{
DB_doquer('START TRANSACTION');
/****************************************\
* Attributes that will not be saved are: *
* -------------------------------------- *
\****************************************/
$me = array("id" => 1, "Process" => $this->_Process);
// no code for session,i in session
// no code for case,i in legalcase
foreach ($me['Process'] as $i0 => $v0) {
DB_doquer("DELETE FROM `process` WHERE `i`='" . addslashes($v0['id']) . "'", 5);
}
foreach ($me['Process'] as $i0 => $v0) {
$res = DB_doquer("INSERT IGNORE INTO `process` (`i`,`session`,`legalcase`) VALUES ('" . addslashes($v0['id']) . "', '" . addslashes($v0['session']) . "', '" . addslashes($v0['case']) . "')", 5);
if ($res !== false && !isset($v0['id'])) {
$v0['id'] = mysql_insert_id();
}
}
// no code for nr,i in process
foreach ($me['Process'] as $i0 => $v0) {
DB_doquer("DELETE FROM `date` WHERE `i`='" . addslashes($v0['scheduled']) . "'", 5);
}
foreach ($me['Process'] as $i0 => $v0) {
$res = DB_doquer("INSERT IGNORE INTO `date` (`i`) VALUES ('" . addslashes($v0['scheduled']) . "')", 5);
}
// no code for case,legalcase in plaintiff
// no code for session,session in judge
if (!checkRule3()) {
$DB_err = '\\"Written authorizations for representatives of a case are not put in the case file\\"';
} else {
if (!checkRule4()) {
$DB_err = '\\"Every administrative case is either an appeal or an objection or an appeal to an administrative court. (Art.6:4 Awb)\\"';
} else {
if (!checkRule7()) {
$DB_err = '\\"a session can be identified by its panel, its city and its date.\\"';
} else {
if (!checkRule10()) {
$DB_err = '\\"All sessions are scheduled\\"';
} else {
if (!checkRule13()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule15()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule19()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule21()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule23()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule25()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule34()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule35()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule36()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule37()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule39()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule42()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule44()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule47()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule48()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule49()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule57()) {
$DB_err = '\\"\\"';
} else {
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
DB_doquer('ROLLBACK');
return false;
}
function del()
{
DB_doquer('START TRANSACTION');
$me = array("id" => $this->getId(), "regels" => $this->_regels, "relaties" => $this->_relaties, "Conceptueel diagram" => $this->_Conceptueeldiagram);
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($me['Conceptueel diagram']) . "'", 5);
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
DB_doquer('ROLLBACK');
return false;
}
function save()
{
DB_doquer('START TRANSACTION');
/****************************************\
* Attributes that will not be saved are: *
* -------------------------------------- *
\****************************************/
$me = array("id" => 1, "Sessions" => $this->_Sessions);
foreach ($me['Sessions'] as $i0 => $v0) {
DB_doquer("DELETE FROM `session` WHERE `i`='" . addslashes($v0['id']) . "'", 5);
}
foreach ($me['Sessions'] as $i0 => $v0) {
$res = DB_doquer("INSERT IGNORE INTO `session` (`i`,`panel`,`location`,`clerk`,`scheduled`,`occured`) VALUES ('" . addslashes($v0['id']) . "', '" . addslashes($v0['panel']) . "', '" . addslashes($v0['court']) . "', '" . addslashes($v0['clerk']) . "', '" . addslashes($v0['scheduled']) . "', " . (null != $v0['date of occurence'] ? "'" . addslashes($v0['date of occurence']) . "'" : "NULL") . ")", 5);
if ($res !== false && !isset($v0['id'])) {
$v0['id'] = mysql_insert_id();
}
}
// no code for nr,i in session
// no code for city,i in city
// no code for court,i in court
// no code for judge,i in party
// no code for clerk,i in party
// no code for panel,i in panel
foreach ($me['Sessions'] as $i0 => $v0) {
DB_doquer("DELETE FROM `date` WHERE `i`='" . addslashes($v0['scheduled']) . "'", 5);
}
foreach ($me['Sessions'] as $i0 => $v0) {
DB_doquer("DELETE FROM `date` WHERE `i`='" . addslashes($v0['date of occurence']) . "'", 5);
}
foreach ($me['Sessions'] as $i0 => $v0) {
$res = DB_doquer("INSERT IGNORE INTO `date` (`i`) VALUES ('" . addslashes($v0['scheduled']) . "')", 5);
}
foreach ($me['Sessions'] as $i0 => $v0) {
$res = DB_doquer("INSERT IGNORE INTO `date` (`i`) VALUES ('" . addslashes($v0['date of occurence']) . "')", 5);
}
foreach ($me['Sessions'] as $i0 => $v0) {
DB_doquer("DELETE FROM `judge` WHERE `session`='" . addslashes($v0['id']) . "'", 5);
}
foreach ($me['Sessions'] as $i0 => $v0) {
foreach ($v0['judge'] as $judge) {
$res = DB_doquer("INSERT IGNORE INTO `judge` (`session`,`party`) VALUES ('" . addslashes($v0['id']) . "', '" . addslashes($judge) . "')", 5);
}
}
// no code for nr,session in judge
if (!checkRule1()) {
$DB_err = '\\"The plaintiff in an administrative case is a juristic person\\"';
} else {
if (!checkRule2()) {
$DB_err = '\\"The defendant in an administrative case is an administrative authority as referred to in art.1:1 Awb.\\"';
} else {
if (!checkRule5()) {
$DB_err = '\\"Every party is either a person or an organization or an administrative authority.\\"';
} else {
if (!checkRule7()) {
$DB_err = '\\"a session can be identified by its panel, its city and its date.\\"';
} else {
if (!checkRule8()) {
$DB_err = '\\"A judge at a session is a member of the panel that runs the session.\\"';
} else {
if (!checkRule9()) {
$DB_err = '\\"The clerk of a session must be the clerk of the court where the session is held.\\"';
} else {
if (!checkRule10()) {
$DB_err = '\\"All sessions are scheduled\\"';
} else {
if (!checkRule27()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule29()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule31()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule33()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule34()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule38()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule39()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule40()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule41()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule42()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule43()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule44()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule46()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule47()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule48()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule49()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule51()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule52()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule53()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule54()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule56()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule57()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule59()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule60()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule61()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule62()) {
$DB_err = '\\"\\"';
} else {
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
DB_doquer('ROLLBACK');
return false;
}
function display($tbl, $col, $id)
{
return firstRow(firstCol(DB_doquer("SELECT DISTINCT `" . $col . "` FROM `" . $tbl . "` WHERE `i`='" . addslashes($id) . "'")));
}
function del()
{
DB_doquer('START TRANSACTION');
$me = array("id" => $this->getId(), "session" => $this->_session, "case" => $this->_case);
DB_doquer("DELETE FROM `process` WHERE `i`='" . addslashes($me['id']) . "'", 5);
if (!checkRule3()) {
$DB_err = '\\"Written authorizations for representatives of a case are not put in the case file\\"';
} else {
if (!checkRule4()) {
$DB_err = '\\"Every administrative case is either an appeal or an objection or an appeal to an administrative court. (Art.6:4 Awb)\\"';
} else {
if (!checkRule7()) {
$DB_err = '\\"a session can be identified by its panel, its city and its date.\\"';
} else {
if (!checkRule13()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule15()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule19()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule21()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule23()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule25()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule34()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule35()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule36()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule37()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule39()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule42()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule44()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule48()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule57()) {
$DB_err = '\\"\\"';
} else {
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
DB_doquer('ROLLBACK');
return false;
}
function del()
{
DB_doquer('START TRANSACTION');
$me = array("id" => $this->getId(), "Cases" => $this->_Cases);
foreach ($me['Cases'] as $i0 => $v0) {
foreach ($v0['type of case'] as $i1 => $v1) {
DB_doquer("DELETE FROM `casetype` WHERE `i`='" . addslashes($v1) . "'", 5);
}
}
if (!checkRule3()) {
$DB_err = '\\"Written authorizations for representatives of a case are not put in the case file\\"';
} else {
if (!checkRule4()) {
$DB_err = '\\"Every administrative case is either an appeal or an objection or an appeal to an administrative court. (Art.6:4 Awb)\\"';
} else {
if (!checkRule12()) {
$DB_err = '\\"An appeal lodged against a decision of an administrative authority of a province or municipality, or a water management board, or a region as referred to in article 21 of the 1993 Police Act, or of a joint body or public body established under the Joint Arrangements Act, falls within the jurisdiction of the district court within whose district the administrative authority has its seat. (art. 8:7 par.1 Awb.)\\"';
} else {
if (!checkRule13()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule14()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule15()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule18()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule19()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule20()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule21()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule22()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule23()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule24()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule25()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule36()) {
$DB_err = '\\"\\"';
} else {
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
DB_doquer('ROLLBACK');
return false;
}
function del()
{
DB_doquer('START TRANSACTION');
$me = array("id" => $this->getId(), "uitleg" => $this->_uitleg, "overtredingen" => $this->_overtredingen, "populatie van subexpressies" => $this->_populatievansubexpressies, "relaties" => $this->_relaties, "source" => $this->_source, "target" => $this->_target, "ga naar pattern" => $this->_ganaarpattern, "ga naar vorige regel" => $this->_ganaarvorigeregel, "ga naar volgende regel" => $this->_ganaarvolgenderegel, "Conceptueel diagram" => $this->_Conceptueeldiagram);
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($me['uitleg']) . "'", 5);
foreach ($me['overtredingen'] as $i0 => $v0) {
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($v0) . "'", 5);
}
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($me['Conceptueel diagram']) . "'", 5);
DB_doquer("DELETE FROM `morphisms1` WHERE `UserRule`='" . addslashes($me['id']) . "'", 5);
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
DB_doquer('ROLLBACK');
return false;
}
function save()
{
DB_doquer('START TRANSACTION');
/****************************************\
* Attributes that will not be saved are: *
* -------------------------------------- *
\****************************************/
$me = array("id" => 1, "Judges" => $this->_Judges, "Clerks" => $this->_Clerks);
// no code for court,i in court
// no code for court,i in court
foreach ($me['Judges'] as $i0 => $v0) {
DB_doquer("DELETE FROM `party` WHERE `i`='" . addslashes($v0['id']) . "'", 5);
}
foreach ($me['Clerks'] as $i0 => $v0) {
DB_doquer("DELETE FROM `party` WHERE `i`='" . addslashes($v0['id']) . "'", 5);
}
foreach ($me['Judges'] as $i0 => $v0) {
$res = DB_doquer("INSERT IGNORE INTO `party` (`i`,`actsas`) VALUES ('" . addslashes($v0['id']) . "', '" . addslashes($v0['role']) . "')", 5);
if ($res !== false && !isset($v0['id'])) {
$v0['id'] = mysql_insert_id();
}
}
// no code for name,i in party
foreach ($me['Clerks'] as $i0 => $v0) {
$res = DB_doquer("INSERT IGNORE INTO `party` (`i`,`actsas`) VALUES ('" . addslashes($v0['id']) . "', '" . addslashes($v0['role']) . "')", 5);
if ($res !== false && !isset($v0['id'])) {
$v0['id'] = mysql_insert_id();
}
}
// no code for name,i in party
foreach ($me['Judges'] as $i0 => $v0) {
DB_doquer("DELETE FROM `role` WHERE `i`='" . addslashes($v0['role']) . "'", 5);
}
foreach ($me['Clerks'] as $i0 => $v0) {
DB_doquer("DELETE FROM `role` WHERE `i`='" . addslashes($v0['role']) . "'", 5);
}
foreach ($me['Judges'] as $i0 => $v0) {
$res = DB_doquer("INSERT IGNORE INTO `role` (`i`) VALUES ('" . addslashes($v0['role']) . "')", 5);
}
foreach ($me['Clerks'] as $i0 => $v0) {
$res = DB_doquer("INSERT IGNORE INTO `role` (`i`) VALUES ('" . addslashes($v0['role']) . "')", 5);
}
if (!checkRule1()) {
$DB_err = '\\"The plaintiff in an administrative case is a juristic person\\"';
} else {
if (!checkRule2()) {
$DB_err = '\\"The defendant in an administrative case is an administrative authority as referred to in art.1:1 Awb.\\"';
} else {
if (!checkRule5()) {
$DB_err = '\\"Every party is either a person or an organization or an administrative authority.\\"';
} else {
if (!checkRule8()) {
$DB_err = '\\"A judge at a session is a member of the panel that runs the session.\\"';
} else {
if (!checkRule9()) {
$DB_err = '\\"The clerk of a session must be the clerk of the court where the session is held.\\"';
} else {
if (!checkRule27()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule29()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule31()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule33()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule40()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule41()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule43()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule45()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule46()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule51()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule53()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule56()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule59()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule60()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule61()) {
$DB_err = '\\"\\"';
} else {
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
DB_doquer('ROLLBACK');
return false;
}
function del()
{
DB_doquer('START TRANSACTION');
$me = array("id" => $this->getId(), "type Document" => $this->_typeDocument);
if (!checkRule3()) {
$DB_err = '\\"Written authorizations for representatives of a case are not put in the case file\\"';
} else {
if (!checkRule16()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule17()) {
$DB_err = '\\"\\"';
} else {
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
}
}
}
DB_doquer('ROLLBACK');
return false;
}
function del()
{
DB_doquer('START TRANSACTION');
$me = array("id" => $this->getId(), "eigenschap van relatie" => $this->_eigenschapvanrelatie, "overtredingen" => $this->_overtredingen, "uitleg" => $this->_uitleg, "pattern" => $this->_pattern);
foreach ($me['overtredingen'] as $i0 => $v0) {
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($v0) . "'", 5);
}
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($me['uitleg']) . "'", 5);
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
DB_doquer('ROLLBACK');
return false;
}
function setTimestamp()
{
$time = explode(' ', microTime());
// yields [seconds,microseconds] both in seconds, e.g. ["1322761879", "0.85629400"]
$microseconds = substr($time[0], 2, 6);
// we drop the leading "0." and trailing "00" from the microseconds
$seconds = $time[1] . $microseconds;
$date = date("j-M-Y, H:i:s.") . $microseconds;
DB_doquer("INSERT INTO `__History__` (`Seconds`,`Date`) VALUES ('{$seconds}','{$date}')");
// TODO: add error checking
}
function del()
{
DB_doquer('START TRANSACTION');
$me = array("id" => $this->getId(), "naam" => $this->_naam, "call" => $this->_call, "outputURL" => $this->_outputURL);
DB_doquer("DELETE FROM `OperationTbl` WHERE `Id`='" . addslashes($me['id']) . "'", 5);
DB_doquer("DELETE FROM `Text` WHERE `I`='" . addslashes($me['naam']) . "'", 5);
DB_doquer("DELETE FROM `Text` WHERE `I`='" . addslashes($me['call']) . "'", 5);
DB_doquer("DELETE FROM `Compilation` WHERE `I`='" . addslashes($me['outputURL']) . "'", 5);
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
DB_doquer('ROLLBACK');
return false;
}
function save()
{
DB_doquer('START TRANSACTION');
/****************************************\
* Attributes that will not be saved are: *
* -------------------------------------- *
\****************************************/
$me = array("id" => 1, "Plaintiffs" => $this->_Plaintiffs, "Defendants" => $this->_Defendants);
// no code for Plaintiffs,i in party
// no code for Defendants,i in party
if (!checkRule1()) {
$DB_err = '\\"The plaintiff in an administrative case is a juristic person\\"';
} else {
if (!checkRule2()) {
$DB_err = '\\"The defendant in an administrative case is an administrative authority as referred to in art.1:1 Awb.\\"';
} else {
if (!checkRule5()) {
$DB_err = '\\"Every party is either a person or an organization or an administrative authority.\\"';
} else {
if (!checkRule12()) {
$DB_err = '\\"An appeal lodged against a decision of an administrative authority of a province or municipality, or a water management board, or a region as referred to in article 21 of the 1993 Police Act, or of a joint body or public body established under the Joint Arrangements Act, falls within the jurisdiction of the district court within whose district the administrative authority has its seat. (art. 8:7 par.1 Awb.)\\"';
} else {
if (!checkRule13()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule27()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule29()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule31()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule33()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule43()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule46()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule51()) {
$DB_err = '\\"\\"';
} else {
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
}
}
}
}
}
}
}
}
}
}
}
}
DB_doquer('ROLLBACK');
return false;
}
function del()
{
DB_doquer('START TRANSACTION');
$me = array("id" => $this->getId(), "court" => $this->_court, "members" => $this->_members, "sessions" => $this->_sessions);
DB_doquer("DELETE FROM `panel` WHERE `i`='" . addslashes($me['id']) . "'", 5);
if (!checkRule1()) {
$DB_err = '\\"The plaintiff in an administrative case is a juristic person\\"';
} else {
if (!checkRule2()) {
$DB_err = '\\"The defendant in an administrative case is an administrative authority as referred to in art.1:1 Awb.\\"';
} else {
if (!checkRule5()) {
$DB_err = '\\"Every party is either a person or an organization or an administrative authority.\\"';
} else {
if (!checkRule7()) {
$DB_err = '\\"a session can be identified by its panel, its city and its date.\\"';
} else {
if (!checkRule8()) {
$DB_err = '\\"A judge at a session is a member of the panel that runs the session.\\"';
} else {
if (!checkRule27()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule29()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule31()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule33()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule34()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule38()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule39()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule40()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule41()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule42()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule43()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule44()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule46()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule48()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule51()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule53()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule56()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule57()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule59()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule60()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule61()) {
$DB_err = '\\"\\"';
} else {
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
DB_doquer('ROLLBACK');
return false;
}
function del()
{
DB_doquer('START TRANSACTION');
$me = array("id" => $this->getId(), "beschrijving" => $this->_beschrijving, "populatie" => $this->_populatie, "toepassing in regel(s)" => $this->_toepassinginregels, "Conceptueel diagram" => $this->_Conceptueeldiagram);
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($me['beschrijving']) . "'", 5);
foreach ($me['populatie'] as $i0 => $v0) {
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($v0) . "'", 5);
}
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($me['Conceptueel diagram']) . "'", 5);
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
DB_doquer('ROLLBACK');
return false;
}
function save()
{
DB_doquer('START TRANSACTION');
/****************************************\
* Attributes that will not be saved are: *
* -------------------------------------- *
\****************************************/
$me = array("id" => 1, "Authorizations" => $this->_Authorizations);
foreach ($me['Authorizations'] as $i0 => $v0) {
if (isset($v0['id'])) {
DB_doquer("UPDATE `document` SET `i`='" . addslashes($v0['id']) . "' WHERE `i`='" . addslashes($v0['document']) . "'", 5);
}
}
// no code for document,i in document
// no code for for,i in legalcase
// no code for by,i in party
// no code for representative,i in party
// no code for for,legalcase in plaintiff
foreach ($me['Authorizations'] as $i0 => $v0) {
DB_doquer("DELETE FROM `writtenauthof` WHERE `document`='" . addslashes($v0['id']) . "'", 5);
}
foreach ($me['Authorizations'] as $i0 => $v0) {
foreach ($v0['representative'] as $representative) {
$res = DB_doquer("INSERT IGNORE INTO `writtenauthof` (`party`,`document`) VALUES ('" . addslashes($representative) . "', '" . addslashes($v0['id']) . "')", 5);
}
}
foreach ($me['Authorizations'] as $i0 => $v0) {
DB_doquer("DELETE FROM `authfor` WHERE `document`='" . addslashes($v0['id']) . "'", 5);
}
foreach ($me['Authorizations'] as $i0 => $v0) {
foreach ($v0['for'] as $for) {
$res = DB_doquer("INSERT IGNORE INTO `authfor` (`legalcase`,`document`) VALUES ('" . addslashes($for) . "', '" . addslashes($v0['id']) . "')", 5);
}
}
foreach ($me['Authorizations'] as $i0 => $v0) {
DB_doquer("DELETE FROM `authby` WHERE `document`='" . addslashes($v0['id']) . "'", 5);
}
foreach ($me['Authorizations'] as $i0 => $v0) {
foreach ($v0['by'] as $by) {
$res = DB_doquer("INSERT IGNORE INTO `authby` (`party`,`document`) VALUES ('" . addslashes($by) . "', '" . addslashes($v0['id']) . "')", 5);
}
}
if (!checkRule1()) {
$DB_err = '\\"The plaintiff in an administrative case is a juristic person\\"';
} else {
if (!checkRule2()) {
$DB_err = '\\"The defendant in an administrative case is an administrative authority as referred to in art.1:1 Awb.\\"';
} else {
if (!checkRule3()) {
$DB_err = '\\"Written authorizations for representatives of a case are not put in the case file\\"';
} else {
if (!checkRule4()) {
$DB_err = '\\"Every administrative case is either an appeal or an objection or an appeal to an administrative court. (Art.6:4 Awb)\\"';
} else {
if (!checkRule5()) {
$DB_err = '\\"Every party is either a person or an organization or an administrative authority.\\"';
} else {
if (!checkRule13()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule15()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule17()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule19()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule21()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule23()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule25()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule27()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule29()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule31()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule33()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule36()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule43()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule46()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule51()) {
$DB_err = '\\"\\"';
} else {
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
DB_doquer('ROLLBACK');
return false;
}
function del()
{
DB_doquer('START TRANSACTION');
$me = array("id" => $this->getId(), "uitleg" => $this->_uitleg, "cardinaliteitseigenschappen" => $this->_cardinaliteitseigenschappen, "homogene eigenschappen" => $this->_homogeneeigenschappen, "concepten" => $this->_concepten, "toepassing in regels" => $this->_toepassinginregels, "pattern" => $this->_pattern, "populatie" => $this->_populatie);
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($me['uitleg']) . "'", 5);
foreach ($me['cardinaliteitseigenschappen'] as $i0 => $v0) {
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($v0['eigenschap']) . "'", 5);
}
foreach ($me['cardinaliteitseigenschappen'] as $i0 => $v0) {
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($v0['afgeleide regel']) . "'", 5);
}
foreach ($me['cardinaliteitseigenschappen'] as $i0 => $v0) {
foreach ($v0['wordt overtreden door'] as $i1 => $v1) {
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($v1) . "'", 5);
}
}
foreach ($me['homogene eigenschappen'] as $i0 => $v0) {
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($v0['eigenschap']) . "'", 5);
}
foreach ($me['homogene eigenschappen'] as $i0 => $v0) {
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($v0['afgeleide regel']) . "'", 5);
}
foreach ($me['homogene eigenschappen'] as $i0 => $v0) {
foreach ($v0['wordt overtreden door'] as $i1 => $v1) {
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($v1) . "'", 5);
}
}
foreach ($me['populatie'] as $i0 => $v0) {
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($v0) . "'", 5);
}
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
DB_doquer('ROLLBACK');
return false;
}
// TODO: with multiple users, this mechanism may lead to non-unique new atom names, until we enocode a session number
// in the unique atom name. But since the atom names are based on microseconds, the chances of a problem are pretty slim.
if ($isNew) {
DB_doquer('START TRANSACTION');
addAtomToConcept($atom, $concept);
}
// we need an extra ScrollPane div because the log windows need to be outside scroll area but inside ampersand root
// (since their css depends on the 'editing' attribute)
echo '<div id=ScrollPane>';
echo generateAtomInterfaces($allInterfaceObjects[$interface], $atom, true);
echo '</div>';
echo '</div>';
echo '<div id=Rollback></div>';
// needs to be outside AmpersandRoot, so it's easy to address all interface elements not in the Rollback
if ($isNew) {
DB_doquer('ROLLBACK');
}
}
}
}
}
?>
</body>
</html>
<?php
SetSMF('pause', false);
function topLevelInterfaceLinks()
{
global $allInterfaceObjects;
global $selectedRoleNr;
function del()
{
DB_doquer('START TRANSACTION');
$me = array("id" => $this->getId(), "Sessions" => $this->_Sessions, "panels" => $this->_panels, "members" => $this->_members, "cases" => $this->_cases, "main office" => $this->_mainoffice, "local offices" => $this->_localoffices, "court of appeal" => $this->_courtofappeal, "schedule" => $this->_schedule);
if (isset($me['id'])) {
DB_doquer("UPDATE `city` SET `localoffices`=NULL WHERE `localoffices`='" . addslashes($me['id']) . "'", 5);
}
DB_doquer("DELETE FROM `court` WHERE `i`='" . addslashes($me['id']) . "'", 5);
DB_doquer("DELETE FROM `panel` WHERE `court`='" . addslashes($me['id']) . "'", 5);
foreach ($me['Sessions'] as $i0 => $v0) {
foreach ($v0['schedule'] as $i1 => $v1) {
foreach ($v1['type of case'] as $i2 => $v2) {
DB_doquer("DELETE FROM `casetype` WHERE `i`='" . addslashes($v2) . "'", 5);
}
}
}
foreach ($me['Sessions'] as $i0 => $v0) {
DB_doquer("DELETE FROM `date` WHERE `i`='" . addslashes($v0['scheduled']) . "'", 5);
}
foreach ($me['schedule'] as $i0 => $v0) {
DB_doquer("DELETE FROM `plaintiff` WHERE `legalcase`='" . addslashes($v0['id']) . "'", 5);
}
foreach ($me['Sessions'] as $i0 => $v0) {
DB_doquer("DELETE FROM `judge` WHERE `session`='" . addslashes($v0['id']) . "'", 5);
}
if (!checkRule1()) {
$DB_err = '\\"The plaintiff in an administrative case is a juristic person\\"';
} else {
if (!checkRule2()) {
$DB_err = '\\"The defendant in an administrative case is an administrative authority as referred to in art.1:1 Awb.\\"';
} else {
if (!checkRule3()) {
$DB_err = '\\"Written authorizations for representatives of a case are not put in the case file\\"';
} else {
if (!checkRule4()) {
$DB_err = '\\"Every administrative case is either an appeal or an objection or an appeal to an administrative court. (Art.6:4 Awb)\\"';
} else {
if (!checkRule5()) {
$DB_err = '\\"Every party is either a person or an organization or an administrative authority.\\"';
} else {
if (!checkRule7()) {
$DB_err = '\\"a session can be identified by its panel, its city and its date.\\"';
} else {
if (!checkRule8()) {
$DB_err = '\\"A judge at a session is a member of the panel that runs the session.\\"';
} else {
if (!checkRule9()) {
$DB_err = '\\"The clerk of a session must be the clerk of the court where the session is held.\\"';
} else {
if (!checkRule10()) {
$DB_err = '\\"All sessions are scheduled\\"';
} else {
if (!checkRule12()) {
$DB_err = '\\"An appeal lodged against a decision of an administrative authority of a province or municipality, or a water management board, or a region as referred to in article 21 of the 1993 Police Act, or of a joint body or public body established under the Joint Arrangements Act, falls within the jurisdiction of the district court within whose district the administrative authority has its seat. (art. 8:7 par.1 Awb.)\\"';
} else {
if (!checkRule13()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule15()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule18()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule19()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule20()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule21()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule22()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule23()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule24()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule25()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule27()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule29()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule31()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule33()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule34()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule35()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule36()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule37()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule38()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule39()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule40()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule41()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule42()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule43()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule44()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule46()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule47()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule48()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule49()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule51()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule52()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule53()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule54()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule55()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule56()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule57()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule58()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule59()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule60()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule61()) {
$DB_err = '\\"\\"';
} else {
if (!checkRule62()) {
$DB_err = '\\"\\"';
} else {
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
DB_doquer('ROLLBACK');
return false;
}
function save()
{
DB_doquer('START TRANSACTION');
/**************************\
* All attributes are saved *
\**************************/
$me = array("id" => 1, "de regel" => $this->_deregel, "de cardinaliteitseigenschap" => $this->_decardinaliteitseigenschap, "de homogene eigenschap" => $this->_dehomogeneeigenschap);
// no code for de regel,I in UserRule
foreach ($me['de homogene eigenschap'] as $i0 => $v0) {
if (isset($v0['id'])) {
DB_doquer("UPDATE `HomogeneousRule` SET `on`='" . addslashes($v0['van relatie']) . "' WHERE `I`='" . addslashes($v0['id']) . "'", 5);
}
}
foreach ($me['de cardinaliteitseigenschap'] as $i0 => $v0) {
if (isset($v0['id'])) {
DB_doquer("UPDATE `MultiplicityRule` SET `on`='" . addslashes($v0['van relatie']) . "' WHERE `I`='" . addslashes($v0['id']) . "'", 5);
}
}
// no code for van relatie,I in Relation
// no code for van relatie,I in Relation
foreach ($me['de regel'] as $i0 => $v0) {
foreach ($v0['wordt overtreden door'] as $i1 => $v1) {
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($v1) . "'", 5);
}
}
foreach ($me['de cardinaliteitseigenschap'] as $i0 => $v0) {
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($v0['eigenschap']) . "'", 5);
}
foreach ($me['de cardinaliteitseigenschap'] as $i0 => $v0) {
foreach ($v0['wordt overtreden door'] as $i1 => $v1) {
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($v1) . "'", 5);
}
}
foreach ($me['de homogene eigenschap'] as $i0 => $v0) {
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($v0['eigenschap']) . "'", 5);
}
foreach ($me['de homogene eigenschap'] as $i0 => $v0) {
foreach ($v0['wordt overtreden door'] as $i1 => $v1) {
DB_doquer("DELETE FROM `String` WHERE `I`='" . addslashes($v1) . "'", 5);
}
}
foreach ($me['de regel'] as $i0 => $v0) {
foreach ($v0['wordt overtreden door'] as $i1 => $v1) {
$res = DB_doquer("INSERT IGNORE INTO `String` (`I`) VALUES ('" . addslashes($v1) . "')", 5);
}
}
foreach ($me['de cardinaliteitseigenschap'] as $i0 => $v0) {
$res = DB_doquer("INSERT IGNORE INTO `String` (`I`) VALUES ('" . addslashes($v0['eigenschap']) . "')", 5);
}
foreach ($me['de cardinaliteitseigenschap'] as $i0 => $v0) {
foreach ($v0['wordt overtreden door'] as $i1 => $v1) {
$res = DB_doquer("INSERT IGNORE INTO `String` (`I`) VALUES ('" . addslashes($v1) . "')", 5);
}
}
foreach ($me['de homogene eigenschap'] as $i0 => $v0) {
$res = DB_doquer("INSERT IGNORE INTO `String` (`I`) VALUES ('" . addslashes($v0['eigenschap']) . "')", 5);
}
foreach ($me['de homogene eigenschap'] as $i0 => $v0) {
foreach ($v0['wordt overtreden door'] as $i1 => $v1) {
$res = DB_doquer("INSERT IGNORE INTO `String` (`I`) VALUES ('" . addslashes($v1) . "')", 5);
}
}
if (true) {
// all rules are met
DB_doquer('COMMIT');
return true;
}
DB_doquer('ROLLBACK');
return false;
}