#核价管理

Junjie

2023-08-24 480431571f806f9ef66f77ec42034549cd573a31

#核价管理

 src/main/java/com/zy/crm/manager/controller/PriOnline2Controller.java

New file
@@ -0,0 +1,331 @@
package com.zy.crm.manager.controller;

import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.baomidou.mybatisplus.plugins.Page;
import com.core.annotations.ManagerAuth;
import com.core.common.BaseRes;
import com.core.common.Cools;
import com.core.common.DateUtils;
import com.core.common.R;
import com.core.domain.KeyValueVo;
import com.zy.crm.common.web.BaseController;
import com.zy.crm.manager.entity.Plan;
import com.zy.crm.manager.entity.Pri;
import com.zy.crm.manager.entity.PriOnline2;
import com.zy.crm.manager.service.PlanService;
import com.zy.crm.manager.service.PriOnline2Service;
import com.zy.crm.manager.service.PriService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.core.io.ClassPathResource;
import org.springframework.util.ClassUtils;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.http.HttpServletResponse;
import java.io.*;
import java.text.SimpleDateFormat;
import java.util.*;

@RestController
public class PriOnline2Controller extends BaseController {

    @Autowired
    private PriOnline2Service priOnline2Service;

    @Autowired
    private PriService priService;

    @Autowired
    private PlanService planService;

    @RequestMapping(value = "/priOnline2/{id}/auth")
    @ManagerAuth
    public R get(@PathVariable("id") String id) {
        return R.ok(priOnline2Service.selectById(String.valueOf(id)));
    }

    @RequestMapping(value = "/priOnline2/viewCheck/{id}/auth")
    @ManagerAuth
    public R viewCheck(@PathVariable("id") String id) {
        PriOnline2 priOnline = priOnline2Service.selectById(String.valueOf(id));
        if (Cools.isEmpty(priOnline.getCheckData())) {
            return R.error("请先上传询价");
        }
        return R.ok(priOnline);
    }

    @RequestMapping(value = "/priOnline2/list/auth")
    @ManagerAuth
    public R list(@RequestParam(defaultValue = "1")Integer curr,
                  @RequestParam(defaultValue = "10")Integer limit,
                  @RequestParam(required = false)String orderByField,
                  @RequestParam(required = false)String orderByType,
                  @RequestParam(required = false)String condition,
                  @RequestParam Map<String, Object> param){
        EntityWrapper<PriOnline2> wrapper = new EntityWrapper<>();
        wrapper.setSqlSelect("id,title,create_time as createTime,filepath,item_id as itemId,order_num as orderNum,template_name as templateName,user_id as userId,dept_id as deptId,status,update_time as updateTime,check_data as checkData,update_user_id as updateUserId,member_id as memberId");
        wrapper.in("member_id", getUserRoleBelongsToUserId("allopen"));
        excludeTrash(param);
        convert(param, wrapper);
        allLike(PriOnline2.class, param.keySet(), wrapper, condition);
        if (!Cools.isEmpty(orderByField)){wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));}
        return R.ok(priOnline2Service.selectPage(new Page<>(curr, limit), wrapper));
    }

    private <T> void convert(Map<String, Object> map, EntityWrapper<T> wrapper){
        Long deptId = getDeptId();
        boolean signUserId = false;
        boolean signDeptId = false;
        for (Map.Entry<String, Object> entry : map.entrySet()){
            if (entry.getKey().equals("dept_id")){
                signDeptId = true;
            }
        }
        for (Map.Entry<String, Object> entry : map.entrySet()){
            String val = String.valueOf(entry.getValue());
            if (val.contains(RANGE_TIME_LINK)){
                String[] dates = val.split(RANGE_TIME_LINK);
                wrapper.ge(entry.getKey(), DateUtils.convert(dates[0]));
                wrapper.le(entry.getKey(), DateUtils.convert(dates[1]));
            } else if (entry.getKey().equals("dept_id")){
                if (!val.equals("19")){
                    wrapper.eq(entry.getKey(), val);
                }
            } else if (entry.getKey().equals("user_id") && !signDeptId){
                signUserId = true;
                wrapper.eq(entry.getKey(), val);
            } else {
                wrapper.like(entry.getKey(), val);
            }
        }
        if (!signUserId && !signDeptId){
            wrapper.eq("user_id", getUserId());
        }
    }

    @RequestMapping(value = "/priOnline2/add/auth")
    @ManagerAuth
    public R add(@RequestBody Map<String,Object> map) {
        PriOnline2 priOnline2 = new PriOnline2();
        priOnline2.setCreateTime(new Date());
        priOnline2.setTitle(map.get("title").toString());
        priOnline2.setTemplateName(map.get("title").toString());
        priOnline2.setSheetData(map.get("sheetData").toString());
        priOnline2.setItemId(Long.parseLong(map.get("itemId").toString()));
        SimpleDateFormat format = new SimpleDateFormat("yyyyMMddHHmmss");
        priOnline2.setOrderNum(format.format(new Date()));
        //创建人员
        priOnline2.setUserId(getUserId());
        //创建人员部门
        priOnline2.setDeptId(getDeptId());
        //更新时间
        priOnline2.setUpdateTime(new Date());
        //更新人员
        priOnline2.setUpdateUserId(getUserId());
        //状态，未完成
        priOnline2.setStatus(0);
        //业务员
//        Item item = itemService.selectById(priOnline.getItemId());
        Plan plan = planService.selectById(priOnline2.getItemId());
        priOnline2.setMemberId(plan.getUserId());


        //设置项目流程
        plan.setStep(2);
        planService.updateById(plan);

        priOnline2Service.insert(priOnline2);
        return R.ok();
    }

    @RequestMapping(value = "/priOnline2/addOther/auth")
    @ManagerAuth
    public R addOther(@RequestBody Map<String,Object> map) {
        PriOnline2 online = priOnline2Service.selectById(Long.parseLong(map.get("id").toString()));

        PriOnline2 priOnline2 = new PriOnline2();
        priOnline2.setCreateTime(new Date());
        priOnline2.setTitle(map.get("title").toString());
        priOnline2.setTemplateName(online.getTemplateName());
        priOnline2.setSheetData(map.get("sheetData").toString());
        priOnline2.setItemId(online.getItemId());

        SimpleDateFormat format = new SimpleDateFormat("yyyyMMddHHmmss");
        priOnline2.setOrderNum(format.format(new Date()));
        //创建人员
        priOnline2.setUserId(getUserId());
        //更新时间
        priOnline2.setUpdateTime(new Date());
        //更新人员
        priOnline2.setUpdateUserId(getUserId());
        //状态，未完成
        priOnline2.setStatus(0);
        priOnline2.setDeptId(getDeptId());
        //业务员
//        Item item = itemService.selectById(priOnline.getItemId());
        Plan plan = planService.selectById(priOnline2.getItemId());
        priOnline2.setMemberId(plan.getUserId());

        priOnline2Service.insert(priOnline2);
        return R.ok();
    }

    @RequestMapping(value = "/priOnline2/update/auth")
    @ManagerAuth
    public R update(@RequestBody Map<String,Object> map){
        PriOnline2 priOnline2 = priOnline2Service.selectById(Long.parseLong(map.get("id").toString()));
        if (priOnline2.getStatus() == 1) {
            return R.error("核价已完成，禁止保存");
        }
        priOnline2.setTitle(map.get("title").toString());
        priOnline2.setSheetData(map.get("sheetData").toString());
        //更新人员
        priOnline2.setUpdateUserId(getUserId());
        //更新时间
        priOnline2.setUpdateTime(new Date());
        priOnline2Service.updateById(priOnline2);
        return R.ok();
    }

    //更新状态
    @RequestMapping(value = "/priOnline2/updateForm/auth")
    @ManagerAuth
    public R updateForm(Long id,Integer status,String title,String templateName){
        PriOnline2 priOnline2 = priOnline2Service.selectById(id);
        priOnline2.setStatus(status);
        priOnline2.setUpdateTime(new Date());
        priOnline2.setTitle(title);
        priOnline2.setTemplateName(templateName);
        priOnline2Service.updateById(priOnline2);
        return R.ok();
    }

    @RequestMapping(value = "/priOnline2/uploadCheck/auth")
    @ManagerAuth
    public R uploadCheck(@RequestParam("id") Integer id,
                         @RequestParam("checkData") String checkData,
                         @RequestParam("file") MultipartFile[] files){
        PriOnline2 priOnline2 = priOnline2Service.selectById(id);
        if (priOnline2.getStatus() == 1) {
            return R.error("核价已完成，禁止上传");
        }
        priOnline2.setCheckData(checkData);


        MultipartFile file = files[0];
        SimpleDateFormat format = new SimpleDateFormat("yyyyMMdd_HHmmss");
        String path =  ClassUtils.getDefaultClassLoader().getResource("excel/uploadCheckData").getPath();
        //文件后缀名
        String suffix = file.getOriginalFilename().substring(file.getOriginalFilename().lastIndexOf("."));
        //上传文件名
        String filename = format.format(new Date()) + suffix;
        //最终文件路径
        String filepath = path + "/" + filename;


        //服务器端保存的文件对象
        File serverFile = new File(filepath);
        if(!serverFile.exists()) {
            try {
                //创建文件
                serverFile.createNewFile();
                //将上传的文件写入到服务器端文件内
                file.transferTo(serverFile);
            } catch (IOException e) {
                e.printStackTrace();
            }
        }

        //保存文件名
        priOnline2.setCheckDataFile(filename);
        priOnline2Service.updateById(priOnline2);
        return R.ok();
    }

    @GetMapping("/priOnline2/checkDataDownload/{filename}")
    public void download(@PathVariable String filename, HttpServletResponse response) {
        try {
            ClassPathResource pathResource = new ClassPathResource("excel/uploadCheckData/" + filename);
            File file = pathResource.getFile();
            InputStream inputStream = pathResource.getInputStream();
            //输出文件
            InputStream fis = new BufferedInputStream(inputStream);
            byte[] buffer = new byte[fis.available()];
            fis.read(buffer);
            fis.close();
            response.reset();

            //获取文件的名字再浏览器下载页面
            String name = file.getName();
            response.addHeader("Content-Disposition", "attachment;filename=" + new String(name.getBytes(), "iso-8859-1"));
            response.addHeader("Content-Length", "" + file.length());
            OutputStream out = new BufferedOutputStream(response.getOutputStream());
            response.setContentType("application/octet-stream");
            out.write(buffer);
            out.flush();
            out.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    @RequestMapping(value = "/priOnline2/delete/auth")
    @ManagerAuth
    public R delete(Long[] ids){
        if (Cools.isEmpty(ids)){
            return R.error();
        }
        priOnline2Service.deleteBatchIds(Arrays.asList(ids));
        return R.ok();
    }

    @RequestMapping(value = "/priOnline2/export/auth")
    @ManagerAuth
    public R export(@RequestBody JSONObject param){
        EntityWrapper<PriOnline2> wrapper = new EntityWrapper<>();
        List<String> fields = JSONObject.parseArray(param.getJSONArray("fields").toJSONString(), String.class);
        Map<String, Object> map = excludeTrash(param.getJSONObject("priOnline"));
        convert(map, wrapper);
        List<PriOnline2> list = priOnline2Service.selectList(wrapper);
        return R.ok(exportSupport(list, fields));
    }

    @RequestMapping(value = "/priOnline2Query/auth")
    @ManagerAuth
    public R query(String condition) {
        EntityWrapper<PriOnline2> wrapper = new EntityWrapper<>();
        wrapper.like("order_num", condition);
        wrapper.in("member_id", getUserRoleBelongsToUserId("allopen"));
        Page<PriOnline2> page = priOnline2Service.selectPage(new Page<>(0, 10), wrapper);
        List<Map<String, Object>> result = new ArrayList<>();
        for (PriOnline2 priOnline2 : page.getRecords()){
            Map<String, Object> map = new HashMap<>();
            map.put("id", priOnline2.getId());
            map.put("value", priOnline2.getOrderNum() + "/" + priOnline2.getPlanId$() + "/" + priOnline2.getMemberId$());
            result.add(map);
        }
        return R.ok(result);
    }

    @RequestMapping(value = "/priOnline2/check/column/auth")
    @ManagerAuth
    public R query(@RequestBody JSONObject param) {
        Wrapper<PriOnline2> wrapper = new EntityWrapper<PriOnline2>().eq(humpToLine(String.valueOf(param.get("key"))), param.get("val"));
        if (null != priOnline2Service.selectOne(wrapper)){
            return R.parse(BaseRes.REPEAT).add(getComment(PriOnline2.class, String.valueOf(param.get("key"))));
        }
        return R.ok();
    }

    @RequestMapping("/priOnline2/all/get/kv")
    @ManagerAuth
    public R getDataKV(@RequestParam(required = false) String condition) {
        List<KeyValueVo> vos = new ArrayList<>();
        Wrapper<PriOnline2> wrapper = new EntityWrapper<PriOnline2>().andNew().like("id", condition).orderBy("create_time", false);
        priOnline2Service.selectPage(new Page<>(1, 30), wrapper).getRecords().forEach(item -> vos.add(new KeyValueVo(String.valueOf(item.getId()), item.getId())));
        return R.ok().add(vos);
    }

}

 src/main/java/com/zy/crm/manager/entity/PriOnline2.java

New file
@@ -0,0 +1,196 @@
package com.zy.crm.manager.entity;

import com.baomidou.mybatisplus.annotations.TableField;
import com.baomidou.mybatisplus.annotations.TableId;
import com.baomidou.mybatisplus.annotations.TableName;
import com.baomidou.mybatisplus.enums.IdType;
import com.core.common.Cools;
import com.core.common.SpringUtils;
import com.zy.crm.manager.service.PlanService;
import com.zy.crm.system.entity.User;
import com.zy.crm.system.service.UserService;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import java.io.Serializable;
import java.text.SimpleDateFormat;
import java.util.Date;

@Data
@TableName("man_pri_online2")
public class PriOnline2 implements Serializable {

    private static final long serialVersionUID = 1L;

    /**
     * ID
     */
    @ApiModelProperty(value= "ID")
    @TableId(value = "id", type = IdType.AUTO)
    private Long id;

    /**
     * excel表标题
     */
    @ApiModelProperty(value= "excel表标题")
    private String title;

    /**
     * excel表数据
     */
    @ApiModelProperty(value= "excel表数据")
    @TableField("sheet_data")
    private String sheetData;

    @ApiModelProperty(value= "文件保存地址")
    private String filepath;

    /**
     * 创建时间
     */
    @ApiModelProperty(value= "创建时间")
    @TableField("create_time")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
    private Date createTime;

    @ApiModelProperty(value= "项目id{man_item}")
    @TableField("item_id")
    private Long itemId;

    @ApiModelProperty(value= "订单号")
    @TableField("order_num")
    private String orderNum;

    @ApiModelProperty(value= "模板名")
    @TableField("template_name")
    private String templateName;

    @ApiModelProperty(value= "创建人员用户id")
    @TableField("user_id")
    private Long userId;

    @ApiModelProperty(value= "创建人员用户部门")
    @TableField("dept_id")
    private Long deptId;

    @ApiModelProperty(value= "状态{0：未完成，1：已完成}")
    @TableField("status")
    private Integer status;

    @ApiModelProperty(value= "更新时间")
    @TableField("update_time")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
    private Date updateTime;

    @ApiModelProperty(value= "上传报价excel数据")
    @TableField("check_data")
    private String checkData;

    @ApiModelProperty(value= "更新人员")
    @TableField("update_user_id")
    private Long updateUserId;

    @ApiModelProperty(value= "业务员")
    @TableField("member_id")
    private Long memberId;

    @ApiModelProperty(value= "上传报价excel数据的原始文件地址")
    @TableField("check_data_file")
    private String checkDataFile;

    public PriOnline2() {}

    public PriOnline2(String title, String sheetData, Date createTime, String filepath) {
        this.title = title;
        this.sheetData = sheetData;
        this.createTime = createTime;
        this.filepath = filepath;
    }

//    PriOnline priOnline = new PriOnline(
//            null,    // excel表标题
//            null,    // excel表数据
//            null    // 创建时间
//    );

    public String getCreateTime$(){
        if (Cools.isEmpty(this.createTime)){
            return "";
        }
        return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.createTime);
    }

    public String getUpdateTime$(){
        if (Cools.isEmpty(this.updateTime)){
            return "";
        }
        return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.updateTime);
    }

//    public String getItemId$() {
//        ItemService itemService = SpringUtils.getBean(ItemService.class);
//        Item item = itemService.selectById(this.itemId);
//        if (!Cools.isEmpty(item)){
//            return String.valueOf(item.getName());
//        }
//        return null;
//    }

    public String getPlanId$() {
        PlanService planService = SpringUtils.getBean(PlanService.class);
        Plan plan = planService.selectById(this.itemId);
        if (!Cools.isEmpty(plan)){
            return String.valueOf(plan.getUuid());
        }
        return null;
    }

    public String getUser$() {
        UserService userService = SpringUtils.getBean(UserService.class);
        User user = userService.selectById(this.userId);
        if (!Cools.isEmpty(user)){
            return String.valueOf(user.getNickname());
        }
        return null;
    }

    public String getUpdateUserId$() {
        UserService userService = SpringUtils.getBean(UserService.class);
        User user = userService.selectById(this.updateUserId);
        if (!Cools.isEmpty(user)){
            return String.valueOf(user.getNickname());
        }
        return null;
    }

    public String getMemberId$() {
        UserService userService = SpringUtils.getBean(UserService.class);
        User user = userService.selectById(this.memberId);
        if (!Cools.isEmpty(user)){
            return String.valueOf(user.getNickname());
        }
        return null;
    }

    public String getStatus$() {
        if (null == this.status){ return null; }
        switch (this.status){
            case 1:
                return "已完成";
            case 0:
                return "未完成";
            default:
                return String.valueOf(this.status);
        }
    }

    public String getCheckDataStatus$() {
        if (Cools.isEmpty(this.checkData)) {
            return "未上传";
        }
        return "已上传";
    }


}

 src/main/java/com/zy/crm/manager/mapper/PriOnline2Mapper.java

New file
@@ -0,0 +1,19 @@
package com.zy.crm.manager.mapper;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.baomidou.mybatisplus.plugins.Page;
import com.zy.crm.manager.entity.PriOnline2;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

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

@Mapper
@Repository
public interface PriOnline2Mapper extends BaseMapper<PriOnline2> {

    List<PriOnline2> listByPage(Page<PriOnline2> page, @Param("userIds") ArrayList<Long> userIds , @Param("condition") String condition);

}

 src/main/java/com/zy/crm/manager/service/PriOnline2Service.java

New file
@@ -0,0 +1,13 @@
package com.zy.crm.manager.service;

import com.baomidou.mybatisplus.plugins.Page;
import com.baomidou.mybatisplus.service.IService;
import com.zy.crm.manager.entity.PriOnline2;

import java.util.ArrayList;

public interface PriOnline2Service extends IService<PriOnline2> {

    Page<PriOnline2> listByPage(Page<PriOnline2> page, ArrayList<Long> userIds , String condition);

}

 src/main/java/com/zy/crm/manager/service/impl/PriOnline2ServiceImpl.java

New file
@@ -0,0 +1,19 @@
package com.zy.crm.manager.service.impl;

import com.baomidou.mybatisplus.plugins.Page;
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import com.zy.crm.manager.entity.PriOnline2;
import com.zy.crm.manager.mapper.PriOnline2Mapper;
import com.zy.crm.manager.service.PriOnline2Service;
import org.springframework.stereotype.Service;

import java.util.ArrayList;

@Service("priOnline2Service")
public class PriOnline2ServiceImpl extends ServiceImpl<PriOnline2Mapper, PriOnline2> implements PriOnline2Service {

    @Override
    public Page<PriOnline2> listByPage(Page<PriOnline2> page, ArrayList<Long> userIds, String condition) {
        return page.setRecords(this.baseMapper.listByPage(page, userIds, condition));
    }
}

 src/main/resources/mapper/PriOnline2Mapper.xml

New file
@@ -0,0 +1,61 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zy.crm.manager.mapper.PriOnline2Mapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.zy.crm.manager.entity.PriOnline2">
        <id column="id" property="id" />
        <result column="title" property="title" />
        <result column="sheet_data" property="sheetData" />
        <result column="create_time" property="createTime" />
        <result column="filepath" property="filepath" />
        <result column="item_id" property="itemId" />
        <result column="order_num" property="orderNum" />
        <result column="template_name" property="templateName" />
        <result column="user_id" property="userId" />
        <result column="dept_id" property="deptId" />
        <result column="status" property="status" />
        <result column="update_time" property="updateTime" />
        <result column="check_data" property="checkData" />
    </resultMap>

    <!-- 查询结果不包含excel数据data，以免结果集过大 -->
    <resultMap id="NoDataResultMap" type="com.zy.crm.manager.entity.PriOnline2">
        <id column="id" property="id" />
        <result column="title" property="title" />
        <result column="create_time" property="createTime" />
        <result column="filepath" property="filepath" />
        <result column="item_id" property="itemId" />
        <result column="order_num" property="orderNum" />
        <result column="template_name" property="templateName" />
        <result column="user_id" property="userId" />
        <result column="dept_id" property="deptId" />
        <result column="status" property="status" />
        <result column="update_time" property="updateTime" />
    </resultMap>

    <select id="listByPage" resultMap="NoDataResultMap">
        SELECT
        *
        FROM man_pri_online2
        WHERE 1=1
        <if test="userIds != null">
            and user_id in
            <foreach collection="userIds" index="index" item="item" separator="," open="(" close=")">
                #{item}
            </foreach>
        </if>
        <if test="condition != null and condition != ''">
            and (
            id like concat('%',#{condition},'%')
            or title like concat('%',#{condition},'%')
            or item_id like concat('%',#{condition},'%')
            or order_num like concat('%',#{condition},'%')
            or template_name like concat('%',#{condition},'%')
            or user_id like concat('%',#{condition},'%')
            )
        </if>
        ORDER BY id DESC
    </select>

</mapper>

 src/main/webapp/static/js/priOnline2/data1.txt

New file
@@ -0,0 +1 @@
H4sIAAAAAAAAA+1dW3uqPBP9QV58imLbS7faSiu4rQeEO1GrIAerouCv/xIQDzX2rXZXJ3Yu9tPt4pAhmazMGkKiZmem4TzO9YaUl2zF09V2Wm5IM8lRFsbTQyhZnimZS7OXfR31K+0V/R0ffwj1p3Z0XC7S3+T4U9ms2XNjED4LFBffizmx6mfFd3MkToT/VQfd4SjlmE50vpKWrMmd5Ogjeu6r0Pb1zvPIoMfculkzn13JTZPz0uT/VcerWmP/7s15f6k4rnE/J/eu5LsvGrVNc3pmzREzxtOSnP88I/cLqsXnSb8o5eXi0tQdzaxZLXJMp/YHtQiTaRmhLkgeOWcY/xub5Dovua5P7bAK5LqMFdnqSuvfcvzXfV6ty7J6oZRXspmHaoXUp0qOuzOzZ8b30cgxuQLs2FNcX4bbnhnFwO+rwQyxf4g9pmcq6Vt9Uu+SP7i3ffXvPDzZ793Fs2Fbdz3ql6ZO2i4uj/r8kvhgmZxnk/t5S3Lc0UlZSoP4tkv9s5ymGG1v4qeuZg7JOYXo30vUf0fJdULk75X0bNNv9aIi5gfLqG9l65H/6E6Z2lbRVdHuOY8zeoxeJ5G+90bKNCh/+GrdGgzcWdS/yXNYk7heiO0GLYOc1+0kfUp3SFkZaiPtO3KzTjGLlt9z+uZLiZwT/5vQsrqV9XWuHtn91ghIf9RoHXmTXJPww5LWkUVtIs/haNSecd82nHaoqdExeh2pw+cH8v85/X/+ZVAmPHJ/DocoJ3HIn6gvxr7Q7Y9rZvr9DA509ZI3fxle1hcm6jKvDf6e7gvd9qzmVKzwor5gW3pnvNDSJ/uCqAltsSool/UFdTxKdVdn+II9kd6cWf6YLxT+qS+A49YbwzqNgMZM/+mvhhn568+2N/VT6ptW2Uz6htx4jnz2q/2f0X+W/7r/fLClsLGBPPOVbIBUHwxbcoBsuWC9/HQZgHjkJrF1HA3Dv2nMQeMMKaTlRnGOJZlR/PHl8ZsRCxX/cSyEtpxriw/IlgvWy4+XAYdPbhIL+tXHORj/prEk+bvaxI8hxo/g4yQQ4yvAesH4kW8MYvxo1dd5HClN+fgr2n+dq/rxXM+hLYWNDb2r2QCpPq6Ul4FXL5h35ByDmHdUkvcHVgu8rq5vbVj9Tt0IQ29wWC+XsgUc59wWBlJ3C4nuVkzU3eD1JQhdArBeUHfzjYHU3b1Ed2dRd4PXlzB0Cbx6Qd3NOQZRd9M50bHuHqLuhq3pwOgNePXyE2WUUU//bj0tJnq6hvMg4etGEHoDYL38RBkN1NO/W0+Xlwk3ys0Cxo3g4yMY4yq8esG4kW8MZNwYyJt32eUA843g82ow8jEc1ssP2hJgXvJ35yXlppS8swlkfJ8NX2eC0CcA6wX1N98YTP29/camKaP+Bq8zYegTePWC8yD5xmDqb2XzTrvMwXc2aAvqcJz3c8sYTH3d2uhrBf777dvTcKifYdQ9IJ64SQymft58KyM3NfD6GW1BHY06+pYxoDo63OhoiN/N3EoZMHQB6l5gnMA/BlP3Dje6t1YEqHtvpQwQ8T7qWWicwD2W6NkT25G+sz/pvf4ZvoJlYBk4XwQGP6z3/JhPamZ6kuoO5r7pL8g/b5C6d/zui51yeqMUxRxt5g9KZk3NT3xyzHqz/XdjsZBW3nR6503fK7Z7N3Xcl5XtVksTV3qzzffSZPj8v/i8Z+If1qPL2KfjYE7aen+Oy9r03fHOamU+nR9K3/Xu7nUU7YdyZJ8m1t5Im/P/PMS5lN09n6To2igH0ok0yZzGm+Qv3f8qpP1qd8+l9d4eramvPlu0Ts3T9/ewX+5s0pC0Ds/Z4yP4Qkz8hbqrH9Sd7H5Wd68P5+Whyl/IS+D3FBfPQ6331In6drfqTbyKM9OqiU+etr+OHi7zumDmX7p/xOlT8e4u7F6HF6SjvMD2bekDL3w35yZlSD/95+P/yfNFt/tRDf1a426eOounkn35rsRT0ok8JSFP3RS2y1NkjPaTeEb1zYFpjQbx+GvV1N6s5vQ9XxVnqW57HsUz6uNwYPp+Tf1jpdQsGavzdq175w1MYZaeFNul8VJuDueyVQjkwaA7qpnuqKb6jh/dzxn6jZyZMkfvNXa/OZzrmgZg409zF73HXty0SuIm8jeM7kljpSztg21WnLX6NM4KP9nb0pI/i98+3vdneeq8vPXJZcDph7eJrfPW381HhwqdY/X5OJHEWhPbiLSTPatO7endaH76votOe5GKuGPp++rCf0r/iz0CjzxDgfUMjutVJo5esofa/+x5XpwbjTP2umTe44f469Lf6txKDgnzVPxjZ+axT9ZhO3vK5jxnrDQLJ2vInesuyWfFWbN8+l7Is5dAvqStP7+GxSX00q2UAad/3ySWzJO6TC4m3g+3tfxbW8dUtZfnSamckU/et1nKyKXVOrazTLNbD67EZ5nz+KyFfPY7ywDQ528ZuwKf+al71zqHw2j+P3cl3pLOi8MsjMN+aRkA+vYtY3v597BqB75ULI198a/tT/7SOQL2RHqzp57reblO/D5bWnnzlzfHnRoJTt8tuo7XtGdaaTLMW7Zv/HVso0nzYM40dx8aA1MeplRjXlOfRgOaA1eXVqqRt6zXuTGoFYZfz79f2caL599zJ+bfN+ez8u90jfjj+ffhZ/n3j/fF/DtiX82/RzkjObyz3RfLcaWSPXl58xZG1rOMt7EvLfb6q3s3dT2tROcs2G53SvusM/PciaNlbUu07EW3Svo96cfS/8a+lwuqq/JSLhX8L8+bsmRf1ENPnIQFsdtw81XhIS8JWbFqVu/uQjlfbbjiJC+Ieiov5p8KdN6DqAvvovheFqcvz3ndUUQtpYmGYIrGe0s0in/F6ntNbtwHxI5l9To8IR7niVdWfxY/5YnGZzwx/uZ8CpBxBsYy3GNRLAPADsT23k0IAOxAbG9MhmAHYshbYDHkLXAY8hY0DHkLHIa8BQ5D3oKGIW+Bw5C3wGHIW9Aw5C1wGPIWOAx5CxqGvAUOQ94ChyFvQcOQt8BhyFvgMOQtaBjyFjgMeQschrwFDUPeAochb4HDkLegYchb4DDkLXAY8hY0DHkLHIa8BQ5D3oKGIW+Bw5C3wGHIW9Aw5C1wGPIWOAx5CxqGvAUOQ94ChyFvQcOQt8BhyFvgMOQtaBjyFjgMeQschrwFDUPeAochb4HDkLegYchb4DDkLXAY8hY0LOh36Dq9woOvO7Ybr52esXtO347+b/15k4ubNX2Xx9cH7j9Ui1Iot++XrP3SWesJr89PM85PH57/HJ9v790/PH7/zflpxvnH75/Zu/+n+5bS82uPe+d/us56dP5+/fzHest0vfKHUH9qhw1VdAxynO7R1nMefV1otwadPzZdN1gTaJvSde71kVFpx+3mPi/6mYeJ4bzag/UaxKSNZx3B9sn9cusyZ/G5SnqgBnayb7IhBAu6RvPh+ufRHmzpM64xT71mvZ50qKmiq7dfxd5Ti67FbenEb6P1uJ3HWV9txetJOw/ZD89F7/3WVcWx3hmu10+O1/TuZV9Fg94r2qteWRhPDyFz7eVorwDpxGsy8VrW7vPIIP2nXbGXOl0r3FFs0vfo+tuCpgYZitFnM7L9HRsL8b0fd9psve44OXfVr9gzep0c99WZkZWYeydGPmOeeE0nXp/7H/nVik8fqXPpI3TfAg59RKB8d4PcExz6FW2z5el+5Z7qV5f2xfIhXxEf6p3qV5f2xcaBL4Zn+uKV/Urm0kfofrEc+kiGTx/ROPAR6ZBHiI8YZ4xp4P3KPPCrgAO/Cg/9SuLTr0IufSTNp4+0uPQRxeTAR8J/puWh+9WKreWh+5XM1PIc+tWKTx+pc+kjCg8xzKGPnKvlL+kj6d+jy+tc6nLlMEfEgy5n+BUPuvzQR3jQ5Qwf4UGXM3yEB13e+jW6XDnM9/CgyzN86nKGX3Ggyxk+woMuZ/gID7r80Ed40OXKYe7mVnW5wKcu17jU5Qy/4kGXM3yEB11+6CM86HKGj/Cgy7O/R5f3+NTlh/keHnQ5w6940OWHPsKFLj/0ER50OcNHeNDlw1+jy2uH+R4edHmOT13O8CsOdDnDR3jQ5Qwf4UGXH/oID7q8dpi7uVVdLvKpy8dc6nKGX/Ggyxk+woMuP/QRHnQ5w0d40OXBP/xeiMdn5SHOZNnNgzZn2c0Db7Ls5iHWZNnNgz5n2c0Hd/6eeJP1rHxwJ6ffATHs5oM7+Xx/zrKbD+7kNe78Pe/QWc/KB3ce2s0Hd/L5Hp1lNx/ceWg3H9zJ57v04Bd9F8R6Vj64k8/36Sy7+eDOQ7v54E4+36mz7OaCOxnfFtwsdzKelQvu5PQbIZbdXHAnw24uuJPT74RYdvPBnb8o38npt0Isu/ngTk7znZx+L8Symw/u5DTf+Yu+GWI9Kx/cyWm+k9Pvhlh288GdnOY7Of12KGB8d3C73MlpvpPT74dYdvPBnZzmOzn9hohlNxfcyfhu4ma5k9PviFh2c8GdDLu54E5OvyVi2c0FdzLs5oM7f1G+k/GsfHAnp/lOTr8pYtnNB3dymu/k9Lui8Mi750txJ/T9Q1j1cy5vwX9W9thyi+Mo61l5GI/CIzn722wjPvP84ZHc4G22EZ/5xE/Xn/7s22Ny3fY75c52navTrqmbNSfe/zH5Zvvr1//YGrKf1DX9pnrbLjtr1Zx0Dd0XLd7vcvPN99ev/6l1ID/7Pp6uebD5lv5x2x9Pu4aO+/H+nomPn3D9T63ldrs+/ul6TDfr45/mQG7Xxz9fF+GWn/u3tvfv5PLPvyW64ef+9DuAW37uX9q/f2ms9vncmRt+7k/fe9/yc3PdvzN9Wi6Ju2e6moueT6ZxNl0v1yrT9TXDalGi9wrpeC2H9BiJX616ciyTHFPM5FgvOZZLjtUaybHycnOv5ub+JBbYHF9tj2/KIBy6OS5sj2/KIb63OS5uju/Yv72/tL3/9hnC7f2l7f23zxFu7y/F94/WaCP1XGnPDSewjUgfSMtofKdrvkVll7OUA+Oyhzlyn1XkL6Wk/spLepyWXWsSPW9pFAvkbHTvDGmnhdHuT/TKqxe1q1WI14GL701tWf+V13/r67+t9V9t41ekfb2u+jqO23j+QPXNvpacOLpgh/rjw4r4vK1lX996wqNAdZmaofYEGU2Yiz1hZOsdeqxN/EVJd7LKqO+Q8uw58bvA1qlWpPdzE7tJfZTGtD+kjSyx30zTXJCnq7bbrUT1T9frJPfS0x0hs4jutXP9Fisva02Kvy56jw9zI6vb6362vtfrm6E+RPZGvks1FfFVdVWYyY87bWXGmGKnZ2vd5RgCqetwu5d6X834HUFfaNk2ba/lW5ueq096gm0aT+2x1nkdUQ4gbWKQdp0pzfJMWdVntWZvJjelZbVUTpMYL1AsjfweitUS9e9lKK9aM9lq5cjvHIn5V3KpPpNXUrZakjOk7JWyksnvsVAt1SmnpBXiJ0pJy5DfORJDZOQSLUsOqqVWhsRSGWXVmykW0Z8lLSTlCeRc8lsj5WkiKS9LbCF2yWG11MvQ38qK/h6T30NqT46UPauVWvR3lv6ukfNrzTL5PV6R36IS/e7R3/R+pB3psfKSXic3C5kY60UYvZb05yDCmrTMcqDEWDbGaLnlUI4waRVhVivClOh+UlzGKipjFZchx2WsojJWcRn1qAylFJWRjsuoZ2MsKiMTl9GKylCaURmZuIxWVIZiRWUIcRlaJsaiMoS4jF5cRlR3pA/HWFa2D/0g8ZfIF5oSaSt5Sa7N1CKf6KVJ3dK2FmlbkToTyf8DWmZUF6sxfUaqB8gzDrPR85B+S20n7U1sKoiRTSWZlp8hcQXhDtr+ZVEuEV9qjrPET0Ly/1XkY8TvCUctZYpZPVKGtCJ1QrA69Y+Q/J+UIZG6IGVYWpqUQeq+TP0zW2uSMqyhQMoIa6SOo+cgnCSvCrka9dWmRsqQic2kjJUcRP67GtLnJW1AyliR+g6JD1sF6s/EZlLGithMziN8R8qQic2Rf2dJGWlic0D9nPgA8fGySP2d2EzKqBObiV+XiM1RHxhT/88o1pj2Bdqv0sRmUkY9G9VxidhMziP2kzJaxGaFjmdW9/EhS/gu3aU5w2Z5Fa237Izeuk/tiS6M0jEPt2h+m7SfMh10FMIjbcpnNmlbq/9kLwz7IY4HEg50JwtDyDRIu0+McL3HAKkxQwhmzae201/npxKs/fSwXHPUxFAfXb0jR9xL7dPUwKoLo1GX8rE9pzY7XTVI653nDbfujOvrY9JOHm6fj4kfktjDTndV8td5CEl5u9zcP3hOgcQzT+3QcB7ThHsXPScz6hPu1zqUVydGhzyb/vSY1tq63XNsUj65F60TOs5F49OIxEjk+ifb74YJRusuiPoFvQeNp9bPb63/CnG+i4xLZtXxqtbYv3tz3l8qjmvcz8X3YiXffdFojKJl61EsojtlGodVdFUkdjzGsViR5g970XqjBs0l+t2hX2vczVNdzxt0+4sw63jS28SbDGl+0dTDnTwezZlGa6na6bVNjm7G653qbjSO0vHI0cIjOT5nlFwnJO1tqHIcF5rrMWQ9lvRcOVm3lY4j2U1OcPc8mmeMc4tz+vtjnTGvMc+4Jjz9GqrXT77mjOdRTnmexrZ+19fQeM0U70JV1FLZ031ncG/76t95SNv22d2NpY31PiLdzjqmcXRHiuewOFG80KR7PerWsTg7jm9ozKKn4+eINUbyPmz9d7dP2GMp607uCtRvrX6c53Y0aue4bxtOm/BRlDOn9yN+Hb1rm0fPrxcVMT9YRs9Pnm/LE1SHROVMEn/VHW39/khfJXkZ3ZGP5fK95Lp+FNv9Wefz17EnvS5ag1+L6py2ieSb7qjWHS6K0R7g8VwJRx9RO1+Ftk84bhTnwOu0TDde7zhNn9+b5JqEF5bn9Nv0Sf22wvCp8INPTYR6vtrwzuCj/pgEuu/Fq/hU+iPP2kZpMsrdn+5TE3WZ1wZ/r+NTrQ8+pSr2oPFgNU72KdvSO+OFlr6KT+1wW+xT3UZFnNbO8Cl1PEp1V0d9qvgjPhUejN3/Xfd+XPc/a2Nsj2fKUTvQdpYCugb6pv7Ng/H1q77P8JHCz/iIeTCef7CxsLGtdy3bQvj1txOn/KeNhnklGznwwx2uulzZ4UE8B6MN1/bQHFsyHsqk3O04Ja/HqfJmnPoqnzPG0uXPjKWJjRIHNsoc2Fg/wcbclWxscVCP2tbGi5VdX5ddANaGa3uiuonimNVuHKMc5gnAjR8bGwHGMRvbAMcxiY2Q45iNjRz44TXiGOUwLwWjDdf20LqJdKRVN3f0XeYgD/VlbX0xDZrYGB6zsb61bXUl21Yc1F/6BBsvouEZNmY4qEdha+PFyhaA52EyiUZSGrsaSeNAIyU2HtVIhY1thH+vYxtkbZTYCFkbJTZC1kaJjRpgG3vANZSWaChhT0OFHGioELCGCjnQUCEHGirkQEOF19NQtSJwDRUmGqq3q6FyHGioxEaIGiqxDbKGSmyErKESGyFrqMTGa2goEbiGyiUaqlbc1VBjDjRUYiNEDZXYBllDJTZC1lCJjZA1VGLjD79fajDnLS2B84u44Ze9HM3GbsjxS8CY+wpGH8n0uxTwHLNpZ8gxzKadIWukbXtfhWcC4DwTtWGsk8rLvTl5zWRuJ+RYZlO/ELVSwJirDLB/JO0MOZ7ZtDNkvRQw5hH/RDsG7HaUgOd7ozaM5+Y1y+ZevfEw/3dTvxB1UzmZ+w05LxNwMQd4086QtdOmvQUY7V1mtzfw+cJxW8ffI+zPFy6vuNBZgN9DyU0e5gpv2hm2zuLgXdS2va+is9LgddbmfVR5ta+zkrnOoHVWUr8gdRYP84a37QxaZyXtDFpnXXPuMF1nA7jOSm911t784WAz7xn0OJLUL+TvoMo8zCXetDdsvZW0N2i9dc35xPHajKB1VGujo/bnFJeTudCgddSmfo/qKAi8yJhffDn/T9oRtE5K2hG2TmLMHb5cO2ah6yTahmudJOzrpGQ+M2idlNTvUZ0Egu84mCO8bW/Qeilpb9h66YrzhOXmELpeym710t5c4WAzxxn0eJLUr3SN8YQxH/hyfp20D2x9k7QPaH1zzbm+8ZrcoPXNcKNv9uf7lpN5yqD1zaZ+r8L/jDm9l/PrpH1A65akfWDrlgvN12W2o8SYr3tq+5S/0D7M99ihfBgHnFrvwRfqnT2vx0rmL54/vlO7z3uvtqn3b4zv36/3nfH9CvXeuma9f2M8/ka9H1u3910Y56sNV5zkhfxLPkX+je7uwq7ovXfyeliJMN0MxVxNEo13hx5TUmp+4qfurZrpL3zT9wbqm+93e9Oa2pvVnN4opb54Nafgrs9zrIIvqz3G+qcHcxnmV7Dpu3wbKjRX+kk70OfaWVd5ry0+rFGd3ltr2Tqcr7u31vXm+J8HZluz13XeHq9kdv0zOOSFjBWvY7t3fMm2cavp1+vFtqa++mwNSF2bp68Za7/c2SSoXiyevXPa6DSOKC6P1Ct9pufV+lwr6oMus84y/1FnR9r1/HH3Gzx0uKbseu1rt1qauN2qN/EqzkyrJnV/4jrY4TKvC2b+pftHnD4Vad88sn7xaXGF1cqc1oa7c2c/bcOkPoIjbRiy/Z4xd/Snn7HCKv+HY/DPfehgrev1ngLn+c57MSdW/ey5PnNan6D8wWxn+kxhbx0ballax8/7/Hr4TmKfX5PjFaafXWf8P5y3uV6/+c6bv7w57tSwp57reblOzLvSKuED2zf+OrbRtP13wx5pFW86teyh9j97nr+z/UnT8fMVbz5VXup2XZRL5Vy1KS3lZsV1vCZdT96eTqbR/SZedexLC8/rWkf8gx0PXNnGy8cH4dH4ILPPQYdr4O5zoMyODw7nmLLL3/ffZF7lsfhgxebJw7VbT7FRuYo++/68x2+Mz4x5j9/NW0h0H6BTy/+4N8bENv4X9a9ZdWpP70bz09fQd9qLKP5Wl76vLvynY3sC/Iv+xczLhIy1Utd7TeT/5HWnLmpPf0Vj4Btq+oz9Gpj3uM7zhT+aFzzSbxjzIS/fbzLn95vzx9d/MH/xG3zFmL940Vi0dTAOxRrw5XlSai1P54md637mOdj50M1zfNhPZ/YSyM3T9wRaTsuB/E/2CznC3+y8KmMe48W+DwoZ8xOv0A+ukt/7B/MJv8E/h/MJfzxuZZbf2B9XlWbhXjSKebGbyuU8Zyw3z+ADq7X8W1vHDDXKDeXMFfpVMl9uOw8ojouKs2Y5c/IzRZzSunx8cLivzAXjA8ZapZfrn0n7XSc++P4eL9/gRca6oReNDw7n+cXxQeretZK+fFJ+mGjzXKDEY/Jl+8+hdhbWY314xnMQ7pCuEOck7XGV3GEyvy59lX541bxCUu9XySsk84E+5P2lsGoHvlQsjX3xr+1P/nrT6Z09kd4+5to+5uBo3o3mz+yZVpoM89ZuDs6Z5u5DY2DKw5RqzGvq02ig5m0yhlupRt6yXufGoFYYMt4LHX5zmAZg40/nXw5y0btt9SEX3d7LkzHmM+7l8jbH93N5jPVI2eXv5/KGB7yxn8tLjv9h2nhkP9v/svEq4/XG5quM18m8nML+eGnJvqiHnjgJC2K34earwkNeErJi1aze3YVy8s5c1FN5Mf9UoO/iRF14F8X3sjh9ec7rjiJqKU00BFM03lskLv8rVt9rcuM+kEvEtq/3x1XVV3vvtW5vWFPHk5T5sBiYyjzVyJmp6B18epLqDuY+fQc/GA2jd/Bq/90fdEe1bmgOSKMM1L9OTX3w/N0+V14Qnb2Ui7mr5N135yx+/l7+cE3Q/X4wZveD/3gvvzm+3w+S+W7H8u4iu68y1rS83FgjXrXvfn/NppP7bicu39fUjE1tbkX7wtfDKLYTHmZGVqL9htbbqv/0mO7TvejNOPYzss/jaG95uocq+R3t+x7teT+P6+spbrPY/gCxa2GP6ZkqALADsQ3WaQQGBDsQS7CgX31E3gKFIW+Bw5C3oGHIW+Aw5C1wGPIWNAx5CxyGvAUOQ96ChiFvgcOQt8BhyFvQMOQtcBjyFjgMeQsahrwFDkPeAochb0HDkLfAYchb4DDkLWgY8hY4DHkLHIa8BQ1D3gKHIW+Bw5C3oGHIW+Aw5C1wGPIWNAx5CxyGvAUOQ96ChiFvgcOQt8BhyFvQMOQtcBjyFjgMeQsahrwFDkPeAochb0HDkLfAYchb4DDkLWgY8hY4DHkLHIa8BQ1D3gKHIW+Bw5C3oGHIW+Aw5C1wGPIWNAx5CxyGvAUOQ96ChiFvgcOQt8BhyFvQMOQtcBjyFjgMeQsahrwFDkPeAochb0HDkLfAYchb4DDkLWgY8hY4DHkLHIa8BQ1D3gKHIW+Bw5C3oGHIW+Aw5C1wGPIWNAx5CxyGvAUOQ96ChgX9TmNpasKDrzu2K1mTuzfyu6uKY70zNGtWeSY5ik3OG2ud1xE5bnQ66dkgfPY1NWNLlme2hJGtd+oryYzuMzOyklkzJbNafF71nx7T/Y5Mfy/pcSP7TO4bHQ/pb50c1xpSXs0gd4LCkDvBYcid0DCM+cBhyFvgMOQtaBjyFjgMeQschrwFDUPeAochb4HDkLegYchb4DDkLXAY8hY0DHkLHIa8BQ5D3oKGIW+Bw5C3wGHIW9Aw5C1wGPIWOAx5CxqGvAUOQ94ChyFvQcOQt8BhyFvgMOQtaBjyFjgMeQschrwFDUPeAochb4HDkLegYchb4DDkLXAY8hY0DHkLHIa8BQ5D3oKGIW+Bw5C3wGHIW9Aw5C1wGPIWOAx5CxqGvAUOQ94ChyFvQcOQt8BhyFvgMOQtaBjyFjgMeQschrwFDUPeAochb4HDkLegYchb4DDkLXAY8hY0DHkLHIa8BQ5D3oKGIW+Bw5C3wGHIW9Aw5C1wGPIWOAx5CxqGvAUOQ94ChyFvQcOQt8BhyFvgMOQtaBjyFjgMeQschrwFDUPeAochb4HDkLegYUG/01iamvDg647tStbk7o387qriWO8MzZolzSRHscl5Y63zOiLHjU4n0/8/sugGNLD3AgA=

 src/main/webapp/static/js/priOnline2/priOnline.js

New file
@@ -0,0 +1,544 @@
var pageCurr;
var admin;
var treeCond;
layui.config({
    base: baseUrl + "/static/layui/lay/modules/"
}).extend({
    cascader: 'cascader/cascader',
}).use(['table','laydate', 'form', 'admin', 'xmSelect', 'element', 'cascader', 'tree', 'dropdown'], function(){
    var table = layui.table;
    var $ = layui.jquery;
    var layer = layui.layer;
    var layDate = layui.laydate;
    var tree = layui.tree;
    var form = layui.form;
    var dropdown = layui.dropdown;
    admin = layui.admin;

    $('#organization').html(localStorage.getItem('nickname') + ' <i class="layui-icon">&#xe61a;</i>');

    // 部门人员 筛选
    dropdown.render({
        elem: '#organization'
        ,content: ['<div id="organizationTree" style="height: calc(100vh - 525px);border: none"></div>'].join('')
        ,style: 'width: 370px; height: 350px; padding: 0 15px; box-shadow: 1px 1px 30px rgb(0 0 0 / 12%);'
        ,ready: function(){
            loadTree();
        }
    });

    // 树形图
    var organizationTree;
    window.loadTree = function(condition){
        var loadIndex = layer.load(2);
        $.ajax({
            url: baseUrl+"/dept/user/tree/auth",
            headers: {'token': localStorage.getItem('token')},
            data: {
                'condition': condition
            },
            method: 'POST',
            success: function (res) {
                layer.close(loadIndex);
                if (res.code === 200){
                    organizationTree = tree.render({
                        elem: '#organizationTree',
                        id: 'organizationTree',
                        onlyIconControl: true,
                        data: res.data,
                        click: function (obj) {
                            treeCond = {
                                key: obj.data.key,
                                val: obj.data.id
                            }
                            $('#organization').html(obj.data.title + ' <i class="layui-icon">&#xe61a;</i>');
                            $('#organizationTree').find('.ew-tree-click').removeClass('ew-tree-click');
                            $(obj.elem).children('.layui-tree-entry').addClass('ew-tree-click');
                            clearFormVal($('#search-box'));
                            tableIns.reload({
                                where: {[obj.data.key]: obj.data.id},
                                page: {curr: 1}
                            });
                        }
                    });
                    treeData = res.data;
                } else if (res.code === 403){
                    top.location.href = baseUrl+"/";
                } else {
                    layer.msg(res.msg)
                }
            }
        })
    }

    // 数据渲染
    tableIns = table.render({
        elem: '#priOnline',
        headers: {token: localStorage.getItem('token')},
        url: baseUrl+'/priOnline2/list/auth',
        page: true,
        limit: 16,
        limits: [16, 30, 50, 100, 200, 500],
        toolbar: '#toolbar',
        cellMinWidth: 150,
        cols: [[
            {type: 'checkbox', fixed: 'left'}
            ,{field: 'id', title: 'ID', sort: true,align: 'center', fixed: 'left', width: 80,hide: true}
            ,{field: 'templateName', align: 'center',title: '核价名',hide: false}
            ,{field: 'orderNum', align: 'center',title: '核价单号'}
            ,{field: 'planId$', align: 'center',title: '规划单号'}
            ,{field: 'createTime$', align: 'center',title: '创建时间'}
            ,{field: 'updateTime$', align: 'center',title: '更新时间'}
            ,{field: 'status$', align: 'center',title: '状态'}
            ,{field: 'memberId$', align: 'center',title: '业务员'}
            ,{field: 'user$', align: 'center',title: '创建人员'}
            ,{field: 'updateUserId$', align: 'center',title: '更新人员'}
            ,{field: 'checkDataStatus$', align: 'center',title: '报价数据'}
            ,{fixed: 'right', title:'操作', align: 'center', toolbar: '#operate', width:350}
        ]],
        request: {
            pageName: 'curr',
            pageSize: 'limit'
        },
        parseData: function (res) {
            return {
                'code': res.code,
                'msg': res.msg,
                'count': res.data.total,
                'data': res.data.records
            }
        },
        response: {
            statusCode: 200
        },
        done: function(res, curr, count) {
            if (res.code === 403) {
                top.location.href = baseUrl+"/";
            }
            pageCurr=curr;
            limit();
        }
    });

    // 监听排序事件
    table.on('sort(priOnline)', function (obj) {
        var searchData = {};
        $.each($('#search-box [name]').serializeArray(), function() {
            searchData[this.name] = this.value;
        });
        searchData['orderByField'] = obj.field;
        searchData['orderByType'] = obj.type;
        tableIns.reload({
            where: searchData,
            page: {
                curr: 1
            },
            done: function (res, curr, count) {
                if (res.code === 403) {
                    top.location.href = baseUrl+"/";
                }
                pageCurr=curr;
                limit();
            }
        });
    });

    // 监听头工具栏事件
    table.on('toolbar(priOnline)', function (obj) {
        var checkStatus = table.checkStatus(obj.config.id);
        switch(obj.event) {
            case 'addBlank':
                showEditModel();
                break;
            case 'refreshData':
                tableIns.reload({
                    page: {
                        curr: pageCurr
                    }
                });
                limit();
                break;
            case 'deleteData':
                var data = checkStatus.data;
                var ids=[];
                data.map(function (track) {
                    ids.push(track.id);
                });
                if (ids.length === 0){
                    layer.msg('请选择数据');
                } else {
                    layer.confirm('确定删除'+(ids.length===1?'此':ids.length)+'条数据吗', function(){
                        $.ajax({
                            url: baseUrl+"/priOnline/delete/auth",
                            headers: {'token': localStorage.getItem('token')},
                            data: {ids: ids},
                            method: 'POST',
                            traditional:true,
                            success: function (res) {
                                if (res.code === 200){
                                    layer.closeAll();
                                    tableReload(false);
                                } else if (res.code === 403){
                                    top.location.href = baseUrl+"/";
                                } else {
                                    layer.msg(res.msg)
                                }
                            }
                        })
                    });
                }
                break;
            case 'exportData':
                layer.confirm('确定导出Excel吗', {shadeClose: true}, function(){
                    var titles=[];
                    var fields=[];
                    obj.config.cols[0].map(function (col) {
                        if (col.type === 'normal' && col.hide === false && col.toolbar == null) {
                            titles.push(col.title);
                            fields.push(col.field);
                        }
                    });
                    var exportData = {};
                    $.each($('#search-box [name]').serializeArray(), function() {
                        exportData[this.name] = this.value;
                    });
                    var param = {
                        'config': exportData,
                        'fields': fields
                    };
                    $.ajax({
                        url: baseUrl+"/priOnline/export/auth",
                        headers: {'token': localStorage.getItem('token')},
                        data: JSON.stringify(param),
                        dataType:'json',
                        contentType:'application/json;charset=UTF-8',
                        method: 'POST',
                        success: function (res) {
                            layer.closeAll();
                            if (res.code === 200) {
                                table.exportFile(titles,res.data,'xls');
                            } else if (res.code === 403) {
                                top.location.href = baseUrl+"/";
                            } else {
                                layer.msg(res.msg)
                            }
                        }
                    });
                });
                break;
        }
    });

    // 监听行工具事件
    table.on('tool(priOnline)', function(obj){
        var data = obj.data;
        switch (obj.event) {
            // 核价
            case 'check':
                layer.open({
                    type: 2,
                    title: '核价',
                    maxmin: true,
                    area: [top.detailWidth, top.detailHeight],
                    shadeClose: false,
                    content: 'priOnline_detail.html?id=' + data.id,
                    success: function(layero, index){
                        // layer.iframeAuto(index);layer.style(index, {top: (($(window).height()-layer.getChildFrame('#data-detail', index).height())/3)+"px"});
                    }
                });
                break;
            case 'del':
                layer.confirm('确定删除这条数据吗', function(){
                    $.ajax({
                        url: baseUrl+"/priOnline2/delete/auth",
                        headers: {'token': localStorage.getItem('token')},
                        data: {ids: data.id},
                        method: 'POST',
                        traditional:true,
                        success: function (res) {
                            if (res.code === 200){
                                layer.closeAll();
                                tableReload(false);
                            } else if (res.code === 403){
                                top.location.href = baseUrl+"/";
                            } else {
                                layer.msg(res.msg)
                            }
                        }
                    })
                });
                break;
            case "edit":
                showEditForm(data);
                break;
            case "upload":
                $.ajax({
                    type:"get",
                    url: baseUrl+"/priOnline2/viewCheck/" + data.id + "/auth",
                    dataType:"json",
                    headers: {'token': localStorage.getItem('token')},
                    success:function(res) {
                        if (res.code == 200) {
                            layer.confirm('当前已存在数据，继续上传将会覆盖旧数据，是否上传？', function(){
                                $("#uploadQuote").click()
                            });
                        }else{
                            $("#uploadQuote").click()
                        }
                    }
                });

                $("#uploadQuote").on("change",(evt) => {
                    var files = evt.target.files;
                    if(files==null || files.length==0){
                        alert("No files wait for import");
                        return;
                    }

                    let name = files[0].name;
                    let suffixArr = name.split("."), suffix = suffixArr[suffixArr.length-1];
                    if(suffix!="xlsx"){
                        alert("Currently only supports the import of xlsx files");
                        return;
                    }
                    LuckyExcel.transformExcelToLucky(files[0], function(exportJson, luckysheetfile){
                        if(exportJson.sheets==null || exportJson.sheets.length==0){
                            alert("Failed to read the content of the excel file, currently does not support xls files!");
                            return;
                        }

                        let formData = new FormData($("#uploadFile")[0]);
                        formData.append("id", data.id);
                        formData.append("checkData", zip(exportJson.sheets));
                        $.ajax({
                            url: baseUrl+"/priOnline2/uploadCheck/auth",
                            headers: {'token': localStorage.getItem('token')},
                            data: formData,
                            // data: JSON.stringify({
                            //     id: data.id,
                            //     checkData: zip(exportJson.sheets)
                            // }),
                            // dataType: "json",
                            method: 'POST',
                            cache: false,
                            processData: false,
                            contentType: false,
                            // contentType:'application/json;charset=UTF-8',
                            success: function (res) {
                                if (res.code == 200) {
                                    layer.msg('上传成功',{time:1000},() => {
                                        parent.location.reload()
                                    })
                                }else{
                                    layer.msg(res.msg,{time:1000},() => {
                                        parent.location.reload()
                                    })
                                }
                            }
                        })
                    });
                })
                break;
            case "viewCheck":
                //查看询价
                $.ajax({
                    type:"get",
                    url: baseUrl+"/priOnline2/viewCheck/" + data.id + "/auth",
                    dataType:"json",
                    headers: {'token': localStorage.getItem('token')},
                    success:function(res) {
                        if (res.code == 200) {
                            layer.open({
                                type: 2,
                                title: '查看询价',
                                maxmin: true,
                                area: [top.detailWidth, top.detailHeight],
                                shadeClose: false,
                                content: 'priOnline_check.html?id=' + data.id,
                                success: function(layero, index){
                                    // layer.iframeAuto(index);layer.style(index, {top: (($(window).height()-layer.getChildFrame('#data-detail', index).height())/3)+"px"});
                                }
                            });
                        }else{
                            layer.msg(res.msg,{time:1000})
                        }
                    }
                });
                break;
        }
    });

    // 搜索
    form.on('submit(search)', function (data) {
        pageCurr = 1;
        pageCount = 0;
        tableReload();
    });

    /* 弹窗 - 新增、修改 */
    function showEditModel(mData) {
        admin.open({
            type: 1,
            area: '800px',
            title: (mData ? '修改' : '添加') + '核价',
            content: $('#editDialog').html(),
            success: function (layero, dIndex) {
                form.val('detail', mData);
                form.on('submit(editSubmit)', function (data) {
                    var loadIndex = layer.load(2);
                    layer.close(loadIndex);
                    layer.close(dIndex);
                    layer.open({
                        type: 2,
                        title: '新增',
                        maxmin: true,
                        area: [top.detailWidth, top.detailHeight],
                        shadeClose: false,
                        content: 'priOnline_detail.html?item_id=' + data.field.planId + "&template=" + data.field.template + "&name=" + data.field.name,
                        success: function(layero, index){
                            clearFormVal(layer.getChildFrame('#detail', index));
                            // layer.iframeAuto(index);layer.style(index, {top: (($(window).height()-layer.getChildFrame('#data-detail', index).height())/3)+"px"});
                        }
                    });
                    return false;
                });
                $(layero).children('.layui-layer-content').css('overflow', 'visible');
                layui.form.render('select');
            }
        });
    }

    //更新form
    function showEditForm(mData) {
        admin.open({
            type: 1,
            area: '800px',
            title: '核价信息编辑',
            content: $('#editStatus').html(),
            success: function (layero, dIndex) {
                form.val('editStatusDetail', mData);
                form.render('select')
                form.on('submit(editSubmit)', function (data) {
                    var loadIndex = layer.load(2);
                    $.ajax({
                        url: baseUrl+"/priOnline2/updateForm/auth",
                        headers: {'token': localStorage.getItem('token')},
                        data: data.field,
                        method: 'POST',
                        traditional:true,
                        success: function (res) {
                            if (res.code === 200){
                                layer.closeAll();
                                tableReload(false);
                            } else if (res.code === 403){
                                top.location.href = baseUrl+"/";
                            } else {
                                layer.msg(res.msg)
                            }
                        }
                    })
                    layer.close(loadIndex);
                    layer.close(dIndex);
                    return false;
                });
                $(layero).children('.layui-layer-content').css('overflow', 'visible');
                layui.form.render('select');
            }
        });
    }

});

// 关闭动作
$(document).on('click','#data-detail-close', function () {
    parent.layer.closeAll();
});

function tableReload(child) {
    var searchData = {};
    $.each($('#search-box [name]').serializeArray(), function() {
        searchData[this.name] = this.value;
    });
    (child ? parent.tableIns : tableIns).reload({
        where: searchData,
        page: {
            curr: pageCurr
        },
        done: function (res, curr, count) {
            if (res.code === 403) {
                top.location.href = baseUrl+"/";
            }
            pageCurr=curr;
            if (res.data.length === 0 && count !== 0) {
                tableIns.reload({
                    where: searchData,
                    page: {
                        curr: pageCurr-1
                    }
                });
                pageCurr -= 1;
            }
            limit(child);
        }
    });
}

function setFormVal(el, data, showImg) {
    for (var val in data) {
        var find = el.find(":input[id='" + val + "']");
        find.val(data[val]);
        if (showImg){
            var next = find.next();
            if (next.get(0)){
                if (next.get(0).localName === "img") {
                    find.hide();
                    next.attr("src", data[val]);
                    next.show();
                }
            }
        }
    }
}

function clearFormVal(el) {
    $(':input', el)
        .val('')
        .removeAttr('checked')
        .removeAttr('selected');
}

function detailScreen(index) {
    var detail = layer.getChildFrame('#data-detail', index);
    var height = detail.height()+60;
    if (height > ($(window).height()*0.9)) {
        height = ($(window).height()*0.9);
    }
    layer.style(index, {
        top: (($(window).height()-height)/3)+"px",
        height: height+'px'
    });
    $(".layui-layer-shade").remove();
}

$('body').keydown(function () {
    if (event.keyCode === 13) {
        $("#search").click();
    }
});

// 压缩
function zip(data) {
    if (!data) return data
    // 判断数据是否需要转为JSON
    const dataJson = typeof data !== 'string' && typeof data !== 'number' ? JSON.stringify(data) : data

    // 使用Base64.encode处理字符编码，兼容中文
    const str = Base64.encode(dataJson)
    let binaryString = pako.gzip(str);
    let arr = Array.from(binaryString);
    let s = "";
    arr.forEach((item, index) => {
        s += String.fromCharCode(item)
    })
    return btoa(s)
}

 src/main/webapp/views/priOnline2/css/loading.gif

 src/main/webapp/views/priOnline2/priOnline.html

New file
@@ -0,0 +1,177 @@
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <title></title>
  <meta name="renderer" content="webkit">
  <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
  <link rel="stylesheet" href="../../static/layui/css/layui.css" media="all">
  <link rel="stylesheet" href="../../static/css/admin.css?v=318" media="all">
  <link rel="stylesheet" href="../../static/css/cool.css" media="all">
  <link rel="stylesheet" href="../../static/css/tree.css" media="all">
  <link rel="stylesheet" href="../../static/layui/lay/modules/formDesigner/coolForm.css" />
  <style>
    .nav-box {
      position: absolute;
      top: 1px;
      left: 5px;
    }
    .nav-box-item {
      display: inline-block;
      vertical-align: middle;
      margin-right: 5px;
    }

  </style>
</head>
<body>

<div class="layui-fluid">
  <div class="layui-card">
    <div class="layui-card-body">
      <div id="search-box" class="layui-form toolbar" style="display: flex;justify-content: flex-end;position: relative">
        <div class="nav-box">
          <div class="nav-box-item">
            <i class="layui-icon" style="color: #1890ff;font-weight: bold">&#xe613;</i>
          </div>
          <div class="nav-box-item">
            <button id="organization" style="border: none;padding-right: 35px;" class="layui-btn layui-btn-primary icon-btn">
              未知
            </button>
          </div>
        </div>
        <div class="layui-form-item">
          <div class="layui-inline">
            <div class="layui-input-inline">
              <input class="layui-input" type="text" name="condition" placeholder="请输入" autocomplete="off" style="border-color: #e1e1e1">
            </div>
          </div>
          <div class="layui-inline">&emsp;
            <button class="layui-btn icon-btn layui-btn-sm" lay-filter="search" lay-submit>
              <i class="layui-icon">&#xe615;</i>搜索
            </button>
          </div>
        </div>
      </div>
      <table class="layui-hide" id="priOnline" lay-filter="priOnline"></table>
    </div>
  </div>
</div>

<script type="text/html" id="toolbar">
  <div class="layui-btn-container">
    <button class="layui-btn layui-btn-sm" lay-event="addBlank">新增核价</button>
    <button class="layui-btn layui-btn-sm layui-btn-danger" lay-event="deleteData">删除</button>
  </div>
</script>

<form id="uploadFile" enctype="multipart/form-data" style="display: none;" >
  <input type="file" name="file" id="uploadQuote">
  <input type="button" onclick="upload()" value="上传"/>
</form>


<script type="text/html" id="operate">
  <a class="layui-btn layui-btn-xs btn-edit" lay-event="check">核价</a>
  <a class="layui-btn layui-btn-primary layui-btn-xs btn-edit" lay-event="edit">编辑</a>
  <a class="layui-btn layui-btn-primary layui-btn-xs btn-edit" lay-event="upload">上传询价</a>
  <a class="layui-btn layui-btn-primary layui-btn-xs btn-edit" lay-event="viewCheck">查看询价</a>
  <a class="layui-btn layui-btn-danger layui-btn-xs btn-edit" lay-event="del">删除</a>
</script>

<script type="text/javascript" src="../../static/js/jquery/jquery-3.3.1.min.js"></script>
<script type="text/javascript" src="../../static/layui/layui.js" charset="utf-8"></script>
<script type="text/javascript" src="../../static/js/common.js" charset="utf-8"></script>
<script type="text/javascript" src="../../static/js/cool.js" charset="utf-8"></script>
<script type="text/javascript" src="../../static/js/luckysheet_js/luckyexcel.umd.js"></script>
<script type="text/javascript" src="../../static/js/luckysheet_js/pako.es5.js" charset="utf-8"></script>
<script type="text/javascript" src="../../static/js/luckysheet_js/base64.min.js" charset="utf-8"></script>
<script type="text/javascript" src="../../static/js/priOnline2/priOnline.js" charset="utf-8"></script>
<!-- 表单弹窗 -->
<script type="text/html" id="editDialog">
  <div id="detail" lay-filter="detail" class="layui-form admin-form model-form">
    <input name="id" type="hidden">
    <div class="layui-row">
      <div class="layui-col-md12">
        <div class="layui-form-item">
          <label class="layui-form-label layui-form-required">项目名: </label>
          <div class="layui-input-block cool-auto-complete">
            <input class="layui-input" name="planId" placeholder="请输入项目名" style="display: none" lay-verify="required">
            <input id="planId$" name="planId$" class="layui-input cool-auto-complete-div" onclick="autoShow(this.id)" type="text" placeholder="请输入项目名" onfocus=this.blur()>
            <div class="cool-auto-complete-window">
              <input class="cool-auto-complete-window-input" data-key="planQueryNameBydirector" onkeyup="autoLoad(this.getAttribute('data-key'))">
              <select class="cool-auto-complete-window-select" data-key="planQueryNameBydirectorSelect" onchange="confirmed(this.getAttribute('data-key'))" multiple="multiple">
              </select>
            </div>
          </div>
        </div>

        <div class="layui-form-item">
          <label class="layui-form-label layui-form-required">核价名: </label>
          <div class="layui-input-block">
            <input class="layui-input" type="text" name="name" placeholder="核价名" autocomplete="off">
          </div>
        </div>

        <div class="layui-form-item">
          <label class="layui-form-label layui-form-required">模板: </label>
          <div class="layui-input-block">
            <input type="radio" name="template" value="1" title="模板1" checked><div class="layui-unselect layui-form-radio"><i class="layui-anim layui-icon"></i><div>模板1</div></div>
            <input type="radio" name="template" value="2" title="模板2" disabled><div class="layui-unselect layui-form-radio"><i class="layui-anim layui-icon"></i><div>模板2</div></div>
          </div>
        </div>
      </div>
    </div>
    <hr class="layui-bg-gray">
    <div class="layui-form-item text-right">
      <button class="layui-btn" lay-filter="editSubmit" lay-submit="">保存</button>
      <button class="layui-btn layui-btn-primary" type="button" ew-event="closeDialog">取消</button>
    </div>
  </div>
</script>

<!-- 表单弹窗 -->
<script type="text/html" id="editStatus">
  <div id="editStatusDetail" lay-filter="editStatusDetail" class="layui-form admin-form model-form">
    <input name="id" type="hidden">
    <div class="layui-row">
      <div class="layui-col-md12">
        <div class="layui-form-item">
          <label class="layui-form-label layui-form-required">状态: </label>
          <div class="layui-input-block">
            <select name="status" lay-vertype="tips" lay-verify="required">
              <option value="">请选择状态</option>
              <option value="1">已完成</option>
              <option value="0">未完成</option>
            </select>
          </div>
        </div>

        <div class="layui-form-item">
          <label class="layui-form-label layui-form-required">核价名: </label>
          <div class="layui-input-block">
            <input class="layui-input" name="templateName" placeholder="请输入核价名" autocomplete="off" lay-verify="required">
          </div>
        </div>

        <div class="layui-form-item">
          <label class="layui-form-label layui-form-required">表格标题: </label>
          <div class="layui-input-block">
            <input class="layui-input" name="title" placeholder="请输入表格标题" autocomplete="off" lay-verify="required">
          </div>
        </div>

      </div>
    </div>
    <hr class="layui-bg-gray">
    <div class="layui-form-item text-right">
      <button class="layui-btn" lay-filter="editSubmit" lay-submit="">保存</button>
      <button class="layui-btn layui-btn-primary" type="button" ew-event="closeDialog">取消</button>
    </div>
  </div>
</script>
</body>
</html>



 src/main/webapp/views/priOnline2/priOnline_check.html

New file
@@ -0,0 +1,271 @@
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <title>excel</title>
  <link rel="stylesheet" href="../../static/layui/css/layui.css" media="all">
  <link rel='stylesheet' href='../../static/plugins/css/pluginsCss.css' />
  <link rel='stylesheet' href='../../static/plugins/plugins.css' />
  <link rel='stylesheet' href='../../static/css/luckysheet.css' />
  <link rel='stylesheet' href='../../static/assets/iconfont/iconfont.css' />
  <script src="../../static/js/luckysheet_js/plugin.js"></script>
  <script src="../../static/js/luckysheet_js/luckysheet.umd.js"></script>
  <script src="../../static/js/luckysheet_js/luckyexcel.umd.js"></script>
  <script src="../../static/js/luckysheet_js/exceljs.min.js"></script>
  <script type="text/javascript" src="../../static/js/luckysheet_js/export.js" charset="utf-8"></script>
  <script type="text/javascript" src="../../static/js/luckysheet_js/pako.es5.js" charset="utf-8"></script>
  <script type="text/javascript" src="../../static/js/luckysheet_js/base64.min.js" charset="utf-8"></script>
  <script type="text/javascript" src="../../static/layui/layui.js" charset="utf-8"></script>
  <script type="text/javascript" src="../../static/js/common.js" charset="utf-8"></script>
  <script type="text/javascript" src="../../static/js/luckysheet_js/print.min.js" charset="utf-8"></script>
</head>
<body>
<div style="display: flex;position: absolute;top: 20px;left:30px;z-index: 9999;">
  <!--  <div><button type="button" id="export">导出Execel</button></div>-->
<!--  <div><button type="button" id="save">保存到服务器</button></div>-->
<!--  <div><button type="button" id="otherSave">另保存到服务器</button></div>-->
  <div><button type="button" class="layui-btn layui-btn-primary layui-btn-xs btn-edit" id="allprint">全部打印</button></div>
  <div><button type="button" class="layui-btn layui-btn-primary layui-btn-xs btn-edit" id="print">选区打印</button></div>
  <div><button type="button" class="layui-btn layui-btn-primary layui-btn-xs btn-edit" id="download">下载</button></div>
</div>
<div id="luckysheet" style="margin:0px;padding:0px;position:absolute;width:100%;height: 100vh;left: 0px;top: 0px;"></div>
<script>
  $(function () {
    var layer = layui.layer;

    //配置项
    var options = {
      container: 'luckysheet' ,//luckysheet为容器id
      title: '查看询价', //工作簿名称
      lang: 'zh', //设定表格语言 国际化设置，允许设置表格的语言，支持中文("zh")和英文("en")
      allowEdit: true, //是否允许前台编辑
      sheetFormulaBar: true, //是否显示公式栏
      forceCalculation: true,//强制计算公式
      myFolderUrl: '' //左上角<返回按钮的链接
    }

    let checkDataFile = "";

    if(getUrlParams('id') == false || getUrlParams('id') == undefined){
      //新增
      luckysheet.create(options)
      $("#luckysheet_info_detail_update").hide()
      $("#luckysheet_info_detail_save").hide()
      $("#luckysheet_info_detail_title").hide()
    }else{
      //修改
      $.ajax({
        type:"get",
        url: baseUrl + "/priOnline2/viewCheck/" + getUrlParams('id') + "/auth",
        dataType:"json",
        headers: {'token': localStorage.getItem('token')},
        success:function(res) {
          if (res.code == 200) {
            checkDataFile = res.data.checkDataFile
            options.data = unzip(res.data.checkData)
            luckysheet.create(options)
            $("#luckysheet_info_detail_update").hide()
            $("#luckysheet_info_detail_save").hide()
            $("#luckysheet_info_detail_title").hide()
          }else {
            layer.msg(res.msg,{time:1000})
          }
        }
      });

    }

    $("#export").on("click",() => {
      console.log('export')
      exportExcel(luckysheet.getluckysheetfile()).then((e) => {
        saveFile(e,'file');
      })
    })

    //保存到服务器
    $("#save").on("click",() => {
      if(getUrlParams('id') == false || getUrlParams('id') == undefined){
        //新增
        $.ajax({
          url: baseUrl + "/priOnline2/add/auth",
          headers: {'token': localStorage.getItem('token')},
          data: JSON.stringify({
            title: luckysheet.toJson().title,
            sheetData: zip(luckysheet.getAllSheets()),
            itemId: getUrlParams('item_id'),
            priId: getUrlParams('pri_id')
          }),
          method: 'POST',
          dataType: "json",
          contentType:'application/json;charset=UTF-8',
          success: function (res) {
            if (res.code == 200) {
              layer.msg('保存成功',{time:1000},() => {
                parent.location.reload()
              })
            }else{
              layer.msg(res.msg,{time:1000})
            }
          }
        })
      }else {
        //修改
        $.ajax({
          url: baseUrl + "/priOnline2/update/auth",
          headers: {'token': localStorage.getItem('token')},
          data: JSON.stringify({
            id: getUrlParams('id'),
            title: luckysheet.toJson().title,
            sheetData: zip(luckysheet.getAllSheets())
          }),
          method: 'POST',
          dataType: "json",
          contentType:'application/json;charset=UTF-8',
          success: function (res) {
            if (res.code == 200) {
              layer.msg('保存成功',{time:1000},() => {
                parent.location.reload()
              })
            }else{
              layer.msg(res.msg,{time:1000})
            }
          }
        })
      }
    })

    $("#download").on("click",() => {
      window.open(baseUrl + "/priOnline2/checkDataDownload/" +checkDataFile)
    })

  })

  $("#allprint").on("click",() => {
    printExcel()
  })

  $("#print").on("click",() => {
    let src = luckysheet.getScreenshot(); // 生成base64图片
    const style = '@page {margin:0 10mm};'
    printJS({
      printable: src,
      type: 'image',
      style: style
    }) // Print.js插件
  })

  // 获取表格中包含内容的row，column
  function getExcelRowColumn() {
    const sheetData = luckysheet.getSheetData();
    let objRowColumn = {
      row: [null, null], //行
      column: [null, null], //列
    };
    sheetData.forEach((item, index) => {
      //行数
      item.forEach((it, itemIndex) => {
        if (it !== null) {
          if (objRowColumn.row[0] == null) objRowColumn.row[0] = index; // row第一位
          objRowColumn.row[1] = index; //row第二位
          if (objRowColumn.column[0] == null)
            objRowColumn.column[0] = itemIndex; //column第一位
          objRowColumn.column[1] = itemIndex; //column第二位
        }
      });
    });
    return objRowColumn;
  }

  function printExcel() {
    let RowColumn = this.getExcelRowColumn() // 获取有值的行和列
    RowColumn.column[0] = 0 //因需要打印左边的边框，需重新设置
    luckysheet.setRangeShow(RowColumn) // 进行选区操作
    let src = luckysheet.getScreenshot(); // 生成base64图片
    const style = '@page {margin:0 10mm};'
    printJS({
      printable: src,
      type: 'image',
      style: style
    }) // Print.js插件
  }

  function getUrlParams(name) {
    var url = window.location.search;
    if (url.indexOf('?') == -1) { return false; }
    url = url.substr(1);
    url = url.split('&');
    var name = name || '';
    var nameres;
    for (var i = 0; i < url.length; i++) {
      var info = url[i].split('=');
      var obj = {};
      obj[info[0]] = decodeURI(info[1]);
      url[i] = obj;
    }
    if (name) {
      for (var i = 0; i < url.length; i++) {
        for (var key in url[i]) {
          if (key == name) {
            nameres = url[i][key];
          }
        }
      }
    } else {
      nameres = url;
    }
    return nameres;
  }

  // 压缩
  function zip(data) {
    if (!data) return data
    // 判断数据是否需要转为JSON
    const dataJson = typeof data !== 'string' && typeof data !== 'number' ? JSON.stringify(data) : data

    // 使用Base64.encode处理字符编码，兼容中文
    const str = Base64.encode(dataJson)
    let binaryString = pako.gzip(str);
    let arr = Array.from(binaryString);
    let s = "";
    arr.forEach((item, index) => {
      s += String.fromCharCode(item)
    })
    return btoa(s)
  }

  // 解压
  function unzip(b64Data) {
    let strData = atob(b64Data);
    let charData = strData.split('').map(function (x) {
      return x.charCodeAt(0);
    });
    let binData = new Uint8Array(charData);
    let data = pako.ungzip(binData);

    // ↓切片处理数据，防止内存溢出报错↓
    let str = '';
    const chunk = 8 * 1024
    let i;
    for (i = 0; i < data.length / chunk; i++) {
      str += String.fromCharCode.apply(null, data.slice(i * chunk, (i + 1) * chunk));
    }
    str += String.fromCharCode.apply(null, data.slice(i * chunk));
    // ↑切片处理数据，防止内存溢出报错↑

    const unzipStr = Base64.decode(str);
    let result = ''

    // 对象或数组进行JSON转换
    try {
      result = JSON.parse(unzipStr)
    } catch (error) {
      if (/Unexpected token o in JSON at position 0/.test(error)) {
        // 如果没有转换成功，代表值为基本数据，直接赋值
        result = unzipStr
      }
    }
    return result
  }
</script>
</body>
</html>

 src/main/webapp/views/priOnline2/priOnline_detail.html

New file
@@ -0,0 +1,340 @@
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <title>excel</title>
  <link rel="stylesheet" href="../../static/layui/css/layui.css" media="all">
  <link rel='stylesheet' href='../../static/plugins/css/pluginsCss.css' />
  <link rel='stylesheet' href='../../static/plugins/plugins.css' />
  <link rel='stylesheet' href='../../static/css/luckysheet.css' />
  <link rel='stylesheet' href='../../static/assets/iconfont/iconfont.css' />
  <script src="../../static/js/luckysheet_js/plugin.js"></script>
  <script src="../../static/js/luckysheet_js/luckysheet.umd.js"></script>
  <script src="../../static/js/luckysheet_js/luckyexcel.umd.js"></script>
  <script src="../../static/js/luckysheet_js/exceljs.min.js"></script>
  <script type="text/javascript" src="../../static/js/luckysheet_js/export.js" charset="utf-8"></script>
  <script type="text/javascript" src="../../static/js/luckysheet_js/pako.es5.js" charset="utf-8"></script>
  <script type="text/javascript" src="../../static/js/luckysheet_js/base64.min.js" charset="utf-8"></script>
  <script type="text/javascript" src="../../static/layui/layui.js" charset="utf-8"></script>
  <script type="text/javascript" src="../../static/js/common.js" charset="utf-8"></script>
  <script type="text/javascript" src="../../static/js/luckysheet_js/print.min.js" charset="utf-8"></script>
</head>
<body>
<div style="display: flex;position: absolute;top: 20px;left:30px;z-index: 9999;">
<!--  <div>上传Execel：<input type="file" id="Luckyexcel-demo-file" /></div>-->
<!--  <div><button type="button" id="export">导出Execel</button></div>-->
  <div><button type="button" class="layui-btn layui-btn-primary layui-btn-xs btn-edit" id="save">保存</button></div>
  <div><button type="button" class="layui-btn layui-btn-primary layui-btn-xs btn-edit" id="otherSave">另存为</button></div>
  <div><button type="button" class="layui-btn layui-btn-primary layui-btn-xs btn-edit" id="allprint">全部打印</button></div>
  <div><button type="button" class="layui-btn layui-btn-primary layui-btn-xs btn-edit" id="print">选区打印</button></div>
</div>
<div id="luckysheet" style="margin:0px;padding:0px;position:absolute;width:100%;height: 100vh;left: 0px;top: 0px;"></div>
<script>
  $(function () {
    var layer = layui.layer;

    //配置项
    var options = {
      container: 'luckysheet' ,//luckysheet为容器id
      title: '在线核价', //工作簿名称
      lang: 'zh', //设定表格语言 国际化设置，允许设置表格的语言，支持中文("zh")和英文("en")
      allowEdit: true, //是否允许前台编辑
      sheetFormulaBar: true, //是否显示公式栏
      forceCalculation: true,//强制计算公式
      myFolderUrl: '' //左上角<返回按钮的链接
    }

    if(getUrlParams('id') == false || getUrlParams('id') == undefined){
      //新增
      if(getUrlParams('template') == false || getUrlParams('template') == undefined){
        luckysheet.create(options)
        $("#luckysheet_info_detail_update").hide()
        $("#luckysheet_info_detail_save").hide()
        $("#luckysheet_info_detail_title").hide()
      }else {
        $.ajax({
          type:"get",
          url: baseUrl + "/static/js/priOnline2/data" + getUrlParams('template') + ".txt",
          success:function(sheetData) {
            options.data = unzip(sheetData)
            options.title = getUrlParams('name')
            luckysheet.create(options)
            $("#luckysheet_info_detail_update").hide()
            $("#luckysheet_info_detail_save").hide()
            $("#luckysheet_info_detail_title").hide()
          }
        });
      }
    }else{
      //修改
      $.ajax({
        type:"get",
        url: baseUrl + "/priOnline2/" + getUrlParams('id') + "/auth",
        dataType:"json",
        headers: {'token': localStorage.getItem('token')},
        success:function(res) {
          options.data = unzip(res.data.sheetData)
          options.title = res.data.title
          luckysheet.create(options)
          $("#luckysheet_info_detail_update").hide()
          $("#luckysheet_info_detail_save").hide()
          $("#luckysheet_info_detail_title").hide()
        }
      });

    }

    $("#Luckyexcel-demo-file").on("change",(evt) => {
      var files = evt.target.files;
      if(files==null || files.length==0){
        alert("No files wait for import");
        return;
      }

      let name = files[0].name;
      let suffixArr = name.split("."), suffix = suffixArr[suffixArr.length-1];
      if(suffix!="xlsx"){
        alert("Currently only supports the import of xlsx files");
        return;
      }
      LuckyExcel.transformExcelToLucky(files[0], function(exportJson, luckysheetfile){

        if(exportJson.sheets==null || exportJson.sheets.length==0){
          alert("Failed to read the content of the excel file, currently does not support xls files!");
          return;
        }
        window.luckysheet.destroy();

        window.luckysheet.create({
          container: 'luckysheet', //luckysheet is the container id
          data:exportJson.sheets,
          title:exportJson.info.name,
          userInfo:exportJson.info.name.creator,
          lang: 'zh', //设定表格语言 国际化设置，允许设置表格的语言，支持中文("zh")和英文("en")
          allowEdit: true, //是否允许前台编辑
          sheetFormulaBar: true, //是否显示公式栏
          forceCalculation: true,//强制计算公式
        });
      });
    })

    $("#export").on("click",() => {
      console.log('export')
      exportExcel(luckysheet.getluckysheetfile()).then((e) => {
        saveFile(e,'file');
      })
    })

    //保存到服务器
    $("#save").on("click",() => {
      if(getUrlParams('id') == false || getUrlParams('id') == undefined){
        //新增
        $.ajax({
          url: baseUrl + "/priOnline2/add/auth",
          headers: {'token': localStorage.getItem('token')},
          data: JSON.stringify({
            title: luckysheet.toJson().title,
            sheetData: zip(luckysheet.getAllSheets()),
            itemId: getUrlParams('item_id'),
            priId: getUrlParams('pri_id')
          }),
          method: 'POST',
          dataType: "json",
          contentType:'application/json;charset=UTF-8',
          success: function (res) {
            if (res.code == 200) {
              layer.msg('保存成功',{time:1000},() => {
                parent.location.reload()
              })
            }else{
              layer.msg(res.msg,{time:1000})
            }
          }
        })
      }else {
        //修改
        $.ajax({
          url: baseUrl + "/priOnline2/update/auth",
          headers: {'token': localStorage.getItem('token')},
          data: JSON.stringify({
            id: getUrlParams('id'),
            title: luckysheet.toJson().title,
            sheetData: zip(luckysheet.getAllSheets())
          }),
          method: 'POST',
          dataType: "json",
          contentType:'application/json;charset=UTF-8',
          success: function (res) {
            if (res.code == 200) {
              layer.msg('保存成功',{time:1000},() => {
                parent.location.reload()
              })
            }else{
              layer.msg(res.msg,{time:1000})
            }
          }
        })
      }
    })

    $("#otherSave").on("click",() => {
      if(getUrlParams('id') == false || getUrlParams('id') == undefined){
        //新建文件
        $("#save").trigger("click")
      }else {
        //另存
        $.ajax({
          url: baseUrl + "/priOnline2/addOther/auth",
          headers: {'token': localStorage.getItem('token')},
          data: JSON.stringify({
            id: getUrlParams('id'),
            title: luckysheet.toJson().title,
            sheetData: zip(luckysheet.getAllSheets())
          }),
          method: 'POST',
          dataType: "json",
          contentType:'application/json;charset=UTF-8',
          success: function (res) {
            if (res.code == 200) {
              layer.msg('另存成功',{time:1000},() => {
                parent.location.reload()
              })
            }else{
              layer.msg('保存失败',{time:1000})
            }
          }
        })
      }
    })

  })

  $("#allprint").on("click",() => {
    printExcel()
  })

  $("#print").on("click",() => {
    let src = luckysheet.getScreenshot(); // 生成base64图片
    const style = '@page {margin:0 10mm};'
    printJS({
      printable: src,
      type: 'image',
      style: style
    }) // Print.js插件
  })

  // 获取表格中包含内容的row，column
  function getExcelRowColumn() {
    const sheetData = luckysheet.getSheetData();
    let objRowColumn = {
      row: [null, null], //行
      column: [null, null], //列
    };
    sheetData.forEach((item, index) => {
      //行数
      item.forEach((it, itemIndex) => {
        if (it !== null) {
          if (objRowColumn.row[0] == null) objRowColumn.row[0] = index; // row第一位
          objRowColumn.row[1] = index; //row第二位
          if (objRowColumn.column[0] == null)
            objRowColumn.column[0] = itemIndex; //column第一位
          objRowColumn.column[1] = itemIndex; //column第二位
        }
      });
    });
    return objRowColumn;
  }

  function printExcel() {
    let RowColumn = this.getExcelRowColumn() // 获取有值的行和列
    RowColumn.column[0] = 0 //因需要打印左边的边框，需重新设置
    luckysheet.setRangeShow(RowColumn) // 进行选区操作
    let src = luckysheet.getScreenshot(); // 生成base64图片
    const style = '@page {margin:0 10mm};'
    printJS({
      printable: src,
      type: 'image',
      style: style
    }) // Print.js插件
  }

  function getUrlParams(name) {
    var url = window.location.search;
    if (url.indexOf('?') == -1) { return false; }
    url = url.substr(1);
    url = url.split('&');
    var name = name || '';
    var nameres;
    for (var i = 0; i < url.length; i++) {
      var info = url[i].split('=');
      var obj = {};
      obj[info[0]] = decodeURI(info[1]);
      url[i] = obj;
    }
    if (name) {
      for (var i = 0; i < url.length; i++) {
        for (var key in url[i]) {
          if (key == name) {
            nameres = url[i][key];
          }
        }
      }
    } else {
      nameres = url;
    }
    return nameres;
  }

  // 压缩
  function zip(data) {
    if (!data) return data
    // 判断数据是否需要转为JSON
    const dataJson = typeof data !== 'string' && typeof data !== 'number' ? JSON.stringify(data) : data

    // 使用Base64.encode处理字符编码，兼容中文
    const str = Base64.encode(dataJson)
    let binaryString = pako.gzip(str);
    let arr = Array.from(binaryString);
    let s = "";
    arr.forEach((item, index) => {
      s += String.fromCharCode(item)
    })
    return btoa(s)
  }

  // 解压
  function unzip(b64Data) {
    let strData = atob(b64Data);
    let charData = strData.split('').map(function (x) {
      return x.charCodeAt(0);
    });
    let binData = new Uint8Array(charData);
    let data = pako.ungzip(binData);

    // ↓切片处理数据，防止内存溢出报错↓
    let str = '';
    const chunk = 8 * 1024
    let i;
    for (i = 0; i < data.length / chunk; i++) {
      str += String.fromCharCode.apply(null, data.slice(i * chunk, (i + 1) * chunk));
    }
    str += String.fromCharCode.apply(null, data.slice(i * chunk));
    // ↑切片处理数据，防止内存溢出报错↑

    const unzipStr = Base64.decode(str);
    let result = ''

    // 对象或数组进行JSON转换
    try {
      result = JSON.parse(unzipStr)
    } catch (error) {
      if (/Unexpected token o in JSON at position 0/.test(error)) {
        // 如果没有转换成功，代表值为基本数据，直接赋值
        result = unzipStr
      }
    }
    return result
  }
</script>
</body>
</html>