<?php

/**
 * E2pdf Template Model
 * 
 * @copyright  Copyright 2017 https://e2pdf.com
 * @license    GPL v2
 * @version    1
 * @link       https://e2pdf.com
 * @since      0.00.01
 */
if (!defined('ABSPATH')) {
    die('Access denied.');
}

class Model_E2pdf_Page extends Model_E2pdf_Model {

    private $page = array();
    private $table;

    function __construct() {
        global $wpdb;
        parent::__construct();
        $this->table = $wpdb->prefix . 'e2pdf_pages';
    }

    public function get_table() {
        return $this->table;
    }

    public function set($key, $value) {
        $this->page[$key] = $value;
    }

    public function get($key) {
        if (isset($this->page[$key])) {
            $value = $this->page[$key];
            return $value;
        } else {
            switch ($key) {
                case 'template_id':
                    $value = 0;
                    break;

                case 'properties':
                case 'actions':
                    $value = array();
                    break;

                default:
                    $value = '';
                    break;
            }
            return $value;
        }
    }

    public function get_page() {
        return $this->page;
    }

    public function before_save() {
        $page = array(
            'template_id' => $this->get('template_id'),
            'page_id' => $this->get('page_id'),
            'properties' => serialize($this->get('properties')),
            'actions' => serialize($this->get('actions'))
        );
        return $page;
    }

    public function save() {
        global $wpdb;

        $page = $this->before_save();
        if ($this->get('page_id') && $this->get('template_id')) {
            $wpdb->insert($this->get_table(), $page);
            return $this->get('page_id');
        }
    }

    public function load($page_id, $template_id) {
        global $wpdb;
        $page = $wpdb->get_row($wpdb->prepare("SELECT * FROM `{$this->get_table()}` WHERE page_id = %d AND template_id = %d", $page_id, $template_id), ARRAY_A);
        if ($page) {
            $this->page = $page;
            $this->set('properties', unserialize($page['properties']));
            $this->set('actions', unserialize($page['actions']));
            $model_e2pdf_element = new Model_E2pdf_Element();
            $this->set('elements', $model_e2pdf_element->get_elements($this->get('page_id'), $this->get('template_id')));
            return true;
        }
        return false;
    }

    public function delete() {
        global $wpdb;
        if ($this->get('page_id') && $this->get('template_id')) {
            $where = array(
                'page_id' => $this->get('page_id'),
                'template_id' => $this->get('template_id')
            );
            $wpdb->delete($this->get_table(), $where);

            foreach ($this->get('elements') as $element) {
                $model_e2pdf_element = new Model_E2pdf_Element();
                $model_e2pdf_element->load($element['element_id'], $element['template_id']);
                $model_e2pdf_element->delete();
            }
        }
    }

    public function get_pages($template_id) {
        global $wpdb;
        $pages = $wpdb->get_results($wpdb->prepare("SELECT * FROM `{$this->get_table()}` WHERE template_id = %d ORDER BY page_id ASC", $template_id), ARRAY_A);
        if ($pages) {
            $pages_list = array();
            $pages_list[] = array();
            foreach ($pages as $page_key => $page) {
                $this->load($page['page_id'], $page['template_id']);
                $pages_list[] = $this->get_page();
            }
            unset($pages_list[0]);
            return $pages_list;
        }
        return array();
    }

}