All Data Structures Functions Variables Pages
SQLQueryUtil.php
1 <?php
2  /*********************************************************************************
3  * Zurmo is a customer relationship management program developed by
4  * Zurmo, Inc. Copyright (C) 2017 Zurmo Inc.
5  *
6  * Zurmo is free software; you can redistribute it and/or modify it under
7  * the terms of the GNU Affero General Public License version 3 as published by the
8  * Free Software Foundation with the addition of the following permission added
9  * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
10  * IN WHICH THE COPYRIGHT IS OWNED BY ZURMO, ZURMO DISCLAIMS THE WARRANTY
11  * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
12  *
13  * Zurmo is distributed in the hope that it will be useful, but WITHOUT
14  * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
15  * FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
16  * details.
17  *
18  * You should have received a copy of the GNU Affero General Public License along with
19  * this program; if not, see http://www.gnu.org/licenses or write to the Free
20  * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
21  * 02110-1301 USA.
22  *
23  * You can contact Zurmo, Inc. with a mailing address at 27 North Wacker Drive
24  * Suite 370 Chicago, IL 60606. or at email address contact@zurmo.com.
25  *
26  * The interactive user interfaces in original and modified versions
27  * of this program must display Appropriate Legal Notices, as required under
28  * Section 5 of the GNU Affero General Public License version 3.
29  *
30  * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
31  * these Appropriate Legal Notices must retain the display of the Zurmo
32  * logo and Zurmo copyright notice. If the display of the logo is not reasonably
33  * feasible for technical reasons, the Appropriate Legal Notices must display the words
34  * "Copyright Zurmo Inc. 2017. All rights reserved".
35  ********************************************************************************/
36 
41  {
42  public static function makeQuery($tableName,
43  RedBeanModelSelectQueryAdapter $selectQueryAdapter,
44  RedBeanModelJoinTablesQueryAdapter $joinTablesAdapter,
45  $offset = null,
46  $count = null,
47  $where = null,
48  $orderBy = null,
49  $groupBy = null)
50  {
51  assert('is_string($tableName) && $tableName != ""');
52  assert('$offset === null || is_integer($offset) && $offset >= 0');
53  assert('$count === null || is_integer($count) && $count >= 1');
54  assert('$where === null || is_string ($where) && $where != ""');
55  assert('$orderBy === null || is_string ($orderBy) && $orderBy != ""');
56  assert('$groupBy === null || is_string ($groupBy) && $groupBy != ""');
58  $sql = $selectQueryAdapter->getSelect();
59  $sql .= "from ";
60  //Added ( ) around from tables to ensure precedence over joins.
61  $joinFromPart = $joinTablesAdapter->getJoinFromQueryPart();
62  if ($joinFromPart !== null)
63  {
64  $sql .= "(";
65  $sql .= "{$quote}$tableName{$quote}";
66  $sql .= ", $joinFromPart) ";
67  }
68  else
69  {
70  $sql .= "{$quote}$tableName{$quote}";
71  $sql .= ' ';
72  }
73  $sql .= $joinTablesAdapter->getJoinQueryPart();
74  $joinWherePart = $joinTablesAdapter->getJoinWhereQueryPart();
75  if ($where !== null)
76  {
77  $sql .= "where $where";
78  if ($joinWherePart != null)
79  {
80  $sql .= " and $joinWherePart";
81  }
82  }
83  elseif ($joinWherePart != null)
84  {
85  $sql .= " where $joinWherePart";
86  }
87  if ($groupBy !== null)
88  {
89  $sql .= " group by $groupBy";
90  }
91  if ($orderBy !== null)
92  {
93  $sql .= " order by $orderBy";
94  }
95  if ($count !== null)
96  {
97  $sql .= " limit $count";
98  }
99  if ($offset !== null)
100  {
101  $sql .= " offset $offset";
102  }
103  return $sql;
104  }
105  }
106 ?>
Generated on Wed Feb 26 2020 07:10:35