162 lines
4.0 KiB
PHP
162 lines
4.0 KiB
PHP
<?php
|
|
include ('includes/config/config.php');
|
|
error_reporting(E_ERROR || E_PARSE);
|
|
|
|
|
|
$imgData = null;
|
|
|
|
$imgData_stamp = null;
|
|
|
|
$photoQuery = "";
|
|
|
|
// error_log ( "Start Printing Request Attributes" );
|
|
// foreach ( $_POST as $key => $value ) {
|
|
// error_log ( $key . " : " . $value . "<br />\r\n" );
|
|
// }
|
|
|
|
print_r($_POST);
|
|
|
|
if (count($_FILES) > 0) {
|
|
$file_name = $_FILES['emp_sign']['name'];
|
|
$file_size = $_FILES['emp_sign']['size'];
|
|
$file_tmp = $_FILES['emp_sign']['tmp_name'];
|
|
$file_type = $_FILES['emp_sign']['type'];
|
|
|
|
$file_name_stamp = $_FILES['emp_stamp']['name'];
|
|
$file_size_stamp = $_FILES['emp_stamp']['size'];
|
|
$file_tmp_stamp = $_FILES['emp_stamp']['tmp_name'];
|
|
$file_type_stamp = $_FILES['emp_stamp']['type'];
|
|
|
|
|
|
|
|
$file_ext=strtolower(end(explode('.',$_FILES['emp_sign']['name'])));
|
|
$file_ext_stamp=strtolower(end(explode('.',$_FILES['emp_stamp']['name'])));
|
|
$select_query_sign="select * from employee_signature where emp_id = '" . $_SESSION['logged_user_empid'] . "'";
|
|
$result_emp_sign = mysqli_query($conn,$select_query_sign);
|
|
if(mysqli_num_rows($result_emp_sign) > 0){
|
|
$query_initial_emp_sign = "update ";
|
|
$query_emp_sign_post =" where emp_id = '" . $_SESSION['logged_user_empid'] . "'";
|
|
}else{
|
|
$query_initial_emp_sign = "insert into ";
|
|
$query_emp_sign_post=", emp_id = '" . $_SESSION['logged_user_empid'] . "'";
|
|
}
|
|
|
|
|
|
$query_emp_sign = " employee_signature set file_name='".$file_name."' ,file_type='".$file_type."' ,stamp_img_name='".$file_name_stamp."',stamp_file_type='".$file_type_stamp."',modified_by = '" . $_SESSION['user_id'] . "'";
|
|
|
|
$query_sign=$query_initial_emp_sign.$query_emp_sign.$query_emp_sign_post;
|
|
//echo $query_sign;
|
|
$result = @mysqli_query($conn,$query_sign);
|
|
|
|
|
|
$_FILES['emp_sign']['tmp_name'];
|
|
$_FILES['emp_stamp']['tmp_name'];
|
|
|
|
if (is_uploaded_file($_FILES['emp_sign']['tmp_name']) ) {
|
|
|
|
|
|
|
|
$info = pathinfo($_FILES['emp_sign']['name']);
|
|
|
|
|
|
|
|
$ext = pathinfo($info, PATHINFO_EXTENSION);
|
|
|
|
$imgData = addslashes(file_get_contents($_FILES['emp_sign']['tmp_name']));
|
|
$imageProperties = getimageSize($_FILES['emp_sign']['tmp_name']);
|
|
|
|
$photoQuery = ",emp_sign='{$imgData}' ,image_type='{$imageProperties['mime']}'";
|
|
|
|
}
|
|
if ( is_uploaded_file($_FILES['emp_stamp']['tmp_name'])) {
|
|
|
|
|
|
|
|
$info_stamp = pathinfo($_FILES['emp_stamp']['name']);
|
|
|
|
|
|
|
|
|
|
$ext_stamp = pathinfo($info_stamp, PATHINFO_EXTENSION);
|
|
|
|
|
|
$imgData_stamp = addslashes(file_get_contents($_FILES['emp_stamp']['tmp_name']));
|
|
|
|
|
|
$imageProperties_stamp = getimageSize($_FILES['emp_stamp']['tmp_name']);
|
|
|
|
$photoQuery .= ",emp_stamp = '{$imgData_stamp}',stamp_img_type='{$imageProperties_stamp['mime']}'";
|
|
|
|
}
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
$data = array();
|
|
|
|
$query = "";
|
|
|
|
$select_query = "select * from employee_signature where emp_id = '" . $_SESSION['logged_user_empid'] . "'";
|
|
|
|
error_log("SIGNATURE QUERY:::" .$select_query);
|
|
|
|
$result = mysqli_query($conn,$select_query);
|
|
|
|
$query_initial="";
|
|
|
|
$query_post="";
|
|
|
|
$query="";
|
|
|
|
|
|
|
|
if(mysqli_num_rows($result) > 0) {
|
|
|
|
|
|
|
|
$query_initial = "update ";
|
|
|
|
$query_post =" where emp_id = '" . $_SESSION['logged_user_empid'] . "'";
|
|
|
|
}
|
|
|
|
else {
|
|
|
|
$query_initial = "insert into";
|
|
|
|
$query_post=", emp_id = '" . $_SESSION['logged_user_empid'] . "'";
|
|
|
|
|
|
|
|
}
|
|
|
|
$query = " employee_signature set qualification='".$_REQUEST['qualification']."' ,
|
|
registration_no='".$_REQUEST['registration_no']."' , modified_by = '" . $_SESSION['user_id'] . "'". $photoQuery;
|
|
|
|
$query=$query_initial.$query.$query_post;
|
|
|
|
error_log("PHOTO:".$query);
|
|
if (! $result = @mysqli_query($conn,$query)) {
|
|
|
|
$data['status'] = 500;
|
|
|
|
exit(mysqli_error($conn));
|
|
|
|
}
|
|
|
|
|
|
|
|
if ($data == null) {
|
|
|
|
$data['status'] = 200;
|
|
|
|
$data['message'] = "Data not found!";
|
|
|
|
}
|
|
move_uploaded_file($file_tmp,"images/".$file_name);
|
|
move_uploaded_file($file_tmp_stamp,"images/".$file_name_stamp);
|
|
echo json_encode($data);
|
|
|
|
?>
|