<?php

namespace UkrSolution\WpLabelsPrinting4\Models;

use UkrSolution\WpLabelsPrinting4\Database;

class PaperFormats
{
    protected $wpdb;
    protected $tablePaperFormats;
    protected $defaultPaperFormatParams = array(
        'name' => 'Paper 1',
        'width' => '210',
        'height' => '297',
        'default' => 0,
        'landscape' => 0,
        'is_roll' => 0,
        'is_editable' => 1,
        'units' => 'mm',
    );

    public function __construct()
    {
        global $wpdb;
        $this->wpdb = $wpdb;
        $this->tablePaperFormats = Database::$tablePaperFormats;
    }

    public function add($params)
    {
        unset($params['id']);

        $params = array_merge($this->defaultPaperFormatParams, $params);
        $result = $this->wpdb->insert("{$this->wpdb->prefix}{$this->tablePaperFormats}", $params);

        return false !== $result ? $this->wpdb->insert_id : false;
    }

    public function get($id)
    {
        return $this->wpdb->get_row($this->wpdb->prepare(
            "SELECT * FROM {$this->wpdb->prefix}{$this->tablePaperFormats} WHERE id='%d';",
            $id
        ));
    }

    public function getByName($name)
    {
        return $this->wpdb->get_row($this->wpdb->prepare(
            "SELECT * FROM {$this->wpdb->prefix}{$this->tablePaperFormats} WHERE name='%s' AND `is_removed` = 0;",
            $name
        ));
    }

    public function update($params)
    {
        $result = $this->wpdb->update("{$this->wpdb->prefix}{$this->tablePaperFormats}", $params, array('id' => $params['id']));

        return false !== $result;
    }

    public function delete($id)
    {
        $result = $this->wpdb->delete("{$this->wpdb->prefix}{$this->tablePaperFormats}", array('id' => $id), array('%d'));

        return !empty($result);
    }

    public function getAll()
    {
        return $this->wpdb->get_results("
            SELECT * 
            FROM {$this->wpdb->prefix}{$this->tablePaperFormats} 
            WHERE `name` <> 'future-reserved-paper-format'
                AND `is_removed` = 0
        ", ARRAY_A);
    }
}