- 페이징 오류 수정

이민희

2022-01-17 5209a6ab479a858a74b5f655bb596ba05afb5da3

- 페이징 오류 수정

 src/main/resources/mybatis/query-template/HostingField-template.xml

@@ -30,7 +30,7 @@

    <select id="count" resultType="java.lang.Long" parameterType="kr.wisestone.owl.web.condition.HostingFieldCondition">
        SELECT
        count(h.id)
        count(DISTINCT h.id)
        FROM
        hosting_field h
        WHERE 1=1

 src/main/resources/mybatis/query-template/IspField-template.xml

@@ -30,7 +30,7 @@

    <select id="count" resultType="java.lang.Long" parameterType="kr.wisestone.owl.web.condition.IspFieldCondition">
        SELECT
        count(i.id)
        count(DISTINCT i.id)
        FROM
        isp_field i
        WHERE 1=1

 src/main/resources/mybatis/query-template/companyField-template.xml

@@ -40,7 +40,7 @@

    <select id="count" resultType="java.lang.Long" parameterType="kr.wisestone.owl.web.condition.CompanyFieldCondition">
        SELECT
        count(cf.id)
        count(DISTINCT cf.id)
        FROM
        company_field cf
        WHERE 1=1

 src/main/resources/mybatis/query-template/companyFieldCategory-template.xml

@@ -28,7 +28,7 @@

    <select id="count" resultType="java.lang.Long" parameterType="kr.wisestone.owl.web.condition.CompanyFieldCondition">
        SELECT
        count(cfc.id)
        count(DISTINCT cfc.id)
        FROM
        company_field_category cfc
        WHERE cfc.type_category = #{typeCategory}

 src/main/resources/mybatis/query-template/department-template.xml

@@ -33,7 +33,7 @@

    <select id="count" resultType="java.lang.Long" parameterType="kr.wisestone.owl.web.condition.DepartmentCondition">
        SELECT
        count(d.id)
        count(DISTINCT d.id)
        FROM
        department d
        WHERE 1=1

 src/main/resources/mybatis/query-template/issue-template.xml

@@ -250,7 +250,7 @@

    <select id="count" resultType="java.lang.Long" parameterType="kr.wisestone.owl.web.condition.IssueCondition">
        SELECT
        COUNT(issue.id)
        COUNT(DISTINCT issue.id)
        FROM issue issue
        INNER JOIN project project FORCE INDEX(workspaceIdIndex) ON issue.project_id = project.id
        INNER JOIN workspace workspace ON workspace.id = project.workspace_id

 src/main/resources/mybatis/query-template/userLevel-template.xml

@@ -10,7 +10,7 @@
        ul.permission as permission
        FROM
        user_level ul
        WHERE id != 1 AND 1=1
        WHERE id != 1
        <if test="levelName != '' and levelName != null">
            AND ul.level_name like CONCAT('%',#{levelName},'%')
        </if>
@@ -24,10 +24,10 @@

    <select id="count" resultType="java.lang.Long" parameterType="kr.wisestone.owl.web.condition.UserLevelCondition">
        SELECT
        count(ul.id)
        count(DISTINCT ul.id)
        FROM
        user_level ul
        WHERE 1=1
        WHERE id != 1
        <if test="levelName != '' and levelName != null">
            AND ul.level_name like CONCAT('%',#{levelName},'%')
        </if>