计算平均交货时间 [英] Calculate average delivery time laravel

问题描述

我有一个电子商务应用程序.所有已交付的订单都有一列"updated_at".我可以在此列中计算平均交货时间总交货订单吗?

I have a e-commerce application. All delivered orders have a column "updated_at". I can with this column calculate average delivery time total delivered orders?

我已经计算了所有订单，并更新了column_at列. 我需要做的是计算平均时间?

I have count all orders and column updated_at. What I need do, that calculate average time?

我的代码:

$deliveryTime = Order::where('status', '8')->count(); //get A count delivered orders..

推荐答案

来自OP的问题和评论:

From OP's question and comment :

平均交货时间=(订单创建日期与order_delivery_date的日期差)的平均值

订单创建日期字段= created_at订单交货日期字段= updated_at

order creation date field = created_at order delivery date field = updated_at

$averageTime = Order::select(\DB::raw("DATEDIFF(updated_at, created_at)AS day_diff"))->where('status', '8')->get()->avg('day_diff');

如果需要舍入该值，则可以使用round($averageTime);

If it required to round off the value you can use round($averageTime);

这篇关于计算平均交货时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！