<?
session_start();
include '../conn.php';

function findrank($id = null)
{
	$results=mysql_query("select rank_eng from rank_master where rank_id=".$id) or die(mysql_error());
	
	if($x = mysql_fetch_array($results))
	{
		return $x['rank_eng'];
	}
	else
	{	
		return 'N/A';
	}
}

if(isset($_POST['B1'])){	
	$_SESSION['pno']=$_REQUEST['Personal_number'];

        if($_SESSION['defType']=="2"){ 
		    $unitName='';
            if($_POST['Joining_Unit_Name']==null){
                if($_POST['Joining_District']!=null) $unitName=unitCode($_POST['Joining_District'],"unit1");
                else if($_POST['Joining_Range']!=null) $unitName=$_POST['Joining_Range'];
                else if($_POST['tempas']!=null) $unitName=zoneCode($_POST['tempas'],"unit1"); 
            }else{ $unitName=$_POST['Joining_Unit_Name'] ; }
            
            $subunitName='';
            if($_POST['Joining_Sub_Unit_Name']==null){
                if($_POST['Joining_Unit_Name']!=null) $subunitName=$_POST['Joining_Unit_Name'];
                else if($_POST['Joining_District']!=null) $subunitName=unitCode($_POST['Joining_District'],"subunit1");
                else if($_POST['Joining_Range']!=null) $subunitName=$_POST['Joining_Range'];
                else if($_POST['tempas']!=null) $subunitName=zoneCode($_POST['tempas'],"subunit1");
            }else $subunitName=$_POST['Joining_Sub_Unit_Name'] ;
        
        }
//		echo $unitName."::".$subunitName;
		@mysql_query("Insert into allotted_posting_detail select * from new_posting_detail where personal_number='".$_POST['Personal_number']."'");
		@mysql_query("UPDATE allotted_posting_detail set joining_unit = '".$unitName."',  joining_sub_unit = '".$subunitName."', transfer_posting_flag ='A' where personal_number = ".$_POST['Personal_number']);
		
		@mysql_query("UPDATE new_posting_detail set transfer_posting_flag ='A' where personal_number = ".$_POST['Personal_number']);
}
function zoneCode($zonename,$unitType){
    if($_SESSION['defType']=="1"){
        if($unitType=="unit"){
            $q=mysql_query("SELECT Distinct pno_unit_code FROM sub_unitmaster where unit = '".$zonename."'");
            $zoneCode=mysql_fetch_array($q); 
            return $zoneCode['pno_unit_code'];
       }else if($unitType=="subunit"){
            $q = mysql_query("select Distinct sub_unit_code FROM sub_unitmaster where unit ='".$zonename."'");
            $unitCode=mysql_fetch_array($q);
            return $unitCode['sub_unit_code'];
       }       
    }else if($_SESSION['defType']=="2"){
        $q=mysql_query("SELECT Distinct hqrs_code FROM nondef where hqrs = '".$zonename."'");
        $zoneCode=mysql_fetch_array($q); 
        return $zoneCode['hqrs_code'];
    } return null;   
}

function rangeCode($rangeCode){
   $q = mysql_query("select Distinct sub_unit_code FROM sub_unitmaster where pno_unit_code ='".$rangeCode."'");
   $unitCode=mysql_fetch_array($q);
   return $unitCode['sub_unit_code'];
}            

function unitCode($unitName,$unitType){
    if($_SESSION['defType']=="1"){
        if($unitType=="unit"){
            $q = mysql_query("select Distinct pno_unit_code FROM sub_unitmaster where unit ='".$unitName."'");
            $unitCode=mysql_fetch_array($q);
            return $unitCode['pno_unit_code'];
        }else if($unitType=="subunit"){
            $q = mysql_query("select Distinct sub_unit_code FROM sub_unitmaster where unit ='".$unitName."'");
            $unitCode=mysql_fetch_array($q);
            return $unitCode['sub_unit_code']; 
        }       
    }else if($_SESSION['defType']=="2"){
        $q=mysql_query("SELECT distinct sub_unit,sub_unit_code FROM sub_unitmaster WHERE sub_unit='".$unitName."'");
        $unitCode=mysql_fetch_array($q);
        return $unitCode['sub_unit_code'];
    }return ;    
}

function subUnitCode($unitCode){
    $q = mysql_query("select Distinct sub_unit_code FROM sub_unitmaster where pno_unit_code ='".$unitCode."'");
    $unitCode1=mysql_fetch_array($q);
    return $unitCode1['sub_unit_code'];
}
    
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if(!isset($_REQUEST['pno']))
{
header('Location: ../posting_detail/search1.php');
exit(0);
}
//echo 'select * from new_posting_detail where personal_number  = '.$_REQUEST['pno'];
$rsq = mysql_query('select transfer_posting_flag from new_posting_detail where personal_number  = '.$_REQUEST['pno']);
$rsq = mysql_fetch_array($rsq);
if($rsq['transfer_posting_flag']=='T')
{
header('Location: transfer1.php?pno='.$_REQUEST['pno']);
exit(0);
}



$results=mysql_query("select * from new_posting_detail where personal_number='".$_REQUEST['pno']."' ") or die(mysql_error());
if(mysql_num_rows($results)==0)
{
$_SESSION['error1'] = true;
header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/posting.php" );
exit; 
?>
<?
}
$arow=mysql_fetch_array($results);
extract($arow);
/* if($unit_name == $_SESSION['Unit'])
{} else {
header('Location: search1.php');
exit(0);
} */
?>
<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Uttar Pradesh Police Nominol Roll System</title>

<script src="../scriptaculous/lib/prototype.js"></script>
<script src="../scriptaculous/src/scriptaculous.js?load=effects"></script>
<SCRIPT language=javascript src="../menuslide.js"></SCRIPT>
<SCRIPT language=javascript src="../menuinfo.js"></SCRIPT>
<SCRIPT language=javascript src="../header1.js"></SCRIPT>
<script src="../Date/calandar.js"></script>
<link href="../Date/calandar.css" rel="stylesheet" type="text/css">



<style type="text/css">
<!--
.ftbl {        font-family: Verdana, Arial, Helvetica, sans-serif;
        font-size: 11px;
        color: #333333;
}
-->
</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 defRadio(){
new Effect.Appear('axx');
new Effect.Fade('joiningidx');
}
function nonDefRadio(){
new Effect.Appear('joiningidx');
new Effect.Fade('axx');
}
 </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 = 1947; intLoop < 2030; 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>

  <!-- calendar stylesheet -->
  <link rel="stylesheet" type="text/css" media="all" href="cal/skins/aqua/theme.css" title="win2k-cold-1" />

  <!-- main calendar program -->
  <script type="text/javascript" src="cal/calendar.js"></script>

  <!-- language for the calendar -->
  <script type="text/javascript" src="cal/lang/calendar-en.js"></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 type="text/javascript" src="cal/calendar-setup.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);
//-->
</script>
<link href="../styles.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
.but {    font-weight:bold;
	color: #ffffff;
	
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 12px;
	background:#999966
}
.cambo {    width: 59px;
	background:#ffffff
}
.cambo1 {    width: 90px;
	background:#ffffff
}
.href {	color: #000000;
}
.style1 {color: #FFFFFF}
.style2 {font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif;}
.style14 {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	color: #000099;
	font-size: 14px;
}
.style17 {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 14pt;
}
.style19 {
	color: #000000;
	font-size: 14pt;
	font-family: Verdana, Arial, Helvetica, sans-serif;
}
-->
</style></head>
<body>

    <form name="frm1" action="allotment.php" method="post" onSubmit="return frmValidation(document.frm1);" >
        <table width="775" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr valign="top">
    <td valign="top"><table border='0' cellpadding='0' cellspacing='0' style='border-collapse: collapse' width='775' id='AutoNumber1'>
      <tr valign="top">
        <td width='100%' valign="top"><img border='0' src='../images/banner1_01.jpg' width='775' height='89' /></td>
      </tr>
    </table></td>
  </tr>
  <tr valign="top">
    <td valign="top" height='20'>

<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;
}
.blink_me {
  animation: blinker 1s linear infinite;
  color:#f00;
}

@keyframes blinker {  
  50% { opacity: 0; }
}
-->
</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'>
                - </font></td>
  </tr>
  <tr bgcolor="#CCCCFF">
   <td style="margin-right:5px; padding:0px 5px 0px 5px;border:0px solid black;" align="left">  	   
	<a href="" style='text-decoration: none;'>
		<font style="font-weight:normal; " color='#000080' face="Verdana" size="2">&#2348;&#2376;&#2325;</font>	</a>&nbsp;|&nbsp;
			
<!--	<a href='../posting_detail/search1.php' style='text-decoration: none'>-->
	<a href='../posting_detail/index.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='../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">          
        <b>
        <font face="Verdana" size="2">
        	
		  
	      </font> 		    
		<!--<a style="text-decoration: none" class="style9" href="../../master_forms/employee_master/index.php">
		   <font size="2" color='#000080'>&#2325;&#2352;&#2381;&#2350;&#2330;&#2366;&#2352;&#2368; &#2325;&#2366; &#2357;&#2367;&#2357;&#2352;&#2339; &#2332;&#2379;&#2337;&#2364;&#2375;&#2306;</font>
		</a>--><span style="display:none;">&nbsp;|
        <a style="text-decoration: none" class="style9" href="../old_employee/index.php">
            <font size="2" color='#000080'>&#2346;&#2370;&#2352;&#2381;&#2357; &#2325;&#2352;&#2381;&#2350;&#2330;&#2366;&#2352;&#2368; &#2325;&#2366; &#2357;&#2367;&#2357;&#2352;&#2339; &#2332;&#2379;&#2337;&#2375;&#2306;</font>
		</a></span>
				&nbsp;|
		<a href="../reports/index.php" style="text-decoration: none" class="style9"><font size="2" color='#000080'>&#2352;&#2367;&#2346;&#2379;&#2352;&#2381;&#2335;&#2360;</font></a>
		    
    </td>	 

  </tr>
</table><!--&#2350;&#2367;&#2340;&#2367; - &#2358;&#2367;&#2357;&#2366;-->	<div style="border:0px solid green;position:relative;text-align:right;top:-18px;right:160px;">|<a href="../hc/detail.php?id=" class="style14">&#2346;&#2370;&#2352;&#2381;&#2357; &#2346;&#2379;&#2360;&#2381;&#2335;&#2367;&#2306;&#2327; &#2325;&#2366; &#2357;&#2367;&#2357;&#2352;&#2339; </a>  	</div>  </td>
  </tr>
   <tr>
      <td valign="top">
	<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2">
 <tr>  
       <td width="100%">
          <table border="1" cellpadding="4" style="border-width:0; border-collapse: collapse" bordercolor="#FFFFFF" width="100%" id="AutoNumber3" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF" height="490">
            <tr>
              <td height="48" colspan="2" style="border-style: solid; border-width: 1">
                <p align="center" class="href href"><font size="3"><b>Allotment Details</b></font></p></td>
            </tr>
            <tr bgcolor="#F8F8FC">
              <td height="144" colspan="2" valign="middle" style="border-style: solid; border-width: 1">
			  <!--? include "../emp_detail.php"; ?-->
			  
			  <font face="Verdana"><span class="ftbl"><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 class="styleHindi"><font size="4">
              emp hindi name error = No database selected