Passed
Push — master ( b847d6...d6d54c )
by Michael
09:34 queued 05:00
created

class/FieldsHandler.php (1 issue)

Labels
Severity
1
<?php namespace XoopsModules\Pedigree;
2
3
/*
4
 You may not change or alter any portion of this comment or credits
5
 of supporting developers from this source code or any supporting source code
6
 which is considered copyrighted (c) material of the original comment or credit authors.
7
8
 This program is distributed in the hope that it will be useful,
9
 but WITHOUT ANY WARRANTY; without even the implied warranty of
10
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
11
*/
12
/**
13
 * Pedigree module for XOOPS
14
 *
15
 * @copyright       {@link https://xoops.org/ The XOOPS Project}
16
 * @license         GPL 2.0 or later
17
 * @package         pedigree
18
 * @author          XOOPS Module Dev Team
19
 */
20
21
use XoopsModules\Pedigree;
0 ignored issues
show
This use statement conflicts with another class in this namespace, XoopsModules\Pedigree\Pedigree. Consider defining an alias.

Let?s assume that you have a directory layout like this:

.
|-- OtherDir
|   |-- Bar.php
|   `-- Foo.php
`-- SomeDir
    `-- Foo.php

and let?s assume the following content of Bar.php:

// Bar.php
namespace OtherDir;

use SomeDir\Foo; // This now conflicts the class OtherDir\Foo

If both files OtherDir/Foo.php and SomeDir/Foo.php are loaded in the same runtime, you will see a PHP error such as the following:

PHP Fatal error:  Cannot use SomeDir\Foo as Foo because the name is already in use in OtherDir/Foo.php

However, as OtherDir/Foo.php does not necessarily have to be loaded and the error is only triggered if it is loaded before OtherDir/Bar.php, this problem might go unnoticed for a while. In order to prevent this error from surfacing, you must import the namespace with a different alias:

// Bar.php
namespace OtherDir;

use SomeDir\Foo as SomeDirFoo; // There is no conflict anymore.
Loading history...
22
23
defined('XOOPS_ROOT_PATH') || die('Restricted access');
24
25
26
/**
27
 * Class Pedigree\FieldsHandler
28
 *
29
 * @param object $db reference to the {@link XoopsDatabase} object
30
 *
31
 * @return void
32
 */
33
class FieldsHandler extends \XoopsPersistableObjectHandler
34
{
35
    /**
36
     * @param null|object|\XoopsDatabase $db
37
     */
38
    public function __construct(\XoopsDatabase $db)
39
    {
40
        parent::__construct($db, 'pedigree_fields', Fields::class, 'id', 'fieldname');
41
    }
42
43
    /**
44
     * @todo table pedigree_lookup doesn't exist in dB this function will FAIL if called
45
     *
46
     * @param $fieldnumber
47
     *
48
     * @return array
49
     */
50
    public function lookupField($fieldnumber)
51
    {
52
        $ret    = [];
53
        $SQL    = 'SELECT * FROM ' . $GLOBALS['xoopsDB']->prefix('pedigree_lookup' . $fieldnumber) . " ORDER BY 'order'";
54
        $result = $GLOBALS['xoopsDB']->query($SQL);
55
        while (false !== ($row = $GLOBALS['xoopsDB']->fetchArray($result))) {
56
            $ret[] = ['id' => $row['id'], 'value' => $row['value']];
57
        }
58
59
        //array_multisort($ret,SORT_ASC);
60
        return $ret;
61
    }
62
}
63