laravel_admin 列表分组统计总计查询 groupBy totalRow

最新推荐文章于 2022-09-27 16:47:25 发布

aawuwuwuxx

最新推荐文章于 2022-09-27 16:47:25 发布

阅读量2.2k

点赞数

分类专栏： laravel_admin 文章标签： php laravel_admin groupby

本文链接：https://blog.csdn.net/aawuwuwuxx/article/details/115166671

版权

laravel_admin 专栏收录该内容

8 篇文章 1 订阅

订阅专栏

该代码段展示了一个在 Laravel Admin 中进行列表数据分组统计的方法。通过构造 SQL 查询，筛选出状态为3, 4, 5的订单商品，计算每个SKU的销售数量、总金额和成本总金额，并按销售数量降序排列。使用 Grid 组件展示数据并添加了合计行，便于查看销售汇总信息。

摘要由CSDN通过智能技术生成

protected function grid()
    {
        $grid = new Grid(new OrderGoods());

$sql = 'SELECT
		`te_a`.*,
		sum( te_a.num ) AS a_num,
		sum( te_a.total_amount ) AS a_total_amount,
		sum( te_a.cost_total_amount ) AS a_cost_total_amount 
	FROM
		`te_order_goods` AS `te_a` 
	WHERE
		EXISTS (
		SELECT
			1 
		FROM
			`te_orders` 
		WHERE
			te_orders.id = te_a.order_id 
			AND `state` IN (3,
				4,
			5)) 
	AND `te_a`.`sku_id` <> 0
	GROUP BY
		`te_a`.`sku_id`';

        $grid->model()->from(\DB::raw('('.$sql.') as te_order_goods'))
            ->orderByRaw('te_order_goods.a_num desc')
            ->select(['order_goods.*', 'order_goods.a_num', 'order_goods.a_total_amount', 'order_goods.a_cost_total_amount']);

$grid->column('a_num', __('销售数量'))->totalRow();
        $grid->column('a_total_amount', __('销售金额'))->totalRow();
}

laravel_admin 列表分组统计，合计