PHP Think\Db Query::field示例

field() public method

指定查询字段 支持字段排除和指定数据表

public field ( mixed $field, boolean $except = false, string $tableName = '', string $prefix = '', string $alias = '' )
$field	mixed
$except	boolean	是否排除
$tableName	string	数据表名
$prefix	string	字段前缀
$alias	string	别名前缀

示例#1

文件： Merge.php 项目： xuyi5918/ipensoft

 /**
  * 附加查询表达式
  * @access protected
  * @param \think\db\Query $query 查询对象
  * @return \think\db\Query
  */
 protected static function attachQuery($query)
 {
     $master = basename(str_replace('\\', '/', get_called_class()));
     $class = new static();
     $fields = self::getModelField($master, '', $class->mapFields);
     $query->alias($master)->field($fields);
     foreach (static::$relationModel as $key => $model) {
         $name = is_int($key) ? $model : $key;
         $table = is_int($key) ? self::db()->name($name)->getTable() : $model;
         $query->join($table . ' ' . $name, $name . '.' . $class->fk . '=' . $master . '.' . $class->getPk());
         $fields = self::getModelField($name, $table, $class->mapFields);
         $query->field($fields);
     }
     return $query;
 }