import csv
import random
import math

def t_number_to_letter(number):
    
    letters = ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z']

    return letters[number-1]

def t_part_id_to_position_in_part_order(part_id, part_order):
    
    position_in_part_order = -1
    # print("This is the part order " + str(part_order))
    # print("This is the part id w are looking for " + str(part_id))
    for i in range(len(part_order)):
        if part_order[i] == part_id:
            position_in_part_order = i+1
            break

    return position_in_part_order

def get_part_set():

    path = 'data/parts_bm_scm.csv'
    capacity = 0

    parts = []

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

        for row in csv_reader:
            if line_count == 0:
                # We take only the capacity from line 1
                capacity = float(f'{row[9]}')
                line_count += 1
            else:
                parts.insert(line_count-1,[int(f'{row[0]}'), int(f'{row[1]}'), int(f'{row[2]}'), float(f'{row[3]}'), int(f'{row[4]}')])
                line_count += 1

    return parts, capacity

def build_table(part_order, treatment, deactivated, show_selection_checkboxes):
    # path = 'data/parts_bm_scm.csv'
    parts, capacity = get_part_set()
    
    if(len(part_order) != len(parts)):
        print("ERROR: The length of the part list csv is not euqal to the part order array!")

    print("Part Order")
    print(part_order)
    
    decision_table = ''

    total_weight_opt = 0
    total_value_opt = 0
    round_selection_opt = ''

    #Style Settings
    color = 'black'
    selection_checkbox = ''
    if deactivated:
        #Style
        color = 'grey'
        sort_link = ''
        selection_checkbox = 'disabled="true"'

    #CSS Style    
    decision_table += '<style>'
    decision_table += 'table, th, td {'
    decision_table += 'color: ' + color + ';'
    decision_table += '}'
    decision_table += '</style>'

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

    decision_table += '<table id="decision_table" border="0">'

    decision_table += '<tr>'
    decision_table += '<th style="width:110px; vertical-align:top"><b>Ersatzteil</b><br></th>'
    decision_table += '<th style="width:110px; vertical-align:top"><b>Gewicht</b><br></th>'
    decision_table += '<th style="width:160px"><b>Häufigkeit<br>des Defekts</b></th>'
    decision_table += '<th style="width:130px; vertical-align:top"><b>Vorschlag des<br>Algorithmus</b><br></th>'
    if show_selection_checkboxes:
        decision_table += '<th style="width:110px; vertical-align:top"><b>Ihre Auswahl</b><br></th>'
    decision_table += '</tr>'


    decision_table += '<td style="border-top:1px solid black;" colspan="'
    
    if show_selection_checkboxes:
        decision_table += '5'
    else:
        decision_table += '4'
    
    decision_table +='"></td>'

    part_counter = 0
    for position in part_order:
        
        part_counter += 1

        #if parts[position-1][4] == 1:
        #    total_weight_opt += parts[position-1][1]
        #    total_value_opt += parts[position-1][2]
        if parts[part_counter-1][4] == 1:
            total_weight_opt += parts[part_counter-1][1]
            total_value_opt += parts[part_counter-1][2]
            round_selection_opt += 'true,'
        else:
            round_selection_opt += 'false,'
        
        decision_table += '<tr>'
        decision_table += '<td>' + t_number_to_letter(part_counter) + '</td>' #Part ID
        decision_table += '<td>' + str(parts[position-1][1]) + '</td>' #Weight
        decision_table += '<td>' + str(parts[position-1][2]) + '</td>' #Value
        rec_presel = ''
        
        rec = ''
        if parts[position-1][4] == 1:
            rec = 'checked=true'
        decision_table += '<td><input type="checkbox" class="o_sol" id="o_part_' + str(parts[position-1][0]) + '" name="o_part_' + str(parts[position-1][0]) + '" value="o_part_' + str(parts[position-1][0]) + '" ' + rec + ' disabled="true"></td>'

        if show_selection_checkboxes:
            decision_table += '<td><input type="checkbox" class="gurke" id="part_' + str(parts[position-1][0]) + '" name="part_' + str(parts[position-1][0]) + '" value="part_' + str(parts[position-1][0]) + '"'+ rec_presel + ' ' + selection_checkbox + '></td>'
        
        decision_table += '<td style="display:none;">' + str(parts[position-1][0]) + '</td>'
        
    decision_table += '<tr>'
    decision_table += '<td style="border-top:1px solid black;" colspan="5"></td>'

    #Total Weight
    decision_table += '<tr><td></td><td></td>'
    decision_table += '<td style="vertical-align:top"><b>Summe Gewicht:</td>'
    decision_table += '<td> <b>' + str(round(total_weight_opt)) + '</b></td>'
    if show_selection_checkboxes:
        decision_table += '<td> <b><span id="total_weight">0</span></b></td>'

    #Total Value
    decision_table += '<tr><td></td><td></td>'
    decision_table += '<td style="vertical-align:top"><b>Summe Häufigkeit:</b></td>'
    decision_table += '<td><b>' + str(round(total_value_opt)) + '</b></td>'
    if show_selection_checkboxes:
        decision_table += '<td><b><span id="total_value">0</span></b></td>'

    decision_table += '</table>'
    
    return decision_table, int(capacity), int(total_weight_opt), int(total_value_opt), round_selection_opt

def build_feedback_table(part_order, treatment, deactivated, decision_str, part_drawn):
    # path = 'data/parts_bm_scm.csv'
    parts, capacity = get_part_set()
    
    # print(decision_str)
    decision = decision_str.split(",")
    print(decision)

    if(len(part_order) != len(parts)):
        print("ERROR: The length of the part list csv is not euqal to the part order array!")

    # print("Part Order")
    # print(part_order)
    
    decision_table = ''

    total_weight_opt = 0
    total_value_opt = 0
    round_selection_opt = ''
    right_part_selected = False

    #Style Settings
    color = 'black'
    selection_checkbox = ''
    if deactivated:
        #Style
        color = 'black'
        sort_link = ''
        selection_checkbox = 'disabled="true"'

    #CSS Style    
    decision_table += '<style>'
    decision_table += 'table, th, td {'
    decision_table += 'color: ' + color + ';'
    decision_table += '}'
    decision_table += '</style>'

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

    decision_table += '<table id="decision_table" border="0">'

    decision_table += '<tr>'
    decision_table += '<th style="width:110px; vertical-align:top"><b>Ersatzteil</b><br></th>'
    decision_table += '<th style="width:110px; vertical-align:top"><b>Gewicht</b><br></th>'
    decision_table += '<th style="width:160px"><b>Häufigkeit<br>des Defekts</b></th>'
    decision_table += '<th style="width:130px; vertical-align:top"><b>Vorschlag des<br>Algorithmus</b><br></th>'
    decision_table += '<th style="width:110px; vertical-align:top"><b>Ihre Auswahl</b><br></th>'
    decision_table += '</tr>'

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

    part_counter = 0
    for position in part_order:
        
        part_counter += 1

        bold_start = ''
        bold_end = ''
        feedback_table_tr_tag = '<tr>'
        if parts[position-1][0] == part_drawn:
            feedback_table_tr_tag = '<tr style="background-color:#C7C7C7">'
           # bold_start = '<b>'
           # bold_end = '</b>'
            if decision[position-1] == 'true':
                right_part_selected = True

        if parts[position-1][4] == 1:
            total_weight_opt += parts[position-1][1]
            total_value_opt += parts[position-1][2]
            round_selection_opt += 'true,'
        else:
            round_selection_opt += 'false,'
        
        decision_table += feedback_table_tr_tag
        decision_table += '<td>' + bold_start + t_number_to_letter(part_counter) + bold_end + '</td>' #Part ID
        decision_table += '<td>' + bold_start + str(parts[position-1][1]) + bold_end + '</td>' #Weight
        decision_table += '<td>' + bold_start + str(parts[position-1][2]) + bold_end + '</td>' #Value
        
        rec = ''
        if parts[position-1][4] == 1:
            rec = 'checked=true'
        decision_table += '<td><input type="checkbox" class="o_sol" id="o_part_' + str(parts[position-1][0]) + '" name="o_part_' + str(parts[position-1][0]) + '" value="o_part_' + str(parts[position-1][0]) + '" ' + rec + ' disabled="true"></td>'

        dec = ''
        #print('Decision for part ' + str(current_part) + ' is ' + str(decision[current_part-1]))
        if decision[position-1] == 'true':
            dec = 'checked = true'             
        decision_table += '<td><input type="checkbox" class="gurke" id="part_' + str(parts[position-1][0]) + '" name="part_' + str(parts[position-1][0]) + '" value="part_' + str(parts[position-1][0]) + '" ' + dec + ' ' + selection_checkbox + '></td>'
        
        decision_table += '<td style="display:none;">' + str(parts[position-1][0]) + '</td>'
        
    decision_table += '<tr>'
    decision_table += '<td style="border-top:1px solid black;" colspan="5"></td>'

    #Total Weight
    decision_table += '<tr><td></td><td></td>'
    decision_table += '<td style="vertical-align:top"><b>Summe Gewicht:</td>'
    decision_table += '<td> <b>' + str(round(total_weight_opt)) + '</b></td>'
    decision_table += '<td> <b><span id="total_weight">0</span></b></td>'

    #Total Value
    decision_table += '<tr><td></td><td></td>'
    decision_table += '<td style="vertical-align:top"><b>Summe Häufigkeit:</b></td>'
    decision_table += '<td><b>' + str(round(total_value_opt)) + '</b></td>'
    decision_table += '<td><b><span id="total_value">0</span></b></td>'

    decision_table += '</table>'
    
    return decision_table, right_part_selected

def build_table_old(part_order, treatment, deactivated, own_decision, show_value_and_weight_recommendation, preselected):
    
    path = 'data/parts_bm_scm.csv'
    
    decision_table = ''
    capacity = 0

    total_weight_sug = 0
    total_value_sug = 0
    round_selection_sug = ''

    #Style Settings
    color = 'black'
    sort_link = 'href="#"'
    selection_checkbox = ''
    if deactivated:
        #Style
        color = 'grey'
        sort_link = ''
        selection_checkbox = 'disabled="true"'

    #CSS Style    
    decision_table += '<style>'
    decision_table += 'table, th, td {'
    decision_table += 'color: ' + color + ';'
    decision_table += '}'

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

        decision_table += '<table id="decision_table" border="0">'

        decision_table += '<tr>'
        decision_table += '<th style="width:110px"><b><a id="sort_id" ' + sort_link + '>Item<span id="arrow_part"></span></a></b> <br>ID</th>'
        decision_table += '<th style="width:110px"><b><a id="sort_w" ' + sort_link + '>Weight<span id="arrow_weight"></span></a></b><br>[oz]</th>'
        decision_table += '<th style="width:140px"><b><a id="sort_p" ' + sort_link + '>Value<span id="arrow_prob"></span></a></b><br>[&#162;]</th>'
        #decision_table += '<th style="width:130px"><b><a id="sort_r" ' + sort_link + '>Ratio<span id="arrow_ratio"></span></a></b><br>[&#162;/oz]</th>'
        if own_decision:
            decision_table += '<th style="width:100px; vertical-align:top"><b>Your First Selection</b><br></th>'
        if treatment != 'no_sol':
            decision_table += '<th style="width:200px; vertical-align:top"><b>Recommendation</b><br></th>' #We do not set a recommendation column for treatment 'no_sol'
        decision_table += '<th style="width:220px; vertical-align:top"><b>Your Selection</b><br></th>'
        decision_table += '</tr>'

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

        for row in csv_reader:
            if line_count == 0:
                # We take only the capacity from line 1
                capacity = float(f'{row[9]}')
                line_count += 1
            else:

                #Save opt weight and value
                if int((f'{row[4]}')) == 1:
                    total_weight_opt += float(f'{row[1]}')
                    total_value_opt += float(f'{row[2]}')
                    round_selection_opt += 'true,'
                else:
                    round_selection_opt += 'false,'

                decision_table += '<tr>'
                decision_table += '<td>' + (f'{row[0]}') + '</td>' #Part ID
                decision_table += '<td>' + (f'{row[1]}') + '</td>' #Weight
                decision_table += '<td>' + (f'{row[2]}') + '</td>' #Value
                #decision_table += '<td>' + str(round(float(f'{row[3]}'),2)) + '</td>' #Ratio
                #decision_table += '<td>' + (f'{row[3]}') + '</td>' #Ratio
                if own_decision:
                    decision_table += '<td><input type="checkbox" class="own_sol" id="own_part_' + (f'{row[0]}') + '" name="own_part_' + (f'{row[0]}') + '" value="own_part_' + (f'{row[0]}') + '" disabled="true"></td>'
                 #Recommendation is only given in treatments 'opt_sol' and 'heur_sol'
                rec_presel = ''
                if (treatment == 'opt_sol'):
                    rec = ''
                    if int((f'{row[4]}')) == 1:
                        rec = 'checked=true'
                        if(preselected):
                            rec_presel = 'checked=true '
                        total_weight_sug += float(f'{row[1]}')
                        total_value_sug += float(f'{row[2]}')
                        round_selection_sug += 'true,'
                    else:
                        round_selection_sug += 'false,'
                    decision_table += '<td><input type="checkbox" class="o_sol" id="o_part_' + (f'{row[0]}') + '" name="o_part_' + (f'{row[0]}') + '" value="o_part_' + (f'{row[0]}') + '" ' + rec + ' disabled="true"></td>'
                elif treatment == 'heur_sol':
                    rec = ''
                    if int((f'{row[5]}')) == 1:
                        rec = 'checked=true'
                        if(preselected):
                            rec_presel = 'checked=true'
                        total_weight_sug += float(f'{row[1]}')
                        total_value_sug += float(f'{row[2]}')
                        round_selection_sug += 'true,'
                    else:
                        round_selection_sug += 'false,'
                    decision_table += '<td><input type="checkbox" class="h_sol" id="h_part_' + (f'{row[0]}') + '" name="h_part_' + (f'{row[0]}') + '" value="h_part_' + (f'{row[0]}') + '" ' + rec + ' disabled="true"></td>'
                elif treatment == 'second_sol':
                    rec = ''
                    if int((f'{row[6]}')) == 1:
                        rec = 'checked=true'
                        if(preselected):
                            rec_presel = 'checked=true'
                        total_weight_sug += float(f'{row[1]}')
                        total_value_sug += float(f'{row[2]}')
                        round_selection_sug += 'true,'
                    else:
                        round_selection_sug += 'false,'
                    decision_table += '<td><input type="checkbox" class="h_sol" id="h_part_' + (f'{row[0]}') + '" name="h_part_' + (f'{row[0]}') + '" value="h_part_' + (f'{row[0]}') + '" ' + rec + ' disabled="true"></td>'
                elif treatment == 'third_sol':
                    rec = ''
                    if int((f'{row[7]}')) == 1:
                        rec = 'checked=true'
                        if(preselected):
                            rec_presel = 'checked=true'
                        total_weight_sug += float(f'{row[1]}')
                        total_value_sug += float(f'{row[2]}')
                        round_selection_sug += 'true,'
                    else:
                        round_selection_sug += 'false,'
                    decision_table += '<td><input type="checkbox" class="h_sol" id="h_part_' + (f'{row[0]}') + '" name="h_part_' + (f'{row[0]}') + '" value="h_part_' + (f'{row[0]}') + '" ' + rec + ' disabled="true"></td>'
                
                decision_table += '<td><input type="checkbox" class="gurke" id="part_' + (f'{row[0]}') + '" name="part_' + (f'{row[0]}') + '" value="part_' + (f'{row[0]}') + '"'+ rec_presel + ' ' + selection_checkbox + '></td>'
                line_count += 1

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

        if show_value_and_weight_recommendation and treatment != 'no_sol':
            #Total Weight
            decision_table += '<tr><td></td><td></td><td></td>'
            if own_decision: #Since we have a 'own decision' colum, we have to push the computation of value and weight one column to the right
                decision_table += '<td></td>'
            decision_table += '<td style="vertical-align:top"><b>Total Weight:</td>'
            decision_table += '<td> <b>' + str(round(total_weight_sug)) + ' oz</b></td>'
            decision_table += '<td> <b><span id="total_weight">0</span> oz</b></td>'

            #Total Value
            decision_table += '<tr><td></td><td></td><td></td>'
            if own_decision: #Since we have a 'own decision' colum, we have to push the computation of value and weight one column to the right
                decision_table += '<td></td>'
            decision_table += '<td style="vertical-align:top"><b>Total Value </b>(Value - Fixed Costs): </td>'
            decision_table +=  '<td>' + str(round(total_value_sug)) + '&#162; - 150&#162; = <b>' + str(round(total_value_sug)-150) + '&#162;</b></td>'
            decision_table += '<td> <span id ="total_value_before_fix_cost_reduction">0</span>&#162; - <span id="fix_costs"></span>&#162;  = <b><span id="total_value">0</span>&#162;</b></td>'
        else:
            #Total Weight
            decision_table += '<tr><td></td><td></td><td></td>'
            if treatment != 'no_sol': #Since we have a recommendation colum, we have to push the computation of value and weight one column to the right
                decision_table += '<td></td>'
            if own_decision: #Since we have a 'own decision' colum, we have to push the computation of value and weight one column to the right
                decision_table += '<td></td>'
            decision_table += '<td style="vertical-align:top"><b>Total Weight:</td> <td> <b> <span id="total_weight">0</span> oz</b></td>'

            #Total Value
            decision_table += '<tr><td></td><td></td><td></td>'
            if treatment != 'no_sol':
                decision_table += '<td></td>'
            if own_decision: #Since we have a 'own decision' colum, we have to push the computation of value and weight one column to the right
                decision_table += '<td></td>'
            decision_table += '<td style="vertical-align:top"><b>Total Value </b>(Value - Fixed Costs): </td> <td> <span id ="total_value_before_fix_cost_reduction">0</span>&#162; - <span id="fix_costs"></span>&#162;  = <b><span id="total_value">0</span>&#162;</b></td>'

        decision_table += '</table>'
    
    return decision_table, int(capacity), int(total_weight_sug), int(total_value_sug), round_selection_sug, int(total_weight_opt), int(total_value_opt), round_selection_opt

def build_feedback_table_old(table_id, treatment, decision_str, part_drawn):
    path = 'data/parts_' + str(table_id) + '.csv'
    print(decision_str)
    decision = decision_str.split(",")
    print(decision)
    feedback_table = ''
    capacity = 0
    current_part = 1

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

        feedback_table += '<table id="decision_table" border="0">'

        feedback_table += '<tr>'
        feedback_table += '<th style="width:110px"><b>Item<span id="arrow_part"></span></b> <br>ID</th>'
        feedback_table += '<th style="width:110px"><b>Weight<span id="arrow_weight"></span></b><br>[oz]</th>'
        feedback_table += '<th style="width:140px"><b>Value<span id="arrow_prob"></span></b><br>[USD]</th>'
        feedback_table += '<th style="width:130px"><b>Ratio<span id="arrow_ratio"></span></b><br>[USD/oz]</th>'
        if treatment != 'no_sol':
            feedback_table += '<th style="width:200px; vertical-align:top"><b>Recommendation</b><br></th>' #We do not set a recommendation column for treatment 'no_sol'
        feedback_table += '<th style="width:200px; vertical-align:top"><b>Your Selection</b><br></th>'
        feedback_table += '</tr>'

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

        for row in csv_reader:
            if line_count == 0:
                # We take only the capacity from line 1
                capacity = float(f'{row[7]}')
                line_count += 1
            else:
                bold_start = ''
                bold_end = ''
                if current_part == part_drawn:
                    feedback_table += '<tr style="background-color:#C7C7C7">'
                    bold_start = '<b>'
                    bold_end = '</b>'
                else:
                    feedback_table += '<tr>'
                feedback_table += '<td>' + bold_start + (f'{row[0]}') + bold_end + '</td>' #Item ID
                feedback_table += '<td>' + bold_start + (f'{row[1]}') + bold_end + '</td>' #Weight
                feedback_table += '<td>' + bold_start + (f'{row[2]}') + bold_end + '</td>' #Value
                feedback_table += '<td>' + bold_start + (f'{row[3]}') + bold_end + '</td>' #Ratio

                #Recommendation is only given in treatments 'opt_sol' and 'heur_sol'
                if treatment == 'opt_sol':
                    rec = ''
                    if int((f'{row[4]}')) == 1:
                        rec = 'checked=true'
                    feedback_table += '<td>' + bold_start + '<input type="checkbox" class="o_sol" id="o_part_' + (f'{row[0]}') + '" name="o_part_' + (f'{row[0]}') + '" value="o_part_' + (f'{row[0]}') + '" ' + rec + ' disabled="true">' + bold_end + '</td>'
                elif treatment == 'heur_sol':
                    rec = ''
                    if int((f'{row[5]}')) == 1:
                        rec = 'checked=true'
                    feedback_table += '<td>' + bold_start + '<input type="checkbox" class="h_sol" id="h_part_' + (f'{row[0]}') + '" name="h_part_' + (f'{row[0]}') + '" value="h_part_' + (f'{row[0]}') + '" ' + rec + ' disabled="true">' + bold_end + '</td>'
                #Own Selection from previous round
                dec = ''
                #print('Decision for part ' + str(current_part) + ' is ' + str(decision[current_part-1]))
                if decision[current_part-1] == 'true':
                    dec = 'checked = true'             
                feedback_table += '<td>' + bold_start + '<input type="checkbox" class="gurke" id="part_' + (f'{row[0]}') + '" name="part_' + (f'{row[0]}') + '" value="part_' + (f'{row[0]}') + '" ' + dec + ' disabled="true">' + bold_end + '</td>'
                line_count += 1
                current_part += 1

        feedback_table += '<tr>'
        feedback_table += '<td style="border-top:1px solid black;" colspan="6"></td>'
        feedback_table += '<tr><td style="vertical-align:top"><b>Total Weight:</b></td><td><b><p id="total_weight">0</p></b></td>'

        feedback_table += '</table>'
    
    return feedback_table, capacity

def partDrawnWasSelected(decision_str, part_drawn):
    decision = decision_str.split(",")
    if decision[part_drawn-1] == 'true':
        return True
    else:
        return False

def compute_performance_measures(self):
    #Avg. efficiency across rounds
    #Avg. adherence (binär)
    #Avg. adherence (relativ)
    #Avg. number of sucessfull rounds
    avg_player_efficiency = 0
    avg_player_adherence_binary = 0
    avg_player_adherence_relative = 0
    avg_player_sucessfull_rounds = 0

    first_round_non_opt = 0

    print(self.session.vars['periods'])

    for r in range(1,self.session.vars['periods']+1):
        avg_player_efficiency += self.participant.vars['efficiency_selection_round_' + str(r)]
        avg_player_adherence_binary += self.participant.vars['followed_recommendation_round_' + str(r)]
        avg_player_adherence_relative += self.participant.vars['relative_adherence_round_' + str(r)]
        avg_player_sucessfull_rounds += self.participant.vars['fulfilled_demand_round_' + str(r)]

        if (first_round_non_opt == 0 and (self.participant.vars['efficiency_selection_round_' + str(r)] <1)):
            first_round_non_opt = r

    avg_player_efficiency /= self.session.vars['periods']
    avg_player_adherence_binary /= self.session.vars['periods']
    avg_player_adherence_relative /= self.session.vars['periods']
    avg_player_sucessfull_rounds /= self.session.vars['periods']

    self.player.avg_efficiency_across_round = avg_player_efficiency
    self.player.avg_adherence_binary = avg_player_adherence_binary
    self.player.avg_adherence_relative = avg_player_adherence_relative
    self.player.avg_sucessfull_rounds = avg_player_sucessfull_rounds
    self.player.first_round_not_optimal = first_round_non_opt

    print(self.player.avg_efficiency_across_round)
    print(self.player.avg_adherence_binary)
    print(self.player.avg_adherence_relative)
    print(self.player.avg_sucessfull_rounds)
    print(self.player.first_round_not_optimal)

def getTextFeedbackPage(decision, part_drawn):
    text_begin = ('According to the probabilities shown <b>part ' + str(part_drawn) + ' was drawn</b>.'
        '<br>')
    if partDrawnWasSelected(decision, part_drawn):
        text_begin += 'Well done! You <b>had the required part ' + str(part_drawn) + ' in your vehicle</b>. You reveive <b>1 ECU</b> for this round.'
    else:
        text_begin += 'You <b>did not select the required part</b> into your vehice. You do not receive a payment for this round.'
    
    return text_begin

def getTextTreatmentPage(treatment):
    title = ''
    text_your_task = ('You can put as many items in your backpack as you like, as long as the total weight of all selected items does <b>not exceed the backpack\'s capacity</b>. '
        'The <b>total value</b> of your backpack is the <b>sum of the value of all selected items minus the fixed costs</b> for the backpack. '
        'Once you have made your choice, you hit the button “Fix your selection and finish round”.')
    text_begin = ''
    table_explanation = ('The table contains the following information'
        '<br>'
        '<br>'
        '<ul>'
        '<li><b>Weight:</b> The weight of the item that will count towards the backpack\'s capacity in case you select the item.</li>'
        '<br>'
        '<li><b>Value:</b> The value assigned to the item.</li>'
        '<br>'
        '<li><b>Ratio:</b> The ratio between the value and the weight.</li>')

    if treatment == 'no_sol':
        title = 'Example'
        text_begin = ('In each round, you will see a table with the items out of which you can make your selection.'
            '<br>'
            '<br>'
            'A table for an example set of items looks like this:')

    elif (treatment == 'opt_sol' or treatment == 'opt_sol_v'):
        title = 'Decision Support'
        text_begin = ('An <b>algorithm</b> has solved the problem. It selects items such that – given the backpack\'s capacity – the total value of the items in the backpack is maximized. The recommendation of the algorithm is shown in the item table.'
            '<br>'
            '<br>'
            'A table for an example set of items looks like this:')
        table_explanation += ('<br>'
            '<b><li>Recommendation: </b> The algorithm would make this selection.</li>')

    elif (treatment == 'opt_sol_presel'):
        title = 'Decision Support'
        text_begin = ('An <b>algorithm</b> has solved the problem. It selects items such that – given the backpack\'s capacity – the total value of the items in the backpack is maximized. The recommendation of the algorithm is shown in the item table and is preselected.'
            '<br>'
            '<br>'
            'A table for an example set of items looks like this:')
        table_explanation += ('<br>'
            '<b><li>Recommendation: </b> The algorithm would make this selection.</li>')

    elif treatment == 'heur_sol':
        title = 'Decision Support'
        text_begin = ('An <b>algorithm</b> has solved the problem. It selects items such that – given the backpack\'s capacity – the total value of the items in the backpack is high. The recommendation of the algorithm is shown in the item table.'
            '<br>'
            '<br>'
            'A table for an example set of items looks like this:')
        table_explanation += ('<br>'
            '<b><li>Recommendation: </b> The algorithm would make this selection.</li>')

    elif treatment == 'opt_sec':
        title = 'Decision Support'
        text_your_task = ('You can put as many items in your backpack as you like, as long as the total weight of all selected items does <b>not exceed the backpack\'s capacity</b>. '
            'The <b>total value</b> of your backpack is the <b>sum of the value of all selected items minus the fixed costs</b> for the backpack.') #We do not want to tell them to click "Fix selection and submit" at this point
        text_begin = ('An <b>algorithm</b> has solved the problem. It selects items such that – given the backpack\'s capacity – the total value of the items in the backpack is high. '
            'In each round, the <b>sequence of actions</b> is as follows:'
            ' <ol> <br><li> You can try to solve the problem on your own.</li><br>'
            '<li> Once you want to see the algorithms solution, click on the button "Show the recommendation".</li><br>'
            '<li> If you like, you can change your selection. For your reference you can see "Your first Selection". </li><br>'
            '<li> Once you have made your choice, you hit the button “Fix your selection and finish round”. </li><br>'
            '</ol> <br>'
            'During step 3, a table for an example set of items looks like this:')
        table_explanation += ('<br>'
            '<b><li>Your first Selection: </b> Your selection before seeing the algorithms solution.</li>'
            '<br>'
            '<b><li>Recommendation: </b> The algorithm would make this selection.</li>')

    elif (treatment == 'decide_opt_sol' or treatment == 'decide_opt_sol_v'):
        title = 'Decide on your Support'
        text_begin = ('An <b>algorithm</b> has solved the problem. It selects items such that – given the backpack\'s capacity – the total value of the items in the backpack is maximized. '
            'In each round, you have to decide whether you want to see the recommendation of the algorithm or not:'
            '<br>'
            '<br>'
            '<div style="box-sizing: border-box; border: 2px solid black; padding: 30px;">'
            + getSelectionPageTreatmentText('active', '', False, treatment) +
            '</div>'
            '<br>'
            'If you select \"Yes\", the recommendation of the algorithm is shown in the item table. If you select \"No\", no recommendation is shown in the item table.'
            '<br>'
            '<br>'
            'Based on your decision, the table for an example set of items looks like this:')    
        table_explanation += ('<br>'
            '<b><li>[Recommendation: </b> The algorithm would make this selection.]</li>')

    elif treatment == 'opt_heur_dec':
        title = 'Decide on your Support'
        text_begin = ('Two <b>algorithms</b> have solved the problem, an easy algorithm and an optimal algorithm:'
            '<br>'
            '<br>'
            '<li>The <b>easy algorithm</b> selects items in a simple way such that – given the backpack\'s capacity – the total value of the items in the backpack is high.</li>'
            '<li>The <b>optimal algorithm</b> selects items in an optimal way such that – given the backpack\'s capacity – the total value of the items in the backpack is maximized.</li>'
            '<br>'
            'In each round, you have to decide on the recommendation of the algorithm you want to see:'
            '<br>'
            '<br>'
            '<div style="box-sizing: border-box; border: 2px solid black; padding: 30px;">'
            + getSelectionPageTreatmentText('active', '', False, 'opt_heur_dec_c') +
            '<b>Please note that you can make this choice only once per round and cannot change your decision!</b>'
            '</div>'
            '<br>'
            'Based on your decision, the table for an example set of items looks like this:')    
        table_explanation += ('<br>'
            '<b><li>Recommendation: </b> The algorithm would make this selection.</li>')

    elif treatment == 'opt_heur_dec_c':
        title = 'Decide on your Support'
        text_begin = ('Two <b>algorithms</b> have solved the problem, an easy algorithm and an optimal algorithm:'
            '<br>'
            '<br>'
            '<li>The <b>easy algorithm</b> selects items in a simple way such that – given the backpack\'s capacity – the total value of the items in the backpack is high.</li>'
            '<li>The <b>optimal algorithm</b> selects items in an optimal way such that – given the backpack\'s capacity – the total value of the items in the backpack is maximized.</li>'
            '<br>'
            'In each round, you have to decide on the recommendation of the algorithm you want to see:'
            '<br>'
            '<br>'
            '<div style="box-sizing: border-box; border: 2px solid black; padding: 30px;">'
            + getSelectionPageTreatmentText('active', '', False, 'opt_heur_dec_c') +
            '</div>'
            '<br>'
            'Based on your decision, the table for an example set of items looks like this:')    
        table_explanation += ('<br>'
            '<b><li>Recommendation: </b> The algorithm would make this selection.</li>')
    
    elif treatment == 'decide_three_sol_c':
        title = 'Decide on your Support'
        (treatment_text, dummy) = getSelectionPageTreatmentText('active', '', False, 'decide_three_sol_c')
        text_begin = ('Three <b>algorithms</b> have solved the problem. '
            'They select items in different ways such that – given the backpack\'s capacity – the total value of the items in the backpack is high.'
            '<br>'
            'In each round, you can look at the recommendations of the algorithms: '
            '<br>'
            '<br>'
            '<div style="box-sizing: border-box; border: 2px solid black; padding: 30px;">'
            + treatment_text +
            '</div>'
            '<br>'
            'Based on your decision, the table for an example set of items looks like this:')    
        table_explanation += ('<br>'
            '<b><li>Recommendation: </b> The algorithm would make this selection.</li>')
        
        
    else:
        title = '!Undefined Treatment Title!'
        text_begin = '!Undefined Treatment!'

    table_explanation += ('<br>'
        '<li><b>Your Selection: </b> You can make your selection by clicking the respective checkboxes.')
    
    table_explanation += ('</li>'
        '</ul>'
        '<br>'
        'You can sort the item table by <i>Item ID, Weight, Value</i> or <i>Ratio</i> by clicking on the table headings.'
        '<br>'
        '<br>'
        '<b>Please '
        )  
    
    if (treatment == 'decide_opt_sol' or treatment == 'decide_opt_sol_v'):
        table_explanation += ('click on one of the buttons above. Afterwards, ')
        
    table_explanation += ('sort the table once by clicking on one of the headings to be able to continue.</b>'
        )

    return title, text_your_task, text_begin, table_explanation

def getRandomPart(table_id):
    
    path = 'data/parts_' + str(table_id) + '.csv'
    prob_smaller_than_current_part = 0
    part_probabilities = []

    with open(path) as csv_file:
        csv_reader = csv.reader(csv_file, delimiter=';')
        line_count = 0
        for row in csv_reader:
            if line_count == 0:
                # We do not need the capacity
                line_count += 1
            else:
                prob_smaller_than_current_part += float(f'{row[2]}')
                part_probabilities.append(prob_smaller_than_current_part)
                line_count += 1
    
    #DEVELOPMENT
    print('Probabilities: ' + str(part_probabilities))

    random_nr = random.uniform(0, 1)
    part_id = 0

    #DEVELOPMENT
    print('Random Numbers: ' + str(random_nr))

    for part_probability in part_probabilities:
        part_id = part_id+1
        if random_nr <= part_probability:
            break

    print('Part ID: ' + str(part_id))
    
    return part_id

def buildResultTableBonusPoints(bp_quiz, bp_decisions, bp_trust_questionnaire, bp_general_questionnaire):
    result_table = '<table id="decision_table" border="0">'

    result_table += '<tr>'
    result_table += '<th style="width:150px"><b>Spiel-Abschnitt</b></th>'
    result_table += '<th style="width:150px"><b>Ihre erreichten Bonuspunkte</b></th>'
    result_table += '<tr>'

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

    result_table += '<tr>'
    result_table += '<td> Verständnisfragen </td>'
    result_table += '<td>' + str(bp_quiz) + '</td>'
    result_table += '</tr>'

    result_table += '<tr>'
    result_table += '<td> Ihre Reparaturen </td>'
    result_table += '<td>' + str(bp_decisions) + '</td>'
    result_table += '</tr>'

    result_table += '<tr>'
    result_table += '<td> Fragebogen Teil 1 </td>'
    result_table += '<td>' + str(bp_trust_questionnaire) + '</td>'
    result_table += '</tr>'

    result_table += '<tr>'
    result_table += '<td> Fragebogen Teil 2 </td>'
    result_table += '<td>' + str(bp_general_questionnaire) + '</td>'
    result_table += '</tr>'

    result_table += '<tr>'
    result_table += '<td style="border-top:1px solid black;" colspan="6"></td>'
  #  result_table += '<tr><td></td><td style="vertical-align:top"><b>Total Value:</b></td><td><b>' + str(sumvalue) + '&#162;</b></td>'

    result_table += '</table>'

    total_bonus_points = bp_quiz + bp_decisions + bp_trust_questionnaire + bp_general_questionnaire
    total_bonus_points = math.ceil(total_bonus_points)

    return total_bonus_points, result_table

def buildResultTable(rounds, weight, value):

    result_table = '<table id="decision_table" border="0">'

    result_table += '<tr>'
    result_table += '<th style="width:110px"><b>Round</b> <br>ID</th>'
    result_table += '<th style="width:110px"><b>Total Weight</b><br>[oz]</th>'
    result_table += '<th style="width:140px"><b>Total Value</b><br>[&#162;]</th>'
    result_table += '<tr>'

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

    sumvalue = 0

    for r in range(1,rounds+1):
        result_table += '<tr>'
        result_table += '<td>' + str(r) + '</td>'
        result_table += '<td>' + str(weight[r-1]) + '</td>'
        result_table += '<td>' + str(value[r-1]) + '</td>'
        result_table += '</tr>'

        sumvalue = sumvalue+value[r-1]

    sumvalue_cent = int(sumvalue)
    sumvalue_dollar = sumvalue_cent/100

    result_table += '<tr>'
    result_table += '<td style="border-top:1px solid black;" colspan="6"></td>'
    result_table += '<tr><td></td><td style="vertical-align:top"><b>Total Value:</b></td><td><b>' + str(sumvalue) + '&#162;</b></td>'

    result_table += '</table>'

    return sumvalue_cent, sumvalue_dollar, result_table

def buildResultTableRandomRoundPayoff(rounds, weight, value, payoff_round):
    
    result_table = '<table id="decision_table" border="0">'

    result_table += '<tr>'
    result_table += '<th style="width:110px"><b>Round</b> <br>ID</th>'
    result_table += '<th style="width:110px"><b>Total Weight</b><br>[oz]</th>'
    result_table += '<th style="width:140px"><b>Total Value</b><br>[&#162;]</th>'
    result_table += '<tr>'

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

    sumvalue = 0

    for r in range(1,rounds+1):
        bold_start = ''
        bold_end = ''
        table_start = '<tr>'
        if r == payoff_round:
            bold_start = '<b>'
            bold_end = '</b>'
            table_start += '<tr style="background-color:#C7C7C7">'
        
        result_table += table_start
        result_table += '<td>' + bold_start + str(r) + bold_end + '</td>'
        result_table += '<td>' + bold_start + str(weight[r-1]) + bold_end + '</td>'
        result_table += '<td>' + bold_start + str(value[r-1]) + bold_end + '</td>'
        result_table += '</tr>'

        sumvalue = sumvalue+value[r-1]

    sumvalue_cent = int(sumvalue)
    sumvalue_dollar = sumvalue_cent/100
    roundpayoff_cent = int(value[payoff_round-1])
    roundpayoff_dollar = roundpayoff_cent/100

    result_table += '<tr>'
    result_table += '<td style="border-top:1px solid black;" colspan="6"></td>'
    result_table += '<tr><td></td><td style="vertical-align:top"><b>Value of selected round:</b></td><td><b>' + str(roundpayoff_cent) + '&#162;</b></td>'

    result_table += '</table>'

    return sumvalue_cent, sumvalue_dollar, roundpayoff_cent, roundpayoff_dollar, result_table

def buildLikertScale(questions, question_order):

    # 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>Statement</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 getSelectionPageTreatmentText(key, recommendation_decision, next_button, treatment):
    color_deactivated = 'black'
    color_no = ''
    color_yes = ''
    disabled = ''
    btn_class = ''
    buttons = ''

    if key == 'disabled':
        disabled = 'disabled'
        color_deactivated = 'grey'

    if recommendation_decision == 'opt':
        color_no = 'style="background-color: ' + color_deactivated + '; border-color: ' + color_deactivated + '"'

    if recommendation_decision == 'none':
        color_yes = 'style="background-color: ' + color_deactivated + '; border-color: ' + color_deactivated + '"'

    if next_button == False:
        btn_class = 'type="button" name="offer_accepted" value="False" class="btn btn-primary btn-large"'

    treatment_text = ''
    if treatment == 'decide_opt_sol' or treatment == 'decide_opt_sol_v':
        treatment_text += '<span style="color:' + color_deactivated + '">'
        treatment_text += 'Do you want to see the recommendation of the algorithm?'
        treatment_text += '<br>'
        treatment_text += '<b>Please note that you can make this choice only once per round and cannot change your decision!</b>'
        treatment_text += '</span>'
        treatment_text += '<br>'
        treatment_text += '<br>'
        treatment_text += '<button ' + btn_class + ' ' + color_yes + ' onclick="setRecommendationRequest(true)" style="float: left;" id="reco_decision_yes_id" ' + disabled + '>Yes</button>&nbsp;&nbsp;'
        treatment_text += '<button ' + btn_class + ' ' + color_no + ' onclick="setRecommendationRequest(false)" id="reco_decision_no_id" ' + disabled + '>No</button>'
        treatment_text += '<br>'
    elif treatment == 'opt_heur_dec' or treatment == 'opt_heur_dec_c':
        treatment_text += '<span style="color:' + color_deactivated + '">'
        treatment_text += 'Which recommendation would you like to see?'
        treatment_text += '<br>'
        if treatment == 'opt_heur_dec':
            treatment_text += '<b>Please note that you can make this choice only once per round and cannot change your decision!</b>'
        treatment_text += '</span>'
        treatment_text += '<br>'
        treatment_text += '<br>'
        treatment_text += '<button ' + btn_class + ' ' + color_yes + ' onclick="showRecommendation(' + "' ', 'heur_sol' " + ')" style="float: left;" id="decision_heur" ' + disabled + '>Easy algorithm</button>&nbsp;&nbsp;'
        treatment_text += '<button ' + btn_class + ' ' + color_no + ' onclick="showRecommendation(' + "' ', 'opt_sol' " + ')" id="decision_opt" ' + disabled + '>Optimal algorithm</button>'
        treatment_text += '<br>'
    elif treatment == 'decide_three_sol_c':
        buttons = ["opt", "second", "third"]
        random.shuffle(buttons)

        print("Shuffled button sequence: " + str(buttons))

        treatment_text += '<span style="color:' + color_deactivated + '">'
        treatment_text += 'Which recommendation would you like to see?'
        treatment_text += '<br>'
       # if treatment == 'opt_heur_dec':
        #    treatment_text += '<b>Please note that you can make this choice only once per round and cannot change your decision!</b>'
        treatment_text += '</span>'
        treatment_text += '<br>'
        treatment_text += '<br>'
        treatment_text += '<button ' + btn_class + ' ' + color_no + ' onclick="showRecommendation(' + "' ', '" + buttons[0] + "_sol' " + ')" style="float: left;" id="decision_' + buttons[0] + '"' + disabled + '>Algorithm A</button>&nbsp;&nbsp;'
        treatment_text += '<button ' + btn_class + ' ' + color_no + ' onclick="showRecommendation(' + "' ', '" + buttons[1] + "_sol' " + ')" id="decision_' + buttons[1] + '" ' + disabled + '>Algorithm B</button>&nbsp;&nbsp;'
        treatment_text += '<button ' + btn_class + ' ' + color_no + ' onclick="showRecommendation(' + "' ', '" + buttons[2] + "_sol' " + ')" id="decision_' + buttons[2] + '" ' + disabled + '>Algorithm C</button>&nbsp;&nbsp;'
        treatment_text += '<br>'
    
    return treatment_text, str(buttons)

def getSelectionPageButton(own_decision_button, next_button):
    color_deactivated = 'black'
    color_own_decision = ''
    color_next = ''
    disabled_own_decision = ''
    disabled_next = ''
    btn_class = 'type="button" name="offer_accepted" value="False" class="btn btn-primary btn-large"'
    button_text = ''

    if own_decision_button == True:
        disabled_next = 'disabled'

    else:
        disabled_own_decision = 'disabled'

    if next_button == False:
        disabled_next = 'disabled'
    #     color_deactivated = 'grey'

    # if recommendation_decision == 'opt':
    #     color_no = 'style="background-color: ' + color_deactivated + '; border-color: ' + color_deactivated + '"'

    # if recommendation_decision == 'none':
    #     color_yes = 'style="background-color: ' + color_deactivated + '; border-color: ' + color_deactivated + '"'

    # if next_button == False:
    #     btn_class = 'type="button" name="offer_accepted" value="False" class="btn btn-primary btn-large"'

    button_text += '<button class="otree-btn-next btn btn-primary" onclick="saveSelection()" style="float: right;" id="Next_Button"' + disabled_next + '>Fix your Selection and finish round</button>&nbsp;&nbsp;'
    
    if own_decision_button == True:
        button_text += '<button ' + btn_class + ' onclick="saveFirstSelection()" style="float: right;" id="show_rec" ' + disabled_own_decision + '>Show me recommendation of the algorithm</button>&nbsp;&nbsp;'
    
   # button_text += '<button class="otree-btn-next btn btn-primary next-button otree-next-button" id="Next_Button" ' + disabled_next + 'onclick="saveSelection()" style="float: right;">Fix your Selection and finish round</button>'
    


   # button_text = '<button class="otree-btn-next btn btn-primary next-button otree-next-button" id="Next_Button" onclick="saveSelection()" style="float: right;">Fix your Selection and finish round</button>'
    
    return button_text