def get_list_with_searchtext(args):
searchText = args['data'].get('search', '')
pageSize = args['data'].get('pageSize', 0)
pageIndex = args['data'].get('pageIndex', 20)
sort = args['data'].get('sort', 20)
pageIndex = (lambda pIndex: pIndex if pIndex != None else 0)(pageIndex)
pageSize = (lambda pSize: pSize if pSize != None else 20)(pageSize)
if not args['data'].has_key('factor_group_code') or args['data'][
'factor_group_code'] == None or args['data'][
'factor_group_code'] == "":
return None
ret = FactorAppraisal.display_list_factor_appraisal(
args['data']['factor_group_code'])
ret = common.filter_lock(ret, args)
if (searchText != None):
ret.match("contains(factor_code, @name) or contains(factor_name, @name)" + \
" or contains(weight, @name) or contains(ordinal, @name)",name=searchText.strip())
if (sort != None):
ret.sort(sort)
return ret.get_page(pageIndex, pageSize)
def get_list_department_by_parent_code(args):
searchText = args['data'].get('search', '')
pageSize = args['data'].get('pageSize', 0)
pageIndex = args['data'].get('pageIndex', 20)
sort = args['data'].get('sort', 20)
pageIndex = (lambda pIndex: pIndex if pIndex != None else 0)(pageIndex)
pageSize = (lambda pSize: pSize if pSize != None else 20)(pageSize)
ret = qmongo.models.HCSSYS_Departments.aggregate.project(
department_code=1,
department_name=1,
department_alias=1,
department_tel=1,
level_code=1,
lock=1)
ret.match("level_code == {0}", args['data']['where']['department_code'])
ret = common.filter_lock(ret, args)
if (searchText != None):
ret.match("contains(department_code, @name) or contains(department_name, @name)" + \
"or contains(department_alias, @name) or contains(department_tel, @name)",name=searchText.strip())
if (sort != None):
ret.sort(sort)
return ret.get_page(pageIndex, pageSize)
def get_list_with_searchtext(args):
searchText = args['data'].get('search', '')
pageSize = args['data'].get('pageSize', 0)
pageIndex = args['data'].get('pageIndex', 20)
where = args['data'].get('where', None)
sort = args['data'].get('sort', 20)
pageIndex = (lambda pIndex: pIndex if pIndex != None else 0)(pageIndex)
pageSize = (lambda pSize: pSize if pSize != None else 20)(pageSize)
ret=AdministrativeSubdivisions.get_hamlet()
ret=common.filter_lock(ret, args)
if where.has_key('ward_code') and where['ward_code'] != None:\
#and where['ward_code'].strip() != "":
ret.match("ward_code == @war_code", war_code = where['ward_code'])
if(searchText != None):
ret.match("contains(hamlet_name, @name) or " + \
"contains(hamlet_code, @name) or " + \
"contains(org_hamlet_code, @name) or " + \
"contains(ordinal, @name)",name=searchText.strip())
if(sort != None):
ret.sort(sort)
return ret.get_page(pageIndex, pageSize)
def get_list_with_searchtext(args):
searchText = args['data'].get('search', '')
pageSize = args['data'].get('pageSize', 0)
pageIndex = args['data'].get('pageIndex', 20)
sort = args['data'].get('sort', 20)
pageIndex = (lambda pIndex: pIndex if pIndex != None else 0)(pageIndex)
pageSize = (lambda pSize: pSize if pSize != None else 20)(pageSize)
ret=Currency.display_list_currency()
ret=common.filter_lock(ret, args)
if(searchText != None):
ret.match("contains(currency_code, @name) or " + \
"contains(currency_name, @name) or " + \
"contains(temp_rate, @name) or " + \
"contains(multiply, @name) or " + \
"contains(cons_code, @name) or " + \
"contains(dec_place, @name) or " + \
"contains(note, @name) or " + \
"contains(lock, @name) or " + \
"contains(ordinal, @name)",name=searchText.strip())
if(sort != None):
ret.sort(sort)
return ret.get_page(pageIndex, pageSize)
def get_list_with_searchtext(args):
searchText = args['data'].get('search', '')
pageSize = args['data'].get('pageSize', 0)
pageIndex = args['data'].get('pageIndex', 20)
sort = args['data'].get('sort', 20)
pageIndex = (lambda pIndex: pIndex if pIndex != None else 0)(pageIndex)
pageSize = (lambda pSize: pSize if pSize != None else 20)(pageSize)
ret = TrainSupplier.display_list_train_supplier()
ret = common.filter_lock(ret, args)
if (searchText != None):
ret.match("contains(tr_supplier_name, @name) or " + \
"contains(tr_supplier_code, @name) or " + \
"contains(tr_supplier_name2, @name) or " + \
"contains(address, @name) or " + \
"contains(tel, @name) or " + \
"contains(supplier_map, @name) or " + \
"contains(kind, @name) or " + \
"contains(note, @name) or " + \
"contains(ordinal, @name)",name=searchText.strip())
if (sort != None):
ret.sort(sort)
return ret.get_page(pageIndex, pageSize)
def get_list_with_searchtext(args):
searchText = args['data'].get('search', '')
pageSize = args['data'].get('pageSize', 0)
pageIndex = args['data'].get('pageIndex', 20)
sort = args['data'].get('sort', 20)
pageIndex = (lambda pIndex: pIndex if pIndex != None else 0)(pageIndex)
pageSize = (lambda pSize: pSize if pSize != None else 20)(pageSize)
ret = AprPeriodEmpOut.get_empNotApr_by_apr_period(
args['data']['apr_period'], args['data']['apr_year'], searchText)
ret = common.filter_lock(ret, args)
if (sort != None):
ret.sort(sort)
return ret.get_page(pageIndex, pageSize)
def get_list_with_searchtext(args):
searchText = args['data'].get('search', '')
pageSize = args['data'].get('pageSize', 0)
pageIndex = args['data'].get('pageIndex', 20)
sort = args['data'].get('sort', 20)
pageIndex = (lambda pIndex: pIndex if pIndex != None else 0)(pageIndex)
pageSize = (lambda pSize: pSize if pSize != None else 20)(pageSize)
ret=TMLS_Rank.display_list_rank()
ret=common.filter_lock(ret, args)
if(searchText != None and searchText !=''):
ret.match("contains(rank_code, @name) or contains(rank_name, @name) or " + \
"contains(rank_content, @name) or contains(total_from, @name) or " + \
"contains(total_to, @name) or contains(ordinal, @name)" ,name=searchText.strip())
if(sort != None):
ret.sort(sort)
return ret.get_page(pageIndex, pageSize)
def get_list_with_searchtext(args):
searchText = args['data'].get('search', '')
pageSize = args['data'].get('pageSize', 0)
pageIndex = args['data'].get('pageIndex', 20)
sort = args['data'].get('sort', 20)
pageIndex = (lambda pIndex: pIndex if pIndex != None else 0)(pageIndex)
pageSize = (lambda pSize: pSize if pSize != None else 20)(pageSize)
ret = Award.get_award_place()
ret = common.filter_lock(ret, args)
if (searchText != None):
ret.match("contains(award_place_name, @name) or " + \
"contains(award_place_code, @name) or " + \
"contains(ordinal, @name)",name=searchText.strip())
if (sort != None):
ret.sort(sort)
return ret.get_page(pageIndex, pageSize)
def get_list_with_searchtext(args):
if args['data'].has_key('gjw_code') and args['data'][
'gjw_code'] != None and args['data']['gjw_code'] != "":
searchText = args['data'].get('search', '')
pageSize = args['data'].get('pageSize', 0)
pageIndex = args['data'].get('pageIndex', 20)
sort = args['data'].get('sort', 20)
pageIndex = (lambda pIndex: pIndex if pIndex != None else 0)(pageIndex)
pageSize = (lambda pSize: pSize if pSize != None else 20)(pageSize)
ret = JobWorking.display_list_job_working(args['data']['gjw_code'])
ret = common.filter_lock(ret, args)
if (searchText != None):
ret.match("contains(job_w_name, @name) or contains(report_to_job_w, @name)" + \
" or contains(job_w_code, @name) or contains(ordinal, @name)",name=searchText.strip())
if (sort != None):
ret.sort(sort)
return ret.get_page(pageIndex, pageSize)
return None
