1<?php 2/** 3 * HavingProcessor.php 4 * 5 * Parses the HAVING statements. 6 * 7 * PHP version 5 8 * 9 * LICENSE: 10 * Copyright (c) 2010-2014 Justin Swanhart and André Rothe 11 * All rights reserved. 12 * 13 * Redistribution and use in source and binary forms, with or without 14 * modification, are permitted provided that the following conditions 15 * are met: 16 * 1. Redistributions of source code must retain the above copyright 17 * notice, this list of conditions and the following disclaimer. 18 * 2. Redistributions in binary form must reproduce the above copyright 19 * notice, this list of conditions and the following disclaimer in the 20 * documentation and/or other materials provided with the distribution. 21 * 3. The name of the author may not be used to endorse or promote products 22 * derived from this software without specific prior written permission. 23 * 24 * THIS SOFTWARE IS PROVIDED BY THE AUTHOR ``AS IS'' AND ANY EXPRESS OR 25 * IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES 26 * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. 27 * IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY DIRECT, INDIRECT, 28 * INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT 29 * NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, 30 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY 31 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT 32 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF 33 * THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. 34 * 35 * @author André Rothe <andre.rothe@phosco.info> 36 * @copyright 2010-2014 Justin Swanhart and André Rothe 37 * @license http://www.debian.org/misc/bsd.license BSD License (3 Clause) 38 * @version SVN: $Id$ 39 * 40 */ 41 42namespace PHPSQLParser\processors; 43use PHPSQLParser\utils\ExpressionType; 44 45/** 46 * This class implements the processor for the HAVING statement. 47 * You can overwrite all functions to achieve another handling. 48 * 49 * @author André Rothe <andre.rothe@phosco.info> 50 * @license http://www.debian.org/misc/bsd.license BSD License (3 Clause) 51 * 52 */ 53class HavingProcessor extends ExpressionListProcessor { 54 55 public function process($tokens, $select = array()) { 56 $parsed = parent::process($tokens); 57 58 foreach ($parsed as $k => $v) { 59 if ($v['expr_type'] === ExpressionType::COLREF) { 60 foreach ($select as $clause) { 61 if (!isset($clause['alias'])) { 62 continue; 63 } 64 if (!$clause['alias']) { 65 continue; 66 } 67 if ($clause['alias']['no_quotes'] === $v['no_quotes']) { 68 $parsed[$k]['expr_type'] = ExpressionType::ALIAS; 69 break; 70 } 71 } 72 } 73 } 74 75 return $parsed; 76 } 77} 78 79?> 80