crm.fsf.org/20131203/files/sites/all/modules-old/civicrm/CRM/Utils/SQL.php

   1 <?php
   2 /*
   3  +--------------------------------------------------------------------+
   4  | CiviCRM version 4.6                                                |
   5  +--------------------------------------------------------------------+
   6  | Copyright CiviCRM LLC (c) 2004-2016                                |
   7  +--------------------------------------------------------------------+
   8  | This file is a part of CiviCRM.                                    |
   9  |                                                                    |
  10  | CiviCRM is free software; you can copy, modify, and distribute it  |
  11  | under the terms of the GNU Affero General Public License           |
  12  | Version 3, 19 November 2007 and the CiviCRM Licensing Exception.   |
  13  |                                                                    |
  14  | CiviCRM is distributed in the hope that it will be useful, but     |
  15  | WITHOUT ANY WARRANTY; without even the implied warranty of         |
  16  | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.               |
  17  | See the GNU Affero General Public License for more details.        |
  18  |                                                                    |
  19  | You should have received a copy of the GNU Affero General Public   |
  20  | License and the CiviCRM Licensing Exception along                  |
  21  | with this program; if not, contact CiviCRM LLC                     |
  22  | at info[AT]civicrm[DOT]org. If you have questions about the        |
  23  | GNU Affero General Public License or the licensing of CiviCRM,     |
  24  | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
  25  +--------------------------------------------------------------------+
  26  */
  27
  28 /**
  29  * Just another collection of static utils functions.
  30  *
  31  * @package CRM
  32  * @copyright CiviCRM LLC (c) 2004-2016
  33  */
  34 class CRM_Utils_SQL {
  35
  36   /**
  37    * Helper function for adding the permissioned subquery from one entity onto another
  38    *
  39    * @param string $entity
  40    * @param string $joinColumn
  41    * @return array
  42    */
  43   public static function mergeSubquery($entity, $joinColumn = 'id') {
  44     require_once 'api/v3/utils.php';
  45     $baoName = _civicrm_api3_get_BAO($entity);
  46     $bao = new $baoName();
  47     $clauses = $subclauses = array();
  48     foreach ((array) $bao->addSelectWhereClause() as $field => $vals) {
  49       if ($vals && $field == $joinColumn) {
  50         $clauses = array_merge($clauses, (array) $vals);
  51       }
  52       elseif ($vals) {
  53         $subclauses[] = "$field " . implode(" AND $field ", (array) $vals);
  54       }
  55     }
  56     if ($subclauses) {
  57       $clauses[] = "IN (SELECT `$joinColumn` FROM `" . $bao->tableName() . "` WHERE " . implode(' AND ', $subclauses) . ")";
  58     }
  59     return $clauses;
  60   }
  61
  62 }