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