def _createSFQueryParam(params):
""" Get clients in both desk and sf
args:
params: worker params
clients: id of clients to query
return:
query doc & filter doc
"""
# 查询指定时间的数据
search_param = {
'Account.Name': {
'$exists': True,
'$in':params['clients']
},
'CreatedDate' : {
'$gte': timestamp2str(params['start_date']),
'$lte': timestamp2str(params['end_date'])
},
'Type' : {'$ne': 'New Customer'},
'IsDeleted' : {'$in': [False, re.compile('false', re.IGNORECASE)]},
'fx_sf_userid': params['apps']['salesforce']['user_id'],
'fx_batch_id': params['apps']['salesforce']['batch_id']
}
# 只获取需要的内容
filter_param = {
'Account.Name': 1,
'CreatedDate': 1,
'_id':0
}
return search_param, filter_param
def _createDeskQueryParam(params):
""" Get clients in both desk and sf
args:
params: worker params
return:
query doc & filter doc
"""
# 查询指定时间的数据
search_param = {
'company': {
'$exists': True,
'$in':params['clients']
},
'status': 'resolved',
'resolved_at' : {
'$ne': 'null',
'$gte': timestamp2str(params['start_date']),
'$lte': timestamp2str(params['end_date']),
},
'fx_desk_userid': params['apps']['desk']['user_id'],
'fx_batch_id': params['apps']['desk']['batch_id']
}
# 只需时间和客户两个字段
filter_param = {
'company': 1,
'resolved_at': 1,
'created_at': 1,
'rating': 1,
'_id':0
}
return search_param, filter_param
