From 480431571f806f9ef66f77ec42034549cd573a31 Mon Sep 17 00:00:00 2001
From: Junjie <fallin.jie@qq.com>
Date: 星期四, 24 八月 2023 08:14:54 +0800
Subject: [PATCH] #核价管理
---
src/main/java/com/zy/crm/manager/entity/PriOnline2.java | 196 +++++
src/main/webapp/static/js/priOnline2/data1.txt | 1
src/main/java/com/zy/crm/manager/controller/PriOnline2Controller.java | 331 ++++++++++
src/main/java/com/zy/crm/manager/service/impl/PriOnline2ServiceImpl.java | 19
src/main/webapp/views/priOnline2/priOnline.html | 177 +++++
src/main/java/com/zy/crm/manager/mapper/PriOnline2Mapper.java | 19
src/main/resources/mapper/PriOnline2Mapper.xml | 61 +
src/main/webapp/static/js/priOnline2/priOnline.js | 544 ++++++++++++++++
src/main/webapp/views/priOnline2/priOnline_detail.html | 340 ++++++++++
src/main/webapp/views/priOnline2/css/loading.gif | 0
src/main/webapp/views/priOnline2/priOnline_check.html | 271 ++++++++
src/main/java/com/zy/crm/manager/service/PriOnline2Service.java | 13
12 files changed, 1,972 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/crm/manager/controller/PriOnline2Controller.java b/src/main/java/com/zy/crm/manager/controller/PriOnline2Controller.java
new file mode 100644
index 0000000..eecca80
--- /dev/null
+++ b/src/main/java/com/zy/crm/manager/controller/PriOnline2Controller.java
@@ -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);
+ }
+
+}
diff --git a/src/main/java/com/zy/crm/manager/entity/PriOnline2.java b/src/main/java/com/zy/crm/manager/entity/PriOnline2.java
new file mode 100644
index 0000000..a019030
--- /dev/null
+++ b/src/main/java/com/zy/crm/manager/entity/PriOnline2.java
@@ -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 "宸蹭笂浼�";
+ }
+
+
+}
diff --git a/src/main/java/com/zy/crm/manager/mapper/PriOnline2Mapper.java b/src/main/java/com/zy/crm/manager/mapper/PriOnline2Mapper.java
new file mode 100644
index 0000000..13c70af
--- /dev/null
+++ b/src/main/java/com/zy/crm/manager/mapper/PriOnline2Mapper.java
@@ -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);
+
+}
diff --git a/src/main/java/com/zy/crm/manager/service/PriOnline2Service.java b/src/main/java/com/zy/crm/manager/service/PriOnline2Service.java
new file mode 100644
index 0000000..86ba431
--- /dev/null
+++ b/src/main/java/com/zy/crm/manager/service/PriOnline2Service.java
@@ -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);
+
+}
diff --git a/src/main/java/com/zy/crm/manager/service/impl/PriOnline2ServiceImpl.java b/src/main/java/com/zy/crm/manager/service/impl/PriOnline2ServiceImpl.java
new file mode 100644
index 0000000..c1bf5d8
--- /dev/null
+++ b/src/main/java/com/zy/crm/manager/service/impl/PriOnline2ServiceImpl.java
@@ -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));
+ }
+}
diff --git a/src/main/resources/mapper/PriOnline2Mapper.xml b/src/main/resources/mapper/PriOnline2Mapper.xml
new file mode 100644
index 0000000..fc609f0
--- /dev/null
+++ b/src/main/resources/mapper/PriOnline2Mapper.xml
@@ -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>
+
+ <!-- 鏌ヨ缁撴灉涓嶅寘鍚玡xcel鏁版嵁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>
diff --git a/src/main/webapp/static/js/priOnline2/data1.txt b/src/main/webapp/static/js/priOnline2/data1.txt
new file mode 100644
index 0000000..cdf16eb
--- /dev/null
+++ b/src/main/webapp/static/js/priOnline2/data1.txt
@@ -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=
\ No newline at end of file
diff --git a/src/main/webapp/static/js/priOnline2/priOnline.js b/src/main/webapp/static/js/priOnline2/priOnline.js
new file mode 100644
index 0000000..4a16343
--- /dev/null
+++ b/src/main/webapp/static/js/priOnline2/priOnline.js
@@ -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"></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"></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
+ // 鍒ゆ柇鏁版嵁鏄惁闇�瑕佽浆涓篔SON
+ 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)
+}
diff --git a/src/main/webapp/views/priOnline2/css/loading.gif b/src/main/webapp/views/priOnline2/css/loading.gif
new file mode 100644
index 0000000..7980d81
--- /dev/null
+++ b/src/main/webapp/views/priOnline2/css/loading.gif
Binary files differ
diff --git a/src/main/webapp/views/priOnline2/priOnline.html b/src/main/webapp/views/priOnline2/priOnline.html
new file mode 100644
index 0000000..0cdbf0a
--- /dev/null
+++ b/src/main/webapp/views/priOnline2/priOnline.html
@@ -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"></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"> 
+ <button class="layui-btn icon-btn layui-btn-sm" lay-filter="search" lay-submit>
+ <i class="layui-icon"></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>
+
+
diff --git a/src/main/webapp/views/priOnline2/priOnline_check.html b/src/main/webapp/views/priOnline2/priOnline_check.html
new file mode 100644
index 0000000..0eb0b3b
--- /dev/null
+++ b/src/main/webapp/views/priOnline2/priOnline_check.html
@@ -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涓哄鍣╥d
+ 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锛宑olumn
+ 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
+ // 鍒ゆ柇鏁版嵁鏄惁闇�瑕佽浆涓篔SON
+ 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 = ''
+
+ // 瀵硅薄鎴栨暟缁勮繘琛孞SON杞崲
+ 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>
\ No newline at end of file
diff --git a/src/main/webapp/views/priOnline2/priOnline_detail.html b/src/main/webapp/views/priOnline2/priOnline_detail.html
new file mode 100644
index 0000000..48b2494
--- /dev/null
+++ b/src/main/webapp/views/priOnline2/priOnline_detail.html
@@ -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涓哄鍣╥d
+ 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锛宑olumn
+ 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
+ // 鍒ゆ柇鏁版嵁鏄惁闇�瑕佽浆涓篔SON
+ 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 = ''
+
+ // 瀵硅薄鎴栨暟缁勮繘琛孞SON杞崲
+ 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>
\ No newline at end of file
--
Gitblit v1.9.1