<? session_start();
if(!isset($_SESSION['Unit']) && !isset($_SESSION['user_type'])){
	header("Location: ../index.php");
}
//include '../conn.php';
include '../function.php';

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'];
}
if(isset($_REQUEST["B1"]))
{

$i_ddate="0000-00-00";
if($_REQUEST['enq_ord_date']!=""){
$temp = explode('/',$_REQUEST['enq_ord_date']);
$i_ddate = $temp[2].'-'. $temp[1].'-'. $temp[0];
}

$e_sdate="0000-00-00";
if($_REQUEST['e_sdate']!=""){
$temp = explode('/',$_REQUEST['e_sdate']);
$e_sdate = $temp[2].'-'. $temp[1].'-'. $temp[0];
}

$e_edate="0000-00-00";
if($_REQUEST['e_edate']!=""){
$temp = explode('/',$_REQUEST['e_edate']);
$e_edate = $temp[2].'-'. $temp[1].'-'. $temp[0];
}

$dop="0000-00-00";
if($_REQUEST['dop']!=""){
$temp = explode('/',$_REQUEST['dop']);
$dop = $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;
	$name_of_employee = $first_name_of_employee_english.' '.$middle_name_of_employee_english.' '.$last_name_of_employee_english;
	$present_rank = $present_rank;
	$unit_name = $joining_unit;
	$name_enquiry_officer = $_REQUEST['ef_name'];
	$rank_enquiry_officer = $_REQUEST['tempas3'];
	$enquiry_order_no = $_REQUEST['e_orderno'];
	$type_of_enquiry = $_REQUEST['e_type'];
	$enquiry_district = $_REQUEST['tempas2'];
	$suspended = $_REQUEST['e_suspend'];
	$enquiry_start_date = $e_sdate;
	$enquiry_end_date = $e_edate;
	$punishment_officer_name = $_REQUEST['p_officer'];
	$punishment_order_no = $_REQUEST['p_orderno'];
	$type_of_punishment = $_REQUEST['tempas'];
	$punishment = $_REQUEST['punishment_name'];
	$date_of_punsihment = $dop;
	$remark =  $_REQUEST['remarks'];
	$penaltyText =  $_REQUEST['penalty'];	
	
}

mysql_query("INSERT INTO `investigation` (`pno`, `investigation_date`, `officer_name`, `officer_post`, `order_no`, `order_date`, `e_type`,`order_type`, `dist_id`, `investigation_start`, `investigation_end`, `status`, `investigation_unit`) VALUES ('".$_REQUEST['personalno']."', '".$i_ddate ."' , '".$_POST['ef_name']."','".$_POST['tempas3']."', '".$_POST['e_orderno']."', '".$i_ddate."','".$_POST['e_type']."', '".$_POST['e_suspend']."', '".$_POST['tempas2']."', '".$e_sdate."', '".$e_edate."', '1','".$_POST['investigation_unit']."')") or die(mysql_error());
$personal_number=$_REQUEST['personalno'];
updatecrkrecotd($_SESSION['login_pno'], $_REQUEST['personalno'], investigation_transdate);
header("Location: confirm_add.php?id=".$personal_number);

}
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='".$_REQUEST['id']."' ");

$arow=mysql_fetch_array($results);
extract($arow);
include "../others.php";
?>
<!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>UP Police Nominal 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: 12px; COLOR: #333333; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif
}
.ftbl23 {
    FONT-SIZE: 16px; COLOR: #333333; FONT-FAMILY: 'Kruti Dev 010';
}
.style15 {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"; }
}
//  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 src="../js/common.js"></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
}
.style19 {font-size: 0.8em}
</STYLE>
</HEAD>
<BODY>
 <script language="javascript" type="text/javascript">
			 function checkPre() {
				date1 = new Date();
				date2 = new Date();
				diff  = new Date();
				diff1 = new Date();
				
				date1temp = new Date(formatDate(document.getElementById("e_sdate").value));
				date1.setTime(date1temp.getTime());
				
				
				date2temp = new Date(formatDate(document.getElementById("e_edate").value));
				date2.setTime(date2temp.getTime());
				
				 var ONE_DAY = 1000 * 60 * 60 * 24
			
				var date1_ms = date1temp.getTime()
				var date2_ms = date2temp.getTime()
				
				var difference_ms = date2_ms-date1_ms 
				
				var datDiffs= Math.round(difference_ms/ONE_DAY)
				datDiffs=datDiffs+1
				return datDiffs;
			}
				function frmValidation(myForm){
					
					
					if(myForm.ef_name.value=="")
					{
					   alert("Please fill Officer Name");
                       myForm.ef_name.focus();
                       return false;
					
					}
					if(myForm.tempas3.value=="" )
					{
					    alert("Please fill Officer Post");
                        myForm.tempas3.focus();
                        return false;
					
					}
					if(myForm.investigation_unit.value=="")
					{
					   	alert("Please select Investigation unit ");
                        myForm.investigation_unit.focus();
                        return false;
					}
				 if(myForm.e_orderno.value=="" )
					{
					    alert("Please fill Order no.");
                        myForm.e_orderno.focus();
                        return false;
					}
				if(myForm.enq_ord_date.value=="" )
					{
					    alert("Please fill Enquiry Order Date.");
                        myForm.enq_ord_date.focus();
                        return false;
					}
				if(myForm.tempas2.value=="" )
					{
					    alert("Please Select District.");
                        myForm.tempas2.focus();
                        return false;
					}
				if(myForm.e_sdate.value=="" )
					{
					    alert("Please fill Enquiry Starting Date.");
                        myForm.e_sdate.focus();
                        return false;
					}
				if(myForm.e_edate.value=="" )
					{
					    alert("Please fill Enquiry Ending Date.");
                        myForm.e_edate.focus();
                        return false;
					}
					
                  }
			
			  function dateCheck(str){
						pattern = /^[0-9]*$/;
						var d=str.substr(2,1);
						 var m=str.substr(2,1);
						  var mm=str.substr(3,2);
						   var dd=str.substr(0,2)
						 var y=str.substr(6).length;
						 if(d=='/' & m=='/' & y==4 & (dd>=1 & dd<=31) & (mm<=12 & mm>=1) & pattern.test(mm) & pattern.test(dd) & pattern.test(str.substr(6)))
						return true;
						 else {
						 
						return false;
						}
						}
        </script>
  
  <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>

      
      <TABLE id=AutoNumber2 style="BORDER-COLLAPSE: collapse" borderColor=#e1e1e1 cellSpacing=0 cellPadding=0 width=775 border="0">
        <TBODY>
		<tr>
			<td></td>
		</tr>
        <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 action="add_detail.php" method="post" name="login" id="login" onSubmit="return frmValidation(document.login)"><!-- onSubmit="return frmValidation(document.login)"-->
          
            <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=483 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>&#2332;&#2366;&#2306;&#2330; &#2325;&#2366; &#2357;&#2367;&#2357;&#2352;&#2339;<b></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=4 height=98><FONT face=Verdana><span class="href"><font size="2">&#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">&#2344;&#2366;&#2350; </font><font size="2" face="Verdana">: </font><font class="styleHindi"><font size="4">