railpage/railpagecore

<?php

/**
 * Content class
 * @since Version 3.5
 * @package Railpage
 * @author Michael Greenhill
 * @todo Add validate() and commit() methods
 */

namespace Railpage\Content;

use Exception;
use DateTime;
use Railpage\Url;
use Railpage\ContentUtility;

/**
 * Content
 */

class Page extends Content {
    
    /**
     * Page ID
     * @var int $id
     */
    
    public $id; 
    
    /**
     * Active flag
     * @var boolean $active
     */
    
    public $active;
    
    /**
     * Page title 
     * @var string $title
     */
    
    public $title;
    
    /**
     * Page subtitle
     * @var string $subtitle
     */
    
    public $subtitle; 
    
    /**
     * Page header
     * @var string $header
     */
    
    public $header;
    
    /**
     * Page body
     * @var string $body
     */
    
    public $body; 
    
    /**
     * Page footer
     * @var string $footer
     */
    
    public $footer; 
    
    /**
     * Date published
     * @var object $date
     */
    
    public $date; 
    
    /**
     * Hits counter
     * @var int $hits
     */
     
    public $hits;
    
    /**
     * Page language
     * @var string $langauge
     */
    
    public $language; 
    
    /**
     * Page URL stub / permalink
     * @var string $permalink
     */
    
    public $permalink;
    
    /**
     * Constructor
     * @since Version 3.5
     * @param int|string $id
     */
    
    public function __construct($id = null) {
        
        parent::__construct();
        
        if (filter_var($id, FILTER_VALIDATE_INT)) {
            $this->id = $id;  
        } elseif (is_string($id) && strlen($id) > 1) {
            $query = "SELECT pid FROM nuke_pages WHERE shortname = ?";
            
            $this->id = $this->db->fetchOne($query, $id); 
        }
        
        if (filter_var($this->id)) {
            $this->mckey = sprintf("railpage:page=%d", $this->id);
            $this->fetch();
        }
    }
    
    /**
     * Fetch a page
     * @since Version 3.5
     */
    
    private function fetch() {
        if (!$row = $this->Memcached->fetch($this->mckey)) {
            $query = "SELECT * FROM nuke_pages WHERE pid = ?";
            
            $row = $this->db->fetchRow($query, $this->id);
            
            foreach ($row as $key => $val) {
                $row[$key] = stripslashes($val);
            }
            
            $this->Memcached->save($this->mckey, $row, strtotime("+1 month"));
        }
        
        $this->title        = $row['title']; 
        $this->subtitle     = $row['subtitle']; 
        $this->active       = $row['active']; 
        $this->header       = $row['page_header']; 
        $this->body         = $row['text']; 
        $this->footer       = $row['page_footer']; 
        $this->date         = new DateTime($row['date']);
        $this->hits         = $row['counter']; 
        $this->langauge     = isset($row['clanguage']) ? $row['clanguage'] : NULL;
        $this->permalink    = $row['shortname']; 
        
        $this->url = new Url(sprintf("/static-%s.htm", $this->permalink));
        $this->url->edit = sprintf("/admin/pages/edit/%d", $this->id);
        
        return true;
    }
    
    /**
     * Validate changes
     * @since Version 3.10.0
     * @return boolean
     */
    
    private function validate() {
        
        if (empty($this->title)) {
            throw new Exception("Title cannot be empty"); 
        }
        
        if (!$this->date instanceof DateTime) {
            $this->date = new DateTime; 
        }
        
        if (empty($this->hits)) {
            $this->hits = 0; 
        }
        
        if (empty($this->language)) {
            $this->language = "english";
        }
        
        if (empty($this->permalink)) {
            $prop = ContentUtility::generateUrlSlug($this->title); 
            
            if ($rs = $this->db->fetchAll("SELECT pid FROM nuke_pages WHERE shortname = ?", $prop)) {
                $prop .= count($rs); 
            }
            
            $this->permalink = $prop;
        }
        
        return true;
        
    }
    
    /**
     * Save changes
     * @since Version 3.10.0
     * @return \Railpage\Content\Page
     */
    
    public function commit() {
        
        $this->validate();
        
        $data = [
            "title" => $this->title,
            "subtitle" => $this->subtitle,
            "active" => $this->active,
            "page_header" => $this->header,
            "text" => $this->body,
            "page_footer" => $this->footer,
            "date" => $this->date->format("Y-m-d H:i:s"),
            "counter" => $this->hits,
            "clanguage" => $this->language,
            "shortname" => $this->permalink
        ];
        
        if (filter_var($this->id, FILTER_VALIDATE_INT)) {
            $where = [ "pid = ?" => $this->id ];
            
            $this->db->update("nuke_pages", $data, $where);
            
            return $this;
        }
        
        $this->db->insert("nuke_pages", $data); 
        $this->id = $this->db->lastInsertId(); 
        
        return $this;
        
    }
}