# yyx 20200426
INSERT INTO `print_design` (`active`, `create_time`, `update_time`, `update_by`, `areacode`, `content`, `seq`,`type`)
VALUES
('1', '2020-04-21 18:03:30','2020-04-21 18:03:30', 'system', '110000', ' LODOP.PRINT_INITA("0mm","0mm","300mm","600mm","申请设立保安服务公司行政许可审批表");
LODOP.SET_SHOW_MODE(''BKIMG_IN_PREVIEW'',1);
strHtml =''
''+
''''+
''''+
''''+
''申请设立保安服务公司行政许可审批表 |
''+
''''+
''公司名称 | ''+
''''+data.companyname+'' | ''+
''电话 | ''+
''''+(data.tel == null ? " ":data.tel)+'' | ''+
''
''+
''''+
''公司地址 | ''+
''''+data.address+'' | ''+
''邮编 | ''+
''''+data.zipcode+'' | ''+
''
''+
''''+
''经营范围 | ''+
''''+management+'' | ''+
''
''+
''''+
''企业类型 | ''+
''''+data.enterprisetype+'' | ''+
''注册资金 | ''+
''''+
''''+(data.regcapital == null ? " " : data.regcapital)+''(万元)''+
'' | ''+
''
''+
''''+
''注册资本验资或评估机构 | ''+
''''+(data.assessmentorg == null ? " " : data.assessmentorg)+'' | ''+
''货币资本 | ''+
''''+(data.currency == null ? " " : data.currency)+'' | ''+
''
''+
''''+
''资产评估价值 | ''+
''''+(data.currencyvalue == null ? " " : data.currencyvalue)+'' | ''+
''
''+
''''+
''拟任法定代表人 | ''+
''''+data.representative+'' | ''+
''手机及固定电话 | ''+
''''+data.phone+'' | ''+
''
''+
''''+
''公司管理人员数 | ''+
''''+data.companymanger+'' | ''+
''专业技术人员数 | ''+
''''+data.technologynum+'' | ''+
''
''+
''''+
''公司用房面积 | ''+
''''+data.areanum+'' | ''+
''产权归属 | ''+
''''+data.ascription+'' | ''+
''
''+
''''+
''专用运输车辆数 | ''+
''''+(data.ascriptionvehicle == null ? " " : data.ascriptionvehicle)+'' | ''+
''防爆枪支数 | ''+
''''+(data.gunnum == null ? " " : data.gunnum)+'' | ''+
''
''+
''''+
''提交办事区域 | ''+
''''+(data.szss == null ? " " : data.szss)+'' | ''+
''
''+
''''+
''
''+
''''+
'''';
LODOP.ADD_PRINT_TABLE("2%","3%","120%","400%",strHtml);
LODOP.SET_PRINT_STYLEA(0,"FontName","宋体");
LODOP.SET_PRINT_STYLEA(0,"FontSize",16);
LODOP.SET_PRINT_STYLEA(0,"TableHeightScope",4);
LODOP.PRINT_DESIGN();','1','BAFWXKSP'),
('1', '2020-04-24 10:12:27','2020-04-24 10:12:27', 'system', '110000', ' LODOP.PRINT_INITA("0mm","0mm","300mm","600mm","审批进度");
LODOP.SET_SHOW_MODE(''BKIMG_IN_PREVIEW'',1);
strHtmlLog =''''+
''''+
''''+
''''+
''
''+
''''+
''审批进度 |
''+
''''+
''序号 | ''+
''审批日期 | ''+
''审批人 | ''+
''审批结果 | ''+
''审批意见 | ''+
''审批人所在机构 | ''+
''
''+
''''+
'''';
if(data != null && data.length>0){
for(var i = 0;i''+
''''+(i+1)+'' | ''+
''''+ new Date(data[i].approvaldate).format("yyyy-MM-dd hh:mm:ss")+'' | ''+
''''+(data[i].approvalperson == null?"没有配置下一级审批人员":data[i].approvalperson)+'' | ''+
''''+data[i].approvalstate+'' | ''+
''''+data[i].approvalreason+'' | ''+
''''+data[i].approvalorg+'' | ''+
'''';
}
}
}else{
strHtmlLog = strHtmlLog +''''+
''暂无相关数据! | ''+
''
'';
}
strHtmlLog = strHtmlLog +''''+
''
''+
''
''
''''+
'''';
LODOP.ADD_PRINT_TABLE("1%","1%","124%","100%",strHtmlLog);
LODOP.SET_PRINT_STYLEA(0,"FontName","宋体");
LODOP.SET_PRINT_STYLEA(0,"FontSize",16);
LODOP.SET_PRINT_STYLEA(0,"TableHeightScope",4);
LODOP.PRINT_DESIGN();','2','BAFWXKSP'),
('1', now(),now(), 'system', '110000',' LODOP.PRINT_INITA("0mm","0mm","300mm","600mm","保安服务公司许可项目审检文件处理签打印");
LODOP.SET_SHOW_MODE(''BKIMG_IN_PREVIEW'',1);
var strHtmlTable ='''';
var tableMessage = data.tableMessage;
var messageMap = data.messageMap;
var companyDetail = data.companyDetail;
var approvalMessage = data.approvalMessage;
var logList = data.logList;
strHtmlTable =''''+
''''+
''''+
''
'' + tableMessage.title + ''
'';
if(companyDetail.businesstype == ''007''){
strHtmlTable = strHtmlTable +
''
'';
}
if(companyDetail.businesstype != ''007''){
strHtmlTable = strHtmlTable +
''
'';
}
strHtmlTable = strHtmlTable +
''
'' +
''
'' +
''
'' +
''
'' +
''
'' +
'''' +
''''+tableMessage.approvalReason1+'' | '' +
'''' +
'''' +
'' ''+(approvalMessage.approvalPoliceStationReason == null ? " ":approvalMessage.approvalPoliceStationReason)+'' '' +
'' '' +
'''' +
'' 签名:''+(approvalMessage.personPoliceStationName == null ? " ":approvalMessage.personPoliceStationName)+'' '' +
'' ''+(approvalMessage.approvalPoliceStationDate == null ? " ":approvalMessage.approvalPoliceStationDate)+'' '' +
'' '' +
'' | '' +
''
'' +
'''' +
''''+tableMessage.approvalReason2+'' | '' +
'''' +
'''' +
'' ''+(approvalMessage.approvalBranchLeaderReason == null ? " ":approvalMessage.approvalBranchLeaderReason)+'' '' +
'' '' +
'''' +
'' 签名:''+(approvalMessage.personBranchLeaderName == null ? " ":approvalMessage.personBranchLeaderName)+'' '' +
'' ''+(approvalMessage.approvalBranchLeaderDate == null ? " ":approvalMessage.approvalBranchLeaderDate)+'' '' +
'' '' +
'' | '' +
''
'' +
'''' +
''''+tableMessage.approvalReason3+'' | '' +
'''' +
'''' +
'' ''+(approvalMessage.approvalTeamLeaderReason == null ? " ":approvalMessage.approvalTeamLeaderReason)+'' '' +
'' '' +
'''' +
'' 签名:''+(approvalMessage.personTeamLeaderName == null ? " ":approvalMessage.personTeamLeaderName)+'' '' +
'' ''+(approvalMessage.approvalTeamLeaderDate == null ? " ":approvalMessage.approvalTeamLeaderDate)+'' '' +
'' '' +
'' | '' +
''
'' +
'''' +
''''+tableMessage.approvalReason4+'' | '' +
'''' +
'''' +
'' ''+(approvalMessage.approvalTeamMainLeaderReason == null ? " ":approvalMessage.approvalTeamMainLeaderReason)+'' '' +
'' '' +
'''' +
'' 签名:''+(approvalMessage.personTeamMainLeaderName == null ? " ":approvalMessage.personTeamMainLeaderName)+'' '' +
'' ''+(approvalMessage.approvalTeamMainLeaderDate == null ? " ":approvalMessage.approvalTeamMainLeaderDate)+'' '' +
'' '' +
'' | '' +
''
'' +
'''' +
''''+tableMessage.approvalReason5+'' | '' +
'''' +
'' '' +
'' '' +
'''' +
'' 签名: '' +
'' 年 月 日 '' +
'' '' +
'' | '' +
''
'' +
'''' +
''备注 | '' +
'''' +
'''' +
'' | '' +
''
'' +
''
'' +
''
'' +
''
'' +
''
'' +
''
'' +
''
'' +
''
'' +
''
'' +
''
'' +
'''' +
'''' +
''序号 | '' +
''审批日期 | '' +
''审批人 | '' +
''审批结果 | '' +
''审批意见 | '' +
''审批人所在机构 | '' +
''
'' +
'''' +
'''' ;
if(logList != null && logList.length>0){
for(var i = 0;i''+
''''+(i+1)+'' | ''+
''''+ new Date(logList[i].approvaldate).format("yyyy-MM-dd hh:mm:ss")+'' | ''+
''''+(logList[i].approvalperson == null?"没有配置下一级审批人员":logList[i].approvalperson)+'' | ''+
''''+logList[i].approvalstate+'' | ''+
''''+logList[i].approvalreason+'' | ''+
''''+logList[i].approvalorg+'' | ''+
'''' ;
}
}
}
else{
strHtmlTable = strHtmlTable +''''+
''暂无相关数据! | ''+
''
'';
}
strHtmlTable = strHtmlTable +''''+
''
''+
''
''+
''''+
''
''+
''''+
'''';
LODOP.ADD_PRINT_TABLE("1%","1%","124%","100%",strHtmlTable);
LODOP.SET_PRINT_STYLEA(0,"FontName","宋体");
LODOP.SET_PRINT_STYLEA(0,"FontSize",16);
LODOP.SET_PRINT_STYLEA(0,"TableHeightScope",4);
LODOP.PRINT_DESIGN();','3','BAFWXKSP');
# yyx 20200426
delete from operation where module_id in(191,192,193,194,195,196,197,198,199,200,201,202,203,204,205);
INSERT INTO `operation` (`id`, `native_code`, `code`, `name`, `module_id`, `active`, `create_time`, `update_time`, `update_by`)
VALUES
(null, null, 'export', '导出', '191', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'export', '导出', '192', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'export', '导出', '193', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'export', '导出', '194', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'export', '导出', '195', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'export', '导出', '196', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'export', '导出', '197', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'export', '导出', '198', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'export', '导出', '199', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'export', '导出', '200', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'export', '导出', '201', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'export', '导出', '202', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'export', '导出', '203', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'export', '导出', '204', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'export', '导出', '205', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'query', '查询', '191', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'query', '查询', '192', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'query', '查询', '193', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'query', '查询', '194', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'query', '查询', '195', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'query', '查询', '196', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'query', '查询', '197', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'query', '查询', '198', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'query', '查询', '199', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'query', '查询', '200', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'query', '查询', '201', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'query', '查询', '202', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'query', '查询', '203', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'query', '查询', '204', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'query', '查询', '205', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'edit', '查看', '191', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'edit', '查看', '192', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'edit', '查看', '193', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'edit', '查看', '194', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'edit', '查看', '195', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'edit', '查看', '196', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'edit', '查看', '197', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'edit', '查看', '198', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'edit', '查看', '199', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'edit', '查看', '200', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'edit', '查看', '201', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'edit', '查看', '203', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'edit', '查看', '204', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'edit', '查看', '205', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'add', '新增', '191', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'add', '新增', '192', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'add', '新增', '193', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'add', '新增', '194', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'add', '新增', '195', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'add', '新增', '196', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'add', '新增', '197', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'add', '新增', '198', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'add', '新增', '199', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'add', '新增', '200', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'add', '新增', '201', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'add', '新增', '203', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'add', '新增', '204', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system'),
(null, null, 'add', '新增', '205', b'1', '2020-02-28 10:13:20', '2020-02-28 10:13:20', 'system');
delete from permission where module_id in(191,192,193,194,195,196,197,198,199,200,201,202,203,204,205);
INSERT INTO `permission` (`role_id`, `module_id`, `operation_id`, `roletype`)
select pr.id,o.module_id,o.id,'2'
from police_role pr,police p,operation o,module m
where pr.active=true
and p.active=TRUE
and o.active=TRUE
and pr.orgid=p.id
and o.module_id=m.id
and m.id in(191,192,193,194,195,196,197,198,199,200,201,202,203,204,205);
#070 保安员资格证打印配置
delete from print_design where `type`='BAYZGZ';
INSERT INTO `print_design` (`active`, `create_time`, `update_time`, `update_by`, `areacode`, `content`, `seq`, `type`) VALUES (true, now(), now(), 'system', '610000', 'var printState = 0,LODOP = perCerPrintUtil.getLodop();\r\n LODOP.PRINT_INITA(\"0mm\", 0, \"210mm\", \"297mm\", \"陕西保安员证书打印\");\r\n LODOP.SET_PRINT_MODE(\"BKIMG_IN_PREVIEW\", 1);\r\n LODOP.ADD_PRINT_SETUP_BKIMG(\"
\");\r\n LODOP.SET_SHOW_MODE(\"BKIMG_LEFT\", 0);\r\n LODOP.SET_SHOW_MODE(\"BKIMG_TOP\", 0);\r\n LODOP.SET_SHOW_MODE(\"BKIMG_WIDTH\", \"210mm\");\r\n LODOP.SET_SHOW_MODE(\"BKIMG_HEIGHT\", \"297mm\");\r\n LODOP.SET_SHOW_MODE(\"BKIMG_IN_PREVIEW\", true);\r\n LODOP.SET_SHOW_MODE(\"BKIMG_PRINT\", true);\r\n for (i = 0; i < detail.length; i += 2) {\r\n if(detail[i] != null && typeof(detail[i] != \'undefined\')) {\r\n LODOP.NewPage();\r\n LODOP.ADD_PRINT_TEXT(260 + 36, 517, 133, 20, detail[i].xm);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.ADD_PRINT_TEXT(370, 518, 171, 56, detail[i].address == null ? \'\' : detail[i].address.substring(0, 9) + \"\\r\\n\" + detail[i].address.substring(9, detail[i].address.length));\r\n LODOP.SET_PRINT_STYLEA(2,\"ReadOnly\",0);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LineSpacing\", 3);\r\n LODOP.ADD_PRINT_TEXT(334, 517, 163, 20, changeBirthFormat(getBirthdayFromIDNo(detail[i].idnum)));\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LetterSpacing\", -1);\r\n LODOP.ADD_PRINT_TEXT(462, 541, 239, 20, detail[i].idnum);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LetterSpacing\", -1);\r\n LODOP.ADD_PRINT_TEXT(360, 223, 200, 20, (detail[i].fzrq == null ? \"\" : changeBirthFormat(detail[i].fzrq.substring(0, 10))));\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LetterSpacing\", -1);\r\n LODOP.ADD_PRINT_TEXT(462, 207, 186, 20, detail[i].zsbh);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 16);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LetterSpacing\", -2);\r\n LODOP.ADD_PRINT_TEXT(145, 168, 111, 20, detail[i].xm);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 16);\r\n //照片\r\n if(detail[i].photo != null && detail[i].photo !=\"\") {\r\n LODOP.ADD_PRINT_IMAGE(138, 488, \"26.00mm\", \"32.00mm\", \"data:image/jpg;base64,\" + detail[i].photo);//+1\r\n }\r\n\r\n LODOP.SET_PRINT_STYLEA(0, \"Stretch\", 2);\r\n //二维码50\r\n LODOP.ADD_PRINT_IMAGE(182, 282, 99, 99,detail[i].qrcode);\r\n LODOP.SET_PRINT_STYLEA(0, \"Stretch\", 2);\r\n }\r\n if (detail[i + 1] != null && typeof(detail[i + 1] != \'undefined\')) {\r\n LODOP.ADD_PRINT_TEXT(778, 517, 133, 20, detail[i + 1].xm);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.ADD_PRINT_TEXT(816, 518, 163, 20, changeBirthFormat(getBirthdayFromIDNo(detail[i + 1].idnum)));\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LetterSpacing\", -1);\r\n LODOP.ADD_PRINT_TEXT(852, 518, 171, 56, detail[i + 1].address == null ? \'\' : detail[i + 1].address.substring(0, 9) + \"\\r\\n\" + detail[i + 1].address.substring(9, detail[i + 1].address.length));\r\n LODOP.SET_PRINT_STYLEA(12,\"ReadOnly\",0);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LineSpacing\", 3);\r\n LODOP.ADD_PRINT_TEXT(945, 541, 239, 20, detail[i + 1].idnum);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LetterSpacing\", -1);\r\n LODOP.ADD_PRINT_TEXT(627, 168, 111, 20, detail[i + 1].xm);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 16);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.ADD_PRINT_TEXT(842, 223, 200, 20, (detail[i + 1].fzrq == null ? \"\" : changeBirthFormat(detail[i + 1].fzrq.substring(0, 10))));\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LetterSpacing\", -1);\r\n LODOP.ADD_PRINT_TEXT(945, 204, 186, 20, detail[i + 1].zsbh);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 16);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LetterSpacing\", -2);\r\n //照片\r\n if(detail[i+1].photo != null && detail[i+1].photo !=\"\") {\r\n LODOP.ADD_PRINT_IMAGE(617, 488, \"26.00mm\", \"32.00mm\", \"data:image/jpg;base64,\" + detail[i + 1].photo);\r\n }\r\n LODOP.SET_PRINT_STYLEA(0, \"Stretch\", 2);//二维码\r\n //二维码50\r\n LODOP.ADD_PRINT_IMAGE(666, 282, 99, 99,detail[i + 1].qrcode);\r\n LODOP.SET_PRINT_STYLEA(0, \"Stretch\", 2);\r\n }\r\n }\r\n\r\n //直接打印返回逻辑真假结果(1或true代表真,false或0代表假),表示是否成功(关于进一步捕获打印状态参考样例45);\r\n //打印维护和打印预览返回打印次数,大于0表示打印成功的次数;\r\n //谷歌浏览器\r\n if (LODOP.CVERSION) {\r\n CLODOP.On_Return = function (TaskID, Value) {\r\n //打印状态\r\n printState = Value;\r\n if(printState >= 1){\r\n var snapshotIdArr=[];\r\n var idArr=[];\r\n for (i = 0; i < detail.length; i++) {\r\n idArr.push(detail[i].securitypersonid);\r\n snapshotIdArr.push(detail[i].snapshotId);\r\n }\r\n perCerPrintUtil.updatePrinted(idArr,snapshotIdArr);\r\n $(\'#dataTable\').datagrid(\'clearChecked\');\r\n //查询刷新\r\n setTimeout(\"refresh();\",1000);\r\n setTimeout(\"layer.closeAll();\",1500);\r\n }\r\n };\r\n }\r\n printState = LODOP.PRINT_SETUP();', '1', 'BAYZGZ');
INSERT INTO `print_design` (`active`, `create_time`, `update_time`, `update_by`, `areacode`, `content`, `seq`, `type`) VALUES (true, now(), now(), 'system', '640000', 'var printState = 0,LODOP = perCerPrintUtil.getLodop();\r\n LODOP.PRINT_INITA(\"0mm\", 0, \"210mm\", \"148.51mm\", \"宁夏保安员证书打印\");\r\n LODOP.SET_PRINT_MODE(\"BKIMG_IN_PREVIEW\", 1);\r\n LODOP.PRINT_INITA(\"0mm\", 0, \"210mm\", \"148.51mm\", \"宁夏保安员证书打印\");\r\n LODOP.SET_PRINT_MODE(\"PRINT_NOCOLLATE\", 1);\r\n LODOP.ADD_PRINT_TEXT(219, 430, 133, 20, detail.xm);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.ADD_PRINT_TEXT(277, 428, 214, 56, detail.address == null ? \'\' : detail.address.substring(0, 9) + \"\\r\\n\" + detail.address.substring(9, detail.address.length));\r\n LODOP.SET_PRINT_STYLEA(2, \"ReadOnly\", 0);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LineSpacing\", 3);\r\n LODOP.ADD_PRINT_TEXT(248, 429, 163, 20, changeBirthFormat(getBirthdayFromIDNo(detail.idnum)));\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LetterSpacing\", -1);\r\n LODOP.ADD_PRINT_TEXT(363, 450, 239, 20, detail.idnum);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LetterSpacing\", -1);\r\n LODOP.ADD_PRINT_TEXT(308, 183, 200, 20, (detail.fzrq == null ? \"\" : changeBirthFormatFZRQ(detail.fzrq.substring(0, 10))));\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LetterSpacing\", -1);\r\n LODOP.ADD_PRINT_TEXT(365, 124, 186, 20, detail.zsbh);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 16);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LetterSpacing\", -2);\r\n LODOP.ADD_PRINT_TEXT(61, 107, 111, 20, detail.xm);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 16);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.ADD_PRINT_IMAGE(45, 419, \"26.01mm\", \"31.99mm\", detail.photo);\r\n LODOP.SET_PRINT_STYLEA(0, \"Stretch\", 2);\r\n LODOP.ADD_PRINT_IMAGE(136, 280, 99, 99, detail.qrcode);\r\n LODOP.SET_PRINT_STYLEA(0, \"Stretch\", 2);\r\n //谷歌浏览器\r\n if (LODOP.CVERSION) {\r\n CLODOP.On_Return = function (TaskID, Value) {\r\n //打印状态\r\n printState = Value;\r\n if(printState >= 1){\r\n perCerPrintUtil.updatePrinted(detail.securitypersonid,detail.snapshotId);\r\n //查询刷新\r\n setTimeout(\"refresh();\",1000);\r\n setTimeout(\"layer.closeAll();\",1500);\r\n }\r\n };\r\n }\r\n printState = LODOP.PRINT_SETUP();', '1', 'BAYZGZ');
INSERT INTO `print_design` (`active`, `create_time`, `update_time`, `update_by`, `areacode`, `content`, `seq`, `type`) VALUES (true, now(), now(), 'system', '450000', 'var printState = 0,LODOP = perCerPrintUtil.getLodop();\r\n LODOP.PRINT_INITA(\"0mm\", 0, \"210mm\", \"148.51mm\", \"广西保安员证书打印\");\r\n LODOP.SET_PRINT_MODE(\"BKIMG_IN_PREVIEW\", 1);\r\n LODOP.ADD_PRINT_TEXT(266, 459, 133, 20, detail.xm);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.ADD_PRINT_TEXT(325, 459, 171, 56, detail.address == null ? \'\' : detail.address.substring(0, 9) + \"\\r\\n\" + detail.address.substring(9, detail.address.length));\r\n LODOP.SET_PRINT_STYLEA(2, \"ReadOnly\", 0);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LineSpacing\", 3);\r\n LODOP.ADD_PRINT_TEXT(294, 459, 163, 20, changeBirthFormat(getBirthdayFromIDNo(detail.idnum)));\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LetterSpacing\", -1);\r\n LODOP.ADD_PRINT_TEXT(379, 501, 239, 20, detail.idnum);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LetterSpacing\", -1);\r\n LODOP.ADD_PRINT_TEXT(304, 180, 200, 20, (detail.fzrq == null ? \"\" : changeBirthFormatFZRQ(detail.fzrq.substring(0, 10))));\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LetterSpacing\", -1);\r\n LODOP.ADD_PRINT_TEXT(359, 186, 186, 20, detail.zsbh.replace(\"桂\", \"\"));\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 16);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LetterSpacing\", -2);\r\n LODOP.ADD_PRINT_TEXT(105, 112, 111, 20, detail.xm);\r\n LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 16);\r\n //照片\r\n LODOP.ADD_PRINT_IMAGE(45, 454, \"26.00mm\", \"32.00mm\", detail.photo);//+1\r\n LODOP.SET_PRINT_STYLEA(0, \"Stretch\", 2);\r\n //二维码50\r\n LODOP.ADD_PRINT_IMAGE(142, 212, 99, 99, detail.qrcode);\r\n LODOP.SET_PRINT_STYLEA(0, \"Stretch\", 2);\r\n //谷歌浏览器\r\n if (LODOP.CVERSION) {\r\n CLODOP.On_Return = function (TaskID, Value) {\r\n //打印状态\r\n printState = Value;\r\n if(printState >= 1) {\r\n perCerPrintUtil.updatePrinted(detail.securitypersonid, detail.snapshotId);\r\n //查询刷新\r\n setTimeout(\"refresh();\", 1000);\r\n setTimeout(\"layer.closeAll();\", 1500);\r\n }\r\n };\r\n }\r\n printState = LODOP.PRINT_SETUP();', '1', 'BAYZGZ');
INSERT INTO `print_design` (`active`, `create_time`, `update_time`, `update_by`, `areacode`, `content`, `seq`, `type`) VALUES (true, now(), now(), 'system', '110000', 'var printState = 0,LODOP = perCerPrintUtil.getLodop();\r\n LODOP.PRINT_INITA(\"-2.38mm\", -7, \"169.99mm\", \"144.99mm\", \"北京保安员证书打印V3.5.1\");\r\n LODOP.SET_PRINT_MODE(\"PRINT_NOCOLLATE\", 1);\r\n LODOP.ADD_PRINT_SETUP_BKIMG(\"
\");\r\n LODOP.SET_SHOW_MODE(\"BKIMG_LEFT\", -50);\r\n LODOP.SET_SHOW_MODE(\"BKIMG_TOP\", -50);\r\n LODOP.SET_SHOW_MODE(\"BKIMG_WIDTH\", \"205.32mm\");\r\n LODOP.SET_SHOW_MODE(\"BKIMG_HEIGHT\", \"144.99mm\");\r\n LODOP.SET_SHOW_MODE(\"BKIMG_PRINT\", true);\r\n //照片\r\n if (detail.photo) {\r\n LODOP.ADD_PRINT_IMAGE(30, 104, \"26.01mm\", \"31.99mm\", detail.photo);//+1\r\n LODOP.SET_PRINT_STYLEA(0, \"Stretch\", 2);\r\n } else {\r\n LODOP.ADD_PRINT_IMAGE(30, 104, \"26.01mm\", \"31.99mm\", \"\");//+1\r\n LODOP.SET_PRINT_STYLEA(0, \"Stretch\", 2);\r\n }\r\n //二维码50\r\n LODOP.ADD_PRINT_IMAGE(91, 501, 116, 111, detail.qrcode);\r\n\r\n LODOP.SET_PRINT_STYLEA(0, \"Stretch\", 2);\r\n //姓名\r\n LODOP.ADD_PRINT_TEXT(193, 109, 133, 20, detail.xm);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n // LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n //地址\r\n LODOP.ADD_PRINT_TEXT(300, 110, 171, 56, detail.address == null ? \'\' : detail.address.substring(0, 9) + \"\\r\\n\" + detail.address.substring(9, detail.address.length));\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n // LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LineSpacing\", 3);\r\n //民族\r\n LODOP.ADD_PRINT_TEXT(227, 110, 163, 20, detail.nation);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n //LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LetterSpacing\", -1);\r\n //出生日期\r\n LODOP.ADD_PRINT_TEXT(266, 110, 163, 20, changeBirthFormat(getBirthdayFromIDNo(detail.idnum)));\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n //LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LetterSpacing\", -1);\r\n //身份证号\r\n LODOP.ADD_PRINT_TEXT(391, 111, 163, 20, detail.idnum);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n //LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LetterSpacing\", -1);\r\n\r\n //发证日期\r\n LODOP.ADD_PRINT_TEXT(325, 461, 200, 20, (detail.fzrq == null ? \"\" : changeBirthFormatFZRQBJ(detail.fzrq.substring(0, 10))));\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 12);\r\n // LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LetterSpacing\", -1);\r\n //编号\r\n LODOP.ADD_PRINT_TEXT(383, 496, 186, 20, detail.zsbh.replace(\"京\", \"\"));\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 16);\r\n // LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"LetterSpacing\", -2);\r\n //姓名\r\n LODOP.ADD_PRINT_TEXT(34, 432, 75, 20, detail.xm);\r\n // LODOP.SET_PRINT_STYLEA(0, \"Bold\", 1);\r\n LODOP.SET_PRINT_STYLEA(0, \"FontSize\", 16);\r\n //谷歌浏览器\r\n if (LODOP.CVERSION) {\r\n CLODOP.On_Return = function (TaskID, Value) {\r\n //打印状态\r\n printState = Value;\r\n if(printState >= 1) {\r\n perCerPrintUtil.updatePrinted(detail.securitypersonid, detail.snapshotId);\r\n //查询刷新\r\n setTimeout(\"refresh();\", 1000);\r\n setTimeout(\"layer.closeAll();\", 1500);\r\n }\r\n };\r\n }\r\n //打印维护\r\n printState = LODOP.PRINT_SETUP();', '1', 'BAYZGZ');
delete from config where `key` like 'PERCERURL%';
INSERT INTO `config` (`key`, `value`, `name`, `active`, `create_time`, `update_time`, `update_by`)
VALUES ('PERCERURL450000', 'http://gx.baibaodun.cn/', '资格证地址', true,now(),now(), 'system'),
('PERCERURL610000', 'http://sn.baibaodun.cn/', '资格证地址', true,now(),now(), 'system'),
('PERCERURL640000', 'http://nx.baibaodun.cn/', '资格证地址', true,now(),now(), 'system'),
('PERCERURL110000', 'http://bj.baibaodun.cn:8801/ars-web/', '资格证地址', true,now(),now(), 'system');
delete from sys_dict where codeType='isolddata';
INSERT INTO `sys_dict` (`isActive`, `codeType`, `tableName`, `description`, `codeValue`, `label`, `seq`)
VALUES
('1', 'isolddata', NULL, '是否历史导入数据', '0', '否', '1'),
('1', 'isolddata', NULL, '是否历史导入数据', '1', '是', '2');