<?
session_start();
include '../conn.php';
$pno=$_REQUEST['id'];
while(strlen($pno)<9){
	$pno="0".$pno;
}
function findrank1($pno){
	if($pno == '') return $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'];
}
function formatDateField($date){
	if($date=='0000-00-00' || $date=='')
		return '';
	$strArray=explode("-",$date);
	$newDate=$strArray[2]."/".$strArray[1]."/".$strArray[0];
	return $newDate;
}
function datetodatabase($str){
	if($str=='' || $str=='//'){
		return '';
	}
	$strarr=explode("/",$str);
	$newdate=$strarr[2]."-".$strarr[1]."-".$strarr[0];
	return $newdate;
}
//$sel_date
if(isset($_REQUEST["B1"]))
{

if($_REQUEST['pdate']!=""){
$temp = explode('/',$_REQUEST['pdate']);
$Promotion_Date = $temp[2].'-'. $temp[1].'-'. $temp[0];
} else{
$Promotion_Date="0000-00-00";
}


/*
$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 key_id,personal_number,present_address,present_address_hindi,present_phone_residence_mobile,present_phone_office,present_range,present_state_name,present_district_name,present_rank,present_designation,proficiency_of_employee,present_grad,date_of_selection_grad,s_selection_grad_date,s_selection_grad,higher_selection_grad_date,higher_selection_grad,transfer_posting_flag,transfer_order_date,order_no,release_date,type_of_joining,joining_unit,joining_sub_unit,transfer_reason,posting_date,posting_time,pormotion_date,alloted_to,first_name_of_employee_english,middle_name_of_employee_english,last_name_of_employee_english,archive_date 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['Previous_Promotion_rank'];
	$no_of_previous_promotion=0;		
	if($_REQUEST['promotion_status']!=""){
	$no_of_previous_promotion=$_REQUEST['promotion_status'];	
	}
//$no_of_previous_promotion=$_REQUEST['promotion_status'];

	
}

$Promotion_OrderDate="0000-00-00";
if($_REQUEST['p_orderdate']!=""){
$Promotion_OrderDate=datetodatabase($_REQUEST['p_orderdate']);
}

mysql_query("update promotion_detail set Promotion_Date='$Promotion_Date', Promotion_Order_No='$Promotion_Order_No', Promotion_Type='$Promotion_Type', seniority_level='$seniority_level', sub_unit='$sub_unit',   Total_marks='$Total_marks',   Previous_Promotion_rank='$Previous_Promotion_rank',no_of_previous_promotion='$no_of_previous_promotion', Promotion_OrderDate='".$Promotion_OrderDate."',remark='".$_REQUEST['comment']."'   where Serial_number=".$_REQUEST['soid']);
header("Location: confirm_edit.php?id=".$personal_number);


}

 $rec=mysql_query("select Serial_number,Personal_Number,Employee_name,Previous_Promotion_rank,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,selection_date,selection_grade,selection_type,Promotion_OrderDate,remark,PTC_Session,PCT_Batch_no,chest_no,PTCName from promotion_detail where Serial_number=".$_REQUEST['eid']);

  $sec_type=array();
  if(mysql_num_rows($rec)){
	  while($row=mysql_fetch_array($rec)){
	  $sec_type[]=$row['selection_type'];
	  $seldate1=$row['selection_date'];
	  $selgrade=$row['selection_grade'];
	  }
   }
  $cnt=count($sec_type);
	
 $recno=mysql_query("select max(selection_type) maxi from promotion_detail where Personal_Number=".$pno);

 // $sec_type1=array();
 if(mysql_num_rows($recno)){
	  while($row=mysql_fetch_array($recno)){
	  $sec_type1=$row['maxi'];
	  }
  }
  $cnt1=count($sec_type1);

$temp = explode('-',$seldate1);
$sel_date = $temp[2].'/'. $temp[1].'/'. $temp[0];

function findrank($id = null)
{
	$results=mysql_query("select serial_number,rank_id,rank_eng,rank_hin 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 key_id,personal_number,present_address,present_address_hindi,present_phone_residence_mobile,present_phone_office,present_range,present_state_name,present_district_name,present_rank,present_designation,proficiency_of_employee,present_grad,date_of_selection_grad,s_selection_grad_date,s_selection_grad,higher_selection_grad_date,higher_selection_grad,transfer_posting_flag,transfer_order_date,order_no,release_date,type_of_joining,joining_unit,joining_sub_unit,transfer_reason,posting_date,posting_time,pormotion_date,alloted_to,first_name_of_employee_english,middle_name_of_employee_english,last_name_of_employee_english,archive_date 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 src="transfer_files/scriptaculous.js"></SCRIPT>
<SCRIPT language=javascript src="../js/common.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("fdate").value));
date1.setTime(date1temp.getTime());


date2temp = new Date(formatDate(document.getElementById("tdate").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 = date2_ms-date1_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;}
.style17 {font-family: Verdana, Arial, Helvetica, sans-serif}
</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;-->    </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="edit_detail.php" method="post"  onSubmit="return frmValidation(document.a);">
           <input type="hidden" name="soid" value="">
            <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" 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="ftbl"><FONT face=Verdana><font face="Verdana">&#2346;&#2352;&#2381;&#2360;&#2344;&#2354; &#2344;&#2350;&#2381;&#2348;&#2352;</font>: <font face="Verdana">
                  <input type="hidden" name="personalno" value="" />
                                    </font></FONT></span><FONT face=Verdana><br>
                  <br>
                  <span class="ftbl"><font face="Verdana">&#2344;&#2366;&#2350;: <font class="styleHindi" size="4">
                    emp hindi name error = No database selected