/**
* 获取分页的用户列表
* @param string $type 用户类型
*/
public function getUserList($type = 'user')
{
$count = $this->where(['type' => $type])->count();
// 查询满足要求的总记录数
$page = new \Org\Util\AdminPage($count);
// 实例化分页类 传入总记录数
$show = $page->show();
// 分页显示输出
// 进行分页数据查询
$list = $this->where(['type' => $type])->limit($page->firstRow . ',' . $page->listRows)->select();
return $user = ['list' => $list, 'page' => $show];
}
/**
* 分页获取当前登录用户家的菜品
* @return array 菜品
*/
public function getGoodsListByUserId($id)
{
$shopId = D('shop')->getByUserId($id)['id'];
$count = $this->where(['shop_id' => $shopId])->count();
// 查询满足要求的总记录数
$page = new \Org\Util\AdminPage($count);
// 实例化分页类 传入总记录数
$show = $page->show();
// 分页显示输出
// 进行分页数据查询
$list = $this->where(['shop_id' => $shopId])->limit($page->firstRow . ',' . $page->listRows)->select();
return $goods = ['list' => $list, 'page' => $show];
}
/**
* 获取分页的商家列表
* @return array 店铺列表
*/
public function getShopList()
{
$count = $this->count();
// 查询满足要求的总记录数
$page = new \Org\Util\AdminPage($count);
// 实例化分页类 传入总记录数
$show = $page->show();
// 分页显示输出
// 进行分页数据查询
$list = $this->limit($page->firstRow . ',' . $page->listRows)->select();
foreach ($list as $key => $value) {
$list[$key]['user'] = D('user')->getById($value['user_id']);
}
return $shop = ['list' => $list, 'page' => $show];
}
/**
* 分页获取订单
* @param intger $id shopid
* @return array 菜品
*/
public function getOrderList()
{
$count = $this->count();
// 查询满足要求的总记录数
$page = new \Org\Util\AdminPage($count);
// 实例化分页类 传入总记录数
$show = $page->show();
// 分页显示输出
// 进行分页数据查询
$list = $this->order('purchase_time desc')->limit($page->firstRow . ',' . $page->listRows)->select();
//--补充用户信息
foreach ($list as $key => $value) {
$list[$key]['user'] = D('User')->getById($value['user_id']);
$list[$key]['shop'] = D('Shop')->getById($value['shop_id']);
}
return array('list' => $list, 'page' => $show);
}
/**
* 分页获取当前商家菜品评价
* @return array 菜品评价
*/
public function getGoodsCommentListBySeller($sellerId = 0)
{
if ($sellerId == 0) {
$sellerId = session('seller')['id'];
}
$shopId = D('shop')->getShopByUser($sellerId)['id'];
$count = $this->where(['shop_id' => $shopId])->count();
// 查询满足要求的总记录数
$page = new \Org\Util\AdminPage($count);
// 实例化分页类 传入总记录数
$show = $page->show();
// 分页显示输出
// 进行分页数据查询
$list = $this->where(['shop_id' => $shopId])->limit($page->firstRow . ',' . $page->listRows)->order('id desc')->select();
foreach ($list as $k => $v) {
$shop = D('Shop')->getById($v['shop_id']);
$list[$k]['shop_name'] = $shop['name'];
$list[$k]['username'] = D('User')->getById($v['user_id'])['username'];
$list[$k]['goods_name'] = D('Goods')->getById($v['goods_id'])['name'];
}
return $goodsComment = ['list' => $list, 'page' => $show];
}
