efile_att_json_lov.lview

<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: luochenglong
    $Date: 2023-02-10 下午2:03:31
    $Revision: 1.0
    $Purpose: 附件列表
-->
<a:screen xmlns:a="http://www.leaf-framework.org/application" xmlns:s="leaf.plugin.script"  customizationEnabled="true" trace="true">
    <a:init-procedure>
        <s:server-script><![CDATA[
            function newMap(name) {
            	return new CompositeMap("a", 'http://www.aurora-framework.org/application',
            			name);
            }
            var para = $ctx.current_parameter || $ctx.parameter;
             var logger = $logger('server-script');
                       var sql_content;
                       var query_validation_sql_bm = $bm('efile.EFILE1030.efile_pool_att_para_sql');
                       var query_archive_type_bm = $bm('efile.EFILE1030.efile_archive_type_sql');
                       var config_map = query_validation_sql_bm.queryAsMap(para);
                       var config_map_detail = config_map.getChildren();
                        logger.info(config_map_detail.length);
                        if (config_map_detail.length != 0) {
                           sql_content = config_map_detail[0].sql_content;
                            logger.info(sql_content);
                           para.sql_content = sql_content;
                      }
                       //println(sql_content);
                        var obj;
                        var dataSet_id='att_json_ds';

                        if(typeof(sql_content)!="undefined"){
                        sql_content ='{'+sql_content+'}';
                          obj = JSON.parse(sql_content).attachmentList;
                        }else{
                            obj='';
                        }
                         var config = $config();
                         var dataSets = CompositeUtil.findChild(config, 'dataSets');
                         var dataSet = CompositeUtil.findChild(dataSets, 'dataSet', 'id', dataSet_id);
                         if (!dataSet) {
                         dataSet = newMap("dataSet");
                         dataSet.id = dataSet_id;
                         dataSet.autocreate = 'true';
                         dataSets.addChild(dataSet.getData());
                         var datas = newMap("datas");
                         dataSet.addChild(datas.getData());
                         }

                         // dataSets.addChild(dataSet.getData());
                         //  dataSet.id = 'att_json_ds';
                         // dataSet.autocreate = 'true';
                         //  dataSets.addChild(dataSet.getData());
                         // var datas = newMap("datas");
                         // dataSet.addChild(datas.getData());

                        if(obj.length>0){
                             for (var k in obj) {
                             // if (obj[k] instanceof Object) {
                             var datasRecord = newMap("record");
                             datasRecord.code_value = obj[k].fileURL;
                             datasRecord.code_value_name = obj[k].fileName;
                             datasRecord.action_type = obj[k].attachTypeCode;
                             var archive_type_desc_data=query_archive_type_bm.queryAsMap({
                                archive_type : obj[k].attachTypeCode
                             });
                             var archive_type_desc=archive_type_desc_data.getChildren()[0].archive_type_desc;
                             datasRecord.archive_type_desc=archive_type_desc;
                             datas.addChild(datasRecord.getData());

                             //println(datasRecord.code_value+":"+datasRecord.code_value_name);
                             //} else {
                             //  println("2222"+obj[k].fieldCode);
                             //}
                             }
                        }else{
                            var datasRecord = newMap("record");
                            datas.addChild(datasRecord.getData());
                        }



            ]]></s:server-script>
    </a:init-procedure>
    <a:view>
        <script type="text/javascript"><![CDATA[



        ]]></script>
        <a:dataSets>
        </a:dataSets>
        <a:screenBody>
            <a:grid id="att_para_ds_id" bindTarget="att_json_ds"  height="180" width="1050" navBar="true">
                <a:columns>
                    <a:column name="action_type"  prompt="附件类型" width="150"/>
                    <a:column name="code_value"  prompt="附件地址"  width="650"/>
                    <a:column name="code_value_name"  prompt="附件名称" width="250"/>
                </a:columns>
            </a:grid>
        </a:screenBody>
    </a:view>
</a:screen>