<%@ page language = "java" import="java.sql.*,java.text.*,java.util.*,java.net.*,java.io.*,poolcon.*,Utils.*"%>

<jsp:useBean id = "validate" scope="page" class="validation.FieldValidations" />
<%@ taglib uri="http://jakarta.apache.org/taglibs/image-1.0" prefix="img" %>
<%
/*
@ rajeev gupta
* All variables start with s are string type
* All variables start with n are integer type
* All variables start with d are double type
*/
Properties props = new Properties();
String contextName=""+getServletContext().getAttribute("contextName");
String rootpath=request.getContextPath();;
contextName = rootpath;
Connection conn = null;
ResultSet rs = null; 
Statement st=null;Statement st1=null,stProd = null;
ResultSet rs1 = null;
//String canonedge = "http://www.canon.co.in/edge";
String canonedge = "http://www.canonedge.com/edge/user/register";

try{
	javax.naming.Context initContext = new javax.naming.InitialContext();
	javax.naming.Context envContext  = (javax.naming.Context)initContext.lookup("java:/comp/env");
	javax.sql.DataSource ds = (javax.sql.DataSource)envContext.lookup("jdbc/wms");
	conn = ds.getConnection();
	
	st = conn.createStatement();
	st1 = conn.createStatement();
	stProd = conn.createStatement();
	
	String s_hidfld = request.getParameter("hidfld");boolean flag=true;
	String s_custId="",s_custIdp="",s_serialNo="",s_serialNop="";
	String s_model = "", model = "", product = "", prodgroup = "", modelSearchP = "";	
	
	String s_buffer1 = "";
	String s_sub1 = "";
	String s_tempid1="";
	
	ArrayList prodList = new ArrayList() , modList = new ArrayList(), prodGroupList = new ArrayList();
	
	rs=stProd.executeQuery("SELECT b.prod_id,b.product FROM ca_spdcl_product_group AS a, ca_spdcl_products AS b WHERE a.prod_id=b.prod_id GROUP BY b.prod_id,b.product ORDER BY b.product ASC");
	while(rs.next()){
		int id = rs.getInt(1);
		String p = rs.getString(2);
		HashMap m = new HashMap();
		m.put("id",""+id);
		m.put("product",p);
		prodList.add(m);
		m = null;
	}
	//Getting models
	rs = st.executeQuery("SELECT a.prod_group_id,a.prod_id FROM ca_spdcl_product_group AS a, ca_spdcl_products AS b WHERE a.prod_id=b.prod_id ORDER BY a.prod_group ASC");
	while(rs.next()){//START2
		int n_id = rs.getInt(1);
		int pid = rs.getInt(2);
		String flag1 = "true";
		String s_chk = "false";
		int i = 0;
		rs1 = st1.executeQuery("SELECT model_id,model_code,standard_warranty FROM ca_spdcl_model WHERE prod_group_id="+n_id+" AND prod_id='"+pid+"' ORDER BY model_code ASC");
		while(rs1.next()){//START3
			if(flag1.equals("true")){
				s_buffer1 = s_buffer1+"var subb"+n_id+"=new Array('";
				s_tempid1 = s_tempid1+"var tempidb"+n_id+"=new Array('";
				s_sub1=s_sub1+"case \""+n_id+"\" :len = subb"+n_id+".length;\n";
				//s_sub1=s_sub1+" document.frm1.model.options.length = len+1;\n";
				s_sub1=s_sub1+" obj.actb_keywords = subb"+n_id+";\n";
				s_sub1=s_sub1+"for(i=0; i<len; i++){\n";				
				//s_sub1=s_sub1+"document.frm1.model.options[i+1].text = subb"+n_id+"[i];\n";
				//s_sub1=s_sub1+"document.frm1.model.options[i+1].value = tempidb"+n_id+"[i];\n";
				s_sub1=s_sub1+"}break;\n";
				
				
				
			}			
			if(s_chk.equals("true")){
				s_buffer1 = s_buffer1+",'";
				s_tempid1 = s_tempid1+",'";					
			}
			String s_modid=rs1.getString(1);
			String s_modname=rs1.getString(2);
			String s_modstdwar=rs1.getString(3);
			
			s_buffer1 = s_buffer1+s_modname+"'";
			s_tempid1 = s_tempid1+s_modid+"'";

			s_chk = "true";	
			flag1 = "false";
			i++;
		}//START3 ENDS
		if(i!=0){
			s_buffer1 = s_buffer1+ ");\n";	
			s_tempid1 = s_tempid1+ ");\n";
		}				
	}//START2 ENDS
	//Getting Models Ends
	String radioemailid = "sid";
	if(s_hidfld != null){
		radioemailid = request.getParameter("radioemailid");
		if(radioemailid==null)radioemailid="sid";		
		String _from=request.getParameter("_from");
		if(_from.equals("1")){
			s_custId= request.getParameter("custId").trim();
			s_custIdp=s_custId;
			
			if(s_custId.equals("")){
				if(radioemailid.equals("eid")){
					s_custId= "Enter Your Email Id";
				}else{
					s_custId= "Enter Your Service Id";
				}
				flag=false;
			}else{
				if(radioemailid.equals("eid")){
					validate.setValueForEmails(s_custId);
					s_custId=validate.getValueForEmails();					
				}else{				
					validate.setValueForAlfaNumeric(s_custId);
					s_custId=validate.getValueForAlfaNumeric();
				}
				
				if(!s_custId.equals("")){
					flag=false;
				}else{
					if(radioemailid.equals("eid")){
						rs = st.executeQuery("SELECT * from ca_customer_details where email = '"+s_custIdp+"'");
					}else{
						rs = st.executeQuery("SELECT * from ca_customer_details where customer_id = '"+s_custIdp+"'");
					}
					if(rs.next()){
						s_custIdp = rs.getString("customer_id");
					}else{
						if(radioemailid.equals("eid")){
							s_custId= "Invalid Customer Email Id";
						}else{
							s_custId= "Invalid Customer Service Id";
						}
						flag=false;
					}
				}
			}
			if(flag){
%>
					<jsp:forward page="CustDetails.jsp">
					 <jsp:param name="custId" value="<%=s_custIdp%>" />
					</jsp:forward>
<%
					return;
			}
		}else{
			product = request.getParameter("product");
			if(!product.equals("0")){				
				rs=stProd.executeQuery("SELECT a.prod_group_id,a.prod_group FROM ca_spdcl_product_group AS a, ca_spdcl_products AS b WHERE a.prod_id=b.prod_id AND b.prod_id = '"+product+"' ORDER BY b.product ASC");
				while(rs.next()){
					int id = rs.getInt(1);
					String p = rs.getString(2);
					HashMap m = new HashMap();
					m.put("id",""+id);
					m.put("prodgroup",p);
					prodGroupList.add(m);
					m = null;
				}
			}
			
			prodgroup = request.getParameter("prodgroup");
			if( prodgroup == null ) prodgroup = "0";
			if( prodgroup.equals("") ) prodgroup = "0";
						
			String modelSearch = request.getParameter("modelSearch");
			if(modelSearch==null)modelSearch="";
			modelSearchP = modelSearch;
			
			rs=stProd.executeQuery("SELECT model_id FROM ca_spdcl_model WHERE prod_id = "+product+" AND prod_group_id = '"+prodgroup+"' AND LTRIM(UPPER(model_code))=LTRIM(UPPER('"+modelSearch+"'))");
			if(rs.next()){
				model = rs.getString("model_id");				
			}else{
				model = "";
				s_model = "Invalid Model";
				flag=false;
			}
				
			//model = request.getParameter("model");
			if(model.equals("0")){
				s_model = "Enter Model";
				flag=false;
			}
			s_serialNo= request.getParameter("serialNo").trim();
			s_serialNop=s_serialNo;
			if(s_serialNo.equals("")){
				s_serialNo= "Enter Serial Number";
				flag=false;
			}else if(flag){
				validate.setValueForAlfaNumeric(s_serialNo);
				s_serialNo=validate.getValueForAlfaNumeric();
				if(!s_serialNo.equals("")){
					flag=false;
				}else{
					String modelCode = "";
					rs = st.executeQuery("SELECT model_code from ca_spdcl_model WHERE model_id = '"+model+"'");					
					if(rs.next()){
						modelCode = rs.getString(1);
					}
					rs = st.executeQuery("SELECT * FROM ca_wty_validation WHERE LTRIM(UPPER(mserialno)) = LTRIM(UPPER('"+Utils.trim0(s_serialNop)+"')) AND model_id='"+model+"'");
					if(rs.next()){
						Statement stt = conn.createStatement();
						ResultSet rss = stt.executeQuery("SELECT * FROM ca_dealer_swap_stock WHERE is_used='0' AND model_id = '"+model+"' AND UPPER(LTRIM(mserialno)) =  UPPER(LTRIM('"+Utils.trim0(s_serialNop)+"'))");
						if(rss.next()){
							s_serialNo = "Please check the serial number or you may please try removing 0 on the prefix of the serial number or you may <A HREF=javascript:escalate('"+(Utils.trim0(s_serialNop)).replaceAll(" ","%20")+"','0','"+model+"','"+modelCode.replaceAll(" ","%20")+"')><FONT COLOR=blue SIZE=3><B>click here to Escalate</B></FONT></A> this Model Serial";
							flag=false;
						}else{
							//CHANGE DONE ON 04/08/2008
							String modelname = rs.getString("model");
							String warrantyStartDate=rs.getString("wty_start_date");
							String warrantyEndDate=rs.getString("wty_end_date");
							String wtyEndDate="";
							if(warrantyStartDate==null)warrantyStartDate="";
							if(warrantyEndDate==null)warrantyEndDate="";
							s_serialNo= "Serial No is already Registered. ";
							if(warrantyStartDate.equals(warrantyEndDate))
								s_serialNo+="Canon India does not provide Warranty on this Product.";
							else{
								try{
									SimpleDateFormat sdf =new SimpleDateFormat("dd/MM/yyyy");
									//(COMMENTED ON 04/08/2008)s_serialNo= "Serial No is already Registered. Warranty End Date is : "+sdf.format(rs.getDate("wty_end_date"));
									wtyEndDate=sdf.format(rs.getDate("wty_end_date"));
								}catch(Exception e){
									wtyEndDate="NA";
								}
								s_serialNo+="Warranty End Date is : "+wtyEndDate+".";
							}
							//CHANGE DONE ON 04/08/2008 END
							rs = st.executeQuery("SELECT * from ca_customer_products where LTRIM(UPPER(serial_no)) = LTRIM(UPPER('"+Utils.trim0(s_serialNop)+"')) AND model_id='"+model+"' AND is_unregistered = 0");
							if(rs.next()){
								
							}else{
								s_serialNo = "<font color=green>This is a Valid Serial Number! If you want to register the same, kindly login with your Email ID below or <a href='"+canonedge+"'>Click here</a>.</font>";
								flag=false;								
							}
						}
					}else{
						s_serialNo = "Please check the serial number or this product has been purchased from other than Canon India or <BR>Canon Singapore sales network or you may please try removing 0 on the prefix of the serial number or you may <A HREF=javascript:escalate('"+(Utils.trim0(s_serialNop)).replaceAll(" ","%20")+"','0','"+model+"','"+modelCode.replaceAll(" ","%20")+"')><FONT COLOR=blue SIZE=3><B>click here to Escalate</B></FONT></A> this Model Serial";
						flag=false;
					}
				}
			}else{
				s_serialNo = "";
			}
		}
	}
	//session.setAttribute("renderImage",renderedImage);
%>
<jsp:include page="commontemplate/header.jsp"/>
<SCRIPT language=JavaScript>
<!--
	<%= s_buffer1 %>
	<%= s_tempid1 %>
	var isBusy = 0;
	var explStyle="";
	var explorerName=navigator.appName;
	if(explorerName=="Netscape")
		explStyle="table-row";
	else
		explStyle="block";
	function chanmenu1(menuvalue){
		var len = 0;
		document.frm1.modelSearch.value='';
		obj.actb_keywords = new Array('');
		switch (menuvalue){
			<%= s_sub1 %>		
			default : 
					//document.frm1.model.options.length = 1;
					//document.frm1.model.options[0].selected = true;	
		}
	}
	function holdindex1(){
		/*if(document.frm1.product.selectedIndex == 0){
			document.frm1.model.options.length = 1;
			document.frm1.model.options[0].selected = true;
		}*/
	}

	function escalate(mserialno,id,modelId,modelCode){
		var theURL = '<%=rootpath%>/wtyregis/Escalation.jsp?mserialno='+mserialno+'&id='+id+'&modelId='+modelId+'&custModel='+modelCode;
		window.open(theURL,'window2','resizable=0,scrollbars=1,menubar=0,directories=0,status=0,location=0,width=500,height=520');		
	}
	function switchMode(){
		var obj = document.frm.radioemailid;
		if(obj[0].checked){
			document.getElementById("modeText").innerHTML='Customer Service Id *';
			//document.getElementById("forgetServiceId").style.display=explStyle;	
		}else{
			document.getElementById("modeText").innerHTML='Customer Email Id *';	
			//document.getElementById("forgetServiceId").style.display='none';		
		}		
	}
	var customarray=new Array('an apple','alligator','elephant','pear','kingbird','kingbolt', 'kingcraft','kingcup','kingdom','kingfisher','kingpin');
	function getProductGroups(prodid,formName,fieldName){
		if(isBusy==1){
			return;			
		}		
		var xmlHttpReq = false;
	    var self = this;
	    // Mozilla/Safari
	    if (window.XMLHttpRequest) {
	        self.xmlHttpReq = new XMLHttpRequest();
	    }
	    // IE
	    else if (window.ActiveXObject) {
	        self.xmlHttpReq = new ActiveXObject("Microsoft.XMLHTTP");
	    }
		if (!self.xmlHttpReq) {
			alert('Giving up :( Cannot create an XMLHTTP instance) Please check the Browser Settings');
			isBusy=0;
			return false;
		}
		document.frm1.modelSearch.value='';
		obj.actb_keywords = new Array('');
		
	    self.xmlHttpReq.open('POST', '<%= contextName %>/modules/admin/cls/Cls', true);
	    self.xmlHttpReq.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
	    self.xmlHttpReq.onreadystatechange = function() {
	        if (self.xmlHttpReq.readyState == 4) {
				if (self.xmlHttpReq.status == 200) {
					if(self.xmlHttpReq.responseText!=""){							
						var str=eval("("+self.xmlHttpReq.responseText+")");
						str=eval(str);
						arr=str.productGroups;
						
						eval("document."+formName+"."+fieldName+".length=0");
						if(arr.length != 0){
							for(var i=0;i<arr.length;i++){
								if(i==0){
									eval("++document."+formName+"."+fieldName+".length");									
									eval("document."+formName+"."+fieldName+".options[0].value='0'");
									eval("document."+formName+"."+fieldName+".options[0].text='--Select Product Group--'");
								}
								if(arr[i].length!=0){
									eval("++document."+formName+"."+fieldName+".length");									
									eval("document."+formName+"."+fieldName+".options["+(i+1)+"].value=arr[i].prod_group_id");
									eval("document."+formName+"."+fieldName+".options["+(i+1)+"].text=arr[i].prod_group");
								}
							}
						}else{										
							eval("++document."+formName+"."+fieldName+".length");
							eval("document."+formName+"."+fieldName+".options[0].value='0'");
							eval("document."+formName+"."+fieldName+".options[0].text='--Select Product Group--'");
						}
						isBusy=0;							
					}
				} else {
	                alert("Status Code: "+self.xmlHttpReq.status+'. There was a problem with the request.');
	            }
			}
		}			
		if(isBusy==0)
			self.xmlHttpReq.send('mappingPath=getProductGroups&prodid='+prodid);			
	}
	//-->
	</SCRIPT>	
	<script language="JavaScript1.2" type="text/javascript" src="<%=rootpath%>/js/autosuggest/actb.js"></script>
	<script language="JavaScript1.2" type="text/javascript" src="<%=rootpath%>/js/autosuggest/common.js"></script>

<TABLE cellSpacing=0 cellPadding=0 width=100% border=0>
  <TBODY>
  <TR>
    <TD width=20><IMG height=20 
      src="images/spacer(1).gif" 
      width=20></TD>
    <TD >
     <IMG height=5 src="images/spacer(1).gif" 
      width=100%><BR><IMG height=40 src="images/managewty.png" 
      width=250><BR>
      
      
      
      
      <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR>
          <TD>
          <IMG height=1 src="images/pixel_grey.gif" width=100%></TD>
        </TR>
        </TBODY>
      </TABLE>
      
							<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
						        <TBODY>
							        <TR>
							          <TD class=normfont>            
							          	    <TABLE cellSpacing=0 cellPadding=2 width=700 border=0>
								              	<TBODY>							              
													 <FORM name="frm1" action="CustRegistration.jsp" method="post">
														  <TR>
											                <TD colSpan=3>
											                	<font size=2 color='gray'><BR>Check Warranty Status of your Canon Product.<sup>**</sup>
											               	</TD>
											        	  </TR>
												 		  <TR>
											                <TD class=subheaders width="100px" valign="top">&nbsp;Product Category</TD>
											                <TD colspan=2 width="600px">
											                	<select name="product" style='width:230px' onchange="javascript:getProductGroups(this.value,'frm1','prodgroup')">
																	<option value='0'>--Select Product Category--</option>
																	<%
																		for(int i=0;i<prodList.size();i++){
																			HashMap map=(HashMap)prodList.get(i);
																			String selInd="";
																			String id=(String)map.get("id");
																			String val=(String)map.get("product");
																			if(id.equals(product))
																				selInd="SELECTED";
																			else
																				selInd="";
																			out.println("<option "+selInd+" value='"+id+"'>"+val+"</option>");
																		}
																	%>
																</select>
															</td>
														   </TR>
														   <TR>
											                <TD class=subheaders width="100px" valign="top">&nbsp;Product Group</TD>
											                <TD colspan=2 width="600px">
											                	<select name="prodgroup" style='width:230px' onchange="chanmenu1(this.options[this.selectedIndex].value);holdindex1()">
																	<option value='0'>--Select Product Group--</option>																
																	<%
																		for(int i=0;i<prodGroupList.size();i++){
																			HashMap map=(HashMap)prodGroupList.get(i);
																			String selInd="";
																			String id=(String)map.get("id");
																			String val=(String)map.get("prodgroup");
																			if(id.equals(prodgroup))
																				selInd="SELECTED";
																			else
																				selInd="";
																			out.println("<option "+selInd+" value='"+id+"'>"+val+"</option>");
																		}
																	%>
																</select>
															</td>
														   </TR>
									        				<TR>
												                <TD class=subheaders width="100px" valign="top">&nbsp;Model *</TD>
												                <TD colspan = 2 width="600px">
												                	<input type='hidden' name='model' />						
																		<input size='30' autocomplete=off type='text' class='flat' id='tb' name='modelSearch' /> 
																		<script language='javascript'>
																			var obj = actb(document.getElementById('tb'),new Array());
																			chanmenu1(document.frm1.prodgroup.value);
																			document.frm1.modelSearch.value='<%=modelSearchP%>';
																		</script>
																	<BR>
																	<font color='#FF0000' size=1>Note: For quick selection of model, use numeric characters of your product</font>
																	<br><font face = arial color = red size=1><%= s_model %></font>
												                </TD>
									        				</TR>					        
												            <TR>
												                <TD class=subheaders width="100px" valign="top">&nbsp;Serial Number *</TD>
												                <TD width="400px"><INPUT class='flat' maxLength=50 size=30 name="serialNo" value="<%= s_serialNop %>" onblur='javascript:convertSerial(this)'> &nbsp;&nbsp;<INPUT TYPE="hidden" name="hidfld" value='send'>
																<INPUT TYPE="hidden" name="_from" value='2'></td>
																<td width="200px" valign="top"><INPUT type=image height=20 width=71 
												                  src="images/submit_butt.gif" border=0 name=image> 
												                  <A onclick="return rSet();" href="http://www.canon.co.in/reset"></A>
												                </TD>
												        	</TR>
												        	<TR>
												                <TD class=subheaders width="100px" valign="top">&nbsp;</TD>
												                <TD colspan=2 width="600px"><font face = arial color = red size=1><%= s_serialNo %></font>
																</td>															
												        	</TR>
											        	</FORM>
											        	<FORM name="frm" action="CustRegistration.jsp" method="post">
											        		<INPUT TYPE="hidden" name="hidfld" value='send'>
															<INPUT TYPE="hidden" name="_from" value='1'>
											        		<TR>
																<TD colSpan=3 width="700px"><IMG height=10 src="images/sp.gif" width=1></TD>
															</TR>
															<TR>
																<TD colSpan=3 width="700px"><font size=2 color='gray'>If you are already registered with us kindly enter your Customer Email Id / Customer Id to View your profile or register product and related purchase informations.</TD>
															</TR>
															<TR>
																<TD align = left class=subheaders width="100px" valign="top"></TD>
																<TD valign="middle" colspan=2 width="600px"><FONT SIZE=1><INPUT class='flat' type='radio' <%=radioemailid.equals("sid")?"checked=true":""%> value='sid' name="radioemailid" onclick='javascript:switchMode()'> Customer Service Id <INPUT class='flat' type='radio' <%=radioemailid.equals("eid")?"checked=true":""%> value='eid' name="radioemailid" onclick='javascript:switchMode()'> Customer Email Id</FONT></TD>
															</TR>
															
															 <TR>
																<TD width="100px" align = left class=subheaders  valign="top" id='modeText'></TD>
																<TD width="400px" valign="middle">
																	<INPUT class='flat' maxLength=50 size=30 name="custId" value="<%= s_custIdp %>"><br><font face = arial color = red size=1><%= s_custId %></font> &nbsp;&nbsp;
																</td>
																<td valign="top" width="200px"><INPUT type=image height=20 width=71 
																  src="images/submit_butt.gif" border=0 name=image> 
																  <A onclick="return rSet();" 
																  href="http://www.canon.co.in/reset"></A>
																</TD>
															 </TR>
															 <TR id='forgetServiceId' style='display:none;'>
												                <TD colSpan=3 width="700px"><A HREF="GetCustId.jsp">Forgot your Customer Service Id ?</A></TD>
												             </TR>
															 <TR>
																<TD colSpan=3 width="700px"><IMG height=10 src="images/sp.gif" width=1></TD>
												            </TR>											             
															<TR>
											                	<TD colSpan=3 width="700px"><IMG height=10 src="images/sp.gif" width=1></TD>
											                </TR>											           
												            <TR>
												                <TD colSpan=3 width="700px"><font color='#FF0000' size=1>* mandatory field</font> 
												                </TD>
												            </TR>
															<TR>
												                <TD colSpan=3 width="700px"><font color='#FF0000' size=1>** Valid for products Imported and Marketed by Canon India Pvt Ltd Only. <BR> 
																** Valid for Digital Cameras and Digital Camcorders sold by Canon Singapore Authorised sales network with valid Singapore-India Warranty Card.</font> 
																</TD>
															</TR>
											        	</FORM>
						              				</TBODY>						              				
						              			</TABLE>
					              		
									</TD>
								</TR>
								</TBODY>
						</TABLE>
					</TD>
				</TR>				
			</TBODY>
		</TABLE>
		
		<SCRIPT LANGUAGE="JavaScript">
<!--
function popopen(){
window.open('tnc.html','window2','resizable=1,scrollbars=1,menubar=1,directories=0,status=0,location=0,width=600,height=500');
}
switchMode();
//-->
</SCRIPT>
<jsp:include page="commontemplate/footer.jsp"/>
<%
}catch(SQLException sqe){
	out.println(sqe.getMessage());
}catch(Exception ex){
	out.println(ex.getMessage());
}
finally
		{
			try
			{	
				if(rs!= null){rs.close();rs=null;}
				if(st!= null){st.close();st=null;}
				if(conn!=null){conn.close(); conn=null;}
			}
			catch(Exception e)
			{	
				System.out.println(e.getMessage());
			}
		}
%>