297, 'module_name' => 'missingcashbackclaims', 'module_title' => 'Missing Cashback Claims', 'module_note' => 'Missing Cashback Claims', 'module_frontend_slug' => '', 'module_author' => NULL, 'module_created' => '2019-09-10 05:57:36', 'module_desc' => NULL, 'module_db' => 'user_claims', 'module_db_key' => 'id', 'module_type' => 'native', 'module_config' => [ 'sql_select' => ' SELECT user_claims.* FROM user_claims ', 'sql_where' => ' WHERE user_claims.id IS NOT NULL', 'sql_group' => '', 'table_db' => 'user_claims', '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' => 'Missing Cashback Claim,Additional Details', 'format' => 'grid', 'display' => 'vertical', ], 'subform' => [ 'title' => 'Comment', 'master' => 'missingcashbackclaims', 'master_key' => 'id', 'module' => 'claimcomment', 'table' => 'user_claim_comments', 'key' => 'claim_id', ], 'subgrid' => [ [ 'title' => 'Comment', 'master' => 'missingcashbackclaims', 'master_key' => 'id', 'module' => 'claimcomment', 'table' => 'user_claim_comments', 'key' => 'claim_id', ], ], 'grid' => [ [ 'field' => 'id', 'alias' => 'user_claims', '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_claims', '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|last_name|email', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'click_id', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Click Id', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '2', 'conn' => [ 'valid' => '1', 'db' => 'clicks', 'key' => 'id', 'display' => 'id', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'store_id', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Store', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '3', 'conn' => [ 'valid' => '1', 'db' => 'stores', 'key' => 'id', 'display' => 'slug', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'network_id', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Network', 'view' => 1, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '4', 'conn' => [ 'valid' => '1', 'db' => 'networks', 'key' => 'id', 'display' => 'name', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'click_time', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Click Time', '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' => 'order_id', 'alias' => 'user_claims', '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' => 'currency_iso', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Currency Iso', 'view' => 0, 'detail' => 1, 'sortable' => 1, 'search' => 1, 'download' => 1, 'frozen' => 1, 'limited' => '', 'width' => '100', 'align' => 'left', 'sortlist' => '7', 'conn' => [ 'valid' => '1', 'db' => 'currencies', 'key' => 'iso_code', 'display' => 'symbol', ], 'format_as' => '', 'format_value' => '', ], [ 'field' => 'order_amount', 'alias' => 'user_claims', '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' => 'transaction_date', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Transaction Date', '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' => '', 'format_value' => '', ], [ 'field' => 'platform', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Platform', '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' => 'message', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Message', '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' => 'note', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Note', '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' => 'status', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Status', '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' => 'closed_by', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Closed By', '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' => 'created_at', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Created At', 'view' => 0, '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' => 'updated_at', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Updated At', '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' => '', 'format_value' => '', ], ], 'forms' => [ [ 'field' => 'id', 'alias' => 'user_claims', '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_claims', 'language' => [ ], 'label' => 'User', 'form_group' => '0', 'required' => 1, 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'select', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => '1', 'limited' => '', 'note' => '', 'dependency' => '', 'option' => [ 'opt_type' => 'external', 'lookup_query' => '', 'lookup_table' => 'users', 'lookup_key' => 'user_id', 'lookup_value' => 'first_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' => 'click_id', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Click ID', 'form_group' => '0', 'required' => 1, 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'text', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => '2', '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' => 'click_time', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Click Time', 'form_group' => '0', 'required' => 0, 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'text_datetime', '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' => 'store_id', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Store', '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' => 'stores', 'lookup_key' => 'id', 'lookup_value' => 'slug', '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_claims', 'language' => [ ], 'label' => 'Network', 'form_group' => '0', 'required' => 0, 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'select', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => '5', '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' => '0', ], ], [ 'field' => 'currency_iso', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Currency ISO', 'form_group' => '0', 'required' => 1, 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'select', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => '6', 'limited' => '', 'note' => '', 'dependency' => '', 'option' => [ 'opt_type' => 'external', 'lookup_query' => '', 'lookup_table' => 'currencies', 'lookup_key' => 'iso_code', 'lookup_value' => 'symbol', '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' => 'platform', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Platform', 'form_group' => '0', 'required' => '1', 'default' => 'website', 'validations' => '', 'view' => 1, 'type' => 'radio', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => '7', 'limited' => '', 'note' => '', 'dependency' => '', 'option' => [ 'opt_type' => '', 'lookup_query' => 'website:Website|mobile:Mobile|ios:Ios|android:Android', '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' => 'closed_by', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Closed By', 'form_group' => '0', 'required' => 0, 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'radio', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => '8', 'limited' => '', 'note' => '', 'dependency' => '', 'option' => [ 'opt_type' => '', 'lookup_query' => 'admin:Admin|user:User', '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_date', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Transaction Date', 'form_group' => '1', 'required' => 0, 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'text_date', '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' => 'order_id', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Order ID', 'form_group' => '1', 'required' => 0, 'default' => '', 'validations' => 'maxlength="255"', 'view' => 1, 'type' => 'text', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => '12', '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_claims', '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' => '13', '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' => 'message', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Message', 'form_group' => '1', 'required' => 0, 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'textarea', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => '14', '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' => 'note', 'alias' => 'user_claims', 'language' => [ ], 'label' => 'Note', 'form_group' => '1', 'required' => 0, 'default' => '', 'validations' => '', 'view' => 1, 'type' => 'textarea', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => '15', '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_claims', 'language' => [ ], 'label' => 'Status', 'form_group' => '1', 'required' => '1', 'default' => 'open', 'validations' => '', 'view' => 1, 'type' => 'radio', 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => '1', 'sortlist' => '16', 'limited' => '', 'note' => '', 'dependency' => '', 'option' => [ 'opt_type' => '', 'lookup_query' => 'open:Open|hold:Hold|answered:Answered|closed:Closed', '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, ];