<?
session_start();
//include '../conn.php';
include '../function.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.")") or die(mysql_error());
	if($x = mysql_fetch_array($results)) return $x['rank_hin'];
}

if(isset($_REQUEST["B1"]))
{
//print_r($_REQUEST);
//exit;
$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"];

$checkrs=mysql_query("Select personal_number,leave_type,rem_leave from emp_remain_leave where personal_number=".$_REQUEST['personalno']." and leave_type=".$ltype);
if(mysql_num_rows($checkrs)>0){
	mysql_query("update emp_remain_leave set rem_leave=". $_REQUEST['left_leave']." where personal_number=".$_REQUEST['personalno']." and leave_type=".$ltype);
}else{
	mysql_query("Insert into emp_remain_leave values(".$_REQUEST['personalno'].",'".$ltype."',".$_REQUEST['left_leave'].")") or print mysql_error() ;
}
updatecrkrecotd($_SESSION['login_pno'], $_REQUEST['personalno'], leave_transdate);
$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);
	$employee_name = $first_name_of_employee_english.' '.$middle_name_of_employee_english.' '.$last_name_of_employee_english;
	$rank = $present_rank;
	$designation = $present_designation;
	$leave_type = $_REQUEST['ltype'];
	$from_date = $fdate;
	$to_date = $tdate;
	$taken_leave_days = $_REQUEST['total_leave'];
	$left_leave_days =  $_REQUEST['left_leave'];
	
	$REMARK =  $_REQUEST['remark'];

}
mysql_query("insert into leave_detail(employee_name, rank, designation, leave_type,from_date, to_date, taken_leave_days, left_leave_days, personal_number, REMARK ) values('$employee_name', '$rank', '$designation','$leave_type', '$from_date', '$to_date', '$taken_leave_days', '$left_leave_days', '$personal_number', '$REMARK')") ;
header("Location: confirm_leave.php?id=$personal_number");
}
function findrank($id = null)
{
	$results=mysql_query("select serial_number,rank_id,rank_eng,rank_hin,unit_code,rank_description,designation,group_category,source_of_joing,approved_posts_number 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';
	}
}
$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']."' ") or die(mysql_error());

$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="../js/common.js"></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
}
.style11 {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"; }
}


function dateDiff() {

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

diff.setTime(Math.abs(date1.getTime() - date2.getTime()));

timediff = diff.getTime();

weeks = Math.floor(timediff / (1000 * 60 * 60 * 24 * 7));
//timediff -= weeks * (1000 * 60 * 60 * 24 * 7);

days = Math.floor(timediff / (1000 * 60 * 60 * 24)); 
timediff = days * (1000 * 60 * 60 * 24);

day=days+1;
if(isNaN(days))
document.getElementById("total_leave").value = ''
else
document.getElementById("total_leave").value = day
return false; // form should never submit, returns false
}

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="leave_edit.php?id=".$_REQUEST[eid];
}
 </SCRIPT>

<SCRIPT language=javascript>

function getRemaining(){
	var unit=document.getElementById("ltype").value;
	var pno=document.getElementById("personalno").value;
	
	getData('subunitDiv','leaveCode.php?id='+unit+"&pno="+pno);
}

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>


<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
}
.style14 {
color:#333333; font-size:14px
}

</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>.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="/uppolice/login/leave_11_12_2013/leave.php" method="post" onSubmit="return frmValidation(document.a);">
                    
            <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=471 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 align="center" class="style14"><B>&#2309;&#2357;&#2325;&#2366;&#2358; &#2357;&#2367;&#2357;&#2352;&#2339;</B><BR></p></TD></TR>
              <tr bordercolor="#FFFFFF" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF" bgcolor="#F8F8FC">
                <td height="144" colspan="4" valign="middle" style="border-style: solid; border-width: 1"; class="style14"><b> &#2346;&#2352;&#2381;&#2360;&#2344;&#2354; &#2344;&#2350;&#2381;&#2348;&#2352;: </b>
				<!--<font face="Verdana"><span class="ftbl"><span class="href"><font face="Verdana"><font size="2"-->
                 <input type="hidden" name="personalno" id="personalno" value="" />
                                    </font></font><br>
                  <br>
                  <span class="style14"><b> &#2344;&#2366;&#2350;: </b></span><font class="styleHindi" size="2">
                  emp hindi name error = No database selected