<%@ page import="com.engine.kq.biz.KQFormatData" %>
<%@ page import="weaver.conn.RecordSet" %>
<%@ page import="weaver.general.Util" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%
    try{

        String signdate = Util.null2String(request.getParameter("signdate"));
        String userid = Util.null2String(request.getParameter("userid"));
        String to_signdate = Util.null2String(request.getParameter("to_signdate"));
        if(signdate.length() == 0){
            out.println("param signdate is null:<br/>");
            return ;
        }
        if(userid.length() == 0){
            out.println("param userid is null:<br/>");
            return ;
        }
        if(to_signdate.length() == 0){
            out.println("param to_signdate is null:<br/>");
            return ;
        }
        RecordSet rs1 = new RecordSet();
        String sql = "insert into HRMSCHEDULESIGN(userId,userType,signType,signDate,signTime,clientAddress,isInCom,timeZone,belongdate,signfrom,longitude,latitude,addr) "
                + "select userId,userType,signType,'"+to_signdate+"',signTime,clientAddress,isInCom,timeZone,belongdate,signfrom,longitude,latitude,addr from HRMSCHEDULESIGN where userid = "+userid+" and signdate = '"+signdate+"' ";
        if(sql.length() > 0){
          rs1.executeUpdate(sql);
        }
        KQFormatData kqFormatData = new KQFormatData();
        kqFormatData.formatDate(userid, to_signdate);
        out.print("ok");
    }catch (Exception e){
        e.printStackTrace();
    }

%>