def index():
'''
首页 - 支出预览
:return:
'''
if session.get('username') == 'changhao' and session.get(
'password') == 'changhao':
if not len(getfile()) >= 1:
return redirect(url_for('upload'))
db = querydb.DBAPI()
# 总支出金额
zcyl_zzc = db.queryForeEnd('zcyl_zzc')
# 总收入金额
zcyl_zsr = db.queryForeEnd('zcyl_zsr')
# 单笔最高支出
zcyl_dbzgzc = db.queryForeEnd('zcyl_dbzgzc')
# 单笔最高收入
zcyl_dbzgsr = db.queryForeEnd('zcyl_dbzgsr')
# 单笔最高支出百分比
zcyl_dbzgzcbfb = db.queryForeEnd('zcyl_dbzgzcbfb')
# 单笔最高收入百分比
zcyl_dbzgsrbfb = db.queryForeEnd('zcyl_dbzgsrbfb')
# 消费活跃区域 TOP10
xfcity = db.queryFootmark('footmark_10top')
# TOP10 消费清单
zcyl_xftop10 = db.queryForeEnd('zcyl_xftop10')
return render_template('index.html',
zcyl_zzc=round(zcyl_zzc, 2),
zcyl_zsr=round(zcyl_zsr, 2),
zcyl_dbzgsr=zcyl_dbzgsr,
zcyl_dbzgzc=zcyl_dbzgzc,
zcyl_dbzgzcbfb=zcyl_dbzgzcbfb,
zcyl_dbzgsrbfb=zcyl_dbzgsrbfb,
xfcity=xfcity,
zcyl_xftop10=zcyl_xftop10)
return redirect(url_for('login'))
def complete():
'''
支出明细
:return:
'''
if session.get('username') == 'changhao' and session.get(
'password') == 'changhao':
db = querydb.DBAPI()
# 支出明细页面
data = db.queryForeEnd('zcmx')
# 支出明细 共多少条记录
zcmx_jl = db.queryForeEnd('zcmx_jl')
# 分页查询
li = []
for i in range(1, zcmx_jl[0] + 1):
li.append(i)
pager_obj = Pagination(request.args.get("page", 1),
len(li),
request.path,
request.args,
per_page_count=50)
print(request.path)
print(request.args)
index_list = li[pager_obj.start:pager_obj.end]
html = pager_obj.page_html()
return render_template('table_complete.html',
data=data,
zcmx_jl=zcmx_jl,
html=html,
index_list=index_list)
return redirect(url_for('login'))
def indexjs():
'''
首页 Chart 图表后台数据更改
:return:
'''
db = querydb.DBAPI()
# 消费分类
# 美食
zcyl_ms = db.queryForeEnd('zcyl_ms')
# 交通
zcyl_jt = db.queryForeEnd('zcyl_jt')
# 娱乐
zcyl_yl = db.queryForeEnd('zcyl_yl')
# 生活
zcyl_sh = db.queryForeEnd('zcyl_sh')
# 电子产品
zcyl_dzcp = db.queryForeEnd('zcyl_dzcp')
# 近一周消费
# 日期
zcyl_rq = db.queryForeEnd('zcyl_rq')
# 金额
zcyl_je = db.queryForeEnd('zcyl_je')
# 两周高低消费对比
zcyl_lzgdxf = db.queryForeEnd('zcyl_zxf')
# 指定原始 indexChart.js 文件md5值
if get_file_md5('indexChart.js', 'old') == get_file_md5('indexChart.js', 'new'):
# 消费分类 Chart
with open(BASE_DIR + 'indexChart.js', 'r', encoding='utf-8') as f:
a = f.readlines()
newfile = []
for line in a:
if re.search("{value:100, name:'美食'},", line):
a = line.replace("{value:100, name:'美食'},", "{value:%d, name:'美食'}," % zcyl_ms[0])
newfile.append(a)
elif re.search("{value:10, name:'交通'},", line):
a = line.replace("{value:10, name:'交通'},", "{value:%d, name:'交通'}," % zcyl_jt[0])
newfile.append(a)
elif re.search("{value:234, name:'娱乐'},", line):
a = line.replace("{value:234, name:'娱乐'},", "{value:%d, name:'娱乐'}," % zcyl_yl[0])
newfile.append(a)
elif re.search("{value:135, name:'生活'},", line):
a = line.replace("{value:135, name:'生活'},", "{value:%d, name:'生活'}," % zcyl_sh[0])
newfile.append(a)
elif re.search("{value:0, name:'电子产品'}", line):
a = line.replace("{value:0, name:'电子产品'}", "{value:%d, name:'电子产品'}" % zcyl_dzcp[0])
newfile.append(a)
else:
newfile.append(line)
# 近一周消费 Chart
jyzxf = []
for i in newfile:
if re.search("'10', '20', '30', '40', '50', '60', '70'", i):
newfile = i.replace("data : ['10', '20', '30', '40', '50', '60', '70'],", "data : ['%s', '%s', '%s', '%s', '%s', '%s', '%s']," % (zcyl_rq[0], zcyl_rq[1], zcyl_rq[2],
zcyl_rq[3], zcyl_rq[4], zcyl_rq[5], zcyl_rq[6]))
jyzxf.append(newfile)
elif re.search("10, 52, 200, 334, 390, 330, 220", i):
newfile = i.replace("data:[10, 52, 200, 334, 390, 330, 220]", "data:[%d, %d, %d, %d, %d, %d, %d]" % (zcyl_je[0], zcyl_je[1], zcyl_je[2],
zcyl_je[3], zcyl_je[4], zcyl_je[5], zcyl_je[6]))
jyzxf.append(newfile)
else:
jyzxf.append(i)
# 两周高低消费对比 Chart
lzgdxf = []
for i in jyzxf:
if re.search("11, 11, 15, 13, 12, 13, 10", i):
jyzxf = i.replace("data:[11, 11, 15, 13, 12, 13, 10],", "data:[%d, %d, %d, %d, %d, %d, %d]," % (zcyl_lzgdxf[0][0], zcyl_lzgdxf[0][1],
zcyl_lzgdxf[0][2], zcyl_lzgdxf[0][3],
zcyl_lzgdxf[0][4], zcyl_lzgdxf[0][5],
zcyl_lzgdxf[0][6]))
lzgdxf.append(jyzxf)
elif re.search("1, 2, 2, 5, 3, 2, 0", i):
jyzxf = i.replace("data:[1, 2, 2, 5, 3, 2, 0],", "data:[%d, %d, %d, %d, %d, %d, %d]," % (zcyl_lzgdxf[1][0], zcyl_lzgdxf[1][1],
zcyl_lzgdxf[1][2], zcyl_lzgdxf[1][3],
zcyl_lzgdxf[1][4], zcyl_lzgdxf[1][5],
zcyl_lzgdxf[1][6]))
lzgdxf.append(jyzxf)
else:
lzgdxf.append(i)
f.close()
with open(BASE_DIR + 'indexChart1.js', 'w+', encoding='utf-8') as new:
for i in lzgdxf:
new.write(i)
new.close()
changeIndexFileName('indexChart.js', 'indexChart1.js')
else:
print('MD5值不正确!!')
def wxbillmd():
'''
微信账单页面
:return:
'''
db = querydb.DBAPI()
# 外卖订单次数
waimai_num = db.queryLife('waimai_num')
# 吃垃圾食品的次数
ljsp_num = db.queryLife('ljsp_num')
# 共计吃饭消费
wxzd_cfxf = db.queryBill('wxzd_cfxf')
# 最爱吃的东西
like_thing = db.queryForecast('like_thing')
# 交通出行消费
wxzd_jtxf = db.queryBill('wxzd_jtxf')
# 预测生日
wxzd_ycsr = db.queryBill('wxzd_ycsr')
# 早上时间段消费多少笔06:00~09:30
morn_xf_num = db.queryCONSUME('morn_xf_num')
# 中午时间段消费多少笔11:00~13:30
noon_xf_num = db.queryCONSUME('noon_xf_num')
# 晚上时间段消费多少笔18:00~24:00
night_xf_num = db.queryCONSUME('night_xf_num')
# 计天,消费次,均消费,均每消费 (wxzd_tcxx)
wxzd_tcxx = db.queryBill('wxzd_tcxx')
# 最晚的一次消费
zwxf = db.queryCONSUME('zwxf')
# 其中几天没有消费
daywxf = db.queryCONSUME('daywxf')
# 最高消费的一天
wxzd_zgxf = db.queryBill('wxzd_zgxf')
# 扫二维码付款, 商户消费
wxzd_ewmsh = db.queryBill('wxzd_ewmsh')
# 账单至少消费多少钱
wxzd_zdxf = db.queryBill('wxzd_zdxf')
# 账单时间格式
wxzd_zdsjgs = db.queryBill('wxzd_zdsjgs')
# 微信账单 称号 随机数
wxzd_chsjs = db.queryBill('wxzd_chsjs')
# 合计 支出金额 收入金额 总计流水
wxzd_zcsrzj = db.queryBill('wxzd_zcsrzj')
# 会员等级
wxzd_hydj = db.queryBill('wxzd_hydj')
# 获取当前时间
wxzd_time = db.queryBill('wxzd_time')
# 微信账单 访问第几位用户 流水帐号
wxzd_fwls = db.queryBill('wxzd_fwls')
# 微信账单 微信名称
wxzd_wxnc = db.queryBill('wxzd_wxnc')
# 指定原始 indexChart.js 文件md5值
if get_file_md5('wechatBill.md', 'old') == get_file_md5('wechatBill.md', 'new'):
with open(BASE_DIR + 'wechatBill.md', 'r', encoding='utf-8') as f:
a = f.readlines()
# 微信账单
wxzd1List = []
for wxzd1 in a:
# 本月外卖订单次数
if re.search("本月外卖订单次数高达", wxzd1):
a = wxzd1.replace("本月外卖订单次数高达<font color=red >50 次</font>",
"本月外卖订单次数高达<font color=red >%s 次</font>" % str(waimai_num[0]))
wxzd1List.append(a)
# 吃垃圾食品的次数
elif re.search("年轻人你竟然吃了垃圾食品", wxzd1):
a = wxzd1.replace("年轻人你竟然吃了垃圾食品<font color=red >20 次</font>",
"年轻人你竟然吃了垃圾食品<font color=red >%s 次</font>" % str(ljsp_num[0][0]))
wxzd1List.append(a)
# 共计吃饭消费
elif re.search("民以食为天,共计吃饭消费", wxzd1):
a = wxzd1.replace("民以食为天,共计吃饭消费<font color=red >5000元</font>",
"民以食为天,共计吃饭消费<font color=red >%s元</font>" % str(round(wxzd_cfxf[0], 2)))
wxzd1List.append(a)
# 最爱吃的东西
elif re.search("天呐，没想到！你竟然最爱吃的是这个", wxzd1):
a = wxzd1.replace("天呐，没想到！你竟然最爱吃的是这个：<font color=red >番茄炒鸡蛋</font>",
"天呐，没想到！你竟然最爱吃的是这个：<font color=red >%s</font>" % str(like_thing[0]))
wxzd1List.append(a)
# 最爱吃的东西
elif re.search("感谢您为雾霾天做出的贡献，交通出行消费", wxzd1):
a = wxzd1.replace("感谢您为雾霾天做出的贡献，交通出行消费<font color=red >500元</font> 历史将会铭记你！",
"感谢您为雾霾天做出的贡献，交通出行消费<font color=red >%s元</font> 历史将会铭记你！" %
str(wxzd_jtxf[0]))
wxzd1List.append(a)
# 预测生日
elif re.search("小bill 预测这一天", wxzd1):
if len(wxzd_ycsr) == 0:
a = wxzd1.replace("小bill 预测这一天<font color=red > 2019-01-01 </font>是你生日，祝你生日快乐!",
"小Bill 没有预测到您的生日是哪天，在此感到非常的抱歉！")
wxzd1List.append(a)
else:
a = wxzd1.replace("小bill 预测这一天<font color=red > 2019-01-01 </font>是你生日，祝你生日快乐!",
"小bill 预测这一天<font color=red > %s </font>是你生日，祝你生日快乐!" %
str(wxzd_ycsr[0]))
wxzd1List.append(a)
# 早上时间段消费多少笔06:00~09:30
elif re.search("一天之季在于晨，早上时间段消费了", wxzd1):
a = wxzd1.replace("一天之季在于晨，早上时间段消费了<font color=red > 50 </font>笔",
"一天之季在于晨，早上时间段消费了<font color=red > %s </font>笔" % str(morn_xf_num[0]))
wxzd1List.append(a)
# 中午时间段消费多少笔11:00~13:30
elif re.search("被称为国家GDP增长率三驾马车之一的消费，中午时间段消费", wxzd1):
a = wxzd1.replace("被称为国家GDP增长率三驾马车之一的消费，中午时间段消费<font color=red >5000</font>笔",
"被称为国家GDP增长率三驾马车之一的消费，中午时间段消费<font color=red >%s</font>笔" %
str(noon_xf_num[0]))
wxzd1List.append(a)
# 晚上时间段消费多少笔18:00~24:00
elif re.search("晚上时间段消费", wxzd1):
a = wxzd1.replace("晚上时间段消费<font color=red >500</font>笔",
"晚上时间段消费<font color=red >%s</font>笔" % str(night_xf_num[0]))
wxzd1List.append(a)
# 共计200天, 共消费600次, 平均每天至少消费7次, 平均每次消费20元
elif re.search("次,平均每天至少消费", wxzd1):
a = wxzd1.replace("共计<font color=red >200</font>天,共消费<font color=red >600</font>次,平均每天至少消费"
"<font color=red >7</font>次,平均每次消费<font color=red >20</font>元",
"共计<font color=red >%s</font>天,共消费<font color=red >%s</font>次,平均每天至少消费"
"<font color=red >%s</font>次,平均每次消费<font color=red >%s</font>元" %
(str(wxzd_tcxx[0][0]), str(wxzd_tcxx[0][1]), str(wxzd_tcxx[0][2]), str(wxzd_tcxx[0][3])))
wxzd1List.append(a)
# 消费最晚的一次
elif re.search("年轻人不要常熬夜啦，消费最晚的一次", wxzd1):
a = wxzd1.replace("年轻人不要常熬夜啦，消费最晚的一次<font color=red > 2019-01-09 02:22 </font>有魄力!!",
"年轻人不要常熬夜啦，消费最晚的一次<font color=red > %s </font>有魄力!!" %
str(zwxf[0]))
wxzd1List.append(a)
# 其中几天没有消费
elif re.search("起止日期2019-01-01 至 2019-03-29 其中", wxzd1):
if daywxf[2] == 0:
a = wxzd1.replace("起止日期2019-01-01 至 2019-03-29 其中<font color=red > 7 </font>天没有消费",
"起止日期%s 至 %s 你居然在这段时间内<font color=red > 消费满勤 </font>!!" %
(str(daywxf[0]), str(daywxf[1])))
wxzd1List.append(a)
else:
a = wxzd1.replace("起止日期2019-01-01 至 2019-03-29 其中<font color=red > 7 </font>天没有消费",
"起止日期%s 至 %s 其中<font color=red > %s </font>天没有消费" %
(str(daywxf[0]), str(daywxf[1]), str(daywxf[2])))
wxzd1List.append(a)
# 最高消费的一天
elif re.search("这一天对你非常重要吧!消费已经爆表了,想想自己干了什么", wxzd1):
a = wxzd1.replace("<font color=red >2019-01-29</font>这一天对你非常重要吧!消费已经爆表了,想想自己干了什么",
"<font color=red >%s</font>这一天对你非常重要吧!消费已经爆表了,想想自己干了什么" %
wxzd_zgxf[0])
wxzd1List.append(a)
# 扫二维码付款, 商户消费
elif re.search("通过扫二维码付款消费", wxzd1):
a = wxzd1.replace("通过扫二维码付款消费<font color=red > 10000 </font>元，通过商户消费 <font color=red > 美食 </font>元",
"通过扫二维码付款消费<font color=red > %s </font>元，通过商户消费 <font color=red > %s </font>元" %
(str(round(wxzd_ewmsh[0][0], 2)), str(round(wxzd_ewmsh[0][1], 2))))
wxzd1List.append(a)
# 账单至少消费多少钱
elif re.search("总计您本次账单至少消费", wxzd1):
a = wxzd1.replace("总计您本次账单至少消费<font color=red > 100000 </font>元，且行且珍惜",
"总计您本次账单至少消费<font color=red > %s </font>元，且行且珍惜" % str(wxzd_zdxf[0]))
wxzd1List.append(a)
# 账单时间格式
elif re.search("截止2019/01/01 - 2019/03/26", wxzd1):
a = wxzd1.replace("截止2019/01/01 - 2019/03/26",
"截止%s - %s" % (str(wxzd_zdsjgs[0]), str(wxzd_zdsjgs[1])))
wxzd1List.append(a)
# 微信账单 称号 随机数
elif re.search("称号：消费不理智", wxzd1):
a = wxzd1.replace("**称号：消费不理智**",
"**称号：%s**" % str(wxzd_chsjs))
wxzd1List.append(a)
# 合计
# 支出金额 总计流水
elif re.search("支出金额：999,999,99", wxzd1):
a = wxzd1.replace("支出金额：999,999,99",
"支出金额：<font color=red > %s </font>￥" % str(wxzd_zcsrzj[0][0]))
wxzd1List.append(a)
# 收入金额
elif re.search("收入金额：1000,000,000", wxzd1):
a = wxzd1.replace("收入金额：1000,000,000",
"收入金额：<font color=red > %s </font>￥" % str(wxzd_zcsrzj[0][1]))
wxzd1List.append(a)
# 收入金额
elif re.search("总计流水：666666666", wxzd1):
a = wxzd1.replace("总计流水：666666666￥",
"总计流水：<font color=red > %s </font>￥" % str(wxzd_zcsrzj[0][2]))
wxzd1List.append(a)
# 会员等级
elif re.search("会员等级：VIP客户", wxzd1):
a = wxzd1.replace("会员等级：VIP客户",
"会员等级：<font color=red > %s </font>" % str(wxzd_hydj[0]))
wxzd1List.append(a)
# 获取当前时间 wxzd_time
elif re.search("2019/03/26 11:16", wxzd1):
a = wxzd1.replace("2019/03/26 11:16",
"%s" % str(wxzd_time))
wxzd1List.append(a)
# 微信账单
# 流水帐号
elif re.search("流水号：1000000000000000000", wxzd1):
a = wxzd1.replace("流水号：1000000000000000000",
"流水号：%s" % str(wxzd_fwls[1]))
wxzd1List.append(a)
# 访问第几位用户
elif re.search("欢迎光临，第 1 位顾客", wxzd1):
a = wxzd1.replace("欢迎光临，第 1 位顾客",
"欢迎光临，第 %s 位顾客" % str(wxzd_fwls[0]))
wxzd1List.append(a)
# 访问第几位用户
elif re.search("位客户，烦请微信转发宣传，", wxzd1):
a = wxzd1.replace("您是本店第<font color=red > 1 </font>位客户，烦请微信转发宣传，小Bill感激不尽!!!",
"您是本店第<font color=red > %s </font>位客户，烦请微信转发宣传，小Bill感激不尽!!!" % str(wxzd_fwls[0]))
wxzd1List.append(a)
# 微信账单 微信名称
elif re.search("微信名称：随便", wxzd1):
a = wxzd1.replace("微信名称：随便",
"微信名称：%s" % str(wxzd_wxnc[0]))
wxzd1List.append(a)
else:
wxzd1List.append(wxzd1)
f.close()
with open(BASE_DIR + 'wechatBill1.md', 'w+', encoding='utf-8') as new:
for i in wxzd1List:
new.write(i)
new.close()
changeIndexFileName('wechatBill.md', 'wechatBill1.md')
else:
print('MD5值不正确!!')
def piejs():
'''
消费分布 Charts
:return:
'''
db = querydb.DBAPI()
# 经常消费商铺
xffb_jcxfsp = db.queryForeEnd('xffb_jcxfsp')
# 日常生活
# 滴滴 地铁 外卖 医院 垃圾食品 飞机 酒店 购物 美食 其他
xffb_rcsh = db.queryForeEnd('xffb_rcsh')
# 消费分布
# 消费区域
xffb_xfqy = db.queryForeEnd('xffb_xfqy')
# 钱都去了哪里
xffb_qdqlnl = db.queryForeEnd('xffb_qdqlnl')
# 指定原始 indexChart.js 文件md5值
if get_file_md5('pieChart.js', 'old') == get_file_md5('pieChart.js', 'new'):
# 经常消费商铺
jcxfspList = []
with open(BASE_DIR + 'pieChart.js', 'r', encoding='utf-8') as f:
a = f.readlines()
for jcxfsp in a:
# 商铺名称
if re.search("'田老师红烧肉','麦当劳','肯德基','庆丰包子铺','和合谷'", jcxfsp):
a = jcxfsp.replace("data:['田老师红烧肉','麦当劳','肯德基','庆丰包子铺','和合谷']",
"data:['%s', '%s', '%s', '%s', '%s']" % (xffb_jcxfsp[0][1], xffb_jcxfsp[1][1],
xffb_jcxfsp[2][1], xffb_jcxfsp[3][1],
xffb_jcxfsp[4][1]))
jcxfspList.append(a)
elif re.search("value:335, name:'田老师红烧肉'", jcxfsp):
a = jcxfsp.replace("{value:335, name:'田老师红烧肉'},", "{value:%d, name:'%s'}," % (xffb_jcxfsp[0][0], xffb_jcxfsp[0][1]))
jcxfspList.append(a)
elif re.search("value:310, name:'麦当劳'", jcxfsp):
a = jcxfsp.replace("{value:310, name:'麦当劳'},", "{value:%d, name:'%s'}," % (xffb_jcxfsp[1][0], xffb_jcxfsp[1][1]))
jcxfspList.append(a)
elif re.search("value:234, name:'肯德基'", jcxfsp):
a = jcxfsp.replace("{value:234, name:'肯德基'},", "{value:%d, name:'%s'}," % (xffb_jcxfsp[2][0], xffb_jcxfsp[2][1]))
jcxfspList.append(a)
elif re.search("value:135, name:'庆丰包子铺'", jcxfsp):
a = jcxfsp.replace("{value:135, name:'庆丰包子铺'},", "{value:%d, name:'%s'}," % (xffb_jcxfsp[3][0], xffb_jcxfsp[3][1]))
jcxfspList.append(a)
elif re.search("value:1548, name:'和合谷'", jcxfsp):
a = jcxfsp.replace("{value:1548, name:'和合谷'}", "{value:%d, name:'%s'}" % (xffb_jcxfsp[4][0], xffb_jcxfsp[4][1]))
jcxfspList.append(a)
else:
jcxfspList.append(jcxfsp)
# 日常生活
rcshList = []
for rcsh in jcxfspList:
# 滴滴 地铁 外卖 医院 垃圾食品 飞机 酒店 购物 美食 其他
# [4, 10, 10, 0, 4, 3, 1, 4, 9, 71]
if re.search("value:335, name:'美食'", rcsh):
a = rcsh.replace("{value:335, name:'美食', selected:true},",
"{value:%d, name:'美食', selected:true}," % xffb_rcsh[8])
rcshList.append(a)
elif re.search("value:679, name:'垃圾食品'", rcsh):
a = rcsh.replace("{value:679, name:'垃圾食品'},",
"{value:%d, name:'垃圾食品'}," % xffb_rcsh[4])
rcshList.append(a)
elif re.search("value:1548, name:'外卖订单'", rcsh):
a = rcsh.replace("{value:1548, name:'外卖订单'}",
"{value:%d, name:'外卖订单'}" % xffb_rcsh[2])
rcshList.append(a)
elif re.search("value:335, name:'滴滴打车'", rcsh):
a = rcsh.replace("{value:335, name:'滴滴打车'},",
"{value:%d, name:'滴滴打车'}," % xffb_rcsh[0])
rcshList.append(a)
elif re.search("value:310, name:'乘坐地铁'", rcsh):
a = rcsh.replace("{value:310, name:'乘坐地铁'},",
"{value:%d, name:'乘坐地铁'}," % xffb_rcsh[1])
rcshList.append(a)
elif re.search("value:234, name:'购物'", rcsh):
a = rcsh.replace("{value:234, name:'购物'},",
"{value:%d, name:'购物'}," % xffb_rcsh[7])
rcshList.append(a)
elif re.search("value:135, name:'医院看病'", rcsh):
a = rcsh.replace("{value:135, name:'医院看病'},",
"{value:%d, name:'医院看病'}," % xffb_rcsh[3])
rcshList.append(a)
elif re.search("value:1048, name:'其他'", rcsh):
a = rcsh.replace("{value:1048, name:'其他'},",
"{value:%d, name:'其他'}," % xffb_rcsh[9])
rcshList.append(a)
elif re.search("value:251, name:'飞机出行'", rcsh):
a = rcsh.replace("{value:251, name:'飞机出行'},",
"{value:%d, name:'飞机出行'}," % xffb_rcsh[5])
rcshList.append(a)
elif re.search("value:147, name:'酒店'", rcsh):
a = rcsh.replace("{value:147, name:'酒店'}",
"{value:%d, name:'酒店'}" % xffb_rcsh[6])
rcshList.append(a)
else:
rcshList.append(rcsh)
# 消费分布
# 消费区域
# [[6, '北京'], [4, '阜阳'], [1, '恩平'], [0, ''], [0, '']]
xfqyList = []
for xfqy in rcshList:
if re.search("'北京','上海','深圳','广州','成都'", xfqy):
a = xfqy.replace("data: ['北京','上海','深圳','广州','成都']",
"data: ['%s','%s','%s','%s','%s']" % (xffb_xfqy[0][1], xffb_xfqy[1][1],
xffb_xfqy[2][1], xffb_xfqy[3][1], xffb_xfqy[4][1]))
xfqyList.append(a)
elif re.search("value:335, name:'北京'", xfqy):
a = xfqy.replace("{value:335, name:'北京'},",
"{value:%d, name:'%s'}," % (xffb_xfqy[0][0], xffb_xfqy[0][1]))
xfqyList.append(a)
elif re.search("value:310, name:'上海'", xfqy):
a = xfqy.replace("{value:310, name:'上海'},",
"{value:%d, name:'%s'}," % (xffb_xfqy[1][0], xffb_xfqy[1][1]))
xfqyList.append(a)
elif re.search("value:234, name:'深圳'", xfqy):
a = xfqy.replace("{value:234, name:'深圳'},",
"{value:%d, name:'%s'}," % (xffb_xfqy[2][0], xffb_xfqy[2][1]))
xfqyList.append(a)
elif re.search("value:135, name:'广州'", xfqy):
a = xfqy.replace("{value:135, name:'广州'},",
"{value:%d, name:'%s'}," % (xffb_xfqy[3][0], xffb_xfqy[3][1]))
xfqyList.append(a)
elif re.search("value:1548, name:'成都'", xfqy):
a = xfqy.replace("{value:1548, name:'成都'}",
"{value:%d, name:'%s'}" % (xffb_xfqy[4][0], xffb_xfqy[4][1]))
xfqyList.append(a)
else:
xfqyList.append(xfqy)
# 消费分布
# 钱都去了哪里
qdqlnlList = []
for qdqlnl in xfqyList:
if re.search("'rose','rose2','rose3','rose4','rose5','rose6','rose7','rose8'", qdqlnl):
a = qdqlnl.replace("data:['rose','rose2','rose3','rose4','rose5','rose6','rose7','rose8']",
"data:['%s','%s','%s','%s','%s','%s','%s','%s']" % (xffb_qdqlnl[0][0], xffb_qdqlnl[1][0],
xffb_qdqlnl[2][0], xffb_qdqlnl[3][0],
xffb_qdqlnl[4][0], xffb_qdqlnl[5][0],
xffb_qdqlnl[6][0], xffb_qdqlnl[7][0]))
qdqlnlList.append(a)
elif re.search("value:10, name:'rose'", qdqlnl):
a = qdqlnl.replace("{value:10, name:'rose'},",
"{value:%d, name:'%s'}," % (xffb_qdqlnl[0][1], xffb_qdqlnl[0][0]))
qdqlnlList.append(a)
elif re.search("value:5, name:'rose2'", qdqlnl):
a = qdqlnl.replace("{value:5, name:'rose2'},",
"{value:%d, name:'%s'}," % (xffb_qdqlnl[1][1], xffb_qdqlnl[1][0]))
qdqlnlList.append(a)
elif re.search("value:15, name:'rose3'", qdqlnl):
a = qdqlnl.replace("{value:15, name:'rose3'},",
"{value:%d, name:'%s'}," % (xffb_qdqlnl[2][1], xffb_qdqlnl[2][0]))
qdqlnlList.append(a)
elif re.search("value:25, name:'rose4'", qdqlnl):
a = qdqlnl.replace("{value:25, name:'rose4'},",
"{value:%d, name:'%s'}," % (xffb_qdqlnl[3][1], xffb_qdqlnl[3][0]))
qdqlnlList.append(a)
elif re.search("value:20, name:'rose5'", qdqlnl):
a = qdqlnl.replace("{value:20, name:'rose5'},",
"{value:%d, name:'%s'}," % (xffb_qdqlnl[4][1], xffb_qdqlnl[4][0]))
qdqlnlList.append(a)
elif re.search("value:35, name:'rose6'", qdqlnl):
a = qdqlnl.replace("{value:35, name:'rose6'},",
"{value:%d, name:'%s'}," % (xffb_qdqlnl[5][1], xffb_qdqlnl[5][0]))
qdqlnlList.append(a)
elif re.search("value:30, name:'rose7'", qdqlnl):
a = qdqlnl.replace("{value:30, name:'rose7'},",
"{value:%d, name:'%s'}," % (xffb_qdqlnl[6][1], xffb_qdqlnl[6][0]))
qdqlnlList.append(a)
elif re.search("value:40, name:'rose8'", qdqlnl):
a = qdqlnl.replace("{value:40, name:'rose8'}",
"{value:%d, name:'%s'}" % (xffb_qdqlnl[7][1], xffb_qdqlnl[7][0]))
qdqlnlList.append(a)
else:
qdqlnlList.append(qdqlnl)
f.close()
with open(BASE_DIR + 'pieChart1.js', 'w+', encoding='utf-8') as new:
for i in qdqlnlList:
new.write(i)
new.close()
changeIndexFileName('pieChart.js', 'pieChart1.js')
else:
print('MD5值不正确!!')
def columnarjs():
'''
消费支收 Chart 图表后台数据更改
:return:
'''
db = querydb.DBAPI()
# 微信红包
# 收, 发, 收到最大金额, 发送最大金额 , 转账次数, 转最大金额, 收最大金额
sf_redpacket_num = db.queryCONSUME('sf_redpacket_num')
# 返回半年月份列表
# 获取当前月 [美食$ 交通$ 娱乐$ 生活$ 电子产品$] 金额
monthList, get_month = db.queryForeEnd('xfzs_bnxffl')
# 消费最高一周收支记录 [0, 0, 32.01, 821, 0, 0, 0] [-41, -39, -893, -1021.9, -218.42000000000002, -2218, -145.09]
pay, income = db.queryForeEnd('xfzs_xfzgyzsz')
# 全年各月收支记录
# 获取最大值，各月支出、各月收入
maxvalue, monthpay_list, monthincome_list = db.queryForeEnd('xfzs_qngysz')
# 指定原始 indexChart.js 文件md5值
if get_file_md5('columnarChart.js', 'old') == get_file_md5('columnarChart.js', 'new'):
# 消费支收 Chart
# 微信红包
wxhbList = []
with open(BASE_DIR + 'columnarChart.js', 'r', encoding='utf-8') as f:
a = f.readlines()
for wxhb in a:
if re.search("10, 52, 200, 334, 390, 330, 220", wxhb):
a = wxhb.replace("data:[10, 52, 200, 334, 390, 330, 220]", "data:[%d, %d, %d, %d, %d, %d, %d]" % (sf_redpacket_num[0], sf_redpacket_num[1],
sf_redpacket_num[2], sf_redpacket_num[3],
sf_redpacket_num[4], sf_redpacket_num[5],
sf_redpacket_num[6]))
wxhbList.append(a)
else:
wxhbList.append(wxhb)
# 半年消费分类
# 返回半年月份列表
bnxfflList = []
for bnxf in wxhbList:
if re.search("'1月','2月','3月','4月','5月','6月','7月'", bnxf):
a = bnxf.replace("data: ['1月','2月','3月','4月','5月','6月','7月']", "data: ['%s月','%s月','%s月','%s月','%s月','%s月','%s月']" % (str(monthList[0]), str(monthList[1]),
str(monthList[2]), str(monthList[3]),
str(monthList[4]), str(monthList[5]), str(monthList[6])))
bnxfflList.append(a)
else:
bnxfflList.append(bnxf)
# 获取当前月 [美食$ 交通$ 娱乐$ 生活$ 电子产品$] 金额
getmonthList = []
for gqdy in bnxfflList:
# 美食
if re.search("320, 302, 301, 334, 390, 330, 320", gqdy):
a = gqdy.replace("data: [320, 302, 301, 334, 390, 330, 320]", "data:[%d, %d, %d, %d, %d, %d, %d]" % (get_month[0][0], get_month[0][1],
get_month[0][2], get_month[0][3],
get_month[0][4], get_month[0][5],
get_month[0][6]))
getmonthList.append(a)
# 交通
elif re.search("120, 132, 101, 134, 90, 230, 210", gqdy):
a = gqdy.replace("data: [120, 132, 101, 134, 90, 230, 210]", "data:[%d, %d, %d, %d, %d, %d, %d]" % (get_month[1][0], get_month[1][1],
get_month[1][2], get_month[1][3],
get_month[1][4], get_month[1][5],
get_month[1][6]))
getmonthList.append(a)
# 娱乐
elif re.search("220, 182, 191, 234, 290, 330, 310", gqdy):
a = gqdy.replace("data: [220, 182, 191, 234, 290, 330, 310]", "data:[%d, %d, %d, %d, %d, %d, %d]" % (get_month[2][0], get_month[2][1],
get_month[2][2], get_month[2][3],
get_month[2][4], get_month[2][5],
get_month[2][6]))
getmonthList.append(a)
# 生活
elif re.search("150, 212, 201, 154, 190, 330, 410", gqdy):
a = gqdy.replace("data: [150, 212, 201, 154, 190, 330, 410]", "data:[%d, %d, %d, %d, %d, %d, %d]" % (get_month[3][0], get_month[3][1],
get_month[3][2], get_month[3][3],
get_month[3][4], get_month[3][5],
get_month[3][6]))
getmonthList.append(a)
# 电子产品
elif re.search("820, 832, 901, 934, 1290, 1330, 1320", gqdy):
a = gqdy.replace("data: [820, 832, 901, 934, 1290, 1330, 1320]", "data:[%d, %d, %d, %d, %d, %d, %d]" % (get_month[4][0], get_month[4][1],
get_month[4][2], get_month[4][3],
get_month[4][4], get_month[4][5],
get_month[4][6]))
getmonthList.append(a)
else:
getmonthList.append(gqdy)
# 消费最高一周收支记录
xfzgszList = []
for zgsz in getmonthList:
# 支出
if re.search("-120, -132, -101, -134, -190, -230, -210", zgsz):
a = zgsz.replace("data:[-120, -132, -101, -134, -190, -230, -210]", "data:[%d, %d, %d, %d, %d, %d, %d]" % (pay[0], pay[1],
pay[2], pay[3],
pay[4], pay[5],
pay[6]))
xfzgszList.append(a)
elif re.search("320, 302, 341, 374, 390, 450, 420", zgsz):
a = zgsz.replace("data:[320, 302, 341, 374, 390, 450, 420]", "data:[%d, %d, %d, %d, %d, %d, %d]" % (income[0], income[1],
income[2], income[3],
income[4], income[5],
income[6]))
xfzgszList.append(a)
else:
xfzgszList.append(zgsz)
# 全年各月收支记录
qngyszList = []
for qngy in xfzgszList:
# 最大值
if re.search("max: 250,", qngy):
a = qngy.replace("max: 250,", "max: %d," % maxvalue[0])
qngyszList.append(a)
# 支出
elif re.search("20, 49, 70, 32, 56, 67, 36, 22, 26, 50, 64, 33", qngy):
a = qngy.replace("data:[20, 49, 70, 32, 56, 67, 36, 22, 26, 50, 64, 33]", "data:[%d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d]" % (monthpay_list[0], monthpay_list[1],
monthpay_list[2], monthpay_list[3],
monthpay_list[4], monthpay_list[5],
monthpay_list[6], monthpay_list[7],
monthpay_list[8], monthpay_list[9],
monthpay_list[10], monthpay_list[11]))
qngyszList.append(a)
# 收入
elif re.search("26, 59, 90, 264, 28, 707, 76, 182, 87, 88, 60, 23", qngy):
a = qngy.replace("data:[26, 59, 90, 264, 28, 707, 76, 182, 87, 88, 60, 23]",
"data:[%d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d]" % (
monthincome_list[0], monthincome_list[1],
monthincome_list[2], monthincome_list[3],
monthincome_list[4], monthincome_list[5],
monthincome_list[6], monthincome_list[7],
monthincome_list[8], monthincome_list[9],
monthincome_list[10], monthincome_list[11]))
qngyszList.append(a)
else:
qngyszList.append(qngy)
f.close()
with open(BASE_DIR + 'columnarChart1.js', 'w+', encoding='utf-8') as new:
for i in qngyszList:
new.write(i)
new.close()
changeIndexFileName('columnarChart.js', 'columnarChart1.js')
else:
print('MD5值不正确!!')