From 567556af0acaf45329ec79b9fb40cdb9388939fd Mon Sep 17 00:00:00 2001 From: wyu <kknd09321@nate.com> Date: 월, 08 11월 2021 17:13:47 +0900 Subject: [PATCH] 업체 관리 백엔드 수정 --- src/main/java/kr/wisestone/owl/domain/CompanyField.java | 56 ++----------- src/main/resources/migration/V1_11__Alter_Table.sql | 8 - src/main/java/kr/wisestone/owl/web/condition/CompanyFieldCondition.java | 10 +- src/main/resources/mybatis/query-template/companyField-template.xml | 4 src/main/java/kr/wisestone/owl/web/form/CompanyFieldForm.java | 56 ++----------- src/main/java/kr/wisestone/owl/vo/CompanyFieldVo.java | 66 +++------------- 6 files changed, 42 insertions(+), 158 deletions(-) diff --git a/src/main/java/kr/wisestone/owl/domain/CompanyField.java b/src/main/java/kr/wisestone/owl/domain/CompanyField.java index df714bc..77b14c1 100644 --- a/src/main/java/kr/wisestone/owl/domain/CompanyField.java +++ b/src/main/java/kr/wisestone/owl/domain/CompanyField.java @@ -14,13 +14,9 @@ @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; private String name; - private String companyType; - private String profitYN; - private String industy; - private String domain; - private String email; private String tel; - private String desc; + private String email; + private String memo; public CompanyField() {} @@ -40,36 +36,12 @@ this.name = name; } - public String getCompanyType() { - return companyType; + public String getTel() { + return tel; } - public void setCompanyType(String companyType) { - this.companyType = companyType; - } - - public String getProfitYN() { - return profitYN; - } - - public void setProfitYN(String profitYN) { - this.profitYN = profitYN; - } - - public String getIndusty() { - return industy; - } - - public void setIndusty(String industy) { - this.industy = industy; - } - - public String getDomain() { - return domain; - } - - public void setDomain(String domain) { - this.domain = domain; + public void setTel(String tel) { + this.tel = tel; } public String getEmail() { @@ -80,19 +52,11 @@ this.email = email; } - public String getTel() { - return tel; + public String getMemo() { + return memo; } - public void setTel(String tel) { - this.tel = tel; - } - - public String getDesc() { - return desc; - } - - public void setDesc(String desc) { - this.desc = desc; + public void setMemo(String memo) { + this.memo = memo; } } diff --git a/src/main/java/kr/wisestone/owl/vo/CompanyFieldVo.java b/src/main/java/kr/wisestone/owl/vo/CompanyFieldVo.java index 9fd52a1..89ce21a 100644 --- a/src/main/java/kr/wisestone/owl/vo/CompanyFieldVo.java +++ b/src/main/java/kr/wisestone/owl/vo/CompanyFieldVo.java @@ -4,27 +4,19 @@ private Long id; private String name; - private String companyType; - private String profitYN; - private String industy; - private String domain; - private String email; private String tel; - private String desc; + private String email; + private String memo; public CompanyFieldVo() {} - public CompanyFieldVo(Long id, String name, String companyType, String profitYN, String industy, String domain, String email, String tel, String desc) { + public CompanyFieldVo(Long id, String name, String tel, String email, String memo) { this.id = id; this.name = name; - this.companyType = companyType; - this.profitYN = profitYN; - this.industy = industy; - this.domain = domain; - this.email = email; this.tel = tel; - this.desc = desc; + this.email = email; + this.memo = memo; } public Long getId() { @@ -43,36 +35,12 @@ this.name = name; } - public String getCompanyType() { - return companyType; + public String getTel() { + return tel; } - public void setCompanyType(String companyType) { - this.companyType = companyType; - } - - public String getProfitYN() { - return profitYN; - } - - public void setProfitYN(String profitYN) { - this.profitYN = profitYN; - } - - public String getIndusty() { - return industy; - } - - public void setIndusty(String industy) { - this.industy = industy; - } - - public String getDomain() { - return domain; - } - - public void setDomain(String domain) { - this.domain = domain; + public void setTel(String tel) { + this.tel = tel; } public String getEmail() { @@ -83,19 +51,11 @@ this.email = email; } - public String getTel() { - return tel; + public String getMemo() { + return memo; } - public void setTel(String tel) { - this.tel = tel; - } - - public String getDesc() { - return desc; - } - - public void setDesc(String desc) { - this.desc = desc; + public void setMemo(String memo) { + this.memo = memo; } } diff --git a/src/main/java/kr/wisestone/owl/web/condition/CompanyFieldCondition.java b/src/main/java/kr/wisestone/owl/web/condition/CompanyFieldCondition.java index 9385756..9a8f1e9 100644 --- a/src/main/java/kr/wisestone/owl/web/condition/CompanyFieldCondition.java +++ b/src/main/java/kr/wisestone/owl/web/condition/CompanyFieldCondition.java @@ -9,7 +9,7 @@ private String name; private String companyType; private String profitYN; - private String industy; + private String industry; private String domain; private String email; private String tel; @@ -54,12 +54,12 @@ this.profitYN = profitYN; } - public String getIndusty() { - return industy; + public String getIndustry() { + return industry; } - public void setIndusty(String industy) { - this.industy = industy; + public void setIndustry(String industry) { + this.industry = industry; } public String getDomain() { diff --git a/src/main/java/kr/wisestone/owl/web/form/CompanyFieldForm.java b/src/main/java/kr/wisestone/owl/web/form/CompanyFieldForm.java index 786003e..a872e89 100644 --- a/src/main/java/kr/wisestone/owl/web/form/CompanyFieldForm.java +++ b/src/main/java/kr/wisestone/owl/web/form/CompanyFieldForm.java @@ -10,13 +10,9 @@ public class CompanyFieldForm { private Long id; private String name; - private String companyType; - private String profitYN; - private String industy; - private String domain; - private String email; private String tel; - private String desc; + private String email; + private String memo; private List<Long> removeIds = Lists.newArrayList(); public CompanyFieldForm() { @@ -46,36 +42,12 @@ this.name = name; } - public String getCompanyType() { - return companyType; + public String getTel() { + return tel; } - public void setCompanyType(String companyType) { - this.companyType = companyType; - } - - public String getProfitYN() { - return profitYN; - } - - public void setProfitYN(String profitYN) { - this.profitYN = profitYN; - } - - public String getIndusty() { - return industy; - } - - public void setIndusty(String industy) { - this.industy = industy; - } - - public String getDomain() { - return domain; - } - - public void setDomain(String domain) { - this.domain = domain; + public void setTel(String tel) { + this.tel = tel; } public String getEmail() { @@ -86,20 +58,12 @@ this.email = email; } - public String getTel() { - return tel; + public String getMemo() { + return memo; } - public void setTel(String tel) { - this.tel = tel; - } - - public String getDesc() { - return desc; - } - - public void setDesc(String desc) { - this.desc = desc; + public void setMemo(String memo) { + this.memo = memo; } public List<Long> getRemoveIds() { diff --git a/src/main/resources/migration/V1_11__Alter_Table.sql b/src/main/resources/migration/V1_11__Alter_Table.sql index 024844b..85df95e 100644 --- a/src/main/resources/migration/V1_11__Alter_Table.sql +++ b/src/main/resources/migration/V1_11__Alter_Table.sql @@ -1,13 +1,9 @@ CREATE TABLE `company`( `id` BIGINT(11) AUTO_INCREMENT, `name` VARCHAR(50) NOT NULL, - `company_type` VARCHAR(50) NOT NULL, - `profit_yn` VARCHAR(50) NOT NULL, - `industry` VARCHAR(50) NOT NULL, - `domain` VARCHAR(255) NOT NULL, - `email` VARCHAR (255) NOT NULL, `tel` VARCHAR (50) NOT NULL, - `desc` VARCHAR(255) NOT NULL, + `email` VARCHAR (255) NOT NULL, + `memo` VARCHAR(255) NOT NULL, `register_date` TIMESTAMP NULL, `modify_id` BIGINT(20) NOT NULL, `modify_date` TIMESTAMP NULL, diff --git a/src/main/resources/mybatis/query-template/companyField-template.xml b/src/main/resources/mybatis/query-template/companyField-template.xml index 0aac445..4dd9d58 100644 --- a/src/main/resources/mybatis/query-template/companyField-template.xml +++ b/src/main/resources/mybatis/query-template/companyField-template.xml @@ -7,9 +7,9 @@ SELECT c.id as id, c.name as name, - c.email as email, c.tel as tel, - c.desc as desc + c.email as email, + c.memo as memo FROM company c WHERE 1=1 -- Gitblit v1.8.0