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('{}')