map.php

<?php
require_once 'vendor/autoload.php';

/**
 * Whole Class analog to user.php
 * Created by PhpStorm.
 * User: User
 * Date: 17.06.2017
 * Time: 18:30
 */
class map extends udvide
{
    /** @var  string */
    protected $name;
    /** @var  resource */
    protected $image;

    public function __construct(){}

    //<editor-fold desc="CRUD DB">
    public function read()
    {
        $sql = <<<'SQL'
SELECT name, image
FROM udvide.Maps m
WHERE name = ?
SQL;
        $db = access_DB::prepareExecuteFetchStatement($sql, [$this->name]);
        $this->set($db[0]);
        return $this;
    }

    public static function readAll()
    {
        $sql = <<<'SQL'
SELECT name, image
FROM udvide.Maps
SQL;
        $db = access_DB::prepareExecuteFetchStatement($sql);
        foreach ($db as $key => $userArr) {
            $temp = new self();
            $temp->setImage($userArr['image']);
            $db[$key]['image'] = $temp->getImageAsDataUrlJpg();
        } // todo refactor
        return $db;
    }

    public function create()
    {
        if (user::getLoggedInUser()->getRole() < MIN_ALLOW_MAP_CREATE)
            throw new PermissionException(ERR_PERMISSION_INSUFFICIENT,1);
        if (!isset($this->name) || !isset($this->image))
            throw new IncompleteObjectException(ERR_USER_DATASET_INVALID,1);

        $sql = <<<'SQL'
INSERT INTO udvide.Maps
(name,image)
VALUES (?,?);
SQL;
        $values = [
            $this->name,
            $this->getImageAsRawJpg()
        ];
        access_DB::prepareExecuteStatementGetAffected($sql,$values);
        return $this;
    }

    public function update(string $subject = null)
    {
        $subject = empty($subject) ? $this->name : $subject;

        // If not allowed to update and self-update (in case of self update)
        if (user::getLoggedInUser()->getRole() < MIN_ALLOW_MAP_UPDATE)
            throw new PermissionException(ERR_PERMISSION_INSUFFICIENT,1);

        $updateDB = false;
        $sql = '';
        foreach ($this as $key => $value) {
            if(isset($this->{$key})) {
                $sql .= " $key = ? , ";
                if ($key == "image") {
                    $value = $this->getImageAsRawJpg();
                }
                $ins[] = $value;
                $updateDB = true;
            }
        }

        $sql = rtrim(rtrim($sql),',');

        if ($updateDB) {
            $sql = <<<SQL
UPDATE udvide.maps
SET $sql
WHERE name = ?;
SQL;
            $ins[] = $subject;

            //echo $sql ."\n";
            //var_dump($ins);

            access_DB::prepareExecuteFetchStatement($sql, $ins);
        }
        return $this;
    }

    public function delete()
    {
        if (user::getLoggedInUser()->getRole() < MIN_ALLOW_MAP_DELETE)
            throw new PermissionException(ERR_PERMISSION_INSUFFICIENT,1);

        $sql = 'DELETE FROM udvide.Maps WHERE name = ?';
        access_DB::prepareExecuteFetchStatement($sql,[$this->name]);
    }
    //</editor-fold>

    public function __set(string $name, $value): map
    {
        switch($name) {
            case 'name':
                return $this->setName($value);
            case 'image':
                return $this->setImage($value);
            default:
                return $this;
        }
    }

    public function __get(string $name) {
        switch($name) {
            case 'name':
                return $this->getName();
            case 'image':
                return $this->getImage();
            case 'width':
                return $this->getWidth();
            case 'height':
                return $this->getHeight();
            default:
                return null;
        }
    }

    //<editor-fold desc="Fluent Setter">

    /**
     * @param string $name
     * @return map
     */
    public function setName(string $name = null):map
    {
        $this->name = $name;
        return $this;
    }

    /**
     * @param resource|string $image
     * @return map
     */
    public function setImage($image = null):map
    {
        if (isset($image)) {
            if (is_string($image)) {
                if (!helper::strIsJpg($image)) {
                    // if it is a data url we want to resolve it
                    $image = helper::base64ImgToDecodeAbleBase64($image);
                    $image = base64_decode($image);
                }
                $image = imagecreatefromstring($image);
            }
            $this->image = helper::imgAssistant($image, ['maxFileSize' => VUFORIA_DATA_SIZE_LIMIT]);
        }
        return $this;
    }
    //</editor-fold>

    //<editor-fold desc="Getter">
    /**
     * @return string
     */
    public function getName():string
    {
        return $this->name;
    }

    /**
     * @return resource
     */
    public function getImage()
    {
        return $this->image;
    }

    /**
     * @return string
     */
    public function getImageAsRawJpg()
    {
        return helper::imgResToJpgString($this->image); // quality defaults to 95
    }

    /**
     * @return string
     */
    public function getImageAsBase64Jpg()
    {
        return base64_encode($this->getImageAsRawJpg());
    }

    /**
     * @return string
     */
    public function getImageAsDataUrlJpg()
    {
        return 'data:image/jpeg;base64,' . $this->getImageAsBase64Jpg();
    }

    /**
     * @return int
     */
    public function getHeight():int
    {
        return imagesy($this->image);
    }

    /**
     * @return int
     */
    public function getWidth():int
    {
        return imagesx($this->image);
    }
    //</editor-fold>

}