| | |
| | | @Schema(description = "公司地址", example = "上海市浦东新区XX路XX号") |
| | | private String address; |
| | | |
| | | @Schema(description = "开户银行", example = "中国工商银行上海分行") |
| | | private String bankName; |
| | | |
| | | @Schema(description = "银行账号", example = "622202xxxxxxxxxxxx") |
| | | private String bankAccount; |
| | | |
| | | @Schema(description = "联系人", example = "张三") |
| | | private String contactName; |
| | | |
| | |
| | | @Schema(description = "邮箱", example = "zhangsan@example.com") |
| | | private String contactEmail; |
| | | |
| | | @Schema(description = "备注", example = "优先供货") |
| | | private String remark; |
| | | |
| | | @Schema(description = "申请人ID", example = "1") |
| | | private Long applyUserId; |
| | | |
| | |
| | | @Schema(description = "公司地址", example = "上海市浦东新区XX路XX号") |
| | | private String address; |
| | | |
| | | @Schema(description = "开户银行", example = "中国工商银行上海分行") |
| | | private String bankName; |
| | | |
| | | @Schema(description = "银行账号", example = "622202xxxxxxxxxxxx") |
| | | private String bankAccount; |
| | | |
| | | @Schema(description = "联系人", example = "张三") |
| | | private String contactName; |
| | | |
| | |
| | | @Schema(description = "邮箱", example = "zhangsan@example.com") |
| | | private String contactEmail; |
| | | |
| | | @Schema(description = "备注", example = "优先供货") |
| | | private String remark; |
| | | |
| | | } |
| | |
| | | import com.baomidou.mybatisplus.annotation.KeySequence; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import com.baomidou.mybatisplus.annotation.TableField; |
| | | import lombok.*; |
| | | |
| | | import java.math.BigDecimal; |
| | |
| | | private String businessLicenseNo; |
| | | private String taxNo; |
| | | private String address; |
| | | private String bankName; |
| | | private String bankAccount; |
| | | private String contactName; |
| | | private String contactMobile; |
| | | private String contactEmail; |
| | |
| | | private Long financeReviewerId; |
| | | private LocalDateTime financeReviewTime; |
| | | private String financeReviewOpinion; |
| | | private String remark; |
| | | |
| | | } |
| | |
| | | supplier.setBusinessLicenseNo(apply.getBusinessLicenseNo()); |
| | | supplier.setTaxNo(apply.getTaxNo()); |
| | | supplier.setAddress(apply.getAddress()); |
| | | supplier.setBankName(apply.getBankName()); |
| | | supplier.setBankAccount(apply.getBankAccount()); |
| | | supplier.setContactName(apply.getContactName()); |
| | | supplier.setContactMobile(apply.getContactMobile()); |
| | | supplier.setContactEmail(apply.getContactEmail()); |
| | | supplier.setRemark(apply.getRemark()); |
| | | supplier.setStatus(0); |
| | | supplierMapper.insert(supplier); |
| | | |
| | |
| | | business_license_no VARCHAR(100) DEFAULT NULL COMMENT '营业执照编号', |
| | | tax_no VARCHAR(100) DEFAULT NULL COMMENT '税号', |
| | | address VARCHAR(500) DEFAULT NULL COMMENT '公司地址', |
| | | bank_name VARCHAR(255) DEFAULT NULL COMMENT '开户银行', |
| | | bank_account VARCHAR(100) DEFAULT NULL COMMENT '银行账号', |
| | | contact_name VARCHAR(50) DEFAULT NULL COMMENT '联系人', |
| | | contact_mobile VARCHAR(20) DEFAULT NULL COMMENT '联系电话', |
| | | contact_email VARCHAR(100) DEFAULT NULL COMMENT '邮箱', |
| | |
| | | finance_reviewer_id BIGINT DEFAULT NULL COMMENT '财务审核人ID', |
| | | finance_review_time DATETIME DEFAULT NULL COMMENT '财务审核时间', |
| | | finance_review_opinion VARCHAR(500) DEFAULT NULL COMMENT '财务审核意见', |
| | | remark VARCHAR(500) DEFAULT NULL COMMENT '备注', |
| | | creator VARCHAR(64) DEFAULT '' COMMENT '创建者', |
| | | create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', |
| | | updater VARCHAR(64) DEFAULT '' COMMENT '更新者', |
| | |
| | | KEY idx_supplier_id (supplier_id), |
| | | KEY idx_purchase_order_id (purchase_order_id) |
| | | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='定标记录表'; |
| | | |