| | |
|---|
| | | |
|---|
| | | String urls = "http://223.82.109.183:2081/zhba/" + newName; |
|---|
| | | //内网 |
|---|
| | | String inUrl = ip + newName; |
|---|
| | | String inUrl = ip +"/zhba/"+ newName; |
|---|
| | | //取出身份证号,查询用户信息，更新用户信息 |
|---|
| | | String pictrueName = multipartFile.getName().substring(0, multipartFile.getName().lastIndexOf(".")); |
|---|
| | | // String regex ="([1-9]\\d{5}(18|19|20)\\d{2}((0[1-9])|(10|11|12))(([0-2][1-9])|10|20|30|31)\\d{3}[0-9Xx])|([1-9]\\d{5}\\d{2}((0[1-9])|(10|11|12))(([0-2][1-9])|10|20|30|31)\\d{3})"; |
|---|
| | |
|---|
| | | if (null!=user){ |
|---|
| | | ExamPayment examPayment = new ExamPayment(); |
|---|
| | | examPayment.setWorkerId(user.getId().toString()); |
|---|
| | | examPayment.setPaymentStatus(3); |
|---|
| | | examPayment.setCertificateUrl(urls); |
|---|
| | | examPayment.setType(1); |
|---|
| | | examPayment.setPaymentTime(new Date()); |
|---|
| | |
|---|
| | | |
|---|
| | | //数据推送 |
|---|
| | | 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.getCertificateUrl() + "'" + ")"; |
|---|
| | | "," + "'" + examPayment.getPaymentStatus() + "'" + |
|---|
| | | "," +"'" + inUrl + "'" + ")"; |
|---|
| | | FtpUtil.sqlFileUpload(s); |
|---|
| | | |
|---|
| | | //文件推送 |
|---|
