def LMSLS_ExTemplateCategory():
global _hasCreated
if not _hasCreated:
_hasCreated=True
ret = db_context.collection("LMSLS_ExTemplateCategory")
return ret
def auth_user_info():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"auth_user_info",
"base",
[["login_account"], ["email"]],
login_account = helpers.create_field("text",True),
username=helpers.create_field("text",True),
display_name=helpers.create_field("text",True),
role_code=helpers.create_field("text"),
email=helpers.create_field("text"),
is_system=helpers.create_field("bool"),
never_expire=helpers.create_field("bool"),
manlevel_from=helpers.create_field("numeric"),
manlevel_to=helpers.create_field("numeric"),
mobile=helpers.create_field("text"),
description=helpers.create_field("text"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("auth_user_info")
return ret
def HCSSYS_ComboboxList():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSSYS_ComboboxList",
"base",
[["combobox_code"]],
combobox_code = helpers.create_field("text",True),
language=helpers.create_field("text", True),
display_name=helpers.create_field("text"),
description=helpers.create_field("text"),
table_name=helpers.create_field("text"),
table_fields=helpers.create_field("list"),
display_fields=helpers.create_field("list"),
predicate=helpers.create_field("list", False, dict(
column = helpers.create_field("string"),
operator = helpers.create_field("string")
)),
value_field=helpers.create_field("text"),
caption_field=helpers.create_field("text"),
sorting_field=helpers.create_field("object"),
filter_field=helpers.create_field("text"),
multi_select=helpers.create_field("bool"),
page_size=helpers.create_field("int"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text"),
)
_hasCreated=True
ret = db_context.collection("HCSSYS_ComboboxList")
return ret
def HCSSYS_ExcelTemplate():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSSYS_ExcelTemplate",
"base", [["function_id"], ["template_code"],
["detail.field_name", "template_code"]],
function_id=helpers.create_field("text", True),
template_code=helpers.create_field("text", True),
template_name=helpers.create_field("text", True),
is_default=helpers.create_field("bool"),
view_name=helpers.create_field("text", True),
detail=helpers.create_field(
"list", False,
dict(field_name=helpers.create_field("text"),
lookup_data=helpers.create_field("text"),
lookup_key_field=helpers.create_field("text"),
lookup_result=helpers.create_field("text"),
allow_null=helpers.create_field("bool"),
is_key=helpers.create_field("bool"),
language=helpers.create_field("text"),
header_text=helpers.create_field("text"),
is_visible=helpers.create_field("bool"),
ordinal=helpers.create_field("numeric"))),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text"))
_hasCreated = True
ret = db_context.collection("HCSSYS_ExcelTemplate")
return ret
def HCSLS_District():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSLS_District",
"base",
[["district_code"], ['province_code']],
district_code = helpers.create_field("text", True),
province_code = helpers.create_field("text", True),
district_name = helpers.create_field("text", True),
district_name2 = helpers.create_field("text"),
type_code = helpers.create_field("text"),
ordinal=helpers.create_field("numeric"),
note=helpers.create_field("text"),
lock=helpers.create_field("bool"),
org_district_code=helpers.create_field("text"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("HCSLS_District")
return ret
def TMLS_RankSub():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"TMLS_RankSub",
"base",
[["rank_code"]],
rec_id = helpers.create_field('text'),
rank_code = helpers.create_field('text'),
change_object = helpers.create_field('numeric'),
object_level = helpers.create_field('numeric'),
object_code = helpers.create_field('text'),
object_name = helpers.create_field('text'),
priority_no = helpers.create_field('numeric'),
total_from = helpers.create_field('numeric'),
total_to = helpers.create_field('numeric'),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("TMLS_RankSub")
return ret
def HCSSYS_Departments():
global _hasCreated
if not _hasCreated:
_hasCreated = True
ret = db_context.collection("HCSSYS_Departments")
return ret
def HCSLS_Certificate():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSLS_Certificate",
"base",
[["cer_code"]],
cer_code=helpers.create_field("text", True),
cer_name=helpers.create_field("text", True),
cer_name2=helpers.create_field("text"),
expired_time=helpers.create_field("numeric"),
group_cer_code=helpers.create_field("text"),
cers_time_limit=helpers.create_field("numeric"),
scer_code=helpers.create_field("text"),
cers_replace_code=helpers.create_field("text"),
ordinal=helpers.create_field("numeric"),
note=helpers.create_field("text"),
lock=helpers.create_field("bool"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("HCSLS_Certificate")
return ret
def HCSSYS_CollectionInfo():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSSYS_CollectionInfo",
"base",
[],
table_name = helpers.create_field("text",True),
field_name=helpers.create_field("text",True),
data_type=helpers.create_field("text",True),
data_length=helpers.create_field("numeric"),
default_value=helpers.create_field("text"),
is_unique=helpers.create_field("bool"),
description=helpers.create_field("text"),
is_parent=helpers.create_field("bool"),
parent_field=helpers.create_field("text"),
field_path=helpers.create_field("text", True),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("HCSSYS_CollectionInfo")
return ret
def LMSLS_ExResultType():
global _hasCreated
if not _hasCreated:
_hasCreated=True
ret = db_context.collection("LMSLS_ExResultType")
return ret
def HCSSYS_SystemConfig():
global _hasCreated
if not _hasCreated:
_hasCreated=True
ret = db_context.collection("HCSSYS_SystemConfig")
return ret
def SYS_FunctionList():
global _hasCreated
if not _hasCreated:
_hasCreated = True
ret = db_context.collection("SYS_FunctionList")
return ret
def HCSLS_Certificate():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSLS_Certificate",
"base",
[["cer_code"]],
cer_code=helpers.create_field("text", True),
cer_name=helpers.create_field("text", True),
cer_name2=helpers.create_field("text"),
expired_time=helpers.create_field("numeric"),
group_cer_code=helpers.create_field("text"),
cers_time_limit=helpers.create_field("numeric"),
scer_code=helpers.create_field("text"),
cers_replace_code=helpers.create_field("text"),
ordinal=helpers.create_field("numeric"),
note=helpers.create_field("text"),
lock=helpers.create_field("bool"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("HCSLS_Certificate")
return ret
def LMSSYS_Value_List():
global _hasCreated
if not _hasCreated:
_hasCreated = True
ret = db_context.collection("LMSSYS_Value_List")
return ret
def LMSLS_MaterialFolder():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"LMSLS_MaterialFolder",
"base",
[["folder_id"]],
#id=helpers.create_field("numeric",True),
folder_id=helpers.create_field("text", True),
folder_name=helpers.create_field("text", True),
folder_name2=helpers.create_field("text"),
parent_id=helpers.create_field("text"),
parent_code=helpers.create_field("text"),
level=helpers.create_field("numeric"),
level_code=helpers.create_field("list"),
ordinal=helpers.create_field("numeric"),
lock=helpers.create_field("bool"),
note=helpers.create_field("text"),
moderator_id=helpers.create_field("text"),
approver_id=helpers.create_field("text"),
active=helpers.create_field("bool"),
approve_type=helpers.create_field("bool"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("LMSLS_MaterialFolder")
return ret
def HCSLS_EmployeeType():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSLS_EmployeeType",
"base",
[["emp_type_code"]],
emp_type_code=helpers.create_field("text", True),
emp_type_name=helpers.create_field("text", True),
emp_type_name2=helpers.create_field("text"),
rate_main_sal=helpers.create_field("numeric"),
rate_soft_sal=helpers.create_field("numeric"),
true_type=helpers.create_field("numeric", True),
# probation_time_by=helpers.create_field("numeric"),
# probation_time=helpers.create_field("text"),
# is_fix=helpers.create_field("numeric"),
# coeff=helpers.create_field("text"),
# begin_date_cal=helpers.create_field("numeric"),
ordinal=helpers.create_field("numeric"),
note=helpers.create_field("text"),
lock=helpers.create_field("bool"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
#department_code=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("HCSLS_EmployeeType")
return ret
def HCSLS_Nation():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSLS_Nation",
"base",
[["nation_code"]],
nation_code=helpers.create_field("text", True),
nation_name=helpers.create_field("text", True),
ordinal=helpers.create_field("numeric"),
note=helpers.create_field("text"),
lock=helpers.create_field("bool"),
continents=helpers.create_field("numeric"),
#eat_amount=helpers.create_field("numeric"),
#home_amount=helpers.create_field("numeric"),
#taxi_amount=helpers.create_field("numeric"),
#sub_days_amount=helpers.create_field("numeric"),
nation_name2=helpers.create_field("text"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text"),
#department_code=helpers.create_field("text"),
org_nation_code=helpers.create_field("text"))
_hasCreated = True
ret = db_context.collection("HCSLS_Nation")
return ret
def LMSLS_MaterialFolder():
global _hasCreated
if not _hasCreated:
_hasCreated = True
ret = db_context.collection("LMSLS_MaterialFolder")
return ret
def HCSSYS_ComboboxList():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSSYS_ComboboxList",
"base",
[["combobox_code"]],
combobox_code=helpers.create_field("text", True),
language=helpers.create_field("text", True),
display_name=helpers.create_field("text"),
description=helpers.create_field("text"),
table_name=helpers.create_field("text"),
table_fields=helpers.create_field("list"),
display_fields=helpers.create_field("list"),
predicate=helpers.create_field(
"list", False,
dict(column=helpers.create_field("string"),
operator=helpers.create_field("string"))),
value_field=helpers.create_field("text"),
caption_field=helpers.create_field("text"),
sorting_field=helpers.create_field("object"),
filter_field=helpers.create_field("text"),
multi_select=helpers.create_field("bool"),
page_size=helpers.create_field("int"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text"),
)
_hasCreated = True
ret = db_context.collection("HCSSYS_ComboboxList")
return ret
def HCSLS_JobWorking():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSLS_JobWorking",
"base",
[["job_w_code"]],
job_w_code = helpers.create_field("text", True),
job_w_name = helpers.create_field("text", True),
job_w_name2 = helpers.create_field("text"),
job_w_duty = helpers.create_field("text"),
gjw_code = helpers.create_field("text", True),
ordinal = helpers.create_field("numeric"),
lock = helpers.create_field("bool"),
is_job_w_main_staff = helpers.create_field("bool"),
report_to_job_w=helpers.create_field("text"),
internal_process = helpers.create_field("text"),
combine_process = helpers.create_field("text"),
description = helpers.create_field("text"),
effect_date = helpers.create_field("date"),
job_pos_code = helpers.create_field("text"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("HCSLS_JobWorking")
return ret
def auth_user_info():
global _hasCreated
if not _hasCreated:
helpers.extent_model("auth_user_info",
"base", [["login_account"], ["email"]],
login_account=helpers.create_field("text", True),
username=helpers.create_field("text", True),
display_name=helpers.create_field("text", True),
role_code=helpers.create_field("text"),
email=helpers.create_field("text"),
is_system=helpers.create_field("bool"),
never_expire=helpers.create_field("bool"),
manlevel_from=helpers.create_field("numeric"),
manlevel_to=helpers.create_field("numeric"),
mobile=helpers.create_field("text"),
description=helpers.create_field("text"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text"))
_hasCreated = True
ret = db_context.collection("auth_user_info")
return ret
def HCSLS_EmployeeType():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSLS_EmployeeType",
"base",
[["emp_type_code"]],
emp_type_code=helpers.create_field("text", True),
emp_type_name=helpers.create_field("text", True),
emp_type_name2=helpers.create_field("text"),
rate_main_sal=helpers.create_field("numeric"),
rate_soft_sal=helpers.create_field("numeric"),
true_type=helpers.create_field("numeric", True),
# probation_time_by=helpers.create_field("numeric"),
# probation_time=helpers.create_field("text"),
# is_fix=helpers.create_field("numeric"),
# coeff=helpers.create_field("text"),
# begin_date_cal=helpers.create_field("numeric"),
ordinal=helpers.create_field("numeric"),
note=helpers.create_field("text"),
lock=helpers.create_field("bool"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
#department_code=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("HCSLS_EmployeeType")
return ret
def HCSLS_Nation():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSLS_Nation",
"base",
[["nation_code"]],
nation_code=helpers.create_field("text", True),
nation_name=helpers.create_field("text", True),
ordinal=helpers.create_field("numeric"),
note=helpers.create_field("text"),
lock=helpers.create_field("bool"),
continents=helpers.create_field("numeric"),
#eat_amount=helpers.create_field("numeric"),
#home_amount=helpers.create_field("numeric"),
#taxi_amount=helpers.create_field("numeric"),
#sub_days_amount=helpers.create_field("numeric"),
nation_name2=helpers.create_field("text"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text"),
#department_code=helpers.create_field("text"),
org_nation_code=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("HCSLS_Nation")
return ret
def HCSLS_Award():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSLS_Award",
"base",
[["award_code"]],
award_code = helpers.create_field("text", True),
award_name = helpers.create_field("text", True),
award_name2 = helpers.create_field("text"),
ordinal = helpers.create_field("numeric"),
note = helpers.create_field("text"),
lock=helpers.create_field("bool"),
award_level_code=helpers.create_field("text"),
award_place_code = helpers.create_field("text"),
award_type = helpers.create_field("numeric"),
is_team = helpers.create_field("bool"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("HCSLS_Award")
return ret
def HCSSYS_ExcelTemplate():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSSYS_ExcelTemplate",
"base",
[["function_id"], ["template_code"], ["detail.field_name", "template_code"]],
function_id=helpers.create_field("text", True),
template_code=helpers.create_field("text", True),
template_name=helpers.create_field("text", True),
is_default=helpers.create_field("bool"),
view_name=helpers.create_field("text", True),
detail=helpers.create_field("list",False,dict(
field_name = helpers.create_field("text"),
lookup_data = helpers.create_field("text"),
lookup_key_field = helpers.create_field("text"),
lookup_result = helpers.create_field("text"),
allow_null = helpers.create_field("bool"),
is_key = helpers.create_field("bool"),
language = helpers.create_field("text"),
header_text = helpers.create_field("text"),
is_visible = helpers.create_field("bool"),
ordinal = helpers.create_field("numeric")
)),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("HCSSYS_ExcelTemplate")
return ret
def SYS_FunctionList():
global _hasCreated
if not _hasCreated:
helpers.define_model(
"SYS_FunctionList",
[["function_id"]],
sorting=helpers.create_field("text"),
description=helpers.create_field("text"),
custom_name=helpers.create_field("text"),
style_class=helpers.create_field("text"),
url=helpers.create_field("text"),
image=helpers.create_field("text"),
default_name=helpers.create_field("text", True),
height=helpers.create_field("text"),
parent_id=helpers.create_field("text"),
active=helpers.create_field("bool"),
function_id=helpers.create_field("text", True),
type=helpers.create_field("text"),
width=helpers.create_field("text"),
icon=helpers.create_field("text"),
app=helpers.create_field("text"),
level_code=helpers.create_field("list")
)
_hasCreated=True
ret = db_context.collection("SYS_FunctionList")
return ret
def HCSLS_Province():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSLS_Province",
"base",
[["province_code"]],
province_code=helpers.create_field("text",True),
province_name=helpers.create_field("text", True),
province_name2=helpers.create_field("text"),
type_code=helpers.create_field("text"),
region_code=helpers.create_field("text"),
nation_code=helpers.create_field("text"),
ordinal=helpers.create_field("numeric"),
note=helpers.create_field("text"),
lock=helpers.create_field("bool"),
org_province_code=helpers.create_field("text"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("HCSLS_Province")
return ret
def HCSSYS_ComboboxList():
global _hasCreated
if not _hasCreated:
_hasCreated = True
ret = db_context.collection("HCSSYS_ComboboxList")
return ret
def HCSLS_Acadame():
global _hasCreated
if not _hasCreated:
"""
#is_fix: Hệ số cố định
#coeff: #Thiết lập theo
#coeff: #Ngày bắt đầu tính thâm niên
"""
helpers.extent_model(
"HCSLS_Acadame",
"base",
[["train_level_code"]],
train_level_code=helpers.create_field("text",True),
train_level_name=helpers.create_field("text"),
range=helpers.create_field("numeric"),
ordinal=helpers.create_field("numeric"),
note=helpers.create_field("text"),
#train_cof=helpers.create_field("numeric"),
is_fix=helpers.create_field("numeric"),
coeff=helpers.create_field("numeric"),
begin_date_cal=helpers.create_field("numeric"),
lock=helpers.create_field("bool"),
train_level_name2=helpers.create_field("text"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text"),
details=helpers.create_field("list",False,dict(
rec_id = helpers.create_field("text"),
seniority_from = helpers.create_field("numeric"),
seniority_to = helpers.create_field("numeric"),
coefficient = helpers.create_field("numeric"),
salary = helpers.create_field("numeric"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
))
)
_hasCreated=True
#def on_before_insert(data):
# before_process
#def on_before_update(data):
# before_process(data)
#def before_process(data):
# data.update({
# "detail": [{
# "department_code":x['_id'],
# } for x in data.get('detail',[])]
# })
#helpers.events("HCSLS_Acadame").on_before_insert(on_before_insert).on_before_update(on_before_update)
ret = db_context.collection("HCSLS_Acadame")
return ret
def HCSLS_Acadame():
global _hasCreated
if not _hasCreated:
"""
#is_fix: Hệ số cố định
#coeff: #Thiết lập theo
#coeff: #Ngày bắt đầu tính thâm niên
"""
helpers.extent_model(
"HCSLS_Acadame",
"base",
[["train_level_code"]],
train_level_code=helpers.create_field("text",True),
train_level_name=helpers.create_field("text"),
range=helpers.create_field("numeric"),
ordinal=helpers.create_field("numeric"),
note=helpers.create_field("text"),
#train_cof=helpers.create_field("numeric"),
is_fix=helpers.create_field("numeric"),
coeff=helpers.create_field("numeric"),
begin_date_cal=helpers.create_field("numeric"),
lock=helpers.create_field("bool"),
train_level_name2=helpers.create_field("text"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text"),
details=helpers.create_field("list",False,dict(
rec_id = helpers.create_field("text"),
seniority_from = helpers.create_field("numeric"),
seniority_to = helpers.create_field("numeric"),
coefficient = helpers.create_field("numeric"),
salary = helpers.create_field("numeric"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
))
)
_hasCreated=True
#def on_before_insert(data):
# before_process
#def on_before_update(data):
# before_process(data)
#def before_process(data):
# data.update({
# "detail": [{
# "department_code":x['_id'],
# } for x in data.get('detail',[])]
# })
#helpers.events("HCSLS_Acadame").on_before_insert(on_before_insert).on_before_update(on_before_update)
ret = db_context.collection("HCSLS_Acadame")
return ret
def HCSEM_Employees():
global _hasCreated
if not _hasCreated:
dict_permission = dict()
_hasCreated = True
ret = db_context.collection("HCSEM_Employees")
return ret
def HCSSYS_Departments():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSSYS_Departments",
"base",
[["department_code"]],
#id=helpers.create_field("numeric",True),
department_code=helpers.create_field("text", True),
department_name=helpers.create_field("text", True),
department_name2=helpers.create_field("text"),
department_alias=helpers.create_field("text"),
#parent_id=helpers.create_field("numeric"),
parent_code=helpers.create_field("text"),
level=helpers.create_field("numeric"),
level_code=helpers.create_field("list"),
#level_code2=helpers.create_field("text"),
department_tel=helpers.create_field("text"),
department_fax=helpers.create_field("text"),
department_email=helpers.create_field("text"),
department_address=helpers.create_field("text"),
#Xem lại kiểu dữ liệu
nation_code=helpers.create_field("text"),
province_code=helpers.create_field("text"),
district_code=helpers.create_field("text"),
is_company=helpers.create_field("bool"),
is_fund=helpers.create_field("bool"),
is_fund_bonus=helpers.create_field("bool"),
decision_no=helpers.create_field("text"),
decision_date=helpers.create_field("date"),
effect_date=helpers.create_field("date"),
license_no=helpers.create_field("text"),
tax_code=helpers.create_field("text"),
lock_date=helpers.create_field("date"),
logo_image=helpers.create_field("text"),
manager_code=helpers.create_field("text"),
secretary_code=helpers.create_field("text"),
ordinal=helpers.create_field("text"),
lock=helpers.create_field("bool"),
note=helpers.create_field("text"),
region_code=helpers.create_field("text"),
domain_code=helpers.create_field("text"),
signed_by=helpers.create_field("text"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("HCSSYS_Departments")
return ret
def HCSSYS_Departments():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSSYS_Departments",
"base",
[["department_code"]],
#id=helpers.create_field("numeric",True),
department_code=helpers.create_field("text", True),
department_name=helpers.create_field("text", True),
department_name2=helpers.create_field("text"),
department_alias=helpers.create_field("text"),
#parent_id=helpers.create_field("numeric"),
parent_code=helpers.create_field("text"),
level=helpers.create_field("numeric"),
level_code=helpers.create_field("list"),
#level_code2=helpers.create_field("text"),
department_tel=helpers.create_field("text"),
department_fax=helpers.create_field("text"),
department_email=helpers.create_field("text"),
department_address=helpers.create_field("text"),
#Xem lại kiểu dữ liệu
nation_code=helpers.create_field("text"),
province_code=helpers.create_field("text"),
district_code=helpers.create_field("text"),
is_company=helpers.create_field("bool"),
is_fund=helpers.create_field("bool"),
is_fund_bonus=helpers.create_field("bool"),
decision_no=helpers.create_field("text"),
decision_date=helpers.create_field("date"),
effect_date=helpers.create_field("date"),
license_no=helpers.create_field("text"),
tax_code=helpers.create_field("text"),
lock_date=helpers.create_field("date"),
logo_image=helpers.create_field("text"),
manager_code=helpers.create_field("text"),
secretary_code=helpers.create_field("text"),
ordinal=helpers.create_field("text"),
lock=helpers.create_field("bool"),
note=helpers.create_field("text"),
region_code=helpers.create_field("text"),
domain_code=helpers.create_field("text"),
signed_by=helpers.create_field("text"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("HCSSYS_Departments")
return ret
def HCSLS_Position():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSLS_Position",
"base",
[["job_pos_code"]],
job_pos_code=helpers.create_field("text",True),
job_pos_name=helpers.create_field("text", True),
job_pos_name2=helpers.create_field("text"),
man_level=helpers.create_field("numeric", True),
ordinal=helpers.create_field("numeric"),
note=helpers.create_field("text"),
is_fix=helpers.create_field("numeric"),
coeff=helpers.create_field("numeric"),
begin_date_cal=helpers.create_field("numeric"),
lock=helpers.create_field("bool"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text"),
details=helpers.create_field("list",False,dict(
rec_id = helpers.create_field("text"),
seniority_from = helpers.create_field("numeric"),
seniority_to = helpers.create_field("numeric"),
coefficient = helpers.create_field("numeric"),
salary = helpers.create_field("numeric"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
))
)
_hasCreated=True
#def on_before_insert(data):
# before_process
#def on_before_update(data):
# before_process(data)
#def before_process(data):
# data.update({
# "detail": [{
# "department_code":x['_id'],
# } for x in data.get('detail',[])]
# })
#helpers.events("HCSLS_Acadame").on_before_insert(on_before_insert).on_before_update(on_before_update)
ret = db_context.collection("HCSLS_Position")
return ret
def HCSLS_Position():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSLS_Position",
"base", [["job_pos_code"]],
job_pos_code=helpers.create_field("text", True),
job_pos_name=helpers.create_field("text", True),
job_pos_name2=helpers.create_field("text"),
man_level=helpers.create_field("numeric", True),
ordinal=helpers.create_field("numeric"),
note=helpers.create_field("text"),
is_fix=helpers.create_field("numeric"),
coeff=helpers.create_field("numeric"),
begin_date_cal=helpers.create_field("numeric"),
lock=helpers.create_field("bool"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text"),
details=helpers.create_field(
"list", False,
dict(rec_id=helpers.create_field("text"),
seniority_from=helpers.create_field("numeric"),
seniority_to=helpers.create_field("numeric"),
coefficient=helpers.create_field("numeric"),
salary=helpers.create_field("numeric"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text"))))
_hasCreated = True
#def on_before_insert(data):
# before_process
#def on_before_update(data):
# before_process(data)
#def before_process(data):
# data.update({
# "detail": [{
# "department_code":x['_id'],
# } for x in data.get('detail',[])]
# })
#helpers.events("HCSLS_Acadame").on_before_insert(on_before_insert).on_before_update(on_before_update)
ret = db_context.collection("HCSLS_Position")
return ret
def HCSSYS_SystemConfig():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSSYS_SystemConfig",
"base",
[],
is_has_number=helpers.create_field("bool"),
num_of_number=helpers.create_field("numeric"),
is_has_upper_char=helpers.create_field("bool"),
num_of_upper=helpers.create_field("numeric"),
is_has_lower_char=helpers.create_field("bool"),
num_of_lower=helpers.create_field("numeric"),
is_has_symbols=helpers.create_field("bool"),
num_of_symbol=helpers.create_field("numeric"),
is_ad_aut=helpers.create_field("bool"),
session_timeOut=helpers.create_field("numeric"),
time_out_expand=helpers.create_field("numeric"),
minimum_age=helpers.create_field("numeric"),
password_expiration=helpers.create_field("numeric"),
will_expire=helpers.create_field("bool"),
change_after=helpers.create_field("numeric"),
apply_minimum_age=helpers.create_field("bool"),
apply_history=helpers.create_field("bool"),
history=helpers.create_field("numeric"),
apply_minLength=helpers.create_field("bool"),
min_len=helpers.create_field("numeric"),
apply_maxLength=helpers.create_field("bool"),
max_len=helpers.create_field("numeric"),
lock_on_failed=helpers.create_field("bool"),
threshold_to_lock=helpers.create_field("numeric"),
time_lock=helpers.create_field("numeric"),
alert_before=helpers.create_field("numeric"),
is_first_change=helpers.create_field("bool"),
not_user_in_password=helpers.create_field("bool"),
date_format=helpers.create_field("text"),
dec_place_separator=helpers.create_field("text"),
dec_place_currency=helpers.create_field("numeric"),
default_language=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("HCSSYS_SystemConfig")
return ret
def HCSSYS_SystemConfig():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSSYS_SystemConfig",
"base",
[],
is_has_number=helpers.create_field("bool"),
num_of_number=helpers.create_field("numeric"),
is_has_upper_char=helpers.create_field("bool"),
num_of_upper=helpers.create_field("numeric"),
is_has_lower_char=helpers.create_field("bool"),
num_of_lower=helpers.create_field("numeric"),
is_has_symbols=helpers.create_field("bool"),
num_of_symbol=helpers.create_field("numeric"),
is_ad_aut=helpers.create_field("bool"),
session_timeOut=helpers.create_field("numeric"),
time_out_expand=helpers.create_field("numeric"),
minimum_age=helpers.create_field("numeric"),
password_expiration=helpers.create_field("numeric"),
will_expire=helpers.create_field("bool"),
change_after=helpers.create_field("numeric"),
apply_minimum_age=helpers.create_field("bool"),
apply_history=helpers.create_field("bool"),
history=helpers.create_field("numeric"),
apply_minLength=helpers.create_field("bool"),
min_len=helpers.create_field("numeric"),
apply_maxLength=helpers.create_field("bool"),
max_len=helpers.create_field("numeric"),
lock_on_failed=helpers.create_field("bool"),
threshold_to_lock=helpers.create_field("numeric"),
time_lock=helpers.create_field("numeric"),
alert_before=helpers.create_field("numeric"),
is_first_change=helpers.create_field("bool"),
not_user_in_password=helpers.create_field("bool"),
date_format=helpers.create_field("text"),
dec_place_separator=helpers.create_field("text"),
dec_place_currency=helpers.create_field("numeric"),
default_language=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("HCSSYS_SystemConfig")
return ret
def LMS_SetupProcessApproveLevel():
global _hasCreated
if not _hasCreated:
def on_before_insert(data):
data.update({
"rec_id": common.generate_guid()
})
def on_before_update(data):
pass
helpers.events("LMS_SetupProcessApproveLevel").on_before_insert(on_before_insert).on_before_update(on_before_update)
_hasCreated=True
ret = db_context.collection("LMS_SetupProcessApproveLevel")
return ret
def HCSLS_Acadame():
# _hasCreated=True
# #def on_before_insert(data):
# # before_process
#
# #def on_before_update(data):
# # before_process(data)
#
# #def before_process(data):
# # data.update({
# # "detail": [{
# # "department_code":x['_id'],
# # } for x in data.get('detail',[])]
# # })
#
# #helpers.events("HCSLS_Acadame").on_before_insert(on_before_insert).on_before_update(on_before_update)
ret = db_context.collection("HCSLS_Acadame")
return ret
def TMLS_Rank():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"TMLS_Rank",
"base",
[["rank_code"]],
rank_code = helpers.create_field('text', True),
rank_name = helpers.create_field('text', True),
rank_name2 = helpers.create_field('text'),
rank_content = helpers.create_field('text'),
total_from = helpers.create_field('numeric'),
total_to = helpers.create_field('numeric'),
is_change_object = helpers.create_field('bool'),
ordinal = helpers.create_field('numeric'),
lock = helpers.create_field('bool'),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text"),
#TMLS_RankSub
details=helpers.create_field("list",False,dict(
rec_id = helpers.create_field('text'),# True),
rank_code = helpers.create_field('text'),# True),
change_object = helpers.create_field('numeric'),# True),
object_level = helpers.create_field('numeric'),
object_code = helpers.create_field('text'),# True),
object_name = helpers.create_field('text'),
priority_no = helpers.create_field('numeric'),
total_from = helpers.create_field('numeric'),
total_to = helpers.create_field('numeric'),
note = helpers.create_field('text'),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
))
)
_hasCreated=True
ret = db_context.collection("TMLS_Rank")
return ret
def HCSLS_TrainDomain():
global _hasCreated
if not _hasCreated:
helpers.extent_model("HCSLS_TrainDomain",
"base", [["domain_code"]],
domain_code=helpers.create_field("text", True),
domain_name=helpers.create_field("text", True),
ordinal=helpers.create_field("numeric"),
note=helpers.create_field("text"),
lock=helpers.create_field("bool"),
domain_name2=helpers.create_field("text"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text"))
_hasCreated = True
ret = db_context.collection("HCSLS_TrainDomain")
return ret
def tmp_transactions():
global _hasCreated
if not _hasCreated:
helpers.define_model(
"tmp_transactions",
[["transaction_id"]],
transaction_id=helpers.create_field("text", True),
collection_name=heplers.create_field("text", True),
path=helpers.create_field("text", True),
session=helpers.create_field("text", True),
ordinal=helpers.create_field("numeric"),
data=helpers.create_field("text"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
)
_hasCreated = True
ret = db_context.collection("tmp_transactions")
return ret
def tmp_transactions():
global _hasCreated
if not _hasCreated:
helpers.define_model(
"tmp_transactions",
[["transaction_id"]],
transaction_id=helpers.create_field("text", True),
collection_name=heplers.create_field("text", True),
path=helpers.create_field("text", True),
session=helpers.create_field("text", True),
ordinal=helpers.create_field("numeric"),
data=helpers.create_field("text"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
)
_hasCreated=True
ret = db_context.collection("tmp_transactions")
return ret
def HCSLS_JobWorkingGroup():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSLS_JobWorkingGroup",
"base", [["gjw_code"]],
gjw_code=helpers.create_field("text", True),
gjw_name=helpers.create_field("text", True),
gjw_name2=helpers.create_field("text"),
ordinal=helpers.create_field("numeric"),
note=helpers.create_field("text"),
lock=helpers.create_field("bool"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text"),
details=helpers.create_field(
"list", False,
dict(job_w_code=helpers.create_field("text", True),
job_w_name=helpers.create_field("text", True),
job_w_name2=helpers.create_field("text"),
job_w_duty=helpers.create_field("text"),
gjw_code=helpers.create_field("text", True),
ordinal=helpers.create_field("numeric"),
lock=helpers.create_field("bool"),
is_job_w_main_staff=helpers.create_field("bool"),
report_to_job_w=helpers.create_field("text"),
internal_process=helpers.create_field("text"),
combine_process=helpers.create_field("text"),
description=helpers.create_field("text"),
job_w_work=helpers.create_field("text"),
effect_date=helpers.create_field("date"),
job_pos_cod=helpers.create_field("text"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text"))))
_hasCreated = True
ret = db_context.collection("HCSLS_JobWorkingGroup")
return ret
def HCSLS_Discipline():
global _hasCreated
if not _hasCreated:
helpers.extent_model("HCSLS_Discipline",
"base", [["disc_code"]],
disc_code=helpers.create_field("text", True),
disc_name=helpers.create_field("text", True),
is_due_salary=helpers.create_field("bool"),
ordinal=helpers.create_field("numeric"),
note=helpers.create_field("text"),
lock=helpers.create_field("bool"),
disc_name2=helpers.create_field("text"),
created_on=helpers.create_field("text"),
created_by=helpers.create_field("date"),
modified_on=helpers.create_field("text"),
modified_by=helpers.create_field("date"))
_hasCreated = True
ret = db_context.collection("HCSLS_Discipline")
return ret
def HCSLANG_CollectionInfo():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSLANG_CollectionInfo",
"base",
[],
language = helpers.create_field("text",True),
field_path=helpers.create_field("text",True),
default_caption=helpers.create_field("text",True),
custom_caption=helpers.create_field("text"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("HCSLANG_CollectionInfo")
return ret
def HCSLS_QuitJob():
global _hasCreated
if not _hasCreated:
helpers.extent_model("HCSLS_QuitJob",
"base", [["quit_job_code"]],
quit_job_code=helpers.create_field("text", True),
quit_job_name=helpers.create_field("text", True),
quit_type=helpers.create_field("numeric"),
ordinal=helpers.create_field("numeric"),
note=helpers.create_field("text"),
lock=helpers.create_field("bool"),
quit_job_name2=helpers.create_field("text"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text"))
_hasCreated = True
ret = db_context.collection("HCSLS_QuitJob")
return ret
def SYS_ValueList():
global _hasCreated
if not _hasCreated:
helpers.define_model("SYS_ValueList", [["language", "list_name"]],
language=helpers.create_field("text"),
list_name=helpers.create_field("text"),
values=helpers.create_field(
"list", False,
dict(value=helpers.create_field("numeric"),
caption=helpers.create_field("text"),
custom=helpers.create_field("text"))),
multi_select=helpers.create_field("bool"),
description=helpers.create_field("text"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text"))
_hasCreated = True
ret = db_context.collection("SYS_ValueList")
return ret
def HCSLS_AwardPlace():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSLS_AwardPlace",
"base", [["award_place_code"]],
award_place_code=helpers.create_field("text", True),
award_place_name=helpers.create_field("text", True),
award_place_name2=helpers.create_field("text"),
ordinal=helpers.create_field("numeric"),
note=helpers.create_field("text"),
lock=helpers.create_field("bool"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text"))
_hasCreated = True
ret = db_context.collection("HCSLS_AwardPlace")
return ret
def HCSLS_Marital():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSLS_Marital",
"base",
[["marital_code"]],
marital_code=helpers.create_field("text", True),
marital_name=helpers.create_field("text", True),
ordinal=helpers.create_field("numeric"),
note=helpers.create_field("text"),
lock=helpers.create_field("bool"),
marital_name2=helpers.create_field("text"),
created_on=helpers.create_field("text"),
created_by=helpers.create_field("date"),
modified_on=helpers.create_field("text"),
modified_by=helpers.create_field("date")
)
_hasCreated=True
ret = db_context.collection("HCSLS_Marital")
return ret
def auth_user():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"auth_user",
"base",
[["username"]],
username=helpers.create_field("text",True),
first_name=helpers.create_field("text"),
last_name=helpers.create_field("text"),
is_active=helpers.create_field("bool"),
email=helpers.create_field("text"),
is_superuser=helpers.create_field("bool"),
is_staff=helpers.create_field("bool"),
last_login=helpers.create_field("date"),
password=helpers.create_field("text"),
date_joined=helpers.create_field("date")
)
_hasCreated=True
ret = db_context.collection("auth_user")
return ret
def HCSLS_TrainTypeDetail():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSLS_TrainTypeDetail",
"base",
[["train_detail_code"]],
train_detail_code=helpers.create_field("text", True),
train_detail_name=helpers.create_field("text", True),
train_detail_name2=helpers.create_field("text"),
ordinal=helpers.create_field("numeric"),
note=helpers.create_field("text"),
lock=helpers.create_field("bool"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
#department_code=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("HCSLS_TrainTypeDetail")
return ret
def HCSSYS_DataDomain():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSSYS_DataDomain",
"base",
[["dd_code"]],
dd_code=helpers.create_field("text",True),
dd_name=helpers.create_field("text"),
access_mode=helpers.create_field("numeric"),
description=helpers.create_field("text"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text"),
detail=helpers.create_field("list",False,dict(
department_code = helpers.create_field("text"),
))
)
def on_before_insert(data):
before_process
def on_before_update(data):
before_process(data)
def before_process(data):
data.update({
"detail": [{
"department_code":x['department_code'],
} for x in data.get('detail',[])]
})
helpers.events("HCSSYS_DataDomain").on_before_insert(on_before_insert).on_before_update(on_before_update)
_hasCreated=True
ret = db_context.collection("HCSSYS_DataDomain")
return ret
def HCSLS_Ethnic():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"HCSLS_Ethnic",
"base",
[["ethnic_code"]],
ethnic_code=helpers.create_field("text", True),
ethnic_name=helpers.create_field("text", True),
range=helpers.create_field("numeric"),
ordinal=helpers.create_field("numeric"),
note=helpers.create_field("text"),
lock=helpers.create_field("bool"),
ethnic_name2=helpers.create_field("text"),
is_ethnic_minority=helpers.create_field("bool"),
created_on=helpers.create_field("text"),
created_by=helpers.create_field("date"),
modified_on=helpers.create_field("text"),
modified_by=helpers.create_field("date")
)
_hasCreated=True
ret = db_context.collection("HCSLS_Ethnic")
return ret
def SYS_ValueList():
global _hasCreated
if not _hasCreated:
helpers.define_model(
"SYS_ValueList",
[["language", "list_name"]],
language=helpers.create_field("text"),
list_name=helpers.create_field("text"),
values=helpers.create_field("list",False,dict(
value = helpers.create_field("numeric"),
caption = helpers.create_field("text"),
custom = helpers.create_field("text")
)),
multi_select=helpers.create_field("bool"),
description=helpers.create_field("text"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("SYS_ValueList")
return ret
def TMSYS_ConfigChangeObjectPriority():
global _hasCreated
if not _hasCreated:
helpers.extent_model(
"TMSYS_ConfigChangeObjectPriority",
"base",
[[]],
value_list_key = helpers.create_field('text'),
change_object = helpers.create_field('numeric'),
change_object_name = helpers.create_field('text'),
priority_no = helpers.create_field('numeric'),
table_name = helpers.create_field('text'),
note = helpers.create_field('text'),
language = helpers.create_field('numeric'),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("TMSYS_ConfigChangeObjectPriority")
return ret
def HCSEM_Employees():
global _hasCreated
if not _hasCreated:
dict_permission = dict()
helpers.extent_model(
"HCSEM_Employees",
"base",
[["employee_code"]],
photo_id=helpers.create_field("text"),
employee_code=helpers.create_field("text", True),
last_name=helpers.create_field("text", True),
first_name=helpers.create_field("text", True),
extra_name=helpers.create_field("text"),
gender=helpers.create_field("numeric"),
birthday=helpers.create_field("date"),
b_province_code=helpers.create_field("text"),
nation_code=helpers.create_field("text"),
ethnic_code=helpers.create_field("text"),
religion_code=helpers.create_field("text"),
culture_id=helpers.create_field("numeric"),
is_retrain=helpers.create_field("numeric"),
train_level_code=helpers.create_field("text"),
marital_code=helpers.create_field("text"),
id_card_no=helpers.create_field("text"),
issued_date=helpers.create_field("date"),
issued_place_code=helpers.create_field("text"),
mobile=helpers.create_field("text"),
p_phone=helpers.create_field("text"),
email=helpers.create_field("text"),
personal_email=helpers.create_field("text"),
document_no=helpers.create_field("text"),
join_date=helpers.create_field("date", True),
official_date=helpers.create_field("date"),
career_date=helpers.create_field("date"),
personnel_date=helpers.create_field("date"),
emp_type_code=helpers.create_field("text"),
labour_type=helpers.create_field("numeric"),
department_code=helpers.create_field("text", True),
job_pos_code=helpers.create_field("text"),
job_pos_date=helpers.create_field("date"),
job_w_code=helpers.create_field("text", True),
job_w_date=helpers.create_field("date"),
profession_code=helpers.create_field("text"),
level_management=helpers.create_field("numeric"),
is_cbcc=helpers.create_field("bool"),
is_expert_recruit=helpers.create_field("bool"),
is_expert_train=helpers.create_field("bool"),
manager_code=helpers.create_field("text"),
manager_sub_code=helpers.create_field("text"),
user_id=helpers.create_field("text"),
job_pos_hold_code=helpers.create_field("text"),
job_w_hold_code=helpers.create_field("text"),
department_code_hold=helpers.create_field("text"),
job_pos_hold_from_date=helpers.create_field("date"),
job_pos_hold_to_date=helpers.create_field("date"),
end_date=helpers.create_field("date"),
retire_ref_no=helpers.create_field("text"),
signed_date=helpers.create_field("date"),
signed_person=helpers.create_field("text"),
active=helpers.create_field("bool"),
note=helpers.create_field("text"),
p_address=helpers.create_field("text"),
p_province_code=helpers.create_field("text"),
p_district_code=helpers.create_field("text"),
p_ward_code=helpers.create_field("text"),
p_hamlet_code=helpers.create_field("text"),
t_address=helpers.create_field("text"),
t_province_code=helpers.create_field("text"),
t_district_code=helpers.create_field("text"),
t_ward_code=helpers.create_field("text"),
t_hamlet_code=helpers.create_field("text"),
foreigner=helpers.create_field("bool"),
vn_foreigner=helpers.create_field("bool"),
is_not_reside=helpers.create_field("bool"),
fo_working=helpers.create_field("numeric"),
fo_permiss=helpers.create_field("text"),
fo_begin_date=helpers.create_field("date"),
fo_end_date=helpers.create_field("date"),
created_on=helpers.create_field("date"),
created_by=helpers.create_field("text"),
modified_on=helpers.create_field("date"),
modified_by=helpers.create_field("text")
)
_hasCreated=True
ret = db_context.collection("HCSEM_Employees")
return ret
