考勤汇总功能搞不定

cnjszd

我试着输入了考勤报审的一个部门的数据，就登记了一天所有员工正常出勤，然后，去看汇总，添加该部门员工后，进行汇总，提示：汇总完成！结果汇总报表数据为空，重新汇总，就会报错。我不知道到底怎么样才能汇总，这个考勤原理到底是什么，不需要设置班次的吗？

lixin_justep

正在查看问题，请稍等

lixin_justep

lixin_justep 发表于 2013-9-26 10:23
正在查看问题，请稍等

测试了一下，没有报错，添加人员是没有出数据，统计整个部门是有数据的。楼主是取得最新资源吗？ 把控制台的详细信息帖一下。
考勤设计原理：在考勤报审中录入每天的考勤数据，
在考勤汇总中，根据报审中录入的考勤项，汇总指定部门人员的考勤数据。

指定人员考勤不出数据正在检查，尽快回复

lixin_justep

lixin_justep 发表于 2013-9-26 10:33
测试了一下，没有报错，添加人员是没有出数据，统计整个部门是有数据的。楼主是取得最新资源吗？ 把控制 ...

经检查，确认界面有缺陷，系统不支持对指定人员的考勤汇总，只能对一个指定的部门进行统一汇总。
考勤报审后，要审批，并结束流程汇总中才能出数据。楼主说的错误，没有重现

cnjszd

lixin_justep 发表于 2013-9-26 11:32
经检查，确认界面有缺陷，系统不支持对指定人员的考勤汇总，只能对一个指定的部门进行统一汇总。
考勤报 ...

我走完两天的考勤上报流程了，然后进行汇总，又出现如图所示，详细内容如下：

com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
at com.justep.system.action.Engine.invokeActions(Unknown Source)
at com.justep.business.server.BusinessServer.doAction(Unknown Source)
at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at com.justep.system.action.Engine.invokeActions(Native Method)
... 21 more
Caused by: com.justep.model.exception.ModelException: 执行ksql:update HR_EP_Pluralism p set p.fFID = (select concat((select o.fFID from HR_OG_OrgPosition o where o = p.fPositionID), '/' , (select e from HR_EP_Employee e where e = p.fMasterID), '.psm') from HR_EP_Pluralism pp), p.fFCode = (select concat((select o.fFCode from HR_OG_OrgPosition o where o = p.fPositionID) , '/' , (select e.fCode from HR_EP_Employee e where e = p.fMasterID)) from HR_EP_Pluralism pp), p.fFName = (select concat((select o.fFName from HR_OG_OrgPosition o where o = p.fPositionID), '/' , (select e.fName from HR_EP_Employee e where e = p.fMasterID)) from HR_EP_Pluralism pp) where p.fPositionID is not null时出错！
at com.justep.system.data.impl.TableUtilsImplement.ksqlUpdate(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at x5hr.utils.HROrgURL.regenerateHRPluralismURLByFilter(HROrgURL.java:312)
at x5hr.utils.HROrgURL.regenerateHRPluralismURLByOrgURLs(HROrgURL.java:331)
at x5hr.utils.HROrgURL.regenerateHROrgURL(HROrgURL.java:24)
at HRSysTools.regenerateHRURL(HRSysTools.java:20)
... 26 more
Caused by: com.justep.model.exception.ModelException: 执行sql：UPDATE HR_EP_Pluralism SET HR_EP_Pluralism.FFID = (SELECT (SELECT o.FFID AS fFID FROM HR_OG_OrgPosition o WHERE o.fID = HR_EP_Pluralism.FPOSITIONID) + ? + (SELECT e.fID FROM HR_EP_Employee e WHERE e.fID = HR_EP_Pluralism.fMasterID) + ? FROM HR_EP_Pluralism pp), HR_EP_Pluralism.FFCODE = (SELECT (SELECT o.FFCODE AS fFCode FROM HR_OG_OrgPosition o WHERE o.fID = HR_EP_Pluralism.FPOSITIONID) + ? + (SELECT e.FCODE AS fCode FROM HR_EP_Employee e WHERE e.fID = HR_EP_Pluralism.fMasterID) FROM HR_EP_Pluralism pp), HR_EP_Pluralism.FFNAME = (SELECT (SELECT o.FFNAME AS fFName FROM HR_OG_OrgPosition o WHERE o.fID = HR_EP_Pluralism.FPOSITIONID) + ? + (SELECT e.FNAME AS fName FROM HR_EP_Employee e WHERE e.fID = HR_EP_Pluralism.fMasterID) FROM HR_EP_Pluralism pp) WHERE HR_EP_Pluralism.FPOSITIONID IS NOT NULL, binds:[/, .psm, /, /]出错！
at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
... 35 more
Caused by: java.sql.SQLException: 子查询返回的值不止一个。当子查询跟随在 =、!=、<、<=、>、>= 之后，或子查询用作表达式时，这种情况是不允许的。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
... 36 more

url:/UI/system/service/common/bizAction.j
param:undefined
at (http://127.0.0.1:8080/x5/$v62d6e5ae49ef4edabd1be8acff3628d1/base/base.js?language=zh_CN:1)

lixin_justep

cnjszd 发表于 2013-9-29 15:44
我走完两天的考勤上报流程了，然后进行汇总，又出现如图所示，详细内容如下：

com.justep.model.excepti ...

请问楼主是最新资源吗？

lixin_justep

lixin_justep 发表于 2013-10-9 09:53
请问楼主是最新资源吗？

执行ksql报错的原因应该跟这个帖子的原因一样
http://bbs.justep.com/forum.php? ... &extra=page%3D1

zzv

这个问题我没出现啊