根据某张表的数据进行分组后获取最新数据
$count = A表::query()
->where('company_wechat_id', $wechatId)
->where('is_delete', 0)
->count();
$sql = A表::query()
->where('company_wechat_id', $wechatId)
->where(function ($query) use ($customerIdArr, $type) {
if ($type) { //type 0 查询所有 1 按标签查
$query->whereIn('customer_id', $customerIdArr);
}
})
->where('is_delete', 0)
->orderBy('id', 'DESC')->limit($count);
$list = A表::query()
->from(DB::raw('(' . $sql->toSql() . ') as a'))
->mergeBindings($sql->getQuery())
->where('company_wechat_id', $wechatId)
->where('is_delete', 0)
->groupBy(['customer_id'])
->select(['customer_id as id', 'user_id',
DB::raw("(select B表.external_userid from B表 where
wechat_customer.id=a.customer_id) as external_userid")
])
->get()
->toArray();
根据某张表的数据进行分组后获取最新数据
最新推荐文章于 2024-07-16 11:51:58 发布