<?php
|
namespace App\Vola\Services\FakeSSODatabase;
|
|
use App\Models\Msisdn;
|
use App\Models\Products;
|
use App\Models\VodafoneUser;
|
use Exception;
|
use Illuminate\Support\Facades\DB;
|
use PDOException;
|
|
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]);
|
|
foreach ($data["products_select"] as $index => $value) {
|
$product = Products::find($value);
|
$product->msisdn()->attach($msisdnModel->id);
|
}
|
|
|
}catch(PDOException $e) {
|
echo $e->getMessage();
|
}
|
|
}
|
|
public function readProducts(): array {
|
$productsList = Products::select("Name", "id")->get()?->toArray();
|
return $productsList;
|
}
|
}
|
