<?
session_start();
include '../conn.php';
$pno=$_REQUEST['id'];
while(strlen($pno)<9){
	$pno="0".$pno;
}
function findrank1($pno){
	if($pno == '') return $pno;
	//echo "select rank_hin from rank_master where rank_id=(select confirmation_rank from employee_master where personal_number=".$pno.")";
	$results=mysql_query("select rank_hin from rank_master where rank_id=(select rank from employee_master where personal_number=".$pno.")") ;
	if($x = mysql_fetch_array($results)) return $x['rank_hin'];
}

 $rec=mysql_query("select max(selection_type) maxi from promotion_detail where Personal_Number=".$pno);

  $sec_type=array();
  if(mysql_num_rows($rec)){
	  while($row=mysql_fetch_array($rec)){
	  $sec_type[]=$row['maxi'];
	  }
  }
  $cnt=count($sec_type);

if(isset($_REQUEST["B1"]))
{
/*print_r($_REQUEST);
exit(0);*/
$temp = explode('/',$_REQUEST['pdate']);
$Promotion_Date = $temp[2].'-'. $temp[1].'-'. $temp[0];

$temp = explode('/',$_REQUEST['fdate']);
$From_Date = $temp[2].'-'. $temp[1].'-'. $temp[0];

$temp = explode('/',$_REQUEST['tdate']);
$To_Date = $temp[2].'-'. $temp[1].'-'. $temp[0];

$temp = explode('/',$_REQUEST['jdate']);
$Joing_Date_at_Promotion = $temp[2].'-'. $temp[1].'-'. $temp[0];


$rs = mysql_query('select * from new_posting_detail where personal_number = '.$_REQUEST['personalno']);
if(mysql_num_rows($rs) > 0)
{	
	$rs = mysql_fetch_array($rs);
	extract($rs);
	$Personal_Number = $personal_number;
	$Employee_name = $first_name_of_employee_english.' '.$middle_name_of_employee_english.' '.$last_name_of_employee_english;
	$Promotion_Order_No = $_REQUEST['p_orderno'];
	
	$Promotion_Type = $_REQUEST['ptype'];
	$seniority_level = $_REQUEST['slevel'];
	$sub_unit = $_REQUEST['Joining_Sub_Unit_Name'];
	$Batch = $_REQUEST['batch'];
	$Total_marks = '0';
	$marks_Obtained = $_REQUEST['tmarks'];
	$Position = $_REQUEST['position'];
	$promotion_District = $_REQUEST['district'];
	$promotion_Unit = $_REQUEST['Joining_Unit_Name'];
	$Previous_Promotion_rank = $_REQUEST['rank'];	
	$no_of_previous_promotion=$_REQUEST['promotion_status'];	
}
 $rec=mysql_query("select  max(selection_type) maxi from promotion_detail where Personal_Number=".$Personal_Number);

  $sec_type=array();
  if(mysql_num_rows($rec)){
	  while($row=mysql_fetch_array($rec)){
	  $sec_type[]=$row['maxi'];
	  }
  }
  $cnt=count($sec_type);
$sel_type=$sec_type[$cnt-1]+1;

	if($sel_type==1){
	$select_grade=$_REQUEST["Present_grad1"];
	$temp=explode('/',$_REQUEST['sgd1']);
	}
	if($sel_type==2){
	$select_grade=$_REQUEST["Present_grad2"];
	$temp=explode('/',$_REQUEST['sgd2']);
	}
	if($sel_type==3){
	$select_grade=$_REQUEST["Present_grad3"];
	$temp=explode('/',$_REQUEST['sgd3']);
	}
	
	$select_date=$temp[2].'-'.$temp[1].'-'.$temp[0];
	
	  if($select_date=='--' && $select_grade=='')
	  $sel_type=0;

mysql_query("insert into promotion_detail(Personal_Number, Employee_name,no_of_previous_promotion , Promotion_Date, Promotion_Order_No, Promotion_Type, seniority_level, sub_unit, Batch, To_Date, From_Date, Total_marks, marks_Obtained, Position, Joing_Date_at_Promotion, promotion_District, promotion_Unit, Previous_Promotion_rank,selection_date,selection_grade,selection_type) values('$Personal_Number', '$Employee_name','$no_of_previous_promotion', '$Promotion_Date', '$Promotion_Order_No', '$Promotion_Type', '$seniority_level', '$sub_unit', '$Batch','$To_Date', '$From_Date', '$Total_marks', '$marks_Obtained', '$Position', '$Joing_Date_at_Promotion','$promotion_District', '$promotion_Unit', '$Previous_Promotion_rank','".$select_date."','".$select_grade."',".$sel_type.")") ;


header("Location: confirm_add.php?id=".$personal_number);


}

function findrank($id = null)
{
	$results=mysql_query("select * from rank_master where rank_id=".$id) ;
	
	if($x = mysql_fetch_array($results))
	{
	
		return $x['rank_eng'];
	} else {
	
		return 'N/A';
	}
}
$results=mysql_query("select * from new_posting_detail where personal_number='".$pno."'") ;

$arow=mysql_fetch_array($results);
extract($arow);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0095)http://www.uppolice.com.lpus1.onlyfordemo.com/login/transfer_detail/transfer1.php?pno=802464172 -->
<HTML><HEAD><TITLE>Uttar Pradesh Police Nominol Roll System</TITLE>
<META http-equiv=Content-Language content=en-us>
<META content="Microsoft FrontPage 5.0" name=GENERATOR>
<META content=FrontPage.Editor.Document name=ProgId>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<SCRIPT src="transfer_files/prototype.js"></SCRIPT>
<SCRIPT language=javascript src="../js/common.js"></SCRIPT>
<SCRIPT src="transfer_files/scriptaculous.js"></SCRIPT>


<script src="../Date/calandar.js"></script>
<link href="../Date/calandar.css" rel="stylesheet" type="text/css">
<STYLE type=text/css>
.ftbl {
	FONT-SIZE: 11px; COLOR: #333333; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif
}
.ftbl23 {
    FONT-SIZE: 16px; COLOR: #333333; FONT-FAMILY: 'Kruti Dev 010';
}
.style17 {color: #FF0000;font-size:18px;  }

</STYLE>

<SCRIPT language=JavaScript>
<!-- Begin
var checkflag = "false";
function check(field) {
if (checkflag == "false") {
  for (i = 0; i < field.length; i++) {
  field[i].checked = true;}
  checkflag = "true";
  return "Deselect all"; }
else {
  for (i = 0; i < field.length; i++) {
  field[i].checked = false; }
  checkflag = "false";
  return "Select all"; }
}

function checkPre() {
date1 = new Date();
date2 = new Date();
diff  = new Date();
diff1 = new Date();

//alert(formatDate(document.getElementById("fdate").value));
date1temp = new Date(formatDate(document.getElementById("tdate").value));
date1.setTime(date1temp.getTime());


date2temp = new Date(formatDate(document.getElementById("fdate").value));
date2.setTime(date2temp.getTime());

// sets difference date to difference of first date and second date
 var ONE_DAY = 1000 * 60 * 60 * 24

    // Convert both dates to milliseconds
    var date1_ms = date1temp.getTime()
    var date2_ms = date2temp.getTime()
	

    // Calculate the difference in milliseconds
    var difference_ms = date1_ms -date2_ms
    
    // Convert back to days and return
    var datDiffs= Math.round(difference_ms/ONE_DAY)
	datDiffs=datDiffs+1
	return datDiffs;
}
//  End -->
</SCRIPT>

<SCRIPT language=javascript type=text/javascript>
function imposeMaxLength(Object, MaxLen)
{
  return (Object.value.length <= MaxLen);
}
</SCRIPT>

<SCRIPT>
function validation()
{
if(document.frm1.Personal_number.value=="")
{
alert('please enter Personal_number');
document.frm1.Personal_number.focus();
return false;
}
else if(document.frm1.Employee_name.value=="")
{
alert('please enter state_name in English');
document.frm1.Employee_name.focus();
return false;
}
else if(document.frm1.Present_rank.value=="")
{
alert('please Enter Present_rank');
document.frm1.Present_rank.focus();
return false;
}

else
return true;
}
</SCRIPT>

<SCRIPT language=javascript>
function Submit()
{
document.frm1.submit();
}

/*function reset1()
{
window.location="transfer.php";
}*/
 </SCRIPT>

<SCRIPT language=javascript>

function day(d)
{
	var str
	for (var intLoop = 1; intLoop < 32; intLoop++)
	{
		if(intLoop==d)
		document.write("<OPTION value=" + intLoop + " selected>" + intLoop +"</option>");
		else
		document.write("<OPTION value=" + intLoop + ">" + intLoop +"</option>");
	}
}

function month(m)
{
var arrMonths=new Array;
	arrMonths[1]="Jan";
	arrMonths[2]="Feb";
	arrMonths[3]="Mar";
	arrMonths[4]="Apr";
	arrMonths[5]="May";
	arrMonths[6]="Jun";
	arrMonths[7]="Jul";
	arrMonths[8]="Aug";
	arrMonths[9]="Sep";
	arrMonths[10]="Oct";
	arrMonths[11]="Nov";
	arrMonths[12]="Dec";

	for (var intLoop = 1; intLoop <= 12; intLoop++)
	{
		if(intLoop==m)
			document.write("<OPTION value=" + intLoop + " selected>" + arrMonths[intLoop] +"</option>");
		else
			document.write("<OPTION value=" + intLoop + ">" + arrMonths[intLoop] +"</option>");
	}
		
}
function year(y)
{
	for (var intLoop = 1930; intLoop < 2010; intLoop++)
	{
		if(intLoop==y)
			document.write("<OPTION value=" + intLoop + " selected>" + intLoop+"</option>");
		else
			document.write("<OPTION value=" + intLoop + ">" + intLoop+"</option>");
	}
}
</SCRIPT>

<SCRIPT language=JavaScript>
var mycntr = 0;
function showOrHide(value) {
    if (value==0) {
        if (document.layers)
           document.layers["loading"].visibility='hide';
        else
           document.all["loading"].style.visibility='hidden';
   }
   else if (value==1) {
       if (document.layers)
          document.layers["loading"].visibility='show';
       else
          document.all["loading"].style.visibility='visible';
   }
}

function showOrHide2(value) {
    if (value==0) {
        if (document.layers)
           document.layers["sss"].visibility='hide';
        else
           document.all["sss"].style.visibility='hidden';
   }
   else if (value==1) {
       if (document.layers)
          document.layers["sss"].visibility='show';
       else
          document.all["sss"].style.visibility='visible';
   }
}

function showOrHide3(value) {
    if (value==0) {
        if (document.layers)
           document.layers["login"].visibility='hide';
        else
           document.all["login"].style.visibility='hidden';
   }
   else if (value==1) {
       if (document.layers)
          document.layers["login"].visibility='show';
       else
          document.all["login"].style.visibility='visible';
   }
}

var XMLHttpRequestObject = false;
if(window.XMLHttpRequest)
	{
		XMLHttpRequestObject = new XMLHttpRequest();
	}else if(window.ActiveXObject)
	{
		XMLHttpRequestObject = new ActiveXObject("Microsoft.XMLHTTP");
	}
function getData(divid, data_path, params)
{
 

	if(mycntr!=0)
	{
	showOrHide(1);
	}
	var obj = document.getElementById(divid);
	if(XMLHttpRequestObject)
	{
		XMLHttpRequestObject.open("GET", data_path);
		XMLHttpRequestObject.onreadystatechange = function()
		{
			if (XMLHttpRequestObject.readyState == 4 &&
			XMLHttpRequestObject.status == 200) {
			obj.innerHTML = XMLHttpRequestObject.responseText;
			
			showOrHide(0);
			
			mycntr++;
		}
	}
	
	XMLHttpRequestObject.send(params);		
		
		
		
}

}
</SCRIPT>
<LINK href="css/stylesheet.css" type=text/css rel=stylesheet><!-- calendar stylesheet --><LINK title=win2k-cold-1 media=all 
href="transfer_files/theme.css" type=text/css rel=stylesheet><!-- main calendar program -->
<SCRIPT src="transfer_files/calendar.js" type=text/javascript></SCRIPT>
<!-- language for the calendar -->
<SCRIPT src="transfer_files/calendar-en.js" type=text/javascript></SCRIPT>
<!-- the following script defines the Calendar.setup helper function, which makes
       adding a calendar a matter of 1 or 2 lines of code. -->
<SCRIPT src="transfer_files/calendar-setup.js" type=text/javascript></SCRIPT>

<SCRIPT language=JavaScript type=text/JavaScript>
<!--
function MM_reloadPage(init) {  //reloads the window if Nav4 resized
  if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
    document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
  else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
//-->
</SCRIPT>
<LINK href="../styles.css" type=text/css rel=stylesheet>
<STYLE type=text/css>
BODY {
	MARGIN: 0px
}
.but {
	FONT-WEIGHT: bold; FONT-SIZE: 12px; BACKGROUND: #999966; COLOR: #ffffff; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif
}
.cambo {
	BACKGROUND: #ffffff; WIDTH: 59px
}
.cambo1 {
	BACKGROUND: #ffffff; WIDTH: 90px
}
.href {
	COLOR: #000000
}
.style1 {
	COLOR: #ffffff
}
.style15 {
	color: #FFFFFF;
	font-weight: bold;
	font-size: 0.8em;
}
.style16 {FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif; color: #333333;}
.style18 {COLOR: #333333; font-size: 11px;}
.style19 {color: #333333}
</STYLE>
</HEAD>
<BODY>

  
  <TABLE cellSpacing=0 cellPadding=0 width=775 align=center border=0>
  <TBODY>
  <TR vAlign=top>
    <TD vAlign=top>
      <TABLE id=AutoNumber1 style="BORDER-COLLAPSE: collapse" cellSpacing=0 
      cellPadding=0 width=775 border=0>
        <TBODY>
        <TR vAlign=top>
          <TD vAlign=top width="100%"><img border='0' src='../images/banner1_01.jpg' width='775' height='89' /></TD>
        </TR></TBODY></TABLE></TD></TR>
  <TR vAlign=top>
    <TD vAlign=top height=20>
      <STYLE type=text/css>.style2 {
	FONT-SIZE: 9px; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif
}
      </STYLE>

      

		<style type="text/css">
		<!--
		.style9 {
			font-family: "Verdana";
			font-size: 11pt;
			font-weight: Normal;
			}
		.style12 {
			color: #990000;
			font-size: 16px;
			font-family: Verdana, Arial, Helvetica, sans-serif;
		}
		-->
		</style>
		<table border='0' cellpadding='0' cellspacing='0' style='border-collapse: collapse' width='100%' id='AutoNumber2' bordercolor='#E1E1E1'>
		  <tr align="center" bgcolor="#F7F7Ff">
			<td colspan="3" height='20' style='margin-right:5px; padding:5px 5px 0px 5px;border:0px solid black;'>
					<span class="style12">&#2332;&#2344;&#2346;&#2342;/&#2311;&#2325;&#2366;&#2312; &#2325;&#2366; &#2344;&#2366;&#2350; </span> 
					<font face='Arial' style='font-size: 10pt;font-weight:bold;' font color='#990000'>
					   <? echo ' - '.strToUpper($_SESSION['Unit1']);  ?></font></td>
		  </tr>
		  <tr bgcolor="#CCCCFF">
		   <td style="margin-right:5px; padding:5px 5px 0px 5px;border:0px solid black;" align="left">  	   
			<a href="listing.php?" style='text-decoration: none;'>
				<font style="font-weight:normal; " color='#000080' face="Verdana" size="2">&#2348;&#2376;&#2325;</font>	</a>&nbsp;|&nbsp;				
			<a href='../../login/posting_detail/search1.php' style='text-decoration: none'>
				<font style="font-weight:normal; " color='#000080' face="Verdana" size="2" >&#2361;&#2379;&#2350;</font>    </a>&nbsp;|&nbsp; 
		   <a href='../../login/logout.php' style='text-decoration: none'>
				<font style="font-weight:normal; " color='#000080' face="Verdana" size="2" >&#2354;&#2377;&#2327; &#2310;&#2314;&#2335;	</font>  </a> </td>
			<td align="right">&nbsp;</td>	 
		  </tr>
		</table>
		<!--&#2350;&#2367;&#2340;&#2367; - &#2358;&#2367;&#2357;&#2366;-->      <TABLE id=AutoNumber2 style="BORDER-COLLAPSE: collapse" 
      borderColor=#e1e1e1 cellSpacing=0 cellPadding=0 width=775 border=1>
        <TBODY>
        <TR align=middle bgColor=#f4f4f4>
          <TD 
          style="PADDING-RIGHT: 5px; PADDING-LEFT: 5px; PADDING-BOTTOM: 0px; MARGIN-RIGHT: 5px; PADDING-TOP: 0px" 
          width="100%" height=20>
            <P align="center"><B><FONT style="FONT-SIZE: 9pt" face=Arial><A 
            style="TEXT-DECORATION: none" 
            href="http://www.uppolice.com.lpus1.onlyfordemo.com/login/transfer_detail/transfer1.php?pno=802464172#"><FONT 
            color=#000080></FONT></A><FONT color=#000080></FONT></FONT></B></P>
            </TD></TR></TBODY></TABLE></TD></TR>
  <TR vAlign=top>
    <TD vAlign=top>
      <TABLE id=AutoNumber2 style="BORDER-COLLAPSE: collapse" 
      borderColor=#111111 cellSpacing=0 cellPadding=0 width="100%" border=1>
        <TBODY>
        <TR>
          <TD width="100%">
       <form name="a" action="add_detail.php" method="post"  onSubmit="return frmValidation(document.a);">
          
            <TABLE id=AutoNumber3 
            style="BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; BORDER-COLLAPSE: collapse; BORDER-RIGHT-WIDTH: 0px" 
            borderColor=#ffffff height=732 borderColorDark=#ffffff cellPadding=4 
            width="100%" borderColorLight=#ffffff border=1>
              <TBODY>
              <TR>
                <TD 
                style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid" 
                colSpan=4 height=48>
                  <P class="href href" align=center><B>&#2346;&#2342;&#2379;&#2344;&#2381;&#2344;&#2340;&#2367; &#2357;&#2367;&#2357;&#2352;&#2339; </B></P></TD></TR>
              <TR bgColor=#f8f8fc>
                <TD height=98 colSpan=4 
                vAlign=center class="ftbl" 
                style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid"><p class="style16"><span class="style18"><FONT face=Verdana>&#2346;&#2352;&#2381;&#2360;&#2344;&#2354; &#2344;&#2350;&#2381;&#2348;&#2352; </FONT></span><span class="ftbl"><FONT face=Verdana>: <font face="Verdana">
                  <input type="hidden" name="personalno" value=" " />
                                    </font></FONT></span><FONT face=Verdana><br>
                  <br>
                  <span class="style18">&#2344;&#2366;&#2350; </span> :<span class="ftbl"><font class="styleHindi" size="4">
                     emp hindi name error = No database selected