kjs
/
ERP-node
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
ERP-node/WebContent/WEB-INF/view/materMgmt/materOrderDown.jsp

267 lines
9.8 KiB
Plaintext
Raw Permalink Normal View History

최초커밋
2025-08-21 09:41:46 +09:00
<%@ 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());
//마스터 정보
Map masterInfo = (Map)request.getAttribute("info");
//결재라인
ArrayList ApprList = (ArrayList)request.getAttribute("ApprLine");
//발주 PART정보
ArrayList detailinfo = (ArrayList)request.getAttribute("detailinfo");
String excelName = (String)masterInfo.get("ORDER_NO");
/* String encodeName = excelName+todayKor+".xls"; */
String encodeName = excelName+".xls";
String fileName = java.net.URLEncoder.encode(encodeName,"UTF-8");
response.setHeader("Content-Disposition", "attachment;filename="+fileName+"");
response.setHeader("Content-Description", "JSP Generated Data");
int k=0;
String appr0 ="";
String appr1 ="";
String appr2 ="";
String appr3 ="";
String appr5 ="";
//if(!"SRT00020".equals(masterInfo.get("SORT_CD"))){
for(int i = 0 ; i < ApprList.size() ; i++){
HashMap map = (HashMap)ApprList.get(i);
if(k==0){
appr0 = CommonUtils.checkNull(map.get("WRITER"))+"<br>"+CommonUtils.checkNull(map.get("REGDATE"));
}
if(k==2){
appr2 = CommonUtils.checkNull(map.get("WRITER"))+"<br>"+CommonUtils.checkNull(map.get("REGDATE"));
}
k++;
if(k==1){
appr1 = CommonUtils.checkNull(map.get("TARGET_USER_NAME"))+"<br>"+CommonUtils.checkNull(map.get("PROC_DATE"));
}
if(k==3){
appr3 = CommonUtils.checkNull(map.get("TARGET_USER_NAME"))+"<br>"+CommonUtils.checkNull(map.get("PROC_DATE"));
}
if(k==5){
appr5 = CommonUtils.checkNull(map.get("TARGET_USER_NAME"))+"<br>"+CommonUtils.checkNull(map.get("PROC_DATE"));
}
k++;
}
/*}else{
k=2;
for(int i = 0 ; i < ApprList.size() ; i++){
HashMap map = (HashMap)ApprList.get(i);
if(k==0){
appr0 = CommonUtils.checkNull(map.get("WRITER"))+"<br>"+CommonUtils.checkNull(map.get("REGDATE"));
}
if(k==2){
appr2 = CommonUtils.checkNull(map.get("WRITER"))+"<br>"+CommonUtils.checkNull(map.get("REGDATE"));
}
k++;
if(k==1){
appr1 = CommonUtils.checkNull(map.get("TARGET_USER_NAME"))+"<br>"+CommonUtils.checkNull(map.get("PROC_DATE"));
}
if(k==3){
appr3 = CommonUtils.checkNull(map.get("TARGET_USER_NAME"))+"<br>"+CommonUtils.checkNull(map.get("PROC_DATE"));
}
if(k==5){
appr5 = CommonUtils.checkNull(map.get("TARGET_USER_NAME"))+"<br>"+CommonUtils.checkNull(map.get("PROC_DATE"));
}
k++;
}
}*/
/* for(var j=0;j<data[i].length;j++){
var REGDATE="";
var PROC_DATE="";
if(data[i][j].REGDATE!=undefined){
REGDATE = data[i][j].REGDATE;
}
if(data[i][j].PROC_DATE!=undefined){
PROC_DATE = data[i][j].PROC_DATE;
}
text = data[i][j].WRITER+"<br>"+REGDATE;
$("#appr"+k).html(text);
k++;
text = data[i][j].TARGET_USER_NAME+"<br>"+PROC_DATE;
$("#appr"+k).html(text);
k++;
} */
%>
<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">
</head>
<body>
<table style="width:950px" border="2" cellpadding="1" cellspacing="1">
<colgroup>
<col style="width:38px;height:23px" >
<col style="width:101px;height:23px">
<col style="width:181px;height:23px">
<col style="width:61px;height:23px">
<col style="width:69px;height:23px">
<col style="width:101px;height:23px">
<col style="width:101px;height:23px">
<col style="width:101px;height:23px">
<col style="width:101px;height:23px">
</colgroup>
<tr>
<td colspan="5" rowspan="4" style="text-align:center;font-size:25px;"><br><b>발주서<br></b></td>
<td colspan="4">회사명 :다인산업기계(주)</td>
</tr>
<tr style="height:23px">
<td colspan="4">주소 : 경북 고령군 다산면 성암로 507</td>
</tr>
<tr style="height:23px">
<td colspan="4">전화 : (054)956-3701~3</td>
</tr>
<tr style="height:23px">
<td colspan="4">팩스 : (054)956-3704</td>
</tr>
<tr style="height:23px">
<td colspan="2" style="background-color:#D5D5D5;text-align:left;">발주 일자</td>
<td colspan="7"><%=CommonUtils.checkNull((String)masterInfo.get("ORDER_DATE"))%></td>
</tr>
<tr>
<td colspan="2" style="background-color:#D5D5D5;">외주처명</td>
<td colspan="7">
<%=CommonUtils.checkNull((String)masterInfo.get("SUPPLY_NAME"))%>
</td>
</tr>
<tr>
<td colspan="2" style="background-color:#D5D5D5;">연락처</td>
<td colspan="7"><%=CommonUtils.checkNull((String)masterInfo.get("SUPPLY_TEL_NO"))%> &nbsp;&nbsp;&nbsp;<%=CommonUtils.checkNull((String)masterInfo.get("SUPPLY_FAX_NO"))%></td>
</tr>
<tr>
<td align="center" style="background-color:#D5D5D5;">NO</td>
<td align="center" style="background-color:#D5D5D5;">품명</td>
<td colspan="2" align="center" style="background-color:#D5D5D5;">규격</td>
<td align="center" style="background-color:#D5D5D5;">단위</td>
<td align="center" style="background-color:#D5D5D5;">수량</td>
<td colspan="3" align="center" style="background-color:#D5D5D5;">비 고</td>
</tr>
<%
for(int i = 0 ; i < detailinfo.size() ; i++){
if(i<18){
HashMap map = (HashMap)detailinfo.get(i);
String PRODUCT_TITLE_NAME = CommonUtils.checkNull(map.get("PRODUCT_TITLE_NAME"));
String STANDARD_NAME = CommonUtils.checkNull(map.get("STANDARD_NAME"));
String UNIT = CommonUtils.checkNull(map.get("UNIT"));
String QTY = CommonUtils.checkNull(map.get("QTY"));
String PRICE = CommonUtils.checkNull(map.get("PRICE"));
String UNIT_PRICE = CommonUtils.checkNull(map.get("UNIT_PRICE"));
String BIGO = CommonUtils.checkNull(map.get("BIGO"));
%>
<tr>
<td align="center"><%=(i+1)%></td>
<td align="center"><%=PRODUCT_TITLE_NAME%></td>
<td align="center" colspan="2"><%=STANDARD_NAME%></td>
<td align="center"><%=UNIT%></td>
<td align="center"><%=QTY%></td>
<td align="center" colspan="3"><%=BIGO%></td>
</tr>
<%
}
}
%>
<tr>
<td colspan="2" style="background-color:#D5D5D5;">특이사항</td>
<td colspan="7"><%=CommonUtils.checkNull((String)masterInfo.get("REASON"))%></td>
</tr>
<tr>
<td colspan="2" style="background-color:#D5D5D5;">1.납품장소</td>
<td colspan="7"><%=CommonUtils.checkNull((String)masterInfo.get("DELIVERY_PLACE"))%></td>
</tr>
<tr>
<td colspan="2" style="background-color:#D5D5D5;">2.납 기 일</td>
<td colspan="3"><%=CommonUtils.checkNull((String)masterInfo.get("RECV_DATE"))%></td>
<td rowspan="3" style="text-align:center;background-color:#D5D5D5;" >결재</td>
<td style="text-align:center;background-color:#D5D5D5;" class="input_title">담당</td>
<td style="text-align:center;background-color:#D5D5D5;" class="input_title">부장</td>
<td style="text-align:center;background-color:#D5D5D5;" class="input_title">대표</td>
</tr>
<tr>
<td colspan="2" style="background-color:#D5D5D5;">3.발주자</td>
<td colspan="3"><%=CommonUtils.checkNull((String)masterInfo.get("REG_USER_NAME"))%></td>
<td rowspan="2" style="text-align:center;"><%=appr0%></td>
<td rowspan="2" style="text-align:center;"><%=appr1%></td>
<td rowspan="2" style="text-align:center;"><%=appr3%></td>
</tr>
<tr>
<td colspan="2" style="background-color:#D5D5D5;">4.수주자</td>
<td colspan="3"><%=CommonUtils.checkNull((String)masterInfo.get("RECV_USERID"))%></td>
</tr>
<% if(detailinfo.size() > 18 ){ %>
<tr border="0" cellpadding="0" cellspacing="0">
<td colspan="30"></td>
</tr>
<tr class="row7">
<td align="center" style="background-color:#D5D5D5;">NO</td>
<td align="center" style="background-color:#D5D5D5;">품명</td>
<td align="center" colspan="2" style="background-color:#D5D5D5;">규격</td>
<td align="center" style="background-color:#D5D5D5;">단위</td>
<td align="center" style="background-color:#D5D5D5;">수량</td>
<td align="center" colspan="3" style="background-color:#D5D5D5;">비 고</td>
</tr>
<%} %>
<%
for(int i = 18 ; i < detailinfo.size() ; i++){
HashMap map = (HashMap)detailinfo.get(i);
String PRODUCT_TITLE_NAME = CommonUtils.checkNull(map.get("PRODUCT_TITLE_NAME"));
String STANDARD_NAME = CommonUtils.checkNull(map.get("STANDARD_NAME"));
String UNIT = CommonUtils.checkNull(map.get("UNIT"));
String QTY = CommonUtils.checkNull(map.get("QTY"));
String PRICE = CommonUtils.checkNull(map.get("PRICE"));
String UNIT_PRICE = CommonUtils.checkNull(map.get("UNIT_PRICE"));
String BIGO = CommonUtils.checkNull(map.get("BIGO"));
%>
<tr>
<td align="center"><%=(i+1)%></td>
<td align="center"><%=PRODUCT_TITLE_NAME%></td>
<td align="center" colspan="2"><%=STANDARD_NAME%></td>
<td align="center"><%=UNIT%></td>
<td align="center"><%=QTY%></td>
<td align="center" colspan="3"><%=BIGO%></td>
</tr>
<%
}
%>
</table>
</body>
</html>