<?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();
    }
    
}