Subversion-Projekte lars-tiefland.laravel_shop

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

use Spatie\Sluggable\HasSlug;

use Spatie\Sluggable\SlugOptions;

class Directory extends Model

{

    use HasFactory, HasSlug;

    /**

     * Get the options for generating the slug.

     */

    public function getSlugOptions(): SlugOptions

    {

        return SlugOptions::create()

            ->generateSlugsFrom('name')

            ->saveSlugsTo('slug')

            ->usingLanguage('de')

            ->doNotGenerateSlugsOnUpdate()

            ->skipGenerateWhen(fn() => $this->id < 0);

    }

    public function navigation($root, $override = false, $rootInfo = false, $cnt = 0)

    {

        if (!isset($GLOBALS["count"][__function__ . "_" . $root])) {

            $GLOBALS["count"][__function__ . "_" . $root] = 0;

            $GLOBALS["zeit"][__function__ . "_" . $root] = 0;

        }

        $GLOBALS["count"][__function__ . "_" . $root]++;

        $time = microtime(true);

        $showArtikelstamm = false;

        if (isset($GLOBALS["INI"]["Navigation"]["showArtikelstamm"])) {

            $showArtikelstamm = true;

        }

        $treebuffer = $this->where("directory_id", "=", $root)->get();

        if (is_array($treebuffer) && is_array($linkDirs)) {

            $treebuffer = array_merge($treebuffer, $linkDirs);

        }

        $treebufferCount = 0;

        if (is_countable($treebuffer)) {

            $treebufferCount = count($treebuffer) - 1;

        }

        $i = 0;

        if (is_array($treebuffer)) {

            foreach ($treebuffer as $counter => $zeile) {

                $k = $i % 2;

                $i++;

                /* ######################################################################## */ /* Link entsprechend der Alias-Definition generieren.                        */

                /* ######################################################################## */

                if ($GLOBALS["INI"]['alias'] == 0) {

                    // dirLink

                    //$zeile['dirLink']=$GLOBALS["INI"]["absoluteURL"]."/?navigation=".$zeile['ID'];

                    $zeile['dirLink'] = "/?navigation=" . $zeile['ID'];

                } else {

                    // Pfad ermitteln

                    $buffer = array();

                    $path = getPath_New($zeile['ID']);

                    foreach ($path as $elem) {

                        //Muss hier gemacht werden, weil durch die UTF8 Kodierung die Umlaute für die str2url funktion nicht richtig übergeben werden

                        //Wenn man hier die Dateikodierung ändert funktioniert es auch nicht weil der Shop UTF8 ist

                        $name = $elem['Name'];

                        $umlaute = array(

                            "Ä",

                            "ä",

                            "Ö",

                            "ö",

                            "Ü",

                            "ü",

                        );

                        $umlauteErsetzen = array(

                            "Ae",

                            "ae",

                            "Oe",

                            "oe",

                            "Üe",

                            "ue",

                        );

                        $name = str_replace($umlaute, $umlauteErsetzen, $name);

                        //$buffer[]=preg_replace("/[\W]+/", "", $elem['ID']."_".$elem['Name']);

                        $buffer[] = $elem['ID'] . "-" . str2url($name);

                    }

                    // dirLink

                    //$zeile['dirLink']=$GLOBALS["INI"]["absoluteURL"]."/".implode("/",$buffer)."/";

                    $zeile['dirLink'] = "/" . implode("/", $buffer) . "/";

                }

                /* ######################################################################## */ /* Ausgabe der Unterverzeichnisse                                            */ /* ######################################################################## */

                // Container-Kopf

                $_SESSION['navigation']['nav-zebra'] = $k;

                $subdirs = $this->where("direcotry_id", "=", $zeile["ID"])->get();

                $nav["sub"][] = array(

                    "id" => $zeile["ID"],

                    "link" => $zeile['dirLink'],

                    "name" => $zeile["Name"],

                    "sub2" => $subdirs,

                );

            }

        }

        $anzahl_spalten = 3;

        if (is_numeric($GLOBALS["INI"]["navigation"]["anzahl_spalten"])) {

            $anzahl_spalten = $GLOBALS["INI"]["navigation"]["anzahl_spalten"];

        }

        if (is_array($nav["sub"])) {

            $nav["sub"]['elemsPerRow'] = floor(count($nav["sub"]) / $anzahl_spalten);

            $nav["sub"]['elemsPerRowRest'] = count($treebuffer) - ($nav["sub"]['elemsPerRow'] * $anzahl_spalten);

        }

        $time2 = microtime(true);

        $diff = $time2 - $time;

        $GLOBALS["zeit"][__function__ . "_" . $root] += $diff;

        return $nav;

    }

    /**

     * Wenn in der Config der Wert 'showNavigation' in der Kategorie 'Navigation' gleich "1" ist,

     * dann zeige die Navigation an.

     */

    public function nav_menu($father = -1)

    {

        $navigation = null;

        if (!isset($GLOBALS["count"][__function__ . "_" . $father])) {

            $GLOBALS["count"][__function__ . "_" . $father] = 0;

            $GLOBALS["zeit"][__function__ . "_" . $father] = 0;

        }

        $GLOBALS["count"][__function__ . "_" . $father]++;

        $time = microtime(true);

        if ($GLOBALS['INI']['navigation']['cache_type'] == "2") {

            $fName = $_SERVER["DOCUMENT_ROOT"] . "/menu_serialized.txt";

            if (isset($GLOBALS["INI"]["treeRootMainNav"]) && $father == $GLOBALS["INI"]["treeRootMainNav"]) {

                $fName = $_SERVER["DOCUMENT_ROOT"] . "/mainnav_serialized.txt";

            }

            if (isset($GLOBALS["INI"]["treeRooSecondNav"]) && $father == $GLOBALS["INI"]["treeRootSecondNav"]) {

                $fName = $_SERVER["DOCUMENT_ROOT"] . "/secondnav_serialized.txt";

            }

            if (file_exists($fName)) {

                $content = file_get_contents($fName);

                $navigation = unserialize($content);

            }

        } elseif ($GLOBALS["INI"]["navigation"]["cache_type"] == "1") {

            $fName = $_SERVER["DOCUMENT_ROOT"] . "/menu.xml";

            if (file_exists($fName)) {

                $confArr = array(

                    "root" => "menu",

                    "encoding" => "UTF-8",

                );

                $nav = new Config();

                $nav = $nav->parseConfig($fName, "XML", $confArr);

                $nav = $nav->toArray();

                $navigation = $nav["root"];

            }

        }

        if (!$navigation) {

            $navigation = $this->getMenuFromDB($father);

        }

        $time2 = microtime(true);

        $diff = $time2 - $time;

        $GLOBALS["zeit"][__function__ . "_" . $father] += $diff;

        return $navigation;

    }

    private function getMenuFromDB($father)

    {

        if (!isset($GLOBALS["count"][__function__ . "_" . $father])) {

            $GLOBALS["count"][__function__ . "_" . $father] = 0;

            $GLOBALS["zeit"][__function__ . "_" . $father] = 0;

        }

        $GLOBALS["count"][__function__ . "_" . $father]++;

        $navigation = array();

        $time = microtime(true);

        $order_by = "kennung, name";

        $sql_erw = "AND artikelstamm = 0";

        if (isset($GLOBALS['INI']['navigation']['order_by'])) {

            $order_by = $GLOBALS['INI']['navigation']['order_by'];

        }

        //Sollen Artikelstämme in der Navigation rauskommen, dann hole auch Artikelstämme

        if (isset($GLOBALS["INI"]["Navigation"]["showArtikelstamm"])) {

            $sql_erw = "";

        }

        if (isset($GLOBALS["INI"]["navigation"]["sqlErweiterung"])) {

            $sql_erw .= " " . $GLOBALS["INI"]["navigation"]["sqlErweiterung"];

        }

        $sel = "";

        //if ( !$_SESSION['mainNavigation'] )

        {

            /*$sql = 'SELECT

                    id,

                    name,

                    status,

                    slug,

                    url,

                    description,

                    short_line_1

                    ' . $sel . '

                FROM

                    directory

                WHERE

                    directory_id = ' . $father . '

                    ' . $sql_erw . '

                ORDER BY

                    ' . $order_by . '

            ';

            if ( $result = $GLOBALS["shopDB"]->query( $sql ) )

            {

                while ( $row = $result->fetch_assoc() )

                {

                    $row["medien"] = directory_medien::liste( $row["id"] );

                    if ( $row["status"] == 99 )

                    {

                        $row["dirLink"] = $row["url"];

                    }

                    else

                    {

                        $row["dirLink"] = "/" . $row['id'] . "-" . $row['slug'] . "/";

                    }

                    $topLvl_arr[] = $row;

                    $topLvl = $row["id"];

                    //$specialItems['specialItems'][$row['id']] = getItems( $row['id'] );

                }

                if ( is_array( $specialItems ) )

                {

                    $GLOBALS["ui"]->assign( "specialItems", $specialItems );

                }

            }

            else

            {

                admin_debug( $GLOBALS["shopDB"]->error . "<br>" . $sql );

            }

            $_SESSION['Fathers'] = @implode( ",", $topLvl );

            $cnt = 0;

            if ( is_array( $topLvl_arr ) )

            {

                foreach ( $topLvl_arr as $elem )

                {

                    $navigation[ $cnt ]["top"][] = array(

                        "id"           => $elem["id"],

                        "name"         => $elem["name"],

                        "dirLink"      => $elem["dirLink"],

                        "beschreibung" => $elem["Beschreibung"],

                        "medien"       => $elem["medien"],

                        "specialItem"  => $elem["specialItem"],

                        "short_line_1" => $elem["short_line_1"],

                    );

                    if ( $elem['Alternativer_Titel'] )

                    {

                        $navigation[ $cnt ]["top"][0]["Alternativer_Titel"] = $elem['Alternativer_Titel'];

                    }

                    if ( !( $_REQUEST["buy"] == true || $_REQUEST["basket"] == true ) )

                    {

                        $nav = $this->navigation( $elem["id"], false, true, $cnt );

                        $navigation[ $cnt ]["sub"] = $nav["sub"];

                    }

                    $cnt++;

                }

	    }*/

        }

        $dirs = self::with('directory')->whereIn("status", [0, 2, 99])->where("directory_id", "=", $father)->get();

        foreach ($dirs as $cnt => $dir) {

            $navigation[$cnt]["top"][] = array("id" => $dir["id"], "name" => $dir["name"], "dirLink" => $dir["slug"], "beschreibung" => $dir["description"],);

        }

        $time2 = microtime(true);

        $diff = $time2 - $time;

        $GLOBALS["zeit"][__function__ . "_" . $father] += $diff;

        return $navigation;

    }

    public function directory()

    {

        return $this->belongsTo(Directory::class);

    }

}