SSM企业人事工资管理系统源码

【217】SSM企业人事工资管理系统

 开发工具:idea 
 数据库mysql5.7+
 数据库链接工具:navcat,小海豚等
  技术:ssm

package com.esms.controller;

import com.esms.service.IEchartsService;
import com.esms.service.impl.EchartsServiceImpl;
import com.esms.vo.EchDepartmentSalary;
import com.esms.vo.EchEmployeeNums;
import com.esms.vo.EchMonthSalary;
import com.esms.vo.EchSalaryPercent;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
/**
 * @Author: 方宏泰
 * @Description: 图表制作类
 * @Date: 22:24 2021/10/6
 **/
@Controller
public class EchartsController {
    @Autowired
    private IEchartsService echartsService;

    @RequestMapping(value = "/showEmployeeNums.do")
    @ResponseBody
    public Map<String,List<EchEmployeeNums>> showEmployeeNums(){
        /**
         * 各部门的员工数量柱状图的数据
         * json格式{"list":[{"department":"人事部","num":480},{"department":"行政部","num":380}]}
         */
        /*
        List<EchEmployeeNums> echEmployeeNumsList = new ArrayList();
        Map<String,List<EchEmployeeNums>> map = new HashMap<String,List<EchEmployeeNums>>();
        EchEmployeeNums e1 = new EchEmployeeNums();
        e1.setDepartment("人事部");
        e1.setNum(123);
        EchEmployeeNums e2 = new EchEmployeeNums();
        e2.setDepartment("行政部");
        e2.setNum(123);
        echEmployeeNumsList.add(e1);
        echEmployeeNumsList.add(e2);
        map.put("list",echEmployeeNumsList);*/
        return echartsService.getEmployeeNums();
    }

    @RequestMapping(value = "/showDepartmentSalary.do")
    @ResponseBody
    public Map<String,List<EchDepartmentSalary>> showDepartmentSalary(String date){
        /**
         *各年月工资对比图的数据
         * json格式{"list":[{"year":"1","salary":[480,500,600,..]},{"year":"2","salary":[480,500,600...]}]}
         */
/*
        List<EchDepartmentSalary> echDepartmentSalaryList = new ArrayList<EchDepartmentSalary>();
        Map<String,List<EchDepartmentSalary>> stringListMap = new HashMap<String, List<EchDepartmentSalary>>();

        EchDepartmentSalary e1 = new EchDepartmentSalary();
        e1.setDepartment("人事部");
        List<Double> salary1 = new ArrayList<Double>();
        salary1.add(5000.00);
        salary1.add(8000.00);
        salary1.add(20000.00);
        e1.setSalary(salary1);

        EchDepartmentSalary e2 = new EchDepartmentSalary();
        e2.setDepartment("科研部");
        List<Double> salary2 = new ArrayList<Double>();
        salary2.add(6000.00);
        salary2.add(8500.00);
        salary2.add(25000.00);
        e2.setSalary(salary2);

        EchDepartmentSalary e3 = new EchDepartmentSalary();
        e3.setDepartment("策划部");
        List<Double> salary3 = new ArrayList<Double>();
        salary3.add(6000.00);
        salary3.add(8800.00);
        salary3.add(23000.00);
        e3.setSalary(salary3);

        echDepartmentSalaryList.add(e1);
        echDepartmentSalaryList.add(e2);
        echDepartmentSalaryList.add(e3);
        stringListMap.put("list",echDepartmentSalaryList);
        return stringListMap;*/
        return echartsService.getDepartmentSalary(date);
    }

    @RequestMapping(value = "/showSalaryPercent.do")
    @ResponseBody
    public Map<String,List<EchSalaryPercent>> showSalaryPercent(String date,int state){
        /*List<EchSalaryPercent> echSalaryPercentList = new ArrayList<EchSalaryPercent>();
        Map<String,List<EchSalaryPercent>> map = new HashMap<String,List<EchSalaryPercent>>();
        EchSalaryPercent s1 = new EchSalaryPercent();
        EchSalaryPercent s2 = new EchSalaryPercent();
        s1.setDepartment("人事部");
        s1.setSalary(1010010.00);
        s2.setDepartment("科研部");
        s2.setSalary(1510010.00);
        echSalaryPercentList.add(s1);
        echSalaryPercentList.add(s2);
        map.put("list",echSalaryPercentList);*/

        return  echartsService.getSalaryPercent(date,state);
    }

    @RequestMapping(value = "/showMonthSalary.do")
    @ResponseBody
    public Map<String,List<EchMonthSalary>> showMonthSalary(){
        /*
        List<EchMonthSalary> echMonthSalaryList = new ArrayList<EchMonthSalary>();
        Map<String,List<EchMonthSalary>> stringListMap = new HashMap<String, List<EchMonthSalary>>();

        EchMonthSalary e1 = new EchMonthSalary();
        e1.setYear("2015年");
        List<Double> salary1 = new ArrayList<Double>();
        salary1.add(5000.00);
        salary1.add(8000.00);
        salary1.add(20000.00);
        salary1.add(5000.00);
        salary1.add(8000.00);
        salary1.add(20000.00);
        salary1.add(5000.00);
        salary1.add(8000.00);
        salary1.add(20000.00);
        salary1.add(5000.00);
        salary1.add(8000.00);
        salary1.add(20000.00);
        e1.setSalary(salary1);

        EchMonthSalary e2 = new EchMonthSalary();
        e2.setYear("2016年");
        List<Double> salary2 = new ArrayList<Double>();
        salary2.add(5800.00);
        salary2.add(8080.00);
        salary2.add(20800.00);
        salary2.add(5080.00);
        salary2.add(8800.00);
        salary2.add(20800.00);
        salary2.add(5080.00);
        salary2.add(8080.00);
        salary2.add(20800.00);
        salary2.add(5080.00);
        salary2.add(8080.00);
        salary2.add(20080.00);
        e2.setSalary(salary2);

        EchMonthSalary e3 = new EchMonthSalary();
        e3.setYear("2017年");
        List<Double> salary3 = new ArrayList<Double>();
        salary3.add(6000.00);
        salary3.add(8800.00);
        salary3.add(23000.00);
        salary3.add(6000.00);
        salary3.add(8800.00);
        salary3.add(23000.00);
        salary3.add(6000.00);
        salary3.add(8800.00);
        salary3.add(23000.00);
        salary3.add(6000.00);
        salary3.add(8800.00);
        salary3.add(23000.00);
        e3.setSalary(salary3);

        echMonthSalaryList.add(e1);
        echMonthSalaryList.add(e2);
        echMonthSalaryList.add(e3);
        stringListMap.put("list",echMonthSalaryList);
        return stringListMap;*/
        return echartsService.getMonthSalary();
    }

}

 

package com.controller;

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Calendar;
import java.util.Map;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpServletRequest;

import com.utils.ValidatorUtils;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.format.annotation.DateTimeFormat;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.annotation.IgnoreAuth;

import com.entity.YonghuEntity;
import com.entity.view.YonghuView;

import com.service.YonghuService;
import com.service.TokenService;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.CommonUtil;


/**
 * 用户
 * 后端接口
 * @author 
 * @email 
 * @date 2021-03-31 15:31:46
 */
@RestController
@RequestMapping("/yonghu")
public class YonghuController {
    @Autowired
    private YonghuService yonghuService;
    
	@Autowired
	private TokenService tokenService;
	
	/**
	 * 登录
	 */
	@IgnoreAuth
	@RequestMapping(value = "/login")
	public R login(String username, String password, String captcha, HttpServletRequest request) {
		YonghuEntity user = yonghuService.selectOne(new EntityWrapper<YonghuEntity>().eq("zhanghao", username));
		if(user==null || !user.getMima().equals(password)) {
			return R.error("账号或密码不正确");
		}
		String token = tokenService.generateToken(user.getId(), username,"yonghu",  "用户" );
		return R.ok().put("token", token);
	}
	
	/**
     * 注册
     */
	@IgnoreAuth
    @RequestMapping("/register")
    public R register(@RequestBody YonghuEntity yonghu){
    	//ValidatorUtils.validateEntity(yonghu);
    	YonghuEntity user = yonghuService.selectOne(new EntityWrapper<YonghuEntity>().eq("zhanghao", yonghu.getZhanghao()));
		if(user!=null) {
			return R.error("注册用户已存在");
		}
		Long uId = new Date().getTime();
		yonghu.setId(uId);
        yonghuService.insert(yonghu);
        return R.ok();
    }
	
	/**
	 * 退出
	 */
	@RequestMapping("/logout")
	public R logout(HttpServletRequest request) {
		request.getSession().invalidate();
		return R.ok("退出成功");
	}
	
	/**
     * 获取用户的session用户信息
     */
    @RequestMapping("/session")
    public R getCurrUser(HttpServletRequest request){
    	Long id = (Long)request.getSession().getAttribute("userId");
        YonghuEntity user = yonghuService.selectById(id);
        return R.ok().put("data", user);
    }
    
    /**
     * 密码重置
     */
    @IgnoreAuth
	@RequestMapping(value = "/resetPass")
    public R resetPass(String username, HttpServletRequest request){
    	YonghuEntity user = yonghuService.selectOne(new EntityWrapper<YonghuEntity>().eq("zhanghao", username));
    	if(user==null) {
    		return R.error("账号不存在");
    	}
    	user.setMima("123456");
        yonghuService.updateById(user);
        return R.ok("密码已重置为:123456");
    }


    /**
     * 后端列表
     */
    @RequestMapping("/page")
    public R page(@RequestParam Map<String, Object> params,YonghuEntity yonghu, 
		HttpServletRequest request){

        EntityWrapper<YonghuEntity> ew = new EntityWrapper<YonghuEntity>();
		PageUtils page = yonghuService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, yonghu), params), params));
        return R.ok().put("data", page);
    }
    
    /**
     * 前端列表
     */
    @RequestMapping("/list")
    public R list(@RequestParam Map<String, Object> params,YonghuEntity yonghu, HttpServletRequest request){
        EntityWrapper<YonghuEntity> ew = new EntityWrapper<YonghuEntity>();
		PageUtils page = yonghuService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, yonghu), params), params));
        return R.ok().put("data", page);
    }

	/**
     * 列表
     */
    @RequestMapping("/lists")
    public R list( YonghuEntity yonghu){
       	EntityWrapper<YonghuEntity> ew = new EntityWrapper<YonghuEntity>();
      	ew.allEq(MPUtil.allEQMapPre( yonghu, "yonghu")); 
        return R.ok().put("data", yonghuService.selectListView(ew));
    }

	 /**
     * 查询
     */
    @RequestMapping("/query")
    public R query(YonghuEntity yonghu){
        EntityWrapper< YonghuEntity> ew = new EntityWrapper< YonghuEntity>();
 		ew.allEq(MPUtil.allEQMapPre( yonghu, "yonghu")); 
		YonghuView yonghuView =  yonghuService.selectView(ew);
		return R.ok("查询用户成功").put("data", yonghuView);
    }
	
    /**
     * 后端详情
     */
    @RequestMapping("/info/{id}")
    public R info(@PathVariable("id") Long id){
        YonghuEntity yonghu = yonghuService.selectById(id);
        return R.ok().put("data", yonghu);
    }

    /**
     * 前端详情
     */
    @RequestMapping("/detail/{id}")
    public R detail(@PathVariable("id") Long id){
        YonghuEntity yonghu = yonghuService.selectById(id);
        return R.ok().put("data", yonghu);
    }
    



    /**
     * 后端保存
     */
    @RequestMapping("/save")
    public R save(@RequestBody YonghuEntity yonghu, HttpServletRequest request){
    	yonghu.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(yonghu);
    	YonghuEntity user = yonghuService.selectOne(new EntityWrapper<YonghuEntity>().eq("zhanghao", yonghu.getZhanghao()));
		if(user!=null) {
			return R.error("用户已存在");
		}

		yonghu.setId(new Date().getTime());
        yonghuService.insert(yonghu);
        return R.ok();
    }
    
    /**
     * 前端保存
     */
    @RequestMapping("/add")
    public R add(@RequestBody YonghuEntity yonghu, HttpServletRequest request){
    	yonghu.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(yonghu);
    	YonghuEntity user = yonghuService.selectOne(new EntityWrapper<YonghuEntity>().eq("zhanghao", yonghu.getZhanghao()));
		if(user!=null) {
			return R.error("用户已存在");
		}

		yonghu.setId(new Date().getTime());
        yonghuService.insert(yonghu);
        return R.ok();
    }

    /**
     * 修改
     */
    @RequestMapping("/update")
    public R update(@RequestBody YonghuEntity yonghu, HttpServletRequest request){
        //ValidatorUtils.validateEntity(yonghu);
        yonghuService.updateById(yonghu);//全部更新
        return R.ok();
    }
    

    /**
     * 删除
     */
    @RequestMapping("/delete")
    public R delete(@RequestBody Long[] ids){
        yonghuService.deleteBatchIds(Arrays.asList(ids));
        return R.ok();
    }
    
    /**
     * 提醒接口
     */
	@RequestMapping("/remind/{columnName}/{type}")
	public R remindCount(@PathVariable("columnName") String columnName, HttpServletRequest request, 
						 @PathVariable("type") String type,@RequestParam Map<String, Object> map) {
		map.put("column", columnName);
		map.put("type", type);
		
		if(type.equals("2")) {
			SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
			Calendar c = Calendar.getInstance();
			Date remindStartDate = null;
			Date remindEndDate = null;
			if(map.get("remindstart")!=null) {
				Integer remindStart = Integer.parseInt(map.get("remindstart").toString());
				c.setTime(new Date()); 
				c.add(Calendar.DAY_OF_MONTH,remindStart);
				remindStartDate = c.getTime();
				map.put("remindstart", sdf.format(remindStartDate));
			}
			if(map.get("remindend")!=null) {
				Integer remindEnd = Integer.parseInt(map.get("remindend").toString());
				c.setTime(new Date());
				c.add(Calendar.DAY_OF_MONTH,remindEnd);
				remindEndDate = c.getTime();
				map.put("remindend", sdf.format(remindEndDate));
			}
		}
		
		Wrapper<YonghuEntity> wrapper = new EntityWrapper<YonghuEntity>();
		if(map.get("remindstart")!=null) {
			wrapper.ge(columnName, map.get("remindstart"));
		}
		if(map.get("remindend")!=null) {
			wrapper.le(columnName, map.get("remindend"));
		}


		int count = yonghuService.selectCount(wrapper);
		return R.ok().put("count", count);
	}
	


}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值