<?php return [
    'module_id' => 302,
    'module_name' => 'userreferralsaletransactions',
    'module_title' => 'User Referral Sale Transactions',
    'module_note' => 'User Referral Sale Transactions',
    'module_frontend_slug' => '',
    'module_author' => NULL,
    'module_created' => '2019-09-10 06:01:03',
    'module_desc' => NULL,
    'module_db' => 'user_referrer_sales',
    'module_db_key' => 'id',
    'module_type' => 'native',
    'module_config' => [
        'sql_select' => ' SELECT user_referrer_sales.* FROM user_referrer_sales ',
        'sql_where' => ' WHERE user_referrer_sales.id IS NOT NULL',
        'sql_group' => '',
        'table_db' => 'user_referrer_sales',
        'primary_key' => 'id',
        'setting' => [
            'gridtype' => '',
            'orderby' => 'id',
            'ordertype' => 'DESC',
            'perpage' => '50',
            'frozen' => 'false',
            'form-method' => 'native',
            'view-method' => 'native',
            'inline' => 'false',
        ],
        'grid' => [
            [
                'field' => 'id',
                'alias' => 'user_referrer_sales',
                'label' => 'Id',
                'language' => [
                ],
                'search' => '1',
                'download' => '1',
                'align' => 'left',
                'view' => 0,
                'detail' => '1',
                'sortable' => '1',
                'frozen' => '0',
                'hidden' => '0',
                'sortlist' => 0,
                'width' => '100',
                'conn' => [
                    'valid' => '0',
                    'db' => '',
                    'key' => '',
                    'display' => '',
                ],
                'format_as' => '',
                'format_value' => '',
            ],
            [
                'field' => 'sales_id',
                'alias' => 'user_referrer_sales',
                'label' => 'Sales Id',
                'language' => [
                ],
                'search' => '1',
                'download' => '1',
                'align' => 'left',
                'view' => 0,
                'detail' => '1',
                'sortable' => '1',
                'frozen' => '0',
                'hidden' => '0',
                'sortlist' => 1,
                'width' => '100',
                'conn' => [
                    'valid' => 1,
                    'db' => 'sales',
                    'key' => 'id',
                    'display' => 'network_id',
                ],
                'format_as' => '',
                'format_value' => '',
            ],
            [
                'field' => 'user_id',
                'alias' => 'user_referrer_sales',
                'label' => 'User Id',
                'language' => [
                ],
                'search' => '1',
                'download' => '1',
                'align' => 'left',
                'view' => 0,
                'detail' => '1',
                'sortable' => '1',
                'frozen' => '0',
                'hidden' => '0',
                'sortlist' => 2,
                'width' => '100',
                'conn' => [
                    'valid' => 1,
                    'db' => 'users',
                    'key' => 'user_id',
                    'display' => 'first_name',
                ],
                'format_as' => '',
                'format_value' => '',
            ],
            [
                'field' => 'shopper_id',
                'alias' => 'user_referrer_sales',
                'label' => 'Shopper Id',
                'language' => [
                ],
                'search' => '1',
                'download' => '1',
                'align' => 'left',
                'view' => 0,
                'detail' => '1',
                'sortable' => '1',
                'frozen' => '0',
                'hidden' => '0',
                'sortlist' => 3,
                'width' => '100',
                'conn' => [
                    'valid' => 1,
                    'db' => 'users',
                    'key' => 'user_id',
                    'display' => 'first_name',
                ],
                'format_as' => '',
                'format_value' => '',
            ],
            [
                'field' => 'order_amount',
                'alias' => 'user_referrer_sales',
                'label' => 'Order Amount',
                'language' => [
                ],
                'search' => '1',
                'download' => '1',
                'align' => 'left',
                'view' => 0,
                'detail' => '1',
                'sortable' => '1',
                'frozen' => '0',
                'hidden' => '0',
                'sortlist' => 4,
                'width' => '100',
                'conn' => [
                    'valid' => '0',
                    'db' => '',
                    'key' => '',
                    'display' => '',
                ],
                'format_as' => '',
                'format_value' => '',
            ],
            [
                'field' => 'transaction_time',
                'alias' => 'user_referrer_sales',
                'label' => 'Transaction Time',
                'language' => [
                ],
                'search' => '1',
                'download' => '1',
                'align' => 'left',
                'view' => 1,
                'detail' => '1',
                'sortable' => '1',
                'frozen' => '0',
                'hidden' => '0',
                'sortlist' => 5,
                'width' => '100',
                'conn' => [
                    'valid' => '0',
                    'db' => '',
                    'key' => '',
                    'display' => '',
                ],
                'format_as' => '',
                'format_value' => '',
            ],
            [
                'field' => 'store_id',
                'alias' => 'user_referrer_sales',
                'label' => 'Store Id',
                'language' => [
                ],
                'search' => '1',
                'download' => '1',
                'align' => 'left',
                'view' => 0,
                'detail' => '1',
                'sortable' => '1',
                'frozen' => '0',
                'hidden' => '0',
                'sortlist' => 6,
                'width' => '100',
                'conn' => [
                    'valid' => '0',
                    'db' => '',
                    'key' => '',
                    'display' => '',
                ],
                'format_as' => '',
                'format_value' => '',
            ],
            [
                'field' => 'referral_amount',
                'alias' => 'user_referrer_sales',
                'label' => 'Referral Amount',
                'language' => [
                ],
                'search' => '1',
                'download' => '1',
                'align' => 'left',
                'view' => 0,
                'detail' => '1',
                'sortable' => '1',
                'frozen' => '0',
                'hidden' => '0',
                'sortlist' => 7,
                'width' => '100',
                'conn' => [
                    'valid' => '0',
                    'db' => '',
                    'key' => '',
                    'display' => '',
                ],
                'format_as' => '',
                'format_value' => '',
            ],
            [
                'field' => 'currency',
                'alias' => 'user_referrer_sales',
                'label' => 'Currency',
                'language' => [
                ],
                'search' => '1',
                'download' => '1',
                'align' => 'left',
                'view' => 1,
                'detail' => '1',
                'sortable' => '1',
                'frozen' => '0',
                'hidden' => '0',
                'sortlist' => 8,
                'width' => '100',
                'conn' => [
                    'valid' => '0',
                    'db' => '',
                    'key' => '',
                    'display' => '',
                ],
                'format_as' => '',
                'format_value' => '',
            ],
            [
                'field' => 'status',
                'alias' => 'user_referrer_sales',
                'label' => 'Status',
                'language' => [
                ],
                'search' => '1',
                'download' => '1',
                'align' => 'left',
                'view' => 0,
                'detail' => '1',
                'sortable' => '1',
                'frozen' => '0',
                'hidden' => '0',
                'sortlist' => 9,
                'width' => '100',
                'conn' => [
                    'valid' => '0',
                    'db' => '',
                    'key' => '',
                    'display' => '',
                ],
                'format_as' => '',
                'format_value' => '',
            ],
            [
                'field' => 'created_at',
                'alias' => 'user_referrer_sales',
                'label' => 'Created At',
                'language' => [
                ],
                'search' => '1',
                'download' => '1',
                'align' => 'left',
                'view' => 0,
                'detail' => '1',
                'sortable' => '1',
                'frozen' => '0',
                'hidden' => '0',
                'sortlist' => 10,
                'width' => '100',
                'conn' => [
                    'valid' => '0',
                    'db' => '',
                    'key' => '',
                    'display' => '',
                ],
                'format_as' => '',
                'format_value' => '',
            ],
            [
                'field' => 'updated_at',
                'alias' => 'user_referrer_sales',
                'label' => 'Updated At',
                'language' => [
                ],
                'search' => '1',
                'download' => '1',
                'align' => 'left',
                'view' => 0,
                'detail' => '1',
                'sortable' => '1',
                'frozen' => '0',
                'hidden' => '0',
                'sortlist' => 11,
                'width' => '100',
                'conn' => [
                    'valid' => '0',
                    'db' => '',
                    'key' => '',
                    'display' => '',
                ],
                'format_as' => '',
                'format_value' => '',
            ],
        ],
        'forms' => [
            [
                'field' => 'id',
                'alias' => 'user_referrer_sales',
                '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' => 'sales_id',
                'alias' => 'user_referrer_sales',
                'label' => 'Sales Id',
                'language' => [
                ],
                'required' => 0,
                'default' => NULL,
                'validations' => '',
                'view' => '1',
                'type' => 'select',
                'add' => '1',
                'edit' => '1',
                'search' => '1',
                'size' => 'span12',
                'sortlist' => 1,
                'form_group' => '',
                'option' => [
                    'opt_type' => 'external',
                    'lookup_query' => '',
                    'lookup_table' => 'sales',
                    'lookup_key' => 'id',
                    'lookup_value' => 'network_id',
                    '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_referrer_sales',
                'label' => 'User Id',
                'language' => [
                ],
                'required' => 0,
                'default' => NULL,
                'validations' => '',
                'view' => '1',
                'type' => 'select',
                'add' => '1',
                'edit' => '1',
                'search' => '1',
                'size' => 'span12',
                'sortlist' => 2,
                'form_group' => '',
                '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' => '',
                    'upload_type' => '',
                    'tooltip' => '',
                    'attribute' => '',
                    'extend_class' => '',
                    'is_json' => 0,
                    'is_ajax' => 1,
                ],
            ],
            [
                'field' => 'shopper_id',
                'alias' => 'user_referrer_sales',
                'label' => 'Shopper Id',
                'language' => [
                ],
                'required' => 0,
                'default' => NULL,
                'validations' => '',
                'view' => '1',
                'type' => 'select',
                'add' => '1',
                'edit' => '1',
                'search' => '1',
                'size' => 'span12',
                'sortlist' => 3,
                'form_group' => '',
                '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' => '',
                    'upload_type' => '',
                    'tooltip' => '',
                    'attribute' => '',
                    'extend_class' => '',
                    'is_json' => 0,
                    'is_ajax' => 1,
                ],
            ],
            [
                'field' => 'order_amount',
                'alias' => 'user_referrer_sales',
                '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' => 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' => 'transaction_time',
                'alias' => 'user_referrer_sales',
                'label' => 'Transaction Time',
                'language' => [
                ],
                'required' => 1,
                'default' => NULL,
                'validations' => '',
                'view' => '1',
                'type' => 'text_datetime',
                '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' => 'store_id',
                'alias' => 'user_referrer_sales',
                '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' => 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' => 'referral_amount',
                'alias' => 'user_referrer_sales',
                'label' => 'Referral Amount',
                'language' => [
                ],
                'required' => 0,
                'default' => NULL,
                'validations' => 'maxlength="10"',
                'view' => '1',
                'type' => 'text_decimal',
                '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' => 'currency',
                'alias' => 'user_referrer_sales',
                'label' => 'Currency',
                'language' => [
                ],
                'required' => 1,
                'default' => NULL,
                'validations' => 'maxlength="3"',
                'view' => '1',
                'type' => 'text',
                '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' => 'status',
                'alias' => 'user_referrer_sales',
                'label' => 'Status',
                'language' => [
                ],
                'required' => 0,
                'default' => NULL,
                'validations' => '',
                'view' => '1',
                'type' => 'radio',
                'add' => '1',
                'edit' => '1',
                'search' => '1',
                'size' => 'span12',
                'sortlist' => 9,
                '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' => 'user_referrer_sales',
                'label' => 'Created At',
                'language' => [
                ],
                'required' => 0,
                'default' => 'CURRENT_TIMESTAMP',
                'validations' => '',
                'view' => 0,
                'type' => 'update_timestamp',
                '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' => 'updated_at',
                'alias' => 'user_referrer_sales',
                'label' => 'Updated At',
                'language' => [
                ],
                'required' => 0,
                'default' => NULL,
                'validations' => '',
                'view' => 0,
                'type' => 'update_timestamp',
                '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,
                ],
            ],
        ],
    ],
    'module_lang' => NULL,
];