<? session_start();
if(!isset($_SESSION['Unit']) && !isset($_SESSION['user_type'])){
	header("Location: ../index.php");
}
set_time_limit(300);
	function getDateInQueryFormat($dateArr){
		list($date,$month,$year)=explode('-',$_REQUEST["dateText"]);
		return ($year).'/'.$month.'/' .$date;
    }
	
	include "../conn.php";

$condition = "";
$conditionPostingUnit = "";
$defType=1;
$zone=0;
$range=0;
$unit=0;
$subunit=0;
$thana=0;
	
$distRs=mysql_query("select district_code,district_name_eng from district_master_home order by district_name_eng");
$distArray=array();
while($dist=mysql_fetch_assoc($distRs)){
	$distArray[$dist["district_code"]]=$dist["district_name_eng"];
}
if(isset($_POST['defType'])){
$defType=$_POST['defType'];
}
if(isset($_POST['zoneName'])){
$zone=$_POST['zoneName'];
}
if(isset($_POST['rangeName'])){
$range=$_POST['rangeName'];
}
if(isset($_POST['unitName'])){
$unit=$_POST['unitName'];
}
if(isset($_POST['thanaName'])){
$subunit=$_POST['thanaName'];
}
if(isset($_POST['subUnitName'])){
$subunitND=$_POST['subUnitName'];
}
$displayUnit='---';

if($_SESSION['user_type']=='user'){ 

if($defType=="1"){
$unitLogin= $_POST['unitName'];
$subUnitLogin=$_POST['thanaName'];

 //$condition=$condition." and (b.type_of_joining = 'def' or b.type_of_joining = '1')";
 if($subUnitLogin!=0){
		$condition=$condition." and (b.joining_unit  = '".$unitLogin."') and (b.joining_sub_unit  = '".$subUnitLogin."')";
		$displayUnit=$unitLogin;
  }
  else{
		$condition=$condition." and (b.joining_unit  = '".$unitLogin."') ";
		$displayUnit=$unitLogin;
  }
}else{
 $subUnitLogin= $_SESSION['Unit'];
$unitLogin=substr($subUnitLogin,0,3);

// $condition=$condition." and (b.type_of_joining = 'nondef' or b.type_of_joining = '2')";
  if($subUnitLogin!=0){
$condition=$condition." and (b.joining_unit  = '".$unitLogin."') and (b.joining_sub_unit  = '".$subUnitLogin."')";
$displayUnit=$subUnitLogin;
}else{
$condition=$condition." and (b.joining_unit  = '".$unitLogin."')";
$displayUnit=$unitLogin;
}
}

} else{

if(($zone=="0" || $zone=="") && ($range=="0" || $range=="") && ($unit=="0" || $unit=="") && ($subunit=="0" || $subunit=="") && ($subunitND=="0" || $subunitND=="") ){
	if($defType=="1") {
       $condition=$condition." and (b.type_of_joining = 'def' or b.type_of_joining = '1')";
	  
	}else if($defType=="2") {
		$condition=$condition." and (b.type_of_joining = 'nondef' or b.type_of_joining = '2')";
		
		}
		

	}else {
if($defType=="1"){

// $condition=$condition." and (b.type_of_joining = 'def' or b.type_of_joining = '1')";
 if($unit!='0' && $unit!=''){
 	$condition=$condition." and (b.joining_unit = '".$unit."')";
 }else if($range!='0' && $range!=''){
 	$condition=$condition." and ((b.joining_unit in (SELECT dist_code from zone_rang_dist_mst where range_code = '".$range."')) or b.joining_unit='".$range."')";
 }else if($zone!='0' && $zone!=''){
 	$condition=$condition." and ((b.joining_unit in (select dist_code from zone_rang_dist_mst where zone_code = '".$zone."')) or b.joining_unit='".$zone."')";
 }

}else if($defType=="2"){
// $condition=$condition." and (b.type_of_joining = 'nondef' or b.type_of_joining = '2')";
 if($unit !='0'){
	if($subunitND=='0' || $subunitND=='-1'){  // records of hqrs 
		$unit=$unit;
		$condition=$condition." and (b.joining_unit = '".$unit."')";
		$displayUnit=$unit;
	} else{  // records of selected subunit
		
		$condition=$condition." and (b.joining_sub_unit  = '".$subunitND."')";
		$displayUnit=$subunitND;
	}
}

}
	}

}

		
	function findrank($present_rank){
                   if($present_rank==null) return '---'; 
                   $results=mysql_query("SELECT rank_hin FROM rank_master WHERE rank_id=(select rank from employee_master where personal_number=".$present_rank.")") or die(mysql_error());
                    if(mysql_num_rows($results)>0){
                        $x = mysql_fetch_array($results);
                        return $x['rank_hin'];
                    }return '---';
               }
     function findrankEng($rank){
                   if($rank==null) return '---'; 
                   $results=mysql_query("SELECT rank_eng FROM rank_master WHERE rank_id=".$rank) or die(mysql_error());
                    if(mysql_num_rows($results)>0){
                        $x = mysql_fetch_array($results);
                        return $x['rank_eng'];
                    }return '---';
               }
		function findrankHin($rank){
                   if($rank==null) return '---'; 
                   $results=mysql_query("SELECT rank_hin FROM rank_master WHERE rank_id=".$rank) or die(mysql_error());
                    if(mysql_num_rows($results)>0){
                        $x = mysql_fetch_array($results);
                        return $x['rank_hin'];
                    }return '---';
               }	   
		function findunitdisp($joining_unit){
	if($joining_unit==null or $joining_unit=='---') return '---';
	if(strlen($joining_unit)==3)
	$unit=mysql_query("SELECT unit_hindi FROM sub_unitmaster WHERE pno_unit_code=".$joining_unit) or die(mysql_error());
	else
	$unit=mysql_query("SELECT sub_unit_hindi unit_hindi FROM sub_unitmaster WHERE sub_unit_code=".$joining_unit) or die(mysql_error());
	if(mysql_num_rows($unit)>0){
		$u=mysql_fetch_array($unit);
		return $u['unit_hindi'];
	}return ' - ';
}
    function findunitDispsub($joining_unit,$subunit,$defType){
	if($joining_unit!="" && $subunit!=""){
		if($defType=="1"){			
			$unit=mysql_query("SELECT concat(unit_hindi,' & ',sub_unit_hindi ) as unit_hindi FROM sub_unitmaster WHERE pno_unit_code=".$joining_unit." limit 0,1");
		}else{			
			$unit=mysql_query("SELECT concat(unit_hindi,' & ',sub_unit_hindi ) as unit_hindi FROM sub_unitmaster WHERE pno_unit_code=".$joining_unit." and sub_unit_code='".$subunit."'") or die(mysql_error());
		}
	if(mysql_num_rows($unit)>0){
		$u=mysql_fetch_array($unit);
		return $u['unit_hindi'];
	}else{
		return '---';
	}
	}
	return '---'; 
	}
	function findCader($cid)
	{
	if($cid==null) return '---'; 

                   $results=mysql_query("SELECT cader_name FROM main_cadre WHERE cader_id='".$cid."'") or die(mysql_error());
                    if(mysql_num_rows($results)>0){
                        $x = mysql_fetch_array($results);
                        return $x['cader_name'];
                    }return '---';
	} 
	function getUnitHindi($deng)
	{	
		$rs=mysql_query("select unit_hindi from  sub_unitmaster where pno_unit_code='".trim($deng)."'");
		$row=mysql_fetch_assoc($rs);
		if($row['unit_hindi']!=null && $row['unit_hindi']!='')
		{
		 
		 return  str_replace("\\","",$row['unit_hindi']);
		 }
		
	}
		function getSubUnitHindi($deng)
	{	
		$rs=mysql_query("select sub_unit_hindi from sub_unitmaster where sub_unit_code='".trim($deng)."'");
		$row=mysql_fetch_assoc($rs);
		if($row['sub_unit_hindi']!=null && $row['sub_unit_hindi']!='')
		{
		 
		 return  str_replace("\\","",$row['sub_unit_hindi']);
		 }
		
	}
				?>
             
      <html>
    <head>
        <meta http-equiv="Content-Language" content="en" />
        <meta name="GENERATOR" content="PHPEclipse 1.0" />
        <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
        <title>UP Police: Nominal Roll System</title>
        <link rel="stylesheet" href="login.css" type="text/css">
        <script language="JavaScript" type="text/javascript" src="../js/Ajax.js"></script>
        <style type="text/css">
		<!--
			.style1 {font-weight:bold;
				font-size:12px;
				
				}
			.style4 {font-size:12px;
				font-weight:bold}
				
				@media print {
				img.print_btn {
				display: none;
				}
				}
				.style2 {font-weight:bold;
				font-size:16px;
				font-family:"Kruti Dev 010"
				
				}
		-->
        </style>
        	<script type="text/javascript" src="../js/jquery-1.3.2.min.js"></script>
        		<script language="javascript" type="text/javascript">
		  $(document).ready(function(){
		    $("#loadExcel").click(function(ev){
			
			  ev.preventDefault();
			 $(this).hide();
			 $("#dvBtn").show();
			$("#dvBtn").attr("style","display:inline;");
			 var  excelData=$("#toSendTable").html();
			 $("#tableHtml").val(excelData);
			});
		  });
		</script>
	</head>
<script>
var BrowserDetect = {
	init: function () {
		this.browser = this.searchString(this.dataBrowser) || "An unknown browser";
		this.version = this.searchVersion(navigator.userAgent)
			|| this.searchVersion(navigator.appVersion)
			|| "an unknown version";
		this.OS = this.searchString(this.dataOS) || "an unknown OS";
	},
	searchString: function (data) {
		for (var i=0;i<data.length;i++)	{
			var dataString = data[i].string;
			var dataProp = data[i].prop;
			this.versionSearchString = data[i].versionSearch || data[i].identity;
			if (dataString) {
				if (dataString.indexOf(data[i].subString) != -1)
					return data[i].identity;
			}
			else if (dataProp)
				return data[i].identity;
		}
	},
	searchVersion: function (dataString) {
		var index = dataString.indexOf(this.versionSearchString);
		if (index == -1) return;
		return parseFloat(dataString.substring(index+this.versionSearchString.length+1));
	},
	dataBrowser: [
		{
			string: navigator.userAgent,
			subString: "Chrome",
			identity: "Chrome"
		},
		{ 	string: navigator.userAgent,
			subString: "OmniWeb",
			versionSearch: "OmniWeb/",
			identity: "OmniWeb"
		},
		{
			string: navigator.vendor,
			subString: "Apple",
			identity: "Safari",
			versionSearch: "Version"
		},
		{
			prop: window.opera,
			identity: "Opera"
		},
		{
			string: navigator.vendor,
			subString: "iCab",
			identity: "iCab"
		},
		{
			string: navigator.vendor,
			subString: "KDE",
			identity: "Konqueror"
		},
		{
			string: navigator.userAgent,
			subString: "Firefox",
			identity: "Firefox"
		},
		{
			string: navigator.vendor,
			subString: "Camino",
			identity: "Camino"
		},
		{		// for newer Netscapes (6+)
			string: navigator.userAgent,
			subString: "Netscape",
			identity: "Netscape"
		},
		{
			string: navigator.userAgent,
			subString: "MSIE",
			identity: "Explorer",
			versionSearch: "MSIE"
		},
		{
			string: navigator.userAgent,
			subString: "Gecko",
			identity: "Mozilla",
			versionSearch: "rv"
		},
		{ 		// for older Netscapes (4-)
			string: navigator.userAgent,
			subString: "Mozilla",
			identity: "Netscape",
			versionSearch: "Mozilla"
		}
	],
	dataOS : [
		{
			string: navigator.platform,
			subString: "Win",
			identity: "Windows"
		},
		{
			string: navigator.platform,
			subString: "Mac",
			identity: "Mac"
		},
		{
			   string: navigator.userAgent,
			   subString: "iPhone",
			   identity: "iPhone/iPod"
	    },
		{
			string: navigator.platform,
			subString: "Linux",
			identity: "Linux"
		}
	]

};
BrowserDetect.init();
var myBrowser=BrowserDetect.browser;
</script>
<object classid="clsid:1663ed61-23eb-11d2-b92f-008048fdd814" id="factory" codebase="ScriptX.cab#Version=5,60,0,375" style="display:none" viewastext>
</object>
<script>
function PrintBasic() {
if(myBrowser=='Explorer'){
document.factory.printing.header = "";
document.factory.printing.footer = "Printed as on: &d. This is a website generated report.&b Page &p of &p";
document.factory.printing.Print(true);
}
else {
var currentTime = new Date()
var month = currentTime.getMonth() + 1
var day = currentTime.getDate()
var year = currentTime.getFullYear()
d= day+ "/" + month + "/" + year;
document.getElementById("repFooter").innerHTML='<br>Printed as on:'+d+' . This is a website generated report.';
//alert("kokoko");
window.print();
}
}
</script>
<body>
    
 <table cellpadding="0" cellspacing="0" border="0" width="500px" style="margin:0px auto">
<tr>
<td align="left" width="14%"><img width="70px;" height="70px;" src="../uttar-pradesh-police-logo.gif"/></td>
<td width="2%"></td>
<td align="left" valign="middle"><h2>
    &#2313;&#2340;&#2381;&#2340;&#2352; &#2346;&#2381;&#2352;&#2342;&#2375;&#2358; &#2346;&#2369;&#2354;&#2367;&#2360;  &#2344;&#2377;&#2350;&#2367;&#2344;&#2354;  &#2352;&#2379;&#2354; &#2346;&#2381;&#2352;&#2339;&#2366;&#2354;&#2368;</h2> </td>
</tr>
 
</table>
         
     
    <form action="download.php" method="post">
    <input type="hidden" id="tableHtml" name="tableHtml" />
	<table width="95%" align="center" style="border:0px solid #000000">
		<tr bgcolor="#999999">
			<td bgcolor="#CCCCCC" align="center" style="font-size:18px; font-weight:bold;"><span id="result_box" lang="hi">&#2352;&#2376;&#2306;&#2325; &#2325;&#2375; &#2309;&#2344;&#2369;&#2360;&#2366;&#2352; &#2349;&#2352;&#2375; &#2327;&#2351;&#2375; &#2327;&#2354;&#2340; &#2360;&#2306;&#2357;&#2352;&#2381;&#2327; &#2325;&#2368; &#2352;&#2367;&#2346;&#2379;&#2352;&#2381;&#2335;</span></td>
		</tr>
	</table>
	<table width="95%" align="center" style="border:0px solid #000000">
		
		<!--<tr>
			<td class="style4" colspan="3"><b>&#2311;&#2325;&#2366;&#2312;&nbsp;&nbsp;&nbsp;&nbsp;  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</b></font><strong>:</strong>	
            <font  class="style2" style="font-size:16px;">	</font>
            </td>
		</tr>-->
		
		<td width="69%"></td></tr>
		<tr>
			<td>
			<span  class="style4">
			&#2352;&#2376;&#2306;&#2325;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;</span>
               <font  class="style2" style="font-size:16px;">