作者:银仔-zxy | 来源:互联网 | 2023-05-17 15:15
Ihavetwocolumns,quarter_numberandquarter_year.Thequarter_numbercolumnstoresavaluebetwee
I have two columns, quarter_number and quarter_year. The quarter_number column stores a value between 1 and 4, while quarter_year stores a year value. I want the data to be sorted like so for example:
我有两列,quarter_number和quarter_year。 quarter_number列存储1到4之间的值,而quarter_year存储年份值。我想要对数据进行排序,例如:
ex: (quarter_number - quarter_year)
4 - 2015
3 - 2015
2 - 2015
1 - 2015
4 - 2014
3 - 2014
etc...
Thus it seemed like this statement would work:
因此,这句话似乎有效:
$last_figures = QuarterData::where('company_id', '=', $company->id) ->orderBy('quarter_number')->orderBy('quarter_year')->get();
$ last_figures = QuarterData :: where('company_id','=',$ company-> id) - > orderBy('quarter_number') - > orderBy('quarter_year') - > get();
Unfortunately, it doesn't seem to work as intended (which I thought would be similar to a radix sort). It ends up just sorting by the year (or whatever to last orderBy statement is). Do I have to just program my own custom radix sort for this? Or is there a better way?
不幸的是,它似乎没有按预期工作(我认为它类似于基数排序)。它最终只是按年份排序(或者最后的orderBy语句是什么)。我是否必须为此编制自己的自定义基数排序?或者,还有更好的方法?
Thank you.
1 个解决方案