from services.database import DatabaseEngine

from PySide6.QtCore import Qt
from PySide6.QtWidgets import (
    QMainWindow,
    QTableWidget,
    QTableWidgetItem,
    QLabel,
    QScrollArea,
    QPushButton
)

from styles.styles import (
    get_font,
    table_style,
    scroll_area_style,
    label_style_two,
    button_style
)

class PreviousGames(QMainWindow):
    def __init__(self, window_manager, logged_in_user):
        super(PreviousGames, self).__init__()

        self.window_manager = window_manager
        self.logged_in_user = logged_in_user

        self.db_engine = DatabaseEngine()

        self.font = get_font()
        self.table_style = table_style()
        self.scroll_area_style = scroll_area_style()
        self.label_style = label_style_two()
        self.button_style = button_style()

        self.setStyleSheet("background-color: #D1258A;")
        self.UiComponents()
        self.showMaximized()

    def UiComponents(self):
        # self.table = QTableWidget(self)
        # self.table.setGeometry(20,20,1880,970)
        # self.table.setStyleSheet(self.table_style)
        # self.table.setColumnCount(7)

        # self.table.setItem(0,0, QTableWidgetItem("Id"))
        # self.table.setItem(0,1, QTableWidgetItem("Username"))
        # self.table.setItem(0,2, QTableWidgetItem("Stars"))
        # self.table.setItem(0,3, QTableWidgetItem("Game Played"))
        # self.table.setItem(0,4, QTableWidgetItem("Correct"))
        # self.table.setItem(0,5, QTableWidgetItem("Wrong"))
        # self.table.setItem(0,6, QTableWidgetItem("Total"))

        # user_games = self.db_engine.get_user_games(self.logged_in_user)

        # x = 1
        # y = 0

        # """
        # [(1, 'mekasu0124', 3, 'addition', 25, 19, 25), (2, 'mekasu0124', 15, 'subtraction', 16, 13, 25)]
        # """

        # if user_games:
        #     for index, value in enumerate(user_games):
        #         self.table.setItem(x,y, QTableWidgetItem(user_games[index][0]))
        #         y += 1

        self.scroll_area = QScrollArea(self)
        self.scroll_area.setGeometry(20,20,1880,900)
        self.scroll_area.setStyleSheet(self.scroll_area_style)

        self.label = QLabel(
            "Id    | Username        | Stars         | Game Type         | Correct           | Wrong          | Total",
            self.scroll_area
        )
        self.label.setGeometry(20,20,1850,70)
        self.label.setStyleSheet(self.label_style)
        self.label.setFont(self.font)
        self.label.setWordWrap(False)
        self.label.setAlignment(Qt.AlignCenter)

        user_games = self.db_engine.get_user_games(self.logged_in_user)

        if user_games:
            x = 20
            y = 100

            for i in range(len(user_games)):
                for index, value in enumerate(user_games):
                    text = ""

                    for j in user_games[index]:
                        text += f"{j}              "

                    self.label = QLabel(text, self.scroll_area)
                    self.label.setGeometry(x,y,1850,70)
                    self.label.setStyleSheet(self.label_style)
                    self.label.setFont(self.font)
                    self.label.setWordWrap(False)
                    self.label.setAlignment(Qt.AlignCenter)

                y += 100

        self.button = QPushButton("Back", self)
        self.button.setGeometry(820,920,300,70)
        self.button.setStyleSheet(self.button_style)
        self.button.setFont(self.font)
        self.button.clicked.connect(self.back_button)

    def back_button(self):
        self.window_manager.close_window()