def sdetail_render():
survey_id = request.args.get("survey_id")
flag_ses, user_id = getSession()
if not flag_ses:
return redirect("login.html")
list = MyDaoSdetail().myselect(survey_id)
return render_template('sdetail.html', list=list, survey_id=survey_id)
def sview_render():
survey_id = request.args.get("survey_id")
st_mobile = request.args.get("st_mobile")
list = MyDaoSdetail().myselect(survey_id)
q_cnt = len(list)
return render_template('sview.html',
list=list,
survey_id=survey_id,
st_mobile=st_mobile,
q_cnt=q_cnt)
def sdetail_del_ajax():
survey_id = request.form["survey_id"]
s_seq = request.form["s_seq"]
cnt = MyDaoSdetail().mydelete(survey_id, s_seq)
msg = ""
if cnt == 1:
msg = "ok"
else:
msg = "ng"
return jsonify(msg = msg)
def sdetail_upd_ajax():
survey_id = request.form["survey_id"]
s_seq = request.form["s_seq"]
question = request.form["question"]
a1 = request.form["a1"]
a2 = request.form["a2"]
a3 = request.form["a3"]
a4 = request.form["a4"]
in_date = request.form["in_date"]
in_user_id = str(escape(session["user_id"]))
up_date = request.form["up_date"]
up_user_id = str(escape(session["user_id"]))
cnt = MyDaoSdetail().myupdate(survey_id, s_seq, question, a1, a2, a3, a4, in_date, in_user_id, up_date, up_user_id)
msg = ""
if cnt == 1:
msg = "ok"
else:
msg = "ng"
return jsonify(msg = msg)