def import_from_csv():
callers = Account.get_all_active_hr()
iterator = 0
if 'csv-input' not in request.files:
flash('No File Uploaded')
return redirect(url_for('admin.candidates_page'))
csv_file = request.files.get('csv-input')
if csv_file:
directory = upload_file(csv_file)
with open(directory, 'r', encoding='utf-8-sig') as file:
headers = file.readline().strip().split(',')
line = file.readline()
while line:
data = line.strip().split(',')
applicant = Applicant(**dict(zip(headers,data)))
applicant.hr_id = callers[iterator].id
if iterator == len(callers)-1:
iterator = 0
else:
++iterator
db.session.add(applicant)
line = file.readline()
db.session.commit()
file.close()
return redirect(url_for('admin.candidates_page'))
def add_applicant_page():
form = CalloutForm(request.form)
form.call.hr.validators.append(DataRequired())
form.call.hr.choices = list()
callers = Account.get_all_active_hr()
for caller in callers:
form.call.hr.choices.append((caller.id, f'{caller.first_name} {caller.last_name} ({caller.username})'))
return render_template('pages/account/add_applicant.html', form=form)
def edit_applicant_page(applicant_id):
form = CalloutForm(request.form)
applicant = Applicant.find_applicant(applicant_id)
form.call.hr.validators.append(DataRequired())
form.personal.address.data = applicant.address
form.call.remarks.data = applicant.remarks
form.call.hr.choices = list()
callers = Account.get_all_active_hr()
for caller in callers:
form.call.hr.choices.append((caller.id, caller.username))
if not applicant:
flash('Applicant does not exist', 'danger')
return redirect(url_for('admin.candidates_page'))
return render_template('pages/account/edit_applicant.html', form=form, applicant=applicant)
def records_page():
interviewers = Account.get_all_active_hr()
return render_template('pages/account/admin/records.html', interviewers=interviewers)
def edit_applicant(applicant_id):
form = CalloutForm(request.form)
applicant = Applicant.find_applicant(applicant_id)
form.call.hr.validators.append(DataRequired())
form.personal.address.data = applicant.address
form.call.remarks.data = applicant.remarks
form.call.hr.choices = list()
callers = Account.get_all_active_hr()
for caller in callers:
form.call.hr.choices.append((caller.id, caller.username))
if form.validate_on_submit():
applicant.last_name=request.form.get('personal-last_name')
applicant.first_name=request.form.get('personal-first_name')
applicant.middle_name=request.form.get('personal-middle_name')
applicant.email=request.form.get('personal-email')
applicant.mobile1=request.form.get('personal-mobile1')
applicant.mobile2=request.form.get('personal-mobile2')
applicant.landline=request.form.get('personal-landline')
applicant.address=request.form.get('personal-address')
applicant.marital_status=request.form.get('personal-marital_status')
applicant.course=request.form.get('education-course')
applicant.graduation_year=request.form.get('education-graduation_year')
applicant.applied_position=request.form.get('preference-applied_position')
applicant.expected_salary=request.form.get('preference-expected_salary')
applicant.preferred_shift=request.form.get('preference-shift')
applicant.preferred_location=request.form.get('preference-location')
applicant.status=request.form.get('call-disposition')
applicant.remarks=request.form.get('call-remarks')
applicant.source=request.form.get('additional-source')
applicant.hr_id=request.form.get('call-hr')
birthdate = request.form.get('personal-birthdate')
if birthdate != '':
applicant.birthdate = datetime.strptime('{0}'.format(birthdate), '%Y-%m-%d')
educational_attainment = request.form.get('education-attainment')
if educational_attainment != '':
applicant.educational_attainment = educational_attainment
interview_date = request.form.get('additional-interview_date')
interview_time = request.form.get('additional-interview_time')
if interview_date != '' and interview_time != '':
timepiece = interview_time.split(" ")
try:
hour = timepiece[0].split(":")[0]
minute = timepiece[0].split(":")[1]
except IndexError as e:
minute = '00'
locale_time = timepiece[1]
interview_datetime = datetime.strptime('{0} {1}:{2} {3}'.format(interview_date, hour, minute, locale_time), '%Y-%m-%d %I:%M %p')
applicant.interview_datetime = interview_datetime
db.session.commit()
flash('Applicant {0} {1} has been modified'.format(applicant.first_name, applicant.last_name), 'success')
return redirect(url_for('admin.candidates_page'))
else:
flash('Applicant not modified', 'danger')
print('==================== ERRORS: add_applicant() ================')
for err in form.errors:
print(err)
print('=============================================================')
for err in form.personal.errors:
print(err)
print('=============================================================')
for err in form.education.errors:
print(err)
print('=============================================================')
for err in form.preference.errors:
print(err)
print('=============================================================')
for err in form.call.errors:
print(err)
print('=============================================================')
for err in form.additional.errors:
print(err)
return render_template('pages/account/edit_applicant.html', form=form, applicant=applicant)
return redirect(url_for('admin.edit_applicant_page', applicant_id=applicant_id))
