This is my table :
If I use this :
{{$periode->pakan->sum('jumlah_masuk')}}
The result is "55"
What if I want sum('jumlah_masuk') but only value='s10' from ('Jenis_pakan')?
Laravel Sum by Value
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
分享- 邀请回答
-
1条回答 默认 最新
- donglang6656 2019-03-15 03:56关注
try the below query,
{{$periode->pakan->where('Jenis_pakan', 's10')->sum('jumlah_masuk')}}本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏举报 分享
- 2019-03-15 03:51回答 1 已采纳 try the below query, {{$periode->pakan->where('Jenis_pakan', 's10')->sum('jumlah_masuk')
- 2016-06-11 20:40回答 2 已采纳 You can wrap nullable fields into IFNULL() function, something like this: DB::raw('(IFNULL(sales.
- 2014-11-07 14:08回答 3 已采纳 I believe there is a function (its just not in the official docs) I found this in the source of L
- 2021-04-18 14:44辉煌与毁灭的博客 $users = DB::table('orders') ->select('department', DB::raw('SUM(price) as total_sales')) ->groupBy('department') ->havingRaw('SUM(price) > 2500') ->get(); skip 与 take $tasks = DB::table('tasks')->...
- 2017-05-26 08:27回答 2 已采纳 From your other question you said that there's only one user and it's an admin. In that case you c
- 2013-06-07 04:29回答 1 已采纳 Ended up switching to Laravel 4 and doing the ff which seemed to work. Order::leftJoin('deliverie
- 2017-07-22 06:09回答 3 已采纳 after validation you can write the code to store the data into table DB::table('Order_table')-&g
- 2022-01-11 17:16番茄蛋饭25块半的博客 $sql = BlindBox::selectRaw('any_value(id) as id, any_value(business_id) as business_id,project_id,SUM(access_count) as access_count,SUM(join_count) as join_count,SUM(share_count) as share_count')->...
- 2015-07-20 05:06回答 2 已采纳 I don't know about the table structure that you follow, But here's the Working Logic what you expe
- 2017-03-11 18:10回答 1 已采纳 i add this in my code if(!empty($value->jenis_perusahaan)) {} after foreach, thus it looks l
- 2018-08-07 17:11回答 1 已采纳 Try this.. public function passes($attribute, $value) { if(array_sum($value) < 1){
- 2021-03-23 17:17番茄蛋饭25块半的博客 select([DB::raw('DATE_FORMAT(starting_time,"%Y-%m-%d") as date'), DB::raw('COUNT(distinct(user_id)) as value')])->groupBy('date')->orderBy('date')->get() 按时间分组加去重 select([DB::raw('...
- 2017-10-04 11:25回答 2 已采纳 Try this Query does this help. $query = DB::table('users') ->join('products','products.auth
- 2021-04-27 08:42潘润琦的博客 Laravel 集合就像是在 PHP 中的数组，但会更好用。在这篇教程中，我们将会体验一些集合使用时的实用技巧。集合(Collection)Illuminate\Support\Collection类了提供一个便捷的操作数组的封装。集合 Collection 类实现...
- 2021-07-20 23:16与非学堂的博客 ## Laravel学习笔记汇总——Collection方法详解 本文参考：https:// laravel.com/docs/8.x/collections // 返回整个底层的数组 collect([1, 2, 3])->all(); // [1, 2, 3] // 返回平均数 $average = collect([1...
- 没有解决我的问题, 去提问
悬赏问题
- ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
- ¥15 java写代码遇到问题，求帮助
- ¥15 uniapp uview http 如何实现统一的请求异常信息提示？
- ¥15 有了解d3和topogram.js库的吗？有偿请教
- ¥100 任意维数的K均值聚类
- ¥15 stamps做sbas-insar，时序沉降图怎么画
- ¥15 买了个传感器，根据商家发的代码和步骤使用但是代码报错了不会改，有没有人可以看看
- ¥15 关于#Java#的问题，如何解决？
- ¥15 加热介质是液体，换热器壳侧导热系数和总的导热系数怎么算
- ¥100 嵌入式系统基于PIC16F882和热敏电阻的数字温度计