l-44 ol-44"> 44 
+                ('MC15', models.CharField(max_length=255, null=True)),
45 
+                ('MC16', models.CharField(max_length=255, null=True)),
46 
+                ('MC19', models.CharField(max_length=255, null=True)),
47 
+                ('MC20', models.CharField(max_length=255, null=True)),
48 
+                ('MC21', models.CharField(max_length=255, null=True)),
49 
+                ('MC22', models.CharField(max_length=255, null=True)),
50 
+                ('MC23', models.CharField(max_length=255, null=True)),
51 
+                ('MC24', models.CharField(max_length=255, null=True)),
52 
+                ('MP34', models.CharField(max_length=255, null=True)),
53 
+                ('MP39', models.CharField(max_length=255, null=True)),
54 
+                ('MI13', models.CharField(max_length=255, null=True)),
55 
+                ('TC', models.CharField(max_length=255, null=True)),
56 
+                ('MI14', models.CharField(max_length=255, null=True)),
57 
+                ('MI15', models.CharField(max_length=255, null=True)),
58 
+                ('MI16', models.CharField(max_length=255, null=True)),
59 
+                ('MI17', models.CharField(max_length=255, null=True)),
60 
+                ('MI18', models.CharField(max_length=255, null=True)),
61 
+                ('MI19', models.CharField(max_length=255, null=True)),
62 
+                ('MI20', models.CharField(max_length=255, null=True)),
63 
+                ('MI21', models.CharField(max_length=255, null=True)),
64 
+                ('MI22', models.CharField(max_length=255, null=True)),
65 
+                ('MI23', models.CharField(max_length=255, null=True)),
66 
+                ('MI31', models.CharField(max_length=255, null=True)),
67 
+                ('MI33', models.CharField(max_length=255, null=True)),
68 
+                ('INSAGM', models.CharField(max_length=255, null=True)),
69 
+                ('MARAGM', models.CharField(max_length=255, null=True)),
70 
+                ('MI53', models.CharField(max_length=255, null=True)),
71 
+                ('MI55', models.CharField(max_length=255, null=True)),
72 
+                ('MI36', models.CharField(max_length=255, null=True)),
73 
+                ('MI39', models.CharField(max_length=255, null=True)),
74 
+                ('MI24', models.CharField(max_length=255, null=True)),
75 
+                ('Ind1', models.CharField(max_length=255, null=True)),
76 
+                ('Ind2', models.CharField(max_length=255, null=True)),
77 
+                ('Ind3', models.CharField(max_length=255, null=True)),
78 
+                ('AGR1', models.CharField(max_length=255, null=True)),
79 
+                ('AGR2', models.CharField(max_length=255, null=True)),
80 
+                ('ob_Condition', models.CharField(max_length=255, null=True)),
81 
+            ],
82 
+        ),
83 
+    ]

+ 416 - 0
app/core/models.py
View File 

@@ -15,3 +15,419 @@ class Report(models.Model):
15 15
16 16 
     def __str__(self):
17 17 
         return self.name
18 
+
19 
+
20 
+class MgMasterView(models.Model):
21 
+    # ProcessControl.dbo.[Q-PRO-DATA]
22 
+    PRO0 = models.CharField(max_length=255, null=True)
23 
+    PRO1 = models.CharField(max_length=255, null=True)
24 
+    PRO1C = models.CharField(max_length=255, null=True)
25 
+    PRO2 = models.CharField(max_length=255, null=True)
26 
+    PRO5 = models.CharField(max_length=255, null=True)
27 
+    PRO8 = models.CharField(max_length=255, null=True)
28 
+    PRO9 = models.CharField(max_length=255, null=True)
29 
+    PRO10 = models.CharField(max_length=255, null=True)
30 
+    PRO11 = models.CharField(max_length=255, null=True)
31 
+    PRO12 = models.CharField(max_length=255, null=True)
32 
+    PRO13 = models.CharField(max_length=255, null=True)
33 
+    PRO14 = models.CharField(max_length=255, null=True)
34 
+    PRO15 = models.CharField(max_length=255, null=True)
35 
+    PRO16 = models.CharField(max_length=255, null=True)
36 
+    PRO17 = models.CharField(max_length=255, null=True)
37 
+    PRO18 = models.CharField(max_length=255, null=True)
38 
+    PRO21 = models.CharField(max_length=255, null=True)
39 
+    PRO25 = models.CharField(max_length=255, null=True)
40 
+    PRO27 = models.CharField(max_length=255, null=True)
41 
+    P2 = models.CharField(max_length=255, null=True)  # PRO-P2
42 
+    SPEED = models.CharField(max_length=255, null=True)  # PRO-SPEED
43 
+    PRO_TOOL = models.CharField(max_length=255, null=True)  # PRO-TOOL
44 
+    PRO4 = models.CharField(max_length=255, null=True)
45 
+
46 
+    # dbo.[MG-MAS-1]
47 
+    MC11 = models.CharField(max_length=255, null=True)
48 
+    MC12 = models.CharField(max_length=255, null=True)
49 
+    MC14 = models.CharField(max_length=255, null=True)
50 
+    MC15 = models.CharField(max_length=255, null=True)
51 
+    MC16 = models.CharField(max_length=255, null=True)
52 
+    MC19 = models.CharField(max_length=255, null=True)
53 
+    MC20 = models.CharField(max_length=255, null=True)
54 
+    MC21 = models.CharField(max_length=255, null=True)
55 
+    MC22 = models.CharField(max_length=255, null=True)
56 
+    MC23 = models.CharField(max_length=255, null=True)
57 
+    MC24 = models.CharField(max_length=255, null=True)
58 
+
59 
+    # dbo.[MG-MAS-2]
60 
+    MP45 = models.CharField(max_length=255, null=True)
61 
+    MP49 = models.CharField(max_length=255, null=True)
62 
+
63 
+    # dbo.[MG-MAS-3]
64 
+    MI13 = models.CharField(max_length=255, null=True)
65 
+    TC = models.CharField(max_length=255, null=True)
66 
+    MI14 = models.CharField(max_length=255, null=True)
67 
+    MI15 = models.CharField(max_length=255, null=True)
68 
+    MI16 = models.CharField(max_length=255, null=True)
69 
+    MI17 = models.CharField(max_length=255, null=True)
70 
+    MI18 = models.CharField(max_length=255, null=True)
71 
+    MI19 = models.CharField(max_length=255, null=True)
72 
+    MI20 = models.CharField(max_length=255, null=True)
73 
+    MI21 = models.CharField(max_length=255, null=True)
74 
+    MI22 = models.CharField(max_length=255, null=True)
75 
+    MI23 = models.CharField(max_length=255, null=True)
76 
+    MI31 = models.CharField(max_length=255, null=True)
77 
+    MI33 = models.CharField(max_length=255, null=True)
78 
+    INSAGM = models.CharField(max_length=255, null=True)
79 
+    MARAGM = models.CharField(max_length=255, null=True)
80 
+    MI53 = models.CharField(max_length=255, null=True)
81 
+    MI55 = models.CharField(max_length=255, null=True)
82 
+    MI36 = models.CharField(max_length=255, null=True)
83 
+    MI39 = models.CharField(max_length=255, null=True)
84 
+    MI24 = models.CharField(max_length=255, null=True)
85 
+
86 
+    # MGT_Config.dbo.[TABLE_TI-T1], [TABLE_TI-T5], [TABLE_TI-T6]
87 
+    Ind1 = models.CharField(max_length=255, null=True)  # TIT1NE
88 
+    Ind2 = models.CharField(max_length=255, null=True)  # TIT5NE
89 
+    Ind3 = models.CharField(max_length=255, null=True)  # TIT6NE
90 
+
91 
+    # Conditional Fields
92 
+    AGR1 = models.CharField(max_length=255, null=True)
93 
+    AGR2 = models.CharField(max_length=255, null=True)
94 
+    ob_Condition = models.CharField(max_length=255, null=True)  # TIT4NE
95 
+
96 
+    class Meta:
97 
+        managed = False
98 
+        db_table = 'MgMasterView_Full_Mockup_Data'
99 
+
100 
+class VMasterView(models.Model):
101 
+    # Fields from ProcessControl.dbo.[Q-PRO-DATA]
102 
+    PRO0 = models.CharField(max_length=255, null=True)
103 
+    PRO1 = models.CharField(max_length=255, null=True)
104 
+    PRO1C = models.CharField(max_length=255, null=True)
105 
+    PRO2 = models.CharField(max_length=255, null=True)
106 
+    PRO5 = models.CharField(max_length=255, null=True)
107 
+    PRO8 = models.CharField(max_length=255, null=True)
108 
+    PRO9 = models.CharField(max_length=255, null=True)
109 
+    PRO10 = models.CharField(max_length=255, null=True)
110 
+    PRO11 = models.CharField(max_length=255, null=True)
111 
+    PRO12 = models.CharField(max_length=255, null=True)
112 
+    PRO13 = models.CharField(max_length=255, null=True)
113 
+    PRO14 = models.CharField(max_length=255, null=True)
114 
+    PRO15 = models.CharField(max_length=255, null=True)
115 
+    PRO16 = models.CharField(max_length=255, null=True)
116 
+    PRO17 = models.CharField(max_length=255, null=True)
117 
+    PRO18 = models.CharField(max_length=255, null=True)
118 
+    PRO21 = models.CharField(max_length=255, null=True)
119 
+    PRO25 = models.CharField(max_length=255, null=True)
120 
+    PRO27 = models.CharField(max_length=255, null=True)
121 
+    P2 = models.CharField(max_length=255, null=True)  # PRO-P2
122 
+    PRO6 = models.CharField(max_length=255, null=True)
123 
+    SPEED = models.CharField(max_length=255, null=True)  # PRO-SPEED
124 
+    PRO_TOOL = models.CharField(max_length=255, null=True)  # PRO-TOOL
125 
+    PRO4 = models.CharField(max_length=255, null=True)
126 
+
127 
+    # Fields from dbo.[V-MAS-1]
128 
+    MC11 = models.CharField(max_length=255, null=True)
129 
+    MC12 = models.CharField(max_length=255, null=True)
130 
+    MC14 = models.CharField(max_length=255, null=True)
131 
+    MC15 = models.CharField(max_length=255, null=True)
132 
+    MC16 = models.CharField(max_length=255, null=True)
133 
+    MC19 = models.CharField(max_length=255, null=True)
134 
+    MC20 = models.CharField(max_length=255, null=True)
135 
+    MC21 = models.CharField(max_length=255, null=True)
136 
+    MC22 = models.CharField(max_length=255, null=True)
137 
+    MC23 = models.CharField(max_length=255, null=True)
138 
+    MC24 = models.CharField(max_length=255, null=True)
139 
+
140 
+    # Fields from dbo.[V-MAS-2]
141 
+    MP34 = models.CharField(max_length=255, null=True)
142 
+    MP39 = models.CharField(max_length=255, null=True)
143 
+
144 
+    # Fields from dbo.[V-MAS-3]
145 
+    MI13 = models.CharField(max_length=255, null=True)
146 
+    TC = models.CharField(max_length=255, null=True)
147 
+    MI14 = models.CharField(max_length=255, null=True)
148 
+    MI15 = models.CharField(max_length=255, null=True)
149 
+    MI16 = models.CharField(max_length=255, null=True)
150 
+    MI17 = models.CharField(max_length=255, null=True)
151 
+    MI18 = models.CharField(max_length=255, null=True)
152 
+    MI19 = models.CharField(max_length=255, null=True)
153 
+    MI20 = models.CharField(max_length=255, null=True)
154 
+    MI21 = models.CharField(max_length=255, null=True)
155 
+    MI22 = models.CharField(max_length=255, null=True)
156 
+    MI23 = models.CharField(max_length=255, null=True)
157 
+    MI31 = models.CharField(max_length=255, null=True)
158 
+    MI33 = models.CharField(max_length=255, null=True)
159 
+    INSAGM = models.CharField(max_length=255, null=True)
160 
+    MARAGM = models.CharField(max_length=255, null=True)
161 
+    MI53 = models.CharField(max_length=255, null=True)
162 
+    MI55 = models.CharField(max_length=255, null=True)
163 
+    MI36 = models.CharField(max_length=255, null=True)
164 
+    MI39 = models.CharField(max_length=255, null=True)
165 
+    MI24 = models.CharField(max_length=255, null=True)
166 
+
167 
+    # Fields from MGT_Config.dbo.[TABLE_TI-T1], [TABLE_TI-T5], [TABLE_TI-T6]
168 
+    Ind1 = models.CharField(max_length=255, null=True)  # TIT1NE
169 
+    Ind2 = models.CharField(max_length=255, null=True)  # TIT5NE
170 
+    Ind3 = models.CharField(max_length=255, null=True)  # TIT6NE
171 
+
172 
+    # Conditional Fields
173 
+    AGR1 = models.CharField(max_length=255, null=True)
174 
+    AGR2 = models.CharField(max_length=255, null=True)
175 
+    ob_Condition = models.CharField(max_length=255, null=True)  # TIT4NE
176 
+
177 
+
178 
+    class Meta:
179 
+        managed = False
180 
+        db_table = 'VMasterView_Full_Mockup_Data'
181 
+
182 
+
183 
+class VwRotateLog(models.Model):
184 
+    # Fields from the SQL view
185 
+    PROD_CODE = models.CharField(max_length=255, null=True)
186 
+    LOT_NO = models.CharField(max_length=255, null=True)
187 
+    SPEED_SPEC = models.DecimalField(max_digits=10, decimal_places=2, null=True)
188 
+    SPEED_TEST = models.DecimalField(max_digits=10, decimal_places=2, null=True)
189 
+    SPEED_NG = models.DecimalField(max_digits=10, decimal_places=2, null=True)
190 
+    CREATED_DT = models.DateTimeField(null=True)
191 
+    LAST_UPD_DT = models.DateTimeField(null=True)
192 
+    QTY = models.IntegerField(null=True)
193 
+    STATION_NO = models.CharField(max_length=255, null=True)
194 
+
195 
+    class Meta:
196 
+        managed = False  # This model corresponds to a database view
197 
+        db_table = 'VwRotateLog_Mockup_Data'
198 
+
199 
+
200 
+class VwRotateResult(models.Model):
201 
+    # Fields from the SQL view
202 
+    PROD_CODE = models.CharField(max_length=255, null=True)
203 
+    LOT_NO = models.CharField(max_length=255, null=True)
204 
+    SPEED_SPEC = models.DecimalField(max_digits=10, decimal_places=2, null=True)
205 
+    QTY = models.IntegerField(null=True)
206 
+    STATION_NO = models.CharField(max_length=255, null=True)
207 
+    START_DT = models.DateTimeField(null=True)  # T1.TEST_DT as START_DT
208 
+    TEST_NO = models.CharField(max_length=255, null=True)
209 
+    SPEED_TEST_VAL = models.DecimalField(max_digits=10, decimal_places=2, null=True)
210 
+    SPEED_NG_VAL = models.DecimalField(max_digits=10, decimal_places=2, null=True)
211 
+    TEST_END_DT = models.DateTimeField(null=True)  # T2.TEST_DT as TEST_END_DT
212 
+
213 
+    class Meta:
214 
+        managed = False  # This model corresponds to a database view
215 
+        db_table = 'VW_ROTATE_RESULT'  # Name of the database view
216 
+
217 
+
218 
+class BelMasterView(models.Model):
219 
+    # Fields from ProcessControl.dbo.[Q-PRO-DATA]
220 
+    PRO0 = models.CharField(max_length=255, null=True)
221 
+    PRO1 = models.CharField(max_length=255, null=True)
222 
+    PRO1C = models.CharField(max_length=255, null=True)
223 
+    PRO2 = models.CharField(max_length=255, null=True)
224 
+    PRO5 = models.CharField(max_length=255, null=True)
225 
+    PRO8 = models.CharField(max_length=255, null=True)
226 
+    PRO9 = models.CharField(max_length=255, null=True)
227 
+    PRO10 = models.CharField(max_length=255, null=True)
228 
+    PRO11 = models.CharField(max_length=255, null=True)
229 
+    PRO12 = models.CharField(max_length=255, null=True)
230 
+    PRO13 = models.CharField(max_length=255, null=True)
231 
+    PRO14 = models.CharField(max_length=255, null=True)
232 
+    PRO15 = models.CharField(max_length=255, null=True)
233 
+    PRO16 = models.CharField(max_length=255, null=True)
234 
+    PRO17 = models.CharField(max_length=255, null=True)
235 
+    PRO18 = models.CharField(max_length=255, null=True)
236 
+    PRO21 = models.CharField(max_length=255, null=True)
237 
+    PRO25 = models.CharField(max_length=255, null=True)
238 
+    PRO27 = models.CharField(max_length=255, null=True)
239 
+    P2 = models.CharField(max_length=255, null=True)  # PRO-P2
240 
+    PRO6 = models.CharField(max_length=255, null=True)
241 
+    SPEED = models.CharField(max_length=255, null=True)  # PRO-SPEED
242 
+    PRO_TOOL = models.CharField(max_length=255, null=True)  # PRO-TOOL
243 
+    PRO4 = models.CharField(max_length=255, null=True)
244 
+
245 
+    # Fields from dbo.[BEL-MAS-1]
246 
+    MC11 = models.CharField(max_length=255, null=True)
247 
+    MC12 = models.CharField(max_length=255, null=True)
248 
+    MC14 = models.CharField(max_length=255, null=True)
249 
+    MC15 = models.CharField(max_length=255, null=True)
250 
+    MC16 = models.CharField(max_length=255, null=True)
251 
+    MC19 = models.CharField(max_length=255, null=True)
252 
+    MC20 = models.CharField(max_length=255, null=True)
253 
+    MC21 = models.CharField(max_length=255, null=True)
254 
+    MC22 = models.CharField(max_length=255, null=True)
255 
+    MC23 = models.CharField(max_length=255, null=True)
256 
+    MC24 = models.CharField(max_length=255, null=True)
257 
+
258 
+    # Fields from dbo.[BEL-MAS-2]
259 
+    MP45 = models.CharField(max_length=255, null=True)
260 
+    MP49 = models.CharField(max_length=255, null=True)
261 
+
262 
+    # Fields from dbo.[BEL-MAS-3]
263 
+    MI13 = models.CharField(max_length=255, null=True)
264 
+    TC = models.CharField(max_length=255, null=True)
265 
+    MI14 = models.CharField(max_length=255, null=True)
266 
+    MI15 = models.CharField(max_length=255, null=True)
267 
+    MI16 = models.CharField(max_length=255, null=True)
268 
+    MI17 = models.CharField(max_length=255, null=True)
269 
+    MI18 = models.CharField(max_length=255, null=True)
270 
+    MI19 = models.CharField(max_length=255, null=True)
271 
+    MI20 = models.CharField(max_length=255, null=True)
272 
+    MI21 = models.CharField(max_length=255, null=True)
273 
+    MI22 = models.CharField(max_length=255, null=True)
274 
+    MI23 = models.CharField(max_length=255, null=True)
275 
+    MI31 = models.CharField(max_length=255, null=True)
276 
+    MI33 = models.CharField(max_length=255, null=True)
277 
+    INSAGM = models.CharField(max_length=255, null=True)
278 
+    MARAGM = models.CharField(max_length=255, null=True)
279 
+    MI53 = models.CharField(max_length=255, null=True)
280 
+    MI55 = models.CharField(max_length=255, null=True)
281 
+    MI36 = models.CharField(max_length=255, null=True)
282 
+    MI39 = models.CharField(max_length=255, null=True)
283 
+    MI24 = models.CharField(max_length=255, null=True)
284 
+
285 
+    # Fields from MGT_Config.dbo.[TABLE_TI-T1], [TABLE_TI-T5], [TABLE_TI-T6]
286 
+    Ind1 = models.CharField(max_length=255, null=True)  # TIT1NE
287 
+    Ind2 = models.CharField(max_length=255, null=True)  # TIT5NE
288 
+    Ind3 = models.CharField(max_length=255, null=True)  # TIT6NE
289 
+
290 
+    # Conditional Fields
291 
+    AGR1 = models.CharField(max_length=255, null=True)
292 
+    AGR2 = models.CharField(max_length=255, null=True)
293 
+    ob_Condition = models.CharField(max_length=255, null=True)  # TIT4NE
294 
+
295 
+    class Meta:
296 
+        managed = False  # This model corresponds to a database view
297 
+        db_table = 'bel_master_view'  # Name of the database view
298 
+
299 
+class EMasterView(models.Model):
300 
+    # Fields from ProcessControl.dbo.[Q-PRO-DATA]
301 
+    PRO0 = models.CharField(max_length=255, null=True)
302 
+    PRO1 = models.CharField(max_length=255, null=True)
303 
+    PRO1C = models.CharField(max_length=255, null=True)
304 
+    PRO2 = models.CharField(max_length=255, null=True)
305 
+    PRO5 = models.CharField(max_length=255, null=True)
306 
+    PRO8 = models.CharField(max_length=255, null=True)
307 
+    PRO9 = models.CharField(max_length=255, null=True)
308 
+    PRO10 = models.CharField(max_length=255, null=True)
309 
+    PRO11 = models.CharField(max_length=255, null=True)
310 
+    PRO12 = models.CharField(max_length=255, null=True)
311 
+    PRO13 = models.CharField(max_length=255, null=True)
312 
+    PRO14 = models.CharField(max_length=255, null=True)
313 
+    PRO15 = models.CharField(max_length=255, null=True)
314 
+    PRO16 = models.CharField(max_length=255, null=True)
315 
+    PRO17 = models.CharField(max_length=255, null=True)
316 
+    PRO18 = models.CharField(max_length=255, null=True)
317 
+    PRO21 = models.CharField(max_length=255, null=True)
318 
+    PRO25 = models.CharField(max_length=255, null=True)
319 
+    PRO27 = models.CharField(max_length=255, null=True)
320 
+    P2 = models.CharField(max_length=255, null=True)  # PRO-P2
321 
+    PRO6 = models.CharField(max_length=255, null=True)
322 
+    SPEED = models.CharField(max_length=255, null=True)  # PRO-SPEED
323 
+    PRO_TOOL = models.CharField(max_length=255, null=True)  # PRO-TOOL
324 
+    PRO4 = models.CharField(max_length=255, null=True)
325 
+
326 
+    # Fields from dbo.[E-MAS-1]
327 
+    MC11 = models.CharField(max_length=255, null=True)
328 
+    MC12 = models.CharField(max_length=255, null=True)
329 
+    MC14 = models.CharField(max_length=255, null=True)
330 
+    MC15 = models.CharField(max_length=255, null=True)
331 
+    MC16 = models.CharField(max_length=255, null=True)
332 
+    MC19 = models.CharField(max_length=255, null=True)
333 
+    MC20 = models.CharField(max_length=255, null=True)
334 
+    MC21 = models.CharField(max_length=255, null=True)
335 
+    MC22 = models.CharField(max_length=255, null=True)
336 
+    MC23 = models.CharField(max_length=255, null=True)
337 
+    MC24 = models.CharField(max_length=255, null=True)
338 
+
339 
+    # Fields from dbo.[E-MAS-2]
340 
+    MP45 = models.CharField(max_length=255, null=True)
341 
+    MP49 = models.CharField(max_length=255, null=True)
342 
+
343 
+    # Fields from dbo.[E-MAS-3]
344 
+    MI13 = models.CharField(max_length=255, null=True)
345 
+    TC = models.CharField(max_length=255, null=True)
346 
+    MI14 = models.CharField(max_length=255, null=True)
347 
+    MI15 = models.CharField(max_length=255, null=True)
348 
+    MI16 = models.CharField(max_length=255, null=True)
349 
+    MI17 = models.CharField(max_length=255, null=True)
350 
+    MI18 = models.CharField(max_length=255, null=True)
351 
+    MI19 = models.CharField(max_length=255, null=True)
352 
+    MI20 = models.CharField(max_length=255, null=True)
353 
+    MI21 = models.CharField(max_length=255, null=True)
354 
+    MI22 = models.CharField(max_length=255, null=True)
355 
+    MI23 = models.CharField(max_length=255, null=True)
356 
+    MI31 = models.CharField(max_length=255, null=True)
357 
+    MI33 = models.CharField(max_length=255, null=True)
358 
+    INSAGM = models.CharField(max_length=255, null=True)
359 
+    MARAGM = models.CharField(max_length=255, null=True)
360 
+    MI53 = models.CharField(max_length=255, null=True)
361 
+    MI55 = models.CharField(max_length=255, null=True)
362 
+    MI36 = models.CharField(max_length=255, null=True)
363 
+    MI39 = models.CharField(max_length=255, null=True)
364 
+    MI24 = models.CharField(max_length=255, null=True)
365 
+
366 
+    # Fields from MGT_Config.dbo.[TABLE_TI-T1], [TABLE_TI-T5], [TABLE_TI-T6]
367 
+    Ind1 = models.CharField(max_length=255, null=True)  # TIT1NE
368 
+    Ind2 = models.CharField(max_length=255, null=True)  # TIT5NE
369 
+    Ind3 = models.CharField(max_length=255, null=True)  # TIT6NE
370 
+
371 
+    # Conditional Fields
372 
+    AGR1 = models.CharField(max_length=255, null=True)
373 
+    AGR2 = models.CharField(max_length=255, null=True)
374 
+    ob_Condition = models.CharField(max_length=255, null=True)  # TIT4NE
375 
+
376 
+    class Meta:
377 
+        managed = False  # This model corresponds to a database view
378 
+        db_table = 'e_master_view'  # Name of the database view
379 
+
380 
+class AllProductAverageObMinMaxView(models.Model):
381 
+    ProductCode = models.CharField(max_length=255, null=True)  # RE01
382 
+    out_min = models.DecimalField(max_digits=10, decimal_places=2, null=True)  # Minimum of [OB-O]
383 
+    out_max = models.DecimalField(max_digits=10, decimal_places=2, null=True)  # Maximum of [OB-O]
384 
+    in_min = models.DecimalField(max_digits=10, decimal_places=2, null=True)  # Minimum of [OB-I]
385 
+    in_max = models.DecimalField(max_digits=10, decimal_places=2, null=True)  # Maximum of [OB-I]
386 
+
387 
+    class Meta:
388 
+        managed = False  # This model corresponds to a database view
389 
+        db_table = 'AllProduct_Average_OB_MIN_MAX_view'  # Name of the database view
390 
+
391 
+class AllProductDimensionForInsProcess(models.Model):
392 
+    ProdType = models.CharField(max_length=255, null=True)  # Product type (e.g., 'V', 'E', 'BEL', 'MG')
393 
+    ProductCode = models.CharField(max_length=255, null=True)  # Product code
394 
+    Size_Id = models.CharField(max_length=255, null=True)  # Size ID (e.g., '001', '002')
395 
+    Size_Name = models.CharField(max_length=255, null=True)  # Size name (e.g., 'D', 'T', 'H')
396 
+    Std = models.DecimalField(max_digits=10, decimal_places=2, null=True)  # Standard value
397 
+    TolUn = models.DecimalField(max_digits=10, decimal_places=2, null=True)  # Tolerance lower limit
398 
+    TolUp = models.DecimalField(max_digits=10, decimal_places=2, null=True)  # Tolerance upper limit
399 
+
400 
+    class Meta:
401 
+        managed = False  # This model corresponds to a database view
402 
+        db_table = 'AllProduct_Dimension_ForInsProcess'  # Name of the database view
403 
+
404 
+class AllProductPressPositionPressWeight(models.Model):
405 
+    ProductCode = models.CharField(max_length=255, null=True)
406 
+    Lot_No = models.CharField(max_length=255, null=True)
407 
+    PO_Qty = models.DecimalField(max_digits=10, decimal_places=2, null=True)
408 
+    UWeight = models.DecimalField(max_digits=10, decimal_places=2, null=True)
409 
+    Current_ProNo = models.CharField(max_length=255, null=True)
410 
+    Press_Time = models.DecimalField(max_digits=10, decimal_places=2, null=True)
411 
+    PressType_1 = models.CharField(max_length=255, null=True)
412 
+    PressWeight_1 = models.DecimalField(max_digits=10, decimal_places=2, null=True)
413 
+    PressType_2 = models.CharField(max_length=255, null=True)
414 
+    PressWeight_2 = models.DecimalField(max_digits=10, decimal_places=2, null=True)
415 
+    Press_Ton = models.DecimalField(max_digits=10, decimal_places=2, null=True)
416 
+    Press_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
417 
+    Press_T_Tol = models.DecimalField(max_digits=10, decimal_places=2, null=True)
418 
+    Mold_D = models.DecimalField(max_digits=10, decimal_places=2, null=True)
419 
+    Mold_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
420 
+    SegMold_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
421 
+    SegMold_D = models.DecimalField(max_digits=10, decimal_places=2, null=True)
422 
+    Center_D = models.DecimalField(max_digits=10, decimal_places=2, null=True)
423 
+    Center_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
424 
+    LowerPlate_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
425 
+    StudPlate_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
426 
+    UpperPlate_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
427 
+    PinPlate_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
428 
+    TopConcave_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
429 
+    BottomConcave_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
430 
+
431 
+    class Meta:
432 
+        managed = False  # This model corresponds to a database view
433 
+        db_table = 'AllProduct_PressPosition_PressWeight'  # Name of the database view

+ 2 - 0
app/legacy/models.py
View File 

@@ -843,3 +843,5 @@ class LegacyUsers(models.Model):
843 843 
         managed = False
844 844 
         db_table = 'users'
845 845 
         app_label = "legacy"
846 
+
847 
+

+ 1 - 1
app/templates/base.html
View File 

@@ -63,7 +63,7 @@
63 63 
         <div class="h-full px-3 pb-4 overflow-y-auto">
64 64 
             <ul class="space-y-2">
65 65 
                 <li><a href="/dashboard/" class="flex items-center p-2 text-gray-900 rounded-lg hover:bg-gray-100 dark:hover:bg-gray-700 dark:text-white"><span class="ml-3">Dashboard</span></a></li>
66 
-                <li><a href="/reports/" class="flex items-center p-2 text-gray-900 rounded-lg hover:bg-gray-100 dark:hover:bg-gray-700 dark:text-white"><span class="ml-3">Reports</span></a></li>
66 
+                <li><a href="{% url "report:index" %}" class="flex items-center p-2 text-gray-900 rounded-lg hover:bg-gray-100 dark:hover:bg-gray-700 dark:text-white"><span class="ml-3">Reports</span></a></li>
67 67 
                  <li>
68 68 
                     <button type="button" class="flex items-center w-full p-2 text-base text-gray-900 transition duration-75 rounded-lg group hover:bg-gray-100 dark:text-white dark:hover:bg-gray-700" aria-controls="dropdown-example" data-collapse-toggle="dropdown-example">
69 69 
                           <svg class="w-6 h-6 text-gray-800 dark:text-white" aria-hidden="true" xmlns="http://www.w3.org/2000/svg" width="24" height="24" fill="none" viewBox="0 0 24 24">

+ 1 - 1
docker-compose.yml
View File 

@@ -29,7 +29,7 @@ services:
29 29 
     volumes:
30 30 
       - ./app:/app
31 31 
     ports:
32 
-      - "8000:8000"
32 
+      - "8039:8000"
33 33 
     depends_on:
34 34 
       db:
35 35 
         condition: service_started

tum/whitesports - Gogs: Simplico Git Service
Accueil Explorer Aide
Connexion
tum
/
whitesports
Suivre 1
Voter 0
Fork 0
Code Tickets 0 Pull Requests 0 Commits 9 Publications 0 Wiki

Aucune description

Aborescence: 92ae4370cd
Branches Tags
whitesports
/
app
/
xmlrpc.php

xmlrpc.php 3.2KB
Historique Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106 
  1. <?php
    2. 

  2. /**
    3. 

  3.  * XML-RPC protocol support for WordPress
    4. 

  4.  *
    5. 

  5.  * @package WordPress
    6. 

  6.  */
    7. 

  7. 

  8. /**
    9. 

  9.  * Whether this is an XML-RPC Request
    10. 

  10.  *
    11. 

  11.  * @var bool
    12. 

  12.  */
    13. 

  13. define( 'XMLRPC_REQUEST', true );
    14. 

  14. 

  15. // Some browser-embedded clients send cookies. We don't want them.
    16. 

  16. $_COOKIE = array();
    17. 

  17. 

  18. // $HTTP_RAW_POST_DATA was deprecated in PHP 5.6 and removed in PHP 7.0.
    19. 

  19. // phpcs:disable PHPCompatibility.Variables.RemovedPredefinedGlobalVariables.http_raw_post_dataDeprecatedRemoved
    20. 

  20. if ( ! isset( $HTTP_RAW_POST_DATA ) ) {
    21. 

  21. 	$HTTP_RAW_POST_DATA = file_get_contents( 'php://input' );
    22. 

  22. }
    23. 

  23. 

  24. // Fix for mozBlog and other cases where '<?xml' isn't on the very first line.
    25. 

  25. if ( isset( $HTTP_RAW_POST_DATA ) ) {
    26. 

  26. 	$HTTP_RAW_POST_DATA = trim( $HTTP_RAW_POST_DATA );
    27. 

  27. }
    28. 

  28. // phpcs:enable
    29. 

  29. 

  30. /** Include the bootstrap for setting up WordPress environment */
    31. 

  31. require_once __DIR__ . '/wp-load.php';
    32. 

  32. 

  33. if ( isset( $_GET['rsd'] ) ) { // http://cyber.law.harvard.edu/blogs/gems/tech/rsd.html
    34. 

  34. 	header( 'Content-Type: text/xml; charset=' . get_option( 'blog_charset' ), true );
    35. 

  35. 	echo '<?xml version="1.0" encoding="' . get_option( 'blog_charset' ) . '"?' . '>';
    36. 

  36. 	?>
    37. 

  37. <rsd version="1.0" xmlns="http://archipelago.phrasewise.com/rsd">
    38. 

  38. 	<service>
    39. 

  39. 		<engineName>WordPress</engineName>
    40. 

  40. 		<engineLink>https://wordpress.org/</engineLink>
    41. 

  41. 		<homePageLink><?php bloginfo_rss( 'url' ); ?></homePageLink>
    42. 

  42. 		<apis>
    43. 

  43. 			<api name="WordPress" blogID="1" preferred="true" apiLink="<?php echo site_url( 'xmlrpc.php', 'rpc' ); ?>" />
    44. 

  44. 			<api name="Movable Type" blogID="1" preferred="false" apiLink="<?php echo site_url( 'xmlrpc.php', 'rpc' ); ?>" />
    45. 

  45. 			<api name="MetaWeblog" blogID="1" preferred="false" apiLink="<?php echo site_url( 'xmlrpc.php', 'rpc' ); ?>" />
    46. 

  46. 			<api name="Blogger" blogID="1" preferred="false" apiLink="<?php echo site_url( 'xmlrpc.php', 'rpc' ); ?>" />
    47. 

  47. 			<?php
    48. 

  48. 			/**
    49. 

  49. 			 * Add additional APIs to the Really Simple Discovery (RSD) endpoint.
    50. 

  50. 			 *
    51. 

  51. 			 * @link http://cyber.law.harvard.edu/blogs/gems/tech/rsd.html
    52. 

  52. 			 *
    53. 

  53. 			 * @since 3.5.0
    54. 

  54. 			 */
    55. 

  55. 			do_action( 'xmlrpc_rsd_apis' );
    56. 

  56. 			?>
    57. 

  57. 		</apis>
    58. 

  58. 	</service>
    59. 

  59. </rsd>
    60. 

  60. 	<?php
    61. 

  61. 	exit;
    62. 

  62. }
    63. 

  63. 

  64. require_once ABSPATH . 'wp-admin/includes/admin.php';
    65. 

  65. require_once ABSPATH . WPINC . '/class-IXR.php';
    66. 

  66. require_once ABSPATH . WPINC . '/class-wp-xmlrpc-server.php';
    67. 

  67. 

  68. /**
    69. 

  69.  * Posts submitted via the XML-RPC interface get that title
    70. 

  70.  *
    71. 

  71.  * @name post_default_title
    72. 

  72.  * @var string
    73. 

  73.  */
    74. 

  74. $post_default_title = '';
    75. 

  75. 

  76. /**
    77. 

  77.  * Filters the class used for handling XML-RPC requests.
    78. 

  78.  *
    79. 

  79.  * @since 3.1.0
    80. 

  80.  *
    81. 

  81.  * @param string $class The name of the XML-RPC server class.
    82. 

  82.  */
    83. 

  83. $wp_xmlrpc_server_class = apply_filters( 'wp_xmlrpc_server_class', 'wp_xmlrpc_server' );
    84. 

  84. $wp_xmlrpc_server       = new $wp_xmlrpc_server_class;
    85. 

  85. 

  86. // Fire off the request.
    87. 

  87. $wp_xmlrpc_server->serve_request();
    88. 

  88. 

  89. exit;
    90. 

  90. 

  91. /**
    92. 

  92.  * logIO() - Writes logging info to a file.
    93. 

  93.  *
    94. 

  94.  * @deprecated 3.4.0 Use error_log()
    95. 

  95.  * @see error_log()
    96. 

  96.  *
    97. 

  97.  * @param string $io Whether input or output
    98. 

  98.  * @param string $msg Information describing logging reason.
    99. 

  99.  */
    100. 

  100. function logIO( $io, $msg ) { // phpcs:ignore WordPress.NamingConventions.ValidFunctionName.FunctionNameInvalid
    101. 

  101. 	_deprecated_function( __FUNCTION__, '3.4.0', 'error_log()' );
    102. 

  102. 	if ( ! empty( $GLOBALS['xmlrpc_logging'] ) ) {
    103. 

  103. 		error_log( $io . ' - ' . $msg );
    104. 

  104. 	}
    105. 

  105. }
    106. 

  106.