如何通过视图选项卡按钮调出数据并写如明细表中

【myApps/OBPM版本号】：v5.0- sp XX
【浏览器类型】：Chrome/其他
【联系方式-QQ】：请留下您的QQ号码
【联系电话】:    请留下您的联系电话，以便技术同事更好解决您的问题
【问题描述】：

1、通过视图选择框选择信息后，如何写如到子表中，如图显示，我点击确认后，信息无法写到明细表中







1、问题描述最好图文并茂，如有视频/脚本可直接放出，这样技术同事在处理该问题时效率更加高效哦~
2、如果该问题已得到解决，请在该帖子下回复\\\"已解决可结帖\\\"

可以参考这个脚本试试：视图选择框勾选的数据映射到包含元素数据中
http://www.teemlink.com/bbs/foru ... C%D1%A1%D4%F1%BF%F2

yaya 发表于 2024-4-15 11:24
可以参考这个脚本试试：视图选择框勾选的数据映射到包含元素数据中
http://www.teemlink.com/bbs/forum.ph ...

(function(){
        var process = getDocumentProcess();                                             
        var formProcess = getFormProcess();//申明表单业务处理类                                             
        var form = formProcess.doViewByFormName("入库单子表",getApplication()); //子表表单名称
      
        var webuser = getWebUser();               
        var sid = getParameter("_selects");
        var parentid =getCurrentDocument().getId();         
        var arr = splitText(sid, ";");               
        for (var i=0;i<arr.length;i++){   
                        println("arr.length-------->"+arr.length)   
                        var fd=findDocument(arr);                 
                        var fd=findDocument(arr);                 
            var no = fd.getItemValueAsString("商品编号"); //表单字段名称
            var name = fd.getItemValueAsString("商品名称");
            var ggxh= fd.getItemValueAsString("规格型号");
                        var dw= fd.getItemValueAsString("计量单位");                    
                        var doc = process.doNew(form,webuser,createParamsTable());//创建记录
                        
                        doc.findItem("商品编号").setValue(no);
                        doc.findItem("商品名称").setValue(name);
                        doc.findItem("规格型号").setValue(ggxh);
                        doc.findItem("计量单位").setValue(dw);
                        doc.setParent(parentid)      
                        doc.setIstmp(false);      
                        process.doCreate(doc);      
                     
                }
})();


脚本参考修改，但是在弹出视图选择商品后，点击确定，系统报错。

19907131753 发表于 2024-4-16 10:20
(function(){
        var process = getDocumentProcess();                                          ...

看一下具体报什么错

yaya 发表于 2024-4-16 10:28
看一下具体报什么错

这个在什么地方看?

19907131753 发表于 2024-4-16 10:52
这个在什么地方看?

designer--》右上角的调试，以及tomcat窗口的报错。

yaya 发表于 2024-4-16 11:28
designer--》右上角的调试，以及tomcat窗口的报错。

JsUtil:sql:select DATE_FORMAT( ITEM_StartTime, '%m' ) AS ITEM_月份,sum( ITEM_LeaveDays ) AS ITEM_每月请假天数 FROM tlk_leaveapplication WHERE ITEM_Applicant='Ei5lhI5kxstPtGTXcFT' AND STATELABEL='结束' AND YEAR(ITEM_StartTime) = YEAR(NOW()) GROUP BY DATE_FORMAT( ITEM_StartTime, '%Y-%m' )
JsUtil:map={"05":"","06":"","07":"","08":"","09":"","10":"","11":"","12":"","01":"","02":"","03":"","04":""}
JsUtil:station2list=["","","","","","","","","","","",""]
org.mozilla.javascript.EcmaError: TypeError: splitText is not a function, it is org.mozilla.javascript.Undefined. (__K34uHPZrC3O2HXaS7q3).选择商品.callbackScript#9)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3350)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3340)
at org.mozilla.javascript.ScriptRuntime.typeError(ScriptRuntime.java:3356)
at org.mozilla.javascript.ScriptRuntime.typeError2(ScriptRuntime.java:3375)
at org.mozilla.javascript.ScriptRuntime.notFunctionError(ScriptRuntime.java:3430)
at org.mozilla.javascript.ScriptRuntime.getNameFunctionAndThis(ScriptRuntime.java:1953)
at org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:95)
at org.mozilla.javascript.gen.c50._c1(Form.入库单主表.Field(__K34uHPZrC3O2HXaS7q3).选择商品.callbackScript:9)
at org.mozilla.javascript.gen.c50.call(Form.入库单主表.Field(__K34uHPZrC3O2HXaS7q3).选择商品.callbackScript)
at org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:57)
at org.mozilla.javascript.gen.c50._c0(Form.入库单主表.Field(__K34uHPZrC3O2HXaS7q3).选择商品.callbackScript:1)
at org.mozilla.javascript.gen.c50.call(Form.入库单主表.Field(__K34uHPZrC3O2HXaS7q3).选择商品.callbackScript)
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
at org.mozilla.javascript.gen.c50.call(Form.入库单主表.Field(__K34uHPZrC3O2HXaS7q3).选择商品.callbackScript)
at org.mozilla.javascript.gen.c50.exec(Form.入库单主表.Field(__K34uHPZrC3O2HXaS7q3).选择商品.callbackScript)
at cn.myapps.runtime.macro.runner.JavaScriptRunner.run(JavaScriptRunner.java:177)
at cn.myapps.runtime.dynaform.view.service.ViewHelperRunTimeServiceImpl.runViewDialogCallbackscriptByFieldId(ViewHelperRunTimeServiceImpl.java:73)
at cn.myapps.runtime.dynaform.view.controller.ViewHelperController.runViewDialogCallbackscript(ViewHelperController.java:114)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
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:893)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:799)
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:981)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:884)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:858)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
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:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at cn.myapps.runtime.common.filter.MultiLanguageFilter.doFilter(MultiLanguageFilter.java:56)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:90)
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 cn.myapps.base.web.filter.SecurityFilter.doFilter(SecurityFilter.java:212)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:130)
at org.springframework.boot.web.servlet.support.ErrorPageFilter.access$000(ErrorPageFilter.java:66)
at org.springframework.boot.web.servlet.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:105)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:155)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:123)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:108)
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:202)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1594)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)

是不是这个？

19907131753 发表于 2024-4-16 14:57
JsUtil:sql:select DATE_FORMAT( ITEM_StartTime, '%m' ) AS ITEM_月份,sum( ITEM_LeaveDays ) AS ITEM_ ...

改成splitString试试

yaya 发表于 2024-4-16 17:05
改成splitString试试

修改为splistString可以正常实现功能。感谢



\\\"已解决可结帖\\\"