def register_application():
application_form = ApplicationForm(meta={'csrf': False})
if application_form.validate_on_submit():
car_brand = request.form['car_brand']
car_model = request.form['car_model']
name = request.form['name']
last_name = request.form['last_name']
email = request.form['email']
tel = request.form['tel']
try:
application = Application(name=name, last_name=last_name, email=email, tel=tel, car_brand_id=car_brand,
car_model_id=car_model)
db.session.add(application)
db.session.commit()
# !!!
# Uncomment it if you want to use Mail
# !!!
# track_number = application.unique_track_number
# send_application_registered_msg(name, email, track_number)
return jsonify({'success': 'Ваша заявка была успешно подана!'})
except Exception as e:
return jsonify({'errors': f'Что-то пошло не так, попробуйте снова! {e}'})
return jsonify({'errors': application_form.errors})
def setting_application():
# 表格信息区
applications = db.engine.execute(SQL['APPLICATION_INFO'])
application_choices = [(p.id, p.application_name) for p in Application.query.order_by('id')]
user_choices = [(p.id, p.user_name) for p in User.query.filter(User.enable == 1).order_by('id')]
status_choices = APPLICATION_STATUS
# 增加项目区
add_form = ApplicationForm()
add_form.product_manger_id.choices = user_choices
if add_form.validate_on_submit():
if g.user.role == 0:
try:
new_application = Application(add_form.application_name.data, add_form.product_manger_id.data,
add_form.current_version.data, add_form.status.data)
db.session.add(new_application)
db.session.commit()
log('application', '增加系统', new_application.id, new_application.application_name, '成功')
flash("系统添加成功!")
except Exception, e:
flash("无法添加系统!")
print Exception, e
return render_template('setting-application.html', data=applications, user_choices=user_choices,
status_choices=status_choices, add_form=add_form,
application_choices=application_choices, atr='show')
else:
flash("无权限操作!")
def return_loan_application():
form = ApplicationForm()
message = ''
if form.validate_on_submit():
age = form.age.data
occupation = form.occupation.data
credit = form.grade.data
grade = convert_credit_grade(credit)
Years_At_present_Employment = form.Years_At_present_Employment.data
expenses = form.expenses.data
income = form.income.data
dti = round((expenses / (income / 12) * 100), 2)
Delinquency = convert_to_binary(form.Delinquency.data)
Collections = convert_to_binary(form.Collections.data)
Derogatory = convert_to_binary(form.Derogatory.data)
Housing = form.Housing.data
application_data = [[grade, dti, Delinquency, Collections, Derogatory]]
probabs_result = tfidf_model.predict_proba(application_data)
default_chance = probabs_result[1][0][1]
print('Chance of default: {}'.format(default_chance * 100))
if default_chance > .3:
message = 'However you have been rejected :('
approval = 'rejected'
else:
message = 'You have been accepted! :)'
approval = 'accepted'
insert_query = "INSERT INTO loan_history VALUES(DEFAULT, {}, '{}', {}, '{}', '{}', '{}', '{}')".format(
age, occupation, Years_At_present_Employment, income, Housing,
credit, approval)
# print(insert_query)
cur.execute(insert_query)
conn.commit()
return render_template('application_complete.html', message=message)
return render_template('loan_application.html', form=form)
def save_applications(nickname, jobkey):
print "====== got into save_applications jobkey: ", jobkey
set_upload_dir(nickname)
form = ApplicationForm()
# get the job data from the database or server
job_data = Position.query.filter_by(jobkey=jobkey).first();
if job_data is None:
getJob = ProcessJobSearch()
job = getJob.search_by_jobkeys(jobkey)
job_data = job[0]
print "title: %s, jobkey: %s, company: %s" % (job_data['jobtitle'],
job_data['jobkey'], job_data['company'])
if request.method == 'POST' and form.validate_on_submit():
position = Position.query.filter_by(jobkey=jobkey).first();
if position is None:
print " ---- inserting into position table ----"
position = insert_into_position_table(job_data)
apply_date = form.apply_date.data
dt = datetime.strptime(apply_date, "%m/%d/%Y" )
resume = form.resume_version.data
cv = form.cv_version.data
username = form.username_on_website.data
password = form.password_on_website.data
#insert into Application table
user = User.query.filter_by(nickname=nickname).first()
if user is not None:
application = Application.query.filter_by(id=user.id, jobkey=position.jobkey).first()
if application is None:
print("commit to application table")
application = Application(id=user.id, jobkey=position.jobkey,
apply_date=dt, resume=resume, cv=cv)
db.session.add(application)
db.session.commit()
else:
print(" We couldn't save the position.")
return redirect(url_for('list_applications', nickname=nickname))
print "documents available: ", os.listdir(g.user.upload_dir), " path is: ", g.user.upload_dir
documents = os.listdir(g.user.upload_dir)
return render_template('save_applications.html',
job=job_data,
user=g.user, form=form,
documents=documents)
def apply():
form = ApplicationForm()
if form.validate_on_submit():
file = request.files['resume']
if file and allowed_file(file.filename):
filename = secure_filename(file.filename)
file.save(os.path.join(app.config['UPLOAD_FOLDER'], filename))
new_applicant = Application()
form.populate_obj(new_applicant)
new_applicant.resume = filename
db.session.add(new_applicant)
db.session.commit()
return "Thanks for applying!"
else:
flash("Invalid file extension")
return render_template('application.html', form=form)
return render_template('application.html', form=form)
def index():
form = ApplicationForm()
if form.validate_on_submit():
if form.squirrel.data:
# ANTI SPAM YO
app.logger.info('SECRET SQUIRREL')
return redirect(url_for('index'))
form_data = "name: {}\nemail: {}\nphone: {}\n\n".format(
form.name.data, form.email.data, form.phone.data)
app.logger.info(form_data)
# send the email
email.send(form_data)
flash(app.config['THANKS_FLASH'])
return redirect(url_for('index'))
return render_template('index.jade', form=form)
def application_edit(app_id):
from forms import ApplicationForm
ac = Application.query.get_u_or_404(app_id)
servers = Server.query.all()
form = ApplicationForm(
formdata=request.form,
obj=ac)
if form.validate_on_submit():
form.servers.data = [
Server.query.get_or_404(x) for x in form.servers.data]
form.populate_obj(ac)
db.session.commit()
return redirect(url_for(".application"))
return render_template("app_edit.html",
form=form,
servers=servers,
ac=ac)
def apply():
if current_user.is_authenticated:
if current_user.type == 'admin':
return redirect(url_for('main.index'))
return redirect(url_for('student.studentIndex'))
form = ApplicationForm()
if request.method == 'POST':
if form.validate_on_submit():
user = User.query.filter_by(email=form.email.data).first()
if user is not None:
flash('There is already an account with that email.',
'warning')
return redirect(url_for('student.apply'))
stu = Student.query.filter_by(email=form.email.data).first()
if stu is not None:
flash('There is already a student with that email.', 'warning')
return redirect(url_for('student.apply'))
applicant = Applicant.query.filter_by(
email=form.email.data).first()
if applicant is not None:
flash('You have already applied with that email.', 'warning')
return redirect(url_for('student.apply'))
if form.document.data:
document = save_doc(form.document.data)
student = Applicant(name=form.name.data,
birthday=form.birthday.data,
phone=form.phone.data,
address=form.address.data,
email=form.email.data,
status=False,
city=form.city.data,
country=form.country.data,
program=form.program.data,
document=document)
db.session.add(student)
db.session.commit()
flash('You application has been received!', 'success')
return redirect(url_for('student.studentlogin'))
return render_template('apply.html', form=form)
def index():
form = ApplicationForm()
if form.validate_on_submit():
if form.squirrel.data:
# ANTI SPAM YO
app.logger.info('SECRET SQUIRREL')
return redirect(url_for('index'))
form_data = "name: {}\nemail: {}\nphone: {}\n\n".format(
form.name.data,
form.email.data,
form.phone.data
)
app.logger.info(form_data)
# send the email
email.send(form_data)
flash(app.config['THANKS_FLASH'])
return redirect(url_for('index'))
return render_template('index.jade', form=form)
def application_add():
from forms import ApplicationForm
servers = Server.query.all()
form = ApplicationForm(request.form)
iservers = request.form.getlist('servers')
iservers = Server.query.filter(
Server.id.in_(iservers)).all()
if form.validate_on_submit():
s = Application()
form.servers.data = [
Server.query.get_or_404(x) for x in form.servers.data]
form.populate_obj(s)
db.session.add(s)
db.session.commit()
return redirect(url_for(".application"))
return render_template("app_add.html",
form=form,
servers=servers,
iservers=iservers)
