def save_data(self): try: mysql = Mysql() for i in range(3): lottery_code = self.ran(6) sql = "SELECT * from oneyuanpurchase WHERE order_num = %s AND lottery_code IS NULL limit 1" order_id = mysql.getOne(sql, param=[self.Info['orderNum']]) sql = "UPDATE oneyuanpurchase SET lottery_code = %s, state = 1, \ is_get=0, wxid = %s, wx_money = %s WHERE id = %s" mysql.update(sql, param=[ lottery_code, self.Info['wxid'], self.Info['total_fee'], order_id.get('id') ]) sql = "SELECT user_id FROM oneyuanpurchase WHERE order_num = %s" user = mysql.getOne(sql, param=[self.Info['orderNum']]) up_sql, log_sql = Type_Log.coin_handle( user_id=user.get('user_id'), handle=12, num=10, asd=1) mysql.update(up_sql) mysql.insertOne(log_sql) mysql.dispose() except Exception as e: print(e) mysql.errdispose()
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 post(self, request): bp_id = request.POST.get('bp_id') user_id = request.POST.get('user_id') link = request.POST.get('link') try: mysql = Mysql() sql = "SELECT * FROM bargain_user WHERE user_id = %s \ AND bp_id = %s AND (state = 1 OR state = 2) FOR UPDATE" check = mysql.getOne(sql, param=[user_id, bp_id]) if check: msg = '该订单正在砍价中' if int(check.get('state')) == 1 else '有待支付订单' mysql.dispose() return JsonResponse({'ret': -2, 'msg': msg}) sql = "SELECT bp.*, s.price FROM bargain_product AS bp \ LEFT JOIN stock AS s ON bp.stock_id = s.id WHERE bp.id = %s" bp_info = mysql.getOne(sql, param=[bp_id]) sql = "INSERT INTO bargain_user SET user_id = %s, \ bp_id = %s, nowcut_price = 0, present_price = %s, \ bargain_link=%s, state = 1" bu_id = mysql.insertOne( sql, param=[user_id, bp_id, int(bp_info.get('price') * 100), link]) mysql.dispose() return JsonResponse({'ret': 0, 'msg': '发起砍价成功', 'bu_id': bu_id}) except Exception as e: print(e) mysql.errdispose() return HttpResponse(0)
def post(self, request): self.params = {} self.params['phone'] = request.POST.get('phone') self.params['user_name'] = request.POST.get('user_name') self.params['password'] = request.POST.get('password') #可以随机生成密码 self.params['mer_id'] = request.POST.get('mer_id') #商户id 必传 mysql = Mysql() sql = "SELECT is_admin FROM mer_admin WHERE mer_id = '{mer_id}' AND phone ='{phone}' \ AND is_admin = '1'".format(mer_id=self.params['mer_id'], phone=self.params['phone']) check = mysql.getOne(sql) sql = "SELECT is_admin FROM mer_admin WHERE phone ='{phone}'".format( phone=self.params['phone']) check_phone = mysql.getOne(sql) if check or check_phone: mysql.dispose() return HttpResponse(2) sql = "INSERT INTO mer_admin SET phone='{phone}', user_name='{user_name}',\ `password`='{password}', is_admin='1', mer_id='{mer_id}'\ " .format(phone=self.params['phone'],password=self.params['password'], \ mer_id=self.params['mer_id'], user_name=self.params['user_name']) suc = mysql.insertOne(sql) if suc: mysql.dispose() return HttpResponse(1) mysql.errdispose() return HttpResponse(0)
def post(self, request): prize_id = request.POST.get('prize_id') mysql = Mysql() sql = "SELECT * FROM probability WHERE prize_id = '{prize_id}'".format(prize_id=prize_id) info = mysql.getOne(sql) if info: mysql.dispose() return HttpResponse(2) #转盘绑定了商品 不能删除 #检查奖品类型 sql = "SELECT * FROM prize WHERE id = '{prize_id}'".format(prize_id=prize_id) prize_type = mysql.getOne(sql) check_list = [5, 6, 7] #--------盒盒币余额类型 if int(prize_type.get('prize_type')) in check_list: #已在数据库做对应操作 print('删除phv类型') #---------卷码类型 if int(prize_type.get('prize_type')) == 3: #已在数据库做对应操作 print('删除cdk类型') #删除奖品 sql = "DELETE FROM prize WHERE id='{prize_id}'".format(prize_id=prize_id) suc = mysql.delete(sql) if suc: mysql.dispose() return HttpResponse(1) mysql.errdispose() return HttpResponse(0)
def get(self, request): mer_id = request.GET.get('mer_id') mysql = Mysql() sql = f"SELECT mer_type FROM merchant WHERE mer_id = {mer_id}" mer_type = mysql.getOne(sql) mer_type = int(mer_type.get('mer_type')) sql = f"SELECT SUM(wx_money+balance) as money, COUNT(*) as numbs FROM mer_orders \ WHERE TO_DAYS(create_time) = TO_DAYS(NOW()) AND mer_id = '{mer_id}' AND state = 1 " mer_order = mysql.getOne(sql) money1 = mer_order.get('money') if mer_order.get('money') else 0 numbs1 = mer_order.get('numbs') sql = f"SELECT SUM(wx_money+balance) as money, COUNT(*) as numbs FROM mer_pay \ WHERE TO_DAYS(create_time) = TO_DAYS(NOW()) AND mer_id = '{mer_id}' AND state = 1" mer_pay = mysql.getOne(sql) money2 = mer_pay.get('money') if mer_pay.get('money') else 0 numbs2 = mer_pay.get('numbs') info = mysql.getOne(sql) mysql.dispose() info = {'money': money1 + money2, 'numbs': numbs1 + numbs2} return HttpResponse(callJson(info))
def post(self, request, **payload): try: user_id = payload.get('user_id') address = request.POST.get('address') handle_type = request.POST.get('handle_type') if handle_type == 'finish': if not address: return JsonResponse({'ret': -2, 'msg': '地址数据为空'}) mysql = Mysql() sql = "SELECT * FROM user_star_sign WHERE user_id = %s FOR UPDATE" mysql.getOne(sql, param=[user_id]) sql = "SELECT * FROM user_star_sign WHERE \ user_id = %s \ AND one > 0 \ AND two > 0 \ AND three > 0 \ AND four > 0 \ AND five > 0 \ AND six > 0 \ AND seven > 0 \ AND eight > 0 \ AND nine > 0 \ AND ten > 0 \ AND eleven > 0 \ AND twelve > 0 \ AND state = 0" check = mysql.getOne(sql, param=[user_id]) if not check: mysql.dispose() return JsonResponse({'ret': -2, 'msg': '碎片不足或已被领取'}) sql = "UPDATE user_star_sign SET address = %s, \ state = 1 WHERE user_id = %s" mysql.update(sql, param=[address, user_id]) patch_type = [i for i in range(1, 13)] getPatch(user_id, patch_type, 11, 0, mysql) mysql.dispose() return JsonResponse({'ret': 0, 'msg': '领取成功'}) if handle_type == 'update': mysql = Mysql() sql = "SELECT * FROM user_star_sign WHERE state = 1 \ AND user_id = %s FOR UPDATE" user_info = mysql.getOne(sql, param=[user_id]) if not user_info: mysql.dispose() return JsonResponse({'ret': -2, 'msg': '网络繁忙'}) sql = "UPDATE user_star_sign SET address = %s \ WHERE user_id = %s AND state = 1" mysql.update(sql, param=[address, user_id]) mysql.dispose() return JsonResponse({'ret': 0, 'msg': '领取成功'}) return JsonResponse({'ret': -2, 'msg': '参数错误'}) except Exception as e: mysql.errdispose() erroLog(e) return JsonResponse({'ret': -2, 'msg': '网络错误'})
def post(self, request): try: unionid = request.POST.get('unionid') position = request.POST.get('position') mysql = Mysql() sql = "SELECT * FROM h5_user WHERE unionid = %s FOR UPDATE" user_info = mysql.getOne(sql, param=[unionid]) if not user_info: mysql.dispose() return JsonResponse({'ret': -2, 'msg': '无用户信息'}) sql = 'SELECT * FROM gzh_user WHERE unionid = %s AND state = 1' gzh_info = mysql.getOne(sql, param=[unionid]) if not gzh_info: mysql.dispose() return JsonResponse({'ret': -1, 'msg': '未关注公众号'}) sql = "SELECT COUNT(*) AS numbers FROM h5_luckdraw_log \ WHERE unionid = %s AND create_time BETWEEN %s AND %s" numbers = mysql.getOne( sql, param=[unionid, self.START_TIME, self.END_TIME]) if numbers: if numbers.get('numbers') >= 12: mysql.dispose() return JsonResponse({'ret': -2, 'msg': '当日抽奖次数达到上限'}) if user_info.get('lucky_draw_times') < 1: mysql.dispose() return JsonResponse({'ret': -2, 'msg': '抽奖次数不足'}) sql = 'SELECT * FROM h5_luckdraw_log WHERE unionid = %s \ AND position = %s AND create_time BETWEEN %s AND %s' luckdraw_postion = mysql.getOne( sql, param=[unionid, position, self.START_TIME, self.END_TIME]) if luckdraw_postion: mysql.dispose() return JsonResponse({'ret': -2, 'msg': '网络繁忙'}) sql = "UPDATE h5_user SET lucky_draw_times = \ lucky_draw_times - 1 WHERE unionid = %s" mysql.update(sql, param=[unionid]) patch_id = randomH5Patch() sql = "INSERT INTO h5_luckdraw_log SET unionid = %s, \ patch_id = %s, state = 0, position=%s" mysql.insertOne(sql, param=[unionid, patch_id, position]) mysql.dispose() return JsonResponse({ 'ret': 0, 'msg': '抽奖成功', 'result': { 'patch_id': patch_id, 'patch_name': STAR_SIGIN[patch_id] } }) except Exception as e: mysql.errdispose() erroLog(e) return JsonResponse({'ret': -2, 'msg': '网络错误'})
def update(self): mysql = Mysql() sql = "SELECT * FROM userInfo WHERE id = %s FOR UPDATE" mysql.getOne(sql, param=[self.info['user_id']]) sql = "update userInfo set wxname=%s, user_img=%s, \ unionId=%s where id = %s" mysql.update(sql, param=[ self.info['wxname'], self.info['img'], self.info['unionid'], self.info['user_id'] ]) mysql.dispose() return HttpResponse(returnJson(0, '更新用户信息成功'))
def post(self, request): del_id = request.POST.get('id') if int(del_id) == BOOK_ID: return HttpResponse(0) mysql = Mysql() sql = "SELECT id FROM product WHERE productTypeId = %s" info_one = mysql.getOne(sql, param=[del_id]) sql = "SELECT id FROM proclass WHERE parentId = %s" info_two = mysql.getOne(sql, param=[del_id]) if info_one or info_two: return HttpResponse(2) else: sql = "DELETE FROM proclass WHERE id = %s" suc = mysql.delete(sql, param=[del_id]) return HttpResponse(suc)
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 post(self, request, **payload): user_id = payload.get('user_id') hot_numbs = int(request.POST.get('hot_numbs')) mer_id = request.POST.get('mer_id') if hot_numbs > 5 or hot_numbs < 1: return HttpResponse(0) mysql = Mysql() sql = "SELECT id FROM mer_hots WHERE mer_id = %s AND user_id = %s" check = mysql.getOne(sql, param=[mer_id, user_id]) if check: mysql.dispose() return HttpResponse(2) sql = "INSERT INTO mer_hots SET mer_id = %s, user_id = %s, hots = %s" ins_suc = mysql.insertOne(sql, param=[mer_id, user_id, hot_numbs]) sql = "UPDATE merchant SET mer_hot = mer_hot + %s, \ mer_hot_numbs = mer_hot_numbs + 1 WHERE mer_id = %s" up_suc = mysql.update(sql, param=[hot_numbs, mer_id]) if up_suc and ins_suc: mysql.dispose() return HttpResponse(1) mysql.errdispose() return HttpResponse(0)
def addMerHot(self): self.params['hot_numbs'] = int(request.POST.get('hot_numbs')) if self.params['hot_numbs'] > 5 or self.params['hot_numbs'] < 1: return HttpResponse(returnJson(-2, '增加热度失败')) mysql = Mysql() sql = "SELECT id FROM mer_hots WHERE mer_id = %s AND user_id = %s" check = mysql.getOne( sql, param=[self.params['mer_id'], self.params['user_id']]) if check: mysql.dispose() return HttpResponse(returnJson(-2, '已增加过热度,不能重复')) sql = "INSERT INTO mer_hots SET mer_id = %s, user_id = %s, hots = %s" ins_suc = mysql.insertOne(sql, param=[ self.params['mer_id'], self.params['user_id'], self.params['hot_numbs'] ]) sql = "UPDATE merchant SET mer_hot = mer_hot + %s, \ mer_hot_numbs = mer_hot_numbs + 1 WHERE mer_id = %s" up_suc = mysql.update( sql, param=[self.params['hot_numbs'], self.params['mer_id']]) mysql.dispose() return HttpResponse(returnJson(0, '增加热度成功'))
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 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 post(self, request, **payload): user_id = payload.get('user_id') handle = payload.get('handle') address_id = request.POST.get('address_id') mysql = Mysql() if handle == 'edit': sql = "UPDATE userInfo SET address_id=%s WHERE id=%s" mysql.update(sql, param=[address_id, user_id]) mysql.dispose() return HttpResponse(returnJson(0, '更新成功')) if handle == 'get': mysql = Mysql() sql = "SELECT address_id from userInfo WHERE id=%s" info = mysql.getOne(sql, param=[user_id]) mysql.dispose() info = info if info else [] return HttpResponse(returnJson(0, '查询成功', info)) if handle == 'del': mysql = Mysql() sql = "UPDATE userInfo SET address_id = null WHERE id=%s" mysql.update(sql, param=[user_id]) mysql.dispose() return HttpResponse(returnJson(0, '删除成功')) if handle == 'default': pass else: return HttpResponse(returnJson(-2, '参数错误'))
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 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 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): try: unionid = request.GET.get('unionid') if not unionid: return JsonResponse({'ret': -2, 'msg': '缺少参数'}) mysql = Mysql() sql = 'SELECT * FROM h5_user WHERE unionid = %s' share_info = mysql.getOne(sql, param=[unionid]) if not share_info: mysql.dispose() return JsonResponse({'ret': -2, 'msg': '公众号信息未授权'}) # sql = 'SELECT id FROM userInfo WHERE unionId = %s' # user_id = mysql.getOne(sql, param=[unionid]) # if not user_id: # mysql.dispose() # return JsonResponse({ # 'ret' : -2, # 'msg' : '小程序信息未授权' # }) user_id = user_id.get('id') sql = 'SELECT one, two, three, four, five, six, seven, \ eight, nine, ten, eleven, twelve \ FROM user_star_sign WHERE user_id = %s' patch_info = mysql.getOne(sql, param=[user_id]) sql = "SELECT hu.nickname, hu.headimgurl \ FROM h5_help_log AS hl \ LEFT JOIN h5_user AS hu ON hl.help_unionid = hu.unionid \ WHERE leader_unionid = %s" helpuser_info = mysql.getAll(sql, param=[unionid]) mysql.dispose() data = { 'ret': 0, 'msg': '查询成功', 'resule': { 'patch_info': patch_info, 'help_user': helpuser_info, 'lucky_draw_times': share_info.get('lucky_draw_times') } } return JsonResponse(data) except Exception as e: erroLog(e) mysql.errdispose() return JsonResponse({'ret': -2, 'msg': '网络错误'})
def post(self, request): order_num = request.POST.get('order_num') mer_id = request.POST.get('mer_id') mysql = Mysql() sql = f"SELECT `get`, state FROM mer_orders WHERE \ order_num = '{order_num}' AND mer_id = '{mer_id}'" check_get = mysql.getOne(sql) data = {} if check_get: if int(check_get.get('get')) == 1: data['msg'] = "FAILE" data['info'] = "二维码已经被扫描使用" mysql.dispose() return HttpResponse(callJson(data)) if int(check_get.get('state')) != 1: data['msg'] = "FAILE" data['info'] = "二维码未付款" mysql.dispose() return HttpResponse(callJson(data)) if int(check_get.get('get')) == 0: sql = f'SELECT *, DATE_ADD(pay_time,INTERVAL 3 DAY) as c \ FROM mer_orders WHERE order_num="{order_num}"' info = mysql.getOne(sql) ex_time = info.get('c') now_time = datetime.datetime.now() if ex_time >= now_time: print('没过期') sql = f"UPDATE mer_orders SET `get` = 1 WHERE order_num = '{order_num}'" suc = mysql.update(sql) if suc: data['msg'] = "OK" data['info'] = "扫码成功" mysql.dispose() return HttpResponse(callJson(data)) if ex_time < now_time: print('过期了') data['msg'] = "FAILE" data['info'] = "二维码过期" return HttpResponse(callJson(data)) mysql.dispose() data['msg'] = "FAILE" data['info'] = "订单号错误" return HttpResponse(callJson(data))
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, **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, **payload): user_id = payload.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 mp.order_num, mp.order_money, mp.wx_money, mp.balance, \ mp.hhcoin, mp.state, mp.create_time, mr.mer_name FROM mer_pay \ AS mp LEFT JOIN merchant AS mr ON mp.mer_id = mr.mer_id WHERE \ mr.mer_id IS NOT NULL AND mp.user_id = {user_id} limit {page}, {row}" info = mysql.getAll(sql) if info: # 总页数 sql = f"SELECT ceil(COUNT(mp.id) / 5) AS sum_page \ FROM mer_pay AS mp WHERE mp.user_id = {user_id} " sum_page = mysql.getOne(sql) # 总金额 sql = f"SELECT sum(wx_money+balance+0.1*hhcoin) AS sum_money \ FROM mer_pay WHERE user_id = {user_id}" sum_money = mysql.getOne(sql) # 本月订单数 sql = f"SELECT COUNT(*) AS month_orders FROM mer_pay \ WHERE DATE_FORMAT( create_time, '%Y%m' ) = \ DATE_FORMAT( CURDATE( ) , '%Y%m' ) AND user_id = {user_id}" month_orders = mysql.getOne(sql) # 总订单数 sql = f"SELECT COUNT(id) AS sum_order FROM mer_pay WHERE user_id = {user_id}" sum_order = mysql.getOne(sql) # 本月金额 sql = f"SELECT SUM(wx_money+balance) AS month_money \ FROM mer_pay WHERE DATE_FORMAT( create_time, '%Y%m' ) \ = DATE_FORMAT( CURDATE( ) , '%Y%m' ) AND user_id = {user_id}" month_money = mysql.getOne(sql) data = {} data['sum_page'] = sum_page.get('sum_page') data['sum_money'] = sum_money.get('sum_money') data['month_orders'] = month_orders.get('month_orders') data['sum_order'] = sum_order.get('sum_order') data['month_money'] = month_money.get('month_money') data['info'] = info mysql.dispose() return HttpResponse(callJson(data)) mysql.dispose() 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): prize_id = request.GET.get('prize_id') mysql = Mysql() sql = "SELECT * FROM prize_phv WHERE prize_id='{prize_id}'".format(prize_id=prize_id) info = mysql.getOne(sql) mysql.dispose() if info: info = json.dumps(info, ensure_ascii=False, sort_keys=True, indent=4) return HttpResponse(info) return HttpResponse(0)
def post(self, request): try: bu_id = request.POST.get('bu_id') mysql = Mysql() sql = "SELECT * FROM bargain_user WHERE id = %s AND order_num IS NOT NULL" bu_info = mysql.getOne(sql, param=[bu_id]) if bu_info: order_num = bu_info.get('order_num') sql = "SELECT * FROM orders WHERE orderNum = %s AND state = 0" order_info = mysql.getOne(sql, param=[order_num]) if order_info: sql = "DELETE FROM orders WHERE orderNum = %s" mysql.delete(sql, param=[order_num]) sql = "UPDATE bargain_user SET state = 1, order_num = NULL WHERE id = %s" mysql.update(sql, param=[bu_id]) mysql.dispose() return HttpResponse(1) except Exception as e: print(e) return HttpResponse(0)
def get(self, request): prize_id = request.GET.get('prize_id') mysql = Mysql() sql = "SELECT stock.stock_name, stock.id, prize_stock.stock_numb FROM prize_stock \ LEFT JOIN stock ON prize_stock.stock_id = stock.id \ WHERE prize_stock.prize_id = '{prize_id}'".format(prize_id=prize_id) info = mysql.getOne(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): self.params = {} self.params['product_id'] = request.GET.get('product_id') mysql = Mysql() data = {} sql = "SELECT * FROM mer_product WHERE product_id \ = '{product_id}'".format(product_id=self.params['product_id']) product_info = mysql.getOne(sql) data['product_info'] = product_info #商品所对应的库存商品 sql = "SELECT * FROM mer_stock WHERE product_id = \ '{product_id}'".format(product_id=self.params['product_id']) stock_check = mysql.getOne(sql) stock = mysql.getAll(sql) data['stock'] = stock if stock_check.get('stock_specs'): #商品所拥有的规格以及 规格详情 sql = "SELECT * FROM mer_spec WHERE product_id \ = '{product_id}'".format(product_id=self.params['product_id']) spec_info = mysql.getAll(sql) list_a = [] for i in spec_info: spec_dict = {} sql = "SELECT spec_detail_id, detail_name FROM mer_specdetail WHERE spec_id = \ '{spec_id}'".format(spec_id=i.get('spec_id')) spec_detail_info = mysql.getAll(sql) spec_dict['spec_id'] = i.get('spec_id') spec_dict['spec_name'] = i.get('spec_name') #spec_dict['spec_detail'] = [x.get('detail_name') for x in spec_detail_info] spec_dict['spec_detail'] = [x for x in spec_detail_info] list_a.append(spec_dict) data['spec'] = list_a mysql.dispose() data = json.dumps(data, ensure_ascii=False, sort_keys=True, indent=4, cls=ComplexEncode) return HttpResponse(data)
def get(self, request): order_num = request.GET.get('order_num') mysql = Mysql() sql = f"SELECT * FROM as_orders WHERE order_id = '{order_num}'" info = mysql.getOne(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)