Cms.php

Go to the documentation of this file.

<?php

namespace Entity;

class Cms extends ModelBase
{
    protected function install()
    {
        $dbPrefix = $this->getDbPrefix();
        $result = self::$dbo->exec("CREATE TABLE IF NOT EXISTS `{$dbPrefix}cms` (
            `id` INTEGER(11) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
            `shurl` VARCHAR(255) NOT NULL,
            `controller` VARCHAR(255) NOT NULL,
            `order` INTEGER UNSIGNED NOT NULL DEFAULT 0,
            UNIQUE(`shurl`)
        )");
        if ($result === false)
            throw new \Exception(get_class().": ".self::$dbo->errorInfo()[2]);
        self::createRoute("/", "\\Controller\\HomeController", 50);
        self::createRoute("/:category", "\\Controller\\CategoryController", 50);
        self::createRoute("/:category/:product", "\\Controller\\ProductController", 50);
        self::createRoute("/:product", "\\Controller\\ProductController", 60);
        return true;
    }

    private function createRoute($category, $controller, $order)
    {
        $cms = new self();
        $cms->shurl = $category;
        $cms->controller = $controller;
        $cms->order = $order;
        $cms->save();
    }
}