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



<?php

 

    namespace App\Http\Controllers;
 

    use Illuminate\Http\Request;
    use Illuminate\Support\Facades\DB;
 
    class ShippingController extends Controller
    {
        public function getShippingOptions()
        {
            $Land = 47;
            $buffer = array();
            $rufnamen = array();
            $sql = "SELECT

                JOIN
                    shipping_payment_methods vz
                ON
                    vz.payment_method_id=z.id  
            ";
            $r = DB::connection( 'mysql' )->select( $sql );
            $rufnamen[] = "- Bezahlarten -";
            foreach ( $r as $row )
            {
                $ini_name = $row->internal_name;
                if ( $row->internal_name == "sofortueberweisung" )
                {
                    $ini_name = "ueberweisung";
                }
                if ( !isset( $_SESSION["zahlarten"][$ini_name] ) )
                {
                    $_SESSION["zahlarten"][$ini_name] = true;
                }
                if ( ( $GLOBALS["INI"][$ini_name]["aktiv"] == 1 && $_SESSION["zahlarten"][$ini_name] !== false ) || !in_array( $row->internal_name, $GLOBALS["zahlsysteme"] ) )
                {
                    $rufnamen[$row->id] = $row->internal_name;
                }
            }
            if ( $_SESSION["SHOP"]["BASKET"]->items )
            {
                $vgruppen = array();
                $preis = $_SESSION["SHOP"]["BASKET"]->paymentInfo["Total"];
                $gewicht = $_SESSION["SHOP"]["BASKET"]->getBasketGewicht();
                foreach ( $_SESSION["SHOP"]["BASKET"]->items as $artikel )
                {
                    if ( $artikel->spedId )
                    {
                        $vgruppen[] = $artikel->spedId;
                    }

                    AND
                        country_id=" . $Land . "
                ";
                if ( isset( $_SESSION["SHOP"]["vIsland"] ) && $_SESSION["SHOP"]["vIsland"] )
                {
                    //Insel ausgewählt ==> Versandoption darf NICHT auf "kein Inselversand" (Wert: 1) stehen!
                    $sqlCondArr [] = " island_shipping IN (0,2) ";
                }
                else
                {
                    $sqlCondArr [] = " island_shipping IN (0,1) ";

                        AND
                            " . $sqlCond . "
                    ";
                }
                $vR = DB::select( $sql );
                if ( !count( $vR ) )
                {
                    $_SESSION["versandFehler"] = "Wir versenden NICHT an diese Adresse! Bitte geben Sie eine andere Adresse ein!";
                }
                foreach ( $vR as $vRow )
                {

 
                    if ( $param == "single" )
                    {

                    if ( ( $_GET['vRufname'] ) && is_numeric( $_GET['vRufname'] ) )
                    {
                        $sql .= " AND z.id = " . $_GET['vRufname'];
                    }
                    $zR = DB::select( $sql );
                    foreach ( $zR as $zRow )
                    {
                        if ( $zRow->internal_name != "nicht_belegt" )
                        {
                            $ini_name = $zRow->internal_name;
                            if ( $ini_name == "sofortueberweisung" )

                            }
                            if ( $GLOBALS["INI"]["PayPalPlus"]["aktiv"] != 1 )
                            {
                                $row["beschr"] = ( str_replace( "\r\n", "<br>", $row["beschr"] ) );
                            }
                            if ( ( $GLOBALS["INI"][$ini_name]["aktiv"] == 1 && $_SESSION["zahlarten"][$ini_name] !== false ) || !in_array( $zRow->internal_name, $GLOBALS["zahlsysteme"] ) )
                            {
                                $preis = $vRow->price;
                                $name = $vRow->name . " - " . $zRow->name;
                                if ( $_SESSION["SHOP"]["Lieferadresse"] == "abholung" )
                                {

                                }
                                if ( $vRow->info_mail )
                                {
                                    $beschreibung2 .= $vRow->info_mail;
                                }
                                $buffer[$zRow->internal_name . "_" . $vRow->id] = array(
                                    "zusaetze"         => $vRow->zusaetze,
                                    "ID"               => $zRow->internal_name . "_" . $vRow->id,
                                    "beschreibung"     => $beschreibung,
                                    "beschreibung2"    => $beschreibung2,
                                    "kurz"             => $name,

                                WHERE
                                    id=" . $zId . "
                            ";
                            $res = DB::select( $sql );
                            $row = $res[0];
                            $zusaetze[$zId] = $row->beschreibung;
                        }
                    }
                }
            }
            else

                        vl.shipping_id=v.id    
                    WHERE
                        country_id=" . $Land . "
                ";
                $res = DB::select( $sql );
                foreach ( $res as $vRow )
                {
                    $vgId = $vRow->versandgruppen_id;
                    $sql = "SELECT
                            z.name,
                            z.internal_name

                    if ( ( $_GET['vRufname'] ) && is_numeric( $_GET['vRufname'] ) )
                    {
                        $sql .= " AND z.id = " . $_GET['vRufname'];
                    }
                    $resZ = DB::select( $sql );
                    foreach ( $resZ as $vzRow )
                    {
                        if ( $vzRow->internal_name != "nicht_belegt" )
                        {
                            $ini_name = $vzRow->internal_name;
                            if ( $ini_name == "sofortueberweisung" )

                            }
                            if ( $GLOBALS["INI"]["PayPalPlus"]["aktiv"] != 1 )
                            {
                                $row["beschr"] = ( str_replace( "\r\n", "<br>", $row["beschr"] ) );
                            }
                            if ( ( $GLOBALS["INI"][$ini_name]["aktiv"] == 1 && $_SESSION["zahlarten"][$ini_name] !== false ) || !in_array( $vzRow->internal_name, $GLOBALS["zahlsysteme"] ) )
                            {
                                $preis = $vRow->price;
                                $name = $vRow->name . " - " . $vzRow->name;
                                if ( $_SESSION["SHOP"]["Lieferadresse"] == "abholung" )
                                {

                                }
                                if ( $vRow->info_mail )
                                {
                                    $beschreibung2 .= $vRow->info_mail;
                                }
                                $buffer[$vzRow->internal_name . "_" . $vRow->id] = array(
                                    "zusaetze"             => $vRow->zusaetze,
                                    "ID"                   => $vzRow->internal_name . "_" . $vRow->id,
                                    "beschreibung"         => $beschreibung,
                                    "beschreibung2"        => $beschreibung2,
                                    "kurz"                 => $name,

                        }
                    }
                }
                ksort( $buffer );
            }
            return $buffer;
        }
    }

Revision 817	Revision 829
Zeile 1...	Zeile 1...
1	`<?php`	1	`<?php`
Zeile 2...	Zeile 2...
2		2
Zeile 3...	Zeile 3...
3	`namespace App\Http\Controllers;`	3	`namespace App\Http\Controllers;`
4		4
Zeile 5...	Zeile 5...
5	`use Illuminate\Http\Request;`	5	`use Illuminate\Http\Request;`
6	`use Illuminate\Support\Facades\DB;`	6	`use Illuminate\Support\Facades\DB;`
7		7
8	`class ShippingController extends Controller`	8	`class ShippingController extends Controller`
9	`{`	9	`{`
10	`public function getShippingOptions()`	10	`public function getShippingOptions()`
11	`{`	11	`{`
12	`$Land = 47;`	12	`$Land = 47;`
13	`$buffer = array();`	13	`$buffer = array();`
14	`$rufnamen = array();`	14	`$rufnamen = array();`
15	`$sql = "SELECT`	15	`$sql = "SELECT`
Zeile 20...	Zeile 20...
20	`JOIN`	20	`JOIN`
21	`shipping_payment_methods vz`	21	`shipping_payment_methods vz`
22	`ON`	22	`ON`
23	`vz.payment_method_id=z.id`	23	`vz.payment_method_id=z.id`
24	`";`	24	`";`
25	`$r = DB::connection('mysql')->select($sql);`	25	`$r = DB::connection( 'mysql' )->select( $sql );`
26	`$rufnamen[] = "- Bezahlarten -";`	26	`$rufnamen[] = "- Bezahlarten -";`
27	`foreach( $r as $row )`	27	`foreach ( $r as $row )`
28	`{`	28	`{`
29	`$ini_name = $row->internal_name;`	29	`$ini_name = $row->internal_name;`
30	`if ( $row->internal_name == "sofortueberweisung" )`	30	`if ( $row->internal_name == "sofortueberweisung" )`
31	`{`	31	`{`
32	`$ini_name = "ueberweisung";`	32	`$ini_name = "ueberweisung";`
33	`}`	33	`}`
34	`if ( !isset( $_SESSION["zahlarten"][ $ini_name ] ) )`	34	`if ( !isset( $_SESSION["zahlarten"][$ini_name] ) )`
35	`{`	35	`{`
36	`$_SESSION["zahlarten"][ $ini_name ] = true;`	36	`$_SESSION["zahlarten"][$ini_name] = true;`
37	`}`	37	`}`
38	`if ( ( $GLOBALS["INI"][ $ini_name ]["aktiv"] == 1 && $_SESSION["zahlarten"][ $ini_name ] !== false ) \|\| !in_array( $row->internal_name, $GLOBALS["zahlsysteme"] ) )`	38	`if ( ( $GLOBALS["INI"][$ini_name]["aktiv"] == 1 && $_SESSION["zahlarten"][$ini_name] !== false ) \|\| !in_array( $row->internal_name, $GLOBALS["zahlsysteme"] ) )`
39	`{`	39	`{`
40	`$rufnamen[ $row->id ] = $row->internal_name;`	40	`$rufnamen[$row->id] = $row->internal_name;`
41	`}`	41	`}`
42	`}`	42	`}`
43	`if ( $_SESSION["SHOP"]["BASKET"]->items )`	43	`if ( $_SESSION["SHOP"]["BASKET"]->items )`
44	`{`	44	`{`
45	`$vgruppen = array();`	45	`$vgruppen = array();`
46	`$preis = $_SESSION["SHOP"]["BASKET"]->paymentInfo["Total"];`	46	`$preis = $_SESSION["SHOP"]["BASKET"]->paymentInfo["Total"];`
47	`$gewicht = $_SESSION["SHOP"]["BASKET"]->getBasketGewicht();`	47	`$gewicht = $_SESSION["SHOP"]["BASKET"]->getBasketGewicht();`
48	`foreach ( $_SESSION["SHOP"]["BASKET"]->items as $bId => $artikel )`	48	`foreach ( $_SESSION["SHOP"]["BASKET"]->items as $artikel )`
49	`{`	49	`{`
50	`if ( $artikel->spedId )`	50	`if ( $artikel->spedId )`
51	`{`	51	`{`
52	`$vgruppen[] = $artikel->spedId;`	52	`$vgruppen[] = $artikel->spedId;`
53	`}`	53	`}`
Zeile 106...	Zeile 106...
106	`AND`	106	`AND`
107	`country_id=" . $Land . "`	107	`country_id=" . $Land . "`
108	`";`	108	`";`
109	`if ( isset( $_SESSION["SHOP"]["vIsland"] ) && $_SESSION["SHOP"]["vIsland"] )`	109	`if ( isset( $_SESSION["SHOP"]["vIsland"] ) && $_SESSION["SHOP"]["vIsland"] )`
110	`{`	110	`{`
111	`//Insel ausgewählt ==> Versandoption darf NICHT auf "kein Inselversand (Wert: 1) stehen!`	111	`//Insel ausgewählt ==> Versandoption darf NICHT auf "kein Inselversand" (Wert: 1) stehen!`
112	`$sqlCondArr [] = " island_shipping IN (0,2) ";`	112	`$sqlCondArr [] = " island_shipping IN (0,2) ";`
113	`}`	113	`}`
114	`else`	114	`else`
115	`{`	115	`{`
116	`$sqlCondArr [] = " island_shipping IN (0,1) ";`	116	`$sqlCondArr [] = " island_shipping IN (0,1) ";`
Zeile 122...	Zeile 122...
122	`AND`	122	`AND`
123	`" . $sqlCond . "`	123	`" . $sqlCond . "`
124	`";`	124	`";`
125	`}`	125	`}`
126	`$vR = DB::select( $sql );`	126	`$vR = DB::select( $sql );`
127	`if ( !count($vR) )`	127	`if ( !count( $vR ) )`
128	`{`	128	`{`
129	`$_SESSION["versandFehler"] = "Wir versenden NICHT an diese Adresse! Bitte geben Sie eine andere Adresse ein!";`	129	`$_SESSION["versandFehler"] = "Wir versenden NICHT an diese Adresse! Bitte geben Sie eine andere Adresse ein!";`
130	`}`	130	`}`
131	`foreach( $vR as $vRow )`	131	`foreach ( $vR as $vRow )`
132	`{`	132	`{`
Zeile 133...	Zeile 133...
133		133
134	`if ( $param == "single" )`	134	`if ( $param == "single" )`
135	`{`	135	`{`
Zeile 175...	Zeile 175...
175	`if ( ( $_GET['vRufname'] ) && is_numeric( $_GET['vRufname'] ) )`	175	`if ( ( $_GET['vRufname'] ) && is_numeric( $_GET['vRufname'] ) )`
176	`{`	176	`{`
177	`$sql .= " AND z.id = " . $_GET['vRufname'];`	177	`$sql .= " AND z.id = " . $_GET['vRufname'];`
178	`}`	178	`}`
179	`$zR = DB::select( $sql );`	179	`$zR = DB::select( $sql );`
180	`foreach( $zR as $zRow )`	180	`foreach ( $zR as $zRow )`
181	`{`	181	`{`
182	`if ( $zRow->internal_name != "nicht_belegt" )`	182	`if ( $zRow->internal_name != "nicht_belegt" )`
183	`{`	183	`{`
184	`$ini_name = $zRow->internal_name;`	184	`$ini_name = $zRow->internal_name;`
185	`if ( $ini_name == "sofortueberweisung" )`	185	`if ( $ini_name == "sofortueberweisung" )`
Zeile 188...	Zeile 188...
188	`}`	188	`}`
189	`if ( $GLOBALS["INI"]["PayPalPlus"]["aktiv"] != 1 )`	189	`if ( $GLOBALS["INI"]["PayPalPlus"]["aktiv"] != 1 )`
190	`{`	190	`{`
191	`$row["beschr"] = ( str_replace( "\r\n", "<br>", $row["beschr"] ) );`	191	`$row["beschr"] = ( str_replace( "\r\n", "<br>", $row["beschr"] ) );`
192	`}`	192	`}`
193	`if ( ( $GLOBALS["INI"][ $ini_name ]["aktiv"] == 1 && $_SESSION["zahlarten"][ $ini_name ] !== false ) \|\| !in_array( $zRow->internal_name, $GLOBALS["zahlsysteme"] ) )`	193	`if ( ( $GLOBALS["INI"][$ini_name]["aktiv"] == 1 && $_SESSION["zahlarten"][$ini_name] !== false ) \|\| !in_array( $zRow->internal_name, $GLOBALS["zahlsysteme"] ) )`
194	`{`	194	`{`
195	`$preis = $vRow->price;`	195	`$preis = $vRow->price;`
196	`$name = $vRow->name . " - " . $zRow->name;`	196	`$name = $vRow->name . " - " . $zRow->name;`
197	`if ( $_SESSION["SHOP"]["Lieferadresse"] == "abholung" )`	197	`if ( $_SESSION["SHOP"]["Lieferadresse"] == "abholung" )`
198	`{`	198	`{`
Zeile 223...	Zeile 223...
223	`}`	223	`}`
224	`if ( $vRow->info_mail )`	224	`if ( $vRow->info_mail )`
225	`{`	225	`{`
226	`$beschreibung2 .= $vRow->info_mail;`	226	`$beschreibung2 .= $vRow->info_mail;`
227	`}`	227	`}`
228	`$buffer[ $zRow->internal_name . "_" . $vRow->id ] = array(`	228	`$buffer[$zRow->internal_name . "_" . $vRow->id] = array(`
229	`"zusaetze" => $vRow->zusaetze,`	229	`"zusaetze" => $vRow->zusaetze,`
230	`"ID" => $zRow->internal_name . "_" . $vRow->id,`	230	`"ID" => $zRow->internal_name . "_" . $vRow->id,`
231	`"beschreibung" => $beschreibung,`	231	`"beschreibung" => $beschreibung,`
232	`"beschreibung2" => $beschreibung2,`	232	`"beschreibung2" => $beschreibung2,`
233	`"kurz" => $name,`	233	`"kurz" => $name,`
Zeile 256...	Zeile 256...
256	`WHERE`	256	`WHERE`
257	`id=" . $zId . "`	257	`id=" . $zId . "`
258	`";`	258	`";`
259	`$res = DB::select( $sql );`	259	`$res = DB::select( $sql );`
260	`$row = $res[0];`	260	`$row = $res[0];`
261	`$zusaetze[ $zId ] = $row->beschreibung;`	261	`$zusaetze[$zId] = $row->beschreibung;`
262	`}`	262	`}`
263	`}`	263	`}`
264	`}`	264	`}`
265	`}`	265	`}`
266	`else`	266	`else`
Zeile 276...	Zeile 276...
276	`vl.shipping_id=v.id`	276	`vl.shipping_id=v.id`
277	`WHERE`	277	`WHERE`
278	`country_id=" . $Land . "`	278	`country_id=" . $Land . "`
279	`";`	279	`";`
280	`$res = DB::select( $sql );`	280	`$res = DB::select( $sql );`
281	`foreach( $res as $vRow )`	281	`foreach ( $res as $vRow )`
282	`{`	282	`{`
283	`$vgId = $vRow->versandgruppen_id;`	283	`$vgId = $vRow->versandgruppen_id;`
284	`$sql = "SELECT`	284	`$sql = "SELECT`
285	`z.name,`	285	`z.name,`
286	`z.internal_name`	286	`z.internal_name`
Zeile 296...	Zeile 296...
296	`if ( ( $_GET['vRufname'] ) && is_numeric( $_GET['vRufname'] ) )`	296	`if ( ( $_GET['vRufname'] ) && is_numeric( $_GET['vRufname'] ) )`
297	`{`	297	`{`
298	`$sql .= " AND z.id = " . $_GET['vRufname'];`	298	`$sql .= " AND z.id = " . $_GET['vRufname'];`
299	`}`	299	`}`
300	`$resZ = DB::select( $sql );`	300	`$resZ = DB::select( $sql );`
301	`foreach( $resZ as $vzRow )`	301	`foreach ( $resZ as $vzRow )`
302	`{`	302	`{`
303	`if ( $vzRow->internal_name != "nicht_belegt" )`	303	`if ( $vzRow->internal_name != "nicht_belegt" )`
304	`{`	304	`{`
305	`$ini_name = $vzRow->internal_name;`	305	`$ini_name = $vzRow->internal_name;`
306	`if ( $ini_name == "sofortueberweisung" )`	306	`if ( $ini_name == "sofortueberweisung" )`
Zeile 309...	Zeile 309...
309	`}`	309	`}`
310	`if ( $GLOBALS["INI"]["PayPalPlus"]["aktiv"] != 1 )`	310	`if ( $GLOBALS["INI"]["PayPalPlus"]["aktiv"] != 1 )`
311	`{`	311	`{`
312	`$row["beschr"] = ( str_replace( "\r\n", "<br>", $row["beschr"] ) );`	312	`$row["beschr"] = ( str_replace( "\r\n", "<br>", $row["beschr"] ) );`
313	`}`	313	`}`
314	`if ( ( $GLOBALS["INI"][ $ini_name ]["aktiv"] == 1 && $_SESSION["zahlarten"][ $ini_name ] !== false ) \|\| !in_array( $vzRow->internal_name, $GLOBALS["zahlsysteme"] ) )`	314	`if ( ( $GLOBALS["INI"][$ini_name]["aktiv"] == 1 && $_SESSION["zahlarten"][$ini_name] !== false ) \|\| !in_array( $vzRow->internal_name, $GLOBALS["zahlsysteme"] ) )`
315	`{`	315	`{`
316	`$preis = $vRow->price;`	316	`$preis = $vRow->price;`
317	`$name = $vRow->name . " - " . $vzRow->name;`	317	`$name = $vRow->name . " - " . $vzRow->name;`
318	`if ( $_SESSION["SHOP"]["Lieferadresse"] == "abholung" )`	318	`if ( $_SESSION["SHOP"]["Lieferadresse"] == "abholung" )`
319	`{`	319	`{`
Zeile 344...	Zeile 344...
344	`}`	344	`}`
345	`if ( $vRow->info_mail )`	345	`if ( $vRow->info_mail )`
346	`{`	346	`{`
347	`$beschreibung2 .= $vRow->info_mail;`	347	`$beschreibung2 .= $vRow->info_mail;`
348	`}`	348	`}`
349	`$buffer[ $vzRow->internal_name . "_" . $vRow->id ] = array(`	349	`$buffer[$vzRow->internal_name . "_" . $vRow->id] = array(`
350	`"zusaetze" => $vRow->zusaetze,`	350	`"zusaetze" => $vRow->zusaetze,`
351	`"ID" => $vzRow->internal_name . "_" . $vRow->id,`	351	`"ID" => $vzRow->internal_name . "_" . $vRow->id,`
352	`"beschreibung" => $beschreibung,`	352	`"beschreibung" => $beschreibung,`
353	`"beschreibung2" => $beschreibung2,`	353	`"beschreibung2" => $beschreibung2,`
354	`"kurz" => $name,`	354	`"kurz" => $name,`
Zeile 368...	Zeile 368...
368	`}`	368	`}`
369	`}`	369	`}`
370	`}`	370	`}`
371	`ksort( $buffer );`	371	`ksort( $buffer );`
372	`}`	372	`}`
373	`return $buffer;`	373	`return $buffer;`
374	`}`	374	`}`
375	`}`	375	`}`

Subversion-Projekte lars-tiefland.laravel_shop

(root)/trunk/app/Http/Controllers/ShippingController.php – Revision 817 → 829