Plugins directory and local modifications

1 files changed, 320 insertions, 0 deletions

diff --git a/plugins/Customizer/Model/CustomizerFileModel.php b/plugins/Customizer/Model/CustomizerFileModel.php
new file mode 100644
index 00000000..64dbc2c8
--- /dev/null
+++ b/plugins/Customizer/Model/CustomizerFileModel.php
@@ -0,0 +1,320 @@
+<?php
+
+namespace Kanboard\Plugin\Customizer\Model;
+
+use Exception;
+use Kanboard\Core\Base;
+use Kanboard\Core\Thumbnail;
+use Kanboard\Core\ObjectStorage\ObjectStorageException;
+
+/**
+ * Customizer File Model
+ *
+ * @package  Customizer\Model
+ * @author   creecros
+ */
+class CustomizerFileModel extends Base
+{
+    /**
+     * Table name
+     *
+     * @var string
+     */
+    const TABLE = 'customizer_files';
+
+    /**
+     * Get the table
+     *
+     * @abstract
+     * @access protected
+     * @return string
+     */
+    public function getTable()
+    {
+        return self::TABLE;
+    }
+    
+    /**
+     * Define the path prefix
+     *
+     * @abstract
+     * @access protected
+     * @return string
+     */
+    public function getPathPrefix()
+    {
+        return 'customizer';
+    }
+
+     /**
+     * Get a file by the Id
+     *
+     * @access public
+     * @param  integer   $file_id    File id
+     * @return array
+     */
+    public function getById($file_id)
+    {
+        return $this->db->table($this->getTable())->eq('id', $file_id)->findOne();
+    }
+    
+     /**
+     * Get a file by the type
+     *
+     * @access public
+     * @param  integer   $custom_id    1=logo 2=flavicon 3=loginlogo
+     * @return array
+     */
+    public function getByType($custom_id)
+    {
+        return $this->db->table($this->getTable())->eq('custom_id', $custom_id)->findOne();
+    }
+    
+     /**
+     * Get a file id by the type
+     *
+     * @access public
+     * @param  integer   $custom_id    1=logo 2=flavicon 3=loginlogo
+     * @return array
+     */
+    public function getIdByType($custom_id)
+    {
+        $file = $this->db->table($this->getTable())->eq('custom_id', $custom_id)->findOne();
+        return $file['id'];
+    }
+    
+         /**
+     * Get all files by the type
+     *
+     * @access public
+     * @param  integer   $custom_id    1=logo 2=flavicon 3=loginlogo
+     * @return array
+     */
+    public function getAllByType($custom_id)
+    {
+        return $this->db->table($this->getTable())->eq('custom_id', $custom_id)->findAll();
+    }
+    
+    /**
+     * Create a file entry in the database
+     *
+     * @access public
+     * @param  integer $custom_id      1=logo 2=flavicon
+     * @param  string  $name           Filename
+     * @param  string  $path           Path on the disk
+     * @param  integer $size           File size
+     * @return bool|integer
+     */
+    public function create($custom_id, $name, $path, $size)
+    {
+        $values = array(
+            'custom_id' => $custom_id,
+            'name' => substr($name, 0, 255),
+            'path' => $path,
+            'is_image' => $this->isImage($name) ? 1 : 0,
+            'size' => $size,
+            'user_id' => $this->userSession->getId() ?: 0,
+            'date' => time(),
+        );
+        if (null !== $this->getByType($custom_id)) { 
+            foreach ($this->getAllByType($custom_id) as $image) { $this->remove($image['id']); }
+            $result = $this->db->table($this->getTable())->insert($values); 
+        } else { 
+            $result = $this->db->table($this->getTable())->insert($values);
+        }
+        if ($result) {
+            $file_id = (int) $this->db->getLastId();
+            return $file_id;
+        }
+        return false;
+    }
+    
+    /**
+     * Remove a file
+     *
+     * @access public
+     * @param  integer   $file_id    File id
+     * @return bool
+     */
+    public function remove($file_id)
+    {
+        try {
+            $file = $this->getById($file_id);
+            $this->objectStorage->remove($file['path']);
+            if ($file['is_image'] == 1) {
+                $this->objectStorage->remove($this->getThumbnailPath($file['path']));
+            }
+            return $this->db->table($this->getTable())->eq('id', $file['id'])->remove();
+        } catch (ObjectStorageException $e) {
+            $this->logger->error($e->getMessage());
+            return false;
+        }
+    }
+    
+    /**
+     * Check if a filename is an image (file types that can be shown as thumbnail)
+     *
+     * @access public
+     * @param  string   $filename   Filename
+     * @return bool
+     */
+    public function isImage($filename)
+    {
+        switch (get_file_extension($filename)) {
+            case 'jpeg':
+            case 'jpg':
+            case 'png':
+            case 'gif':
+                return true;
+        }
+        return false;
+    }
+    /**
+     * Generate the path for a thumbnails
+     *
+     * @access public
+     * @param  string  $key  Storage key
+     * @return string
+     */
+    public function getThumbnailPath($key)
+    {
+        return 'thumbnails'.DIRECTORY_SEPARATOR.$key;
+    }
+    
+    /**
+     * Generate the path for a new filename
+     *
+     * @access public
+     * @param  integer   $id            Foreign key
+     * @param  string    $filename      Filename
+     * @return string
+     */
+    public function generatePath($id, $filename)
+    {
+        return $this->getPathPrefix().DIRECTORY_SEPARATOR.$id.DIRECTORY_SEPARATOR.hash('sha1', $filename.time());
+    }
+    
+    /**
+     * Upload multiple files
+     *
+     * @access public
+     * @param  integer  $id
+     * @param  array    $files
+     * @return bool
+     */
+    public function uploadFiles($id, array $files)
+    {
+        try {
+            if (empty($files)) {
+                return false;
+            }
+            foreach (array_keys($files['error']) as $key) {
+                $file = array(
+                    'name' => $files['name'][$key],
+                    'tmp_name' => $files['tmp_name'][$key],
+                    'size' => $files['size'][$key],
+                    'error' => $files['error'][$key],
+                );
+                $this->uploadFile($id, $file);
+            }
+            return true;
+        } catch (Exception $e) {
+            $this->logger->error($e->getMessage());
+            return false;
+        }
+    }
+    
+    /**
+     * Upload a file
+     *
+     * @access public
+     * @param  integer $id
+     * @param  array   $file
+     * @throws Exception
+     */
+    public function uploadFile($id, array $file)
+    {
+        if ($file['error'] == UPLOAD_ERR_OK && $file['size'] > 0) {
+            $destination_filename = $this->generatePath($id, $file['name']);
+            if ($this->isImage($file['name'])) {
+                $this->generateThumbnailFromFile($file['tmp_name'], $destination_filename);
+            }
+            $this->objectStorage->moveUploadedFile($file['tmp_name'], $destination_filename);
+            $this->create($id, $file['name'], $destination_filename, $file['size']);
+        } else {
+            throw new Exception('File not uploaded: '.var_export($file['error'], true));
+        }
+    }
+    
+    /**
+     * Handle file upload (base64 encoded content)
+     *
+     * @access public
+     * @param  integer $id
+     * @param  string  $originalFilename
+     * @param  string  $data
+     * @param  bool    $isEncoded
+     * @return bool|int
+     */
+    public function uploadContent($id, $originalFilename, $data, $isEncoded = true)
+    {
+        try {
+            if ($isEncoded) {
+                $data = base64_decode($data);
+            }
+            if (empty($data)) {
+                $this->logger->error(__METHOD__.': Content upload with no data');
+                return false;
+            }
+            $destinationFilename = $this->generatePath($id, $originalFilename);
+            $this->objectStorage->put($destinationFilename, $data);
+            if ($this->isImage($originalFilename)) {
+                $this->generateThumbnailFromData($destinationFilename, $data);
+            }
+            return $this->create(
+                $id,
+                $originalFilename,
+                $destinationFilename,
+                strlen($data)
+            );
+        } catch (ObjectStorageException $e) {
+            $this->logger->error($e->getMessage());
+            return false;
+        }
+    }
+    
+        /**
+     * Generate thumbnail from a blob
+     *
+     * @access public
+     * @param  string   $destination_filename
+     * @param  string   $data
+     */
+    public function generateThumbnailFromData($destination_filename, &$data)
+    {
+        $blob = Thumbnail::createFromString($data)
+            ->resize()
+            ->toString();
+        $this->objectStorage->put($this->getThumbnailPath($destination_filename), $blob);
+    }
+    /**
+     * Generate thumbnail from a local file
+     *
+     * @access public
+     * @param  string   $uploaded_filename
+     * @param  string   $destination_filename
+     */
+    public function generateThumbnailFromFile($uploaded_filename, $destination_filename)
+    {
+        $blob = Thumbnail::createFromFile($uploaded_filename)
+            ->resize()
+            ->toString();
+        $this->objectStorage->put($this->getThumbnailPath($destination_filename), $blob);
+    }
+    
+    public function getUserSessionId()
+    {
+        return $this->userSession->getId();
+    }
+    
+}