def get(self, request): self.params = {} self.params['mer_id'] = request.GET.get('mer_id') self.params['row'] = request.GET.get('row') self.params['page'] = request.GET.get('page') self.params['product_name'] = request.GET.get('product_name') mysql = Mysql() sql = "SELECT * FROM mer_product WHERE mer_id = {mer_id} AND product_name \ LIKE '%{product_name}%'".format( mer_id=self.params['mer_id'], product_name=self.params['product_name']) print(sql) info = mysql.getAll(sql) mysql.dispose() if info: sumpage, info = Pagings.paging(info, row=self.params['row'], page=self.params['page']) data = {} data['sumpage'] = sumpage data['info'] = info data = json.dumps(data, ensure_ascii=False, sort_keys=True, indent=4, cls=ComplexEncode) return HttpResponse(data) return HttpResponse(0)
def get(self, request): parentid = request.GET.get('parentid') mysql = Mysql() sql = 'SELECT * FROM proclass WHERE parentId = %s' class_info = mysql.getAll(sql, param=[parentid]) mysql.dispose() return HttpResponse(callJson(class_info))
def get(self, request): recurrence_no = request.GET.get('recurrence_no') recurrence_name = request.GET.get('recurrence_name') row = int(request.GET.get('row')) page = int(request.GET.get('page')) mysql = Mysql() if recurrence_no: sql = f"SELECT * FROM recurrence WHERE recurrence_no \ = '{recurrence_no}'" if recurrence_name: sql = f"SELECT * FROM recurrence WHERE recurrence_name \ LIKE '%{recurrence_name}%'" if not recurrence_no and not recurrence_name: sql = "SELECT * FROM recurrence" info = mysql.getAll(sql) mysql.dispose() if info: sum_page, info = Pagings.paging(info, row=row, page=page) data = {} data['sum_page'] = sum_page data['info'] = info data = json.dumps(data, ensure_ascii=False, sort_keys=True, indent=4) return HttpResponse(data) return HttpResponse(0)
def get(self, request): area_name = request.GET.get('area_name') row = request.GET.get('row') page = request.GET.get('page') area_id = request.GET.get('area_id') get_school = request.GET.get('get_school') mysql = Mysql() if int(get_school) == 0: sql = "SELECT * FROM school_area WHERE area_name like '%{area_name}%'".format( area_name=area_name) if int(get_school) == 1: sql = "SELECT * FROM school WHERE area_id = '{area_id}'".format( area_id=area_id) print(sql) info = mysql.getAll(sql) mysql.dispose() if info: sumpage, info = Pagings.paging(info, row=row, page=page) data = {} data['sumpage'] = sumpage data['info'] = info data = json.dumps(data, ensure_ascii=False, sort_keys=True, indent=4) return HttpResponse(data) return HttpResponse(0)
def save_data(self, mobile): mysql = Mysql() sql = "update userInfo set mobile=%s where openid=%s" checkOk = mysql.update(sql, param=[mobile, self.Info['openid']]) mysql.dispose() print(f"用户 {self.Info['openid']} 更新手机号 {mobile}") return True
def get(self, request): start_time = request.GET.get('start_time') end_time = request.GET.get('end_time') row = request.GET.get('row') page = request.GET.get('page') mysql = Mysql() sql = f"SELECT \ COUNT(*) AS numbs, \ s.store_name, \ sum(o.orderMoney) AS sum_money \ FROM orders AS o ON \ LEFT JOIN store AS s ON o.store_id = s.id \ WHERE o.state = 4 AND \ o.createTime BETWEEN '{start_time}' AND '{end_time}' GROUP BY s.id " info = mysql.getAll(sql) mysql.dispose() if info: sum_page, info = Pagings.paging(info, row=row, page=page) data = {} data['sum_page'] = sum_page data['info'] = info data = json.dumps(data, ensure_ascii=False, sort_keys=True, indent=4, cls=ComplexEncode) return HttpResponse(data) return HttpResponse(0)
def isEsxit(self, openid): ''' 判断用户是否存在,不存在则插入 ''' mysql = Mysql() sql = 'select id, mobile, school_id from userInfo where openid=%s' data = mysql.getOne(sql, param=[openid]) if data: print(f"***********用户已经存在了****id{data.get('id')}*********") mysql.dispose() data['isnew'] = 0 return data else: sql = "INSERT INTO userInfo(openid, createTime, isVip, vipEndTime, hhcoin) VALUE \ (%s, NOW(),1, DATE_ADD(Now(), INTERVAL 7 day ), 100)" user_id = mysql.insertOne(sql, param=[openid]) if user_id: mysql.dispose() data = {} data['id'] = user_id data['mobile'] = None data['school_id'] = None data['isnew'] = 1 print(f"**************新增用户成功****id{user_id}**********") return data else: mysql.errdispose() print("**************新增用户失败****************") return False
def turntable(self): mysql = Mysql() sql = "SELECT * FROM probability ORDER BY id" info = mysql.getAll(sql) mysql.dispose() random_list = [] id_list = [] for i in info: random_list.append(i.get('probability_num')) id_list.append(i.get('id')) a = sum(random_list[0:1]) + 1 b = sum(random_list[0:2]) + 1 c = sum(random_list[0:3]) + 1 d = sum(random_list[0:4]) + 1 e = sum(random_list[0:5]) + 1 f = sum(random_list[0:6]) + 1 g = sum(random_list[0:7]) + 1 h = sum(random_list[0:8]) + 1 num = randint(1, 100) if num in list(range(1, a)): return id_list[0] elif num in list(range(a, b)): return id_list[1] elif num in list(range(b, c)): return id_list[2] elif num in list(range(c, d)): return id_list[3] elif num in list(range(d, e)): return id_list[4] elif num in list(range(e, f)): return id_list[5] elif num in list(range(f, g)): return id_list[6] elif num in list(range(g, h)): return id_list[7]
def get(self, request): user_id = request.GET.get('user_id') mysql = Mysql() sql = f"SELECT \ o.orderNum, \ o.state, \ o.orderMoney, \ o.createTime, \ og.stock_name, \ og.stock_detail \ FROM \ orders AS o \ LEFT JOIN ordergoods AS og \ ON o.orderNum = og.order_id \ WHERE \ createUser = '******' \ AND orderNum LIKE '%kanjia%'" data = mysql.getAll(sql) mysql.dispose() if data: data = json.dumps(data, ensure_ascii=False, sort_keys=True, indent=4, cls=ComplexEncode) return HttpResponse(data) else: return HttpResponse(0)
def get(self, request): state = request.GET.get('state') #0未领取 1领取 re_id = request.GET.get('re_id') row = request.GET.get('row') page = request.GET.get('page') mysql = Mysql() sql = "" if state: sql = f"SELECT reward_log.*, userInfo.wxname, userInfo.user_img FROM reward_log \ LEFT JOIN userInfo ON reward_log.user_id = userInfo.id WHERE \ (prize_type = 1 or prize_type = 2) AND `get` = {state}" else: sql = "SELECT reward_log.*, userInfo.wxname, userInfo.user_img FROM reward_log \ LEFT JOIN userInfo ON reward_log.user_id = userInfo.id WHERE \ (prize_type = 1 or prize_type = 2)" if re_id: sql = f"SELECT reward_log.*, userInfo.wxname, userInfo.user_img FROM reward_log \ LEFT JOIN userInfo ON reward_log.user_id = userInfo.id WHERE \ (prize_type = 1 or prize_type = 2) AND reward_log.id = {re_id}" info = mysql.getAll(sql) mysql.dispose() if info: sumpage, info = Pagings.paging(info, row=row, page=page) data = {} data['sumpage'] = sumpage data['info'] = info data = json.dumps(data, ensure_ascii=False, sort_keys=True, indent=4, cls=ComplexEncode) return HttpResponse(data) return HttpResponse(0)
def add(self): if int(self.info['num']) <= 0: return HttpResponse(returnJson(-2, '数量出现错误')) mysql = Mysql() sql = "SELECT id, num FROM cart WHERE userid=%s AND stock_id=%s AND store_id = %s" data = mysql.getOne(sql, param=[ self.info['user_id'], self.info['stock_id'], self.info['store_id'] ]) #新增数量判断 sql = "SELECT \ h.iNumUsed + h.iNumFreeze AS limits, \ p.id AS pid, \ s.id AS sid, \ p.user_goods_limit, \ h.iNumTotal \ FROM \ stock AS s \ LEFT JOIN product AS p ON s.product_id = p.id \ LEFT JOIN tbHold AS h ON h.sHoldKey = CONCAT('product_1909_', p.id) AND h.iUserId=%s \ WHERE s.id = %s" product_id = mysql.getOne( sql, param=[self.info['user_id'], self.info['stock_id']]) if not product_id: return HttpResponse(returnJson(-2, "库存编号错误")) if product_id.get('limits'): limits = int(product_id.get('limits')) + self.info['num'] \ if product_id.get('iNumTotal') else self.info['num'] limits += int(info.get('num')) if data else 0 if limits > int(product_id.get('user_goods_limit')): return HttpResponse(returnJson(-2, '超出限量限制')) #加入购物车 if data: sql = "UPDATE cart SET num = num + %s WHERE userid=%s \ AND stock_id=%s AND store_id = %s" mysql.update(sql, param=[ self.info['num'], self.info['user_id'], self.info['stock_id'], self.info['store_id'] ]) else: sql = "INSERT INTO cart SET userid = %s, stock_id = %s, \ num = %s, store_id = %s" mysql.insertOne(sql, param=[ self.info['user_id'], self.info['stock_id'], self.info['num'], self.info['store_id'] ]) mysql.dispose() return HttpResponse(returnJson(0, "加入购物车成功"))
def get(self, request): product_id = int(request.GET.get('product_id')) mysql = Mysql() sql = "SELECT * FROM stock WHERE product_id = %s AND state = 1" info = mysql.getAll(sql, param=[product_id]) mysql.dispose() if info: return HttpResponse(callJson(info)) return HttpResponse(0)
def post(self, request): user_id = request.POST.get('user_id') mysql = Mysql() sql = f"SELECT * FROM userInfo WHERE id = '{user_id}'" print(sql) # info = mysql.getAll(sql) info = mysql.getOne(sql) mysql.dispose() return JsonResponse(info)
def get(self, request): mysql = Mysql() sql = "SELECT * FROM prize_class" info = mysql.getAll(sql) mysql.dispose() if info: info = json.dumps(info, ensure_ascii=False, sort_keys=True, indent=4) return HttpResponse(info) return HttpResponse(0)
def get(self, request, **payload): user = request.GET.get('user') mysql = Mysql() sql = f"SELECT power FROM users WHERE mobile = '{user}'" check = mysql.getOne(sql) mysql.dispose() if check: return JsonResponse(check) return HttpResponse(0)
def get(self, request): prize_id = request.GET.get('prize_id') mysql = Mysql() sql = "SELECT * FROM prize_coupon WHERE prize_id = '{prize_id}'".format(prize_id=prize_id) info = mysql.getAll(sql) if info: info = json.dumps(info, sort_keys=True, ensure_ascii=False, indent=4) return HttpResponse(info) return HttpResponse(0)
def get(self, request): store_id = request.GET.get('store_id') order_num = request.GET.get('order_num') #订单编号 order_state = request.GET.get( 'order_state') #订单状态0待付款1代发货2待收货3售后4已完成5取消6抽奖 row = request.GET.get('row') page = request.GET.get('page') print(request.GET) mysql = Mysql() sql = "SELECT orders.*, userInfo.wxname, store.store_name FROM orders \ LEFT JOIN userInfo ON orders.createUser = userInfo.id \ LEFT JOIN store ON store.id = orders.store_id \ ORDER BY createTime DESC" if order_num: sql = f"SELECT orders.*, userInfo.wxname, store.store_name FROM orders \ LEFT JOIN userInfo ON orders.createUser = userInfo.id \ LEFT JOIN store ON store.id = orders.store_id \ WHERE orders.orderNum = '{order_num}' \ ORDER BY createTime DESC" if order_state: sql = f"SELECT orders.*, userInfo.wxname, store.store_name FROM orders \ LEFT JOIN userInfo ON orders.createUser = userInfo.id \ LEFT JOIN store ON store.id = orders.store_id \ WHERE orders.state = '{order_state}' \ ORDER BY createTime DESC" if store_id: sql = f"SELECT orders.*, userInfo.wxname, store.store_name FROM orders \ LEFT JOIN userInfo ON orders.createUser = userInfo.id \ LEFT JOIN store ON store.id = orders.store_id \ WHERE orders.store_id = '{store_id}' \ ORDER BY createTime DESC" if store_id and order_state: sql = f"SELECT orders.*, userInfo.wxname, store.store_name FROM orders \ LEFT JOIN userInfo ON orders.createUser = userInfo.id \ LEFT JOIN store ON store.id = orders.store_id \ WHERE orders.store_id = '{store_id}' AND orders.state = '{order_state}' \ ORDER BY createTime DESC" info = mysql.getAll(sql) mysql.dispose() if info: sumpage, info = Pagings.paging(info, row=row, page=page) data = {} data['sumpage'] = sumpage data['info'] = info data = json.dumps(data, ensure_ascii=False, sort_keys=True, indent=4, cls=ComplexEncode) return HttpResponse(data) return HttpResponse(0)
def get(self, request): admin_id = request.GET.get('id') mysql = Mysql() sql = 'delete from users where id=%s' state = mysql.delete(sql, param=[ admin_id ]) mysql.dispose() state = 1 if state else 0 return JsonResponse({'state': state})
def get(self, request): banner_path = request.GET.get('banner_path') mysql = Mysql() sql = "SELECT * FROM banner WHERE banner_path = %s ORDER BY banner_type" info = mysql.getAll(sql, param=[banner_path]) mysql.dispose() info = json.dumps(info, ensure_ascii=False, sort_keys=True, indent=4) if info: return HttpResponse(info) return HttpResponse(0)
def get(self, request): mysql = Mysql() sql = 'select * from users' data = mysql.getAll(sql) mysql.dispose() return JsonResponse({ 'ret' : 0, 'msg' : '查询成功', 'result' : data })
def add_activity_class(self): mysql = Mysql() sql = "INSERT INTO activity_class SET acti_classname = '{name}', \ acti_parentId = '{parentId}'".format( name=self.__reqData['name'], parentId=self.__reqData['parentId']) suc = mysql.insertOne(sql) if suc: return 1 else: return 0
def get(self, request): class_id = request.POST.get('class_id') mysql = Mysql() sql = "SELECT * FROM prize WHERE class_id='{class_id}'".format(class_id=class_id) info = mysql.getAll(sql) mysql.dispose() if info: info = json.dumps(info, ensure_ascii=False, sort_keys=True, indent=4) return HttpResponse(info) return HttpResponse(0)
def sel_activity(self): mysql = Mysql() sql = 'SELECT * FROM activity' info = mysql.getAll(sql) if info: iswin = 1 else: iswin = 0 mysql.dispose() return info, iswin
def get(self, request, **payload): self.params = {} self.params['mer_id'] = request.GET.get('mer_id') mysql = Mysql() sql = "SELECT * FROM mer_product WHERE mer_id = %s" info = mysql.getAll(sql, param=[self.params['mer_id']]) mysql.dispose() if info: return HttpResponse(callJson(info)) return HttpResponse(0)
def get(self, request): mer_id = request.GET.get('mer_id') mysql = Mysql() sql = f"SELECT mer_userid, user_name, wx_img, phone, is_admin, openid FROM mer_admin WHERE mer_id = {mer_id}" info = mysql.getAll(sql) mysql.dispose() if info: data = json.dumps(info, ensure_ascii=False, sort_keys=True, indent=4, cls=ComplexEncode) return HttpResponse(data) return HttpResponse(0)
def starSignLog(user_id, handle_type): mysql = Mysql() sql = f"SELECT * FROM star_sign_log WHERE user_id = {user_id} \ AND handle_type = {handle_type}" data = mysql.getOne(sql) mysql.dispose() if data: return True return False
def get(self, request): mysql = Mysql() sql = "SELECT p.*, pr.prize_detail, pr.all_limit, pr.one_limit FROM probability as p \ LEFT JOIN prize as pr ON p.prize_id = pr.id ORDER BY p.id" info = mysql.getAll(sql) mysql.dispose() if info: info = json.dumps(info, ensure_ascii=False, sort_keys=True, indent=4) return HttpResponse(info) return 0
def shopOrder(self): mysql = Mysql() sql = "SELECT o.product_id, o.stock_name, p.user_goods_limit FROM ordergoods \ AS o LEFT JOIN product AS p ON o.product_id = p.id WHERE o.order_id = %s" info = mysql.getAll(sql, param=[self.Info['orderNum']]) sql = "SELECT createUser FROM orders WHERE orderNum = %s" user_id = mysql.getOne(sql, param=[self.Info['orderNum']]) holds = [] for i in info: if i.get('user_goods_limit') != 0: key = 'product_1909_' + str(i.get('product_id')) data = {} data['key'] = key data['ext'] = str(i.get('stock_name')) holds.append(data) if holds: check = hold_shikou(holds=holds, user_id=user_id.get('createUser'), mysql=mysql) if check['ret'] == -2: raise Exception("实扣限量出现问题") mysql = Mysql() sql = "update orders set state = '1', wxid=%s where orderNum=%s" suc = mysql.update(sql, param=[self.Info['wxid'], self.Info['orderNum']]) mysql.dispose()
def get_userinfo(self, access_token, openid): mysql = Mysql() sql = "SELECT * FROM h5_user WHERE openid = %s" check = mysql.getOne(sql, param=[openid]) if check: mysql.dispose() return check url = f'https://api.weixin.qq.com/sns/userinfo?access_token={access_token}&openid={openid}&lang=zh_CN' response = requests.get(url) response.encoding = 'utf-8' response.text user_info = response.json() sql = 'INSERT INTO h5_user SET unionid=%s, openid=%s, \ city=%s, country=%s, headimgurl=%s, lucky_draw_times=1' mysql.insertOne(sql, param=[ user_info.get('unionid'), user_info.get('openid'), user_info.get('city'), user_info.get('country'), user_info.get('headimgurl') ]) mysql.dispose() return user_info
def del_activity_class(self): mysql = Mysql() sql = "SELECT * FROM activity WHERE acti_class_id = '{id}'".format( id=self.__reqData['id']) info = mysql.getAll(sql) if info: #有活动 return 2 else: sql = "SELECT * FROM activity_class WHERE acti_parentId = '{id}'".format( id=self.__reqData['id']) suc = mysql.getOne(sql) if suc: #分类下有子分类 return 3 else: sql = "DELETE FROM activity_class WHERE id = '{id}'".format( id=self.__reqData['id']) suc = mysql.delete(sql) if suc: mysql.dispose() return 1 else: mysql.errdispose() return 0