| | |
| | | " t.address, " + |
| | | " t.create_at AS createAt " + |
| | | "FROM " + |
| | | " com_mng_real_company t " + |
| | | " com_mng_real_company t where 1=1" + |
| | | "<if test='pageComMngRealCompanyDTO.legalPerson != null and pageComMngRealCompanyDTO.legalPerson.trim() != ""'>" + |
| | | " and t.legal_person LIKE concat( #{pageComMngRealCompanyDTO.legalPerson}, '%' ) " + |
| | | " </if> " + |
| | | "<if test='pageComMngRealCompanyDTO.comName != null and pageComMngRealCompanyDTO.comName.trim() != ""'>" + |
| | | " and t.com_name LIKE concat( #{pageComMngCarDTO.comName}, '%' ) " + |
| | | " 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> " + |
| | | "<if test='pageComMngRealCompanyDTO.legalPerson != null and pageComMngRealCompanyDTO.legalPerson.trim() != ""'>" + |
| | | " and t.legal_person LIKE concat( #{pageComMngCarDTO.legalPerson}, '%' ) " + |
| | | " </if> " + |
| | | " order by t.create_at desc"+ |
| | | "</script>") |