質問編集履歴
3
文法の修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -120,33 +120,27 @@
|
|
|
120
120
|
```
|
|
121
121
|
**検索結果取得コード**
|
|
122
122
|
```PHP
|
|
123
|
-
$query = MItemSplit::
|
|
124
|
-
->leftJoin('m_item_split_detail', 'm_item_split.item_id', '=', 'm_item_split_detail.item_split_id')
|
|
125
|
-
->select('m_item_split.*', 'sm_items.id as item_class_id', 'sm_items.code as item_code', 'sm_items.name as item_name')
|
|
126
|
-
->addSelect('sm_items.created_at as item_created_at', 'sm_items.created_user as item_created_user', 'sm_items.updated_at as item_updated_at', 'sm_items.updated_user as item_updated_user')
|
|
127
|
-
->addSelect('m_item_split_detail.id as split_detail_id', 'm_item_split_detail.item_split_id as split_detail_item_split_id', 'm_item_split_detail.no as split_detail_no', 'm_item_split_detail.sub_item_id as split_detail_sub_item_id', 'm_item_split_detail.split_price as split_detail_split_price')
|
|
128
|
-
->addSelect('m_item_split_detail.created_at as split_detail_created_at', 'm_item_split_detail.created_user as split_detail_created_user', 'm_item_split_detail.updated_at as split_detail_updated_at', 'm_item_split_detail.updated_user as split_detail_updated_user')
|
|
129
|
-
->get();
|
|
123
|
+
$query = MItemSplit::get();
|
|
130
124
|
|
|
131
|
-
$query = $query->map(function ($getQuery) {
|
|
125
|
+
$query = $query->map(function ($getQuery) {
|
|
132
126
|
$query = [
|
|
133
127
|
"id" => $getQuery->id,
|
|
134
128
|
"item_id" => $getQuery->item_id,
|
|
135
129
|
"item" => array(
|
|
136
|
-
"id" => $getQuery->item
|
|
130
|
+
"id" => $getQuery->item->id,
|
|
137
|
-
"code" => $getQuery->item
|
|
131
|
+
"code" => $getQuery->item->code,
|
|
138
|
-
"name" => $getQuery->item
|
|
132
|
+
"name" => $getQuery->item->name,
|
|
139
133
|
),
|
|
140
134
|
"item_split_detail" => array(
|
|
141
|
-
"id" => $getQuery->split
|
|
135
|
+
"id" => $getQuery->splitDetail->id,
|
|
142
|
-
"item_split_id" => $getQuery->split
|
|
136
|
+
"item_split_id" => $getQuery->splitDetail->item_split_id,
|
|
143
|
-
"no" => $getQuery->split
|
|
137
|
+
"no" => $getQuery->splitDetail->no,
|
|
144
|
-
"sub_item_id" => $getQuery->split
|
|
138
|
+
"sub_item_id" => $getQuery->splitDetail->sub_item_id,
|
|
145
|
-
"split_price" => $getQuery->split
|
|
139
|
+
"split_price" => $getQuery->splitDetail->split_price,
|
|
146
|
-
"created_at" => $getQuery->split
|
|
140
|
+
"created_at" => $getQuery->splitDetail->created_at,
|
|
147
|
-
"created_user" => $getQuery->split
|
|
141
|
+
"created_user" => $getQuery->splitDetail->created_user,
|
|
148
|
-
"updated_at" => $getQuery->split
|
|
142
|
+
"updated_at" => $getQuery->splitDetail->updated_at,
|
|
149
|
-
"updated_user" => $getQuery->split
|
|
143
|
+
"updated_user" => $getQuery->splitDetail->updated_user,
|
|
150
144
|
),
|
|
151
145
|
"created_at" => $getQuery->created_at,
|
|
152
146
|
"created_user" => $getQuery->created_user,
|
|
@@ -155,6 +149,7 @@
|
|
|
155
149
|
];
|
|
156
150
|
return $query;
|
|
157
151
|
});
|
|
152
|
+
return $query;
|
|
158
153
|
```
|
|
159
154
|
|
|
160
155
|
### 試したこと
|
2
文法の修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -107,7 +107,18 @@
|
|
|
107
107
|
```
|
|
108
108
|
|
|
109
109
|
### 該当のソースコード
|
|
110
|
+
**リレーションメソッド**
|
|
111
|
+
```ここに言語を入力
|
|
112
|
+
public function item()
|
|
113
|
+
{
|
|
114
|
+
return $this->belongsTo(SMItem::class, 'item_id')->withDefault();
|
|
115
|
+
}
|
|
110
|
-
|
|
116
|
+
public function splitDetail()
|
|
117
|
+
{
|
|
118
|
+
return $this->belongsTo(MItemSplitDetail::class, 'item_id')->withDefault();
|
|
119
|
+
}
|
|
120
|
+
```
|
|
121
|
+
**検索結果取得コード**
|
|
111
122
|
```PHP
|
|
112
123
|
$query = MItemSplit::leftJoin('sm_items', 'm_item_split.item_id', '=', 'sm_items.id')
|
|
113
124
|
->leftJoin('m_item_split_detail', 'm_item_split.item_id', '=', 'm_item_split_detail.item_split_id')
|
1
文法の修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -109,6 +109,14 @@
|
|
|
109
109
|
### 該当のソースコード
|
|
110
110
|
$queryにはSQLで取得したデータが入っています。
|
|
111
111
|
```PHP
|
|
112
|
+
$query = MItemSplit::leftJoin('sm_items', 'm_item_split.item_id', '=', 'sm_items.id')
|
|
113
|
+
->leftJoin('m_item_split_detail', 'm_item_split.item_id', '=', 'm_item_split_detail.item_split_id')
|
|
114
|
+
->select('m_item_split.*', 'sm_items.id as item_class_id', 'sm_items.code as item_code', 'sm_items.name as item_name')
|
|
115
|
+
->addSelect('sm_items.created_at as item_created_at', 'sm_items.created_user as item_created_user', 'sm_items.updated_at as item_updated_at', 'sm_items.updated_user as item_updated_user')
|
|
116
|
+
->addSelect('m_item_split_detail.id as split_detail_id', 'm_item_split_detail.item_split_id as split_detail_item_split_id', 'm_item_split_detail.no as split_detail_no', 'm_item_split_detail.sub_item_id as split_detail_sub_item_id', 'm_item_split_detail.split_price as split_detail_split_price')
|
|
117
|
+
->addSelect('m_item_split_detail.created_at as split_detail_created_at', 'm_item_split_detail.created_user as split_detail_created_user', 'm_item_split_detail.updated_at as split_detail_updated_at', 'm_item_split_detail.updated_user as split_detail_updated_user')
|
|
118
|
+
->get();
|
|
119
|
+
|
|
112
120
|
$query = $query->map(function ($getQuery) {
|
|
113
121
|
$query = [
|
|
114
122
|
"id" => $getQuery->id,
|