From 56f8c80f9a610c80810b24718340bc9cfd14df07 Mon Sep 17 00:00:00 2001
From: Filippo Bertilotti <filippobertilotti@gmail.com>
Date: Mon, 02 Sep 2024 10:14:35 +0200
Subject: [PATCH] creazione view nuova per inserimento database e refactor
---
app/Vola/Services/FakeSSODatabase/FakeSSODatabaseHandler.php | 37 +++++++++++++++++++++----------------
1 files changed, 21 insertions(+), 16 deletions(-)
diff --git a/app/Vola/Services/FakeSSODatabase/FakeSSODatabaseHandler.php b/app/Vola/Services/FakeSSODatabase/FakeSSODatabaseHandler.php
index 29f383d..706b327 100644
--- a/app/Vola/Services/FakeSSODatabase/FakeSSODatabaseHandler.php
+++ b/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();
- };
+ }
+
}
--
Gitblit v1.8.0