def merchant(): resq = {} if request.method == 'GET': resq = {} req = request.values query = Merchant_Info.query page = int(req['p']) if ('p' in req and req['p']) else 1 if 'mix_kw' in req: rule = or_( Merchant_Info.UserName.ilike("%{0}%".format(req['mix_kw'])), Merchant_Info.Phone.ilike("%{0}%".format(req['mix_kw']))) query = query.filter(rule) if 'status' in req and int(req['status']) > -1: query = query.filter(Merchant_Info.Status == int(req['status'])) count = query.count() page_params = { 'total': count, 'page_size': app.config['PAGE_SIZE'], 'page': page, 'display': app.config['PAGE_DISPLAY'], 'url': request.full_path.replace("&p={}".format(page), "") } pages = iPagination(page_params) offset = (page - 1) * app.config['PAGE_SIZE'] limit = app.config['PAGE_SIZE'] * page list = query.order_by(Merchant_Info.Id.desc()).all() resq['list'] = list resq['pages'] = pages resq['search_con'] = req resq['status_mapping'] = app.config['STATUS_MAPPING'] return ops_render("admin/index.html", resq)
def balance_list_admin(): resp = {'code': 200, 'msg': '查询成功'} req = request.values list = Balance_Log.query.order_by(Balance_Log.id.desc()).all() tmp_list = [] for item in list: merchant_info = Merchant_Info.query.filter_by( Id=item.merchant_id).first() tmp_data = { 'id': item.id, 'merchant_id': item.merchant_id, 'merchant_name': merchant_info.Name, 'createtime': item.createtime, 'updatetime': item.updatetime, 'status_Desc': item.Status_Desc, 'balance': str(item.balance), 'operating_Desc': str(item.Operating_Desc), 'status': str(item.status), 'operating': str(item.operating), 'total_balance': str(item.total_balance), 'receipt_qrcode': item.receipt_qrcode } tmp_list.append(tmp_data) resp['list'] = tmp_list return ops_render("admin/report.html", resp)
def update(): resp_data = {} if request.method == 'GET': req = request.args id = req.get('id') info = S_User_Info.query.filter_by(Id=id).first() resp_data['info'] = info return ops_render('admin/update.html', resp_data) req = request.values userPwd = req['userPwd'] if 'userPwd' in req else '' if userPwd == '': resp_data['msg'] = '密码不能为空' resp_data['code'] = -1 info = S_User_Info.query.filter_by(Id=g.current_user.Id).first() info.UserPwd = userPwd db.session.add(info) db.session.commit() resp_data['msg'] = '修改成功' resp_data['code'] = 200 response = make_response(json.dumps(resp_data)) response.set_cookie(app.config['AUTH_COOKIE_NAME'], "%s#%s" % (UserService.geneAuthCode(info), info.Id)) return response
def add(): resp_data = {} if request.method == 'GET': return ops_render('admin/add.html') req = request.values userPwd = req['userPwd'] if 'userPwd' in req else '' userName = req['userName'] if 'userPwd' in req else '' if userName == '': resp_data['msg'] = '用户名不能为空' resp_data['code'] = -1 return jsonify(resp_data) if userPwd == '': resp_data['msg'] = '密码不能为空' resp_data['code'] = -1 return jsonify(resp_data) info = S_User_Info.query.filter_by(UserName=userName).first() if info: resp_data['msg'] = '用户已存在' resp_data['code'] = -1 return jsonify(resp_data) info = S_User_Info() info.UserPwd = userPwd info.UserName = userName info.UserRole = 1 db.session.add(info) db.session.commit() resp_data['msg'] = '添加成功' resp_data['code'] = 200 return jsonify(resp_data)
def commodity_info(): resq = {} id = request.args.get('id') if request.method == 'GET': resq['info'] = Shop_Info.query.filter_by(Id=id).first() resq['merchants'] = Merchant_Info.query.order_by( Merchant_Info.Id.desc()).all() return ops_render('shop/info.html', resq)
def index(): resp = {} req = request.values code = req['code'] if 'code' in req else '' state = req['state'] if 'state' in req else '' resp['info'] = Profession.query.order_by(Profession.pid.desc()).first() url = 'https://api.weixin.qq.com/sns/oauth2/access_token?appid={0}&secret={1}&code={2}&grant_type=authorization_code'.format( 'wx6950865320663956', '336da1d2a1f11447b057311f24655413', code) r = requests.get(url) value = json.loads(r.text) resp['openId'] = value['openid'] if 'openid' in value else '' resp['share'] = wechat.getShareData() return ops_render('index.html', resp)
def index_next(): resp = {} req = request.values id = req['id'] if 'id' in req else 0 openId = req['openId'] if 'openId' in req else 0 resp['profession'] = Profession.query.order_by(Profession.pid.desc()).first() info = Department.query.filter_by(did=id).first() list = Department.query.filter_by(fid=id).all() resp['list'] = list resp['info'] = info resp['openId'] = openId resp['share'] = wechat.getShareData() return ops_render('index_next.html', resp)
def index(): resp_data = { 'data': { 'finance': { 'today': 0, 'month': 0 }, 'member': { 'today_new': 0, 'month_new': 0, 'total': 0 }, 'order': { 'today': 0, 'month': 0 }, 'shared': { 'today': 0, 'month': 0 }, } } now = datetime.datetime.now() date_before_30days = now + datetime.timedelta(days=-30) date_from = getFormatDate(date=date_before_30days, format="%Y-%m-%d") date_to = getFormatDate(date=now, format="%Y-%m-%d") list = StatDailySite.query.filter(StatDailySite.date >= date_from) \ .filter(StatDailySite.date <= date_to).order_by(StatDailySite.id.asc()) \ .all() data = resp_data['data'] if list: for item in list: data['finance']['month'] += item.total_pay_money data['member']['month_new'] += item.total_new_member_count data['member']['total'] = item.total_member_count data['order']['month'] += item.total_order_count data['shared']['month'] += item.total_shared_count if getFormatDate(date=item.date, format="%Y-%m-%d") == date_to: data['finance']['today'] = item.total_pay_money data['member']['today_new'] = item.total_new_member_count data['order']['today'] = item.total_order_count data['shared']['today'] = item.total_shared_count return ops_render("index.html", resp_data)
def admin(): resp = {'code': 200, 'msg': '登录成功'} if request.method == 'GET': return ops_render('/admin/index.html') req = request.values name = req['name'] if 'name' in req else '' pwd = req['pwd'] if 'pwd' in req else '' admin = Admin.query.filter_by(username=name).first() admin = Admin.query.filter_by(password=pwd).first() resp['id'] = admin.id if admin: return jsonify(resp) resp['code'] = -1 resp['msg'] = '用户名或密码错误' return jsonify(resp)
def login(): if request.method == "GET": if g.current_user: return redirect(UrlManager.buildUrl("/index")) return ops_render('login.html') result = {'code': 200, 'msg': '登录成功'} value = request.values login_name = value['login_name'] if 'login_name' in value else '' login_pwd = value['login_pwd'] if 'login_pwd' in value else '' if login_name is None or len(login_name) < 1: result['code'] = -1 result['msg'] = 'error' return jsonify(result) if login_pwd is None or len(login_pwd) < 1: result['code'] = -1 result['msg'] = 'error' return jsonify(result) user_info = S_User_Info.query.filter_by(UserName=login_name).first() if not user_info: result['code'] = -1 result['msg'] = '账号错误' return jsonify(result) if user_info.UserPwd != login_pwd: result['code'] = -1 result['msg'] = '密码错误' return jsonify(result) response = make_response(json.dumps(result)) response.set_cookie( app.config['AUTH_COOKIE_NAME'], "%s#%s" % (UserService.geneAuthCode(user_info), user_info.Id)) return response
def user(): return ops_render('admin/user.html')
def commodity(): resq = {} if request.method == 'GET': list = Shop_Info.query.order_by(Shop_Info.Id.desc()).all() resq['list'] = list return ops_render('admin/commodity.html', resq)
from web.controller.admin import route_admin
def form_name(): resp = {} resp['share'] = wechat.getShareData() req = request.values id = req['id'] if 'id' in req else -1 openId = req['openId'] if 'openId' in req else 0 pro = Profession.query.order_by(Profession.pid.desc()).first() if request.method == 'GET': info = Department.query.filter_by(did=id).first() resp['profession'] = pro resp['info'] = info resp['openId'] = openId resp['data'] = { 'id': req['id'] if 'id' in req else -1, 'f2': req['f2'] if 'f2' in req else -1, 'f3': req['f3'] if 'f3' in req else -1, 'f4': req['f4'] if 'f4' in req else -1, 'f0': req['f0'] if 'f0' in req else -1 } return ops_render('form_name.html', resp) f1 = req['f1'] if 'f1' in req else -1 f2 = req['f2'] if 'f2' in req else -1 f3 = req['f3'] if 'f3' in req else -1 f4 = req['f4'] if 'f4' in req else -1 f0 = req['f0'] if 'f0' in req else -1 openId = req['openIds'] if 'openIds' in req else -1 sid = pro.pid name = req['x_name'] if 'x_name' in req else -1 hei = BaoMing.query.filter_by(sid=sid).filter_by(openid=openId).first() if hei: return redirect(pro.url) b_info = BaoMing() b_info.sid = sid b_info.name = name b_info.f0 = f0 b_info.f1 = f1 b_info.f2 = f2 b_info.f3 = f3 b_info.f4 = f4 b_info.openid = openId db.session.add(b_info) db.session.commit() info = Department.query.filter_by(did=f0).first() info.num += 1 db.session.add(info) db.session.commit() info = Department.query.filter_by(did=f1).first() if info: info.num += 1 db.session.add(info) db.session.commit() info = Department.query.filter_by(did=f2).first() if info: info.num += 1 db.session.add(info) db.session.commit() info = Department.query.filter_by(did=f3).first() if info: info.num += 1 db.session.add(info) db.session.commit() info = Department.query.filter_by(did=f4).first() if info: info.num += 1 db.session.add(info) db.session.commit() return redirect(pro.url)
def report(): return ops_render('admin/report.html')
def user(): resp = {} if request.method == 'GET': list = Member.query.order_by(Member.Id.desc()).all() resp['list'] = list return ops_render('admin/user.html', resp)