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)