Inspector.py 文件源码

def submitReportButtonClicked(self):
        for i in range(0, 15):
            if not self.itemScoreList[i].get():
                messagebox.showwarning("Empty input", "Please enter a score for each item.")
                return False
        for i in range(0, 8):
            if not (int(self.itemScoreList[i].get()) in range(0, 10)):
                messagebox.showwarning("Input out of range", "For items 1-8, the score must be 0-9. You entered "
                                       + self.itemScoreList[i].get() + " for item " + str(i + 1) + ".")
                return False
        for i in range(8, 15):
            if not (int(self.itemScoreList[i].get()) in range(0, 5)):
                messagebox.showwarning("Input out of range", "For items 9-15, the score must be 0-4. You entered "
                                       + self.itemScoreList[i].get() + " for item " + str(i + 1) + ".")
                return False
        result = self.cursor.execute("SELECT iid FROM inspector WHERE iid = %s", self.inspectorID.get())
        if not result:
            messagebox.showwarning("Inspector ID is not exist")
            return False
        result = self.cursor.execute("SELECT rid FROM restaurant WHERE rid = %s", self.restaurantID.get())
        if not result:
            messagebox.showwarning("Restaurant ID is not exist")
            return False
        self.submitReportToDatabase()
        messagebox.showwarning("Submission successful", "Your report has been submitted.")
        self.insertReportWindow.withdraw()
        self.inspectorMenuWindow.deiconify()
        return True
#----------DATABASE INTERACTION METHODS---------------------------------------------