制证数据更新

Administrator

2022-06-10 7b291d619aa70e5bb33f2b1caabe7f4b0bd003d9

制证数据更新

 src/main/java/org/springblade/modules/system/controller/UserController.java

@@ -42,6 +42,9 @@
import org.springblade.core.tool.constant.RoleConstant;
import org.springblade.core.tool.utils.DateUtil;
import org.springblade.core.tool.utils.StringPool;
import org.springblade.modules.FTP.MyAsyncService;
import org.springblade.modules.accreditation.entity.AccreditationRecords;
import org.springblade.modules.accreditation.service.AccreditationRecordsService;
import org.springblade.modules.system.entity.User;
import org.springblade.modules.system.excel.SecurityExcel;
import org.springblade.modules.system.excel.UserExcel;
@@ -55,10 +58,9 @@

import javax.servlet.http.HttpServletResponse;
import javax.validation.Valid;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.stream.Collectors;

import static org.springblade.core.cache.constant.CacheConstant.USER_CACHE;

@@ -75,6 +77,12 @@
public class UserController {

    private final IUserService userService;


    private final MyAsyncService myAsyncService;


    private final AccreditationRecordsService accreditationRecordsService;

    /**
     * 查询单条
@@ -403,4 +411,62 @@
        return R.data(userService.getSecurityInfoByIdCardNo(user));
    }


    /**
     * 修改发证时间
     */
    @PostMapping("/updatePaperTime")
    public R updatePaperTime(@RequestBody User user) {
        user.setPaperTime(new Date());
        user.setUpdateTime(new Date());
        userService.updateById(user);
        String paperTime = null;
        //发证日期处理
        if (user.getPaperTime() == null) {
            paperTime = null;
        } else {
            paperTime = new SimpleDateFormat("yyyy-MM-dd").format(user.getPaperTime());
        }
        //更新制证记录制证状态
        AccreditationRecords accreditationRecords = new AccreditationRecords();
        accreditationRecords.setUserId(user.getId());
        //审核通过的
        accreditationRecords.setAuditStatus(2);
        //未制证的记录
        accreditationRecords.setStatus(1);
        //查询
        List<AccreditationRecords> list = accreditationRecordsService.list(Condition.getQueryWrapper(accreditationRecords));
        if (list.size() > 0) {
            //排序
            List<AccreditationRecords> collect = list.stream().sorted(Comparator.comparing(AccreditationRecords::getId).reversed()).collect(Collectors.toList());
            //取出第一个
            AccreditationRecords accreditationRecords1 = collect.get(0);
            //修改为已制证状态
            accreditationRecords1.setStatus(2);
            //记录打印时间
            accreditationRecords1.setPaperTime(new Date());
            //更新
            accreditationRecordsService.updateById(accreditationRecords1);
            //同步
            String s1 =
                "update blade_user set paper_time = " + "'" + paperTime + "'"
                    + ",user_type = " + "'" + user.getUserType() + "'"
                    + ",update_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(user.getUpdateTime()) + "'"
                    + " " + "where id = " + "'" + user.getId() + "';" +
                "update sys_accreditation_records set status = " + "'" + accreditationRecords1.getStatus() + "'" +
                    " " + "where id = " + "'" + accreditationRecords1.getId() + "'";
            myAsyncService.FTP(s1);
            //返回
            return R.success("修改成功");
        }

        String s1 =
            "update blade_user set paper_time = " + "'" + paperTime + "'"
                + ",user_type = " + "'" + user.getUserType() + "'"
                + ",update_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(user.getUpdateTime()) + "'"
                + " " + "where id = " + "'" + user.getId() + "'";
        myAsyncService.FTP(s1);
        return R.success("修改成功");
    }

}