thinkphp5按照设置的营业时间统计每天销售额分组

最新推荐文章于 2021-03-10 05:22:42 发布

名字长点才好记

最新推荐文章于 2021-03-10 05:22:42 发布

阅读量788

点赞数

分类专栏： PHP

本文为博主原创文章，未经博主允许不得转载。

本文链接：https://blog.csdn.net/bianlitongcn/article/details/98874195

版权

PHP 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

$day_start_time = '11:22:33';
$hour = substr ($day_start_time , 0, 2);
$minute = substr ($day_start_time , -5, 2);
$second   = substr ($day_start_time , -2);
$orders = DB::name('wxOrder')
            ->field("createTime,SUM(DISTINCT dayAmount) orderpaid,FROM_UNIXTIME(createTime,'%Y-%m-%d $hour:$minute:$second') AS dayorder")
            ->where('contactNumber',$contact_number)
            ->where('isDelete',0)
            ->where('orderStatus', 4)
            ->where('payStatus', 1)
            ->group('dayorder')
            ->select();