1.许可

tangzy

2021-11-05 425fb772c347a85fe8c9cb38a7a386d6368402cd

 src/main/java/org/springblade/modules/permit/controller/PermitController.java

@@ -124,7 +124,21 @@
   @ApiOperationSupport(order = 3)
   @ApiOperation(value = "分页", notes = "传入permit")
   public R<IPage<PermitVO>> page(PermitVO permit, Query query) {
      IPage<PermitVO> pages = permitService.selectPermitPage(Condition.getPage(query), permit);
      IPage<PermitVO> pages;
      if (permit.getUsetype().equals("0")) {
         pages = permitService.selectPermitPage(Condition.getPage(query), permit, null);
      } else if (permit.getUsetype().equals("1")) {
         String childer = informationService.selJurchilder(permit.getJurisdiction());
         String[] split = childer.split(",");
         String strArrays = "";
         for (int j = 0; j < split.length; j++) {
            strArrays += "'" + split[j] + "',";
         }
         String jurisdiction = strArrays.substring(0, strArrays.length() - 1);
         pages = permitService.selectPermitPage(Condition.getPage(query), permit, jurisdiction);
      } else {
         pages = permitService.selectPermitPage(Condition.getPage(query), permit, null);
      }
      return R.data(pages);
   }

@@ -146,22 +160,21 @@
      permit.setStorage("1");
      permit.setPermitime(new Date());
      permitService.save(permit);
      String pertime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(permit.getPermitime());
      //String pertime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(permit.getPermitime());
      String overtime = new SimpleDateFormat("yyyy-MM-dd").format(permit.getOvertime());
      String s = "insert into sys_permit(id,creditCode,enterpriseName,representative," +
         "registeredCapital,organizationCode,registrationNumber,identificationNumber,enterprises," +
         "address,business,region,registration,industry,type,permitime,deptid,ptype,representativecell,contacts,contactscell,jurisdiction,cardid,overtime)" +
         "address,business,region,registration,industry,type,deptid,ptype,representativecell,contacts,contactscell,jurisdiction,cardid,overtime)" +
         "values(" + "'" + permit.getId() + "'" + "," + "'" + permit.getCreditcode() + "'" + "," + "'" + permit.getEnterprisename() + "'" + "," + "'"
         + permit.getRepresentative() + "'" + "," + "'" + permit.getRegisteredcapital() + "'" + "," + "'"
         + permit.getOrganizationcode() + "'" + "," + "'" + permit.getRegistrationnumber() + "'" + "," +
         "'" + permit.getIdentificationnumber() + "'" + "," + "'" + permit.getEnterprises() + "'" + "," + "'" +
         permit.getAddress() + "'" + "," + "'" + permit.getBusiness() + "'" + "," + "'" +
         permit.getRegion() + "'" + "," + "'" + permit.getRegistration() + "'" + "," + "'" + permit.getIndustry() + "'" + "," + "'"
         + permit.getType() + "'" + "," +
         "'" + pertime + "'" + "," + "'" + permit.getDeptid() + "'" + "," + "'" + permit.getPtype() + "'" + "," +
         + permit.getType() + "'" + "," + "'" + permit.getDeptid() + "'" + "," + "'" + permit.getPtype() + "'" + "," +
         "'" + permit.getRepresentativecell() + "'" + "," + "'" + permit.getContacts() + "'" + "," + "'"
         + permit.getContactscell() + "'" + "," + "'" + permit.getJurisdiction() + "'" +
         "," + "'" + permit.getCardid() + "'"+ "," + "'" + overtime+ "'" + ")";
         "," + "'" + permit.getCardid() + "'" + "," + "'" + overtime + "'" + ")";
      FtpUtil.sqlFileUpload(s);
      return R.success("许可提交成功");
   }