HaaseIT\HCSF\Controller\Admin\Shop\Itemgroupadmin

Complexity

Total Complexity

43

Size/Duplication

Total Lines	261
Duplicated Lines	10.34 %

Coupling/Cohesion

Components	1
Dependencies	9

Importance

Changes

0

<?php
class Itemgroupadmin extends Base
{
    /**
     * @var \PDO
     */
    private $db;

    /**
     * Itemgroupadmin constructor.
     * @param ServiceManager $serviceManager
     */
    public function __construct(ServiceManager $serviceManager)
    {
        parent::__construct($serviceManager);
        $this->db = $serviceManager->get('db');
    }

    /**
     *
     */
    public function preparePage()
    {
        $this->P = new \HaaseIT\HCSF\CorePage($this->serviceManager);
        $this->P->cb_pagetype = 'content';
        $this->P->cb_subnav = 'admin';

        $this->P->cb_customcontenttemplate = 'shop/itemgroupadmin';

        $return = '';
        if (isset($_REQUEST['action']) && $_REQUEST['action'] === 'insert_lang') {
            $sql = 'SELECT itmg_id FROM itemgroups_base WHERE itmg_id = :gid';
            $hResult = $this->db->prepare($sql);
            $hResult->bindValue(':gid', $_REQUEST['gid']);
            $hResult->execute();
            $iNumRowsBasis = $hResult->rowCount();

            $sql = 'SELECT itmgt_id FROM itemgroups_text WHERE itmgt_pid = :gid AND itmgt_lang = :lang';
            $hResult = $this->db->prepare($sql);
            $hResult->bindValue(':gid', $_REQUEST['gid']);
            $hResult->bindValue(':lang', HelperConfig::$lang);
            $hResult->execute();
            $iNumRowsLang = $hResult->rowCount();

            if ($iNumRowsBasis == 1 && $iNumRowsLang == 0) {
                $iGID = filter_var($_REQUEST['gid'], FILTER_SANITIZE_NUMBER_INT);
                $aData = [
                    'itmgt_pid' => $iGID,
                    'itmgt_lang' => HelperConfig::$lang,
                ];
                $sql = DBTools::buildPSInsertQuery($aData, 'itemgroups_text');
                $hResult = $this->db->prepare($sql);
                foreach ($aData as $sKey => $sValue) {
                    $hResult->bindValue(':'.$sKey, $sValue);
                }
                $hResult->execute();
                \HaaseIT\HCSF\Helper::redirectToPage('/_admin/itemgroupadmin.html?gid='.$iGID.'&action=editgroup');
            }
        }

        if (isset($_REQUEST['action']) && $_REQUEST['action'] === 'editgroup') {
            if (isset($_REQUEST['do']) && $_REQUEST['do'] === 'true') {
                $this->P->cb_customdata['updatestatus'] = $this->admin_updateGroup(\HaaseIT\HCSF\Helper::getPurifier('itemgroup'));
            }

            $iGID = filter_var($_REQUEST['gid'], FILTER_SANITIZE_NUMBER_INT);
            $aGroup = $this->admin_getItemgroups($iGID);
            if (isset($_REQUEST['added'])) {
                $this->P->cb_customdata['groupjustadded'] = true;
            }
            $this->P->cb_customdata['showform'] = 'edit';
            $this->P->cb_customdata['group'] = $this->admin_prepareGroup('edit', $aGroup[0]);
        } elseif (isset($_REQUEST['action']) && $_REQUEST['action'] === 'addgroup') {
            $aErr = [];
            if (isset($_REQUEST['do']) && $_REQUEST['do'] === 'true') {
                $sName = filter_var($_REQUEST['name'], FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW);
                $sGNo = filter_var($_REQUEST['no'], FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW);
                $sImg = filter_var($_REQUEST['img'], FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW);

                if (strlen($sName) < 3) {
                    $aErr['nametooshort'] = true;
                }
                if (strlen($sGNo) < 3) {
                    $aErr['grouptooshort'] = true;
                }
                if (count($aErr) == 0) {
                    $sql = 'SELECT itmg_no FROM itemgroups_base WHERE itmg_no = :no';
                    $hResult = $this->db->prepare($sql);
                    $hResult->bindValue(':no', $sGNo);
                    $hResult->execute();
                    if ($hResult->rowCount() > 0) {
                        $aErr['duplicateno'] = true;
                    }
                }
                if (count($aErr) == 0) {
                    $aData = [
                        'itmg_name' => $sName,
                        'itmg_no' => $sGNo,
                        'itmg_img' => $sImg,
                    ];
                    $sql = DBTools::buildPSInsertQuery($aData, 'itemgroups_base');
                    $hResult = $this->db->prepare($sql);
                    foreach ($aData as $sKey => $sValue) {
                        $hResult->bindValue(':'.$sKey, $sValue);
                    }
                    $hResult->execute();
                    $iLastInsertID = $this->db->lastInsertId();
                    \HaaseIT\HCSF\Helper::redirectToPage('/_admin/itemgroupadmin.html?action=editgroup&added&gid='.$iLastInsertID));
                } else {
                    $this->P->cb_customdata['err'] = $aErr;
                    $this->P->cb_customdata['showform'] = 'add';
                    $this->P->cb_customdata['group'] = $this->admin_prepareGroup('add');
                }
            } else {
                $this->P->cb_customdata['showform'] = 'add';
                $this->P->cb_customdata['group'] = $this->admin_prepareGroup('add');
            }
        } else {
            if (!$return .= $this->admin_showItemgroups($this->admin_getItemgroups(''))) {
                $this->P->cb_customdata['err']['nogroupsavaliable'] = true;
            }
        }
        $this->P->oPayload->cl_html = $return;
    }

    /**
     * @param $purifier
     * @return string
     */
    private function admin_updateGroup( $purifier)
    {
        $sql = 'SELECT * FROM itemgroups_base WHERE itmg_id != :id AND itmg_no = :gno';
        $hResult = $this->db->prepare($sql);
        $iGID = filter_var($_REQUEST['gid'], FILTER_SANITIZE_NUMBER_INT);
        $sGNo = filter_var($_REQUEST['no'], FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW);
        $hResult->bindValue(':id', $iGID);
        $hResult->bindValue(':gno', $sGNo);
        $hResult->execute();
        $iNumRows = $hResult->rowCount();

        if ($iNumRows > 0) {
            return 'duplicateno';
        }

        $aData = [
            'itmg_name' => filter_var($_REQUEST['name'], FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW),
            'itmg_no' => $sGNo,
            'itmg_img' => filter_var($_REQUEST['img'], FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW),
            'itmg_id'=> $iGID,
        ];

        $sql = DBTools::buildPSUpdateQuery($aData, 'itemgroups_base', 'itmg_id');
        $hResult = $this->db->prepare($sql);
        foreach ($aData as $sKey => $sValue) {
            $hResult->bindValue(':' . $sKey, $sValue);
        }
        $hResult->execute();

        $sql = 'SELECT itmgt_id FROM itemgroups_text WHERE itmgt_pid = :gid AND itmgt_lang = :lang';
        $hResult = $this->db->prepare($sql);
        $hResult->bindValue(':gid', $iGID);
        $hResult->bindValue(':lang', HelperConfig::$lang, \PDO::PARAM_STR);
        $hResult->execute();

        $iNumRows = $hResult->rowCount();

        if ($iNumRows == 1) {
            $aRow = $hResult->fetch();
            $aData = [
                'itmgt_shorttext' => $purifier->purify($_REQUEST['shorttext']),
                'itmgt_details' => $purifier->purify($_REQUEST['details']),
                'itmgt_id' => $aRow['itmgt_id'],
            ];
            $sql = DBTools::buildPSUpdateQuery($aData, 'itemgroups_text', 'itmgt_id');
            $hResult = $this->db->prepare($sql);
            foreach ($aData as $sKey => $sValue) {
                $hResult->bindValue(':' . $sKey, $sValue);
            }
            $hResult->execute();
        }

        return 'success';
    }

    /**
     * @param string $sPurpose
     * @param array $aData
     * @return array
     */
    private function admin_prepareGroup($sPurpose = 'none', $aData = [])
    {
        $aGData = [
            'formaction' => Tools::makeLinkHRefWithAddedGetVars('/_admin/itemgroupadmin.html'),
            'id' => isset($aData['itmg_id']) ? $aData['itmg_id'] : '',
            'name' => isset($aData['itmg_name']) ? $aData['itmg_name'] : '',
            'no' => isset($aData['itmg_no']) ? $aData['itmg_no'] : '',
            'img' => isset($aData['itmg_img']) ? $aData['itmg_img'] : '',
        ];

        if ($sPurpose === 'edit') {
            if ($aData['itmgt_id'] != '') {
                $aGData['lang'] = [
                    'shorttext' => isset($aData['itmgt_shorttext']) ? $aData['itmgt_shorttext'] : '',
                    'details' => isset($aData['itmgt_details']) ? $aData['itmgt_details'] : '',
                ];
            }
        }

        return $aGData;
    }

    /**
     * @param string $iGID
     * @return mixed
     */
    private function admin_getItemgroups($iGID = '')
    {
        $sql = 'SELECT * FROM itemgroups_base '
            . 'LEFT OUTER JOIN itemgroups_text ON itemgroups_base.itmg_id = itemgroups_text.itmgt_pid'
            . ' AND itemgroups_text.itmgt_lang = :lang';
        if ($iGID != '') {
            $sql .= ' WHERE itmg_id = :gid';
        }
        $sql .= ' ORDER BY itmg_no';
        $hResult = $this->db->prepare($sql);
        $hResult->bindValue(':lang', HelperConfig::$lang);
        if ($iGID != '') {
            $hResult->bindValue(':gid', $iGID);
        }
        $hResult->execute();

        return $hResult->fetchAll();
    }

    /**
     * @param $aGroups
     * @return bool|mixed
     */
    private function admin_showItemgroups($aGroups)
    {
        $aList = [
            ['title' => HardcodedText::get('itemgroupadmin_list_no'), 'key' => 'gno', 'width' => 80, 'linked' => false, 'style-data' => 'padding: 5px 0;'],
            ['title' => HardcodedText::get('itemgroupadmin_list_name'), 'key' => 'gname', 'width' => 350, 'linked' => false, 'style-data' => 'padding: 5px 0;'],
            ['title' => HardcodedText::get('itemgroupadmin_list_edit'), 'key' => 'gid', 'width' => 30, 'linked' => true, 'ltarget' => '/_admin/itemgroupadmin.html', 'lkeyname' => 'gid', 'lgetvars' => ['action' => 'editgroup'], 'style-data' => 'padding: 5px 0;'],
        ];
        if (count($aGroups) > 0) {
            $aData = [];
            foreach ($aGroups as $aValue) {
                $aData[] = [
                    'gid' => $aValue['itmg_id'],
                    'gno' => $aValue['itmg_no'],
                    'gname' => $aValue['itmg_name'],
                ];
            }
            return Tools::makeListtable($aList, $aData, $this->serviceManager->get('twig'));
        } else {
            return false;
        }
    }
}