<?php
|
|
namespace app\api\model\plus\groupbuy;
|
|
use app\common\model\plus\groupbuy\Bill as BillModel;
|
|
/**
|
* 团购订单模型（API端）
|
*/
|
class Bill extends BillModel
|
{
|
/**
|
* 获取正在进行中的团购订单
|
*/
|
public function getBill($groupbuy_product_id, $groupbuy_active_id, $groupbuy_num)
|
{
|
$filter = [
|
'groupbuy_product_id' => $groupbuy_product_id,
|
'groupbuy_active_id' => $groupbuy_active_id,
|
'status' => 10
|
];
|
$res = $this->with(['user','billUser'])
|
->where($filter)
|
->order(['create_time' => 'desc'])
|
->select();
|
foreach ($res as $key => $val) {
|
$res[$key]['dif_people'] = $groupbuy_num - $val['actual_people'];
|
}
|
return $res;
|
}
|
|
/**
|
* 获取用户参与的团购订单
|
*/
|
public function getUserBills($user_id, $groupbuy_product_id = null)
|
{
|
$model = $this->with(['active', 'user', 'billUser.user'])
|
->where('creator_id', '=', $user_id)
|
->whereOrExists(function ($query) use ($user_id) {
|
$query->table('groupbuy_bill_user gb_user')
|
->where('gb_user.groupbuy_bill_id', '=', 'groupbuy_bill.groupbuy_bill_id')
|
->where('gb_user.user_id', '=', $user_id);
|
});
|
|
if ($groupbuy_product_id) {
|
$model = $model->where('groupbuy_product_id', '=', $groupbuy_product_id);
|
}
|
|
return $model->order(['create_time' => 'desc'])->select();
|
}
|
}
|
