dbXapp 2.0
RAD, CMS, Module und Runtime-IDE fuer dbXapp
Loading...
Searching...
No Matches
contactRequest.dd.php
Go to the documentation of this file.
1<?php
2
3/* =========================================================
4 TABLE
5 ========================================================= */
6$table['server']='dbxContact|dbxContact.db3';
7$table['table']='contact_request';
8$table['datadic']='contactRequest';
9$table['primary']='id';
10$table['language']='0';
11$table['version']='2.0';
12$table['autosync']='1';
13$table['cache']='0';
14$table['trash']='1';
15$table['trace']='1';
16$table['update_sql']='';
17$table['default_sort']='create_date DESC';
18$table['form-dd-table']='';
19$table['read']='admin';
20$table['create']='*';
21$table['update']='admin';
22$table['delete']='admin';
23$table['read_owner']='owner,admin';
24$table['create_owner']='owner,admin';
25$table['update_owner']='admin';
26$table['delete_owner']='admin';
27
28/* =========================================================
29 FIELDS
30 ========================================================= */
31$field=array();
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=array();
54$field['name']='priority';
55$field['type']='varchar';
56$field['index']='MUL';
57$field['length']='16';
58$field['default']='normal';
59$field['label']='Prioritaet';
60$field['rules']='parameter|max=16';
61$field['tooltip']='Prioritaet der Bearbeitung';
62$field['errormsg']='';
63$field['placeholder']='';
64$field['convert']='';
65$field['protect']='0';
66$field['group']='';
67$field['mask']='';
68$field['data']='';
69$field['options']='low=Niedrig&normal=Normal&high=Hoch&urgent=Dringend';
70$field['tpl']='select-single-label';
71$field['js']='';
72$field['prompt']='';
73$fields[]=$field;
74
75$field=array();
76$field['name']='assigned_uid';
77$field['type']='int';
78$field['index']='MUL';
79$field['length']='11';
80$field['default']='0';
81$field['label']='Zugewiesen an';
82$field['rules']='int';
83$field['tooltip']='Bearbeitender Administrator';
84$field['errormsg']='';
85$field['placeholder']='';
86$field['convert']='';
87$field['protect']='0';
88$field['group']='';
89$field['mask']='';
90$field['data']='';
91$field['options']='';
92$field['tpl']='hidden';
93$field['js']='';
94$field['prompt']='';
95$fields[]=$field;
96
97$field=array();
98$field['name']='last_activity_date';
99$field['type']='datetime';
100$field['index']='MUL';
101$field['length']='-1';
102$field['default']='';
103$field['label']='Letzte Aktivitaet';
104$field['rules']='datetime';
105$field['tooltip']='';
106$field['errormsg']='';
107$field['placeholder']='';
108$field['convert']='date_time';
109$field['protect']='0';
110$field['group']='';
111$field['mask']='';
112$field['data']='';
113$field['options']='';
114$field['tpl']='hidden';
115$field['js']='';
116$field['prompt']='';
117$fields[]=$field;
118
119$field=array();
120$field['name']='closed_date';
121$field['type']='datetime';
122$field['index']='';
123$field['length']='-1';
124$field['default']='';
125$field['label']='Geschlossen am';
126$field['rules']='datetime';
127$field['tooltip']='';
128$field['errormsg']='';
129$field['placeholder']='';
130$field['convert']='date_time';
131$field['protect']='0';
132$field['group']='';
133$field['mask']='';
134$field['data']='';
135$field['options']='';
136$field['tpl']='hidden';
137$field['js']='';
138$field['prompt']='';
139$fields[]=$field;
140
141$field=array();
142$field['name']='user_hidden';
143$field['type']='int';
144$field['index']='MUL';
145$field['length']='1';
146$field['default']='0';
147$field['label']='Vom Benutzer geloescht';
148$field['rules']='int';
149$field['tooltip']='Blendet das Ticket nur fuer den Anfragenden aus';
150$field['errormsg']='';
151$field['placeholder']='';
152$field['convert']='';
153$field['protect']='0';
154$field['group']='';
155$field['mask']='';
156$field['data']='';
157$field['options']='';
158$field['tpl']='hidden';
159$field['js']='';
160$field['prompt']='';
161$fields[]=$field;
162
163$field=array();
164$field['name']='user_hidden_date';
165$field['type']='datetime';
166$field['index']='';
167$field['length']='-1';
168$field['default']='';
169$field['label']='Benutzer-Loeschung am';
170$field['rules']='datetime';
171$field['tooltip']='';
172$field['errormsg']='';
173$field['placeholder']='';
174$field['convert']='date_time';
175$field['protect']='0';
176$field['group']='';
177$field['mask']='';
178$field['data']='';
179$field['options']='';
180$field['tpl']='hidden';
181$field['js']='';
182$field['prompt']='';
183$fields[]=$field;
184
185$field=array();
186$field['name']='create_date';
187$field['type']='datetime';
188$field['index']='';
189$field['length']='-1';
190$field['default']='';
191$field['label']='Datum';
192$field['rules']='datetime';
193$field['tooltip']='';
194$field['errormsg']='';
195$field['placeholder']='';
196$field['convert']='date_time';
197$field['protect']='0';
198$field['group']='';
199$field['mask']='';
200$field['data']='';
201$field['options']='';
202$field['tpl']='hidden';
203$field['js']='';
204$field['prompt']='';
205$fields[]=$field;
206
207$field=array();
208$field['name']='create_uid';
209$field['type']='int';
210$field['index']='MUL';
211$field['length']='11';
212$field['default']='0';
213$field['label']='Erstellt von';
214$field['rules']='int';
215$field['tooltip']='';
216$field['errormsg']='';
217$field['placeholder']='';
218$field['convert']='';
219$field['protect']='0';
220$field['group']='';
221$field['mask']='';
222$field['data']='';
223$field['options']='';
224$field['tpl']='hidden';
225$field['js']='';
226$field['prompt']='';
227$fields[]=$field;
228
229$field=array();
230$field['name']='update_date';
231$field['type']='datetime';
232$field['index']='';
233$field['length']='-1';
234$field['default']='';
235$field['label']='Aktualisiert';
236$field['rules']='datetime';
237$field['tooltip']='';
238$field['errormsg']='';
239$field['placeholder']='';
240$field['convert']='date_time';
241$field['protect']='0';
242$field['group']='';
243$field['mask']='';
244$field['data']='';
245$field['options']='';
246$field['tpl']='hidden';
247$field['js']='';
248$field['prompt']='';
249$fields[]=$field;
250
251$field=array();
252$field['name']='update_uid';
253$field['type']='int';
254$field['index']='MUL';
255$field['length']='11';
256$field['default']='0';
257$field['label']='Aktualisiert von';
258$field['rules']='int';
259$field['tooltip']='';
260$field['errormsg']='';
261$field['placeholder']='';
262$field['convert']='';
263$field['protect']='0';
264$field['group']='';
265$field['mask']='';
266$field['data']='';
267$field['options']='';
268$field['tpl']='hidden';
269$field['js']='';
270$field['prompt']='';
271$fields[]=$field;
272
273$field=array();
274$field['name']='owner';
275$field['type']='int';
276$field['index']='MUL';
277$field['length']='11';
278$field['default']='0';
279$field['label']='Owner';
280$field['rules']='int';
281$field['tooltip']='';
282$field['errormsg']='';
283$field['placeholder']='';
284$field['convert']='';
285$field['protect']='0';
286$field['group']='';
287$field['mask']='';
288$field['data']='';
289$field['options']='';
290$field['tpl']='hidden';
291$field['js']='';
292$field['prompt']='';
293$fields[]=$field;
294
295$field=array();
296$field['name']='trash';
297$field['type']='int';
298$field['index']='MUL';
299$field['length']='1';
300$field['default']='0';
301$field['label']='Trash';
302$field['rules']='int';
303$field['tooltip']='';
304$field['errormsg']='';
305$field['placeholder']='';
306$field['convert']='';
307$field['protect']='0';
308$field['group']='';
309$field['mask']='';
310$field['data']='';
311$field['options']='';
312$field['tpl']='hidden';
313$field['js']='';
314$field['prompt']='';
315$fields[]=$field;
316
317$field=array();
318$field['name']='uid';
319$field['type']='int';
320$field['index']='MUL';
321$field['length']='11';
322$field['default']='0';
323$field['label']='Benutzer';
324$field['rules']='int';
325$field['tooltip']='Angemeldeter Benutzer der Anfrage. 0 bedeutet Gast.';
326$field['errormsg']='';
327$field['placeholder']='';
328$field['convert']='';
329$field['protect']='0';
330$field['group']='';
331$field['mask']='';
332$field['data']='';
333$field['options']='';
334$field['tpl']='hidden';
335$field['js']='';
336$field['prompt']='';
337$fields[]=$field;
338
339$field=array();
340$field['name']='status';
341$field['type']='varchar';
342$field['index']='MUL';
343$field['length']='24';
344$field['default']='open';
345$field['label']='Status';
346$field['rules']='parameter|max=24';
347$field['tooltip']='Bearbeitungsstatus der Kontaktanfrage';
348$field['errormsg']='';
349$field['placeholder']='';
350$field['convert']='';
351$field['protect']='0';
352$field['group']='';
353$field['mask']='';
354$field['data']='';
355$field['options']='open=Offen&in_progress=In Bearbeitung&waiting_customer=Rueckfrage&answered=Beantwortet&closed=Geschlossen';
356$field['tpl']='select-single-label';
357$field['js']='';
358$field['prompt']='';
359$fields[]=$field;
360
361$field=array();
362$field['name']='name';
363$field['type']='varchar';
364$field['index']='MUL';
365$field['length']='160';
366$field['default']='';
367$field['label']='Name';
368$field['rules']='words|min=2|max=160';
369$field['tooltip']='Ihr Name';
370$field['errormsg']='Bitte einen Namen eintragen.';
371$field['placeholder']='Ihr Name';
372$field['convert']='';
373$field['protect']='0';
374$field['group']='';
375$field['mask']='';
376$field['data']='';
377$field['options']='';
378$field['tpl']='text-label';
379$field['js']='';
380$field['prompt']='';
381$fields[]=$field;
382
383$field=array();
384$field['name']='email';
385$field['type']='varchar';
386$field['index']='MUL';
387$field['length']='180';
388$field['default']='';
389$field['label']='E-Mail';
390$field['rules']='email|max=180';
391$field['tooltip']='Antwortadresse';
392$field['errormsg']='Bitte eine gueltige E-Mail-Adresse eintragen.';
393$field['placeholder']='name@example.org';
394$field['convert']='';
395$field['protect']='0';
396$field['group']='';
397$field['mask']='';
398$field['data']='';
399$field['options']='';
400$field['tpl']='text-label';
401$field['js']='';
402$field['prompt']='';
403$fields[]=$field;
404
405$field=array();
406$field['name']='phone';
407$field['type']='varchar';
408$field['index']='';
409$field['length']='80';
410$field['default']='';
411$field['label']='Telefon';
412$field['rules']='varchar|max=80';
413$field['tooltip']='Optionale Rueckrufnummer';
414$field['errormsg']='';
415$field['placeholder']='optional';
416$field['convert']='';
417$field['protect']='0';
418$field['group']='';
419$field['mask']='';
420$field['data']='';
421$field['options']='';
422$field['tpl']='text-label';
423$field['js']='';
424$field['prompt']='';
425$fields[]=$field;
426
427$field=array();
428$field['name']='subject';
429$field['type']='varchar';
430$field['index']='MUL';
431$field['length']='220';
432$field['default']='';
433$field['label']='Betreff';
434$field['rules']='varchar|min=3|max=220';
435$field['tooltip']='Worum geht es?';
436$field['errormsg']='Bitte einen Betreff eintragen.';
437$field['placeholder']='Betreff';
438$field['convert']='';
439$field['protect']='0';
440$field['group']='';
441$field['mask']='';
442$field['data']='';
443$field['options']='';
444$field['tpl']='text-label';
445$field['js']='';
446$field['prompt']='';
447$fields[]=$field;
448
449$field=array();
450$field['name']='message';
451$field['type']='mediumtext';
452$field['index']='';
453$field['length']='-1';
454$field['default']='';
455$field['label']='Nachricht';
456$field['rules']='*|min=8|max=5000';
457$field['tooltip']='Ihre Nachricht';
458$field['errormsg']='Bitte eine Nachricht mit mindestens 8 Zeichen eintragen.';
459$field['placeholder']='Ihre Nachricht';
460$field['convert']='';
461$field['protect']='0';
462$field['group']='';
463$field['mask']='';
464$field['data']='rows=8';
465$field['options']='';
466$field['tpl']='textarea-label';
467$field['js']='';
468$field['prompt']='';
469$fields[]=$field;
470
471$field=array();
472$field['name']='request_ip';
473$field['type']='varchar';
474$field['index']='';
475$field['length']='64';
476$field['default']='';
477$field['label']='IP';
478$field['rules']='varchar|max=64';
479$field['tooltip']='';
480$field['errormsg']='';
481$field['placeholder']='';
482$field['convert']='';
483$field['protect']='0';
484$field['group']='';
485$field['mask']='';
486$field['data']='';
487$field['options']='';
488$field['tpl']='hidden';
489$field['js']='';
490$field['prompt']='';
491$fields[]=$field;
492
493$field=array();
494$field['name']='request_user_agent';
495$field['type']='varchar';
496$field['index']='';
497$field['length']='512';
498$field['default']='';
499$field['label']='Browser';
500$field['rules']='varchar|max=512';
501$field['tooltip']='';
502$field['errormsg']='';
503$field['placeholder']='';
504$field['convert']='';
505$field['protect']='0';
506$field['group']='';
507$field['mask']='';
508$field['data']='';
509$field['options']='';
510$field['tpl']='hidden';
511$field['js']='';
512$field['prompt']='';
513$fields[]=$field;
514
515$field=array();
516$field['name']='mail_sent';
517$field['type']='int';
518$field['index']='';
519$field['length']='1';
520$field['default']='0';
521$field['label']='Mail gesendet';
522$field['rules']='int';
523$field['tooltip']='';
524$field['errormsg']='';
525$field['placeholder']='';
526$field['convert']='';
527$field['protect']='0';
528$field['group']='';
529$field['mask']='';
530$field['data']='';
531$field['options']='';
532$field['tpl']='hidden';
533$field['js']='';
534$field['prompt']='';
535$fields[]=$field;
536
537$field=array();
538$field['name']='mail_sent_date';
539$field['type']='datetime';
540$field['index']='';
541$field['length']='-1';
542$field['default']='';
543$field['label']='Mail gesendet am';
544$field['rules']='datetime';
545$field['tooltip']='';
546$field['errormsg']='';
547$field['placeholder']='';
548$field['convert']='date_time';
549$field['protect']='0';
550$field['group']='';
551$field['mask']='';
552$field['data']='';
553$field['options']='';
554$field['tpl']='hidden';
555$field['js']='';
556$field['prompt']='';
557$fields[]=$field;
558
559$field=array();
560$field['name']='confirm_mail_sent';
561$field['type']='int';
562$field['index']='';
563$field['length']='1';
564$field['default']='0';
565$field['label']='Bestaetigungsmail';
566$field['rules']='int';
567$field['tooltip']='';
568$field['errormsg']='';
569$field['placeholder']='';
570$field['convert']='';
571$field['protect']='0';
572$field['group']='';
573$field['mask']='';
574$field['data']='';
575$field['options']='';
576$field['tpl']='hidden';
577$field['js']='';
578$field['prompt']='';
579$fields[]=$field;
580
581$field=array();
582$field['name']='confirm_mail_sent_date';
583$field['type']='datetime';
584$field['index']='';
585$field['length']='-1';
586$field['default']='';
587$field['label']='Bestaetigungsmail am';
588$field['rules']='datetime';
589$field['tooltip']='';
590$field['errormsg']='';
591$field['placeholder']='';
592$field['convert']='date_time';
593$field['protect']='0';
594$field['group']='';
595$field['mask']='';
596$field['data']='';
597$field['options']='';
598$field['tpl']='hidden';
599$field['js']='';
600$field['prompt']='';
601$fields[]=$field;
$table
$table['server']
Definition .dd.php:6
$fields
$fields[]
Definition config.dd.php:16
$field
$field
Definition config.dd.php:4