<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<jsp:useBean id="td_pjm" class="td.personaljob"/>
<jsp:useBean id="td_pjm_data" class="td.personaljobdata"/>
<%@ include file="lib/config.jsp" %>
<%
		if(!td_pjm.init(mysqlDriver,mysqlUrl,mysqlUser,mysqlPsw))
		{
		    out.println("<script language=\"JavaScript\" type=\"text/javascript\">alert(\"Fail to Connect MySQL Server!  Please check the settings!\");window.close();</script>");
		}
    HttpSession mysession = request.getSession();
		String username = (String)mysession.getAttribute("td_pjm_user");
		String password = (String)mysession.getAttribute("td_pjm_pass");
		
    td_pjm.setUsername(username);
		td_pjm.setPasswrod(password);
		
		//驗證未通過
		if(!td_pjm.logcheck())
		{
		    out.println("<script language=\"JavaScript\" type=\"text/javascript\">alert(\"Wrong username or password!\");window.close();location.href=\"index.jsp\";</script>");
		}
		
		String action = request.getParameter("action");
		if(action == null || action.equals(""))
		{
		    out.println("<script language=\"JavaScript\" type=\"text/javascript\">alert(\"Wrong action!\");window.close();location.href=\"index.jsp\";</script>");
		}
		else if(action.equals("showcop"))
		{
		    //get ID
		    //int id = Integer.parseInt((String)request.getParameter("id"));
				String id = request.getParameter("id");
				if(id == null || id.equals(""))
				{
				    out.println("<script language=\"JavaScript\" type=\"text/javascript\">alert(\"Miss job ID!\");window.close();</script>");
				}
				else
				{
						ResultSet res = null;
						res = td_pjm.getCopInfo(id);
						if(res == null)
						{
						    out.println("<script language=\"JavaScript\" type=\"text/javascript\">alert(\"沒有對應的公司信息！\");window.close();</script>");
						}
						else
						{
						    res.next();
								String cop_name = res.getString("cop_name");
								String cop_mann = td_pjm_data.cop_mann[res.getInt("cop_mann")];
								String cop_cont = res.getString("cop_cont");
								String cop_tel  = res.getString("cop_tel");
								String cop_mail = res.getString("cop_mail");
								if(cop_mail != null && !cop_mail.equals(""))
								{
								    cop_mail = "<a href=\"mailto:"+cop_mail+"\" target=\"_blank\">"+cop_mail+"</a>";
								}
								
								String cop_fax  = res.getString("cop_fax");
								String cop_addr = res.getString("cop_addr");
								String cop_zip  = res.getString("cop_zip");
								String cop_www  = res.getString("cop_www");
								if(cop_www != null && !cop_www.equals(""))
								{
								    cop_www = "<a href=\""+cop_www+"\" target=\"_blank\">"+cop_www+"</a>";
								}
								
								String cop_desc = res.getString("cop_desc");
								String info = "<a href=\"detail.jsp?action=showjob&id="+id+"\" title=\"查看該公司的職位信息\"><font color=\"#FF0000\">查看職位信息</font></a>";
								%>
								<%@ include file="lib/detail_cop.htm" %>
								<%
						}
				}
		}
		else if(action.equals("showjob"))
		{
		    //get ID
		    //int id = Integer.parseInt((String)request.getParameter("id"));
				String id = request.getParameter("id");
				if(id == null || id.equals(""))
				{
				    out.println("<script language=\"JavaScript\" type=\"text/javascript\">alert(\"Miss job ID!\");window.close();</script>");
				}
				else
				{
						ResultSet res = null;
						res = td_pjm.getJobInfo(id);
						if(res == null)
						{
						    out.println("<script language=\"JavaScript\" type=\"text/javascript\">alert(\"沒有對應的職位信息！\");window.close();</script>");
						}
						else
						{
						    res.next();
								String job_name = res.getString("job_name");
								String job_mann = td_pjm_data.job_mann[res.getInt("job_mann")];
								String job_addr = res.getString("job_addr");
								int job_num = res.getInt("job_num");
								String job_get = res.getString("job_get");
								String time = "從"+res.getInt("job_sta")+"至"+res.getInt("job_end");
								String job_grad = td_pjm_data.job_grad[res.getInt("job_grad")];
								String age = res.getInt("job_age1")+"～"+res.getInt("job_age2");
								String job_expe = td_pjm_data.job_expe[res.getInt("job_expe")];
								String job_lang = td_pjm_data.job_lang[res.getInt("job_lang")];
								String job_odem = res.getString("job_odem");
								String job_oget = res.getString("job_oget");
								String info = "<a href=\"detail.jsp?action=showcop&id="+id+"\" title=\"查看該職位的公司信息\"><font color=\"#FF0000\">查看公司信息</font></a>";
								%>
								<%@ include file="lib/detail_job.htm" %>
								<%
						}
				}
		}
		else
		{
		    out.println("<script language=\"JavaScript\" type=\"text/javascript\">alert(\"Wrong action!\");window.close();location.href=\"index.jsp\";</script>");
		}
%>