creazione view nuova per inserimento database e refactor

Filippo Bertilotti

2024-09-02 56f8c80f9a610c80810b24718340bc9cfd14df07

 app/Vola/Services/FakeSSODatabase/FakeSSODatabaseHandler.php

@@ -1,34 +1,39 @@
<?php
namespace App\Vola\Services\FakeSSODatabase;

use App\Models\Msisdn;
use App\Models\VodafoneUser;
use Exception;
use Illuminate\Support\Facades\DB;
use PDOException;

class FakeSSODatabaseHandler {

    public function __construct() {
        echo "Loaded class 'FakeSSODatabaseHandler'";
    }
    
    /*public function insertDataIntoTable(array $data) {
        //usare insert() per inserire il valore nella tabella giusta
    }

    private function insert($value ,string $field, string $table) {
        
    }*/

    public function insertDataIntoTables(array $data) {
        print_r($data["EmailAddress"]);

        $userArray =
        [
            'Name' => $data["Name"],
            'Surname' => $data["Surname"],
            'EmailAddress' => $data["EmailAddress"]
        ];

        $msisdnArray =
        [
            'MSISDN' => $data["sim_1"],
            'IdPiano' => $data["IdPiano"]
        ];

        try{
            DB::insert("insert into fakesso_vodafoneusers (Name, Surname, EmailAddress) values (?, ?, ?)",
                        [$data["Name"], $data["Surname"], $data["EmailAddress"]]);
            $userModel = VodafoneUser::create($userArray);
            Msisdn::create(['MSISDN' => $data["sim_1"],
                            'IdPiano' => $data['IdPiano'],
                            'LinkedUser' => $userModel->id]);

        }catch(PDOException $e) {
            echo $e->getMessage();
        };
        }

    }