11, 'module_name' => 'logs', 'module_title' => 'Logs', 'module_note' => 'Users Activity Log', 'module_frontend_slug' => '', 'module_author' => 'Mango Tm', 'module_created' => '2014-04-21 17:29:43', 'module_desc' => NULL, 'module_db' => 'tb_logs', 'module_db_key' => 'auditID', 'module_type' => 'core', 'module_config' => [ 'table_db' => 'tb_logs', 'primary_key' => 'auditID', 'sql_select' => ' SELECT tb_logs.* FROM tb_logs ', 'sql_where' => ' WHERE tb_logs.auditID IS NOT NULL', 'sql_group' => '', 'form_column' => 2, 'form_layout' => [ 'column' => 2, 'title' => 'logs,sdsdsd', 'format' => 'grid', 'display' => 'horizontal', ], 'forms' => [ [ 'field' => 'auditID', 'alias' => 'tb_logs', 'language' => [ ], 'label' => 'AuditID', 'form_group' => 0, 'required' => '0', 'view' => 1, 'type' => 'text', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => 0, 'option' => [ 'opt_type' => '', 'lookup_query' => '', 'lookup_table' => '', 'lookup_key' => '', 'lookup_value' => '', 'is_dependency' => '', 'is_multiple' => '', 'lookup_dependency_key' => '', 'path_to_upload' => '', 'resize_width' => '', 'resize_height' => '', 'upload_type' => '', 'tooltip' => '', 'attribute' => '', 'extend_class' => '', ], ], [ 'field' => 'ipaddress', 'alias' => 'tb_logs', 'language' => [ ], 'label' => 'Ipaddress', 'form_group' => 0, 'required' => '0', 'view' => 1, 'type' => 'text', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => 1, 'option' => [ 'opt_type' => '', 'lookup_query' => '', 'lookup_table' => '', 'lookup_key' => '', 'lookup_value' => '', 'is_dependency' => '', 'is_multiple' => '', 'lookup_dependency_key' => '', 'path_to_upload' => '', 'resize_width' => '', 'resize_height' => '', 'upload_type' => '', 'tooltip' => '', 'attribute' => '', 'extend_class' => '', ], ], [ 'field' => 'note', 'alias' => 'tb_logs', 'label' => 'Note', 'form_group' => 0, 'required' => '0', 'view' => 1, 'type' => 'textarea_editor', 'add' => 1, 'edit' => 1, 'search' => '1', 'size' => '', 'sortlist' => 2, 'option' => [ 'opt_type' => NULL, 'lookup_query' => '', 'lookup_table' => NULL, 'lookup_key' => NULL, 'lookup_value' => '', 'is_dependency' => NULL, 'is_multiple' => NULL, 'lookup_dependency_key' => NULL, 'path_to_upload' => '', 'upload_type' => NULL, 'resize_width' => '', 'resize_height' => '', 'tooltip' => '', 'attribute' => '', 'extend_class' => '', ], ], [ 'field' => 'logdate', 'alias' => 'tb_logs', 'language' => [ ], 'label' => 'Logdate', 'form_group' => 0, 'required' => '0', 'view' => 1, 'type' => 'text_datetime', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => 3, 'option' => [ 'opt_type' => '', 'lookup_query' => '', 'lookup_table' => '', 'lookup_key' => '', 'lookup_value' => '', 'is_dependency' => '', 'is_multiple' => '', 'lookup_dependency_key' => '', 'path_to_upload' => '', 'resize_width' => '', 'resize_height' => '', 'upload_type' => '', 'tooltip' => '', 'attribute' => '', 'extend_class' => '', ], ], [ 'field' => 'user_id', 'alias' => 'tb_logs', 'label' => 'Users', 'form_group' => 1, 'required' => '0', 'view' => 1, 'type' => 'select', 'add' => 1, 'edit' => 1, 'search' => '1', 'size' => '', 'sortlist' => 4, 'option' => [ 'opt_type' => 'external', 'lookup_query' => '', 'lookup_table' => 'tb_users', 'lookup_key' => 'id', 'lookup_value' => 'first_name', 'is_dependency' => NULL, 'is_multiple' => NULL, 'lookup_dependency_key' => '', 'path_to_upload' => '', 'upload_type' => NULL, 'resize_width' => '', 'resize_height' => '', 'tooltip' => '', 'attribute' => '', 'extend_class' => '', ], ], [ 'field' => 'task', 'alias' => 'tb_logs', 'language' => [ ], 'label' => 'Task', 'form_group' => 1, 'required' => '0', 'view' => 1, 'type' => 'text', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => 5, 'option' => [ 'opt_type' => '', 'lookup_query' => '', 'lookup_table' => '', 'lookup_key' => '', 'lookup_value' => '', 'is_dependency' => '', 'is_multiple' => '', 'lookup_dependency_key' => '', 'path_to_upload' => '', 'resize_width' => '', 'resize_height' => '', 'upload_type' => '', 'tooltip' => '', 'attribute' => '', 'extend_class' => '', ], ], [ 'field' => 'module', 'alias' => 'tb_logs', 'language' => [ ], 'label' => 'Module', 'form_group' => 1, 'required' => '0', 'view' => 1, 'type' => 'text', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => 6, 'option' => [ 'opt_type' => '', 'lookup_query' => '', 'lookup_table' => '', 'lookup_key' => '', 'lookup_value' => '', 'is_dependency' => '', 'is_multiple' => '', 'lookup_dependency_key' => '', 'path_to_upload' => '', 'resize_width' => '', 'resize_height' => '', 'upload_type' => '', 'tooltip' => '', 'attribute' => '', 'extend_class' => '', ], ], ], 'grid' => [ [ 'field' => 'logdate', 'alias' => 'tb_logs', 'language' => [ ], 'label' => 'Logdate', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '1', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => 'date', 'format_value' => 'd/m/Y', ], [ 'field' => 'auditID', 'alias' => 'tb_logs', 'language' => [ ], 'label' => 'AuditID', 'view' => 0, 'detail' => 0, 'sortable' => 0, 'search' => 1, 'download' => 0, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '2', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'ipaddress', 'alias' => 'tb_logs', 'language' => [ ], 'label' => 'IPs', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '3', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'user_id', 'alias' => 'tb_logs', 'language' => [ ], 'label' => 'Users', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '160', 'align' => 'left', 'sortlist' => '4', 'conn' => [ 'valid' => '1', 'db' => 'tb_users', 'key' => 'id', // YK-566: the acceptance criteria wants both name and // email on the audit log, not just name. formatLookUp() // already joins pipe-separated fields and space-joins // them, so this needed no new code, just this value. 'display' => 'first_name|email', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'module', 'alias' => 'tb_logs', 'language' => [ ], 'label' => 'Module', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '5', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'task', 'alias' => 'tb_logs', 'language' => [ ], 'label' => 'Task', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '6', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'note', 'alias' => 'tb_logs', 'language' => [ ], 'label' => 'Note', 'view' => 0, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '7', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], ], ], 'module_lang' => '{"title":{"id":""},"note":{"id":""}}', ];