DALFromParser.inc

<?php
require_once 'DAL/Parsers/DALQueryParser.inc';
require_once 'DAL/Parsers/DALUnionParser.inc';
require_once 'DAL/Parsers/DALSelectParser.inc';
require_once 'DAL/DALBaker.inc';
require_once 'XML/XML.inc';

class DALFromParser extends DALQueryParser
{


    private function __construct()
    {

    }//end __construct()


    public static function parse(DomElement $fromTag)
    {
        if ($fromTag->tagName !== 'from') {
            $fromTag = $fromTag->getElementsByTagName('from')->item(0);
        }

        $from = array();
        if ($fromTag !== NULL) {
            $from['FROM'] = array();

            // Get union/union-all if there is one, else get tables.
            $unionTag = self::getUnionTag($fromTag);
            if ($unionTag !== NULL) {
                $from['FROM'] = DALUnionParser::parse($fromTag);
            } else {
                $tables = XML::getElementsByTagNames(array('table', 'hook'), $fromTag);
                foreach ($fromTag->childNodes as $table) {
                    if ($table->nodeType !== XML_ELEMENT_NODE) {
                        continue;
                    }

                    // Make sure this is the first level.
                    if ($table->tagName === 'hook') {
                        $hook = DALBaker::getHookPrefix().$table->getAttribute('id');
                        // Add the hook to the 'FROM' array.
                        $from['FROM'][] = $hook;
                    } else if ($table->tagName === 'table') {
                        // Could have a select statement.
                        $tableInfo = array();
                        $tblSelect = $table->getElementsByTagName('select')->item(0);
                        if ($tblSelect !== NULL) {
                            $tableInfo['name'] = DALSelectParser::parse($tblSelect);
                        } else {
                            $tableInfo['name'] = $table->nodeValue;
                        }

                        // Check if we have alias.
                        if ($table->getAttribute('alias') !== '') {
                            $tableInfo['alias'] = $table->getAttribute('alias');
                        }

                        if (isset($tableInfo['alias']) === TRUE) {
                            $from['FROM'][] = $tableInfo;
                        } else {
                            $from['FROM'][] = $tableInfo['name'];
                        }
                    } else if ($table->tagName === 'function') {
                        self::validateFunctionTag($table);
                        $from['FROM'][] = self::parseSqlFunction($table);
                    }//end if
                }//end foreach
            }//end if
        }//end if

        return $from;

    }//end parse()


}//end class

?>