<?php
namespace Controller;

use Responses\Message, Responses\Action, Responses\Data;
use Database\Sql, Database\Listable;
use Pages\Page, Pages\ListPage, Pages\FormPage;
use Routing\Route;
use Utility\WebSystem;


class documentHelper {
	
	public static function find($id, $fetchMode=\PDO::FETCH_OBJ) {
		$sql = Sql::select("document")->where(['id', '=', "?"]);
		$stm = $sql->prepare();
		$stm->execute([$id]);
		$obj = $stm->fetch($fetchMode);
		if ($obj === false) return null;

		return $obj;
	}
	
	public static function upload($fileObj, $type) {
		$url =  $_SERVER['REQUEST_SCHEME']."://".$_SERVER['HTTP_HOST']."/";   
		$userObj = unserialize($_SESSION['user']);
		$target_dir = "upload/".$type."/";
		$target_file_name = uniqid()."_".basename($fileObj['name']);
		$target_file_path = $target_dir.$target_file_name;
		$documentID = 0;

		if(move_uploaded_file($fileObj['tmp_name'], $target_file_path)){
		
			$addFields = [
				'fileName'=>"?", 
				'filePath'=>"?", 
				'downloadPath'=>"?",
				'fileType'=>"?", 
				'fileSize'=>"?", 
				'docType'=>"?", 
				'createBy'=>"?",
				'modifyBy'=>"?"
			];			
			
			$addValues = [
				strip_tags($fileObj['name']), 
				strip_tags($target_file_name), 
				strip_tags($url.$target_file_path), 
				strip_tags($fileObj['type']),
				strip_tags($fileObj['size']),
				strip_tags($type), 
				strip_tags($userObj->id),
				strip_tags($userObj->id)
			];
								
			$sql = Sql::insert('document')->setFieldValue($addFields);
			if ($sql->prepare()->execute($addValues)) {
				$documentID = db()->lastInsertId();
			}						
		}

		return $documentID;
			
	}	

	public static function delete($docID) {	

		if (!user::checklogin()) 
			return false;
		
		if (!isset($docID) || empty($docID))
			return false;

		$docObj = self::find($docID);

		if (is_null($docObj))
			return false;	
			
		$sql = Sql::delete('document')->where(['id', '=', $docID]);
		if ($sql->prepare()->execute()) {
			
			$file_real_path = $_SERVER['DOCUMENT_ROOT']."/upload/".$docObj->docType."/".$docObj->filePath;
			unlink($file_real_path);

			return true;
		} else {
			return false;
		}					
	}
	
}