package org.tyler.ctiRadius;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

import javax.naming.*;
import javax.sql.DataSource;

public class PrePayment1 extends HttpServlet{
	public void doGet(HttpServletRequest request,
						HttpServletResponse response)
			throws IOException,ServletException{
		response.setContentType("text/xml;charset=UTF-8");
		PrintWriter out=response.getWriter();
		out.println("<PrePayment>");
		String f1=request.getParameter("f1");	//主叫號碼
		out.println("	<RtnCode>"+f1+"</RtnCode>");			
		String f2=request.getParameter("f2");	//被叫號碼				
		out.println("	<RtnCode>"+f2+"</RtnCode>");
		String f3=f2.substring(0,1);			//取被叫號碼第一位賦值給F3
		out.println("	<RtnCode>"+f3+"</RtnCode>");
		int k=Integer.parseInt(f3);				//類型轉(zhuǎn)換
		out.println("	<RtnCode>"+k+"</RtnCode>");
		String f4=request.getParameter("f4");	//取電話詳單ID
		int id=Integer.parseInt(f4);			//類型轉(zhuǎn)換
		String f5=request.getParameter("f5");	//判斷是否需要還費標(biāo)識
		String endtime=request.getParameter("endtime");	//通話結(jié)束時間
		out.println("	<RtnCode>"+endtime+"</RtnCode>");
		//String類型轉(zhuǎn)換成Date類型，如果時間不為MULL，則需要修改通話結(jié)束時間。
		Date end = null;
		if(endtime!=null){
			SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
			try {
				end = sdf.parse(endtime);
				} catch (ParseException pe) {
					System.out.println(pe.getMessage());
			}  
		}
		//判斷主叫號是否為空
		if(f1==null){
			out.println("	<RtnCode>501</RtnCode>");
		}
		else{
			Connection conn = null;
			try{
				Context ctx = new InitialContext(); //得到初始化上下文
				Object obj = ctx.lookup("java:PostgresDS");//查找連接池
				DataSource ds = (DataSource) obj;//轉(zhuǎn)換成DataSource
				conn=ds.getConnection();
				Statement stmt=conn.createStatement();
				//f5為判斷是否需要還費的關(guān)鍵字，為空還費，否則，不還.
				if(f5==null){
				ResultSet rs=stmt.executeQuery("select * from addressnum where number=" + f1);
				if(rs.next()){
					float money1=rs.getFloat("money");	//余額
					out.println("	<RtnCode>"+money1+"</RtnCode>");
					rs.close();
					rs=stmt.executeQuery("select * from rate where prefix=" + k);
				if(rs.next()){
							
				}
				else{
					out.println("	<RtnCode>404</RtnCode>");
				}
				float rate=rs.getFloat("rate");	//費率
				out.println("	<RtnCode>"+rate+"</RtnCode>");
				rs.close();
					float money=money1+rate;
					out.println("	<RtnCode>"+money+"</RtnCode>");
					stmt.executeUpdate("update addressnum set money='"+money+"' where number='"+f1+"'");
				}
				else{
					out.println("	<RtnCode>404</RtnCode>");
				}
			}
				//判斷時間時間是否為空，用來判斷掛機類型，從而根據(jù)通話情況選擇不同操作。
				if(endtime==null){
				//根據(jù)id修改表teleinfo（通話記錄）中字段isthrough（是否通話，0.未通話1.已通話）
				stmt.executeUpdate("update teleinfo set isthrough=0 where id='"+id+"'");
				}
				else{
				ResultSet rs=stmt.executeQuery("select * from teleinfo where id='"+id+"'");
				rs.next();
				Date starttime=rs.getTimestamp("starttime");
				rs.close();
				out.println("	<RtnTime>"+starttime+"</RtnTime>");
				 long m1 = Math.abs(end.getTime() - starttime.getTime()) ; //兩時間之差
				 out.println("	<RtnTime>"+m1+"</RtnTime>");
				 double t1=m1/60000.0;
				 out.println("	<RtnTime1>"+t1+"</RtnTime1>");
				 int t2=(int)Math.ceil(t1);
//				 long t2=(long)(t1+0.99);
				 out.println("	<RtnTime2>"+t2+"</RtnTime2>");
				 
				 rs=stmt.executeQuery("select * from rate where prefix=" + k);
				 rs.next();
				 float money2=rs.getFloat("rate")*t2;
				 out.println("	<Rtnmoney2>"+money2+"</Rtnmoney2>");
				 rs.close();
				//根據(jù)id修改表teleinfo（通話記錄）中字段isthrough（是否通話，0.未通話1.已通話）和字段endtime（通話結(jié)束時間）	
				stmt.executeUpdate("update teleinfo set totalmoney='"+money2+"',endtime='"+end+"' where id='"+id+"'");	
				}
				stmt.close();
				conn.close();

			}
			catch(SQLException e){
				out.println("	<RtnCode>502</RtnCode>");
				out.print("	<ErrText>");
				out.print(e.getMessage());
				out.print("</ErrText>");
			}
			catch(NamingException e){
				out.println("	<RtnCode>503</RtnCode>");
			}
		}
		out.println("</PrePayment>");
	}
	public void doPost(HttpServletRequest request,
						HttpServletResponse response)
			throws IOException,ServletException{
		doGet(request,response);
	}
}