找不到变量对应的值

cqu666

用ksql写了一个报表，但是不知道为什么总是说获取不到变量的值。错误如下。

1. 2017-09-12 15:46:26 action:<?xml version="1.0" encoding="UTF-8"?>
   
2. <action process="/nsbd_zjp/sz_bb/process/hkyypjzb/hkyypjzbProcess" activity="mainActivity" action-flag="__action_0__" executor="" execute-context="" name="selectHkyypjzb"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="variables"/></parameters></action>
   
3. java.lang.reflect.InvocationTargetException
   
4.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   
5.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   
6.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   
7.         at java.lang.reflect.Method.invoke(Method.java:606)
   
8.         at com.justep.system.action.Engine.invokeActions(Native Method)
   
9.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
   
10.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
    
11.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
    
12.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
13.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
14.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
    
15.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
    
16.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
17.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
    
18.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
19.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
20.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
21.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
22.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
23.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
24.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
25.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
26.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    
27.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    
28.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    
29.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
30.         at java.lang.Thread.run(Thread.java:745)
    
31. Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select V_SZ_HKYYPJZB.HPMC as HPMC,V_SZ_HKYYPJZB.CZMC as CZMC,V_SZ_HKYYPJZB.XMMC as XMMC,V_SZ_HKYYPJZB.GXSJ as GXSJ,V_SZ_HKYYPJZB.NDZ as NDZ,V_SZ_HKYYPJZB.FFZ as FFZ,V_SZ_HKYYPJZB.YYZTZS as YYZTZS,V_SZ_HKYYPJZB.YYZTFJ as YYZTFJ from V_SZ_HKYYPJZB V_SZ_HKYYPJZB where V_SZ_HKYYPJZB.GXSJ >= stringToDate(:start) AND V_SZ_HKYYPJZB.GXSJ <= stringToDate(:end) AND V_SZ_HKYYPJZB.CZMC = :czmc
    
32. --> sql:
    
33. --> binds: []
    
34.         at com.justep.exception.BusinessException.create(Unknown Source)
    
35.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    
36.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    
37.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    
38.         at com.justep.system.data.KSQL.select(Unknown Source)
    
39.         at KSQLProcedure.query(KSQLProcedure.java:17)
    
40.         ... 27 more
    
41. Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154150; 提示: 找不到变量start对应的值
    
42.         at com.justep.exception.BusinessException.create(Unknown Source)
    
43.         at com.justep.util.Utils.check(Unknown Source)
    
44.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
    
45.         at com.justep.system.ksql.node.VariableNode.accept(Unknown Source)
    
46.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
    
47.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
    
48.         at com.justep.system.ksql.node.FunctionNode.accept(Unknown Source)
    
49.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
    
50.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
    
51.         at com.justep.system.ksql.node.CompExpressionNode.accept(Unknown Source)
    
52.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
    
53.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
    
54.         at com.justep.system.ksql.node.LogicalExpressionNode.accept(Unknown Source)
    
55.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
    
56.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
    
57.         at com.justep.system.ksql.node.WhereNode.accept(Unknown Source)
    
58.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
    
59.         at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
    
60.         at com.justep.system.ksql.node.SelectSentenceNode.accept(Unknown Source)
    
61.         at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
    
62.         at com.justep.system.ksql.visitor.QueryVisitor.visit(Unknown Source)
    
63.         at com.justep.system.ksql.node.QuerySentence.accept(Unknown Source)
    
64.         ... 32 more
    
65. [ERROR] 2017-09-12 15:46:26,730 com.justep.report.controller.DataController - 报表数据获取失败
    
66. 执行KSQL出错, KSQL: select V_SZ_HKYYPJZB.HPMC as HPMC,V_SZ_HKYYPJZB.CZMC as CZMC,V_SZ_HKYYPJZB.XMMC as XMMC,V_SZ_HKYYPJZB.GXSJ as GXSJ,V_SZ_HKYYPJZB.NDZ as NDZ,V_SZ_HKYYPJZB.FFZ as FFZ,V_SZ_HKYYPJZB.YYZTZS as YYZTZS,V_SZ_HKYYPJZB.YYZTFJ as YYZTFJ from V_SZ_HKYYPJZB V_SZ_HKYYPJZB where V_SZ_HKYYPJZB.GXSJ >= stringToDate(:start) AND V_SZ_HKYYPJZB.GXSJ <= stringToDate(:end) AND V_SZ_HKYYPJZB.CZMC = :czmc
    
67. --> sql:
    
68. --> binds: []
    
69. com.justep.report.exception.ReportServerException: 报表数据获取失败
    
70.         at com.justep.report.controller.DataController.execute(Unknown Source)
    
71.         at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
    
72.         at com.justep.report.controller.InitController.execute(Unknown Source)
    
73.         at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
    
74.         at com.justep.report.Servlet.a(Unknown Source)
    
75.         at com.justep.report.Servlet.doPost(Unknown Source)
    
76.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
    
77.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
78.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
79.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
80.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
81.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
82.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
83.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
84.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
85.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    
86.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    
87.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    
88.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
89.         at java.lang.Thread.run(Thread.java:745)
    
90. Caused by: com.justep.report.exception.ReportServerException: 执行KSQL出错, KSQL: select V_SZ_HKYYPJZB.HPMC as HPMC,V_SZ_HKYYPJZB.CZMC as CZMC,V_SZ_HKYYPJZB.XMMC as XMMC,V_SZ_HKYYPJZB.GXSJ as GXSJ,V_SZ_HKYYPJZB.NDZ as NDZ,V_SZ_HKYYPJZB.FFZ as FFZ,V_SZ_HKYYPJZB.YYZTZS as YYZTZS,V_SZ_HKYYPJZB.YYZTFJ as YYZTFJ from V_SZ_HKYYPJZB V_SZ_HKYYPJZB where V_SZ_HKYYPJZB.GXSJ >= stringToDate(:start) AND V_SZ_HKYYPJZB.GXSJ <= stringToDate(:end) AND V_SZ_HKYYPJZB.CZMC = :czmc
    
91. --> sql:
    
92. --> binds: []
    
93.         at com.justep.report.controller.DataController.a(Unknown Source)
    
94.         at com.justep.report.controller.DataController.a(Unknown Source)
    
95.         ... 20 more
    
96. Caused by: java.lang.Exception
    
97.         ... 22 more
    

复制代码

cqu666

以上是KSQL……求大神帮忙看一下，谢谢……！

cqu666

1. define(function(require){
   
2.         var $ = require("jquery");
   
3.         var justep = require("$UI/system/lib/justep");
   
4.         var a1;
   
5.         var a2;
   
6.         var a3;
   
7.         var Model = function(){
   
8.                 this.callParent();
   
9.                 a1=this.getContext().getRequestParameter("start");
   
10.                 a2=this.getContext().getRequestParameter("end");
    
11.                 a3=this.getContext().getRequestParameter("czmc");
    
12.         };
    
13.         Model.prototype.modelLoad = function(event){       
    
14.                 this.comp('reportData1').setStringVar("start" ,a1);
    
15.                 this.comp('reportData1').setStringVar("end" , a2);
    
16.                 this.comp('reportData1').setStringVar("czmc" , a3);
    
17.         };
    
18.         return Model;
    
19. });

复制代码

以上是js……

jishuang

stringToDate函数去掉看看

cqu666

jishuang 发表于 2017-9-12 16:03
stringToDate函数去掉看看

去掉了stringToDate函数 还是不行，错误一样……

jishuang

this.comp('reportData1').setStringVar("start" ,a1);
                this.comp('reportData1').setStringVar("end" , a2);
                this.comp('reportData1').setStringVar("czmc" , a3);
然后在调用report组件的refresh()才会传到action中

cqu666

jishuang 发表于 2017-9-12 16:32
this.comp('reportData1').setStringVar("start" ,a1);
                this.comp('reportData1').setStri ...

是加个

1. this.comp('report1').refresh();

复制代码

对吗？错误一样还是不行。而且我这个用的时候是直接发get请求访问的应该不用这个吧……？

jishuang

report的autoLoad设置的是false吗?

cqu666

jishuang 发表于 2017-9-12 17:10
report的autoLoad设置的是false吗?

诶？我没明白……这个autoLoad在哪看呀？

jishuang

report组件上的属性