Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sql = "SELECT WEEKlY_DAY, START_TIME, END_TIME FROM ROSTER WHERE EMPLOYEE_ID = %s;"
- cursor = connection.cursor()
- cursor.execute(sql, [employee_id])
- result = cursor.fetchall()
- cursor.close()
- table = []
- for data in result :
- row = {'day': data[0], 'start_time': data[1], 'end_time': data[2]}
- table.append(row)
- return render(request, 'sales_representative_status.html', {'emp_info': emp_info, 'flag': flag, 'table': table})
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement