'主键', 'mall_id' => 'mall_id', 'user_id' => 'user_id', 'order_id' => 'order_id', 'coupon_id' => 'coupon_id', 'user_coupon_id' => 'user_coupon_id', 'status' => '状态[-1:删除;0:禁用;1启用]', 'created_at' => '创建时间', 'updated_at' => '修改时间', ]; } public static function setData($params) { Yii::$app->db->close(); try { $order_detail_id_arr = array_keys($params['order_detail_id_arr']); $list = StoreOrderMarketing::lists(['where' => [['order_detail_id' => $order_detail_id_arr]], 'select' => 'user_coupon_id,order_detail_id']); $user_coupon_id_arr = []; $temp_arr = []; $user_coupon_arr = []; $user_coupon_order_detail_id_arr = []; foreach ($list as $item) { $user_coupon_id = json_decode($item['user_coupon_id'], 'true'); if (!empty($user_coupon_id)) { foreach ($user_coupon_id as $key => $val) { if(isset($user_coupon_arr[$key])){ $user_coupon_arr[$key] += $val; }else{ $user_coupon_arr[$key] = $val; } $user_coupon_order_detail_id_arr[$key][] = $item['order_detail_id']; $user_coupon_id_arr[] = $key; $temp_arr[$key] = $item['order_detail_id']; } } } if (!empty($user_coupon_id_arr)) { $coupon_user_relate_list = StoreCouponUserRelate::lists(['where' => [['id' => $user_coupon_id_arr]], 'select' => 'id,coupon_id,store_id,from_type']); $field = ['mall_id','user_id', 'order_id', 'coupon_id', 'user_coupon_id', 'status', 'created_at', 'updated_at']; $time = time(); $insert = []; foreach ($coupon_user_relate_list as $val) { $arr['mall_id'] = $params['mall_id']; $arr['user_id'] = $params['user_id']; $arr['order_id'] = $params['order_detail_id_arr'][$temp_arr[$val['id']]]; $arr['coupon_id'] = $val['coupon_id']; $arr['user_coupon_id'] = $val['id']; $arr['status'] = StatusEnum::ENABLED; $arr['created_at'] = $time; $arr['updated_at'] = $time; $insert[] = $arr; $set_data = [ 'mall_id'=>$params['mall_id'], 'coupon_id'=>$val['coupon_id'], 'used_number'=>1,'use_user_number'=>1,'use_order_number'=>$params['counts']??0, 'total_payed_amount'=>$params['total_payed_amount']??0,'total_use_coupon_payed_amount'=>$params['total_use_coupon_payed_amount']??0, 'total_discount_amount'=>$user_coupon_arr[$val['id']]??0, ]; $set_goods_data = [ 'mall_id'=>$params['mall_id'], 'coupon_id'=>$val['coupon_id'], 'payed_number'=>0,'buyed_user_number'=>1, ]; if(!empty($user_coupon_order_detail_id_arr[$val['id']])){ $order_detail_ids = $user_coupon_order_detail_id_arr[$val['id']]; foreach ($order_detail_ids as $order_detail_id){ if(!empty($params['order_detail_arr'][$order_detail_id])){ $set_goods_data['good_id'] = $params['order_detail_arr'][$order_detail_id]['goods_id']; $set_goods_data['payed_number'] = $params['order_detail_arr'][$order_detail_id]['num']; if($val['from_type']==1){ if(MallAddons::isInstall($params['mall_id'],AddonsEnum::ADDONS_NAME_COUPON)){ AddonsCouponGoodStatistics::setData($set_goods_data); } }else{ StoreCouponGoodStatistics::setData($set_goods_data); } } } } if($val['from_type']==1){ if(MallAddons::isInstall($params['mall_id'],AddonsEnum::ADDONS_NAME_COUPON)){ AddonsCouponStatistics::setData($set_data); } }else{ $set_data['store_id'] = $val['store_id']; StoreCouponStatistics::setData($set_data); } } // 批量插入数据 $res = Yii::$app->db->createCommand()->batchInsert(self::tableName(), $field, $insert)->execute(); if ($res == false) throw new \Exception('添加优惠券使用记录失败'); } return true; }catch (\Exception $e) { self::$static_error = $e->getMessage(); return false; } } }