From.php 2.72 KB
Newer Older
doctrine's avatar
doctrine committed
1
<?php
zYne's avatar
zYne committed
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
/*
 *  $Id$
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * This software consists of voluntary contributions made by many individuals
 * and is licensed under the LGPL. For more information, see
 * <http://www.phpdoctrine.com>.
 */
21
Doctrine::autoload("Doctrine_Query_Part");
zYne's avatar
zYne committed
22 23 24 25 26 27 28 29 30 31 32
/**
 * Doctrine_Query_From
 *
 * @package     Doctrine
 * @license     http://www.opensource.org/licenses/lgpl-license.php LGPL
 * @category    Object Relational Mapping
 * @link        www.phpdoctrine.com
 * @since       1.0
 * @version     $Revision$
 * @author      Konsta Vesterinen <kvesteri@cc.hut.fi>
 */
lsmith's avatar
lsmith committed
33
class Doctrine_Query_From extends Doctrine_Query_Part
zYne's avatar
zYne committed
34
{      
doctrine's avatar
doctrine committed
35 36 37 38 39 40 41
    /**
     * DQL FROM PARSER
     * parses the from part of the query string

     * @param string $str
     * @return void
     */
lsmith's avatar
lsmith committed
42 43
    final public function parse($str)
    {
44

45 46 47 48
        $str = trim($str);
        $parts = Doctrine_Query::bracketExplode($str, 'JOIN');

        $operator = false;
zYne's avatar
zYne committed
49

lsmith's avatar
lsmith committed
50
        switch (trim($parts[0])) {
51 52 53 54
            case 'INNER':
                $operator = ':';
            case 'LEFT':
                array_shift($parts);
zYne's avatar
zYne committed
55 56
        }

57 58
        $last = '';

lsmith's avatar
lsmith committed
59
        foreach ($parts as $k => $part) {
60
            $part = trim($part);
zYne's avatar
zYne committed
61

lsmith's avatar
lsmith committed
62
            if (empty($part)) {
zYne's avatar
zYne committed
63 64 65 66
                continue;
            }

            $e    = explode(' ', $part);
67

lsmith's avatar
lsmith committed
68
            if (end($e) == 'INNER' || end($e) == 'LEFT') {
69
                $last = array_pop($e);
lsmith's avatar
lsmith committed
70
            }
zYne's avatar
zYne committed
71
            $part = implode(' ', $e);
72

lsmith's avatar
lsmith committed
73
            foreach (Doctrine_Query::bracketExplode($part, ',') as $reference) {
74 75 76
                $reference = trim($reference);
                $e         = explode('.', $reference);

lsmith's avatar
lsmith committed
77
                if ($operator) {
zYne's avatar
zYne committed
78
                    $reference = array_shift($e) . $operator . implode('.', $e);
79
                }
80

zYne's avatar
zYne committed
81
                $table = $this->query->load($reference);
lsmith's avatar
lsmith committed
82 83
            }

84
            $operator = ($last == 'INNER') ? ':' : '.';
doctrine's avatar
doctrine committed
85 86
        }
    }
zYne's avatar
zYne committed
87

doctrine's avatar
doctrine committed
88
}