天眼人脸识别系统-消费分析案例

一、月度消费分析

步骤一：sourceai/model/face/db/face_query.py添加及修改如下代码：

from sourceai.model.face.db import face_storage
from sourceai.model.face.db import face_obj


def query(imgid, name=''):
    dbconn = face_storage.MySQL_Query()
    res = ''
    if (name == 'user'):
        res = query_userinfo(dbconn, imgid)
    elif (name == 'resume'):
        res = query_resume_info(dbconn, imgid)
    elif (name == 'travel'):
        res = query_travel_info(dbconn, imgid)
    elif (name == 'medical'):
        res = query_medical_info(dbconn, imgid)
    elif (name == 'diet'):
        res = query_diet_info(dbconn, imgid)
    elif (name == 'catagory'):
        res = query_diet_catagory(dbconn, imgid)
    elif (name == 'consume_month'):
        res = query_consume_info(dbconn, imgid)

    # print(res)
    dbconn.disconnect()
    return res
    
 def query_consume_info(dbconn, imgid):
    sql = "select  date_format(f_time,'%m月')  AS 月份,sum(f_money) AS 数量 from tb_finance where f_time >= (SELECT DATE_SUB(CURDATE(),INTERVAL dayofyear(now())-1 DAY)) and f_userid in (select f_id from tb_user where f_faceid = '" + imgid + "' ) group by 月份 order by 月份"
    results = dbconn.query(sql)
    months = []
    values = []

    for row in results:
        months.append(str(row[0]))
        values.append(str(row[1]))

    dict_data = {}
    dict_data['月份'] = months
    dict_data['消费'] = values

    return dict_data

步骤二：在sourceai/controller/portrait_views.py文件中添加如下内容：

def get_consume_info(request):
    faceid = request.POST.get('userid')
    datas = face_query.query(faceid, 'consume_month')
    return HttpResponse(json.dumps(datas))

步骤三：启动项目，进行人脸识别后，结果如下：

二、年度消费分析

步骤一：sourceai/model/face/db/face_query.py添加及修改如下代码：

from sourceai.model.face.db import face_storage
from sourceai.model.face.db import face_obj


def query(imgid, name=''):
    dbconn = face_storage.MySQL_Query()
    res = ''
    if (name == 'user'):
        res = query_userinfo(dbconn, imgid)
    elif (name == 'resume'):
        res = query_resume_info(dbconn, imgid)
    elif (name == 'travel'):
        res = query_travel_info(dbconn, imgid)
    elif (name == 'medical'):
        res = query_medical_info(dbconn, imgid)
    elif (name == 'diet'):
        res = query_diet_info(dbconn, imgid)
    elif (name == 'catagory'):
        res = query_diet_catagory(dbconn, imgid)
    elif (name == 'consume_month'):
        res = query_consume_info(dbconn, imgid)
    elif (name == 'consume_year'):
        res = query_consume_year(dbconn, imgid)

    # print(res)
    dbconn.disconnect()
    return res
    
def query_consume_year(dbconn, imgid):
    sql = "select  date_format(f_time,'%y年')  AS 年份 ,sum(IF(f_type='支出',f_money,0)) AS 支出, sum(IF(f_type='收入',f_money,0)) AS 收入 from tb_finance where f_userid in (select f_id from tb_user where f_faceid = '" + imgid + "' ) group by 年份  order by 年份 "
    results = dbconn.query(sql)
    years = []
    payout = []
    income = []

    for row in results:
        years.append(str(row[0]))
        payout.append(str(row[1]))
        income.append(str(row[2]))

    dict_data = {}
    dict_data['年份'] = years
    dict_data['支出'] = payout
    dict_data['收入'] = income

    return dict_data

步骤二：在sourceai/controller/portrait_views.py文件中添加如下内容：

def get_consume_year(request):
    faceid = request.POST.get('userid')
    datas = face_query.query(faceid, 'consume_year')
    return HttpResponse(json.dumps(datas))

步骤三：启动项目，进行人脸识别后，结果如下：