HaaseIT / HCSF

     * @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();

        $aGroups = $hResult->fetchAll();

        return $aGroups;

    }

    /**

     * @param $aGroups

     * @param string $iGID

     * @return mixed

     */

    private function admin_getItemgroups($iGID = '') // this function should be outsourced, a duplicate is used in admin itemgroups!

    {

        $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();

    }

}