def MainMenu(email): window = QtWidgets.QMainWindow() try: loadUi('../screens/MainCustomerScreen.ui', window) except: loadUi('screens/MainCustomerScreen.ui', window) window.setWindowTitle("Sistem Tracking Corona Menu") window.btn_account.clicked.connect(lambda: account_clicked(window, email)) window.btn_suhu.clicked.connect(lambda: suhu_clicked(window)) window.btn_harian.clicked.connect(lambda: harian_clicked(window)) window.btn_pesan.clicked.connect(lambda: pesan_clicked(window)) window.btn_member.clicked.connect(lambda: member_clicked(window)) window.btn_logout.clicked.connect(lambda: logout_clicked(window)) text = "E-mail: " + email + "\n" text += "Name: " + lq.getName(email) + "\n" if lq.getMembershipStatus(email)[0] == False: memStatus = "Membership status: Not a member\n" else: memStatus = "Membership status: Member\n" memStatus += "Akun Customer\n" text += memStatus window.lbl_info.setText(text) window.lbl_info.setAlignment(QtCore.Qt.AlignCenter) # Menambahkan widget (harus berurutan) window.stack_widget.addWidget(stm.screenSuhu(lq.getUserID(email))) # Widget Suhu Tubuh window.stack_widget.addWidget(kasus.kasusHarian(False)) # Widget Kasus window.stack_widget.addWidget(prs.screenPesanRumahSakit(email)) # Widget Pemesanan Rumah Sakit window.stack_widget.addWidget(mem.membershipWindow(email)) # Widget Member return window
def test_suhu(): lq.addCustomerEntry('dummycustomer', '*****@*****.**', 'dummycustomer', 87881528311, 2486) email = '*****@*****.**' user_id = lq.getUserID(email) date = QDate.fromString('2021-04-20', 'yyyy-mm-dd') sq.addSuhuEntry(user_id, date, 36) assert (sq.isSuhuExist(user_id, date) == True)
def test_add_customer(): lq.addCustomerEntry('dummycustomer', '*****@*****.**', 'dummycustomer', 87712345, 2486) email = '*****@*****.**' name = lq.getName(email) user_id = lq.getUserID(email) upin = lq.getPIN(email) mem_status = lq.getMembershipStatus(email) assert (name == 'dummycustomer' and upin == 2486 and mem_status[0] == False)
def getReviewedPesananUser(email): if not lq.isEmailExist(email): return False uid = lq.getUserID(email) connection = sqlite3.connect('sistem-tracking-corona.db') cursor = connection.cursor() command = """SELECT * FROM t_prs WHERE timestamp_review IS NOT NULL AND user_id = ?""" cursor.execute(command, (uid, )) rows = cursor.fetchall() if len(rows) == 0: return False return rows
def addPemesananEntry(nama_rs, email): if not isNameExist(nama_rs): return False if not lq.isEmailExist(email): return False connection = sqlite3.connect('sistem-tracking-corona.db') cursor = connection.cursor() user_id = lq.getUserID(email) if isUserExist(user_id): return False rs_id = getRSID(nama_rs) add = (user_id, rs_id) print(add) command = """INSERT INTO t_prs(user_id, rs_id) VALUES (?, ?)""" cursor.execute(command, add) cursor.connection.commit() return True
def test_login_2(): user_id = lq.getUserID('*****@*****.**') assert user_id == 1