343, 'module_name' => 'salescusers', 'module_title' => 'Sales Clicks Users', 'module_note' => 'Sales Clicks Users', 'module_frontend_slug' => '', 'module_author' => NULL, 'module_created' => '2020-02-26 14:29:59', 'module_desc' => NULL, 'module_db' => 'rep_salesCusers', 'module_db_key' => 'id', 'module_type' => 'report', 'module_config' => [ 'sql_select' => ' SELECT rep_salesCusers.* FROM rep_salesCusers ', 'sql_where' => ' WHERE rep_salesCusers.id IS NOT NULL', 'sql_group' => '', 'table_db' => 'rep_salesCusers', 'primary_key' => 'id', 'forms' => [ [ 'field' => 'id', 'alias' => 'rep_salesCusers', 'label' => 'Id', 'language' => [ ], 'required' => 1, 'default' => '0', 'validations' => 'maxlength="11"', 'view' => '1', 'type' => 'text_number', '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' => 'network_id', 'alias' => 'rep_salesCusers', 'label' => 'Network 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' => 'network_transaction_id', 'alias' => 'rep_salesCusers', 'label' => 'Network Transaction Id', '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' => 'network_sale_id', 'alias' => 'rep_salesCusers', 'label' => 'Network Sale Id', 'language' => [ ], 'required' => 0, 'default' => NULL, 'validations' => 'maxlength="20"', 'view' => '1', 'type' => 'text', '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, ], ], [ 'field' => 'order_id', 'alias' => 'rep_salesCusers', 'label' => 'Order Id', 'language' => [ ], 'required' => 0, 'default' => NULL, 'validations' => 'maxlength="255"', 'view' => '1', 'type' => 'text', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 4, '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' => 'store_id', 'alias' => 'rep_salesCusers', 'label' => 'Store Id', 'language' => [ ], 'required' => 0, 'default' => NULL, 'validations' => 'maxlength="11"', 'view' => '1', 'type' => 'text_number', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 5, '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' => 'click_id', 'alias' => 'rep_salesCusers', 'label' => 'Click Id', 'language' => [ ], 'required' => 0, 'default' => NULL, 'validations' => 'maxlength="11"', 'view' => '1', 'type' => 'text_number', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 6, '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' => 'campaign_id', 'alias' => 'rep_salesCusers', 'label' => 'Campaign Id', 'language' => [ ], 'required' => 0, 'default' => NULL, 'validations' => 'maxlength="11"', 'view' => '1', 'type' => 'text_number', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 7, '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' => 'cashback_percent', 'alias' => 'rep_salesCusers', 'label' => 'Cashback Percent', 'language' => [ ], 'required' => 1, 'default' => '0', 'validations' => 'maxlength="11"', 'view' => '1', 'type' => 'text_number', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 8, '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' => 'transaction_time', 'alias' => 'rep_salesCusers', 'label' => 'Transaction Time', 'language' => [ ], 'required' => 0, 'default' => NULL, 'validations' => '', 'view' => '1', 'type' => 'text_datetime', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 9, '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' => 'order_amount', 'alias' => 'rep_salesCusers', 'label' => 'Order Amount', 'language' => [ ], 'required' => 0, 'default' => NULL, 'validations' => 'maxlength="10"', 'view' => '1', 'type' => 'text_decimal', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 10, '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' => 'comission', 'alias' => 'rep_salesCusers', 'label' => 'Comission', 'language' => [ ], 'required' => 0, 'default' => NULL, 'validations' => 'maxlength="10"', 'view' => '1', 'type' => 'text_decimal', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 11, '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' => 'currency', 'alias' => 'rep_salesCusers', 'label' => 'Currency', 'language' => [ ], 'required' => 0, 'default' => NULL, 'validations' => 'maxlength="3"', 'view' => '1', 'type' => 'text', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 12, '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' => 'network_status', 'alias' => 'rep_salesCusers', 'label' => 'Network Status', 'language' => [ ], 'required' => 0, 'default' => NULL, 'validations' => 'maxlength="255"', 'view' => '1', 'type' => 'text', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 13, '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' => 'status', 'alias' => 'rep_salesCusers', 'label' => 'Status', 'language' => [ ], 'required' => 0, 'default' => NULL, 'validations' => '', 'view' => '1', 'type' => 'radio', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 14, 'form_group' => '', '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' => '', 'upload_type' => '', 'tooltip' => '', 'attribute' => '', 'extend_class' => '', 'is_json' => 0, 'is_ajax' => 1, ], ], [ 'field' => 'created_at', 'alias' => 'rep_salesCusers', 'label' => 'Created At', 'language' => [ ], 'required' => 1, 'default' => 'CURRENT_TIMESTAMP', 'validations' => '', 'view' => '1', 'type' => 'update_timestamp', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 15, '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' => 'updated_at', 'alias' => 'rep_salesCusers', 'label' => 'Updated At', 'language' => [ ], 'required' => 0, 'default' => NULL, 'validations' => '', 'view' => '1', 'type' => 'update_timestamp', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 16, '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' => 'click_time', 'alias' => 'rep_salesCusers', 'label' => 'Click Time', 'language' => [ ], 'required' => 0, 'default' => 'CURRENT_TIMESTAMP', 'validations' => '', 'view' => '1', 'type' => 'text_datetime', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 17, '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' => 'cashback_enabled', 'alias' => 'rep_salesCusers', 'label' => 'Cashback Enabled', 'language' => [ ], 'required' => 1, 'default' => '0', 'validations' => '', 'view' => '1', 'type' => 'switch', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 18, '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' => 'store_name', 'alias' => 'rep_salesCusers', 'label' => 'Store Name', 'language' => [ ], 'required' => 0, 'default' => NULL, 'validations' => '', 'view' => '1', 'type' => 'json', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 19, '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' => 'first_name', 'alias' => 'rep_salesCusers', 'label' => 'First Name', 'language' => [ ], 'required' => 0, 'default' => NULL, 'validations' => 'maxlength="100"', 'view' => '1', 'type' => 'text', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 20, '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' => 'last_name', 'alias' => 'rep_salesCusers', 'label' => 'Last Name', 'language' => [ ], 'required' => 0, 'default' => NULL, 'validations' => 'maxlength="100"', 'view' => '1', 'type' => 'text', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 21, '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_email', 'alias' => 'rep_salesCusers', 'label' => 'User Email', 'language' => [ ], 'required' => 0, 'default' => NULL, 'validations' => 'maxlength="100"', 'view' => '1', 'type' => 'text', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 22, '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' => 'network_name', 'alias' => 'rep_salesCusers', 'label' => 'Network Name', 'language' => [ ], 'required' => 0, 'default' => NULL, 'validations' => 'maxlength="255"', 'view' => '1', 'type' => 'text', 'add' => '1', 'edit' => '1', 'search' => '1', 'size' => 'span12', 'sortlist' => 25, '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' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Id', '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' => '', 'format_value' => '', ], [ 'field' => 'network_id', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Network Id', 'view' => 0, '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' => 'network_transaction_id', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Network Transaction Id', 'view' => 0, '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' => 'network_sale_id', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Network Sale Id', 'view' => 0, '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' => 'order_id', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Order Id', 'view' => 0, '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' => 'store_id', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Store 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' => 'click_id', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Click Id', 'view' => 1, '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' => '', ], [ 'field' => 'campaign_id', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Campaign Id', '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' => 'transaction_time', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Transaction Time', 'view' => 0, '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' => 'local_timestamp', 'format_value' => 'Africa/Cairo', ], [ 'field' => 'order_amount', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Order Amount', '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' => 'currency', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Currency', 'view' => 0, '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' => 'network_status', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Network Status', 'view' => 0, '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' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Created At', 'view' => 0, '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' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Updated At', 'view' => 0, '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' => '', ], [ 'field' => 'click_time', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Click Time', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '24', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => 'local_timestamp', 'format_value' => 'Africa/Cairo', ], [ 'field' => 'network_name', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Network Name', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '15', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'store_name', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Store Name', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '16', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => 'lang', 'format_value' => '', ], [ 'field' => 'first_name', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'First Name', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '17', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'last_name', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Last Name', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '18', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'user_email', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'User Email', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '19', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'user_email', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'User Country', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '19', 'conn' => [ 'valid' => '1', 'db' => 'users', 'key' => 'email', 'display' => 'country_code', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'comission', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Comission', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '20', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'status', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Status', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '21', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'cashback_percent', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Cashback Percent', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '22', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'cashback_enabled', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'Cashback Enabled', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '23', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'comission', 'alias' => 'rep_salesCusers', 'language' => [ ], 'label' => 'User Commission', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '23', 'conn' => [ 'valid' => '0', 'db' => '', 'key' => '', 'display' => '', ], 'format_as' => 'function', 'format_value' => 'SiteHelpers|userCommission|cashback_enabled:comission:cashback_percent', ], ], ], 'module_lang' => NULL, ];