1. <?php
3. namespace App\Controller;
5. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
6. use Symfony\Component\HttpFoundation\JsonResponse;
7. use Symfony\Component\Routing\Annotation\Route;
8. use Symfony\Component\HttpFoundation\Request;
9. use Doctrine\ORM\EntityManagerInterface;
10. use Psr\Log\LoggerInterface;
11. use App\Entity\Event;
12. use App\Entity\ProfileMenu;
13. use App\Entity\Product;
14. use App\Entity\Portfolio;
15. use App\Entity\ProviderDatabaseConfiguration;
16. use App\Entity\Observation;
17. use App\Entity\EventDomain;
18. use App\Entity\EventLevel;
19. use App\Entity\EventType;
20. use App\Entity\Coverage;
21. use App\Entity\Units;
22. use App\Entity\Insured;
24. class CoverageController extends AbstractController
25. {
26.     #[Route('/api/coverage/cat/getpremium', name: 'CatPremium', methods: ['POST'])]
27.     public function getCatPremium(Request $request,EntityManagerInterface $entityManager, LoggerInterface $logger): JsonResponse
28.     {
29.         $user = $this->getUSer();
30.         if ($user){
31.             $EventCoumter = $entityManager->getRepository(Event::class)->counterTodayByUsers($user);
32.             $Menulist = $entityManager->getRepository(ProfileMenu::class)->findByProfile($user->getProfile()->getId());
33.             $control = FALSE;
34.             foreach ($Menulist as $value){
35.                 if(strpos($value->getMenu()->getMenuLink(), $request->getPathInfo()) !== false){
36.                     $control = TRUE;
37.                 }
38.             }
39.             if($control && $EventCoumter<$user->getMaxRequest()){
40.                 $logger->alert('coverage/cat/getpremium as '.$user->getUsername().' alowed');
41.                 $formData=json_decode($request->getContent(),true);
42.                 $totalIndex = array();
43.                 $product = $entityManager->getRepository(Product::class)->findOneById($formData["product_id"]);
44.                 $portfolio = $entityManager->getRepository(Portfolio::class)->findOneById($product->getPortfolio());
45.                 $min_start_date = 10000;
46.                 $max_end_date = 0;
47.                 $strucCount = 0;
48.                 if(!isset($formData["geteventnames"])){
49.                     $formData["geteventnames"] = "PAYOUT";
50.                 }
51.                 if(!isset($formData["dointerpol"])){
52.                     $formData["dointerpol"] = "YES";
53.                 }
54.                 
55.                 foreach ($formData["structures"] as $key=>$value){
56.                     $strucCount = $strucCount +1;
57.                     $databaseConf = $entityManager->getRepository(ProviderDatabaseConfiguration::class)->createQueryBuilder('o')->where('o.providerDatabase = :databaseId')->andWhere('o.configuration = :config')->setParameter('databaseId', $product->getProductDatabase()->getId())->setParameter('config', 'GetCatIndex')->getQuery()->getResult();
58.                     
59.                     if(!isset($value["reference"])){
60.                         $value["reference"] = "Struc".$strucCount;
61.                         $formData["structures"][$key]["reference"] = "Struc".$strucCount;
62.                     }
63.                     
64.                     if(!isset($value["geteventnames"])){
65.                         $value["geteventnames"] = $formData["geteventnames"];
66.                         $formData["structures"][$key]["geteventnames"] = $formData["geteventnames"];
67.                     }
68.                     
69.                     if(!isset($value["units"])){
70.                         $value["units"] = "CAT";
71.                         $formData["structures"][$key]["units"] = "CAT";
72.                     }
73.                     
74.                     if(!isset($value["replica_period"])){
75.                         $value["replica_period"] = 30;
76.                         $formData["structures"][$key]["replica_period"] = 30;
77.                     }
78.                     
79.                     if(!isset($value["history_length"])){
80.                         if(is_null($product->getHistoryLength())){
81.                             $value["history_length"] = 50;
82.                             $formData["structures"][$key]["history_length"] = 50;
83.                         }else{
84.                             $value["history_length"] = $product->getHistoryLength();
85.                             $formData["structures"][$key]["history_length"] = $product->getHistoryLength();
86.                         }
87.                     }
88.                     
89.                     $value["period"]=$formData["period"];
90.                     $formData["structures"][$key]["period"]=$formData["period"];
91.                     $value["dointerpol"]=$formData["dointerpol"];
92.                     
93.                     $indexTemp = array();
94.                     $counterLoop=0;
95.                     while(count($indexTemp)==0 && $counterLoop<3){
96.                         $counterLoop=$counterLoop+1;
97.                         $indexTemp = $entityManager->getRepository(Observation::class)->getDataLakeCatPayOut($product,$databaseConf[0]->getConfigurationValue(),json_encode($value));
98.                     }
99.                     if(count($indexTemp)!=0){
100.                         foreach ($indexTemp as $indexValues){
101.                             if(str_contains($indexValues["historic_payout_org"],':')){
102.                                 $filteredZone[$value["reference"]][] = $indexValues;
103.                             }else{
104.                                 $totalIndex[] = $indexValues;
105.                             }
106.                         }
107.                     }else{
108.                         $response = new JsonResponse($value["reference"]." Pricing error", 422);
109.                         $response->headers->set('Content-Type', 'application/json');
110.                         return $response;
111.                     }
112.                 }
113.                 $originalPayout=array();
114.                 foreach ($totalIndex as $value){
115.                     $originalPayout[] = array(
116.                         "date_year" => $value["date_year"],
117.                         "historic_payout_org" => $value["historic_payout_org"]
118.                     );
119.                 }
120.                 $Years = array_column($totalIndex,'date_year');
121.                 $totalPayout = array();
122.                 for($i=min($Years);$i<=max($Years);$i++){
123.                     $yearIndex = array_keys($Years,$i);
124.                     $total = array_fill(0, 11, 0);
125.                     foreach ($yearIndex as $value2){
126.                         $total[0] = $total[0] + $totalIndex[$value2]["historic_payout_org"];
127.                         $total[1] = $total[1] + $totalIndex[$value2]["historic_payout_varcat_minus"];
128.                         $total[2] = $total[2] + $totalIndex[$value2]["historic_payout_varcat_plus"];
129.                         $total[3] = $total[3] + $totalIndex[$value2]["historic_payout_varpoint1"];
130.                         $total[4] = $total[4] + $totalIndex[$value2]["historic_payout_varpoint2"];
131.                         $total[5] = $total[5] + $totalIndex[$value2]["historic_payout_varpoint3"];
132.                         $total[6] = $total[6] + $totalIndex[$value2]["historic_payout_varpoint4"];
133.                         $total[7] = $total[7] + $totalIndex[$value2]["historic_payout_varpoint5"];
134.                         $total[8] = $total[8] + $totalIndex[$value2]["historic_payout_varpoint6"];
135.                         $total[9] = $total[9] + $totalIndex[$value2]["historic_payout_varpoint7"];
136.                         $total[10] = $total[10] + $totalIndex[$value2]["historic_payout_varpoint8"];
137.                     }
138.                     if(!isset($formData["general_deductible"])){
139.                         $formData["general_deductible"]=0;
140.                     }
141.                     for($j=0;$j<11;$j++){
142.                         if($total[$j] < $formData["general_deductible"]){
143.                             $total[$j] = 0;
144.                         }else{
145.                             $total[$j] = $total[$j] - $formData["general_deductible"];
146.                         }
147.                         if($total[$j]>$formData["general_limit"]) $total[$j] = $formData["general_limit"];
148.                     }
149.                     $total_mean = array_sum($total)/count($total);
150.                     if($total_mean>$formData["general_limit"]){
151.                         $total_mean = $formData["general_limit"];
152.                     }
153.                     $totalPayout[]=array(
154.                         "date_year" => $i,
155.                         "total_mean" => $total_mean,
156.                         "historic_payout_org" => $total[0],
157.                         "historic_payout_varcat_minus" => $total[1],
158.                         "historic_payout_varcat_plus" => $total[2],
159.                         "historic_payout_varpoint1" => $total[3],
160.                         "historic_payout_varpoint2" => $total[4],
161.                         "historic_payout_varpoint3" => $total[5],
162.                         "historic_payout_varpoint4" => $total[6],
163.                         "historic_payout_varpoint5" => $total[7],
164.                         "historic_payout_varpoint6" => $total[8],
165.                         "historic_payout_varpoint7" => $total[9],
166.                         "historic_payout_varpoint8" => $total[10]
167.                     );
168.                 }
170.                 $payoutMean = array_fill(0, 12, 0);
171.                 $payoutMean[0] =  array_sum(array_column($totalPayout,'total_mean'))/(count(array_column($totalPayout,'total_mean')));
172.                 $payoutMean[1] =  array_sum(array_column($totalPayout,'historic_payout_org'))/(count(array_column($totalPayout,'historic_payout_org')));
173.                 $payoutMean[2] =  array_sum(array_column($totalPayout,'historic_payout_varcat_minus'))/(count(array_column($totalPayout,'historic_payout_varcat_minus')));
174.                 $payoutMean[3] =  array_sum(array_column($totalPayout,'historic_payout_varcat_plus'))/(count(array_column($totalPayout,'historic_payout_varcat_plus')));
175.                 
176.                 for($j=4;$j<12;$j++){
177.                     $payoutMean[$j] =  array_sum(array_column($totalPayout,'historic_payout_varpoint'.($j-3)))/(count(array_column($totalPayout,'historic_payout_varpoint'.($j-3))));
178.                 }
179.                 
180.                 if(!isset($formData["load_tail"])){
181.                     $formData["load_tail"]=0.01;
182.                 }
183.                 if(!isset($formData["load_fronting"])){
184.                     $formData["load_fronting"]=0;
185.                 }
186.                 if(!isset($formData["load_brokerage"])){
187.                     $formData["load_brokerage"]=0.325;
188.                 }
189.                 if(!isset($formData["load_el"])){
190.                     $formData["load_el"]=1;
191.                 }
192.                 if(!isset($formData["load_std"])){
193.                     $formData["load_std"]=0.2;
194.                 }
195.                 if(!isset($formData["load_min"])){
196.                     $formData["load_min"]=0.02538462;
197.                 }
198.                 if(!isset($formData["load_deduction_cg"])){
199.                     $formData["load_deduction_cg"]=0.125;
200.                 }
201.                 if(!isset($formData["load_factor_uw"])){
202.                     $formData["load_factor_uw"]=0.15;
203.                 }
205.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_org')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
206.                 $ExpectedLoss[] = $payoutMean[1];
207.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
208.                 $Iteration[] = "STRICT";
210.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'total_mean')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
211.                 $ExpectedLoss[] = $payoutMean[0];
212.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
213.                 $Iteration[] = "AVERAGE";
215.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_varcat_minus')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
216.                 $ExpectedLoss[] = $payoutMean[2];
217.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
218.                 $Iteration[] = "SPEED_MINUS10PCT";
220.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_varcat_plus')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
221.                 $ExpectedLoss[] = $payoutMean[3];
222.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
223.                 $Iteration[] = "SPEED_PLUS10PCT";
225.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_varpoint1')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
226.                 $ExpectedLoss[] = $payoutMean[4];
227.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
228.                 $Iteration[] = "VAR_NORTH";
230.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_varpoint2')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
231.                 $ExpectedLoss[] = $payoutMean[5];
232.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
233.                 $Iteration[] = "VAR_SOUTH";
235.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_varpoint3')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
236.                 $ExpectedLoss[] = $payoutMean[6];
237.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
238.                 $Iteration[] = "VAR_EAST";
240.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_varpoint4')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
241.                 $ExpectedLoss[] = $payoutMean[7];
242.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
243.                 $Iteration[] = "VAR_WEST";
245.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_varpoint5')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
246.                 $ExpectedLoss[] = $payoutMean[8];
247.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
248.                 $Iteration[] = "VAR_NORTHWEST";
250.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_varpoint6')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
251.                 $ExpectedLoss[] = $payoutMean[9];
252.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
253.                 $Iteration[] = "VAR_NORTHEAST";
255.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_varpoint7')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
256.                 $ExpectedLoss[] = $payoutMean[10];
257.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
258.                 $Iteration[] = "VAR_SOUTHWEST";
260.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_varpoint8')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
261.                 $ExpectedLoss[] = $payoutMean[11];
262.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
263.                 $Iteration[] = "VAR_SOUTHEAST";
264.                 
265.                 $primes=array();
266.                 foreach ($Premiums as $key => $value2){
267.                     $primes["Analysis"][] = array(
268.                         "Iteration" => $Iteration[$key],
269.                         "ExpectedLoss"=> $ExpectedLoss[$key],
270.                         "Premiums" => $Premiums[$key]
271.                     );
272.                 }
273.                 
274.                 $totalyears=max($Years)-min($Years)+1;
275.                 
276.                 for($i=min($Years);$i<=max($Years);$i++){
277.                     $yearIndex = array_keys($Years,$i);
278.                     $strucCount = 0;
279.                     foreach ($yearIndex as $key=>$value2){
280.                         $primes["Payouts"][$formData["structures"][$strucCount]["reference"]][] = array(
281.                         //$primes["Payouts"][$formData["structures"][intval($value2/$totalyears)]["reference"]][] = array(
282.                             "Year" => $totalIndex[$value2]["date_year"],
283.                             "Payout" => $totalIndex[$value2]["historic_payout_org"]
284.                         );
285.                         $strucCount = $strucCount + 1;
286.                     }
287.                 }
289.                 if (isset($filteredZone)) {
290.                     foreach ($filteredZone as $key=>$value){
291.                         if($formData["geteventnames"]=="ALL"){
292.                             foreach ($value as $key2=>$value2){
293.                                 $primes["Events"][$key][]=array(
294.                                     "ID"=>$value2["date_year"],
295.                                     "Name"=>$value2["historic_payout_varpoint1"],
296.                                     "TIME"=>$value2["historic_payout_org"],
297.                                     "LAT"=>floatval($value2["historic_payout_varcat_minus"]),
298.                                     "LON"=>floatval($value2["historic_payout_varcat_plus"]),
299.                                     "Mg"=>floatval($value2["historic_payout_varpoint2"]),
300.                                     "MgSec"=>floatval($value2["historic_payout_varpoint3"])
301.                                 );
302.                             }
303.                         }else{
304.                             foreach ($value as $key2=>$value2){
305.                                 $primes["Events"][$key][]=array(
306.                                     "ID"=>$value2["date_year"],
307.                                     "Name"=>$value2["historic_payout_varpoint1"],
308.                                     "TIME"=>$value2["historic_payout_org"],
309.                                     "LAT"=>floatval($value2["historic_payout_varcat_minus"]),
310.                                     "LON"=>floatval($value2["historic_payout_varcat_plus"]),
311.                                     "Mg"=>floatval($value2["historic_payout_varpoint2"]),
312.                                     "MgSec"=>floatval($value2["historic_payout_varpoint3"]),
313.                                     "Circle"=>floatval($value2["historic_payout_varpoint7"]),
314.                                     "PayOut"=>floatval($value2["historic_payout_varpoint8"])
315.                                 );
316.                             }
317.                         }
318.                     }
319.                 }
320.                 $EventDomain = $entityManager->getRepository(EventDomain::class)->findOneById(1);
321.                 $EventLevel = $entityManager->getRepository(EventLevel::class)->findOneById(1);
322.                 $EventType = $entityManager->getRepository(EventType::class)->findOneById(1);
324.                 $Event = new Event();
326.                 $Event->setDateEvent(new \DateTime('now'));
327.                 $Event->setDescription('{"entry_point":"'.$request->getPathInfo().'","vivaldi_version":"'.$_ENV["VIVALDI_VERSION"].'","input_json":'.json_encode($formData).',"output_json":'.json_encode($primes).'}');
328.                 $Event->setUsers($user);
329.                 $Event->setEventType($EventType);
330.                 $Event->setEventDomain($EventDomain);
331.                 $Event->setEventLevel($EventLevel);
332.                 
333.                 
334.                 $entityManager->persist($Event);
335.                 $entityManager->flush();
336.                 $primes["Reference"] = $Event->getId();
337.                 $primes["VivaldiVersion"] = $_ENV["VIVALDI_VERSION"];
338.                 $primes["Time"] = $Event->getDateEvent();
339.                 
340.                 return $this->json($primes);
341.             }else{
342.                 $response = new JsonResponse(null, 401);
343.                 $response->headers->set('Content-Type', 'application/json');
344.                 return $response;
345.             }
346.         }else{
347.             $response = new JsonResponse(null, 401);
348.             $response->headers->set('Content-Type', 'application/json');
349.             return $response;
350.         }
351.     }
352.     
353.     #[Route('/api/coverage/cat/getpremiumstruc', name: 'CatPremiumStruc', methods: ['POST'])]
354.     public function getCatPremiumStruc(Request $request,EntityManagerInterface $entityManager, LoggerInterface $logger): JsonResponse
355.     {
356.         $user = $this->getUSer();
357.         if ($user){
358.             $EventCoumter = $entityManager->getRepository(Event::class)->counterTodayByUsers($user);
359.             $Menulist = $entityManager->getRepository(ProfileMenu::class)->findByProfile($user->getProfile()->getId());
360.             $control = FALSE;
361.             foreach ($Menulist as $value){
362.                 if(strpos($value->getMenu()->getMenuLink(), $request->getPathInfo()) !== false){
363.                     $control = TRUE;
364.                 }
365.             }
366.             if($control && $EventCoumter<$user->getMaxRequest()){
367.                 $logger->alert('coverage/getcatpremium as '.$user->getUsername().' alowed');
368.                 $formData=json_decode($request->getContent(),true);
369.                 $outStruct["general_limit"]= "general_limit_value";
370.                 $outStruct["product_id"]="product_id_value";
371.                 $outStruct["period"]=array(
372.                     "start_date"=>"start_date_value",
373.                     "end_date"=>"end_date_value"
374.                 );
375.                 for($x=0;$x<$formData["structures"];$x++){
376.                     $structuresTemp = array();
377.                     $structuresTemp["reference"]="reference_value_".$x;
378.                     $structuresTemp["limit"]="limit_value_".$x;
379.                     if($formData["form_type"][$x]=="rings"){
380.                         $structuresTemp["latitude"]="latitude_value_".$x;
381.                         $structuresTemp["longitude"]="longitude_value_".$x;
382.                         $rings=array();
383.                         unset($ringsTemp);
384.                         for($y=0;$y<$formData["form_type_number"][$x];$y++){
385.                             $ringsTemp["radius"]="radius_value_".$x."_".$y;
386.                             $strike=array();
387.                             unset($strikeTemp);
388.                             for($z=0;$z<$formData["strikes_number"][$x];$z++){
389.                                 $strikeTemp["strike"]="strike_value_".$x."_".$y."_".$z;
390.                                 $strikeTemp["payout"]="payout_value_".$x."_".$y."_".$z;
391.                                 $strike[]=$strikeTemp;
392.                             }
393.                             $ringsTemp["strikes"]=$strike;
394.                             $rings[]=$ringsTemp;
395.                         }
396.                         $structuresTemp["rings"]=$rings;
397.                     }else{
398.                         $polygon=array();
399.                         unset($polygonTemp);
400.                         for($y=0;$y<$formData["form_type_number"][$x];$y++){
401.                             $lat=array();
402.                             $lon=array();
403.                             for($z=0;$z<$formData["form_type_coord"][$x];$z++){
404.                                 $lat[]="latitude_value_".$x."_".$y."_".$z;
405.                                 $lon[]="longitude_value_".$x."_".$y."_".$z;
406.                             }
407.                             $polygonTemp["latitude"]=$lat;
408.                             $polygonTemp["longitude"]=$lon;
409.                             $strike=array();
410.                             unset($strikeTemp);
411.                             for($z=0;$z<$formData["strikes_number"][$x];$z++){
412.                                 $strikeTemp["strike"]="strike_value_".$x."_".$y."_".$z;
413.                                 $strikeTemp["payout"]="payout_value_".$x."_".$y."_".$z;
414.                                 $strike[]=$strikeTemp;
415.                             }
416.                             $polygonTemp["strikes"]=$strike;
417.                             $polygon[]=$polygonTemp;
418.                         }
419.                         $structuresTemp["polygons"]=$polygon;
420.                     }
421.                     $structures[]=$structuresTemp;
422.                 }
423.                 $outStruct["structures"]=$structures;
424.                 return $this->json($outStruct);
425.             }else{
426.                 $response = new JsonResponse(null, 401);
427.                 $response->headers->set('Content-Type', 'application/json');
428.                 return $response;
429.             }
430.         }else{
431.             $response = new JsonResponse(null, 401);
432.             $response->headers->set('Content-Type', 'application/json');
433.             return $response;
434.         }
435.     }
437.     #[Route('/api/coverage/cat/getmultipremium', name: 'CatMultiPremium', methods: ['POST'])]
438.     public function getCatMultiPremium(Request $request,EntityManagerInterface $entityManager, LoggerInterface $logger): JsonResponse
439.     {
440.         $user = $this->getUSer();
441.         if ($user){
442.             $EventCoumter = $entityManager->getRepository(Event::class)->counterTodayByUsers($user);
443.             $Menulist = $entityManager->getRepository(ProfileMenu::class)->findByProfile($user->getProfile()->getId());
444.             $control = FALSE;
445.             foreach ($Menulist as $value){
446.                 if(strpos($value->getMenu()->getMenuLink(), $request->getPathInfo()) !== false){
447.                     $control = TRUE;
448.                 }
449.             }
450.             if($control && $EventCoumter<$user->getMaxRequest()){
451.                 $logger->alert('coverage/cat/getmultipremium as '.$user->getUsername().' alowed');
452.                 $formData=json_decode($request->getContent(),true);
453.                 $min_start_date = 10000;
454.                 $max_end_date = 0;
455.                 $strucCount = 0;
456.                 if(!isset($formData["dointerpol"])){
457.                     $formData["dointerpol"] = "YES";
458.                 }
459.                 foreach ($formData["structures"] as $key=>$value){
460.                     $totalIndex = array();
461.                     $filteredZone = array();
462.                     $strucCount=$strucCount+1;
463.                     $product = $entityManager->getRepository(Product::class)->findOneById($value["product_id"]);
464.                     $portfolio = $entityManager->getRepository(Portfolio::class)->findOneById($product->getPortfolio());
465.                     $databaseConf = $entityManager->getRepository(ProviderDatabaseConfiguration::class)->createQueryBuilder('o')->where('o.providerDatabase = :databaseId')->andWhere('o.configuration = :config')->setParameter('databaseId', $product->getProductDatabase()->getId())->setParameter('config', 'GetCatIndex')->getQuery()->getResult();
466.                     
467.                     if(!isset($value["reference"])){
468.                         $value["reference"] = "Struc".$strucCount;
469.                         $formData["structures"][$key]["reference"] = "Struc".$strucCount;
470.                     }
471.                     
472.                     if(!isset($value["geteventnames"])){
473.                         if(!isset($formData["geteventnames"])){
474.                             $value["geteventnames"] = "PAYOUT";
475.                             $formData["structures"][$key]["geteventnames"] = "PAYOUT";
476.                         }else{
477.                             $value["geteventnames"] = $formData["geteventnames"];
478.                             $formData["structures"][$key]["geteventnames"] = $formData["geteventnames"];
479.                         }
480.                     }
481.                     
482.                     if(!isset($value["replica_period"])){
483.                         $value["replica_period"] = 30;
484.                         $formData["structures"][$key]["replica_period"] = 30;
485.                     }
486.                     if(!isset($value["history_length"])){
487.                         if(is_null($product->getHistoryLength())){
488.                             $formData["structures"][$key]["history_length"] = 50;
489.                         }else{
490.                             $formData["structures"][$key]["history_length"] = $product->getHistoryLength();
491.                         }
492.                     }
493.                     if(!isset($value["period"])){
494.                         $value["period"]=$formData["period"];
495.                         $formData["structures"][$key]["period"]=$formData["period"];
496.                     }
497.                     
498.                     $value["dointerpol"]=$formData["dointerpol"];
499.                     
500.                     $indexTemp = array();
501.                     $counterLoop=0;
502.                     while(count($indexTemp)==0 && $counterLoop<6){
503.                         $counterLoop=$counterLoop+1;
504.                         $indexTemp = $entityManager->getRepository(Observation::class)->getDataLakeCatPayOut($product,$databaseConf[0]->getConfigurationValue(),json_encode($value));
505.                     }
506.                     
507.                     if(count($indexTemp)==0){
508.                         $response = new JsonResponse($value["reference"]." Pricing error", 422);
509.                         $response->headers->set('Content-Type', 'application/json');
510.                         return $response;
511.                     }else{
512.                         foreach ($indexTemp as $indexValues){
513.                             if(str_contains($indexValues["historic_payout_org"],':')){
514.                                 $filteredZone[] = $indexValues;
515.                             }else{
516.                                 $totalIndex[] = $indexValues;
517.                             }
518.                         }
519.                         if(!isset($formData["general_deductible"])){
520.                             $formData["general_deductible"]=0;
521.                         }
522.                         if(!isset($value["limit"])){
523.                             $limit = $formData["general_limit"];
524.                         }else{
525.                             $limit = $value["limit"];
526.                         }
527.                         $counterLoop=0;
528.                         foreach ($totalIndex as $indexkey=>$indexvalue){
529.                             foreach ($indexvalue as $indexkey2=>$indexvalue2){
530.                                 if($indexkey2!="date_year"){
531.                                     if($indexvalue2 < $formData["general_deductible"]){
532.                                         $indexvalue2 = 0;
533.                                     }else{
534.                                         $indexvalue2 = $indexvalue2 - $formData["general_deductible"];
535.                                     }
536.                                     if($indexvalue2>$limit) $indexvalue2 = $limit;
537.                                     $totalIndex[$indexkey][$indexkey2]=$indexvalue2;
538.                                     $payoutMean[$counterLoop]["historic_payout"]=$payoutMean[$counterLoop]["historic_payout"]+$indexvalue2;
539.                                 }else{
540.                                     $payoutMean[$counterLoop]=array(
541.                                         "date_year"=>$totalIndex[$indexkey]["date_year"],
542.                                         "historic_payout"=>0
543.                                         
544.                                     );
545.                                 }
546.                             }
547.                             $payoutMean[$counterLoop]["historic_payout"]=$payoutMean[$counterLoop]["historic_payout"]/(count($indexvalue)-1);
548.                             $counterLoop=$counterLoop+1;
549.                         }
550.                         
551.                         if(!isset($formData["load_tail"])){
552.                             $formData["load_tail"]=0.01;
553.                         }
554.                         if(!isset($formData["load_fronting"])){
555.                             $formData["load_fronting"]=0;
556.                         }
557.                         if(!isset($formData["load_brokerage"])){
558.                             $formData["load_brokerage"]=0.325;
559.                         }
560.                         if(!isset($formData["load_el"])){
561.                             $formData["load_el"]=1;
562.                         }
563.                         if(!isset($formData["load_std"])){
564.                             $formData["load_std"]=0.2;
565.                         }
566.                         if(!isset($formData["load_min"])){
567.                             $formData["load_min"]=0.02538462;
568.                         }
569.                         if(!isset($formData["load_deduction_cg"])){
570.                             $formData["load_deduction_cg"]=0.125;
571.                         }
572.                         if(!isset($formData["load_factor_uw"])){
573.                             $formData["load_factor_uw"]=0.15;
574.                         }
575.                         
576.                         if(isset($ExpectedLoss)){
577.                             unset($ExpectedLoss);
578.                             unset($Premiums);
579.                             unset($Iteration);
580.                         }
581.                         
582.                         $jsonPremium=array("payout"=>array("date_year"=>array_column($totalIndex,'date_year'),"historic_payout"=>array_column($totalIndex,'historic_payout_org')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
583.                         $ExpectedLoss[] = array_sum(array_column($totalIndex,'historic_payout_org'))/count(array_column($totalIndex,'historic_payout_org'));
584.                         $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
585.                         $Iteration[] = "STRICT";
587.                         $jsonPremium=array("payout"=>array("date_year"=>array_column($payoutMean,'date_year'),"historic_payout"=>array_column($payoutMean,'historic_payout')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
588.                         $ExpectedLoss[] = array_sum(array_column($payoutMean,'historic_payout'))/count(array_column($payoutMean,'historic_payout'));
589.                         $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
590.                         $Iteration[] = "AVERAGE";
591.                         
592.                         $jsonPremium=array("payout"=>array("date_year"=>array_column($totalIndex,'date_year'),"historic_payout"=>array_column($totalIndex,'historic_payout_varcat_minus')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
593.                         $ExpectedLoss[] = array_sum(array_column($totalIndex,'historic_payout_varcat_minus'))/count(array_column($totalIndex,'historic_payout_varcat_minus'));
594.                         $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
595.                         $Iteration[] = "SPEED_MINUS10PCT";
596.                         
597.                         $jsonPremium=array("payout"=>array("date_year"=>array_column($totalIndex,'date_year'),"historic_payout"=>array_column($totalIndex,'historic_payout_varcat_plus')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
598.                         $ExpectedLoss[] = array_sum(array_column($totalIndex,'historic_payout_varcat_plus'))/count(array_column($totalIndex,'historic_payout_varcat_plus'));
599.                         $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
600.                         $Iteration[] = "SPEED_PLUS10PCT";
601.                         
602.                         $jsonPremium=array("payout"=>array("date_year"=>array_column($totalIndex,'date_year'),"historic_payout"=>array_column($totalIndex,'historic_payout_varpoint1')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
603.                         $ExpectedLoss[] = array_sum(array_column($totalIndex,'historic_payout_varpoint1'))/count(array_column($totalIndex,'historic_payout_varpoint1'));
604.                         $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
605.                         $Iteration[] = "VAR_NORTH";
606.                         
607.                         $jsonPremium=array("payout"=>array("date_year"=>array_column($totalIndex,'date_year'),"historic_payout"=>array_column($totalIndex,'historic_payout_varpoint2')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
608.                         $ExpectedLoss[] = array_sum(array_column($totalIndex,'historic_payout_varpoint2'))/count(array_column($totalIndex,'historic_payout_varpoint2'));
609.                         $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
610.                         $Iteration[] = "VAR_SOUTH";
611.                         
612.                         $jsonPremium=array("payout"=>array("date_year"=>array_column($totalIndex,'date_year'),"historic_payout"=>array_column($totalIndex,'historic_payout_varpoint3')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
613.                         $ExpectedLoss[] = array_sum(array_column($totalIndex,'historic_payout_varpoint3'))/count(array_column($totalIndex,'historic_payout_varpoint3'));
614.                         $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
615.                         $Iteration[] = "VAR_EAST";
616.                         
617.                         $jsonPremium=array("payout"=>array("date_year"=>array_column($totalIndex,'date_year'),"historic_payout"=>array_column($totalIndex,'historic_payout_varpoint4')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
618.                         $ExpectedLoss[] = array_sum(array_column($totalIndex,'historic_payout_varpoint4'))/count(array_column($totalIndex,'historic_payout_varpoint4'));
619.                         $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
620.                         $Iteration[] = "VAR_WEST";
621.                         
622.                         $jsonPremium=array("payout"=>array("date_year"=>array_column($totalIndex,'date_year'),"historic_payout"=>array_column($totalIndex,'historic_payout_varpoint5')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
623.                         $ExpectedLoss[] = array_sum(array_column($totalIndex,'historic_payout_varpoint5'))/count(array_column($totalIndex,'historic_payout_varpoint5'));
624.                         $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
625.                         $Iteration[] = "VAR_NORTHWEST";
626.                         
627.                         $jsonPremium=array("payout"=>array("date_year"=>array_column($totalIndex,'date_year'),"historic_payout"=>array_column($totalIndex,'historic_payout_varpoint6')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
628.                         $ExpectedLoss[] = array_sum(array_column($totalIndex,'historic_payout_varpoint6'))/count(array_column($totalIndex,'historic_payout_varpoint6'));
629.                         $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
630.                         $Iteration[] = "VAR_NORTHEAST";
631.                         
632.                         $jsonPremium=array("payout"=>array("date_year"=>array_column($totalIndex,'date_year'),"historic_payout"=>array_column($totalIndex,'historic_payout_varpoint7')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
633.                         $ExpectedLoss[] = array_sum(array_column($totalIndex,'historic_payout_varpoint7'))/count(array_column($totalIndex,'historic_payout_varpoint7'));
634.                         $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
635.                         $Iteration[] = "VAR_SOUTHWEST";
636.                         
637.                         $jsonPremium=array("payout"=>array("date_year"=>array_column($totalIndex,'date_year'),"historic_payout"=>array_column($totalIndex,'historic_payout_varpoint8')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
638.                         $ExpectedLoss[] = array_sum(array_column($totalIndex,'historic_payout_varpoint8'))/count(array_column($totalIndex,'historic_payout_varpoint8'));
639.                         $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
640.                         $Iteration[] = "VAR_SOUTHEAST";
641.                         
642.                         foreach ($Premiums as $key2 => $value2){
643.                             $primes[$value["reference"]]["Analysis"][] = array(
644.                                 "Iteration" => $Iteration[$key2],
645.                                 "ExpectedLoss"=> $ExpectedLoss[$key2],
646.                                 "Premiums" => $Premiums[$key2]
647.                             );
648.                         }
649.                         
650.                         foreach ($totalIndex as $key2 => $value2){
651.                             $primes[$value["reference"]]["Payouts"][] = array(
652.                                 "Year" => $value2["date_year"],
653.                                 "Payout" => $value2["historic_payout_org"]
654.                             );
655.                             
656.                         }
657.                         if (isset($filteredZone)) {
658.                             foreach ($filteredZone as $key3=>$value3){
659.                                 if($value["geteventnames"]=="ALL"){
660.                                     $primes[$value["reference"]]["Events"][]=array(
661.                                         "ID"=>$value3["date_year"],
662.                                         "Name"=>$value3["historic_payout_varpoint1"],
663.                                         "TIME"=>$value3["historic_payout_org"],
664.                                         "LAT"=>floatval($value3["historic_payout_varcat_minus"]),
665.                                         "LON"=>floatval($value3["historic_payout_varcat_plus"]),
666.                                         "Mg"=>floatval($value3["historic_payout_varpoint2"]),
667.                                         "MgSec"=>floatval($value3["historic_payout_varpoint3"])
668.                                     );
669.                                 }else{
670.                                     $primes[$value["reference"]]["Events"][]=array(
671.                                         "ID"=>$value3["date_year"],
672.                                         "Name"=>$value3["historic_payout_varpoint1"],
673.                                         "TIME"=>$value3["historic_payout_org"],
674.                                         "LAT"=>floatval($value3["historic_payout_varcat_minus"]),
675.                                         "LON"=>floatval($value3["historic_payout_varcat_plus"]),
676.                                         "Mg"=>floatval($value3["historic_payout_varpoint2"]),
677.                                         "MgSec"=>floatval($value3["historic_payout_varpoint3"]),
678.                                         "Circle"=>floatval($value2["historic_payout_varpoint7"]),
679.                                         "PayOut"=>floatval($value2["historic_payout_varpoint8"])
680.                                     );
681.                                 }
682.                             }
683.                         }
684.                     }
685.                 }
686.                 
687.                 $EventDomain = $entityManager->getRepository(EventDomain::class)->findOneById(1);
688.                 $EventLevel = $entityManager->getRepository(EventLevel::class)->findOneById(1);
689.                 $EventType = $entityManager->getRepository(EventType::class)->findOneById(1);
690.                 
691.                 $Event = new Event();
692.                 
693.                 $Event->setDateEvent(new \DateTime('now'));
694.                 $Event->setDescription('{"entry_point":"'.$request->getPathInfo().'","vivaldi_version":"'.$_ENV["VIVALDI_VERSION"].'","input_json":'.json_encode($formData).',"output_json":'.json_encode($primes).'}');
695.                 $Event->setUsers($user);
696.                 $Event->setEventType($EventType);
697.                 $Event->setEventDomain($EventDomain);
698.                 $Event->setEventLevel($EventLevel);
699.                 
700.                 
701.                 $entityManager->persist($Event);
702.                 $entityManager->flush();
703.                 $primes["Reference"] = $Event->getId();
704.                 $primes["VivaldiVersion"] = $_ENV["VIVALDI_VERSION"];
705.                 $primes["Time"] = $Event->getDateEvent();
706.                 
707.                 return $this->json($primes);
708.             }else{
709.                 $response = new JsonResponse(null, 401);
710.                 $response->headers->set('Content-Type', 'application/json');
711.                 return $response;
712.             }
713.         }else{
714.             $response = new JsonResponse(null, 401);
715.             $response->headers->set('Content-Type', 'application/json');
716.             return $response;
717.         }
718.     }
719.     
720.     #[Route('/api/coverage/cat/getmultipremiumstruc', name: 'CaMultitPremiumStruc', methods: ['POST'])]
721.     public function getCatMultiPremiumStruc(Request $request,EntityManagerInterface $entityManager, LoggerInterface $logger): JsonResponse
722.     {
723.         $user = $this->getUSer();
724.         if ($user){
725.             $EventCoumter = $entityManager->getRepository(Event::class)->counterTodayByUsers($user);
726.             $Menulist = $entityManager->getRepository(ProfileMenu::class)->findByProfile($user->getProfile()->getId());
727.             $control = FALSE;
728.             foreach ($Menulist as $value){
729.                 if(strpos($value->getMenu()->getMenuLink(), $request->getPathInfo()) !== false){
730.                     $control = TRUE;
731.                 }
732.             }
733.             if($control && $EventCoumter<$user->getMaxRequest()){
734.                 $logger->alert('coverage/getcatpremium as '.$user->getUsername().' alowed');
735.                 $formData=json_decode($request->getContent(),true);
736.                 $outStruct["general_limit"]= "general_limit_value";
737.                 for($x=0;$x<$formData["structures"];$x++){
738.                     $structuresTemp = array();
739.                     $structuresTemp["reference"]="reference_value_".$x;
740.                     $structuresTemp["limit"]="limit_value_".$x;
741.                     $structuresTemp["product_id"]="product_id_value_".$x;
742.                     if($formData["form_type"][$x]=="rings"){
743.                         $structuresTemp["latitude"]="latitude_value_".$x;
744.                         $structuresTemp["longitude"]="longitude_value_".$x;
745.                         $rings=array();
746.                         unset($ringsTemp);
747.                         for($y=0;$y<$formData["form_type_number"][$x];$y++){
748.                             $ringsTemp["radius"]="radius_value_".$x."_".$y;
749.                             $strike=array();
750.                             unset($strikeTemp);
751.                             for($z=0;$z<$formData["strikes_number"][$x];$z++){
752.                                 $strikeTemp["strike"]="strike_value_".$x."_".$y."_".$z;
753.                                 $strikeTemp["payout"]="payout_value_".$x."_".$y."_".$z;
754.                                 $strike[]=$strikeTemp;
755.                             }
756.                             $ringsTemp["strikes"]=$strike;
757.                             $rings[]=$ringsTemp;
758.                         }
759.                         $structuresTemp["rings"]=$rings;
760.                     }else{
761.                         $polygon=array();
762.                         unset($polygonTemp);
763.                         for($y=0;$y<$formData["form_type_number"][$x];$y++){
764.                             $lat=array();
765.                             $lon=array();
766.                             for($z=0;$z<$formData["form_type_coord"][$x];$z++){
767.                                 $lat[]="latitude_value_".$x."_".$y."_".$z;
768.                                 $lon[]="longitude_value_".$x."_".$y."_".$z;
769.                             }
770.                             $polygonTemp["latitude"]=$lat;
771.                             $polygonTemp["longitude"]=$lon;
772.                             $strike=array();
773.                             unset($strikeTemp);
774.                             for($z=0;$z<$formData["strikes_number"][$x];$z++){
775.                                 $strikeTemp["strike"]="strike_value_".$x."_".$y."_".$z;
776.                                 $strikeTemp["payout"]="payout_value_".$x."_".$y."_".$z;
777.                                 $strike[]=$strikeTemp;
778.                             }
779.                             $polygonTemp["strikes"]=$strike;
780.                             $polygon[]=$polygonTemp;
781.                         }
782.                         $structuresTemp["polygons"]=$polygon;
783.                     }
784.                     $structuresTemp["period"]=array(
785.                         "start_date"=>"start_date_value_".$x,
786.                         "end_date"=>"end_date_value_".$x
787.                     );
788.                     $structures[]=$structuresTemp;
789.                 }
790.                 $outStruct["structures"]=$structures;
791.                 return $this->json($outStruct);
792.             }else{
793.                 $response = new JsonResponse(null, 401);
794.                 $response->headers->set('Content-Type', 'application/json');
795.                 return $response;
796.             }
797.         }else{
798.             $response = new JsonResponse(null, 401);
799.             $response->headers->set('Content-Type', 'application/json');
800.             return $response;
801.         }
802.     }
803.     
804.     #[Route('/api/coverage/cat/getaggregatedpremium', name: 'CatAggregatedPremium', methods: ['POST'])]
805.     public function getCatAggregatedPremium(Request $request,EntityManagerInterface $entityManager, LoggerInterface $logger): JsonResponse
806.     {
807.         $user = $this->getUSer();
808.         if ($user){
809.             $EventCoumter = $entityManager->getRepository(Event::class)->counterTodayByUsers($user);
810.             $Menulist = $entityManager->getRepository(ProfileMenu::class)->findByProfile($user->getProfile()->getId());
811.             $control = FALSE;
812.             foreach ($Menulist as $value){
813.                 if(strpos($value->getMenu()->getMenuLink(), $request->getPathInfo()) !== false){
814.                     $control = TRUE;
815.                 }
816.             }
817.             if($control && $EventCoumter<$user->getMaxRequest()){
818.                 $logger->alert('coverage/cat/getpremium as '.$user->getUsername().' alowed');
819.                 $formData=json_decode($request->getContent(),true);
820.                 $totalIndex = array();
821.                 $min_start_date = 10000;
822.                 $max_end_date = 0;
823.                 $strucCount = 0;
824.                 if(!isset($formData["geteventnames"])){
825.                     $formData["geteventnames"] = "PAYOUT";
826.                 }
827.                 if(!isset($formData["dointerpol"])){
828.                     $formData["dointerpol"] = "YES";
829.                 }
830.                 foreach ($formData["structures"] as $key=>$value){
831.                     $product = $entityManager->getRepository(Product::class)->findOneById($value["product_id"]);
832.                     $portfolio = $entityManager->getRepository(Portfolio::class)->findOneById($product->getPortfolio());
833.                     
834.                     $strucCount = $strucCount +1;
835.                     $databaseConf = $entityManager->getRepository(ProviderDatabaseConfiguration::class)->createQueryBuilder('o')->where('o.providerDatabase = :databaseId')->andWhere('o.configuration = :config')->setParameter('databaseId', $product->getProductDatabase()->getId())->setParameter('config', 'GetCatIndex')->getQuery()->getResult();
836.                     
837.                     if(!isset($value["reference"])){
838.                         $value["reference"] = "Struc".$strucCount;
839.                         $formData["structures"][$key]["reference"] = "Struc".$strucCount;
840.                     }
841.                     
842.                     if(!isset($value["geteventnames"])){
843.                         $value["geteventnames"] = $formData["geteventnames"];
844.                         $formData["structures"][$key]["geteventnames"] = $formData["geteventnames"];
845.                     }
846.                     
847.                     if(!isset($value["units"])){
848.                         $value["units"] = "CAT";
849.                     }
850.                     
851.                     if(!isset($value["replica_period"])){
852.                         $value["replica_period"] = 30;
853.                     }
854.                     
855.                     if(!isset($value["history_length"])){
856.                         if(is_null($product->getHistoryLength())){
857.                             $formData["structures"][$key]["history_length"] = 50;
858.                         }else{
859.                             $formData["structures"][$key]["history_length"] = $product->getHistoryLength();
860.                         }
861.                     }
862.                     
863.                     $value["period"]=$formData["period"];
864.                     $formData["structures"][$key]["period"]=$formData["period"];
865.                     $value["dointerpol"]=$formData["dointerpol"];
866.                     
867.                     $indexTemp = array();
868.                     $counterLoop=0;
869.                     while(count($indexTemp)==0 && $counterLoop<3){
870.                         $counterLoop=$counterLoop+1;
871.                         $indexTemp = $entityManager->getRepository(Observation::class)->getDataLakeCatPayOut($product,$databaseConf[0]->getConfigurationValue(),json_encode($value));
872.                     }
873.                     if(count($indexTemp)!=0){
874.                         foreach ($indexTemp as $indexValues){
875.                             if(str_contains($indexValues["historic_payout_org"],':')){
876.                                 $filteredZone[$value["reference"]][] = $indexValues;
877.                             }else{
878.                                 $totalIndex[] = $indexValues;
879.                             }
880.                         }
881.                     }else{
882.                         $response = new JsonResponse($value["reference"]." Pricing error", 422);
883.                         $response->headers->set('Content-Type', 'application/json');
884.                         return $response;
885.                     }
886.                 }
887.                 $originalPayout=array();
888.                 foreach ($totalIndex as $value){
889.                     $originalPayout[] = array(
890.                         "date_year" => $value["date_year"],
891.                         "historic_payout_org" => $value["historic_payout_org"]
892.                     );
893.                 }
894.                 $Years = array_column($totalIndex,'date_year');
895.                 $totalPayout = array();
896.                 for($i=min($Years);$i<=max($Years);$i++){
897.                     $yearIndex = array_keys($Years,$i);
898.                     $total = array_fill(0, 11, 0);
899.                     foreach ($yearIndex as $value2){
900.                         $total[0] = $total[0] + $totalIndex[$value2]["historic_payout_org"];
901.                         $total[1] = $total[1] + $totalIndex[$value2]["historic_payout_varcat_minus"];
902.                         $total[2] = $total[2] + $totalIndex[$value2]["historic_payout_varcat_plus"];
903.                         $total[3] = $total[3] + $totalIndex[$value2]["historic_payout_varpoint1"];
904.                         $total[4] = $total[4] + $totalIndex[$value2]["historic_payout_varpoint2"];
905.                         $total[5] = $total[5] + $totalIndex[$value2]["historic_payout_varpoint3"];
906.                         $total[6] = $total[6] + $totalIndex[$value2]["historic_payout_varpoint4"];
907.                         $total[7] = $total[7] + $totalIndex[$value2]["historic_payout_varpoint5"];
908.                         $total[8] = $total[8] + $totalIndex[$value2]["historic_payout_varpoint6"];
909.                         $total[9] = $total[9] + $totalIndex[$value2]["historic_payout_varpoint7"];
910.                         $total[10] = $total[10] + $totalIndex[$value2]["historic_payout_varpoint8"];
911.                     }
912.                     if(!isset($formData["general_deductible"])){
913.                         $formData["general_deductible"]=0;
914.                     }
915.                     for($j=0;$j<11;$j++){
916.                         if($total[$j] < $formData["general_deductible"]){
917.                             $total[$j] = 0;
918.                         }else{
919.                             $total[$j] = $total[$j] - $formData["general_deductible"];
920.                         }
921.                         if($total[$j]>$formData["general_limit"]) $total[$j] = $formData["general_limit"];
922.                     }
923.                     $total_mean = array_sum($total)/count($total);
924.                     if($total_mean>$formData["general_limit"]){
925.                         $total_mean = $formData["general_limit"];
926.                     }
927.                     $totalPayout[]=array(
928.                         "date_year" => $i,
929.                         "total_mean" => $total_mean,
930.                         "historic_payout_org" => $total[0],
931.                         "historic_payout_varcat_minus" => $total[1],
932.                         "historic_payout_varcat_plus" => $total[2],
933.                         "historic_payout_varpoint1" => $total[3],
934.                         "historic_payout_varpoint2" => $total[4],
935.                         "historic_payout_varpoint3" => $total[5],
936.                         "historic_payout_varpoint4" => $total[6],
937.                         "historic_payout_varpoint5" => $total[7],
938.                         "historic_payout_varpoint6" => $total[8],
939.                         "historic_payout_varpoint7" => $total[9],
940.                         "historic_payout_varpoint8" => $total[10]
941.                     );
942.                 }
943.                 
944.                 $payoutMean = array_fill(0, 12, 0);
945.                 $payoutMean[0] =  array_sum(array_column($totalPayout,'total_mean'))/(count(array_column($totalPayout,'total_mean')));
946.                 $payoutMean[1] =  array_sum(array_column($totalPayout,'historic_payout_org'))/(count(array_column($totalPayout,'historic_payout_org')));
947.                 $payoutMean[2] =  array_sum(array_column($totalPayout,'historic_payout_varcat_minus'))/(count(array_column($totalPayout,'historic_payout_varcat_minus')));
948.                 $payoutMean[3] =  array_sum(array_column($totalPayout,'historic_payout_varcat_plus'))/(count(array_column($totalPayout,'historic_payout_varcat_plus')));
949.                 
950.                 for($j=4;$j<12;$j++){
951.                     $payoutMean[$j] =  array_sum(array_column($totalPayout,'historic_payout_varpoint'.($j-3)))/(count(array_column($totalPayout,'historic_payout_varpoint'.($j-3))));
952.                 }
953.                 
954.                 if(!isset($formData["load_tail"])){
955.                     $formData["load_tail"]=0.01;
956.                 }
957.                 if(!isset($formData["load_fronting"])){
958.                     $formData["load_fronting"]=0;
959.                 }
960.                 if(!isset($formData["load_brokerage"])){
961.                     $formData["load_brokerage"]=0.325;
962.                 }
963.                 if(!isset($formData["load_el"])){
964.                     $formData["load_el"]=1;
965.                 }
966.                 if(!isset($formData["load_std"])){
967.                     $formData["load_std"]=0.2;
968.                 }
969.                 if(!isset($formData["load_min"])){
970.                     $formData["load_min"]=0.02538462;
971.                 }
972.                 if(!isset($formData["load_deduction_cg"])){
973.                     $formData["load_deduction_cg"]=0.125;
974.                 }
975.                 if(!isset($formData["load_factor_uw"])){
976.                     $formData["load_factor_uw"]=0.15;
977.                 }
978.                 
979.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_org')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
980.                 $ExpectedLoss[] = $payoutMean[1];
981.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
982.                 $Iteration[] = "STRICT";
983.                 
984.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'total_mean')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
985.                 $ExpectedLoss[] = $payoutMean[0];
986.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
987.                 $Iteration[] = "AVERAGE";
988.                 
989.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_varcat_minus')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
990.                 $ExpectedLoss[] = $payoutMean[2];
991.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
992.                 $Iteration[] = "SPEED_MINUS10PCT";
993.                 
994.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_varcat_plus')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
995.                 $ExpectedLoss[] = $payoutMean[3];
996.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
997.                 $Iteration[] = "SPEED_PLUS10PCT";
998.                 
999.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_varpoint1')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
1000.                 $ExpectedLoss[] = $payoutMean[4];
1001.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
1002.                 $Iteration[] = "VAR_NORTH";
1003.                 
1004.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_varpoint2')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
1005.                 $ExpectedLoss[] = $payoutMean[5];
1006.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
1007.                 $Iteration[] = "VAR_SOUTH";
1008.                 
1009.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_varpoint3')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
1010.                 $ExpectedLoss[] = $payoutMean[6];
1011.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
1012.                 $Iteration[] = "VAR_EAST";
1013.                 
1014.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_varpoint4')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
1015.                 $ExpectedLoss[] = $payoutMean[7];
1016.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
1017.                 $Iteration[] = "VAR_WEST";
1018.                 
1019.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_varpoint5')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
1020.                 $ExpectedLoss[] = $payoutMean[8];
1021.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
1022.                 $Iteration[] = "VAR_NORTHWEST";
1023.                 
1024.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_varpoint6')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
1025.                 $ExpectedLoss[] = $payoutMean[9];
1026.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
1027.                 $Iteration[] = "VAR_NORTHEAST";
1028.                 
1029.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_varpoint7')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
1030.                 $ExpectedLoss[] = $payoutMean[10];
1031.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
1032.                 $Iteration[] = "VAR_SOUTHWEST";
1033.                 
1034.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_varpoint8')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
1035.                 $ExpectedLoss[] = $payoutMean[11];
1036.                 $Premiums[] = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
1037.                 $Iteration[] = "VAR_SOUTHEAST";
1038.                 
1039.                 $primes=array();
1040.                 foreach ($Premiums as $key => $value2){
1041.                     $primes["Analysis"][] = array(
1042.                         "Iteration" => $Iteration[$key],
1043.                         "ExpectedLoss"=> $ExpectedLoss[$key],
1044.                         "Premiums" => $Premiums[$key]
1045.                     );
1046.                 }
1047.                 
1048.                 $totalyears=max($Years)-min($Years)+1;
1050.                 for($i=min($Years);$i<=max($Years);$i++){
1051.                     $yearIndex = array_keys($Years,$i);
1052.                     $strucCount = 0;
1053.                     foreach ($yearIndex as $key=>$value2){
1054.                         $primes["Payouts"][$formData["structures"][$strucCount]["reference"]][] = array(
1055.                         //$primes["Payouts"][$formData["structures"][intval($value2/$totalyears)]["reference"]][] = array(
1056.                             "Year" => $totalIndex[$value2]["date_year"],
1057.                             "Payout" => $totalIndex[$value2]["historic_payout_org"]
1058.                         );
1059.                         $strucCount = $strucCount + 1;
1060.                     }
1061.                 }
1062.                 if (isset($filteredZone)) {
1063.                     foreach ($filteredZone as $key=>$value){
1064.                         foreach ($value as $key2=>$value2){
1065.                             if($formData["geteventnames"]=="ALL"){
1066.                                 $primes["Events"][$key][]=array(
1067.                                     "ID"=>$value2["date_year"],
1068.                                     "Name"=>$value2["historic_payout_varpoint1"],
1069.                                     "TIME"=>$value2["historic_payout_org"],
1070.                                     "LAT"=>floatval($value2["historic_payout_varcat_minus"]),
1071.                                     "LON"=>floatval($value2["historic_payout_varcat_plus"]),
1072.                                     "Mg"=>floatval($value2["historic_payout_varpoint2"]),
1073.                                     "MgSec"=>floatval($value2["historic_payout_varpoint3"])
1074.                                 );
1075.                             }else{
1076.                                 $primes["Events"][$key][]=array(
1077.                                     "ID"=>$value2["date_year"],
1078.                                     "Name"=>$value2["historic_payout_varpoint1"],
1079.                                     "TIME"=>$value2["historic_payout_org"],
1080.                                     "LAT"=>floatval($value2["historic_payout_varcat_minus"]),
1081.                                     "LON"=>floatval($value2["historic_payout_varcat_plus"]),
1082.                                     "Mg"=>floatval($value2["historic_payout_varpoint2"]),
1083.                                     "MgSec"=>floatval($value2["historic_payout_varpoint3"]),
1084.                                     "Circle"=>floatval($value2["historic_payout_varpoint7"]),
1085.                                     "PayOut"=>floatval($value2["historic_payout_varpoint8"])
1086.                                 );
1087.                             }
1088.                         }
1089.                     }
1090.                 }
1091.                 
1092.                 $EventDomain = $entityManager->getRepository(EventDomain::class)->findOneById(1);
1093.                 $EventLevel = $entityManager->getRepository(EventLevel::class)->findOneById(1);
1094.                 $EventType = $entityManager->getRepository(EventType::class)->findOneById(1);
1095.                 
1096.                 $Event = new Event();
1097.                 
1098.                 $Event->setDateEvent(new \DateTime('now'));
1099.                 $Event->setDescription('{"entry_point":"'.$request->getPathInfo().'","vivaldi_version":"'.$_ENV["VIVALDI_VERSION"].'","input_json":'.json_encode($formData).',"output_json":'.json_encode($primes).'}');
1100.                 $Event->setUsers($user);
1101.                 $Event->setEventType($EventType);
1102.                 $Event->setEventDomain($EventDomain);
1103.                 $Event->setEventLevel($EventLevel);
1104.                 
1105.                 
1106.                 $entityManager->persist($Event);
1107.                 $entityManager->flush();
1108.                 $primes["Reference"] = $Event->getId();
1109.                 $primes["VivaldiVersion"] = $_ENV["VIVALDI_VERSION"];
1110.                 $primes["Time"] = $Event->getDateEvent();
1111.                 
1112.                 return $this->json($primes);
1113.             }else{
1114.                 $response = new JsonResponse(null, 401);
1115.                 $response->headers->set('Content-Type', 'application/json');
1116.                 return $response;
1117.             }
1118.         }else{
1119.             $response = new JsonResponse(null, 401);
1120.             $response->headers->set('Content-Type', 'application/json');
1121.             return $response;
1122.         }
1123.     }
1124.     
1125.     #[Route('/api/coverage/cat/getaggregatedpremiumstruc', name: 'CatAggregatedPremiumStruc', methods: ['POST'])]
1126.     public function getCatAggregatedPremiumStruc(Request $request,EntityManagerInterface $entityManager, LoggerInterface $logger): JsonResponse
1127.     {
1128.         $user = $this->getUSer();
1129.         if ($user){
1130.             $EventCoumter = $entityManager->getRepository(Event::class)->counterTodayByUsers($user);
1131.             $Menulist = $entityManager->getRepository(ProfileMenu::class)->findByProfile($user->getProfile()->getId());
1132.             $control = FALSE;
1133.             foreach ($Menulist as $value){
1134.                 if(strpos($value->getMenu()->getMenuLink(), $request->getPathInfo()) !== false){
1135.                     $control = TRUE;
1136.                 }
1137.             }
1138.             if($control && $EventCoumter<$user->getMaxRequest()){
1139.                 $logger->alert('coverage/getcatpremium as '.$user->getUsername().' alowed');
1140.                 $formData=json_decode($request->getContent(),true);
1141.                 $outStruct["general_limit"]= "general_limit_value";
1142.                 $outStruct["period"]=array(
1143.                     "start_date"=>"start_date_value",
1144.                     "end_date"=>"end_date_value"
1145.                 );
1146.                 for($x=0;$x<$formData["structures"];$x++){
1147.                     $structuresTemp = array();
1148.                     $structuresTemp["reference"]="reference_value_".$x;
1149.                     $structuresTemp["limit"]="limit_value_".$x;
1150.                     $structuresTemp["product_id"]="product_id_value_".$x;
1151.                     if($formData["form_type"][$x]=="rings"){
1152.                         $structuresTemp["latitude"]="latitude_value_".$x;
1153.                         $structuresTemp["longitude"]="longitude_value_".$x;
1154.                         $rings=array();
1155.                         unset($ringsTemp);
1156.                         for($y=0;$y<$formData["form_type_number"][$x];$y++){
1157.                             $ringsTemp["radius"]="radius_value_".$x."_".$y;
1158.                             $strike=array();
1159.                             unset($strikeTemp);
1160.                             for($z=0;$z<$formData["strikes_number"][$x];$z++){
1161.                                 $strikeTemp["strike"]="strike_value_".$x."_".$y."_".$z;
1162.                                 $strikeTemp["payout"]="payout_value_".$x."_".$y."_".$z;
1163.                                 $strike[]=$strikeTemp;
1164.                             }
1165.                             $ringsTemp["strikes"]=$strike;
1166.                             $rings[]=$ringsTemp;
1167.                         }
1168.                         $structuresTemp["rings"]=$rings;
1169.                     }else{
1170.                         $polygon=array();
1171.                         unset($polygonTemp);
1172.                         for($y=0;$y<$formData["form_type_number"][$x];$y++){
1173.                             $lat=array();
1174.                             $lon=array();
1175.                             for($z=0;$z<$formData["form_type_coord"][$x];$z++){
1176.                                 $lat[]="latitude_value_".$x."_".$y."_".$z;
1177.                                 $lon[]="longitude_value_".$x."_".$y."_".$z;
1178.                             }
1179.                             $polygonTemp["latitude"]=$lat;
1180.                             $polygonTemp["longitude"]=$lon;
1181.                             $strike=array();
1182.                             unset($strikeTemp);
1183.                             for($z=0;$z<$formData["strikes_number"][$x];$z++){
1184.                                 $strikeTemp["strike"]="strike_value_".$x."_".$y."_".$z;
1185.                                 $strikeTemp["payout"]="payout_value_".$x."_".$y."_".$z;
1186.                                 $strike[]=$strikeTemp;
1187.                             }
1188.                             $polygonTemp["strikes"]=$strike;
1189.                             $polygon[]=$polygonTemp;
1190.                         }
1191.                         $structuresTemp["polygons"]=$polygon;
1192.                     }
1193.                     $structures[]=$structuresTemp;
1194.                 }
1195.                 $outStruct["structures"]=$structures;
1196.                 return $this->json($outStruct);
1197.             }else{
1198.                 $response = new JsonResponse(null, 401);
1199.                 $response->headers->set('Content-Type', 'application/json');
1200.                 return $response;
1201.             }
1202.         }else{
1203.             $response = new JsonResponse(null, 401);
1204.             $response->headers->set('Content-Type', 'application/json');
1205.             return $response;
1206.         }
1207.     }
1208.     
1209.     #[Route('/api/external/cat/getpremium', name: 'ExtCatPremium', methods: ['POST'])]
1210.     public function getExtCatPremium(Request $request,EntityManagerInterface $entityManager, LoggerInterface $logger): JsonResponse
1211.     {
1212.         $user = $this->getUSer();
1213.         if ($user){
1214.             $EventCoumter = $entityManager->getRepository(Event::class)->counterTodayByUsers($user);
1215.             $Menulist = $entityManager->getRepository(ProfileMenu::class)->findByProfile($user->getProfile()->getId());
1216.             $control = FALSE;
1217.             foreach ($Menulist as $value){
1218.                 if(strpos($value->getMenu()->getMenuLink(), $request->getPathInfo()) !== false){
1219.                     $control = TRUE;
1220.                 }
1221.             }
1222.             if($control && $EventCoumter<$user->getMaxRequest()){
1223.                 $logger->alert('coverage/cat/getpremium as '.$user->getUsername().' alowed');
1224.                 $formData=json_decode($request->getContent(),true);
1225.                 $totalIndex = array();
1226.                 $product = $entityManager->getRepository(Product::class)->findOneById($formData["product_id"]);
1227.                 $portfolio = $entityManager->getRepository(Portfolio::class)->findOneById($product->getPortfolio());
1228.                 $min_start_date = 10000;
1229.                 $max_end_date = 0;
1230.                 $strucCount = 0;
1231.                 if(!isset($formData["geteventnames"])){
1232.                     $formData["geteventnames"] = "PAYOUT";
1233.                 }
1234.                 if(!isset($formData["dointerpol"])){
1235.                     $formData["dointerpol"] = "YES";
1236.                 }
1237.                 
1238.                 $formData["structures"][1]=$formData["structures"][0];
1239.                 $formData["structures"][0]["period"]["start_date"]="1945-01-01";
1240.                 $formData["structures"][0]["period"]["end_date"]=(date("Y")-1)."-12-31";
1241.                 $formData["structures"][1]["period"]["start_date"]="1970-01-01";
1242.                 $formData["structures"][1]["period"]["end_date"]=(date("Y")-1)."-12-31";
1243.                 
1244.                 $key=0;
1245.                 $value=$formData["structures"][$key];
1246.                 
1247.                     $strucCount = $strucCount +1;
1248.                     $databaseConf = $entityManager->getRepository(ProviderDatabaseConfiguration::class)->createQueryBuilder('o')->where('o.providerDatabase = :databaseId')->andWhere('o.configuration = :config')->setParameter('databaseId', $product->getProductDatabase()->getId())->setParameter('config', 'GetCatIndex')->getQuery()->getResult();
1249.                     
1250.                     if(!isset($value["reference"])){
1251.                         $value["reference"] = "Struc".$strucCount;
1252.                         $formData["structures"][$key]["reference"] = "Struc".$strucCount;
1253.                     }
1254.                     
1255.                     if(!isset($value["geteventnames"])){
1256.                         $value["geteventnames"] = $formData["geteventnames"];
1257.                         $formData["structures"][$key]["geteventnames"] = $formData["geteventnames"];
1258.                     }
1259.                     
1260.                     if(!isset($value["units"])){
1261.                         $value["units"] = "CAT";
1262.                     }
1263.                     
1264.                     if(!isset($value["replica_period"])){
1265.                         $value["replica_period"] = 30;
1266.                     }
1267.                     
1268.                     $value["dointerpol"]=$formData["dointerpol"];
1269.                     
1270.                     $indexTemp = array();
1271.                     $counterLoop=0;
1272.                     while(count($indexTemp)==0 && $counterLoop<3){
1273.                         $counterLoop=$counterLoop+1;
1274.                         $indexTemp = $entityManager->getRepository(Observation::class)->getDataLakeCatPayOut($product,$databaseConf[0]->getConfigurationValue(),json_encode($value));
1275.                     }
1276.                     if(count($indexTemp)!=0){
1277.                         foreach ($indexTemp as $indexValues){
1278.                             if(!str_contains($indexValues["historic_payout_org"],':')){
1279.                                 $totalIndex[$key][] = $indexValues;
1280.                             }
1281.                         }
1282.                     }else{
1283.                         $response = new JsonResponse($value["reference"]." Pricing error", 422);
1284.                         $response->headers->set('Content-Type', 'application/json');
1285.                         return $response;
1286.                     }
1287.                     
1288.                     $key=$key+1;
1289.                     $value=$formData["structures"][$key];
1290.                     
1291.                     $strucCount = $strucCount +1;
1292.                     $databaseConf = $entityManager->getRepository(ProviderDatabaseConfiguration::class)->createQueryBuilder('o')->where('o.providerDatabase = :databaseId')->andWhere('o.configuration = :config')->setParameter('databaseId', $product->getProductDatabase()->getId())->setParameter('config', 'GetCatIndex')->getQuery()->getResult();
1293.                     
1294.                     if(!isset($value["reference"])){
1295.                         $value["reference"] = "Struc".$strucCount;
1296.                         $formData["structures"][$key]["reference"] = "Struc".$strucCount;
1297.                     }
1298.                     
1299.                     if(!isset($value["geteventnames"])){
1300.                         $value["geteventnames"] = $formData["geteventnames"];
1301.                         $formData["structures"][$key]["geteventnames"] = $formData["geteventnames"];
1302.                     }
1303.                     
1304.                     if(!isset($value["units"])){
1305.                         $value["units"] = "CAT";
1306.                     }
1307.                     
1308.                     if(!isset($value["replica_period"])){
1309.                         $value["replica_period"] = 30;
1310.                     }
1311.                     
1312.                     $value["dointerpol"]=$formData["dointerpol"];
1313.                     
1314.                     if(count($indexTemp)!=0){
1315.                         foreach ($indexTemp as $indexValues){
1316.                             if(!str_contains($indexValues["historic_payout_org"],':')){
1317.                                 if(intval($indexValues["date_year"])>=1970){
1318.                                     $totalIndex[$key][] = $indexValues;
1319.                                 }
1320.                             }
1321.                         }
1322.                     }else{
1323.                         $response = new JsonResponse($value["reference"]." Pricing error", 422);
1324.                         $response->headers->set('Content-Type', 'application/json');
1325.                         return $response;
1326.                     }
1328.                     if(!isset($formData["general_deductible"])){
1329.                         $formData["general_deductible"]=0;
1330.                     }
1331.                     
1332.                     for ($i = 0; $i <= 1; $i++) {
1333.                         foreach ($totalIndex[$i] as $key=>$value){
1334.                             if($totalIndex[$i][$key]["historic_payout_org"] < $formData["general_deductible"]){
1335.                                 $totalIndex[$i][$key]["historic_payout_org"] = 0;
1336.                             }else{
1337.                                 $totalIndex[$i][$key]["historic_payout_org"] = $totalIndex[$i][$key]["historic_payout_org"] - $formData["general_deductible"];
1338.                             }
1339.                             if($totalIndex[$i][$key]["historic_payout_org"]>$formData["general_limit"]) $totalIndex[$i][$key]["historic_payout_org"] = $formData["general_limit"];
1340.                         }
1341.                     }
1342.                     
1343.                 if(!isset($formData["load_tail"])){
1344.                     $formData["load_tail"]=0.01;
1345.                 }
1346.                 if(!isset($formData["load_fronting"])){
1347.                     $formData["load_fronting"]=0;
1348.                 }
1349.                 if(!isset($formData["load_brokerage"])){
1350.                     $formData["load_brokerage"]=0.325;
1351.                 }
1352.                 if(!isset($formData["load_el"])){
1353.                     $formData["load_el"]=1;
1354.                 }
1355.                 if(!isset($formData["load_std"])){
1356.                     $formData["load_std"]=0.2;
1357.                 }
1358.                 if(!isset($formData["load_min"])){
1359.                     $formData["load_min"]=0.02538462;
1360.                 }
1361.                 if(!isset($formData["load_deduction_cg"])){
1362.                     $formData["load_deduction_cg"]=0.125;
1363.                 }
1364.                 if(!isset($formData["load_factor_uw"])){
1365.                     $formData["load_factor_uw"]=0.15;
1366.                 }
1367.                 
1368.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalIndex[0],'date_year'),"historic_payout"=>array_column($totalIndex[0],'historic_payout_org')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
1369.                 $Premium = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
1370.                 
1371.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalIndex[1],'date_year'),"historic_payout"=>array_column($totalIndex[1],'historic_payout_org')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
1372.                 $Premium = ($Premium + $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium)))/2;
1373.                 
1374.                 $primes["Analysis"][] = array(
1375.                     "Premiums" => $Premium
1376.                 );
1377.                 
1378.                 foreach ($totalIndex[1] as $value){
1379.                     $primes["Payouts"][] = array(
1380.                         "Year" => $value["date_year"],
1381.                         "Payout" => $value["historic_payout_org"]
1382.                     );
1383.                 }
1385.                 $EventDomain = $entityManager->getRepository(EventDomain::class)->findOneById(1);
1386.                 $EventLevel = $entityManager->getRepository(EventLevel::class)->findOneById(1);
1387.                 $EventType = $entityManager->getRepository(EventType::class)->findOneById(1);
1388.                 
1389.                 $Event = new Event();
1390.                 
1391.                 $Event->setDateEvent(new \DateTime('now'));
1392.                 $Event->setDescription('{"entry_point":"'.$request->getPathInfo().'","vivaldi_version":"'.$_ENV["VIVALDI_VERSION"].'","input_json":'.json_encode($formData).',"output_json":'.json_encode($primes).'}');
1393.                 $Event->setUsers($user);
1394.                 $Event->setEventType($EventType);
1395.                 $Event->setEventDomain($EventDomain);
1396.                 $Event->setEventLevel($EventLevel);
1397.                 
1398.                 
1399.                 $entityManager->persist($Event);
1400.                 $entityManager->flush();
1401.                 $primes["Reference"] = $Event->getId();
1402.                 $primes["VivaldiVersion"] = $_ENV["VIVALDI_VERSION"];
1403.                 $primes["Time"] = $Event->getDateEvent();
1404.                 
1405.                 return $this->json($primes);
1406.             }else{
1407.                 $response = new JsonResponse(null, 401);
1408.                 $response->headers->set('Content-Type', 'application/json');
1409.                 return $response;
1410.             }
1411.         }else{
1412.             $response = new JsonResponse(null, 401);
1413.             $response->headers->set('Content-Type', 'application/json');
1414.             return $response;
1415.         }
1416.     }
1417.     
1419.     #[Route('/api/partners/getmultipremium', name: 'PartnerMultiPremium', methods: ['POST'])]
1420.     public function getPartnerMultiPremium(Request $request,EntityManagerInterface $entityManager, LoggerInterface $logger): JsonResponse
1421.     {
1422.         $user = $this->getUSer();
1423.         if ($user){
1424.             $EventCoumter = $entityManager->getRepository(Event::class)->counterTodayByUsers($user);
1425.             $Menulist = $entityManager->getRepository(ProfileMenu::class)->findByProfile($user->getProfile()->getId());
1426.             $control = FALSE;
1427.             foreach ($Menulist as $value){
1428.                 if(strpos($value->getMenu()->getMenuLink(), $request->getPathInfo()) !== false){
1429.                     $control = TRUE;
1430.                 }
1431.             }
1432.             if($control && $EventCoumter<$user->getMaxRequest()){
1433.                 $logger->alert('partners/getmultipremium as '.$user->getUsername().' alowed');
1434.                 $formData=json_decode($request->getContent(),true);
1435.                 $min_start_date = 10000;
1436.                 $max_end_date = 0;
1437.                 $strucCount = 0;
1438.                 $formData["dointerpol"] = "YES";
1439.                 
1440.                 foreach ($formData["structures"] as $key=>$value){
1441.                     $totalIndex = array();
1442.                     $filteredZone = array();
1443.                     $strucCount=$strucCount+1;
1444.                     $product = $entityManager->getRepository(Product::class)->findOneById($value["product_id"]);
1445.                     $portfolio = $entityManager->getRepository(Portfolio::class)->findOneById($product->getPortfolio());
1446.                     $databaseConf = $entityManager->getRepository(ProviderDatabaseConfiguration::class)->createQueryBuilder('o')->where('o.providerDatabase = :databaseId')->andWhere('o.configuration = :config')->setParameter('databaseId', $product->getProductDatabase()->getId())->setParameter('config', 'GetCatIndex')->getQuery()->getResult();
1447.                     
1448.                     if(!isset($value["reference"])){
1449.                         $value["reference"] = "Struc".$strucCount;
1450.                         $formData["structures"][$key]["reference"] = "Struc".$strucCount;
1451.                     }
1452.                     
1453.                     if(!isset($value["geteventnames"])){
1454.                         if(!isset($formData["geteventnames"])){
1455.                             $value["geteventnames"] = "PAYOUT";
1456.                             $formData["structures"][$key]["geteventnames"] = "PAYOUT";
1457.                         }else{
1458.                             $value["geteventnames"] = $formData["geteventnames"];
1459.                             $formData["structures"][$key]["geteventnames"] = $formData["geteventnames"];
1460.                         }
1461.                     }
1462.                     
1463.                     
1464.                     $value["replica_period"] = 30;
1465.                     $formData["structures"][$key]["replica_period"] = 30;
1466.                     
1467.                     if(is_null($product->getHistoryLength())){
1468.                         $formData["structures"][$key]["history_length"] = 50;
1469.                     }else{
1470.                         $formData["structures"][$key]["history_length"] = $product->getHistoryLength();
1471.                     }
1472.                     
1473.                     if($value["product_id"]==2 || $value["product_id"]==3){
1474.                         $value["period"]=array("start_date" => "1970-01-01",
1475.                             "end_date" => (intval(date("Y"))-1)."-12-31");
1476.                         $formData["structures"][$key]["period"]=$value["period"];
1477.                     }elseif ($value["product_id"]==8){
1478.                         $value["period"]=array("start_date" => "1925-01-01",
1479.                             "end_date" => (intval(date("Y"))-1)."-12-31");
1480.                         $formData["structures"][$key]["period"]=$value["period"];
1481.                     }else{
1482.                         $response = new JsonResponse("Missing Product", 400);
1483.                         $response->headers->set('Content-Type', 'application/json');
1484.                         return $response;
1485.                     }
1486.                     
1487.                     $value["dointerpol"]=$formData["dointerpol"];
1488.                     
1489.                     $indexTemp = array();
1490.                     $counterLoop=0;
1491.                     while(count($indexTemp)==0 && $counterLoop<6){
1492.                         $counterLoop=$counterLoop+1;
1493.                         $indexTemp = $entityManager->getRepository(Observation::class)->getDataLakeCatPayOut($product,$databaseConf[0]->getConfigurationValue(),json_encode($value));
1494.                     }
1495.                     
1496.                     if(count($indexTemp)==0){
1497.                         $response = new JsonResponse($value["reference"]." Pricing error", 422);
1498.                         $response->headers->set('Content-Type', 'application/json');
1499.                         return $response;
1500.                     }else{
1501.                         foreach ($indexTemp as $indexValues){
1502.                             if(str_contains($indexValues["historic_payout_org"],':')){
1503.                                 $filteredZone[] = $indexValues;
1504.                             }else{
1505.                                 $totalIndex[] = $indexValues;
1506.                             }
1507.                         }
1508.                         if(!isset($formData["general_deductible"])){
1509.                             $formData["general_deductible"]=0;
1510.                         }
1511.                         if(!isset($value["limit"])){
1512.                             $limit = $formData["general_limit"];
1513.                         }else{
1514.                             $limit = $value["limit"];
1515.                         }
1516.                         $counterLoop=0;
1517.                         foreach ($totalIndex as $indexkey=>$indexvalue){
1518.                             foreach ($indexvalue as $indexkey2=>$indexvalue2){
1519.                                 if($indexkey2!="date_year"){
1520.                                     if($indexvalue2 < $formData["general_deductible"]){
1521.                                         $indexvalue2 = 0;
1522.                                     }else{
1523.                                         $indexvalue2 = $indexvalue2 - $formData["general_deductible"];
1524.                                     }
1525.                                     if($indexvalue2>$limit) $indexvalue2 = $limit;
1526.                                     $totalIndex[$indexkey][$indexkey2]=$indexvalue2;
1527.                                     $payoutMean[$counterLoop]["historic_payout"]=$payoutMean[$counterLoop]["historic_payout"]+$indexvalue2;
1528.                                 }else{
1529.                                     $payoutMean[$counterLoop]=array(
1530.                                         "date_year"=>$totalIndex[$indexkey]["date_year"],
1531.                                         "historic_payout"=>0
1532.                                         
1533.                                     );
1534.                                 }
1535.                             }
1536.                             $payoutMean[$counterLoop]["historic_payout"]=$payoutMean[$counterLoop]["historic_payout"]/(count($indexvalue)-1);
1537.                             $counterLoop=$counterLoop+1;
1538.                         }
1539.                         
1540.                         $formData["load_tail"]=(1 + (sqrt(intval(date("j")))/20))/100;
1542.                         $formData["load_fronting"]=0;
1543.                         
1544.                         $formData["load_brokerage"]=0.325;
1546.                         $formData["load_el"]=1;
1548.                         $formData["load_std"]=0.2;
1550.                         $formData["load_min"]=0.02538462;
1552.                         $formData["load_deduction_cg"]=0.125;
1554.                         $formData["load_factor_uw"]=0.15;
1555.                         
1556.                         $jsonPremium=array("payout"=>array("date_year"=>array_column($totalIndex,'date_year'),"historic_payout"=>array_column($totalIndex,'historic_payout_org')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
1557.                         $PremiumsStrict = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
1558.                         
1559.                         $jsonPremium=array("payout"=>array("date_year"=>array_column($payoutMean,'date_year'),"historic_payout"=>array_column($payoutMean,'historic_payout')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
1560.                         $PremiumAVG = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
1561.                         
1562.                         $primes[$value["reference"]]["Analysis"][] = array(
1563.                             "Premium" => max($PremiumAVG,$PremiumsStrict) 
1564.                         );
1565.                     }
1566.                 }
1567.                 
1568.                 $EventDomain = $entityManager->getRepository(EventDomain::class)->findOneById(1);
1569.                 $EventLevel = $entityManager->getRepository(EventLevel::class)->findOneById(1);
1570.                 $EventType = $entityManager->getRepository(EventType::class)->findOneById(1);
1571.                 
1572.                 $Event = new Event();
1573.                 
1574.                 $Event->setDateEvent(new \DateTime('now'));
1575.                 $Event->setDescription('{"entry_point":"'.$request->getPathInfo().'","vivaldi_version":"'.$_ENV["VIVALDI_VERSION"].'","input_json":'.json_encode($formData).',"output_json":'.json_encode($primes).'}');
1576.                 $Event->setUsers($user);
1577.                 $Event->setEventType($EventType);
1578.                 $Event->setEventDomain($EventDomain);
1579.                 $Event->setEventLevel($EventLevel);
1580.                 
1581.                 
1582.                 $entityManager->persist($Event);
1583.                 $entityManager->flush();
1584.                 $primes["Reference"] = $Event->getId();
1585.                 $primes["VivaldiVersion"] = $_ENV["VIVALDI_VERSION"];
1586.                 $primes["Time"] = $Event->getDateEvent();
1587.                 
1588.                 return $this->json($primes);
1589.             }else{
1590.                 $response = new JsonResponse(null, 401);
1591.                 $response->headers->set('Content-Type', 'application/json');
1592.                 return $response;
1593.             }
1594.         }else{
1595.             $response = new JsonResponse(null, 401);
1596.             $response->headers->set('Content-Type', 'application/json');
1597.             return $response;
1598.         }
1599.     }
1601.     #[Route('/api/partners/getaggregatedpremium', name: 'PartnerAggregatedPremium', methods: ['POST'])]
1602.     public function getPartnerAggregatedPremium(Request $request, EntityManagerInterface $entityManager, LoggerInterface $logger): JsonResponse
1603.     {
1604.         $user = $this->getUSer();
1605.         if ($user){
1606.             $EventCoumter = $entityManager->getRepository(Event::class)->counterTodayByUsers($user);
1607.             $Menulist = $entityManager->getRepository(ProfileMenu::class)->findByProfile($user->getProfile()->getId());
1608.             $control = FALSE;
1609.             foreach ($Menulist as $value){
1610.                 if(strpos($value->getMenu()->getMenuLink(), $request->getPathInfo()) !== false){
1611.                     $control = TRUE;
1612.                 }
1613.             }
1614.             if($control && $EventCoumter<$user->getMaxRequest()){
1615.                 $logger->alert('coverage/cat/getpremium as '.$user->getUsername().' alowed');
1616.                 $formData=json_decode($request->getContent(),true);
1617.                 $totalIndex = array();
1618.                 $min_start_date = 10000;
1619.                 $max_end_date = 0;
1620.                 $strucCount = 0;
1621.                 
1622.                 $formData["geteventnames"] = "PAYOUT";
1623.                 $formData["dointerpol"] = "YES";
1625.                 foreach ($formData["structures"] as $key=>$value){
1626.                     $product = $entityManager->getRepository(Product::class)->findOneById($value["product_id"]);
1627.                     $portfolio = $entityManager->getRepository(Portfolio::class)->findOneById($product->getPortfolio());
1628.                     
1629.                     if($value["product_id"]==2 || $value["product_id"]==3){
1630.                         $value["period"]=array("start_date" => "1970-01-01",
1631.                             "end_date" => (intval(date("Y"))-1)."-12-31");
1632.                         $formData["structures"][$key]["period"]=$value["period"];
1633.                     }elseif ($value["product_id"]==8){
1634.                         $value["period"]=array("start_date" => "1925-01-01",
1635.                             "end_date" => (intval(date("Y"))-1)."-12-31");
1636.                         $formData["structures"][$key]["period"]=$value["period"];
1637.                     }else{
1638.                         $response = new JsonResponse("Missing Product", 400);
1639.                         $response->headers->set('Content-Type', 'application/json');
1640.                         return $response;
1641.                     }
1642.                     
1643.                     $strucCount = $strucCount +1;
1644.                     $databaseConf = $entityManager->getRepository(ProviderDatabaseConfiguration::class)->createQueryBuilder('o')->where('o.providerDatabase = :databaseId')->andWhere('o.configuration = :config')->setParameter('databaseId', $product->getProductDatabase()->getId())->setParameter('config', 'GetCatIndex')->getQuery()->getResult();
1645.                     
1646.                     if(!isset($value["reference"])){
1647.                         $value["reference"] = "Struc".$strucCount;
1648.                         $formData["structures"][$key]["reference"] = "Struc".$strucCount;
1649.                     }
1650.                     
1651.                     $value["geteventnames"] = $formData["geteventnames"];
1652.                     $formData["structures"][$key]["geteventnames"] = $formData["geteventnames"];
1653.                     
1654.                     if(!isset($value["units"])){
1655.                         $value["units"] = "CAT";
1656.                     }
1657.                     
1658.                     $value["replica_period"] = 30;
1659.                     $formData["structures"][$key]["replica_period"] = 30;
1660.                     
1661.                     if(is_null($product->getHistoryLength())){
1662.                         $formData["structures"][$key]["history_length"] = 50;
1663.                         $value["history_length"] = 50;
1664.                     }else{
1665.                         $formData["structures"][$key]["history_length"] = $product->getHistoryLength();
1666.                         $value["history_length"] = $product->getHistoryLength();
1667.                     }
1669.                     $value["dointerpol"]=$formData["dointerpol"];
1670.                     
1671.                     $indexTemp = array();
1672.                     $counterLoop=0;
1673.                     while(count($indexTemp)==0 && $counterLoop<3){
1674.                         $counterLoop=$counterLoop+1;
1675.                         $indexTemp = $entityManager->getRepository(Observation::class)->getDataLakeCatPayOut($product,$databaseConf[0]->getConfigurationValue(),json_encode($value));
1676.                     }
1677.                     if(count($indexTemp)!=0){
1678.                         foreach ($indexTemp as $indexValues){
1679.                             if(str_contains($indexValues["historic_payout_org"],':')){
1680.                                 $filteredZone[$value["reference"]][] = $indexValues;
1681.                             }else{
1682.                                 $totalIndex[] = $indexValues;
1683.                             }
1684.                         }
1685.                     }else{
1686.                         $response = new JsonResponse($value["reference"]." Pricing error", 422);
1687.                         $response->headers->set('Content-Type', 'application/json');
1688.                         return $response;
1689.                     }
1690.                 }
1691.                 $originalPayout=array();
1692.                 foreach ($totalIndex as $value){
1693.                     $originalPayout[] = array(
1694.                         "date_year" => $value["date_year"],
1695.                         "historic_payout_org" => $value["historic_payout_org"]
1696.                     );
1697.                 }
1698.                 $Years = array_column($totalIndex,'date_year');
1699.                 $totalPayout = array();
1700.                 for($i=min($Years);$i<=max($Years);$i++){
1701.                     $yearIndex = array_keys($Years,$i);
1702.                     $total = array_fill(0, 11, 0);
1703.                     foreach ($yearIndex as $value2){
1704.                         $total[0] = $total[0] + $totalIndex[$value2]["historic_payout_org"];
1705.                         $total[1] = $total[1] + $totalIndex[$value2]["historic_payout_varcat_minus"];
1706.                         $total[2] = $total[2] + $totalIndex[$value2]["historic_payout_varcat_plus"];
1707.                         $total[3] = $total[3] + $totalIndex[$value2]["historic_payout_varpoint1"];
1708.                         $total[4] = $total[4] + $totalIndex[$value2]["historic_payout_varpoint2"];
1709.                         $total[5] = $total[5] + $totalIndex[$value2]["historic_payout_varpoint3"];
1710.                         $total[6] = $total[6] + $totalIndex[$value2]["historic_payout_varpoint4"];
1711.                         $total[7] = $total[7] + $totalIndex[$value2]["historic_payout_varpoint5"];
1712.                         $total[8] = $total[8] + $totalIndex[$value2]["historic_payout_varpoint6"];
1713.                         $total[9] = $total[9] + $totalIndex[$value2]["historic_payout_varpoint7"];
1714.                         $total[10] = $total[10] + $totalIndex[$value2]["historic_payout_varpoint8"];
1715.                     }
1716.                     if(!isset($formData["general_deductible"])){
1717.                         $formData["general_deductible"]=0;
1718.                     }
1719.                     for($j=0;$j<11;$j++){
1720.                         if($total[$j] < $formData["general_deductible"]){
1721.                             $total[$j] = 0;
1722.                         }else{
1723.                             $total[$j] = $total[$j] - $formData["general_deductible"];
1724.                         }
1725.                         if($total[$j]>$formData["general_limit"]) $total[$j] = $formData["general_limit"];
1726.                     }
1727.                     $total_mean = array_sum($total)/count($total);
1728.                     if($total_mean>$formData["general_limit"]){
1729.                         $total_mean = $formData["general_limit"];
1730.                     }
1731.                     $totalPayout[]=array(
1732.                         "date_year" => $i,
1733.                         "total_mean" => $total_mean,
1734.                         "historic_payout_org" => $total[0],
1735.                         "historic_payout_varcat_minus" => $total[1],
1736.                         "historic_payout_varcat_plus" => $total[2],
1737.                         "historic_payout_varpoint1" => $total[3],
1738.                         "historic_payout_varpoint2" => $total[4],
1739.                         "historic_payout_varpoint3" => $total[5],
1740.                         "historic_payout_varpoint4" => $total[6],
1741.                         "historic_payout_varpoint5" => $total[7],
1742.                         "historic_payout_varpoint6" => $total[8],
1743.                         "historic_payout_varpoint7" => $total[9],
1744.                         "historic_payout_varpoint8" => $total[10]
1745.                     );
1746.                 }
1747.                 
1748.                 $payoutMean = array_fill(0, 12, 0);
1749.                 $payoutMean[0] =  array_sum(array_column($totalPayout,'total_mean'))/(count(array_column($totalPayout,'total_mean')));
1750.                 $payoutMean[1] =  array_sum(array_column($totalPayout,'historic_payout_org'))/(count(array_column($totalPayout,'historic_payout_org')));
1751.                 $payoutMean[2] =  array_sum(array_column($totalPayout,'historic_payout_varcat_minus'))/(count(array_column($totalPayout,'historic_payout_varcat_minus')));
1752.                 $payoutMean[3] =  array_sum(array_column($totalPayout,'historic_payout_varcat_plus'))/(count(array_column($totalPayout,'historic_payout_varcat_plus')));
1753.                 
1754.                 for($j=4;$j<12;$j++){
1755.                     $payoutMean[$j] =  array_sum(array_column($totalPayout,'historic_payout_varpoint'.($j-3)))/(count(array_column($totalPayout,'historic_payout_varpoint'.($j-3))));
1756.                 }
1757.                 
1758.                 $formData["load_tail"]=(1 + (sqrt(intval(date("j")))/20))/100;
1760.                 $formData["load_fronting"]=0;
1762.                 $formData["load_brokerage"]=0.325;
1764.                 $formData["load_el"]=1;
1766.                 $formData["load_std"]=0.2;
1768.                 $formData["load_min"]=0.02538462;
1770.                 $formData["load_deduction_cg"]=0.125;
1772.                 $formData["load_factor_uw"]=0.15;
1774.                 
1775.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'historic_payout_org')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
1776.                 $PremiumStrict = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
1777.                 
1778.                 
1779.                 $jsonPremium=array("payout"=>array("date_year"=>array_column($totalPayout,'date_year'),"historic_payout"=>array_column($totalPayout,'total_mean')),"risk_taker"=>$portfolio->getThirdParty()->getAlgorithm(),"inputjson"=>$formData);
1780.                 $PremiumAVG = $entityManager->getRepository(Coverage::class)->getPremium(json_encode($jsonPremium));
1781.                 
1782.                 $primes=array();
1783.                 $primes["Analysis"][] = array(
1784.                     "Premium" => max($PremiumAVG,$PremiumStrict) 
1785.                 );
1786.                 
1787.                 $EventDomain = $entityManager->getRepository(EventDomain::class)->findOneById(1);
1788.                 $EventLevel = $entityManager->getRepository(EventLevel::class)->findOneById(1);
1789.                 $EventType = $entityManager->getRepository(EventType::class)->findOneById(1);
1790.                 
1791.                 $Event = new Event();
1792.                 
1793.                 $Event->setDateEvent(new \DateTime('now'));
1794.                 $Event->setDescription('{"entry_point":"'.$request->getPathInfo().'","vivaldi_version":"'.$_ENV["VIVALDI_VERSION"].'","input_json":'.json_encode($formData).',"output_json":'.json_encode($primes).'}');
1795.                 $Event->setUsers($user);
1796.                 $Event->setEventType($EventType);
1797.                 $Event->setEventDomain($EventDomain);
1798.                 $Event->setEventLevel($EventLevel);
1799.                 
1800.                 
1801.                 $entityManager->persist($Event);
1802.                 $entityManager->flush();
1803.                 $primes["Reference"] = $Event->getId();
1804.                 $primes["VivaldiVersion"] = $_ENV["VIVALDI_VERSION"];
1805.                 $primes["Time"] = $Event->getDateEvent();
1806.                 
1807.                 return $this->json($primes);
1808.             }else{
1809.                 $response = new JsonResponse(null, 401);
1810.                 $response->headers->set('Content-Type', 'application/json');
1811.                 return $response;
1812.             }
1813.         }else{
1814.             $response = new JsonResponse(null, 401);
1815.             $response->headers->set('Content-Type', 'application/json');
1816.             return $response;
1817.         }
1818.     }
1819.     
1820.     #[Route('/api/coverage', name: 'app_coverage')]
1821.     public function index(): JsonResponse
1822.     {
1823.         return $this->json([
1824.             'message' => 'Welcome to your new controller!',
1825.             'path' => 'src/Controller/CoverageController.php',
1826.         ]);
1827.     }
1828. }