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"];
$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;
$training_code = $_REQUEST['tcode'];
$center_code= $_REQUEST['ccode'];
$training_duration_from_date = $fdate;
$training_duration_to_date= $tdate;
$REMARK = $_REQUEST['remark'];
$courseDuration = $_REQUEST['courseDuration'];
}
$isApplicableInPromotion=0;
if(isset($_POST['isApplicableInPromotion'])){
$isApplicableInPromotion=1;
}
mysql_query("insert into training_detail(personal_number,employee_name, rank, training_code, center_code, training_duration_from_date,training_duration_to_date, REMARK, isApplicableInPromotion,courseDuration) values('$personal_number', '$employee_name', '$rank', '$training_code', '$center_code', '$training_duration_from_date', '$training_duration_to_date', '$REMARK',$isApplicableInPromotion,'".$_REQUEST['courseDuration']."')") ;
header("Location: confirm_training.php?id=".$personal_number);
}
function makeDate1($dt)
{
$dt = trim(str_replace('00:00:00', '', $dt));
//echo $dt.' lenth is: '.strlen($dt).'
';
if(strlen($dt) > 10)
{
$dt = trim(substr($dt,0,10));
}
$dt = explode('-', $dt);
$month = '';
switch($dt[1])
{
case 1:
$month = 'Jan';
break;
case 2:
$month = 'Feb';
break;
case 3:
$month = 'Mar';
break;
case 4:
$month = 'Apr';
break;
case 5:
$month = 'May';
break;
case 6:
$month = 'Jun';
break;
case 7:
$month = 'Jul';
break;
case 8:
$month = 'Aug';
break;
case 9:
$month = 'Sep';
break;
case 10:
$month = 'Oct';
break;
case 11:
$month = 'Nov';
break;
case 12:
$month = 'Dec';
break;
}
return $dt[2]. ' '.$month. ' '.$dt[0];
}
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']); ?> |
|
बैक |
होम |
लॉग आऊट |
|
|
|
|