";
//print_r($_SESSION);
//echo $cur_date = date("Y-m-d");
$checked = "";
if(isset($_POST['submit']))
{
//$result = mysqli_query($con,"insert into categories(category_name, category_order, category_status) values ('$category_name', '$order', '$status')");
$officer_name = addslashes(trim($_POST['officer_name']));
$officer_job_id = Bn2En(addslashes(trim($_POST['officer_job_id'])));
$officer_job_fathername = addslashes(trim($_POST['officer_job_fathername']));
$officer_job_mothername = addslashes(trim($_POST['officer_job_mothername']));
$nid_no = Bn2En(addslashes(trim($_POST['nid_no'])));
$phone = addslashes(trim($_POST['phone']));
$email = addslashes(trim($_POST['email']));
$result = mysqli_query($con,"insert into tbl_acr_officer(user_full_name, officer_id, father_name,mother_name,national_id,officer_phone,officer_email) values ('$officer_name','$officer_job_id','$officer_job_fathername', '$officer_job_mothername', '$nid_no', '$phone', '$email')");
//echo "insert into tbl_acr_officer(user_full_name, officer_id, father_name,mother_name,national_id,officer_phone,officer_email) values ('$officer_name','$officer_job_id','$officer_job_fathername', '$officer_job_mothername', '$nid_no', '$phone', '$email')";
//exit;
/*$result = mysqli_query($con,"UPDATE asset_user
SET asset_user_name='$asset_user_name',
fathername='$asset_user_fathername',
asset_user_address='$asset_user_address'
Where asset_user_id='".$_POST['update_user_id']."'");
echo "UPDATE asset_user
SET asset_user_name='$asset_user_name',
fathername='$asset_user_fathername',
asset_user_address='$asset_user_address'
Where asset_user_id='".$_POST['update_user_id']."'";
exit;*/
print '';
exit;
}
if(!empty($_GET['acr_id']))
{
$result = mysqli_query($con,"SELECT * FROM acr_data where acr_data_id ='".base64_decode($_GET['acr_id'])."'");
//echo "SELECT * FROM acr_data where acr_data_id ='".base64_decode($_GET['acr_id'])."'";
$count = mysqli_num_rows($result);
while($row = mysqli_fetch_array($result))
{
$acr_year = $row["acr_year"];
$acr_start_time = $row["acr_start_time"];
$acr_date_start = date("d",strtotime($acr_start_time));
$acr_start_time = $row["acr_start_time"];
$acr_month_start = date("m",strtotime($acr_start_time));
$acr_end_time = $row["acr_end_time"];
$acr_date_end = date("d",strtotime($acr_end_time));
$acr_end_time = $row["acr_end_time"];
$acr_month_end = date("m",strtotime($acr_end_time));
$acr_marks = $row["acr_marks"];
$acr_receive_date = $row["acr_receive_date"];
$acr_receive_date = date("m/d/Y",strtotime($acr_receive_date));
$acr_add_datetime = $row["acr_add_datetime"];
$officer_id = $row["officer_id"];
$acr_docs = $row["acr_docs"];
if(empty($acr_docs))
{
$acr_docs=0;
}
$negetive_comments = $row["negetive_comments"];
$acr_data_id = $row["acr_data_id "];
$user_id = $row["user_id "];
}
}
$asset_user_name="";
$result = mysqli_query($con,"SELECT * FROM tbl_acr_officer where user_status='Active' and user_id ='".base64_decode($_GET['officer_add_id'])."'");
//echo "SELECT * FROM tbl_acr_officer where user_status='Active' and user_id ='".base64_decode($_GET['officer_add_id'])."'";
$count = mysqli_num_rows($result);
while($row = mysqli_fetch_array($result))
{
$asset_user_id = $row["user_id"];
$officer_name = $row["user_full_name"];
$officer_job_id = $row["officer_id"];
$officer_job_fathername = $row["father_name"];
$officer_job_mothername = $row["mother_name"];
$nid_no = $row["national_id"];
$phone = $row["officer_phone"];
$email = $row["officer_email"];
$status = $row["user_status"];
}
?>
কর্মকর্তার এসিআর (ACR) তথ্য যোগ
কর্মকর্তার নাম (পরিচিতি নং) |
পদবী |
ফোন নম্বর |
ইমেইল |
| |
|
|