将复杂的查询转换为Laravel的口才 [英] Converting a complicated query to Laravel's Eloquent

问题描述

我想知道如何将查询转换为Laravel?

I was wondering how I would go about converting this query to Laravel?

SELECT * FROM users INNER JOIN srp_user_statistics ON users.id = srp_user_statistics.user_id ORDER BY srp_user_statistics.payslips_collected DESC LIMIT 2

用户"表位于名为Player的模式中，而srp_user_statistics表位于名为Roleplay的模式中，该模式是称为"roleplay"的模式Player的关系

"users" table is in a modal called Player and the srp_user_statistics table is in a modal called Roleplay which is a relationship of modal Player called "roleplay"

我尝试过，但是即使选择ASC，它也会返回DESC:

I tried this, but its returning DESC even when selecting ASC:

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

推荐答案

使用Larvel查询生成器:

using Larvel Query Builder:

$record = DB::table('users')
->innerJoin('srp_user_statistics', 'users.id', '=', 'srp_user_statistics.user_id')
->orderBy('payslips_collected', 'DESC')
->limit(2)
->get();

这篇关于将复杂的查询转换为Laravel的口才的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！