本文整理匯總了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'))]);
}