基于javaweb和mysql的springboot超市进销存系统(java+springboot+maven+mybaits+vue+elementui+mysql)

私信源码获取及调试交流

私信源码获取及调试交流

运行环境

Java≥8、MySQL≥5.7、Node.js≥14

开发工具

后端：eclipse/idea/myeclipse/sts等均可配置运行

前端：WebStorm/VSCode/HBuilderX等均可

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb的SpringBoot超市进销存系统(java+springboot+maven+mybaits+vue+elementui+mysql)

角色：管理员、员工

管理员：管理员登录进入超市进销存系统可以查看首页、个人中心、员工管理、客户管理、供应商管理、承运商管理、仓库信息管理、商品类别管理、 商品信息管理、采购信息管理、入库信息管理、出库信息管理、销售订单管理、部门管理、岗位管理等功能

员工：员工登录进入超市进销存系统可以查看首页、个人中心、仓库信息管理、 商品信息管理、采购信息管理、入库信息管理、出库信息管理、销售订单管理等功能

技术栈

后端：SpringBoot+Mybaits

前端：Vue+ElementUI

 * 承运商
 * 后端接口
 * @email 
 */
@RestController
@RequestMapping("/chengyunshang")
public class ChengyunshangController {
    @Autowired
    private ChengyunshangService chengyunshangService;

    

    /**
     * 后端列表
     */
    @RequestMapping("/page")
    public R page(@RequestParam Map<String, Object> params,ChengyunshangEntity chengyunshang,
		HttpServletRequest request){
        EntityWrapper<ChengyunshangEntity> ew = new EntityWrapper<ChengyunshangEntity>();
		PageUtils page = chengyunshangService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, chengyunshang), params), params));

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

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

     * 保存
     */
    @PostMapping("/save")
    public R save(@RequestBody UserEntity user){
//    	ValidatorUtils.validateEntity(user);
    	if(userService.selectOne(new EntityWrapper<UserEntity>().eq("username", user.getUsername())) !=null) {
    		return R.error("用户已存在");
    	}
        userService.insert(user);
        return R.ok();
    }

    /**
     * 修改
     */
    @RequestMapping("/update")
    public R update(@RequestBody UserEntity user){
//        ValidatorUtils.validateEntity(user);
    	UserEntity u = userService.selectOne(new EntityWrapper<UserEntity>().eq("username", user.getUsername()));
    	if(u!=null && u.getId()!=user.getId() && u.getUsername().equals(user.getUsername())) {
    		return R.error("用户名已存在。");
    	}
        userService.updateById(user);//全部更新
        return R.ok();
    }

    /**
     * 删除
     */
    @RequestMapping("/delete")
    public R delete(@RequestBody Long[] ids){
        userService.deleteBatchIds(Arrays.asList(ids));
        return R.ok();
    }
}

			chukuxinxi.setYuangongzhanghao((String)request.getSession().getAttribute("username"));
		}
        EntityWrapper<ChukuxinxiEntity> ew = new EntityWrapper<ChukuxinxiEntity>();
		PageUtils page = chukuxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, chukuxinxi), params), params));

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

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

	 /**
     * 查询
     */
    @RequestMapping("/query")
    public R query(ChukuxinxiEntity chukuxinxi){
        EntityWrapper< ChukuxinxiEntity> ew = new EntityWrapper< ChukuxinxiEntity>();
 		ew.allEq(MPUtil.allEQMapPre( chukuxinxi, "chukuxinxi")); 
		ChukuxinxiView chukuxinxiView =  chukuxinxiService.selectView(ew);
		return R.ok("查询出库信息成功").put("data", chukuxinxiView);
    }

/**
 * 员工
 * 后端接口
 * @email 
 */
@RestController
@RequestMapping("/yuangong")
public class YuangongController {
    @Autowired
    private YuangongService yuangongService;

    
	@Autowired
	private TokenService tokenService;

/**
 * 客户
 * 后端接口
 * @email 
 */
@RestController
@RequestMapping("/kehu")
public class KehuController {
    @Autowired
    private KehuService kehuService;

    

    

    /**
     * 后端列表
     */
    @RequestMapping("/page")
    public R page(@RequestParam Map<String, Object> params,KehuEntity kehu,
		HttpServletRequest request){
        EntityWrapper<KehuEntity> ew = new EntityWrapper<KehuEntity>();
		PageUtils page = kehuService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, kehu), params), params));

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

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

	 /**
     * 查询
     */
    @RequestMapping("/query")
    public R query(KehuEntity kehu){
        EntityWrapper< KehuEntity> ew = new EntityWrapper< KehuEntity>();
 		ew.allEq(MPUtil.allEQMapPre( kehu, "kehu")); 
		KehuView kehuView =  kehuService.selectView(ew);
		return R.ok("查询客户成功").put("data", kehuView);
    }
	
    /**
     * 后端详情
     */
    @RequestMapping("/info/{id}")

			xiaoshoudingdan.setYuangongzhanghao((String)request.getSession().getAttribute("username"));
		}
        EntityWrapper<XiaoshoudingdanEntity> ew = new EntityWrapper<XiaoshoudingdanEntity>();
		PageUtils page = xiaoshoudingdanService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, xiaoshoudingdan), params), params));

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

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

	 /**
     * 查询
     */
    @RequestMapping("/query")
    public R query(XiaoshoudingdanEntity xiaoshoudingdan){
        EntityWrapper< XiaoshoudingdanEntity> ew = new EntityWrapper< XiaoshoudingdanEntity>();
 		ew.allEq(MPUtil.allEQMapPre( xiaoshoudingdan, "xiaoshoudingdan")); 
		XiaoshoudingdanView xiaoshoudingdanView =  xiaoshoudingdanService.selectView(ew);
		return R.ok("查询销售订单成功").put("data", xiaoshoudingdanView);
    }
	
    /**
     * 后端详情
     */

        shangpinleibieService.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<ShangpinleibieEntity> wrapper = new EntityWrapper<ShangpinleibieEntity>();
		if(map.get("remindstart")!=null) {
			wrapper.ge(columnName, map.get("remindstart"));
		}
		if(map.get("remindend")!=null) {
			wrapper.le(columnName, map.get("remindend"));
		}

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

    }
}

/**
 * 上传文件映射表
 */
@RestController
@RequestMapping("file")

	@IgnoreAuth
	@RequestMapping("/option/{tableName}/{columnName}")
	public R getOption(@PathVariable("tableName") String tableName, @PathVariable("columnName") String columnName,String level,String parent) {
		Map<String, Object> params = new HashMap<String, Object>();
		params.put("table", tableName);
		params.put("column", columnName);
		if(StringUtils.isNotBlank(level)) {
			params.put("level", level);
		}
		if(StringUtils.isNotBlank(parent)) {
			params.put("parent", parent);
		}
		List<String> data = commonService.getOption(params);
		return R.ok().put("data", data);
	}
	
	/**
	 * 根据table中的column获取单条记录
	 * @param table
	 * @param column
	 * @return
	 */
	@IgnoreAuth
	@RequestMapping("/follow/{tableName}/{columnName}")
	public R getFollowByOption(@PathVariable("tableName") String tableName, @PathVariable("columnName") String columnName, @RequestParam String columnValue) {
		Map<String, Object> params = new HashMap<String, Object>();
		params.put("table", tableName);
		params.put("column", columnName);
		params.put("columnValue", columnValue);
		Map<String, Object> result = commonService.getFollowByOption(params);
		return R.ok().put("data", result);
	}
	
	/**
	 * 修改table表的sfsh状态
	 * @param table
	 * @param map
	 * @return
	 */
	@RequestMapping("/sh/{tableName}")
	public R sh(@PathVariable("tableName") String tableName, @RequestBody Map<String, Object> map) {
		map.put("table", tableName);

/**
 * 员工
 * 后端接口
 * @email 
 */
@RestController
@RequestMapping("/yuangong")
public class YuangongController {
    @Autowired
    private YuangongService yuangongService;

    
	@Autowired
	private TokenService tokenService;
	
	/**
	 * 登录
	 */
	@IgnoreAuth

/**
 * 供应商
 * 后端接口
 * @email 
 */
@RestController
@RequestMapping("/gongyingshang")
public class GongyingshangController {
    @Autowired
    private GongyingshangService gongyingshangService;

    

    /**
     * 后端列表
     */
    @RequestMapping("/page")
    public R page(@RequestParam Map<String, Object> params,GongyingshangEntity gongyingshang,
		HttpServletRequest request){
        EntityWrapper<GongyingshangEntity> ew = new EntityWrapper<GongyingshangEntity>();
		PageUtils page = gongyingshangService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, gongyingshang), params), params));

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

	/**
     * 列表
     */
    @RequestMapping("/lists")
    public R list( GongyingshangEntity gongyingshang){
       	EntityWrapper<GongyingshangEntity> ew = new EntityWrapper<GongyingshangEntity>();

    public R query(XiaoshoudingdanEntity xiaoshoudingdan){
        EntityWrapper< XiaoshoudingdanEntity> ew = new EntityWrapper< XiaoshoudingdanEntity>();
 		ew.allEq(MPUtil.allEQMapPre( xiaoshoudingdan, "xiaoshoudingdan")); 
		XiaoshoudingdanView xiaoshoudingdanView =  xiaoshoudingdanService.selectView(ew);
		return R.ok("查询销售订单成功").put("data", xiaoshoudingdanView);
    }
	
    /**
     * 后端详情
     */
    @RequestMapping("/info/{id}")
    public R info(@PathVariable("id") Long id){
        XiaoshoudingdanEntity xiaoshoudingdan = xiaoshoudingdanService.selectById(id);
        return R.ok().put("data", xiaoshoudingdan);
    }

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

    /**
     * 后端保存
     */
    @RequestMapping("/save")
    public R save(@RequestBody XiaoshoudingdanEntity xiaoshoudingdan, HttpServletRequest request){
    	xiaoshoudingdan.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(xiaoshoudingdan);
        xiaoshoudingdanService.insert(xiaoshoudingdan);
        return R.ok();
    }
    
    /**
     * 前端保存
     */
    @RequestMapping("/add")
    public R add(@RequestBody XiaoshoudingdanEntity xiaoshoudingdan, HttpServletRequest request){
    	xiaoshoudingdan.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(xiaoshoudingdan);
        xiaoshoudingdanService.insert(xiaoshoudingdan);
        return R.ok();
    }

/**
 * 供应商
 * 后端接口
 * @email 
 */
@RestController
@RequestMapping("/gongyingshang")
public class GongyingshangController {
    @Autowired
    private GongyingshangService gongyingshangService;

    

    /**
     * 后端列表
     */
    @RequestMapping("/page")
    public R page(@RequestParam Map<String, Object> params,GongyingshangEntity gongyingshang,
		HttpServletRequest request){
        EntityWrapper<GongyingshangEntity> ew = new EntityWrapper<GongyingshangEntity>();
		PageUtils page = gongyingshangService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, gongyingshang), params), params));

        return R.ok().put("data", page);
    }
    
    /**
     * 前端列表
     */
	@IgnoreAuth

    

    /**
     * 后端列表
     */
    @RequestMapping("/page")
    public R page(@RequestParam Map<String, Object> params,CaigouxinxiEntity caigouxinxi,
		HttpServletRequest request){
		String tableName = request.getSession().getAttribute("tableName").toString();
		if(tableName.equals("yuangong")) {
			caigouxinxi.setYuangongzhanghao((String)request.getSession().getAttribute("username"));
		}
        EntityWrapper<CaigouxinxiEntity> ew = new EntityWrapper<CaigouxinxiEntity>();
		PageUtils page = caigouxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, caigouxinxi), params), params));

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

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

	 /**
     * 查询
     */
    @RequestMapping("/query")
    public R query(CaigouxinxiEntity caigouxinxi){

		return R.ok("查询采购信息成功").put("data", caigouxinxiView);
    }
	
    /**
     * 后端详情
     */
    @RequestMapping("/info/{id}")
    public R info(@PathVariable("id") Long id){
        CaigouxinxiEntity caigouxinxi = caigouxinxiService.selectById(id);
        return R.ok().put("data", caigouxinxi);
    }

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

    /**
     * 后端保存
     */
    @RequestMapping("/save")
    public R save(@RequestBody CaigouxinxiEntity caigouxinxi, HttpServletRequest request){
    	caigouxinxi.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(caigouxinxi);
        caigouxinxiService.insert(caigouxinxi);
        return R.ok();
    }
    
    /**
     * 前端保存
     */
    @RequestMapping("/add")
    public R add(@RequestBody CaigouxinxiEntity caigouxinxi, HttpServletRequest request){
    	caigouxinxi.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(caigouxinxi);
        caigouxinxiService.insert(caigouxinxi);
        return R.ok();

/**
 * 采购信息
 * 后端接口
 * @email 
 */
@RestController
@RequestMapping("/caigouxinxi")

        xiaoshoudingdanService.insert(xiaoshoudingdan);
        return R.ok();
    }

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

    /**
     * 删除
     */
    @RequestMapping("/delete")
    public R delete(@RequestBody Long[] ids){
        xiaoshoudingdanService.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());