def get(self, request, **payload): self.params = {} self.params['product_id'] = request.GET.get('product_id') data = {} mysql = Mysql() sql = "SELECT * FROM mer_stock WHERE product_id = %s" stock = mysql.getAll(sql, param=[self.params['product_id']]) if stock: data['stock'] = stock sql = "SELECT spec_id, spec_name FROM mer_spec WHERE product_id = %s" spec_name = mysql.getAll(sql, param=[self.params['product_id']]) spec_info = [] if stock[0].get('stock_specs'): for i in spec_name: spec_deatil_dic = {} spec_deatil_dic['spec'] = i sql = "SELECT spec_detail_id, detail_name FROM mer_specdetail \ WHERE spec_id = %s" spec_detail = mysql.getAll(sql, param=[i.get('spec_id')]) spec_deatil_dic['spec_detail'] = spec_detail spec_info.append(spec_deatil_dic) data['spec_info'] = spec_info return HttpResponse(callJson(data)) mysql.dispose() return HttpResponse(0)
def selProduct(self): mysql = Mysql() sql = "SELECT * FROM mer_product WHERE mer_id = %s limit %s, %s" page, row = Pagings.mysqlPagings(self.params['page'], self.params['row']) product = mysql.getAll(sql, param=[self.params['mer_id'], page, row]) for i in product: sql = "SELECT * FROM mer_stock WHERE product_id = %s" stock = mysql.getAll(sql, param=[i.get('product_id')]) if stock: i['stock'] = stock sql = "SELECT spec_id, spec_name FROM mer_spec WHERE product_id = %s" spec_name = mysql.getAll(sql, param=[i.get('product_id')]) spec_info = [] if stock[0].get('stock_specs'): for x in spec_name: spec_deatil_dic = {} spec_deatil_dic['spec'] = x sql = "SELECT spec_detail_id, detail_name FROM mer_specdetail \ WHERE spec_id = %s" spec_detail = mysql.getAll(sql, param=[x.get('spec_id')]) spec_deatil_dic['spec_detail'] = spec_detail spec_info.append(spec_deatil_dic) i['spec_info'] = spec_info mysql.dispose() return HttpResponse(returnJson(0, '查询成功', product))
def sel_activity_class(self): mysql = Mysql() if self.__reqData['parentId']: sql = 'SELECT * FROM activity_class WHERE acti_parentId = "{parentId}"'.format( id=self.__reqData['parentId']) info = mysql.getAll(sql) return info else: sql = 'SELECT * FROM activity_class WHERE acti_parentId = 0' info = mysql.getAll(sql) mysql.dispose() return info
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 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): 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 get(self, request): title = request.GET.get('title') news_id = request.GET.get('news_id') row = request.GET.get('row') page = request.GET.get('page') mysql = Mysql() if news_id: sql = f"SELECT * FROM information WHERE title LIKE '%{title}%' ORDER BY create_time DESC " info = mysql.getAll(sql) mysql.dispose() if info: for i in info: i['details'] = html.unescape(i.get('details')) 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) else: print('id形式') sql = f"SELECT * FROM information WHERE id = '{news_id}'" info = mysql.getOne(sql) info['details'] = html.unescape(info.get('details')) mysql.dispose() if info: info = json.dumps(info, ensure_ascii=False, sort_keys=True, indent=4, cls=ComplexEncode) return HttpResponse(info) else: return HttpResponse(0)
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): user_id = request.GET.get("user_id") row = request.GET.get('row') page = request.GET.get('page') mysql = Mysql() page, row = Pagings.mysqlPagings(page=page, row=row) sql = f"SELECT id, logtime, detail, prize_type, `get` FROM \ reward_log WHERE user_id = {user_id} AND prize_type !=8 \ ORDER BY logtime DESC limit {page}, {row}" info = mysql.getAll(sql) sql = f"SELECT COUNT(id) as c FROM reward_log WHERE \ user_id = {user_id} AND prize_type !=8" sum_page = mysql.getOne(sql) sum_page = math.ceil(int(sum_page.get('c')) / int(row)) mysql.dispose() if info: 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 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): 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 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 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
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(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 sel_class_list(self): mysql = Mysql() if self.__reqData['name']: sql = "SELECT * FROM proclass WHERE `name` LIKE '%{name}%'".format( name=self.__reqData['name']) info = mysql.getAll(sql) else: sql = "SELECT * FROM proclass" info = mysql.getAll(sql) for i in info: sql = "SELECT `name` FROM proclass WHERE id = %a" parent_name = mysql.getOne(sql, param=[i.get('parentId')]) if parent_name: i['parentName'] = parent_name.get('name') else: i['parentName'] = None return info
def get(self, request): mer_id = request.GET.get("mer_id") start_time = request.GET.get('start_time') end_time = request.GET.get('end_time') handler = request.GET.get('handler') mysql = Mysql() if handler == 'online': sql = f"SELECT m.*, u.wxname, u.user_img FROM mer_orders as m \ LEFT JOIN userInfo as u ON m.user_id = u.id \ WHERE m.mer_id = {mer_id} AND state = 1 AND \ m.create_time BETWEEN '{start_time}' AND '{end_time}'\ ORDER BY m.create_time DESC " order_info = mysql.getAll(sql) if order_info: order_list = [] for i in order_info: data = {} sql = f'''SELECT * FROM mer_ordergoods WHERE order_num="{i.get('order_num')}"''' order_goods = mysql.getAll(sql) data['order'] = i for x in order_goods: specs = x.get('mer_stockname').split('-') x['stock_name'] = specs[0] x['spec'] = '-'.join(specs[1:len(specs)]) data['goods'] = order_goods order_list.append(data) mysql.dispose() return HttpResponse(callJson(order_list)) mysql.dispose() return HttpResponse(0) if handler == 'underline': sql = f"SELECT m.*, u.wxname, u.user_img FROM mer_pay \ AS m LEFT JOIN userInfo AS u ON m.user_id = u.id WHERE \ mer_id = {mer_id} AND state = 1 AND m.create_time BETWEEN \ '{start_time}' AND '{end_time}' ORDER BY m.create_time DESC" info = mysql.getAll(sql) mysql.dispose() if info: return HttpResponse(callJson(info)) return HttpResponse(0) else: return HttpResponse(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 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): 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): try: user_id = payload.get('user_id') mysql = Mysql() data = {} sql = "SELECT * FROM user_star_sign WHERE user_id = %s" result = mysql.getAll(sql, param=[user_id]) data = {'ret': 0, 'result': result} if not result: sql = "INSERT INTO user_star_sign SET user_id = %s " mysql.insertOne(sql, param=[user_id]) sql = "SELECT * FROM user_star_sign WHERE user_id = %s" info = mysql.getAll(sql, param=[user_id]) data = {'ret': 0, 'msg': '查询成功', 'result': info} sql = "SELECT unionId FROM userInfo WHERE id = %s" user_info = mysql.getOne(sql, param=[user_id]) if user_info.get('unionId'): sql = "SELECT * FROM h5_luckdraw_log WHERE unionid = %s AND state = 0" luckdraw_log = mysql.getAll(sql, param=[user_info.get('unionId')]) if luckdraw_log: patch_list = [] for i in luckdraw_log: patch_list.append(i.get('patch_id')) sql = 'UPDATE h5_luckdraw_log SET state = 1 WHERE id = %s' mysql.update(sql, param=[i.get('id')]) getPatch(user_id, patch_list, 3, 1, mysql) data['msg'] = '查询成功 碎片领取成功' sql = "SELECT * FROM user_star_sign WHERE user_id = %s" info = mysql.getAll(sql, param=[user_id]) data['result'] = info else: data['msg'] = '查询成功 无碎片领取' else: data['ret'] = -1 data['msg'] = '查询成功 但未绑定unionid 可能会导致h5抽奖碎片领取失败' mysql.dispose() return HttpResponse(callJson(data)) except Exception as e: print(e) mysql.errdispose() erroLog(e) return JsonResponse({'ret': -2, 'msg': '网络错误'})
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): mysql = Mysql() sql = 'select * from users' data = mysql.getAll(sql) mysql.dispose() return JsonResponse({ 'ret' : 0, 'msg' : '查询成功', 'result' : data })
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): 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 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 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 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): quiz_id = request.GET.get("quiz_id") mysql = Mysql() sql = f"SELECT * FROM quiz_bank WHERE quiz_id = {quiz_id}" info = mysql.getAll(sql) mysql.dispose() if info: info = json.dumps(info, ensure_ascii=False, sort_keys=True, indent=4, cls=ComplexEncode) return HttpResponse(info) return HttpResponse(0)