ggoffy / wgevents

class/AccountHandler.php

<?php declare(strict_types=1);

namespace XoopsModules\Wgevents;

/*
 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.
*/

/**
 * wgEvents module for xoops
 *
 * @copyright    2021 XOOPS Project (https://xoops.org)
 * @license      GPL 2.0 or later
 * @package      wgevents
 * @since        1.0.0
 * @min_xoops    2.5.11 Beta1
 * @author       Goffy - Wedega - Email:webmaster@wedega.com - Website:https://xoops.wedega.com
 */

use XoopsModules\Wgevents;


/**
 * Class Object Handler Account
 */
class AccountHandler extends \XoopsPersistableObjectHandler
{
    /**
     * Constructor
     *
     * @param \XoopsDatabase $db
     */
    public function __construct(\XoopsDatabase $db)
    {
        parent::__construct($db, 'wgevents_account', Account::class, 'id', 'type');
    }

    /**
     * @param bool $isNew
     *
     * @return object
     */
    public function create($isNew = true)
    {
        return parent::create($isNew);
    }

    /**
     * retrieve a field
     *
     * @param int $id field id
     * @param $fields
     * @return \XoopsObject|null reference to the {@link Get} object
     */
    public function get($id = null, $fields = null)
    {
        return parent::get($id, $fields);
    }

    /**
     * get inserted id
     *
     * @return int reference to the {@link Get} object
     */
    public function getInsertId()
    {
        return $this->db->getInsertId();
    }

    /**
     * Get Count Account in the database
     * @param int    $start
     * @param int    $limit
     * @param string $sort
     * @param string $order
     * @return int
     */
    public function getCountAccounts($start = 0, $limit = 0, $sort = 'id ASC, type', $order = 'ASC')
    {
        $crCountAccounts = new \CriteriaCompo();
        $crCountAccounts = $this->getAccountsCriteria($crCountAccounts, $start, $limit, $sort, $order);
        return $this->getCount($crCountAccounts);

$crCountAccounts of type integer is incompatible with the type CriteriaElement|null expected by parameter $criteria of XoopsPersistableObjectHandler::getCount().

    }

    /**
     * Get All Account in the database
     * @param int    $start
     * @param int    $limit
     * @param string $sort
     * @param string $order
     * @return array
     */
    public function getAllAccounts($start = 0, $limit = 0, $sort = 'id ASC, type', $order = 'ASC')
    {
        $crAllAccounts = new \CriteriaCompo();
        $crAllAccounts = $this->getAccountsCriteria($crAllAccounts, $start, $limit, $sort, $order);
        return $this->getAll($crAllAccounts);

$crAllAccounts of type integer is incompatible with the type CriteriaElement|null expected by parameter $criteria of XoopsPersistableObjectHandler::getAll().

    }

    /**
     * Get Criteria Account
     * @param        $crAccount
     * @param int $start
     * @param int $limit
     * @param string $sort
     * @param string $order
     * @return int
     */
    private function getAccountsCriteria($crAccount, int $start, int $limit, string $sort, string $order)
    {
        $crAccount->setStart($start);
        $crAccount->setLimit($limit);
        $crAccount->setSort($sort);
        $crAccount->setOrder($order);
        return $crAccount;
    }

    /**
     * Get primary Account
     * returns
     * - array with defaults if no primary account found (website email settings will be used)
     * - an array with settings of the primary account
     *
     * @return array
     */
    public function getPrimary() {

        $crAccount = new \CriteriaCompo();
        $crAccount->add(new \Criteria('primary', 1));
        $primaryCount = $this->getCount($crAccount);
        $accountConfig = [];
        // default settings
        $accountConfig['type']           = 0;
        $accountConfig['yourname']       = '';
        $accountConfig['yourmail']       = '';
        $accountConfig['password']       = '';
        $accountConfig['server_out']     = '';
        $accountConfig['port_out']       = '';
        $accountConfig['securetype_out'] = '';
        if ($primaryCount > 0) {
            $accountAll = $this->getAll($crAccount);
            foreach (\array_keys($accountAll) as $i) {
                $accountConfig['type']           = $accountAll[$i]->getVar('type');
                $accountConfig['yourname']       = $accountAll[$i]->getVar('yourname');
                $accountConfig['yourmail']       = $accountAll[$i]->getVar('yourmail');
                $accountConfig['password']       = $accountAll[$i]->getVar('password');
                $accountConfig['server_out']     = $accountAll[$i]->getVar('server_out');
                $accountConfig['port_out']       = $accountAll[$i]->getVar('port_out');
                $accountConfig['securetype_out'] = $accountAll[$i]->getVar('securetype_out');
            }
        }
        return $accountConfig;
    }

    /**
     * Get the value of limit_hour of primary account
     * @return int
     */
    public function getLimitHour() {

        $limitHour = 0;
        $crAccount = new \CriteriaCompo();
        $crAccount->add(new \Criteria('primary', 1));
        $primaryCount = $this->getCount($crAccount);
        if ($primaryCount > 0) {
            $accountAll = $this->getAll($crAccount);
            foreach (\array_keys($accountAll) as $i) {
                $limitHour = $accountAll[$i]->getVar('limit_hour');
            }
        }
        return (int)$limitHour;
    }
}