package platform.modules.build.dao; import java.util.List; import io.swagger.models.auth.In; import org.apache.ibatis.annotations.Param; import platform.common.base.mapper.BaseMapper; import platform.modules.api.dto.CompanyInfoDto; import platform.modules.build.DTO.CompanyFeeDto; import platform.modules.build.entity.Company; import platform.modules.company.dto.CompanyInfoManageDto; import platform.modules.government.dto.SearchCondition; import platform.modules.government.dto.StreetCompanys; import platform.modules.government.response.CompanyContractResp; import platform.modules.government.response.CompanyDataResp; import platform.modules.government.response.CompanyDetail; import platform.modules.request.DataManageRequest; /** * 企业信息DAO接口 * * @author lhf * @version 2017-10-26 */ public interface CompanyDao extends BaseMapper { /** * 根据用户名查询用户 * * @param company_name * @return */ Company findByCompanyName(@Param("company_name") String company_name); List findListByCompanyName(@Param("company_name") String company_name, @Param("ids") List ids); List findListByCompanyIds(@Param("ids") List ids); Integer findCuntCompanyByBuildId(@Param("build_id") Integer build_id, @Param("date_from") String date_from, @Param("date_to") String date_to); Integer getCompanyCountByStreetName(String name); List findCompanyFee(CompanyFeeDto company_id); Integer findAllCuntCompanyByBuildId(@Param("build_id") Integer buildId); /* *统计类型是否有引用 */ Integer countByType(@Param("type_id") Integer type_id); Integer countAllCompany(@Param("condition") SearchCondition condition); List findCompanyByWaterId(Integer water_id); List findCompanyByElectricId(Integer electric_id); /*企业信息多条件模糊查询*/ List findByCondition(@Param("companyInfoManageDto") CompanyInfoManageDto companyInfoManageDto); /*企业信息多条件模糊查询*/ List findByConditions(@Param("companyInfoManageDto") CompanyInfoManageDto companyInfoManageDto); List selectCompanyByCondition(@Param("street_id") Integer street_id, @Param("build_id") Integer build_id, @Param("param") String param, @Param("is_start") Boolean is_start); List findCompanyByCondition(@Param("currentStreet_id") Integer currentStreet_id, @Param("currentUserId") Integer currentUserId, @Param("type") String type, @Param("keyword") String keyword, @Param("searchCondition") Company searchCondition); List findListByContidion(@Param("currentUserId") Integer userId, @Param("currentStreet_id") Integer currentStreet_id, @Param("companyRegister") String companyRegister, @Param("keyword") String keyword, @Param("searchCondition") Company searchCondition); Integer isCompanyExist(@Param("company_name") String company_name, @Param("organization_code") String organization_code); Integer isCompanyNameExist(@Param("company_name") String company_name); Integer isCompanyUsccExist(@Param("uscc") String uscc); Integer isCompanyOrganizationCodeExist(@Param("organization_code") String organization_code, @Param("company_id") String company_id); /** * 查询企业统计信息 * * @param request * @return */ List selectCompStatisticInfo(DataManageRequest request); /** * 查询企业合同统计信息 * * @param request * @return */ List selectCompanyContractInfo(DataManageRequest request); /** * 查询园区外企业统计信息 * * @param request * @return */ List selectCompStatisticInfoOutsidePark(DataManageRequest request); CompanyDetail selectCompDetailInfo(String id); Company selectCompanyById(int id); /** * 存量用地街道查询企业 * * @param street_id * @param keyword * @return */ List selectStockLandCompany(@Param("street_id") Integer street_id, @Param("build_id") Integer build_id, @Param("keyword") String keyword); List getStreetCompanys(); /** * 通过组合条件获取企业详情 * * @param condition */ List getCompanyByCondition(@Param("condition") platform.modules.carrier.dto.SearchCondition condition); Company findByParkIdAndCompanyName(@Param("company_name") String company_name, @Param("park_id") Integer id); CompanyInfoDto findByUserId(@Param("userId") Integer userId); // List findByLetter(@Param("letter") String letter, @Param("searchName") String searchName); List findListByUscc(String uscc); }