103 lines
3.8 KiB
Plaintext
103 lines
3.8 KiB
Plaintext
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
|
|
<%@ page import="java.util.*"%>
|
|
<%@ page import="java.io.*"%>
|
|
<%@ page import="com.oreilly.servlet.MultipartRequest" %>
|
|
<%@ page import="com.oreilly.servlet.multipart.DefaultFileRenamePolicy" %>
|
|
<%@ include file="/field_manager/include/manager_head.jsp"%>
|
|
<%request.setCharacterEncoding("utf-8");%>
|
|
<%
|
|
|
|
|
|
|
|
String fileName = "";
|
|
String realFolder = "";
|
|
String saveFolder = "/upload/board";
|
|
String encType = "utf-8";
|
|
int maxSize = 10 * 1024 * 1024;
|
|
|
|
ServletContext scontext = getServletContext();
|
|
ArrayList saveFiles = new ArrayList();
|
|
ArrayList orgFiles = new ArrayList();
|
|
realFolder = scontext.getRealPath(saveFolder);
|
|
realFolder = "/home/apply/upload/yangsik";
|
|
MultipartRequest multi = new MultipartRequest( request
|
|
, realFolder
|
|
, maxSize
|
|
, encType
|
|
, new DefaultFileRenamePolicy() );
|
|
Enumeration files = multi.getFileNames();
|
|
int t1 = 0;
|
|
String[] a_file = new String[50];
|
|
int olp = 31;
|
|
while( files.hasMoreElements() ){
|
|
olp = olp - 1;
|
|
|
|
String name = (String)files.nextElement();
|
|
int rtp = Integer.parseInt(name.replaceAll("f_","").replaceAll("_4_2",""));
|
|
String fName = multi.getFilesystemName( name );
|
|
String oName = multi.getOriginalFileName( name );
|
|
String type = multi.getContentType( name );
|
|
File f = multi.getFile( name );
|
|
if(fName != null && !fName.equals("")){
|
|
t1 = t1 + 1;
|
|
if(t1 > 1){
|
|
fileName = fileName + "|";
|
|
}
|
|
fileName = fileName + fName;
|
|
a_file[rtp] = fName;
|
|
|
|
}else{
|
|
a_file[rtp] = "";
|
|
}
|
|
}
|
|
if(fileName == null){
|
|
fileName = "";
|
|
}
|
|
|
|
String c_home = r_call(multi.getParameter("c_home"));
|
|
String c_maker = r_call(multi.getParameter("c_maker"));
|
|
String c_project_no = r_call(multi.getParameter("c_project_no"));
|
|
int fix_field_no = Integer.parseInt(r_call(multi.getParameter("fix_field_no")));
|
|
int field_no = Integer.parseInt(r_call(multi.getParameter("field_no")));
|
|
|
|
|
|
String sql_ok = "delete from tbl_apply_field where c_home = " + c_home + " and c_maker = " + c_maker + " and c_project_no = " + c_project_no;
|
|
stmt2.execute(sql_ok);
|
|
int c_order = 0;
|
|
for (int i = 1; i < field_no + 1 ; i++){
|
|
if( r_call(multi.getParameter("f_" + i + "_1")).equals("0")){
|
|
c_order = c_order + 1;
|
|
sql_ok = "insert into tbl_apply_field (c_home,c_maker,c_project_no,c_relation,c_use_field,c_name,c_type,c_content,c_order,c_use,c_date) values(";
|
|
sql_ok = sql_ok + c_home + "," + c_maker + "," + c_project_no + "," + i;
|
|
sql_ok = sql_ok + ", '" + r_call(multi.getParameter("f_"+i+"_5")) + "' ";
|
|
sql_ok = sql_ok + ", '" + r_call(multi.getParameter("f_"+i+"_2")) + "' ";
|
|
sql_ok = sql_ok + ", " + r_call(multi.getParameter("f_"+i+"_3")) + " ";
|
|
if(r_call(multi.getParameter("f_"+i+"_3")).equals("2")){
|
|
sql_ok = sql_ok + ", '" + r_call(multi.getParameter("f_"+i+"_4")) + "' ";
|
|
}
|
|
if(r_call(multi.getParameter("f_"+i+"_3")).equals("1") || r_call(multi.getParameter("f_"+i+"_3")).equals("3")){
|
|
sql_ok = sql_ok + ", '' ";
|
|
}
|
|
if(r_call(multi.getParameter("f_"+i+"_3")).equals("4")){
|
|
if(!a_file[i].equals("")){
|
|
sql_ok = sql_ok + ", '" + a_file[i] + "' ";
|
|
}else{
|
|
sql_ok = sql_ok + ", '" + r_call(multi.getParameter("o_"+i+"_4_2")) + "' ";
|
|
}
|
|
}
|
|
sql_ok = sql_ok + ", " + c_order + ",0,now())";
|
|
stmt2.execute(sql_ok);
|
|
%>
|
|
<%
|
|
}
|
|
}
|
|
|
|
|
|
%>
|
|
|
|
<script>
|
|
alert("Has been applied");
|
|
parent.location.href="list.jsp?c_project_no=<%=c_project_no%>";
|
|
</script>
|
|
<%@ include file="/field_manager/include/manager_bottom.jsp"%>
|