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);*/
if($_REQUEST['dop']!=""){
$temp = explode('/',$_REQUEST['dop']);
$dop = $temp[2].'-'. $temp[1].'-'. $temp[0];
}else{
$dop="0000-00-00";
}
$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);
$personal_number = $personal_number;
$name_of_employee = $first_name_of_employee_english.' '.$middle_name_of_employee_english.' '.$last_name_of_employee_english;
$present_rank = $present_rank;
$unit = $joining_unit;
$category_of_property = $_REQUEST['p_cat'];
$property_type = $_REQUEST['p_type'];
$land_property = $_REQUEST['land_property'];
$no_of_property = $_REQUEST['nop'];
$property_location = $_REQUEST['p_location'];
$district = $_REQUEST['district'];
$area_in_acrs = $_REQUEST['p_area'];
$date_of_possession = $dop;
$yearly_income = $_REQUEST['y_incom'];
$approximate_cost = $_REQUEST['a_cost'];
$remarks = $_REQUEST['remarks'];
/*$cnt=mysql_query("select count(*) cnt from property_detail_new ");
$cnts=0;
while($row=mysql_fetch_array($cnt)){
$cnts=$row['cnt'];
}
$cnts=$cnts+1;*/
mysql_query("insert into property_detail_new(personal_number,serial_number, name_of_employee, present_rank, unit, category_of_property, property_type, land_property, no_of_property, property_location, district, area_in_acrs, date_of_possession, yearly_income, approximate_cost, remarks) values('$personal_number',null, '$name_of_employee', '$present_rank', '$unit', '$category_of_property', '$property_type', '$land_property', '$no_of_property', '$property_location', '$district', '$area_in_acrs', '$date_of_possession', '$yearly_income', '$approximate_cost', '$remarks')") ;
header("Location: confirm_add.php?id=".$personal_number);
}}
function findrank($id = null)
{
$results=mysql_query("select serial_number,rank_id,rank_eng,rank_hin 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 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']."' ");
$arow=mysql_fetch_array($results);
extract($arow);
?>
Uttar Pradesh Police Nominol Roll System
|
|
|
जनपद/इकाई का नाम
echo ' - '.strToUpper($_SESSION['Unit1']); ?> |
|
बैक |
होम |
लॉग आऊट |
|
|
|
|