122 lines
5.1 KiB
Plaintext
122 lines
5.1 KiB
Plaintext
<%@ page isThreadSafe = "true" %>
|
|
<%@ page buffer="256kb" %>
|
|
<%@ page autoFlush = "true" %>
|
|
<%@ page contentType="application/vnd.ms-excel;charset=UTF-8" %>
|
|
<%@ page import="com.pms.common.utils.*"%>
|
|
<%@ page import="java.util.*" %>
|
|
<%
|
|
java.text.SimpleDateFormat frm= new java.text.SimpleDateFormat ("yyyy_MM_dd_HH_mm");
|
|
Calendar cal = Calendar.getInstance();
|
|
String todayKor = frm.format(cal.getTime());
|
|
|
|
String excelName = "발주관리_업체별_입고요청월 금액현황";
|
|
String encodeName = excelName+todayKor+".xls";
|
|
String fileName = java.net.URLEncoder.encode(encodeName,"UTF-8");
|
|
|
|
response.setHeader("Content-Disposition", "attachment;filename="+fileName+"");
|
|
response.setHeader("Content-Description", "JSP Generated Data");
|
|
ArrayList list = (ArrayList)request.getAttribute("LIST");
|
|
Map sumPriceMap = (Map)request.getAttribute("SUM_PRICE_MAP");
|
|
%>
|
|
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">
|
|
<head>
|
|
<meta http-equiv=Content-Type content="text/html; charset=UTF-8">
|
|
<meta name=ProgId content=Excel.Sheet>
|
|
<meta name=Generator content="Microsoft Excel 11">
|
|
<title><%=Constants.SYSTEM_NAME%></title>
|
|
<script src="http://code.jquery.com/jquery-1.10.1.min.js"></script>
|
|
<script>
|
|
|
|
</script>
|
|
</head>
|
|
<body class="backcolor">
|
|
<form name="form1" action="" method="post">
|
|
<section class="min_part_search">
|
|
<div class="pdm_menu_name">
|
|
<h2>
|
|
<span>발주관리_업체별_입고요청월 금액현황</span>
|
|
</h2>
|
|
</div>
|
|
<div class="contents_page_basic_margin">
|
|
<div class="pdm_table_wrap">
|
|
<table class="pdm_table_noImg" style="text-align:center;" border="1">
|
|
<colgroup>
|
|
<col style="width: 250px;"></col>
|
|
<col style="width: 120px;"></col>
|
|
<col style="width: 120px;"></col>
|
|
<col style="width: 120px;"></col>
|
|
<col style="width: 120px;"></col>
|
|
<col style="width: 120px;"></col>
|
|
<col style="width: 120px;"></col>
|
|
<col style="width: 120px;"></col>
|
|
<col style="width: 120px;"></col>
|
|
<col style="width: 120px;"></col>
|
|
<col style="width: 120px;"></col>
|
|
<col style="width: 120px;"></col>
|
|
<col style="width: 120px;"></col>
|
|
<col style="width: 120px;"></col>
|
|
</colgroup>
|
|
<tr class="pdm_thead" align="center" style="background:yellow; font-weight:bold;">
|
|
<td>공급업체명</td>
|
|
<td>소계</td>
|
|
<td>1월</td>
|
|
<td>2월</td>
|
|
<td>3월</td>
|
|
<td>4월</td>
|
|
<td>5월</td>
|
|
<td>6월</td>
|
|
<td>7월</td>
|
|
<td>8월</td>
|
|
<td>9월</td>
|
|
<td>10월</td>
|
|
<td>11월</td>
|
|
<td>12월</td>
|
|
</tr>
|
|
<tr style="background:#eeeeee; font-weight:bold;">
|
|
<td align="right"></td>
|
|
<td align="right"><%=CommonUtils.checkNull(sumPriceMap.get("TOTAL_SUPPLY_UNIT_PRICE"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(sumPriceMap.get("M01"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(sumPriceMap.get("M02"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(sumPriceMap.get("M03"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(sumPriceMap.get("M04"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(sumPriceMap.get("M05"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(sumPriceMap.get("M06"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(sumPriceMap.get("M07"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(sumPriceMap.get("M08"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(sumPriceMap.get("M09"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(sumPriceMap.get("M10"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(sumPriceMap.get("M11"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(sumPriceMap.get("M12"))%></td>
|
|
</tr>
|
|
<%
|
|
if(list != null && !list.isEmpty()){
|
|
for(int i = 0 ; i < list.size() ; i++){
|
|
HashMap map = (HashMap)list.get(i);
|
|
%>
|
|
<tr>
|
|
<td align="left"><%=CommonUtils.checkNull(map.get("SUPPLY_NAME"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(map.get("TOTAL_SUPPLY_UNIT_PRICE"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(map.get("M01"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(map.get("M02"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(map.get("M03"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(map.get("M04"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(map.get("M05"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(map.get("M06"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(map.get("M07"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(map.get("M08"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(map.get("M09"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(map.get("M10"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(map.get("M11"))%></td>
|
|
<td align="right"><%=CommonUtils.checkNull(map.get("M12"))%></td>
|
|
</tr>
|
|
<%
|
|
}
|
|
}
|
|
%>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
</section>
|
|
</form>
|
|
</body>
|
|
</html> |