def all_user_list():
# FIXME This page brakes if there is no jobs in the database
"""
This page will show the list of the user in the company
:return:
"""
user_list = []
number_list = sql_functions.get_all_user_ids(session["login_details"])
for number in number_list:
user_list.append(User(session["login_details"], number))
return render_template("private/users/list.html", user_list=user_list)
def job_main_details(job_number):
"""
Bring the overview of all the details to show
:param job_number:
:return:
"""
# TODO a lot of this code maybe able to be put in the Job Class
login_details = session["login_details"]
# Job details
year, number = job_number.split("-")
job_number_sql = (int(year), int(number))
job = Job(job_number_sql, login_details)
client_company_list = []
client_company_id_list = []
# assigned users
member_list = []
id_list = sql_functions.job_assigned_users(login_details, job_number_sql)
if id_list is not None:
for id_value in id_list:
member_list.append(User(login_details, id_value))
else:
member_list = None
# User list
user_list = []
number_list = sql_functions.get_all_user_ids(login_details)
for number in number_list:
if number in id_list:
pass
else:
user_list.append(User(login_details, number))
# user that have put time to the job
time_users = []
if job.timed_user_ids:
for user_with_time in job.timed_user_ids:
user_time = User(login_details, user_with_time)
time_users.append((user_time.id, user_time.username, user_time.job_times(job.job_number_sql)))
# get the list of companies so that one can be added to the job.
if job.company_assigned:
pass
else:
company_id_list = site_actions.ClientCompany.all_companies(login_details["company_schema"])
for company in company_id_list:
client_company = site_actions.ClientCompany(company, login_details)
client_company_list.append(client_company)
client_company_id_list.append(company[0])
# page form details
form = Form(request.form)
if request.method == "POST":
if sql_functions.verify_user_company_schema(login_details):
user = session["login_details"]["person_ID"]
if request.form["timer"] == "Start":
start_time = job.start_time_entry(user)
flash(start_time.strftime("%Y/%m/%d %H:%M"))
elif request.form["timer"] == "Stop":
finish_time = job.user_stop_log(user)
flash(finish_time.strftime("%Y/%m/%d %H:%M"))
elif request.form["timer"] == "Assign":
user_assigned = []
for value in request.form:
for user in user_list:
if value == "user" + str(user.id):
user_assigned.append(user.id)
for user_id in user_assigned:
values = (job_number_sql[0], job_number_sql[1], user_id)
sql_functions.assign_users_to_job(values, login_details)
elif request.form["timer"] == "Remove Members" and member_list is not None:
remove_member = []
for value in request.form:
for member in member_list:
if value == "member" + str(member.id):
remove_member.append(member.id)
for member_id in remove_member:
values = (job_number_sql[0], job_number_sql[1], member_id)
sql_functions.remove_users_from_job(values, login_details)
elif request.form["timer"] == "Assign company" and client_company_list is not None:
for value in request.form:
for client_id in client_company_id_list:
try:
if int(value) == client_id:
job.add_client_company(int(value))
flash(value)
except ValueError:
pass
return redirect(url_for("job_main_details", job_number=job.job_number))
current_user = User(session["login_details"])
return render_template(
"private/jobs/main_details.html",
job=job,
user_list=user_list,
member_list=member_list,
time_users=time_users,
current_user=current_user,
client_company_list=client_company_list,
form=form,
)
