from flask import Flask, escape, request, render_template, redirect, current_app, flash
from aap import app
from flask_login import current_user
from .forms import ScoreForm, RetargetingScoreForm, ScibidsRequestForm, WCMDashRequestForm, BFRequestForm
from .utils import login_required, start_score_process, start_retargeting_score_process, send_bigfish_email, get_requests
import aap.login
from .models import ScoreRequest, BFRequest, ScibidsRequest, WCMDashRequest, RetargetingScoreRequest
from .database import db_session
from datetime import datetime

@app.route('/')
@app.route('/home')
def home(name=None):
    return render_template('home.html', title="Home")

@app.route('/score', methods=['GET', 'POST'])
@login_required(roles="ANY")
def score(name=None):
    form = ScoreForm()
    if form.validate_on_submit():
        new_score_request = ScoreRequest(user_id=current_user.id, name_wcm=form.name_wcm.data, id_wcm=form.id_wcm.data,
                                country=form.country.data, conversion_tag_ids=form.conversion_tag_ids.data, id_wam=form.id_wam.data,
                                tagging_date=form.tagging_date.data, campaign_start=form.campaign_start.data, campaign_end=form.campaign_end.data,
                                request_date=datetime.now())
        db_session.add(new_score_request)
        db_session.commit()
        #start_score_process(new_score_request)
        return redirect('/home')
    return render_template('score.html', form=form, title="Score")

@app.route('/retargeting_score', methods=['GET', 'POST'])
@login_required(roles="ANY")
def retargeting_score(name=None):
    form = RetargetingScoreForm()
    if form.validate_on_submit():
        new_rtg_request = RetargetingScoreRequest(user_id=current_user.id, id_wam=form.id_wam.data, pages_retarget=form.pages_retarget.data,
                            campaign_start=form.campaign_start.data, campaign_end=form.campaign_end.data, request_date=datetime.now())
        db_session.add(new_rtg_request)
        db_session.commit()
        #start_retargeting_score_process(new_rtg_request)
        print("Valid and commited")
        return redirect('/home')

    print(form.errors)
    return render_template('retargeting_score.html', form=form, title="Retargeting Score")

@app.route('/reporting_dashboard', methods=['GET', 'POST'])
@login_required(roles="ANY")
def reporting_dashboard(name=None):
    form = WCMDashRequestForm()

    if form.validate_on_submit():
        new_bf_request = WCMDashRequest(user_id=current_user.id, wcm_name=form.wcm_name.data, id_wcm=form.id_wcm.data,
                            country=form.country.data, conv_tag_id=form.conv_tag_id.data, conv_funnel_tag_id=form.conv_funnel_tag_id.data,
                            campaign_start=form.campaign_start.data, expiration_date=form.expiration_date.data, dynamic=form.dynamic.data,
                            request_date=datetime.now())
        db_session.add(new_bf_request)
        db_session.commit()
        return redirect('/home')
    return render_template('wcm_dash.html', form=form)

@app.route('/scibids_connection', methods=['GET', 'POST'])
@login_required(roles="ANY")
def scibids_connection(name=None):
    form = ScibidsRequestForm()
    if form.validate_on_submit():
        new_scibids_request = ScibidsRequest(user_id=current_user.id, advertiser_name=form.advertiser_name.data, campaign_name=form.campaign_name.data,
                            id_advertiser=form.id_advertiser.data, id_conv_pixel=form.id_conv_pixel.data, id_seg_pixel=form.id_seg_pixel.data,
                            expiration_date=form.expiration_date.data, request_date=datetime.now())
        db_session.add(new_scibids_request)
        db_session.commit()

        #send_bigfish_email(new_bf_request)
    return render_template('scibids_request.html', form=form)

@app.route('/big_fish' , methods=['GET', 'POST'])
@login_required(roles="ANY")
def big_fish(name=None):
    form = BFRequestForm()
    if form.validate_on_submit():
        new_bf_request = BFRequest(user_id=current_user.id, advertiser_name=form.advertiser_name.data, agency=form.agency.data,
                            objective=form.objective.data, budget=form.budget.data, number_bf=form.number_bf.data,
                            keywords_list=form.keywords_list.data, perimeter=form.perimeter.data, responsible=form.responsible.data,
                            notes=form.notes.data, start_date=form.start_date.data, request_date=datetime.now())
        db_session.add(new_bf_request)
        db_session.commit()
        #send_bigfish_email(new_bf_request)
        return redirect('/home')
    return render_template('big_fish.html', form=form, title="Big Fish Request")

@app.route('/history')
@login_required(roles="ANY")
def history(name=None):
    requests = get_requests()
    return render_template('history.html',title="Requests History", requests=requests)

@app.route('/user/<username>')
@login_required(roles="ANY")
def show_user_profile(username):
    # show the user profile for that user
    return 'User %s' % escape(username)