TYPE-0 PERFECT SEIHA

Server Info: FreeBSD scimitar.blueboard.cz 13.5-STABLE FreeBSD 13.5-STABLE stable/13-4f2925105 GENERIC amd64
Software: Apache
User: www

Edit File: /data/www/19068/fszoo_net/www/api/2/root/vendor/teze/teze/src/sql/src/Sql/SqlBuilder.php

<?php

/**
 * Copyright (c) Jan Pospisil (http://www.jan-pospisil.cz)
 */

namespace Teze\SqlBuilder;

use Nette\Utils\ArrayHash;
use Nette\Utils\Validators;

/**
 * SqlBuilder
 * @author Jan Pospisil
 */
class SqlBuilder extends \Nette\Object
{

const SELECT = 'SELECT';
	const DELETE = 'DELETE';

const MYSQL = 'mysql';
	const MSSQL = 'mssql';

private static $driver = self::MYSQL;

private $select = array ();
	private $table;
	private $where;
	private $joins;
	private $order;
	private $columns; // columns to be select
	private $action;
	private $group;
	private $limit;
	private $offset;

public function __construct($action) {
		$this->action = $action;
	}

public static function setDriver($driver){
		if($driver == 'sqlsrv')
			$driver = self::MSSQL;
		if($driver != self::MYSQL && $driver != self::MSSQL)
			throw new InvalidArgumentException('Invalid driver '.$driver);
		self::$driver = $driver;
	}

public static function select($select) {
		$return = new self(self::SELECT);
		$return->selectColumns($select);
		return $return;
	}

public function selectColumns($columns) {
		$this->columns = $columns;
		return $this;
	}

public function addColumn($column){
		if($this->columns)
			$this->columns .= ', '.$column;
		else
			$this->columns = $column;
		return $this;
	}

public function setAction($action) {
		$this->action = $action;
		return $this;
	}

public static function delete() {
		$return = new self(self::DELETE);
		return $return;
	}

public function from($table) {
		$this->table = $table;
		return $this;
	}

public function where($where) {
		$args = func_get_args();
		array_shift($args);
		$this->where[] = array ('sql' => $where, 'args' => $args);
		return $this;
	}

public function join($join, $table, $sql) {
		$this->joins[] = array (
			'join' => $join,
			'table' => $table,
			'sql' => $sql
		);
		return $this;
	}

public function innerJoin($table, $sql) {
		return $this->join('INNER JOIN', $table, $sql);
	}

public function leftJoin($table, $sql) {
		return $this->join('LEFT JOIN', $table, $sql);
	}

public function group($column){
		$this->group = $column;
		return $this;
	}

public function whereIn($in, $column) {
		if(!$in) {
			$this->where('0 = 1');
			return $this;
		}
		if(is_array($in)) {
			if(count($in) == 1){
				$this->where[] = array (
					'sql' => $column . ' = ?',
					'args' => $in
				);
			}
			else {
				$p = $in;
				$this->where[] = array (
					'sql' => $column . ' IN (?)', // user queryArgs() instead of query() !!!
					'args' => array ($p)
				);
			}
		} else {
			$p = '(' . $in . ')';
			$this->where[] = array (
				'sql' => $column . ' IN ?',
				'args' => array ($p)
			);
		}
		return $this;
	}

public function getSql() {
		$sql = array ();
		$sql[] = $this->action;
		if($this->action == self::SELECT)
			$sql[] = $this->columns;
		$sql[] = 'FROM';
		$sql[] = $this->table;
		$params = array ();
		if($this->joins) {
			foreach ($this->joins as $join) {
				$sql[] = $join['join'];
				$sql[] = $join['table'];
				$sql[] = 'ON';
				$sql[] = $join['sql'];
			}
		}
		if($this->where) {
			$sql[] = 'WHERE';
			$whereSql = array ();
			foreach ($this->where as $where) {
				$whereSql[] = $where['sql'];
				foreach ($where['args'] as $a)
					$params[] = $a;
			}
			$sql[] = implode(' AND ', $whereSql);
		}
		if($this->group){
			$sql[] = 'GROUP BY '.$this->group;
		}
		if($this->order)
			$sql[] = 'ORDER BY ' . $this->order;
		if(self::$driver == self::MYSQL){
			if($this->limit){
				$sql[] = 'LIMIT ?';
				$params[] = $this->limit;
			}
			if($this->offset){
				$sql[] = 'OFFSET ?';
				$params[] = $this->offset;
			}
		} elseif(self::$driver == self::MSSQL){
			if($this->offset !== NULL && $this->limit !== NULL){
				$this->addColumn('ROW_NUMBER() OVER (ORDER BY '.$this->table.'.id) AS RowNum');
				$from = $this->offset;
				$to = $this->offset + $this->limit;
				$this->limit = NULL;
				$this->offset = NULL;
				$cloneSql = $this->getSql();
				$return = 'SELECT * FROM ('.$cloneSql->sql.') AS MyDerivedTable WHERE MyDerivedTable.RowNum BETWEEN '.$from.' AND '.$to;
				$return2 = $return = array (
					'sql' => $return,
					'params' => $cloneSql->params
				);
				return ArrayHash::from($return2, FALSE);
			}
		} else
			throw new \InvalidArgumentException('Invalid driver '.self::$driver);
		$return = array (
			'sql' => implode(' ', $sql),
			'params' => $params
		);
		return ArrayHash::from($return, FALSE);
	}

public function page($page, $itemsPerPage){
		if(!Validators::isNumericInt($page))
			throw new \InvalidArgumentException('Page must be number. '.$page);
		if(!Validators::isNumericInt($itemsPerPage))
			throw new \InvalidArgumentException('ItemsPerPage must be number. '.$itemsPerPage);
		$this->limit = $itemsPerPage;
		$this->offset = ($page - 1) * $itemsPerPage;
	}

public function order($order) {
		$this->order = $order;
		return $this;
	}
}

	Name	Size	Permissions	Modified	User/Group
	SqlBuilder.php	5120	0644	2016-03-05 11:28:54	Unknown/Unknown