#!/usr/bin/python
# -*- coding: GBK -*-
#---------------------------------------------------------------------
#
#---------------------------------------------------------------------
##@package GMT_CardTypeInfo.py
# GMÃüÁîÐÂÊÖ¿¨ÀàÐÍÊý¾Ý²éѯ
#
# @author wdb
# @date 2012-06-21
# @version 1.0
#
# @note
#---------------------------------------------------------------------
"""Version = 2012-06-21 15:30"""
#---------------------------------------------------------------------
#µ¼Èë
import GMCommon
from Collections.CollectionDefine import *
#---------------------------------------------------------------------
#È«¾Ö±äÁ¿
#---------------------------------------------------------------------

## ÊÕµ½gmÃüÁîÖ´ÐÐ
# @param gmCmdDict:gmÃüÁî×Öµä
# @return None 
def OnExec(gmCmdDict):         

    if GMCommon.ToIntDef(gmCmdDict.get('cardType', ''), -1) < 0:
        return GMCommon.Def_ParamErr, ''
    
    return GMCommon.Def_DoQueryUserDB, ''

    
## ²éѯlogdb·µ»Ø
# @param logdb:logdb
# @param data:´«ÈëµÄÐÅÏ¢
# @param gmCmdDict:gmÃüÁî×Öµä
# @return None 
def LogDBResponse(logdb, data, gmCmdDict):       
    return GMCommon.Def_ParamErr, ''


## ²éѯuserdb·µ»Ø
# @param userdb:userdb
# @param data:´«ÈëµÄÐÅÏ¢
# @param gmCmdDict:gmÃüÁî×Öµä
# @return None 
def UserDBResponse(userdb, data, gmCmdDict):
    cardType = GMCommon.ToIntDef(gmCmdDict.get('cardType', ''))
    
    collection = userdb[UCN_DBNewGuyCardState]
    validTime = ''
    
    # ¸ÃÀàÐÍ×ÜÊý
    findCards = collection.find({'CardType':cardType}) 
    totalCnt = findCards.count()
    if totalCnt > 0:
        validTime = findCards[0].get('ValidTime', '')
    
    # ¸ÃÀàÐÍδʹÓÃÊýÁ¿
    unUsedCnt = collection.find({'CardType':cardType, 'IsUsed':0}).count()

    cartTypeInfo = {
                    'totalCnt':totalCnt,
                    'usedCnt':totalCnt - unUsedCnt,
                    'unUsedCnt':unUsedCnt,     
                    'validTime':validTime,      
                    }
    
    return GMCommon.Def_Success, cartTypeInfo