基于SpringBoot+Vue框架的企业人事管理系统

/\*\*

 \* 商家

 \* 后端接口

 \* @author

 \* @email

\*/

@RestController

@Controller

@RequestMapping("/shangjia")

public class ShangjiaController {

    private static final Logger logger = LoggerFactory.getLogger(ShangjiaController.class);



    @Autowired

    private ShangjiaService shangjiaService;





    @Autowired

    private TokenService tokenService;

    @Autowired

    private DictionaryService dictionaryService;



    //级联表service



    @Autowired

    private YonghuService yonghuService;





   

    /\*\*

    \* 后端修改

    \*/

    @RequestMapping("/update")

    public R update(@RequestBody ShangjiaEntity shangjia, HttpServletRequest request){

        logger.debug("update方法:,,Controller:{},,shangjia:{}",this.getClass().getName(),shangjia.toString());



        String role = String.valueOf(request.getSession().getAttribute("role"));

//        if(false)

//            return R.error(511,"永远不会进入");

        //根据字段查询是否有相同数据

        Wrapper<ShangjiaEntity> queryWrapper = new EntityWrapper<ShangjiaEntity>()

            .notIn("id",shangjia.getId())

            .andNew()

            .eq("username", shangjia.getUsername())

            .or()

            .eq("shangjia\_phone", shangjia.getShangjiaPhone())

            .andNew()

            .eq("shangjia\_delete", 1)

            ;



        logger.info("sql语句:"+queryWrapper.getSqlSegment());

        ShangjiaEntity shangjiaEntity = shangjiaService.selectOne(queryWrapper);

        if("".equals(shangjia.getShangjiaPhoto()) || "null".equals(shangjia.getShangjiaPhoto())){

                shangjia.setShangjiaPhoto(null);

        }

        if(shangjiaEntity==null){

            shangjiaService.updateById(shangjia);//根据id更新

            return R.ok();

        }else {

            return R.error(511,"账户或者联系方式已经被使用");

        }

    }





    /\*\*

    \* 审核

    \*/

    @RequestMapping("/shenhe")

    public R shenhe(@RequestBody ShangjiaEntity shangjia, HttpServletRequest request){

        logger.debug("shenhe方法:,,Controller:{},,shangjia:{}",this.getClass().getName(),shangjia.toString());



//        if(shangjia.getShangjiaYesnoTypes() == 2){//通过

//            shangjia.setShangjiaTypes();

//        }else if(shangjia.getShangjiaYesnoTypes() == 3){//拒绝

//            shangjia.setShangjiaTypes();

//        }

        shangjia.setShangjiaShenheTime(new Date());//审核时间

        shangjiaService.updateById(shangjia);//审核

        return R.ok();

    }



    /\*\*

    \* 删除

    \*/

    @RequestMapping("/delete")

    public R delete(@RequestBody Integer[] ids){

        logger.debug("delete:,,Controller:{},,ids:{}",this.getClass().getName(),ids.toString());

        ArrayList<ShangjiaEntity> list = new ArrayList<>();

        for(Integer id:ids){

            ShangjiaEntity shangjiaEntity = new ShangjiaEntity();

            shangjiaEntity.setId(id);

            shangjiaEntity.setShangjiaDelete(2);

            list.add(shangjiaEntity);

        }

        if(list != null && list.size() >0){

            shangjiaService.updateBatchById(list);

        }

        return R.ok();

    }





   



    /\*\*

    \* 登录

    \*/

    @IgnoreAuth

    @RequestMapping(value = "/login")

    public R login(String username, String password, String captcha, HttpServletRequest request) {

        ShangjiaEntity shangjia = shangjiaService.selectOne(new EntityWrapper<ShangjiaEntity>().eq("username", username));

        if(shangjia==null || !shangjia.getPassword().equals(password))

            return R.error("账号或密码不正确");

        else if(shangjia.getShangjiaDelete() != 1)

            return R.error("账户已被删除");

        else if(shangjia.getShangjiaYesnoTypes() == 1)

            return R.error("请等待审核结果");

        else if(shangjia.getShangjiaYesnoTypes() == 3)

            return R.error("账户审核已被拒绝,有疑问请联系服务人员");

        //  // 获取监听器中的字典表

        String token = tokenService.generateToken(shangjia.getId(),username, "shangjia", "商家");

        R r = R.ok();

        r.put("token", token);

        r.put("role","商家");

        r.put("username",shangjia.getShangjiaName());

        r.put("tableName","shangjia");

        r.put("userId",shangjia.getId());

        return r;

    }



    /\*\*

    \* 注册

    \*/

    @IgnoreAuth

    @PostMapping(value = "/register")

    public R register(@RequestBody ShangjiaEntity shangjia){

//        ValidatorUtils.validateEntity(user);

        Wrapper<ShangjiaEntity> queryWrapper = new EntityWrapper<ShangjiaEntity>()

            .eq("username", shangjia.getUsername())

            .or()

            .eq("shangjia\_phone", shangjia.getShangjiaPhone())

            .andNew()

            .eq("shangjia\_delete", 1)

            ;

        ShangjiaEntity shangjiaEntity = shangjiaService.selectOne(queryWrapper);

        if(shangjiaEntity != null)

            return R.error("账户或者联系方式已经被使用");

        shangjia.setShangjiaXingjiTypes(1);

        shangjia.setNewMoney(0.0);

        shangjia.setShangjiaYesnoTypes(1);

        shangjia.setShangjiaDelete(1);

        shangjia.setCreateTime(new Date());

        shangjiaService.insert(shangjia);

        return R.ok();

    }



    /\*\*

     \* 重置密码

     \*/

    @GetMapping(value = "/resetPassword")

    public R resetPassword(Integer  id){

        ShangjiaEntity shangjia = new ShangjiaEntity();

        shangjia.setPassword("123456");

        shangjia.setId(id);

        shangjiaService.updateById(shangjia);

        return R.ok();

    }





    /\*\*

     \* 忘记密码

     \*/

    @IgnoreAuth

    @RequestMapping(value = "/resetPass")

    public R resetPass(String username, HttpServletRequest request) {

        ShangjiaEntity shangjia = shangjiaService.selectOne(new EntityWrapper<ShangjiaEntity>().eq("username", username));

        if(shangjia!=null){

            shangjia.setPassword("123456");

            boolean b = shangjiaService.updateById(shangjia);

            if(!b){

               return R.error();

            }

        }else{

           return R.error("账号不存在");

        }

        return R.ok();

    }





    /\*\*

    \* 获取用户的session用户信息

    \*/

    @RequestMapping("/session")

    public R getCurrShangjia(HttpServletRequest request){

        Integer id = (Integer)request.getSession().getAttribute("userId");

        ShangjiaEntity shangjia = shangjiaService.selectById(id);

        if(shangjia !=null){

            //entity转view

            ShangjiaView view = new ShangjiaView();

            BeanUtils.copyProperties( shangjia , view );//把实体数据重构到view中



            //修改对应字典表字段

            dictionaryService.dictionaryConvert(view, request);

            return R.ok().put("data", view);

        }else {

            return R.error(511,"查不到数据");

        }

    }





    /\*\*

    \* 退出

    \*/

    @GetMapping(value = "logout")

    public R logout(HttpServletRequest request) {

        request.getSession().invalidate();

        return R.ok("退出成功");

    }

}

CREATE TABLE `yonghu` (

  `id` bigint NOT NULL AUTO\_INCREMENT COMMENT '主键',

  `addtime` timestamp NOT NULL DEFAULT CURRENT\_TIMESTAMP COMMENT '创建时间',

  `yonghuming` varchar(200) NOT NULL COMMENT '用户名',

  `mima` varchar(200) NOT NULL COMMENT '密码',

  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',

  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',

  `touxiang` varchar(200) DEFAULT NULL COMMENT '头像',

  `shouji` varchar(200) DEFAULT NULL COMMENT '手机',

  `shenfenzheng` varchar(200) DEFAULT NULL COMMENT '身份证',

  PRIMARY KEY (`id`),

  UNIQUE KEY `yonghuming` (`yonghuming`)

) ENGINE=InnoDB AUTO\_INCREMENT=1616222324596 DEFAULT CHARSET=utf8mb3 COMMENT='用户';

CREATE TABLE `messages` (

  `id` bigint NOT NULL AUTO\_INCREMENT COMMENT '主键',

  `addtime` timestamp NOT NULL DEFAULT CURRENT\_TIMESTAMP COMMENT '创建时间',

  `userid` bigint NOT NULL COMMENT '留言人id',

  `username` varchar(200) DEFAULT NULL COMMENT '用户名',

  `content` longtext NOT NULL COMMENT '留言内容',

  `reply` longtext COMMENT '回复内容',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO\_INCREMENT=1616222424131 DEFAULT CHARSET=utf8mb3 COMMENT='留言板';

CREATE TABLE `token` (

  `id` bigint NOT NULL AUTO\_INCREMENT COMMENT '主键',

  `userid` bigint NOT NULL COMMENT '用户id',

  `username` varchar(100) NOT NULL COMMENT '用户名',

  `tablename` varchar(100) DEFAULT NULL COMMENT '表名',

  `role` varchar(100) DEFAULT NULL COMMENT '角色',

  `token` varchar(200) NOT NULL COMMENT '密码',

  `addtime` timestamp NOT NULL DEFAULT CURRENT\_TIMESTAMP COMMENT '新增时间',

  `expiratedtime` timestamp NOT NULL DEFAULT CURRENT\_TIMESTAMP COMMENT '过期时间',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO\_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COMMENT='token表';