WebSVN – SmartDukaan – Diff – //trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py



            creditorMap['Sanctions'] = sanctionsList
            returnMap[sanction.creditor_id] = creditorMap
                    
    return returnMap
 
def get_user_sanction_details_paginated(userId, creditorId, limit=0, offset=0,sort):
    totalCount = UserSanction.query.filter(UserSanction.active == True).count()
    hasMore = False
    if limit >0 and (limit+offset) < totalCount:
        hasMore = True 
    us_query = UserSanction.query
    if userId:
        us_query = us_query.filter(UserSanction.user_id == userId)
    if creditorId:
        us_query = us_query.filter(UserSanction.creditor_id == creditorId)
    us_query = us_query.filter(UserSanction.active == True)
    print sort
    if sort is 'loan':
        us_query = us_query.order_by(desc(UserSanction.loan))
    if limit>0:
        us_query = us_query.limit(limit)
    if offset>0 and limit >0:
        us_query = us_query.offset(offset)
 
    allSanctions = us_query.all()
    returnMap = {}
    for sanction in allSanctions:
        ticket_size = -1
        if creditorTicketSizeMap.has_key(sanction.creditor_id):

Rev 19839	Rev 19868
Line 9581...	Line 9581...
9581	`creditorMap['Sanctions'] = sanctionsList`	9581	`creditorMap['Sanctions'] = sanctionsList`
9582	`returnMap[sanction.creditor_id] = creditorMap`	9582	`returnMap[sanction.creditor_id] = creditorMap`
9583		9583
9584	`return returnMap`	9584	`return returnMap`
9585		9585
9586	`def get_user_sanction_details_paginated(userId, creditorId, limit=0, offset=0):`	9586	`def get_user_sanction_details_paginated(userId, creditorId, limit=0, offset=0,sort):`
9587	`totalCount = UserSanction.query.filter(UserSanction.active == True).count()`	9587	`totalCount = UserSanction.query.filter(UserSanction.active == True).count()`
9588	`hasMore = False`	9588	`hasMore = False`
9589	`if limit >0 and (limit+offset) < totalCount:`	9589	`if limit >0 and (limit+offset) < totalCount:`
9590	`hasMore = True`	9590	`hasMore = True`
9591	`us_query = UserSanction.query`	9591	`us_query = UserSanction.query`
9592	`if userId:`	9592	`if userId:`
9593	`us_query = us_query.filter(UserSanction.user_id == userId)`	9593	`us_query = us_query.filter(UserSanction.user_id == userId)`
9594	`if creditorId:`	9594	`if creditorId:`
9595	`us_query = us_query.filter(UserSanction.creditor_id == creditorId)`	9595	`us_query = us_query.filter(UserSanction.creditor_id == creditorId)`
9596	`us_query = us_query.filter(UserSanction.active == True)`	9596	`us_query = us_query.filter(UserSanction.active == True)`
-		9597	`print sort`
-		9598	`if sort is 'loan':`
-		9599	`us_query = us_query.order_by(desc(UserSanction.loan))`
9597	`if limit>0:`	9600	`if limit>0:`
9598	`us_query = us_query.limit(limit)`	9601	`us_query = us_query.limit(limit)`
9599	`if offset>0 and limit >0:`	9602	`if offset>0 and limit >0:`
9600	`us_query = us_query.offset(offset)`	9603	`us_query = us_query.offset(offset)`
9601		-
9602	`allSanctions = us_query.all()`	9604	`allSanctions = us_query.all()`
9603	`returnMap = {}`	9605	`returnMap = {}`
9604	`for sanction in allSanctions:`	9606	`for sanction in allSanctions:`
9605	`ticket_size = -1`	9607	`ticket_size = -1`
9606	`if creditorTicketSizeMap.has_key(sanction.creditor_id):`	9608	`if creditorTicketSizeMap.has_key(sanction.creditor_id):`

Subversion Repositories SmartDukaan

(root)//trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py – Rev 19839 → 19868