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: 159: <?php
// $Id: Item.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. //
// ------------------------------------------------------------------------- //
/**
* A single criteria for a database query
*
* @copyright http://www.impresscms.org/ The ImpressCMS Project
* @license http://www.gnu.org/licenses/old-licenses/gpl-2.0.html GNU General Public License (GPL)
*
* @category ICMS
* @package Database
* @subpackage Criteria
*
* @version SVN: $Id: Item.php 12313 2013-09-15 21:14:35Z skenow $
*/
defined("ICMS_ROOT_PATH") or die("ImpressCMS root path not defined");
/**
* A single criteria
*
* @category ICMS
* @package Database
* @subpackage Criteria
*
* @author Kazumi Ono <onokazu@xoops.org>
* @copyright copyright (c) 2000-2007 XOOPS.org
*/
class icms_db_criteria_Item extends icms_db_criteria_Element {
/**
* @var string
*/
private $_prefix;
private $_function;
private $_column;
private $_operator;
private $_value;
/**
* Constructor
*
* @param string $column
* @param string $value
* @param string $operator
**/
public function __construct($column, $value='', $operator='=', $prefix = '', $function = '') {
$this->_prefix = $prefix;
$this->_function = $function;
$this->_column = $column;
$this->_value = $value;
$this->_operator = $operator;
}
/**
* Make a sql condition string
*
* @return string
**/
public function render() {
$clause = (!empty($this->_prefix) ? "{$this->_prefix}." : "") . $this->_column;
if (!empty($this->_function)) {
$clause = sprintf($this->_function, $clause);
}
if (in_array( strtoupper($this->_operator), array('IS NULL', 'IS NOT NULL'))) {
$clause .= ' ' . $this->_operator;
} else {
if ('' === ( $value = trim($this->_value) )) {
return '';
}
if (!in_array(strtoupper($this->_operator), array('IN', 'NOT IN'))) {
if (( substr($value, 0, 1) != '`' ) && ( substr($value, -1) != '`' )) {
$value = "'$value'";
} elseif (!preg_match('/^[a-zA-Z0-9_\.\-`]*$/', $value)) {
$value = '``';
}
}
$clause .= " {$this->_operator} $value";
}
return $clause;
}
/**
* Generate an LDAP filter from criteria
*
* @return string
* @author Nathan Dial ndial@trillion21.com, improved by Pierre-Eric MENUET pemen@sourceforge.net
*/
public function renderLdap() {
if ($this->_operator == '>') {
$this->_operator = '>=';
}
if ($this->_operator == '<') {
$this->_operator = '<=';
}
if ($this->_operator == '!=' || $this->_operator == '<>') {
$operator = '=';
$clause = "(!(" . $this->_column . $operator . $this->_value . "))";
}
else {
if ($this->_operator == 'IN') {
$newvalue = str_replace(array('(', ')'), '', $this->_value);
$tab = explode(',', $newvalue);
foreach ($tab as $uid) {
$clause .= '(' . $this->_column . '=' . $uid
.')';
}
$clause = '(|' . $clause . ')';
} else {
$clause = "(" . $this->_column . $this->_operator . $this->_value . ")";
}
}
return $clause;
}
/**
* Make a SQL "WHERE" clause
*
* @return string
*/
public function renderWhere() {
$cond = $this->render();
return empty($cond) ? '' : "WHERE $cond";
}
}