virt()

Complexity

Conditions	24
Paths	> 20000

Size

Total Lines	212
Code Lines	131

Duplication

Lines	0
Ratio	0 %

Importance

Changes	4
Bugs	0	Features	0

<?php
function virt()
{
    global $xoopsTpl;
    $moduleDirName = basename(__DIR__);
    //get module configuration
    /** @var XoopsModuleHandler $moduleHandler */
    $moduleHandler = xoops_getHandler('module');

The function xoops_getHandler was not found. Maybe you did not declare it correctly or list all dependencies?

    $module        = $moduleHandler->getByDirname($moduleDirName);
    $configHandler = xoops_getHandler('config');
    $moduleConfig  = $configHandler->getConfigsByCat(0, $module->getVar('mid'));

The assignment to $moduleConfig is dead and can be removed.

    $helper      = Pedigree\Helper::getInstance();

    //    if (isset($_GET['st'])) {
    //        $st = $_GET['st'];
    //    } else {
    //        $st = 0;
    //    }
    //    if (isset($_GET['l'])) {
    //        $l = $_GET['l'];
    //    } else {
    //        $l = 'A';
    //    }
    $st = Request::getInt('st', 0, 'GET');
    $l  = Request::getString('l', 'A', 'GET');

    $xoopsTpl->assign('sire', '1');
    //create list of males dog to select from
    $perPage = $helper->getConfig('perpage');
    //count total number of dogs
    $numDog = 'SELECT COUNT(d.id) FROM '
              . $GLOBALS['xoopsDB']->prefix('pedigree_tree')
              . ' d LEFT JOIN '
              . $GLOBALS['xoopsDB']->prefix('pedigree_tree')
              . ' m ON m.id = d.mother LEFT JOIN '
              . $GLOBALS['xoopsDB']->prefix('pedigree_tree')
              //            . " f ON f.id = d.father WHERE d.roft = '0' and d.mother != '0' and d.father != '0' and m.mother != '0' and m.father != '0' and f.mother != '0' and f.father != '0' and d.naam LIKE '" . $l . "%'";
              . " f ON f.id = d.father WHERE d.roft = '0' AND d.mother != '0' AND d.father != '0' AND m.mother != '0' AND m.father != '0' AND f.mother != '0' AND f.father != '0' AND d.naam LIKE '"
              . $GLOBALS['xoopsDB']->escape($l)
              . "%'";
    $numRes = $GLOBALS['xoopsDB']->query($numDog);
    //total number of dogs the query will find
    list($numResults) = $GLOBALS['xoopsDB']->fetchRow($numRes);
    //total number of pages
    $numPages = floor($numResults / $perPage) + 1;
    if (($numPages * $perPage) == ($numResults + $perPage)) {
        --$numPages;
    }
    //find current page
    $currentPage = floor($st / $perPage) + 1;
    //create alphabet
    $pages = '';
    for ($i = 65; $i <= 90; ++$i) {
        if ($l == chr($i)) {
            $pages .= '<b><a href="virtual.php?r=1&st=0&l=' . chr($i) . '">' . chr($i) . '</a></b>&nbsp;';
        } else {
            $pages .= '<a href="virtual.php?r=1&st=0&l=' . chr($i) . '">' . chr($i) . '</a>&nbsp;';
        }
    }
    $pages .= '-&nbsp;';
    $pages .= '<a href="virtual.php?r=1&st=0&l=Ã…">Ã…</a>&nbsp;';
    $pages .= '<a href="virtual.php?r=1&st=0&l=Ö">Ö</a>&nbsp;';
    $pages .= '<br>';
    //create previous button
    if (($numPages > 1) && ($currentPage > 1)) {
        $pages .= '<a href="virtual.php?r=1&&l=' . $l . 'st=' . ($st - $perPage) . '">' . _MA_PEDIGREE_PREVIOUS . '</a>&nbsp;&nbsp';
        }
    //create numbers
    $xLimit = $numPages + 1;
    for ($x = 1; $x < $xLimit; ++$x) {
        //create line break after 20 number
        if (0 == ($x % 20)) {
            $pages .= '<br>';
        }
        if ($x != $currentPage) {
            $pages .= '<a href="virtual.php?r=1&l=' . $l . '&st=' . ($perPage * ($x - 1)) . '">' . $x . '</a>&nbsp;&nbsp;';
        } else {
            $pages .= $x . '&nbsp;&nbsp';
        }
    }
    //create next button
    if ($numPages > 1) {
        if ($currentPage < $numPages) {
            $pages .= '<a href="virtual.php?r=1&l=' . $l . '&st=' . ($st + $perPage) . '">' . _MA_PEDIGREE_NEXT . '</a>&nbsp;&nbsp';
        }
    }

    //query
    $queryString = 'SELECT d.*, d.id AS d_id, d.naam AS d_naam FROM '
                   . $GLOBALS['xoopsDB']->prefix('pedigree_tree')
                   . ' d LEFT JOIN '
                   . $GLOBALS['xoopsDB']->prefix('pedigree_tree')
                   . ' m ON m.id = d.mother LEFT JOIN '
                   . $GLOBALS['xoopsDB']->prefix('pedigree_tree')
                   . " f ON f.id = d.father WHERE d.roft = '0' AND d.mother != '0' AND d.father != '0' AND m.mother != '0' AND m.father != '0' AND f.mother != '0' AND f.father != '0' AND d.naam LIKE '"
                   . $l
                   . "%' ORDER BY d.naam LIMIT "
                   . $st
                   . ', '
                   . $perPage;
    $result      = $GLOBALS['xoopsDB']->query($queryString);

    $animal = new Pedigree\Animal();
    //test to find out how many user fields there are...
    $fields       = $animal->getNumOfFields();
    $numofcolumns = 1;
    $columns[]    = ['columnname' => 'Name'];

$columns was never initialized. Although not strictly required by PHP, it is generally a good practice to add $columns = array(); before regardless.

    for ($i = 0, $iMax = count($fields); $i < $iMax; ++$i) {
        $userField   = new Pedigree\Field($fields[$i], $animal->getConfig());
        $fieldType   = $userField->getSetting('FieldType');
        $fieldObject = new $fieldType($userField, $animal);
        //create empty string
        $lookupValues = '';
        if ($userField->isActive() && $userField->inList()) {
            if ($userField->hasLookup()) {
                $lookupValues = $userField->lookupField($fields[$i]);
                //debug information
                //print_r($lookupValues);
            }
            $columns[] = [
                'columnname'   => $fieldObject->fieldname,
                'columnnumber' => $userField->getId(),
                'lookupval'    => $lookupValues
            ];
            ++$numofcolumns;
            unset($lookupValues);
        }
    }

    while (false !== ($row = $GLOBALS['xoopsDB']->fetchArray($result))) {
        //create picture information
        if ('' != $row['foto']) {
            $camera = ' <img src="' . PEDIGREE_UPLOAD_URL . '/images/dog-icon25.png">';
        } else {
            $camera = '';
        }
        $name = stripslashes($row['d_naam']) . $camera;
        //empty array
        unset($columnvalue);
        //fill array
        for ($i = 1; $i < $numofcolumns; ++$i) {
            $x = $columns[$i]['columnnumber'];
            //echo $x."columnnumber";
            if (is_array($columns[$i]['lookupval'])) {
                foreach ($columns[$i]['lookupval'] as $key => $keyValue) {
                    if ($keyValue['id'] == $row['user' . $x]) {
                        //echo "key:".$row['user5']."<br>";
                        $value = $keyValue['value'];
                    }
                }
                //debug information
                ///echo $columns[$i]['columnname']."is an array !";
            } //format value - cant use object because of query count
            elseif (0 === strncmp($row['user' . $x], 'http://', 7)) {
                $value = '<a href="' . $row['user' . $x] . '">' . $row['user' . $x] . '</a>';
            } else {
                $value = $row['user' . $x];
            }
            $columnvalue[] = ['value' => $value];

The variable $value does not seem to be defined for all execution paths leading up to this point.

            unset($value);
        }
        $dogs[] = [
            'id'          => $row['d_id'],
            'name'        => $name,
            'gender'      => '<img src="assets/images/male.gif">',
            'link'        => '<a href="virtual.php?f=dam&selsire=' . $row['d_id'] . '">' . $name . '</a>',
            'colour'      => '',
            'number'      => '',
            'usercolumns' => isset($columnvalue) ? $columnvalue : 0
        ];
    }

    //add data to smarty template
    //assign dog
    if (isset($dogs)) {
        $xoopsTpl->assign('dogs', $dogs);
    }
    $xoopsTpl->assign('columns', $columns);
    $xoopsTpl->assign('numofcolumns', $numofcolumns);
    $xoopsTpl->assign('tsarray', Pedigree\Utility::sortTable($numofcolumns));
    $xoopsTpl->assign('nummatch', strtr(_MA_PEDIGREE_ADD_SELSIRE, ['[father]' => $helper->getConfig('father')]));
    $xoopsTpl->assign('pages', $pages);

    $xoopsTpl->assign('virtualtitle', strtr(_MA_PEDIGREE_VIRUTALTIT, ['[mother]' => $helper->getConfig('mother')]));
    $xoopsTpl->assign('virtualstory', strtr(_MA_PEDIGREE_VIRUTALSTO, [
        '[mother]'   => $helper->getConfig('mother'),
        '[father]'   => $helper->getConfig('father'),
        '[children]' => $helper->getConfig('children')
    ]));
    $xoopsTpl->assign('nextaction', '<b>' . strtr(_MA_PEDIGREE_VIRT_SIRE, ['[father]' => $helper->getConfig('father')]) . '</b>');
    //    break;

    //mb =========== FATHER LETTERS =============================
    $myObject = Pedigree\Helper::getInstance();
    $roft     = 0;
    //    $criteria     = $myObject->getHandler('Tree')->getActiveCriteria($roft);
    $activeObject = 'Tree';
    $name         = 'naam';
    $number1      = '1';
    $number2      = '0';
    //    $link         = "virtual.php?r={$number1}&st={$number2}&l=";
    $link = "virtual.php?r={$number1}&st={$number2}&l=";

    //    http://localhost/257belgi/modules/pedigree/virtual.php?f=dam&selsire=35277

    $link2 = '';

    $criteria = $myObject->getHandler('Tree')->getActiveCriteria($roft);
    //    $criteria->setGroupby('UPPER(LEFT(' . $name . ',1))');

    $fatherArray['letters'] = Pedigree\Utility::lettersChoice($myObject, $activeObject, $criteria, $name, $link, $link2);

$fatherArray was never initialized. Although not strictly required by PHP, it is generally a good practice to add $fatherArray = array(); before regardless.

    //$catarray['toolbar']          = pedigree_toolbar();
    $xoopsTpl->assign('fatherArray', $fatherArray);