def is_member_completion(view, caret): line = view.substr(Region(view.line(caret).a, caret)) if member_regex.search(line) != None: return True elif get_language(view).startswith("objc"): return re.search(r"\[[\.\->\s\w\]]+\s+$", line) != None return False
def get_opts(self, view, filename): folder = os.path.dirname(filename) if folder in self.compilation_database: opts = list(self.compilation_database[folder]) else: self.set_status('%s not in compilation database' % folder) opts = get_path_setting("options", [], view) if not get_setting("dont_prepend_clang_includes", False, view): opts.insert(0, "-I%s/clang/include" % scriptpath) if get_setting("add_language_option", True, view): language = get_language(view) if language == "objc": opts.append("-ObjC") elif language == "objc++": opts.append("-ObjC++") else: opts.append("-x") opts.append(language) additional_language_options = get_setting("additional_language_options", {}, view) if additional_language_options.has_key(language): opts.extend(additional_language_options[language] or []) self.debug_options = get_setting("debug_options", False) self.index_parse_options = get_setting("index_parse_options", 13, view) return opts
def is_member_completion(view, caret): line = view.substr(Region(view.line(caret).a, caret)) if member_regex.search(line) != None: return True elif get_language(view).startswith("objc"): return re.search(r"\[[\s\w\]]+\s+$", line) != None return False
def get_kpi_by_kpi_code(args): try: collection = common.get_collection('TMLS_KPI') ret = collection.aggregate([ {'$lookup': { 'foreignField': 'value', 'as': 'val', 'from': common.get_collection_name_with_schema('SYS_VW_ValueList'), 'localField': 'cycle_type' } }, {'$unwind': { 'path': '$val', 'preserveNullAndEmptyArrays': True } }, {'$match': { '$and':[{ '$or' :[{ 'val.list_name':None}, { 'val.list_name':'LCycleType'}] }, { '$or' :[{ 'val.language':None}, { 'val.language': common.get_language()}] }] } }, {'$lookup': { 'foreignField': 'unit_code', 'as': 'unit', 'from': common.get_collection_name_with_schema('HCSLS_Unit'), 'localField': 'unit_code' } }, {'$unwind': { 'path': '$unit', 'preserveNullAndEmptyArrays': True } }, {'$project': { 'kpi_name': '$kpi_name', 'is_apply_all': '$is_apply_all', 'kpi_desc': '$kpi_desc', 'cycle_type': { '$ifNull': [ '$val.caption', '' ] }, 'kpi_code': { '$ifNull': [ '$kpi_code', '' ] }, 'weight': '$weight', 'unit_code': { '$ifNull': [ '$unit.unit_name', '' ] }, 'lock': '$lock', 'benchmark': { '$ifNull': [ '$benchmark', '' ] }, 'score_from': { '$ifNull': [ '$score_from', '' ] }, 'score_to': { '$ifNull': [ '$score_to', '' ] } } }, {'$match': {'lock': {'$ne': True}, 'kpi_code':{'$eq':args['data']['kpi_code']}}}]) return (lambda x: x[0] if x != None and len(x) > 0 else None)(list(ret)) except Exception as ex: raise(ex)
def get_email_template(): collection = qmongo.models.TM_EmailTemplate.aggregate collection.lookup(SYS_VW_ValueList(), "module_name", "value", "val") collection.unwind("val") collection.match("val.language == {0}", common.get_language()) collection.project(rec_id="rec_id", email_template_code="email_template_code", email_template_name="email_template_name", description="description", subject="subject", body="body", module_name="module_name", display_module_name="val.caption") return collection
def get_opts(self, view): opts = get_path_setting("options", [], view) if not get_setting("dont_prepend_clang_includes", False, view): opts.insert(0, "-I%s/clang/include" % scriptpath) if get_setting("add_language_option", True, view): language = get_language(view) if language == "objc": opts.append("-ObjC") elif language == "objc++": opts.append("-ObjC++") else: opts.append("-x") opts.append(language) additional_language_options = get_setting("additional_language_options", {}, view) if additional_language_options.has_key(language): opts.extend(additional_language_options[language] or []) self.debug_options = get_setting("debug_options", False) self.index_parse_options = get_setting("index_parse_options", 13, view) return opts
def get_opts(self, view): opts = get_path_setting("options", [], view) if not get_setting("dont_prepend_clang_includes", False, view): opts.insert(0, "-I%s/clang/include" % scriptpath) if get_setting("add_language_option", True, view): language = get_language(view) if language == "objc": opts.append("-ObjC") elif language == "objc++": opts.append("-ObjC++") else: opts.append("-x") opts.append(language) additional_language_options = get_setting( "additional_language_options", {}, view) if additional_language_options.has_key(language): opts.extend(additional_language_options[language] or []) self.debug_options = get_setting("debug_options", False) self.index_parse_options = get_setting("index_parse_options", 13, view) return opts
def get_list_approve_level_by_process_id(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) items = qmongo.models.TM_SetupProcessApproveLevel.aggregate # items.left_join(models.SYS_VW_ValueList(), "email_approve_to", "value", "email_approve") # items.match("(email_approve.list_name == @list_name and email_approve.language == @lan) or email_approve_to == @email_approve_to", # list_name="LSendEmail", lan= common.get_language(), email_approve_to = None) # items.left_join(models.SYS_VW_ValueList(), "email_reject_to", "value", "email_reject") # items.match("(email_reject.list_name == @list_name and email_reject.language == @lan) or email_reject_to == @email_reject_to", # list_name="LSendEmail", lan=common.get_language(), email_reject_to = None) items.left_join(SYS_VW_ValueList(), "approver_value", "value", "appr_val") items.match( "(appr_val.list_name == @list_name and appr_val.language == @lan) or approver_value == @approver_value", list_name="PERF_Approver", lan=common.get_language(), approver_value=None) items.left_join(models.auth_user_info(), "created_by", "username", "uc") items.left_join(models.auth_user_info(), "modified_by", "username", "um") items.project( rec_id=1, process_id=1, approve_level=1, approver_value=1, approver_value_display= "switch(case(appr_val.caption!='',appr_val.caption),'')", email_approve_code=1, email_approve_to=1, #email_approve_to_name="switch(case(email_approve.value!='',email_approve.value),'')", email_approve_cc=1, email_approve_more=1, email_reject_code=1, email_reject_to=1, #email_reject_to_name="switch(case(email_reject.value!='',email_reject.value),'')", email_reject_cc=1, email_reject_more=1, email_approve_cancel_code=1, email_approve_cancel_to=1, email_approve_cancel_cc=1, email_approve_cancel_more=1, email_reject_cancel_code=1, email_reject_cancel_to=1, email_reject_cancel_cc=1, email_reject_cancel_more=1, default_approver_code=1, not_receive_email=1, created_by="uc.login_account", created_on="created_on", modified_on="switch(case(modified_on!='',modified_on),'')", modified_by="switch(case(modified_by!='',um.login_account),'')").match( "process_id == {0}", int(args['data']['process_id'])) if (searchText != None): items.match("contains(process_name, @name)", name=searchText) if (sort != None): items.sort(sort) return items.get_page(pageIndex, pageSize)
def get_list_kpi(args): searchText = args['data'].get('search', '') page_size = args['data'].get('pageSize', 0) page_index = args['data'].get('pageIndex', 20) sort = args['data'].get('sort', 20) collection = common.get_collection('TMLS_KPI') ret = collection.aggregate([{ '$lookup': { 'foreignField': 'value', 'as': 'val', 'from': common.get_collection_name_with_schema('SYS_VW_ValueList'), 'localField': 'cycle_type' } }, { '$unwind': { 'path': '$val', 'preserveNullAndEmptyArrays': True } }, { '$match': { '$and': [{ '$or': [{ 'val.list_name': None }, { 'val.list_name': 'LCycleType' }] }, { '$or': [{ 'val.language': None }, { 'val.language': common.get_language() }] }] } }, { '$lookup': { 'foreignField': 'unit_code', 'as': 'unit', 'from': common.get_collection_name_with_schema('HCSLS_Unit'), 'localField': 'unit_code' } }, { '$unwind': { 'path': '$unit', 'preserveNullAndEmptyArrays': True } }, { '$lookup': { 'foreignField': 'kpi_group_code', 'as': 'kpig', 'from': common.get_collection_name_with_schema('TMLS_KPIGroup'), 'localField': 'kpi_group_code' } }, { '$unwind': { 'path': '$kpig', 'preserveNullAndEmptyArrays': True } }, { '$project': { 'kpi_name': '$kpi_name', 'is_apply_all': '$is_apply_all', 'kpi_desc': '$kpi_desc', 'cycle_type': { '$ifNull': ['$val.caption', ''] }, 'kpi_code': '$kpi_code', 'level_code': '$kpig.level_code', 'weight': '$weight', 'unit_code': { '$ifNull': ['$unit.unit_name', ''] }, 'lock': '$lock', 'benchmark': { '$ifNull': ['$benchmark', ''] }, 'score_from': { '$ifNull': ['$score_from', ''] }, 'score_to': { '$ifNull': ['$score_to', ''] } } }, { '$match': { 'lock': { '$ne': True }, 'level_code': { '$eq': args['data']['kpi_group_code'] } } }, { '$sort': common.aggregate_sort(sort) }, { "$facet": { "metadata": [{ "$count": "total" }, { "$addFields": { "page_index": page_index, "page_size": page_size } }], "data": [{ "$skip": page_size * page_index }, { "$limit": page_size }] } }, { "$unwind": { "path": '$metadata', "preserveNullAndEmptyArrays": False } }, { "$project": { 'page_size': '$metadata.page_size', 'page_index': '$metadata.page_index', 'total_items': '$metadata.total', 'items': '$data' } }]) return (lambda x: x[0] if x != None and len(x) > 0 else { 'page_size': page_size, 'page_index': page_index, 'total_items': 0, 'items': [] })(list(ret))
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) collection = common.get_collection('TMLS_Competency') ret = collection.aggregate([{ '$lookup': { 'foreignField': 'value', 'as': 'val_aft', 'from': common.get_collection_name_with_schema('SYS_VW_ValueList'), 'localField': 'apr_form_type' } }, { '$unwind': { 'path': '$val_aft', 'preserveNullAndEmptyArrays': True } }, { '$match': { '$and': [{ '$or': [{ 'val_aft.list_name': None }, { 'val_aft.list_name': 'PERF_AproveFormType' }] }, { '$or': [{ 'val_aft.language': None }, { 'val_aft.language': common.get_language() }] }] } }, { '$lookup': { 'foreignField': 'value', 'as': 'val_pst', 'from': SYS_VW_ValueList().get_collection_name(), 'localField': 'point_scale_type' } }, { '$unwind': { 'path': '$val_pst', 'preserveNullAndEmptyArrays': True } }, { '$match': { '$and': [{ '$or': [{ 'val_pst.list_name': None }, { 'val_pst.list_name': 'PERF_PointScaleType' }] }, { '$or': [{ 'val_pst.language': None }, { 'val_pst.language': common.get_language() }] }] } }, { '$lookup': { 'foreignField': 'com_group_code', 'as': 'group', 'from': common.get_collection_name_with_schema('TMLS_CompetencyGroup'), 'localField': 'com_group_code' } }, { '$unwind': { 'path': '$group', 'preserveNullAndEmptyArrays': True } }, { '$project': { 'com_code': '$com_code', 'level_code': '$group.level_code', 'com_group_code': '$com_group_code', 'com_name': '$com_name', 'com_type': '$com_type', 'apr_form_type': { '$ifNull': ['$val_aft.caption', ''] }, 'point_scale_type': { '$ifNull': ['$val_pst.caption', ''] }, 'ordinal': '$ordinal', 'lock': '$lock' } }, { '$match': { 'lock': common.aggregate_filter_lock(args['data']['lock']), 'level_code': { '$eq': args['data']['com_group_code'] }, '$or': [(lambda x: {} if x == 0 else { "com_type": x })(args['data']['com_type'])] } }, { '$sort': common.aggregate_sort(sort) }, { "$facet": { "metadata": [{ "$count": "total" }, { "$addFields": { "page_index": pageIndex, "page_size": pageSize } }], "data": [{ "$skip": pageSize * pageIndex }, { "$limit": pageSize }] } }, { "$unwind": { "path": '$metadata', "preserveNullAndEmptyArrays": False } }, { "$project": { 'page_size': '$metadata.page_size', 'page_index': '$metadata.page_index', 'total_items': '$metadata.total', 'items': '$data' } }]) return (lambda x: x[0] if x != None and len(x) > 0 else { 'page_size': pageSize, 'page_index': pageIndex, 'total_items': 0, 'items': [] })(list(ret))
def get_list_performance_standanrd(args): try: search = args['data'].get('search', '') if search == None: search = "" page_size = args['data'].get('pageSize', 0) page_index = args['data'].get('pageIndex', 20) sort = args['data'].get('sort', 20) collection = common.get_collection('HCSLS_JobWorking') ret = collection.aggregate([ { '$unwind': { 'path': '$kpi', 'preserveNullAndEmptyArrays': False } }, { '$project': { 'job_w_code': '$job_w_code', 'rec_id': '$kpi.rec_id', 'kpi_code': '$kpi.kpi_code', 'cycle_type': "$kpi.cycle", 'weight': '$kpi.weight', 'unit_code': "$kpi.unit", 'description': '$kpi.description', #'standard_mark': '$kpi.standard_mark', 'score_from': '$kpi.score_from', 'score_to': '$kpi.score_to', 'note': "$kpi.note", 'created_by': '$kpi.created_by', 'created_on': "$kpi.created_on", 'modified_by': '$kpi.modified_by', 'modified_on': "$kpi.modified_on" } }, { '$lookup': { 'foreignField': 'value', 'as': 'val', 'from': common.get_collection_name_with_schema('SYS_VW_ValueList'), 'localField': 'cycle_type' } }, { '$unwind': { 'path': '$val', 'preserveNullAndEmptyArrays': True } }, { '$lookup': { 'foreignField': 'username', 'as': 'uc', 'from': common.get_collection_name_with_schema('auth_user_info'), 'localField': 'created_by' } }, { '$unwind': { 'path': '$uc', 'preserveNullAndEmptyArrays': True } }, { '$lookup': { 'foreignField': 'username', 'as': 'um', 'from': common.get_collection_name_with_schema('auth_user_info'), 'localField': 'modified_by' } }, { '$unwind': { 'path': '$um', 'preserveNullAndEmptyArrays': True } }, { '$match': { '$and': [{ '$or': [{ 'val.list_name': None }, { 'val.list_name': 'LCycleType' }] }, { '$or': [{ 'val.language': None }, { 'val.language': common.get_language() }] }] } }, { '$lookup': { 'foreignField': 'unit_code', 'as': 'unit', 'from': common.get_collection_name_with_schema('HCSLS_Unit'), 'localField': 'unit_code' } }, { '$unwind': { 'path': '$unit', 'preserveNullAndEmptyArrays': True } }, { '$lookup': { 'foreignField': 'kpi_code', 'as': 'h_kpi', 'from': common.get_collection_name_with_schema('TMLS_KPI'), 'localField': 'kpi_code' } }, { '$unwind': { 'path': '$h_kpi', 'preserveNullAndEmptyArrays': True } }, { '$project': { 'job_w_code': '$job_w_code', 'rec_id': '$rec_id', 'kpi_name': '$h_kpi.kpi_name', 'kpi_desc': { '$ifNull': ['$h_kpi.kpi_desc', ''] }, 'cycle_type': { '$ifNull': ['$val.caption', ''] }, 'cycle': '$cycle_type', 'kpi_code': { '$ifNull': ['$kpi_code', ''] }, 'weight': '$weight', 'unit': { '$ifNull': ['$unit.unit_name', ''] }, 'unit_code': '$unit', 'description': "$h_kpi.kpi_desc", #'standard_mark': "$standard_mark", 'score_from': "$score_from", 'score_to': "$score_to", 'note': '$note', 'created_by': { '$ifNull': ['$uc.login_account', ''] }, 'created_on': "$created_on", 'modified_by': { '$ifNull': ['$um.login_account', ''] }, 'modified_on': "$modified_on" } }, { '$match': { "$and": [ { "$or": [ { "kpi_name": { "$regex": search, "$options": 'i' } }, { "unit_code": { "$regex": search, "$options": 'i' } }, { "cycle_type": { "$regex": search, "$options": 'i' } }, { "note": { "$regex": search, "$options": 'i' } }, { "description": { "$regex": search, "$options": 'i' } }, #{ "standard_mark": { "$regex": search, "$options": 'i' } }, { "score_from": { "$regex": search, "$options": 'i' } }, { "score_to": { "$regex": search, "$options": 'i' } } ] }, { "job_w_code": args['data']['job_w_code'] } ] } }, { "$sort": common.aggregate_sort(sort) }, { "$facet": { "metadata": [{ "$count": "total" }, { "$addFields": { "page_index": page_index, "page_size": page_size } }], "data": [{ "$skip": page_size * page_index }, { "$limit": page_size }] } }, { "$unwind": { "path": '$metadata', "preserveNullAndEmptyArrays": False } }, { "$project": { 'page_size': '$metadata.page_size', 'page_index': '$metadata.page_index', 'total_items': '$metadata.total', 'items': '$data' } } ]) return (lambda x: x[0] if x != None and len(x) > 0 else { "page_size": "", "page_index": "", "total_items": 0, "items": [], })(list(ret)) except Exception as ex: raise (ex)