dbxapp 4.1.3
CMS, Shop, Workflows und modulare Geschäftsanwendungen
Loading...
Searching...
No Matches
invoice.dd.php
Go to the documentation of this file.
1<?php
2
3/* =========================================================
4 TABLE
5 ========================================================= */
6$table['server']='myInvoices|myInvoices.db3';
7$table['table']='invoice';
8$table['datadic']='invoice';
9$table['primary']='id';
10$table['language']='0';
11$table['version']='1.0';
12$table['autosync']='1';
13$table['cache']='0';
14$table['trash']='0';
15$table['trace']='0';
16$table['update_sql']='';
17$table['default_sort']='invoice_date DESC, invoice_no DESC';
18$table['form-dd-table']='';
19$table['read']='admin';
20$table['create']='admin';
21$table['update']='admin';
22$table['delete']='admin';
23$table['read_owner']='admin,owner';
24$table['create_owner']='admin,owner';
25$table['update_owner']='admin,owner';
26$table['delete_owner']='admin,owner';
27
28
29/* =========================================================
30 FIELDS
31 ========================================================= */
32$field['name']='id';
33$field['type']='int';
34$field['index']='PRI';
35$field['length']='11';
36$field['default']='';
37$field['label']='ID';
38$field['rules']='int';
39$field['tooltip']='';
40$field['errormsg']='';
41$field['placeholder']='';
42$field['convert']='';
43$field['protect']='0';
44$field['group']='';
45$field['mask']='';
46$field['data']='';
47$field['options']='';
48$field['tpl']='hidden';
49$field['js']='';
50$field['prompt']='';
51$fields[]=$field;
52
53$field['name']='create_date';
54$field['type']='datetime';
55$field['index']='MUL';
56$field['length']='-1';
57$field['default']='';
58$field['label']='Erstellt';
59$field['rules']='datetime';
60$field['tooltip']='';
61$field['errormsg']='';
62$field['placeholder']='';
63$field['convert']='date_time';
64$field['protect']='0';
65$field['group']='';
66$field['mask']='';
67$field['data']='';
68$field['options']='';
69$field['tpl']='hidden';
70$field['js']='';
71$field['prompt']='';
72$fields[]=$field;
73
74$field['name']='create_uid';
75$field['type']='int';
76$field['index']='MUL';
77$field['length']='11';
78$field['default']='0';
79$field['label']='Erstellt von';
80$field['rules']='int';
81$field['tooltip']='';
82$field['errormsg']='';
83$field['placeholder']='';
84$field['convert']='';
85$field['protect']='0';
86$field['group']='';
87$field['mask']='';
88$field['data']='';
89$field['options']='';
90$field['tpl']='hidden';
91$field['js']='';
92$field['prompt']='';
93$fields[]=$field;
94
95$field['name']='update_date';
96$field['type']='datetime';
97$field['index']='MUL';
98$field['length']='-1';
99$field['default']='';
100$field['label']='Aktualisiert';
101$field['rules']='datetime';
102$field['tooltip']='';
103$field['errormsg']='';
104$field['placeholder']='';
105$field['convert']='date_time';
106$field['protect']='0';
107$field['group']='';
108$field['mask']='';
109$field['data']='';
110$field['options']='';
111$field['tpl']='hidden';
112$field['js']='';
113$field['prompt']='';
114$fields[]=$field;
115
116$field['name']='update_uid';
117$field['type']='int';
118$field['index']='MUL';
119$field['length']='11';
120$field['default']='0';
121$field['label']='Aktualisiert von';
122$field['rules']='int';
123$field['tooltip']='';
124$field['errormsg']='';
125$field['placeholder']='';
126$field['convert']='';
127$field['protect']='0';
128$field['group']='';
129$field['mask']='';
130$field['data']='';
131$field['options']='';
132$field['tpl']='hidden';
133$field['js']='';
134$field['prompt']='';
135$fields[]=$field;
136
137$field['name']='owner';
138$field['type']='int';
139$field['index']='MUL';
140$field['length']='11';
141$field['default']='0';
142$field['label']='Owner';
143$field['rules']='int';
144$field['tooltip']='';
145$field['errormsg']='';
146$field['placeholder']='';
147$field['convert']='';
148$field['protect']='0';
149$field['group']='';
150$field['mask']='';
151$field['data']='';
152$field['options']='';
153$field['tpl']='hidden';
154$field['js']='';
155$field['prompt']='';
156$fields[]=$field;
157
158$field['name']='invoice_no';
159$field['type']='varchar';
160$field['index']='UNI';
161$field['length']='40';
162$field['default']='';
163$field['label']='Rechnungsnummer';
164$field['rules']='parameter|min=2|max=40';
165$field['tooltip']='';
166$field['errormsg']='';
167$field['placeholder']='';
168$field['convert']='';
169$field['protect']='0';
170$field['group']='';
171$field['mask']='';
172$field['data']='';
173$field['options']='';
174$field['tpl']='text-label';
175$field['js']='';
176$field['prompt']='';
177$fields[]=$field;
178
179$field['name']='invoice_date';
180$field['type']='date';
181$field['index']='MUL';
182$field['length']='-1';
183$field['default']='';
184$field['label']='Rechnungsdatum';
185$field['rules']='date';
186$field['tooltip']='';
187$field['errormsg']='';
188$field['placeholder']='';
189$field['convert']='date';
190$field['protect']='0';
191$field['group']='';
192$field['mask']='';
193$field['data']='';
194$field['options']='';
195$field['tpl']='date-label';
196$field['js']='';
197$field['prompt']='';
198$fields[]=$field;
199
200$field['name']='customer';
201$field['type']='varchar';
202$field['index']='MUL';
203$field['length']='180';
204$field['default']='';
205$field['label']='Kunde';
206$field['rules']='*|min=2|max=180';
207$field['tooltip']='';
208$field['errormsg']='';
209$field['placeholder']='';
210$field['convert']='';
211$field['protect']='0';
212$field['group']='';
213$field['mask']='';
214$field['data']='';
215$field['options']='';
216$field['tpl']='text-label';
217$field['js']='';
218$field['prompt']='';
219$fields[]=$field;
220
221$field['name']='status';
222$field['type']='varchar';
223$field['index']='MUL';
224$field['length']='24';
225$field['default']='draft';
226$field['label']='Status';
227$field['rules']='parameter|max=24';
228$field['tooltip']='';
229$field['errormsg']='';
230$field['placeholder']='';
231$field['convert']='';
232$field['protect']='0';
233$field['group']='';
234$field['mask']='';
235$field['data']='';
236$field['options']='draft=Entwurf&open=Offen&paid=Bezahlt';
237$field['tpl']='select-single-label';
238$field['js']='';
239$field['prompt']='';
240$fields[]=$field;
241
242$field['name']='total_gross';
243$field['type']='decimal';
244$field['index']='';
245$field['length']='12,2';
246$field['default']='0';
247$field['label']='Rechnungssumme';
248$field['rules']='decimal';
249$field['tooltip']='';
250$field['errormsg']='';
251$field['placeholder']='';
252$field['convert']='';
253$field['protect']='0';
254$field['group']='';
255$field['mask']='';
256$field['data']='';
257$field['options']='';
258$field['tpl']='hidden';
259$field['js']='';
260$field['prompt']='';
261$fields[]=$field;
262
263
264/* =========================================================
265 INDEXES
266 ========================================================= */
267$index['name']='pk_invoice';
268$index['type']='PRIMARY';
269$index['fields']='id';
270$index['unique']='1';
271$index['comment']='from field index PRI';
272$indexes[]=$index;
273
274$index['name']='idx_invoice_create_date';
275$index['type']='INDEX';
276$index['fields']='create_date';
277$index['unique']='0';
278$index['comment']='from field index MUL';
279$indexes[]=$index;
280
281$index['name']='idx_invoice_create_uid';
282$index['type']='INDEX';
283$index['fields']='create_uid';
284$index['unique']='0';
285$index['comment']='from field index MUL';
286$indexes[]=$index;
287
288$index['name']='idx_invoice_update_date';
289$index['type']='INDEX';
290$index['fields']='update_date';
291$index['unique']='0';
292$index['comment']='from field index MUL';
293$indexes[]=$index;
294
295$index['name']='idx_invoice_update_uid';
296$index['type']='INDEX';
297$index['fields']='update_uid';
298$index['unique']='0';
299$index['comment']='from field index MUL';
300$indexes[]=$index;
301
302$index['name']='idx_invoice_owner';
303$index['type']='INDEX';
304$index['fields']='owner';
305$index['unique']='0';
306$index['comment']='from field index MUL';
307$indexes[]=$index;
308
309$index['name']='uidx_invoice_invoice_no';
310$index['type']='UNIQUE';
311$index['fields']='invoice_no';
312$index['unique']='1';
313$index['comment']='from field index UNI';
314$indexes[]=$index;
315
316$index['name']='idx_invoice_invoice_date';
317$index['type']='INDEX';
318$index['fields']='invoice_date';
319$index['unique']='0';
320$index['comment']='from field index MUL';
321$indexes[]=$index;
322
323$index['name']='idx_invoice_customer';
324$index['type']='INDEX';
325$index['fields']='customer';
326$index['unique']='0';
327$index['comment']='from field index MUL';
328$indexes[]=$index;
329
330$index['name']='idx_invoice_status';
331$index['type']='INDEX';
332$index['fields']='status';
333$index['unique']='0';
334$index['comment']='from field index MUL';
335$indexes[]=$index;
$table
$table['server']
Definition .dd.php:6
$indexes
$indexes[]
Definition .dd.php:167
$index
$index
Definition dbxDocsPortal_contract_test.php:42
$fields
$fields
Definition dbxForm_fd_language_messages_test.php:204