<?

session_start();
include '../conn.php';
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'];
}
if(isset($_REQUEST["B1"]))
{
//print_r($_REQUEST);
//exit(0);
$temp = explode('/',$_REQUEST['fdate']);
$fdate = $temp[2].'-'. $temp[1].'-'. $temp[0];

$temp = explode('/',$_REQUEST['tdate']);
$tdate = $temp[2].'-'. $temp[1].'-'. $temp[0];

$ltype = $_REQUEST["ltype"];

/*
employee_name, rank, designation, f//om_date, to_date, taken_leave_days, left_leave_days, personal_number, serial_number, leave_type,  REMARK
serial_number, leave_code, leave_type, paid_unpaid, carry_forwd_next_yr_or_not, no_of_leave
*/


//keyid, 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, zone_name
//personalno







//personal_number, employee_name, rank, designation, type_of_posting, unit, sub_unit, district, details_eng, detail_hindi, station_of_so, from_date, to_date, serial_number


//echo "select * from new_posting_detail where personal_number = ".$_REQUEST['personalno'];
$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);
	$employee_name = $first_name_of_employee_english.' '.$middle_name_of_employee_english.' '.$last_name_of_employee_english;
	$rank = $present_rank;
	$designation = $present_designation;
	$from_date = $fdate;
	$to_date = $tdate;
	$type_of_posting = $_REQUEST['tempas'];
	$unit = $_REQUEST['Joining_Unit_Name'];
	$sub_unit =  $_REQUEST['Joining_Sub_Unit_Name'];   
	$district = $_REQUEST['tempas2'];
	$details_eng = $_REQUEST['S1'];
	$detail_hindi= $_REQUEST['S2'];

	
}
/*
Array
(
    [soid] => 1516
    [personalno] =>  982830028
    [tempas] => 62
    [fdate] => 10/17/2007
    [tdate] => 10/18/2007
    [tempas2] => MAU
    [Joining_Unit_Name] => 219
    [Joining_Sub_Unit_Name] => 89615
    [S1] => 67uiyiuyi
    [B1] => Submit
    [PHPSESSID] => e2cb5ebbd1ea55849ef070fae37cd327
)
*/
//echo "update so_detail set rank = '$rank', type_of_posting = '$type_of_posting', unit = '$unit', sub_unit = '$sub_unit', district = '$district', details_eng = '$details_eng', detail_hindi = '$detail_hindi', from_date = '$from_date', to_date = '$to_date' where personal_number='".$_REQUEST['personalno']."' and from_date='".$_REQUEST['frdate']."' and to_date='".$_REQUEST['todate']."'";
mysql_query("update so_detail set rank = '$rank', type_of_posting = '$type_of_posting', unit = '$unit', sub_unit = '$sub_unit', district = '$district', details_eng = '$details_eng', detail_hindi = '$detail_hindi', from_date = '$from_date', to_date = '$to_date' where personal_number='".$_REQUEST['personalno']."' and from_date='".$_REQUEST['frdate']."' and to_date='".$_REQUEST['todate']."'");

header("Location: confirm_so_edit.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='".$_REQUEST['id']."' ");

$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=""></SCRIPT>

<SCRIPT language=javascript src=""></SCRIPT>

<SCRIPT language=javascript src=""></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
}
.style24 {
	font-size: 14px;
	color: #000000;
}
.stylehindi {
			font-family: Kruti Dev 010; 
			font-size:16px;
}
.style15 {color: #FF0000;font-size:18px;  }
</STYLE>
<SCRIPT language=javascript src="../js/common.js"></SCRIPT>
<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);


//-->
</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
}
.style2 {
	FONT-SIZE: 11px; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif
}
.style3 {
	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 height=89 
            src='../images/banner1_01.jpg' width=775 
      border=0></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="edit_so_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 height=513 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=2 height=48>
                  <P class="href href" align=center><B>&#2319;&#2360;&#2406;&#2323;&#2406;/&#2319;&#2360;&#2406;&#2319;&#2330;&#2406;&#2323;&#2406; &#2325;&#2366; &#2357;&#2367;&#2357;&#2352;&#2339; </B><BR></P></TD></TR>
              <TR bgColor=#f8f8fc>
                <TD 
                style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid" 
                vAlign=center colSpan=2 height=98><FONT face=Verdana><span class="href"><font size="2" face="Verdana">&#2346;&#2352;&#2381;&#2360;&#2344;&#2354; &#2344;&#2350;&#2381;&#2348;&#2352; </font>: <font face="Verdana"><font size="2">
                <input type="hidden" name="personalno" value=" " />
                                </font></font><br>
                <br>
                <font size="2" face="Verdana">&#2344;&#2366;&#2350; </font><font size="2" face="Verdana">: </font><font class="styleHindi"><font size="4">
                  emp hindi name error = No database selected