def apply_step3():
data = {}
data['step'] = 3
notice_no = request.values.get(
"notice_no") if "notice_no" in request.values else ''
if not appliable_check(notice_no):
flash("수정가능한 기간이 아닙니다.")
return redirect(url_for("mypage_view.mypage"))
####################
cursor = dao.get_conn().cursor()
query_str = "select r_cert_name, r_cert_no, r_cert_date, r_notice_no from resume where r_writer_no = %s and r_notice_no = %s" % (
current_user.user_no, notice_no)
cursor.execute(query_str)
logger.info("apply_step3 query : " + query_str)
result = cursor.fetchall()
col_names = cursor.description
if result:
for idx in range(0, len(col_names)):
data[col_names[idx][0]] = result[0][idx]
####################
logger.info("apply_step3 view data : " + str(result))
return render_template('apply/step3.html', data=data)
def step1_save():
logger.info("/step1_save_action params : " + str(request.values))
sel1 = request.values.get('sel1') if 'sel1' in request.values else ''
sel2 = request.values.get('sel2') if 'sel2' in request.values else ''
notice_no = request.values.get(
"notice_no") if "notice_no" in request.values else ''
if not appliable_check(notice_no):
flash("수정가능한 기간이 아닙니다.")
return redirect(url_for("mypage_view.mypage"))
data = {}
#####################
cursor = dao.get_conn().cursor()
query = "update resume set r_group1='%s', r_group2='%s' where r_writer_no=%d and r_notice_no=%d" % (
sel1.encode('utf-8'), sel2.encode('utf-8'), int(
current_user.user_no), int(notice_no))
logger.info("query : " + query)
cursor.execute(query)
g.conn.commit()
affected_row = cursor.rowcount
#####################
logger.info("affected_row : %s" % (affected_row))
if affected_row == 1:
data["notice_no"] = notice_no
data["RETURNCODE"] = 0
data["RETURNMSG"] = "저장되었습니다."
else:
data["RETURNCODE"] = -1
data["RETURNMSG"] = "서버 오류. 관리자에게 문의하세요."
return jsonify(data)
def apply_step1():
data = {}
data['step'] = 1
sel1 = request.values.get("sel1") if "sel1" in request.values else ''
sel2 = request.values.get("sel2") if "sel2" in request.values else ''
notice_no = request.values.get(
"notice_no") if "notice_no" in request.values else ''
if not appliable_check(notice_no):
flash("수정가능한 기간이 아닙니다.")
return redirect(url_for("mypage_view.mypage"))
data["sel1"] = sel1
data["sel2"] = sel2
####################
cursor = dao.get_conn().cursor()
query_str = "select r_group1, r_group2, r_notice_no from resume where r_writer_no = %s and r_notice_no = %s" % (
current_user.user_no, notice_no)
cursor.execute(query_str)
result = cursor.fetchall()
col_names = cursor.description
logger.info("apply_step1 query : " + query_str)
if result:
for idx in range(0, len(col_names)):
data[col_names[idx][0]] = result[0][idx]
####################
logger.info('apply_step1 view data : ' + str(data))
return render_template('apply/step1.html', data=data)
def step5_save():
logger.info("/step5_save_action params : " + str(request.values))
submit_flag = request.values.get(
"submit_flag") if "submit_flag" in request.values else ""
notice_no = request.values.get(
"notice_no") if "notice_no" in request.values else ''
data = {}
if not appliable_check(notice_no):
flash("수정가능한 기간이 아닙니다.")
return redirect(url_for("mypage_view.mypage"))
#####################
cursor = dao.get_conn().cursor()
cur_time = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
query = "update resume set r_submit=%d, r_submit_time='%s' where r_writer_no=%d and r_notice_no=%d" % (
int(submit_flag), cur_time, int(current_user.user_no), int(notice_no))
logger.info("query : %s " % (query))
cursor.execute(query)
g.conn.commit()
affected_row = cursor.rowcount
#####################
logger.info("affected_row : %s" % (affected_row))
if affected_row == 1:
data["notice_no"] = notice_no
data["RETURNCODE"] = 0
data["RETURNMSG"] = "제출되었습니다."
else:
data["RETURNCODE"] = -1
data["RETURNMSG"] = "서버 오류. 관리자에게 문의하세요."
return jsonify(data)
def notice_post(p_no):
if not appliable_check(p_no):
flash("지원가능한 기간이 아닙니다.")
return redirect(url_for("notice_view.notice_board"))
cursor = dao.get_conn().cursor()
cursor.execute("select * from recruit_notice where n_no = %s" % (p_no))
result = cursor.fetchone()
cursor.close()
if not current_user.is_authenticated:
result = result + ('login',)
return render_template("/notice/notice_post.html", data=result)
#이미 해당공고에 대한 이력서가 있으면 '수정하기'버튼을 보여준다.
cursor = dao.get_conn().cursor()
cursor.execute("select * from resume where r_notice_no = %s and r_writer_no = %s " % (p_no, current_user.user_no))
result2 = cursor.fetchone();
if result2:
result = result + ('modify',)
else:
result = result + ('apply',)
logger.info("notice_post view data : "+str(result))
return render_template("/notice/notice_post.html", data=result)
def create_resume():
notice_no = request.values.get(
"notice_no") if "notice_no" in request.values else ''
sel1 = request.values.get("sel1") if "sel1" in request.values else ''
sel2 = request.values.get("sel2") if "sel2" in request.values else ''
if not appliable_check(notice_no):
flash("수정가능한 기간이 아닙니다.")
return redirect(url_for("mypage_view.mypage"))
data = {}
#######################
cursor = dao.get_conn().cursor()
query_str = "select * from resume where r_notice_no = %s and r_writer_no = %s" % (
notice_no, current_user.user_no)
logger.info("create resume check query : " + query_str)
cursor.execute(query_str)
chk_r = cursor.fetchall()
cursor.close()
#######################
if chk_r:
data["RETURNCODE"] = -2
data["RETURNMSG"] = "이미 작성한 지원서가 있습니다."
else:
if notice_no == '':
data["RETURNCODE"] = -1
data["RETURNMSG"] = "잘못된 접근입니다."
else:
c_time = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
cursor = dao.get_conn().cursor()
cursor.callproc("insert_r_resume",
(notice_no, current_user.user_no, c_time, 0))
cursor.execute("select @_insert_r_resume_3")
result = cursor.fetchone()
cursor.close()
if int(result[0]) > 0:
data["sel1"] = sel1
data["sel2"] = sel2
data["notice_no"] = notice_no
data["RETURNCODE"] = 0
data["RETURNMSG"] = "success"
else:
data["RETURNCODE"] = -1
data["RETURNMSG"] = "잘못된 접근입니다."
return jsonify(data)
def step2_save():
logger.info("/step2_save_action params : " + str(request.values))
name = request.values.get("name") if "name" in request.values else ""
birth = request.values.get("birth") if "birth" in request.values else ""
gender = request.values.get("gender") if "gender" in request.values else ""
addr = request.values.get("addr") if "addr" in request.values else ""
phone = request.values.get("phone") if "phone" in request.values else ""
school_type = request.values.get(
"school_type") if "school_type" in request.values else ""
school_name = request.values.get(
"school_name") if "school_name" in request.values else ""
major = request.values.get("major") if "major" in request.values else ""
grade = request.values.get("grade") if "grade" in request.values else ""
career = request.values.get("career") if "career" in request.values else ""
notice_no = request.values.get(
"notice_no") if "notice_no" in request.values else ''
data = {}
if not appliable_check(notice_no):
flash("수정가능한 기간이 아닙니다.")
return redirect(url_for("mypage_view.mypage"))
#####################
cursor = dao.get_conn().cursor()
query = "update resume set r_name='%s', r_birth='%s', r_gender='%s', r_addr='%s', r_phone='%s', r_school_type='%s', r_school_name='%s', r_major='%s', r_grade='%s', r_career='%s' " \
"where r_writer_no=%d and r_notice_no=%d" % (name.encode('utf-8'), birth.encode('utf-8'), gender.encode('utf-8'), addr.encode('utf-8'), phone.encode('utf-8'), school_type.encode('utf-8'), school_name.encode('utf-8'), major.encode('utf-8'), grade.encode('utf-8'), career.encode('utf-8'), int(current_user.user_no), int(notice_no))
logger.info("query : %s " % (query))
cursor.execute(query)
g.conn.commit()
affected_row = cursor.rowcount
#####################
logger.info("affected_row : %s" % (affected_row))
if affected_row == 1:
data["notice_no"] = notice_no
data["RETURNCODE"] = 0
data["RETURNMSG"] = "저장되었습니다."
else:
data["RETURNCODE"] = -1
data["RETURNMSG"] = "서버 오류. 관리자에게 문의하세요."
return jsonify(data)
def step3_save():
logger.info("/step3_save_action params : " + str(request.values))
list1_cert_name = request.values.get(
"list1_cert_name") if "list1_cert_name" in request.values else ""
list1_cert_no = request.values.get(
"list1_cert_no") if "list1_cert_no" in request.values else ""
list1_cert_date = request.values.get(
"list1_cert_date") if "list1_cert_date" in request.values else ""
notice_no = request.values.get(
"notice_no") if "notice_no" in request.values else ''
data = {}
if not appliable_check(notice_no):
flash("수정가능한 기간이 아닙니다.")
return redirect(url_for("mypage_view.mypage"))
#####################
cursor = dao.get_conn().cursor()
query = "update resume set r_cert_name='%s', r_cert_no='%s', r_cert_date='%s' " \
"where r_writer_no=%d and r_notice_no=%d" % (list1_cert_name.encode('utf-8'), list1_cert_no.encode('utf-8'), list1_cert_date.encode('utf-8'), int(current_user.user_no), int(notice_no))
logger.info("query : %s " % (query))
cursor.execute(query)
g.conn.commit()
affected_row = cursor.rowcount
#####################
logger.info("affected_row : %s" % (affected_row))
if affected_row == 1:
data["notice_no"] = notice_no
data["RETURNCODE"] = 0
data["RETURNMSG"] = "저장되었습니다."
else:
data["RETURNCODE"] = -1
data["RETURNMSG"] = "서버 오류. 관리자에게 문의하세요."
return jsonify(data)
