日期类赋值

VANYQ

        Model.prototype.searchData = function(event){
        var day = new Date();
        var year = day.getFullYear();
        var month = day.getMonth();
        var firstdate = year + '-' + month + '-01';
        var lastdate = year + '-' +month + '-' + day.getDate();
        var data = this.comp("reportData1");
        var datadayandweek = this.comp("reportData2");
        data.setValue("st",firstdate);
        data.setValue("et",lastdate);
        datadayandweek.setValue("st",firstdate);
        datadayandweek.setValue("et",lastdate);
        this.comp("report1").refresh();
        };


请问这样写有错吗？总提示我找不到变量 st 对应的值。

VANYQ

控制台报错：

2017-03-19 15:43:21 开始-WINDOW生成中间文件: /UI2/portal/pc/index.w
2017-03-19 15:43:21 结束-WINDOW生成中间文件: /UI2/portal/pc/index.w
2017-03-19 15:43:21 开始-中间文件生成缓存文件: /UI2/portal/pc/index.w
2017-03-19 15:43:21 结束-中间文件生成缓存文件: /UI2/portal/pc/index.w
2017-03-19 15:43:23 开始-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2017-03-19 15:43:23 结束-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2017-03-19 15:43:23 开始-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2017-03-19 15:43:23 结束-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2017-03-19 15:43:24 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
2017-03-19 15:43:24 结束-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
2017-03-19 15:43:24 开始-中间文件生成缓存文件: /UI2/SA/task/taskView/submitActivity.w
2017-03-19 15:43:25 结束-中间文件生成缓存文件: /UI2/SA/task/taskView/submitActivity.w
2017-03-19 15:43:25 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/waitActivity.w
2017-03-19 15:43:25 结束-WINDOW生成中间文件: /UI2/SA/task/taskView/waitActivity.w
2017-03-19 15:43:25 开始-中间文件生成缓存文件: /UI2/SA/task/taskView/waitActivity.w
2017-03-19 15:43:26 结束-中间文件生成缓存文件: /UI2/SA/task/taskView/waitActivity.w
2017-03-19 15:43:27 开始-WINDOW生成中间文件: /UI2/WzAccount/Report/process/CurrentMonthrep/mainActivity.w
2017-03-19 15:43:27 结束-WINDOW生成中间文件: /UI2/WzAccount/Report/process/CurrentMonthrep/mainActivity.w
2017-03-19 15:43:27 开始-中间文件生成缓存文件: /UI2/WzAccount/Report/process/CurrentMonthrep/mainActivity.w
2017-03-19 15:43:27 结束-中间文件生成缓存文件: /UI2/WzAccount/Report/process/CurrentMonthrep/mainActivity.w
2017-03-19 15:43:28 action:<?xml version="1.0" encoding="UTF-8"?>
<action process="/WzAccount/Report/process/CurrentMonthrep/currentMonthrepProcess" activity="mainActivity" action-flag="__action_0__" executor="" execute-context="" name="Ksqldayandweek"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="variables"/></parameters></action>
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        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.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:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        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:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select WZ_dayandweek,WZ_dayandweek.version as version,WZ_dayandweek.fRQ as fRQ,WZ_dayandweek.fXQJ as fXQJ,WZ_dayandweek.fSZXQJ as fSZXQJ,WZ_dayandweek.fRQDW as fRQDW,WZ_dayandweek.fBZ as fBZ from WZ_dayandweek WZ_dayandweek where WZ_dayandweek.fRQ >= :st AND WZ_dayandweek.fRQ <= :et
--> sql:
--> binds: []
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.KSQL.select(Unknown Source)
        at KSQLProcedure.query(KSQLProcedure.java:17)
        ... 27 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154150; 提示: 找不到变量st对应的值
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.check(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.VariableNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.CompExpressionNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.LogicalExpressionNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.WhereNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.SelectSentenceNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.QueryVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.QuerySentence.accept(Unknown Source)
        ... 32 more
[ERROR] 2017-03-19 15:43:28,142 com.justep.report.controller.DataController - 报表数据获取失败
执行KSQL出错, KSQL: select WZ_dayandweek,WZ_dayandweek.version as version,WZ_dayandweek.fRQ as fRQ,WZ_dayandweek.fXQJ as fXQJ,WZ_dayandweek.fSZXQJ as fSZXQJ,WZ_dayandweek.fRQDW as fRQDW,WZ_dayandweek.fBZ as fBZ from WZ_dayandweek WZ_dayandweek where WZ_dayandweek.fRQ >= :st AND WZ_dayandweek.fRQ <= :et
--> sql:
--> binds: []
com.justep.report.exception.ReportServerException: 报表数据获取失败
        at com.justep.report.controller.DataController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.controller.InitController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.Servlet.a(Unknown Source)
        at com.justep.report.Servlet.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        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:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.report.exception.ReportServerException: 执行KSQL出错, KSQL: select WZ_dayandweek,WZ_dayandweek.version as version,WZ_dayandweek.fRQ as fRQ,WZ_dayandweek.fXQJ as fXQJ,WZ_dayandweek.fSZXQJ as fSZXQJ,WZ_dayandweek.fRQDW as fRQDW,WZ_dayandweek.fBZ as fBZ from WZ_dayandweek WZ_dayandweek where WZ_dayandweek.fRQ >= :st AND WZ_dayandweek.fRQ <= :et
--> sql:
--> binds: []
        at com.justep.report.controller.DataController.a(Unknown Source)
        at com.justep.report.controller.DataController.a(Unknown Source)
        ... 20 more
Caused by: java.lang.Exception
        ... 22 more

jishuang

action中定义st参数了吗？

VANYQ

jishuang 发表于 2017-3-20 10:41
action中定义st参数了吗？

where WZ_dayandweek.fRQ >= :st AND WZ_dayandweek.fRQ <= :et

定义了

jishuang

reportData怎么定义的？使用的KSQLAction吗?

VANYQ

jishuang 发表于 2017-3-20 14:05
reportData怎么定义的？使用的KSQLAction吗?

使用了两个KSQLAction，各自做为两个REPORTDATA的数据源，我觉得这两部分应该都没问题，我在其他的W文件中也在使用，运行很好，其他W文件和这个的区别在于，传 st 和 et 两个参数的范围不一样，这个是要传当月的时间，另外的文件是通过两个INPUT传了一个可选择的任意时间段（INPUT设为日期类型）。

jishuang

把action的定义和reportData的定义发一下看看