apisongcan/application/index/model/BoxActionModel.php

<?php

namespace app\index\model;

use think\Model;

class BoxActionModel extends Model {

    // 确定链接表名
    protected $name = 'box_action_record';

    /**
     * 根据搜索条件获取箱子列表信息
     * @param $offset
     * @param $limit
     */
    public function getBoxActionsByWhere($where , $offset , $limit)
    {
        return $this->where($where)->limit($offset, $limit)->order('box_number asc')->select();
    }

    /**
     * 根据搜索条件获取所有的箱子数量
     */
    public function getAllCounts($where)
    {
        return $this->where($where)->count();
    }
}