(스프링) 관리자 배송조회 하기 등록하기 배송현황

 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"
    isELIgnored="false" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<c:set var="contextPath"  value="${pageContext.request.contextPath}"  />
<html>
<head>
<meta  charset="utf-8">
 
<script>
 
 
 
 
function fn_modify_order_state(order_id,select_id){
    var s_delivery_state=document.getElementById(select_id);
    var index = s_delivery_state.selectedIndex;
    var value = s_delivery_state[index].value;
    //console.log("value: "+value );
     
    $.ajax({
        type : "post",
        async : false,
        url : "${contextPath}/admin/order/modifyDeliveryState.do",
        data : {
            "order_id":order_id,
            delivery_state:value
        },
        success : function(data, textStatus) {
            if(data.trim()=='mod_success'){
                alert("주문 정보를 수정했습니다.");
                location.href="${contextPath}/admin/order/adminOrderMain.do";
            }else if(data.trim()=='failed'){
                alert("다시 시도해 주세요.");    
            }
            
        },
        error : function(data, textStatus) {
            alert("에러가 발생했습니다."+data);
        },
        complete : function(data, textStatus) {
            //alert("작업을완료 했습니다");
            
        }
    }); //end ajax        
}
 
 
 
 
 
</script>
</head>
<body>
 
 
 
 
 
 
<table class="list_view">
        <tbody align=center >
            <tr style="background:#33ff00" >
                <td class="fixed" >주문번호</td>
                <td class="fixed">주문일자</td>
                <td>주문내역</td>
                <td>배송상태</td>
                <td>배송수정</td>
            </tr>
   <c:choose>
     <c:when test="${empty newOrderList}">            
            <tr>
               <td colspan=5 class="fixed">
                  <strong>주문한 상품이 없습니다.</strong>
               </td>
             </tr>
     </c:when>
     <c:otherwise>
     <c:forEach var="item" items="${newOrderList}" varStatus="i">
        <c:choose>
          <c:when test="${item.order_id != pre_order_id }">  
            <c:choose>
              <c:when test="${item.delivery_state=='delivery_prepared' }">
                <tr  bgcolor="lightgreen">    
              </c:when>
              <c:when test="${item.delivery_state=='finished_delivering' }">
                <tr  bgcolor="lightgray">    
              </c:when>
              <c:otherwise>
                <tr  bgcolor="orange">   
              </c:otherwise>
            </c:choose>   
                 <td width=10%>
                   <a href="javascript:fn_detail_order('${item.order_id}')">
                     <strong>${item.order_id}</strong>
                   </a>
                </td>
                <td width=20%>
                 <strong>${item.pay_order_time }</strong> 
                </td>
                <td width=50% align=left >
                    <strong>주문자:${item.orderer_name}</strong><br>
                  <strong>주문자 번화번호:${item.orderer_hp}</strong><br>
                  <strong>수령자:${item.receiver_name}</strong><br>
                  <strong>수령자 번화번호:${item.receiver_hp1}-${item.receiver_hp2}-${item.receiver_hp3}</strong><br>
                  <strong>주문상품명(수량):${item.goods_title}(${item.order_goods_qty})</strong><br>
                     <c:forEach var="item2" items="${newOrderList}" varStatus="j">
                       <c:if test="${j.index > i.index }" >
                          <c:if  test="${item.order_id ==item2.order_id}" >
                            <strong>주문상품명(수량):${item2.goods_title}(${item2.order_goods_qty})</strong><br>
                      </c:if>   
                       </c:if>
                    </c:forEach> 
                </td>
                <td width=10%>
                 <select name="s_delivery_state${i.index }"  id="s_delivery_state${i.index }">
                 <c:choose>
                   <c:when test="${item.delivery_state=='delivery_prepared' }">
                     <option  value="delivery_prepared" selected>배송준비중</option>
                     <option  value="delivering">배송중</option>
                     <option  value="finished_delivering">배송완료</option>
                     <option  value="cancel_order">주문취소</option>
                     <option  value="returning_goods">반품</option>
                   </c:when>
                    <c:when test="${item.delivery_state=='delivering' }">
                    <option  value="delivery_prepared" >배송준비중</option>
                     <option  value="delivering" selected >배송중</option>
                     <option  value="finished_delivering">배송완료</option>
                     <option  value="cancel_order">주문취소</option>
                     <option  value="returning_goods">반품</option>
                   </c:when>
                   <c:when test="${item.delivery_state=='finished_delivering' }">
                    <option  value="delivery_prepared" >배송준비중</option>
                     <option  value="delivering"  >배송중</option>
                     <option  value="finished_delivering" selected>배송완료</option>
                     <option  value="cancel_order">주문취소</option>
                     <option  value="returning_goods">반품</option>
                   </c:when>
                   <c:when test="${item.delivery_state=='cancel_order' }">
                    <option  value="delivery_prepared" >배송준비중</option>
                     <option  value="delivering"  >배송중</option>
                     <option  value="finished_delivering" >배송완료</option>
                     <option  value="cancel_order" selected>주문취소</option>
                     <option  value="returning_goods">반품</option>
                   </c:when>
                   <c:when test="${item.delivery_state=='returning_goods' }">
                    <option  value="delivery_prepared" >배송준비중</option>
                     <option  value="delivering"  >배송중</option>
                     <option  value="finished_delivering" >배송완료</option>
                     <option  value="cancel_order" >주문취소</option>
                     <option  value="returning_goods" selected>반품</option>
                   </c:when>
                   </c:choose>
                 </select> 
                </td>
                <td width=10%>
                 <input  type="button" value="배송수정"  onClick="fn_modify_order_state('${item.order_id}','s_delivery_state${i.index}')"/>
                </td>
            </tr>
        </c:when>
        </c:choose>    
        <c:set  var="pre_order_id" value="${item.order_id }" />
    </c:forEach>
    </c:otherwise>
  </c:choose>    
         <tr>
             <td colspan=8 class="fixed">
                 <c:forEach   var="page" begin="1" end="10" step="1" >
                 <c:if test="${section >1 && page==1 }">
                  <a href="${contextPath}/admin/order/adminOrderMain.do?chapter=${section-1}&pageNum=${(section-1)*10 +1 }">&nbsp;&nbsp;</a>
                 </c:if>
                  <a href="${contextPath}/admin/order/adminOrderMain.do?chapter=${section}&pageNum=${page}">${(section-1)*10 +page } </a>
                 <c:if test="${page ==10 }">
                  <a href="${contextPath}/admin/order/adminOrderMain.do?chapter=${section+1}&pageNum=${section*10+1}">&nbsp; next</a>
                 </c:if> 
                  </c:forEach> 
           </td>
        </tr>             
        </tbody>
    </table>
  </form>       
    <div class="clear"></div>
</body>
</html>
 
 
cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
    @Override
    @RequestMapping(value="/modifyDeliveryState.do" ,method={RequestMethod.POST})
    public ResponseEntity modifyDeliveryState(@RequestParam Map<StringString> deliveryMap, 
                                    HttpServletRequest request, HttpServletResponse response)  throws Exception {
        System.out.println("############################deliveryMap =" +deliveryMap);
        
        adminOrderService.modifyDeliveryState(deliveryMap);
        
        System.out.println("deliveryMap =" +deliveryMap);
        
        
        String message = null;
        ResponseEntity resEntity = null;
        HttpHeaders responseHeaders = new HttpHeaders();
        message  = "mod_success";
        resEntity =new ResponseEntity(message, responseHeaders, HttpStatus.OK);
        return resEntity;
        
    }
 
 
 
 
 
 
 
 
 
    @Override
    public void  modifyDeliveryState(Map deliveryMap) throws Exception{
        adminOrderDAO.updateDeliveryState(deliveryMap);
    }
 
 
 
 
public void  updateDeliveryState(Map deliveryMap) throws DataAccessException{
        sqlSession.update("mapper.admin.order.updateDeliveryState",deliveryMap);
    }
 
 
 
 
<update id="updateDeliveryState" parameterType="java.util.Map" >
       update t_shopping_order
        <set> 
          <if test=" delivery_state!='' and delivery_state!=null">
            delivery_state=#{delivery_state}
          </if>
        </set>
        where 
        order_id=#{order_id}
    </update>    
cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
    @RequestMapping(value="/adminOrderMain.do" ,method={RequestMethod.GET, RequestMethod.POST})
    public ModelAndView adminOrderMain(@RequestParam Map<StringString> dateMap,
                                      HttpServletRequest request, HttpServletResponse response)  throws Exception {
 
        
        
        List<OrderVO> newOrderList=adminOrderService.listNewOrder(condMap);
        mav.addObject("newOrderList",newOrderList);
        
    
        
        return mav;
        
    }
cs