All Data Structures Functions Variables Pages
ReadOptimizationModelWhereAndJoinBuilder.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  {
47  $modelAttributeToDataProviderAdapter,
49  $joinTablesAdapter)
50  {
51  parent::__construct($modelAttributeToDataProviderAdapter, $joinTablesAdapter);
52  }
53 
62  public function resolveJoinsAndBuildWhere($operatorType, $value, & $clausePosition, & $where,
63  $onTableAliasName = null, $resolveAsSubquery = false)
64  {
65  assert('$operatorType == null');
66  assert('$value == null');
67  assert('is_array($where)');
68  assert('is_string($onTableAliasName) || $onTableAliasName == null');
69  $tableAliasName = $this->resolveJoins(
70  $onTableAliasName, ModelDataProviderUtil::resolveCanUseFromJoins($onTableAliasName));
71  $this->addReadOptimizationWhereClause($where, $clausePosition, $tableAliasName);
72  }
73 
74  protected function addReadOptimizationWhereClause(& $where, $whereKey, $tableAliasName)
75  {
76  assert('is_array($where)');
77  assert('is_int($whereKey)');
78  assert('is_string($tableAliasName)');
80  $columnWithTableAlias = self::makeColumnNameWithTableAlias($tableAliasName,
81  $this->modelAttributeToDataProviderAdapter->getColumnName());
82  $mungeTableName = ReadPermissionsOptimizationUtil::getMungeTableName($this->modelAttributeToDataProviderAdapter->getModelClassName());
83  $mungeIds = AllPermissionsOptimizationUtil::getMungeIdsByUser(Yii::app()->user->userModel);
84  $whereContent = $columnWithTableAlias . " " . SQLOperatorUtil::getOperatorByType('equals'). " ";
85  $whereContent .= "(select securableitem_id from {$q}$mungeTableName{$q} " .
86  "where {$q}securableitem_id{$q} = $columnWithTableAlias and {$q}munge_id{$q}" .
87  " in ('" . join("', '", $mungeIds) . "') limit 1)";
88  $where[$whereKey] = $whereContent;
89  }
90  }
91 ?>
resolveJoinsAndBuildWhere($operatorType, $value, &$clausePosition, &$where, $onTableAliasName=null, $resolveAsSubquery=false)
__construct(ReadOptimizationDerivedAttributeToDataProviderAdapter $modelAttributeToDataProviderAdapter, RedBeanModelJoinTablesQueryAdapter $joinTablesAdapter)
static getOperatorByType($operatorType)
static resolveCanUseFromJoins($onTableAliasName)
resolveJoins($onTableAliasName=null, $canUseFromJoins=true)
Generated on Thu May 28 2020 07:10:36