def displayHolidays(cursor):
holidays = cursor.execute("""SELECT date, assigneeId, workHours
FROM jobs
WHERE status = 'Holiday'
ORDER BY date DESC
""").fetchall()
ui.displayList(holidays, listBox)
def displayHolidays(cursor):
holidays = cursor.execute("""SELECT date, assigneeId, workHours
FROM jobs
WHERE status = 'Holiday'
ORDER BY date DESC
""").fetchall()
ui.displayList(holidays, listBox)
def displayJobs(cursor):
jobIds.clear()
jobs = cursor.execute("""SELECT jobId, date, assigneeId, customerId, boatId, description
FROM jobs
WHERE status = ?
ORDER BY date DESC
""", [status.get()]).fetchall()
jobIds.extend([job[0] for job in jobs])
ui.displayList(jobs, listBox)
def displayJobs(cursor):
jobIds.clear()
jobs = cursor.execute(
"""SELECT jobId, date, assigneeId, customerId, boatId, description
FROM jobs
WHERE status = ?
ORDER BY date DESC
""", [status.get()]).fetchall()
jobIds.extend([job[0] for job in jobs])
ui.displayList(jobs, listBox)
def displaySkills(cursor):
skills = cursor.execute(
"SELECT skill FROM skills WHERE id = ? AND job = ?"
"", [id, table == "Job"]).fetchall()
ui.displayList(skills, listBox)
def displayEmployees(cursor):
employeeIds.clear()
employees = cursor.execute("SELECT employeeId, name FROM employees"
"").fetchall()
employeeIds.extend([employee[0] for employee in employees])
ui.displayList(employees, listBox)
def displaySkills(cursor):
skills = cursor.execute("SELECT skill FROM skills WHERE id = ? AND job = ?""", [id, table == "Job"]).fetchall()
ui.displayList(skills, listBox)
def displayEmployees(cursor):
employeeIds.clear()
employees = cursor.execute("SELECT employeeId, name FROM employees""").fetchall()
employeeIds.extend([employee[0] for employee in employees])
ui.displayList(employees, listBox)
