1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158:
<?php
// $Id: Compo.php 12313 2013-09-15 21:14:35Z skenow $
// ------------------------------------------------------------------------ //
// XOOPS - PHP Content Management System //
// Copyright (c) 2000 XOOPS.org //
// <http://www.xoops.org/> //
// ------------------------------------------------------------------------ //
// This program is free software; you can redistribute it and/or modify //
// it under the terms of the GNU General Public License as published by //
// the Free Software Foundation; either version 2 of the License, or //
// (at your option) any later version. //
// //
// You may not change or alter any portion of this comment or credits //
// of supporting developers from this source code or any supporting //
// source code which is considered copyrighted (c) material of the //
// original comment or credit authors. //
// //
// This program is distributed in the hope that it will be useful, //
// but WITHOUT ANY WARRANTY; without even the implied warranty of //
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the //
// GNU General Public License for more details. //
// //
// You should have received a copy of the GNU General Public License //
// along with this program; if not, write to the Free Software //
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA //
// ------------------------------------------------------------------------ //
// Author: Kazumi Ono (AKA onokazu) //
// URL: http://www.myweb.ne.jp/, http://www.xoops.org/, http://jp.xoops.org/ //
// Project: The XOOPS Project //
// ------------------------------------------------------------------------- //
// Modified by: Nathan Dial //
// Date: 20 March 2003 //
// Desc: added experimental LDAP filter generation code //
// also refactored to remove about 20 lines of redundant code. //
// ------------------------------------------------------------------------- //
/**
* icms_db_criteria_Compo
*
* @copyright Copyright (c) 2000 XOOPS.org
* @copyright The ImpressCMS Project http://www.impresscms.org/
* @license http://www.gnu.org/licenses/old-licenses/gpl-2.0.html GNU General Public License (GPL)
*
* @category ICMS
* @package Database
* @subpackage Criteria
*
* @since 1.3
* @author marcan <marcan@impresscms.org>
* @version SVN: $Id: Compo.php 12313 2013-09-15 21:14:35Z skenow $
*/
defined("ICMS_ROOT_PATH") or die("ImpressCMS root path not defined");
/**
* Collection of multiple {@link icms_db_criteria_Element}s
*
* @category ICMS
* @package Database
* @subpackage Criteria
*
* @author Kazumi Ono <onokazu@xoops.org>
* @copyright Copyright (c) 2000 XOOPS.org
*/
class icms_db_criteria_Compo extends icms_db_criteria_Element {
/**
* The elements of the collection
* @var array Array of {@link icms_db_criteria_Element} objects
*/
public $criteriaElements = array();
/**
* Conditions
* @var array
*/
public $conditions = array();
/**
* Constructor
*
* @param object $ele
* @param string $condition
**/
public function __construct($ele=null, $condition='AND') {
if (isset($ele) && is_object($ele)) {
$this->add($ele, $condition);
}
}
/**
* Add an element
*
* @param object &$criteriaElement
* @param string $condition
*
* @return object reference to this collection
**/
public function &add($criteriaElement, $condition='AND') {
$this->criteriaElements[] = $criteriaElement;
$this->conditions[] = $condition;
return $this;
}
/**
* Make the criteria into a query string
*
* @return string
*/
public function render() {
$ret = '';
$count = count($this->criteriaElements);
if ($count > 0) {
$ret = '(' . $this->criteriaElements[0]->render();
for ($i = 1; $i < $count; $i++) {
$ret .= ' ' . $this->conditions[$i] . ' ' . $this->criteriaElements[$i]->render();
}
$ret .= ')';
}
return $ret;
}
/**
* Make the criteria into a SQL "WHERE" clause
*
* @return string
*/
public function renderWhere() {
$ret = $this->render();
$ret = ($ret != '') ? 'WHERE ' . $ret : $ret;
return $ret;
}
/**
* Generate an LDAP filter from criteria
*
* @return string
* @author Nathan Dial ndial@trillion21.com
*/
public function renderLdap() {
$retval = '';
$count = count($this->criteriaElements);
if ($count > 0) {
$retval = $this->criteriaElements[0]->renderLdap();
for ($i = 1; $i < $count; $i++) {
$cond = $this->conditions[$i];
if (strtoupper($cond) == 'AND') {
$op = '&';
} elseif (strtoupper($cond) == 'OR') {
$op = '|';
}
$retval = "(" . $op . $retval . $this->criteriaElements[$i]->renderLdap() . ")";
}
}
return $retval;
}
}