Tips and trick Feature

src/features/tips_and_trick.py

+from PyQt5 import QtCore, QtGui, QtWidgets
+import mysql.connector
+
+db = mysql.connector.connect(
+    host="localhost",
+    user="root",
+    password="# isi password",
+    database="toptrackr"
+)
+
+mycursor = db.cursor()
+
+mycursor.execute("SELECT id_customer_premium FROM customer_premium")
+
+listidpremium = [id[0] for id in mycursor.fetchall()]
+
+
+class tips_and_trick(object):
+    def tipsAndTrickUi(self, Frame):
+        # * Frame
+        Frame.setObjectName("Frame")
+        Frame.setFixedSize(367, 280)
+        Frame.setStyleSheet("background-color: rgb(238, 238, 238);")
+        Frame.setFrameShape(QtWidgets.QFrame.Panel)
+        Frame.setFrameShadow(QtWidgets.QFrame.Raised)
+
+        # * Title
+        self.label = QtWidgets.QLabel(Frame)
+        self.label.setText("Tips And Trick")
+        font = QtGui.QFont()
+        font.setFamily("Lucida Console")
+        font.setPointSize(18)
+        self.label.setFont(font)
+        self.label.move(90, 20)
+
+        # * Content
+        tipsAndTrickContent = "Lorem ipsum dolor sit amet consectetur adipisicing elit. Dicta, vel ipsa a architecto laboriosam voluptatum, omnis unde doloribus consequuntur beatae nam debitis nesciunt tempore, sunt numquam aspernatur asperiores ratione cumque quasi. Quibusdam corrupti ducimus velit? Vero nisi voluptatibus dolore incidunt ea voluptates repellat, quisquam quis animi provident"
+        self.content = QtWidgets.QLabel(tipsAndTrickContent, Frame)
+        self.content.setGeometry(23, 60, 320, 200)
+        self.content.setStyleSheet("border : 2px solid black; padding: 10px;")
+        self.content.setWordWrap(True)
+        font = QtGui.QFont()
+        font.setFamily("Lucida Console")
+        font.setPointSize(10)
+        self.content.setFont(font)
+    
+    def notPremiumUi(self, Frame):
+        # * Frame
+        Frame.setObjectName("Frame")
+        Frame.setFixedSize(367, 280)
+        Frame.setStyleSheet("background-color: rgb(238, 238, 238);")
+        Frame.setFrameShape(QtWidgets.QFrame.Panel)
+        Frame.setFrameShadow(QtWidgets.QFrame.Raised)
+
+        # * Title
+        self.label = QtWidgets.QLabel(Frame)
+        self.label.setText("Tips And Trick")
+        font = QtGui.QFont()
+        font.setFamily("Lucida Console")
+        font.setPointSize(18)
+        self.label.setFont(font)
+        self.label.move(90, 20)
+
+        # * Content
+        tipsAndTrickContent = "Anda bukan Customer Premium"
+        self.content = QtWidgets.QLabel(tipsAndTrickContent, Frame)
+        self.content.setGeometry(23, 60, 320, 200)
+        self.content.setStyleSheet("border : 2px solid black; padding: 10px; color: red; text-align: center;")
+        self.content.setWordWrap(True)
+        font = QtGui.QFont()
+        font.setFamily("Lucida Console")
+        font.setPointSize(30)
+        self.content.setFont(font)
+    
+    def openTipsAndTrick(self, Frame, userId):
+        self.idpremium = listidpremium
+        if userId in self.idpremium:
+            self.tipsAndTrickUi(Frame)
+        else:
+            self.notPremiumUi(Frame)
+    
+
+if __name__ == "__main__":
+    import sys
+    app = QtWidgets.QApplication(sys.argv)
+    Frame = QtWidgets.QFrame()
+    ui = tips_and_trick()
+    ui.openTipsAndTrick(Frame, 102)
+    Frame.show()
+    sys.exit(app.exec_())