snd-escloud/src/main/java/platform/modules/build/dao/CompanyDao.java

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<Company> {

    /**
     * 根据用户名查询用户
     *
     * @param company_name
     * @return
     */
    Company findByCompanyName(@Param("company_name") String company_name);

    List<Company> findListByCompanyName(@Param("company_name") String company_name, @Param("ids") List<String> ids);

    List<Company> findListByCompanyIds(@Param("ids") List<String> 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<CompanyFeeDto> 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<Company> findCompanyByWaterId(Integer water_id);

    List<Company> findCompanyByElectricId(Integer electric_id);

    /*企业信息多条件模糊查询*/
    List<Company> findByCondition(@Param("companyInfoManageDto") CompanyInfoManageDto companyInfoManageDto);

    /*企业信息多条件模糊查询*/
    List<Company> findByConditions(@Param("companyInfoManageDto") CompanyInfoManageDto companyInfoManageDto);

    List<Company> selectCompanyByCondition(@Param("street_id") Integer street_id, @Param("build_id") Integer build_id, @Param("param") String param, @Param("is_start") Boolean is_start);

    List<Company> findCompanyByCondition(@Param("currentStreet_id") Integer currentStreet_id,
                                         @Param("currentUserId") Integer currentUserId,
                                         @Param("type") String type,
                                         @Param("keyword") String keyword,
                                         @Param("searchCondition") Company searchCondition);

    List<Company> 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<CompanyDataResp> selectCompStatisticInfo(DataManageRequest request);

    /**
     * 查询企业合同统计信息
     *
     * @param request
     * @return
     */
    List<CompanyDataResp> selectCompanyContractInfo(DataManageRequest request);

    /**
     * 查询园区外企业统计信息
     *
     * @param request
     * @return
     */
    List<CompanyDataResp> selectCompStatisticInfoOutsidePark(DataManageRequest request);

    CompanyDetail selectCompDetailInfo(String id);

    Company selectCompanyById(int id);

    /**
     * 存量用地街道查询企业
     *
     * @param street_id
     * @param keyword
     * @return
     */
    List<Company> selectStockLandCompany(@Param("street_id") Integer street_id, @Param("build_id") Integer build_id, @Param("keyword") String keyword);

    List<StreetCompanys> getStreetCompanys();

    /**
     * 通过组合条件获取企业详情
     *
     * @param condition
     */
    List<Company> 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<Company> findByLetter(@Param("letter") String letter, @Param("searchName") String searchName);

    List<Company> findListByUscc(String uscc);
}