summaryrefslogtreecommitdiff
path: root/plugins/Customizer/Model
diff options
context:
space:
mode:
Diffstat (limited to 'plugins/Customizer/Model')
-rw-r--r--plugins/Customizer/Model/CustomizerFileModel.php320
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();
+ }
+
+}
generated by cgit v1.2.3 (git 2.46.0) at 2024-11-26 16:05:32 +0000