# !page: admin_register
# !latest updated: 09Jul2021

from flask import render_template, request, Blueprint
from modules.database_modules import db_connect
from functions.date_time_functions import current_day
from htmlmin.minify import html_minify


user_webview_tarot = Blueprint("user_webview_tarot", __name__, static_folder="static",
                               template_folder="templates")


@user_webview_tarot.route("/", methods=['GET'])
def tarotView():
    header = request.headers
    # authKey = header.get('Authorization')
    # serverAuth = '88d464b2c2f13bcd7d1d648126e0e8aa5abeb5b1a209639f4e53d994696a422587b403fd69e1baa27b21deb03c2020fd3303e5cdc3ded8e0bc686b5dbbcd37ae'
    # if authKey == serverAuth:
    qtype = request.args.get('qtype')
    con = db_connect()
    cur = con.cursor(dictionary=True, buffered=True)
    # qtype = 1
    cur.execute(
        'select cateogry_type from tarot_question_category where id=%s', (qtype,))
    c_name = cur.fetchone()['cateogry_type']
    con.disconnect()
    return html_minify(render_template('tarot_webview_port.html', rows=[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11], qtype=qtype, appTitle=c_name))
    # return jsonify({'message': 'unauthorized access'}), 401


@user_webview_tarot.route("/card-result", methods=['GET'])
def tarotCardResult():
    header = request.headers
    authKey = header.get('Authorization')
    serverAuth = '88d464b2c2f13bcd7d1d648126e0e8aa5abeb5b1a209639f4e53d994696a422587b403fd69e1baa27b21deb03c2020fd3303e5cdc3ded8e0bc686b5dbbcd37ae'
    # if authKey == serverAuth:
    con = db_connect()
    cur = con.cursor(dictionary=True, buffered=True)
    cur.execute(
        'select result_mm, result_eng from tarot_result where card_id=%s and question_id=%s', (request.args.get('cardID'), request.args.get('qtype')))
    cardResult = cur.fetchone()
    cur.execute(
        'select card_name_eng, card_name_mm, img_path from tarot_card where id=%s', (request.args.get('cardID'),))
    cardDetails = cur.fetchone()
    con.disconnect()
    return html_minify(render_template('tarot_webview_result.html', cardResult=cardResult, cardDetails=cardDetails))
    # return jsonify({'message': 'unauthorized access'}), 401


@user_webview_tarot.route("/lattan-test", methods=['GET'])
def lattanTest():
    header = request.headers
    authKey = header.get('Authorization')
    serverAuth = '88d464b2c2f13bcd7d1d648126e0e8aa5abeb5b1a209639f4e53d994696a422587b403fd69e1baa27b21deb03c2020fd3303e5cdc3ded8e0bc686b5dbbcd37ae'
    # if authKey == serverAuth:
    con = db_connect()
    cur = con.cursor(buffered=True)
    currentDay = current_day()
    cur.execute('select id from lattan_days where days=%s', (currentDay,))
    currentDayID = cur.fetchone()

    q_wordCount = 14
    ans_dayID = currentDayID[0] + q_wordCount % 7
    if ans_dayID > 7:
        ans_dayID = ans_dayID - 7

    cur.execute('select days from lattan_days where id=%s', (ans_dayID,))
    ansDay = cur.fetchone()
    print(ansDay[0])
    return ''
    # return jsonify({'message': 'unauthorized access'}), 401


# *************************************************************************************************************************************************