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)
