X-Git-Url: https://git.rapsys.eu/airbundle/blobdiff_plain/0efda2ab5d287649787774ab57f810781b15852c..f6e5df0b39d856f05ceea3e3c784ad936530b8c4:/Repository/SessionRepository.php

diff --git a/Repository/SessionRepository.php b/Repository/SessionRepository.php
index cf79a18..dd89a98 100644
--- a/Repository/SessionRepository.php
+++ b/Repository/SessionRepository.php
@@ -183,7 +183,6 @@ SELECT
 	l.address AS l_address,
 	l.zipcode AS l_zipcode,
 	l.city AS l_city,
-	l.short AS l_short,
 	l.title AS l_title,
 	l.latitude AS l_latitude,
 	l.longitude AS l_longitude,
@@ -196,6 +195,7 @@ SELECT
 	p.description AS p_description,
 	p.class AS p_class,
 	p.short AS p_short,
+	p.hat AS p_hat,
 	p.rate AS p_rate,
 	p.contact AS p_contact,
 	p.donate AS p_donate,
@@ -232,7 +232,6 @@ SQL;
 			->addScalarResult('l_city', 'l_city', 'string')
 			->addScalarResult('l_latitude', 'l_latitude', 'float')
 			->addScalarResult('l_longitude', 'l_longitude', 'float')
-			->addScalarResult('l_short', 'l_short', 'string')
 			->addScalarResult('l_title', 'l_title', 'string')
 			->addScalarResult('t_id', 't_id', 'integer')
 			->addScalarResult('t_title', 't_title', 'string')
@@ -245,6 +244,7 @@ SQL;
 			->addScalarResult('p_description', 'p_description', 'string')
 			->addScalarResult('p_class', 'p_class', 'string')
 			->addScalarResult('p_short', 'p_short', 'string')
+			->addScalarResult('p_hat', 'p_hat', 'integer')
 			->addScalarResult('p_rate', 'p_rate', 'integer')
 			->addScalarResult('p_contact', 'p_contact', 'string')
 			->addScalarResult('p_donate', 'p_donate', 'string')
@@ -317,7 +317,6 @@ SELECT
 	s.created,
 	s.updated,
 	s.location_id AS l_id,
-	l.short AS l_short,
 	l.title AS l_title,
 	l.address AS l_address,
 	l.zipcode AS l_zipcode,
@@ -389,7 +388,6 @@ SQL;
 			->addScalarResult('created', 'created', 'datetime')
 			->addScalarResult('updated', 'updated', 'datetime')
 			->addScalarResult('l_id', 'l_id', 'integer')
-			->addScalarResult('l_short', 'l_short', 'string')
 			->addScalarResult('l_title', 'l_title', 'string')
 			->addScalarResult('l_address', 'l_address', 'string')
 			->addScalarResult('l_zipcode', 'l_zipcode', 'string')
@@ -503,7 +501,6 @@ SELECT
 	ADDDATE(ADDTIME(s.date, s.begin), INTERVAL IF(s.slot_id = :afterid, 1, 0) DAY) AS start,
 	ADDDATE(ADDTIME(ADDTIME(s.date, s.begin), s.length), INTERVAL IF(s.slot_id = :afterid, 1, 0) DAY) AS stop,
 	s.location_id AS l_id,
-	l.short AS l_short,
 	l.title AS l_title,
 	s.slot_id AS t_id,
 	t.title AS t_title,
@@ -550,7 +547,6 @@ SQL;
 			->addScalarResult('t_id', 't_id', 'integer')
 			->addScalarResult('t_title', 't_title', 'string')
 			->addScalarResult('l_id', 'l_id', 'integer')
-			->addScalarResult('l_short', 'l_short', 'string')
 			->addScalarResult('l_title', 'l_title', 'string')
 			->addScalarResult('a_id', 'a_id', 'integer')
 			->addScalarResult('a_canceled', 'a_canceled', 'datetime')
@@ -729,7 +725,7 @@ SQL;
 						'id' => $session['id'],
 						'start' => $session['start'],
 						'stop' => $session['stop'],
-						'location' => $translator->trans($session['l_short']),
+						'location' => $translator->trans($session['l_title']),
 						'pseudonym' => $pseudonym,
 						'class' => $class,
 						'slot' => self::GLYPHS[$session['t_title']],
@@ -808,7 +804,6 @@ SELECT
 	ADDDATE(ADDTIME(s.date, s.begin), INTERVAL IF(s.slot_id = :afterid, 1, 0) DAY) AS start,
 	ADDDATE(ADDTIME(ADDTIME(s.date, s.begin), s.length), INTERVAL IF(s.slot_id = :afterid, 1, 0) DAY) AS stop,
 	s.location_id AS l_id,
-	l.short AS l_short,
 	l.title AS l_title,
 	s.slot_id AS t_id,
 	t.title AS t_title,
@@ -854,7 +849,6 @@ SQL;
 			->addScalarResult('t_id', 't_id', 'integer')
 			->addScalarResult('t_title', 't_title', 'string')
 			->addScalarResult('l_id', 'l_id', 'integer')
-			->addScalarResult('l_short', 'l_short', 'string')
 			->addScalarResult('l_title', 'l_title', 'string')
 			->addScalarResult('a_id', 'a_id', 'integer')
 			->addScalarResult('au_id', 'au_id', 'integer')
@@ -1029,7 +1023,7 @@ SQL;
 						'id' => $session['id'],
 						'start' => $session['start'],
 						'stop' => $session['stop'],
-						'location' => $translator->trans($session['l_short']),
+						'location' => $translator->trans($session['l_title']),
 						'pseudonym' => $pseudonym,
 						'class' => $class,
 						'slot' => self::GLYPHS[$session['t_title']],