質問編集履歴
2
変更
test
CHANGED
File without changes
|
test
CHANGED
@@ -24,7 +24,7 @@
|
|
24
24
|
|
25
25
|
```
|
26
26
|
|
27
|
-
WHERE (CallNumbers.
|
27
|
+
WHERE (CallNumbers.A_id = :id ...
|
28
28
|
|
29
29
|
```
|
30
30
|
|
@@ -100,7 +100,7 @@
|
|
100
100
|
|
101
101
|
])
|
102
102
|
|
103
|
-
->where('CallNumbers.
|
103
|
+
->where('CallNumbers.A_id = :id', ['id' => $id])
|
104
104
|
|
105
105
|
-> select([
|
106
106
|
|
@@ -144,18 +144,6 @@
|
|
144
144
|
|
145
145
|
```
|
146
146
|
|
147
|
-
###テーブル構成に関して
|
148
|
-
|
149
|
-
call_numbers(電話番号マスタ)
|
150
|
-
|
151
|
-
id|studio_id|call_number_kbn|call_number
|
152
|
-
|
153
|
-
|
154
|
-
|
155
|
-
kbn_masters(区分マスタ)
|
156
|
-
|
157
|
-
id|subjectid|subject_name|kbnid|kbn_name
|
158
|
-
|
159
147
|
|
160
148
|
|
161
149
|
電話番号マスタのcall_number_kbnに対応する区分マスタはsubjectidが2のものとなります。
|
@@ -168,7 +156,7 @@
|
|
168
156
|
|
169
157
|
select
|
170
158
|
|
171
|
-
call_numbers.
|
159
|
+
call_numbers.A_id
|
172
160
|
|
173
161
|
, kbn_masters.kbn_name
|
174
162
|
|
@@ -186,7 +174,7 @@
|
|
186
174
|
|
187
175
|
where
|
188
176
|
|
189
|
-
call_numbers.
|
177
|
+
call_numbers.A_id = /*id*/;
|
190
178
|
|
191
179
|
```
|
192
180
|
|
1
題名にcakephp3 と入力。
test
CHANGED
@@ -1 +1 @@
|
|
1
|
-
JOINした情報を画面に出力したい
|
1
|
+
cakephp3 JOINした情報を画面に出力したい
|
test
CHANGED
File without changes
|