src/main/java/org/springblade/modules/recordLegalperson/controller/RecordLegalpersonController.java
New file @@ -0,0 +1,472 @@ /* * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * * Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright * notice, this list of conditions and the following disclaimer in the * documentation and/or other materials provided with the distribution. * Neither the name of the dreamlu.net developer nor the names of its * contributors may be used to endorse or promote products derived from * this software without specific prior written permission. * Author: Chill 庄骞 (smallchill@163.com) */ package org.springblade.modules.recordLegalperson.controller; import com.baomidou.mybatisplus.core.metadata.IPage; import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import io.swagger.annotations.ApiParam; import lombok.AllArgsConstructor; import org.springblade.common.cache.DictCache; import org.springblade.common.cache.ParamCache; import org.springblade.common.config.FtpConfig; import org.springblade.common.enums.DictEnum; import org.springblade.core.boot.ctrl.BladeController; import org.springblade.core.cache.utils.CacheUtil; import org.springblade.core.mp.support.Condition; import org.springblade.core.mp.support.Query; import org.springblade.core.tool.api.R; import org.springblade.core.tool.support.Kv; import org.springblade.core.tool.utils.DigestUtil; import org.springblade.core.tool.utils.Func; import org.springblade.modules.FTP.FtpUtil; import org.springblade.modules.information.entity.Information; import org.springblade.modules.information.service.IInformationService; import org.springblade.modules.recordLegalperson.entity.RecordLegalperson; import org.springblade.modules.recordLegalperson.service.IRecordLegalpersonService; import org.springblade.modules.recordLegalperson.vo.RecordLegalpersonVO; import org.springblade.modules.resource.service.IAttachService; import org.springblade.modules.system.entity.Dept; import org.springblade.modules.system.entity.User; import org.springblade.modules.system.service.IDeptService; import org.springblade.modules.system.service.IUserService; import org.springframework.web.bind.annotation.*; import javax.validation.Valid; import java.text.SimpleDateFormat; import java.util.Date; import java.util.Map; import static org.springblade.common.constant.CommonConstant.DEFAULT_PARAM_PASSWORD; import static org.springblade.core.cache.constant.CacheConstant.SYS_CACHE; /** * 控制器 * * @author BladeX * @since 2021-07-12 */ @RestController @AllArgsConstructor @RequestMapping("/recordlegalperson") @Api(value = "", tags = "接口") public class RecordLegalpersonController extends BladeController { private final IRecordLegalpersonService recordService; private final IDeptService iDeptService; private final IInformationService informationService; private final IUserService userService; private final IAttachService attachService; /** * 详情 */ @GetMapping("/detail") @ApiOperationSupport(order = 1) @ApiOperation(value = "详情", notes = "传入record") public R<RecordLegalperson> detail(RecordLegalperson record) { RecordLegalperson detail = recordService.getOne(Condition.getQueryWrapper(record)); return R.data(detail); } /** * 分页 */ @GetMapping("/list") @ApiOperationSupport(order = 2) @ApiOperation(value = "分页", notes = "传入record") public R<IPage<RecordLegalperson>> list(RecordLegalperson record, Query query) { record.setStorage("1"); IPage<RecordLegalperson> pages = recordService.page(Condition.getPage(query), Condition.getQueryWrapper(record)); return R.data(pages); } /** * 自定义分页 */ @GetMapping("/page") @ApiOperationSupport(order = 3) @ApiOperation(value = "分页", notes = "传入record") public R<IPage<RecordLegalpersonVO>> page(RecordLegalpersonVO record, Query query) { IPage<RecordLegalpersonVO> pages; pages = recordService.selectRecordPage(Condition.getPage(query), record, record.getJurisdiction()); // if (record.getUsetype().equals("0")) { // pages = recordService.selectRecordPage(Condition.getPage(query), record, null); // } else if (record.getUsetype().equals("1")) { // String childer = informationService.selJurchilder(record.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 = recordService.selectRecordPage(Condition.getPage(query), record, jurisdiction); // } else { // pages = recordService.selectRecordPage(Condition.getPage(query), record, null); // } return R.data(pages); } /** * 新增 */ @PostMapping("/save") @ApiOperationSupport(order = 4) @ApiOperation(value = "新增", notes = "传入record") public R save(@Valid @RequestBody RecordLegalperson record) { String cardid = record.getCardid(); String type = record.getPtype(); Map map = recordService.selectIn(cardid, type); if (map != null) { String id = map.get("id").toString(); recordService.removeByIds(Func.toLongList(id)); String s1 = "delete from sys_record where id = " + "'" + id + "'"; FtpUtil.sqlFileUpload(s1); } record.setStorage("1"); record.setType("2"); record.setPermitime(new Date()); recordService.save(record); //String offtime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(record.getOfficetime()); //String pertime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(record.getPermitime()); String s = "insert into sys_record(id,representative," + "address,business,registration,industry,type,ptype,representativecell,contacts,contactscell,perid,offices,jurisdiction,cardid,storage," + "overtime," + "changecontacts," + "changecontactscell" + ")" + "values(" + "'" + record.getId() + "'" + "," + "'" + record.getRepresentative() + "'" + "," + "'" + record.getAddress() + "'" + "," + "'" + record.getBusiness() + "'" + "," + "'" + record.getRegistration() + "'" + "," + "'" + record.getIndustry() + "'" + "," + "'" + record.getType() + "'" + "," + "'" + record.getPtype() + "'" + "," + "'" + record.getRepresentativecell() + "'" + "," + "'" + record.getContacts() + "'" + "," + "'" + record.getContactscell() + "'" + "," + "'" + record.getPerid() + "'" + "," + "'" + record.getOffices() + "'" + "," + "'" + record.getJurisdiction() + "'" + "," + "'" + record.getCardid() + "'" + "," + "'" + record.getStorage() + "'" + "," + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(record.getOvertime()) + "'" + "," + "'" + record.getChangecontacts() + "'" + "," + "'" + record.getChangecontactscell() + "'" + ")"; FtpUtil.sqlFileUpload(s); return R.success("成功"); } /** * 暂存 */ @PostMapping("/rocordsave") @ApiOperationSupport(order = 4) @ApiOperation(value = "新增", notes = "传入record") public R rocordsave(@Valid @RequestBody RecordLegalperson record) { String cardid = record.getCardid(); String type = record.getPtype(); Map map = recordService.selectIn(cardid, type); if (map != null) { record.setStorage("0"); record.setPermitime(new Date()); recordService.updateById(record); } else { record.setStorage("0"); record.setType("2"); record.setPermitime(new Date()); recordService.save(record); } return R.success("暂存成功"); } /** * 修改 */ @PostMapping("/update") @ApiOperationSupport(order = 5) @ApiOperation(value = "修改", notes = "传入record") public R update(@Valid @RequestBody RecordLegalperson record) { //审核通过 if (record.getType().equals("0")) { //新增组织机构和单位信息 Information information = new Information(); information.setCreditcode(record.getCreditcode()); information.setEnterprisename(record.getEnterprisename()); information.setRepresentative(record.getRepresentative()); information.setEstablishtime(record.getEstablishtime()); information.setRegisteredcapital(record.getRegisteredcapital()); information.setOrganizationcode(record.getOrganizationcode()); information.setRegistrationnumber(record.getRegistrationnumber()); information.setEnterprises(record.getEnterprises()); information.setAddress(record.getAddress()); information.setBusiness(record.getBusiness()); information.setRegion(record.getRegion()); information.setRegistration(record.getRegistration()); information.setIndustry(record.getIndustry()); information.setRepresentativecell(record.getRepresentativecell()); information.setContacts(record.getContacts()); information.setContactscell(record.getContactscell()); Dept dept = new Dept(); //本市公司 if (record.getPtype().equals("2")) { Long i = 1425366663452196865L; dept.setParentId(i); dept.setAncestors("0,1425366663452196865"); } //培训公司 else { Long i = 1420222768149966850L; dept.setParentId(i); dept.setAncestors("0,1420222768149966850"); } dept.setTenantId("000000"); dept.setDeptName(information.getEnterprisename()); dept.setDeptCategory(1); if (iDeptService.submit(dept)) { CacheUtil.clear(SYS_CACHE); // 返回懒加载树更新节点所需字段 Kv kv = Kv.create().set("id", String.valueOf(dept.getId())).set("tenantId", dept.getTenantId()) .set("deptCategoryName", DictCache.getValue(DictEnum.ORG_CATEGORY, dept.getDeptCategory())); String id = kv.get("id").toString(); information.setDepartmentid(id); } informationService.save(information); Integer isDeleted = 0; //注册用户 User user = new User(); user.setDeptId(information.getDepartmentid()); user.setTenantId("000000"); user.setAccount(record.getEnterprisename()); String initPassword = ParamCache.getValue(DEFAULT_PARAM_PASSWORD); user.setPassword(DigestUtil.encrypt(initPassword)); //user.setPassword(initPassword); user.setCreateTime(new Date()); user.setUpdateTime(new Date()); user.setRoleId("1414575196264300546"); user.setStatus(1); user.setIsDeleted(0); userService.save(user); String roleid = "1415563428727328770"; String s = "insert into sys_information(id,creditCode,enterpriseName,representative" + ",registeredCapital,organizationCode,registrationNumber, enterprises, address," + " business,region,registration,industry,departmentid,stats,jurisdiction,representativecell," + "contacts,contactscell,create_user_id) " + "values(" + "'" + information.getId() + "'" + "," + "'" + information.getCreditcode() + "'" + "," + "'" + information.getEnterprisename() + "'" + "," + "'" + information.getRepresentative() + "'" + "," + "'" + information.getRegisteredcapital() + "'" + "," + "'" + information.getOrganizationcode() + "'" + "," + "'" + information.getRegistrationnumber() + "'" + "," + "'" + information.getEnterprises() + "'" + "," + "'" + information.getAddress() + "'" + "," + "'" + information.getBusiness() + "'" + "," + "'" + information.getRegion() + "'" + "," + "'" + information.getRegistration() + "'" + "," + "'" + information.getIndustry() + "'" + "," + "'" + information.getDepartmentid() + "'" + "," + "'" + information.getStats() + "'" + "," + "'" + information.getJurisdiction() + "'" + "," + "'" + information.getRepresentativecell() + "'" + "," + "'" + information.getContacts() + "'" + "," + "'" + information.getContactscell() + "'" + "," + "'" + information.getCreateUserId() + "'" + ")"; FtpUtil.sqlFileUpload(s); String ss = "insert into blade_dept(id,parent_id,tenant_id,dept_name,ancestors,dept_category,is_deleted) values(" + "'" + dept.getId() + "'" + "," + "'" + dept.getParentId() + "'" + "," + "'" + dept.getTenantId() + "'" + "," + "'" + information.getEnterprisename() + "'" + "," + "'" + dept.getAncestors() + "'" + "," + "'" + dept.getDeptCategory() + "'" + "," + "'" + isDeleted + "'" + ")"; FtpUtil.sqlFileUpload(ss); String rtime; String paperTime; if (user.getRtime() == null) { rtime = null; } else { rtime = new SimpleDateFormat("yyyy-MM-dd").format(user.getRtime()); } //发证日期处理 if (user.getPaperTime() == null) { paperTime = ""; } else { paperTime = new SimpleDateFormat("yyyy-MM-dd").format(user.getPaperTime()); } //头像 if (null != user.getAvatar() && !user.getAvatar().equals("")) { user.setAvatar(FtpConfig.ip + user.getAvatar().substring(26)); } //指纹 if (null != user.getFingerprint() && !user.getFingerprint().equals("")) { user.setFingerprint(FtpConfig.ip + user.getFingerprint().substring(26)); } String sss = "insert into blade_user(" + "id,tenant_id,account,password,name,real_name,avatar,email,phone,sex," + "role_id,dept_id,cardid,nativePlace,nation,fingerprint,education," + "politicaloutlook,healstats,height,address,registered,rtime," + "securitynumber,hold,jurisdiction,examination_type,status,is_deleted,dispatch) " + "values(" + "'" + user.getId() + "'" + "," + "'" + user.getTenantId() + "'" + "," + "'" + user.getAccount() + "'" + "," + "'" + user.getPassword() + "'" + "," + "'" + user.getName() + "'" + "," + "'" + user.getRealName() + "'" + "," + "'" + user.getAvatar() + "'" + "," + "'" + user.getEmail() + "'" + "," + "'" + user.getPhone() + "'" + "," + "'" + null + "'" + "," + "'" + roleid + "'" + "," + "'" + user.getDeptId() + "'" + "," + "'" + user.getCardid() + "'" + "," + "'" + user.getNativeplace() + "'" + "," + "'" + user.getNation() + "'" + "," + "'" + user.getFingerprint() + "'" + "," + "'" + user.getEducation() + "'" + "," + "'" + user.getPoliticaloutlook() + "'" + "," + "'" + user.getHealstats() + "'" + "," + "'" + user.getHeight() + "'" + "," + "'" + user.getAddress() + "'" + "," + "'" + user.getRegistered() + "'" + "," + "'" + rtime + "'" + "," + "'" + user.getSecuritynumber() + "'" + "," + "'" + user.getHold() + "'" + "," + "'" + user.getJurisdiction() + "'" + "," + "'" + user.getExaminationType() + "'" + "," + "'" + user.getStatus() + "'" + "," + "'" + user.getIsDeleted() + "'" + "," + "'" + user.getDispatch() + "'" + ")"; FtpUtil.sqlFileUpload(sss); // Integer isDeleted = 0; // //注册用户 // User user = new User(); // user.setDeptId(information.getDepartmentid()); // user.setTenantId("000000"); // user.setAccount(record.getEnterprisename()); // String initPassword = ParamCache.getValue(DEFAULT_PARAM_PASSWORD); // user.setPassword(initPassword); // user.setCreateTime(new Date()); // user.setUpdateTime(new Date()); // user.setRoleId("1414575196264300546"); // user.setStatus(1); // user.setIsDeleted(0); // userService.save(user); // String roleid = "1415563428727328770"; // String s = "insert into sys_information(id,creditCode,enterpriseName,representative" + // ",registeredCapital,organizationCode,registrationNumber, enterprises, address," + // " business,region,registration,industry,departmentid,stats,jurisdiction,representativecell," + // "contacts,contactscell,create_time,create_user_id) " + // "values(" + "'" + information.getId() + "'" + // "," + "'" + information.getCreditcode() + "'" + // "," + "'" + information.getEnterprisename() + "'" + // "," + "'" + information.getRepresentative() + "'" + // "," + "'" + information.getRegisteredcapital() + "'" + // "," + "'" + information.getOrganizationcode() + "'" + // "," + "'" + information.getRegistrationnumber() + "'" + // "," + "'" + information.getEnterprises() + "'" + // "," + "'" + information.getAddress() + "'" + // "," + "'" + information.getBusiness() + "'" + // "," + "'" + information.getRegion() + "'" + // "," + "'" + information.getRegistration() + "'" + // "," + "'" + information.getIndustry() + "'" + // "," + "'" + information.getDepartmentid() + "'" + // "," + "'" + information.getStats() + "'" + // "," + "'" + information.getJurisdiction() + "'" + // "," + "'" + information.getRepresentativecell() + "'" + // "," + "'" + information.getContacts() + "'" + // "," + "'" + information.getContactscell() + "'" + // "," + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(information.getCreateTime()) + "'" + // "," + "'" + information.getCreateUserId() + "'" + ");" + // "insert into blade_dept(id,parent_id,tenant_id,dept_name,ancestors,dept_category,is_deleted) values(" + "'" + information.getDepartmentid() + "'" + "," + "'" + dept.getParentId() + "'" + "," // + "'" + dept.getTenantId() + "'" + // "," + "'" + information.getEnterprisename() + "'" + // "," + "'" + dept.getAncestors() + "'" + // "," + "'" + dept.getDeptCategory() + "'" + // "," + "'" + isDeleted + "'" + ");" + // "insert into blade_user(id,tenant_id,account,password,role_id,dept_id,create_time,update_time,status,is_deleted) " + // "values(" + "'" + user.getId() + "'" + // "," + "'" + user.getTenantId() + "'" // + "," + "'" + user.getAccount() + "'" + // "," + "'" + user.getPassword() + "'" + // "," + "'" + roleid + "'" + // "," + "'" + user.getDeptId() + "'" + // "," + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(user.getCreateTime()) + "'" + // "," + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(user.getUpdateTime()) + "'" + // "," + "'" + user.getStatus() + "'" + // "," + "'" + user.getIsDeleted() + "'" + ")"; // FtpUtil.sqlFileUpload(s); // //注册用户 // User user = new User(); // user.setAccount(record.getEnterprisename()); // String initPassword = ParamCache.getValue(DEFAULT_PARAM_PASSWORD); // user.setPassword(initPassword); // boolean b = userService.saveOrUpdate(user); //把附件添加单位id attachService.updat(information.getDepartmentid(), record.getCardid()); String s1 = "update sys_record set type = " + "'" + record.getType() + "'" + ",papprove = " + "'" + record.getPapprove() + "'" + ",xapprove = " + "'" + record.getXapprove() + "'" + ",sapprove = " + "'" + record.getSapprove() + "'" + ",popinion = " + "'" + record.getPopinion() + "'" + ",sopinion = " + "'" + record.getSopinion() + "'" + ",xopinion = " + "'" + record.getXopinion() + "'" + ",ptime = " + "'" + record.getPtime() + "'" + ",stime = " + "'" + record.getStime() + "'" + ",xtime = " + "'" + record.getXtime() + "'" + " " + "where id = " + "'" + record.getId() + "'"; FtpUtil.sqlFileUpload(s1); } else { String s1 = "update sys_record set type = " + "'" + record.getType() + "'" + ",papprove = " + "'" + record.getPapprove() + "'" + ",xapprove = " + "'" + record.getXapprove() + "'" + ",sapprove = " + "'" + record.getSapprove() + "'" + ",popinion = " + "'" + record.getPopinion() + "'" + ",sopinion = " + "'" + record.getSopinion() + "'" + ",xopinion = " + "'" + record.getXopinion() + "'" + ",ptime = " + "'" + record.getPtime() + "'" + ",stime = " + "'" + record.getStime() + "'" + ",xtime = " + "'" + record.getXtime() + "'" + " " + "where id = " + "'" + record.getId() + "'"; FtpUtil.sqlFileUpload(s1); } return R.status(recordService.saveOrUpdate(record)); } /** * 新增或修改 */ @PostMapping("/submit") @ApiOperationSupport(order = 6) @ApiOperation(value = "新增或修改", notes = "传入record") public R submit(@Valid @RequestBody RecordLegalperson record) { return R.status(recordService.saveOrUpdate(record)); } /** * 删除 */ @PostMapping("/remove") @ApiOperationSupport(order = 8) @ApiOperation(value = "删除", notes = "传入ids") public R remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) { return R.status(recordService.removeByIds(Func.toLongList(ids))); } @PostMapping("/selectIn") public R selectIn(String cardid, String type) { Map map = recordService.selectIn(cardid, type); return R.data(map); } } src/main/java/org/springblade/modules/recordLegalperson/dto/RecordLegalpersonDTO.java
New file @@ -0,0 +1,34 @@ /* * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * * Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright * notice, this list of conditions and the following disclaimer in the * documentation and/or other materials provided with the distribution. * Neither the name of the dreamlu.net developer nor the names of its * contributors may be used to endorse or promote products derived from * this software without specific prior written permission. * Author: Chill 庄骞 (smallchill@163.com) */ package org.springblade.modules.recordLegalperson.dto; import lombok.Data; import lombok.EqualsAndHashCode; import org.springblade.modules.recordLegalperson.entity.RecordLegalperson; /** * 数据传输对象实体类 * * @author BladeX * @since 2021-07-12 */ @Data @EqualsAndHashCode(callSuper = true) public class RecordLegalpersonDTO extends RecordLegalperson { private static final long serialVersionUID = 1L; } src/main/java/org/springblade/modules/recordLegalperson/entity/RecordLegalperson.java
New file @@ -0,0 +1,203 @@ /* * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * * Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright * notice, this list of conditions and the following disclaimer in the * documentation and/or other materials provided with the distribution. * Neither the name of the dreamlu.net developer nor the names of its * contributors may be used to endorse or promote products derived from * this software without specific prior written permission. * Author: Chill 庄骞 (smallchill@163.com) */ package org.springblade.modules.recordLegalperson.entity; import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.annotation.TableField; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import com.fasterxml.jackson.annotation.JsonFormat; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import org.springframework.format.annotation.DateTimeFormat; import java.io.Serializable; import java.util.Date; /** * 实体类 * * @author BladeX * @since 2021-07-12 */ @Data @TableName("sys_record_legalperson") @ApiModel(value = "Record对象", description = "Record对象") public class RecordLegalperson implements Serializable { private static final long serialVersionUID = 1L; /** * 统一社会信用代码 */ @ApiModelProperty(value = "统一社会信用代码") @TableField("creditCode") private String creditcode; /** * 企业名称 */ @ApiModelProperty(value = "企业名称") @TableField("enterpriseName") private String enterprisename; /** * 法定代表人 */ @ApiModelProperty(value = "法定代表人") private String representative; /** * 成立日期 */ @ApiModelProperty(value = "注册时间") @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8") @DateTimeFormat(pattern = "yyyy-MM-dd") private Date establishtime; /** * 注册资本 */ @ApiModelProperty(value = "注册资本") @TableField("registeredCapital") private String registeredcapital; /** * 组织机构代码 */ @ApiModelProperty(value = "组织机构代码") @TableField("organizationCode") private String organizationcode; /** * 工商注册号 */ @ApiModelProperty(value = "工商注册号") @TableField("registrationNumber") private String registrationnumber; /** * 纳税人识别号 */ @ApiModelProperty(value = "纳税人识别号") @TableField("identificationNumber") private String identificationnumber; /** * 企业类型 */ @ApiModelProperty(value = "企业类型") private String enterprises; /** * 注册地址 */ @ApiModelProperty(value = "注册地址") private String address; /** * 经营范围 */ @ApiModelProperty(value = "经营范围") private String business; /** * 所属地区 */ @ApiModelProperty(value = "所属地区") private String region; /** * 登记机关 */ @ApiModelProperty(value = "登记机关") private String registration; /** * 所属行业 */ @ApiModelProperty(value = "所属行业") private String industry; /** * 状态 0:审核通过 1：审核不通过 2: 审核中 */ @ApiModelProperty(value = "状态 0:审核通过 1：审核不通过 2: 审核中") private String type; /** * 保安服务单位许可编号 */ @ApiModelProperty(value = "保安服务单位许可编号") private String perid; /** * 许可发证机关 */ @ApiModelProperty(value = "许可发证机关") private String offices; /** * 发证时间 */ @ApiModelProperty(value = "发证时间") @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8") @DateTimeFormat(pattern = "yyyy-MM-dd") private Date officetime; @TableId(value = "id", type = IdType.AUTO) private Integer id; private String deptid; private String ptype; @ApiModelProperty(value = "提交时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date permitime; private String approve; private String cardid; private String representativecell; private String contacts; private String contactscell; private String storage; private String jurisdiction; //派出所审批 private String papprove; //县审批 private String xapprove; //市审批 private String sapprove; //派出意见 private String popinion; //县意见 private String xopinion; //市意见 private String sopinion; @ApiModelProperty(value = "审批时间") @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8") @DateTimeFormat(pattern = "yyyy-MM-dd") private Date overtime; @ApiModelProperty(value = "派出所审批时间") @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date ptime; @ApiModelProperty(value = "县审批时间") @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date stime; @ApiModelProperty(value = "市审批时间") @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date xtime; //更变后法人 private String changecontacts; //更变后法人电话 private String changecontactscell; } src/main/java/org/springblade/modules/recordLegalperson/mapper/RecordLegalpersonMapper.java
New file @@ -0,0 +1,45 @@ /* * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * * Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright * notice, this list of conditions and the following disclaimer in the * documentation and/or other materials provided with the distribution. * Neither the name of the dreamlu.net developer nor the names of its * contributors may be used to endorse or promote products derived from * this software without specific prior written permission. * Author: Chill 庄骞 (smallchill@163.com) */ package org.springblade.modules.recordLegalperson.mapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.core.metadata.IPage; import org.apache.ibatis.annotations.Param; import org.springblade.modules.recordLegalperson.entity.RecordLegalperson; import org.springblade.modules.recordLegalperson.vo.RecordLegalpersonVO; import java.util.List; import java.util.Map; /** * Mapper 接口 * * @author BladeX * @since 2021-07-12 */ public interface RecordLegalpersonMapper extends BaseMapper<RecordLegalperson> { /** * 自定义分页 * * @param page * @param record * @return */ List<RecordLegalpersonVO> selectRecordPage(IPage page, @Param("record") RecordLegalpersonVO record, String jurisdiction); Map selectIn(String cardid,String type); } src/main/java/org/springblade/modules/recordLegalperson/mapper/RecordLegalpersonMapper.xml
New file @@ -0,0 +1,79 @@ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="org.springblade.modules.recordLegalperson.mapper.RecordLegalpersonMapper"> <!-- 通用查询映射结果 --> <resultMap id="RecordLegalpersonMapper" type="org.springblade.modules.recordLegalperson.entity.RecordLegalperson"> <id column="id" property="id"/> <result column="creditCode" property="creditcode"/> <result column="enterpriseName" property="enterprisename"/> <result column="representative" property="representative"/> <result column="establishtime" property="establishtime"/> <result column="registeredCapital" property="registeredcapital"/> <result column="organizationCode" property="organizationcode"/> <result column="registrationNumber" property="registrationnumber"/> <result column="identificationNumber" property="identificationnumber"/> <result column="enterprises" property="enterprises"/> <result column="address" property="address"/> <result column="business" property="business"/> <result column="region" property="region"/> <result column="registration" property="registration"/> <result column="industry" property="industry"/> <result column="type" property="type"/> <result column="perid" property="perid"/> <result column="offices" property="offices"/> <result column="officetime" property="officetime"/> <result column="deptid" property="deptid"/> <result column="permitime" property="permitime"/> <result column="ptype" property="ptype"/> <result column="cardid" property="cardid"/> <result column="representativecell" property="representativecell"/> <result column="contacts" property="contacts"/> <result column="contactscell" property="contactscell"/> <result column="storage" property="storage"/> <result column="jurisdiction" property="jurisdiction"/> <result column="papprove" property="papprove"/> <result column="xapprove" property="xapprove"/> <result column="sapprove" property="sapprove"/> <result column="popinion" property="popinion"/> <result column="xopinion" property="xopinion"/> <result column="sopinion" property="sopinion"/> <result column="overtime" property="overtime"/> <result column="ptime" property="ptime"/> <result column="stime" property="stime"/> <result column="xtime" property="xtime"/> <result column="changecontacts" property="changecontacts"/> <result column="changecontactscell" property="changecontactscell"/> </resultMap> <select id="selectRecordPage" resultMap="RecordLegalpersonMapper"> select * from sys_record_legalperson si left join sys_jurisdiction sj on sj.id = si.jurisdiction where 1=1 <if test="record.ptype!=null and record.ptype!=''"> and ptype=#{record.ptype} </if> <if test="record.jurisdiction!=null and record.jurisdiction != '' and record.jurisdiction!='1372091709474910209'"> and (sj.id = #{record.jurisdiction} or sj.parent_id = #{record.jurisdiction}) </if> <if test="record.papprove!=null and record.papprove!=''"> and papprove=#{record.papprove} </if> <if test="record.xapprove!=null and record.xapprove!=''"> and xapprove=#{record.xapprove} </if> <if test="record.sapprove!=null and record.sapprove!=''"> and sapprove=#{record.sapprove} </if> </select> <select id="selectIn" resultType="java.util.HashMap"> select * from sys_record_legalperson where cardid = #{cardid} and ptype = #{type} </select> </mapper> src/main/java/org/springblade/modules/recordLegalperson/service/IRecordLegalpersonService.java
New file @@ -0,0 +1,44 @@ /* * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * * Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright * notice, this list of conditions and the following disclaimer in the * documentation and/or other materials provided with the distribution. * Neither the name of the dreamlu.net developer nor the names of its * contributors may be used to endorse or promote products derived from * this software without specific prior written permission. * Author: Chill 庄骞 (smallchill@163.com) */ package org.springblade.modules.recordLegalperson.service; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.service.IService; import org.apache.ibatis.annotations.Param; import org.springblade.modules.recordLegalperson.entity.RecordLegalperson; import org.springblade.modules.recordLegalperson.vo.RecordLegalpersonVO; import java.util.Map; /** * 服务类 * * @author BladeX * @since 2021-07-12 */ public interface IRecordLegalpersonService extends IService<RecordLegalperson> { /** * 自定义分页 * * @param page * @param record * @return */ IPage<RecordLegalpersonVO> selectRecordPage(IPage<RecordLegalpersonVO> page, @Param("record") RecordLegalpersonVO record, String jurisdiction); Map selectIn(String cardid,String type); } src/main/java/org/springblade/modules/recordLegalperson/service/impl/RecordLegalpersonServiceImpl.java
New file @@ -0,0 +1,48 @@ /* * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * * Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright * notice, this list of conditions and the following disclaimer in the * documentation and/or other materials provided with the distribution. * Neither the name of the dreamlu.net developer nor the names of its * contributors may be used to endorse or promote products derived from * this software without specific prior written permission. * Author: Chill 庄骞 (smallchill@163.com) */ package org.springblade.modules.recordLegalperson.service.impl; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import org.springblade.modules.recordLegalperson.entity.RecordLegalperson; import org.springblade.modules.recordLegalperson.mapper.RecordLegalpersonMapper; import org.springblade.modules.recordLegalperson.service.IRecordLegalpersonService; import org.springblade.modules.recordLegalperson.vo.RecordLegalpersonVO; import org.springframework.stereotype.Service; import java.util.Map; /** * 服务实现类 * * @author BladeX * @since 2021-07-12 */ @Service public class RecordLegalpersonServiceImpl extends ServiceImpl<RecordLegalpersonMapper, RecordLegalperson> implements IRecordLegalpersonService { @Override public IPage<RecordLegalpersonVO> selectRecordPage(IPage<RecordLegalpersonVO> page, RecordLegalpersonVO record, String jurisdiction) { return page.setRecords(baseMapper.selectRecordPage(page, record,jurisdiction)); } @Override public Map selectIn(String cardid,String type) { return baseMapper.selectIn(cardid,type); } } src/main/java/org/springblade/modules/recordLegalperson/vo/RecordLegalpersonVO.java
New file @@ -0,0 +1,36 @@ /* * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * * Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright * notice, this list of conditions and the following disclaimer in the * documentation and/or other materials provided with the distribution. * Neither the name of the dreamlu.net developer nor the names of its * contributors may be used to endorse or promote products derived from * this software without specific prior written permission. * Author: Chill 庄骞 (smallchill@163.com) */ package org.springblade.modules.recordLegalperson.vo; import io.swagger.annotations.ApiModel; import lombok.Data; import lombok.EqualsAndHashCode; import org.springblade.modules.recordLegalperson.entity.RecordLegalperson; /** * 视图实体类 * * @author BladeX * @since 2021-07-12 */ @Data @EqualsAndHashCode(callSuper = true) @ApiModel(value = "RecordVO对象", description = "RecordVO对象") public class RecordLegalpersonVO extends RecordLegalperson { private static final long serialVersionUID = 1L; private String usetype; } src/main/java/org/springblade/modules/recordk/controller/RecordkController.java
@@ -42,7 +42,7 @@ import java.util.Map; /** * 控制器 * 控制器 * * @author BladeX * @since 2021-07-12 @@ -55,6 +55,7 @@ private final IRecordkService recordkService; private final IInformationService informationService; /** * 详情 */ @@ -86,7 +87,7 @@ @ApiOperation(value = "分页", notes = "传入recordk") public R<IPage<RecordkVO>> page(RecordkVO recordk, Query query) { IPage<RecordkVO> pages; pages = recordkService.selectRecordkPage(Condition.getPage(query), recordk,recordk.getJurisdiction()); pages = recordkService.selectRecordkPage(Condition.getPage(query), recordk, recordk.getJurisdiction()); // if (recordk.getUsetype().equals("0")) { // pages = recordkService.selectRecordkPage(Condition.getPage(query), recordk,null); // } else if (recordk.getUsetype().equals("1")) { @@ -113,8 +114,8 @@ public R save(@Valid @RequestBody Recordk recordk) { String cardid = recordk.getCardid(); String ptype = recordk.getPtype(); Map map = recordkService.selectIn(cardid,ptype); if (map!=null){ Map map = recordkService.selectIn(cardid, ptype); if (map != null) { String id = map.get("id").toString(); recordkService.removeByIds(Func.toLongList(id)); } @@ -125,30 +126,56 @@ //String offtime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(recordk.getOfficetime()); //String pertime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(recordk.getPermitime()); String s = "insert into sys_recordk(id,creditCode,enterpriseName,representative," + "address,business,region,registration,industry,type,deptid,ptype,representativecell,contacts,contactscell,cardid,overtime,jurisdiction)" + "values(" + "'" + recordk.getId() + "'" + "," + "'" + recordk.getCreditcode() + "'" + "," + "'" + recordk.getEnterprisename() + "'" + "," + "'" + recordk.getRepresentative() + "'" +"," + "'" + "address,business,region,registration,industry,type,deptid,ptype,representativecell,contacts,contactscell,cardid,overtime," + "jurisdiction," + "ksecuritys," + "kproject," + "kzipcode," + "kservicetime," + "kaddress" + ")" + "values(" + "'" + recordk.getId() + "'" + "," + "'" + recordk.getCreditcode() + "'" + "," + "'" + recordk.getEnterprisename() + "'" + "," + "'" + recordk.getRepresentative() + "'" + "," + "'" + recordk.getAddress() + "'" + "," + "'" + recordk.getBusiness() + "'" + "," + "'" + recordk.getRegion() + "'" + "," + "'" + recordk.getRegistration() + "'" + "," + "'" + recordk.getIndustry() + "'" + "," + "'" + recordk.getType() + "'" +"," + "'" + recordk.getDeptid() + "'" + "," + "'" + recordk.getPtype() + "'" + "," + "'" + recordk.getRepresentativecell() + "'" + "," + "'" + recordk.getContacts() + "'" + "," + "'" + recordk.getContactscell() + "'" +"," + "'" + recordk.getCardid() + "'"+"," + "'" + new SimpleDateFormat("yyyy-MM-dd").format(recordk.getOvertime())+ "'" +"," + "'" + recordk.getJurisdiction()+"'"+")"; FtpUtil.sqlFileUpload(s); recordk.getRegion() + "'" + "," + "'" + recordk.getRegistration() + "'" + "," + "'" + recordk.getIndustry() + "'" + "," + "'" + recordk.getType() + "'" + "," + "'" + recordk.getDeptid() + "'" + "," + "'" + recordk.getPtype() + "'" + "," + "'" + recordk.getRepresentativecell() + "'" + "," + "'" + recordk.getContacts() + "'" + "," + "'" + recordk.getContactscell() + "'" + "," + "'" + recordk.getCardid() + "'" + "," + "'" + new SimpleDateFormat("yyyy-MM-dd").format(recordk.getOvertime()) + "'" + "," + "'" + recordk.getJurisdiction() + "'" + "," + "'" + recordk.getKsecuritys() + "'" + "," + "'" + recordk.getKproject() + "'" + "," + "'" + recordk.getKzipcode() + "'" + "," + "'" + recordk.getKservicetime() + "'" + "," + "'" + recordk.getKaddress() + "'" + ")"; // System.out.println(s); // System.out.println(recordk.getKsecuritys()); // System.out.println(recordk.getKproject()); // System.out.println(recordk.getKzipcode()); // System.out.println(recordk.getKservicetime()); // System.out.println(recordk.getKaddress()); // System.out.println(recordk); // FtpUtil.sqlFileUpload(s); return R.success("成功"); } /** *暂存 * 暂存 */ @PostMapping("/recorkstorage") @ApiOperation(value = "新增", notes = "传入permit") public R recorkstorage(@Valid @RequestBody Recordk recordk) { String cardid = recordk.getCardid(); String ptype = recordk.getPtype(); Map map = recordkService.selectIn(cardid,ptype); if (map!=null){ Map map = recordkService.selectIn(cardid, ptype); if (map != null) { recordk.setStorage("0"); recordkService.updateById(recordk); } else { } else { recordk.setStorage("0"); recordk.setPermitime(new Date()); recordkService.save(recordk); @@ -193,8 +220,8 @@ @PostMapping("/selectIn") public R selectIn(String cardid,String type) { Map map = recordkService.selectIn(cardid,type); public R selectIn(String cardid, String type) { Map map = recordkService.selectIn(cardid, type); return R.data(map); }
@@ -167,5 +167,19 @@ private Date overtime; @ApiModelProperty(value = "保安人数") private Integer ksecuritys; @ApiModelProperty(value = "拟跨区域经营的保安服务项目") private String kproject; @ApiModelProperty(value = "邮编") private String kzipcode; @ApiModelProperty(value = "跨区域经营服务时间（备案有效期）") private String kservicetime; @ApiModelProperty(value = "地址") private String kaddress; } src/main/java/org/springblade/modules/recordk/mapper/RecordkMapper.xml
@@ -34,6 +34,12 @@ <result column="storage" property="storage"/> <result column="approve" property="approve"/> <result column="jurisdiction" property="jurisdiction"/> <result column="ksecuritys" property="ksecuritys"/> <result column="kproject" property="kproject"/> <result column="kzipcode" property="kzipcode"/> <result column="kservicetime" property="kservicetime"/> <result column="kaddress" property="kaddress"/> </resultMap>
@@ -17,6 +17,7 @@ package org.springblade.modules.recordk.vo; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import lombok.EqualsAndHashCode; import org.springblade.modules.recordk.entity.Recordk; src/main/resources/application-test.yml
@@ -40,7 +40,7 @@ #ftp 设置 ftp: sqlConnect: jdbc:mysql://223.82.109.183:2083/zhbaw-test?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true ftpHost: 192.168.0.199 ftpHost: 192.168.0.198 ftpPort: 21 ftpUserName: arsn ftpPassword: 123456
