示例#1
0
def refresh_summary_acperiodcate():

    userID = request.args.get('userID')
    startDate = request.args.get('startDate')
    endDate = request.args.get('endDate')

    modeDate = 2

    from controls.GetJson_ACPeriodCate import GetJson_ACPeriodCate
    json_response = GetJson_ACPeriodCate(userID, modeDate, startDate, endDate)

    if 'errMsg' not in json_response:
        # 解包,翻译,打包
        legendLabels = json_response['json_dateTrend']['legendLabels']
        seriesData = json_response['json_dateTrend']['seriesData']

        legendLabels = map(lambda x: helpers.translate(x), legendLabels)
        for datum in seriesData:
            datum['name'] = helpers.translate(datum['name'])

        json_response['json_dateTrend']['legendLabels'] = legendLabels
        json_response['json_dateTrend']['seriesData'] = seriesData

        legendLabels = json_response['json_timeDistribution']['legendLabels']
        seriesData = json_response['json_timeDistribution']['seriesData']

        legendLabels = map(lambda x: helpers.translate(x), legendLabels)
        for datum in seriesData:
            datum['name'] = helpers.translate(datum['name'])

        json_response['json_timeDistribution']['legendLabels'] = legendLabels
        json_response['json_timeDistribution']['seriesData'] = seriesData

    return jsonify(json_response)
示例#2
0
def refresh_chart_concategory():
    form = Form_Concategory()
    form.userID.data = request.args.get('userID')
    form.dateRange.data = request.args.get('dateRange')

    if not form.validate():
        return jsonify(errMsg=form.errors['userID'])
    if not check_user_id(form.userID.data):
        return jsonify(errMsg=lstr.warn_userIDNon)

    userID = form.userID.data
    startDate = form.dateRange.data[:10]
    endDate = form.dateRange.data[-10:]

    from controls.GetJson_ConCategory import GetJson_ConCategory
    json_response = GetJson_ConCategory(userID, startDate, endDate)

    if 'errMsg' not in json_response:
        titles = json_response['titles']
        seriesData = json_response['seriesData']

        for datum in seriesData:
            datum['name'] = helpers.translate(datum['name'])
        titles = [helpers.translate(title) for title in titles]

        json_response['titles'] = titles
        json_response['seriesData'] = seriesData

    return jsonify(json_response)
示例#3
0
def refresh_chart_acvalid():
    form = Form_Acvalid()
    form.userID.data = request.args.get('userID')
    form.dateRange.data = request.args.get('dateRange')

    if not form.validate():
        return jsonify(errMsg=form.errors['userID'])
    if not check_user_id(form.userID.data):
        return jsonify(errMsg=lstr.warn_userIDNon)

    userID = form.userID.data
    startDate = form.dateRange.data[:10]
    endDate = form.dateRange.data[-10:]

    from controls.GetJson_ACValid import GetJson_ACValid
    json_response = GetJson_ACValid(userID, startDate, endDate)

    if 'errMsg' not in json_response:
        titles = json_response['titles']
        seriesData = json_response['seriesData']

        titles = map(lambda x: helpers.translate(x), titles)
        for datum in seriesData:
            datum['name'] = helpers.translate(datum['name'])

        json_response['titles'] = titles
        json_response['seriesData'] = seriesData

    return jsonify(json_response)
示例#4
0
def ac_overall(userID, startDate, endDate):
    # 不同门禁地点的数量
    # 总门禁次数
    # 地点信息:名称,次数,分类

    sql = (
        "SELECT node_des,COUNT(acrec.node_des)as con from acrec where user_id='%s' GROUP BY node_des ORDER BY con DESC"
        % (userID)
    )
    # sql = db.session.query(acrec.node_des, func.count(acrec.node_des)).filter(acrec.user_id==userID)
    results = db.session.execute(sql).fetchall()

    if len(results) == 0:
        return {"count_nodes": -1, "total_count": -1, "ac_items": -1}

    node_des = [result.node_des for result in results]  # 地点名
    count = [result.con for result in results]  # 地点门禁次数
    node_cate = []  # 地点分类
    total_count = sum(count)  # 总门禁次数

    ac_items = []
    for i in xrange(len(node_des)):
        sql = db.session.query(ac_loc.category).filter(ac_loc.node_des == node_des[i])  # 查询地点的分类
        node_cate.append(helpers.translate(sql.first()))  # 翻译并加入
        ac_items.append({"node_des": node_des[i], "count": count[i], "node_cate": node_cate[i]})

    return {"count_nodes": len(node_des), "total_count": total_count, "ac_items": ac_items}
示例#5
0
def refresh_chart_acperiodcate():
    """Codes mainly in controls.ACPeriodCate.py.
    """
    form = Form_Acperiodcate()
    form.userID.data = request.args.get('userID')
    form.dateRange.data = request.args.get('dateRange')
    form.modeDate.data = request.args.get('modeDate')

    if not form.validate():
        return jsonify(errMsg=form.errors['userID'])
    if not check_user_id(form.userID.data):
        return jsonify(errMsg=lstr.warn_userIDNon)

    userID = form.userID.data
    startDate = form.dateRange.data[:10]
    endDate = form.dateRange.data[-10:]
    modeDate = int(form.modeDate.data)

    from controls.GetJson_ACPeriodCate import GetJson_ACPeriodCate
    json_response = GetJson_ACPeriodCate(userID,modeDate,startDate,endDate)

    if 'errMsg' not in json_response:
        # 解包,翻译,打包
        legendLabels = json_response['json_dateTrend']['legendLabels']
        seriesData = json_response['json_dateTrend']['seriesData']

        legendLabels = map(lambda x: helpers.translate(x), legendLabels)
        for datum in seriesData:
            datum['name'] = helpers.translate(datum['name'])

        json_response['json_dateTrend']['legendLabels'] = legendLabels
        json_response['json_dateTrend']['seriesData'] = seriesData

        legendLabels = json_response['json_timeDistribution']['legendLabels']
        seriesData = json_response['json_timeDistribution']['seriesData']

        legendLabels = map(lambda x: helpers.translate(x), legendLabels)
        for datum in seriesData:
            datum['name'] = helpers.translate(datum['name'])

        json_response['json_timeDistribution']['legendLabels'] = legendLabels
        json_response['json_timeDistribution']['seriesData'] = seriesData

    return jsonify(json_response)
示例#6
0
def refresh_summary_concategory():

    userID = request.args.get('userID')
    startDate = request.args.get('startDate')
    endDate = request.args.get('startDate')

    from controls.GetJson_ConCategory import GetJson_ConCategory
    json_response = GetJson_ConCategory(userID, startDate, endDate)

    if 'errMsg' not in json_response:
        titles = json_response['titles']
        seriesData = json_response['seriesData']

        for datum in seriesData:
            datum['name'] = helpers.translate(datum['name'])
        titles = [helpers.translate(title) for title in titles]

        json_response['titles'] = titles
        json_response['seriesData'] = seriesData

    return jsonify(json_response)
示例#7
0
def bill(userID, startDate, endDate):
    # 账单: 最近一月:
    # 消费类型比例 concategory, conablilty, expenditure
    # 一月消费总额

    # init
    total_expend = -1
    top_cate = ""
    con_per_month = -1

    # Get total_expend 总支出
    from GetJson_Expenditure import GetJson_expenditure

    json_Expenditure = GetJson_expenditure(userID, 0, 2, startDate, endDate)
    if "errMsg" not in json_Expenditure:
        dateTrend = json_Expenditure["json_dateTrend"]
        total_expend = dateTrend["accumulatedVals"][-1]

    # 消费分类排名
    from GetJson_ConCategory import GetJson_ConCategory

    json_ConCategory = GetJson_ConCategory(userID, startDate, endDate)

    if "errMsg" not in json_ConCategory:
        con_items = json_ConCategory["seriesData"]
        top_cate = helpers.translate(con_items[0]["name"])

    # [{'name': 'food', 'value': 2653.9}, {'name': 'shop', 'value': 177.5}, {'name': 'None', 'value': 56.5}, ...]

    # 消费能力
    from GetJson_ConAbility import GetJson_ConAbility

    json_ConAbility = GetJson_ConAbility(userID)

    # 月均消费
    if "errMsg" not in json_ConAbility:
        con_per_month = json_ConAbility["userAmount"]

    return {"total_expend": total_expend, "top_cate": top_cate, "con_per_month": con_per_month}