WebSVN – lars-tiefland.laravel_shop – Diff – /trunk/app/Http/Controllers/ShippingController.php

     use Illuminate\Http\Request;
     use Illuminate\Support\Facades\DB;
     class ShippingController extends Controller
     {
-        public function getShippingOptions(): array
+        public function getShippingOptions( ?int $Land = 47 ): array
-        {
             $Land = 47;
             $buffer = array();
             $rufnamen = array();
             $sql = "SELECT
                     z.id,
                     return true;
                 }*/
                 $sql = "SELECT
-                            z.id,
+                        z.id,
-                            z.name,
+                        z.name,
-                            z.internal_name,
+                        z.internal_name,
-                            z.discount,
+                        z.discount,
-                            z.shipping_text AS versandtextbaustein,
+                        z.shipping_text AS versandtextbaustein,
-                            z.info_in_shop
+                        z.info_in_shop
-                        FROM
+                    FROM
-                            shipping_payment_methods vz
+                        shipping_payment_methods vz
-                        JOIN
+                    JOIN
-                            payment_methods z
+                        payment_methods z
-                        ON
+                    ON
-                            z.id=vz.payment_method_id
+                        z.id=vz.payment_method_id
-                        WHERE
+                    WHERE
-                            shipping_id IN (" . implode( ",", $shippingIds ) . ")
+                        shipping_id IN (" . implode( ",", $shippingIds ) . ")
-                    ";
+                ";
                 if ( isset( $_GET['vRufname'] ) && is_numeric( $_GET['vRufname'] ) )
+                {
                     $sql .= " AND z.id = " . $_GET['vRufname'];
                 foreach ( $res as $vRow )
+                {
                     $vgId = $vRow->shipping_group_id;
                     $sql = "SELECT
                             z.name,
-			    z.internal_name,
+                            z.internal_name,
-			    z.info_in_shop,
+                            z.info_in_shop,
                             z.discount,
                             z.shipping_text AS versand_textbaustein
                         FROM
                             payment_methods z
                         JOIN

Subversion-Projekte lars-tiefland.laravel_shop

(root)/trunk/app/Http/Controllers/ShippingController.php – Revision 872 → 873