source: trunk/Application/FormClasses.php@ 710

Last change on this file since 710 was 710, checked in by chronos, 10 years ago
File size: 27.6 KB
Line 
1<?php
2
3// TODO: Split all form class definitions to modules
4
5/*
6Item definition:
7Type - identifikace typu z podporovaných
8Caption - popisek, titulek položky
9Default - výchozí hodnota
10Null - hodnota nemusí být zadána
11NoInList - sloupec viditelný v seznamu
12Suffix - text za hodnotou
13Description - popis významu položky
14ReadOnly - je položky pouze pro čtení
15Required - položka je vyžadována
16*/
17
18function RegisterFormClasses($FormManager)
19{
20 $FormManager->Classes = array(
21 'Module' => array(
22 'Title' => 'Moduly',
23 'Table' => 'Module',
24 'Items' => array(
25 'Name' => array('Type' => 'String', 'Caption' => 'Systémové jméno', 'Default' => ''),
26 'Title' => array('Type' => 'String', 'Caption' => 'Název', 'Default' => ''),
27 ),
28 ),
29 'UserCustomerRel' => array(
30 'Title' => 'Vztahy uživatel - zákazník',
31 'Table' => 'UserCustomerRel',
32 'Items' => array(
33 'User' => array('Type' => 'TUser', 'Caption' => 'Uživatel', 'Default' => ''),
34 'Customer' => array('Type' => 'TMember', 'Caption' => 'Zákazník', 'Default' => ''),
35 ),
36 ),
37 'FinanceInvoiceOperationRel' => array(
38 'Title' => 'Zaplacení faktůr',
39 'Table' => 'FinanceInvoiceOperationRel',
40 'Items' => array(
41 'Invoice' => array('Type' => 'TFinanceInvoice', 'Caption' => 'Faktura', 'Default' => ''),
42 'Operation' => array('Type' => 'TFinanceOperation', 'Caption' => 'Platba', 'Default' => ''),
43 ),
44 ),
45 'ServiceCustomerRel' => array(
46 'Title' => 'Vztahy služba - zákazník',
47 'Table' => 'ServiceCustomerRel',
48 'Items' => array(
49 'Service' => array('Type' => 'TService', 'Caption' => 'Služba', 'Default' => ''),
50 'Customer' => array('Type' => 'TMember', 'Caption' => 'Zákazník', 'Default' => ''),
51 'Action' => array('Type' => 'TActionEnum', 'Caption' => 'Změna období', 'Default' => '', 'Null' => true),
52 'ReplaceId' => array('Type' => 'TServiceCustomerRel', 'Caption' => 'Cílová položka', 'Default' => '', 'Null' => true),
53 ),
54 ),
55 'DocumentLine' => array(
56 'Title' => 'Dokladové řady',
57 'Table' => 'DocumentLine',
58 'DefaultSortColumn' => 'Name',
59 'Items' => array(
60 'Name' => array('Type' => 'String', 'Caption' => 'Jméno', 'Default' => ''),
61 'Shortcut' => array('Type' => 'String', 'Caption' => 'Kód', 'Default' => ''),
62 'Sequence' => array('Type' => 'TDocumentLineSequenceListLine', 'Caption' => 'Čísleníky', 'Default' => ''),
63 ),
64 ),
65 'DocumentLineSequence' => array(
66 'Title' => 'Čísleníky dokladových řad',
67 'Table' => 'DocumentLineSequence',
68 'DefaultSortColumn' => 'Id',
69 'Items' => array(
70 'DocumentLine' => array('Type' => 'TDocumentLine', 'Caption' => 'Dokladová řada', 'Default' => ''),
71 'FinanceYear' => array('Type' => 'TFinanceYear', 'Caption' => 'Účetní rok', 'Default' => ''),
72 'NextNumber' => array('Type' => 'Integer', 'Caption' => 'Další číslo', 'Default' => '1'),
73 'YearPrefix' => array('Type' => 'Boolean', 'Caption' => 'Rok jako přípona', 'Default' => '1'),
74 'Operations' => array('Type' => 'TFinanceOperationListDocumentLine', 'Caption' => 'Finanční operace', 'Default' => ''),
75 'Invoices' => array('Type' => 'TFinanceInvoiceListDocumentLine', 'Caption' => 'Faktury', 'Default' => ''),
76 ),
77 ),
78 'FinanceYear' => array(
79 'Title' => 'Účetní roky',
80 'Table' => 'FinanceYear',
81 'DefaultSortColumn' => 'Year',
82 'DefaultSortOrder' => 1,
83 'Items' => array(
84 'Year' => array('Type' => 'Integer', 'Caption' => 'Rok', 'Default' => ''),
85 'DateStart' => array('Type' => 'Date', 'Caption' => 'První den', 'Default' => ''),
86 'DateEnd' => array('Type' => 'Date', 'Caption' => 'Poslední den', 'Default' => ''),
87 'Closed' => array('Type' => 'Boolean', 'Caption' => 'Uzavřen', 'Default' => 0),
88 'Sequence' => array('Type' => 'TDocumentLineSequenceListYear', 'Caption' => 'Čísleníky', 'Default' => ''),
89 ),
90 //'AfterInsert' => array($this, 'AfterInsertFinanceYear'),
91 ),
92 'FinanceYearReport' => array(
93 'Title' => 'Roční výkaz',
94 'Table' => 'FinanceYearReport',
95 'SQL' => 'SELECT Id, DateEnd, DateStart FROM FinanceYear',
96 'DefaultSortColumn' => 'Id',
97 'Items' => array(
98 'Id' => array('Type' => 'TFinanceYear', 'Caption' => 'Rok', 'Default' => '',
99 'ReadOnly' => true),
100 'Income' => array('Type' => 'Integer', 'Caption' => 'Příjmy', 'Default' => '0', 'Suffix' => 'Kč', 'ReadOnly' => true,
101 'SQL' => '(SELECT ROUND(SUM(`FinanceOperation`.`Value`)) FROM `FinanceOperation` WHERE (`FinanceOperation`.`Time` <= `DateEnd`) '.
102 'AND (`FinanceOperation`.`Time` >= `DateStart`) AND (`FinanceOperation`.`Value` > 0))'),
103 'Spending' => array('Type' => 'Integer', 'Caption' => 'Výdaje', 'Default' => '0', 'Suffix' => 'Kč', 'ReadOnly' => true,
104 'SQL' => '(SELECT -ROUND(SUM(`FinanceOperation`.`Value`)) FROM `FinanceOperation` WHERE (`FinanceOperation`.`Time` <= `DateEnd`) '.
105 'AND (`FinanceOperation`.`Time` >= `DateStart`) AND (`FinanceOperation`.`Value` < 0))'),
106 'OperationBalance' => array('Type' => 'Integer', 'Caption' => 'Zisk', 'Default' => '0', 'Suffix' => 'Kč', 'ReadOnly' => true,
107 'SQL' => '(SELECT ROUND(SUM(`FinanceOperation`.`Value`)) FROM `FinanceOperation` WHERE (`FinanceOperation`.`Time` <= `DateEnd`) '.
108 'AND (`FinanceOperation`.`Time` >= `DateStart`))'),
109 'TaxIncome' => array('Type' => 'Integer', 'Caption' => 'Daňové příjmy', 'Default' => '0', 'Suffix' => 'Kč', 'ReadOnly' => true,
110 'SQL' => '(SELECT ROUND(SUM(`FinanceOperation`.`Value`)) FROM `FinanceOperation` WHERE (`FinanceOperation`.`Time` <= `DateEnd`) '.
111 'AND (`FinanceOperation`.`Time` >= `DateStart`) AND (`FinanceOperation`.`Taxable` = 1) AND (`FinanceOperation`.`Value` > 0))'),
112 'TaxSpending' => array('Type' => 'Integer', 'Caption' => 'Daňové výdaje', 'Default' => '0', 'Suffix' => 'Kč', 'ReadOnly' => true,
113 'SQL' => '(SELECT -ROUND(SUM(`FinanceOperation`.`Value`)) FROM `FinanceOperation` WHERE (`FinanceOperation`.`Time` <= `DateEnd`) '.
114 'AND (`FinanceOperation`.`Time` >= `DateStart`) AND (`FinanceOperation`.`Taxable` = 1) AND (`FinanceOperation`.`Value` < 0))'),
115 'TaxBase' => array('Type' => 'Integer', 'Caption' => 'Základ daně', 'Default' => '0', 'Suffix' => 'Kč', 'ReadOnly' => true,
116 'SQL' => '(SELECT ROUND(SUM(`FinanceOperation`.`Value`)) FROM `FinanceOperation` WHERE (`FinanceOperation`.`Time` <= `DateEnd`) '.
117 'AND (`FinanceOperation`.`Time` >= `DateStart`) AND (`FinanceOperation`.`Taxable` = 1))'),
118 'Claims' => array('Type' => 'Integer', 'Caption' => 'Pohledávky', 'Default' => '0', 'Suffix' => 'Kč', 'ReadOnly' => true,
119 'SQL' => '(SELECT ROUND(SUM(`FinanceInvoice`.`Value`)) FROM `FinanceInvoice` WHERE (`FinanceInvoice`.`Time` <= `DateEnd`) '.
120 'AND (`FinanceInvoice`.`Time` >= `DateStart`) AND (`FinanceInvoice`.`Value` > 0))'),
121 'Liabilities' => array('Type' => 'Integer', 'Caption' => 'Závazky', 'Default' => '0', 'Suffix' => 'Kč', 'ReadOnly' => true,
122 'SQL' => '(SELECT -ROUND(SUM(`FinanceInvoice`.`Value`)) FROM `FinanceInvoice` WHERE (`FinanceInvoice`.`Time` <= `DateEnd`) '.
123 'AND (`FinanceInvoice`.`Time` >= `DateStart`) AND (`FinanceInvoice`.`Value` < 0))'),
124 'InvoiceBalance' => array('Type' => 'Integer', 'Caption' => 'Fakturační rozdíl', 'Default' => '0', 'Suffix' => 'Kč', 'ReadOnly' => true,
125 'SQL' => '(SELECT ROUND(SUM(`FinanceInvoice`.`Value`)) FROM `FinanceInvoice` WHERE (`FinanceInvoice`.`Time` <= `DateEnd`) '.
126 'AND (`FinanceInvoice`.`Time` >= `DateStart`))'),
127 ),
128 //'AfterInsert' => array($this, 'AfterInsertFinanceYear'),
129 ),
130 'Language' => array(
131 'Title' => 'Jazyky',
132 'Table' => 'Language',
133 'DefaultSortColumn' => 'Name',
134 'Items' => array(
135 'Name' => array('Type' => 'String', 'Caption' => 'Jméno', 'Default' => ''),
136 ),
137 ),
138 'UnitOfMeasure' => array(
139 'Title' => 'Měrné jednotky',
140 'Table' => 'UnitOfMeasure',
141 'DefaultSortColumn' => 'Name',
142 'Items' => array(
143 'Name' => array('Type' => 'String', 'Caption' => 'Jméno', 'Default' => ''),
144 'Unit' => array('Type' => 'String', 'Caption' => 'Jednotka', 'Default' => ''),
145 ),
146 ),
147 'FinanceBillingPeriod' => array(
148 'Title' => 'Platební období',
149 'Table' => 'FinanceBillingPeriod',
150 'DefaultSortColumn' => 'Name',
151 'Items' => array(
152 'Name' => array('Type' => 'String', 'Caption' => 'Jméno', 'Default' => ''),
153 'MonthCount' => array('Type' => 'Integer', 'Caption' => 'Počet měsíců', 'Default' => '0', 'Suffix' => 'měsíců'),
154 'Customers' => array('Type' => 'TCustomerListBillingPeriod', 'Caption' => 'Zákazníci', 'Default' => ''),
155 ),
156 ),
157 'Service' => array(
158 'Title' => 'Služby',
159 'Table' => 'Service',
160 'DefaultSortColumn' => 'Name',
161 'Items' => array(
162 'Name' => array('Type' => 'String', 'Caption' => 'Jméno', 'Default' => ''),
163 'Category' => array('Type' => 'TServiceCategory', 'Caption' => 'Skupina', 'Default' => '', 'Null' => true),
164 'Price' => array('Type' => 'Integer', 'Caption' => 'Cena', 'Default' => '0', 'Suffix' => 'Kč'),
165 'VAT' => array('Type' => 'TFinanceVATType', 'Caption' => 'Sazba DPH', 'Default' => '0', 'Suffix' => ''),
166 'CustomerCount' => array('Type' => 'Integer', 'Caption' => 'Počet zákazníků', 'Default' => '', 'ReadOnly' => true),
167 'Public' => array('Type' => 'Boolean', 'Caption' => 'Veřejné', 'Default' => ''),
168 'InternetSpeedMin' => array('Type' => 'Integer', 'Caption' => 'Min. rychlost internetu', 'Default' => '0', 'Suffix' => 'kbit/s'),
169 'InternetSpeedMax' => array('Type' => 'Integer', 'Caption' => 'Max. rychlost internetu', 'Default' => '0', 'Suffix' => 'kbit/s'),
170 'UploadAsymmetry' => array('Type' => 'Integer', 'Caption' => 'Asymetrie odesílání', 'Default' => '1'),
171 'Memory' => array('Type' => 'Integer', 'Caption' => 'Paměť', 'Default' => '0', 'Suffix' => 'GB'),
172 'MemorySwap' => array('Type' => 'Integer', 'Caption' => 'Odkládací oddíl', 'Default' => '0', 'Suffix' => 'GB'),
173 'Storage' => array('Type' => 'Integer', 'Caption' => 'Úložiště', 'Default' => '0', 'Suffix' => 'GB'),
174 'CPUCount' => array('Type' => 'Integer', 'Caption' => 'Počet jader', 'Default' => '0', 'Suffix' => ''),
175 'Action' => array('Type' => 'TActionEnum', 'Caption' => 'Změna období', 'Default' => '', 'Null' => true),
176 'ReplaceId' => array('Type' => 'TService', 'Caption' => 'Cílová položka', 'Default' => '', 'Null' => true),
177 'CustomerRel' => array('Type' => 'TServiceCustomerRelListService', 'Caption' => 'Placení zákazníky', 'Default' => ''),
178 ),
179 ),
180 'Country' => array(
181 'Title' => 'Země',
182 'Table' => 'Country',
183 'DefaultSortColumn' => 'Name',
184 'Items' => array(
185 'Name' => array('Type' => 'String', 'Caption' => 'Jméno', 'Default' => ''),
186 ),
187 ),
188 'ServiceCategory' => array(
189 'Title' => 'Kategorie služeb',
190 'Table' => 'ServiceCategory',
191 'Items' => array(
192 'Name' => array('Type' => 'String', 'Caption' => 'Jméno', 'Default' => ''),
193 'Items' => array('Type' => 'TServiceListServiceCategory', 'Caption' => 'Služby', 'Default' => ''),
194 ),
195 ),
196);
197
198$FormManager->FormTypes = array
199(
200 'TServiceCategory' => array(
201 'Type' => 'Reference',
202 'Table' => 'ServiceCategory',
203 'Id' => 'Id',
204 'Name' => 'Name',
205 'Filter' => '1',
206 ),
207 'TPriority' => array(
208 'Type' => 'Enumeration',
209 'States' => array('Nízká', 'Střední', 'Vysoká'),
210 ),
211 'TOnlineState' => array(
212 'Type' => 'Enumeration',
213 'States' => array('<span style="color:red;">Nedostupný</span>', '<span style="color:green;">Dostupný</span>'),
214 ),
215 'TNetworkConfigurationState' => array(
216 'Type' => 'Enumeration',
217 'States' => array('Neplánováno', 'V plánu', 'Provádí se'),
218 ),
219 'TAntennaPolarity' => array(
220 'Type' => 'Enumeration',
221 'States' => array('Vertikální', 'Horizontální', 'Kruhová', 'Vertikální i horizontální'),
222 ),
223 'TNetworkDeviceState' => array(
224 'Type' => 'Enumeration',
225 'States' => array('Vyřazeno', 'Použito', 'Na skladě'),
226 ),
227 'TNetworkDeviceAction' => array(
228 'Type' => 'Enumeration',
229 'States' => array('Zakoupeno', 'Prodáno', 'Zařazeno do použití', 'Vyřazeno z použití', 'Zasláno do reklamace', 'Přijato z reklamace'),
230 ),
231 'TActionEnum' => array(
232 'Type' => 'Enumeration',
233 'States' => array('add' => 'Přidat', 'modify' => 'Upravit', 'remove' => 'Odstranit'),
234 ),
235 'TWirelessMode' => array(
236 'Type' => 'Enumeration',
237 'States' => array('Přístupový bod (AP)', 'Klient'),
238 ),
239 'TService' => array(
240 'Type' => 'Reference',
241 'Table' => 'Service',
242 'Id' => 'Id',
243 'Name' => 'Name',
244 'Filter' => '1',
245 ),
246 'TFinanceBillingPeriod' => array(
247 'Type' => 'Reference',
248 'Table' => 'FinanceBillingPeriod',
249 'Id' => 'Id',
250 'Name' => 'Name',
251 'Filter' => '1',
252 ),
253 'TMember' => array(
254 'Type' => 'Reference',
255 'Table' => 'Member',
256 'Id' => 'Id',
257 'Name' => 'Name',
258 'Filter' => '1',
259 ),
260 'TContract' => array(
261 'Type' => 'Reference',
262 'Table' => 'Contract',
263 'Id' => 'Id',
264 'Name' => 'BillCode',
265 'Filter' => '1',
266 ),
267 'TEmployee' => array(
268 'Type' => 'Reference',
269 'Table' => 'Employee',
270 'Id' => 'Id',
271 'Name' => 'CONCAT(FirstName, " ", SecondName)',
272 'Filter' => '1',
273 ),
274 'TEmployeeSalaryList' => array(
275 'Type' => 'ManyToOne',
276 'Table' => 'EmployeeSalary',
277 'Id' => 'Id',
278 'Ref' => 'Employee',
279 'Filter' => '1',
280 ),
281 'TMemberListSubject' => array(
282 'Type' => 'ManyToOne',
283 'Table' => 'Member',
284 'Id' => 'Id',
285 'Ref' => 'Subject',
286 'Filter' => '1',
287 ),
288 'TFinanceVAT' => array(
289 'Type' => 'Reference',
290 'Table' => 'FinanceVAT',
291 'Id' => 'Id',
292 'Name' => 'Name',
293 'Filter' => '1',
294 ),
295 'TFinanceVATType' => array(
296 'Type' => 'Reference',
297 'Table' => 'FinanceVATType',
298 'Id' => 'Id',
299 'Name' => 'Name',
300 'Filter' => '1',
301 ),
302 'TModule' => array(
303 'Type' => 'Reference',
304 'Table' => 'Module',
305 'Id' => 'Id',
306 'Name' => 'Name',
307 'Filter' => '1',
308 ),
309 'TMapPosition' => array(
310 'Type' => 'Reference',
311 'Table' => 'MapPosition',
312 'Id' => 'Id',
313 'Name' => 'Name',
314 'Filter' => '1',
315 ),
316 'TUser' => array(
317 'Type' => 'Reference',
318 'Table' => 'User',
319 'Id' => 'Id',
320 'Name' => 'Name',
321 'Filter' => '1',
322 ),
323 'TFinanceSubject' => array(
324 'Type' => 'Reference',
325 'Table' => 'Subject',
326 'Id' => 'Id',
327 'Name' => 'Name',
328 'Filter' => '1',
329 ),
330 'TDocumentLine' => array(
331 'Type' => 'Reference',
332 'Table' => 'DocumentLine',
333 'Id' => 'Id',
334 'Name' => 'Name',
335 'Filter' => '1',
336 ),
337 'TBankAccount' => array(
338 'Type' => 'Reference',
339 'Table' => 'FinanceBankAccount',
340 'Id' => 'Id',
341 'Name' => 'CONCAT(`Comment`, " (", `Number`, "/", '.
342 '(SELECT `FinanceBank`.`Code` FROM `FinanceBank` WHERE `FinanceBank`.`Id`=`FinanceBankAccount`.`Bank`), ")")',
343 'Filter' => '1',
344 ),
345 'TNetworkDevice' => array(
346 'Type' => 'Reference',
347 'Table' => 'NetworkDevice',
348 'Id' => 'Id',
349 'Name' => 'Name',
350 'Filter' => '1',
351 ),
352 'TNetworkDeviceType' => array(
353 'Type' => 'Reference',
354 'Table' => 'NetworkDeviceType',
355 'Id' => 'Id',
356 'Name' => 'Name',
357 'Filter' => '1',
358 ),
359 'TNetworkInterface' => array(
360 'Type' => 'Reference',
361 'Table' => 'NetworkInterface',
362 'View' => '(SELECT NetworkInterface.*, CONCAT(NetworkDevice.Name, "-", NetworkInterface.Name) AS DeviceName FROM NetworkInterface '.
363 'LEFT JOIN NetworkDevice ON NetworkDevice.Id = NetworkInterface.Device) AS T',
364 'Id' => 'Id',
365 'Name' => 'DeviceName',
366 'Filter' => '1',
367 ),
368 'TNetworkInterfaceType' => array(
369 'Type' => 'Reference',
370 'Table' => 'NetworkInterfaceType',
371 'Id' => 'Id',
372 'Name' => 'Name',
373 'Filter' => '1',
374 ),
375 'TServiceCustomerRel' => array(
376 'Type' => 'Reference',
377 'Table' => 'ServiceCustomerRel',
378 'Id' => 'Id',
379 'Name' => 'Id',
380 'Filter' => '1',
381 ),
382 'TNetworkSegment' => array(
383 'Type' => 'Reference',
384 'Table' => 'NetworkSegment',
385 'Id' => 'Id',
386 'Name' => 'Name',
387 'Filter' => '1',
388 ),
389 'TNewsCategory' => array(
390 'Type' => 'Reference',
391 'Table' => 'NewsCategory',
392 'Id' => 'Id',
393 'Name' => 'Caption',
394 'Filter' => '1',
395 ),
396 'TCountry' => array(
397 'Type' => 'Reference',
398 'Table' => 'Country',
399 'Id' => 'Id',
400 'Name' => 'Name',
401 'Filter' => '1',
402 ),
403 'TSubject' => array(
404 'Type' => 'Reference',
405 'Table' => 'Subject',
406 'Id' => 'Id',
407 'Name' => 'Name',
408 'Filter' => '1',
409 ),
410 'TFinanceTreasury' => array(
411 'Type' => 'Reference',
412 'Table' => 'FinanceTreasury',
413 'Id' => 'Id',
414 'Name' => 'Name',
415 'Filter' => '1',
416 ),
417 'TFinanceBankAccount' => array(
418 'Type' => 'Reference',
419 'Table' => 'FinanceBankAccount',
420 'Id' => 'Id',
421 'Name' => 'Comment',
422 'Filter' => '1',
423 ),
424 'TNewsList' => array(
425 'Type' => 'ManyToOne',
426 'Table' => 'News',
427 'Id' => 'Id',
428 'Ref' => 'Category',
429 'Filter' => '1',
430 ),
431 'TTaskList' => array(
432 'Type' => 'ManyToOne',
433 'Table' => 'Task',
434 'Id' => 'Id',
435 'Ref' => 'Group',
436 'Filter' => '1',
437 ),
438 'TDeviceList' => array(
439 'Type' => 'ManyToOne',
440 'Table' => 'NetworkDevice',
441 'Id' => 'Id',
442 'Ref' => 'Member',
443 'Filter' => '1',
444 ),
445 'TDeviceListAPI' => array(
446 'Type' => 'ManyToOne',
447 'Table' => 'NetworkDevice',
448 'Id' => 'Id',
449 'Ref' => 'API',
450 'Filter' => '1',
451 ),
452 'TNetworkInterfaceWirelessListInterface' => array(
453 'Type' => 'ManyToOne',
454 'Table' => 'NetworkInterfaceWireless',
455 'Id' => 'Id',
456 'Ref' => 'NetworkInterface',
457 'Filter' => '1',
458 ),
459 'TInterfaceList' => array(
460 'Type' => 'ManyToOne',
461 'Table' => 'NetworkInterface',
462 'Id' => 'Id',
463 'Ref' => 'Device',
464 'Filter' => '1',
465 ),
466 'TProduct' => array(
467 'Type' => 'Reference',
468 'Table' => 'Product',
469 'Id' => 'Id',
470 'Name' => 'Name',
471 'Filter' => '1',
472 ),
473 'TTaskGroup' => array(
474 'Type' => 'Reference',
475 'Table' => 'TaskGroup',
476 'Id' => 'Id',
477 'Name' => 'Name',
478 'Filter' => '1',
479 ),
480 'TStock' => array(
481 'Type' => 'Reference',
482 'Table' => 'Stock',
483 'Id' => 'Id',
484 'Name' => 'Name',
485 'Filter' => '1',
486 ),
487 'TStockSerialNumber' => array(
488 'Type' => 'Reference',
489 'Table' => 'StockSerialNumber',
490 'Id' => 'Id',
491 'Name' => 'RegNumber',
492 'Filter' => '1',
493 ),
494 'TFinanceBank' => array(
495 'Type' => 'Reference',
496 'Table' => 'FinanceBank',
497 'Id' => 'Id',
498 'Name' => 'CONCAT(Name, " (", Code, ")")',
499 'Filter' => '1',
500 ),
501 'TUnitOfMeasure' => array(
502 'Type' => 'Reference',
503 'Table' => 'UnitOfMeasure',
504 'Id' => 'Id',
505 'Name' => 'Name',
506 'Filter' => '1',
507 ),
508 'TLanguage' => array(
509 'Type' => 'Reference',
510 'Table' => 'Language',
511 'Id' => 'Id',
512 'Name' => 'Name',
513 'Filter' => '1',
514 ),
515 'TAction' => array(
516 'Type' => 'Reference',
517 'Table' => 'Action',
518 'Id' => 'Id',
519 'Name' => 'Title',
520 'Filter' => '1',
521 ),
522 'TActionIcon' => array(
523 'Type' => 'Reference',
524 'Table' => 'ActionIcon',
525 'Id' => 'Id',
526 'Name' => 'Name',
527 'Filter' => '1',
528 ),
529 'TActionType' => array(
530 'Type' => 'Reference',
531 'Table' => 'ActionType',
532 'Id' => 'Id',
533 'Name' => 'Name',
534 'Filter' => '1',
535 ),
536 'TActionGroup' => array(
537 'Type' => 'Reference',
538 'Table' => 'ActionGroup',
539 'Id' => 'Id',
540 'Name' => 'Name',
541 'Filter' => '1',
542 ),
543 'TTVGroup' => array(
544 'Type' => 'Reference',
545 'Table' => 'TVGroup',
546 'Id' => 'Id',
547 'Name' => 'Name',
548 'Filter' => '1',
549 ),
550 'TStockSerialNumberListStock' => array(
551 'Type' => 'ManyToOne',
552 'Table' => 'StockSerialNumber',
553 'Id' => 'Id',
554 'Ref' => 'Stock',
555 'Filter' => '1',
556 ),
557 'TStockSerialNumberListProduct' => array(
558 'Type' => 'ManyToOne',
559 'Table' => 'StockSerialNumber',
560 'Id' => 'Id',
561 'Ref' => 'Product',
562 'Filter' => '1',
563 ),
564 'TNetworkDeviceListProduct' => array(
565 'Type' => 'ManyToOne',
566 'Table' => 'NetworkDevice',
567 'Id' => 'Id',
568 'Ref' => 'Product',
569 'Filter' => '1',
570 ),
571 'TDocumentLine' => array(
572 'Type' => 'Reference',
573 'Table' => 'DocumentLine',
574 'Id' => 'Id',
575 'Name' => 'Name',
576 'Filter' => '1',
577 ),
578 'TFinanceYear' => array(
579 'Type' => 'Reference',
580 'Table' => 'FinanceYear',
581 'Id' => 'Id',
582 'Name' => 'Year',
583 'Filter' => '1',
584 ),
585 'TTask' => array(
586 'Type' => 'Reference',
587 'Table' => 'Task',
588 'Id' => 'Id',
589 'Name' => 'Name',
590 'Filter' => '1',
591 ),
592 'TCurrency' => array(
593 'Type' => 'Reference',
594 'Table' => 'Currency',
595 'Id' => 'Id',
596 'Name' => 'Code',
597 'Filter' => '1',
598 ),
599 'TMenuItem' => array(
600 'Type' => 'Reference',
601 'Table' => 'MenuItem',
602 'Id' => 'Id',
603 'Name' => 'Name',
604 'Filter' => '1',
605 ),
606 'TMenu' => array(
607 'Type' => 'Reference',
608 'Table' => 'Menu',
609 'Id' => 'Id',
610 'Name' => 'Name',
611 'Filter' => '1',
612 ),
613 'TDeviceAPIType' => array(
614 'Type' => 'Reference',
615 'Table' => 'DeviceAPIType',
616 'Id' => 'Id',
617 'Name' => 'Name',
618 'Filter' => '1',
619 ),
620 'TFinanceInvoice' => array(
621 'Type' => 'Reference',
622 'Table' => 'FinanceInvoice',
623 'Id' => 'Id',
624 'Name' => 'BillCode',
625 'Filter' => '1',
626 ),
627 'TFinanceOperation' => array(
628 'Type' => 'Reference',
629 'Table' => 'FinanceOperation',
630 'Id' => 'Id',
631 'Name' => 'BillCode',
632 'Filter' => '1',
633 ),
634 'TPermissionGroup' => array(
635 'Type' => 'Reference',
636 'Table' => 'PermissionGroup',
637 'Id' => 'Id',
638 'Name' => 'Description',
639 'Filter' => '1',
640 ),
641 'TPermissionGroupAssignment' => array(
642 'Type' => 'Reference',
643 'Table' => 'PermissionGroupAssignment',
644 'Id' => 'Id',
645 'Name' => 'Id',
646 'Filter' => '1',
647 ),
648 'TPermissionOperation' => array(
649 'Type' => 'Reference',
650 'Table' => 'PermissionOperation',
651 'Id' => 'Id',
652 'Name' => 'Id',
653 'Filter' => '1',
654 ),
655 'TFinanceCharge' => array(
656 'Type' => 'Reference',
657 'Table' => 'FinanceCharge',
658 'Id' => 'Id',
659 'Name' => 'Id',
660 'Filter' => '1',
661 ),
662 'TDocumentLineSequenceListYear' => array(
663 'Type' => 'ManyToOne',
664 'Table' => 'DocumentLineSequence',
665 'Id' => 'Id',
666 'Ref' => 'FinanceYear',
667 'Filter' => '1',
668 ),
669 'TDocumentLineSequenceListLine' => array(
670 'Type' => 'ManyToOne',
671 'Table' => 'DocumentLineSequence',
672 'Id' => 'Id',
673 'Ref' => 'DocumentLine',
674 'Filter' => '1',
675 ),
676 'TWorkListTask' => array(
677 'Type' => 'ManyToOne',
678 'Table' => 'Work',
679 'Id' => 'Id',
680 'Ref' => 'Task',
681 'Filter' => '1',
682 ),
683 'TUserCustomerRelListUser' => array(
684 'Type' => 'ManyToOne',
685 'Table' => 'UserCustomerRel',
686 'Id' => 'Id',
687 'Ref' => 'User',
688 'Filter' => '1',
689 ),
690 'TUserCustomerRelListCustomer' => array(
691 'Type' => 'ManyToOne',
692 'Table' => 'UserCustomerRel',
693 'Id' => 'Id',
694 'Ref' => 'Customer',
695 'Filter' => '1',
696 ),
697 'TFinanceInvoiceOperationRelListInvoice' => array(
698 'Type' => 'ManyToOne',
699 'Table' => 'FinanceInvoiceOperationRel',
700 'Id' => 'Id',
701 'Ref' => 'Invoice',
702 'Filter' => '1',
703 ),
704 'TFinanceInvoiceOperationRelListOperation' => array(
705 'Type' => 'ManyToOne',
706 'Table' => 'FinanceInvoiceOperationRel',
707 'Id' => 'Id',
708 'Ref' => 'Operation',
709 'Filter' => '1',
710 ),
711 'TServiceCustomerRelListCustomer' => array(
712 'Type' => 'ManyToOne',
713 'Table' => 'ServiceCustomerRel',
714 'Id' => 'Id',
715 'Ref' => 'Customer',
716 'Filter' => '1',
717 ),
718 'TServiceCustomerRelListService' => array(
719 'Type' => 'ManyToOne',
720 'Table' => 'ServiceCustomerRel',
721 'Id' => 'Id',
722 'Ref' => 'Service',
723 'Filter' => '1',
724 ),
725 'TCustomerStockSerialNumber' => array(
726 'Type' => 'ManyToOne',
727 'Table' => 'StockSerialNumber',
728 'Id' => 'Id',
729 'Ref' => 'Location',
730 'Filter' => '1',
731 ),
732 'TPermissionUserAssignmentListUser' => array(
733 'Type' => 'ManyToOne',
734 'Table' => 'PermissionUserAssignment',
735 'Id' => 'Id',
736 'Ref' => 'User',
737 'Filter' => '1',
738 ),
739 'TPermissionGroupAssignmentListGroup' => array(
740 'Type' => 'ManyToOne',
741 'Table' => 'PermissionGroupAssignment',
742 'Id' => 'Id',
743 'Ref' => 'Group',
744 'Filter' => '1',
745 ),
746 'TPermissionGroupAssignmentListOperation' => array(
747 'Type' => 'ManyToOne',
748 'Table' => 'PermissionGroupAssignment',
749 'Id' => 'Id',
750 'Ref' => 'AssignedOperation',
751 'Filter' => '1',
752 ),
753 'TPermissionGroupAssignmentListAssignedGroup' => array(
754 'Type' => 'ManyToOne',
755 'Table' => 'PermissionGroupAssignment',
756 'Id' => 'Id',
757 'Ref' => 'AssignedGroup',
758 'Filter' => '1',
759 ),
760 'TServiceListServiceCategory' => array(
761 'Type' => 'ManyToOne',
762 'Table' => 'Service',
763 'Id' => 'Id',
764 'Ref' => 'Category',
765 'Filter' => '1',
766 ),
767 'TNetworkLinkListInterface1' => array(
768 'Type' => 'ManyToOne',
769 'Table' => 'NetworkLink',
770 'Id' => 'Id',
771 'Ref' => 'Interface1',
772 'Filter' => '1',
773 ),
774 'TNetworkLinkListInterface2' => array(
775 'Type' => 'ManyToOne',
776 'Table' => 'NetworkLink',
777 'Id' => 'Id',
778 'Ref' => 'Interface2',
779 'Filter' => '1',
780 ),
781 'TNetworkInterfaceUpDown' => array(
782 'Type' => 'ManyToOne',
783 'Table' => 'NetworkInterfaceUpDown',
784 'Id' => 'Id',
785 'Ref' => 'Interface',
786 'Filter' => '1',
787 ),
788 'TNetworkSignalListInterface' => array(
789 'Type' => 'ManyToOne',
790 'Table' => 'NetworkSignal',
791 'Id' => 'Id',
792 'Ref' => 'Interface',
793 'Filter' => '1',
794 ),
795 'TFinanceInvoiceItemListInvoice' => array(
796 'Type' => 'ManyToOne',
797 'Table' => 'FinanceInvoiceItem',
798 'Id' => 'Id',
799 'Ref' => 'FinanceInvoice',
800 'Filter' => '1',
801 ),
802 'TFinanceOperationListAccount' => array(
803 'Type' => 'ManyToOne',
804 'Table' => 'FinanceOperation',
805 'Id' => 'Id',
806 'Ref' => 'BankAccount',
807 'Filter' => '1',
808 ),
809 'TFinanceOperationListSubject' => array(
810 'Type' => 'ManyToOne',
811 'Table' => 'FinanceOperation',
812 'Id' => 'Id',
813 'Ref' => 'Subject',
814 'Filter' => '1',
815 ),
816 'TFinanceInvoiceListSubject' => array(
817 'Type' => 'ManyToOne',
818 'Table' => 'FinanceInvoice',
819 'Id' => 'Id',
820 'Ref' => 'Subject',
821 'Filter' => '1',
822 ),
823 'TMenuItemListMenu' => array(
824 'Type' => 'ManyToOne',
825 'Table' => 'MenuItem',
826 'Id' => 'Id',
827 'Ref' => 'Menu',
828 'Filter' => '1',
829 ),
830 'TMenuItemListParent' => array(
831 'Type' => 'ManyToOne',
832 'Table' => 'MenuItem',
833 'Id' => 'Id',
834 'Ref' => 'Parent',
835 'Filter' => '1',
836 ),
837 'TActionListGroup' => array(
838 'Type' => 'ManyToOne',
839 'Table' => 'Action',
840 'Id' => 'Id',
841 'Ref' => 'Group',
842 'Filter' => '1',
843 ),
844 'TFinanceOperationListTreasury' => array(
845 'Type' => 'ManyToOne',
846 'Table' => 'FinanceOperation',
847 'Id' => 'Id',
848 'Ref' => 'Treasury',
849 'Filter' => '1',
850 ),
851 'TActionListIcon' => array(
852 'Type' => 'ManyToOne',
853 'Table' => 'Action',
854 'Id' => 'Id',
855 'Ref' => 'Icon',
856 'Filter' => '1',
857 ),
858 'TActionListType' => array(
859 'Type' => 'ManyToOne',
860 'Table' => 'Action',
861 'Id' => 'Id',
862 'Ref' => 'Type',
863 'Filter' => '1',
864 ),
865 'TStockSerialNumberListStockSerialNumber' => array(
866 'Type' => 'ManyToOne',
867 'Table' => 'StockSerialNumber',
868 'Id' => 'Id',
869 'Ref' => 'Esemble',
870 'Filter' => '1',
871 ),
872 'TCustomerListBillingPeriod' => array(
873 'Type' => 'ManyToOne',
874 'Table' => 'Member',
875 'Id' => 'Id',
876 'Ref' => 'BillingPeriod',
877 'Filter' => '1',
878 ),
879 'TTVListCategory' => array(
880 'Type' => 'ManyToOne',
881 'Table' => 'TV',
882 'Id' => 'Id',
883 'Ref' => 'Category',
884 'Filter' => '1',
885 ),
886 'TFinanceOperationListDocumentLine' => array(
887 'Type' => 'ManyToOne',
888 'Table' => 'FinanceOperation',
889 'Id' => 'Id',
890 'Ref' => 'DocumentLine',
891 'Filter' => '1',
892 ),
893 'TFinanceInvoiceListDocumentLine' => array(
894 'Type' => 'ManyToOne',
895 'Table' => 'FinanceInvoice',
896 'Id' => 'Id',
897 'Ref' => 'DocumentLine',
898 'Filter' => '1',
899 ),
900);
901}
Note: See TracBrowser for help on using the repository browser.