tpframe之查询数据

查询数据实际上已经有了

一、控制器

在控制器里面添加index方法

<?php namespace app\frontend\controller; use \tpfcore\Core; class User extends FrontendBase { public function add() { IS_POST && $this->jump(Core::loadModel($this->name)->saveUser($this->param)); return $this->fetch("add"); } public function edit(){ IS_POST && $this->jump(Core::loadModel($this->name)->editUser($this->param)); return $this->fetch("edit",[ "list"=>Core::loadModel($this->name)->listUser($this->param) ]); } public function del(){ $this->jump(Core::loadModel($this->name)->delUser($this->param)); } public function index(){ return $this->fetch("index",[ "list"=>Core::loadModel($this->name)->listUser([ "order"=>"id desc" "paginate" => ['rows' => 30] ]) ]); } }

就这么简单就实现了查询的操作，那分页怎么办呢？不急，直接在视图里面须要显示分页的地方加入{$list->render()}就可以了

注意这里要实现分页，必须传递paginate参数，并指定每页显示多少条

具体实现用的是Bootstrap类里面的render方法实现的

/**

• 渲染分页html
• @return mixed */ public function render() { if ($this->hasPages()) { if ($this->simple) { return sprintf( '<ul class="pager">%s %s</ul>', $this->getPreviousButton(), $this->getNextButton() ); } else { return sprintf( '<ul class="pagination">%s %s %s</ul>', $this->getPreviousButton(), $this->getLinks(), $this->getNextButton() ); } } }

二、服务层

<?php // +---------------------------------------------------------------------- // | Author: yaoyihong <510974211@qq.com> // +---------------------------------------------------------------------- namespace app\frontend\service;

use app\common\service\ServiceBase;
use \tpfcore\Core;
/**
 * 基础服务
 */
class User extends FrontendBase
{
    public function editUser($data){
        // 在进行数据操作前进行数据验证
        $validate=\think\Loader::validate($this->name);
        $validate_result = $validate->scene('edit')->check($data);
        if (!$validate_result) {    
            return [RESULT_ERROR, $validate->getError(), null];
        }
        return Core::loadModel($this->name)->saveObject($data);
    }
    public function listUser($data){
        return Core::loadModel($this->name)->listUser($data);
    }
}

三、查询的其它操作

1、getStatistics ($where = [], $stat_type = 'count', $field = 'id')

聚合函数-统计数据

例如：self::getStatistics(["status"=>0]); //统计正常用户有多少

2、array getColumns($where = [], $field = '', $key = '')

得到某个列的数组

3、mixed getColumnValue($where = [], $field = '', $default = null, $force = false)

得到某个字段的值

4、getOneObject($where = [], $field = true)

查找单条记录，返回的是一维数组

5、getList($param=[])

获取数据

注意：只有通过此查询的数据才有可能进行数据缓存，默认参数如下

[ "where" =>[], "field" =>true, "order" =>"", "paginate" =>['rows' => null, 'simple' => false, 'config' => []], "join" =>['join' => null, 'condition' => null, 'type' => 'INNER'], "group" =>['group' => '', 'having' => ''], "limit" =>null, "data" =>null, "expire"=>0 ]