質問編集履歴
3
修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -106,7 +106,7 @@
|
|
106
106
|
|
107
107
|
// 結果を取得する
|
108
108
|
|
109
|
-
$
|
109
|
+
$aa = $this -> AA-> get($id, ['contain' => ['KbnMasters']]);
|
110
110
|
|
111
111
|
}
|
112
112
|
|
2
修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -4,7 +4,7 @@
|
|
4
4
|
|
5
5
|
そのため、belongsToを使用し、発行したSQLが別名となるようにしたい
|
6
6
|
|
7
|
-
現在発行されるSQLだと//
|
7
|
+
現在発行されるSQLだと//km_Aの箇所が上書きされて//km_Bの箇所のSQLのみが発行されてしまう
|
8
8
|
|
9
9
|
|
10
10
|
|
@@ -14,51 +14,33 @@
|
|
14
14
|
|
15
15
|
|
16
16
|
|
17
|
-
###テーブル構成
|
18
|
-
|
19
|
-
studios(店舗マスタ)
|
20
|
-
|
21
|
-
id|studio_nm|studio_kbn|apply_kbn
|
22
|
-
|
23
|
-
|
24
|
-
|
25
|
-
kbn_masters(区分マスタ)
|
26
|
-
|
27
|
-
id|subjectid|subject_name|kbnid|kbn_name
|
28
|
-
|
29
|
-
|
30
|
-
|
31
|
-
店舗マスタのstudio_kbnに対応する区分マスタはsubjectidが3のもので、apply_kbnに対応する区分マスタはsubjectidが4となります。
|
32
|
-
|
33
|
-
|
34
|
-
|
35
17
|
SQL取得イメージ
|
36
18
|
|
37
19
|
```sql
|
38
20
|
|
39
21
|
select
|
40
22
|
|
41
|
-
|
23
|
+
AA.*
|
42
24
|
|
43
|
-
, km_
|
25
|
+
, km_A.kbn_name
|
44
26
|
|
45
|
-
, km_
|
27
|
+
, km_B.kbn_name
|
46
28
|
|
47
29
|
from
|
48
30
|
|
49
|
-
|
31
|
+
AA
|
50
32
|
|
51
|
-
left outer join kbn_master km_
|
33
|
+
left outer join kbn_master km_A
|
52
34
|
|
53
|
-
on km_
|
35
|
+
on km_A.subject_id = 3
|
54
36
|
|
55
|
-
and km_
|
37
|
+
and km_A.kbn_id = AA.c_kbn
|
56
38
|
|
57
|
-
left outer join kbn_master km_
|
39
|
+
left outer join kbn_master km_B
|
58
40
|
|
59
|
-
on km_
|
41
|
+
on km_B.subject_id = 4
|
60
42
|
|
61
|
-
and km_
|
43
|
+
and km_B.kbn_id = AA.d_kbn
|
62
44
|
|
63
45
|
;
|
64
46
|
|
@@ -82,25 +64,25 @@
|
|
82
64
|
|
83
65
|
|
84
66
|
|
85
|
-
//
|
67
|
+
//km_A
|
86
68
|
|
87
69
|
$this -> belongsTo('KbnMasters', [
|
88
70
|
|
89
71
|
'bindingKey' => 'kbnid',
|
90
72
|
|
91
|
-
'foreignKey' => '
|
73
|
+
'foreignKey' => 'km_A',
|
92
74
|
|
93
75
|
'conditions'=>['subjectid' => '3' ],
|
94
76
|
|
95
77
|
'joinType' => 'LEFT']);
|
96
78
|
|
97
|
-
//
|
79
|
+
//km_B
|
98
80
|
|
99
81
|
$this -> belongsTo('KbnMasters', [
|
100
82
|
|
101
83
|
'bindingKey' => 'kbnid',
|
102
84
|
|
103
|
-
'foreignKey' => '
|
85
|
+
'foreignKey' => 'km_B',
|
104
86
|
|
105
87
|
'conditions'=>['subjectid' => '4' ],
|
106
88
|
|
1
初心者マークを追加
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|