def update(pid): db = MhDatabases() if request.method == 'GET': result = db.executeQuery("select * from goods where gid=%s", [pid]) # 从数据库获取商品信息并返回 return render_template("update.html", result=result) else: gid = request.form.get("productId") # 获取web前端发送的要删除的商品ID print(gid) if gid: db.executeUpdate("delete from goods where gid=%s", [gid]) # 在数据库中删除商品信息 return redirect(url_for('product')) else: # 获取web前端发送的商品要修改的信息 product = [] product.append(request.form.get("type")) product.append(int(request.form.get("number"))) product.append(float(request.form.get("price"))) product.append(request.form.get("location")) print(product) # 在数据库中修改商品信息 db.executeUpdate( "update goods set sort=%s,number=%s,uprice=%s,location=%s where gid=%s", [product[0], product[1], product[2], product[3], pid]) return redirect(url_for('product'))
def idcodelogin(): db = MhDatabases() # 获取微信小程序端传来的用户id id = str(json.loads(request.values.get("id"))) print(id) result = db.executeQuery("select * from user where phone=%s", [id]) # 查询id在数据库是否已存在 if len(result) == 0: db.executeUpdate("insert into user values(%s,null,null,null) ", [id]) res = "成功" return json.dumps(res)
def cartdelete(): db = MhDatabases() # 获取微信小程序端传来的商品id,删除商品数组 id = str(json.loads(request.values.get("id"))) scart = json.loads(request.values.get("scart")) for i in scart: db.executeUpdate( "update pcr set isdelete=1 where gid=%s and buyerid=%s and optype=5", [i['gid'], id]) # 修改订单isdelete项 res = "删除成功" return json.dumps(res)
def productAdd(): # 连接数据库 db = MhDatabases() if request.method == 'GET': return render_template("productAdd.html") else: # 获取要添加的商品信息 product = [] product.append(request.form.get("productId")) product.append(request.form.get("productName")) product.append(request.form.get("type")) product.append(int(request.form.get("number"))) product.append(float(request.form.get("price"))) product.append(request.form.get("dateofproduce")) product.append(request.form.get("dateofbad")) print(product) # 查询数据库中是否已存在该商品,如果不存在则向数据库添加商品信息 result1 = db.executeQuery("select * from goods where gid=%s", [product[0]]) result2 = db.executeQuery("select * from goods where name=%s", [product[1]]) if len(result1[0]) == 0 and len(result2[0]) == 0: result = db.executeUpdate( "insert into goods values(%s,%s,null,%s,%s,%s,%s,%s,null)", product) else: result = 0 return render_template("productAdd.html", data=result)
def updatemine(): db = MhDatabases() # 获取微信小程序端传来的用户修改信息 name = str(json.loads(request.values.get("name"))) sex = str(json.loads(request.values.get("sex"))) id = str(json.loads(request.values.get("id"))) password = str(json.loads(request.values.get("password"))) result = db.executeUpdate( "update user set pwd=%s,gender=%s,name=%s where phone=%s", [password, sex, name, id]) # 修改用户在数据库中的个人信息记录 if result == 0: res = "修改失败" else: res = "修改成功" return json.dumps(res)
def cartchange(): db = MhDatabases() id = str(json.loads(request.values.get("id"))) gid = str(json.loads(request.values.get("gid"))) quantity = int(json.loads(request.values.get("quantity"))) r = db.executeUpdate( "update pcr set number=%s where gid=%s and buyerid=%s and optype=5", [quantity, gid, id]) if r == 1: res = "修改失敗" else: res = "修改成功" return json.dumps(res)
def deleteorders(): db = MhDatabases() # 获取微信小程序端传来的ID和订单完成时间 id = str(json.loads(request.values.get("id"))) time = str(json.loads(request.values.get("times"))) print("id", id, " time", time) # 根据ID和订单完成时间修改该订单在数据库中的isdelete项 result = db.executeUpdate( "update pcr set isdelete=true where buyerid=%s and time=%s and optype=10 ", [id, time]) # 返回删除的结果: if result == 0: res = "删除失败" else: res = "删除成功" return json.dumps(res)
def userregister(): db = MhDatabases() # 获取微信小程序端传来的注册用户的id,password,name,sex id = str(json.loads(request.values.get("id"))) password = str(json.loads(request.values.get("password"))) name = str(json.loads(request.values.get("name"))) sex = str(json.loads(request.values.get("sex"))) print("name", name, " sex", sex, " id", id, " password", password) # 判断id是否已注册,将信息存入数据库 result1 = db.executeQuery("select * from user where phone=%s", [id]) if len(result1) == 0: result = db.executeUpdate("insert into user values(%s,%s,%s,%s)", [id, password, sex, name]) res = "注册成功" else: res = "注册失败,手机号已注册" return json.dumps(res)
def score(): # 连接数据库 db = MhDatabases() # 获取微信小程序端传来的ID和password id = str(json.loads(request.values.get("id"))) password = str(json.loads(request.values.get("password"))) name = str(json.loads(request.values.get("name"))) sex = str(json.loads(request.values.get("sex"))) print("name", name, " sex", sex, " id", id, " password", password) # 根据ID在数据库中查询用户数据 result1 = db.executeQuery("select * from goods where gid=%s", [id]) if len(result1[0]) == 0: result = db.executeUpdate("insert into goods values(%s,%s,%s,%s,)", [id, password, sex, name]) else: result = 0 if result == 1: res = "注册成功" else: res = "注册失败,手机号已注册" return json.dumps(res)
def cartadd(): db = MhDatabases() # 获取微信小程序端传来的用户id,商品信息 id = str(json.loads(request.values.get("id"))) gid = str(json.loads(request.values.get("gid"))) quantity = int(json.loads(request.values.get("quantity"))) time = str(json.loads(request.values.get("time"))) result = db.executeQuery( "select image,name,sort,uprice,number from goods where gid=%s", [gid]) # 获取商品在数据库中的详细信息 print(result) if result[0][4] - quantity < 0: res = "库存不足" else: order = [] price = result[0][3] order.append(result[0][0]) order.append(gid) order.append(result[0][1]) order.append(result[0][2]) order.append(quantity) order.append(price) order.append(quantity * price) order.append(time) order.append(id) order.append(5) order.append(0) r = db.executeUpdate( "insert into pcr values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)", order) # 添加加入购物车记录 if r == 1: res = "添加成功" else: res = "添加失败" return json.dumps(res)
def add(): db = MhDatabases() if request.method == 'GET': return render_template("add.html") else: # 获取web前端发送要添加的商品信息 img = request.files.get("myFile") fname = img.filename filepath = "./static/img/" + fname img.save("C:/macrohardweb/static/img/" + fname) product = [] product.append(request.form.get("productId")) product.append(request.form.get("productName")) product.append(filepath) product.append(request.form.get("type")) product.append(int(request.form.get("number"))) product.append(float(request.form.get("price"))) product.append(request.form.get("dateofproduce")) product.append(request.form.get("dateofbad")) product.append(request.form.get("location")) print(product) # 查询数据库中是否已存在该商品,如果不存在则向数据库添加商品信息 result1 = db.executeQuery("select * from goods where gid=%s", [product[0]]) result2 = db.executeQuery("select * from goods where name=%s", [product[1]]) result3 = db.executeQuery("select * from goods where image=%s", [product[2]]) if len(result1) == 0 and len(result2) == 0 and len(result3) == 0: result = db.executeUpdate( "insert into goods values(%s,%s,%s,%s,%s,%s,%s,%s,%s)", product) else: result = 0 return render_template("add.html", data=result)
def cartsettle(): db = MhDatabases() # 获取微信小程序端传来的商品id,订单时间,结算商品数组 id = str(json.loads(request.values.get("id"))) time = str(json.loads(request.values.get("time"))) scart = json.loads(request.values.get("scart")) print(id, time, scart) for i in scart: order = [] result = db.executeQuery( "select name,image,sort,number from goods where gid=%s", [i['gid']]) # 获取商品信息 print(result) if len(result) != 0: order.append(result[0][1]) # image order.append(i['gid']) # gid order.append(result[0][0]) # name order.append(result[0][2]) # sort gnumber = result[0][3] - int(i['quantity']) # gnumber order.append(int(i['quantity'])) # number order.append(float(i['price'])) # uprice order.append(int(i['quantity']) * float(i['price'])) # total order.append(time) # time order.append(id) # buyerid order.append(10) # optype order.append(0) # isdelete if gnumber < 0: res = "库存不足" else: db.executeUpdate("update goods set number=%s where gid=%s", [gnumber, order[1]]) # 修改商品库存 db.executeUpdate( "update pcr set isdelete=1 where gid=%s and buyerid=%s and optype=5", [order[1], order[8]]) # 修改加入购物车订单isdelete项 db.executeUpdate( "insert into pcr values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)", order) # 添加购买记录 res = "结算成功" else: res = "结算失败" return json.dumps(res)
def productUpdate(pid): # 连接数据库 db = MhDatabases() if request.method == 'GET': # 从数据库获取商品信息并返回 result = db.executeQuery("select * from goods where gid=%s", [pid]) return render_template("productUpdate.html", result=result) else: # 获取商品可修改的信息 product = [] pid = request.form.get("productId") product.append(request.form.get("type")) product.append(int(request.form.get("number"))) product.append(float(request.form.get("price"))) print(product) # 在数据库中修改商品信息 db.executeUpdate("update goods set sort=%s where gid=%s", [product[0], pid]) db.executeUpdate("update goods set number=%s where gid=%s", [product[1], pid]) db.executeUpdate("update goods set uprice=%s where gid=%s", [product[2], pid]) return redirect(url_for('product'))