| | |
| | | + "<if test='pageComMngRealCompanyDTO.comName != null and pageComMngRealCompanyDTO.comName.trim() != ""'>" |
| | | + " and t.com_name LIKE concat( '%',#{pageComMngRealCompanyDTO.comName}, '%' ) " + " </if> " |
| | | + "<if test='pageComMngRealCompanyDTO.communityId != null and pageComMngRealCompanyDTO.communityId != 0'>" |
| | | + " and t.community_id = #{pageComMngRealCompanyDTO.communityId} " + " </if> " + " order by t.create_at desc" |
| | | + " and t.community_id = ${pageComMngRealCompanyDTO.communityId} " + " </if> " + " order by t.create_at desc" |
| | | + "</script>") |
| | | IPage<ComMngRealCompanyVO> pageQueryComMngRealCompany(Page page, |
| | | @Param(value = "pageComMngRealCompanyDTO") PageComMngRealCompanyDTO pageComMngRealCompanyDTO); |
| | |
| | | + "<if test='exportRealCompanyExcelDTO.comName != null and exportRealCompanyExcelDTO.comName.trim() != ""'>" |
| | | + " and t.com_name LIKE concat( #{exportRealCompanyExcelDTO.comName}, '%' ) " + " </if> " |
| | | + "<if test='exportRealCompanyExcelDTO.communityId != null and exportRealCompanyExcelDTO.communityId != 0'>" |
| | | + " and t.community_id = #{exportRealCompanyExcelDTO.communityId} " + " </if> " |
| | | + " and t.community_id = ${exportRealCompanyExcelDTO.communityId} " + " </if> " |
| | | + "<if test='exportRealCompanyExcelDTO.legalPerson != null and exportRealCompanyExcelDTO.legalPerson.trim() != ""'>" |
| | | + " and t.legal_person LIKE concat( #{exportRealCompanyExcelDTO.legalPerson}, '%' ) " + " </if> " |
| | | + " order by t.create_at desc" + "</script>") |
| | |
| | | ComMngRealCompanyBelongsVO queryComMngRealCompanyBelongs( |
| | | @Param(value = "pageComMngRealCompanyBelongsDTO") ComMngRealCompanyBelongsDTO comMngRealCompanyBelongsDTO); |
| | | |
| | | @Select("select count(id) as companyTotal from com_mng_real_company where community_id = #{communityId}") |
| | | @Select("select count(id) as companyTotal from com_mng_real_company where community_id = ${communityId}") |
| | | ComMngRealCompanyTotalVO getComMngRealCompanyTotalByAdmin(@Param("communityId") Long communityId); |
| | | } |