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!"})
