mysql - 我不知道如何将此查询转换为 Eloquent 或 Fluent 查询生成器

Question

我使用 Laravel v5.1.4。我在网上搜索但找不到任何解决方案。我尝试了很多方法，但无法弄清楚如何将此查询转换为 Eloquent 或 Fluent Query Builder。这是使用 select 的工作查询。

DB::select("SELECT t1.id,t1.date1,t1.date2, t2.name as pick, t3.name as dest
        FROM reservations AS t1
        LEFT JOIN prices AS t2 ON t1.pick = t2.id
        LEFT JOIN prices AS t3 ON t1.dest = t3.id
        ORDER BY t2.name ASC
        ");

我想使用分页等 Eloquent 或 Fluent 功能。如果你帮我解决这个问题，我将不胜感激。

Answer 1

我已经解决了。希望对遇到同样问题的人有所帮助:)

DB::table('reservations')->join('prices as t1','reservations.pick',"=","t1.id")
                        ->join('prices as t2','reservations.dest',"=","t2.id")
                        ->select('reservations.id','t1.name as result1','t2.name as result2')->paginate(10);