请教,从两张表分别取出数据,然后组合后按日期分组输出,这个怎么写啊?
laravel后端从两张表分别取出数据,然后组合后按日期分组输出,这个怎么写啊?
表1:notes取出来的数是
array:2 [
0 => {#337
+"id": 1
+"title": "房贷还款"
+"date": "2021-09-18"
+"content": "房贷8688元还款"
}
1 => {#327
+"id": 2
+"title": "购车材料"
+"date": "2021-09-19"
+"content": "购车材料提交截止时间"
}
]
表2:other
array:2 [ `0 => {#333 `+"id": 1
+"name": "交割"
+"title": "黄金期货交割"
+"date": "2021-09-18"
+"content": "第五期黄金期货交割日"
}
1 => {#332 `+"id": 2
+"name": "打新"
+"title": "两只新股打新"
+"date": "2021-09-19"
+"content": "大盘新股打新时间"
} ]
如何组合成按日期分组的数组输出,像如下样式:
'2021-09-18' => [
'notes => [
'id' => '1',
'title' => '部门会议',
'content' => '下午四点开部门会议',
],
'other' => [
'list' => [
[ 'id' => '1',
'name' =>'交割',
'title' => '黄金期货交割',
'content' => '第五期黄金期货交割日',
],
]
]
],
'2021-09-19' => [
'notes' => [
'id' => '2',
'title' => '团队聚会',
'content' => '中秋节搞团聚',
],
'other' => [
'list' => [
[ 'id' => '2',
'name' =>'打新',
'title' => '两只新股打新',
'content' => '大盘新股打新时间',
],
]
]
]
```
推荐文章: