Java源码社

基于javaweb的SpringBoot办公erp管理系统(java+springboot+easyui+maven+mysql+html)

更新于

运行环境

Java≥8、MySQL≥5.7

开发工具

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

适用

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

功能说明

050023192402

060023192402

070023192402

080023192402

090023192402

100023192402

110023192402

基于javaweb的SpringBoot办公erp管理系统(java+springboot+easyui+maven+mysql+html)

项目介绍

系统主要功能包括： 首页 零售管理：零售出库、零售退货； 采购管理：采购订单、采购入库、采购退货； 销售管理：销售订单、销售出库、销售退货； 仓库管理：其它入库、其它出库、调拨出库、组装单、拆卸单； 财务管理：收入单、支出单、收款单、付款单、转账单、收预付款； 报表查询：库存状况、结算账户、进货统计、销售统计、入库明细、出库明细、入库汇总、出库汇总、客户对账、供应商对账、库存预警； 商品管理：商品类别、商品信息、计量单位、序列号； 基本资料：供应商信息、客户信息、会员信息、仓库信息、收支项目、结算账户、经手人管理；

系统管理：角色管理、机构管理、用户管理、日志管理、系统配置；

环境需要

1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。
2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;
3.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS；
4.数据库：MySql 5.7或8.0版本；

技术栈

  • 核心框架：SpringBoot 2.0.0 * 持久层框架：Mybatis 1.3.2 * 日志管理：Log4j 2.10.0 * JS框架：Jquery 1.8.0 * UI框架: EasyUI 1.3.5 * 模板框架: AdminLTE 2.4.0

  • 项目管理框架: Maven 3.2.3

使用说明
浏览器地址访问登录页面http://localhost:8080/login.html
默认管理员账号：admin，管理员账号一些特殊模块不具有修改权限，建议使用普通账号：jsh，密码都为123456

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
 * @param materialIds
 * @param mpList
 * @param request
 * @return
 */
@PostMapping(value = "/buyIn")
public BaseResponseInfo buyIn(@RequestParam("currentPage") Integer currentPage,
                                  @RequestParam("pageSize") Integer pageSize,
                                  @RequestParam("monthTime") String monthTime,
                                  @RequestParam("headIds") String headIds,
                                  @RequestParam("materialIds") String materialIds,
                                  @RequestParam("mpList") String mpList,
                                  HttpServletRequest request)throws Exception {
    BaseResponseInfo res = new BaseResponseInfo();
    Map<String, Object> map = new HashMap<String, Object>();
    try {
        List<DepotItemVo4WithInfoEx> dataList = depotItemService.findByAll(headIds, materialIds, (currentPage-1)*pageSize, pageSize);
        String[] mpArr = mpList.split(",");
        int total = depotItemService.findByAllCount(headIds, materialIds);
        map.put("total", total);
        //存放数据json数组
        JSONArray dataArray = new JSONArray();
        if (null != dataList) {
            for (DepotItemVo4WithInfoEx diEx : dataList) {
                JSONObject item = new JSONObject();
                BigDecimal InSum = depotItemService.buyOrSale("入库", "采购", diEx.getMId(), monthTime, "number");
                BigDecimal OutSum = depotItemService.buyOrSale("出库", "采购退货", diEx.getMId(), monthTime, "number");
                BigDecimal InSumPrice = depotItemService.buyOrSale("入库", "采购", diEx.getMId(), monthTime, "price");
                BigDecimal OutSumPrice = depotItemService.buyOrSale("出库", "采购退货", diEx.getMId(), monthTime, "price");
                item.put("MaterialName", diEx.getMName());
                item.put("MaterialModel", diEx.getMModel());
                //扩展信息
                String materialOther = getOtherInfo(mpArr, diEx);
                item.put("MaterialOther", materialOther);
                item.put("MaterialColor", diEx.getMColor());
                item.put("MaterialUnit", diEx.getMaterialUnit());
                item.put("UName", diEx.getUName());
                item.put("InSum", InSum);
                item.put("OutSum", OutSum);
                item.put("InSumPrice", InSumPrice);
                item.put("OutSumPrice", OutSumPrice);
                dataArray.add(item);
            }
        }
        map.put("rows", dataArray);
        res.code = 200;
        res.data = map;
    } catch(Exception e){
        e.printStackTrace();
        res.code = 500;
        res.data = "获取数据失败";
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
/**
 * 删除的可以继续卖，删除的需要将使用的序列号回收
 * 插入的需要判断当前货源是否充足
 * 更新的需要判断货源是否充足
 * */
if (null != deletedJson) {
    StringBuffer bf=new StringBuffer();
    for (int i = 0; i < deletedJson.size(); i++) {
        //首先回收序列号，如果是调拨，不用处理序列号
        JSONObject tempDeletedJson = JSONObject.parseObject(deletedJson.getString(i));
        if(BusinessConstants.DEPOTHEAD_TYPE_OUT.equals(depotHead.getType())
                &&!BusinessConstants.SUB_TYPE_TRANSFER.equals(depotHead.getSubtype())){
            DepotItem depotItem = getDepotItem(tempDeletedJson.getLong("Id"));
            if(depotItem==null){
                continue;
            }
            /**
             * 判断商品是否开启序列号，开启的收回序列号，未开启的跳过
             * */
            Material material= materialService.getMaterial(depotItem.getMaterialid());
            if(material==null){
                continue;
            }
            if(BusinessConstants.ENABLE_SERIAL_NUMBER_ENABLED.equals(material.getEnableserialnumber())){
                serialNumberService.cancelSerialNumber(depotItem.getMaterialid(),depotItem.getHeaderid(),(depotItem.getBasicnumber()==null?0:depotItem.getBasicnumber()).intValue(),
                        userInfo);
            }
        }
        this.deleteDepotItem(tempDeletedJson.getLong("Id"), request);
        bf.append(tempDeletedJson.getLong("Id"));
        if(i<(deletedJson.size()-1)){
            bf.append(",");
        }
    }
    this.batchDeleteDepotItemByIds(bf.toString());
}
if (null != insertedJson) {
    for (int i = 0; i < insertedJson.size(); i++) {
        DepotItem depotItem = new DepotItem();
        JSONObject tempInsertedJson = JSONObject.parseObject(insertedJson.getString(i));
        depotItem.setHeaderid(headerId);
        depotItem.setMaterialid(tempInsertedJson.getLong("MaterialId"));
        depotItem.setMunit(tempInsertedJson.getString("Unit"));
        if (!StringUtil.isEmpty(tempInsertedJson.get("OperNumber").toString())) {
            depotItem.setOpernumber(tempInsertedJson.getBigDecimal("OperNumber"));
            try {
                String Unit = tempInsertedJson.get("Unit").toString();
                BigDecimal oNumber = tempInsertedJson.getBigDecimal("OperNumber");
                Long mId = Long.parseLong(tempInsertedJson.get("MaterialId").toString());
                /***
                 * 为什么调用的方法要先把基础单位去掉，去掉之后后续还能获取到？
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
if(StringUtils.isEmpty(ids)){
    return deleteTotal;
}
String [] idArray=ids.split(",");
/**
 * 校验财务主表	jsh_accounthead
 * */
List<AccountHead> accountHeadList=null;
try{
    accountHeadList = accountHeadMapperEx.getAccountHeadListByAccountIds(idArray);
}catch(Exception e){
    JshException.readFail(logger, e);
}
if(accountHeadList!=null&&accountHeadList.size()>0){
    logger.error("异常码[{}],异常提示[{}],参数,AccountIds[{}]",
            ExceptionConstants.DELETE_FORCE_CONFIRM_CODE,ExceptionConstants.DELETE_FORCE_CONFIRM_MSG,ids);
    throw new BusinessRunTimeException(ExceptionConstants.DELETE_FORCE_CONFIRM_CODE,
            ExceptionConstants.DELETE_FORCE_CONFIRM_MSG);
}
/**
 * 校验财务子表	jsh_accountitem
 * */
List<AccountItem> accountItemList=null;
try{
    accountItemList = accountItemMapperEx.getAccountItemListByAccountIds(idArray);
}catch(Exception e){
    JshException.readFail(logger, e);
}
if(accountItemList!=null&&accountItemList.size()>0){
    logger.error("异常码[{}],异常提示[{}],参数,AccountIds[{}]",
            ExceptionConstants.DELETE_FORCE_CONFIRM_CODE,ExceptionConstants.DELETE_FORCE_CONFIRM_MSG,ids);
    throw new BusinessRunTimeException(ExceptionConstants.DELETE_FORCE_CONFIRM_CODE,
            ExceptionConstants.DELETE_FORCE_CONFIRM_MSG);
}
/**
 * 校验单据主表	jsh_depothead
 * */
List<DepotHead> depotHeadList =null;
try{
    depotHeadList = depotHeadMapperEx.getDepotHeadListByAccountIds(idArray);
}catch(Exception e){
    JshException.readFail(logger, e);
}
if(depotHeadList!=null&&depotHeadList.size()>0){
    logger.error("异常码[{}],异常提示[{}],参数,AccountIds[{}]",
            ExceptionConstants.DELETE_FORCE_CONFIRM_CODE,ExceptionConstants.DELETE_FORCE_CONFIRM_MSG,ids);
    throw new BusinessRunTimeException(ExceptionConstants.DELETE_FORCE_CONFIRM_CODE,
            ExceptionConstants.DELETE_FORCE_CONFIRM_MSG);
}
/**
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35


@Service
public class DepotHeadService {
    private Logger logger = LoggerFactory.getLogger(DepotHeadService.class);

    @Resource
    private DepotHeadMapper depotHeadMapper;
    @Resource
    private DepotHeadMapperEx depotHeadMapperEx;
    @Resource
    private UserService userService;
    @Resource
    DepotItemService depotItemService;
    @Resource
    private SupplierService supplierService;
    @Resource
    private SerialNumberService serialNumberService;
    @Resource
    DepotItemMapperEx depotItemMapperEx;
    @Resource
    private LogService logService;


    public DepotHead getDepotHead(long id)throws Exception {
        DepotHead result=null;
        try{
            result=depotHeadMapper.selectByPrimaryKey(id);
        }catch(Exception e){
            JshException.readFail(logger, e);
        }
        return result;
    }

    public List<DepotHead> getDepotHead()throws Exception {
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
    BaseResponseInfo res = new BaseResponseInfo();
    Map<String, Object> map = new HashMap<String, Object>();
    Long tenantId = Long.parseLong(request.getSession().getAttribute("tenantId").toString());
    try {
        List<DepotItemVo4WithInfoEx> dataList = depotItemService.findByAll(headIds, materialIds, null, null);
        BigDecimal thisAllPrice = BigDecimal.ZERO;
        if (null != dataList) {
            for (DepotItemVo4WithInfoEx diEx : dataList) {
                Long mId = diEx.getMId();
                BigDecimal thisSum = depotItemService.getStockByParam(depotId,mId,null,null,tenantId);
                BigDecimal unitPrice = getUnitPrice(diEx.getPresetPriceOne(), diEx.getPriceStrategy());
                thisAllPrice = thisAllPrice.add(thisSum.multiply(unitPrice));
            }
        }
        map.put("totalCount", thisAllPrice);
        res.code = 200;
        res.data = map;
    } catch(Exception e){
        e.printStackTrace();
        res.code = 500;
        res.data = "获取数据失败";
    }
    return res;
}

/**
 * 进货统计
 * @param currentPage
 * @param pageSize
 * @param monthTime
 * @param headIds
 * @param materialIds
 * @param mpList
 * @param request
 * @return
 */
@PostMapping(value = "/buyIn")
public BaseResponseInfo buyIn(@RequestParam("currentPage") Integer currentPage,
                                  @RequestParam("pageSize") Integer pageSize,
                                  @RequestParam("monthTime") String monthTime,
                                  @RequestParam("headIds") String headIds,
                                  @RequestParam("materialIds") String materialIds,
                                  @RequestParam("mpList") String mpList,
                                  HttpServletRequest request)throws Exception {
    BaseResponseInfo res = new BaseResponseInfo();
    Map<String, Object> map = new HashMap<String, Object>();
    try {
        List<DepotItemVo4WithInfoEx> dataList = depotItemService.findByAll(headIds, materialIds, (currentPage-1)*pageSize, pageSize);
        String[] mpArr = mpList.split(",");
        int total = depotItemService.findByAllCount(headIds, materialIds);
        map.put("total", total);
        //存放数据json数组
        JSONArray dataArray = new JSONArray();
        if (null != dataList) {

项目链接：
https://javayms.github.io?id=211422302105200ga
https://javayms.pages.dev?id=211422302105200ga