| | |
|---|
| | | private static final String SQL_GET_USER = |
|---|
| | | "SELECT * FROM fin_sys_tenant_user WHERE IS_DELETE = 0 AND `STATUS` = 1 AND TENANT_ID = ?"; |
|---|
| | | private static final String SQL_QH_PAGE_USER_PREFIX = |
|---|
| | | "select fstu.id,fstu.USER_CODE,fstu.USER_NAME,fstu.USER_PHONE,fst.name tenantName,fstd.name sysDeptName,fst.STATUS from FIN_SYS_TENANT_USER fstu " |
|---|
| | | "select fstu.id,fstu.USER_CODE,fstu.USER_NAME,fstu.USER_PHONE,fst.name tenantName,fstd.name sysDeptName,fstu.STATUS from FIN_SYS_TENANT_USER fstu " |
|---|
| | | + "left join fin_sys_tenant fst on fst.id =fstu.TENANT_ID " |
|---|
| | | + "left join fin_sys_tenant_department fstd on fstd.id = fstu.SYS_DEPT_ID where fstu.IS_DELETE = 0 "; |
|---|
| | | |
|---|
