1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
| <?php
|
| namespace app\api\model\plus\assemble;
|
| use app\common\model\plus\assemble\BillUser as BillUserModel;
|
| class BillUser extends BillUserModel
| {
| public function add($data)
| {
| return self::create($data);
| }
|
| /**
| * 查询拼团数量，10拼单中 20拼单成功
| */
| public static function getOrderNum($user_id, $assemble_product_id, $assemble_activity_id){
| $model = new self();
| return $model->alias('user')->where('user_id', '=', $user_id)
| ->join('assemble_bill bill', 'bill.assemble_bill_id = user.assemble_bill_id','left')
| ->where('user.user_id', '=', $user_id)
| ->where('bill.assemble_product_id', '=', $assemble_product_id)
| ->where('bill.assemble_activity_id', '=', $assemble_activity_id)
| ->where('bill.status', 'in', [10,20])
| ->count();
| }
| }
|
|
