YangHuOperation/web/maintain/bills_lib/scripts/db_controller.js

/**
 * Created by vian on 2017/4/12.
 */
var dbController = {
  controller: null,
  currentEditData: null,
  insert: function (controller, btn) {
    tools.btnClose(btn);
    btn.attr("doing", "true");
    if (controller.tree.items.length === 0) {
      controller.tree.maxNodeID(0);
      let newNodeId = uuid.v1();
      let sectionInfo = { first: null, second: null, third: null };
      billsAjax.createBills(
        userAccount,
        billsLibId,
        newNodeId,
        -1,
        -1,
        null,
        sectionInfo,
        function () {
          controller.insertByID(newNodeId);
          controller.tree.selected.jobs = new Array();
          controller.tree.selected.items = new Array();
          controller.sheet.setTag(
            controller.tree.selected.serialNo(),
            0,
            newNodeId
          );
          sheetBillsDatas = tools.getsheetDatas(
            controller.sheet,
            "bills",
            controller
          );
          tools.btnAction(btn);
          btn.attr("doing", "false");
          controller.sheet.getParent().focus(true);
        }
      );
    } else {
      let node = controller.tree.selected;
      if (node) {
        var updateId = node.getID(),
          createpid = node.getParentID(),
          createnid = node.getNextSiblingID();
        let newNodeId = uuid.v1();
        let updatePreData = { ID: updateId, NextSiblingID: newNodeId };
        let sectionInfo = tools.getSectionInfo(node);
        billsAjax.createBills(
          userAccount,
          billsLibId,
          newNodeId,
          createpid,
          createnid,
          updatePreData,
          sectionInfo,
          function () {
            controller.insertByID(newNodeId);
            controller.tree.selected.jobs = new Array();
            controller.tree.selected.items = new Array();
            controller.sheet.setTag(
              controller.tree.selected.serialNo(),
              0,
              newNodeId
            );
            sheetBillsDatas = tools.getsheetDatas(
              controller.sheet,
              "bills",
              controller
            );
            tools.btnAction(btn);
            btn.attr("doing", "false");
            controller.sheet.getParent().focus(true);
          }
        );
      } else {
        let updateNode =
          controller.tree.roots[controller.tree.roots.length - 1];
        let updateId = updateNode.getID();
        //let newNodeId = controllers.tree.newNodeID();
        let newNodeId = uuid.v1();
        let updatePreData = { ID: updateId, NextSiblingID: newNodeId };
        let sectionInfo = tools.getSectionInfo(node);
        billsAjax.createBills(
          userAccount,
          billsLibId,
          newNodeId,
          -1,
          -1,
          updatePreData,
          sectionInfo,
          function () {
            controller.insertByID(newNodeId);
            controller.tree.selected.jobs = new Array();
            controller.tree.selected.items = new Array();
            controller.sheet.setTag(
              controller.tree.selected.serialNo(),
              0,
              newNodeId
            );
            sheetBillsDatas = tools.getsheetDatas(
              controller.sheet,
              "bills",
              controller
            );
            tools.btnAction(btn);
            btn.attr("doing", "false");
            controller.sheet.getParent().focus(true);
          }
        );
      }
    }
  },

  upLevel: function (controller, btn) {
    tools.btnClose(btn);
    btn.attr("doing", "true");
    var node = controller.tree.selected;
    var nextSiblingIds = [];
    var updateData = [];
    let selNodes = tools.getSameDepthNodes(controller);
    let nextSiblings = [];
    let toUpSectionNodes = [];
    let getNextSibling = function (node) {
      if (node.nextSibling) {
        nextSiblingIds.push(node.getNextSiblingID());
        nextSiblings.push(node.nextSibling);
        getNextSibling(node.nextSibling);
      }
    };
    if (selNodes.length > 0) {
      let firstParent = selNodes[0].parent;
      //选中的第一个节点有父节点，则可升级
      if (firstParent) {
        //更新父节点
        updateData.push({
          ID: firstParent.getID(),
          NextSiblingID: selNodes[0].getID(),
          type: "parentNode",
        });
        //更新前节点
        if (selNodes[0].preSibling) {
          updateData.push({
            ID: selNodes[0].preSibling.getID(),
            NextSiblingID: -1,
            type: "preSiblingNode",
          });
        }
        //更新选中节点的后兄弟节点
        let lastSelNode = selNodes[selNodes.length - 1];
        if (lastSelNode.nextSibling) {
          let nextSectionInfo = tools.getSectionInfo(firstParent);
          let nullNextSectionInfo = tools.sectionInfoNull(nextSectionInfo);
          if (nullNextSectionInfo) {
            nextSectionInfo[nullNextSectionInfo] = lastSelNode.getID();
          }
          getNextSibling(lastSelNode);
          updateData.push({
            ID: nextSiblingIds,
            ParentID: lastSelNode.getID(),
            //sectionInfo: nextSectionInfo,
            type: "nextSiblingNode",
          });
          //nextSibling children
        }
        //更新选中节点
        for (let i = 0; i < selNodes.length; i++) {
          let selNode = selNodes[i];
          let oprSectionInfo = tools.getSectionInfo(firstParent);
          updateData.push({
            ID: selNode.getID(),
            ParentID: firstParent.getParentID(),
            NextSiblingID:
              i === selNodes.length - 1
                ? firstParent.getNextSiblingID()
                : selNode.getNextSiblingID(),
            sectionInfo: oprSectionInfo,
            type: "oprNode",
          });
          //update node children and grandchildren sectionInfo
        }
        //get updateSectionInfo nodes
        toUpSectionNodes = toUpSectionNodes.concat(selNodes); //选中的节点
        //选中节点的所有子节点
        toUpSectionNodes = toUpSectionNodes.concat(
          tools.getChildrenNodes(selNodes)
        );
        //后兄弟节点
        toUpSectionNodes = toUpSectionNodes.concat(nextSiblings);
        //所有后兄弟节点的所有子节点
        toUpSectionNodes = toUpSectionNodes.concat(
          tools.getChildrenNodes(nextSiblings)
        );

        billsAjax.upLevel(userAccount, billsLibId, updateData, function () {
          //tools.btnAction(btn);
          //btn.attr('doing', 'false');
          for (let upLevelNode of selNodes) {
            controller.setTreeSelected(upLevelNode);
            controller.upLevel();
          }
          sheetBillsDatas = tools.getsheetDatas(
            controller.sheet,
            "bills",
            controller
          );
          controller.sheet.getParent().focus(true);
          //updateSectionInfo
          if (toUpSectionNodes.length > 0) {
            billsAjax.updateSectionInfo(
              tools.getUpdateSectionData(toUpSectionNodes),
              function () {
                tools.btnAction(btn);
                btn.attr("doing", "false");
              }
            );
          }
        });
      }
    }
  },

  downLevel: function (controller, btn) {
    tools.btnClose(btn);
    btn.attr("doing", "true");
    var updateData = [];
    let selNodes = tools.getSameDepthNodes(controller);
    let toUpSectionNodes = [];
    if (selNodes.length > 0) {
      //选中的第一个节点有前节点，则可降级
      let firstPreSibling = selNodes[0].preSibling;
      if (firstPreSibling) {
        //更新前节点
        updateData.push({
          ID: firstPreSibling.getID(),
          NextSiblingID: selNodes[selNodes.length - 1].getNextSiblingID(),
          type: "preSiblingNode",
        });
        //更新前节点最末子节点
        if (firstPreSibling.children.length > 0) {
          updateData.push({
            ID: firstPreSibling.children[
              firstPreSibling.children.length - 1
            ].getID(),
            NextSiblingID: selNodes[0].getID(),
            type: "preChildren",
          });
        }
        for (let i = 0; i < selNodes.length; i++) {
          let selNode = selNodes[i];
          //更新选中的节点
          updateData.push({
            ID: selNode.getID(),
            ParentID: firstPreSibling.getID(),
            NextSiblingID:
              i === selNodes.length - 1 ? -1 : selNode.getNextSiblingID(),
            type: "oprNode",
          });
        }

        //get updateSectionInfo nodes
        //选中的节点
        toUpSectionNodes = toUpSectionNodes.concat(selNodes);
        //选中节点的所有子节点
        toUpSectionNodes = toUpSectionNodes.concat(
          tools.getChildrenNodes(selNodes)
        );

        billsAjax.downLevel(userAccount, billsLibId, updateData, function () {
          //tools.btnAction(btn);
          //btn.attr('doing', 'false');
          for (let downNode of selNodes) {
            controller.setTreeSelected(downNode);
            controller.downLevel();
          }
          sheetBillsDatas = tools.getsheetDatas(
            controller.sheet,
            "bills",
            controller
          );
          controller.sheet.getParent().focus(true);
          //update sectionInfo
          if (toUpSectionNodes.length > 0) {
            billsAjax.updateSectionInfo(
              tools.getUpdateSectionData(toUpSectionNodes),
              function () {
                tools.btnAction(btn);
                btn.attr("doing", "false");
              }
            );
          }
        });
      }
    }
  },

  delete: function (controller, btn, totalJobs, totalItems) {
    tools.btnClose(btn);
    btn.attr("doing", "true");
    var node = controller.tree.selected;

    if (node) {
      var deleteIds = [];
      var getDeleteIds = function (node) {
        if (node) {
          deleteIds.push(node.getID());
          var length = node.children.length;
          if (length > 0) {
            for (var i = 0; i < length; i++) {
              getDeleteIds(node.children[i]);
            }
          }
        }
      };
      var selNodes = tools.getSameDepthNodes(controller);
      for (var selNode of selNodes) {
        getDeleteIds(selNode);
      }

      let updateNode = node.preSibling
        ? {
            ID: node.preSibling.getID(),
            NextSiblingID: node.getNextSiblingID(),
          }
        : null;
      billsAjax.deleteBills(
        userAccount,
        billsLibId,
        deleteIds,
        updateNode,
        function () {
          tools.btnAction(btn);
          btn.attr("doing", "false");
          controller.m_delete(selNodes);
          //to solve refresh after deleted
          let jobsSheet = jobsSpread.getActiveSheet();
          let designsSheet = designsSpread.getActiveSheet();
          let itemsSheet = itemsSpread.getActiveSheet();
          let nowNode = controller.tree.selected;
          if (nowNode) {
            let jobs = controller.tree.selected.jobs;
            const recharge = controller.tree.selected.data.recharge || "";
            codeEditor.setValue(recharge);
            //$('#exampleTextarea').val(controller.tree.selected.data.recharge);
            setSheet.setMaxRowCount(jobsSheet, jobs);
            tools.orderReshowData(jobsSheet, jobs, jobsSetting, "job", false);
            if (jobs.length > 0) {
              orgJobData = jobsSheet.getValue(0, 0);
            }
            let designs = controller.tree.selected.designs;
            setSheet.setMaxRowCount(designsSheet, designs);
            tools.orderReshowData(
              designsSheet,
              designs,
              designsSetting,
              "design",
              false
            );
            if (designs.length > 0) {
              orgDesignData = designsSheet.getValue(0, 0);
            }

            let items = controller.tree.selected.items;
            setSheet.setMaxRowCount(itemsSheet, items);
            tools.orderReshowData(
              itemsSheet,
              items,
              itemsSetting,
              "item",
              false
            );
            if (items.length > 0) {
              orgItemData = itemsSheet.getValue(0, 0);
            }
          } else {
            tools.clearData(jobsSheet);
            tools.clearData(designsSheet);
            tools.clearData(itemsSheet);
            codeEditor.setValue("");
            //$('#exampleTextarea').val("");
          }
          sheetDatas = tools.getsheetDatas(jobsSheet, "jobs");
          sheetDesignDatas = tools.getsheetDatas(designsSheet, "designs");
          sheetItemsDatas = tools.getsheetDatas(itemsSheet, "items");
          sheetBillsDatas = tools.getsheetDatas(
            controller.sheet,
            "bills",
            controller
          );
          controller.sheet.getParent().focus(true);
          //to solve refresh after deleted
        }
      );
    }
  },

  upMove: function (controller, btn) {
    tools.btnClose(btn);
    btn.attr("doing", "true");
    var node = controller.tree.selected;
    var updateData = [];
    if (node) {
      if (node.preSibling) {
        let updateA = {
          ID: node.preSibling.getID(),
          NextSiblingID: node.getNextSiblingID(),
        };
        let updateB = {
          ID: node.getID(),
          NextSiblingID: node.preSibling.getID(),
        };
        updateData.push(updateA);
        updateData.push(updateB);
        if (node.preSibling.preSibling) {
          let updateC = {
            ID: node.preSibling.preSibling.getID(),
            NextSiblingID: node.getID(),
          };
          updateData.push(updateC);
        }
        billsAjax.upMove(userAccount, billsLibId, updateData, function () {
          tools.btnAction(btn);
          btn.attr("doing", "false");
          controller.upMove();
          //udpate tag
          controller.sheet.setTag(
            controller.tree.selected.serialNo(),
            0,
            controller.tree.selected.getID()
          );
          controller.sheet.setTag(
            controller.tree.selected.nextSibling.serialNo(),
            0,
            controller.tree.selected.nextSibling.getID()
          );
          sheetBillsDatas = tools.getsheetDatas(
            controller.sheet,
            "bills",
            controller
          );

          controller.sheet.getParent().focus(true);
        });
      }
    }
  },

  downMove: function (controller, btn) {
    tools.btnClose(btn);
    btn.attr("doing", "true");
    var node = controller.tree.selected;
    var updateData = [];
    if (node) {
      if (node.nextSibling) {
        var updateA = {
          ID: node.getNextSiblingID(),
          NextSiblingID: node.getID(),
          type: "nextSiblingNode",
        };
        var updateB = {
          ID: node.getID(),
          NextSiblingID: node.nextSibling.getNextSiblingID(),
          type: "oprNode",
        };
        updateData.push(updateA);
        updateData.push(updateB);
        if (node.preSibling) {
          var updateC = {
            ID: node.preSibling.getID(),
            NextSiblingID: node.getNextSiblingID(),
            type: "preSiblingNode",
          };
          updateData.push(updateC);
        }
        billsAjax.downMove(userAccount, billsLibId, updateData);
        tools.btnAction(btn);
        btn.attr("doing", "false");
        controller.downMove();
        //udpate tag
        controller.sheet.setTag(
          controller.tree.selected.serialNo(),
          0,
          controller.tree.selected.getID()
        );
        controller.sheet.setTag(
          controller.tree.selected.preSibling.serialNo(),
          0,
          controller.tree.selected.preSibling.getID()
        );
        sheetBillsDatas = tools.getsheetDatas(
          controller.sheet,
          "bills",
          controller
        );
        controller.sheet.getParent().focus(true);
      }
    }
  },
  onEditStart: function (sender, args) {
    dbController.currentEditData = args.sheet.getValue(args.row, args.col);
  },
  onEditEnded: function (sender, args) {
    let controller = dbController.controller;
    var node = controller.tree.items[args.row],
      updateId,
      field;
    if (node) {
      updateId = node.getID();
      field = billsLibSetting.cols[args.col].data.field;
      /* if (field === 'engineering') {
                if (isNaN(args.editingText) || args.editingText % 1 !== 0) {
                    args.sheet.setValue(args.row, args.col, dbController.currentEditData ? dbController.currentEditData : '');
                    alert('工程专业只能输入整数！');
                    return;
                }
            } else  */ if (field === "unitPrice") {
        if (isNaN(args.editingText)) {
          args.sheet.setValue(
            args.row,
            args.col,
            dbController.currentEditData ? dbController.currentEditData : ""
          );
          alert("单价只能输入数值！");
          return;
        }
      }
      node.data[field] = args.editingText;
      sheetBillsDatas.datasIdx["rowIdx" + args.row][field] = args.editingText;
      billsAjax.updateBills(
        userAccount,
        billsLibId,
        updateId,
        field,
        args.editingText
      );
    } else {
      args.sheet
        .getCell(args.row, args.col, GC.Spread.Sheets.SheetArea.viewport)
        .value("");
    }
  },
  onEnterCell: function (sender, args) {
    args.sheet.repaint();
  },

  onButtonClicked: function (sender, info) {
    if (info.sheet.isEditing()) {
      info.sheet.endEdit(true);
    }
    const field = dbController.controller.setting.cols[info.col].data.field;
    var node = dbController.controller.tree.items[info.row];
    if (node && field === "isBillBudget") {
      const isChecked = Boolean(info.sheet.getValue(info.row, info.col));
      const allNodes = [node, ...node.getPosterity()];
      const postData = [];
      allNodes.forEach((item) => {
        postData.push({ ID: item.data.ID, [field]: isChecked });
      });
      billsAjax.pasteBills(userAccount, billsLibId, postData, () => {
        allNodes.forEach((item) => {
          const row = node.tree.items.indexOf(item);
          if (row >= 0) {
            sheetBillsDatas.datasIdx["rowIdx" + row][field] = isChecked;
            item.data[field] = isChecked;
          }
        });
        dbController.controller.refreshTreeNode(allNodes, false);
      });

      /* node.data[field] = isChecked;
            sheetBillsDatas.datasIdx['rowIdx' + info.row][field] = isChecked;
            billsAjax.updateBills(userAccount, billsLibId, node.getID(), field, isChecked); */
    }
  },
  editData: function (controller, billsSpread) {
    billsSpread.bind(
      GC.Spread.Sheets.Events.ButtonClicked,
      this.onButtonClicked
    );
    controller.sheet.bind(
      GC.Spread.Sheets.Events.EditStarting,
      this.onEditStart
    );
    controller.sheet.bind(GC.Spread.Sheets.Events.EditEnded, this.onEditEnded);
    controller.sheet.bind(GC.Spread.Sheets.Events.EnterCell, this.onEnterCell);
  },
};

var createObj = {
  newJob: function (data) {
    var Job = function (data) {
      this.data = data;
      //count = 0则没有被引用了
      this.count = 0;
    };
    return new Job(data);
  },
  newJobs: function () {
    var TotalJobs = function () {
      this.jobs = {};
      this.jobsArr = [];
      this.prefix = "_id";
    };

    TotalJobs.prototype.findJob = function (id) {
      return this.jobs[this.prefix + id] ? this.jobs[this.prefix + id] : null;
    };

    TotalJobs.prototype.loadJobs = function (nodes, datas) {
      var me = this;
      datas.forEach(function (jobData) {
        var job = createObj.newJob(jobData);
        me.jobs[me.prefix + jobData.id] = job;
        me.jobsArr.push(job);
      });
      if (nodes) {
        nodes.forEach(function (node) {
          node.jobs = new Array();
          let spliceArr = [];
          node.data.jobs.forEach(function (obj) {
            if (me.jobs[me.prefix + obj.id]) {
              node.jobs.push({
                job: me.jobs[me.prefix + obj.id],
                serialNo: obj.serialNo,
              });
              me.jobs[me.prefix + obj.id].count++;
            } else {
              spliceArr.push(obj);
            }
          });
          for (let sItem of spliceArr) {
            node.data.jobs.splice(node.data.jobs.indexOf(sItem), 1);
          }
        });
      }
    };

    TotalJobs.prototype.getUpdateIds = function (nodes, repeatId) {
      var ids = [];
      nodes.forEach(function (node) {
        node.jobs.forEach(function (job) {
          if (job.data.id === repeatId) {
            ids.push(node.getID());
          }
        });
      });
      return ids;
    };

    return new TotalJobs();
  },

  newDesign: function (data) {
    var Design = function (data) {
      this.data = data;
      //count = 0则没有被引用了
      this.count = 0;
    };
    return new Design(data);
  },
  newDesigns: function () {
    var TotalDesigns = function () {
      this.designs = {};
      this.designsArr = [];
      this.prefix = "_id";
    };

    TotalDesigns.prototype.findDesign = function (id) {
      return this.designs[this.prefix + id]
        ? this.designs[this.prefix + id]
        : null;
    };

    TotalDesigns.prototype.loadDesigns = function (nodes, datas) {
      var me = this;
      datas.forEach(function (data) {
        var design = createObj.newDesign(data);
        me.designs[me.prefix + data.id] = design;
        me.designsArr.push(design);
      });
      if (nodes) {
        nodes.forEach(function (node) {
          node.designs = new Array();
          if (node.data.designs) {
            let spliceArr = [];
            node.data.designs.forEach(function (obj) {
              if (me.designs[me.prefix + obj.id]) {
                node.designs.push({
                  design: me.designs[me.prefix + obj.id],
                  serialNo: obj.serialNo,
                });
                me.designs[me.prefix + obj.id].count++;
              } else {
                spliceArr.push(obj);
              }
            });
            for (let sItem of spliceArr) {
              node.data.designs.splice(node.data.designs.indexOf(sItem), 1);
            }
          }
        });
      }
    };

    TotalDesigns.prototype.getUpdateIds = function (nodes, repeatId) {
      var ids = [];
      nodes.forEach(function (node) {
        node.designs.forEach(function (design) {
          if (design.data.id === repeatId) {
            ids.push(node.getID());
          }
        });
      });
      return ids;
    };

    return new TotalDesigns();
  },

  newItem: function (data) {
    var Item = function (data) {
      this.data = data;
      this.count = 0;
    };
    return new Item(data);
  },

  newItems: function () {
    var TotalItems = function () {
      this.items = {};
      this.itemsArr = [];
      this.prefix = "_id";
    };

    TotalItems.prototype.findItem = function (id) {
      return this.items[this.prefix + id] ? this.items[this.prefix + id] : null;
    };

    TotalItems.prototype.loadItems = function (nodes, datas) {
      var me = this;
      datas.forEach(function (itemData) {
        var item = createObj.newItem(itemData);
        me.items[me.prefix + itemData.id] = item;
        me.itemsArr.push(item);
      });
      if (nodes) {
        nodes.forEach(function (node) {
          node.items = new Array();
          let spliceArr = [];
          node.data.items.forEach(function (obj) {
            if (me.items[me.prefix + obj.id]) {
              node.items.push({
                item: me.items[me.prefix + obj.id],
                serialNo: obj.serialNo,
              });
              me.items[me.prefix + obj.id].count++;
            } else {
              spliceArr.push(obj);
            }
          });
          for (let sItem of spliceArr) {
            node.data.items.splice(node.data.items.indexOf(sItem), 1);
          }
        });
      }
    };

    TotalItems.prototype.getUpdateIds = function (nodes, repeatId) {
      var ids = [];
      nodes.forEach(function (node) {
        node.items.forEach(function (item) {
          if (item.data.id === repeatId) {
            ids.push(node.getID());
          }
        });
      });
      return ids;
    };
    return new TotalItems();
  },
};

var tools = {
  alertOpr: function (args, sheet, txt, arr, field) {
    $("#alertTxt").text(txt);
    $("#alertBtn").click();
    sheet.options.isProtected = true;
    let dataCode = args.col === 0 ? "code" : "content";
    let orgCode =
      args.row < arr.length ? arr[args.row][field].data[dataCode] : "";
    $("#alertCof").unbind("click");
    $("#alertCls").unbind("click");
    $("#alertCls").click(function () {
      sheet.options.isProtected = false;
      sheet.getCell(args.row, args.col).value(orgCode);
    });
    $("#alertCof").click(function () {
      sheet.options.isProtected = false;
      sheet.getCell(args.row, args.col).value(orgCode);
    });
  },
  alertTotalOpr: function (args, txt, arr) {
    $("#alertTxt").text(txt);
    $("#alertBtn").click();
    args.sheet.options.isProtected = true;
    let dataCode = args.col === 0 ? "code" : "content";
    let orgCode = args.row < arr.length ? arr[args.row].data[dataCode] : "";
    $("#alertCof").unbind("click");
    $("#alertCls").unbind("click");
    $("#alertCls").click(function () {
      args.sheet.options.isProtected = false;
      args.sheet.getCell(args.row, args.col).value(orgCode);
    });
    $("#alertCof").click(function () {
      args.sheet.options.isProtected = false;
      args.sheet.getCell(args.row, args.col).value(orgCode);
    });
  },
  //ref sheet up&down Move
  canUpMove: function (selected, arr) {
    return selected && arr.indexOf(selected) > 0 && arr.indexOf(selected) !== -1
      ? true
      : false;
  },
  canDownMove: function (selected, arr) {
    return selected &&
      arr.indexOf(selected) < arr.length - 1 &&
      arr.indexOf(selected) !== -1
      ? true
      : false;
  },
  btnClose: function (btn) {
    btn.css("opacity", "0.2");
    btn.addClass("disabled");
    //btn.attr(attr, 'true');
  },
  btnAction: function (btn) {
    btn.css("opacity", "");
    btn.removeClass("disabled");
    //btn.attr(attr, 'false');
  },
  /*isExist: function (totalArr, field, newData, orgData){
        var isExist = false;
        if(totalArr.length > 0){
            totalArr.forEach(function(item){
                if(item.data[field] == newData && newData !== orgData){
                    isExist = true;
                }
            });
        }
        return isExist;
    },*/
  isExist: function (totalArr, field, newData) {
    var isExist = false;
    if (totalArr.length > 0) {
      totalArr.forEach(function (item) {
        if (item.data[field] == newData) {
          isExist = true;
        }
      });
    }
    return isExist;
  },
  isDesignExist: function (totalArr, field, newData, sheet, row) {
    if (field === "code") {
      return !!totalArr.find((item) => item.data.code == newData);
    }
    const name = field === "name" ? newData : sheet.getValue(row, 1);
    const unit = field === "unit" ? newData : sheet.getValue(row, 2);
    return !!totalArr.find(
      (item) => item.data.name == name && item.data.unit == unit
    );
  },
  isRepeat: function (arr, field, newData, ref, classify) {
    var isRepeat = false;
    if (classify) {
      if (arr) {
        arr.forEach(function (item) {
          if (ref === "reference" && item[classify].data[field] == newData) {
            isRepeat = true;
          } else if (ref === "document" && item[field] == newData) {
            isRepeat = true;
          }
        });
      }
    } else {
      if (arr) {
        arr.forEach(function (item) {
          if (ref === "reference" && item.data[field] == newData) {
            isRepeat = true;
          } else if (ref === "document" && item[field] == newData) {
            isRepeat = true;
          }
        });
      }
    }
    return isRepeat;
  },
  isDesignRepeat: function (arr, field, newData, ref, classify, sheet, row) {
    const name = field === "name" ? newData : sheet.getValue(row, 1);
    const unit = field === "unit" ? newData : sheet.getValue(row, 2);
    var isRepeat = false;
    if (classify) {
      if (arr) {
        arr.forEach(function (item, index) {
          if (
            ref === "reference" &&
            index !== row &&
            ((item[classify].data.name == name &&
              item[classify].data.unit == unit) ||
              (field === "code" && item[classify].data.code == newData))
          ) {
            isRepeat = true;
          } else if (
            ref === "document" &&
            index !== row &&
            ((item.name == name && item.unit == unit) ||
              (field === "code" && item.code == newData))
          ) {
            isRepeat = true;
          }
        });
      }
    } else {
      if (arr) {
        arr.forEach(function (item, index) {
          if (
            ref === "reference" &&
            index !== row &&
            ((item.data.name == name && item.data.unit == unit) ||
              (field === "code" && item.data.code == newData))
          ) {
            isRepeat = true;
          } else if (
            ref === "document" &&
            index !== row &&
            ((item.name == name && item.unit == unit) ||
              (field === "code" && item.code == newData))
          ) {
            isRepeat = true;
          }
        });
      }
    }
    return isRepeat;
  },

  getContentByCode: function (items, code) {
    for (let item of items) {
      if (item.data.code == code) {
        return item.data.content;
      }
    }
    return null;
  },

  addAttr: function (attr) {
    if (!attr) {
      attr = new Array();
    }
  },

  isEmptyObj: function (obj) {
    let t;
    for (t in obj) return !1;
    return !0;
  },

  reSetCell: function (sheet, rowIdx, colIdx, value, id) {
    if (value && colIdx !== null) {
      sheet
        .getCell(rowIdx, colIdx, GC.Spread.Sheets.SheetArea.viewport)
        .value(value);
    }
    sheet.setTag(rowIdx, 0, id);
    sheet.setTag(rowIdx, 1, id);
  },

  getIndex: function (arr, id, classify) {
    var index;
    arr.forEach(function (item) {
      if (item[classify].data.id === id) {
        index = arr.indexOf(item);
      }
    });
    return index;
  },

  getObj: function (arr, id, classify) {
    for (let i = 0; i < arr.length; i++) {
      if (arr[i][classify].data.id === id) {
        return arr[i];
      }
    }
    return null;
  },

  getNewCode: function (totalObj, classify) {
    let arr;
    if (classify === "jobs") {
      arr = totalObj.jobsArr;
    } else {
      arr = totalObj.itemsArr;
    }
    tools.resort(arr, "code", false);
    return arr.length > 0 ? arr[arr.length - 1].data.code : 0;
  },

  getValidDatas: function (sheet, setting, args) {
    let validDatas = [];
    let orgRow = args.cellRange.row,
      orgCol = args.cellRange.col,
      rowCount = args.cellRange.rowCount,
      colCount = args.cellRange.colCount;
    let maxRow = orgRow + rowCount - 1,
      maxCol = orgCol + colCount - 1;
    for (let i = orgRow; i <= maxRow; i++) {
      let validData = {};
      for (let j = orgCol; j <= maxCol; j++) {
        let value = sheet.getValue(i, j);
        if (value) {
          if (setting.cols[j].data.field === "engineering") {
            if (!isNaN(value) && value % 1 === 0) {
              validData[setting.cols[j].data.field] = value;
            }
          } else if (setting.cols[j].data.field === "unitPrice") {
            if (!isNaN(value)) {
              validData[setting.cols[j].data.field] = value;
            }
          } else if (setting.cols[j].data.field === "fixedFlag") {
            let findData = BillsFixedFlagList.find((x) => x.name === value);
            if (findData) {
              validData[setting.cols[j].data.field] = findData.value;
            }
          } else if (setting.cols[j].data.field === "kind") {
            const kindItem = billKindComboList.find(
              (item) => item.name === value
            );
            if (kindItem) {
              validData[setting.cols[j].data.field] = kindItem.value;
            }
          } else {
            validData[setting.cols[j].data.field] = value;
          }
        }
      }
      if (!tools.isEmptyObj(validData)) {
        validDatas.push(validData);
      }
    }
    return validDatas;
  },

  getValidRow: function (sheet, rowIdx) {
    const colCount = 5;
    let isValid = false;
    for (let i = 0; i < colCount; i++) {
      if (sheet.getValue(rowIdx, i, GC.Spread.Sheets.SheetArea.viewport)) {
        isValid = true;
      }
    }
    return isValid;
  },

  getDelDatas: function (controller, totalJobs, totalItems) {
    let delJobs = controller.tree.selected.jobs,
      delItems = controller.tree.selected.items,
      delJobsIds = [],
      delItemsIds = [];
    if (delJobs.length > 0) {
      delJobs.forEach();
    }
  },

  delteSheets: function (
    controller,
    totalJobs,
    totalItems,
    jobsSheet,
    itemsSheet
  ) {
    var delJobs = controller.tree.selected.jobs;
    var delItems = controller.tree.selected.items;
    var delJobsIds = [];
    var delItemsIds = [];
    if (delJobs.length > 0) {
      delJobs.forEach(function (obj) {
        obj.job.count--;
        if (obj.job.count <= 0) {
          totalJobs.jobsArr.splice(totalJobs.jobsArr.indexOf(obj), 1);
          delJobsIds.push(obj.job.data.id);
        }
      });
      jobsAjax.deleteJobContent(userAccount, billsLibId, delJobsIds);
      tools.clearData(jobsSheet);
      tools.orderReshowData(
        jobsSheet,
        controller.tree.selected.jobs,
        jobsSetting,
        "job",
        true
      );
    }
    if (delItems.length > 0) {
      delItems.forEach(function (obj) {
        obj.item.count--;
        if (obj.item.count <= 0) {
          totalItems.itemsArr.splice(totalItems.itemsArr.indexOf(obj), 1);
          delItemsIds.push(obj.item.data.id);
        }
      });
      itemsAjax.deleteItemCharacter(userAccount, billsLibId, delItemsIds);
      tools.clearData(itemsSheet);
      tools.orderReshowData(
        itemsSheet,
        controller.tree.selected.items,
        itemsSetting,
        "item",
        true
      );
    }
    controller.delete();
  },

  deleteELes: function (arr, delIds, classifyStr) {
    var ids = [];
    delIds.forEach(function (delId) {
      arr.forEach(function (ele) {
        if (ele[classifyStr].data.id === delId) {
          arr.splice(arr.indexOf(ele), 1);
          ele.count--;
          /*if(ele.count <= 0){
                        ids.push(ele.data.id);
                    }*/
        }
      });
    });
    /* if(callback){
             callback(ids);
         }*/
  },

  getSerialNo: function (arr) {
    if (arr.length > 0) {
      tools.resortSerialNo(arr);
      return arr[arr.length - 1].serialNo + 1;
    }
    return 1;
  },

  resortSerialNo: function (arr) {
    function compare() {
      return function (a, b) {
        let valA = a.serialNo,
          valB = b.serialNo;
        return valA - valB;
      };
    }
    arr.sort(compare());
  },

  resort: function (arr, attr, isValue) {
    function compare(attr) {
      return function (a, b) {
        var valA, valB;
        if (isValue) {
          valA = a[attr];
          valB = a[attr];
        } else {
          valA = a.data[attr];
          valB = b.data[attr];
        }
        return valA - valB;
      };
    }
    arr.sort(compare(attr));
  },
  //update--
  orderReshowData: function (sheet, arr, setting, classify, isResort) {
    const colCount = setting.cols.length;
    sheet.setColumnCount(colCount, GC.Spread.Sheets.SheetArea.viewport);
    sheet.setColumnCount(colCount, GC.Spread.Sheets.SheetArea.colHeader);
    tools.clearData(sheet);
    if (arr.length > 0) {
      sheet.suspendPaint();
      setSheet.setMaxRowCount(sheet, arr);
      if (isResort) {
        tools.resortSerialNo(arr);
      }
      let length = arr.length;
      for (let i = 0; i < length; i++) {
        setting.cols.forEach(function (col, colIdx) {
          sheet.setTag(i, colIdx, arr[i][classify].data.id);
          if (arr[i][classify].data[col.data.field]) {
            sheet
              .getCell(i, colIdx)
              .value(arr[i][classify].data[col.data.field]);
          } else {
            sheet.getCell(i, colIdx).value("");
          }
        });
      }
      sheet.resumePaint();
    }
  },

  reshowData: function (sheet, arr, setting, isResort) {
    sheet.suspendPaint();
    const colCount = setting.cols.length;
    sheet.setColumnCount(colCount, GC.Spread.Sheets.SheetArea.viewport);
    sheet.setColumnCount(colCount, GC.Spread.Sheets.SheetArea.colHeader);
    tools.clearData(sheet);
    if (isResort) {
      tools.resort(arr, "code", false);
    }
    if (arr.length > 0) {
      var length = arr.length;
      for (var i = 0; i < length; i++) {
        setting.cols.forEach(function (col, colIdx) {
          sheet.setTag(i, colIdx, arr[i].data.id);
          if (arr[i].data[col.data.field]) {
            sheet.getCell(i, colIdx).value(arr[i].data[col.data.field]);
          } else {
            sheet.getCell(i, colIdx).value("");
          }
        });
      }
    }
    sheet.resumePaint();
  },

  reshowValue: function (sheet, arr, setting, isResort) {
    sheet.suspendPaint();
    tools.clearData(sheet);
    sheet.setColumnCount(2, GC.Spread.Sheets.SheetArea.viewport);
    sheet.setColumnCount(2, GC.Spread.Sheets.SheetArea.colHeader);
    if (isResort) {
      //tools.resort(arr, 'code', true);
      function myCompareCode(a, b) {
        let valA = a.code,
          valB = b.code;
        return valA - valB;
      }
      arr.sort(myCompareCode);
    }
    if (arr.length > 0) {
      var length = arr.length;
      for (var i = 0; i < length; i++) {
        setting.cols.forEach(function (col, colIdx) {
          sheet.setTag(i, colIdx, arr[i].code);
          if (arr[i][col.data.field]) {
            sheet.getCell(i, colIdx).value(arr[i][col.data.field]);
          } else {
            sheet.getCell(i, colIdx).value("");
          }
        });
      }
    }
    sheet.resumePaint();
  },

  clearData: function (sheet) {
    sheet.clear(
      0,
      0,
      sheet.getRowCount(),
      sheet.getColumnCount(),
      GC.Spread.Sheets.SheetArea.viewport,
      GC.Spread.Sheets.StorageType.data
    );
    sheet.clear(
      0,
      0,
      sheet.getRowCount(),
      sheet.getColumnCount(),
      GC.Spread.Sheets.SheetArea.viewport,
      GC.Spread.Sheets.StorageType.tag
    );
  },

  getRoot: function (node) {
    return node.parent ? tools.getRoot(node.parent) : node;
  },

  getBillsIds: function (callback) {
    billsAjax.getBills(billsLibId, function (datas) {
      var ids = [];
      datas.forEach(function (data) {
        ids.push(data.ID);
      });
      if (callback) {
        callback(ids);
      }
    });
  },

  delIds: function (sheet) {
    var ids = [];
    var sels = sheet.getSelections();
    sels.forEach(function (sel) {
      var orgRow = sel.row,
        rowCount = sel.rowCount,
        colCount = sel.colCount;
      var orgCol = sel.col === -1 ? 0 : sel.col;
      var maxRow = orgRow + rowCount - 1;
      for (var i = orgRow; i <= maxRow; i++) {
        if (sheet.getTag(i, orgCol)) {
          ids.push(sheet.getTag(i, orgCol));
        }
      }
    });
    return ids;
  },

  redirect: function (billsLibId, newHref) {
    mainAjax.getABillsLib(billsLibId, function (result) {
      if (result.length === 0) {
        window.location.href = newHref;
      }
    });
  },

  uniqArr: function (arr) {
    let newArr = [];
    for (let i = 0; i < arr.length; i++) {
      if (newArr.indexOf(arr[i]) === -1) {
        newArr.push(arr[i]);
      }
    }
    return newArr;
  },

  uniqObjArr: function (arr) {
    let uniqArr = [];
    for (let i = 0; i < arr.length; i++) {
      let uniqLen = uniqArr.length;
      let flag = false;
      if (uniqLen > 0) {
        for (let j = 0; j < uniqLen; j++) {
          if (
            arr[i].field === uniqArr[j].field &&
            arr[i].data === uniqArr[j].data
          ) {
            flag = true;
            //uniqArr.push(arr[i]);
          }
        }
        if (!flag) {
          uniqArr.push(arr[i]);
        }
      } else {
        uniqArr.push(arr[i]);
      }
    }
    return uniqArr;
  },

  resetRowIdx: function (arr, beginRow) {
    let rowIdx = beginRow;
    for (let i = 0; i < arr.length; i++) {
      if (arr[i].rowIdx !== rowIdx) {
        rowIdx++;
        arr[i].rowIdx = rowIdx;
      }
    }
  },

  getsheetDatas: function (sheet, classify, controller) {
    let rowCount = sheet.getRowCount();
    let colCount = sheet.getColumnCount();
    const colIdx = 1;
    let sheetDatas;
    if (classify === "total") {
      sheetDatas = [];
      for (let i = 0; i < rowCount; i++) {
        for (let j = 0; j <= colCount - 1; j++) {
          let data = sheet.getCell(i, j).value,
            id = sheet.getTag(i, j);
          if (data && id) {
            let unitData = {
              rowIdx: i,
              colIdx: j,
              data: data,
              id: id,
            };
            sheetDatas.push(unitData);
          }
        }
      }
    } else if (classify === "bills") {
      sheetDatas = { datasIdx: {}, datas: [] };
      for (let i = 0; i < controller.tree.items.length; i++) {
        let kind = sheet.getValue(i, 0),
          code = sheet.getValue(i, 1),
          name = sheet.getValue(i, 2),
          unit = sheet.getValue(i, 3),
          ruleText = sheet.getValue(i, 4),
          engineerContent = sheet.getValue(i, 5),
          unitPrice = sheet.getValue(i, 6),
          // engineering = sheet.getValue(i, 7),
          fixedFlag = sheet.getValue(i, 7);
        let data = {
          kind: kind,
          code: code,
          name: name,
          unit: unit,
          ruleText: ruleText,
          engineerContent,
          unitPrice,
          /* engineering: engineering, */ fixedFlag: fixedFlag,
          rowIdx: i,
        };
        sheetDatas.datas.push(data);
        sheetDatas.datasIdx["rowIdx" + i] = data;
      }
    } else if (classify === "designs") {
      sheetDatas = [];
      for (let i = 0; i < rowCount; i++) {
        let name = sheet.getCell(i, 1).value(),
          unit = sheet.getCell(i, 2).value(),
          id = sheet.getTag(i, colIdx);
        if (id) {
          let rowData = {
            rowIdx: i,
            name,
            unit,
            id: id,
          };
          sheetDatas.push(rowData);
        }
      }
    } else {
      sheetDatas = [];
      for (let i = 0; i < rowCount; i++) {
        let data = sheet.getCell(i, colIdx).value(),
          id = sheet.getTag(i, colIdx);
        if (data && id) {
          let rowData = {
            rowIdx: i,
            data: data,
            id: id,
          };
          sheetDatas.push(rowData);
        }
      }
    }
    return sheetDatas;
  },

  encapData: function (uncrossedDatas, crossedDatas, controller, totalJobs) {
    const UpdateExist = "updateExist",
      UpdateNew = "updateNew",
      CreateExist = "createExist",
      CreateNew = "createNew";
    let updateDatas = [];
    let createDatas = [];
    let nodeId = controller.tree.selected.getID();
    uncrossedDatas.forEach((obj) => {
      let cnDataObj, ceDataObj, content, jobId;
      let isExisit = tools.isExist(
        totalJobs.jobsArr,
        "content",
        obj.data,
        null
      );
      let isRepeat = tools.isRepeat(
        controller.tree.selected.jobs,
        "content",
        obj.data,
        "reference",
        "job"
      );
      if (isExisit && !isRepeat) {
        totalJobs.jobsArr.forEach((job) => {
          if (obj.data == job.data.content) {
            jobId = job.data.id;
          }
        });
        ceDataObj = {
          newData: obj.data,
          billsLibId: billsLibId,
          nodeId: nodeId,
          jobId: jobId,
          serialNo: obj.serialNo,
          type: CreateExist,
        };
        createDatas.push(ceDataObj);
      }
      if (!isExisit) {
        maxJobsNumber++;
        //currentCountId++;
        cnDataObj = {
          //id: maxJobsNumber,
          billsLibId: billsLibId,
          nodeId: nodeId,
          newData: obj.data,
          code: maxJobsNumber,
          serialNo: obj.serialNo,
          type: CreateNew,
        };
        createDatas.push(cnDataObj);
      }
    });
    crossedDatas.forEach((cData) => {
      let ueObj, unObj, newJobId;
      let isExisit = tools.isExist(
        totalJobs.jobsArr,
        "content",
        cData.newData,
        null
      );
      let isRepeat = tools.isRepeat(
        controller.tree.selected.jobs,
        "content",
        cData.newData,
        "reference",
        "job"
      );
      if (isExisit && !isRepeat) {
        totalJobs.jobsArr.forEach((job) => {
          if (cData.newData == job.data.content) {
            newJobId = job.data.id;
          }
        });
        ueObj = {
          newData: cData.newData,
          billsLibId: billsLibId,
          nodeId: nodeId,
          newJobId: newJobId,
          orgJobId: cData.orgId,
          serialNo: cData.serialNo,
          type: UpdateExist,
        };
        updateDatas.push(ueObj);
      }
      if (!isExisit && !isRepeat) {
        maxJobsNumber++;
        //currentCountId++;
        unObj = {
          //newJobId: maxJobsNumber,
          billsLibId: billsLibId,
          nodeId: nodeId,
          newData: cData.newData,
          orgJobId: cData.orgId,
          code: maxJobsNumber,
          serialNo: cData.serialNo,
          type: UpdateNew,
        };
        updateDatas.push(unObj);
      }
    });
    let pasteDatas = {
      updateDatas: updateDatas,
      createDatas: createDatas,
    };
    return pasteDatas;
  },
  getDesignByNameUnit: function (arr, name, unit, fromSelected) {
    if (fromSelected) {
      return arr.find(
        (item) => item.design.data.name == name && item.design.data.unit == unit
      );
    } else {
      return arr.find(
        (item) => item.data.name == name && item.data.unit == unit
      );
    }
  },
  encapDesignsData: function (
    uncrossedDatas,
    crossedDatas,
    controller,
    totalDesigns
  ) {
    const UpdateExist = "updateExist",
      UpdateNew = "updateNew",
      CreateExist = "createExist",
      CreateNew = "createNew";
    let updateDatas = [];
    let createDatas = [];
    let nodeId = controller.tree.selected.getID();
    uncrossedDatas.forEach((obj) => {
      let cnDataObj, ceDataObj, designId;
      const matchedTotalDesign = tools.getDesignByNameUnit(
        totalDesigns.designsArr,
        obj.name,
        obj.unit,
        false
      );
      const matchedDesign = tools.getDesignByNameUnit(
        controller.tree.selected.designs,
        obj.name,
        obj.unit,
        true
      );
      if (matchedTotalDesign && !matchedDesign) {
        designId = matchedTotalDesign.data.id;
        ceDataObj = {
          name: obj.name,
          unit: obj.unit,
          billsLibId: billsLibId,
          nodeId: nodeId,
          designId: designId,
          serialNo: obj.serialNo,
          type: CreateExist,
        };
        createDatas.push(ceDataObj);
      }
      if (!matchedTotalDesign) {
        maxDesignsNumber++;
        cnDataObj = {
          //id: maxJobsNumber,
          billsLibId: billsLibId,
          nodeId: nodeId,
          name: obj.name,
          unit: obj.unit,
          code: maxDesignsNumber,
          serialNo: obj.serialNo,
          type: CreateNew,
        };
        createDatas.push(cnDataObj);
      }
    });
    crossedDatas.forEach((cData) => {
      let ueObj, unObj, newDesignId;
      const matchedTotalDesign = tools.getDesignByNameUnit(
        totalDesigns.designsArr,
        cData.name,
        cData.unit,
        false
      );
      const matchedDesign = tools.getDesignByNameUnit(
        controller.tree.selected.designs,
        cData.name,
        cData.unit,
        true
      );
      if (matchedTotalDesign && !matchedDesign) {
        newDesignId = matchedTotalDesign.data.id;
        ueObj = {
          name: cData.name,
          unit: cData.unit,
          billsLibId: billsLibId,
          nodeId: nodeId,
          newDesignId: newDesignId,
          orgDesignId: cData.orgId,
          serialNo: cData.serialNo,
          type: UpdateExist,
        };
        updateDatas.push(ueObj);
      }
      if (!matchedTotalDesign && !matchedDesign) {
        maxDesignsNumber++;
        unObj = {
          billsLibId: billsLibId,
          nodeId: nodeId,
          name: cData.name,
          unit: cData.unit,
          orgDesignId: cData.orgId,
          code: maxDesignsNumber,
          serialNo: cData.serialNo,
          type: UpdateNew,
        };
        updateDatas.push(unObj);
      }
    });
    let pasteDatas = {
      updateDatas: updateDatas,
      createDatas: createDatas,
    };
    return pasteDatas;
  },
  encapItemsData: function (
    uncrossedDatas,
    crossedDatas,
    controller,
    totalItems
  ) {
    const UpdateExist = "updateExist",
      UpdateNew = "updateNew",
      CreateExist = "createExist",
      CreateNew = "createNew";
    let updateDatas = [];
    let createDatas = [];
    let nodeId = controller.tree.selected.getID();
    uncrossedDatas.forEach((obj) => {
      let cnDataObj, ceDataObj, content, itemId;
      let isExisit = tools.isExist(
        totalItems.itemsArr,
        "content",
        obj.data,
        null
      );
      let isRepeat = tools.isRepeat(
        controller.tree.selected.items,
        "content",
        obj.data,
        "reference",
        "item"
      );
      if (isExisit && !isRepeat) {
        totalItems.itemsArr.forEach((item) => {
          if (obj.data == item.data.content) {
            itemId = item.data.id;
          }
        });
        ceDataObj = {
          newData: obj.data,
          billsLibId: billsLibId,
          nodeId: nodeId,
          itemId: itemId,
          serialNo: obj.serialNo,
          type: CreateExist,
        };
        createDatas.push(ceDataObj);
      }
      if (!isExisit) {
        maxItemsNumber++;
        //currentCountId++;
        cnDataObj = {
          // id: maxItemsNumber,
          billsLibId: billsLibId,
          nodeId: nodeId,
          newData: obj.data,
          serialNo: obj.serialNo,
          code: maxItemsNumber,
          type: CreateNew,
        };
        createDatas.push(cnDataObj);
      }
    });

    crossedDatas.forEach((cData) => {
      let ueObj, unObj, newItemId;
      let isExisit = tools.isExist(
        totalItems.itemsArr,
        "content",
        cData.newData,
        null
      );
      let isRepeat = tools.isRepeat(
        controller.tree.selected.items,
        "content",
        cData.newData,
        "reference",
        "item"
      );
      if (isExisit && !isRepeat) {
        totalItems.itemsArr.forEach((item) => {
          if (cData.newData == item.data.content) {
            newItemId = item.data.id;
          }
        });
        ueObj = {
          newData: cData.newData,
          billsLibId: billsLibId,
          nodeId: nodeId,
          newItemId: newItemId,
          orgItemId: cData.orgId,
          serialNo: cData.serialNo,
          type: UpdateExist,
        };
        updateDatas.push(ueObj);
      }
      if (!isExisit && !isRepeat) {
        maxItemsNumber++;
        //currentCountId++;
        unObj = {
          // newItemId: maxItemsNumber,
          billsLibId: billsLibId,
          nodeId: nodeId,
          newData: cData.newData,
          orgItemId: cData.orgId,
          code: maxItemsNumber,
          serialNo: cData.serialNo,
          type: UpdateNew,
        };
        updateDatas.push(unObj);
      }
    });
    let pasteDatas = {
      updateDatas: updateDatas,
      createDatas: createDatas,
    };
    return pasteDatas;
  },

  encapTotalJobsDatas: function (
    sheet,
    totalJobs,
    uncrossedDatas,
    crossedDatas
  ) {
    let pasteDatas;
    let rebuildArr = [];
    if (crossedDatas.length > 0) {
      for (let i = 0; i < crossedDatas.length; i++) {
        let field = crossedDatas[i].field,
          data = crossedDatas[i].data;
        let isRepeat = tools.isRepeat(
          totalJobs.jobsArr,
          field,
          data,
          "reference"
        );
        if (isRepeat) {
          crossedDatas.splice(i--, 1);
        }
      }
      for (let i = 0; i < crossedDatas.length; i++) {
        let field = crossedDatas[i].field,
          data = crossedDatas[i].data;
        if (crossedDatas[i].field === "code" && typeof data !== "number") {
          crossedDatas.splice(i--, 1);
        }
      }
    }
    if (uncrossedDatas.length > 0) {
      for (let i = 0; i < uncrossedDatas.length; i++) {
        let field = uncrossedDatas[i].field;
        let isRepeat = tools.isRepeat(
          totalJobs.jobsArr,
          field,
          uncrossedDatas[i].data,
          "reference"
        );
        if (isRepeat) {
          uncrossedDatas.splice(i--, 1);
        }
      }
      for (let i = 0; i < uncrossedDatas.length; i++) {
        let field = uncrossedDatas[i].field;
        if (
          uncrossedDatas[i].field === "code" &&
          typeof uncrossedDatas[i].data !== "number"
        ) {
          uncrossedDatas.splice(i--, 1);
        }
      }
      rebuildArr = tools.rebuildArr(uncrossedDatas, "create");
      function myCompare(a, b) {
        if (a.rowIdx > b.rowIdx) return 1;
        if (a.rowIdx < b.rowIdx) return -1;
        return 0;
      }
      function myCompareCode(a, b) {
        if (a.code > b.code) return -1;
        if (a.code < b.code) return 1;
        return 0;
      }
      if (rebuildArr.length > 0) {
        rebuildArr.sort(myCompareCode);
        if (rebuildArr[0].code) {
          maxJobsNumber =
            maxJobsNumber + 1 > rebuildArr[0].code
              ? maxJobsNumber
              : rebuildArr[0].code;
        }
        rebuildArr.forEach(function (data) {
          if (!data.code) {
            maxJobsNumber++;
            let code = maxJobsNumber;
            data.code = code;
          }
          /* if (data.type !== 'CreateT' && data.field === 'content') {
                        maxJobsNumber++;
                        let code = maxJobsNumber;
                        data.code = code;
                    } */
        });
      }
      //rebuildArr.sort(myCompare);
    }
    //rebuildArr.sort(myCompare);
    pasteDatas = {
      updateDatas: crossedDatas,
      createDatas: rebuildArr,
    };
    return pasteDatas;
  },

  encapTotalDesignsDatas: function (
    sheet,
    totalDesigns,
    uncrossedDatas,
    crossedDatas
  ) {
    let pasteDatas;
    let rebuildArr = [];
    if (crossedDatas.length > 0) {
      for (let i = 0; i < crossedDatas.length; i++) {
        let field = crossedDatas[i].field,
          data = crossedDatas[i].data;
        let isRepeat = tools.isDesignRepeat(
          totalDesigns.designsArr,
          field,
          data,
          "reference",
          null,
          sheet,
          crossedDatas[i].rowIdx
        );
        if (isRepeat) {
          crossedDatas.splice(i--, 1);
        }
      }
      for (let i = 0; i < crossedDatas.length; i++) {
        let field = crossedDatas[i].field,
          data = crossedDatas[i].data;
        if (crossedDatas[i].field === "code" && typeof data !== "number") {
          crossedDatas.splice(i--, 1);
        }
      }
    }
    if (uncrossedDatas.length > 0) {
      for (let i = 0; i < uncrossedDatas.length; i++) {
        let field = uncrossedDatas[i].field;
        let isRepeat = tools.isDesignRepeat(
          totalDesigns.designsArr,
          field,
          uncrossedDatas[i].data,
          "reference",
          null,
          sheet,
          uncrossedDatas[i].rowIdx
        );
        if (isRepeat) {
          uncrossedDatas.splice(i--, 1);
        }
      }
      for (let i = 0; i < uncrossedDatas.length; i++) {
        let field = uncrossedDatas[i].field;
        if (
          uncrossedDatas[i].field === "code" &&
          typeof uncrossedDatas[i].data !== "number"
        ) {
          uncrossedDatas.splice(i--, 1);
        }
      }
      rebuildArr = tools.rebuildArr(uncrossedDatas, "create");
      function myCompare(a, b) {
        if (a.rowIdx > b.rowIdx) return 1;
        if (a.rowIdx < b.rowIdx) return -1;
        return 0;
      }
      function myCompareCode(a, b) {
        if (a.code > b.code) return -1;
        if (a.code < b.code) return 1;
        return 0;
      }
      if (rebuildArr.length > 0) {
        rebuildArr.sort(myCompareCode);
        if (rebuildArr[0].code) {
          maxDesignsNumber =
            maxDesignsNumber + 1 > rebuildArr[0].code
              ? maxDesignsNumber
              : rebuildArr[0].code;
        }
        rebuildArr.forEach(function (data) {
          if (!data.code) {
            maxDesignsNumber++;
            let code = maxDesignsNumber;
            data.code = code;
          }
        });
      }
      //rebuildArr.sort(myCompare);
    }
    //rebuildArr.sort(myCompare);
    pasteDatas = {
      updateDatas: crossedDatas,
      createDatas: rebuildArr,
    };
    return pasteDatas;
  },

  encapTotalItemsDatas: function (
    sheet,
    totalItems,
    uncrossedDatas,
    crossedDatas
  ) {
    let pasteDatas;
    let rebuildArr = [];
    if (crossedDatas.length > 0) {
      for (let i = 0; i < crossedDatas.length; i++) {
        let field = crossedDatas[i].field,
          data = crossedDatas[i].data;
        let isRepeat = tools.isRepeat(
          totalItems.itemsArr,
          field,
          data,
          "reference"
        );
        if (isRepeat) {
          crossedDatas.splice(i--, 1);
        }
      }
      for (let i = 0; i < crossedDatas.length; i++) {
        let field = crossedDatas[i].field,
          data = crossedDatas[i].data;
        if (crossedDatas[i].field === "code" && typeof data !== "number") {
          crossedDatas.splice(i--, 1);
        }
      }
    }
    if (uncrossedDatas.length > 0) {
      for (let i = 0; i < uncrossedDatas.length; i++) {
        let field = uncrossedDatas[i].field;
        let isRepeat = tools.isRepeat(
          totalItems.itemsArr,
          field,
          uncrossedDatas[i].data,
          "reference"
        );
        if (isRepeat) {
          uncrossedDatas.splice(i--, 1);
        }
      }
      for (let i = 0; i < uncrossedDatas.length; i++) {
        let field = uncrossedDatas[i].field;
        if (
          uncrossedDatas[i].field === "code" &&
          typeof uncrossedDatas[i].data !== "number"
        ) {
          uncrossedDatas.splice(i--, 1);
        }
      }
      rebuildArr = tools.rebuildArr(uncrossedDatas, "create");
      function myCompare(a, b) {
        if (a.rowIdx > b.rowIdx) return 1;
        if (a.rowIdx < b.rowIdx) return -1;
        return 0;
      }
      function myCompareCode(a, b) {
        if (a.code > b.code) return -1;
        if (a.code < b.code) return 1;
        return 0;
      }
      //rebuildArr.sort(myCompare);
      if (rebuildArr.length > 0) {
        rebuildArr.sort(myCompareCode);
        if (rebuildArr[0].code) {
          maxItemsNumber =
            maxItemsNumber + 1 > rebuildArr[0].code
              ? maxItemsNumber
              : rebuildArr[0].code;
        }
        rebuildArr.forEach(function (data) {
          if (!data.code) {
            maxItemsNumber++;
            let code = maxItemsNumber;
            data.code = code;
          }
        });
      }
    }
    // rebuildArr.sort(myCompare);
    pasteDatas = {
      updateDatas: crossedDatas,
      createDatas: rebuildArr,
    };
    return pasteDatas;
  },
  encapValues: function (sheet, totalItems, uncrossedDatas, crossedDatas) {
    let rebuildArr = [];
    let rebuildUpdateDatas = [];
    let valuesArr = valueController.getValues(totalItems, selectedId);
    function myCompare(a, b) {
      if (a.rowIdx > b.rowIdx) return 1;
      if (a.rowIdx < b.rowIdx) return -1;
      return 0;
    }
    if (crossedDatas.length > 0) {
      for (let i = 0; i < crossedDatas.length; i++) {
        let field = crossedDatas[i].field,
          data = crossedDatas[i].data;
        let isRepeat = tools.isRepeat(
          valuesArr,
          field,
          data,
          "document",
          "value"
        );
        if (isRepeat) {
          crossedDatas.splice(i--, 1);
        }
      }
      for (let i = 0; i < crossedDatas.length; i++) {
        let field = crossedDatas[i].field,
          data = crossedDatas[i].data;
        if (crossedDatas[i].field === "code" && typeof data !== "number") {
          crossedDatas.splice(i--, 1);
        }
      }
      rebuildUpdateDatas = tools.rebuildArr(crossedDatas, "update");
      rebuildUpdateDatas.sort(myCompare);
      for (let i = 0; i < rebuildUpdateDatas.length; i++) {
        rebuildUpdateDatas[i].itemId = selectedId;
      }
    }
    if (uncrossedDatas.length > 0) {
      for (let i = 0; i < uncrossedDatas.length; i++) {
        let field = uncrossedDatas[i].field;
        let isRepeat = tools.isRepeat(
          valuesArr,
          field,
          uncrossedDatas[i].data,
          "document",
          "value"
        );
        if (isRepeat) {
          uncrossedDatas.splice(i--, 1);
        }
      }
      for (let i = 0; i < uncrossedDatas.length; i++) {
        let field = uncrossedDatas[i].field;
        if (
          uncrossedDatas[i].field === "code" &&
          typeof uncrossedDatas[i].data !== "number"
        ) {
          uncrossedDatas.splice(i--, 1);
        }
      }
      rebuildArr = tools.rebuildArr(uncrossedDatas, "create");
      //rebuildArr.sort(myCompare);
      function myCompareCode(a, b) {
        let valA = a.code,
          valB = b.code;
        return valB - valA;
      }
      rebuildArr.sort(myCompareCode);
      let newCode = valueController.getCode(totalItems, selectedId);
      if (rebuildArr[0].code) {
        newCode =
          newCode > rebuildArr[0].code ? newCode : rebuildArr[0].code + 1;
      }
      for (let i = 0; i < rebuildArr.length; i++) {
        rebuildArr[i].itemId = selectedId;
        if (
          rebuildArr[i].type !== "CreateT" &&
          rebuildArr[i].field === "value"
        ) {
          rebuildArr[i].code = newCode;
          newCode++;
        }
      }
    }
    //backendOP
    let pasteDatas = {
      updateDatas: rebuildUpdateDatas,
      createDatas: rebuildArr,
    };
    return pasteDatas;
  },

  rebuildArr: function (arr, classify) {
    let conformDatas = [];
    let flag = true;
    for (let i = 0; i < arr.length; i++) {
      let conformData = {
        billsLibId: billsLibId,
        rowIdx: arr[i].rowIdx,
        type: classify === "create" ? "CreateT" : "UpdateT",
      };
      conformData[arr[i].field] = arr[i].data;
      for (let j = i + 1; j < arr.length; j++) {
        if (arr[i].rowIdx === arr[j].rowIdx) {
          flag = false;
          let field = arr[i].field;
          if (classify === "create") {
            conformData[arr[j].field] = arr[j].data;
            /* conformData = {
                            billsLibId: billsLibId,
                            rowIdx: arr[i].rowIdx,
                            type: 'CreateT'
                        }
                        conformData[arr[i].field] = arr[i].data;
                        conformData[arr[j].field] = arr[j].data; */
            /* if (field === 'code') {
                            conformData = {
                                billsLibId: billsLibId,
                                code: arr[i].data,
                                content: arr[j].data,
                                rowIdx: arr[i].rowIdx,
                                type: 'CreateT'
                            }
                        }
                        else {
                            conformData = {
                                billsLibId: billsLibId,
                                code: arr[j].data,
                                content: arr[i].data,
                                rowIdx: arr[i].rowIdx,
                                type: 'CreateT'
                            }
                        } */
          } else {
            conformData.orgId = arr[i].orgId;
            conformData[arr[j].field] = arr[j].data;
            /* conformData = {
                            billsLibId: billsLibId,
                            rowIdx: arr[i].rowIdx,
                            orgId: arr[i].orgId,
                            type: 'UpdateT'
                        }
                        conformData[arr[i].field] = arr[i].data;
                        conformData[arr[j].field] = arr[j].data; */
            /* if (field === 'code') {
                            conformData = {
                                billsLibId: billsLibId,
                                code: arr[i].data,
                                content: arr[j].data,
                                rowIdx: arr[i].rowIdx,
                                orgId: arr[i].orgId,
                                type: 'UpdateT'
                            }
                        }
                        else {
                            conformData = {
                                billsLIbId: billsLibId,
                                code: arr[j].data,
                                content: arr[i].data,
                                rowIdx: arr[i].rowIdx,
                                orgId: arr[i].orgId,
                                type: 'UpdateT'
                            }
                        } */
          }
        }
      }
      const matched = conformDatas.find(
        (item) => item.rowIdx === conformData.rowIdx
      );
      if (!matched) {
        conformDatas.push(conformData);
      }
    }
    /* for (let i = 0; i < arr.length; i++) {
            let flag = true;
            for (let j = 0; j < arr.length; j++) {
                if (arr[i].rowIdx === arr[j].rowIdx && arr[i].field !== arr[j].field) {
                    flag = false;
                }
            }
            if (flag) {

                conformDatas.push(arr[i]);
            }
        } */
    return conformDatas;
  },

  isDef: function (v) {
    return v !== undefined && v !== null;
  },
  //返回
  sectionInfoNull: function (sectionInfo) {
    for (let info in sectionInfo) {
      if (!this.isDef(sectionInfo[info])) {
        return info;
      }
    }
    return false;
  },

  getSectionInfo: function (node) {
    let parentIDs = [];
    let sectionInfo = { first: null, second: null, third: null };
    getParent(node);
    if (this.isDef(parentIDs[parentIDs.length - 1])) {
      sectionInfo.first = parentIDs[parentIDs.length - 1];
    }
    if (this.isDef(parentIDs[parentIDs.length - 2])) {
      sectionInfo.second = parentIDs[parentIDs.length - 2];
    }
    if (this.isDef(parentIDs[parentIDs.length - 3])) {
      sectionInfo.third = parentIDs[parentIDs.length - 3];
    }
    return sectionInfo;
    function getParent(node) {
      if (node.parent) {
        parentIDs.push(node.parent.data.ID);
        getParent(node.parent);
      }
    }
  },

  getUpdateSectionData: function (nodes) {
    let rst = [];
    for (let node of nodes) {
      rst.push({ ID: node.getID(), sectionInfo: tools.getSectionInfo(node) });
    }
    return rst;
  },

  //获取节点底下所有子节点
  getChildrenNodes: function (nodes) {
    let rst = [];
    for (let node of nodes) {
      getChild(node.children);
    }
    function getChild(ns) {
      rst = rst.concat(ns);
      for (let n of ns) {
        if (n.children.length > 0) {
          getChild(n.children);
        }
      }
    }
    return rst;
  },

  getSameDepthNodes: function (controller) {
    const items = controller.tree.items;
    let rst = [];
    let sel = controller.sheet.getSelections()[0];
    let selectedDepth = controller.tree.selected.depth();
    for (let i = 0; i < sel.rowCount; i++) {
      let row = sel.row + i;
      if (items[row].depth() === selectedDepth) {
        rst.push(items[row]);
      }
    }
    return rst;
  },
};

let pasteController = {
  frontOperator: function (sheet, setting, controller, totalJobs, datas) {
    const UpdateExist = "updateExist",
      UpdateNew = "updateNew",
      CreateExist = "createExist",
      CreateNew = "createNew";
    if (datas.length > 0) {
      for (let i = 0; i < datas.length; i++) {
        if (datas[i]) {
          if (datas[i].type === UpdateExist) {
            totalJobs.jobsArr.forEach((job) => {
              if (job.data.content == datas[i].newData) {
                let serialNo = datas[i].serialNo;
                let index = tools.getIndex(
                  controller.tree.selected.jobs,
                  datas[i].orgJobId,
                  "job"
                );
                job.count++;
                controller.tree.selected.jobs.splice(index, 1);
                controller.tree.selected.jobs.splice(index, 0, {
                  job: job,
                  serialNo: serialNo,
                });
              }
            });
          } else if (datas[i].type === UpdateNew) {
            let newJobData, newJob;
            let newJobId = datas[i].newJobId,
              serialNo = datas[i].serialNo;
            newJobData = {
              id: newJobId,
              content: datas[i].newData,
              code: datas[i].code,
            };
            newJob = createObj.newJob(newJobData);
            newJob.count = 1;
            totalJobs.jobs[totalJobs.prefix + newJobId] = newJob;
            totalJobs.jobsArr.push(newJob);
            var index = tools.getIndex(
              controller.tree.selected.jobs,
              datas[i].orgJobId,
              "job"
            );
            controller.tree.selected.jobs.splice(index, 1);
            controller.tree.selected.jobs.splice(index, 0, {
              job: newJob,
              serialNo: serialNo,
            });
          } else if (datas[i].type === CreateExist) {
            let serialNo = datas[i].serialNo;
            totalJobs.jobsArr.forEach((job) => {
              if (job.data.content == datas[i].newData) {
                job.count++;
                controller.tree.selected.jobs.push({
                  job: job,
                  serialNo: serialNo,
                });
              }
            });
          } else if (datas[i].type === CreateNew) {
            let newJobId = datas[i].newJobId,
              serialNo = datas[i].serialNo;
            let newJobData, newJob;
            newJobData = {
              id: newJobId,
              content: datas[i].newData,
              code: datas[i].code,
            };
            newJob = createObj.newJob(newJobData);
            newJob.count = 1;
            totalJobs.jobs[totalJobs.prefix + newJobId] = newJob;
            totalJobs.jobsArr.push(newJob);
            controller.tree.selected.jobs.push({
              job: newJob,
              serialNo: serialNo,
            });
          }
        }
      }
    }
    //resort&reshow
    tools.orderReshowData(
      sheet,
      controller.tree.selected.jobs,
      setting,
      "job",
      true
    );
    sheetDatas = tools.getsheetDatas(sheet);
  },
  frontDesignsRelOperator: function (
    sheet,
    setting,
    controller,
    totalDesigns,
    datas
  ) {
    const UpdateExist = "updateExist",
      UpdateNew = "updateNew",
      CreateExist = "createExist",
      CreateNew = "createNew";
    if (datas.length > 0) {
      for (let i = 0; i < datas.length; i++) {
        if (datas[i]) {
          if (datas[i].type === UpdateExist) {
            const design = tools.getDesignByNameUnit(
              totalDesigns.designsArr,
              datas[i].name,
              datas[i].unit,
              false
            );
            if (design) {
              let serialNo = datas[i].serialNo;
              let index = tools.getIndex(
                controller.tree.selected.designs,
                datas[i].orgDesignId,
                "design"
              );
              design.count++;
              controller.tree.selected.designs.splice(index, 1);
              controller.tree.selected.designs.splice(index, 0, {
                design: design,
                serialNo: serialNo,
              });
            }
          } else if (datas[i].type === UpdateNew) {
            let newDesignData, newDesign;
            let newDesignId = datas[i].newDesignId,
              serialNo = datas[i].serialNo;
            newDesignData = {
              id: newDesignId,
              name: datas[i].name,
              unit: datas[i].unit,
              code: datas[i].code,
            };
            newDesign = createObj.newDesign(newDesignData);
            newDesign.count = 1;
            totalDesigns.designs[totalDesigns.prefix + newDesignId] = newDesign;
            totalDesigns.designsArr.push(newDesign);
            var index = tools.getIndex(
              controller.tree.selected.designs,
              datas[i].orgDesignId,
              "design"
            );
            controller.tree.selected.designs.splice(index, 1);
            controller.tree.selected.designs.splice(index, 0, {
              design: newDesign,
              serialNo: serialNo,
            });
          } else if (datas[i].type === CreateExist) {
            let serialNo = datas[i].serialNo;
            const design = tools.getDesignByNameUnit(
              totalDesigns.designsArr,
              datas[i].name,
              datas[i].unit,
              false
            );
            if (design) {
              design.count++;
              controller.tree.selected.designs.push({
                design: design,
                serialNo: serialNo,
              });
            }
          } else if (datas[i].type === CreateNew) {
            let newDesignId = datas[i].newDesignId,
              serialNo = datas[i].serialNo;
            let newDesignData, newDesign;
            newDesignData = {
              id: newDesignId,
              name: datas[i].name,
              unit: datas[i].unit,
              code: datas[i].code,
            };
            newDesign = createObj.newDesign(newDesignData);
            newDesign.count = 1;
            totalDesigns.designs[totalDesigns.prefix + newDesignId] = newDesign;
            totalDesigns.designsArr.push(newDesign);
            controller.tree.selected.designs.push({
              design: newDesign,
              serialNo: serialNo,
            });
          }
        }
      }
    }
    //resort&reshow
    tools.orderReshowData(
      sheet,
      controller.tree.selected.designs,
      setting,
      "design",
      true
    );
    sheetDatas = tools.getsheetDatas(sheet, "designs");
  },
  frontItemsRelOperator: function (
    sheet,
    setting,
    controller,
    totalItems,
    datas
  ) {
    const UpdateExist = "updateExist",
      UpdateNew = "updateNew",
      CreateExist = "createExist",
      CreateNew = "createNew";
    if (datas.length > 0) {
      for (let i = 0; i < datas.length; i++) {
        if (datas[i]) {
          if (datas[i].type == UpdateExist) {
            let serialNo = datas[i].serialNo;
            totalItems.itemsArr.forEach((item) => {
              if (item.data.content === datas[i].newData) {
                let index = tools.getIndex(
                  controller.tree.selected.items,
                  datas[i].orgItemId,
                  "item"
                );
                item.count++;
                controller.tree.selected.items.splice(index, 1);
                controller.tree.selected.items.splice(index, 0, {
                  item: item,
                  serialNo: serialNo,
                });
              }
            });
          } else if (datas[i].type === UpdateNew) {
            let newItemData, newItem;
            let newItemId = datas[i].newItemId,
              serialNo = datas[i].serialNo;
            newItemData = {
              id: newItemId,
              content: datas[i].newData,
              code: datas[i].code,
            };
            newItem = createObj.newItem(newItemData);
            newItem.count = 1;
            totalItems.items[totalItems.prefix + newItemId] = newItem;
            totalItems.itemsArr.push(newItem);
            var index = tools.getIndex(
              controller.tree.selected.items,
              datas[i].orgItemId,
              "item"
            );
            controller.tree.selected.items.splice(index, 1);
            controller.tree.selected.items.splice(index, 0, {
              item: newItem,
              serialNo: serialNo,
            });
          } else if (datas[i].type === CreateExist) {
            let serialNo = datas[i].serialNo;
            totalItems.itemsArr.forEach((item) => {
              if (item.data.content == datas[i].newData) {
                item.count++;
                controller.tree.selected.items.push({
                  item: item,
                  serialNo: serialNo,
                });
              }
            });
          } else if (datas[i].type === CreateNew) {
            let newItemId = datas[i].newItemId,
              serialNo = datas[i].serialNo;
            let newItemData, newItem;
            newItemData = {
              id: newItemId,
              content: datas[i].newData,
              code: datas[i].code,
            };
            newItem = createObj.newItem(newItemData);
            newItem.count = 1;
            totalItems.items[totalItems.prefix + newItemId] = newItem;
            totalItems.itemsArr.push(newItem);
            controller.tree.selected.items.push({
              item: newItem,
              serialNo: serialNo,
            });
          }
        }
      }
    }
    //resort&reshow
    tools.orderReshowData(
      sheet,
      controller.tree.selected.items,
      setting,
      "item",
      true
    );
    sheetItemsDatas = tools.getsheetDatas(sheet);
  },
  pasteJobsFront: function (sheet, totalJobs, datas) {
    const Update = "Update",
      CreateT = "CreateT";
    if (datas.length > 0) {
      for (let i = 0; i < datas.length; i++) {
        let newJobData, newJob;
        if (datas[i]) {
          if (datas[i].type === Update) {
            totalJobs.jobsArr.forEach((job) => {
              if (job.data.id === datas[i].orgId) {
                job.data[datas[i].field] = datas[i].data;
              }
            });
          } else if (datas[i].type === CreateT) {
            //maxJobsNumber++;
            // maxJobsNumber = maxJobsNumber >= datas[i].code ? maxJobsNumber : datas[i].code;
            newJobData = {
              id: datas[i].newJobId,
              content: datas[i].content,
              code: datas[i].code,
            };
            newJob = createObj.newJob(newJobData);
            totalJobs.jobsArr.push(newJob);
          } else if (
            datas[i].type !== CreateT &&
            datas[i].field === "content"
          ) {
            newJobData = {
              id: datas[i].newJobId,
              content: datas[i].data,
              code: datas[i].code,
            };
            newJob = createObj.newJob(newJobData);
            totalJobs.jobsArr.push(newJob);
          } else if (datas[i].type !== "CreateT" && datas[i].field === "code") {
            //  maxJobsNumber++;
            // maxJobsNumber = maxJobsNumber >= datas[i].data  ? maxJobsNumber : datas[i].data;
            newJobData = {
              id: datas[i].newJobId,
              content: "",
              code: datas[i].data,
            };
            newJob = createObj.newJob(newJobData);
            totalJobs.jobsArr.push(newJob);
          }
        }
      }
    }
    setSheet.setMaxRowCount(sheet, totalJobs.jobsArr);
    tools.reshowData(sheet, totalJobs.jobsArr, totalJobsSetting, true);
    sheetJobsDatas = tools.getsheetDatas(sheet, "total");
  },
  pasteDesignsFront: function (sheet, totalDesigns, datas) {
    const Update = "Update",
      CreateT = "CreateT";
    if (datas.length > 0) {
      for (let i = 0; i < datas.length; i++) {
        let newDesignData, newDesign;
        if (datas[i]) {
          if (datas[i].type === Update) {
            totalDesigns.designsArr.forEach((design) => {
              if (design.data.id === datas[i].orgId) {
                design.data[datas[i].field] = datas[i].data;
              }
            });
          } else if (datas[i].type === CreateT) {
            //maxJobsNumber++;
            // maxJobsNumber = maxJobsNumber >= datas[i].code ? maxJobsNumber : datas[i].code;
            newDesignData = {
              id: datas[i].newJobId,
              name: datas[i].name,
              code: datas[i].code,
              unit: datas[i].unit,
            };
            newDesign = createObj.newDesign(newDesignData);
            totalDesigns.designsArr.push(newDesign);
          } else if (datas[i].type !== CreateT && datas[i].field === "name") {
            newDesignData = {
              id: datas[i].newJobId,
              name: datas[i].data,
              code: datas[i].code,
            };
            newDesign = createObj.newDesign(newDesignData);
            totalDesigns.designsArr.push(newDesign);
          } else if (datas[i].type !== "CreateT" && datas[i].field === "code") {
            //  maxJobsNumber++;
            // maxJobsNumber = maxJobsNumber >= datas[i].data  ? maxJobsNumber : datas[i].data;
            newDesignData = {
              id: datas[i].newJobId,
              name: "",
              code: datas[i].data,
            };
            newDesign = createObj.newDesign(newDesignData);
            totalDesigns.designsArr.push(newDesign);
          }
        }
      }
    }
    setSheet.setMaxRowCount(sheet, totalDesigns.designsArr);
    tools.reshowData(sheet, totalDesigns.designsArr, totalDesignsSetting, true);
    sheetJobsDatas = tools.getsheetDatas(sheet, "total");
  },
  pasteItemsFront: function (sheet, totalItems, datas) {
    const Update = "Update",
      CreateT = "CreateT";
    if (datas.length > 0) {
      for (let i = 0; i < datas.length; i++) {
        let newItemData, newItem;
        if (datas[i]) {
          if (datas[i].type === Update) {
            totalItems.itemsArr.forEach((item) => {
              if (item.data.id === datas[i].orgId) {
                item.data[datas[i].field] = datas[i].data;
              }
            });
          } else if (datas[i].type === CreateT) {
            newItemData = {
              id: datas[i].newItemId,
              content: datas[i].content,
              code: datas[i].code,
              itemValue: [],
            };
            newItem = createObj.newItem(newItemData);
            totalItems.itemsArr.push(newItem);
            totalItems.items[totalItems.prefix + datas[i].newItemId] = newItem;
          } else if (
            datas[i].type !== CreateT &&
            datas[i].field === "content"
          ) {
            newItemData = {
              id: datas[i].newItemId,
              content: datas[i].data,
              code: datas[i].code,
              itemValue: [],
            };
            newItem = createObj.newItem(newItemData);
            totalItems.itemsArr.push(newItem);
            totalItems.items[totalItems.prefix + datas[i].newItemId] = newItem;
          } else if (datas[i].type !== "CreateT" && datas[i].field === "code") {
            newItemData = {
              id: datas[i].newItemId,
              content: "",
              code: datas[i].data,
              itemValue: [],
            };
            newItem = createObj.newItem(newItemData);
            totalItems.itemsArr.push(newItem);
            totalItems.items[totalItems.prefix + datas[i].newItemId] = newItem;
          }
        }
      }
    }
    setSheet.setMaxRowCount(sheet, totalItems.itemsArr);
    tools.reshowData(sheet, totalItems.itemsArr, totalItemsSetting, true);
    totalItemsDatas = tools.getsheetDatas(sheet, "total");
  },

  pasteValueFront: function (sheet, totalItems, datas) {
    let backendUpdateDatas = [];
    let valuesArr = valueController.getValues(totalItems, selectedId);
    if (datas.length > 0) {
      for (let i = 0; i < datas.length; i++) {
        let index;
        if (datas[i]) {
          if (datas[i].type === "UpdateT") {
            if (valuesArr) {
              for (let j = 0; j < valuesArr.length; j++) {
                if (datas[i].orgId === valuesArr[j].code) {
                  index = j;
                  valuesArr.splice(j--, 1);
                }
              }
              let updateEle = { code: datas[i].code, value: datas[i].content };
              valuesArr.splice(index, 0, updateEle);
            }
          } else if (datas[i].type === "Update" && datas[i].field === "code") {
            if (valuesArr) {
              for (let j = 0; j < valuesArr.length; j++) {
                if (datas[i].orgId === valuesArr[j].code) {
                  valuesArr[j].code = datas[i].data;
                }
              }
            }
          } else if (datas[i].type === "Update" && datas[i].field === "value") {
            if (valuesArr) {
              for (let j = 0; j < valuesArr.length; j++) {
                if (datas[i].orgId === valuesArr[j].code) {
                  valuesArr[j].value = datas[i].data;
                }
              }
            }
          } else if (datas[i].type === "CreateT") {
            let newValueData = { value: datas[i].content, code: datas[i].code };
            valuesArr.push(newValueData);
          } else if (datas[i].type === "Create" && datas[i].field === "value") {
            let newValueData = { value: datas[i].data, code: datas[i].code };
            valuesArr.push(newValueData);
          } else if (datas[i].type === "Create" && datas[i].field === "code") {
            let newValueData = { value: "", code: datas[i].data };
            valuesArr.push(newValueData);
          }
        }
      }
    }
    tools.reshowValue(sheet, valuesArr, eigenValueSetting, true);
    valueDatas = tools.getsheetDatas(sheet, "total");
  },
};

var jobsController = {
  currentEditData: null,
  totalJobs: null,
  onEditStart: function (sender, args) {
    let me = jobsController;
    me.currentEditData = args.sheet.getValue(args.row, args.col);
  },
  onEditEnded: function (sender, args) {
    let me = jobsController;
    let sheet = args.sheet;
    let controller = dbController.controller;
    let totalJobs = me.totalJobs;
    let setting = jobsSetting;
    var field,
      newData = args.editingText,
      id = sheet.getTag(args.row, args.col);
    setting.cols.forEach(function (col, idx) {
      if (args.col === idx) {
        field = col.data.field;
      }
    });
    if (controller.tree.selected && newData != me.currentEditData) {
      var isExist = tools.isExist(totalJobs.jobsArr, field, newData);
      var isRepeat = tools.isRepeat(
        controller.tree.selected.jobs,
        field,
        newData,
        "reference",
        "job"
      );
      //create
      if (!id && newData && !isRepeat) {
        if (isExist) {
          jobsController.createExist(
            sheet,
            controller,
            totalJobs,
            field,
            newData,
            args,
            setting
          );
        } else {
          jobsController.createNew(
            sheet,
            controller,
            totalJobs,
            field,
            newData,
            args,
            setting
          );
        }
      }
      //update
      else if (id && !isRepeat) {
        jobsController.update(
          sheet,
          controller,
          totalJobs,
          field,
          newData,
          id,
          isExist,
          args,
          setting
        );
      }
      //处理重复
      if (isRepeat) {
        tools.alertOpr(
          args,
          sheet,
          "该工作内容已存在！",
          controller.tree.selected.jobs,
          "job"
        );
      }
    } else {
      sheet
        .getCell(args.row, args.col)
        .value(me.currentEditData ? me.currentEditData : "");
    }
  },
  editData: function (sheet) {
    let me = jobsController;
    sheet.bind(GC.Spread.Sheets.Events.EditStarting, me.onEditStart);
    sheet.bind(GC.Spread.Sheets.Events.EditEnded, me.onEditEnded);
  },

  createNew: function (
    sheet,
    controller,
    totalJobs,
    field,
    newData,
    args,
    setting
  ) {
    if (field === "content") {
      maxJobsNumber++;
      //update--
      let serialNo = tools.getSerialNo(controller.tree.selected.jobs);
      //--
      jobsAjax.edCreateJob(
        userAccount,
        billsLibId,
        controller.tree.selected.getID(),
        newData,
        maxJobsNumber,
        serialNo,
        function (newJobId) {
          var newJobData, newJob;
          newJobData = { id: newJobId, content: newData, code: maxJobsNumber };
          newJob = createObj.newJob(newJobData);
          newJob.count = 1;
          totalJobs.jobs[totalJobs.prefix + newJobId] = newJob;
          totalJobs.jobsArr.push(newJob);
          controller.tree.selected.jobs.push({
            job: newJob,
            serialNo: serialNo,
          }); //update--
          tools.orderReshowData(
            sheet,
            controller.tree.selected.jobs,
            setting,
            "job",
            true
          ); //update--
        }
      );
    } else {
      tools.alertOpr(
        args,
        sheet,
        "该编号不存在，请重新输入！",
        controller.tree.selected.jobs,
        "job"
      );
    }
  },

  createExist: function (
    sheet,
    controller,
    totalJobs,
    field,
    newData,
    args,
    setting
  ) {
    totalJobs.jobsArr.forEach(function (job) {
      if (field === "content" && newData === job.data.content) {
        let serialNo = tools.getSerialNo(controller.tree.selected.jobs); //update--
        //billsAjax.updateBills(billsLibId, controllers.tree.selected.getID(), 'jobs', job.data.id);//update--
        billsAjax.updateBills(
          userAccount,
          billsLibId,
          controller.tree.selected.getID(),
          "jobs",
          { id: job.data.id, serialNo: serialNo }
        ); //update--
        job.count++;
        // controllers.tree.selected.jobs.push(job);//update--
        controller.tree.selected.jobs.push({ job: job, serialNo: serialNo }); //update--
        //tools.reshowData(sheet, controllers.tree.selected.jobs, setting, true);//update--
        tools.orderReshowData(
          sheet,
          controller.tree.selected.jobs,
          setting,
          "job",
          true
        );
      } else if (field == "code" && newData == job.data.code) {
        let serialNo = tools.getSerialNo(controller.tree.selected.jobs); //update--
        billsAjax.updateBills(
          userAccount,
          billsLibId,
          controller.tree.selected.getID(),
          "jobs",
          { id: job.data.id, serialNo: serialNo }
        ); //update--
        job.count++;
        controller.tree.selected.jobs.push({ job: job, serialNo: serialNo }); //update--
        // tools.reshowData(sheet, controllers.tree.selected.jobs, setting, true);//update--
        tools.orderReshowData(
          sheet,
          controller.tree.selected.jobs,
          setting,
          "job",
          true
        );
      }
    });
  },
  update: function (
    sheet,
    controller,
    totalJobs,
    field,
    newData,
    id,
    isExist,
    args,
    setting
  ) {
    if (isExist) {
      totalJobs.jobsArr.forEach(function (job) {
        if (field == "code" && job.data[field] == newData) {
          let serialNo = tools.getObj(
            controller.tree.selected.jobs,
            id,
            "job"
          ).serialNo; //update--add
          let index = tools.getIndex(controller.tree.selected.jobs, id, "job"); //update-- getIndex
          job.count++;
          controller.tree.selected.jobs.splice(index, 1);
          controller.tree.selected.jobs.splice(index, 0, {
            job: job,
            serialNo: serialNo,
          }); //update--
          billsAjax.updateBillsArr(
            userAccount,
            billsLibId,
            controller.tree.selected.getID(),
            id,
            job.data.id,
            "update",
            "jobs"
          );
          tools.orderReshowData(
            sheet,
            controller.tree.selected.jobs,
            setting,
            "job",
            true
          );
        }
        if (field === "content" && job.data[field] === newData) {
          let serialNo = tools.getObj(
            controller.tree.selected.jobs,
            id,
            "job"
          ).serialNo; //update--add
          let index = tools.getIndex(controller.tree.selected.jobs, id, "job");
          job.count++;
          controller.tree.selected.jobs.splice(index, 1);
          controller.tree.selected.jobs.splice(index, 0, {
            job: job,
            serialNo: serialNo,
          }); //update--
          billsAjax.updateBillsArr(
            userAccount,
            billsLibId,
            controller.tree.selected.getID(),
            id,
            job.data.id,
            "update",
            "jobs"
          );
          // tools.reshowData(sheet, controllers.tree.selected.jobs, setting, true);//update--
          tools.orderReshowData(
            sheet,
            controller.tree.selected.jobs,
            setting,
            "job",
            true
          );
        }
      });
    } else {
      if (field === "content") {
        maxJobsNumber++;
        //let serialNo = tools.getSerialNo(controllers.tree.selected.jobs);//update--
        let serialNo = tools.getObj(
          controller.tree.selected.jobs,
          id,
          "job"
        ).serialNo;
        jobsAjax.edUpdateJob(
          userAccount,
          billsLibId,
          controller.tree.selected.getID(),
          newData,
          maxJobsNumber,
          id,
          function (newJobId) {
            //update--
            var newJobData, newJob;
            newJobData = {
              id: newJobId,
              content: newData,
              code: maxJobsNumber,
            };
            newJob = createObj.newJob(newJobData);
            newJob.count = 1;
            totalJobs.jobs[totalJobs.prefix + newJobId] = newJob;
            totalJobs.jobsArr.push(newJob);
            var index = tools.getIndex(
              controller.tree.selected.jobs,
              id,
              "job"
            );
            controller.tree.selected.jobs.splice(index, 1);
            controller.tree.selected.jobs.splice(index, 0, {
              job: newJob,
              serialNo: serialNo,
            }); //update--
            //tools.reshowData(sheet, controllers.tree.selected.jobs, setting, true);//update--
            tools.orderReshowData(
              sheet,
              controller.tree.selected.jobs,
              setting,
              "job",
              true
            ); //update--
          }
        );
      } else {
        tools.alertOpr(
          args,
          sheet,
          "该编号不存在，请重新输入！",
          controller.tree.selected.jobs,
          "job"
        );
        /*  //todo: 提示窗口
                  console.log(`enter`);
                  console.log(typeof newData);
                  if(typeof newData === 'number'){
                      console.log(`orgJobData: ${orgJobData}`);
                      sheet.getCell(args.row, args.col).value(orgJobData);
                  }
                  else {
                    //编号只能是数字
                      sheet.getCell(args.row, args.col).value('');
                  }*/
      }
    }
  },
  upMove: function (controller, sheet) {
    let updateSelArr = [];
    $("#upMove").attr("doing", "true");
    tools.btnClose($("#upMove"));
    let args = controller.tree.selected.args,
      thisJob = controller.tree.selected.jobs[args.row],
      preJob = controller.tree.selected.jobs[args.row - 1],
      tempSerialNo;
    //switch serialNo
    tempSerialNo = thisJob.serialNo;
    thisJob.serialNo = preJob.serialNo;
    preJob.serialNo = tempSerialNo;
    updateSelArr.push({ id: thisJob.job.data.id, serialNo: thisJob.serialNo });
    updateSelArr.push({ id: preJob.job.data.id, serialNo: preJob.serialNo });
    billsAjax.updateSerialNo(
      billsLibId,
      controller.tree.selected.getID(),
      updateSelArr,
      "jobs",
      function () {
        tools.orderReshowData(
          sheet,
          controller.tree.selected.jobs,
          jobsSetting,
          "job",
          true
        );
        sheet.setActiveCell(args.row - 1, args.col);
        controller.tree.selected.args.row = args.row - 1;
        $("#upMove").attr("doing", "false");
        if (
          tools.canUpMove(
            controller.tree.selected.jobs[controller.tree.selected.args.row],
            controller.tree.selected.jobs
          )
        ) {
          $("#upMove").attr("canMove", "true");
          tools.btnAction($("#upMove"));
        } else {
          $("#upMove").attr("canMove", "false");
        }
        if (
          tools.canDownMove(
            controller.tree.selected.jobs[controller.tree.selected.args.row],
            controller.tree.selected.jobs
          )
        ) {
          $("#downMove").attr("canMove", true);
          tools.btnAction($("#downMove"));
        } else {
          $("#downMove").attr("canMove", "false");
          tools.btnClose($("#downMove"));
        }
      }
    );
  },
  downMove: function (controller, sheet) {
    let updateSelArr = [];
    $("#downMove").attr("doing", "true");
    tools.btnClose($("#downMove"));
    let tempSerialNo =
      controller.tree.selected.jobs[controller.tree.selected.args.row].serialNo;
    controller.tree.selected.jobs[controller.tree.selected.args.row].serialNo =
      controller.tree.selected.jobs[
        controller.tree.selected.args.row + 1
      ].serialNo;
    controller.tree.selected.jobs[
      controller.tree.selected.args.row + 1
    ].serialNo = tempSerialNo;
    updateSelArr.push({
      id: controller.tree.selected.jobs[controller.tree.selected.args.row].job
        .data.id,
      serialNo:
        controller.tree.selected.jobs[controller.tree.selected.args.row]
          .serialNo,
    });
    updateSelArr.push({
      id: controller.tree.selected.jobs[controller.tree.selected.args.row + 1]
        .job.data.id,
      serialNo:
        controller.tree.selected.jobs[controller.tree.selected.args.row + 1]
          .serialNo,
    });
    billsAjax.updateSerialNo(
      billsLibId,
      controller.tree.selected.getID(),
      updateSelArr,
      "jobs",
      function () {
        tools.orderReshowData(
          sheet,
          controller.tree.selected.jobs,
          jobsSetting,
          "job",
          true
        );
        sheet.setActiveCell(
          controller.tree.selected.args.row + 1,
          controller.tree.selected.args.col
        );
        controller.tree.selected.args.row =
          controller.tree.selected.args.row + 1;
        $("#downMove").attr("doing", "false");
        if (
          tools.canDownMove(
            controller.tree.selected.jobs[controller.tree.selected.args.row],
            controller.tree.selected.jobs
          )
        ) {
          $("#downMove").attr("canMove", "true");
          tools.btnAction($("#downMove"));
        } else {
          $("#downMove").attr("canMove", "false");
        }
        if (
          tools.canUpMove(
            controller.tree.selected.jobs[controller.tree.selected.args.row],
            controller.tree.selected.jobs
          )
        ) {
          $("#upMove").attr("canMove", "true");
          tools.btnAction($("#upMove"));
        } else {
          $("#upMove").attr("canMove", "false");
          tools.btnClose($("#upMove"));
        }
      }
    );
  },
};

var designsController = {
  currentEditData: null,
  totalDesigns: null,
  onEditStart: function (sender, args) {
    let me = designsController;
    me.currentEditData = args.sheet.getValue(args.row, args.col);
  },
  onEditEnded: function (sender, args) {
    let me = designsController;
    let sheet = args.sheet;
    let controller = dbController.controller;
    let totalDesigns = me.totalDesigns;
    let setting = designsSetting;
    var field,
      newData = args.editingText,
      id = sheet.getTag(args.row, args.col);
    setting.cols.forEach(function (col, idx) {
      if (args.col === idx) {
        field = col.data.field;
      }
    });
    if (controller.tree.selected && newData != me.currentEditData) {
      var isExist = tools.isDesignExist(
        totalDesigns.designsArr,
        field,
        newData,
        args.sheet,
        args.row
      );
      var isRepeat = tools.isDesignRepeat(
        controller.tree.selected.designs,
        field,
        newData,
        "reference",
        "design",
        args.sheet,
        args.row
      );
      //create
      if (!id && newData && !isRepeat) {
        if (isExist) {
          designsController.createExist(
            sheet,
            controller,
            totalDesigns,
            field,
            newData,
            args,
            setting
          );
        } else {
          designsController.createNew(
            sheet,
            controller,
            totalDesigns,
            field,
            newData,
            args,
            setting
          );
        }
      }
      //update
      else if (id && !isRepeat) {
        designsController.update(
          sheet,
          controller,
          totalDesigns,
          field,
          newData,
          id,
          isExist,
          args,
          setting
        );
      }
      //处理重复
      if (isRepeat) {
        tools.alertOpr(
          args,
          sheet,
          "该设计细目已存在！",
          controller.tree.selected.designs,
          "design"
        );
      }
    } else {
      sheet
        .getCell(args.row, args.col)
        .value(me.currentEditData ? me.currentEditData : "");
    }
  },
  editData: function (sheet) {
    let me = designsController;
    sheet.bind(GC.Spread.Sheets.Events.EditStarting, me.onEditStart);
    sheet.bind(GC.Spread.Sheets.Events.EditEnded, me.onEditEnded);
  },

  createNew: function (
    sheet,
    controller,
    totalDesigns,
    field,
    newData,
    args,
    setting
  ) {
    if (field === "name" || field === "unit") {
      maxDesignsNumber++;
      //update--
      let serialNo = tools.getSerialNo(controller.tree.selected.designs);
      //--
      designsAjax.edCreateDesign(
        userAccount,
        billsLibId,
        controller.tree.selected.getID(),
        field,
        newData,
        maxDesignsNumber,
        serialNo,
        function (newID) {
          var newDesignData, newDesign;
          newDesignData = {
            id: newID,
            [field]: newData,
            code: maxDesignsNumber,
          };
          newDesign = createObj.newDesign(newDesignData);
          newDesign.count = 1;
          totalDesigns.designs[totalDesigns.prefix + newID] = newDesign;
          totalDesigns.designsArr.push(newDesign);
          controller.tree.selected.designs.push({
            design: newDesign,
            serialNo: serialNo,
          }); //update--
          tools.orderReshowData(
            sheet,
            controller.tree.selected.designs,
            setting,
            "design",
            true
          ); //update--
        }
      );
    } else {
      tools.alertOpr(
        args,
        sheet,
        "该编号不存在，请重新输入！",
        controller.tree.selected.designs,
        "design"
      );
    }
  },

  createExist: function (
    sheet,
    controller,
    totalDesigns,
    field,
    newData,
    args,
    setting
  ) {
    const name = field === "name" ? newData : sheet.getValue(args.row, 1);
    const unit = field === "unit" ? newData : sheet.getValue(args.row, 2);
    if (field === "code") {
      matched = totalDesigns.designsArr.find(
        (item) => item.data.code == newData
      );
    } else {
      matched = totalDesigns.designsArr.find(
        (item) => item.data.name == name && item.data.unit == unit
      );
    }
    if (matched) {
      let serialNo = tools.getSerialNo(controller.tree.selected.designs); //update--
      billsAjax.updateBills(
        userAccount,
        billsLibId,
        controller.tree.selected.getID(),
        "designs",
        { id: matched.data.id, serialNo: serialNo }
      ); //update--
      matched.count++;
      controller.tree.selected.designs.push({
        design: matched,
        serialNo: serialNo,
      }); //update--
      // tools.reshowData(sheet, controllers.tree.selected.designs, setting, true);//update--
      tools.orderReshowData(
        sheet,
        controller.tree.selected.designs,
        setting,
        "design",
        true
      );
    }

    /* for (const design of totalDesigns.designsArr) {
            if ((field === 'name' && newData === design.data.name) || (field === 'unit' && newData === design.data.unit)) {
                let serialNo = tools.getSerialNo(controller.tree.selected.designs);//update--
                //billsAjax.updateBills(billsLibId, controllers.tree.selected.getID(), 'designs', job.data.id);//update--
                billsAjax.updateBills(userAccount, billsLibId, controller.tree.selected.getID(), 'designs', { id: design.data.id, serialNo: serialNo });//update--
                design.count++;
                // controllers.tree.selected.designs.push(job);//update--
                controller.tree.selected.designs.push({ design: design, serialNo: serialNo });//update--
                //tools.reshowData(sheet, controllers.tree.selected.designs, setting, true);//update--
                tools.orderReshowData(sheet, controller.tree.selected.designs, setting, 'design', true);
                break;
            }
            else if (field == 'code' && newData == design.data.code) {
                let serialNo = tools.getSerialNo(controller.tree.selected.designs);//update--
                billsAjax.updateBills(userAccount, billsLibId, controller.tree.selected.getID(), 'designs', { id: design.data.id, serialNo: serialNo });//update--
                design.count++;
                controller.tree.selected.designs.push({ design: design, serialNo: serialNo });//update--
                // tools.reshowData(sheet, controllers.tree.selected.designs, setting, true);//update--
                tools.orderReshowData(sheet, controller.tree.selected.designs, setting, 'design', true);
                break;
            }
        } */
  },
  update: function (
    sheet,
    controller,
    totalDesigns,
    field,
    newData,
    id,
    isExist,
    args,
    setting
  ) {
    const name = field === "name" ? newData : sheet.getValue(args.row, 1);
    const unit = field === "unit" ? newData : sheet.getValue(args.row, 2);
    if (isExist) {
      let matched;
      if (field === "code") {
        matched = totalDesigns.designsArr.find(
          (item) => item.data.code == newData
        );
      } else {
        matched = totalDesigns.designsArr.find(
          (item) => item.data.name == name && item.data.unit == unit
        );
      }
      if (matched) {
        let serialNo = tools.getObj(
          controller.tree.selected.designs,
          id,
          "design"
        ).serialNo; //update--add
        let index = tools.getIndex(
          controller.tree.selected.designs,
          id,
          "design"
        ); //update-- getIndex
        matched.count++;
        controller.tree.selected.designs.splice(index, 1);
        controller.tree.selected.designs.splice(index, 0, {
          design: matched,
          serialNo: serialNo,
        }); //update--
        billsAjax.updateBillsArr(
          userAccount,
          billsLibId,
          controller.tree.selected.getID(),
          id,
          matched.data.id,
          "update",
          "designs"
        );
        tools.orderReshowData(
          sheet,
          controller.tree.selected.designs,
          setting,
          "design",
          true
        );
      }
      /* totalDesigns.designsArr.forEach(function (design) {
                if (field == 'code' && design.data[field] == newData) {
                    let serialNo = tools.getObj(controller.tree.selected.designs, id, 'design').serialNo;//update--add
                    let index = tools.getIndex(controller.tree.selected.designs, id, 'design');//update-- getIndex
                    design.count++;
                    controller.tree.selected.designs.splice(index, 1);
                    controller.tree.selected.designs.splice(index, 0, { design: design, serialNo: serialNo });//update--
                    billsAjax.updateBillsArr(userAccount, billsLibId, controller.tree.selected.getID(), id, design.data.id, 'update', 'designs');
                    tools.orderReshowData(sheet, controller.tree.selected.designs, setting, 'design', true);
                }
                if (field === 'name' && design.data[field] === newData) {
                    let serialNo = tools.getObj(controller.tree.selected.designs, id, 'design').serialNo;//update--add
                    let index = tools.getIndex(controller.tree.selected.designs, id, 'design');
                    design.count++;
                    controller.tree.selected.designs.splice(index, 1);
                    controller.tree.selected.designs.splice(index, 0, { design: design, serialNo: serialNo });//update--
                    billsAjax.updateBillsArr(userAccount, billsLibId, controller.tree.selected.getID(), id, design.data.id, 'update', 'designs');
                    // tools.reshowData(sheet, controllers.tree.selected.designs, setting, true);//update--
                    tools.orderReshowData(sheet, controller.tree.selected.designs, setting, 'design', true);
                }
            }); */
    } else {
      if (field === "name" || field === "unit") {
        maxDesignsNumber++;
        //let serialNo = tools.getSerialNo(controllers.tree.selected.designs);//update--
        let serialNo = tools.getObj(
          controller.tree.selected.designs,
          id,
          "design"
        ).serialNo;
        designsAjax.edUpdateDesign(
          userAccount,
          billsLibId,
          controller.tree.selected.getID(),
          name,
          unit,
          maxDesignsNumber,
          id,
          function (newDesignId) {
            //update--
            var newDesignData, newDesign;
            newDesignData = {
              id: newDesignId,
              name,
              unit,
              code: maxDesignsNumber,
            };
            newDesign = createObj.newDesign(newDesignData);
            newDesign.count = 1;
            totalDesigns.designs[totalDesigns.prefix + newDesignId] = newDesign;
            totalDesigns.designsArr.push(newDesign);
            var index = tools.getIndex(
              controller.tree.selected.designs,
              id,
              "design"
            );
            controller.tree.selected.designs.splice(index, 1);
            controller.tree.selected.designs.splice(index, 0, {
              design: newDesign,
              serialNo: serialNo,
            }); //update--
            //tools.reshowData(sheet, controllers.tree.selected.designs, setting, true);//update--
            tools.orderReshowData(
              sheet,
              controller.tree.selected.designs,
              setting,
              "design",
              true
            ); //update--
          }
        );
      } else {
        tools.alertOpr(
          args,
          sheet,
          "该编号不存在，请重新输入！",
          controller.tree.selected.designs,
          "design"
        );
      }
    }
  },
  upMove: function (controller, sheet) {
    let updateSelArr = [];
    $("#upMove").attr("doing", "true");
    tools.btnClose($("#upMove"));
    let args = controller.tree.selected.args,
      thisDesign = controller.tree.selected.designs[args.row],
      preDesign = controller.tree.selected.designs[args.row - 1],
      tempSerialNo;
    //switch serialNo
    tempSerialNo = thisDesign.serialNo;
    thisDesign.serialNo = preDesign.serialNo;
    preDesign.serialNo = tempSerialNo;
    updateSelArr.push({
      id: thisDesign.design.data.id,
      serialNo: thisDesign.serialNo,
    });
    updateSelArr.push({
      id: preDesign.design.data.id,
      serialNo: preDesign.serialNo,
    });
    billsAjax.updateSerialNo(
      billsLibId,
      controller.tree.selected.getID(),
      updateSelArr,
      "designs",
      function () {
        tools.orderReshowData(
          sheet,
          controller.tree.selected.designs,
          designsSetting,
          "design",
          true
        );
        sheet.setActiveCell(args.row - 1, args.col);
        controller.tree.selected.args.row = args.row - 1;
        $("#upMove").attr("doing", "false");
        if (
          tools.canUpMove(
            controller.tree.selected.designs[controller.tree.selected.args.row],
            controller.tree.selected.designs
          )
        ) {
          $("#upMove").attr("canMove", "true");
          tools.btnAction($("#upMove"));
        } else {
          $("#upMove").attr("canMove", "false");
        }
        if (
          tools.canDownMove(
            controller.tree.selected.designs[controller.tree.selected.args.row],
            controller.tree.selected.designs
          )
        ) {
          $("#downMove").attr("canMove", true);
          tools.btnAction($("#downMove"));
        } else {
          $("#downMove").attr("canMove", "false");
          tools.btnClose($("#downMove"));
        }
      }
    );
  },
  downMove: function (controller, sheet) {
    let updateSelArr = [];
    $("#downMove").attr("doing", "true");
    tools.btnClose($("#downMove"));
    let tempSerialNo =
      controller.tree.selected.designs[controller.tree.selected.args.row]
        .serialNo;
    controller.tree.selected.designs[
      controller.tree.selected.args.row
    ].serialNo =
      controller.tree.selected.designs[
        controller.tree.selected.args.row + 1
      ].serialNo;
    controller.tree.selected.designs[
      controller.tree.selected.args.row + 1
    ].serialNo = tempSerialNo;
    updateSelArr.push({
      id: controller.tree.selected.designs[controller.tree.selected.args.row]
        .design.data.id,
      serialNo:
        controller.tree.selected.designs[controller.tree.selected.args.row]
          .serialNo,
    });
    updateSelArr.push({
      id: controller.tree.selected.designs[
        controller.tree.selected.args.row + 1
      ].design.data.id,
      serialNo:
        controller.tree.selected.designs[controller.tree.selected.args.row + 1]
          .serialNo,
    });
    billsAjax.updateSerialNo(
      billsLibId,
      controller.tree.selected.getID(),
      updateSelArr,
      "designs",
      function () {
        tools.orderReshowData(
          sheet,
          controller.tree.selected.designs,
          designsSetting,
          "design",
          true
        );
        sheet.setActiveCell(
          controller.tree.selected.args.row + 1,
          controller.tree.selected.args.col
        );
        controller.tree.selected.args.row =
          controller.tree.selected.args.row + 1;
        $("#downMove").attr("doing", "false");
        if (
          tools.canDownMove(
            controller.tree.selected.designs[controller.tree.selected.args.row],
            controller.tree.selected.designs
          )
        ) {
          $("#downMove").attr("canMove", "true");
          tools.btnAction($("#downMove"));
        } else {
          $("#downMove").attr("canMove", "false");
        }
        if (
          tools.canUpMove(
            controller.tree.selected.designs[controller.tree.selected.args.row],
            controller.tree.selected.designs
          )
        ) {
          $("#upMove").attr("canMove", "true");
          tools.btnAction($("#upMove"));
        } else {
          $("#upMove").attr("canMove", "false");
          tools.btnClose($("#upMove"));
        }
      }
    );
  },
};

var itemsController = {
  currentEditData: null,
  totalItems: null,
  onEditStart: function (sender, args) {
    let me = itemsController;
    me.currentEditData = args.sheet.getValue(args.row, args.col);
  },
  onEditEnded: function (sender, args) {
    let me = itemsController;
    let controller = dbController.controller;
    let totalItems = me.totalItems;
    let setting = itemsSetting;
    let sheet = args.sheet;
    var field,
      newData = args.editingText,
      id = sheet.getTag(args.row, args.col);
    setting.cols.forEach(function (col, idx) {
      if (args.col === idx) {
        field = col.data.field;
      }
    });
    if (controller.tree.selected && newData != me.currentEditData) {
      var isExist = tools.isExist(totalItems.itemsArr, field, newData);
      var isRepeat = tools.isRepeat(
        controller.tree.selected.items,
        field,
        newData,
        "reference",
        "item"
      );
      //create
      if (!id && newData && !isRepeat) {
        if (isExist) {
          itemsController.createExist(
            sheet,
            controller,
            totalItems,
            field,
            newData,
            args,
            setting
          );
        } else {
          itemsController.createNew(
            sheet,
            controller,
            totalItems,
            field,
            newData,
            args,
            setting
          );
        }
      }
      //update
      else if (id && !isRepeat) {
        itemsController.update(
          sheet,
          controller,
          totalItems,
          field,
          newData,
          id,
          isExist,
          args,
          setting
        );
      }
      //处理重复
      if (isRepeat) {
        tools.alertOpr(
          args,
          sheet,
          "该项目特征已存在！",
          controller.tree.selected.items,
          "item"
        );
      }
    } else {
      sheet
        .getCell(args.row, args.col)
        .value(me.currentEditData ? me.currentEditData : "");
    }
  },
  editData: function (sheet) {
    let me = itemsController;
    sheet.bind(GC.Spread.Sheets.Events.EditStarting, me.onEditStart);
    sheet.bind(GC.Spread.Sheets.Events.EditEnded, me.onEditEnded);
  },

  createNew: function (
    sheet,
    controller,
    totalItems,
    field,
    newData,
    args,
    setting
  ) {
    if (field === "content") {
      maxItemsNumber++;
      let serialNo = tools.getSerialNo(controller.tree.selected.items);
      itemsAjax.edCreateItem(
        userAccount,
        billsLibId,
        controller.tree.selected.getID(),
        newData,
        maxItemsNumber,
        serialNo,
        function (newItemId) {
          let newItemData, newItem;
          newItemData = {
            id: newItemId,
            content: newData,
            code: maxItemsNumber,
          };
          newItem = createObj.newItem(newItemData);
          newItem.count = 1;
          totalItems.items[totalItems.prefix + newItemId] = newItem;
          totalItems.itemsArr.push(newItem);
          controller.tree.selected.items.push({
            item: newItem,
            serialNo: serialNo,
          });
          //tools.reshowData(sheet, controllers.tree.selected.items, setting, true);
          tools.orderReshowData(
            sheet,
            controller.tree.selected.items,
            setting,
            "item",
            true
          );
        }
      );
    } else {
      tools.alertOpr(
        args,
        sheet,
        "该编号不存在，请重新输入！",
        controller.tree.selected.items,
        "item"
      );
    }
  },

  createExist: function (
    sheet,
    controller,
    totalItems,
    field,
    newData,
    args,
    setting
  ) {
    totalItems.itemsArr.forEach(function (item) {
      if (field === "content" && newData === item.data.content) {
        let serialNo = tools.getSerialNo(controller.tree.selected.items);
        billsAjax.updateBills(
          userAccount,
          billsLibId,
          controller.tree.selected.getID(),
          "items",
          { id: item.data.id, serialNo: serialNo }
        );
        item.count++;
        controller.tree.selected.items.push({ item: item, serialNo: serialNo });
        tools.orderReshowData(
          sheet,
          controller.tree.selected.items,
          setting,
          "item",
          true
        );
      } else if (field == "code" && newData == item.data.code) {
        let serialNo = tools.getSerialNo(controller.tree.selected.items);
        billsAjax.updateBills(
          userAccount,
          billsLibId,
          controller.tree.selected.getID(),
          "items",
          { id: item.data.id, serialNo: serialNo }
        );
        item.count++;
        controller.tree.selected.items.push({ item: item, serialNo: serialNo });
        tools.orderReshowData(
          sheet,
          controller.tree.selected.items,
          setting,
          "item",
          true
        );
      }
    });
  },

  update: function (
    sheet,
    controller,
    totalItems,
    field,
    newData,
    id,
    isExist,
    args,
    setting
  ) {
    if (isExist) {
      totalItems.itemsArr.forEach(function (item) {
        if (field == "code" && item.data[field] == newData) {
          let serialNo = tools.getObj(
            controller.tree.selected.items,
            id,
            "item"
          ).serialNo;
          let index = tools.getIndex(
            controller.tree.selected.items,
            id,
            "item"
          );
          item.count++;
          controller.tree.selected.items.splice(index, 1);
          controller.tree.selected.items.splice(index, 0, {
            item: item,
            serialNo: serialNo,
          });
          billsAjax.updateBillsArr(
            userAccount,
            billsLibId,
            controller.tree.selected.getID(),
            id,
            item.data.id,
            "update",
            "items"
          );
          tools.orderReshowData(
            sheet,
            controller.tree.selected.items,
            setting,
            "item",
            true
          );
        }
        if (field === "content" && item.data[field] === newData) {
          let serialNo = tools.getObj(
            controller.tree.selected.items,
            id,
            "item"
          ).serialNo;
          let index = tools.getIndex(
            controller.tree.selected.items,
            id,
            "item"
          );
          item.count++;
          controller.tree.selected.items.splice(index, 1);
          controller.tree.selected.items.splice(index, 0, {
            item: item,
            serialNo: serialNo,
          });
          billsAjax.updateBillsArr(
            userAccount,
            billsLibId,
            controller.tree.selected.getID(),
            id,
            item.data.id,
            "update",
            "items"
          );
          tools.orderReshowData(
            sheet,
            controller.tree.selected.items,
            setting,
            "item",
            true
          );
        }
      });
    } else {
      if (field === "content") {
        maxItemsNumber++;
        let serialNo = tools.getObj(
          controller.tree.selected.items,
          id,
          "item"
        ).serialNo;
        itemsAjax.edUpdateItem(
          userAccount,
          billsLibId,
          controller.tree.selected.getID(),
          newData,
          maxItemsNumber,
          id,
          function (newItemId) {
            var newItemData, newItem;
            newItemData = {
              id: newItemId,
              content: newData,
              code: maxItemsNumber,
            };
            newItem = createObj.newItem(newItemData);
            newItem.count = 1;
            totalItems.items[totalItems.prefix + newItemId] = newItem;
            totalItems.itemsArr.push(newItem);
            var index = tools.getIndex(
              controller.tree.selected.items,
              id,
              "item"
            );
            controller.tree.selected.items.splice(index, 1);
            controller.tree.selected.items.splice(index, 0, {
              item: newItem,
              serialNo: serialNo,
            });
            tools.orderReshowData(
              sheet,
              controller.tree.selected.items,
              setting,
              "item",
              true
            );
          }
        );
      } else {
        tools.alertOpr(
          args,
          sheet,
          "该编号不存在，请重新输入！",
          controller.tree.selected.items,
          "item"
        );
      }
    }
  },
  upMove: function (controller, sheet) {
    let updateSelArr = [];
    $("#upMove").attr("doing", "true");
    tools.btnClose($("#upMove"));
    let tempSerialNo =
      controller.tree.selected.items[controller.tree.selected.args.row]
        .serialNo;
    controller.tree.selected.items[controller.tree.selected.args.row].serialNo =
      controller.tree.selected.items[
        controller.tree.selected.args.row - 1
      ].serialNo;
    controller.tree.selected.items[
      controller.tree.selected.args.row - 1
    ].serialNo = tempSerialNo;
    updateSelArr.push({
      id: controller.tree.selected.items[controller.tree.selected.args.row].item
        .data.id,
      serialNo:
        controller.tree.selected.items[controller.tree.selected.args.row]
          .serialNo,
    });
    updateSelArr.push({
      id: controller.tree.selected.items[controller.tree.selected.args.row - 1]
        .item.data.id,
      serialNo:
        controller.tree.selected.items[controller.tree.selected.args.row - 1]
          .serialNo,
    });
    billsAjax.updateSerialNo(
      billsLibId,
      controller.tree.selected.getID(),
      updateSelArr,
      "items",
      function () {
        tools.orderReshowData(
          sheet,
          controller.tree.selected.items,
          itemsSetting,
          "item",
          true
        );
        sheet.setActiveCell(
          controller.tree.selected.args.row - 1,
          controller.tree.selected.args.col
        );
        controller.tree.selected.args.row =
          controller.tree.selected.args.row - 1;
        $("#upMove").attr("doing", "false");
        if (
          tools.canUpMove(
            controller.tree.selected.items[controller.tree.selected.args.row],
            controller.tree.selected.items
          )
        ) {
          $("#upMove").attr("canMove", "true");
          tools.btnAction($("#upMove"));
        } else {
          $("#upMove").attr("canMove", "false");
        }
        if (
          tools.canDownMove(
            controller.tree.selected.items[controller.tree.selected.args.row],
            controller.tree.selected.items
          )
        ) {
          $("#downMove").attr("canMove", "true");
          tools.btnAction($("#downMove"));
        } else {
          $("#downMove").attr("canMove", "false");
          tools.btnClose($("#downMove"));
        }
      }
    );
  },
  downMove: function (controller, sheet) {
    let updateSelArr = [];
    $("#downMove").attr("doing", "true");
    tools.btnClose($("#downMove"));
    let tempSerialNo =
      controller.tree.selected.items[controller.tree.selected.args.row]
        .serialNo;
    controller.tree.selected.items[controller.tree.selected.args.row].serialNo =
      controller.tree.selected.items[
        controller.tree.selected.args.row + 1
      ].serialNo;
    controller.tree.selected.items[
      controller.tree.selected.args.row + 1
    ].serialNo = tempSerialNo;
    updateSelArr.push({
      id: controller.tree.selected.items[controller.tree.selected.args.row].item
        .data.id,
      serialNo:
        controller.tree.selected.items[controller.tree.selected.args.row]
          .serialNo,
    });
    updateSelArr.push({
      id: controller.tree.selected.items[controller.tree.selected.args.row + 1]
        .item.data.id,
      serialNo:
        controller.tree.selected.items[controller.tree.selected.args.row + 1]
          .serialNo,
    });
    billsAjax.updateSerialNo(
      userAccount,
      billsLibId,
      controller.tree.selected.getID(),
      updateSelArr,
      "items",
      function () {
        tools.orderReshowData(
          sheet,
          controller.tree.selected.items,
          itemsSetting,
          "item",
          true
        );
        sheet.setActiveCell(
          controller.tree.selected.args.row + 1,
          controller.tree.selected.args.col
        );
        controller.tree.selected.args.row =
          controller.tree.selected.args.row + 1;
        $("#downMove").attr("doing", "false");
        if (
          tools.canDownMove(
            controller.tree.selected.items[controller.tree.selected.args.row],
            controller.tree.selected.items
          )
        ) {
          $("#downMove").attr("canMove", "true");
          tools.btnAction($("#downMove"));
        } else {
          $("#downMove").attr("canMove", "false");
        }
        if (
          tools.canUpMove(
            controller.tree.selected.items[controlle.tree.selected.args.row],
            controller.tree.selected.items
          )
        ) {
          $("#upMove").attr("canMove", "true");
          tools.btnAction($("#upMove"));
        } else {
          $("#upMove").attr("canMove", "false");
          tools.btnClose($("#upMove"));
        }
      }
    );
  },
};

var valueController = {
  currentEditData: null,
  onEditStart: function (sender, args) {
    let me = valueController;
    me.currentEditData = args.sheet.getValue(args.row, args.col);
  },
  onEditEnded: function (sender, args) {
    let me = valueController;
    let totalItems = totalItemsController.totalItems;
    let sheet = args.sheet;
    let setting = eigenValueSetting;
    var newValue = args.editingText,
      tagId = sheet.getTag(args.row, args.col),
      field,
      isRepeat;
    setting.cols.forEach(function (col, colIdx) {
      if (args.col === colIdx) {
        field = col.data.field;
      }
    });
    if (selectedId && newValue !== me.currentEditData) {
      isRepeat = tools.isRepeat(
        valueController.getValues(totalItems, selectedId),
        field,
        newValue,
        "document"
      );
      if (!tagId && !isRepeat && newValue) {
        //create
        valueController.createValue(
          sheet,
          totalItems,
          selectedId,
          field,
          newValue,
          args
        );
      } else if (tagId && !isRepeat) {
        //update
        valueController.updateValue(totalItems, tagId, newValue, field, args);
      }
      if (isRepeat) {
        if (tagId && newValue) {
          sheet
            .getCell(args.row, args.col, GC.Spread.Sheets.SheetArea.viewport)
            .value(me.currentEditData);
        } else {
          sheet
            .getCell(args.row, args.col, GC.Spread.Sheets.SheetArea.viewport)
            .value("");
        }
      }
    } else {
      sheet
        .getCell(args.row, args.col)
        .value(me.currentEditData ? me.currentEditData : "");
    }
  },
  editData: function (sheet) {
    let me = valueController;
    sheet.bind(GC.Spread.Sheets.Events.EditStarting, me.onEditStart);
    sheet.bind(GC.Spread.Sheets.Events.EditEnded, me.onEditEnded);
  },
  createValue: function (sheet, totalItems, id, field, newValue, args) {
    var newData;
    if (field === "value") {
      var newCode = valueController.getCode(totalItems, id);
      newData = { code: newCode, value: newValue };
      totalItems.findItem(id).data.itemValue.push(newData);
      let valueArr = valueController.getValues(totalItems, id);
      tools.reshowValue(args.sheet, valueArr, eigenValueSetting, true);
      // tools.reSetCell(sheet, sheet.getActiveRowIndex(), 0, newCode, newCode);
    } else {
      if (!isNaN(newValue)) {
        newData = { code: newValue, value: "" };
        totalItems.findItem(id).data.itemValue.push(newData);
        let valueArr = valueController.getValues(totalItems, id);
        tools.reshowValue(args.sheet, valueArr, eigenValueSetting, true);
        //tools.reSetCell(sheet, sheet.getActiveRowIndex(), null, null, newValue);
      } else {
        //编号只能为数字!
        sheet.getCell(args.row, args.col).value("");
      }
    }
    itemsAjax.updateValue(userAccount, billsLibId, id, newData, null, "create");
    valueDatas = tools.getsheetDatas(sheet, "total");
  },

  updateValue: function (totalItems, tagId, newData, field, args) {
    var updateData = { code: tagId, newData: newData, field: field };
    var itemVals = totalItems.findItem(selectedId).data.itemValue;
    if (field === "value") {
      var updateEle = { code: tagId, value: newData };
      if (itemVals) {
        var index;
        itemVals.forEach(function (val) {
          if (val.code === tagId) {
            index = itemVals.indexOf(val);
            itemVals.splice(index, 1);
          }
        });
        itemVals.splice(index, 0, updateEle);
      }
      itemsAjax.updateValue(
        userAccount,
        billsLibId,
        selectedId,
        updateData,
        null,
        "update"
      );
    } else {
      if (isNumber(newData)) {
        if (itemVals) {
          var updateEle;
          var index;
          itemVals.forEach(function (val) {
            if (val.code === tagId) {
              updateEle = { code: parseInt(newData), value: val.value };
              index = itemVals.indexOf(val);
              itemVals.splice(index, 1);
            }
          });
          itemVals.splice(index, 0, updateEle);
        }
        tools.reshowValue(args.sheet, itemVals, eigenValueSetting, true);
        itemsAjax.updateValue(
          userAccount,
          billsLibId,
          selectedId,
          updateData,
          null,
          "update"
        );
      } else {
        //编号只能为数字!
        args.sheet
          .getCell(args.row, args.col)
          .value(
            args.sheet.getValue(0, args.col)
              ? args.sheet.getValue(0, args.col)
              : ""
          );
      }
    }
  },

  getValues: function (totalItems, id) {
    return totalItems.findItem(id).data.itemValue;
  },

  getTopItem: function (totalItems) {
    tools.resort(totalItems.itemsArr, "code", false);
    return totalItems.itemsArr.length > 0 ? totalItems.itemsArr[0] : null;
  },

  getCode: function (totalItems, id) {
    var valArr = totalItems.findItem(id).data.itemValue;
    if (valArr) {
      tools.resort(valArr, "code", true);
      return valArr.length > 0
        ? parseInt(valArr[valArr.length - 1].code) + 1
        : 1;
    } else {
      return 1;
    }
  },

  isRepeat: function (arr, newValue) {
    var isRepeat = false;
    arr.forEach(function (itemValue) {
      if (itemValue.value === newValue) {
        isRepeat = true;
      }
    });
    return isRepeat;
  },
};

var totalJobsController = {
  currentEditData: null,
  totalJobs: null,
  onEditStart: function (sender, args) {
    let me = totalJobsController;
    me.currentEditData = args.sheet.getValue(args.row, args.col);
  },
  onEditEnded: function (sender, args) {
    let me = totalJobsController;
    let totalJobs = me.totalJobs;
    let sheet = args.sheet;
    let setting = totalJobsSetting;
    var newData = args.editingText,
      tagId = sheet.getTag(args.row, args.col),
      field,
      isRepeat;
    setting.cols.forEach(function (col, colIdx) {
      if (args.col === colIdx) {
        field = col.data.field;
      }
    });
    if (newData != me.currentEditData) {
      isRepeat = tools.isRepeat(
        totalJobs.jobsArr,
        field,
        newData,
        "reference",
        null
      );
      if (!tagId && !isRepeat && newData) {
        //create
        totalJobsController.createJob(sheet, totalJobs, field, newData, args);
      } else if (tagId && !isRepeat) {
        //update
        totalJobsController.updateJob(totalJobs, tagId, field, newData, args);
      }
      if (isRepeat) {
        tools.alertTotalOpr(args, "该工作内容已存在！", totalJobs.jobsArr);
      }
    } else {
      sheet
        .getCell(args.row, args.col)
        .value(me.currentEditData ? me.currentEditData : "");
    }
  },
  editData: function (sheet) {
    let me = totalJobsController;
    sheet.bind(GC.Spread.Sheets.Events.EditStarting, me.onEditStart);
    sheet.bind(GC.Spread.Sheets.Events.EditEnded, me.onEditEnded);
  },

  createJob: function (sheet, totalJobs, field, newData, args) {
    if (field === "content") {
      maxJobsNumber++;
      let code = maxJobsNumber;
      jobsAjax.createJobContent(
        userAccount,
        billsLibId,
        newData,
        code,
        function (newJobId) {
          let newJobData, newJob;
          newJobData = { id: newJobId, content: newData, code: code };
          newJob = createObj.newJob(newJobData);
          totalJobs.jobsArr.push(newJob);
          //tools.reSetCell(sheet, args.row, 0, code, newJobId);
          tools.reshowData(sheet, totalJobs.jobsArr, totalJobsSetting, true);
          setSheet.setMaxRowCount(sheet, totalJobs.jobsArr);
          sheetJobsDatas = tools.getsheetDatas(sheet, "total");
        }
      );
    } else {
      let parseNum = parseInt(newData);
      //if(typeof newData === 'number'){
      if (!isNaN(parseNum)) {
        maxJobsNumber = maxJobsNumber >= newData ? maxJobsNumber : newData;
        jobsAjax.createJobContent(
          userAccount,
          billsLibId,
          "",
          newData,
          function (newJobId) {
            let newJobData, newJob;
            newJobData = { id: newJobId, content: "", code: newData };
            newJob = createObj.newJob(newJobData);
            totalJobs.jobsArr.push(newJob);
            //tools.reSetCell(sheet, args.row, 0, null, newJobId);
            tools.reshowData(sheet, totalJobs.jobsArr, totalJobsSetting, true);
            setSheet.setMaxRowCount(sheet, totalJobs.jobsArr);
            sheetJobsDatas = tools.getsheetDatas(sheet, "total");
          }
        );
      } else {
        //编号只能为数字!
        tools.alertTotalOpr(
          args,
          "编号只能为数字，请重新输入!",
          totalJobs.jobsArr
        );
        // sheet.getCell(args.row, args.col).value("");
      }
    }
  },

  updateJob: function (totalJobs, id, field, newData, args) {
    // if(field === 'code' && typeof newData !== 'number'){
    if (field === "code" && isNaN(parseInt(newData))) {
      tools.alertTotalOpr(
        args,
        "编号只能为数字，请重新输入!",
        totalJobs.jobsArr
      );
    } else {
      totalJobs.jobsArr.forEach(function (job) {
        if (job.data.id === id) {
          job.data[field] = newData;
        }
      });
      tools.reshowData(args.sheet, totalJobs.jobsArr, totalJobsSetting, true);
      jobsAjax.updateJobContent(userAccount, billsLibId, id, field, newData);
    }
  },
};

var totalDesignsController = {
  currentEditData: null,
  totalDesigns: null,
  onEditStart: function (sender, args) {
    let me = totalDesignsController;
    me.currentEditData = args.sheet.getValue(args.row, args.col);
  },
  onEditEnded: function (sender, args) {
    let me = totalDesignsController;
    let totalDesigns = me.totalDesigns;
    let sheet = args.sheet;
    let setting = totalDesignsSetting;
    var newData = args.editingText,
      tagId = sheet.getTag(args.row, args.col),
      field,
      isRepeat;
    setting.cols.forEach(function (col, colIdx) {
      if (args.col === colIdx) {
        field = col.data.field;
      }
    });
    if (newData != me.currentEditData) {
      isRepeat = tools.isDesignRepeat(
        totalDesigns.designsArr,
        field,
        newData,
        "reference",
        null,
        args.sheet,
        args.row
      );
      if (!tagId && !isRepeat && newData) {
        //create
        totalDesignsController.createDesign(
          sheet,
          totalDesigns,
          field,
          newData,
          args
        );
      } else if (tagId && !isRepeat) {
        //update
        totalDesignsController.updateDesign(
          totalDesigns,
          tagId,
          field,
          newData,
          args
        );
      }
      if (isRepeat) {
        tools.alertTotalOpr(args, "该内容已存在！", totalDesigns.designsArr);
      }
    } else {
      sheet
        .getCell(args.row, args.col)
        .value(me.currentEditData ? me.currentEditData : "");
    }
  },
  editData: function (sheet) {
    let me = totalDesignsController;
    sheet.bind(GC.Spread.Sheets.Events.EditStarting, me.onEditStart);
    sheet.bind(GC.Spread.Sheets.Events.EditEnded, me.onEditEnded);
  },

  createDesign: function (sheet, totalDesigns, field, newData, args) {
    if (field === "name" || field === "unit") {
      maxDesignsNumber++;
      let code = maxDesignsNumber;
      designsAjax.createDesignContent(
        userAccount,
        billsLibId,
        field,
        newData,
        code,
        function (newDesignId) {
          let newDesignData, newDesign;
          newDesignData = { id: newDesignId, [field]: newData, code: code };
          newDesign = createObj.newDesign(newDesignData);
          totalDesigns.designsArr.push(newDesign);
          //tools.reSetCell(sheet, args.row, 0, code, newDesignId);
          tools.reshowData(
            sheet,
            totalDesigns.designsArr,
            totalDesignsSetting,
            true
          );
          setSheet.setMaxRowCount(sheet, totalDesigns.designsArr);
          sheetDesignDatas = tools.getsheetDatas(sheet, "total");
        }
      );
    } else {
      let parseNum = parseInt(newData);
      //if(typeof newData === 'number'){
      if (!isNaN(parseNum)) {
        maxDesignsNumber =
          maxDesignsNumber >= newData ? maxDesignsNumber : newData;
        designsAjax.createDesignContent(
          userAccount,
          billsLibId,
          "code",
          newData,
          newData,
          function (newDesignId) {
            let newDesignData, newDesign;
            newDesignData = {
              id: newDesignId,
              name: "",
              unit: "",
              code: newData,
            };
            newDesign = createObj.newDesign(newDesignData);
            totalDesigns.designsArr.push(newDesign);
            //tools.reSetCell(sheet, args.row, 0, null, newDesignId);
            tools.reshowData(
              sheet,
              totalDesigns.designsArr,
              totalDesignsSetting,
              true
            );
            setSheet.setMaxRowCount(sheet, totalDesigns.designsArr);
            sheetDesignDatas = tools.getsheetDatas(sheet, "total");
          }
        );
      } else {
        //编号只能为数字!
        tools.alertTotalOpr(
          args,
          "编号只能为数字，请重新输入!",
          totalDesigns.designsArr
        );
        // sheet.getCell(args.row, args.col).value("");
      }
    }
  },

  updateDesign: function (totalDesigns, id, field, newData, args) {
    // if(field === 'code' && typeof newData !== 'number'){
    if (field === "code" && isNaN(parseInt(newData))) {
      tools.alertTotalOpr(
        args,
        "编号只能为数字，请重新输入!",
        totalDesigns.designsArr
      );
    } else {
      totalDesigns.designsArr.forEach(function (job) {
        if (job.data.id === id) {
          job.data[field] = newData;
        }
      });
      tools.reshowData(
        args.sheet,
        totalDesigns.designsArr,
        totalDesignsSetting,
        true
      );
      designsAjax.updateDesignContent(
        userAccount,
        billsLibId,
        id,
        field,
        newData
      );
    }
  },
};

var totalItemsController = {
  currentEditData: null,
  totalItems: null,
  onEditStart: function (sender, args) {
    let me = totalItemsController;
    me.currentEditData = args.sheet.getValue(args.row, args.col);
  },
  onEditEnded: function (sender, args) {
    let me = totalItemsController;
    let totalItems = me.totalItems;
    let sheet = args.sheet;
    let setting = totalItemsSetting;
    var newData = args.editingText,
      tagId = sheet.getTag(args.row, args.col),
      field,
      isRepeat;
    setting.cols.forEach(function (col, colIdx) {
      if (args.col === colIdx) {
        field = col.data.field;
      }
    });
    if (newData != me.currentEditData) {
      isRepeat = tools.isRepeat(
        totalItems.itemsArr,
        field,
        newData,
        "reference",
        null
      );
      if (!tagId && !isRepeat && newData) {
        //create
        totalItemsController.createItem(
          sheet,
          totalItems,
          field,
          newData,
          args
        );
      } else if (tagId && !isRepeat) {
        //update
        totalItemsController.updateItem(
          totalItems,
          tagId,
          field,
          newData,
          args
        );
      } else if (isRepeat) {
        tools.alertTotalOpr(args, "该项目特征已存在！", totalItems.itemsArr);
      }
    } else {
      sheet
        .getCell(args.row, args.col)
        .value(me.currentEditData ? me.currentEditData : "");
    }
  },
  editData: function (sheet) {
    let me = totalItemsController;
    sheet.bind(GC.Spread.Sheets.Events.EditStarting, me.onEditStart);
    sheet.bind(GC.Spread.Sheets.Events.EditEnded, me.onEditEnded);
  },

  createItem: function (sheet, totalItems, field, newData, args) {
    if (field === "content") {
      maxItemsNumber++;
      let code = maxItemsNumber;
      itemsAjax.createItemCharacter(
        userAccount,
        billsLibId,
        newData,
        code,
        function (newItemId) {
          var newItemData, newItem;
          newItemData = {
            id: newItemId,
            content: newData,
            code: code,
            itemValue: [],
          };
          newItem = createObj.newItem(newItemData);
          totalItems.itemsArr.push(newItem);
          totalItems.items[totalItems.prefix + newItemId] = newItem;
          //tools.reSetCell(sheet, args.row, 0, code, newItemId);
          tools.reshowData(sheet, totalItems.itemsArr, totalItemsSetting, true);
          setSheet.setMaxRowCount(sheet, totalItems.itemsArr);
          totalItemsDatas = tools.getsheetDatas(sheet, "total");
        }
      );
    } else {
      if (!isNaN(parseInt(newData))) {
        maxItemsNumber = maxItemsNumber >= newData ? maxItemsNumber : newData;
        itemsAjax.createItemCharacter(
          userAccount,
          billsLibId,
          "",
          newData,
          function (newItemId) {
            var newItemData, newItem;
            newItemData = {
              id: newItemId,
              content: "",
              code: newData,
              itemValue: [],
            };
            newItem = createObj.newItem(newItemData);
            totalItems.itemsArr.push(newItem);
            totalItems.items[totalItems.prefix + newItemId] = newItem;
            //tools.reSetCell(sheet, args.row, 0, null, newItemId);
            tools.reshowData(
              sheet,
              totalItems.itemsArr,
              totalItemsSetting,
              true
            );
            setSheet.setMaxRowCount(sheet, totalItems.itemsArr);
            totalItemsDatas = tools.getsheetDatas(sheet, "total");
          }
        );
      } else {
        tools.alertTotalOpr(
          args,
          "编号只能为数字，请重新输入！",
          totalItems.itemsArr
        );
      }
    }
  },

  updateItem: function (totalItems, id, field, newData, args) {
    if (field === "code" && isNaN(parseInt(newData))) {
      tools.alertTotalOpr(
        args,
        "编号只能为数字，请重新输入！",
        totalItems.itemsArr
      );
    } else {
      totalItems.itemsArr.forEach(function (item) {
        if (item.data.id === id) {
          item.data[field] = newData;
        }
      });
      tools.reshowData(
        args.sheet,
        totalItems.itemsArr,
        totalItemsSetting,
        true
      );
      itemsAjax.updateItemCharacter(
        userAccount,
        billsLibId,
        id,
        field,
        newData
      );
    }
  },
};

var rechargeController = {
  updateRechar: function (selectedNode, newData) {
    if (selectedNode) {
      var updateId = selectedNode.getID();
      selectedNode.data.recharge = newData;
      /*var getupdateIds = function(node){
                updateIds.push(node.getID());
                node.data.recharge = newData;
                if(node.children.length > 0){
                    node.children.forEach(function(node){
                        getupdateIds(node);
                    });
                }
            }
            getupdateIds(tools.getRoot(selectedNode));*/
      billsAjax.updateRecharge(userAccount, billsLibId, updateId, newData);
    } else {
      codeEditor.setValue("");
      //$('exampleTextarea').val('');
    }
  },
  createRecharge: function (node) {
    if (node) {
      var tempId = [];
      tempId.push(node.getID());
      var rootNode = tools.getRoot(node);
      if (rootNode.data.recharge && rootNode !== node) {
        billsAjax.updateRecharge(
          userAccount,
          billsLibId,
          tempId,
          rootNode.data.recharge
        );
        node.data.recharge = rootNode.data.recharge;
        //$('#exampleTextarea').val(node.data.recharge);
        codeEditor.setValue(node.data.recharge);
      } else {
        node.data.recharge = "";
        //$('#exampleTextarea').val('');
        codeEditor.setValue("");
      }
    } else {
      codeEditor.setValue("");
      //$('exampleTextarea').val('');
    }
  },
};

function isNumber(num) {
  return !isNaN(num) && num % 1 === 0;
}