def search_store(request):
# 获取店铺名字和搜索关键字
store_name = request.GET["store_name"]
shop_name = request.GET["shop_name"]
print store_name, "----", shop_name
name = request.session.get("name")
# 从数据库中查找指定店铺所查询的商品信息
result = Userdata.find(store_name, shop_name)
data = {"details": result, "name": name, "shop_name": shop_name}
return render(request, "jinrudianpuxiangqing.html", data)
def log_out(request):
# 从数据库中获取数据放到网页中去
result = Userdata.get_kind(1)
result1 = Userdata.get_kind(3)
result2 = Userdata.get_kind(5)
result3 = Userdata.get_kind(4)
result4 = Userdata.get_kind(2)
data = {
"shuju": result[0:8],
"shuju1": result1[0:8],
"shuju2": result2[0:8],
"shuju3": result3[0:8],
"shuju4": result4[0:8],
"shuju5": result[10:15],
"shuju6": result4[10:15]
}
# 退出登录则删除session保存用户信息
if request.session.get("name") != None:
del request.session["name"]
return render(request, "index.html", data)
def Vipcenter(request):
# 获取用户名从数据库中查询
name = request.session.get("name")
pwd = request.session.get("pwd")
# 如果用户长时间没有操作，session失效，则进入到登录页面
if name == None:
return render(request, "login.html")
# 从数据库中查找该用户对应的购物车列表，商品收藏的列表，收藏的店铺列表
result = Userdata.shop_cart(name)
# 通过用户名查询该用户收藏的商品，店铺，以及购物车商品
result1 = Userdata.shop_cang(name)
result2 = Userdata.store_cang(name)
data = {
"name": name,
"pwd": len(pwd),
"shuju": result[0:5],
"shuju1": result1[0:5],
"shuju2": result2[0:8]
}
return render(request, "vipcenter.html", data)
def sales(request):
# 获取搜索关键字
shop_name = request.GET["shop_name"]
name = request.session.get("name")
# 从数据库中查找数据
if request.GET["kind"] == "":
kind = ""
result = Userdata.sales_desc(shop_name)
else:
kind = request.GET["kind"]
result = Userdata.sales_desc_kind(shop_name, request.GET["kind"])
# 这里i是对应的分类
i = result[0][12]
# 从数据库中查找对应的销量最高的5条商品数据
result1 = Userdata.guess(shop_name, i)
data = {
"data": result,
"name": name,
"shop_name": shop_name,
"data1": result1[0:5],
"kind": kind
}
return render(request, "liebiaoye.html", data)
def islogin(request):
# 获取用户名和密码
name = request.POST["name"]
pwd = request.POST["pwd"]
print name, "-----", pwd
# 从数据库中查询是否存在用户
result = Userdata.islogin(name, pwd)
print result
s = ''
if len(result) > 0:
print "存在用户"
# 不能出现result[0][1]
s = '{"sex":"nan"}'
request.session["name"] = result[0][1]
request.session["pwd"] = result[0][2]
request.session["phone"] = result[0][4]
else:
print "不存在用户"
s = '{}'
return HttpResponse(s)
def index(request):
name = request.session.get("name")
# 首页上方的购物车信息显示
cart = Userdata.shop_cart(name)
# 获取数据库中不同种类的商品
result = Userdata.get_kind(1)
result1 = Userdata.get_kind(3)
result2 = Userdata.get_kind(5)
result3 = Userdata.get_kind(4)
result4 = Userdata.get_kind(2)
data = {
"shuju": result[0:8],
"name": name,
"cart": cart[0:5],
"shuju1": result1[0:8],
"shuju2": result2[0:8],
"shuju3": result3[0:8],
"shuju4": result4[0:8],
"shuju5": result[10:15],
"shuju6": result4[10:15]
}
# 值为0则表示关闭浏览器session直接过期，如果值是int类型，则表示在多少秒后过期
# request.session.set_expiry(600)
return render(request, "index.html", data)
def D_shop(request):
# 获取用户名
name = request.session.get("name")
id = request.GET["id"]
Userdata.D_shop(name, id)
return HttpResponse('{}')
def D_allstore(request):
# 获取用户名
name = request.session.get("name")
Userdata.D_allstore(name)
return HttpResponse('{}')
def del_store(request):
# 获取用户名和要删除的店铺名
name = request.session.get("name")
store_name = request.GET["store"]
Userdata.del_store(name, store_name)
return HttpResponse('{}')
def add_store(request):
name = request.session.get("name")
store = request.GET["store"]
time = request.GET["time"]
Userdata.add_store(name, store, time)
return HttpResponse('{}')