endok_job.php

<?php
    //與資料庫連線
 	include("mysql.php");
 	mysqli_query($my_db,"SET NAMES 'utf8'");
    
    //獲取變數
    $cmpltdate=$_REQUEST["cmpltdate"];
    $re_file=$_FILES["re_file"]["name"];
    $ps=$_REQUEST["ps"];
    $sql_id=$_REQUEST["sql_id"];
    $closed=1;
	
	//判斷是否有檔案上傳
	if (empty($re_file)){			
		
		//如沒有檔案直接將資料存入	
		$sql="UPDATE document SET cmpltDate = '$cmpltdate', closed = '$closed' , 
		ps ='$ps' WHERE id = '$sql_id'";
	    mysqli_query($my_db, $sql);
	    echo "<script>alert('結案成功');</script>";
	    header("REFRESH:0;url=user.php");
			
	}else{

		//如有檔案先判斷檔案是否錯誤
		if ($_FILES["re_file"]["error"] === UPLOAD_ERR_OK){ 
  		//檢查檔案是否已經存在
  		if (file_exists("refile_upload/" . $re_file)){
   			echo "<script>alert('檔案已存在');</script>";
   			header("REFRESH:0;url=user.php");
  		} else {
			$file = $_FILES["re_file"]["tmp_name"];
			$re_file="reimg".$sql_id;
			$dest = "refile_upload/" . $re_file;

  		//將檔案移至指定位置
  	  	move_uploaded_file($file, $dest);
  	  	//存入資料庫
	    $sql="UPDATE document SET cmpltDate = '$cmpltdate', closed = '$closed' , 
		    file2 = '$dest' , ps ='$ps' WHERE id = '$sql_id'";
	    mysqli_query($my_db, $sql);
	    echo "<script>alert('結案成功');</script>";
	    header("REFRESH:0;url=user.php");
 	  }
	} else {
 		echo "錯誤代碼：" . $_FILES["re_file"]["error"] . "<br/>";
	  }


	}

?>