From: Raphaël Gertz <git@rapsys.eu>
Date: Tue, 4 Oct 2022 06:53:52 +0000 (+0200)
Subject: Add Slot and Snippet table replacement
X-Git-Tag: 0.3.0~225
X-Git-Url: https://git.rapsys.eu/airbundle/commitdiff_plain/98712a3906dc1845c209112d0f0cb3303d1a4353

Add Slot and Snippet table replacement
Add accuweather, delay, group, slot and other common replacements
Cleanup
---

diff --git a/Repository/EntityRepository.php b/Repository/EntityRepository.php
index e9322b7..fb07c0b 100644
--- a/Repository/EntityRepository.php
+++ b/Repository/EntityRepository.php
@@ -110,11 +110,41 @@ class EntityRepository extends BaseEntityRepository {
 			'RapsysAirBundle:Group' => $qs->getTableName($manager->getClassMetadata('RapsysAirBundle:Group'), $dp),
 			'RapsysAirBundle:Location' => $qs->getTableName($manager->getClassMetadata('RapsysAirBundle:Location'), $dp),
 			'RapsysAirBundle:Session' => $qs->getTableName($manager->getClassMetadata('RapsysAirBundle:Session'), $dp),
+			'RapsysAirBundle:Slot' => $qs->getTableName($manager->getClassMetadata('RapsysAirBundle:Slot'), $dp),
+			'RapsysAirBundle:Snippet' => $qs->getTableName($manager->getClassMetadata('RapsysAirBundle:Snippet'), $dp),
 			'RapsysAirBundle:User' => $qs->getTableName($manager->getClassMetadata('RapsysAirBundle:User'), $dp),
-
+			//Set accuweather max number of daily pages
+			':accudaily' => 12,
+			//Set accuweather max number of hourly pages
+			':accuhourly' => 3,
+			//Set guest delay
+			':guestdelay' => 2 * 24 * 3600,
+			//Set regular delay
+			':regulardelay' => 3 * 24 * 3600,
+			//Set senior delay
+			':seniordelay' => 4 * 24 * 3600,
+			//Set guest group id
+			':guestid' => 2,
+			//Set regular group id
+			':regularid' => 3,
+			//Set senior group id
+			':seniorid' => 4,
+			//Set afternoon slot id
+			':afternoonid' => 2,
+			//Set evening slot id
+			':eveningid' => 3,
+			//Set after slot id
+			':afterid' => 4,
+			//XXX: days since last session after which guest regain normal priority
+			':guestwait' => 30,
+			//XXX: session count until considered at regular delay
+			':scount' => 5,
+			//XXX: pn_ratio over which considered at regular delay
+			':pnratio' => 1,
+			//XXX: tr_ratio diff over which considered at regular delay
+			':trdiff' => 5,
 			//XXX: Set limit used to workaround mariadb subselect optimization
 			':limit' => PHP_INT_MAX,
-			':afterid' => 4,
 			"\t" => '',
 			"\n" => ' '
 		];