× close ? help v save  end of line:	Text editor: /wanples.com/oc-includes/osclass/classes/database/DBCommandClass.php
<?php

/*
 * Copyright 2014 Osclass
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

    /**
     * Database command object
     *
     * @package Osclass
     * @subpackage Database
     * @since 2.3
     */
	class DBCommandClass
	{
        /**
         * Database connection object to Osclass database
         *
         * @access private
         * @since 2.3
         * @var mysqli
         */
        var $connId;
        /**
         * Database result object
         *
         * @access public
         * @since 2.3
         * @var MySQLi_Result
         */
        var $resultId;

        /**
         *
         * @var array
         */
        var $queries;
        /**
         *
         * @var array
         */
        var $queryTimes;
        /**
         *
         * @var int
         */
        var $queryCount;

        /**
         *
         * @var int
         */
        var $errorLevel;
        /**
         *
         * @var string
         */
        var $errorDesc;

        /**
         *
         * @var array
         */
        var $aSelect;
        /* var $aDistinct; */
        /**
         *
         * @var array
         */
        var $aFrom;
        /**
         *
         * @var array
         */
        var $aJoin;
        /**
         *
         * @var array
         */
        var $aWhere;
        /**
         *
         * @var array
         */
        var $aLike;
        /**
         *
         * @var array
         */
        var $aGroupby;
        /**
         *
         * @var array
         */
        var $aHaving;
        /* var $aKeys; */
        /**
         *
         * @var mixed
         */
        var $aLimit;
        /**
         *
         * @var mixed
         */
        var $aOffset;
        /**
         *
         * @var mixed
         */
        var $aOrder;
        /**
         *
         * @var array
         */
        var $aOrderby;
        /**
         *
         * @var array
         */
        var $aSet;
        /**
         *
         * @var array
         */
        var $aWherein;
        /* var $aAliasedTables; */
        /* var $aStoreArray; */

        /**
         *
         * @var LogDatabase
         */
        var $log;

        /**
         * Initializate variables
         *
         * @param mysqli $connId
         */
        function __construct(&$connId)
        {
            $this->connId     = &$connId;
            $this->resultId   = 0;

            $this->queries    = array();
            $this->queryTimes = array();
            $this->queryCount = 0;

            $this->errorLevel = 0;
            $this->errorDesc  = "";

            $this->aSelect    = array();
            $this->aFrom      = array();
            $this->aJoin      = array();
            $this->aWhere     = array();
            $this->aLike      = array();
            $this->aGroupby   = array();
            $this->aHaving    = array();
            $this->aLimit     = false;
            $this->aOffset    = false;
            $this->aOrder     = false;
            $this->aOrderby   = array();
            $this->aWherein   = array();

            if ( OSC_DEBUG_DB || OSC_DEBUG_DB_EXPLAIN ) $this->log = LogDatabase::newInstance();
        }

        /**
         * Unset connection and result objects
         */
        function __destruct()
        {
            unset($this->connId);
            unset($this->resultId);
        }

        /**
         * It creates a new DBCommandClass object or if it has been created before, it
         * returns the previous object
         *
         * @access public
         * @since 2.3
         * @return DBCommandClass
         */
        public static function newInstance()
        {
            if(!self::$instance instanceof self) {
                self::$instance = new self;
            }
            return self::$instance;
        }

        /**
         * Set SELECT clause
         *
         * @access public
         * @since 2.3
         * @param mixed $select It can be a string or array
         * @return DBCommandClass
         */
        function select($select = '*')
        {
            if( is_string($select) ) {
                $select = explode(',', $select);
            }

            foreach($select as $s) {
                $s = trim($s);

                if($s != '') {
                    $this->aSelect[] = $s;
                }
            }

            return $this;
        }

        /**
         * Set FROM clause
         *
         * @param mixed $from It can be a string or array
         * @return DBCommandClass
         */
        function from($from)
        {
            if( !is_array($from) ) {
                if( strpos($from, ',') !== false) {
                    $from = explode(',', $from);
                } else {
                    $from = array($from);
                }
            }

            foreach($from as $f) {
                $this->aFrom[] = $f;
            }

            return $this;
        }

        /**
         * Set JOIN clause
         *
         * @access public
         * @since 2.3
         * @param string $table
         * @param string $cond
         * @param string $type It can be: LEFT, RIGHT, OUTER, INNER, LEFT OUTER or RIGHT OUTER
         * @return DBCommandClass
         */
        function join($table, $cond, $type = '')
        {
            if($type != '') {
                $type = strtoupper(trim($type));

                if( !in_array($type, array('LEFT', 'RIGHT', 'OUTER', 'INNER', 'LEFT OUTER', 'RIGHT OUTER')) ) {
                    $type = '';
                } else {
                    $type .= ' ';
                }
            }

            $join = $type . ' JOIN ' . $table . ' ON ' . $cond;
            $this->aJoin[] = $join;

            return $this;
        }

        /**
         * Set WHERE clause using OR operator
         *
         * @access public
         * @since 2.3
         * @param mixed $key
         * @param mixed $value
         * @return DBCommandClass
         */
        function where($key, $value = null)
        {
            return $this->_where($key, $value, 'AND ');
        }

        /**
         * Set WHERE clause using OR operator
         *
         * @access public
         * @since 2.3
         * @param mixed $key
         * @param mixed $value
         * @return DBCommandClass
         */
        function orWhere($key, $value = null)
        {
            return $this->_where($key, $value, 'OR ');
        }

        /**
         * Set WHERE clause
         *
         * @access private
         * @since 2.3
         * @param mixed $key
         * @param mixed $value
         * @param string $type
         * @return DBCommandClass
         */
        function _where($key, $value = null, $type = 'AND ')
        {
            if( !is_array($key) ) {
                $key = array($key => $value);
            }

            foreach($key as $k => $v) {
                $prefix = (count($this->aWhere) > 0) ? $type : '';

                if( !$this->_hasOperator($k) ) {
                    $k .= ' =';
                }

                if(!is_null($v)) {
                    $v = ' ' . $this->escape($v);
                }

                $this->aWhere[] = $prefix . $k . $v;
            }

            return $this;
        }

        /**
         * Set WHERE IN clause using AND operator
         *
         * @access public
         * @since 2.3
         * @param mixed $key
         * @param mixed $values
         * @return DBCommandClass
         */
        function whereIn($key = null, $values = null)
        {
            return $this->_whereIn($key, $values, false, 'AND ');
        }

        /**
         * Set WHERE IN clause using OR operator
         *
         * @access public
         * @since 2.3
         * @param mixed $key
         * @param mixed $values
         * @return DBCommandClass
         */
        function orWhereIn($key = null, $values = null)
        {
            return $this->_whereIn($key, $values, false, 'OR ');
        }

        /**
         * Set WHERE NOT IN clause using AND operator
         *
         * @access public
         * @since 2.3
         * @param mixed $key
         * @param mixed $values
         * @return DBCommandClass
         */
        function whereNotIn($key = null, $values = null)
        {
            return $this->_whereIn($key, $values, true, 'AND ');
        }

        /**
         * Set WHERE NOT IN clause using OR operator
         *
         * @access public
         * @since 2.3
         * @param mixed $key
         * @param mixed $values
         * @return DBCommandClass
         */
        function orWhereNotIn($key = null, $values = null)
        {
            return $this->_whereIn($key, $values, true, 'OR ');
        }

        /**
         * Set WHERE IN clause
         *
         * @access private
         * @since 2.3
         * @param mixed $key
         * @param mixed $values
         * @param bool $not
         * @param string $type
         * @return DBCommandClass
         */
        function _whereIn($key = null, $values = null, $not = false, $type = 'AND ')
        {
            if( !is_array($values) ) {
                $values = array($values);
            }

            $not = ($not) ? ' NOT' : '';

            foreach($values as $value) {
                $this->aWherein[] = $this->escape($value);
            }

            $prefix  = (count($this->aWhere) > 0) ? $type : '';

            $whereIn = $prefix . $key . $not . ' IN (' . implode(', ', $this->aWherein) . ') ';

            $this->aWhere[] = $whereIn;
            $this->aWherein = array();
            return $this;
        }

        /**
         * Set LIKE clause
         *
         * @access public
         * @param type $field
         * @param type $match
         * @param type $side
         * @return DBCommandClass
         */
        function like($field, $match = '', $side = 'both')
        {
            return $this->_like($field, $match, 'AND ', $side);
        }

        /**
         * Set NOT LIKE clause using AND operator
         *
         * @access public
         * @since 2.3
         * @param string $field
         * @param string $match
         * @param string $side
         * @return DBCommandClass
         */
        function notLike($field, $match = '', $side = 'both')
        {
            return $this->_like($field, $match, 'AND ', $side, 'NOT');
        }

        /**
         * Set LIKE clause using OR operator
         *
         * @access public
         * @since 2.3
         * @param string $field
         * @param string $match
         * @param type $side
         * @return string
         */
        function orLike($field, $match = '', $si