296, 'module_name' => 'userbonus', 'module_title' => 'User Bonus', 'module_note' => 'User Bonus', 'module_frontend_slug' => '', 'module_author' => NULL, 'module_created' => '2019-09-10 05:56:59', 'module_desc' => NULL, 'module_db' => 'user_bonus', 'module_db_key' => 'id', 'module_type' => 'native', 'module_config' => [ 'sql_select' => ' SELECT user_bonus.* FROM user_bonus ', 'sql_where' => ' WHERE user_bonus.id IS NOT NULL', 'sql_group' => '', 'table_db' => 'user_bonus', 'primary_key' => 'id', 'setting' => [ 'gridtype' => '', 'orderby' => 'id', 'ordertype' => 'DESC', 'perpage' => '50', 'frozen' => 'false', 'form-method' => 'native', 'view-method' => 'native', 'inline' => 'false', ], 'form_column' => 2, 'form_layout' => [ 'column' => 2, 'title' => 'User Bonus,Additional Details', 'format' => 'grid', 'display' => 'vertical', ], 'grid' => [ [ 'field' => 'id', 'alias' => 'user_bonus', 'language' => [ ], 'label' => 'Id', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '20', 'align' => 'left', 'sortlist' => '0', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'user_id', 'alias' => 'user_bonus', 'language' => [ ], 'label' => 'User', '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', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'bonus_code', 'alias' => 'user_bonus', 'language' => [ ], 'label' => 'Bonus Details', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '2', 'conn' => [ 'valid' => '1', 'db' => 'bonus_types', 'key' => 'code', 'display' => 'name', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'amount', 'alias' => 'user_bonus', 'language' => [ ], 'label' => 'Amount', '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' => 'awarded_on', 'alias' => 'user_bonus', 'language' => [ ], 'label' => 'Awarded On', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '4', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'expires_on', 'alias' => 'user_bonus', 'language' => [ ], 'label' => 'Expires On', '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' => 'status', 'alias' => 'user_bonus', 'language' => [ ], 'label' => 'Status', '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' => '', ], ], 'forms' => [ [ 'field' => 'id', 'alias' => 'user_bonus', 'language' => [ ], 'label' => 'Id', 'form_group' => 0, 'required' => '1', 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'hidden', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => 0, 'limited' => '', 'note' => '', 'dependency' => '', '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' => '', 'resize_width' => '', 'resize_height' => '', 'upload_type' => '', 'tooltip' => '', 'attribute' => '', 'extend_class' => '', 'is_json' => '0', 'is_ajax' => '1', ], ], [ 'field' => 'user_id', 'alias' => 'user_bonus', 'label' => 'User', 'form_group' => '0', 'required' => '1', 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'select', 'add' => 1, 'edit' => 1, 'search' => '1', 'size' => '', 'sortlist' => '1', 'limited' => '', 'option' => [ 'opt_type' => 'external', 'lookup_query' => '', 'lookup_table' => 'users', 'lookup_key' => 'user_id', 'lookup_value' => 'first_name', 'is_dependency' => NULL, 'select_multiple' => '0', 'image_multiple' => '0', 'lookup_dependency_key' => '', 'lookup_where_clause' => '', 'path_to_upload' => '', 'upload_type' => NULL, 'resize_width' => '', 'resize_height' => '', 'tooltip' => '', 'attribute' => '', 'extend_class' => '', 'prefix' => '', 'sufix' => '', 'is_json' => '0', 'is_ajax' => '1', ], ], [ 'field' => 'bonus_code', 'alias' => 'user_bonus', 'language' => [ ], 'label' => 'Bonus', 'form_group' => 0, 'required' => '1', 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'select', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => 2, 'limited' => '', 'note' => '', 'dependency' => '', 'option' => [ 'opt_type' => 'external', 'lookup_query' => '', 'lookup_table' => 'bonus_types', 'lookup_key' => 'code', 'lookup_value' => 'name', 'is_dependency' => '', 'select_multiple' => '0', 'image_multiple' => '0', 'lookup_dependency_key' => '', 'lookup_where_clause' => '', 'path_to_upload' => '', 'resize_width' => '', 'resize_height' => '', 'upload_type' => '', 'tooltip' => '', 'attribute' => '', 'extend_class' => '', 'is_json' => '0', 'is_ajax' => '1', ], ], [ 'field' => 'amount', 'alias' => 'user_bonus', 'language' => [ ], 'label' => 'Amount', 'form_group' => 0, 'required' => '1', 'default' => '', 'validations' => 'maxlength="10"', 'view' => 1, 'type' => 'text_decimal', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => 3, 'limited' => '', 'note' => '', 'dependency' => '', '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' => '', 'resize_width' => '', 'resize_height' => '', 'upload_type' => '', 'tooltip' => '', 'attribute' => '', 'extend_class' => '', 'is_json' => '0', 'is_ajax' => '1', ], ], [ 'field' => 'awarded_on', 'alias' => 'user_bonus', 'language' => [ ], 'label' => 'Awarded On', 'form_group' => 1, 'required' => '1', 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'date', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => 4, 'limited' => '', 'note' => '', 'dependency' => '', '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' => '', 'resize_width' => '', 'resize_height' => '', 'upload_type' => '', 'tooltip' => '', 'attribute' => '', 'extend_class' => '', 'is_json' => '0', 'is_ajax' => '1', ], ], [ 'field' => 'expires_on', 'alias' => 'user_bonus', 'language' => [ ], 'label' => 'Expires On', 'form_group' => 1, 'required' => '1', 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'date', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => 5, 'limited' => '', 'note' => '', 'dependency' => '', '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' => '', 'resize_width' => '', 'resize_height' => '', 'upload_type' => '', 'tooltip' => '', 'attribute' => '', 'extend_class' => '', 'is_json' => '0', 'is_ajax' => '1', ], ], [ 'field' => 'status', 'alias' => 'user_bonus', 'language' => [ ], 'label' => 'Status', 'form_group' => 1, 'required' => '1', 'default' => 'pending', 'validations' => '', 'view' => 1, 'type' => 'radio', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => 6, 'limited' => '', 'note' => '', 'dependency' => '', 'option' => [ 'opt_type' => '', 'lookup_query' => 'pending:Pending|confirmed:Confirmed|declined:Declined', 'lookup_table' => '', 'lookup_key' => '', 'lookup_value' => '', 'is_dependency' => '', 'select_multiple' => '0', 'image_multiple' => '0', 'lookup_dependency_key' => '', 'lookup_where_clause' => '', 'path_to_upload' => '', 'resize_width' => '', 'resize_height' => '', 'upload_type' => '', 'tooltip' => '', 'attribute' => '', 'extend_class' => '', 'is_json' => '0', 'is_ajax' => '1', ], ], ], ], 'module_lang' => NULL, ];