Laravel：OrderBy不工作？

I am trying to get all of the records in modal Roleplay order by the payslips_collected ASC (ascending).

Ascending is meant to start at the lowest value and go up. I am not getting that... here is my result of a table I made.

+----+------------------+--------+-------------+-----------------+-----------------+--------------+-----------+
| ID |    Username      | Shifts |  Completed  |  Registered     | Website Login   | Client Login | Last Seen |
+----+------------------+--------+-------------+-----------------+-----------------+--------------+-----------+
| 1  |  Danny Fure      |   29   | 1 year ago  |  43 minutes ago | 43 minutes ago  | 1 second ago |           |
| 2  |  James Mack      |   0    | 1 year ago  |  1 second ago   | 2 days ago      | 1 second ago |           |
| 3  |  Peter Barlow    |   0    | 1 year ago  |  1 second ago   | 2 days ago      | 1 second ago |           |
| 4  |  Adam Chapman    |   0    | 1 year ago  |  1 second ago   | 2 days ago      | 1 second ago |           |
| 5  |  Danny Burrows   |   0    | 1 year ago  |  1 second ago   | 2 days ago      | 1 second ago |           |
| 6  |  Kieran Root     |   0    | 1 year ago  |  1 second ago   | 2 days ago      | 1 second ago |           |
| 8  |  Ashton David    |   0    | 1 year ago  |  1 second ago   | 2 days ago      | 1 second ago |           |
| 9  |  Someone Special |   0    | 1 year ago  |  1 second ago   | 2 days ago      | 1 second ago |           |
| 10 |  Kelly Clark     |   0    | 1 year ago  |  1 second ago   | 2 days ago      | 1 second ago |           |
| 11 |  Abbie Grove     |   0    | 1 year ago  |  1 second ago   | 2 days ago      | 1 second ago |           |
+----+------------------+--------+-------------+-----------------+-----------------+--------------+-----------+

I'm sorry its a bit messed up, it didn't format correctly. But anyway, the main issue is its showing in DESC order, (descending) showing the highest before the lowest.

Can anyone tell me why its doing this?

Raw Query:

select * from `users` where exists (select * from `srp_user_statistics` where `users`.`id` = `srp_user_statistics`.`user_id` order by `payslips_collected` asc)

Code:

$players = Player::whereHas('roleplay', function ($query) use($orderType) {
    $query->orderBy('payslips_collected', $orderType);
});

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

4条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
douxu3732 2017-08-02 11:11
关注
Try this

$players = Player::has('roleplay') ->orderBy('payslips_collected', $orderType) // ...
解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

报告相同问题？

关注问题

Laravel：orderBy喜欢count html laravel php
2018-04-23 20:39

回答 1 已采纳 Use this: $posts = Post::withCount('likes')->orderByDesc('likes_count')->get(); This requ
Laravel Eloquent：hasManyThrough还是其他什么？ laravel php
2018-12-03 16:04

回答 3 已采纳 Thank you Nick Surmanidze and Namoshek for your answers! I have found the way it works last night:
Laravel DB :: table AND语句？ database laravel php
2015-02-12 15:01

回答 2 已采纳 Just adding another ->where behind another ->where is the way to get another where statement
php的orderby,php – Laravel默认orderBy
2021-04-12 19:00

刘嘉耿的博客它可以通过扩展Laravel的QueryBuilder来工作，但是要做到这一点，你必须重新布线其中的一些核心功能 – 糟糕的做法。原因这样做的主要目的是 – 我的一个模型得到许多其他人的重视，现在你必须一再诉诸。即使为此...
Laravel 4：如何显示SQL查询？ laravel php
2014-06-21 07:05

回答 1 已采纳 A popular method is to monitor the Event for Eloquent, and output any queries run on the database
Laravel多个orderBy来自动态数组输入 laravel php
2015-01-16 21:57

回答 1 已采纳 Yes, you can add stuff to your query object after creating it like this: <?php $query = DB::ta
Laravel 5.6 inRandomOrder和OrderBy laravel php
2018-03-23 03:50

回答 1 已采纳 How about you get them all with 1 call and sort them with PHP using collection splice method: $al
orderby在php中,laravel框架的orderBy问题
2021-04-21 04:49

fortofor的博客 laravel的 orderBy('a','desc')，我如果还想在a一样的情况下，同时根据b降序排序要怎么写回复讨论(解决方案)orderBy 方法(Builder.php)被写作public function orderBy($column, $direction = 'asc'){$this->...
Laravel 5中的子关系？ laravel php
2018-07-26 23:14

回答 1 已采纳 Use HasManyThrough: public function payments() { return $this->hasManyThrough(Payment::cla
Laravel：如何在控制器的几种方法中重用代码片段 laravel php
2018-08-29 17:30

回答 3 已采纳 You could put them in a separate method in your class that just returns the data as an array and t
Laravel：分页只返回第一块 laravel php
2017-06-22 20:52

回答 1 已采纳 Its because the query params are not appended to the subsequent pagination requests. Update your
php orderby 倒叙,php – Laravel OrderBy关系计数与分页
2021-03-24 08:38

delawarearthur的博客我有很多项目,每个都有很多订单,有些是完成的,有些则没有....orderBy(function($product) {return $product->orders->where('status', 2)->count();})->paginate(15);我知道订单调用不能像这样工作,...
方法orderBy不存在 - laravel laravel php
2017-10-02 19:09

回答 3 已采纳 Try this: return ProposalModel::where('user_id', '=', $userId)->orderBy('user_id', 'desc')-&gt
laravel Orderby排序
2020-07-23 16:27

陀螺仪　的博客 laravel正序为0字段排最后面 USER::OrderByRaw('is_zhi_num=0,is_zhi_num')->get();
Laravel框架03：DB类操作数据库
2023-02-26 18:25

iFulling的博客 Laravel框架03：DB类操作数据库一、概述二、数据表的创建与配置三、增删改操作 1. 增加信息 2. 修改数据 3. 删除数据四、查询操作 1. 取出基本数据 2. 取出单行数据 3. 获取一个字段的值 4. 获取多个字段的值 5....
没有解决我的问题, 去提问

悬赏问题

¥20 软件测试决策法疑问求解答
¥15 win11 23H2删除推荐的项目，支持注册表等
¥15 matlab 用yalmip搭建模型，cplex求解，线性化处理的方法
¥15 qt6.6.3 基于百度云的语音识别不会改
¥15 关于#目标检测#的问题：大概就是类似后台自动检测某下架商品的库存，在他监测到该商品上架并且可以购买的瞬间点击立即购买下单
¥15 神经网络怎么把隐含层变量融合到损失函数中？
¥15 lingo18勾选global solver求解使用的算法
¥15 全部备份安卓app数据包括密码，可以复制到另一手机上运行
¥20 测距传感器数据手册i2c
¥15 RPA正常跑，cmd输入cookies跑不出来

Laravel：OrderBy不工作？

4条回答 默认 最新

悬赏问题

4条回答默认最新