Marius Burkard
2016-07-01 49441bdd0f3ff75d5092d5b832b97ea722a66363
commit | author | age
524077 1 <?php
T 2
3 /*
4     Datatypes:
5     - INTEGER
6     - DOUBLE
7     - CURRENCY
8     - VARCHAR
9     - TEXT
10     - DATE
11 */
12
13
14
15 // Name of the list
b1a6a5 16 $liste["name"]     = "web_folder_user";
524077 17
T 18 // Database table
b1a6a5 19 $liste["table"]    = "web_folder_user";
524077 20
T 21 // Index index field of the database table
b1a6a5 22 $liste["table_idx"]   = "web_folder_user_id";
524077 23
T 24 // Search Field Prefix
b1a6a5 25 $liste["search_prefix"]  = "search_";
524077 26
T 27 // Records per page
b1a6a5 28 $liste["records_per_page"]  = "15";
524077 29
T 30 // Script File of the list
b1a6a5 31 $liste["file"]    = "web_folder_user_list.php";
524077 32
T 33 // Script file of the edit form
b1a6a5 34 $liste["edit_file"]   = "web_folder_user_edit.php";
524077 35
T 36 // Script File of the delete script
b1a6a5 37 $liste["delete_file"]  = "web_folder_user_del.php";
524077 38
T 39 // Paging Template
b1a6a5 40 $liste["paging_tpl"]  = "templates/paging.tpl.htm";
524077 41
T 42 // Enable auth
b1a6a5 43 $liste["auth"]    = "yes";
524077 44
edf806 45 $auth_sql = $app->tform->getAuthSQL('r', 'web_domain');
T 46
524077 47
T 48 /*****************************************************
49 * Suchfelder
50 *****************************************************/
51
52
b1a6a5 53 $liste["item"][] = array( 'field'  => "active",
MC 54     'datatype' => "VARCHAR",
55     'formtype' => "SELECT",
56     'op'  => "=",
57     'prefix' => "",
58     'suffix' => "",
59     'width'  => "",
0ea7b9 60     'value'  => array('y' => "<div id=\"ir-Yes\" class=\"swap\"><span>".$app->lng('yes_txt')."</span></div>", 'n' => "<div class=\"swap\" id=\"ir-No\"><span>".$app->lng('no_txt')."</span></div>"));
524077 61
T 62
b1a6a5 63 $liste["item"][] = array( 'field'  => "web_folder_id",
MC 64     'datatype' => "VARCHAR",
65     'filters'   => array( 0 => array( 'event' => 'SHOW',
66             'type' => 'IDNTOUTF8')
67     ),
68     'formtype' => "SELECT",
69     'op'  => "=",
70     'prefix' => "",
71     'suffix' => "",
72     'datasource' => array (  'type' => 'SQL',
73         'querystring' => "Select concat(web_domain.domain,' ',web_folder.path) as name, web_folder.web_folder_id from web_domain, web_folder WHERE web_domain.domain_id = web_folder.parent_domain_id AND ".$auth_sql." ORDER BY web_domain.domain",
74         'keyfield'=> 'web_folder_id',
75         'valuefield'=> 'name'
76     ),
77     'width'  => "",
78     'value'  => "");
524077 79
b1a6a5 80 $liste["item"][] = array( 'field'  => "username",
MC 81     'datatype' => "VARCHAR",
82     'formtype' => "TEXT",
83     'op'  => "like",
84     'prefix' => "%",
85     'suffix' => "%",
86     'width'  => "",
87     'value'  => "");
524077 88
T 89
b1a6a5 90 ?>