사용자 검색,상세검색 정렬 추가

사용자 검색과 상세검색에 헤더정렬을 추가해봅시다. 

1. sord(정렬방법)와 sidx(정렬기준)를 받을 RequestParam을 추가

2. map 추가

3. mapper.xml 수정

1. 사용자 검색 - 이름검색  (사원번호검색도 똑같이 해주면됨)

// 사용자검색
    //   -이름
    @RequestMapping(value = "/userSearchName.do", method = RequestMethod.POST,
            produces = "application/json; charset=UTF-8")
    public @ResponseBody List<Emp_SearchVo> userSearchName(
            @RequestParam String NAME,

1.sord(정렬방법)와 sidx(정렬기준)를 받을 RequestParam을 추가

            @RequestParam(value = "sord", required=false, defaultValue="sort") String sord,
           @RequestParam(value = "sidx", required=false) String sidx
)  {
        System.out.println("사용자검색 - 이름");
         
        List<Emp_SearchVo> emp = null;

2. map을 추가 
        Map<String, Object> map = new HashMap<>();
        map.put("NAME", NAME);
        map.put("sidx", sidx);
        map.put("sord", sord);
        //emp = employeeServiceimp.userSearchName(name);  
        emp = employeeServiceimp.userSearchName(map);  
        return emp;
        
    }
    
    

3. mapper.xml 수정

<select id="userSearchName" resultMap="EmpSearchMapper"
        parameterType="map">
        SELECT E.ENAME,E.NAME,E.DCODE,BIREDAY,
        DE.DESCRIPTION AS DEPARTMENT,
        PO.DESCRIPTION AS POSITION,
        PR.DESCRIPTION AS PRESENT   
        FROM CODE_TABLE PO,CODE_TABLE PR, CODE_TABLE DE ,EMPLOYEE E 
        WHERE 
        DE.CODE = E.DEPARTMENT AND
        PO.CODE = E.POSITION AND
        PR.CODE = E.PRESENT 
        AND NAME like '%'||#{NAME}||'%'
        order by ${sidx}
        <if test="sord == ('asc')">ASC</if>
        <if test="sord == ('desc')">DESC</if> 
    </select>
    

2. 사용자 상세검색

 
    // 사용자 상세검색
    @RequestMapping(value = "/userDetailedSearch.do", method = RequestMethod.POST,
            produces = "application/json; charset=UTF-8")
    public @ResponseBody List<Emp_SearchVo>  userDetailedSearch(HttpServletRequest req,Emp_SearchVo vo,
            @RequestBody String DCODE,
            @RequestBody String NAME,
            @RequestBody String ENAME,
            @RequestBody String PRESENT,
            @RequestBody String POSITION,
            @RequestBody String DEPARTMENT,

1.sord(정렬방법)와 sidx(정렬기준)를 받을 RequestParam을 추가
            @RequestParam(value = "sord", required=false, defaultValue="sort") String sord,
            @RequestParam(value = "sidx", required=false) String sidx) {
        
        
        System.out.println("사용자 상세검색");
        List<Emp_SearchVo> emp = null;

2. map을 추가 
        Map<String, Object> map = new HashMap<String, Object>();
        
        map.put("DCODE", req.getParameter("DCODE"));
        map.put("NAME", req.getParameter("NAME"));
        map.put("ENAME", req.getParameter("ENAME"));
        map.put("PRESENT", req.getParameter("PRESENT"));
        map.put("POSITION", req.getParameter("POSITION"));
        map.put("DEPARTMENT", req.getParameter("DEPARTMENT"));
        map.put("SORD",sord);
        map.put("SIDX", sidx);
        
    /*    vo.setDCODE(req.getParameter("DCODE"));
        vo.setNAME(req.getParameter("NAME"));
        vo.setENAME(req.getParameter("ENAME"));
        vo.setPRESENT(req.getParameter("PRESENT"));
        vo.setPOSITION(req.getParameter("POSITION"));
        vo.setDEPARTMENT(req.getParameter("DEPARTMENT"));
        
        */
        
        System.out.println(map);
        //emp = employeeServiceimp.userDetailedSearch(vo);
        emp = employeeServiceimp.userDetailedSearch(map);
        
        //mybatis map parameter example  이걸로 검색 ㄱ
        //http://cocomo.tistory.com/245 참고
        
        return emp;
    }

3. mapper.xml 수정

<select id="userDetailedSearch" resultMap="EmpSearchMapper"
        parameterType="map">
        SELECT 
        E.ENAME,E.NAME,E.DCODE,E.BIREDAY,
        DE.DESCRIPTION  AS DEPARTMENT,
        PO.DESCRIPTION  AS POSITION,
        PR.DESCRIPTION  AS PRESENT
        FROM EMPLOYEE E JOIN CODE_TABLE PO ON (PO.CODE = E.POSITION) JOIN
        CODE_TABLE PR ON (PR.CODE = E.PRESENT) JOIN
        CODE_TABLE DE ON (DE.CODE = E.DEPARTMENT)
        WHERE
        DCODE like '%'||#{DCODE}||'%'
        or NAME like '%'||#{NAME}||'%'
        or ENAME like '%'||#{ENAME}||'%'
        or PRESENT like '%'||#{PRESENT}||'%'
        or POSITION like '%'||#{POSITION}||'%'
        or DEPARTMENT like '%'||#{DEPARTMENT}||'%'
        order by ${SIDX}
        <if test="SORD == ('asc')">ASC</if>
        <if test="SORD == ('desc')">DESC</if>
    </select>