def my_applications(): if (get_username() == ""): flash ("Please Login!") return redirect(url_for('auth.login')) username = get_username() cursor.execute("SELECT * FROM leave_application WHERE employee_id = %s ORDER BY leave_id DESC", (username,)) leaves = cursor.fetchall() cursor.execute("SELECT * FROM comments ORDER BY leave_id DESC") comments = cursor.fetchall() cursor.execute("SELECT * FROM leaves_left WHERE employee_id = %s ORDER BY year ASC", (username,)) leaves_left = cursor.fetchall() return render_template('user/leaves/my_applications.html', leaves = leaves, comments = comments, leaves_left = leaves_left, title="My Application" , username = username, isadmin = get_isadmin(), role = get_role())
def employees(): cursor.execute("SELECT * FROM employee ORDER BY employee_id ASC ") employees = cursor.fetchall() cursor.execute( "SELECT * FROM department WHERE department_id != 'NONE' ORDER BY department_id ASC" ) departments = cursor.fetchall() return render_template('about/employees.html', title='Employees', employees=employees, departments=departments, username=get_username(), isadmin=get_isadmin(), role=get_role())
def employees(): if get_isadmin() == False: return redirect(url_for('home.error403')) cursor.execute("SELECT * FROM employee ORDER BY employee_id ASC ") employees = cursor.fetchall() cursor.execute( "SELECT * FROM department WHERE department_id != 'NONE' ORDER BY department_id ASC" ) departments = cursor.fetchall() return render_template('admin/employees.html', employees=employees, departments=departments, title="Employees", username=get_username(), isadmin=get_isadmin())
def comment(): if (get_username() == ""): flash ("Please Login!") return redirect(url_for('auth.login')) username = get_username() form = commentFormLower() cursor.execute("SELECT * FROM leave_application WHERE employee_id = %s ORDER BY leave_id DESC", (username,)) leave = cursor.fetchone() cursor.execute("SELECT * FROM comments ORDER BY leave_id DESC") comments = cursor.fetchall() if leave: if leave[6] == "Sent Back": if form.validate_on_submit(): comment = form.comment.data comment_by = username comment_time = str(datetime.datetime.now()) cursor.execute("UPDATE leave_Application SET status = %s WHERE leave_id = (%s)", ("Waiting", leave[0])) cursor.execute("SELECT role FROM comments WHERE leave_id = %s ORDER BY comment_id DESC", (leave[0],)) end_route = cursor.fetchone()[0] cursor.execute("SELECT department_id FROM employee WHERE employee_id = %s", (username,)) department_id = cursor.fetchone()[0] cursor.execute("INSERT INTO leave_requests(role, leave_id, department_id) VALUES(%s, %s, %s)", (end_route, leave[0], department_id)) cursor.execute("INSERT INTO comments(leave_id, comment, comment_time, comment_by, role, department_id) VALUES(%s, %s, %s, %s, %s, %s)", (leave[0], comment, comment_time, comment_by, get_role(), department_id)) conn.commit() flash ('Application Re-sent!') return redirect(url_for('user.dashboard', username = username)) return render_template('user/leaves/comment.html', form = form, leave = leave, comments = comments, title = "Comment", username = username, isadmin = get_isadmin(), role = get_role()) flash ('No action required!') return redirect(url_for('user.dashboard', username = username)) flash ('No action required!') return redirect(url_for('user.dashboard', username = username))
def list_positions(): if get_isadmin() == False: return redirect(url_for('home.error403')) cursor.execute("SELECT * FROM pos ORDER BY position ASC;") positions = cursor.fetchall() return render_template('admin/positions/positions.html', positions=positions, title="Positions", username=get_username(), isadmin=get_isadmin())
def list_hod(): if get_isadmin() == False: return redirect(url_for('home.error403')) cursor.execute("SELECT * FROM hod ORDER BY department_id ASC") hods = cursor.fetchall() return render_template('admin/roles/hod.html', hods=hods, title='HOD', username=get_username(), isadmin=get_isadmin())
def list_ccf(): if get_isadmin() == False: return redirect(url_for('home.error403')) cursor.execute("SELECT * FROM ccf ORDER BY position ASC") poss = cursor.fetchall() return render_template('admin/roles/ccf.html', poss=poss, title='CCF', username=get_username(), isadmin=get_isadmin())
def list_routes(): if get_isadmin() == False: return redirect(url_for('home.error403')) cursor.execute("SELECT * FROM route ORDER BY role") routes = cursor.fetchall() return render_template('admin/route/route.html', routes=routes, title="Routes", username=get_username(), isadmin=get_isadmin())
def leave_requests(): if (get_username() == ""): flash ("Please Login!") return redirect(url_for('auth.login')) username = get_username() cursor.execute("SELECT leave_application.leave_id, leave_type, leave_application.employee_id, applied_date, start_date, end_date, status, application, leave_application.department_id FROM leave_application, leave_requests WHERE leave_requests.role = %s and leave_application.leave_id = leave_requests.leave_id", (get_role(),)) temp_requests = cursor.fetchall() requests = [] if get_role() == 'HOD': cursor.execute("SELECT department_id FROM employee WHERE employee_id = %s", (username,)) department_id = cursor.fetchone()[0] for request in temp_requests: if department_id == request[8]: requests.append(request) else : requests = temp_requests cursor.execute("SELECT * FROM comments ORDER BY leave_id DESC") comments = cursor.fetchall() return render_template('user/leaves/leave_requests.html', requests = requests, comments = comments, title="Leave Requests", username = username, isadmin = get_isadmin(), role = get_role())
def list_departments(): if get_isadmin() == False: return redirect(url_for('home.error403')) cursor.execute( "SELECT * FROM department WHERE department_id != 'NONE' ORDER BY department_id ASC;" ) departments = cursor.fetchall() return render_template('admin/departments/departments.html', departments=departments, title="Departments", username=get_username(), isadmin=get_isadmin())
def history_ccf(): if get_isadmin() == False: return redirect(url_for('home.error403')) hod = False cursor.execute( "SELECT * FROM ccf_history ORDER BY position ASC, start_date DESC, time ASC" ) history = cursor.fetchall() return render_template('admin/history/history.html', hod=hod, history=history, title="CCF History", username=get_username(), isadmin=get_isadmin())
def history_hod(): if get_isadmin() == False: return redirect(url_for('home.error403')) hod = True cursor.execute( "SELECT * FROM hod_history ORDER BY department_id ASC, start_date ASC, time ASC" ) history = cursor.fetchall() return render_template('admin/history/history.html', hod=hod, history=history, title="HOD History", username=get_username(), isadmin=get_isadmin())