/**
   * 调额插入客户调额信息
   *
   * @param appId
   * @param adjustmentAccount
   * @param adjustmentType
   * @param user
   * @throws SQLException
   */
  public void insertAmountAdjustment(
      String appId, String adjustmentAccount, String adjustmentType, User user) {
    // 进件信息
    CustomerApplicationInfo applicationInfo =
        commonDao.findObjectById(CustomerApplicationInfo.class, appId);

    AmountAdjustment amountAdjustment = new AmountAdjustment();
    amountAdjustment.setCustomerId(applicationInfo.getCustomerId());
    amountAdjustment.setProductId(applicationInfo.getProductId());
    amountAdjustment.setApproval(AmountAdjustmentApproveStatusEnum.Audit.name());
    amountAdjustment.setActualAmount(applicationInfo.getActualQuote());
    amountAdjustment.setApprovalLimit(adjustmentAccount);
    amountAdjustment.setOriginalAmount(applicationInfo.getApplyQuota());
    amountAdjustment.setAdjustAmountTime(new Date());
    amountAdjustment.setCreatedBy(user.getId());
    amountAdjustment.setCreatedTime(new Date());
    amountAdjustment.setModifiedBy(user.getId());
    amountAdjustment.setModifiedTime(new Date());
    amountAdjustment.setAdjustmentType(adjustmentType);
    commonDao.insertObject(amountAdjustment);

    // 添加额度调整申请流程
    WfProcessInfo wf = new WfProcessInfo();
    wf.setProcessType(WfProcessInfoType.amount_adjustment_type); // TODO
    wf.setVersion("1");
    commonDao.insertObject(wf);
    List<NodeAudit> list =
        nodeAuditService.findByNodeTypeAndProductId(
            NodeAuditTypeEnum.ProductAmountAdjust.name(), applicationInfo.getProductId());
    boolean startBool = false;
    boolean endBool = false;
    // 节点id和WfStatusInfo id的映射
    Map<String, String> nodeWfStatusMap = new HashMap<String, String>();
    for (NodeAudit nodeAudit : list) {
      if (nodeAudit.getIsstart().equals(YesNoEnum.YES.name())) {
        startBool = true;
      }

      if (startBool && !endBool) {
        WfStatusInfo wfStatusInfo = new WfStatusInfo();
        wfStatusInfo.setIsStart(nodeAudit.getIsstart().equals(YesNoEnum.YES.name()) ? "1" : "0");
        wfStatusInfo.setIsClosed(nodeAudit.getIsend().equals(YesNoEnum.YES.name()) ? "1" : "0");
        wfStatusInfo.setRelationedProcess(wf.getId());
        wfStatusInfo.setStatusName(nodeAudit.getNodeName());
        wfStatusInfo.setStatusCode(nodeAudit.getId());
        commonDao.insertObject(wfStatusInfo);

        nodeWfStatusMap.put(nodeAudit.getId(), wfStatusInfo.getId());

        if (nodeAudit.getIsstart().equals(YesNoEnum.YES.name())) {
          // 添加初始审核
          AmountAdjustmentProcess amountAdjustmentProcess = new AmountAdjustmentProcess();
          String serialNumber = processService.start(wf.getId());
          amountAdjustmentProcess.setSerialNumber(serialNumber);
          amountAdjustmentProcess.setNextNodeId(nodeAudit.getId());
          amountAdjustmentProcess.setAmountAdjustmentId(amountAdjustment.getId());
          commonDao.insertObject(amountAdjustmentProcess);

          AmountAdjustment adjustment =
              commonDao.findObjectById(AmountAdjustment.class, amountAdjustment.getId());
          adjustment.setSerialNumber(serialNumber);
          commonDao.updateObject(adjustment);
        }
      }

      if (nodeAudit.getIsend().equals(YesNoEnum.YES.name())) {
        endBool = true;
      }
    }

    // 节点关系
    List<NodeControl> nodeControls =
        nodeAuditService.findNodeControlByNodeTypeAndProductId(
            NodeAuditTypeEnum.ProductAmountAdjust.name(), applicationInfo.getProductId());
    for (NodeControl control : nodeControls) {
      WfStatusResult wfStatusResult = new WfStatusResult();
      wfStatusResult.setCurrentStatus(nodeWfStatusMap.get(control.getCurrentNode()));
      wfStatusResult.setNextStatus(nodeWfStatusMap.get(control.getNextNode()));
      wfStatusResult.setExamineResult(control.getCurrentStatus());
      commonDao.insertObject(wfStatusResult);
    }
  }