Question

我有一个表<代码>Quotes,与QuoteDetails表有着一对一的关系。

表格结构如下:

return $this->quotes->with( quotedetails )
    ->orderBy( created_at ,  DESC )->paginate(10);

成果:

{
   "current_page":1,
   "data":[
      {
         "id":2,
         "subject":"demo",
         "quotedetails":[
            {
               "id":2,
               "quotes_id":2,
               "description":"testing data",
               "total":1080
            },
            {
               "id":3,
               "quotes_id":2,
               "description":"testing",
               "total":180
            }
         ]
      },
      {
         "id":1,
         "subject":"demo",
         "quotedetails":[
            {
               "id":1,
               "quotes_id":1,
               "description":"data",
               "total":360
            }
         ]
      }
   ],
   "per_page":10,
   "prev_page_url":null,
   "to":2,
   "total":2
}

我想列入<代码>引述细节>的总和<代码>。页: 1 我不肯定应该如何做到这一点。

在这方面,我是如何在我的模型(Quotes)中查询的。

public function quotedetails(){
        return $this->hasMany( AppModelsQuotesDetail ,  quotes_id ,  id );
    }

如何获得<代码>总。

www.un.org/Depts/DGACM/index_spanish.htm 这里是预期产出()的方法。

{
   "current_page":1,
   "data":[
      {
         "id":2,
         "subject":"demo link data",
         "quotesum": 1260
      },
      {
         "id":1,
         "subject":"demo",
         "quotesum": 360
      }
   ],
   "per_page":10,
   "prev_page_url":null,
   "to":2,
   "total":2
}

Answer 1

$query->withCount([
 quotedetail AS quotesum  => function ($query) {
            $query->select(DB::raw("SUM(total) as quotesum"));
        }
    ]);

Answer 2

我的理解是,你希望通过询问这样做,但是,如果不问你,你就能够以这种方式改变稀有数据,举以下例子:

$quotes = Quotes::whereNotNull( id )->with( quotedetails )
    ->orderBy( created_at ,  DESC )->paginate();

//transform the data in the Paginate instance
$quotes->getCollection()->transform(function($quote){
     $quote->quotesum = $quote->quotedetails->sum( total );
     unset($quote[ quotedetails ]);
     return $quote;
});

p化结果中的数据已经改变,而且你也要求这样做。

<>Pro: 在不增加任何疑问的情况下,有更多的机会与你的答复做更多的工作。

<><>Con: 因此,更多的数据意味着在收集方面开展更多的工作,特别是在数据大的情况下。

Answer 3

Hi you use eloquent itself to archive this. You can use with sum method to calculate the sum of total column from quotedetails table $ideas = Quotes::withSum( quotedetails , total )->with( quotedetails )->all();

友情链接