mint/app/studio/file_index.php

<?php
require_once 'checklogin.inc';
require_once "../path.php";
require_once "../public/_pdo.php";
require_once "../public/function.php";

if(isset($_POST["op"])){
	$op=$_POST["op"];
}
if(isset($_POST["id"])){
	$id=$_POST["id"];
}
if(isset($_POST["filename"])){
	$filename=$_POST["filename"];
}
if(isset($_POST["doc_id"])){
	$doc_id=$_POST["doc_id"];
}
if(isset($_POST["field"])){
	$field=$_POST["field"];
}
if(isset($_POST["value"])){
	$value=$_POST["value"];
}
if($_COOKIE["uid"]){
	$uid=$_COOKIE["uid"];
}
else{
	echo "尚未登录";
	exit;
}

PDO_Connect("sqlite:"._FILE_DB_FILEINDEX_);

switch($op){
	case "list":
	break;
	case "get";
		$query="select * from fileindex where user_id='$uid' AND  id='{$doc_id}'";
		$Fetch = PDO_FetchAll($query);
		echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
	break;
	case "getall";
		//
		$time=time();
		$query="select * from fileindex where user_id='$uid' AND  id='{$_POST["doc_id"]}'";
		$Fetch = PDO_FetchAll($query);
		$iFetch=count($Fetch);
		if($iFetch>0){
			echo json_encode($Fetch[0], JSON_UNESCAPED_UNICODE);
		}
	break;
	case "set";
		//修改文件索引数据库
		if($field=="accese_time"){
			$value=mTime();
		}
		$doc_id=$_POST["doc_id"];
		$query="UPDATE fileindex SET $field='$value' where user_id='$uid' AND   id='{$doc_id}'";
		$stmt = @PDO_Execute($query);
		if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
			$error = PDO_ErrorInfo();
			echo json_encode(array("error"=>$error[2],"message"=>$query), JSON_UNESCAPED_UNICODE);
		}
		else{
			echo json_encode(array("error"=>"","message"=>$query), JSON_UNESCAPED_UNICODE);
		}
	break;
	case "share":
		//修改文件索引数据库
		if(isset($_POST["file"])){
			if(isset($_POST["share"])){
				$share=$_POST["share"];
			}
			else{
				$share=0;
			}
			$fileList=$_POST["file"];
			$aFileList=str_getcsv($fileList);
			if(count($aFileList)>0){
				$strFileList="(";
				foreach($aFileList as $file) {
				  $strFileList.="'{$file}',";
				}
				$strFileList=mb_substr($strFileList, 0,mb_strlen($strFileList,"UTF-8")-1,"UTF-8");
				$strFileList.=")";
				$query="UPDATE fileindex SET share='$share' where user_id='$uid' AND   id in $strFileList";
				$stmt = @PDO_Execute($query);
				if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
					$error = PDO_ErrorInfo();
					echo "error:{$error[2]}";
				}
				else{
					echo "ok".$query;
				}			
			}		
		}	
		break;	
	
	case "delete"://移到回收站
	{
		if(isset($_POST["file"])){
			$fileList=$_POST["file"];
			$aFileList=str_getcsv($fileList);
			if(count($aFileList)>0){
				$strFileList="(";
				foreach($aFileList as $file) {
				  $strFileList.="'{$file}',";
				}
				$strFileList=mb_substr($strFileList, 0,mb_strlen($strFileList,"UTF-8")-1,"UTF-8");
				$strFileList.=")";
				
				$query="UPDATE fileindex SET status='0',share='0' where user_id='$uid' AND  id in $strFileList";
				$stmt = @PDO_Execute($query);
				if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
					$error = PDO_ErrorInfo();
					echo "error:{$error[2]}";
				}
				else{
					echo "ok";
				}			
			}		
		}	
		break;	
	}
	case "restore"://从回收站中恢复
		if(isset($_POST["file"])){
			$fileList=$_POST["file"];
			$aFileList=str_getcsv($fileList);
			if(count($aFileList)>0){
				$strFileList="(";
				foreach($aFileList as $file) {
				  $strFileList.="'{$file}',";
				}
				$strFileList=mb_substr($strFileList, 0,mb_strlen($strFileList,"UTF-8")-1,"UTF-8");
				$strFileList.=")";
				
				$query="UPDATE fileindex SET status='1' where user_id='$uid' AND  id in $strFileList";
				$stmt = @PDO_Execute($query);
				if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
					$error = PDO_ErrorInfo();
					echo "error:{$error[2]}";
				}
				else{
					echo "ok";
				}			
			}		
		}	
		break;		
	case "remove":
		//彻底删除文件
		if(isset($_POST["file"])){
			$fileList=$_POST["file"];
			$aFileList=str_getcsv($fileList);
			if(count($aFileList)>0){
				$strFileList="(";
				//删除文件
				foreach($aFileList as $file) {
					if(!unlink($dir.$file)){
						 echo("Error deleting $file");
					}
				  $strFileList.="'{$file}',";
				}
				$strFileList=mb_substr($strFileList, 0,mb_strlen($strFileList,"UTF-8")-1,"UTF-8");
				$strFileList.=")";
				//删除记录
				$query="DELETE FROM fileindex WHERE user_id='$uid' AND   id in $strFileList";
				$stmt = @PDO_Execute($query);
				if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
					$error = PDO_ErrorInfo();
					echo "error:{$error[2]}";
				}
				else{
					echo "删除".count($aFileList)."个文件。";
				}			
			}		
		}	
		break;
	case "remove_all":
		//	清空回收站
	break;
}

?>