mambax7/pedigree

<?php

namespace XoopsModules\Pedigree;

/**
 *  pedigree HTML Input Interface Class Elements
 *
 * @copyright  ZySpec Incorporated
 * @license    {@link https://www.gnu.org/licenses/gpl-2.0.html GNU Public License}
 * @package    pedigree
 * @subpackage class
 * @author     zyspec <zyspec@yahoo.com>
 * @since      1.3.1
 */

use XoopsModules\Pedigree;

\defined('XOOPS_ROOT_PATH') || die('Restricted access');

/**
 * Pedigree\HtmlInputAbstract
 *
 * @package   \XoopsModules\Pedigree\Class
 * @author    zyspec <zyspec@yahoo.com>
 * @copyright Copyright (c) 2014-2019 ZySpec Incorporated
 * @access    public
 */

/**
 * Class Pedigree\HtmlInputAbstract
 */
abstract class HtmlInputAbstract //extends Pedigree\Field
{
    /**
     * @return mixed
     */
    abstract public function editField();

    /**
     * @param $name
     * @return mixed
     */
    abstract public function newField($name);

    /**
     * @return mixed|void
     */
    public function showField()
    {
        return null;
    }

    /**
     * @return mixed|void
     */
    public function viewField()
    {
        return null;
    }

    /**
     * @return mixed
     */
    abstract public function showValue();

    /**
     * @return mixed|void
     */
    public function searchField()
    {
        return null;
    }

    /**
     * @return mixed|null
     */
    public function getSearchString()
    {
        return null;
    }

    /**
     * @param string $message
     */
    public function echoMsg($message)
    {
        echo "<span style='color: #ff0000;'><h3>{$message}</h3></span>";
    }

    /**
     * @param $fieldnumber
     *
     * @return array
     */
    public function lookupField($fieldnumber)
    {
        $ret = [];

        /** @var \Xmf\Database\Tables $pTables */
        $pTables = new \Xmf\Database\Tables();
        $exists  = $pTables->useTable('pedigree_lookup' . $fieldnumber);
        if ($exists) {
            $tableName = $pTables->name('pedigree_lookup' . $fieldnumber);
            $SQL       = "SELECT * FROM `{$tableName}` ORDER BY 'order'";
            //$SQL    = 'SELECT * FROM ' . $GLOBALS['xoopsDB']->prefix('pedigree_lookup' . $fieldnumber) . " ORDER BY 'order'";
            $result = $GLOBALS['xoopsDB']->query($SQL);
            while (false !== ($row = $GLOBALS['xoopsDB']->fetchArray($result))) {
                $ret[] = ['id' => $row['id'], 'value' => $row['value']];
            }
        }

        //array_multisort($ret,SORT_ASC);
        return $ret;
    }
}