18756
2024-08-28 ebdb4a8a09dc26219af5115c2e6609aaf972c89c
src/main/java/com/product/file/service/DocumentService.java
@@ -652,21 +652,29 @@
    public DataTableEntity getApplyUserSort() throws BaseException {
        StringBuilder sb=new StringBuilder();
        List<String> param=new ArrayList<>();
        sb.append(" SELECT a.borrower,a.show_name,a.applayCount,a.applayFileCount ");
        sb.append(" SELECT b.*,a.applayCount ");
        sb.append(" FROM (");
        sb.append(" SELECT borrower,count(borrower) as applayCount");
        sb.append(" FROM product_oa_document_borrow ");
        sb.append(" group by borrower");
        sb.append(" ) a LEFT JOIN ");
        sb.append(" (");
        sb.append(" SELECT a.borrower,a.show_name,a.applayFileCount ");
        sb.append(" FROM (");
        sb.append(" SELECT w.borrower,s.show_name,");
        sb.append(" count( borrower )  AS applayCount,");
        sb.append(" count(sub_uuid) as applayFileCount ");
        sb.append(" FROM product_oa_document_borrow  w ");
        sb.append(" JOIN product_oa_document_borrow_sub b");
        sb.append(" left JOIN product_oa_document_borrow_sub b");
        sb.append(" on b.borrow_uuid=w.uuid");
        sb.append(" JOIN product_oa_document t");
        sb.append(" left JOIN product_oa_document t");
        sb.append(" on b.sub_uuid=t.uuid");
        sb.append(" JOIN product_sys_staffs s");
        sb.append(" left JOIN product_sys_staffs s");
        sb.append(" on w.borrower=s.user_id");
        sb.append(" GROUP BY w.borrower,s.show_name");
        sb.append(" )a");
        sb.append(" order by a.applayCount,a.applayFileCount asc");
        sb.append(" )a )b");
        sb.append(" on a.borrower=b.borrower ");
        sb.append(" order by a.applayCount,b.applayFileCount asc");
        DataTableEntity dataTableEntity = baseDao.listTable(sb.toString(),param.toArray());
        return dataTableEntity;
    }