shopProduct.dd.php

Go to the documentation of this file.

<?php
$table['server']='dbxShop|dbxShop.db3';
$table['table']='shop_product';
$table['datadic']='shopProduct';
$table['primary']='id';
$table['language']='0';
$table['version']='0.1';
$table['autosync']='1';
$table['cache']='0';
$table['trash']='1';
$table['trace']='0';
$table['update_sql']='';
$table['default_sort']='sorter ASC, title ASC';
$table['form-dd-table']='';
$table['read']='*';
$table['create']='admin';
$table['update']='admin';
$table['delete']='admin';
 
$addField = function($name, $type, $index, $length, $default, $label, $rules, $tpl, $extra = array()) use (&$fields) {
   $field=array();
   $field['name']=$name;
   $field['type']=$type;
   $field['index']=$index;
   $field['length']=$length;
   $field['default']=$default;
   $field['label']=$label;
   $field['rules']=$rules;
   $field['tooltip']=$extra['tooltip'] ?? '';
   $field['errormsg']=$extra['errormsg'] ?? '';
   $field['placeholder']=$extra['placeholder'] ?? '';
   $field['convert']=$extra['convert'] ?? '';
   $field['protect']=$extra['protect'] ?? '0';
   $field['group']=$extra['group'] ?? '';
   $field['mask']=$extra['mask'] ?? '';
   $field['data']=$extra['data'] ?? '';
   $field['options']=$extra['options'] ?? '';
   $field['tpl']=$tpl;
   $field['js']=$extra['js'] ?? '';
   $field['prompt']=$extra['prompt'] ?? '';
   $fields[]=$field;
};
 
$addField('id','int','PRI','11','','ID','int','hidden');
$addField('create_date','datetime','','-1','','Erstellt','datetime','hidden',array('convert'=>'date_time'));
$addField('create_uid','int','MUL','11','0','Erstellt von','int','hidden');
$addField('update_date','datetime','','-1','','Aktualisiert','datetime','hidden',array('convert'=>'date_time'));
$addField('update_uid','int','MUL','11','0','Aktualisiert von','int','hidden');
$addField('owner','int','MUL','11','0','Owner','int','hidden');
$addField('trash','int','MUL','1','0','Trash','int','hidden');
$addField('sku','varchar','UNI','80','','Artikelnummer','parameter|min=2|max=80','text-label');
$addField('slug','varchar','UNI','120','','URL-Name','parameter|min=2|max=120','text-label');
$addField('title','varchar','MUL','180','','Titel','*|min=2|max=180','text-label');
$addField('category','varchar','MUL','80','','Kategorie','parameter|max=80','select-single-label',array('options'=>'Software=Software&Dienstleistung=Dienstleistung&Merchandise=Merchandise'));
$addField('product_group_id','int','MUL','11','0','Artikelgruppe','int','select-single-label');
$addField('product_type','varchar','MUL','24','service','Produkttyp','parameter|max=24','select-single-label',array('options'=>'digital=Digital&service=Dienstleistung&physical=Physisch'));
$addField('summary','varchar','','255','','Kurzbeschreibung','*|max=255','textarea-label',array('data'=>'rows=2'));
$addField('description','mediumtext','','-1','','Beschreibung','*|max=5000','textarea-label',array('data'=>'rows=6'));
$addField('price_gross','decimal','','10,2','0','Bruttopreis','decimal','text-label');
$addField('currency','varchar','','3','EUR','Waehrung','parameter|max=3','text-label');
$addField('tax_mode','varchar','MUL','24','group','MwSt.-Quelle','parameter|max=24','select-single-label',array('options'=>'group=Aus Gruppe&individual=Individuell'));
$addField('tax_rate','decimal','','5,2','-1','MwSt. % individuell','decimal','text-label');
$addField('shipping_mode','varchar','MUL','24','group','Versand-Quelle','parameter|max=24','select-single-label',array('options'=>'group=Aus Gruppe&individual=Individuell'));
$addField('shipping_gross','decimal','','10,2','-1','Versand brutto individuell','decimal','text-label');
$addField('delivery_time','varchar','','120','','Lieferzeit individuell','*|max=120','text-label');
$addField('stock','int','','11','0','Lagerbestand','int','text-label');
$addField('active','int','MUL','1','1','Aktiv','int','checkbox-label');
$addField('sorter','int','MUL','11','100','Sortierung','int','text-label');
$addField('badge','varchar','','80','','Badge','*|max=80','text-label');
$addField('image_icon','varchar','','80','bi-box-seam','Icon','parameter|max=80','text-label');
$addField('logo_variant','varchar','','80','','Logo-Variante','parameter|max=80','text-label');
?>