报表调整，新增统计图，入库时需要移动附件位置

 src/main/java/com/zbooksoft/gdmis/controller/CatAjjxxController.java

@@ -9,9 +9,7 @@
import com.ruili.wcp.web.model.AjaxResponse;
import com.ruili.wcp.web.model.ErrorInfo;
import com.zbooksoft.gdmis.config.ArchivesCustomConfig;
import com.zbooksoft.gdmis.data.entity.CatCgwjxx;
import com.zbooksoft.gdmis.data.entity.CatCheck;
import com.zbooksoft.gdmis.data.entity.CatYswjxx;
import com.zbooksoft.gdmis.data.entity.*;
import com.zbooksoft.gdmis.service.*;
import org.apache.commons.lang.StringUtils;
import org.apache.shiro.SecurityUtils;
@@ -66,6 +64,10 @@
    UpdateXml2023Service updateXml2023Service;
    @Autowired
    XmlService xmlService;
    @Autowired
    CheckQuestionService checkQuestionService;
    @Autowired
    SaveQuestionService saveQuestionService;

    @Autowired
    CustomConfigUtil customConfigUtil;
@@ -381,7 +383,7 @@
            String uploadPath = archivesCustomConfig.getOriginalPath();
            for (Map<String, Object> map : list) {
//                String dh = map.get("DH").toString();
                String dh = map.get("XMKYQBH").toString();
                String dh = map.get("XMKYQBH").toString()+"["+map.get("XMKYQMC")+"]";
                //d/省馆档号
                String filePath = uploadPath + dh + File.separator + "电子文件" + File.separator;
                Long id = Long.parseLong(map.get("ID").toString());
@@ -557,6 +559,47 @@
    }

    /**
     * 添加验收问题
     *
     * @return
     */
    @RequestMapping({"/SaveQuestion"})
    @ResponseBody
    @RequiresUser
    public Object SaveQuestion(@RequestBody Map<String, Object> postData) {
        try {
            Long id = Long.parseLong(postData.get("id").toString());

            String selectSql = "SELECT * FROM BUS_TRANSFER_LOG WHERE ID =" + id;
            Map<String, Object> map = jdbcTemplate.queryForMap(selectSql);
            Object ajId = map.get("AJ_ID");
            List<String> ids= (List<String>) postData.get("ids");
            for (String questionId : ids) {
                CheckQuestion question= checkQuestionService.getById(questionId);
                if (question != null) {
                    QueryWrapper<SaveQuestion> queryWrapper=new QueryWrapper<>();
                    queryWrapper.eq("TRANSFER_ID",id).eq("CHECK_ID",question.getId());
                    List<SaveQuestion> saveQuestionList=saveQuestionService.list(queryWrapper);
                    if (saveQuestionList.size()==0){
                        SaveQuestion saveQuestion=new SaveQuestion();
                        saveQuestion.setQuestion(question.getQuestion());
                        saveQuestion.setRequirements(question.getRequirements());
                        saveQuestion.setTranslation(question.getTranslation());
                        saveQuestion.setTransferId(id);
                        saveQuestion.setCheckId(question.getId());
                        saveQuestionService.saveOrUpdate(saveQuestion);
                    }
                }
            }

            return new AjaxResponse(true);
        } catch (Exception e) {
            logger.error(e.getMessage(), e);
            return new AjaxResponse(new ErrorInfo(e.getMessage()), false);
        }
    }

    /**
     * 资料验收
     *
     * @return
@@ -580,18 +623,23 @@
            CatCheck catCheck = new CatCheck();
            catCheck.setItemId(id);
            catCheck.setAjId(Long.parseLong(ajId.toString()));
            catCheck.setQuestion(postData.get("question").toString());
//            catCheck.setQuestion(postData.get("question").toString());
            catCheck.setIsPass(checkState);
            catCheck.setCreateTime(new Date());
            catCheck.setCreateUserName(user.getUserName());
            catCheck.setCreateUserId(user.getUserId());
            catCheck.setCheckQuestion(postData.get("checkQuestion") == null ? "" : postData.get("checkQuestion").toString());
//            catCheck.setCheckQuestion(postData.get("checkQuestion") == null ? "" : postData.get("checkQuestion").toString());
            catCheckService.saveOrUpdate(catCheck);

            String updateSql = "update BUS_TRANSFER_LOG set YSZT = '" + checkState + "' where ID = " + id;
            jdbcTemplate.execute(updateSql);
            String updateSqlY = "update CAT_ITEM_YSWJXX set YSZT = '" + checkState + "' where YJ_ID = " + id;
            jdbcTemplate.execute(updateSqlY);
            if (checkState==1){
                String updateSqlY = "update CAT_ITEM_YSWJXX set YSZT = '" + checkState + "' where YJ_ID = " + id;
                jdbcTemplate.execute(updateSqlY);
            }else if (checkState==3){
                String updateSqlY = "update CAT_FILE_AJJXX set YSWSJ = '" + postData.get("checkData") + "' where ID = " + ajId;
                jdbcTemplate.execute(updateSqlY);
            }
            return new AjaxResponse(true);
        } catch (Exception e) {
            logger.error(e.getMessage(), e);

 src/main/java/com/zbooksoft/gdmis/controller/ScreenController.java

@@ -10,6 +10,7 @@
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
@@ -32,6 +33,8 @@
    DesktopLayoutService desktopLayoutService;

    private static final Logger logger = LoggerFactory.getLogger(ScreenController.class);
    @Autowired
    private JdbcTemplate jdbcTemplate;


    @RequestMapping
@@ -108,29 +111,16 @@
    // 获取条件搜索的柱状图数据
    @RequestMapping("/getSearchConditionEchartsHistogram")
    @ResponseBody
    public Object getSearchConditionEchartsHistogram() {
    public Object getSearchConditionEchartsHistogram(String columnName) {
        String Sql="select "+columnName+",count("+columnName+") as num FROM cat_item_yswjxx where "+columnName+" is not null group by "+columnName;
        List<Map<String,Object>> list=jdbcTemplate.queryForList(Sql);
        List<String> xAxisData = new ArrayList<String>();
        xAxisData.add("海洋区域地质调查");
        xAxisData.add("海岸带地质矿产调查");
        xAxisData.add("大陆架地质矿产调查");
        xAxisData.add("国际海底地质矿产调查");
        xAxisData.add("极地地质调查");
        xAxisData.add("其他海洋地质调查");
        xAxisData.add("水工环地质勘查");
        xAxisData.add("地质科学研究");
        xAxisData.add("技术方法研究");
        List<JSONObject> seriesList = new ArrayList<JSONObject>();
        List<Object> yList = new ArrayList<Object>();
        yList.add(10);
        yList.add(20);
        yList.add(80);
        yList.add(0);
        yList.add(30);
        yList.add(10);
        yList.add(40);
        yList.add(50);
        yList.add(60);

        for (Map<String,Object> map:list){
            xAxisData.add(map.get(columnName).toString());
            yList.add(map.get("num"));
        }
        List<JSONObject> seriesList = new ArrayList<JSONObject>();
        JSONObject job = new JSONObject();
        job.put("name", "档案数量");
        job.put("type", "bar");

 src/main/java/com/zbooksoft/gdmis/controller/UtlStatisticsController.java

@@ -86,14 +86,15 @@
    @RequestMapping(value = "/transferStatistics")
    @RequiresUser
    public ModelAndView transferStatistics() {
        ModelAndView mav = new ModelAndView("gh/utlStatistics/transferStatistics");
//        ModelAndView mav = new ModelAndView("gh/utlStatistics/transferStatistics");
        ModelAndView mav = new ModelAndView("gh/utlStatistics/cs");
        return mav;
    }

    @RequestMapping({"/getTransferStatistics"})
    @ResponseBody
    @RequiresUser
    public Object getTransferStatistics(String year, String startData, String endData) {
    public Object getTransferStatistics(String selectParameter, String startData, String endData) {
        try {
            String sql = "SELECT " +
                    "    A.ID," +
@@ -103,12 +104,17 @@
                    "    COUNT(CASE WHEN C.yszt = '3' THEN C.ID END) AS tidyCount," +
                    "    COUNT(CASE WHEN C.yszt = '3' THEN C.ID END) AS acceptCount," +
                    "    SUM(C.WJDX) AS acceptData," +
                    "    COUNT(CASE WHEN D.is_pass = 0 THEN D.id END) AS returnTime" +
                    "    COUNT(CASE WHEN D.is_pass = 0 THEN D.id END) AS returnTime," +
                    "    SUM(C.YM) AS YM," +
                    "    SUM(C.SL) AS SL" +
                    " FROM CAT_FILE_AJJXX A" +
                    " LEFT JOIN BUS_TRANSFER_LOG B ON A.ID = B.AJ_ID" +
                    " LEFT JOIN CAT_ITEM_YSWJXX C ON A.ID = C.AJ_ID" +
                    " LEFT JOIN CAT_CHECK_INFO D ON A.ID = D.aj_id" +
                    " WHERE 1=1 ";
            if (selectParameter.equals("rk")){
                sql += " AND C.YSZT=3 ";
            }
            // 添加时间段筛选条件
            if (startData != null && !startData.isEmpty()) {
                sql += " AND B.TRANSFER_TIEM >= '" + startData + "'";
@@ -118,6 +124,53 @@
            }
            sql += " GROUP BY A.ID, A.XMKYQMC" +
                    " ORDER BY A.ID;";
            List<Map<String, Object>> mapList = jdbcTemplate.queryForList(sql);
            return mapList;
        } catch (Exception e) {
            logger.error(e.getMessage(), e);
            return new AjaxResponse(new ErrorInfo(e.getMessage()), false);
        }

    }

    // 获取饼状图数据
    @RequestMapping("/getCollectionEchartsPieData")
    @ResponseBody
    public Object getCollectionEchartsPieData() {
        String sql="select xmkyqlx as name,count(b.id) as value FROM cat_file_ajjxx a left join cat_item_yswjxx b on b.aj_id=a.id GROUP by a.xmkyqlx";
        List<Map<String, Object>> mapList = jdbcTemplate.queryForList(sql);
        // 将键名转换为小写
        List<Map<String, Object>> result = new ArrayList<>();
        for (Map<String, Object> map : mapList) {
            Map<String, Object> newMap = new HashMap<>();
            for (Map.Entry<String, Object> entry : map.entrySet()) {
                newMap.put(entry.getKey().toLowerCase(), entry.getValue());
            }
            result.add(newMap);
        }
        return result;
    }

    /**
     * 入库统计
     * @param year
     * @param startData
     * @param endData
     * @return
     */
    @RequestMapping({"/getInboundTimelinessRate"})
    @ResponseBody
    @RequiresUser
    public Object getInboundTimelinessRate(String year, String startData, String endData) {
        try {
            String sql = "select aj.xmkyqmc,ys.wjtm,ys.sl,ys.ym,ys.wjdx from CAT_ITEM_YSWJXX as ys left join cat_file_ajjxx as aj on ys.aj_id=aj.id where ys.yszt='3' ";
            // 添加时间段筛选条件
            if (startData != null && !startData.isEmpty()) {
                sql += " AND aj.yswsj >= '" + startData + "'";
            }
            if (endData != null && !endData.isEmpty()) {
                sql += " AND aj.yswsj <= '" + endData + "'";
            }
            List<Map<String, Object>> mapList = jdbcTemplate.queryForList(sql);
            return mapList;
        } catch (Exception e) {
@@ -191,19 +244,22 @@
    @RequestMapping({"/getUtlStatisticsByDept"})
    @ResponseBody
    @RequiresUser
    public Object getUtlStatisticsByDept(String deptName) {
    public Object getUtlStatisticsByDept(String deptName,String startData, String endData) {
        try {
            List<Map<String, Object>> mapList = new ArrayList<>();

            if (deptName == null || deptName.equals("")) {
                String yearSQL = "SELECT DISTINCT DEPT_NAME AS DEPT_NAME FROM  UTL_VIEW_FORM";
                jdbcTemplate.queryForList(yearSQL).forEach(map -> {
                    String deptNames = map.get("DEPT_NAME") == null ? "" : map.get("DEPT_NAME").toString();
                    Map<String, Object> hashMap = getCount("DEPT_NAME", deptNames);
                    hashMap.put("deptName", deptNames);
                    mapList.add(hashMap);
                });
            String yearSQL="SELECT DISTINCT DEPT_NAME AS DEPT_NAME FROM  UTL_VIEW_FORM where dept_name like '%"+deptName+"%'";
            if (startData != null && !startData.isEmpty()) {
                yearSQL += " AND date >= '" + startData + "'";
            }
            if (endData != null && !endData.isEmpty()) {
                yearSQL += " AND date <= '" + endData + "'";
            }
            jdbcTemplate.queryForList(yearSQL).forEach(map -> {
                String deptNames = map.get("DEPT_NAME") == null ? "" : map.get("DEPT_NAME").toString();
                Map<String, Object> hashMap = getCount("DEPT_NAME", deptNames);
                hashMap.put("deptName", deptNames);
                mapList.add(hashMap);
            });
            return mapList;
        } catch (Exception e) {
            logger.error(e.getMessage(), e);

 src/main/java/com/zbooksoft/gdmis/dao/SaveQuestionMapper.java

New file
@@ -0,0 +1,19 @@
package com.zbooksoft.gdmis.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zbooksoft.gdmis.data.entity.CheckQuestion;
import com.zbooksoft.gdmis.data.entity.SaveQuestion;
import com.zbooksoft.gdmis.data.vo.ParentBorrowInfo;

import java.util.List;

/**
 * <p>
 * Mapper 借阅明细接口
 * </p>
 *
 * @author cb
 * @since 2020-01-03
 */
public interface SaveQuestionMapper extends BaseMapper<SaveQuestion> {
}

 src/main/java/com/zbooksoft/gdmis/data/entity/CheckQuestion.java

@@ -20,11 +20,19 @@
    @TableId(type = IdType.ID_WORKER)
    private Long id;
    /**
     * 验收问题
     * 检查项
     */
    private String question;
    /**
     * 案卷级id
     * 问题说明
     */
    private String translation;
    /**
     * 修改要求
     */
    private String requirements;
    /**
     * 备注
     */
    private String remark;
}

 src/main/java/com/zbooksoft/gdmis/data/entity/SaveQuestion.java

New file
@@ -0,0 +1,42 @@
package com.zbooksoft.gdmis.data.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

/**
 * @Description:借阅单明细
 * @Author: zhai
 * @Date: 2024/8/2
 **/
@TableName("BUS_SAVE_QUESTION")
@Data
public class SaveQuestion {

    /**
     * id
     */
    @TableId(type = IdType.ID_WORKER)
    private Long id;
    /**
     * 检查项
     */
    private String question;
    /**
     * 问题说明
     */
    private String translation;
    /**
     * 修改要求
     */
    private String requirements;
    /**
     * 移交ID
     */
    private Long transferId;
    /**
     * 问题项ID
     */
    private Long checkId;
}

 src/main/java/com/zbooksoft/gdmis/operate/CatAjjxxOperate.java

@@ -1,7 +1,9 @@
package com.zbooksoft.gdmis.operate;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.ruili.wcp.common.CustomConfigUtil;
import com.ruili.wcp.common.SpringContextUtil;
import com.ruili.wcp.configsettting.SystemConfig;
import com.ruili.wcp.data.entity.config.Module;
import com.ruili.wcp.data.entity.config.View;
import com.ruili.wcp.data.entity.management.User;
@@ -10,8 +12,10 @@
import com.ruili.wcp.service.config.ViewService;
import com.ruili.wcp.web.model.AjaxResponse;
import com.ruili.wcp.web.model.ErrorInfo;
import com.zbooksoft.gdmis.config.ArchivesCustomConfig;
import com.zbooksoft.gdmis.data.entity.BorrowDetail;
import com.zbooksoft.gdmis.data.entity.CatAjjxx;
import com.zbooksoft.gdmis.data.entity.CatYswjxx;
import com.zbooksoft.gdmis.data.entity.PhysicalDetail;
import com.zbooksoft.gdmis.service.*;
import org.apache.shiro.SecurityUtils;
@@ -22,6 +26,8 @@
import org.springframework.jdbc.core.BatchPreparedStatementSetter;
import org.springframework.jdbc.core.JdbcTemplate;

import java.io.File;
import java.io.IOException;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.time.LocalDateTime;
@@ -43,6 +49,8 @@
    ModuleService moduleService = (ModuleService) SpringContextUtil.getBean("moduleServiceImpl");
    JdbcTemplate jdbcTemplate = (JdbcTemplate) SpringContextUtil.getBean("jdbcTemplate");
    IFormData iform = (IFormData) SpringContextUtil.getBean("iFormData");
    CatYswjxxService catYswjxxService = (CatYswjxxService) SpringContextUtil.getBean("catYswjxxServiceImpl");
    CustomConfigUtil customConfigUtil = (CustomConfigUtil) SpringContextUtil.getBean("customConfigUtil");


    /**
@@ -73,11 +81,91 @@
                    return idList.size();
                }
            });
            QueryWrapper<CatYswjxx> queryWrapper=new QueryWrapper<>();
            queryWrapper.in("aj_id",idList).eq("yszt",3);
//            queryWrapper.in("aj_id",idList);
            List<CatYswjxx> catYswjxxList=catYswjxxService.list(queryWrapper);
            ArchivesCustomConfig archivesCustomConfig = customConfigUtil.getConfigObj(ArchivesCustomConfig.class);
            for (CatYswjxx catYswjxx : catYswjxxList) {
                String destDir = archivesCustomConfig.getOriginalPath() + "已入库" + File.separator + catYswjxx.getWjlj().substring(archivesCustomConfig.getOriginalPath().length());
                // 源文件路径
                File sourceFile = new File(catYswjxx.getWjlj());
                // 目标文件路径
                File destFile = new File(destDir);

                // 确保目标目录存在
                File destParentDir = destFile.getParentFile();
                if (destParentDir != null && !destParentDir.exists()) {
                    destParentDir.mkdirs();
                }

                // 判断源文件是文件还是文件夹
                if (sourceFile.isDirectory()) {
                    // 如果是文件夹，复制整个文件夹及其内容
                    copyDirectory(sourceFile, destFile);
                } else {
                    // 如果是文件，直接复制
                    java.nio.file.Files.copy(sourceFile.toPath(), destFile.toPath(),
                        java.nio.file.StandardCopyOption.REPLACE_EXISTING);
                }

                // 删除源文件或源文件夹
                deleteDirectory(sourceFile);

                catYswjxx.setWjlj(destDir);
                catYswjxxService.saveOrUpdate(catYswjxx);
            }
            return new AjaxResponse(true);
        } catch (Exception e) {
            logger.error(e.getMessage(), e);
            return new AjaxResponse(new ErrorInfo(e.getMessage()), false);
        }
    }

    /**
     * 复制目录及其子目录和文件
     * @param source 源目录
     * @param target 目标目录
     * @throws IOException
     */
    private void copyDirectory(File source, File target) throws IOException {
        if (source.isDirectory()) {
            // 如果目标目录不存在，则创建
            if (!target.exists()) {
                target.mkdirs();
            }

            // 获取源目录下的所有文件和子目录
            String[] files = source.list();
            if (files != null) {
                for (String file : files) {
                    File srcFile = new File(source, file);
                    File destFile = new File(target, file);
                    // 递归复制
                    copyDirectory(srcFile, destFile);
                }
            }
        } else {
            // 如果是文件，直接复制
            java.nio.file.Files.copy(source.toPath(), target.toPath(),
                    java.nio.file.StandardCopyOption.REPLACE_EXISTING);
        }
    }

    /**
     * 删除目录及其子目录和文件
     * @param directory 要删除的目录
     */
    private void deleteDirectory(File directory) {
        if (directory.isDirectory()) {
            File[] files = directory.listFiles();
            if (files != null) {
                for (File file : files) {
                    deleteDirectory(file);
                }
            }
        }
        directory.delete();
    }

    /**
@@ -91,7 +179,10 @@
        try {
            int state = 0;
            String columnName = "fbzt";
            updateState(viewId, idList, state, columnName);
//            updateState(viewId, idList, state, columnName);
            QueryWrapper<CatAjjxx> fileQueryWrapper = new QueryWrapper<>();
            fileQueryWrapper.in("id",idList);
            List<CatAjjxx> catAjjxxList=catAjjxxService.list(fileQueryWrapper);
            return new AjaxResponse(true);
        } catch (Exception e) {
            logger.error(e.getMessage(), e);
@@ -122,17 +213,18 @@
    public void updateState(Long viewId, ArrayList<Long> idList, Integer state, String columnName) {
        View view = viewService.getViewById(viewId);
        String strSql = "update " + view.getMainTableName() + " set " + columnName + " = " + state;
        jdbcTemplate.batchUpdate(strSql + " where " + view.getIdField() + "=?", new BatchPreparedStatementSetter() {
            @Override
            public void setValues(PreparedStatement ps, int i) throws SQLException {
                ps.setLong(1, idList.get(i));// 下标从1开始
            }
//        jdbcTemplate.batchUpdate(strSql + " where " + view.getIdField() + "=?", new BatchPreparedStatementSetter() {
//            @Override
//            public void setValues(PreparedStatement ps, int i) throws SQLException {
//                ps.setLong(1, idList.get(i));// 下标从1开始
//            }
//
//            @Override
//            public int getBatchSize() {
//                return idList.size();
//            }
//        });

            @Override
            public int getBatchSize() {
                return idList.size();
            }
        });
    }



 src/main/java/com/zbooksoft/gdmis/operate/TransferOperate.java

@@ -5,6 +5,7 @@
import com.ruili.wcp.service.config.ViewService;
import com.ruili.wcp.web.model.AjaxResponse;
import com.ruili.wcp.web.model.ErrorInfo;
import com.zbooksoft.gdmis.data.entity.CatAjjxx;
import com.zbooksoft.gdmis.service.CatSmxxService;
import com.zbooksoft.gdmis.service.CatYswjxxService;
import com.zbooksoft.gdmis.service.PackingManageService;
@@ -13,6 +14,8 @@
import org.springframework.jdbc.core.JdbcTemplate;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

/**
 * @Description:原始文件信息操作方法
@@ -77,4 +80,21 @@
            return new AjaxResponse(new ErrorInfo(e.getMessage()), false);
        }
    }

    /**
     * 接收到实体资料后确认验收合格
     *
     * @param viewId
     * @param idList
     * @return
     */
    public AjaxResponse qualified(Long viewId, ArrayList<Long> idList) {
        try {
            String updateSqlY = "update CAT_ITEM_YSWJXX set YSZT = '3' where YJ_ID = " + idList.get(0);
            jdbcTemplate.execute(updateSqlY);
            return new AjaxResponse(true);
        } catch (Exception e) {
            throw new RuntimeException(e);
        }
    }
}

 src/main/java/com/zbooksoft/gdmis/service/SaveQuestionService.java

New file
@@ -0,0 +1,15 @@
package com.zbooksoft.gdmis.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.zbooksoft.gdmis.data.entity.SaveQuestion;

import java.util.List;


/**
 * @Description
 * @Author zhai
 * @Date 2024/7/31
 **/
public interface SaveQuestionService extends IService<SaveQuestion> {
}

 src/main/java/com/zbooksoft/gdmis/service/impl/SaveQuestionServiceImpl.java

New file
@@ -0,0 +1,21 @@
package com.zbooksoft.gdmis.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.zbooksoft.gdmis.dao.SaveQuestionMapper;
import com.zbooksoft.gdmis.data.entity.SaveQuestion;
import com.zbooksoft.gdmis.service.SaveQuestionService;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * <p>
 * 服务实现类
 * </p>
 *
 * @author cb
 * @since 2020-01-03
 */
@Service
public class SaveQuestionServiceImpl extends ServiceImpl<SaveQuestionMapper, SaveQuestion> implements SaveQuestionService {
}

 src/main/java/com/zbooksoft/gdmis/service/impl/XmlServiceImpl.java

@@ -203,6 +203,8 @@
            String zxblc = getNodeText(yswjxxNode, "ZXBLC");
            String wjgs = getNodeText(yswjxxNode, "WJGSXX/WJGS");
            String wjgssm = getNodeText(yswjxxNode, "WJGSXX/WJGSSM");
            String zllb = getNodeText(yswjxxNode, "ZLLB");
            String ztlx = getNodeText(yswjxxNode, "ZTLX");


            map.put("ID", catYswjxxId);
@@ -220,6 +222,7 @@
            }


            map.put("ZLLB",zllb);
            map.put("WJM", wjm);
            map.put("XCDWMC", xcdw);
            map.put("BXZ", xcr);
@@ -236,6 +239,7 @@
            map.put("WJLX", wjlb);
//            map.put("WJLJ", wjlj);
            map.put("GDZTXS", ztxs);
            map.put("ZTLX",ztlx);
            map.put("QZY", qzy);
            map.put("FTHXBLC", hxblc);
            map.put("FTZXBLC", zxblc);

 src/main/webapp/WEB-INF/ureportfiles/borrow_approval_hn.ureport.xml

@@ -1,14 +1,14 @@
<?xml version="1.0" encoding="UTF-8"?><ureport><cell expand="None" name="A1" row="1" col="1" col-span="13"><cell-style font-size="14" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"></cell-style><simple-value><![CDATA[地质资料借阅申请表]]></simple-value></cell><cell expand="None" name="A2" row="2" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[申请人]]></simple-value></cell><cell expand="None" name="D2" row="2" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="BORROW_USER_NAME" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="G2" row="2" col="7" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[电话]]></simple-value></cell><cell expand="None" name="I2" row="2" col="9" col-span="5"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="BORROW_TEL" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A3" row="3" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[所在部门]]></simple-value></cell><cell expand="None" name="D3" row="3" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="DEPT_NAME" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A4" row="4" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[申请日期]]></simple-value></cell><cell expand="None" name="D4" row="4" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" format="yyyy-MM-dd" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="BORROW_DATE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="G4" row="4" col="7" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[归还时间]]></simple-value></cell><cell expand="None" name="I4" row="4" col="9" col-span="5"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" format="yyyy-MM-dd" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[□1个月  □就地借阅]]></simple-value></cell><cell expand="None" name="A5" row="5" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[资料用途]]></simple-value></cell><cell expand="None" name="D5" row="5" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="BORROW_PURPOSE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A6" row="6" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[资料密级]]></simple-value></cell><cell expand="None" name="D6" row="6" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[□绝密级   □机密级   □秘密级    □工作秘密]]></simple-value></cell><cell expand="None" name="A7" row="7" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[档号]]></simple-value></cell><cell expand="None" name="D7" row="7" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[文件题名]]></simple-value></cell><cell expand="None" name="G7" row="7" col="7"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[电子]]></simple-value></cell><cell expand="None" name="H7" row="7" col="8"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[纸质]]></simple-value></cell><cell expand="None" name="I7" row="7" col="9"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[调阅原件]]></simple-value></cell><cell expand="None" name="J7" row="7" col="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[密级]]></simple-value></cell><cell expand="None" name="K7" row="7" col="11"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[涉密页码]]></simple-value></cell><cell expand="None" name="L7" row="7" col="12" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[备注]]></simple-value></cell><cell expand="Down" name="A8" row="8" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" wrap-compute="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="ARCHIVAL_CODE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="D8" row="8" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="ITEM_TITLE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="G8" row="8" col="7"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="ELECTRONIC" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="H8" row="8" col="8"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" wrap-compute="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="PAPER" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="I8" row="8" col="9"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="ORIGINAL" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="J8" row="8" col="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="SECURITY_CLASSIFICATION" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="K8" row="8" col="11"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" wrap-compute="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="SECURITY_PAGE_NUM" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="L8" row="8" col="12" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="A9" row="9" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[申请人承诺]]></simple-value></cell><cell expand="None" name="D9" row="9" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="left" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[  1.本人申请的资料严格按照本表中填写的用途使用，不向第三方提供，不以任何
<?xml version="1.0" encoding="UTF-8"?><ureport><cell expand="None" name="A1" row="1" col="1" col-span="13"><cell-style font-size="14" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"></cell-style><simple-value><![CDATA[地质资料借阅申请表]]></simple-value></cell><cell expand="None" name="A2" row="2" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[申请人]]></simple-value></cell><cell expand="None" name="D2" row="2" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="BORROW_USER_NAME" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="G2" row="2" col="7" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[电话]]></simple-value></cell><cell expand="None" name="I2" row="2" col="9" col-span="5"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="BORROW_TEL" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A3" row="3" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[所在部门]]></simple-value></cell><cell expand="None" name="D3" row="3" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="DEPT_NAME" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A4" row="4" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[申请日期]]></simple-value></cell><cell expand="None" name="D4" row="4" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" format="yyyy-MM-dd" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="BORROW_DATE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="G4" row="4" col="7" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[归还时间]]></simple-value></cell><cell expand="None" name="I4" row="4" col="9" col-span="5"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" format="yyyy-MM-dd" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[□1个月  □就地借阅]]></simple-value></cell><cell expand="None" name="A5" row="5" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[资料用途]]></simple-value></cell><cell expand="None" name="D5" row="5" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="BORROW_PURPOSE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A6" row="6" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[资料密级]]></simple-value></cell><cell expand="None" name="D6" row="6" col="4"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="right" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[绝密]]></simple-value></cell><cell expand="Down" name="E6" row="6" col="5"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="left" valign="middle"><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table1" aggregate="group" property="绝密" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="F6" row="6" col="6"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="right" valign="middle"><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[机密]]></simple-value></cell><cell expand="Down" name="G6" row="6" col="7"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="left" valign="middle"><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table1" aggregate="group" property="机密" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="H6" row="6" col="8"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="right" valign="middle"><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[秘密]]></simple-value></cell><cell expand="Down" name="I6" row="6" col="9"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="left" valign="middle"><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table1" aggregate="group" property="秘密" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="J6" row="6" col="10"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="right" valign="middle"><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[工作秘密]]></simple-value></cell><cell expand="Down" name="K6" row="6" col="11"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="left" valign="middle"><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table1" aggregate="group" property="工作秘密" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="L6" row="6" col="12"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="right" valign="middle"><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[公开]]></simple-value></cell><cell expand="Down" name="M6" row="6" col="13"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="left" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table1" aggregate="group" property="公开" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A7" row="7" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[申请人承诺]]></simple-value></cell><cell expand="None" name="D7" row="7" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="left" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[  1.本人申请的资料严格按照本表中填写的用途使用，不向第三方提供，不以任何
形式在互联网上传播。
  2.严格按照局保密规定要求保管、使用（如：复印的，填写《涉密载体内部/送外
印制审批表》（见局《涉密载体印制保密管理规定》）履行审批手续；导入涉密计算
机,填写《涉密计算机信息输入审批表》（见局《信息安全保密操作规程》）履行
审批手 续）。
  3.对因本人所借阅的资料造成的失泄密承担全部责任，接收并配合保密检查。
  4.本人对申请表填写的内容的真实性负责]]></simple-value></cell><cell expand="None" name="A10" row="10" col="1" row-span="2" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[申请人所在
部门负责人]]></simple-value></cell><cell expand="None" name="D10" row="10" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="left" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[（工作秘密、秘密级、机密级审核，绝密级审核；复制移交外单位审核）]]></simple-value></cell><cell expand="None" name="D11" row="11" col="4" col-span="10"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="A12" row="12" col="1" row-span="2" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[项目管理/
  4.本人对申请表填写的内容的真实性负责]]></simple-value></cell><cell expand="None" name="A8" row="8" col="1" row-span="2" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[申请人所在
部门负责人]]></simple-value></cell><cell expand="None" name="D8" row="8" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="left" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[（工作秘密、秘密级、机密级审核，绝密级审核；复制移交外单位审核）]]></simple-value></cell><cell expand="None" name="D9" row="9" col="4" col-span="10"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="A10" row="10" col="1" row-span="2" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[项目管理/
科学技术处
负责人]]></simple-value></cell><cell expand="None" name="D12" row="12" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="left" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[（绝密级审核）]]></simple-value></cell><cell expand="None" name="D13" row="13" col="4" col-span="10"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="A14" row="14" col="1" row-span="2" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[局领导]]></simple-value></cell><cell expand="None" name="D14" row="14" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="left" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[（绝密级审批；复制移交外单位审批）]]></simple-value></cell><cell expand="None" name="D15" row="15" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><row row-number="1" height="26" band="title"/><row row-number="2" height="27" band="title"/><row row-number="3" height="26" band="title"/><row row-number="4" height="25" band="title"/><row row-number="5" height="29" band="title"/><row row-number="6" height="29" band="title"/><row row-number="7" height="26" band="title"/><row row-number="8" height="25"/><row row-number="9" height="152" band="summary"/><row row-number="10" height="33" band="summary"/><row row-number="11" height="33" band="summary"/><row row-number="12" height="22" band="summary"/><row row-number="13" height="42" band="summary"/><row row-number="14" height="23" band="summary"/><row row-number="15" height="50" band="summary"/><column col-number="1" width="34"/><column col-number="2" width="47"/><column col-number="3" width="15"/><column col-number="4" width="40"/><column col-number="5" width="64"/><column col-number="6" width="60"/><column col-number="7" width="50"/><column col-number="8" width="44"/><column col-number="9" width="44"/><column col-number="10" width="43"/><column col-number="11" width="45"/><column col-number="12" width="25"/><column col-number="13" width="28"/><footer  font-family="宋体" font-size="10" forecolor="0,0,0" margin="23"><center><![CDATA["第"+page()+"页,共"+pages()+"页"]]></center></footer><datasource name="内置数据源" type="buildin"><dataset name="table2" type="sql"><sql><![CDATA[SELECT
负责人]]></simple-value></cell><cell expand="None" name="D10" row="10" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="left" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[（绝密级审核）]]></simple-value></cell><cell expand="None" name="D11" row="11" col="4" col-span="10"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="A12" row="12" col="1" row-span="2" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[局领导]]></simple-value></cell><cell expand="None" name="D12" row="12" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="left" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[（绝密级审批；复制移交外单位审批）]]></simple-value></cell><cell expand="None" name="D13" row="13" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="A14" row="14" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[档号]]></simple-value></cell><cell expand="None" name="D14" row="14" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[文件题名]]></simple-value></cell><cell expand="None" name="G14" row="14" col="7"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[电子]]></simple-value></cell><cell expand="None" name="H14" row="14" col="8"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[纸质]]></simple-value></cell><cell expand="None" name="I14" row="14" col="9"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[调阅原件]]></simple-value></cell><cell expand="None" name="J14" row="14" col="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[密级]]></simple-value></cell><cell expand="None" name="K14" row="14" col="11"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[涉密页码]]></simple-value></cell><cell expand="None" name="L14" row="14" col="12" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[备注]]></simple-value></cell><cell expand="Down" name="A15" row="15" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="ARCHIVAL_CODE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="D15" row="15" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="ITEM_TITLE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="G15" row="15" col="7"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="ELECTRONIC" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="H15" row="15" col="8"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="PAPER" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="I15" row="15" col="9"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="ORIGINAL" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="J15" row="15" col="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="SECURITY_CLASSIFICATION" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="K15" row="15" col="11"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="SECURITY_PAGE_NUM" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="L15" row="15" col="12" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><row row-number="1" height="26" band="title"/><row row-number="2" height="27" band="title"/><row row-number="3" height="26" band="title"/><row row-number="4" height="25" band="title"/><row row-number="5" height="29" band="title"/><row row-number="6" height="29" band="title"/><row row-number="7" height="152" band="summary"/><row row-number="8" height="33" band="summary"/><row row-number="9" height="152" band="summary"/><row row-number="10" height="33" band="summary"/><row row-number="11" height="42" band="summary"/><row row-number="12" height="23" band="summary"/><row row-number="13" height="50" band="summary"/><row row-number="14" height="23" band="title"/><row row-number="15" height="50"/><column col-number="1" width="34"/><column col-number="2" width="47"/><column col-number="3" width="15"/><column col-number="4" width="40"/><column col-number="5" width="64"/><column col-number="6" width="60"/><column col-number="7" width="50"/><column col-number="8" width="44"/><column col-number="9" width="44"/><column col-number="10" width="43"/><column col-number="11" width="45"/><column col-number="12" width="25"/><column col-number="13" width="28"/><footer  font-family="宋体" font-size="10" forecolor="0,0,0" margin="23"><center><![CDATA["第"+page()+"页,共"+pages()+"页"]]></center></footer><datasource name="内置数据源" type="buildin"><dataset name="table2" type="sql"><sql><![CDATA[SELECT
 *,
    case when ELECTRONIC = '1' and AGREE = '1' then '√'
    else '' end as ELECTRONIC,
@@ -18,6 +18,13 @@
    else '' end as ORIGINAL
    FROM UTL_BORROW_DETAIL WHERE FORM_ID = (:formId)]]></sql><field name="DETAIL_ID"/><field name="FORM_ID"/><field name="FILE_ID"/><field name="ITEM_ID"/><field name="ARCHIVAL_CODE"/><field name="ITEM_NUMBER"/><field name="FILE_TITLE"/><field name="ITEM_TITLE"/><field name="BORROW_TYPE"/><field name="AGREE"/><field name="SECURITY_CLASSIFICATION"/><field name="SECURITY_PAGE_NUM"/><field name="CREATE_USER_ID"/><field name="CREATE_USER_NAME"/><field name="MODIFY_TIME"/><field name="CREATE_TIME"/><field name="CREATE_DEPT_NAME"/><field name="CREATE_DEPT_ID"/><field name="ELECTRONIC"/><field name="PAPER"/><field name="ORIGINAL"/><field name="PAPER_BORROW"/><field name="ITEM_CODE"/><field name="ELECTRONIC"/><field name="PAPER"/><field name="ORIGINAL"/><parameter name="formId" type="String" default-value="-1"/></dataset><dataset name="table3" type="sql"><sql><![CDATA[SELECT
 *
    FROM UTL_BORROW_FORM WHERE FORM_ID = (:formId)]]></sql><field name="FORM_ID"/><field name="APPLY_CODE"/><field name="BORROW_TYPE"/><field name="BORROW_USER_ID"/><field name="BORROW_USER_NAME"/><field name="POST_CODE"/><field name="CERTIFICATE_NUMBER"/><field name="TEL_NUMBER"/><field name="BORROW_TEL"/><field name="BORROW_DATE"/><field name="BORROW_VALID_DATE"/><field name="BORROW_PURPOSE"/><field name="CREATE_USER_ID"/><field name="CREATE_USER_NAME"/><field name="CREATE_TIME"/><field name="MODIFY_TIME"/><field name="CREATE_DEPT_ID"/><field name="CREATE_DEPT_NAME"/><field name="REMARK"/><field name="STATE"/><field name="SECURITY_CLASSIFICATION"/><field name="DEPT_NAME"/><field name="DEPT_ADDRESS"/><field name="FULLTEXT_STATE"/><field name="FLOW_STATE"/><field name="PROCESS_INSTANCE_ID"/><field name="FLOW_STEP"/><field name="SECURITY_CODE"/><field name="DELETE_STATE"/><field name="DELETE_TIME"/><field name="FILE_COUNT"/><field name="ITEM_COUNT"/><field name="ID_CARD"/><field name="UTILIZATION_METHOD"/><field name="PAPER_BORROW"/><parameter name="formId" type="String" default-value="-1"/></dataset></datasource><paper type="A4" left-margin="28" right-margin="28"
    FROM UTL_BORROW_FORM WHERE FORM_ID = (:formId)]]></sql><field name="FORM_ID"/><field name="APPLY_CODE"/><field name="BORROW_TYPE"/><field name="BORROW_USER_ID"/><field name="BORROW_USER_NAME"/><field name="POST_CODE"/><field name="CERTIFICATE_NUMBER"/><field name="TEL_NUMBER"/><field name="BORROW_TEL"/><field name="BORROW_DATE"/><field name="BORROW_VALID_DATE"/><field name="BORROW_PURPOSE"/><field name="CREATE_USER_ID"/><field name="CREATE_USER_NAME"/><field name="CREATE_TIME"/><field name="MODIFY_TIME"/><field name="CREATE_DEPT_ID"/><field name="CREATE_DEPT_NAME"/><field name="REMARK"/><field name="STATE"/><field name="SECURITY_CLASSIFICATION"/><field name="DEPT_NAME"/><field name="DEPT_ADDRESS"/><field name="FULLTEXT_STATE"/><field name="FLOW_STATE"/><field name="PROCESS_INSTANCE_ID"/><field name="FLOW_STEP"/><field name="SECURITY_CODE"/><field name="DELETE_STATE"/><field name="DELETE_TIME"/><field name="FILE_COUNT"/><field name="ITEM_COUNT"/><field name="ID_CARD"/><field name="UTILIZATION_METHOD"/><field name="PAPER_BORROW"/><parameter name="formId" type="String" default-value="-1"/></dataset><dataset name="table1" type="sql"><sql><![CDATA[SELECT
    SUM(CASE WHEN security_classification LIKE '%秘密%' THEN 1 ELSE 0 END)||'件' AS 秘密,
    SUM(CASE WHEN security_classification LIKE '%绝密%' THEN 1 ELSE 0 END)||'件' AS 绝密,
    SUM(CASE WHEN security_classification LIKE '%机密%' THEN 1 ELSE 0 END)||'件' AS 机密,
    SUM(CASE WHEN security_classification LIKE '%工作秘密%' THEN 1 ELSE 0 END)||'件' AS 工作秘密,
    SUM(CASE WHEN security_classification LIKE '%公开%' or security_classification is null THEN 1 ELSE 0 END)||'件' AS 公开 
FROM UTL_BORROW_DETAIL
WHERE form_id = (:formId);]]></sql><field name="秘密"/><field name="绝密"/><field name="机密"/><field name="工作秘密"/><field name="公开"/><parameter name="formId" type="String" default-value=""/></dataset></datasource><paper type="A4" left-margin="28" right-margin="28"
    top-margin="57" bottom-margin="43" paging-mode="fitpage" fixrows="0"
    width="595" height="842" orientation="portrait" html-report-align="left" bg-image="http://192.168.100.66//static/images/planFormStatistics.jpg" html-interval-refresh-value="0" column-enabled="false"></paper></ureport>

 src/main/webapp/WEB-INF/view/gh/borrow/borrowForm.jsp

@@ -87,6 +87,9 @@
    <div class="pt-title-theme3">
        <i class="fa fa-file-text"></i>
        <h4>借阅申请单</h4>
        <a href="javascript:showFlowDiagram();" style="float: right">
            <span style="color: #0a84ff">流程示意图</span>
        </a>
    </div>
    <div class="ptbody">
        <div class="pt-application-row">
@@ -313,10 +316,6 @@
            <div class="pt-subtitle">
                <i></i>
                <span>流程记录</span>
                <i></i>
                <a href="javascript:showFlowDiagram();">
                    <span style="color: #0a84ff">流程示意图</span>
                </a>
            </div>
            <div class="pt-tablelist">
                <table cellspacing="0" cellpadding="0">

 src/main/webapp/WEB-INF/view/gh/catAjjxx/checkIndex.jsp

@@ -137,14 +137,14 @@
                            </div>
                        </td>
                    </tr>
                    <tr id="tr_question">
                        <td class="tbtitle">验收问题：</td>
                        <td>
                            <input id="question" class="easyui-textbox" name="question"
                                   style="width:260px;height:80px"
                                   data-options="">
                        </td>
                    </tr>
<%--                    <tr id="tr_question">--%>
<%--                        <td class="tbtitle">验收问题：</td>--%>
<%--                        <td>--%>
<%--                            <input id="question" class="easyui-textbox" name="question"--%>
<%--                                   style="width:260px;height:80px"--%>
<%--                                   data-options="">--%>
<%--                        </td>--%>
<%--                    </tr>--%>
                </table>
                <div class="progress" style="display: none;">
                    <span class="text">0%</span>
@@ -222,25 +222,32 @@
        }
    }

    //点击后，打开矿种选择框
    function selectCheckQuestion() {
        var haveSelected = checkQuestion;
        var ids = params.ids;
        top.layer.open({
            title: "选择问题清单",
            type: 2,
            area: ["900px", "600px"],
            fixed: false,
            content: "gdMisManage/selectCheckQuestion",
            // content: "gdMisManage/selectCheckQuestion",
            content: "general/list?viewId=2004428410897367042",
            success: function (layero, index) {
                var body = window.top.layer.getChildFrame('body', index);

                var iframeWin = window.top[layero.find('iframe')[0]['name']]; //得到iframe页的窗口对象
                //将回调函数传给子页面
                if (iframeWin && iframeWin.param) {
                    iframeWin.param.haveSelected = haveSelected;
                    // iframeWin.param.backOne = selectQuestionCallBack;
                    iframeWin.param.backOne = window.selectQuestionCallBack;
                // if (iframeWin && iframeWin.param) {
                //     iframeWin.param.haveSelected = haveSelected;
                //     // iframeWin.param.backOne = selectQuestionCallBack;
                //     iframeWin.param.backOne = window.selectQuestionCallBack;
                // }
                if (iframeWin.params) {
                    if (ids) {
                        iframeWin.params.ids = ids;
                    }
                }

            }
        });
    }
@@ -253,18 +260,18 @@
    function checkNoFile() {
        var id = params.ids[0];
        var checkData = $('#checkData').textbox("getValue");
        var question = $('#question').textbox("getValue");
        if (question != null && question != "") {
            checkQuestion = checkQuestion + "," + "0" + "-" + "question";
        }
        // var question = $('#question').textbox("getValue");
        // if (question != null && question != "") {
        //     checkQuestion = checkQuestion + "," + "0" + "-" + "question";
        // }
        wcp.ui.setBusy("body", wcp.ajax({
            url: "catAjjxx/check",
            data: JSON.stringify({
                checkState: checkState,
                id: id,
                checkData: checkData,
                question: question,
                checkQuestion: checkQuestion
                checkData: checkData
                // question: question,
                // checkQuestion: checkQuestion
            }),
        }).done(function (result) {
            //关闭窗口
@@ -283,4 +290,4 @@
        $("#checkData").datebox('setValue', parsedate);
    }
</script>
</html>
</html>

 src/main/webapp/WEB-INF/view/gh/search/advancedQuery.jsp

@@ -85,6 +85,7 @@
        <div class="pt-note pt-note-info" style="margin: 10px 0 0 0;">
            <p>1.请点击右侧的“+”号按钮添加条件或者分组</p>
            <p>2.分组指一组独立的逻辑条件，在与其他条件组合时会用括号进行逻辑隔离</p>
            <p>3.等于、包含一类适用于全部检索条件，小于等于、小于、大于等于、大于适用于时间或数字类的检索条件，例如年份、数量</p>
        </div>
        <form id="formAdvancedQuery" method="post">
            <div class="ptbody">

 src/main/webapp/WEB-INF/view/gh/search/searchResult.jsp

@@ -601,11 +601,15 @@
            type: 2,
            area: ["800px", "550px"],
            fixed: false,
            scrollbar: false,
            content: "search/advancedQuery",
            success: function (layero, index) {
                var body = window.top.layer.getChildFrame('body', index);
                var iframeWin = window.top[layero.find('iframe')[0]['name']]; //得到iframe页的窗口对象
                iframeWin.params.callBack = superSearchKeyword;
                // 移除滚动条
                body.css('overflow', 'hidden');
                $(layero).find('.layui-layer-content').css('overflow', 'hidden');
            }
        });
    }

 src/main/webapp/WEB-INF/view/gh/utlStatistics/transferStatistics.jsp

@@ -65,11 +65,17 @@
<body class="pt-tree">
<div class="archives_statistics">
    <h3 class="statistics_title">
        【移交统计】
        【资料统计】
    </h3>
    <div class="option_row clear">
        <span class="option_col1">统计数据过滤查询</span>
        <ul class="clear">
            <li>统计字段：
                <select id="selectParameter"  data-options="editable:false" editable="false" class="easyui-combobox" style="width:150px">
                    <option value="yj" selected>移交统计</option>
                    <option value="rk" >入库统计</option>
                </select>
            </li>

            <%--            <li>时间： <input class="easyui-textbox" id="year"--%>
            <%--                             style="width:150px; height: 24px;"/>--%>
@@ -125,8 +131,84 @@
        // var year = $("#year").numberbox("getValue");
        var startDate = $("#startDate").datebox("getValue");
        var endDate = $("#endDate").datebox("getValue");
        var selectParameter = $('#selectParameter').combobox('getValue');

        var url = "utlStatistics/getTransferStatistics?startDate=" + startDate + "&endDate=" + endDate;
        var columns=[[
            {
                field: 'ck',
                checkbox: true
            },
            {
                field: 'XMKYQMC',
                title: '项目名称',
                width: 100,
            },{
                field: 'YM',
                title: '总页码',
                width: 100,
            }, {
                field: 'SL',
                title: '总数量',
                width: 100,
            }, {
                field: 'TRANSFERCOUNT',
                title: '移交资料份数',
                width: 100,
            },
            {
                field: 'TRANSFERTIME',
                title: '移交次数',
                width: 100,
            }, {
                field: 'RETURNTIME',
                title: '退回次数',
                width: 100,
            }, {
                field: 'ACCEPTCOUNT',
                title: '接收数量',
                width: 100,
            }, {
                field: 'TIDYCOUNT',
                title: '整理完成数量',
                width: 100,
            }, {
                field: 'ACCEPTDATA',
                title: '接收数据量',
                width: 100,
            }
        ]]
        if (selectParameter=='rk'){
            columns=[[
                {
                    field: 'ck',
                    checkbox: true
                },
                {
                    field: 'XMKYQMC',
                    title: '项目名称',
                    width: 100,
                },{
                    field: 'YM',
                    title: '总页码',
                    width: 100,
                }, {
                    field: 'SL',
                    title: '总数量',
                    width: 100,
                }, {
                    field: 'TRANSFERCOUNT',
                    title: '移交资料份数',
                    width: 100,
                },
                {
                    field: 'ACCEPTDATA',
                    title: '接收数据量',
                    width: 100,
                }
            ]]
        }

        var url = "utlStatistics/getTransferStatistics?selectParameter="+selectParameter+"&startDate=" + startDate + "&endDate=" + endDate;
        $("#tb_utilizationForm").datagrid({
            rownumbers: true,
            method: "get",
@@ -136,43 +218,7 @@
            toolbar: "#toolbar_form",
            emptyMsg: "没有找到匹配的记录",
            height: wh - 200,
            columns: [[
                {
                    field: 'ck',
                    checkbox: true
                },
                {
                    field: 'XMKYQMC',
                    title: '项目名称',
                    width: 100,
                }, {
                    field: 'TRANSFERCOUNT',
                    title: '移交资料份数',
                    width: 100,
                },
                {
                    field: 'TRANSFERTIME',
                    title: '移交次数',
                    width: 100,
                }, {
                    field: 'RETURNTIME',
                    title: '退回次数',
                    width: 100,
                }, {
                    field: 'ACCEPTCOUNT',
                    title: '接收数量',
                    width: 100,
                }, {
                    field: 'TIDYCOUNT',
                    title: '整理完成数量',
                    width: 100,
                }, {
                    field: 'ACCEPTDATA',
                    title: '接收数据量',
                    width: 100,
                }
            ]]

            columns: columns
        })



 src/main/webapp/WEB-INF/view/gh/utlStatistics/typeStatistics.jsp

@@ -65,8 +65,23 @@
<body class="pt-tree">
<div class="archives_statistics">
    <h3 class="statistics_title">
        【根据资料类别统计】
        【根据字段统计】
    </h3>
    <div class="option_row clear">
        <span class="option_col1">统计数据过滤查询</span>
        <ul class="clear">
            <li>统计字段：
                <select id="selectParameter"  data-options="editable:false" editable="false" class="easyui-combobox" style="width:150px">
                    <option value="zllb">资料类别</option>
                    <option value="ztlx" selected>载体类型</option>
                </select>
            </li>
            <li class="statistics_btn_row" style="display: flex;align-items:center;height:24px">
                <button class="pt-btn pt-btn-purple" onclick="histogram()"><i class="fa fa-bar-chart"></i>开始统计
                </button>
            </li>
        </ul>
    </div>
    <div class="statistics_txt">
        <div class="title">统计结果</div>
        <div class="statistics_scroll">
@@ -162,11 +177,11 @@
        };
        myChart.showLoading(); //loading动画
        // 使用刚指定的配置项和数据显示图表。

        var selectParameter = $('#selectParameter').combobox('getValue');
        $.ajax({
            type: "post",
            async: true,
            url: "screen/getSearchConditionEchartsHistogram",
            url: "screen/getSearchConditionEchartsHistogram?columnName="+selectParameter,
            dataType: "json",
            success: function (result) {
                if (result) {

 src/main/webapp/WEB-INF/view/gh/utlStatistics/utlStatisticsByDept.jsp

@@ -73,6 +73,11 @@
            <li>部门名称： <input class="easyui-textbox" id="deptName"
                                 style="width:150px; height: 24px;"/>
            </li>
            <li>起止时间：
                <input class="easyui-datebox" id="startDate" style="width:150px;height:24px"/>
                -
                <input class="easyui-datebox" id="endDate" style="width:150px;height:24px"/>
            </li>
            <li class="statistics_btn_row" style="display: flex;align-items:center;height:24px">
                <button class="pt-btn pt-btn-purple" onclick="utilizationStatistics()"><i class="fa fa-bar-chart"></i>开始统计
                </button>
@@ -134,9 +139,11 @@

        var wh = $(window).height();
        var deptName = $("#deptName").numberbox("getValue");
        var startDate = $("#startDate").datebox("getValue");
        var endDate = $("#endDate").datebox("getValue");


        var url = "utlStatistics/getUtlStatisticsByDept?deptName=" + deptName;
        var url = "utlStatistics/getUtlStatisticsByDept?deptName=" + deptName + "&startData=" + startDate + "&endData=" + endDate;
        $("#tb_utilizationForm").datagrid({
            rownumbers: true,
            method: "get",