93 lines
		
	
	
		
			2.6 KiB
		
	
	
	
		
			PHP
		
	
	
	
	
	
			
		
		
	
	
			93 lines
		
	
	
		
			2.6 KiB
		
	
	
	
		
			PHP
		
	
	
	
	
	
<?php
 | 
						||
 | 
						||
namespace app\admin\controller\example;
 | 
						||
 | 
						||
use app\common\controller\Backend;
 | 
						||
 | 
						||
/**
 | 
						||
 * 多表格示例
 | 
						||
 *
 | 
						||
 * @icon fa fa-table
 | 
						||
 * @remark 当一个页面上存在多个Bootstrap-table时该如何控制按钮和表格
 | 
						||
 */
 | 
						||
class Multitable extends Backend
 | 
						||
{
 | 
						||
    protected $model = null;
 | 
						||
    protected $noNeedRight = ['table1', 'table2'];
 | 
						||
 | 
						||
    public function _initialize()
 | 
						||
    {
 | 
						||
        parent::_initialize();
 | 
						||
    }
 | 
						||
 | 
						||
    /**
 | 
						||
     * 查看
 | 
						||
     */
 | 
						||
    public function index()
 | 
						||
    {
 | 
						||
        $this->loadlang('general/attachment');
 | 
						||
        $this->loadlang('general/crontab');
 | 
						||
        return $this->view->fetch();
 | 
						||
    }
 | 
						||
 | 
						||
    public function table1()
 | 
						||
    {
 | 
						||
        $this->model = model('Attachment');
 | 
						||
        //设置过滤方法
 | 
						||
        $this->request->filter(['strip_tags']);
 | 
						||
        if ($this->request->isAjax()) {
 | 
						||
            //如果发送的来源是Selectpage,则转发到Selectpage
 | 
						||
            if ($this->request->request('keyField')) {
 | 
						||
                return $this->selectpage();
 | 
						||
            }
 | 
						||
            list($where, $sort, $order, $offset, $limit) = $this->buildparams();
 | 
						||
            $total = $this->model
 | 
						||
                    ->where($where)
 | 
						||
                ->field('id,filename,filesize,imagewidth,imageheight,mimetype')
 | 
						||
                    ->order($sort, $order)
 | 
						||
                    ->count();
 | 
						||
 | 
						||
            $list = $this->model
 | 
						||
                    ->where($where)
 | 
						||
                    ->field('id,filename,filesize,imagewidth,imageheight,mimetype')
 | 
						||
                    ->order($sort, $order)
 | 
						||
                    ->limit($offset, $limit)
 | 
						||
                    ->select();
 | 
						||
 | 
						||
            $result = array("total" => $total, "rows" => $list);
 | 
						||
 | 
						||
            return json($result);
 | 
						||
        }
 | 
						||
        return $this->view->fetch('index');
 | 
						||
    }
 | 
						||
 | 
						||
    public function table2()
 | 
						||
    {
 | 
						||
        $this->model = model('AdminLog');
 | 
						||
        //设置过滤方法
 | 
						||
        $this->request->filter(['strip_tags']);
 | 
						||
        if ($this->request->isAjax()) {
 | 
						||
            //如果发送的来源是Selectpage,则转发到Selectpage
 | 
						||
            if ($this->request->request('keyField')) {
 | 
						||
                return $this->selectpage();
 | 
						||
            }
 | 
						||
            list($where, $sort, $order, $offset, $limit) = $this->buildparams();
 | 
						||
            $total = $this->model
 | 
						||
                    ->where($where)
 | 
						||
                    ->order($sort, $order)
 | 
						||
                    ->count();
 | 
						||
 | 
						||
            $list = $this->model
 | 
						||
                    ->where($where)
 | 
						||
                    ->order($sort, $order)
 | 
						||
                    ->limit($offset, $limit)
 | 
						||
                    ->select();
 | 
						||
 | 
						||
            $result = array("total" => $total, "rows" => $list);
 | 
						||
 | 
						||
            return json($result);
 | 
						||
        }
 | 
						||
        return $this->view->fetch('index');
 | 
						||
    }
 | 
						||
}
 |