41 lines
1.9 KiB
Plaintext
41 lines
1.9 KiB
Plaintext
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
|
|
<%@include file="/include/db/db_connect.jsp"%>
|
|
<%@include file="/include/function/function.jsp"%>
|
|
<%request.setCharacterEncoding("utf-8");%>
|
|
|
|
<%
|
|
|
|
String c_ok = r_call(request.getParameter("c_ok"));
|
|
String c_team_no = r_call(request.getParameter("c_team_no"));
|
|
String c_content = r_call(request.getParameter("c_content"));
|
|
String c_point_project_no = r_call(request.getParameter("c_point_project_no"));
|
|
String p1[] = request.getParameterValues("p1");
|
|
String c_value = "";
|
|
int c_point = 0;
|
|
for(int i=0; i< p1.length; i++){
|
|
if(i>0){
|
|
c_value = c_value + "|";
|
|
}
|
|
c_value = c_value + p1[i];
|
|
c_point = c_point + Integer.parseInt(p1[i]);
|
|
}
|
|
|
|
String sql_re = "select * from tbl_point_result where c_point_project_no = "+ c_point_project_no +" and c_team_no = "+ c_team_no +" and c_pointer_no = "+ session.getAttribute("pointer_no") +" ";
|
|
ResultSet rs_re = stmt.executeQuery(sql_re);
|
|
if (rs_re.next()) {
|
|
String sql_ok = "update tbl_point_result set c_value = '"+ c_value +"', c_point = "+ c_point +", c_ok = "+ c_ok +", c_content = '"+ c_content +"', c_update = now() where c_point_project_no = "+ c_point_project_no +" and c_team_no = "+ c_team_no +" and c_pointer_no = "+ session.getAttribute("pointer_no") +" ";
|
|
stmt2.execute(sql_ok);
|
|
|
|
}else{
|
|
String sql_ok = "insert into tbl_point_result (c_point_project_no,c_team_no,c_pointer_no,c_value,c_point,c_content,c_ok,c_date) values (";
|
|
sql_ok = sql_ok + c_point_project_no + "," + c_team_no + "," + session.getAttribute("pointer_no") + ",'" + c_value + "'," + c_point + ",'" + c_content + "'," + c_ok + ",now())";
|
|
stmt2.execute(sql_ok);
|
|
|
|
|
|
}
|
|
rs_re.close();
|
|
|
|
%>
|
|
<script>
|
|
alert("Lo salvé.")
|
|
parent.location.href="insert_go.jsp?c_team_no=<%=c_team_no%>"
|
|
</script>
|
|
<%@include file="/include/db/db_close.jsp"%> |