%@page import="com.rajsoft.CAF.util.DBconnection"%> <%@page import="java.sql.Statement"%> <%@page im" name="description">
<%@page import="java.sql.SQLException"%>
<%@page import="com.rajsoft.CAF.util.DBconnection"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="com.rajsoft.CAF.VO.RoleVO"%>
<%@page import="java.util.Vector"%>
<%@page import="com.rajsoft.CAF.DAO.AccessPermission"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>R.S Administration Interface</title>
<style>
body { background:rgb(4,95,142);
margin-top:20px;}
</style>
<link href="css/style.css" rel="stylesheet" type="text/css" />
<link href="css/menu.css" rel="stylesheet" type="text/css" />
<link type="icon/png" rel="icon" href="images/icon.png" />
<script src="js/jquery.js" type="text/javascript"></script>
<script src="js/menu.js" type="text/javascript"></script>
<script src="js/show.js" type="text/javascript"></script>
<script language="JavaScript">
function setVisibility(id, visibility) {
document.getElementById(id).style.display = visibility;
}
</script>
<script>
function newWindow(link) {
screen_width = screen.width;
screen_height = screen.height;
window_width = 300;
window_height = 200;
positon_left =
((screen_width-window_width)/2)-((screen_width-window_width)%2);
positon_top =
((screen_height-window_height)/2)-((screen_height-window_height)%2);
window.open(link, "windowname",
"toolbar=no,scrollbars=yes,status=no,resizable=yes,menubar=no,width="+window_width+",height="+window_height+",left="+positon_left+",top="+positon_top);
}
</script>
<style type="text/css">
#popup {
font-family : Arial, Helvetica, sans-serif;
font-size : 12px;
position : absolute;
left : 173px;
top : 97px;
width : 270px;
height: 177px;
z-index: 1;
visibility : hide;
}
</style>
<script language="JavaScript">
function showPopup() {
document.popup.visibility='show';
}
function hidePopup() {
document.popup.visibility='hide';
}
</script>
<script type="text/javascript">
function loadXMLDoc(str)
{
var xmlhttp;
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("myDiv").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","Ajax_Prepaid_GSM_Verification?q="+str,true);
xmlhttp.send();
}
</script>
<SCRIPT type="text/javascript">
window.history.forward();
function noBack() { window.history.forward(); }
</SCRIPT>
<script type="text/javascript">
function getCAF(){
var lnk = document.getElementById('somelink');
lnk.href = lnk.href + "?mdnno=" + document.getElementById('txtbx').value
}
<!--
function hideMe(){
// Hide or show iframe
if(document.getElementById("myframe").style.visibility=="visible"){
document.getElementById("myframe").style.visibility="hidden"
}
else{
document.getElementById("myframe").style.visibility="visible"
}
}
</script>
<script language="JavaScript">
function setVisibility(id, visibility) {
document.getElementById(id).style.display = visibility;
}
</script>
</head>
<body onload="noBack();" onpageshow="if (event.persisted) noBack();" onunload="">
<form action="PrepaidGSMVerification" name="verify" method="POST">
<%
String USERNAME="";
USERNAME=(String)session.getAttribute("USER");
String ADMIN="";
ADMIN=(String)session.getAttribute("ADMIN");
session.setAttribute("user",USERNAME);
session.setAttribute("user1",ADMIN);
String msg = "";
String dist_code="";
String usercheck = "false";
if (session.getAttribute("usercheck") != null || session.getAttribute("usercheck") == null) {
usercheck = session.getAttribute("usercheck").toString();
}if (usercheck.equalsIgnoreCase("true")||usercheck.equalsIgnoreCase("user"))
{
%>
<%-- <%
ResultSet rs=null;
String mdnnumber = request.getParameter("mdnno");
System.out.println(mdnnumber);
if(mdnnumber!=null && !(mdnnumber.equals("")))
{
Connection con = null;
Statement st=null;
try{
con = (Connection) new DBconnection().getDatabaseConnection();
st = con.createStatement();
String sql = "select DCODE from otaf where MDN='"+mdnnumber+"' group by DCODE";
System.out.println(sql);
rs= st.executeQuery(sql);
if(!rs.next())
{
msg = "Entered MDN number "+mdnnumber+" is not available";
}
rs=null;
rs= st.executeQuery(sql);
while(rs.next())
{
dist_code = rs.getString("DCODE");
}
}
catch (SQLException s){
out.println("SQL statement is not executed!"+s);
}
finally{
if(rs!=null)
{
rs.close();
}
if(st!=null)
{
st.close();
}
if(con!=null)
{
con.close();
}
}
}
%>--%>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="top"><table width="932" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="bottom" style="background-image:url(images/top.gif); background-repeat:no-repeat; height:24px;"> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><table width="931" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="35%" height="75" align="center" valign="middle" style="font-family:Arial, Helvetica, sans-serif; font-size:18px; color:#1461a5; font-weight:bold;"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="30%" height="75"><span style="padding-left:15px;"><img src="images/rajsoft-logo1.png" alt="" width="84" height="59" /></span></td>
<td height="75" valign="bottom" style="font-family:Arial, Helvetica, sans-serif; font-size:18px; padding-bottom:15px; padding-left:10px; color:#1461a5;">RajSoft Solutions</td>
</tr>
</table></td>
<td width="33%" height="75" align="center" valign="middle" style="font-family:Verdana, Geneva, sans-serif; font-size:20px; color:#1461a5; letter-spacing:1px; text-shadow: 1px 1px 1px #999; line-height:25px;">Reliance - NCM<br />
Jharkhand</td>
<td height="75" align="right" valign="middle" style="padding-right:15px;"><img src="imges1/R-Logo.gif" width="132" height="25" /></td>
</tr>
</table></td>
</tr>
<tr>
<td height="25" align="right" valign="middle" style="padding-right:15px;"><a href="login.jsp?logout=true" class="content3">Logout</a></td>
</tr>
<tr>
<td align="center" valign="top" bgcolor="#045F8E"><div id="menu">
<ul class="menu">
<%
if(usercheck.equalsIgnoreCase("true"))
{
%>
<li><a href="#" class="parent"><span> Admin </span></a>
<ul>
<li><a href="#" class="parent"><span>Users</span></a>
<ul>
<li><a href="createuser.jsp"><span>Create User</span></a></li>
<li><a href="Manage_User_By_Role.jsp"><span>Manage User</span></a>
<ul>
<li><a href="Manage_User_By_Name.jsp"><span>Manage By Name</span></a></li>
<li><a href="Manage_User_By_Role.jsp"><span>Manage By Role</span></a></li>
</ul>
</li>
<li><a href="Delete_User_Role.jsp"><span>Remove User</span></a>
<ul>
<li><a href="Delete_User_Name.jsp"><span>Remove By Name</span></a></li>
<li><a href="Delete_User_Role.jsp"><span>Remove By Role</span></a></li>
</ul>
</li>
</ul>
</li>
<li><a href="#" class="parent"><span>Roles</span></a>
<ul>
<li><a href="createrole.jsp"><span>Create Role</span></a></li>
<li><a href="managerolebyrole.jsp"><span>Manage Role</span></a></li>
<li><a href="deleterolebyrole.jsp"><span>Remove Role</span></a> </li>
</ul>
</li>
<li><a href="#" class="parent"><span>Configuration</span></a>
<ul>
<li><a href="#" class="parent"><span>FTP</span></a>
<ul>
<li><a href="#" class="parent"><span>User Add</span></a>
<ul> <li><a href="#"><span>User Directory</span></a></li></ul>
</li>
<li><a href="#"><span>User Manage</span></a></li>
<li><a href="#"><span>User Delete</span></a></li>
</ul>
</li>
<li><a href="#"><span>Reports</span></a></li>
</ul>
</li>
</ul>
</li>
<%
}
%>
<%
AccessPermission ap=new AccessPermission();
Vector v1=(Vector) ap.Access(USERNAME);
if(v1!=null)
{
int i=0;
if(i<v1.size()){
//RoleVO vO=new RoleVO();
RoleVO vO=(RoleVO) v1.get(i);
System.out.println("CAFHUB IS====>"+vO.getcafhub());
%>
<%
if(vO.getverification().equalsIgnoreCase("yes"))
{
%>
<li><a href="Verification.jsp"><span>Verification</span></a></li>
<% } %>
<%
if(vO.getorderentry().equalsIgnoreCase("yes"))
{
%>
<li><a href="Order_Entry_Home.jsp"><span>Order Entry</span></a></li>
<% } %>
<%
if(vO.getqualitycheck().equalsIgnoreCase("yes"))
{
%>
<li><a href="PrepaidGSMQualityCheck.jsp"><span>Quality Check</span></a></li>
<% } %>
<%
if(vO.getwarehouse().equalsIgnoreCase("yes"))
{
%>
<li><a href="#"><span>Warehouse</span></a>
<ul>
<li><a href="Warehouse_Image_Verification.jsp"><span>Warehouse Verify</span></a></li>
<li><a href="#" class="parent"><span>Inward</span></a>
<ul>
<li><a href="Warehouse_Inward_New_Entry.jsp"><span>New Entry</span></a></li>
</ul>
</li>
<li><a href="#" class="parent"><span>Repository</span></a>
<ul>
<li><a href="Warehouse_Repository_New_Entry.jsp"><span>New Entry</span></a>
<li><a href="Warehouse_Repository_Re_Entry.jsp"><span>Re Entry</span></a></li>
</ul>
</li>
<li><a href="#"><span>Upload</span></a></li>
<li><a href="#" class="parent"><span>Facility</span></a>
<ul>
<li><a href="Warehouse_Facility_New_Location.jsp"><span>New Location</span></a>
</ul></li>
</ul>
</li>
<% } %>
<%
if(vO.getreports().equalsIgnoreCase("yes"))
{
%>
<li><a href="#"><span>Reports</span></a></li>
<% } %>
<%
if(vO.getupload().equalsIgnoreCase("yes"))
{
%>
<li class="last"><a href="otafupload.jsp"><span>Upload</span></a></li>
<%
}
}
}
%>
<%
if(usercheck.equalsIgnoreCase("true"))
{
%>
<!-- <li><a href="http://183.82.48.40/rsftp/" class="parent"><span>CAF HUB</span></a></li>-->
<li><a href="Verification.jsp"><span>Verification</span></a></li>
<li><a href="Order_Entry_Home.jsp"><span>Order Entry</span></a></li>
<li><a href="PrepaidGSMQualityCheck.jsp"><span>Quality Check</span></a></li>
<li><a href="#"><span>Warehouse</span></a>
<ul>
<li><a href="Warehouse_Image_Verification.jsp"><span>Warehouse Verify</span></a></li>
<li><a href="#" class="parent"><span>Inward</span></a>
<ul>
<li><a href="Warehouse_Inward_New_Entry.jsp"><span>New Entry</span></a></li>
</ul>
</li>
<li><a href="#" class="parent"><span>Repository</span></a>
<ul>
<li><a href="Warehouse_Repository_New_Entry.jsp"><span>New Entry</span></a>
<li><a href="Warehouse_Repository_Re_Entry.jsp"><span>Re Entry</span></a></li>
</ul>
</li>
<li><a href="#"><span>Upload</span></a></li>
<li><a href="#" class="parent"><span>Facility</span></a>
<ul>
<li><a href="Warehouse_Facility_New_Location.jsp"><span>New Location</span></a>
</ul></li>
</ul>
</li>
<li><a href="#"><span>Reports</span></a></li>
<li class="last"><a href="otafupload.jsp"><span>Upload</span></a></li>
<% }
%>
</ul>
</div></td>
</tr>
<tr>
<td align="center" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="40" align="center" valign="top" style="padding-left:10px;">
<table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" align="center" valign="middle">
<A HREF="javascript:newWindow('GetQueueVerificationCAF')">CAF List</A>
</td>
</tr>
<tr>
<td height="30" align="center" valign="middle">
<A HREF="javascript:newWindow('GetNewQueueVerificationCAF')">New CAF List</A>
</td>
</tr> <tr>
<td height="30" align="left" valign="middle"><table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="30" align="center" valign="middle"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr></tr>
<tr>
<td height="30" align="center" valign="middle"><table width="100%" border="0" cellspacing="0" cellpadding="0" style="border:solid 1px #ccc;">
<tr class="b">
<td width="50%" height="32" align="left" valign="middle" bgcolor="#dcf3fd" class="content3">Prepaid GSM Verification</td>
<td width="50%" height="32" align="right" valign="middle" bgcolor="#dcf3fd" style="padding-right:10px;"><table width="40%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="50%" align="right" valign="middle"><label>
<input type="submit" name="button" id="button" value="Accept" />
</label></td>
<td width="50%" align="right" valign="middle"><a href="#">
<label>
<input type="submit" name="button2" id="button2" value="Reject" />
</label>
</a></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td width="75%" height="30" align="left" valign="middle" class="content4"><div style="height:35px; width:98%;"></div>
<%
String message=(String) request.getAttribute("message");
if(message!=null && (!message.isEmpty()))
{
%>
<span style="font-family:Verdana; font-size:12px; color:red">
<%out.println(message); %>
</span>
<%
}
%></td>
</tr>
<tr>
<td height="30"><div id="myDiv" class="content5" style="width:auto;"></div></td>
</tr>
<tr>
<td width="50%" height="30" align="left" valign="middle"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="50%" align="left" valign="middle"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="30%" height="30" align="left" valign="middle" class="content3">CAF No :</td>
<td width="70%" height="30"><label>
<input type="text" name="caf" id="textfield" maxlength="12" onchange="loadXMLDoc(caf.value)" />
</label></td>
</tr>
</table></td>
<td width="50%"> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="30" colspan="5" align="left" valign="middle"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="50%" height="30" align="left" valign="middle"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="30%" height="30" align="left" valign="middle" class="content3">MDN No :</td>
<td width="70%"><input type="text" name="mdnno" id="txtbx" maxlength="10" /></td>
<!--<td width="25%" height="30"><label>
<a href="VerificationGSM.jsp" id="somelink"><input type="button" value="Check" onmousedown="getCAF();" selected="selected" /></a>
</label></td>-->
</tr>
</table></td>
<td width="50%" height="30" align="left" valign="middle"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="30%" height="30" align="left" valign="middle" class="content3">Distributor Code :</td>
<td width="70%"><input type="text" name="distributorcode" id="textfield3" maxlength="10" value="<%out.println(dist_code);%>" /></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td align="center" valign="middle"> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="30" align="left" valign="middle"> </td>
</tr>
<tr>
<td align="center" valign="top" class="content4"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="50%" align="left" valign="top" style="padding-right:15px;"><iframe src="" name="myIframe" width="100%" height="350" frameborder="0" style="visibility:hidden; overflow:auto;" id="myframe"></iframe></td>
<td width="50%" align="left" valign="top" style="padding-left:15px;"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" align="center" valign="middle" bgcolor="#DCF3FD" style="border:solid 1px #ccc;">Physical Details</td>
</tr>
<tr>
<td align="center" valign="top"><div style="height:350px; width:100%; overflow:auto;">
<table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr>
<td align="center" valign="middle"><table width="100%" border="0" cellspacing="0" cellpadding="0" style="border:solid 1px #ccc;">
<tr></tr>
</table></td>
</tr>
<tr>
<td align="center" valign="top" class="content4"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" align="left" valign="top"><table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr class="content4">
<td width="75%" height="20" align="right" valign="middle"> </td>
<td width="10%" height="20" align="center" valign="middle"> </td>
<td width="15%" height="20" align="left" valign="middle"> </td>
</tr>
<tr class="content4">
<td width="75%" height="30" align="left" valign="middle">CAF filled 'in Black Ink' </td>
<td width="10%" height="30" align="center" valign="middle">:</td>
<td width="15%" height="30" align="left" valign="middle"><label>
<select name="select1" id="select">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select>
</label></td>
</tr>
<tr>
<td width="75%" height="30" align="left" valign="middle" class="content4">Details on CAF </td>
<td width="10%" height="30" align="center" valign="middle">:</td>
<td width="15%" height="30" align="left" valign="middle"><select name="select2" id="select2">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td width="75%" height="30" align="left" valign="middle" class="content4">Customer is Major </td>
<td width="10%" height="30" align="center" valign="middle">:</td>
<td width="15%" height="30" align="left" valign="middle"><select name="select3" id="select3">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td width="75%" height="30" align="left" valign="middle" class="content4">No cutting on printed CAF Number</td>
<td width="10%" height="30" align="center" valign="middle" class="content4">:</td>
<td width="15%" height="30" align="left" valign="middle"><select name="select4" id="select4">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td width="75%" height="30" align="left" valign="middle" class="content4" style="line-height:20px;">Sim and MDN mentioned on CAF </td>
<td width="10%" height="30" align="center" valign="middle" class="content4">:</td>
<td width="15%" height="30" align="left" valign="middle"><select name="select5" id="select5">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td width="75%" height="50" align="left" valign="middle" class="content4" style="line-height:20px;">No Over writing / No Cutting on CAF and Documents / Whitener not used </td>
<td width="10%" height="30" align="center" valign="middle" class="content4">:</td>
<td width="15%" height="30" align="left" valign="middle"><select name="select6" id="select6">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td width="75%" height="50" align="left" valign="middle" class="content4" style="line-height:20px;">Customer photo available on CAF and Matching with POI/POA</td>
<td width="10%" height="30" align="center" valign="middle" class="content4">:</td>
<td width="15%" height="30" align="left" valign="middle"><select name="select7" id="select7">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td width="75%" height="30" align="left" valign="middle" class="content4" style="line-height:20px;">First Name </td>
<td width="10%" height="30" align="center" valign="middle" class="content4">:</td>
<td width="15%" height="30" align="left" valign="middle"><select name="select8" id="select8">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td width="75%" height="30" align="left" valign="middle" class="content4">Last Name </td>
<td width="10%" height="30" align="center" valign="middle" class="content4">:</td>
<td width="15%" height="30" align="left" valign="middle"><select name="select9" id="select9">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td width="75%" height="50" align="left" valign="middle" class="content4" style="line-height:20px;">Complete Customer Name mentioned on CAF and Matching with POI/POA</td>
<td width="10%" height="30" align="center" valign="middle" class="content4">:</td>
<td width="15%" height="30" align="left" valign="middle"><select name="select10" id="select10">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td width="75%" height="30" align="left" valign="middle" class="content4" style="line-height:20px;">Sex</td>
<td width="10%" height="30" align="center" valign="middle" class="content4">:</td>
<td width="15%" height="30" align="left" valign="middle"><select name="select11" id="select11">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="50" align="left" valign="middle" class="content4" style="line-height:20px;">Customer DOB mentioned and Matching with POI/POA </td>
<td height="30" align="center" valign="middle" class="content4">:</td>
<td height="30" align="left" valign="middle"><select name="select12" id="select12">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4">Nationality</td>
<td height="30" align="center" valign="middle" class="content4">:</td>
<td height="30" align="left" valign="middle"><select name="select13" id="select13">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4">Father Name/Husband Name mentioned on CAF and Matching with POI/POA </td>
<td height="30" align="center" valign="middle" class="content4">:</td>
<td height="30" align="left" valign="middle"><select name="select14" id="select14">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="50" align="left" valign="middle" class="content4" style="line-height:20px;">Email Address on CAF mentioned for HSD/DataCard/3G Dongle </td>
<td height="30" align="center" valign="middle" class="content4">:</td>
<td height="30" align="left" valign="middle"><select name="select15" id="select31">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">City/Town</td>
<td height="30" align="center" valign="middle" class="content4">:</td>
<td height="30" align="left" valign="middle"><select name="select16" id="select32">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">District</td>
<td height="30" align="center" valign="middle" class="content4">:</td>
<td height="30" align="left" valign="middle"><select name="select17" id="select33">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">State</td>
<td height="30" align="center" valign="middle" class="content4">:</td>
<td height="30" align="left" valign="middle"><select name="select18" id="select34">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">Pincode</td>
<td height="30" align="center" valign="middle" class="content4">:</td>
<td height="30" align="left" valign="middle"><select name="select19" id="select35">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">Address with Landmark </td>
<td height="30" align="center" valign="middle" class="content4">:</td>
<td height="30" align="left" valign="middle"><select name="select20" id="select36">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="50" align="left" valign="middle" class="content4" style="line-height:20px;">Complete Customer Address mentioned on CAF and Matching with POI/POA</td>
<td height="30" align="center" valign="middle" class="content4">:</td>
<td height="30" align="left" valign="middle"><select name="select21" id="select15">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">Cross Signed customer photo available on CAF and matching with POI&POA </td>
<td height="30" align="center" valign="middle" class="content4">:</td>
<td height="30" align="left" valign="middle"><select name="select22" id="select37">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top"><table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">Local POA </td>
<td height="30" align="center" valign="middle" class="content4">:</td>
<td height="30" align="left" valign="middle"><select name="select23" id="select16">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr class="content4">
<td width="75%" height="30" align="left" valign="middle" style="line-height:20px;">Alternate Number </td>
<td width="10%" height="30" align="center" valign="middle">:</td>
<td width="15%" height="30" align="left" valign="middle"><select name="select24" id="select17">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">Account Number </td>
<td height="30" align="center" valign="middle">:</td>
<td height="30" align="left" valign="middle"><select name="select25" id="select38">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">Local Address & Contact Number </td>
<td height="30" align="center" valign="middle">:</td>
<td height="30" align="left" valign="middle"><select name="select26" id="select39">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="50" align="left" valign="middle" class="content4" style="line-height:20px;">Activated MDN & Local reference number are same </td>
<td height="50" align="center" valign="middle">:</td>
<td height="50" align="left" valign="middle"><select name="select27" id="select40">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">Passport & Visa copy attached </td>
<td height="30" align="center" valign="middle">:</td>
<td height="30" align="left" valign="middle"><select name="select28" id="select41">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">PAN/Form 60/61 Signed by Customer</td>
<td height="30" align="center" valign="middle">:</td>
<td height="30" align="left" valign="middle"><select name="select30" id="select43">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">Customer Signature </td>
<td height="30" align="center" valign="middle">:</td>
<td height="30" align="left" valign="middle"><select name="select31" id="select44">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="50" align="left" valign="middle" class="content4" style="line-height:20px;">Customer Signature on CAF Matching with POI/POA </td>
<td height="50" align="center" valign="middle">:</td>
<td height="50" align="left" valign="middle"><select name="select32" id="select45">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">Retailer/Channel Stamp & Signature </td>
<td height="30" align="center" valign="middle">:</td>
<td height="30" align="left" valign="middle"><select name="select33" id="select46">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">CAF Date is on or before Activation Date </td>
<td height="30" align="center" valign="middle">:</td>
<td height="30" align="left" valign="middle"><select name="select34" id="select47">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">Distributor/ECO/RW Signature & Stamp </td>
<td height="30" align="center" valign="middle">:</td>
<td height="30" align="left" valign="middle"><select name="select35" id="select48">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">POI</td>
<td height="30" align="center" valign="middle">:</td>
<td height="30" align="left" valign="middle"><select name="select36" id="select49">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">POA</td>
<td height="30" align="center" valign="middle">:</td>
<td height="30" align="left" valign="middle"><select name="select37" id="select50">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">Common POI/POA </td>
<td height="30" align="center" valign="middle">:</td>
<td height="30" align="left" valign="middle"><select name="select38" id="select51">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="50" align="left" valign="middle" class="content4" style="line-height:20px;">POI/POA Attached as per the DOT Prescribed Test </td>
<td height="50" align="center" valign="middle">:</td>
<td height="50" align="left" valign="middle"><select name="select39" id="select52">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="35" align="left" valign="middle" class="content4" style="line-height:20px;">POI/POA Validity not Expired </td>
<td height="35" align="center" valign="middle">:</td>
<td height="35" align="left" valign="middle"><select name="select40" id="select53">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">POI/POA copy attached Eligible </td>
<td height="30" align="center" valign="middle">:</td>
<td height="30" align="left" valign="middle"><select name="select41" id="select54">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="40" align="left" valign="middle" class="content4" style="line-height:20px;">Witness MDN </td>
<td height="40" align="center" valign="middle">:</td>
<td height="40" align="left" valign="middle"><select name="select42" id="select55">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">MNP</td>
<td height="30" align="center" valign="middle">:</td>
<td height="30" align="left" valign="middle"><select name="select43" id="select56">
<option selected="selected" value="">--Select--</option>
<option value="Y" onclick="setVisibility('sub3', 'inline');";>Yes</option>
<option value="N" onclick="setVisibility('sub3', 'none');";>No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">MNP Form Attached </td>
<td height="30" align="center" valign="middle">:</td>
<td rowspan="2" align="left" valign="middle"><div id="sub3">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" align="left" valign="middle"><select name="select44" id="select57">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
<tr>
<td height="30" align="left" valign="middle"><select name="select29" id="select42">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;"><span class="content4" style="line-height:20px;">UPC code mentioned on CAF </span></td>
<td height="30" align="center" valign="middle">:</td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">Tele Marketing </td>
<td height="30" align="center" valign="middle">:</td>
<td height="30" align="left" valign="middle"><p>
<select name="select45" id="select59">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select>
</p></td>
</tr>
<tr>
<td height="30" align="left" valign="middle" class="content4" style="line-height:20px;">OTAF Date </td>
<td height="30" align="center" valign="middle">:</td>
<td height="30" align="left" valign="middle"><select name="select46" id="select58">
<option selected="selected" value="">--Select--</option>
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td align="center" valign="top" class="content4"> </td>
</tr>
</table></td>
</tr></table></td>
</tr></table></td>
</tr></table></td>
</tr></table>
</form>
<%
}
else
{
response.sendRedirect("./login.jsp");
}
%>
</body>
</html>