<?php return [
    'module_id' => 334,
    'module_name' => 'googlereports',
    'module_title' => 'Google Reports',
    'module_note' => 'Google Analytics Reports',
    'module_frontend_slug' => '',
    'module_author' => NULL,
    'module_created' => '2020-01-06 22:37:09',
    'module_desc' => NULL,
    'module_db' => 'clicks',
    'module_db_key' => 'id',
    'module_type' => 'blank',
    'module_config' => [
        'sql_select' => ' SELECT clicks.* FROM clicks ',
        'sql_where' => ' WHERE clicks.id IS NOT NULL',
        'sql_group' => '',
        'table_db' => 'clicks',
        'primary_key' => 'id',
        'grid' => [
            [
                'field' => 'id',
                'alias' => 'clicks',
                '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' => 'store_id',
                'alias' => 'clicks',
                'label' => 'Store 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' => 'stores',
                    'key' => 'id',
                    'display' => 'slug',
                ],
                'format_as' => '',
                'format_value' => '',
            ],
            [
                'field' => 'user_id',
                'alias' => 'clicks',
                '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' => 'link_id',
                'alias' => 'clicks',
                'label' => 'Link 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' => 'user_links',
                    'key' => 'id',
                    'display' => 'user_id',
                ],
                'format_as' => '',
                'format_value' => '',
            ],
            [
                'field' => 'click_time',
                'alias' => 'clicks',
                'label' => 'Click Time',
                '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' => 'ip_address',
                'alias' => 'clicks',
                'label' => 'Ip Address',
                'language' => [
                ],
                'search' => '1',
                'download' => '1',
                'align' => 'left',
                'view' => 0,
                'detail' => '1',
                'sortable' => '1',
                'frozen' => '0',
                'hidden' => '0',
                'sortlist' => 5,
                'width' => '100',
                'conn' => [
                    'valid' => '0',
                    'db' => '',
                    'key' => '',
                    'display' => '',
                ],
                'format_as' => '',
                'format_value' => '',
            ],
            [
                'field' => 'source_type',
                'alias' => 'clicks',
                'label' => 'Source Type',
                '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' => 'source_id',
                'alias' => 'clicks',
                'label' => 'Source Id',
                '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' => 'cashback_enabled',
                'alias' => 'clicks',
                'label' => 'Cashback Enabled',
                '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' => 'cashback_percent',
                'alias' => 'clicks',
                'label' => 'Cashback Percent',
                'language' => [
                ],
                'search' => '1',
                'download' => '1',
                'align' => 'left',
                'view' => 1,
                'detail' => '1',
                'sortable' => '1',
                'frozen' => '0',
                'hidden' => '0',
                'sortlist' => 9,
                'width' => '100',
                'conn' => [
                    'valid' => '0',
                    'db' => '',
                    'key' => '',
                    'display' => '',
                ],
                'format_as' => '',
                'format_value' => '',
            ],
            [
                'field' => 'network_id',
                'alias' => 'clicks',
                'label' => 'Network Id',
                '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' => 'http_referrer',
                'alias' => 'clicks',
                'label' => 'Http Referrer',
                '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' => '',
            ],
            [
                'field' => 'redirect_link',
                'alias' => 'clicks',
                'label' => 'Redirect Link',
                'language' => [
                ],
                'search' => '1',
                'download' => '1',
                'align' => 'left',
                'view' => 1,
                'detail' => '1',
                'sortable' => '1',
                'frozen' => '0',
                'hidden' => '0',
                'sortlist' => 12,
                'width' => '100',
                'conn' => [
                    'valid' => '0',
                    'db' => '',
                    'key' => '',
                    'display' => '',
                ],
                'format_as' => '',
                'format_value' => '',
            ],
            [
                'field' => 'original_link',
                'alias' => 'clicks',
                'label' => 'Original Link',
                'language' => [
                ],
                'search' => '1',
                'download' => '1',
                'align' => 'left',
                'view' => 0,
                'detail' => '1',
                'sortable' => '1',
                'frozen' => '0',
                'hidden' => '0',
                'sortlist' => 13,
                'width' => '100',
                'conn' => [
                    'valid' => '0',
                    'db' => '',
                    'key' => '',
                    'display' => '',
                ],
                'format_as' => '',
                'format_value' => '',
            ],
        ],
        'forms' => [
            [
                'field' => 'id',
                'alias' => 'clicks',
                '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' => 'store_id',
                'alias' => 'clicks',
                'label' => 'Store 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' => 'stores',
                    'lookup_key' => 'id',
                    'lookup_value' => 'slug',
                    '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' => 'clicks',
                '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' => 'link_id',
                'alias' => 'clicks',
                'label' => 'Link 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' => 'user_links',
                    'lookup_key' => 'id',
                    'lookup_value' => 'user_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' => 'click_time',
                'alias' => 'clicks',
                'label' => 'Click Time',
                'language' => [
                ],
                'required' => 0,
                'default' => 'CURRENT_TIMESTAMP',
                'validations' => '',
                'view' => '1',
                'type' => 'text_datetime',
                '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' => 'ip_address',
                'alias' => 'clicks',
                'label' => 'Ip Address',
                'language' => [
                ],
                'required' => 0,
                'default' => NULL,
                'validations' => 'maxlength="255"',
                'view' => '1',
                'type' => 'text',
                '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' => 'source_type',
                'alias' => 'clicks',
                'label' => 'Source Type',
                'language' => [
                ],
                'required' => 0,
                'default' => NULL,
                'validations' => '',
                'view' => '1',
                'type' => 'radio',
                'add' => '1',
                'edit' => '1',
                'search' => '1',
                'size' => 'span12',
                'sortlist' => 6,
                'form_group' => '',
                'option' => [
                    'opt_type' => '',
                    'lookup_query' => 'store:Store|coupon:Coupon|slider:Slider|share:Share|store-cat:Store-cat|top-store:Top-store',
                    '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' => 'source_id',
                'alias' => 'clicks',
                'label' => 'Source Id',
                'language' => [
                ],
                'required' => 0,
                'default' => NULL,
                'validations' => 'maxlength="20"',
                'view' => '1',
                'type' => 'text',
                '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_enabled',
                'alias' => 'clicks',
                'label' => 'Cashback Enabled',
                'language' => [
                ],
                'required' => 1,
                'default' => '0',
                'validations' => '',
                'view' => '1',
                'type' => 'switch',
                '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' => 'cashback_percent',
                'alias' => 'clicks',
                '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' => 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' => 'network_id',
                'alias' => 'clicks',
                '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' => 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' => 'http_referrer',
                'alias' => 'clicks',
                'label' => 'Http Referrer',
                'language' => [
                ],
                'required' => 0,
                'default' => NULL,
                'validations' => 'maxlength="2500"',
                'view' => '1',
                'type' => 'text',
                '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' => 'redirect_link',
                'alias' => 'clicks',
                'label' => 'Redirect Link',
                'language' => [
                ],
                'required' => 1,
                'default' => NULL,
                'validations' => 'maxlength="5000"',
                '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' => 'original_link',
                'alias' => 'clicks',
                'label' => 'Original Link',
                'language' => [
                ],
                'required' => 0,
                'default' => NULL,
                'validations' => 'maxlength="5000"',
                '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,
                ],
            ],
        ],
    ],
    'module_lang' => NULL,
];