如何在雄辩中别名列的名称 [英] How to alias the name of a column in Eloquent

问题描述

我有一个有说服力的模特，名为口才：

I have an eloquent model named Eloquent:

Products::where("actice", "=", true)->get()->toArray();

现在我要添加join-statement，我已经定义了一个scopeQuery：

Now I want to add join-statement to it, I have defined a scopeQuery with:

public function scopeJoinWithTags($query)
    {
        return $query->leftJoin("tags", "tags.id", "=", "products.tag_id");
    }

然后我们的主要查询更改为：

Then our main query changes to:

Products::where("actice", "=", true)->joinWithTags->get()->toArray();

我得到的是好的，这是我期望的，但我想更改名称属性的标签表到tag_name，该怎么做？我的意思是说，我在查询中的某个地方说：

What I get is OK, it is what I do expect, but I want to change the name property of tags table to tag_name, how should I do that? I mean, i say somewhere in my query to:

 tags.name AS tag_name

所以在最终结果数组中我做：

So that in the final result array I do :

$result[$i]['tag_name'];

现在我必须：

$result[$i]['name'];

推荐答案

最简单的方法是添加字段您需要使用 get（）方法，并将其重命名为别名。

Simplest way to do this would be to add the fields you need to the get() method and alias the ones you want to rename there.

Products::where("actice", "=", true)
    ->joinWithTags
    ->get(['tags.name AS tag_name', 'products.*'])
    ->toArray();

这篇关于如何在雄辩中别名列的名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！