| | |
| | | private String accountHolder; |
| | | private String accountNumber; |
| | | private String branchName; |
| | | private Integer status; |
| | | |
| | | private String avatar; |
| | | private String loginAccount; |
| | | } |
| | |
| | | ClinicDetailVO vo = new ClinicDetailVO(); |
| | | vo.setId(row.getId()); |
| | | vo.setName(row.getName()); |
| | | vo.setStatus(row.getStatus()); |
| | | vo.setPhone(defaultText(row.getContactPhone())); |
| | | vo.setAddress(defaultText(row.getAddress())); |
| | | vo.setBusinessLicenseUrl(trimToNull(row.getBusinessLicenseUrl())); |
| | |
| | | vo.setAccountHolder(defaultText(row.getAccountHolder())); |
| | | vo.setAccountNumber(defaultText(row.getAccountNumber())); |
| | | vo.setBranchName(defaultText(row.getBranchName())); |
| | | vo.setAvatar(row.getAvatar()); |
| | | vo.setLoginAccount(row.getLoginAccount()); |
| | | return vo; |
| | | } |
| | | |
| | |
| | | private String accountHolder; |
| | | private String accountNumber; |
| | | private String branchName; |
| | | |
| | | private String avatar; |
| | | private String loginAccount; |
| | | private Integer status; |
| | | } |
| | |
| | | c.business_license_url AS businessLicenseUrl, |
| | | c.bank_name AS bankName, c.account_holder AS accountHolder, |
| | | c.account_number AS accountNumber, c.branch_name AS branchName, |
| | | c.status, |
| | | u.phone AS loginAccount, u.avatar AS avatar, |
| | | COUNT(u.id) AS userCount |
| | | FROM tcm_clinic c |
| | | LEFT JOIN tcm_app_user u ON u.clinic_id = c.id AND u.deleted = 0 |
| | | WHERE c.deleted = 0 AND c.id = #{id} |
| | | GROUP BY c.id, c.name, c.contact_phone, c.address, c.business_license_url, |
| | | c.bank_name, c.account_holder, c.account_number, c.branch_name |
| | | GROUP BY c.id, c.name, c.contact_phone, c.address, c.business_license_url,c.status, |
| | | c.bank_name, c.account_holder, c.account_number, c.branch_name, u.avatar, u.phone |
| | | </select> |
| | | |
| | | <select id="selectClinicUserPage" resultType="com.tcm.training.admin.member.row.ClinicBoundUserRow"> |