50 lines
3.5 KiB
SQL
50 lines
3.5 KiB
SQL
update jcl_field_extendgroup set group_name='~`~`7 基础信息`~`8 Basic Information`~`9 基礎信息`~`~' where is_system_default =0 and group_name ='基本信息'
|
|
;
|
|
update jcl_field_extendtitle set title='~`~`7 基本信息`~`8 Basic Information`~`9 基本信息`~`~' where is_system_default =0 and title ='基本信息'
|
|
;
|
|
update jcl_field_extendtitle set title='~`~`7 职责信息`~`8 Duty Information`~`9 職責信息`~`~' where is_system_default =0 and title ='职责信息'
|
|
;
|
|
update jcl_field_extendinfo set field_name_desc='~`~`7 编号`~`8 Number`~`9 編號`~`~' where table_name='JCL_ORG_JOB' and field_name='job_no' and is_system_default = 0
|
|
;
|
|
update jcl_field_extendinfo set field_name_desc='~`~`7 工作概述`~`8 Job Overview`~`9 工作概述`~`~' where table_name='JCL_ORG_JOB' and field_name='description' and is_system_default = 0
|
|
;
|
|
update jcl_field_extendinfo set field_name_desc='~`~`7 名称`~`8 Name`~`9 名稱`~`~' where table_name='JCL_ORG_JOB' and field_name='job_name' and is_system_default = 0
|
|
;
|
|
update jcl_field_extendinfo set field_name_desc='~`~`7 任职职责`~`8 Duty`~`9 任職職責`~`~' where table_name='JCL_ORG_JOB' and field_name='work_duty' and is_system_default = 0
|
|
;
|
|
update jcl_field_extendinfo set field_name_desc='~`~`7 所属部门`~`8 Department`~`9 所屬部門`~`~' where table_name='JCL_ORG_JOB' and field_name='ec_department' and is_system_default = 0
|
|
;
|
|
update jcl_field_extendinfo set field_name_desc='~`~`7 工作权限`~`8 Work Permission`~`9 工作權限`~`~' where table_name='JCL_ORG_JOB' and field_name='work_authority' and is_system_default = 0
|
|
;
|
|
update jcl_field_extendinfo set field_name_desc='~`~`7 所属分部`~`8 SubCompany`~`9 所屬分部`~`~' where table_name='JCL_ORG_JOB' and field_name='ec_company' and is_system_default = 0
|
|
;
|
|
update jcl_field_extendinfo set field_name_desc='~`~`7 是否关键岗`~`8 Is it a critical position`~`9 是否關鍵崗`~`~' where table_name='JCL_ORG_JOB' and field_name='is_key' and is_system_default = 0
|
|
;
|
|
update jcl_field_extendinfo set field_name_desc='~`~`7 工作地点`~`8 Work Location`~`9 工作地點`~`~' where table_name='JCL_ORG_JOB' and field_name='workplace' and is_system_default = 0
|
|
;
|
|
update jcl_field_extendinfo set field_name_desc='~`~`7 禁用标记`~`8 Prohibit Flag`~`9 禁用標記`~`~' where table_name='JCL_ORG_JOB' and field_name='forbidden_tag' and is_system_default = 0
|
|
;
|
|
update jcl_field_extendinfo set field_name_desc='~`~`7 显示顺序`~`8 Display Order`~`9 顯示順序`~`~' where table_name='JCL_ORG_JOB' and field_name='show_order' and is_system_default = 0
|
|
;
|
|
update jcl_field_extendinfo set field_name_desc='~`~`7 所属分部`~`8 SubCompany`~`9 所屬分部`~`~' where table_name='JCL_ORG_JOB' and field_name='parent_comp' and is_system_default = 0
|
|
;
|
|
update jcl_field_extendinfo set field_name_desc='~`~`7 所属部门`~`8 Department`~`9 所屬部門`~`~' where table_name='JCL_ORG_JOB' and field_name='parent_dept' and is_system_default = 0
|
|
;
|
|
update jcl_field_extendinfo set field_name_desc='~`~`7 名称`~`8 Name`~`9 名稱`~`~' where table_name='JCL_ORG_JOB' and field_name='ec_jobTitle' and is_system_default = 0
|
|
;
|
|
update jcl_org_cardbutton set name='~`~`7 详细信息`~`8 Detailed Information`~`9 詳細信息`~`~' where url='/spa/hrm/index_mobx.html#/main/hrm/card/cardInfo/${id}' and sys_default = 0
|
|
;
|
|
update jcl_org_cardbutton set name='~`~`7 人员简历`~`8 Personnel Resume`~`9 人員簡歷`~`~' where url='/spa/organization/static/index.html#/main/organization/personnelResume/${id}' and sys_default = 0
|
|
;
|
|
Delete from LeftMenuInfo where id=100161
|
|
;
|
|
Delete from LeftMenuConfig where infoid=100161
|
|
;
|
|
Delete from LeftMenuInfo where id=100156
|
|
;
|
|
Delete from LeftMenuConfig where infoid=100156
|
|
;
|
|
|
|
|
|
|