<?php
|
|
namespace app\common\model\plus\groupbuy;
|
|
use app\common\model\BaseModel;
|
use app\common\model\order\Order as OrderModel;
|
use app\common\model\plus\groupbuy\BillUser as BillUserModel;
|
|
/**
|
* 团购订单模型
|
*/
|
class Bill extends BaseModel
|
{
|
protected $name = 'groupbuy_bill';
|
protected $pk = 'groupbuy_bill_id';
|
|
/**
|
* 获取团购订单详情
|
*/
|
public static function detail($groupbuy_bill_id, $with = [])
|
{
|
return (new static())->with($with)->where('groupbuy_bill_id', '=', $groupbuy_bill_id)->find();
|
}
|
|
/**
|
* 关联团购活动表
|
*/
|
public function active()
|
{
|
return $this->belongsTo('app\\common\\model\\plus\\groupbuy\\Active', 'groupbuy_active_id', 'groupbuy_active_id');
|
}
|
|
/**
|
* 关联创建者
|
*/
|
public function user()
|
{
|
return $this->belongsTo('app\\common\\model\\user\\User', 'creator_id', 'user_id')
|
->field(['user_id', 'nickName', 'avatarUrl']);
|
}
|
|
/**
|
* 关联团购成员表
|
*/
|
public function billUser()
|
{
|
return $this->hasMany('app\\common\\model\\plus\\groupbuy\\BillUser', 'groupbuy_bill_id', 'groupbuy_bill_id')
|
->field(['user_id','groupbuy_bill_id'])
|
->order(['create_time' => 'asc']);
|
}
|
|
/**
|
* 创建团购订单
|
*/
|
public function createBill($data)
|
{
|
$this->allowField(true)->save($data);
|
return $this['groupbuy_bill_id'];
|
}
|
|
/**
|
* 更新团购订单状态
|
*/
|
public function updateBillStatus($status)
|
{
|
return $this->save(['status' => $status]);
|
}
|
|
/**
|
* 更新团购人数
|
*/
|
public function updatePeopleCount($increment = 1)
|
{
|
return $this->where('groupbuy_bill_id', '=', $this['groupbuy_bill_id'])
|
->inc('actual_people', $increment)
|
->update();
|
}
|
|
/**
|
* 处理团购订单
|
*/
|
public function processOrder($product, $sku)
|
{
|
// 更新团购人数
|
$this->where('groupbuy_bill_id', '=', $this['groupbuy_bill_id'])
|
->inc('actual_people', 1)
|
->update();
|
|
// 插入团购记录表
|
$bill_user_model = new BillUser();
|
$bill_user_model->save([
|
'groupbuy_bill_id' => $this['groupbuy_bill_id'],
|
'order_id' => $product['order_id'],
|
'user_id' => $product['user_id'],
|
'is_creator' => 0,
|
'app_id' => $product['app_id'],
|
]);
|
|
// 获取团购商品信息
|
$groupbuy_product = Product::detail($sku['groupbuy_product_id']);
|
|
// 判断团购是否成功
|
if($this['actual_people'] + 1 >= $groupbuy_product['groupbuy_num']){
|
$this->save([
|
'status' => 20
|
]);
|
|
$order_list = (new BillUserModel)
|
->field(['order_id'])
|
->where('groupbuy_bill_id', '=', $this['groupbuy_bill_id'])
|
->select();
|
$orderIds = \app\common\library\helper::getArrayColumn($order_list, 'order_id');
|
|
// 更新主订单表团购状态
|
(new OrderModel)->where('order_id', 'in', $orderIds)
|
->save([
|
'groupbuy_status' => 20
|
]);
|
}
|
}
|
}
|
