OrganizationMapper.java 4.9 KB
Newer Older
eddie.woo's avatar
eddie.woo committed
1 2 3 4
package pwc.taxtech.atms.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
5
import org.apache.ibatis.annotations.Select;
eddie.woo's avatar
eddie.woo committed
6 7
import org.apache.ibatis.session.RowBounds;
import pwc.taxtech.atms.MyMapper;
eddie.woo's avatar
eddie.woo committed
8
import pwc.taxtech.atms.dpo.*;
9 10
import pwc.taxtech.atms.entity.Organization;
import pwc.taxtech.atms.entity.OrganizationExample;
eddie.woo's avatar
eddie.woo committed
11

chase's avatar
chase committed
12 13
import java.util.List;

eddie.woo's avatar
eddie.woo committed
14 15 16
@Mapper
public interface OrganizationMapper extends MyMapper {
    /**
eddie.woo's avatar
eddie.woo committed
17
     * This method was generated by MyBatis Generator.
gary's avatar
gary committed
18
     * This method corresponds to the database table organization
eddie.woo's avatar
eddie.woo committed
19 20 21 22 23 24
     *
     * @mbg.generated
     */
    long countByExample(OrganizationExample example);

    /**
eddie.woo's avatar
eddie.woo committed
25
     * This method was generated by MyBatis Generator.
gary's avatar
gary committed
26
     * This method corresponds to the database table organization
eddie.woo's avatar
eddie.woo committed
27 28 29 30 31 32
     *
     * @mbg.generated
     */
    int deleteByExample(OrganizationExample example);

    /**
eddie.woo's avatar
eddie.woo committed
33
     * This method was generated by MyBatis Generator.
gary's avatar
gary committed
34
     * This method corresponds to the database table organization
eddie.woo's avatar
eddie.woo committed
35 36 37
     *
     * @mbg.generated
     */
38
    int deleteByPrimaryKey(String id);
eddie.woo's avatar
eddie.woo committed
39 40

    /**
eddie.woo's avatar
eddie.woo committed
41
     * This method was generated by MyBatis Generator.
gary's avatar
gary committed
42
     * This method corresponds to the database table organization
eddie.woo's avatar
eddie.woo committed
43 44 45 46 47 48
     *
     * @mbg.generated
     */
    int insert(Organization record);

    /**
eddie.woo's avatar
eddie.woo committed
49
     * This method was generated by MyBatis Generator.
gary's avatar
gary committed
50
     * This method corresponds to the database table organization
eddie.woo's avatar
eddie.woo committed
51 52 53 54 55 56
     *
     * @mbg.generated
     */
    int insertSelective(Organization record);

    /**
eddie.woo's avatar
eddie.woo committed
57
     * This method was generated by MyBatis Generator.
gary's avatar
gary committed
58
     * This method corresponds to the database table organization
eddie.woo's avatar
eddie.woo committed
59 60 61 62 63 64
     *
     * @mbg.generated
     */
    List<Organization> selectByExampleWithRowbounds(OrganizationExample example, RowBounds rowBounds);

    /**
eddie.woo's avatar
eddie.woo committed
65
     * This method was generated by MyBatis Generator.
gary's avatar
gary committed
66
     * This method corresponds to the database table organization
eddie.woo's avatar
eddie.woo committed
67 68 69 70 71 72
     *
     * @mbg.generated
     */
    List<Organization> selectByExample(OrganizationExample example);

    /**
eddie.woo's avatar
eddie.woo committed
73
     * This method was generated by MyBatis Generator.
gary's avatar
gary committed
74
     * This method corresponds to the database table organization
eddie.woo's avatar
eddie.woo committed
75 76 77
     *
     * @mbg.generated
     */
78
    Organization selectByPrimaryKey(String id);
eddie.woo's avatar
eddie.woo committed
79 80

    /**
eddie.woo's avatar
eddie.woo committed
81
     * This method was generated by MyBatis Generator.
gary's avatar
gary committed
82
     * This method corresponds to the database table organization
eddie.woo's avatar
eddie.woo committed
83 84 85 86 87 88
     *
     * @mbg.generated
     */
    int updateByExampleSelective(@Param("record") Organization record, @Param("example") OrganizationExample example);

    /**
eddie.woo's avatar
eddie.woo committed
89
     * This method was generated by MyBatis Generator.
gary's avatar
gary committed
90
     * This method corresponds to the database table organization
eddie.woo's avatar
eddie.woo committed
91 92 93 94 95 96
     *
     * @mbg.generated
     */
    int updateByExample(@Param("record") Organization record, @Param("example") OrganizationExample example);

    /**
eddie.woo's avatar
eddie.woo committed
97
     * This method was generated by MyBatis Generator.
gary's avatar
gary committed
98
     * This method corresponds to the database table organization
eddie.woo's avatar
eddie.woo committed
99 100 101 102 103 104
     *
     * @mbg.generated
     */
    int updateByPrimaryKeySelective(Organization record);

    /**
eddie.woo's avatar
eddie.woo committed
105
     * This method was generated by MyBatis Generator.
gary's avatar
gary committed
106
     * This method corresponds to the database table organization
eddie.woo's avatar
eddie.woo committed
107 108 109 110 111
     *
     * @mbg.generated
     */
    int updateByPrimaryKey(Organization record);

gary's avatar
gary committed
112
    @Select("SELECT id, parent_id as Parent_ID from organization")
113
    List<OrganizationDto> selectOnlyIdAndParentId();
eddie.woo's avatar
eddie.woo committed
114 115 116 117 118 119 120 121 122 123 124 125 126

    List<Organization> selectByExampleWithAssociation(OrganizationExample example);

    List<OrganizationDto> selectIndBusiunitAreaOrgstrct(@Param("orgIsActive") Boolean orgIsActive);

    List<OrgBasicDto> selectIndBusiunitAreaOrgstrctReg(@Param("orgIsActive") Boolean orgIsActive);

    List<OrganizationDto> getCustomDimensionOrgList();

    List<DimensionValueOrgDto> getDimensionValueOrgDtoList();

    List<OrganizationDto> getAllCustomDimensionOrgList();

127
    List<OrganizationDto> getSingleOrgByOrgIdToOrgDto(@Param("orgId") String orgId);
eddie.woo's avatar
eddie.woo committed
128 129 130 131

    Integer countForCodeUniqueValidate(@Param("innerId") String innerId, @Param("innerCode") String innerCode);

    List<OrganizationDto> selectIndBusUnitAreaOrgStrctReg(@Param("orgIsActive") Boolean orgIsActive,
132
                                                          @Param("areaId") String areaId, @Param("regionLevelType") Integer regionLevelType);
eddie.woo's avatar
eddie.woo committed
133 134

    List<OrgGeneralInfoMiddleDto> selectJoinToOrgGeneralInfo();
eddie.woo's avatar
eddie.woo committed
135 136 137 138 139 140 141

    @Select("select tb.id,tb.name from user_organization ta left join organization tb on ta.organization_id = tb.id " +
            "where ta.user_id = #{uid}")
    List<OrgSelectDto> getMyOrgSelectList(String uid);

    @Select("select id, name from organization;")
    List<OrgSelectDto> getAllOrgSelectList();
eddie.woo's avatar
eddie.woo committed
142 143 144 145 146 147 148

    @Select("select tb.id,tb.code from user_organization ta left join organization tb on ta.organization_id = tb.id " +
            "where ta.user_id = #{uid}")
    List<OrgCodeIdDto> getMyOrgCodeList(String uid);

    @Select("select id, code from organization;")
    List<OrgCodeIdDto> getAllOrgCodeList();
149

chase's avatar
chase committed
150
    String queryBusinessByCompanyId(String companyId);
eddie.woo's avatar
eddie.woo committed
151
}