 <? session_start();
    if(!isset($_REQUEST['pno'])){
        header('Location: ../posting_detail/search1.php');
        exit(0);
    }
    include '../conn.php';
if(isset($_REQUEST['B1'])) {	  
        $temps = explode('/',$_REQUEST['sgd']);
        $Release_date = $temps[2].'-'. $temps[1].'-'. $temps[0];	
		
		$dep_date = explode('/',$_REQUEST['depdate']);
        $departe_date = $dep_date[2].'-'. $dep_date[1].'-'. $dep_date[0];
		
		$gddates = explode('/',$_REQUEST['gddate']);
        $gddate = $gddates[2].'-'. $gddates[1].'-'. $gddates[0];		
        $_SESSION['pno']=$_REQUEST['Personal_number'];
	   
	     $sql_s=mysql_query("select personal_number from salary_lpc where is_finalize='1' and personal_number='".$_REQUEST['Personal_number']."'");
		 $num_s=mysql_num_rows($sql_s);
		 
         if($num_s>0)
		 {
		
		$tempRs=mysql_query("Select transId, personal_number,employee_name,dob,doj,rankId,rankName,fromUnit,toUnit,toUnitName,wo_number,wo_date from employee_transfer_order where personal_number='".$_REQUEST['Personal_number']."' and (status_flag='T' or status_flag='SC') and fromUnit='".$_SESSION["Unit"]."' order by transId desc") or die(mysql_error());	
		if(mysql_num_rows($tempRs)){			
			$tempData=mysql_fetch_assoc($tempRs);			
			if($_POST["status"]=="1"){
			$unitRs=mysql_query("Select pno_unit_code, sub_unit_code from sub_unitmaster Where (pno_unit_code='".$tempData["toUnit"]."' or sub_unit_code='".$tempData["toUnit"]."') limit 0,1");	
			if(mysql_num_rows($unitRs)){
				$unitData=mysql_fetch_assoc($unitRs);
				$join_unit=$unitData["pno_unit_code"];
				$sub_join_unit=$unitData["sub_unit_code"];				
			}
			mysql_query("update temp_itransfer_detail set transfer_posting_flag = 'TP',  release_date = '".$Release_date."' where personal_number = '".$_REQUEST['Personal_number']."'") or die(mysql_error());
			
			mysql_query("update new_posting_detail set transfer_posting_flag = 'TP',  release_date = '".$Release_date."', joining_unit='".$join_unit."', joining_sub_unit='".$sub_join_unit."' where personal_number = '".$_REQUEST['Personal_number']."'") or die(mysql_error());
			
			mysql_query("delete from temp_itransfer_detail where personal_number = '".$_REQUEST['Personal_number']."'") or die(mysql_error());						
			
			mysql_query("UPdate employee_transfer_order Set releived_on='".$Release_date."', releive_status='".$_POST["status"]."', hbo_no='".addslashes($_POST["hob"])."', gd_no='".addslashes($_POST["draft"])."', gd_date='".$gddate."', departure_date='".$departe_date."',status_flag='R', releiving_officer='".addslashes($_POST["officer_name"])."', releiving_officer_desig='".addslashes($_POST["officer_name_desig"])."' Where transId=".$tempData["transId"]) or die(mysql_error());
			
			mysql_query("update archive_posting_detail set transfer_posting_flag='TP', release_date ='".$Release_date."' where transfer_posting_flag='T' and personal_number = '".$_REQUEST['Personal_number']."'");
			mysql_query("update allotted_posting_detail set status='1'  where personal_number = '".$_REQUEST['Personal_number']."'");
			header("Location: confirm_transfer1.php?c=".$tempData["transId"]);
			exit(0);
			}else{
				mysql_query("update new_posting_detail set transfer_posting_flag = 'P' where personal_number = '".$_REQUEST['Personal_number']."'") or die(mysql_error());
				mysql_query("delete from temp_itransfer_detail where personal_number = ".$_REQUEST['Personal_number']) or die(mysql_error());
				
				mysql_query("update archive_posting_detail set transfer_posting_flag='TP', release_date ='".$Release_date."' where transfer_posting_flag='T' and personal_number ='".$_REQUEST['Personal_number']."'");
				header("Location: confirm_transfer1.php");
				exit(0);
			}
		}
		 }
		 else
		 {
			 header("Location: confirm_lpc.php");
		 }
		
		/*******************************************************************************************************************/
	    /*$rs = mysql_query("select * from temp_itransfer_detail where personal_number = '".$_REQUEST['Personal_number']."'");
	    if(mysql_num_rows($rs) > 0){	
            $rs = mysql_fetch_array($rs);
		    if($_POST['status']){
			$getRs=mysql_query("select Joining_Unit_Name,Joining_Sub_Unit_Name from transfer_detail where Personal_number='".$_REQUEST['Personal_number']."' order by Serial_number desc limit 0,1");
			while($rows=mysql_fetch_array($getRs)){
			$join_unit=$rows[0];
			$sub_join_unit=$rows[1];
			}
			    if($rs['transfer_posting_flag'] == 'T')	{
				mysql_query("update temp_itransfer_detail set transfer_posting_flag = 'TP',  release_date = '".$Release_date."' where personal_number = '".$_REQUEST['Personal_number']."'") or die(mysql_error());
				
				mysql_query("delete from new_posting_detail where personal_number = '".$_REQUEST['Personal_number']."'") or die(mysql_error());
				mysql_query("insert ignore into new_posting_detail 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,zone_name ,archive_date,nature_of_job,trans_date from temp_itransfer_detail  where personal_number = '".$_REQUEST['Personal_number']."'");
				
					mysql_query("INSERT INTO other_transfer_detail (personal_number ,HOB_number ,DD_no ,DD_date,depart_date,gddate)	VALUES ('".$_REQUEST['Personal_number']."', '".$_REQUEST[hob]."', '".$_REQUEST[draft]."', '0000-00-00', '".$departe_date."','".$gddate."s')");
		//	mysql_query("update new_posting_detail set transfer_posting_flag = 'TP',joining_unit='".$join_unit."',joining_sub_unit='".$sub_join_unit."' where personal_number = ".$_REQUEST['Personal_number']) or die(mysql_error());
				mysql_query("delete from temp_itransfer_detail where personal_number = '".$_REQUEST['Personal_number']."'") or die(mysql_error());
			//	echo "update archive_posting_detail set release_date ='".$Release_date."' where personal_number ".$_REQUEST['Personal_number'];
				mysql_query("update archive_posting_detail set transfer_posting_flag='TP', release_date ='".$Release_date."' where transfer_posting_flag='T' and personal_number = '".$_REQUEST['Personal_number']."'");
				//".$Release_date."
				$r=mysql_query("select key_id from archive_posting_detail where personal_number = '".$_REQUEST['Personal_number']."' order by key_id desc limit 1,1");
//				echo "select key_id from archive_posting_detail where personal_number = ".$_REQUEST['Personal_number']." order by key_id desc limit 1,1";
				mysql_query("update allotted_posting_detail set status='1'  where personal_number = '".$_REQUEST['Personal_number']."'");
				header("Location: confirm_transfer1.php");
				exit(0);
			}
		
		}else{
		   // echo "update new_posting_detail set transfer_posting_flag = 'P' where personal_number = ".$_REQUEST['Personal_number'];
			mysql_query("update new_posting_detail set transfer_posting_flag = 'P' where personal_number = '".$_REQUEST['Personal_number']."'") or die(mysql_error());
			mysql_query("delete from temp_itransfer_detail where personal_number = ".$_REQUEST['Personal_number']) or die(mysql_error());
			
			mysql_query("update archive_posting_detail set transfer_posting_flag='TP', release_date ='".$Release_date."' where transfer_posting_flag='T' and personal_number ='".$_REQUEST['Personal_number']."'");
			header("Location: confirm_transfer1.php");
			exit(0);
		}
	 }*/
  }

  function findrank($id = null){
	if($id == '') return $id;
	$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'];
  }

  $rsq = mysql_query("select transfer_posting_flag,order_no,transfer_order_date from  temp_itransfer_detail where personal_number  = '".$_REQUEST['pno']."'");
  $rsq = mysql_fetch_array($rsq);
  if($rsq['transfer_posting_flag']=='P'){
    header('Location: transfer.php?pno='.$_REQUEST['pno']);
    exit(0);
  }

  $orderdate = $rsq['transfer_order_date'];
  $orderno = $rsq['order_no'];
 
    $results=mysql_query("select * from temp_itransfer_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" );
		 header("Location: http://" . $_SERVER['HTTP_HOST'] .  "/login/posting_detail/posting.php" );
        exit;
    }
    $arow=mysql_fetch_array($results);
    extract($arow);?>
<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">
            <!--
            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;}
            .href1 {  margin-left: 5px; margin-top: 5px; margin-bottom: 5px;color: #000000;font-size: 14px;}
            .style1 {color: #FFFFFF;}
            .style2 {font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif;}
            .style15 {color: #333333;}
            .ftbl { font-family: Verdana, Arial, Helvetica, sans-serif;  font-size: 11px;   color: #333333;}
			.style99 {
	color:#669900;
	font-weight: bold;
}
			
            -->
        </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 imposeMaxLength(Object, MaxLen){
                return (Object.value.length <= MaxLen);
            }
            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;
                } return true;
            }
            function Submit(){
                document.frm1.submit();
            }
            function reset1(){
                window.location="transfer.php";
            }
                     </script>

        <link rel="stylesheet" href="css/stylesheet.css" type="text/css">
        <!-- 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">
        
  </head>
  <body>
    <form name="frm1" action="transfer1.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;--></td>
  </tr>
  <tr valign="top">    <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">
                        <tr>
                            <td height="25" colspan="2" style="border-style: solid; border-width: 1">
                                <p align="center" class="href href">
                          <b>&#2325;&#2352;&#2381;&#2350;&#2330;&#2366;&#2352;&#2368; &#2325;&#2366; &#2357;&#2367;&#2357;&#2352;&#2339; </b>                            </td>
                        </tr>
                        <!--tr bgcolor="#F8F8FC">
                            <td colspan="2" valign="top" >
                                <p class="styleHindi">&#2346;&#2352;&#2381;&#2360;&#2344;&#2354; &#2344;&#2350;&#2381;&#2348;&#2352; : <?php//$personal_number ?>
                                <p class="styleHindi">&#2344;&#2366;&#2350; : <?php//findEmpHindiName($personal_number)?></p>
                                <p class="styleHindi">&#2346;&#2342;&#2344;&#2366;&#2350; :<?php//findrankComm($personal_number)?></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