派遣导入修改

Administrator

2021-09-18 341de5006139c77db80ea2e15a6f759378cdad55

派遣导入修改

 src/main/java/org/springblade/modules/dispatcher/service/impl/DispatcherUnitServiceImpl.java

@@ -103,10 +103,10 @@

            if (dispatcherUnitExcel.getName()!=null && dispatcherUnitExcel.getName()!=""){
                //仅中文
                String chinese = "^[\\u4E00-\\u9FA5\\uF900-\\uFA2D]+$";
                Pattern compile = Pattern.compile(chinese);
                String name = compile.matcher(dispatcherUnitExcel.getName()).replaceAll("");
                dispatcherUnit.setName(name);
//                String chinese = "^[\\u4E00-\\u9FA5\\uF900-\\uFA2D]+$";
//                Pattern compile = Pattern.compile(chinese);
//                String name = compile.matcher(dispatcherUnitExcel.getName()).replaceAll("");
                dispatcherUnit.setName(dispatcherUnitExcel.getName());
            }

            if (dispatcherUnitExcel.getLinkman()!=null && dispatcherUnitExcel.getLinkman()!=""){

 src/main/java/org/springblade/modules/resource/endpoint/OssEndpoint.java

@@ -458,6 +458,7 @@
                if (null!=user){
                    ExamPayment examPayment = new ExamPayment();
                    examPayment.setWorkerId(user.getId().toString());
                    examPayment.setPaymentStatus(1);
                    examPayment.setCertificateUrl(urls);
                    examPayment.setType(1);
                    examPayment.setPaymentTime(new Date());
@@ -472,12 +473,12 @@

                    //数据推送
                    String formatStr = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examPayment.getPaymentTime());
                    String s = "insert into sys_apply(id,type,payment_time,worker_id,apply_code,certificate_url) " +
                    String s = "insert into sys_exam_payment(id,type,payment_time,worker_id,payment_status,certificate_url) " +
                        "values(" + "'" + examPayment.getId() + "'" +
                        "," + "'" + examPayment.getType() + "'" +
                        "," + "'" + formatStr + "'" +
                        "," + "'" + examPayment.getWorkerId() + "'" +
                        "," + "'" + examPayment.getApplyCode() + "'" +
                        "," + "'" + examPayment.getPaymentStatus() + "'" +
                        "," +"'" + examPayment.getCertificateUrl() + "'" + ")";
                    FtpUtil.sqlFileUpload(s);