এসিআর সাল বাছাই করুন
";
} else {
//$officer_name = addslashes(trim($_POST['officer_name']));
}
if (empty($acr_date_start) && $acr_date_start=="0") {
$errorMSG .= "এসিআর সময়কাল শুরুর তারিখ বাছাই করুন";
} else {
//$officer_name = addslashes(trim($_POST['officer_name']));
}
if (empty($acr_month_start) && $acr_month_start=="0") {
$errorMSG .= "এসিআর সময়কাল শুরুর মাস বাছাই করুন";
} else {
//$officer_name = addslashes(trim($_POST['officer_name']));
}
if (empty($acr_date_end) && $acr_date_end=="0") {
$errorMSG .= "এসিআর সময়কাল শেষের তারিখ বাছাই করুন";
} else {
//$officer_name = addslashes(trim($_POST['officer_name']));
}
if (empty($acr_month_end) && $acr_month_end=="0") {
$errorMSG .= "এসিআর সময়কাল শেষের মাস বাছাই করুন";
} else {
//$officer_name = addslashes(trim($_POST['officer_name']));
}
if($acr_type==1)
{
if (empty($datepicker)) {
$errorMSG .= "এসিআর গ্রহনের তারিখ বাছাই করুন";
} else {
//$officer_name = addslashes(trim($_POST['officer_name']));
}
if (empty($acr_no)) {
$errorMSG .= "এসিআর এ প্রাপ্ত নম্বর লিখুন";
} else {
//$officer_name = addslashes(trim($_POST['officer_name']));
}
if ($file_upload==0) {
$errorMSG .= "এসিআর স্ক্যান কপি আপলোড করুন";
} else {
//$officer_name = addslashes(trim($_POST['officer_name']));
}
}
/* MESSAGE */
/*
if (empty($_POST["message"])) {
$errorMSG .= "Message is required";
} else {
$message = $_POST["message"];
}
*/
if(!empty($acr_date_starttime))
{
$result3 = mysqli_query($con,"SELECT * FROM acr_data where officer_id='$officer_add_id' and acr_start_time Between '$acr_date_starttime' and '$acr_date_endtime'");
//echo "SELECT acr_data_id FROM acr_data where officer_id='$officer_add_id' and acr_start_time Between $acr_date_starttime and $acr_date_endtime";
$count3 = mysqli_num_rows($result3);
while($row = mysqli_fetch_array($result3))
{
$Old_acr_start_time = $row["acr_start_time"];
$old_acr_end_time = $row["acr_end_time"];
$old_acr_year = $row["acr_year"];
$old_acr_receive_date = $row["acr_receive_date"];
$old_acr_marks = $row["acr_marks"];
$old_had_acr = $row["had_acr"];
$old_negetive_comments = $row["negetive_comments"];
}
$log_details = $old_acr_year." || ".$Old_acr_start_time." || ".$old_acr_end_time." || ".$old_acr_receive_date." || ".$old_acr_marks." || ".$old_had_acr." || ".$old_negetive_comments;
//echo $acr_id." ".$acr_date_starttime." ".$Old_acr_start_time." ".$acr_date_endtime." ".$old_acr_end_time;
if(!empty($acr_id) && $acr_date_starttime==$Old_acr_start_time && $acr_date_endtime==$old_acr_end_time)
{
$count3=0;
}
if($count3>0)
{
$errorMSG .= "উক্ত মেয়াদের এসিআর এর তথ্য ইতোমধ্যে যুক্ত করা হয়েছে।";
}else{
$result4 = mysqli_query($con,"SELECT acr_data_id FROM acr_data where officer_id='$officer_add_id' and acr_end_time Between '$acr_date_starttime' and '$acr_date_endtime'");
$count4 = mysqli_num_rows($result4);
if(!empty($acr_id) && $acr_date_starttime==$Old_acr_start_time && $acr_date_endtime==$old_acr_end_time)
{
$count4=0;
}
if($count4>0)
{
$errorMSG .= "উক্ত মেয়াদের এসিআর এর তথ্য ইতোমধ্যে যুক্ত করা হয়েছে।";
}
}
}
if(!empty($acr_id))
{
$result5 = mysqli_query($con,"SELECT last_edit_time FROM acr_data where acr_data_id=$acr_id");
while($row = mysqli_fetch_array($result5))
{
$last_edit_time = $row["last_edit_time"];
}
$system_date = date('Y-m-d', strtotime($cur_date . ' -30 day'));
$system_date=$system_date." 00:00:00";
if($last_edit_time<$system_date && !empty($acr_id))
{
$errorMSG .= "এসিআর তথ্য পরিবর্তনের ৩০ দিন মেয়াদ শেষ হয়েছে।";
}
}
if(empty($errorMSG)){
$uploaded=0;
$ext="";
//generate unique file name using time:
$newfilename= md5(rand() * time());
//print $_FILES['uploaded_file']['name'][$i]."
";
$filename = @strtolower(basename($_FILES['uploaded_file']));
if (!empty($filename)) {
$errorMSG .= "এসিআর স্ক্যান কপি আপলোড করুন";
}
if($_FILES["uploaded_file"]['type'] != "pdf" && $_FILES["uploaded_file"]['type'] != "")
{
$errorMSG .= "আপলোডকৃত এসিআর ফরম্যাট সঠিক নয়।";
}
if($_FILES["uploaded_file"]['size']>5000000)
{
$errorMSG .= "আপলোডকৃত এসিআর সাইজ ৫ মেগাবাইটের বেশী হতে পারবে না।";
}
$ext = substr($filename, strrpos($filename, '.') + 1);
//Determine the path to which we want to save this file
$ext=".".$ext;
//$type = $_POST['type'];
//@chmod(dirname(__FILE__).'/uploads', 0777);
$newname = dirname(__FILE__).'/tender_docs/acr_'.$newfilename.$ext;
$main_newname = 'acr_'.$newfilename.$ext;
//exit;
if ((@move_uploaded_file($_FILES['uploaded_file']['tmp_name'],$newname)))
{
//echo "File uploaded successfully!";
//$uploaded=1;
}
else
{
//echo "Error:!";
//print('Back
');
}
//$update_date[$i]= @date("Y-m-d",strtotime($update_date[$i]));
//$img_name = dirname(__FILE__).'/gallery/'."moc_".$newfilename.$ext;
//exit;
if($ext!=".")
{
$path = "acr_".$newfilename.$ext;
}
if(!empty($acr_id))
{
audit_log($con,$_SESSION['d_id'],$officer_add_id,$acr_id,'Before ACR Edit',$log_details);
$result = mysqli_query($con,"UPDATE acr_data
SET acr_year='$acr_year',
acr_start_time='$acr_date_starttime',
acr_end_time='$acr_date_endtime',
acr_receive_date='$new_date',
acr_marks='$acr_no',
acr_add_datetime='$add_datetime',
had_acr='$acr_type',
negetive_comments='$acr_comments'
Where acr_data_id='$acr_id'");
$log_details = $acr_year." || ".$acr_date_starttime." || ".$acr_date_endtime." || ".$new_date." || ".$acr_no." || ".$add_datetime." || ".$acr_type." || ".$acr_comments;
audit_log($con,$_SESSION['d_id'],$officer_add_id,$acr_id,'After ACR Edit',$log_details);
}
else{
$result = mysqli_query($con,"insert into acr_data(user_id, acr_year, acr_start_time,acr_end_time,acr_receive_date,acr_marks,acr_add_datetime,officer_id,negetive_comments,had_acr,last_edit_time,acr_docs)
values ('".$_SESSION['d_id']."','$acr_year','$acr_date_starttime','$acr_date_endtime', '$new_date', '$acr_no', '$add_datetime','$officer_add_id', '$acr_comments','$acr_type','$add_datetime','$file_upload')");
$last_id = mysqli_insert_id($con);
$log_details = $acr_year." || ".$acr_date_starttime." || ".$acr_date_endtime." || ".$new_date." || ".$acr_no." || ".$add_datetime." || ".$acr_type." || ".$acr_comments;
audit_log($con,$_SESSION['d_id'],$officer_add_id,$last_id,'New ACR Add',$log_details);
}
$msg = "1";
echo json_encode(['code'=>200, 'msg'=>$msg]);
exit;
}
echo json_encode(['code'=>404, 'msg'=>$errorMSG]);
?>