<? session_start();
  //include '../conn.php';
include '../function.php';

  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'];
  }
//updatecrkrecotd($_SESSION['login_pno'], $_REQUEST['pno'], patrika_transdate);
  $orderdate = $rsq['transfer_order_date'];
  $orderno = $rsq['order_no '];
 
    $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['pno']."' ") or die(mysql_error());
    $arow=@mysql_fetch_array($results);
    @extract($arow);
     $data = "SELECT * FROM `promotion_head_const_driver` where personal_number=".trim($_REQUEST['pno'])."";
    $arow1=mysql_query($data);
      $arow2=@mysql_fetch_array($arow1);
     @extract($arow2);
function findrankComm1($pno){if($pno == '') return $pno;
	$results=mysql_query("select rank_eng,rank_id from rank_master where rank_id=(select rank from employee_master where personal_number=".$pno.")") or die(mysql_error());
	
	if($x = mysql_fetch_array($results))
	{
	
		return $x['rank_id'];
	} else {
	
		return 'N/A';
	}
}
	function findEmpHindiName1($pno)
	{ 
	$q=mysql_query("Select first_name_of_employee_hindi,mname_hindi,lname_hindi FROM employee_master 
					WHERE personal_number='".trim($pno)."'") or die("emp hindi name error = ".mysql_error());
	if(mysql_num_rows($q)>0) {
		$row=mysql_fetch_array($q);
		$empHindiName=$row['first_name_of_employee_hindi']." ".$row['mname_hindi']." ".$row['lname_hindi'];
		return $empHindiName;
	} return "----";					 
}
function findrankComm2($pno){if($pno == '') return $pno;
	$results=mysql_query("select rank_eng,rank_id from rank_master where rank_id=(select rank from employee_master where personal_number=".$pno.")") or die(mysql_error());
	
	if($x = mysql_fetch_array($results))
	{
	
		return $x['rank_eng'];
	} else {
	
		return 'N/A';
	}
}
function dateformatdriver($dt){
    if($dt==""){
        return "0000-00-00";
    }
    $date = explode('/', $dt);
    $alldate = $date[2].'-'.$date[1].'-'.$date[0];
    return $alldate;
}
    if(isset($_POST['B1'])){
       $cont_driver_rank = $_POST['cont_driver_rank'];
       $cont_driver_date = dateformatdriver($_POST['cont_driver_date']);
       $course_name = $_POST['course_name'];
       $course_no = $_POST['course_no'];
       $batch_no = $_POST['batch_no'];
       $obtain_marks = $_POST['obtain_marks'];
       $total_mark = $_POST['total_mark'];
       $driver_ident_num = $_POST['driver_ident_num'];
       $validity = dateformatdriver($_POST['validity']);
       $driving_category = $_POST['driving_category'];
       $crk_pno= $_SESSION['login_pno'];
       $personal_number= trim($_POST['personalno']);
        $crrent_rank= findrankComm1($_POST['personalno']);
       $employee_name= (findEmpHindiName1($_POST['personalno']));
       if($batch_no=="" || $batch_no=="0" ){
           $batch_no="0";
       }
       $unit_code= $_SESSION['Unit'];
       $unit_name= $_SESSION['Unit1'];
       //echo "INSERT INTO promotion_head_const_driver (id, personal_number, crk_pno, employee_name, emp_curr_rank, promo_current_rank, promotion_date, course_name, course_no, batch_no, obtain_mark, total_mark, licence_no, validity_date, category) VALUES (NULL, '" .trim($personal_number). "','" . $crk_pno . "', '" . $employee_name . "','".$crrent_rank."', '".$cont_driver_rank."', '".$cont_driver_date."', '".$course_name."', '".$course_no."', '".$batch_no."', '".$obtain_marks."', '".$total_mark."', '".$driver_ident_num."', '".$validity."', '".$driving_category."')";exit;
       $sql1= "INSERT INTO promotion_head_const_driver (id, personal_number, crk_pno, employee_name, emp_curr_rank, promo_current_rank, promotion_date, course_name, course_no, batch_no, obtain_mark, total_mark, licence_no, validity_date, category, unit_code, unit_name) VALUES (NULL, '" .trim($personal_number). "','" . $crk_pno . "', '" . $employee_name . "','".$crrent_rank."', '".$cont_driver_rank."', '".$cont_driver_date."', '".$course_name."', '".$course_no."', '".$batch_no."', '".$obtain_marks."', '".$total_mark."', '".$driver_ident_num."', '".$validity."', '".$driving_category."','".$unit_code."','".$unit_name."')" or die('Can not Execute11' . mysql_error());
       mysql_query($sql1);
       $sql2 ="UPDATE employee_master set rank='".$cont_driver_rank."' where personal_number='".trim($personal_number)."'";
       mysql_query($sql2);
       $sql3 ="UPDATE new_posting_detail set present_rank='".$cont_driver_rank."' where personal_number='".trim($personal_number)."'";
       mysql_query($sql3);
       header("Location: confirm_driver.php?pno=$personal_number");
       
    }
    if(isset($_POST['B2'])){
       $cont_driver_rank = $_POST['cont_driver_rank'];
       $cont_driver_date = dateformatdriver($_POST['cont_driver_date']);
       $course_name = $_POST['course_name'];
       $course_no = $_POST['course_no'];
       $batch_no = $_POST['batch_no'];
       $obtain_marks = $_POST['obtain_marks'];
       $total_mark = $_POST['total_mark'];
       $driver_ident_num = $_POST['driver_ident_num'];
       $validity = dateformatdriver($_POST['validity']);
       $driving_category = $_POST['driving_category'];
       $crk_pno= $_SESSION['login_pno'];
       $personal_number= trim($_POST['personalno']);
        $crrent_rank= findrankComm1($_POST['personalno']);
       $employee_name= findEmpHindiName1($_POST['personalno']);
       if($batch_no=="" || $batch_no=="0" ){
           $batch_no="0";
       }
       $unit_code= $_SESSION['Unit'];
       $unit_name= $_SESSION['Unit1'];
       //echo "UPDATE promotion_head_const_driver set crk_pno='".$crk_pno."', employee_name='".$employee_name."', emp_curr_rank='".$crrent_rank."', promo_current_rank='".$cont_driver_rank."', promotion_date='".$cont_driver_date."', course_name='".$course_name."', batch_no='".$batch_no."', obtain_mark='".$obtain_marks."', total_mark='".$total_mark."', licence_no='".$driver_ident_num."', validity_date='".$validity."', category='".$driving_category."' where personal_number=".$personal_number."";exit;
       $sql1= "UPDATE promotion_head_const_driver set crk_pno='".$crk_pno."', employee_name='".$employee_name."', promo_current_rank='".$cont_driver_rank."', promotion_date='".$cont_driver_date."', course_name='".$course_name."', course_no='".$course_no."' , batch_no='".$batch_no."', obtain_mark='".$obtain_marks."', total_mark='".$total_mark."', licence_no='".$driver_ident_num."', validity_date='".$validity."', category='".$driving_category."', unit_code='".$unit_code."', unit_name='".$unit_name."' where personal_number=".$personal_number."";
       mysql_query($sql1);
       $sql2 ="UPDATE employee_master set rank='".$cont_driver_rank."' where personal_number='".trim($personal_number)."'";
       mysql_query($sql2);
       $sql3 ="UPDATE new_posting_detail set present_rank='".$cont_driver_rank."' where personal_number='".trim($personal_number)."'";
       mysql_query($sql3);
       header("Location: confirm_driver.php?pno=$personal_number");
    }
    
?>
<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;}
            .styleHindi{font-family: "Kruti Dev 010";}
            -->
        </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>
      
        
        <link href="../styles.css" rel="stylesheet" type="text/css">
        
  </head>
  <body>
    <form name="frm1" action="" 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 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">