本文整理汇总了PHP中app\Product::sum方法的典型用法代码示例。如果您正苦于以下问题：PHP Product::sum方法的具体用法？PHP Product::sum怎么用？PHP Product::sum使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类app\Product的用法示例。
在下文中一共展示了Product::sum方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: statistics
public function statistics()
{
// Getting data about top 3 products
$products = App\Product::orderBy('clicks', 'desc')->limit(3)->select(['id', 'item_id', 'clicks', 'views'])->get()->toArray();
foreach ($products as $key => $product) {
$products[$key]['img'] = App\Product::find($product['id'])->images()->first()->toArray()['url'];
}
// Total clicks and earned money
$total['clicks'] = App\Product::sum('clicks');
$total['earned'] = 0;
// Getting data about shops + clicks per shop
$shops_query = App\Shop::orderBy('name', 'desc')->select(['id', 'name', 'earned'])->get();
$shops = [];
foreach ($shops_query as $shop) {
$shops[] = ['id' => $shop->id, 'name' => $shop->name, 'earned' => $shop->earned, 'clicks' => round(App\Product::where('shop_id', '=', $shop->id)->sum('clicks'), 2)];
$total['earned'] += $shop->earned;
}
return \View::make('admin/statistics', ['title' => 'Statistiky', 'top_products' => $products, 'shops' => $shops, 'total' => $total]);
}示例2: balancing
/**
* 库存结算
*
* @return response
*/
public function balancing()
{
return response()->json(['inventory' => Product::sum('count'), 'totalPrice' => InventoryLog::where('type', '=', InventoryConfig::IN)->sum(DB::raw('count * price')), 'totalPayment' => InventoryLog::where('type', '=', InventoryConfig::OUT)->sum(DB::raw('count * price'))]);
}