303, 'module_name' => 'usercashbacktransactions', 'module_title' => 'User Cashback Transactions', 'module_note' => 'User Cashback Transactions', 'module_frontend_slug' => '', 'module_author' => NULL, 'module_created' => '2019-09-10 06:01:38', 'module_desc' => NULL, 'module_db' => 'user_sales', 'module_db_key' => 'id', 'module_type' => 'native', 'module_config' => [ 'table_db' => 'user_sales', 'primary_key' => 'id', 'sql_select' => ' SELECT user_sales.* FROM user_sales ', 'sql_where' => ' WHERE user_sales.id IS NOT NULL', 'sql_group' => '', 'setting' => [ 'gridtype' => '', 'orderby' => 'user_sales.id', 'ordertype' => 'DESC', 'perpage' => '50', 'frozen' => 'false', 'form-method' => 'native', 'view-method' => 'native', 'inline' => 'false', ], 'form_column' => 2, 'form_layout' => [ 'column' => 2, 'title' => 'User Cashback Transaction,Additional Details', 'format' => 'grid', 'display' => 'vertical', ], 'forms' => [ [ 'field' => 'click_id', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Click ID', 'form_group' => '0', 'required' => 0, 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'text', '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' => 'id', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'ID', 'form_group' => '0', 'required' => '1', 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'hidden', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => '1', '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_sales', 'label' => 'User', 'form_group' => '0', 'required' => '0', 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'select', 'add' => 1, 'edit' => 1, 'search' => '1', 'size' => '', 'sortlist' => '2', 'limited' => '', 'option' => [ 'opt_type' => 'external', 'lookup_query' => '', 'lookup_table' => 'users', 'lookup_key' => 'user_id', 'lookup_value' => 'first_name|last_name|email', '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' => 'sales_id', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Sales Id', 'form_group' => '0', 'required' => 0, 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'text', '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' => 'network_id', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Network', 'form_group' => '0', 'required' => '1', 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'select', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => '4', 'limited' => '', 'note' => '', 'dependency' => '', 'option' => [ 'opt_type' => 'external', 'lookup_query' => '', 'lookup_table' => 'networks', 'lookup_key' => 'id', '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' => 'order_id', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Order Id', 'form_group' => '0', 'required' => 0, 'default' => '', 'validations' => 'maxlength="255"', 'view' => 1, 'type' => 'text', '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' => 'store_id', 'alias' => 'user_sales', 'label' => 'Store', 'form_group' => '0', 'required' => '0', 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'select', 'add' => 1, 'edit' => 1, 'search' => '1', 'size' => '', 'sortlist' => '6', 'limited' => '', 'option' => [ 'opt_type' => 'external', 'lookup_query' => '', 'lookup_table' => 'stores', 'lookup_key' => 'id', 'lookup_value' => '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' => 'created_at', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Created At', 'form_group' => '0', 'required' => '1', 'default' => 'CURRENT_TIMESTAMP', 'validations' => '', 'view' => 1, 'type' => 'update_timestamp', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => '7', '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' => 'updated_at', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Updated At', 'form_group' => '0', 'required' => 0, 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'update_timestamp', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => '8', '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' => 'transaction_time', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Transaction Time', 'form_group' => '1', 'required' => 0, 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'text_datetime', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => '9', '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' => 'order_amount', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Order Amount', 'form_group' => '1', 'required' => 0, 'default' => '', 'validations' => 'maxlength="10"', 'view' => 1, 'type' => 'text_decimal', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => '10', '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' => 'cashback', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Cashback', 'form_group' => '1', 'required' => 0, 'default' => '', 'validations' => 'maxlength="10"', 'view' => 1, 'type' => 'text_decimal', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => '11', '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' => 'currency', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Currency', 'form_group' => '1', 'required' => 0, 'default' => '', 'validations' => 'maxlength=', 'view' => 1, 'type' => 'select', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => '12', 'limited' => '', 'note' => '', 'dependency' => '', 'option' => [ 'opt_type' => 'external', 'lookup_query' => '', 'lookup_table' => 'currencies', 'lookup_key' => 'iso_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' => '0', ], ], [ 'field' => 'status', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Status', 'form_group' => '1', 'required' => 0, 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'radio', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => '13', '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', ], ], ], 'grid' => [ [ 'field' => 'id', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'ID', 'view' => 0, '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' => '', 'format_value' => '', ], [ 'field' => 'click_id', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Click ID', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '20', 'align' => 'left', 'sortlist' => '2', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'user_id', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'User', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '3', 'conn' => [ 'valid' => '1', 'db' => 'users', 'key' => 'user_id', 'display' => 'first_name|last_name', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'user_id', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'User ID', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '3', 'conn' => [ 'valid' => '0', 'db' => 'users', 'key' => 'user_id', 'display' => 'first_name|last_name', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'user_id', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Country', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '3', 'conn' => [ 'valid' => '1', 'db' => 'users', 'key' => 'user_id', 'display' => 'country_code', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'user_id', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Is Merchant', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '3', 'conn' => [ 'valid' => '1', 'db' => 'users', 'key' => 'user_id', 'display' => 'is_merchant', ], 'format_as' => 'switch', 'format_value' => '', ], [ 'field' => 'sales_id', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Sales Id', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '4', 'conn' => [ 'valid' => '1', 'db' => 'sales', 'key' => 'id', 'display' => 'network_id', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'network_id', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Network', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '5', 'conn' => [ 'valid' => '1', 'db' => 'networks', 'key' => 'id', 'display' => 'name', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'click_id', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Cashback Percent', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '5', 'conn' => [ 'valid' => '1', 'db' => 'clicks', 'key' => 'id', 'display' => 'cashback_percent', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'click_id', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Platform', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '20', 'align' => 'left', 'sortlist' => '1', 'conn' => [ 'valid' => '1', 'db' => 'clicks', 'key' => 'id', 'display' => 'platform', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'order_id', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Order Id', 'view' => 0, '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' => 'store_id', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Store', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '7', 'conn' => [ 'valid' => '1', 'db' => 'stores', 'key' => 'id', 'display' => 'slug', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'order_amount', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Order Amount', 'view' => 0, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '8', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'cashback', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Cashback', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '9', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'currency', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Currency', 'view' => 0, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '10', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'status', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Status', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '11', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'click_id', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'UTM', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '11', 'conn' => [ 'valid' => '1', 'db' => 'clicks', 'key' => 'id', 'display' => 'utm', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'transaction_time', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Transaction Time', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '12', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'created_at', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Created At', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '13', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'updated_at', 'alias' => 'user_sales', 'language' => [ ], 'label' => 'Updated At', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '14', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], ], ], 'module_lang' => NULL, ];