基于ThinkPHP5.0与H+、Layui的通用型后台管理系统设计源码

<?php // +---------------------------------------------------------------------- // | ThinkPHP [ WE CAN DO IT JUST THINK ] // +---------------------------------------------------------------------- // | Copyright (c) 2006~2016 http://thinkphp.cn All rights reserved. // +---------------------------------------------------------------------- // | Licensed ( http://www.apache.org/licenses/LICENSE-2.0 ) // +---------------------------------------------------------------------- // | Author: liu21st <liu21st@gmail.com> // +---------------------------------------------------------------------- namespace think\db; use PDO; use think\Cache; use think\Collection; use think\Config; use think\Db; use think\db\Builder; use think\db\Connection; use think\db\exception\BindParamException; use think\db\exception\DataNotFoundException; use think\db\exception\ModelNotFoundException; use think\Exception; use think\exception\DbException; use think\exception\PDOException; use think\Loader; use think\Model; use think\model\Relation; use think\Paginator; class Query { // 数据库Connection对象实例 protected $connection; // 数据库驱动类型 protected $builder; // 当前模型类名称 protected $model; // 当前数据表名称（含前缀） protected $table = ''; // 当前数据表名称（不含前缀） protected $name = ''; // 当前数据表主键 protected $pk; // 当前数据表前缀 protected $prefix = ''; // 查询参数 protected $options = []; // 参数绑定 protected $bind = []; // 数据表信息 protected static $info = []; /** * 架构函数 * @access public * @param Connection $connection 数据库对象实例 * @param string $model 模型名 */ public function __construct(Connection $connection = null, $model = '') { $this->connection = $connection ?: Db::connect([], true); $this->builder = $this->connection->getConfig('builder') ?: $this->connection->getConfig('type'); $this->prefix = $this->connection->getConfig('prefix'); $this->model = $model; } /** * 利用__call方法实现一些特殊的Model方法 * @access public * @param string $method 方法名称 * @param array $args 调用参数 * @return mixed * @throws DbException * @throws Exception */ public function __call($method, $args) { if (strtolower(substr($method, 0, 5)) == 'getby') { // 根据某个字段获取记录 $field = Loader::parseName(substr($method, 5)); $where[$field] = $args[0]; return $this->where($where)->find(); } elseif (strtolower(substr($method, 0, 10)) == 'getfieldby') { // 根据某个字段获取记录的某个值 $name = Loader::parseName(substr($method, 10)); $where[$name] = $args[0]; return $this->where($where)->value($args[1]); } else { throw new Exception('method not exist:' . __CLASS__ . '->' . $method); } } /** * 获取当前的数据库Connection对象 * @access public * @return Connection */ public function getConnection() { return $this->connection; } /** * 切换当前的数据库连接 * @access public * @param mixed $config * @return $this */ public function connect($config) { $this->connection = Db::connect($config); return $this; } /** * 指定默认的数据表名（不含前缀） * @access public * @param string $name * @return $this */ public function name($name) { $this->name = $name; return $this; } /** * 指定默认数据表名（含前缀） * @access public * @param string $table 表名 * @return $this */ public function setTable($table) { $this->table = $table; return $this; } /** * 得到当前或者指定名称的数据表 * @access public * @param string $name * @return string */ public function getTable($name = '') { if ($name || empty($this->table)) { $name = $name ?: $this->name; $tableName = $this->prefix; if ($name) { $tableName .= Loader::parseName($name); } } else { $tableName = $this->table; } return $tableName; } /** * 将SQL语句中的__TABLE_NAME__字符串替换成带前缀的表名（小写） * @access public * @param string $sql sql语句 * @return string */ public function parseSqlTable($sql) { if (false !== strpos($sql, '__')) { $prefix = $this->prefix; $sql = preg_replace_callback("/__([A-Z0-9_-]+)__/sU", function ($match) use ($prefix) { return $prefix . strtolower($match[1]); }, $sql); } return $sql; } /** * 执行查询 返回数据集 * @access public * @param string $sql sql指令 * @param array $bind 参数绑定 * @param boolean $master 是否在主服务器读操作 * @param bool|string $class 指定返回的数据集对象 * @return mixed * @throws BindParamException * @throws PDOException */ public function query($sql, $bind = [], $master = false, $class = false) { return $this->connection->query($sql, $bind, $master, $class); } /** * 执行语句 * @access public * @param string $sql sql指令 * @param array $bind 参数绑定 * @return int * @throws BindParamException * @throws PDOException */ public function execute($sql, $bind = []) { return $this->connection->execute($sql, $bind); } /** * 获取最近插入的ID * @access public * @param string $sequence 自增序列名 * @return string */ public function getLastInsID($sequence = null) { return $this->connection->getLastInsID($sequence); } /** * 获取最近一次查询的sql语句 * @access public * @return string */ public function getLastSql() { return $this->connection->getLastSql(); } /** * 执行数据库事务 * @access public * @param callable $callback 数据操作方法回调 * @return mixed */ public function transaction($callback) { return $this->connection->transaction($callback); } /** * 启动事务 * @access public * @return void */ public function startTrans() { $this->connection->startTrans(); } /** * 用于非自动提交状态下面的查询提交 * @access public * @return void * @throws PDOException */ public function commit() { $this->connection->commit(); } /** * 事务回滚 * @access public * @return void * @throws PDOException */ public function rollback() { $this->connection->rollback(); } /** * 批处理执行SQL语句 * 批处理的指令都认为是execute操作 * @access public * @param array $sql SQL批处理指令 * @return boolean */ public function batchQuery($sql = []) { return $this->connection->batchQuery($sql); } /** * 获取数据库的配置参数 * @access public * @param string $name 参数名称 * @return boolean */ public function getConfig($name = '') { return $this->connection->getConfig($name); } /** * 得到分表的的数据表名 * @access public * @param array $data 操作的数据 * @param string $field 分表依据的字段 * @