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 | 36 +++++++++++++++++++++++++-----------
1 files changed, 25 insertions(+), 11 deletions(-)
diff --git a/app/Vola/Services/FakeSSODatabase/FakeSSODatabaseHandler.php b/app/Vola/Services/FakeSSODatabase/FakeSSODatabaseHandler.php
index 51e47c9..706b327 100644
--- a/app/Vola/Services/FakeSSODatabase/FakeSSODatabaseHandler.php
+++ b/app/Vola/Services/FakeSSODatabase/FakeSSODatabaseHandler.php
@@ -1,25 +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 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) {
- public function testInsert() {
+ $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) values (?, ?)", ["CIAO", "CIAONE"]);
- }catch(Exception $e) {
- echo $e;
+ $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