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 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;
}
checkRule35();
checkRule36();
checkRule37();
checkRule38();
checkRule39();
checkRule40();
checkRule41();
checkRule42();
checkRule43();
checkRule44();
checkRule45();
checkRule46();
checkRule47();
checkRule48();
checkRule49();
checkRule50();
checkRule51();
checkRule52();
checkRule53();
checkRule54();
checkRule55();
checkRule56();
checkRule57();
checkRule58();
checkRule59();
checkRule60();
checkRule61();
checkRule62();
checkRule63();
checkRule64();
}
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 del()
{
DB_doquer('START TRANSACTION');
$me = array("id" => $this->getId(), "court" => $this->_court, "panel" => $this->_panel, "role" => $this->_role, "Sessions" => $this->_Sessions);
DB_doquer("DELETE FROM `party` WHERE `i`='" . addslashes($me['id']) . "'", 5);
foreach ($me['Sessions'] as $i0 => $v0) {
DB_doquer("DELETE FROM `panel` WHERE `i`='" . addslashes($v0['panel']['id']) . "'", 5);
}
DB_doquer("DELETE FROM `role` WHERE `i`='" . addslashes($me['role']) . "'", 5);
foreach ($me['Sessions'] as $i0 => $v0) {
DB_doquer("DELETE FROM `date` WHERE `i`='" . addslashes($v0['scheduled']) . "'", 5);
}
DB_doquer("DELETE FROM `members` WHERE `party`='" . addslashes($me['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 (!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 (!checkRule45()) {
$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;
}