【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);
}
}