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.")");
if($x = mysql_fetch_array($results)) return $x['rank_hin'];
}
if(isset($_REQUEST["B1"]))
{
/*print_r($_REQUEST);
exit(0);*/
$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"];
$rs = mysql_query('select * 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;
$from_date = $fdate;
if($tdate=='--')
$to_date='0000-00-00';
else
$to_date = $tdate;
$punishment_detail = $_REQUEST['detail'];
$reason_english = $_REQUEST['reason'];
$details_eng = $_REQUEST['S1'];
}
$temp = explode('/',$_REQUEST['suspension_date']);
$suspension_date = $temp[2].'-'. $temp[1].'-'. $temp[0];
/*$res=mysql_query("select max(serial_number) as cnt from suspended_detail");
$tot=0;
$row=mysql_fetch_array($res);
$tot=$row['cnt']+1;
*/
$now = time(); // or your date as well
$your_date = strtotime($to_date);
$datediff = $now - $your_date;
$no_days = floor($datediff/(60*60*24));
if($_POST['tdate']=="" || $no_days<0){
mysql_query("update new_posting_detail set transfer_posting_flag='SUS' where personal_number=".$personal_number);
}
mysql_query("insert into suspended_detail(personal_number, employee_name, rank, designation, reason_english, from_date,To_date, punishment_detail,serial_number,crime_detail,suspension_date) values('$personal_number', '$employee_name', '$rank', '$designation', '$reason_english', '$from_date','$to_date', '$punishment_detail',null,'".$_POST['crime_detail']."','$suspension_date')") or die(mysql_error());
//echo "insert into suspended_detail(personal_number, employee_name, rank, designation, reason_english, from_date,To_date, punishment_detail,serial_number) values('$personal_number', '$employee_name', '$rank', '$designation', '$reason_english', '$from_date','$to_date', '$punishment_detail',null)";
updatecrkrecotd($_SESSION['login_pno'], $personal_number, suspension_transdate);
header("Location: confirm_so_add.php?id=".$personal_number);
}
function findrank($id = null)
{
$results=mysql_query("select * from rank_master where rank_id=".$id);
if($x = mysql_fetch_array($results))
{
return $x['rank_eng'];
} else {
return 'N/A';
}
}
$results=mysql_query("select * from new_posting_detail where personal_number='".$_REQUEST['id']."' ");
$arow=mysql_fetch_array($results);
extract($arow);
?>
Uttar Pradesh Police Nominol Roll System
|
|
|
जनपद/इकाई का नाम
echo ' - '.strToUpper($_SESSION['Unit1']); ?> |
|
बैक |
होम |
लॉग आऊट |
|
|
|
|