def edit_ccf(position):
if get_isadmin() == False:
return redirect(url_for('home.error403'))
add_ccf = False
form = EditCCFForm()
cursor.execute("SELECT * FROM ccf WHERE position = %s", (position, ))
data = cursor.fetchone()
if form.validate_on_submit():
cursor.execute(
"INSERT INTO ccf_history(employee_id, position, time, start_date, end_date) VALUES(%s, %s, %s, %s, %s)",
(data[0], data[1],
(datetime.now()).strftime("%H:%M:%S"), data[2], date.today()))
cursor.execute("UPDATE employee SET role = %s WHERE employee_id = %s",
('FACULTY', data[0]))
cursor.execute("UPDATE employee SET role = %s WHERE employee_id = %s",
(position, form.employee_id.data))
cursor.execute(
"UPDATE ccf SET employee_id = %s, appointed_date = %s WHERE position = %s",
(form.employee_id.data, date.today(), position))
conn.commit()
flash('You have successfully updated the position!')
return redirect(url_for('admin.list_ccf'))
return render_template('admin/roles/ccfs.html',
action="Edit",
add_ccf=add_ccf,
form=form,
title="Edit CCF",
username=get_username(),
isadmin=get_isadmin())
def dashboard():
if get_isadmin() == False:
return redirect(url_for('home.error403'))
return render_template('/admin/dashboard.html',
title="Dashboard",
username=get_username(),
isadmin=get_isadmin())
def add_hod():
if get_isadmin() == False:
return redirect(url_for('home.error403'))
add_hod = True
form = AddHODForm()
if form.validate_on_submit():
cursor.execute(
"SELECT department_id FROM employee WHERE employee_id = %s",
(form.hod_id.data, ))
if cursor.fetchone()[0] == form.department_id.data:
cursor.execute(
"INSERT INTO hod(department_id, hod_id, appointed_date) VALUES(%s, %s, %s)",
(form.department_id.data, form.hod_id.data, date.today()))
cursor.execute(
"UPDATE employee SET role = %s WHERE employee_id = %s", (
'HOD',
form.hod_id.data,
))
conn.commit()
flash('You have successfully added a new HOD!')
else:
flash('Invalid Entry!')
return redirect(url_for('admin.list_hod'))
return render_template('admin/roles/hods.html',
action="Add",
add_hod=add_hod,
form=form,
title="Add HOD",
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 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_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_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())
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 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 add_route():
if get_isadmin() == False:
return redirect(url_for('home.error403'))
form = AddRouteForm()
if form.validate_on_submit():
cursor.execute(
"INSERT INTO route(role, start_route, end_route) VALUES(%s, %s, %s)",
(form.role.data, form.start_route.data, form.end_route.data))
conn.commit()
flash("Route Added Successfully")
return redirect(url_for('admin.list_routes'))
return render_template('admin/route/routes.html',
title="Add Route",
form=form,
username=get_username(),
isadmin=get_isadmin())
def add_position():
if get_isadmin() == False:
return redirect(url_for('home.error403'))
form = AddPositionForm()
if form.validate_on_submit():
cursor.execute(
"INSERT INTO pos(position, position_name) VALUES(%s, %s)",
(form.position_id.data, form.position_name.data))
conn.commit()
flash('You have successfully added a new psoition!')
return redirect(url_for('admin.list_positions'))
return render_template('admin/positions/position.html',
form=form,
action="Add",
title="Add Position",
username=get_username(),
isadmin=get_isadmin())
def add_department():
if get_isadmin() == False:
return redirect(url_for('home.error403'))
form = AddDepartmentForm()
if form.validate_on_submit():
cursor.execute(
"INSERT INTO department(department_id, department_name) VALUES(%s, %s)",
(form.department_id.data, form.department_name.data))
conn.commit()
flash('You have successfully added a new department!')
return redirect(url_for('admin.list_departments'))
return render_template('admin/departments/department.html',
action="Add",
form=form,
title="Add Department",
username=get_username(),
isadmin=get_isadmin())
def delete_route(role, start_route):
if get_isadmin() == False:
return redirect(url_for('home.error403'))
cursor.execute("DELETE FROM route WHERE role = %s AND start_route = %s",
(role, start_route))
conn.commit()
flash('You have successfully deleted the route!')
return redirect(url_for('admin.list_routes'))
return render_template(title="Delete Position")
def new_application():
if (get_username() == ""):
flash ("Please Login!")
return redirect(url_for('auth.login'))
username = get_username()
# Check if user is trying to gnerate more than one requests
cursor.execute("SELECT status FROM leave_application WHERE employee_id = %s ORDER BY leave_id DESC", (username,))
status = cursor.fetchone()
if status :
if status[0] != 'Granted' and status[0] != 'Rejected':
flash("Can't apply For leave as last leave is pending!")
return redirect(url_for('user.dashboard', username = username, isadmin = get_isadmin()))
form = LeaveApplicationForm()
if form.validate_on_submit():
start_date = form.start_date.data
end_date = form.end_date.data
application = form.application.data
leave_type = form.leave_type.data
now = datetime.datetime.now()
curr_year = int(now.year)
cursor.execute("SELECT total_leaves_left FROM leaves_left WHERE employee_id = %s AND year = %s", (username, curr_year))
total_leaves_left = cursor.fetchone()[0]
leaves_demanded = int((end_date - start_date).days) + 1
if(total_leaves_left - leaves_demanded < -10 and leave_type == "Borrowing"):
flash ("Invalid Application! You can atmax borrow 10 leaves from upcoming year!")
return redirect(url_for('home.error'))
if(total_leaves_left - leaves_demanded < 0 and leave_type == "Regular"):
flash ("Invalid Application! You can't apply for this much leaves! You can try borrowing leaves!")
return redirect(url_for('home.error'))
# Check type of Leave
if(total_leaves_left - leaves_demanded < 0):
leave_type = 'Borrowing'
else:
leave_type = 'Regular'
status = 'Waiting'
cursor.execute("SELECT end_route FROM route WHERE role = %s AND start_route = %s", (get_role(), get_role()))
to = cursor.fetchone()
if to is None:
flash("Route is not defined for you! Please contact admin!")
return redirect(url_for('home.error'))
cursor.execute("SELECT department_id FROM employee WHERE employee_id = %s", (username,))
department_id = cursor.fetchone()[0]
cursor.execute("INSERT INTO leave_application(employee_id, applied_date, leave_type, start_date, end_date, status, application, department_id) VALUES(%s, %s, %s, %s, %s, %s, %s, %s)", (username, 'now()', leave_type, start_date, end_date, status, application, department_id))
cursor.execute("SELECT leave_id FROM leave_application WHERE employee_id = %s ORDER BY leave_id DESC", (username,))
leave_id = cursor.fetchone()[0]
cursor.execute("INSERT INTO leave_requests(role, leave_id, department_id) VALUES(%s, %s, %s)", (to[0], leave_id, department_id))
conn.commit()
flash ("Application Sent!")
return redirect(url_for('user.dashboard', username = username))
return render_template('user/leaves/new_application.html', form=form, title="New Application" , username = username, isadmin = get_isadmin(), role = get_role())
def delete_position(position_id):
if get_isadmin() == False:
return redirect(url_for('home.error403'))
conn.commit()
cursor.execute("UPDATE employee SET role = 'FACULTY' WHERE role = %s",
(position_id, ))
cursor.execute("DELETE FROM ccf WHERE position = %s", (position_id, ))
cursor.execute("DELETE FROM pos WHERE position = %s", (position_id, ))
flash('You have successfully deleted the position!')
return redirect(url_for('admin.list_positions'))
return render_template(title="Delete Position")
def add_ccf():
if get_isadmin() == False:
return redirect(url_for('home.error403'))
add_ccf = True
form = AddCCFForm()
if form.validate_on_submit():
cursor.execute(
"INSERT INTO ccf(position, employee_id, appointed_date) VALUES(%s, %s, %s)",
(form.position.data, form.employee_id.data, date.today()))
cursor.execute("UPDATE employee SET role = %s WHERE employee_id = %s",
(form.position.data, form.employee_id.data))
conn.commit()
flash('You have successfully added a new position!')
return redirect(url_for('admin.list_ccf'))
return render_template('admin/roles/ccfs.html',
action="Add",
add_ccf=add_ccf,
form=form,
title="Add CCF",
username=get_username(),
isadmin=get_isadmin())
def edit_hod(department_id):
if get_isadmin() == False:
return redirect(url_for('home.error403'))
add_hod = False
form = EditHODForm()
cursor.execute("SELECT * FROM hod WHERE department_id = %s",
(department_id, ))
data = cursor.fetchone()
if form.validate_on_submit():
cursor.execute(
"SELECT department_id FROM employee WHERE employee_id = %s",
(form.hod_id.data, ))
if cursor.fetchone()[0] == department_id:
cursor.execute(
"INSERT INTO hod_history(hod_id, department_id, time, start_date, end_date) VALUES(%s, %s, %s, %s, %s)",
(data[0], data[1],
(datetime.now()).strftime("%H:%M:%S"), data[2], date.today()))
cursor.execute(
"UPDATE employee SET role = %s WHERE employee_id = %s",
('FACULTY', data[0]))
cursor.execute(
"UPDATE employee SET role = %s WHERE employee_id = %s",
('HOD', form.hod_id.data))
cursor.execute(
"UPDATE hod SET hod_id = %s, appointed_date = %s WHERE department_id = %s",
(form.hod_id.data, date.today(), department_id))
conn.commit()
flash('You have successfully changed the HOD!')
else:
flash('Invalid Entry!')
return redirect(url_for('admin.list_hod'))
return render_template('admin/roles/ccfs.html',
action="Edit",
add_hod=add_hod,
form=form,
title="Edit HOD",
username=get_username(),
isadmin=get_isadmin())
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 delete_employee(employee_id):
if get_isadmin() == False:
return redirect(url_for('home.error403'))
cursor.execute("DELETE FROM hod WHERE hod_id = %s", (employee_id, ))
cursor.execute("DELETE FROM ccf WHERE employee_id = %s", (employee_id, ))
cursor.execute("DELETE FROM leaves_left WHERE employee_id = %s",
(employee_id, ))
cursor.execute("DELETE FROM employee WHERE employee_id = %s",
(employee_id, ))
db.employee.remove({'_id': employee_id})
conn.commit()
flash('You have successfully deleted the employee!')
return redirect(url_for('admin.employees'))
return render_template(title="Delete Department")
def delete_department(department_id):
if get_isadmin() == False:
return redirect(url_for('home.error403'))
cursor.execute("SELECT * from employee WHERE department_id = %s",
(department_id, ))
employees = cursor.fetchone()
if employees:
flash(
"To remove the department, first remove all faculties enrolled in that department."
)
return redirect(url_for('home.error'))
cursor.execute("DELETE FROM department WHERE department_id = %s",
(department_id, ))
conn.commit()
flash('You have successfully deleted the department!')
return redirect(url_for('admin.list_departments'))
return render_template(title="Delete Department")
def delete_ccf(position):
if get_isadmin() == False:
return redirect(url_for('home.error403'))
cursor.execute("SELECT * FROM ccf WHERE position = %s", (position, ))
data = cursor.fetchone()
cursor.execute(
"INSERT INTO ccf_history(employee_id, position, time, start_date, end_date) VALUES(%s, %s, %s, %s, %s)",
(data[0], data[1],
(datetime.now()).strftime("%H:%M:%S"), data[2], date.today()))
cursor.execute("DELETE FROM ccf WHERE position = %s", (position, ))
cursor.execute(
"UPDATE employee SET role = 'FACULTY' WHERE employee_id = %s",
(data[0], ))
conn.commit()
flash('You have successfully deleted the ccf!')
return redirect(url_for('admin.list_ccf'))
return render_template(title="Delete CCF")
def delete_hod(department_id):
if get_isadmin() == False:
return redirect(url_for('home.error403'))
cursor.execute("SELECT * FROM hod WHERE department_id = %s",
(department_id, ))
data = cursor.fetchone()
cursor.execute(
"INSERT INTO hod_history(hod_id, department_id, time, start_date, end_date) VALUES(%s, %s, %s, %s, %s)",
(data[0], data[1],
(datetime.now()).strftime("%H:%M:%S"), data[2], date.today()))
cursor.execute("DELETE FROM hod WHERE department_id = %s",
(department_id, ))
cursor.execute(
"UPDATE employee SET role = 'FACULTY' WHERE employee_id = %s",
(data[0], ))
conn.commit()
flash('You have successfully deleted the HOD!')
return redirect(url_for('admin.list_hod'))
return render_template(title="Delete HOD")
def about(user):
emp = db.employee.find_one({"_id": user})
first_name = emp['first_name']
last_name = emp['last_name']
email_id = emp['email_id']
department_id = emp['department_id']
no_awards = emp['no_awards']
no_publications = emp['no_publications']
no_researchs = emp['no_researchs']
no_projects = emp['no_projects']
biography = emp['biography']
education = emp['education']
experience = emp['experience']
research_interests = emp['research_interests']
projects = emp['projects']
awards = emp['awards']
publications = emp['publications']
return render_template('about/employee.html',
first_name=first_name,
last_name=last_name,
email_id=email_id,
department_id=department_id,
no_awards=no_awards,
no_publications=no_publications,
no_researchs=no_researchs,
no_projects=no_projects,
biography=biography,
education=education,
experience=experience,
research_interests=research_interests,
projects=projects,
publications=publications,
awards=awards,
title='About',
username=get_username(),
isadmin=get_isadmin(),
role=get_role())
def homepage():
return render_template('home/index.html',
title="Welcome",
username=get_username(),
isadmin=get_isadmin(),
role=get_role())
def error():
return render_template('errors/error.html',
title="Error",
username=get_username(),
isadmin=get_isadmin(),
role=get_role())
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 action(leave_id):
if (get_username() == ""):
flash ("Please Login!")
return redirect(url_for('auth.login'))
username = get_username()
form = commentFormHigher()
cursor.execute("SELECT leave_id FROM leave_requests WHERE role = %s AND leave_id = %s", (get_role(), leave_id))
id = cursor.fetchone()
if id is None:
flash ("Error : Unauthorized Access!")
return redirect(url_for('home.error'))
if form.validate_on_submit():
cursor.execute("SELECT * FROM leave_application WHERE leave_id = %s ORDER BY leave_id", (leave_id,))
leave = cursor.fetchone()
cursor.execute("SELECT department_id FROM employee WHERE employee_id = %s", (username,))
department_id = cursor.fetchone()
comment = form.comment.data
comment_by = username
now = datetime.datetime.now()
curr_year = int(now.year)
comment_time = str(datetime.datetime.now())
cursor.execute("INSERT INTO comments(leave_id, comment, comment_time, comment_by, role, department_id) VALUES(%s, %s, %s, %s, %s, %s)", (leave_id, comment, comment_time, comment_by, get_role(), department_id))
if form.action.data == "send_back" :
status = "Sent Back"
elif form.action.data == "reject" :
status = "Rejected"
else :
cursor.execute("Select role FROM employee WHERE employee_id = %s", (leave[2],))
role = cursor.fetchone()[0]
start_route = get_role()
cursor.execute("Select end_route FROM route WHERE role = %s AND start_route = %s", (role, start_route))
end_route = cursor.fetchone()
if end_route is None:
status = "Granted"
cursor.execute("Select total_leaves_left FROM leaves_left WHERE employee_id = %s AND year = %s", (leave[2], curr_year))
leaves_left = cursor.fetchone()[0] - int((leave[5]-leave[4]).days) - 1
if leaves_left < 0:
cursor.execute("Select total_leaves_left FROM leaves_left WHERE employee_id = %s AND year = %s", (leave[2], (curr_year+1)))
next_leaves_left = cursor.fetchone()[0] - abs(leaves_left)
cursor.execute("Update leaves_left SET total_leaves_left = %s WHERE employee_id = %s AND year = %s", (next_leaves_left, leave[2], (curr_year+1)))
leaves_left = 0
cursor.execute("Update leaves_left SET total_leaves_left = %s WHERE employee_id = %s AND year = %s", (leaves_left, leave[2], curr_year))
else :
status = "Forwarded"
cursor.execute("DELETE FROM leave_requests WHERE role = %s AND leave_id = %s", (get_role(), leave_id))
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_id, department_id))
if status != "Forwarded":
cursor.execute("DELETE FROM leave_requests WHERE role = %s AND leave_id = %s", (get_role(), leave_id))
cursor.execute("UPDATE leave_Application SET status = %s WHERE leave_id = (%s)", (status, leave[0]))
conn.commit()
return redirect(url_for('user.leave_requests', username = username))
return render_template('user/leaves/action.html', leave_id = leave_id, form = form, title="Action", username = username, isadmin = get_isadmin(), role = get_role())
def add_experience():
if (get_username() == ""):
flash ("Please Login!")
return redirect(url_for('auth.login'))
form = AddDetailsForm()
username = get_username()
if form.validate_on_submit():
db.employee.update({"_id" : username},{"$push": {"experience" : form.add.data } })
return redirect(url_for('user.profile'))
return render_template('user/profile/add_details.html', form=form, title="Add" , username = username, isadmin = get_isadmin(), role = get_role())
