def search_srch_project(request): user_account = request.COOKIES.get('user_account') user_type = request.COOKIES.get('user_type') context = {} conn = Connect.connect() if conn == -1: return render_to_response("error_page.html", {'error': "interrupt!"}) if request.method == "POST": srch_pgym = '' if user_type == 'member': srch_pgym = request.POST.get('keyword_pgym') else: srch_pgym = user_account srch_pname = request.POST.get('keyword_pname') srch_pdate = request.POST.get('keyword_pdate') srch_ptime = request.POST.get('keyword_ptime') results = Search.SearchProject(conn, user_type, srch_pgym, srch_pname, srch_pdate, srch_ptime) if len(results): context['srch_flag'] = 1 context['results'] = results else: context['srch_flag'] = 0 if user_type == 'member': return render_to_response("search_project.html", context) else: return render_to_response("search_project_guser.html", context) else: return render_to_response("error_page.html", {'error': "request error!"})
def add_project(request): user_account = request.COOKIES.get('user_account') conn = Connect.connect() if conn == -1: return render_to_response("error_page.html", {'error': "interrupt!"}) context = {} if request.method == "POST": pid = request.POST.get('map_id') pname = request.POST.get('map_name') pdate = request.POST.get('map_date') ptime = request.POST.get('map_time') pcapa = request.POST.get('map_capa') pintro = request.POST.get('map_intro') results = -1 results = GymOperation.insert_project_info(conn, pid, user_account, pname, pdate, ptime, pcapa, pintro, pcapa) if results == -1: context['add_flag'] = 0 else: HttpResponse("Delete succeed!") context['add_flag'] = 1 return render_to_response("search_project_guser.html", context) else: return render_to_response("error_page.html", {"error": "failed to delete!"})
def alter_coach(request): user_account = request.COOKIES.get('user_account') conn = Connect.connect() if conn == -1: return render_to_response("error_page.html", {'error': "interrupt!"}) context = {} if request.method == "POST": cid = request.POST.get('c_id') cname = request.POST.get('c_name') cgender = request.POST.get('c_gender') cage = request.POST.get('c_age') cphone = request.POST.get('c_phone') cintro = request.POST.get('c_intro') results = -1 results = GymOperation.update_coach_info(conn, cid, user_account, cname, cgender, cage, cphone, cintro) print results if results == -1: context['alter_flag'] = 0 else: HttpResponse("alter succeed!") context['alter_flag'] = 1 return render_to_response("search_coach_guser.html", context) else: return render_to_response("error_page.html", {"error": "failed to modify coach!"})
def delete_appoint(request): user_account = request.COOKIES.get('user_account') user_type = request.COOKIES.get('user_type') conn = Connect.connect() if conn == -1: return render_to_response("error_page.html", {'error': "interrupt!"}) context = {} if request.method == "POST": delete_apid = request.POST.get('dap_id') delete_amid = request.POST.get('dam_id') results = -1 if user_type == 'member': results = MemOperation.delete_appointment(conn, delete_apid, user_account) else: results = GymOperation.delete_appointment(conn, delete_apid, delete_amid) if results == -1: context['delete_flag'] = 0 else: HttpResponse("Delete succeed!") context['delete_flag'] = 1 if user_type == 'member': return render_to_response("search_appoint.html", context) else: return render_to_response("search_appoint_guser.html", context) else: return render_to_response("error_page.html", {"error": "failed to delete!"})
def gym_info_view(request): user_account = request.COOKIES.get('user_account') user_account = request.COOKIES.get('user_password') conn = Connect.connect() context = {} # check connection with database if conn == -1: return render_to_response("error_page.html", {'error': "database connection error!"}) cur_gid = '' set_ck_flag = 0 if request.method == 'POST': cur_gid = request.POST.get('g_id') set_ck_flag = 1 # gym information gym_info = Search.SearchGymID(conn, cur_gid) # gym project project_info = Search.SearchGymProject(conn, cur_gid) # gym coach coach_info = Search.SearchGymCoach(conn, cur_gid) context['gym_info'] = gym_info[0] if len(project_info): context['project_info'] = project_info context['p_flag'] = 1 else: context['project_info'] = "nil" context['p_flag'] = 0 if len(coach_info): context['coach_info'] = coach_info context['c_flag'] = 1 else: context['coach_info'] = "nil" context['c_flag'] = 0 response = render_to_response("gym_info.html", context) if set_ck_flag == 1: response.set_cookie('gym_id', cur_gid, 3600) return response
def search_srch_coach(request): user_account = request.COOKIES.get('user_account') conn = Connect.connect() context = {} if conn == -1: return render_to_response("error_page.html", {'error': "interrupt!"}) if request.method == "POST": srch_cid = request.POST.get('keyword_cid') srch_cname = request.POST.get('keyword_cname') results = Search.SearchCoach(conn,srch_cid,srch_cname,user_account) if len(results): context['srch_flag'] = 1 context['results'] = results else: context['srch_flag'] = 0 return render_to_response("search_coach_guser.html", context) else: return render_to_response("error_page.html", {'error': "request error!"})
def update_mem_view(request): user_account = request.COOKIES.get('user_account') conn = Connect.connect() if request.method == "POST": u_password = request.POST.get('u_password') if u_password == u"": return render_to_response("error_page.html", {"error": "password shoudn't be empty"}) u_name = request.POST.get('u_name', 'NULL') gender = request.POST.get('gender', 'NULL') phone = request.POST.get('phone', 0) age = request.POST.get('age', 0) if MemOperation.update_member_info(conn,user_account,u_password,u_name,gender,phone,age) == -1: return render_to_response("error_page.html") else: HttpResponse("Modify succeed!") return HttpResponseRedirect('/home') else: return render_to_response("error_page.html", {"error": "failed to modify"})
def update_gym_view(request): user_account = request.COOKIES.get('user_account') conn = Connect.connect() if request.method == "POST": u_password = request.POST.get('g_password', "") if u_password == u"": return render_to_response("error_page.html", {"error": "password shoudn't be empty"}) u_name = request.POST.get('g_name', 'NULL') g_addr = request.POST.get('g_addr', 'NULL') g_phone = request.POST.get('g_phone', 0) g_open = request.POST.get('g_open', 0) g_intro = request.POST.get('g_intro', 0) if GymOperation.update_gym_info(conn,user_account,u_password,u_name,g_addr,g_open,g_phone,g_intro) == -1: return render_to_response("error_page.html") else: HttpResponse("Modify succeed!") return HttpResponseRedirect('/home') else: return render_to_response("error_page.html", {"error": "failed to modify"})
def delete_project(request): user_account = request.COOKIES.get('user_account') conn = Connect.connect() if conn == -1: return render_to_response("error_page.html", {'error': "interrupt!"}) context = {} if request.method == "POST": opera = request.POST.get('modify') pid = request.POST.get('dp_id') results = -1 results = GymOperation.delete_project(conn, user_account, pid) if results == -1: context['delete_flag'] = 0 else: HttpResponse("Delete succeed!") context['delete_flag'] = 1 return render_to_response("search_project_guser.html", context) else: return render_to_response("error_page.html", {"error": "failed to delete!"})
def delete_coach(request): user_account = request.COOKIES.get('user_account') conn = Connect.connect() if conn == -1: return render_to_response("error_page.html", {'error': "interrupt!"}) context = {} if request.method == "POST": delete_cid = request.POST.get('c_id') results = -1 print results results = GymOperation.delete_coach(conn, delete_cid, user_account) print "2" if results == -1: context['delete_flag'] = 0 else: HttpResponse("Delete succeed!") context['delete_flag'] = 1 print results return render_to_response("search_coach_guser.html", context) else: return render_to_response("error_page.html", {"error": "failed to delete!"})