你好，给用户分配按钮权限，页面加载不出所有的按钮权限，无法分配按钮权限。

支持扫码枪扫码录入商品条码吗？

请问一下，ERP登录界面的租户注册如何隐藏掉，注册没有审核机制，随便都可以注册

配置过程中都很正常./start.sh也没有报错，登陆时显示登陆失败查询服务异常，请问是数据库的原因吗

序列号支持的太简单了，我们几千上万个，你用逗号，输入到什么时候

使用现成打包好的项目，启动项目后日志输出如下错误信息

2022/10/22-18:47:23 DEBUG [http-nio-9999-exec-10] com.jsh.erp.datasource.mappers.RoleMapperEx.getRoleWithoutTenant - <==      Total: 0
java.lang.NullPointerException
        at com.jsh.erp.service.redis.RedisService.storageObjectBySession(RedisService.java:77)
        at com.jsh.erp.controller.UserController.login(UserController.java:147)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)
        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:870)
        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:776)
        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:978)
        at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:881)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:855)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at com.jsh.erp.filter.LogCostFilter.doFilter(LogCostFilter.java:64)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Unknown Source)
2022/10/22-18:47:23 ERROR [http-nio-9999-exec-10] com.jsh.erp.controller.UserController - null

后台报错
2021/08/17-10:56:56 ERROR [http-nio-9999-exec-4] com.jsh.erp.controller.UserController - Cannot get Jedis connection; nested exception is redis.clients.jedis.exceptions.JedisDataException: ERR AUTH called without any password configured for the default user. Are you sure your configuration is correct

所有有优惠金额编辑选项的单据编辑界面的其他费用可以在多行选择相同的费用项目。
此时如果输入了不同的金额，保存再打开就变成相同的金额。
然后再将其他费用逐一取消，将所有条目取消之后最后合计不为零，可能是正数也可能是负数。
编辑前：

编辑后：

然后逐一取消：

服务器环境，centos 7
客户端环境：edge和safari和chrome都无法弹出菜单

前端项目运行npm run build打包时候报错

亲测好用，跟外面的那些妖艳贱货完全不一样，直接部署启动，根据个人环境部署，

这是由于Lombok版本低导致的问题，建议将版本更新一下为最近的版本

2.2.1
容器化部署 MariaDB
编写 Dockerfile 文件构建 mysql 镜像，要求基于 centos 完成 MariaDB 数据库的
安装和配置，并设置服务开机自启。
2.2.2
容器化部署 Redis
编写 Dockerfile 文件构建 redis 镜像，要求基于 centos 完成 Redis 服务的安装和
配置，并设置服务开机自启。
2.2.3
容器化部署 Nginx
编写 Dockerfile 文件构建 nginx 镜像，要求基于 centos 完成 Nginx 服务的安装
和配置，并设置服务开机自启。
2.2.4
容器化部署 ERP
编写 Dockerfile 文件构建 erp 镜像，要求基于 centos 完成 JDK 环境和 ERP 服务
的安装与配置，并设置服务开机自启。
2.2.5
编排部署 ERP 管理系统
编写 docker-compose.yaml 文件，要求使用镜像 mysql、redis、nginx 和 erp 完成
ERP 管理系统的编排部署。

SQL: SELECT m.*, u.name unitName, mc.name categoryName, me.bar_code, me.purchase_decimal, me.commodity_decimal, me.wholesale_decimal, me.low_decimal, me.sku FROM jsh_material m LEFT JOIN jsh_material_extend me ON me.tenant_id = 63 AND m.id = me.material_id AND ifnull(me.delete_Flag, '0') != '1' LEFT JOIN jsh_unit u ON u.tenant_id = 63 AND m.unit_id = u.id AND ifnull(u.delete_Flag, '0') != '1' LEFT JOIN jsh_material_category mc ON mc.tenant_id = 63 AND m.category_id = mc.id AND ifnull(mc.delete_Flag, '0') != '1' WHERE m.tenant_id = 63 AND 1 = 1 AND (me.bar_code LIKE ? OR m.name LIKE ? OR m.standard LIKE ? OR m.model LIKE ?) AND ifnull(m.delete_flag, '0') != '1' GROUP BY m.id ORDER BY m.id DESC LIMIT ?, ?
Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #24 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'erp.me.bar_code' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #24 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'erp.me.bar_code' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

应该是对应sql（MaterialMapperEx.xml -> selectByConditionMaterial）中group by的列名不全GROUP BY m.id后面加上u.name, mc.name, me.bar_code, me.purchase_decimal, me.commodity_decimal, me.wholesale_decimal, me.low_decimal, me.sku就好了

ERROR Failed to compile with 1 errors 09:22:26

error in ./src/components/NumberInfo/NumberInfo.vue?vue&type=style&index=0&id=4370c5af&lang=less&scoped=true&

Module build failed (from ./node_modules/vue-loader/lib/loaders/stylePostLoader.js):
TypeError: Cannot set properties of undefined (setting 'parent')
at C:\alan_work\JSH_ERP\jshERP-web\src\components\NumberInfo\NumberInfo.vue:1282:1
at Root.insertAfter (C:\alan_work\JSH_ERP\jshERP-web\node_modules@vue\compiler-sfc\dist\compiler-sfc.js:13933:21)
at C:\alan_work\JSH_ERP\jshERP-web\node_modules@vue\compiler-sfc\dist\compiler-sfc.js:17634:30
at Selector.each (C:\alan_work\JSH_ERP\jshERP-web\node_modules@vue\compiler-sfc\dist\compiler-sfc.js:14037:17)
at rewriteSelector (C:\alan_work\JSH_ERP\jshERP-web\node_modules@vue\compiler-sfc\dist\compiler-sfc.js:17566:14)
at C:\alan_work\JSH_ERP\jshERP-web\node_modules@vue\compiler-sfc\dist\compiler-sfc.js:17559:13
at Root.each (C:\alan_work\JSH_ERP\jshERP-web\node_modules@vue\compiler-sfc\dist\compiler-sfc.js:14037:17)
at Processor.func (C:\alan_work\JSH_ERP\jshERP-web\node_modules@vue\compiler-sfc\dist\compiler-sfc.js:17558:22)
at Processor._runSync (C:\alan_work\JSH_ERP\jshERP-web\node_modules@vue\compiler-sfc\dist\compiler-sfc.js:17161:27)
at Processor.processSync (C:\alan_work\JSH_ERP\jshERP-web\node_modules@vue\compiler-sfc\dist\compiler-sfc.js:17256:24)
at processRule (C:\alan_work\JSH_ERP\jshERP-web\node_modules@vue\compiler-sfc\dist\compiler-sfc.js:17561:8)
at Rule (C:\alan_work\JSH_ERP\jshERP-web\node_modules@vue\compiler-sfc\dist\compiler-sfc.js:17503:13)
at LazyResult.visitSync (C:\alan_work\JSH_ERP\jshERP-web\node_modules@vue\compiler-sfc\node_modules\postcss\lib\lazy-result.js:308:19)
at LazyResult.walkSync (C:\alan_work\JSH_ERP\jshERP-web\node_modules@vue\compiler-sfc\node_modules\postcss\lib\lazy-result.js:297:20)
at C:\alan_work\JSH_ERP\jshERP-web\node_modules@vue\compiler-sfc\node_modules\postcss\lib\lazy-result.js:291:39
at Root.each (C:\alan_work\JSH_ERP\jshERP-web\node_modules@vue\compiler-sfc\node_modules\postcss\lib\container.js:41:16)
at LazyResult.walkSync (C:\alan_work\JSH_ERP\jshERP-web\node_modules@vue\compiler-sfc\node_modules\postcss\lib\lazy-result.js:290:16)

@ ./node_modules/vue-style-loader??ref--10-oneOf-1-0!./node_modules/css-loader??ref--10-oneOf-1-1!./node_modules/vue-loader/lib/loaders/stylePostLoad
er.js!./node_modules/postcss-loader/src??ref--10-oneOf-1-2!./node_modules/less-loader/dist/cjs.js??ref--10-oneOf-1-3!./node_modules/cache-loader/dist/
cjs.js??ref--0-0!./node_modules/vue-loader/lib??vue-loader-options!./src/components/NumberInfo/NumberInfo.vue?vue&type=style&index=0&id=4370c5af&lang=
less&scoped=true& 4:14-483 15:3-20:5 16:22-491
@ ./src/components/NumberInfo/NumberInfo.vue?vue&type=style&index=0&id=4370c5af&lang=less&scoped=true&
@ ./src/components/NumberInfo/NumberInfo.vue
@ ./src lazy ^./components.*$ namespace object
@ ./src/utils/util.js
@ ./src/permission.js
@ ./src/main.js
@ multi (webpack)-dev-server/client?http://172.16.1.100:3000/sockjs-node (webpack)/hot/dev-server.js ./src/main.js

mysql版本为5.7.40
报错为org.springframework.jdbc.BadSqlGrammarException:

Error querying database. Cause: java.sql.SQLSyntaxErrorException: Expression #22 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jsh_erp.me.commodity_unit' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

The error may exist in file [F:\IdeaProjects\jxc\jshERP\jshERP-boot\target\classes\mapper_xml\MaterialMapperEx.xml]

The error may involve defaultParameterMap

The error occurred while setting parameters

SQL: SELECT m.*, me.commodity_unit unitName, mc.name categoryName, me.bar_code, ifnull(me.purchase_decimal, 0) purchase_decimal, ifnull(sum(mcs.current_number), 0) currentStock, sum(ifnull(me.purchase_decimal, 0) * ifnull(mcs.current_number, 0)) currentStockPrice FROM jsh_material m LEFT JOIN jsh_material_extend me ON me.tenant_id = 63 AND m.id = me.material_id AND ifnull(me.delete_Flag, '0') != '1' LEFT JOIN jsh_material_current_stock mcs ON mcs.tenant_id = 63 AND m.id = mcs.material_id AND ifnull(mcs.delete_flag, '0') != '1' LEFT JOIN jsh_unit u ON u.tenant_id = 63 AND m.unit_id = u.id AND ifnull(u.delete_Flag, '0') != '1' LEFT JOIN jsh_material_category mc ON mc.tenant_id = 63 AND m.category_id = mc.id AND ifnull(mc.delete_Flag, '0') != '1' WHERE m.tenant_id = 63 AND 1 = 1 AND me.default_flag = 1 AND mcs.depot_id IN (?, ?, ?) AND ifnull(m.delete_flag, '0') != '1' GROUP BY m.id ORDER BY m.id DESC LIMIT ?, ?

Cause: java.sql.SQLSyntaxErrorException: Expression #22 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jsh_erp.me.commodity_unit' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Expression #22 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jsh_erp.me.commodity_unit' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

测试步骤：
1，新增角色
2，给角色分配菜单
3，给角色分配供应商按钮
4，给用户分配橘色
5，登录该用户，查看对应的按钮
6，测试结果：没有分配按钮，但是依然显示

编辑前

编辑后

这里这个和gitee上的华夏ERP是同一个把？为什么两边的版本号不太一致？

   <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>

mapper xml里面的_parameter是在哪赋值的？

Hello 👋

I run a security community that finds and fixes vulnerabilities in OSS. A researcher (@xulei1112) has found a potential issue, which I would be eager to share with you.

Could you add a SECURITY.md file with an e-mail address for me to send further details to? GitHub recommends a security policy to ensure issues are responsibly disclosed, and it would help direct researchers in the future.

Looking forward to hearing from you 👍

(cc @huntr-helper)

1、注册租户A
2、登录admin 用户
3、删除租户A
4、提示“”不能删除自己“”

如图。不知是什么原因。

测试账户 显示用户密码不正确

采购退货绑定的是采购入库单，但并没有生成出库记录，没有减库存，大佬帮看看？

mavne install 生成jar包后
使用docker发布项目无法正常访问
作者是否也遇到过此现象？

老哥你这filter用contains来判断的话，这个容易出大事啊

您好，我是根据个人环境部署运行的，在执行完登陆操作后，进入index.html,但是这个文件是空的呀!什么也看不到。谢谢解答。

尝试在商品管理-计量单位的副单位比例处输入小数（例如0.001，或100.5），点击保存没反应。
查看开发人员工具的网络请求，显示500未知异常。
疑似后台报错。

建议如果出现后台报错的时候页面弹窗显示e.getMessage()信息。🤣

此处是否为已转销售的记录不能再点击审核？
采购订单也有类似问题。

DepotHeadService中的方法

public DepotHead getDepotHead(String number)throws Exception {
        DepotHead depotHead = new DepotHead();
        try{
            DepotHeadExample example = new DepotHeadExample();
            example.createCriteria().andNumberEqualTo(number).andDeleteFlagNotEqualTo(BusinessConstants.DELETE_FLAG_DELETED);
            List<DepotHead> list = depotHeadMapper.selectByExample(example);
            if(null!=list && list.size()>0) {
                depotHead = list.get(0);
            }
        }catch(Exception e){
            JshException.readFail(logger, e);
        }
        return depotHead;
}

DepotHead depotHead = new DepotHead();意味着这个方法永远不会返回空，我观察到有几处调用应该都产生了潜在的BUG：在没有查询到数据时，也走了正常的处理流程。

请问三联打印地址如何配置呢？

好评

找个UI和前端吧，这画风10年前了。

是否可以支持最新版的node版本

部署服务后，使用jsh账号访问，只有查看数据的权限，各种新增修改按钮都没有，数据库jsh_user_business表的btn_str都是空的，使用注册功能新注册的号也是只有查看权限，这个权限要在哪里配置啊，看了后端的注册接口registerUser，插入表数据时也没有看到设置btnStr

有些界面iframe的建议输入的数据和页面缓存，不然页面内多tab也是枉然

前后端安装成功，运行各个服务正常，数据库密码修改了，redis密码也都改了。打开主页报错“很抱歉，资源未找到”，用默认账号密码登陆也报错。

没有直接再财务处理的界面，都是单据结转
不会是财务模块最主要的需要收费吧，我看模块还是比较全，但是财务处理最主要的东西缺少，相当于做了前期工作，后面的财务一个没体现，没有处理没有管理，查询

库存更新为什么要查所有订单,就是为了保证数据准确性吗

一个简单的账户流水, 为什么不建一个流水表来记录, 非要 jsh_depot_head 和 jsh_account_head
**

**

不理解为什么这么写代码, 不在sql 里面, 真是 不良代码规范

还要按照你的要求配环境，运行时又发现好多问题。使用docker多好，保证与作者运行效果一致

商品库存统计没有支持sku多属性商品，例如商品A有两个颜色（白色、黑色），白色库存为0，黑色库存为1，这是个即使是关闭负库存，新增单据用白色商品也会成功，这里是否新增sku逻辑

如题，谢谢。

这份代码是不是没有高级报表的功能