| | |
| | | @GeneratedValue(strategy = GenerationType.IDENTITY) |
| | | private Long id; |
| | | private String name; |
| | | private String manager; |
| | | private String tel; |
| | | private String email; |
| | | private String memo; |
| | |
| | | this.name = name; |
| | | } |
| | | |
| | | public String getManager() { |
| | | return manager; |
| | | } |
| | | |
| | | public void setManager(String manager) { |
| | | this.manager = manager; |
| | | } |
| | | |
| | | public String getTel() { |
| | | return tel; |
| | | } |
| | |
| | | // code_ko_KR 에 code명 설정 |
| | | ExportExcelVo excelInfo = new ExportExcelVo(); |
| | | excelInfo.setFileName(this.messageAccessor.message("업체 목록")); |
| | | excelInfo.addAttrInfos(new ExportExcelAttrVo("companyName", this.messageAccessor.message("departmentManage.departmentName"), 6, ExportExcelAttrVo.ALIGN_CENTER)); |
| | | excelInfo.addAttrInfos(new ExportExcelAttrVo("", this.messageAccessor.message("departmentManage.departmentDescription"), 10, ExportExcelAttrVo.ALIGN_CENTER)); |
| | | excelInfo.addAttrInfos(new ExportExcelAttrVo("companyPhone", this.messageAccessor.message("departmentManage.departmentCount"), 10, ExportExcelAttrVo.ALIGN_CENTER)); |
| | | excelInfo.addAttrInfos(new ExportExcelAttrVo("companyEmail", this.messageAccessor.message("departmentManage.departmentCount"), 10, ExportExcelAttrVo.ALIGN_CENTER)); |
| | | excelInfo.addAttrInfos(new ExportExcelAttrVo("companyDesc", this.messageAccessor.message("departmentManage.departmentCount"), 10, ExportExcelAttrVo.ALIGN_CENTER)); |
| | | excelInfo.addAttrInfos(new ExportExcelAttrVo("companyName", this.messageAccessor.message("companyField.companyName"), 6, ExportExcelAttrVo.ALIGN_CENTER)); |
| | | excelInfo.addAttrInfos(new ExportExcelAttrVo("companyManager", this.messageAccessor.message("companyField.companyManager"), 10, ExportExcelAttrVo.ALIGN_CENTER)); |
| | | excelInfo.addAttrInfos(new ExportExcelAttrVo("companyTel", this.messageAccessor.message("companyField.companyTel"), 10, ExportExcelAttrVo.ALIGN_CENTER)); |
| | | excelInfo.addAttrInfos(new ExportExcelAttrVo("companyEmail", this.messageAccessor.message("companyField.companyEmail"), 10, ExportExcelAttrVo.ALIGN_CENTER)); |
| | | excelInfo.addAttrInfos(new ExportExcelAttrVo("companyMemo", this.messageAccessor.message("companyField.companyMemo"), 10, ExportExcelAttrVo.ALIGN_CENTER)); |
| | | |
| | | excelInfo.setDatas(companyFieldVos); |
| | | |
| | |
| | | |
| | | private Long id; |
| | | private String name; |
| | | private String manager; |
| | | private String tel; |
| | | private String email; |
| | | private String memo; |
| | | |
| | | public CompanyFieldVo() {} |
| | | |
| | | public CompanyFieldVo(Long id, String name, String tel, String email, String memo) { |
| | | public CompanyFieldVo(Long id, String name, String manager, String tel, String email, String memo) { |
| | | |
| | | this.id = id; |
| | | this.name = name; |
| | | this.manager = manager; |
| | | this.tel = tel; |
| | | this.email = email; |
| | | this.memo = memo; |
| | |
| | | this.name = name; |
| | | } |
| | | |
| | | public String getManager() { |
| | | return manager; |
| | | } |
| | | |
| | | public void setManager(String manager) { |
| | | this.manager = manager; |
| | | } |
| | | |
| | | public String getTel() { |
| | | return tel; |
| | | } |
| | |
| | | public class CompanyFieldCondition { |
| | | private Long id; |
| | | private String name; |
| | | private String companyType; |
| | | private String profitYN; |
| | | private String industry; |
| | | private String domain; |
| | | private String email; |
| | | private String manager; |
| | | private String tel; |
| | | private String desc; |
| | | private String email; |
| | | private String memo; |
| | | |
| | | private Integer Page; |
| | | private Integer PageSize; |
| | |
| | | this.name = name; |
| | | } |
| | | |
| | | public String getCompanyType() { |
| | | return companyType; |
| | | public String getManager() { |
| | | return manager; |
| | | } |
| | | |
| | | public void setCompanyType(String companyType) { |
| | | this.companyType = companyType; |
| | | } |
| | | |
| | | public String getProfitYN() { |
| | | return profitYN; |
| | | } |
| | | |
| | | public void setProfitYN(String profitYN) { |
| | | this.profitYN = profitYN; |
| | | } |
| | | |
| | | public String getIndustry() { |
| | | return industry; |
| | | } |
| | | |
| | | public void setIndustry(String industry) { |
| | | this.industry = industry; |
| | | } |
| | | |
| | | public String getDomain() { |
| | | return domain; |
| | | } |
| | | |
| | | public void setDomain(String domain) { |
| | | this.domain = domain; |
| | | } |
| | | |
| | | public String getEmail() { |
| | | return email; |
| | | } |
| | | |
| | | public void setEmail(String email) { |
| | | this.email = email; |
| | | public void setManager(String manager) { |
| | | this.manager = manager; |
| | | } |
| | | |
| | | public String getTel() { |
| | |
| | | this.tel = tel; |
| | | } |
| | | |
| | | public String getDesc() { |
| | | return desc; |
| | | public String getEmail() { |
| | | return email; |
| | | } |
| | | |
| | | public void setDesc(String desc) { |
| | | this.desc = desc; |
| | | public void setEmail(String email) { |
| | | this.email = email; |
| | | } |
| | | |
| | | public String getMemo() { |
| | | return memo; |
| | | } |
| | | |
| | | public void setMemo(String memo) { |
| | | this.memo = memo; |
| | | } |
| | | |
| | | public Integer getPage() { |
| | |
| | | public class CompanyFieldForm { |
| | | private Long id; |
| | | private String name; |
| | | private String manager; |
| | | private String tel; |
| | | private String email; |
| | | private String memo; |
| | |
| | | this.name = name; |
| | | } |
| | | |
| | | public String getManager() { |
| | | return manager; |
| | | } |
| | | |
| | | public void setManager(String manager) { |
| | | this.manager = manager; |
| | | } |
| | | |
| | | public String getTel() { |
| | | return tel; |
| | | } |
| | |
| | | SELECT |
| | | cf.id as id, |
| | | cf.name as name, |
| | | cf.manager as manager, |
| | | cf.tel as tel, |
| | | cf.email as email, |
| | | cf.memo as memo |
| | |
| | | departmentManage.departmentName=\uBD80\uC11C\uBA85 |
| | | departmentManage.departmentDescription=\uBD80\uC11C\uC124\uBA85 |
| | | departmentManage.departmentCount=\uBD80\uC11C\uC778\uC6D0 |
| | | companyField.companyName=\uC5C5\uCCB4\uBA85 |
| | | companyField.companyManager=\uB2F4\uB2F9\uC790 |
| | | companyField.companyTel=\uC804\uD654\uBC88\uD638 |
| | | companyField.companyEmail=\uC774\uBA54\uC77C |
| | | companyField.companyMemo=\uBE44\uACE0 |