All Data Structures Functions Variables Pages
AutoresponderRedBeanModelsDataProvider.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 makeUnionSql(array $modelClassNamesAndSearchAttributeData,
43  array $modelClassNamesAndSortAttributes = null, $sortDescending = false,
44  $offset = null, $limit = null)
45  {
46  assert('is_bool($sortDescending)');
47  $sqlStatementsToUnion = array();
48  foreach ($modelClassNamesAndSearchAttributeData as $modelClassNameAndSearchAttributeData)
49  {
50  foreach ($modelClassNameAndSearchAttributeData as $modelClassName => $searchAttributeData)
51  {
52  $joinTablesAdapter = new RedBeanModelJoinTablesQueryAdapter($modelClassName);
53  $where = ModelDataProviderUtil::makeWhere( $modelClassName, $searchAttributeData,
54  $joinTablesAdapter);
55 
56  $tableName = $modelClassName::getTableName();
57  $quotedExtraSelectColumnNameAndAliases = array();
58  $quotedExtraSelectColumnNameAndAliases["'" . $modelClassName . "'"] = 'modelClassName';
59  $sqlStatementsToUnion[] = $modelClassName::makeSubsetOrCountSqlQuery($tableName,
60  $joinTablesAdapter, null, null, $where, null, false,
61  $joinTablesAdapter->getSelectDistinct(),
62  $quotedExtraSelectColumnNameAndAliases);
63  }
64  }
65  $orderBy = null;
66  if ($modelClassNamesAndSortAttributes !== null)
67  {
68  $orderBy = $modelClassNamesAndSortAttributes[$modelClassName];
69  if ($sortDescending)
70  {
71  $orderBy .= ' desc';
72  }
73  }
74  return self::makeSubsetUnionSqlQuery($sqlStatementsToUnion, $offset, $limit, $orderBy);
75  }
76  }
77 ?>
static makeWhere($modelClassName, array $metadata, $joinTablesAdapter, $onTableAliasName=null)
Generated on Sat Feb 22 2020 07:10:28