Last modified by Александр Молчин on 2025/05/07 12:49
From version 11.1
edited by Александр Молчин
on 2025/05/07 12:35
To version 12.1
edited by Александр Молчин
on 2025/05/07 12:49
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -70,35 +70,35 @@
70 70  
71 71  **LEFT** **JOIN** product_group //pg//
72 72  
73 - **ON** //p//.group_id = //pg//.id
73 + **ON** //p//.group_id = //pg//.id
74 74  
75 75  **LEFT** **JOIN** brands //b//
76 76  
77 - **ON** //pg//.brand_id = //b//.id
77 + **ON** //pg//.brand_id = //b//.id
78 78  
79 79  **LEFT** **JOIN** product_oem //po//
80 80  
81 - **ON** //p//.id = //po//.product_id
81 + **ON** //p//.id = //po//.product_id
82 82  
83 83  **LEFT** **JOIN** oem_codes //oc//
84 84  
85 - **ON** //po//.oem_id = //oc//.id
85 + **ON** //po//.oem_id = //oc//.id
86 86  
87 87  **LEFT** **JOIN** oem_mark //om//
88 88  
89 - **ON** //oc//.oemmarkId = //om//.id
89 + **ON** //oc//.oemmarkId = //om//.id
90 90  
91 91  **WHERE** 1 = 1
92 92  
93 - **AND** oc.code **IS** **NOT** **NULL**
93 + **AND** oc.code **IS** **NOT** **NULL**
94 94  
95 - **AND** om.name **IS** **NOT** **NULL**
95 + **AND** om.name **IS** **NOT** **NULL**
96 96  
97 - **AND** om.tecdocId **IS** **NOT** **NULL**
97 + **AND** om.tecdocId **IS** **NOT** **NULL**
98 98  
99 - **AND** p.status_id **in** (4, 5)
99 + **AND** p.status_id **in** (4, 5)
100 100  
101 - **AND** b.id **IN** (1, 2, 3, 4, 5)
101 + **AND** b.id **IN** (1, 2, 3, 4, 5)
102 102  
103 103   ~-~-AND oc.code NOT LIKE '%[а-я]%'
104 104  
... ... @@ -108,7 +108,7 @@
108 108  
109 109  **SELECT**
110 110  
111 - //b//.name **AS** 'Бренд'
111 + //b//.name **AS** 'Бренд'
112 112  
113 113   ,//p//.code **AS** Артикул
114 114  
... ... @@ -122,35 +122,35 @@
122 122  
123 123  **LEFT** **JOIN** product_group //pg//
124 124  
125 - **ON** //p//.group_id = //pg//.id
125 + **ON** //p//.group_id = //pg//.id
126 126  
127 127  **LEFT** **JOIN** brands //b//
128 128  
129 - **ON** //pg//.brand_id = //b//.id
129 + **ON** //pg//.brand_id = //b//.id
130 130  
131 131  **LEFT** **JOIN** product_codes //pc//
132 132  
133 - **ON** //p//.id = //pc//.product_id
133 + **ON** //p//.id = //pc//.product_id
134 134  
135 135  **LEFT** **JOIN** codes //c//
136 136  
137 - **ON** //pc//.code_id = //c//.id
137 + **ON** //pc//.code_id = //c//.id
138 138  
139 139  **LEFT** **JOIN** oem_mark //om//
140 140  
141 - **ON** //pc//.oem_mark_id = //om//.id
141 + **ON** //pc//.oem_mark_id = //om//.id
142 142  
143 143  **WHERE** 1 = 1
144 144  
145 - **AND** //c//.code **IS** **NOT** **NULL**
145 + **AND** //c//.code **IS** **NOT** **NULL**
146 146  
147 - **AND** //om//.name **IS** **NOT** **NULL**
147 + **AND** //om//.name **IS** **NOT** **NULL**
148 148  
149 - **AND** //om//.tecdocId **IS** **NOT** **NULL**
149 + **AND** //om//.tecdocId **IS** **NOT** **NULL**
150 150  
151 - **AND** //p//.status_id **IN** (4, 5)
151 + **AND** //p//.status_id **IN** (4, 5)
152 152  
153 - **AND** //b//.id **IN** (1, 2, 3, 4, 5)
153 + **AND** //b//.id **IN** (1, 2, 3, 4, 5)
154 154  
155 155   ~-~-AND c.code NOT LIKE '%[а-я]%'
156 156  
... ... @@ -172,7 +172,7 @@
172 172  
173 173  **SELECT**
174 174  
175 - //br//.name **AS** 'Бренд'
175 + //br//.name **AS** 'Бренд'
176 176  
177 177   ,//p//.code **AS** 'Артикул'
178 178  
... ... @@ -186,37 +186,37 @@
186 186  
187 187  **LEFT** **JOIN** ausage //au//
188 188  
189 - **ON** //p//.id = //au//.product_id
189 + **ON** //p//.id = //au//.product_id
190 190  
191 191  **LEFT** **JOIN** amodification //am//
192 192  
193 - **ON** //au//.modification_id = //am//.id
193 + **ON** //au//.modification_id = //am//.id
194 194  
195 195  **LEFT** **JOIN** product_group //pg//
196 196  
197 - **ON** //p//.group_id = //pg//.id
197 + **ON** //p//.group_id = //pg//.id
198 198  
199 199  **LEFT** **JOIN** brands //br//
200 200  
201 - **ON** //pg//.brand_id = //br//.id
201 + **ON** //pg//.brand_id = //br//.id
202 202  
203 203  **WHERE** 1 = 1
204 204  
205 - **AND** (//p//.status_id = 4 **OR** //p//.status_id = 5)
205 + **AND** (//p//.status_id = 4 **OR** //p//.status_id = 5)
206 206  
207 207   ~-~-AND p.code = 'AG 15024'
208 208  
209 - **AND** //am//.lnktargettypeID **IS** **NOT** **null**
209 + **AND** //am//.lnktargettypeID **IS** **NOT** **null**
210 210  
211 - **AND** //br//.id **IN** (1, 2, 3, 4, 5)
211 + **AND** //br//.id **IN** (1, 2, 3, 4, 5)
212 212  
213 - **AND** //br//.id = 2
213 + **AND** //br//.id = 2
214 214  
215 215  **ORDER** **BY**
216 216  
217 - //br//.name,
217 + //br//.name,
218 218  
219 - //p//.code
219 + //p//.code
220 220  
221 221  
222 222  В полученной выгрузке добавляем столбец с условием:
... ... @@ -237,7 +237,6 @@
237 237  |Двигатели (Engines)|14
238 238  
239 239  
240 -
241 241  = **Загрузка фотографий в TecDoc** =
242 242  
243 243