XoopsModules25x / xhelp

class/BaseObject.php

<?php declare(strict_types=1);

namespace XoopsModules\Xhelp;

/*
 * You may not change or alter any portion of this comment or credits
 * of supporting developers from this source code or any supporting source code
 * which is considered copyrighted (c) material of the original comment or credit authors.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 */

/**
 * @copyright    {@link https://xoops.org/ XOOPS Project}
 * @license      {@link https://www.gnu.org/licenses/gpl-2.0.html GNU GPL 2 or later}
 * @author       Brian Wahoff <ackbarr@xoops.org>
 * @author       Eric Juden <ericj@epcusa.com>
 * @author       XOOPS Development Team
 */

/**
 * class BaseObject
 */
class BaseObject extends \XoopsObject
{
    /**
     * create a new  object
     * @return BaseObject {@link BaseObject}
     */
    public function &create(): BaseObject
    {
        return new $this->classname();

The property classname does not exist on XoopsModules\Xhelp\BaseObject. Did you maybe forget to declare it?

    }

    /**
     * retrieve an object from the database, based on. use in child classes
     * @param int $id ID
     * @return DepartmentMailBox|bool
     */
    public function get(int $id)
    {
        $id = $id;
        if ($id > 0) {
            $sql = $this->selectQuery(new \Criteria('id', (string)$id));
            if (!$result = $this->db->query($sql)) {

The property db does not exist on XoopsModules\Xhelp\BaseObject. Did you maybe forget to declare it?

                return false;
            }
            $numrows = $this->db->getRowsNum($result);
            if (1 == $numrows) {
                $obj = new $this->classname($this->db->fetchArray($result));

The property classname does not exist on XoopsModules\Xhelp\BaseObject. Did you maybe forget to declare it?

                return $obj;
            }
        }

        return false;
    }

    /**
     * Create a "select" SQL query
     * @param \CriteriaElement|null $criteria {@link CriteriaElement} to match
     * @return string SQL query
     */
    public function selectQuery(\CriteriaElement $criteria = null): string
    {
        $sql = \sprintf('SELECT * FROM `%s`', $this->db->prefix($this->dbtable));

The property dbtable does not exist on XoopsModules\Xhelp\BaseObject. Did you maybe forget to declare it?

The property db does not exist on XoopsModules\Xhelp\BaseObject. Did you maybe forget to declare it?

        if (($criteria instanceof \CriteriaCompo) || ($criteria instanceof \Criteria)) {
            $sql .= ' ' . $criteria->renderWhere();
            if ('' != $criteria->getSort()) {
                $sql .= ' ORDER BY ' . $criteria->getSort() . '
                   ' . $criteria->getOrder();
            }
        }

        return $sql;
    }

    /**
     * count objects matching a criteria
     *
     * @param \CriteriaElement|\CriteriaCompo|null $criteria {@link CriteriaElement} to match
     * @return int    count of objects
     */
    public function getCount($criteria = null): int
    {
        $sql = 'SELECT COUNT(*) FROM ' . $this->db->prefix($this->dbtable);

The property dbtable does not exist on XoopsModules\Xhelp\BaseObject. Did you maybe forget to declare it?

The property db does not exist on XoopsModules\Xhelp\BaseObject. Did you maybe forget to declare it?

        if (($criteria instanceof \CriteriaCompo) || ($criteria instanceof \Criteria)) {
            $sql .= ' ' . $criteria->renderWhere();
        }
        if (!$result = $this->db->query($sql)) {
            return 0;
        }
        [$count] = $this->db->fetchRow($result);

        return $count;
    }

    /**
     * delete object based on id
     *
     * @param \XoopsObject $obj
     * @param bool         $force
     * @return bool true/false on deleting objects
     * @internal param CriteriaElement $criteria  to match
     */
    public function delete(\XoopsObject $obj, bool $force = false): bool
    {
        if (0 != \strcasecmp($this->classname, \get_class($obj))) {

The property classname does not exist on XoopsModules\Xhelp\BaseObject. Did you maybe forget to declare it?

            return false;
        }

        $sql = \sprintf('DELETE FROM `%s` WHERE id = %u', $this->db->prefix($this->dbtable), $obj->getVar('id'));

It seems like $obj->getVar('id') can also be of type array and array; however, parameter $values of sprintf() does only seem to accept double|integer|string, maybe add an additional type check?

The property db does not exist on XoopsModules\Xhelp\BaseObject. Did you maybe forget to declare it?

The property dbtable does not exist on XoopsModules\Xhelp\BaseObject. Did you maybe forget to declare it?

        if ($force) {
            $result = $this->db->queryF($sql);
        } else {
            $result = $this->db->query($sql);
        }
        if (!$result) {
            return false;
        }

        return true;
    }
}