common_datetime_wheres

[jackiect]

def common_datetime_wheres(f_datetime, start_time=None, end_time=None):

    wheres = ConditionSet()

    if start_time is not None:
        wheres &= (f_datetime >= start_time)

    if end_time is not None:
        wheres &= (f_datetime < end_time)

    return wheres

[jackiect]

def bd_get_base_merchants_tables_wheres(bd_id=None):
    """
    if bd_id is None, always means a BOSS role view
    """
    ts_base = T.account_recommend_info__ari
    ws_base = (F.ari__referrer_id_type == const.ACCOUNT_RECOMMEND_INFO.REFERRER_ID_TYPE.BD_ACCOUNT)

    if bd_id is not None:
        ws_base &= (F.ari__referrer_id == bd_id)

    return ts_base, ws_base

[jackiect]

def bd_get_merchants_tables_wheres(bd_id, account_status=const.ACCOUNT_STATUS.NORMAL):
    """
    if bd_id is None, always means a BOSS role view;
    if account_status is NOT None, must take account Table into account
    """

    ts_base, ws_base = bd_get_base_merchants_tables_wheres(bd_id)

    if account_status is not None:
        ts_base = (ts_base * T.account__a).on(F.ari__account_id == F.a__id)
        ws_base &= ("a.role & %s > 0" % const.ACCOUNT_ROLE.MERCHANT)
        ws_base &= (F.a__status == account_status)

    return ts_base, ws_base