tplset.php

Go to the documentation of this file.

<?php
use Xoops\Core\Database\Connection;
use Xoops\Core\Kernel\CriteriaElement;
use Xoops\Core\Kernel\XoopsObject;
use Xoops\Core\Kernel\XoopsPersistableObjectHandler;

class XoopsTplset extends XoopsObject
{

    public function __construct()
    {
        $this->initVar('tplset_id', XOBJ_DTYPE_INT, null, false);
        $this->initVar('tplset_name', XOBJ_DTYPE_OTHER, null, false);
        $this->initVar('tplset_desc', XOBJ_DTYPE_TXTBOX, null, false, 255);
        $this->initVar('tplset_credits', XOBJ_DTYPE_TXTAREA, null, false);
        $this->initVar('tplset_created', XOBJ_DTYPE_INT, 0, false);
    }

    public function id($format = 'n')
    {
        return $this->getVar('tplset_id', $format);
    }

    public function tplset_id($format = '')
    {
        return $this->getVar('tplset_id', $format);
    }

    public function tplset_name($format = '')
    {
        return $this->getVar('tplset_name', $format);
    }

    public function tplset_desc($format = '')
    {
        return $this->getVar('tplset_desc', $format);
    }

    public function tplset_credits($format = '')
    {
        return $this->getVar('tplset_credits', $format);
    }

    public function tplset_created($format = '')
    {
        return $this->getVar('tplset_created', $format);
    }
}

class XoopsTplsetHandler extends XoopsPersistableObjectHandler
{

    public function __construct(Connection $db = null)
    {
        parent::__construct($db, 'tplset', 'XoopsTplset', 'tplset_id', 'tplset_name');
    }

    public function getByName($tplset_name)
    {
        $qb = $this->db2->createXoopsQueryBuilder();
        $eb = $qb->expr();

        $tplset = false;
        $tplset_name = trim($tplset_name);
        if ($tplset_name != '') {
            $qb->select('*')
                ->fromPrefix('tplset', null)
                ->where($eb->eq('tplset_name', ':tplsetname'))
                ->setParameter(':tplsetname', $tplset_name, \PDO::PARAM_STR);
            $result = $qb->execute();
            if (!$result) {
                return false;
            }
            $allrows = $result->fetchAll();
            if (count($allrows) == 1) {
                $tplset = new XoopsTplset();
                $tplset->assignVars(reset($allrows));
            }
        }
        return $tplset;
    }

    public function getNameList(CriteriaElement $criteria = null)
    {
        $ret = array();
        $tplsets = $this->getObjects($criteria, true);
        foreach (array_keys($tplsets) as $i) {
            $ret[$tplsets[$i]->getVar('tplset_name')] = $tplsets[$i]->getVar('tplset_name');
        }
        return $ret;
    }
}