session_start();
include '../conn.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"];
/*
employee_name, rank, designation, f//om_date, to_date, taken_leave_days, left_leave_days, personal_number, serial_number, leave_type, REMARK
serial_number, leave_code, leave_type, paid_unpaid, carry_forwd_next_yr_or_not, no_of_leave
*/
//keyid, 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
//personalno
//personal_number, employee_name, rank, designation, type_of_posting, unit, sub_unit, district, details_eng, detail_hindi, station_of_so, from_date, to_date, serial_number
//echo 'select * from new_posting_detail where personal_number = '.$_REQUEST['personalno'];
$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;
$to_date = $tdate;
$type_of_posting = $_REQUEST['tempas'];
$unit = $_REQUEST['Joining_Unit_Name'];
$sub_unit = $_REQUEST['Joining_Sub_Unit_Name'];
$district = $_REQUEST['tempas2'];
$details_eng = $_REQUEST['S1'];
$detail_hindi = $_REQUEST['S2'];
}
mysql_query("insert into so_detail(personal_number, employee_name, rank, type_of_posting, unit, sub_unit, district, details_eng, from_date, to_date, detail_hindi) values('$personal_number', '$employee_name', '$rank', '$type_of_posting', '$unit', '$sub_unit', '$district', '$details_eng', '$from_date', '$to_date', '$detail_hindi')");
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']); ?> |
|
बैक |
होम |
लॉग आऊट |
|
|
|
|