Filippo Bertilotti
7 days ago b35a97d09497e3e7fc561bb4a4f435ec7ae8ff4c
app/Vola/Services/FakeSSODatabase/FakeSSODatabaseHandler.php
@@ -1,4 +1,5 @@
<?php
namespace App\Vola\Services\FakeSSODatabase;
use App\Models\Msisdn;
@@ -6,34 +7,37 @@
use App\Models\VodafoneUser;
use Exception;
use Illuminate\Support\Facades\DB;
use PDOException;
class FakeSSODatabaseHandler {
class FakeSSODatabaseHandler
{
    public function insertDataIntoTables(array $data) {
        try{
            $userModel = VodafoneUser::create(['Name' => $data["Name"],
                                               'Surname' => $data["Surname"],
                                               'EmailAddress' => $data["EmailAddress"]]);
            $msisdnModel = Msisdn::create(['MSISDN' => $data["sim_1"],
                                           'IdPiano' => $data['IdPiano'],
                                           'LinkedUser' => $userModel->id]);
    public function insertDataIntoTables(array $data)
    {
        try {
            $userModel = VodafoneUser::create([
                'Name' => $data["Name"],
                'Surname' => $data["Surname"],
                'EmailAddress' => $data["EmailAddress"]
            ]);
            $msisdnModel = Msisdn::create([
                'MSISDN' => $data["sim_1"],
                'IdPiano' => $data['IdPiano'],
                'LinkedUser' => $userModel->id
            ]);
            foreach ($data["products_select"] as $index => $value) {
                $product = Products::find($value);
                $product->msisdn()->attach($msisdnModel->id);
            }
        }catch(PDOException $e) {
        } catch (Exception $e) {
            echo $e->getMessage();
        }
    }
    public function readProducts(): array {
    public function readProducts(): array
    {
        $productsList = Products::select("Name", "id")->get()?->toArray();
        return $productsList;
    }