import csv
import random
import math

def get_demand_table(product_number):
    
    path = 'data/fc_experiment/demand_history.csv'

    number_periods = 10
    ma10 = 0
    actual_demand = 0
    demand_data = []
    mu = 0
    sigma = 0
    min_level = 0
    max_level = 0
    reg_a = 0
    reg_b = 0
    reg_p = 0

    with open(path) as csv_file:
        csv_reader = csv.reader(csv_file, delimiter=';')
        line_count = 0

        demand_table = '<table id="demand_table" border="0">'

        #First row with period numbers
        demand_table += '<tr>'
        demand_table += '<th style="width:90px"><b>Period</b></th>'
        for r in range(1,number_periods+2): #
            demand_table += '<th style="width:45px">' + str(r) + '</th>'
        demand_table += '</tr>'

        demand_table += '<td style="border-top:1px solid black;" colspan="12"></td>'
        
        #Second row with demands
        demand_table += '<tr>'
        demand_table += '<th><b>Demand</b> <br> [units]</th>'
        
        for row in csv_reader:
            if line_count == product_number:
                mu = int(f'{row[1]}')
                sigma = int(f'{row[2]}')
                min_level = int(f'{row[3]}')
                max_level = int(f'{row[4]}')
                ma10 = int(f'{row[5]}')
                reg_a = int(f'{row[6]}')
                reg_b = int(f'{row[7]}')
                reg_p = float(f'{row[8]}')
                

                demand_table += '<td>' + f'{row[9]}' +'</td>'
                demand_table += '<td>' + f'{row[10]}' +'</td>'
                demand_table += '<td>' + f'{row[11]}' +'</td>'
                demand_table += '<td>' + f'{row[12]}' +'</td>'
                demand_table += '<td>' + f'{row[13]}' +'</td>'
                demand_table += '<td>' + f'{row[14]}' +'</td>'
                demand_table += '<td>' + f'{row[15]}' +'</td>'
                demand_table += '<td>' + f'{row[16]}' +'</td>'
                demand_table += '<td>' + f'{row[17]}' +'</td>'
                demand_table += '<td>' + f'{row[18]}' +'</td>'
                demand_table += '<td>' + '?' +'</td>'

                demand_data.append(int(f'{row[9]}'))
                demand_data.append(int(f'{row[10]}'))
                demand_data.append(int(f'{row[11]}'))
                demand_data.append(int(f'{row[12]}'))
                demand_data.append(int(f'{row[13]}'))
                demand_data.append(int(f'{row[14]}'))
                demand_data.append(int(f'{row[15]}'))
                demand_data.append(int(f'{row[16]}'))
                demand_data.append(int(f'{row[17]}'))
                demand_data.append(int(f'{row[18]}'))


                actual_demand = int(f'{row[19]}')
                line_count += 1
            else:
                line_count += 1
 
        demand_table += '</tr>'
        demand_table += '</table>'
            

    return demand_table, ma10, actual_demand, demand_data, mu, sigma, min_level, max_level, reg_a, reg_b, reg_p

def build_nn_table(demand_data):

    #Get weights and min max demands for normalization
    min_demand = []
    max_demand = []
    weight = []
    bias_weight = 0

    path = 'data/fc_experiment/nn_min_max_demand_and_weights.csv'

    with open(path) as csv_file:
        csv_reader = csv.reader(csv_file, delimiter=';')
        line_count = 0
        
        for row in csv_reader:
            if line_count == 1: #Bias weight
                bias_weight = float(f'{row[3]}')

                line_count += 1 
            elif line_count >= 2:
                min_demand.append(float(f'{row[1]}'))
                max_demand.append(float(f'{row[2]}'))
                weight.append(float(f'{row[3]}'))

                line_count += 1
            else:
                line_count += 1

    normed_demand = []
    normed_demand.append(0)
    weighted_normed_demand = []
    weighted_normed_demand.append(0)

    print(min_demand)
    print(max_demand)
    print(demand_data)

    #Compute normed demand and weighted normed demand
    total_weighted_normed_demand = 0
    for i in range(1,11):
        print(i)
        print(demand_data[i-1])
        print(min_demand[i])
        print(max_demand[i])
        normed_demand.append((demand_data[i-1] - min_demand[i])/(max_demand[i] - min_demand[i]))
        weighted_normed_demand.append(normed_demand[i]*weight[i])
        total_weighted_normed_demand += weighted_normed_demand[i]

    #Compute demand forecast
    demand_forecast_period_11_normed = total_weighted_normed_demand + bias_weight
    demand_forecast_period_11 = demand_forecast_period_11_normed * (max_demand[0] - min_demand[0]) + min_demand[0]


    #Consturct Table
    nn_table = '<table id="nn_table" border="0">'

    #First row with headlines
    nn_table += '<tr>'
    nn_table += '<th style="width:90px"><b>Period t</b></th>'
    nn_table += '<th style="width:90px"><b>Demand</b></th>'
    nn_table += '<th style="width:150px"><b>Normed Demand</b></th>'
    nn_table += '<th style="width:90px"><b>Weight</b></th>'
    nn_table += '<th style="width:150px"><b>Weighted Normed Demand</b></th>'
    nn_table += '<tr>'

    #Fill with data for periods 1 to 10
    for i in range(1,11): #iterate through 10 perids
        nn_table += '<tr>'
        nn_table += '<td>' + str(i) + '</td>'
        nn_table += '<td>' + str(demand_data[i-1]) + '</td>'
        nn_table += '<td>' + str(round(normed_demand[i],3)) + '</td>'
        nn_table += '<td>' + str(round(weight[i],3)) + '</td>'
        nn_table += '<td>' + str(round(weighted_normed_demand[i],3)) + '</td>'
        nn_table += '</tr>'


    #Fill with data for bias
    nn_table += '<tr>'
    nn_table += '<td>Bias</td>'
    nn_table += '<td></td>'
    nn_table += '<td>1.000</td>'
    nn_table += '<td>' + str(round(bias_weight,3)) + '</td>'
    nn_table += '<td>' + str(round(bias_weight,3)) + '</td>'
    nn_table += '</tr>'

    nn_table += '<td style="border-top:1px solid black;" colspan="8"></td>'

    #Demand Forecast normalized
    nn_table += '<tr>'
    nn_table += '<td></td>'
    nn_table += '<td colspan="3">Demand forecast for period 11 (normed)</td>'
    nn_table += '<td>' + str(round(demand_forecast_period_11_normed,3)) + '</td>'
    nn_table += '</tr>'

    #Demand Forecast de-normalized
    nn_table += '<tr>'
    nn_table += '<td></td>'
    nn_table += '<td colspan="3"><b>Demand forecast for period 11</b></td>'
    nn_table += '<td><b>' + str(int(round(demand_forecast_period_11,0))) + '</b></td>'
    nn_table += '</tr>'

    nn_table += '<td style="border-top:1px solid black;" colspan="8"></td>'

    nn_table += '</table>'

    return nn_table
    

def buildLikertScale(questions, question_order, text_at_top = 'Statement'):
    
    # table = '<style> td, th {text-align: center;}</style>'

    table = '<table id="likert_table" border="0">'

    width = 80

    table += '<tr>'
    table += '<th style="width:200px"><b>' + text_at_top + '</b></th>'
    table += '<th style="width:' + str(width) + 'px; text-align: center">Strongly disagree</th>'
    table += '<th style="width:' + str(width) + 'px; text-align: center">Disagree</th>'
    table += '<th style="width:' + str(width) + 'px; text-align: center">Somewhat disagree</th>'
    table += '<th style="width:' + str(width) + 'px; text-align: center">Neither agree nor disagree</th>'
    table += '<th style="width:' + str(width) + 'px; text-align: center">Somewhat agree</th>'
    table += '<th style="width:' + str(width) + 'px; text-align: center">Agree</th>'
    table += '<th style="width:' + str(width) + 'px; text-align: center">Strongly agree</th>'
    # table += '<th style="width:200px"><b>Aussage</b></th>'
    # table += '<th style="width:' + str(width) + 'px; text-align: center">Trifft überhaupt nicht zu</th>'
    # table += '<th style="width:' + str(width) + 'px; text-align: center">Trifft nicht zu</th>'
    # table += '<th style="width:' + str(width) + 'px; text-align: center">Trifft eher nicht zu</th>'
    # table += '<th style="width:' + str(width) + 'px; text-align: center">Teils-teils</th>'
    # table += '<th style="width:' + str(width) + 'px; text-align: center">Trifft eher zu</th>'
    # table += '<th style="width:' + str(width) + 'px; text-align: center">Trifft zu</th>'
    # table += '<th style="width:' + str(width) + 'px; text-align: center">Trifft voll zu</th>'
    table += '</tr>'

    table += '<td style="border-top:1px solid black;" colspan="8"></td>'

    question_counter = 0
    likert_scale_number = 7

    for q in question_order:
        question_counter += 1
        table += '<tr style="height:90px">'
        table += '<td>' + str(questions[q-1]) + '</td>'
       
        for l in range(1,likert_scale_number+1):
             table += '<td style="text-align: center"><input type="radio" class="answer" name="q_' + str(q) + '" value="' + str(l) + '"></td>'
             

        table += '</tr>'
        table += '<td style="border-top:1px solid lightgrey;" colspan="8"></td>'

    table += '</table>'

    return question_counter, table 

def buildLikertScale_appropriate(questions, question_order, text_at_top = 'Statement'):
    #CAUTION
    #This liket table "appropriate" is different two the normal likert table, since it allwos to be placed next to a normal likert table.
    #Therefore, the id has changed to "likert_table_appropriate" and the name tag of each radio button has changed from "q_" to "q_a_"
    # table = '<style> td, th {text-align: center;}</style>'

    table = '<table id="likert_table_appropriate" border="0">'

    width = 80

    table += '<tr>'
    table += '<th style="width:200px"><b>' + text_at_top + '</b></th>'
    table += '<th style="width:' + str(width) + 'px; text-align: center">Much less than appropriate</th>'
    table += '<th style="width:' + str(width) + 'px; text-align: center">Less than appropriate</th>'
    table += '<th style="width:' + str(width) + 'px; text-align: center">A bit less than appropriate</th>'
    table += '<th style="width:' + str(width) + 'px; text-align: center">Appropriate</th>'
    table += '<th style="width:' + str(width) + 'px; text-align: center">A bit more than appropriate</th>'
    table += '<th style="width:' + str(width) + 'px; text-align: center">More than appropriate</th>'
    table += '<th style="width:' + str(width) + 'px; text-align: center">Much more than appropriate</th>'
    # table += '<th style="width:200px"><b>Aussage</b></th>'
    # table += '<th style="width:' + str(width) + 'px; text-align: center">Trifft überhaupt nicht zu</th>'
    # table += '<th style="width:' + str(width) + 'px; text-align: center">Trifft nicht zu</th>'
    # table += '<th style="width:' + str(width) + 'px; text-align: center">Trifft eher nicht zu</th>'
    # table += '<th style="width:' + str(width) + 'px; text-align: center">Teils-teils</th>'
    # table += '<th style="width:' + str(width) + 'px; text-align: center">Trifft eher zu</th>'
    # table += '<th style="width:' + str(width) + 'px; text-align: center">Trifft zu</th>'
    # table += '<th style="width:' + str(width) + 'px; text-align: center">Trifft voll zu</th>'
    table += '</tr>'

    table += '<td style="border-top:1px solid black;" colspan="8"></td>'

    question_counter = 0
    likert_scale_number = 7

    for q in question_order:
        question_counter += 1
        table += '<tr style="height:90px">'
        table += '<td>' + str(questions[q-1]) + '</td>'
        
        for l in range(1,likert_scale_number+1):
                table += '<td style="text-align: center"><input type="radio" class="answer" name="q_a_' + str(q) + '" value="' + str(l) + '"></td>'
                

        table += '</tr>'
        table += '<td style="border-top:1px solid lightgrey;" colspan="8"></td>'

    table += '</table>'

    return question_counter, table 
    
def getPayoffTable(self):
    
    product_order = self.participant.vars['product_order']

    payoff_table = '<table id="payoff_table" border="0">'

    payoff_table += '<tr>'
    payoff_table += '<th style="width:110px; vertical-align: text-top"><b>Product</b> <br> </th>'
    payoff_table += '<th style="width:150px"><b>Your forecast</b><br>[units]</th>'
    payoff_table += '<th style="width:150px"><b>Actual demand</b><br>[units]</th>'
    payoff_table += '<th style="width:150px; vertical-align: text-top"><b>Forecast error</b><br> </th>'
    payoff_table += '<th style="width:130px"><b>Reward</b><br>[USD]</th>'
    payoff_table += '<tr>'

    payoff_table += '<td style="border-top:1px solid black;" colspan="6"></td>'

    for r in range(1,len(product_order)+1):
        payoff_table += '<tr>'
        payoff_table += '<td>' + str(r) + '</td>'
        payoff_table += '<td>' + str(self.participant.vars['second_judgement_'  + str(product_order[r-1])]) + '</td>'
        payoff_table += '<td>' + str(self.participant.vars['actual_demand_'  + str(product_order[r-1])]) + '</td>'
        payoff_table += '<td>' + str(round(self.participant.vars['forecast_error_'  + str(product_order[r-1])],3)) + '</td>'
        payoff_table += '<td>' + str(self.participant.vars['payoff_'  + str(product_order[r-1])]) + '</td>'
        payoff_table += '</tr>'

    payoff_table += '<tr>'
    payoff_table += '<td style="border-top:1px solid black;" colspan="6"></td>'
    payoff_table += '</tr>'

    payoff_table += '<tr>'
    payoff_table += '<td></td>'
    payoff_table += '<td></td>'
    payoff_table += '<td></td>'
    payoff_table += '<td>Bonus reward:</td>'
    payoff_table += '<td>' + str(  self.participant.payoff_plus_participation_fee() - self.session.config['participation_fee']) + '</td>'
    payoff_table += '</tr>'

    payoff_table += '<tr>'
    payoff_table += '<td></td>'
    payoff_table += '<td></td>'
    payoff_table += '<td></td>'
    payoff_table += '<td>Fixed reward:</td>'
    payoff_table += '<td>' + str(self.session.config['participation_fee']) + '</td>'
    payoff_table += '</tr>'

    payoff_table += '<tr>'
    payoff_table += '<td style="border-top:1px solid black;" colspan="6"></td>'
    payoff_table += '</tr>'

    payoff_table += '<tr>'
    payoff_table += '<td></td>'
    payoff_table += '<td></td>'
    payoff_table += '<td></td>'
    payoff_table += '<td><b>Total reward:</b></td>'
    payoff_table += '<td><b>' + str(self.participant.payoff_plus_participation_fee()) + '</b></td>'
    payoff_table += '</tr>'
    
    payoff_table += '</table>'

    return payoff_table