ogp.rb

# coding: utf-8
require 'sinatra'
require 'sequel'
require 'csv'
require 'dotenv'
require 'sinatra/r18n'
require_relative 'models/init.rb'
require_relative 'lib/form_data.rb'
require 'sendgrid-ruby'
include SendGrid

Dotenv.load
R18n::I18n.default = 'es'

# Start Rollbar config
require 'rollbar'
Rollbar.configure do |config|
  config.access_token = ENV['ROLLBAR_ACCESS_TOKEN']
end
# End Rollbar config

before do
  session[:locale] = params.fetch('locale', 'es')
end

get '/' do
  erb :index
end

get '/inscription' do
  inscription = Inscription.new
  erb :form, locals: { inscription: inscription }
end

post '/enviar' do
  inscription = create_inscription(params)
  inscription.save
  erb :thanks
end

#get '/complete-inscription' do
#  inscription = Inscription.new
#  erb :complete_form, locals: { inscription: inscription }
#end

post '/complete' do
  inscription = Inscription.where('lower(email) = ?', params[:email].downcase)
  if inscription.count == 0
    inscription = Inscription.new
    inscription.valid?
    inscription.errors.add(:email, "El email "+params[:email]+" no esta asociado con ninguna inscricpión, porfavor use el mismo email que uso para registrarse anteriormente.")
    return erb :complete_form, locals: { inscription: inscription }
  end  
  if params[:event] 
    inscription.update( 
      :event => params[:event].join(', '),
      :personal_facebook => params[:personal_facebook],
      :personal_twitter => params[:personal_twitter],
      :personal_instagram => params[:personal_instagram],
      :personal_github => params[:personal_github],
      :lunch_confirmation => params[:lunch_confirmation],
      :food_preference =>  params[:food_preference] ? params[:food_preference].join(', ') : '',
      :allergy => params[:allergy],
      :comments_suggestions => params[:comments_suggestions],
      :new_inscription_form => 'No' )
  else 
    inscription.update( 
      :personal_facebook => params[:personal_facebook],
      :personal_twitter => params[:personal_twitter],
      :personal_instagram => params[:personal_instagram],
      :personal_github => params[:personal_github],
      :lunch_confirmation => params[:lunch_confirmation],
      :food_preference =>  params[:food_preference] ? params[:food_preference].join(', ') : '',
      :allergy => params[:allergy],
      :comments_suggestions => params[:comments_suggestions],
      :new_inscription_form => 'No' )
  end

  erb :thanks
end

get '/thanks' do
  erb :thanks
end

get '/agenda' do
  erb :agenda
end

get '/gobcamp' do
  erb :gobcamp
end

get '/taller-datos-abiertos' do
  erb :taller_datos_abiertos
end

get '/data-bootcamp' do
  erb :data_bootcamp
end

get '/taller-tecnico-regional' do
  erb :taller_tecnico_regional
end

get '/data-art' do
  erb :data_art
end

get '/siguiendo-el-dinero' do
  erb :siguiendo_el_dinero
end

get '/datos-y-chiliguaros' do
  erb :datos_y_chiliguaros
end

get '/sedes' do
  erb :sedes
end

get '/evento' do
  erb :evento
end

get '/ciudad' do
  erb :montevideo
end

get '/contact' do
  erb :contact
end

post '/contactar' do
 
  data = JSON.parse('{
    "personalizations": [
      {
        "to": [
          {
            "email":"'+ ENV['CONTACT_EMAIL'] +'"
          }
        ],
        "subject": "[CONDATOS/ABRELATAM] - correo de: '+params['name']+'"
      }
    ],
    "from": {
      "email": "'+params['email']+'"
    },
    "content": [
      {
        "type": "text/plain",
        "value": "Nombre: '+params['name']+' \n Correo: '+params['email']+' \n Organización: '+params['email']+' \n País: '+params['country']+' \n \n Mensaje: '+params['message']+'"
      }
    ]
  }')
  sg = SendGrid::API.new(api_key: ENV['SENDGRID_APIKEY'])
  response = sg.client.mail._("send").post(request_body: data)
  puts response.status_code
  puts response.body

  erb :contactar
end

get '/export_inscriptions' do
  protected!
  Sequel::Plugins::CsvSerializer.configure(
    Inscription,
    col_sep: ',',
    encoding: 'UTF-8'
  )
  content_type 'application/csv'
  attachment 'inscripciones.csv'
  csv = "name,surname,gender,email,country_origin,country_residence,job,open_data_usage,particpated_before,scholarship_before,scholarship_more_than_once,participates_in_representation,event,financial_support,thematic,open_data_problem,organization,organization_type,website,facebook,twitter,instagram,participate_as_colaborator,colaborator_area,has_proposition,proposition_title,proposition_summary,proposition_why_include,proposition_others_needed,organization_role,github,personal_facebook,personal_twitter,personal_instagram,personal_github,lunch_confirmation,food_preference,allergy,comments_suggestions,new_inscription_form\n"
  Inscription.each do |inscription|
    csv << inscription.to_csv(except: :id)
  end
  csv
end

def create_inscription(params)
  inscription = Inscription.new(
    name: params[:name], 
    surname: params[:surname],
    gender: params[:gender],
    email: params[:email],
    country_origin: params[:country_origin],
    country_residence: params[:country_residence],
    job: params[:job],
    personal_facebook: params[:personal_facebook],
    personal_twitter: params[:personal_twitter],
    personal_instagram: params[:personal_instagram],
    personal_github: params[:personal_github],
    open_data_usage: params[:open_data_usage],
    particpated_before: params[:particpated_before],
    scholarship_before: params[:scholarship_before],
    scholarship_more_than_once: params[:scholarship_more_than_once],
    participates_in_representation: params[:participates_in_representation],
    event: params[:event] ? params[:event].join(', ') : '',
    financial_support: params[:financial_support] ? params[:financial_support].join(', ') : '',
    thematic: params[:thematic] ? params[:thematic].join(', ') : '',
    open_data_problem: params[:open_data_problem],
    organization: params[:organization],
    organization_role: params[:organization_role],
    organization_type: params[:organization_type],
    website: params[:website],
    facebook: params[:facebook],
    twitter: params[:twitter],
    instagram: params[:instagram],
    github: params[:github],
    participate_as_colaborator: params[:participate_as_colaborator],
    colaborator_area: params[:colaborator_area] ? params[:colaborator_area].join(', ') : '',
    has_proposition: params[:has_proposition],
    proposition_title: params[:proposition_title],
    proposition_summary: params[:proposition_summary],
    proposition_why_include: params[:proposition_why_include],
    proposition_others_needed: params[:proposition_others_needed],
    lunch_confirmation: params[:lunch_confirmation],
    food_preference:  params[:food_preference] ? params[:food_preference].join(', ') : '',
    allergy: params[:allergy],
    comments_suggestions: params[:comments_suggestions],
    new_inscription_form: 'Sí' )

  inscription
end

helpers do
  def protected!
    return if authorized?
    headers['WWW-Authenticate'] = 'Basic realm="Restricted Area"'
    halt 401, "No está autorizado\n"
  end

  def authorized?
    @auth ||= Rack::Auth::Basic::Request.new(request.env)
    @auth.provided? && @auth.basic? && @auth.credentials && @auth.credentials == [ENV['CONTACT_EMAIL'], ENV['E_PWD']]
  end

  def home_url
    "#{request.env['rack.url_scheme']}://#{request.env['HTTP_HOST']}"
  end

  def clean_current_url
    regex = /\?.+/
    request.url.gsub(regex, '')
  end

  def language_buttons
    if (session[:locale] == 'es')
      "<a class=\"active\">Español</a>" +
      "<a href=\"#{clean_current_url}?locale=en\">English</a>"
    else
      "<a href=\"#{clean_current_url}?locale=es\">Español</a>" +
      "<a class=\"active\">English</a>"
    end
  end
end