package com.tsinghuait.st0717.hospitalsystem.servlet;

import java.io.IOException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.swing.JOptionPane;

import com.tsinghuait.st0717.hospitalsystem.service.InHospitalService;
import com.tsinghuait.st0717.hospitalsystem.service.PatientService;

public class InHospitalServlet extends BaseServltes {
	InHospitalService ihs=new InHospitalService();
	protected RequestDispatcher delete(HttpServletRequest request,
			HttpServletResponse arg1) throws ServletException, IOException {
		// TODO Auto-generated method stub
		return null;
	}
	protected RequestDispatcher executeQuery(HttpServletRequest request,
			HttpServletResponse reponse) throws ServletException, IOException {
		String name=(String)request.getSession().getAttribute("doctorLoginTree");
		System.out.println("Login_patientMcName:"+name);
		PatientService patientService=new PatientService();
		String sql="select * from patient where isfinished=0 and mcName='"+name+"'";
	    request.setAttribute("inHospitalPatient",patientService.selePatient(sql));			
		RequestDispatcher rd=request.getRequestDispatcher("view_linli/inHospitalPatient.jsp");
		return rd;
	}
	protected RequestDispatcher insert(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		RequestDispatcher rd=null;
		//獲得病人的姓名
		//String patientName=request.getParameter("patientName");
		String patientName=getParamByMyFilter(request, "patientName");
		String pId=request.getParameter("pId");
		int patientId=Integer.parseInt(pId);
		//按病床編號查詢病床Id
		String bedNo=request.getParameter("bed");
		String sql1="select id from sickbed where bedNo='"+bedNo+"'";
		int bedid1=ihs.returnId(sql1);
		String startdate=request.getParameter("startdate");
	    String enddate=request.getParameter("enddate");		
		//獲得住院和出院的時間差
		int day=ihs.getdate(startdate, enddate);
		if(day<0)
		{
			 rd=request.getRequestDispatcher("/inHospitalServlet?opertion=4&name="+patientName+"&id="+patientId);
		     JOptionPane.showMessageDialog(null," 您選擇的住院時間或出院時間不正確");
		}
		else
		{
		String sql2="select sinkbedId from sinkbedSchedule where startTime='"+startdate+"' and endTime='"+enddate+"'";
	    int bedid2=ihs.returnSickbedId(sql2);
	    if(bedid1==bedid2)
	    {
	    	    rd=request.getRequestDispatcher("/inHospitalServlet?opertion=4&name="+patientName+"&id="+patientId);
		        JOptionPane.showMessageDialog(null,"該病床已在該段時間被使用");
	    }
	    else
	    {
	    	String sql11="insert into sinkbedSchedule values ("+bedid1+",'"+startdate+"','"+enddate+"',null)";
	    	String sql22="insert into stayInHp values("+patientId+","+bedid1+","+day+")";
	    	String sql33="update patient set isfinished=1 where oid="+patientId;
	    	boolean flag1=ihs.insertInHospital(sql11);
	    	boolean flag2=ihs.insertInHospital(sql22);
	    	boolean flag3=ihs.updateInHospital(sql33);
	    	System.out.println("flag1:"+flag1+"\n flag2:"+flag2+"\n flag3:"+flag3);
	    	if(flag1==false||flag2==false||flag3==false)
	    	{
	    		System.out.println("添加失敗");
	    		rd=request.getRequestDispatcher("/inHospitalServlet?opertion=4&name="+patientName+"&id="+patientId);
	    		JOptionPane.showMessageDialog(null,"住院添加失敗，請確認(rèn)您的信息是否準(zhǔn)確");
	    	}
			request.getSession().setAttribute("locationURL", "patientServlet?isfinished=1");
	        rd=request.getRequestDispatcher("/submits.jsp");
	       /*rd=request.getRequestDispatcher("/patientServlet?isfinished=1");
	       JOptionPane.showMessageDialog(null,"住院添加成功");*/
	      }
		}
		return rd;
	}
	protected RequestDispatcher select(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
        //	獲得病人名字
		String patientName=getParamByMyFilter(request, "name");
		System.out.println("patientName2:"+patientName+" \np:");
		//獲得病人編號
		String i=request.getParameter("id");
		int oid=0;
		if(i!=null){
			oid=Integer.parseInt(i);
		}
		System.out.println("oid:"+oid);
		request.setAttribute("pName",patientName);
		request.setAttribute("oid", oid);
		String sqlbedNo="select bedNo from sickbed where isUseable=0";
		request.setAttribute("bedNo", ihs.selectbedNo(sqlbedNo));
		RequestDispatcher rd=request.getRequestDispatcher("view_linli/addInHospital.jsp");
		return rd;
	}
	protected RequestDispatcher update(HttpServletRequest request,
			HttpServletResponse arg1) throws ServletException, IOException {
		// TODO Auto-generated method stub
		return null;
	}

}