 <?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);

?>