62 lines
6.1 KiB
SQL
62 lines
6.1 KiB
SQL
alter table jcl_org_custom_template add overall int;
|
|
|
|
delete from HtmlLabelIndex where id = 547857 and ( indexdesc is null or indexdesc = '' )
|
|
;
|
|
insert into HtmlLabelIndex(id,indexdesc) select 547857,'该模板字段内容仅管理员可操作，即将返回默认设置值' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 547857 and ( indexdesc is not null and indexdesc <> '' )) limit 1
|
|
;
|
|
delete from HtmlLabelInfo where indexid = 547857 and languageid=7 and ( labelname is null or labelname = '' )
|
|
;
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547857 as indexid ,'该模板字段内容仅管理员可操作，即将返回默认设置值' as content,7 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547857 and languageid=7 and ( labelname is not null and labelname <> '' )) limit 1
|
|
;
|
|
delete from HtmlLabelInfo where indexid = 547857 and languageid=8 and ( labelname is null or labelname = '' or length(labelname)!=char_length(labelname) )
|
|
;
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547857 as indexid ,'The content of this Templates field can only be operation by the administrator, and will return to the default Settings value' as content,8 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547857 and languageid=8 and ( labelname is not null and labelname <> '' and length(labelname)=char_length(labelname) )) limit 1
|
|
;
|
|
delete from HtmlLabelInfo where indexid = 547857 and languageid=9 and ( labelname is null or labelname = '' )
|
|
;
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547857 as indexid ,'該模板字段內容僅管理員可操作，即將返回默認設置值' as content,9 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547857 and languageid=9 and ( labelname is not null and labelname <> '' )) limit 1
|
|
;
|
|
delete from HtmlModuleLabel where indexId = 547857 and moduleCode = 'HRM' and type = 'label'
|
|
;
|
|
insert into HtmlModuleLabel(type,moduleCode,indexId) values ('label','HRM',547857)
|
|
;
|
|
delete from HtmlLabelIndex where id = 547854 and ( indexdesc is null or indexdesc = '' )
|
|
;
|
|
insert into HtmlLabelIndex(id,indexdesc) select 547854,'默认模板不可应用,请选择其它模板' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 547854 and ( indexdesc is not null and indexdesc <> '' )) limit 1
|
|
;
|
|
delete from HtmlLabelInfo where indexid = 547854 and languageid=7 and ( labelname is null or labelname = '' )
|
|
;
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547854 as indexid ,'默认模板不可应用,请选择其它模板' as content,7 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547854 and languageid=7 and ( labelname is not null and labelname <> '' )) limit 1
|
|
;
|
|
delete from HtmlLabelInfo where indexid = 547854 and languageid=8 and ( labelname is null or labelname = '' or length(labelname)!=char_length(labelname) )
|
|
;
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547854 as indexid ,'The default Templates cannot be Applications. Please select another Templates' as content,8 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547854 and languageid=8 and ( labelname is not null and labelname <> '' and length(labelname)=char_length(labelname) )) limit 1
|
|
;
|
|
delete from HtmlLabelInfo where indexid = 547854 and languageid=9 and ( labelname is null or labelname = '' )
|
|
;
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547854 as indexid ,'默認模板不可應用,請選擇其它模板' as content,9 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547854 and languageid=9 and ( labelname is not null and labelname <> '' )) limit 1
|
|
;
|
|
delete from HtmlModuleLabel where indexId = 547854 and moduleCode = 'HRM' and type = 'label'
|
|
;
|
|
insert into HtmlModuleLabel(type,moduleCode,indexId) values ('label','HRM',547854)
|
|
;
|
|
delete from HtmlLabelIndex where id = 547853 and ( indexdesc is null or indexdesc = '' )
|
|
;
|
|
insert into HtmlLabelIndex(id,indexdesc) select 547853,'将当前模板应用所有人' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 547853 and ( indexdesc is not null and indexdesc <> '' )) limit 1
|
|
;
|
|
delete from HtmlLabelInfo where indexid = 547853 and languageid=7 and ( labelname is null or labelname = '' )
|
|
;
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547853 as indexid ,'将当前模板应用所有人' as content,7 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547853 and languageid=7 and ( labelname is not null and labelname <> '' )) limit 1
|
|
;
|
|
delete from HtmlLabelInfo where indexid = 547853 and languageid=8 and ( labelname is null or labelname = '' or length(labelname)!=char_length(labelname) )
|
|
;
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547853 as indexid ,'Applications the current Templates to everyone' as content,8 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547853 and languageid=8 and ( labelname is not null and labelname <> '' and length(labelname)=char_length(labelname) )) limit 1
|
|
;
|
|
delete from HtmlLabelInfo where indexid = 547853 and languageid=9 and ( labelname is null or labelname = '' )
|
|
;
|
|
insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select 547853 as indexid ,'將當前模板應用所有人' as content,9 as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547853 and languageid=9 and ( labelname is not null and labelname <> '' )) limit 1
|
|
;
|
|
delete from HtmlModuleLabel where indexId = 547853 and moduleCode = 'HRM' and type = 'label'
|
|
;
|
|
insert into HtmlModuleLabel(type,moduleCode,indexId) values ('label','HRM',547853)
|
|
; |