327, 'module_name' => 'userreferralinvite', 'module_title' => 'User Referral Invite', 'module_note' => 'User Referral Invite', 'module_frontend_slug' => '', 'module_author' => NULL, 'module_created' => '2019-09-28 07:20:06', 'module_desc' => NULL, 'module_db' => 'user_refer_invites', 'module_db_key' => 'id', 'module_type' => 'report', 'module_config' => [ 'sql_select' => ' SELECT user_refer_invites.* FROM user_refer_invites ', 'sql_where' => ' WHERE user_refer_invites.id IS NOT NULL', 'sql_group' => '', 'table_db' => 'user_refer_invites', 'primary_key' => 'id', 'forms' => [ [ 'field' => 'id', 'alias' => 'user_refer_invites', 'label' => 'Id', 'language' => [ ], 'required' => 1, 'default' => NULL, 'validations' => '', 'view' => '1', 'type' => 'hidden', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 0, 'form_group' => '', 'option' => [ 'opt_type' => '', 'lookup_query' => '', 'lookup_table' => '', 'lookup_key' => '', 'lookup_value' => '', 'is_dependency' => '', 'select_multiple' => '0', 'image_multiple' => '0', 'lookup_dependency_key' => '', 'lookup_where_clause' => '', 'path_to_upload' => '', 'upload_type' => '', 'tooltip' => '', 'attribute' => '', 'extend_class' => '', 'is_json' => 0, 'is_ajax' => 1, ], ], [ 'field' => 'user_id', 'alias' => 'user_refer_invites', 'label' => 'User Id', 'language' => [ ], 'required' => 0, 'default' => NULL, 'validations' => 'maxlength="11"', 'view' => '1', 'type' => 'text_number', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 1, 'form_group' => '', 'option' => [ 'opt_type' => '', 'lookup_query' => '', 'lookup_table' => '', 'lookup_key' => '', 'lookup_value' => '', 'is_dependency' => '', 'select_multiple' => '0', 'image_multiple' => '0', 'lookup_dependency_key' => '', 'lookup_where_clause' => '', 'path_to_upload' => '', 'upload_type' => '', 'tooltip' => '', 'attribute' => '', 'extend_class' => '', 'is_json' => 0, 'is_ajax' => 1, ], ], [ 'field' => 'email', 'alias' => 'user_refer_invites', 'label' => 'Email', 'language' => [ ], 'required' => 0, 'default' => NULL, 'validations' => 'maxlength="255"', 'view' => '1', 'type' => 'text', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 2, 'form_group' => '', 'option' => [ 'opt_type' => '', 'lookup_query' => '', 'lookup_table' => '', 'lookup_key' => '', 'lookup_value' => '', 'is_dependency' => '', 'select_multiple' => '0', 'image_multiple' => '0', 'lookup_dependency_key' => '', 'lookup_where_clause' => '', 'path_to_upload' => '', 'upload_type' => '', 'tooltip' => '', 'attribute' => '', 'extend_class' => '', 'is_json' => 0, 'is_ajax' => 1, ], ], [ 'field' => 'invited_on', 'alias' => 'user_refer_invites', 'label' => 'Invited On', 'language' => [ ], 'required' => 1, 'default' => 'CURRENT_TIMESTAMP', 'validations' => '', 'view' => '1', 'type' => 'text_datetime', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 3, 'form_group' => '', 'option' => [ 'opt_type' => '', 'lookup_query' => '', 'lookup_table' => '', 'lookup_key' => '', 'lookup_value' => '', 'is_dependency' => '', 'select_multiple' => '0', 'image_multiple' => '0', 'lookup_dependency_key' => '', 'lookup_where_clause' => '', 'path_to_upload' => '', 'upload_type' => '', 'tooltip' => '', 'attribute' => '', 'extend_class' => '', 'is_json' => 0, 'is_ajax' => 1, ], ], ], 'grid' => [ [ 'field' => 'id', 'alias' => 'user_refer_invites', 'language' => [ ], 'label' => 'Id', 'view' => 0, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '0', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'user_id', 'alias' => 'user_refer_invites', 'language' => [ ], 'label' => 'User Id', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '1', 'conn' => [ 'valid' => '1', 'db' => 'users', 'key' => 'user_id', 'display' => 'first_name|last_name|email', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'email', 'alias' => 'user_refer_invites', 'language' => [ ], 'label' => 'Email', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '2', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'invited_on', 'alias' => 'user_refer_invites', 'language' => [ ], 'label' => 'Invited On', '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' => '', ], ], ], 'module_lang' => NULL, ];