一。接收值并分页展示
$user_id = $request->getAttribute('route')->getArgument('id');
$db = $this->db;
$couponInfo = $db->table('wechat_api.user_coupon as uc')
->join('coupon as c', 'c.id', '=' ,'uc.coupon_id')
->where('uc.user_id', $user_id)
->select('uc.user_id','c.id','c.coupon_head',$db::raw("if(city_name='0','全国',city_name) as city,
if(new_old_user='0','通用',if(new_old_user='1','新用户','老用户')) as new_old_user,
group_concat(c.start_time,'~',c.end_time) as time,concat(uc.money, '元') as money"),
'uc.created_time','uc.used_time')
->groupBy('uc.id')
->get();
$count = $couponInfo->count();
return $response->withStatus(200)->withJson([
'count'=> $count,
'couponInfo' => $couponInfo->forPage($params['page'],$params['size'])
]);
二。检查今天的退款数和退款总金额
/*检查退款数*/
$today_refund = $db::table('balance_to_cash')
->whereRaw('date(created_at)=date(now())')
->select($db::raw('count(id) as today,sum(cash_money) as cash_money'))
->first();
lumen 数据库操作
最新推荐文章于 2023-06-28 15:34:04 发布