二变量合一变量

Question

我有两个查询。

$createdServer = Server::where('created_at', '>=', \Carbon\Carbon::now()->subMonth())

    ->selectRaw('COUNT(id) as createserver, DATE(created_at) as date,DAY(created_at) as day')

    ->groupBy('day', 'date')

    ->orderBy('date', 'ASC')

    ->orderBy('day', 'ASC')

    ->get();

$deletedServer = Server::where('deleted_at', '>=', \Carbon\Carbon::now()->subMonth())

    ->selectRaw('COUNT(id) as deleteserver, DATE(deleted_at) as date,DAY(deleted_at) as day')

    ->groupBy('day', 'date')

    ->orderBy('date', 'ASC')

    ->orderBy('day', 'ASC')

    ->onlyTrashed()

    ->get();

输出为：

 "deletedServer": [

  {

   "deleteserver": 1,

   "date": "2019-04-29",

   "day": 29

  }

 ],

 "createdServer": [

  {

   "createserver": 2,

   "date": "2019-04-29",

   "day": 29

  }

 ],

我的要求是：

 "allServer": [

  {

   "deleteserver": 1,

   "createserver": 2,

   "date": "2019-04-29",

   "day": 29

  }

 ],

deleteServer和createServer对数据库中的数据进行计数。

Answer 1

merge函数可以解决您当前情况下的问题：链接$merged = $createdServer->merge($deletedServer); $merged->all();编辑：$merged = $createdServer[0]->merge($deletedServer[0]); $merged->all();

Answer 2

您可以使用以下代码进行检索：$allSevers = collect([            "deleteserver" => $deleteServer->count(), // retrieving the deleteServer count            "createserver" => $createServer->count(), // retrieving the createServer count            "date" => date('Y-m-d'), //date format in Year - Month - Date            "day" => date('j') // date format for mday        ]);