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
from web.controller.admin import route_admin
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)
