Subversion-Projekte lars-tiefland.laravel_shop

Revision

Revision 857 | Revision 864 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 857 Revision 862
Zeile 2... Zeile 2...
2 
 
 2 
 
Zeile 3... Zeile 3...
3 
    namespace App\Http\Controllers;
 3 
    namespace App\Http\Controllers;
4 
 
 4 
 
- 
 
 5 
    use App\Models\Item as ItemAlias;
Zeile 5... Zeile 6...
5 
    use App\Models\Item as ItemAlias;
 6 
    use App\Http\Controllers\ShippingController;
6 
    use App\Http\Controllers\ShippingController;
 7 
    use function Termwind\renderUsing;
7 
 
 8 
 
8 
    class BasketController extends Controller
 9 
    class BasketController extends Controller
Zeile 239... Zeile 240...
239 
        private function getShipmentCosts()
 240 
        private function getShipmentCosts()
240 
        {
 241 
        {
241 
            $sc = new ShippingController();
 242 
            $sc = new ShippingController();
242 
            $buffer = $sc->getShippingOptions();
 243 
            $buffer = $sc->getShippingOptions();
243 
            $_SESSION["SHOP"]["BASKET"]->shipmentCosts = $buffer;
 244 
            $_SESSION["SHOP"]["BASKET"]->shipmentCosts = $buffer;
- 
 
 245 
            $this->getShippingCountries();
244 
        }
 246 
        }
Zeile 245... Zeile 247...
245 
 
 247 
 
246 
        public function getBasketGewicht(): void
 248 
        public function getBasketGewicht(): void
247 
        {
 249 
        {
Zeile 250... Zeile 252...
250 
            {
 252 
            {
251 
                $gewicht += $item->menge * $item->weight;
 253 
                $gewicht += $item->menge * $item->weight;
252 
            }
 254 
            }
253 
            $_SESSION["SHOP"]["BASKET"]->weight = $gewicht;
 255 
            $_SESSION["SHOP"]["BASKET"]->weight = $gewicht;
254 
        }
 256 
        }
- 
 
 257 
 
- 
 
 258 
        public function getShippingCountries()
- 
 
 259 
        {
- 
 
 260 
            $rLaender = getRechnungsLaender();
- 
 
 261 
            $laender = $rLaender;
- 
 
 262 
            if ( $_SESSION["SHOP"]["BASKET"]->items )
- 
 
 263 
            {
- 
 
 264 
                foreach ( $_SESSION["SHOP"]["BASKET"]->items as $artikel )
- 
 
 265 
                {
- 
 
 266 
                    if ( !$artikel->shipping_group_id )
- 
 
 267 
                    {
- 
 
 268 
                        $artikel->shipping_group_id = 1;
- 
 
 269 
                    }
- 
 
 270 
                    $vgruppen[] = $artikel->shipping_group_id;
- 
 
 271 
                }
- 
 
 272 
                $vgruppen = array_unique( $vgruppen );
- 
 
 273 
                $sql = "SELECT
- 
 
 274 
                        MAX(rang) AS rang
- 
 
 275 
                    FROM
- 
 
 276 
                        versandgruppen
- 
 
 277 
                    WHERE
- 
 
 278 
                        id IN(" . implode( ",", $vgruppen ) . ")
- 
 
 279 
                ";
- 
 
 280 
                $r = DB::select( $sql );
- 
 
 281 
                $row = $r[0];
- 
 
 282 
                $rang = $row->rank;
- 
 
 283 
                $sql = "SELECT
- 
 
 284 
                        id
- 
 
 285 
                    FROM
- 
 
 286 
                        versandgruppen
- 
 
 287 
                    WHERE
- 
 
 288 
                        rang=" . $rang . "
- 
 
 289 
                ";
- 
 
 290 
                $res = $GLOBALS["shopDB"]->query( $sql );
- 
 
 291 
                $row = $res->fetch_assoc();
- 
 
 292 
                $vgId = $row["id"];
- 
 
 293 
            }
- 
 
 294 
            if ( $vgId )
- 
 
 295 
            {
- 
 
 296 
                $sql = "SELECT DISTINCT
- 
 
 297 
                        country_id
- 
 
 298 
                    FROM
- 
 
 299 
                        shipping_countries vl
- 
 
 300 
                    JOIN
- 
 
 301 
                        shippings v
- 
 
 302 
                    ON
- 
 
 303 
                        v.shipping_group_id=" . $vgId . "
- 
 
 304 
                    AND
- 
 
 305 
                        v.id=vl.shipping_id
- 
 
 306 
                ";
- 
 
 307 
            }
- 
 
 308 
            else
- 
 
 309 
            {
- 
 
 310 
                $sql = "SELECT DISTINCT
- 
 
 311 
                        country_id
- 
 
 312 
                    FROM
- 
 
 313 
                        shipping_countries
- 
 
 314 
                ";
- 
 
 315 
            }
- 
 
 316 
            $res = $GLOBALS["shopDB"]->query( $sql );
- 
 
 317 
            $vLaender = array();
- 
 
 318 
            while ( $row = $res->fetch_assoc() )
- 
 
 319 
            {
- 
 
 320 
                $sql = "SELECT
- 
 
 321 
                        id,
- 
 
 322 
                        `name-ger`
- 
 
 323 
                    FROM
- 
 
 324 
                        countries
- 
 
 325 
                    WHERE
- 
 
 326 
                        id=" . $row["country_id"] . "
- 
 
 327 
                ";
- 
 
 328 
                $resC = DB::select( $sql );
- 
 
 329 
                $rowC = $resC[0];
- 
 
 330 
                $land_name = $rowC->name_de;
- 
 
 331 
                $vLaender[$rowC->id] = $land_name;
- 
 
 332 
            }
- 
 
 333 
            foreach ( $rLaender as $landId => $landName )
- 
 
 334 
            {
- 
 
 335 
                if ( !in_array( $landName, $vLaender ) )
- 
 
 336 
                {
- 
 
 337 
                    unset( $laender[$landId] );
- 
 
 338 
                }
- 
 
 339 
            }
- 
 
 340 
            $_SESSION["SHOP"]["BASKET"]->shippingCountries = $laender;
- 
 
 341 
        }
- 
 
 342 
 
255 
    }
 343 
    }