Filippo Bertilotti
7 days ago 7146e93c75c6215af79fbfe523b7da0e339ec64a
commit | author | age
42e9ce 1 <?php
6472ce 2
42e9ce 3 namespace App\Vola\Services\FakeSSODatabase;
FB 4
7e64cc 5 use App\Models\Msisdn;
072cbb 6 use App\Models\Products;
2bfce6 7 use App\Models\VodafoneUser;
42e9ce 8 use Exception;
FB 9 use Illuminate\Support\Facades\DB;
10
6472ce 11 class FakeSSODatabaseHandler
D 12 {
6aea63 13
6472ce 14     public function insertDataIntoTables(array $data)
D 15     {
16         try {
17             $userModel = VodafoneUser::create([
18                 'Name' => $data["Name"],
19                 'Surname' => $data["Surname"],
20                 'EmailAddress' => $data["EmailAddress"]
21             ]);
22             $msisdnModel = Msisdn::create([
23                 'MSISDN' => $data["sim_1"],
24                 'IdPiano' => $data['IdPiano'],
25                 'LinkedUser' => $userModel->id
26             ]);
c52de0 27
FB 28             foreach ($data["products_select"] as $index => $value) {
29                 $product = Products::find($value);
30                 $product->msisdn()->attach($msisdnModel->id);
31             }
32
6472ce 33         } catch (Exception $e) {
6aea63 34             echo $e->getMessage();
2bfce6 35         }
FB 36
42e9ce 37     }
FB 38
6472ce 39     public function readProducts(): array
D 40     {
072cbb 41         $productsList = Products::select("Name", "id")->get()?->toArray();
FB 42         return $productsList;
c52de0 43     }
42e9ce 44 }