এসিআর সাল বাছাই করুন"; } 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]); ?>