Example #1
0
def get_pv_rpt_by_day(conditions):
    #TODO: add search filters to pipline
    date_start = conditions.get('date_start')
    date_end = conditions.get('date_end')

    pipeline = [
        {"$project":
             {
                 "day":"$day",
                 "uid": "$uid",
                 "pc":{"$cond": [{"$eq": ["$type", "1"]}, 1, 0]},
                 "sc":{"$cond": [{"$eq": ["$type", "2"]}, 1, 0]}
             }
        },
        { "$group":
              {
                  "_id": { "day": "$day", "uid": "$uid" },
                  "pc": {"$sum": "$pc"},
                  "sc": {"$sum": "$sc"}
              }
        },
        { "$group":
              {
                  "_id": "$_id.day",
                  "pc": {"$sum": "$pc"},
                  "sc": {"$sum": "$sc"},
                  "uc": {"$sum": 1}
              }
        }
    ]

    rst = Trace._get_collection().aggregate(pipeline)
    return rst.get('result')
Example #2
0
def get_pv_rpt_by_day(conditions):
    #TODO: add search filters to pipline
    date_start = conditions.get('date_start')
    date_end = conditions.get('date_end')

    pipeline = [{
        "$project": {
            "day": "$day",
            "uid": "$uid",
            "pc": {
                "$cond": [{
                    "$eq": ["$type", "1"]
                }, 1, 0]
            },
            "sc": {
                "$cond": [{
                    "$eq": ["$type", "2"]
                }, 1, 0]
            }
        }
    }, {
        "$group": {
            "_id": {
                "day": "$day",
                "uid": "$uid"
            },
            "pc": {
                "$sum": "$pc"
            },
            "sc": {
                "$sum": "$sc"
            }
        }
    }, {
        "$group": {
            "_id": "$_id.day",
            "pc": {
                "$sum": "$pc"
            },
            "sc": {
                "$sum": "$sc"
            },
            "uc": {
                "$sum": 1
            }
        }
    }]

    rst = Trace._get_collection().aggregate(pipeline)
    return rst.get('result')
Example #3
0
def api_trace(request):
    from integration.models import Trace
    import datetime

    trc = Trace()
    trc.type = request.GET.get("type", "0")
    trc.func_name = request.GET.get("fn", "")
    trc.func_content = request.GET.get("fc", "")
    trc.cookie_id = request.COOKIES.get("sessionid", None)
    trc.uid = request.COOKIES.get("uid", None)
    trc.req_referer = request.META.get("HTTP_REFERER", None)
    trc.agent = request.META.get("HTTP_USER_AGENT", None)
    trc.req_url = request.build_absolute_uri()
    trc.day = datetime.datetime.now().strftime("%Y%m%d")
    if request.META.has_key("HTTP_X_FORWARDED_FOR"):
        trc.ip = request.META["HTTP_X_FORWARDED_FOR"]
    else:
        trc.ip = request.META.get("REMOTE_ADDR", None)
    if request.user and request.user.is_authenticated():
        trc.user_id = str(request.user.pk)
    try:
        trc.save()
    except Exception:
        pass

    return HttpResponseJson("")
Example #4
0
def api_trace(request):
    from integration.models import Trace
    import datetime

    trc = Trace()
    trc.type = request.GET.get('type', '0')
    trc.func_name = request.GET.get('fn', '')
    trc.func_content = request.GET.get('fc', '')
    trc.cookie_id = request.COOKIES.get('sessionid', None)
    trc.uid = request.COOKIES.get('uid', None)
    trc.req_referer = request.META.get('HTTP_REFERER', None)
    trc.agent = request.META.get('HTTP_USER_AGENT', None)
    trc.req_url = request.build_absolute_uri()
    trc.day = datetime.datetime.now().strftime('%Y%m%d')
    if request.META.has_key('HTTP_X_FORWARDED_FOR'):
        trc.ip = request.META['HTTP_X_FORWARDED_FOR']
    else:
        trc.ip = request.META.get('REMOTE_ADDR', None)
    if request.user and request.user.is_authenticated():
        trc.user_id = str(request.user.pk)
    try:
        trc.save()
    except Exception:
        pass

    return HttpResponseJson('')