# encoding: UTF-8
Report.destroy_all
role_superuser = Role.find_by_name('superuser')
role_admin = Role.find_by_name('admin')
role_supervisor = Role.find_by_name('supervisor')
role_manager = Role.find_by_name('manager')
role_operator = Role.find_by_name('operator')
role_customer = Role.find_by_name('customer')
role_customer_operator = Role.find_by_name('customer_operator')



orders_report = {'remote_template_url'=> 'http://files.mobile-sale.com/reports/orders.xlsx.axlsx', 'name'=> 'По заказам', 'format'=>'xlsx', 'report_params_attributes'=>[{'name'=>'date_after', 'view_name'=>'Дата от', 'param_type'=> 'date', 'required'=> true},{'name'=>'date_before', 'view_name'=>'Дата до', 'param_type'=> 'date', 'required'=> true}, {'name'=>'managers', 'view_name'=>'Менеджеры', 'param_type'=> 'managers_multiselect', 'required'=> false}, {'name'=>'customers', 'view_name'=>'Клиенты', 'param_type'=> 'customers_multiselect', 'required'=> false}, {'name'=>'warehouses', 'view_name'=>'Склады', 'param_type'=> 'warehouses_multiselect', 'required'=> false}, {'name'=>'with_items', 'view_name'=>'Со строками', 'param_type'=> 'boolean', 'required'=> false}]}
report_orders = Report.create(orders_report)
report_orders.roles.push(role_admin, role_supervisor, role_operator, role_superuser, role_manager)

audit_documents_report = {'remote_template_url'=> 'http://files.mobile-sale.com/reports/audit_documents.xlsx.axlsx', 'name'=> 'Мерчендайзинг', 'format'=>'xlsx', 'report_params_attributes'=>[{'name'=>'date_after', 'view_name'=>'Дата от', 'param_type'=> 'date', 'required'=> true},{'name'=>'date_before', 'view_name'=>'Дата до', 'param_type'=> 'date', 'required'=> true},{'name'=>'managers', 'view_name'=>'Менеджеры', 'param_type'=> 'managers_multiselect', 'required'=> false},{'name'=>'customers', 'view_name'=>'Клиенты', 'param_type'=> 'customers_multiselect', 'required'=> false},{'name'=>'with_items', 'view_name'=>'Со строками', 'param_type'=> 'boolean', 'required'=> false}]}
report_audit_documents = Report.create(audit_documents_report)
report_audit_documents.roles.push(role_admin, role_supervisor, role_operator, role_superuser, role_manager)

customer_debts_report = {'remote_template_url'=> 'http://files.mobile-sale.com/reports/customer_debts.xlsx.axlsx', 'name'=> 'Долги клиентов', 'format'=>'xlsx', 'report_params_attributes'=>[{'name'=>'customers', 'view_name'=>'Клиенты', 'param_type'=> 'customers_multiselect', 'required'=> false}]}
report_customers_debts = Report.create(customer_debts_report)
report_customers_debts.roles.push(role_admin, role_supervisor, role_superuser, role_operator)

manager_completed_surveys_report = {'remote_template_url'=> 'http://files.mobile-sale.com/reports/manager_completed_surveys.xlsx.axlsx', 'name'=> 'Заполненные анкеты менеджеров', 'format'=>'xlsx', 'report_params_attributes'=>[{'name'=>'date_after', 'view_name'=>'Дата от', 'param_type'=> 'date', 'required'=> true},{'name'=>'date_before', 'view_name'=>'Дата до', 'param_type'=> 'date', 'required'=> true},{'name'=>'managers', 'view_name'=>'Менеджеры', 'param_type'=> 'managers_multiselect', 'required'=> false},{'name'=>'manager_groups', 'view_name'=>'Группы менеджеров', 'param_type'=> 'manager_groups_multiselect', 'required'=> false},{'name'=>'survey', 'view_name'=>'Анкета', 'param_type'=> 'surveys_select', 'required'=> true},{'name'=>'summary', 'view_name'=>'Сводный', 'param_type'=> 'boolean', 'required'=> false}]}
report_manager_completed_survey = Report.create(manager_completed_surveys_report)
report_manager_completed_survey.roles.push(role_admin, role_supervisor, role_superuser)

manager_movements_report = {'remote_template_url'=> 'http://files.mobile-sale.com/reports/manager_movements.html.erb', 'name'=> 'Передвижение менеджеров', 'format'=>'html', 'report_params_attributes'=>[{'name'=>'date', 'view_name'=>'Дата', 'param_type'=> 'date', 'required'=> true},{'name'=>'manager', 'view_name'=>'Менеджер', 'param_type'=> 'managers_select', 'required'=> true},{'name'=>'display_route_points', 'view_name'=>'Отображать точки маршрута', 'param_type'=> 'boolean', 'required'=> false},{'name'=>'display_actions', 'view_name'=>'Отображать операции', 'param_type'=> 'boolean', 'required'=> false}]}
report_manager_movements = Report.create(manager_movements_report)
report_manager_movements.roles.push(role_admin, role_supervisor, role_superuser)

manager_locations_report = {'remote_template_url'=> 'http://files.mobile-sale.com/reports/managers_location.html.erb', 'name'=> 'Месторасположение менеджеров', 'format'=>'html'}
report_manager_locations = Report.create(manager_locations_report)
report_manager_locations.roles.push(role_admin, role_supervisor, role_superuser)

orders_change_report = {'remote_template_url'=> 'http://files.mobile-sale.com/reports/order_change.xlsx.axlsx', 'name'=> 'Изменение заказов', 'format'=>'xlsx', 'report_params_attributes'=>[{'name'=>'date_after', 'view_name'=>'Дата от', 'param_type'=> 'date', 'required'=> true},{'name'=>'date_before', 'view_name'=>'Дата до', 'param_type'=> 'date', 'required'=> true}, {'name'=>'managers', 'view_name'=>'Менеджеры', 'param_type'=> 'managers_multiselect', 'required'=> false}, {'name'=>'customers', 'view_name'=>'Клиенты', 'param_type'=> 'customers_multiselect', 'required'=> false}, {'name'=>'warehouses', 'view_name'=>'Склады', 'param_type'=> 'warehouses_multiselect', 'required'=> false}, {'name'=>'with_items', 'view_name'=>'Со строками', 'param_type'=> 'boolean', 'required'=> false}]}
report_orders_change = Report.create(orders_change_report)
report_orders_change.roles.push(role_admin, role_supervisor, role_operator, role_superuser)

order_without_mml_report = {'remote_template_url'=> 'http://files.mobile-sale.com/reports/orders_without_mml.xlsx.axlsx', 'name'=> 'По обязательному ассортименту', 'format'=>'xlsx', 'report_params_attributes'=>[{'name'=>'date_after', 'view_name'=>'Дата от', 'param_type'=> 'date', 'required'=> true},{'name'=>'date_before', 'view_name'=>'Дата до', 'param_type'=> 'date', 'required'=> true}, {'name'=>'managers', 'view_name'=>'Менеджеры', 'param_type'=> 'managers_multiselect', 'required'=> false}, {'name'=>'customers', 'view_name'=>'Клиенты', 'param_type'=> 'customers_multiselect', 'required'=> false}, {'name'=>'warehouses', 'view_name'=>'Склады', 'param_type'=> 'warehouses_multiselect', 'required'=> false}]}
report_order_without_mml = Report.create(order_without_mml_report)
report_order_without_mml.roles.push(role_admin, role_supervisor, role_superuser)

payments_report = {'remote_template_url'=> 'http://files.mobile-sale.com/reports/payments.xlsx.axlsx', 'name'=> 'По платежам', 'format'=>'xlsx', 'report_params_attributes'=>[{'name'=>'date_after', 'view_name'=>'Дата от', 'param_type'=> 'date', 'required'=> true}, {'name'=>'date_before', 'view_name'=>'Дата до', 'param_type'=> 'date', 'required'=> true}, {'name'=>'customers', 'view_name'=>'Клиенты', 'param_type'=> 'customers_multiselect', 'required'=> false}]}
report_payments = Report.create(payments_report)
report_payments.roles.push(role_admin, role_supervisor, role_operator, role_superuser)

refunds_report = {'remote_template_url'=> 'http://files.mobile-sale.com/reports/refunds.xlsx.axlsx', 'name'=> 'По возвратам', 'format'=>'xlsx', 'report_params_attributes'=>[{'name'=>'date_after', 'view_name'=>'Дата от', 'param_type'=> 'date', 'required'=> true},{'name'=>'date_before', 'view_name'=>'Дата до', 'param_type'=> 'date', 'required'=> true}, {'name'=>'managers', 'view_name'=>'Менеджеры', 'param_type'=> 'managers_multiselect', 'required'=> false}, {'name'=>'customers', 'view_name'=>'Клиенты', 'param_type'=> 'customers_multiselect', 'required'=> false}, {'name'=>'warehouses', 'view_name'=>'Склады', 'param_type'=> 'warehouses_multiselect', 'required'=> false}, {'name'=>'with_items', 'view_name'=>'Со строками', 'param_type'=> 'boolean', 'required'=> false}]}
report_refunds = Report.create(refunds_report)
report_refunds.roles.push(role_admin, role_supervisor, role_operator, role_superuser)

remainders_report = {'remote_template_url'=> 'http://files.mobile-sale.com/reports/remainders.xlsx.axlsx', 'name'=> 'Остатки', 'format'=>'xlsx', 'report_params_attributes'=>[{'name'=>'warehouses', 'view_name'=>'Склады', 'param_type'=> 'warehouses_multiselect', 'required'=> false}]}
report_remainders = Report.create(remainders_report)
report_remainders.roles.push(role_admin, role_supervisor, role_operator, role_superuser, role_manager)

route_execution_report = {'remote_template_url'=> 'http://files.mobile-sale.com/reports/route_execution.xlsx.axlsx', 'name'=> 'Выполнение маршрута', 'format'=>'xlsx', 'report_params_attributes'=>[{'name'=>'date_after', 'view_name'=>'Дата от', 'param_type'=> 'date', 'required'=> true},{'name'=>'date_before', 'view_name'=>'Дата до', 'param_type'=> 'date', 'required'=> true}, {'name'=>'managers', 'view_name'=>'Менеджеры', 'param_type'=> 'managers_multiselect', 'required'=> false}, {'name'=>'manager_groups', 'view_name'=>'Группы менеджеров', 'param_type'=> 'manager_groups_multiselect', 'required'=> false}, {'name'=>'distance', 'view_name'=>'Расстояние (метр)', 'param_type'=> 'warehouses_multiselect', 'required'=> false}, {'name'=>'detail', 'view_name'=>'Детализация', 'param_type'=> 'boolean', 'required'=> false}, {'name'=>'summary', 'view_name'=>'Сводный', 'param_type'=> 'boolean', 'required'=> false}]}
report_route_execution = Report.create(route_execution_report)
report_route_execution.roles.push(role_admin, role_supervisor, role_operator, role_superuser)

routes_report = {'remote_template_url'=> 'http://files.mobile-sale.com/reports/routes.xlsx.axlsx', 'name'=> 'По маршрутам', 'format'=>'xlsx', 'report_params_attributes'=>[{'name'=>'date_after', 'view_name'=>'Дата от', 'param_type'=> 'date', 'required'=> true}, {'name'=>'date_before', 'view_name'=>'Дата до', 'param_type'=> 'date', 'required'=> true}, {'name'=>'managers', 'view_name'=>'Менеджеры', 'param_type'=> 'managers_multiselect', 'required'=> false}]}
report_routes = Report.create(routes_report)
report_routes.roles.push(role_admin, role_supervisor, role_superuser)

supervisor_completed_surveys_report = {'remote_template_url'=> 'http://files.mobile-sale.com/reports/supervisor_completed_surveys.xlsx.axlsx', 'name'=> 'Заполненные анкеты супервайзеров', 'format'=>'xlsx', 'report_params_attributes'=>[{'name'=>'date_after', 'view_name'=>'Дата от', 'param_type'=> 'date', 'required'=> true}, {'name'=>'date_before', 'view_name'=>'Дата до', 'param_type'=> 'date', 'required'=> true}, {'name'=>'supervisors', 'view_name'=>'Супервайзеры', 'param_type'=> 'supervisors_multiselect', 'required'=> false}, {'name'=>'supervisor_groups', 'view_name'=>'Группы супервайзеров', 'param_type'=> 'supervisor_groups_multiselect', 'required'=> false}, {'name'=>'survey', 'view_name'=>'Анкета', 'param_type'=> 'surveys_select', 'required'=> true}, {'name'=>'summary', 'view_name'=>'Сводный', 'param_type'=> 'boolean', 'required'=> false}]}
report_supervisor_completed_surveys = Report.create(supervisor_completed_surveys_report)
report_supervisor_completed_surveys.roles.push(role_admin, role_supervisor, role_superuser)

supervisor_movements_report = {'remote_template_url'=> 'http://files.mobile-sale.com/reports/supervisor_movements.html.erb', 'name'=> 'Передвижение супервайзеров', 'format'=>'html', 'report_params_attributes'=>[{'name'=>'date', 'view_name'=>'Дата', 'param_type'=> 'date', 'required'=> true},{'name'=>'supervisor', 'view_name'=>'Супервайзер', 'param_type'=> 'supervisors_select', 'required'=> true}]}
report_supervisor_movements = Report.create(supervisor_movements_report)
report_supervisor_movements.roles.push(role_admin, role_supervisor, role_superuser)

supervisor_tasks_report = {'remote_template_url'=> 'http://files.mobile-sale.com/reports/supervisor_tasks.xlsx.axlsx', 'name'=> 'Дневные задачи супервайзеров', 'format'=>'xlsx', 'report_params_attributes'=>[{'name'=>'date_after', 'view_name'=>'Дата от', 'param_type'=> 'date', 'required'=> true}, {'name'=>'date_before', 'view_name'=>'Дата до', 'param_type'=> 'date', 'required'=> true}, {'name'=>'supervisors', 'view_name'=>'Супервайзеры', 'param_type'=> 'supervisors_multiselect', 'required'=> false}, {'name'=>'supervisor_groups', 'view_name'=>'Группы супервайзеров', 'param_type'=> 'supervisor_groups_multiselect', 'required'=> false}, {'name'=>'summary', 'view_name'=>'Сводный', 'param_type'=> 'boolean', 'required'=> false}]}
report_supervisor_tasks = Report.create(supervisor_tasks_report)
report_supervisor_tasks.roles.push(role_admin, role_supervisor, role_superuser)

supervisor_locations_report = {'remote_template_url'=> 'http://files.mobile-sale.com/reports/supervisors_location.html.erb', 'name'=> 'Месторасположение супервайзеров', 'format'=>'html'}
report_supervisor_locations = Report.create(supervisor_locations_report)
report_supervisor_locations.roles.push(role_admin, role_supervisor, role_superuser)

template_routes_report = {'remote_template_url'=> 'http://files.mobile-sale.com/reports/template_routes.xlsx.axlsx', 'name'=> 'По шаблонам маршрутов', 'format'=>'xlsx', 'report_params_attributes'=>[{'name'=>'managers', 'view_name'=>'Менеджеры', 'param_type'=> 'managers_multiselect', 'required'=> false}]}
report_template_routes = Report.create(template_routes_report)
report_template_routes.roles.push(role_admin, role_supervisor, role_superuser)