mambax7 / pedigree

pedigree.php

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

/**
 * animal module for xoops
 *
 * @package         XoopsModules\Pedigree
 * @copyright       {@link http://sourceforge.net/projects/thmod/ The TXMod XOOPS Project}
 * @copyright       {@link http://sourceforge.net/projects/xoops/ The XOOPS Project}
 * @license         https://www.gnu.org/licenses/gpl-2.0.html GNU Public License
 * @author          XOOPS Module Development Team
 */

use Xmf\Request;
use XoopsModules\Pedigree;

require_once \dirname(__DIR__, 2) . '/mainfile.php';
require_once __DIR__ . '/header.php';
//xoops_cp_header();
$helper->loadLanguage('main');

//require_once __DIR__ . '/header.php';

// Include any common code for this module.
require_once $helper->path('include/common.php');
//require_once XOOPS_ROOT_PATH ."/modules/" . $xoopsModule->dirname() . "/include/css.php";

// This page uses smarty templates. Set "$xoopsOption['template_main']" before including header
$GLOBALS['xoopsOption']['template_main'] = 'pedigree_pedigree.tpl';
include $GLOBALS['xoops']->path('/header.php');

$GLOBALS['xoTheme']->addScript('browse.php?Frameworks/jquery/jquery.js');
$GLOBALS['xoTheme']->addScript("browse.php?modules/{$moduleDirName}/assets/js/jquery.magnific-popup.min.js");
$GLOBALS['xoTheme']->addStylesheet("browse.php?modules/{$moduleDirName}/assets/css/style.css");
$GLOBALS['xoTheme']->addStylesheet("browse.php?modules/{$moduleDirName}/assets/css/magnific-popup.css");

require_once $GLOBALS['xoops']->path('class/xoopsformloader.php');

//
// Displays the "Main" tab of the module
//
$id = Request::getInt('pedid', 1, 'GET');
//$animal = new Pedigree\Animal($id);
//test to find out how many user fields there are.
//$fields      = $animal->getNumOfFields();
//$fieldsCount = count($fields);

$qarray = ['d', 'f', 'm', 'ff', 'mf', 'fm', 'mm', 'fff', 'ffm', 'fmf', 'fmm', 'mmf', 'mff', 'mfm', 'mmm'];

$querystring = 'SELECT ';

foreach ($qarray as $key) {
    $querystring .= $key . '.id as ' . $key . '_id, ';
    $querystring .= $key . '.pname as ' . $key . '_pname, ';
    $querystring .= $key . '.mother as ' . $key . '_mother, ';
    $querystring .= $key . '.father as ' . $key . '_father, ';
    $querystring .= $key . '.roft as ' . $key . '_roft, ';
    $querystring .= $key . '.foto as ' . $key . '_foto, ';
}

$querystring .= 'mmm.coi as mmm_coi FROM ' . $GLOBALS['xoopsDB']->prefix('pedigree_registry') . ' d
             LEFT JOIN ' . $GLOBALS['xoopsDB']->prefix('pedigree_registry') . ' f ON d.father = f.id
             LEFT JOIN ' . $GLOBALS['xoopsDB']->prefix('pedigree_registry') . ' m ON d.mother = m.id
             LEFT JOIN ' . $GLOBALS['xoopsDB']->prefix('pedigree_registry') . ' ff ON f.father = ff.id
             LEFT JOIN ' . $GLOBALS['xoopsDB']->prefix('pedigree_registry') . ' fff ON ff.father = fff.id
             LEFT JOIN ' . $GLOBALS['xoopsDB']->prefix('pedigree_registry') . ' ffm ON ff.mother = ffm.id
             LEFT JOIN ' . $GLOBALS['xoopsDB']->prefix('pedigree_registry') . ' mf ON m.father = mf.id
             LEFT JOIN ' . $GLOBALS['xoopsDB']->prefix('pedigree_registry') . ' mff ON mf.father = mff.id
             LEFT JOIN ' . $GLOBALS['xoopsDB']->prefix('pedigree_registry') . ' mfm ON mf.mother = mfm.id
             LEFT JOIN ' . $GLOBALS['xoopsDB']->prefix('pedigree_registry') . ' fm ON f.mother = fm.id
             LEFT JOIN ' . $GLOBALS['xoopsDB']->prefix('pedigree_registry') . ' fmf ON fm.father = fmf.id
             LEFT JOIN ' . $GLOBALS['xoopsDB']->prefix('pedigree_registry') . ' fmm ON fm.mother = fmm.id
             LEFT JOIN ' . $GLOBALS['xoopsDB']->prefix('pedigree_registry') . ' mm ON m.mother = mm.id
             LEFT JOIN ' . $GLOBALS['xoopsDB']->prefix('pedigree_registry') . ' mmf ON mm.father = mmf.id
             LEFT JOIN ' . $GLOBALS['xoopsDB']->prefix('pedigree_registry') . " mmm ON mm.mother = mmm.id
             WHERE d.id={$id}";

$result = $GLOBALS['xoopsDB']->query($querystring);

$dogs = []; // initialize dogs array
while (false !== ($row = $GLOBALS['xoopsDB']->fetchArray($result))) {
    //create array for animal (and all parents)
    foreach ($qarray as $key) {
        $dogs[$key] = [
            'id'     => $row[$key . '_id'],
            'name'   => stripslashes($row[$key . '_pname']),
            'mother' => $row[$key . '_mother'],
            'father' => $row[$key . '_father'],
            'roft'   => $row[$key . '_roft'],
            'nhsb'   => '',
        ];
        if ((3 != mb_strlen($key) || (0 != $helper->getConfig('lastimage'))) && ('' !== $row[$key . '_foto'])) {
            //show image in last row of pedigree if image exists
            $dogs[$key]['photo']    = PEDIGREE_UPLOAD_URL . '/images/thumbnails/' . $row[$key . '_foto'] . '_150.jpeg';

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

            $dogs[$key]['photoBig'] = PEDIGREE_UPLOAD_URL . '/images/' . $row[$key . '_foto'] . '.jpeg';
        }

        $dogs[$key]['overig'] = '';
        // $pedidata to hold viewable data to be shown in pedigree
        $pedidata = '';

        if (0 !== $dogs[$key]['id']) {
            //if exists create animal object
            $animal = new Pedigree\Animal($dogs[$key]['id']);
            $fields = $animal->getNumOfFields();
        }
        foreach ($fields as $i => $iValue) {
            $userField = new Pedigree\Field($fields[$i], $animal->getConfig());
            if ($userField->isActive() && $userField->inPedigree()) {
                $fieldType = $userField->getSetting('fieldtype');
                $fieldObj  = new $fieldType($userField, $animal);
                $pedidata  .= $fieldObj->showField() . '<br>';
            }
            $dogs[$key]['hd'] = $pedidata;
        }
    }
}

//add data to smarty template
$GLOBALS['xoopsTpl']->assign([
                                 'page_title' => stripslashes($row['d_pname']),
                                 'd'          => $dogs,  //assign dogs array
                                 //assign config options
                                 'male'       => "<img src=\"" . PEDIGREE_IMAGE_URL . "/male.gif\" alt=\"" . _MA_PEDIGREE_FLD_MALE . "\" title=\"" . _MA_PEDIGREE_FLD_MALE . "\">",
                                 'female'     => "<img src=\"" . PEDIGREE_IMAGE_URL . "/female.gif\" alt=\"" . _MA_PEDIGREE_FLD_FEMA . "\" title=\"" . _MA_PEDIGREE_FLD_FEMA . "\">",
                                 //assign extra display options
                                 'unknown'    => _MA_PEDIGREE_UNKNOWN,
                                 'SD'         => _MA_PEDIGREE_SD,
                                 'PA'         => _MA_PEDIGREE_PA,
                                 'GP'         => _MA_PEDIGREE_GP,
                                 'GGP'        => _MA_PEDIGREE_GGP,
                             ]);

require __DIR__ . '/footer.php';