db->table(self::TABLE)->eq('id', $file_id)->findOne(); } /** * Remove a file * * @access public * @param integer $file_id File id * @return bool */ public function remove($file_id) { $file = $this->getbyId($file_id); if (! empty($file) && @unlink(FILES_DIR.$file['path'])) { return $this->db->table(self::TABLE)->eq('id', $file_id)->remove(); } return false; } /** * Remove all files for a given task * * @access public * @param integer $task_id Task id * @return bool */ public function removeAll($task_id) { $files = $this->getAll($task_id); foreach ($files as $file) { $this->remove($file['id']); } } /** * Create a file entry in the database * * @access public * @param integer $task_id Task id * @param string $name Filename * @param string $path Path on the disk * @param bool $is_image Image or not * @return bool */ public function create($task_id, $name, $path, $is_image) { $this->container['dispatcher']->dispatch( self::EVENT_CREATE, new FileEvent(array('task_id' => $task_id, 'name' => $name)) ); return $this->db->table(self::TABLE)->save(array( 'task_id' => $task_id, 'name' => $name, 'path' => $path, 'is_image' => $is_image ? '1' : '0', )); } /** * Get all files for a given task * * @access public * @param integer $task_id Task id * @return array */ public function getAll($task_id) { return $this->db->table(self::TABLE) ->eq('task_id', $task_id) ->asc('name') ->findAll(); } /** * Check if a filename is an image * * @access public * @param string $filename Filename * @return bool */ public function isImage($filename) { return getimagesize($filename) !== false; } /** * Generate the path for a new filename * * @access public * @param integer $project_id Project id * @param integer $task_id Task id * @param string $filename Filename * @return string */ public function generatePath($project_id, $task_id, $filename) { return $project_id.DIRECTORY_SEPARATOR.$task_id.DIRECTORY_SEPARATOR.hash('sha1', $filename.time()); } /** * Check if the base directory is created correctly * * @access public */ public function setup() { if (! is_dir(FILES_DIR)) { if (! mkdir(FILES_DIR, 0755, true)) { die('Unable to create the upload directory: "'.FILES_DIR.'"'); } } if (! is_writable(FILES_DIR)) { die('The directory "'.FILES_DIR.'" must be writeable by your webserver user'); } } /** * Handle file upload * * @access public * @param integer $project_id Project id * @param integer $task_id Task id * @param string $form_name File form name * @return bool */ public function upload($project_id, $task_id, $form_name) { $this->setup(); $result = array(); if (! empty($_FILES[$form_name])) { foreach ($_FILES[$form_name]['error'] as $key => $error) { if ($error == UPLOAD_ERR_OK && $_FILES[$form_name]['size'][$key] > 0) { $original_filename = basename($_FILES[$form_name]['name'][$key]); $uploaded_filename = $_FILES[$form_name]['tmp_name'][$key]; $destination_filename = $this->generatePath($project_id, $task_id, $original_filename); @mkdir(FILES_DIR.dirname($destination_filename), 0755, true); if (@move_uploaded_file($uploaded_filename, FILES_DIR.$destination_filename)) { $result[] = $this->create( $task_id, $original_filename, $destination_filename, $this->isImage(FILES_DIR.$destination_filename) ); } } } } return count(array_unique($result)) === 1; } }