优惠券数组
<p><img src="https://www.showdoc.cc/server/api/common/visitfile/sign/2a6a1d5ae0beb3d3f34d7de348e4203e?showdoc=.jpg" alt="" /></p>
<pre><code class="language-php">public function lists(MyCoupon $myCoupon)
{
$myCoupon = $myCoupon->where('user_id', $this->request->user_id)
->where('craftsmen_service_id', '>=', 1)
->groupBy('craftsmen_service_id')
->get(['craftsmen_service_id']);
$myCoupons = $myCoupon->toArray();
foreach ($myCoupons as $value) {
$my_arr[] = $value['craftsmen_service_id'];
}
$craftsmen = DB::table('craftsmen as c')
->whereIn('c.id', $my_arr)
->leftJoin('user_data as ud', 'c.user_id', '=', 'ud.user_id')
->leftJoin('profession as p', 'c.profession_id', '=', 'p.id')
->select('c.id', 'ud.name', 'c.cover_map', 'p.pr_name')
->get();
$myCoupon = DB::table('my_coupons')
->whereIn('craftsmen_service_id', $my_arr)
->get(['craftsmen_service_id', 'coupon_name', 'start_time', 'end_time', 'discount_money', 'use_threshold', 'state']);
$crafts = json_decode($craftsmen, true);
$myCoupon = json_decode($myCoupon, true);
foreach ($crafts as $k=>$craft) {
foreach ($myCoupon as $key=>$my_item) {
if ($craft['id'] == $my_item['craftsmen_service_id']) {
$crafts[$k]['my_coupon'][] = $my_item;
}
}
}
return $this->success($crafts);
}</code></pre>