이슈 목록 - '이슈 제목' 검색 조건 추가

이민희

2021-11-29 fd8fdf9441329845ff78d3ae4274f107e3e6ba4d

이슈 목록 - '이슈 제목' 검색 조건 추가

 src/main/java/kr/wisestone/owl/web/condition/IssueCondition.java

@@ -16,6 +16,7 @@
 */
public class IssueCondition {
    private Long id;
    private String keyWord;
    private String title;
    private String description;
    private String combinationIssueNumber;
@@ -175,6 +176,14 @@
        return condition;
    }

    public String getKeyWord() {
        return keyWord;
    }

    public void setKeyWord(String keyWord) {
        this.keyWord = keyWord;
    }

    public Long getId() {
        return id;
    }

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

@@ -50,21 +50,25 @@
        temp_issue_comment on (temp_issue_comment.issue_id = issue.id)
        LEFT OUTER JOIN user user ON issue_user.user_id = user.id
        WHERE 1=1
        <if test="title != null and !title.equals('') ">
        <if test="keyWord != null and !keyWord.equals('') ">
            AND issue.title like CONCAT('%',#{keyWord},'%')
            OR issue.description like CONCAT('%',#{keyWord},'%')
            OR issue.start_date like CONCAT('%',#{keyWord},'%')
            OR issue.complete_date like CONCAT('%',#{keyWord},'%')
            OR issue.issue_number like CONCAT('%',#{keyWord},'%')
            OR issue.register_date like CONCAT('%',#{keyWord},'%')
            OR project.name like CONCAT('%',#{keyWord},'%')
            OR project.project_key like CONCAT('%',#{keyWord},'%')
            OR issue_type.name like CONCAT('%',#{keyWord},'%')
            OR issue_status.issue_status_type like CONCAT('%',#{keyWord},'%')
            OR issue_status.name like CONCAT('%',#{keyWord},'%')
            OR priority.name like CONCAT('%',#{keyWord},'%')
            OR severity.name like CONCAT('%',#{keyWord},'%')
            OR issue_custom.use_value like CONCAT('%',#{keyWord},'%')
        </if>

        <if test="title != null and !title.equals('')">
            AND issue.title like CONCAT('%',#{title},'%')
            OR issue.description like CONCAT('%',#{title},'%')
            OR issue.start_date like CONCAT('%',#{title},'%')
            OR issue.complete_date like CONCAT('%',#{title},'%')
            OR issue.issue_number like CONCAT('%',#{title},'%')
            OR issue.register_date like CONCAT('%',#{title},'%')
            OR project.name like CONCAT('%',#{title},'%')
            OR project.project_key like CONCAT('%',#{title},'%')
            OR issue_type.name like CONCAT('%',#{title},'%')
            OR issue_status.issue_status_type like CONCAT('%',#{title},'%')
            OR issue_status.name like CONCAT('%',#{title},'%')
            OR priority.name like CONCAT('%',#{title},'%')
            OR severity.name like CONCAT('%',#{title},'%')
            OR issue_custom.use_value like CONCAT('%',#{title},'%')
        </if>

        <if test="description != null and !description.equals('')">

 src/main/webapp/i18n/ko/global.json

@@ -210,6 +210,7 @@
        "videoExample": "동영상 예제",
        "writeWaring": "작성 요령",
        "pleaseEnterIssueName": "검색할 이슈 이름을 입력하세요.",
        "pleaseEnterIssueKeyWord": "검색할 이슈의 키워드를 입력하세요.",
        "selectProjectAndIssueTypeDownloadExcel": "프로젝트, 이슈 유형을 선택하면 해당 하는 양식의 엑셀을 다운로드 할 수 있습니다.",
        "settingTableDisplay": "테이블 표시 설정",
        "deleteIssue": "이슈 삭제",

 src/main/webapp/scripts/app/issue/issueList.controller.js

@@ -45,6 +45,7 @@
                    issueTypeId : "",
                    partnerVos : "",
                    search : {
                        keyWord : "", //  전체 검색
                        title : "", //  제목
                        description : "",   //  내용
                        combinationIssueNumber : "",   //  이슈 번호
@@ -320,6 +321,7 @@
                //  이슈 검색 조건을 만든다.
                function makeSearchConditions() {
                    var conditions = {
                        keyWord : $scope.vm.search.keyWord,
                        title : $scope.vm.search.title,
                        description : $scope.vm.search.description,
                        projectType : $scope.vm.search.projectType,

 src/main/webapp/views/issue/issueListNormal.html

@@ -16,8 +16,8 @@
                                                   maxlength="300"
                                                   kr-input
                                                   owl-auto-focus
                                                   ng-model="vm.search.title"
                                                   placeholder="{{'issue.pleaseEnterIssueName' | translate}}">
                                                   ng-model="vm.search.keyWord"
                                                   placeholder="{{'issue.pleaseEnterIssueKeyWord' | translate}}">
                                            <div class="input-group-prepend ml-10">
                                                <button class="btn btn-navy" ng-click="fn.getPageList(0)"> <span translate="common.search">검색</span></button>
                                            </div>
@@ -29,6 +29,12 @@
                                    <div class="col-sm-12">
                                        <div class="tabfilter">
                                            <div translate="common.selectedSearchCriteria">선택한 검색 조건</div>
                                            <!--    이슈 제목   -->
                                            <p ng-if="$root.isDefined(vm.search.title)">
                                                {{vm.search.title}}
                                                <span ng-click="vm.search.title = ''">×</span>
                                            </p>

                                            <!--    프로젝트    -->
                                            <issue-search-array-view-element lists="vm.projects"
                                                                             type="'project'"></issue-search-array-view-element>
@@ -104,6 +110,19 @@
                                        <div class="row">
                                            <div class="col-lg-3">
                                                <div class="form-group">
                                                    <label> <span translate="issue.issueTitle">이슈 제목</span></label>
                                                    <input type="text"
                                                           name="title"
                                                           class="form-control input-sm"
                                                           kr-input
                                                           maxlength="20"
                                                           autocomplete="off"
                                                           ng-model="vm.search.title">
                                                </div>
                                            </div>

                                            <div class="col-lg-3">
                                                <div class="form-group">
                                                    <label> <span translate="common.project">프로젝트</span></label>
                                                    <js-autocomplete-multi data-input-name="projects"
                                                                           selected-model="vm.projects"