当前位置: 首页>>代码示例>>PHP>>正文


PHP firstRow函数代码示例

本文整理汇总了PHP中firstRow函数的典型用法代码示例。如果您正苦于以下问题:PHP firstRow函数的具体用法?PHP firstRow怎么用?PHP firstRow使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。


在下文中一共展示了firstRow函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: Overtredingen

 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']);
     }
 }
开发者ID:4ZP6Capstone2015,项目名称:ampersand-models,代码行数:31,代码来源:Overtredingen.inc.php

示例2: Session

 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;
         }
     }
 }
开发者ID:sapray,项目名称:ampersand-models,代码行数:56,代码来源:Session.inc.php

示例3: UserRule

 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;
         }
     }
 }
开发者ID:4ZP6Capstone2015,项目名称:ampersand-models,代码行数:55,代码来源:UserRule.inc.php

示例4: Magistrate

 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;
         }
     }
 }
开发者ID:sapray,项目名称:ampersand-models,代码行数:50,代码来源:Magistrate.inc.php

示例5: Signal

 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;
         }
     }
 }
开发者ID:4ZP6Capstone2015,项目名称:ampersand-models,代码行数:50,代码来源:Signal.inc.php

示例6: Party

 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;
         }
     }
 }
开发者ID:sapray,项目名称:ampersand-models,代码行数:49,代码来源:Party.inc.php

示例7: Relaties

 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']);
     }
 }
开发者ID:4ZP6Capstone2015,项目名称:ampersand-models,代码行数:15,代码来源:Relaties.inc.php

示例8: Schedule

 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']);
     }
 }
开发者ID:sapray,项目名称:ampersand-models,代码行数:15,代码来源:Schedule.inc.php

示例9: Sessions

 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']);
     }
 }
开发者ID:4ZP6Capstone2015,项目名称:ampersand-models,代码行数:15,代码来源:Sessions.inc.php

示例10: Ops

 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']);
     }
 }
开发者ID:4ZP6Capstone2015,项目名称:ampersand-models,代码行数:15,代码来源:Ops.inc.php

示例11: ISArelaties

 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']);
     }
 }
开发者ID:4ZP6Capstone2015,项目名称:ampersand-models,代码行数:15,代码来源:ISArelaties.inc.php

示例12: Panels

 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']);
     }
 }
开发者ID:sapray,项目名称:ampersand-models,代码行数:16,代码来源:Panels.inc.php

示例13: InterestedParties

 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']);
     }
 }
开发者ID:sapray,项目名称:ampersand-models,代码行数:16,代码来源:InterestedParties.inc.php

示例14: Sessions

 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']);
     }
 }
开发者ID:sapray,项目名称:ampersand-models,代码行数:16,代码来源:Sessions.inc.php

示例15: City

 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;
         }
     }
 }
开发者ID:sapray,项目名称:ampersand-models,代码行数:47,代码来源:City.inc.php


注:本文中的firstRow函数示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。