1 /*
2  *  Make.org Core API
3  *  Copyright (C) 2018 Make.org
4  *
5  * This program is free software: you can redistribute it and/or modify
6  *  it under the terms of the GNU Affero General Public License as
7  *  published by the Free Software Foundation, either version 3 of the
8  *  License, or (at your option) any later version.
9  *
10  *  This program is distributed in the hope that it will be useful,
11  *  but WITHOUT ANY WARRANTY; without even the implied warranty of
12  *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
13  *  GNU Affero General Public License for more details.
14  *
15  *  You should have received a copy of the GNU Affero General Public License
16  *  along with this program.  If not, see <https://www.gnu.org/licenses/>.
17  *
18  */
19 
20 package org.make.api.operation
21 
22 import java.time.{LocalDate, ZonedDateTime}
23 import cats.Show
24 import cats.data.NonEmptyList
25 import cats.implicits._
26 import eu.timepit.refined.auto._
27 import eu.timepit.refined.api.Refined
28 import eu.timepit.refined.collection._
29 import grizzled.slf4j.Logging
30 import org.make.api.extensions.MakeDBExecutionContextComponent
31 import org.make.api.operation.DefaultPersistentOperationOfQuestionServiceComponent.PersistentOperationOfQuestion
32 import org.make.api.operation.DefaultPersistentOperationOfQuestionServiceComponent.PersistentOperationOfQuestion.resultsLinkBinders
33 import org.make.api.operation.DefaultPersistentOperationServiceComponent.PersistentOperation
34 import org.make.api.question.DefaultPersistentQuestionServiceComponent.PersistentQuestion
35 import org.make.api.technical.DatabaseTransactions._
36 import org.make.api.technical.PersistentServiceUtils.sortOrderQuery
37 import org.make.api.technical.{PersistentCompanion, ShortenedNames}
38 import org.make.api.technical.ScalikeSupport._
39 import org.make.core.{DateHelper, Order}
40 import org.make.core.Validation._
41 import org.make.core.technical.{Multilingual, Pagination}
42 import org.make.core.operation._
43 import org.make.core.question.{Question, QuestionId}
44 import org.make.core.reference.{Country, Language}
45 import scalikejdbc._
46 
47 import scala.concurrent.Future
48 
49 trait DefaultPersistentOperationOfQuestionServiceComponent extends PersistentOperationOfQuestionServiceComponent {
50   this: MakeDBExecutionContextComponent =>
51 
52   override lazy val persistentOperationOfQuestionService: DefaultPersistentOperationOfQuestionService =
53     new DefaultPersistentOperationOfQuestionService
54 
55   class DefaultPersistentOperationOfQuestionService
56       extends PersistentOperationOfQuestionService
57       with ShortenedNames
58       with Logging {
59 
60     private val operationOfQuestionAlias = PersistentOperationOfQuestion.alias
61     private val operationAlias = PersistentOperation.alias
62 
63     override def search(
64       offset: Pagination.Offset,
65       end: Option[Pagination.End],
66       sort: Option[String],
67       order: Option[Order],
68       questionIds: Option[Seq[QuestionId]],
69       operationIds: Option[Seq[OperationId]],
70       operationKind: Option[Seq[OperationKind]],
71       openAt: Option[ZonedDateTime],
72       endAfter: Option[ZonedDateTime],
73       slug: Option[String]
74     ): Future[scala.Seq[OperationOfQuestion]] = {
75       implicit val context: EC = readExecutionContext
76       Future(NamedDB("READ").retryableTx { implicit session =>
77         withSQL[PersistentOperationOfQuestion] {
78           val query: scalikejdbc.PagingSQLBuilder[PersistentOperationOfQuestion] = select
79             .from(PersistentOperationOfQuestion.as(PersistentOperationOfQuestion.alias))
80             .innerJoin(PersistentOperation.as(operationAlias))
81             .on(operationOfQuestionAlias.operationId, operationAlias.uuid)
82             .innerJoin(PersistentQuestion.as(PersistentQuestion.alias))
83             .on(operationOfQuestionAlias.questionId, PersistentQuestion.alias.questionId)
84             .where(
85               sqls.toAndConditionOpt(
86                 operationIds
87                   .map(operations => sqls.in(PersistentOperationOfQuestion.alias.operationId, operations.map(_.value))),
88                 questionIds.map(
89                   questionIds => sqls.in(PersistentOperationOfQuestion.alias.questionId, questionIds.map(_.value))
90                 ),
91                 operationKind
92                   .map(operationKind => sqls.in(operationAlias.operationKind, operationKind)),
93                 openAt.map(
94                   openAt =>
95                     sqls
96                       .le(PersistentOperationOfQuestion.alias.startDate, openAt)
97                       .and(sqls.ge(PersistentOperationOfQuestion.alias.endDate, openAt))
98                 ),
99                 endAfter.map(end => sqls.ge(PersistentOperationOfQuestion.alias.endDate, end)),
100                 slug.map(s       => sqls.like(PersistentQuestion.alias.slug, s"%$s%"))
101               )
102             )
103 
104           sortOrderQuery(offset, end, sort, order, query)
105         }.map(PersistentOperationOfQuestion(operationOfQuestionAlias.resultName)).list()
106       }).map(_.map(_.toOperationOfQuestion))
107     }
108 
109     override def persist(operationOfQuestion: OperationOfQuestion): Future[OperationOfQuestion] = {
110       implicit val context: EC = writeExecutionContext
111       Future(NamedDB("WRITE").retryableTx { implicit session =>
112         withSQL {
113           val now = DateHelper.now()
114           insert
115             .into(PersistentOperationOfQuestion)
116             .namedValues(
117               PersistentOperationOfQuestion.column.questionId -> operationOfQuestion.questionId,
118               PersistentOperationOfQuestion.column.operationId -> operationOfQuestion.operationId,
119               PersistentOperationOfQuestion.column.startDate -> operationOfQuestion.startDate,
120               PersistentOperationOfQuestion.column.endDate -> operationOfQuestion.endDate,
121               PersistentOperationOfQuestion.column.operationTitles -> operationOfQuestion.operationTitles,
122               PersistentOperationOfQuestion.column.proposalPrefixes -> operationOfQuestion.proposalPrefixes,
123               PersistentOperationOfQuestion.column.createdAt -> now,
124               PersistentOperationOfQuestion.column.updatedAt -> now,
125               PersistentOperationOfQuestion.column.canPropose -> operationOfQuestion.canPropose,
126               PersistentOperationOfQuestion.column.introCardEnabled -> operationOfQuestion.sequenceCardsConfiguration.introCard.enabled,
127               PersistentOperationOfQuestion.column.introCardTitles -> operationOfQuestion.sequenceCardsConfiguration.introCard.titles,
128               PersistentOperationOfQuestion.column.introCardDescriptions -> operationOfQuestion.sequenceCardsConfiguration.introCard.descriptions,
129               PersistentOperationOfQuestion.column.pushProposalCardEnabled -> operationOfQuestion.sequenceCardsConfiguration.pushProposalCard.enabled,
130               PersistentOperationOfQuestion.column.finalCardEnabled -> operationOfQuestion.sequenceCardsConfiguration.finalCard.enabled,
131               PersistentOperationOfQuestion.column.finalCardSharingEnabled -> operationOfQuestion.sequenceCardsConfiguration.finalCard.sharingEnabled,
132               PersistentOperationOfQuestion.column.finalCardTitles -> operationOfQuestion.sequenceCardsConfiguration.finalCard.titles,
133               PersistentOperationOfQuestion.column.finalCardShareDescriptions -> operationOfQuestion.sequenceCardsConfiguration.finalCard.shareDescriptions,
134               PersistentOperationOfQuestion.column.finalCardLearnMoreTitles -> operationOfQuestion.sequenceCardsConfiguration.finalCard.learnMoreTitles,
135               PersistentOperationOfQuestion.column.finalCardLearnMoreButtons -> operationOfQuestion.sequenceCardsConfiguration.finalCard.learnMoreTextButtons,
136               PersistentOperationOfQuestion.column.finalCardLinkUrl -> operationOfQuestion.sequenceCardsConfiguration.finalCard.linkUrl,
137               PersistentOperationOfQuestion.column.aboutUrls -> operationOfQuestion.aboutUrls,
138               PersistentOperationOfQuestion.column.metaTitles -> operationOfQuestion.metas.titles,
139               PersistentOperationOfQuestion.column.metaDescriptions -> operationOfQuestion.metas.descriptions,
140               PersistentOperationOfQuestion.column.metaPicture -> operationOfQuestion.metas.picture,
141               PersistentOperationOfQuestion.column.color -> operationOfQuestion.theme.color,
142               PersistentOperationOfQuestion.column.fontColor -> operationOfQuestion.theme.fontColor,
143               PersistentOperationOfQuestion.column.descriptions -> operationOfQuestion.descriptions,
144               PersistentOperationOfQuestion.column.consultationImages -> operationOfQuestion.consultationImages,
145               PersistentOperationOfQuestion.column.consultationImageAlts -> operationOfQuestion.consultationImageAlts
146                 .map(_.mapTranslations(_.value)),
147               PersistentOperationOfQuestion.column.descriptionImages -> operationOfQuestion.descriptionImages,
148               PersistentOperationOfQuestion.column.descriptionImageAlts -> operationOfQuestion.descriptionImageAlts
149                 .map(_.mapTranslations(_.value)),
150               PersistentOperationOfQuestion.column.partnersLogos -> operationOfQuestion.partnersLogos,
151               PersistentOperationOfQuestion.column.partnersLogosAlt -> operationOfQuestion.partnersLogosAlt,
152               PersistentOperationOfQuestion.column.initiatorsLogos -> operationOfQuestion.initiatorsLogos,
153               PersistentOperationOfQuestion.column.initiatorsLogosAlt -> operationOfQuestion.initiatorsLogosAlt,
154               PersistentOperationOfQuestion.column.consultationHeader -> operationOfQuestion.consultationHeader,
155               PersistentOperationOfQuestion.column.consultationHeaderAlts -> operationOfQuestion.consultationHeaderAlts
156                 .map(_.mapTranslations(_.value)),
157               PersistentOperationOfQuestion.column.cobrandingLogo -> operationOfQuestion.cobrandingLogo,
158               PersistentOperationOfQuestion.column.cobrandingLogoAlt -> operationOfQuestion.cobrandingLogoAlt
159                 .map(_.value),
160               PersistentOperationOfQuestion.column.resultsLink -> operationOfQuestion.resultsLink,
161               PersistentOperationOfQuestion.column.proposalsCount -> operationOfQuestion.proposalsCount,
162               PersistentOperationOfQuestion.column.participantsCount -> operationOfQuestion.participantsCount,
163               PersistentOperationOfQuestion.column.actions -> operationOfQuestion.actions,
164               PersistentOperationOfQuestion.column.featured -> operationOfQuestion.featured,
165               PersistentOperationOfQuestion.column.votesCount -> operationOfQuestion.votesCount,
166               PersistentOperationOfQuestion.column.votesTarget -> operationOfQuestion.votesTarget,
167               PersistentOperationOfQuestion.column.actionDate -> operationOfQuestion.timeline.action.map(_.date),
168               PersistentOperationOfQuestion.column.actionDateTexts -> operationOfQuestion.timeline.action
169                 .map(_.dateTexts.mapTranslations(_.value)),
170               PersistentOperationOfQuestion.column.actionDescriptions -> operationOfQuestion.timeline.action
171                 .map(_.descriptions.mapTranslations(_.value)),
172               PersistentOperationOfQuestion.column.resultDate -> operationOfQuestion.timeline.result.map(_.date),
173               PersistentOperationOfQuestion.column.resultDateTexts -> operationOfQuestion.timeline.result
174                 .map(_.dateTexts.mapTranslations(_.value)),
175               PersistentOperationOfQuestion.column.resultDescriptions -> operationOfQuestion.timeline.result
176                 .map(_.descriptions.mapTranslations(_.value)),
177               PersistentOperationOfQuestion.column.workshopDate -> operationOfQuestion.timeline.workshop.map(_.date),
178               PersistentOperationOfQuestion.column.workshopDateTexts -> operationOfQuestion.timeline.workshop
179                 .map(_.dateTexts.mapTranslations(_.value)),
180               PersistentOperationOfQuestion.column.workshopDescriptions -> operationOfQuestion.timeline.workshop
181                 .map(_.descriptions.mapTranslations(_.value)),
182               PersistentOperationOfQuestion.column.sessionBindingMode -> operationOfQuestion.sessionBindingMode,
183               PersistentOperationOfQuestion.column.reportUrl -> operationOfQuestion.reportUrl,
184               PersistentOperationOfQuestion.column.actionsUrl -> operationOfQuestion.actionsUrl
185             )
186         }.execute()
187       }).as(operationOfQuestion)
188     }
189 
190     override def modify(operationOfQuestion: OperationOfQuestion): Future[OperationOfQuestion] = {
191       implicit val context: EC = writeExecutionContext
192       Future(NamedDB("WRITE").retryableTx { implicit session =>
193         withSQL {
194           val now = DateHelper.now()
195           update(PersistentOperationOfQuestion)
196             .set(
197               PersistentOperationOfQuestion.column.startDate -> operationOfQuestion.startDate,
198               PersistentOperationOfQuestion.column.endDate -> operationOfQuestion.endDate,
199               PersistentOperationOfQuestion.column.operationTitles -> operationOfQuestion.operationTitles,
200               PersistentOperationOfQuestion.column.proposalPrefixes -> operationOfQuestion.proposalPrefixes,
201               PersistentOperationOfQuestion.column.updatedAt -> now,
202               PersistentOperationOfQuestion.column.canPropose -> operationOfQuestion.canPropose,
203               PersistentOperationOfQuestion.column.introCardEnabled -> operationOfQuestion.sequenceCardsConfiguration.introCard.enabled,
204               PersistentOperationOfQuestion.column.introCardTitles -> operationOfQuestion.sequenceCardsConfiguration.introCard.titles,
205               PersistentOperationOfQuestion.column.introCardDescriptions -> operationOfQuestion.sequenceCardsConfiguration.introCard.descriptions,
206               PersistentOperationOfQuestion.column.pushProposalCardEnabled -> operationOfQuestion.sequenceCardsConfiguration.pushProposalCard.enabled,
207               PersistentOperationOfQuestion.column.finalCardEnabled -> operationOfQuestion.sequenceCardsConfiguration.finalCard.enabled,
208               PersistentOperationOfQuestion.column.finalCardSharingEnabled -> operationOfQuestion.sequenceCardsConfiguration.finalCard.sharingEnabled,
209               PersistentOperationOfQuestion.column.finalCardTitles -> operationOfQuestion.sequenceCardsConfiguration.finalCard.titles,
210               PersistentOperationOfQuestion.column.finalCardShareDescriptions -> operationOfQuestion.sequenceCardsConfiguration.finalCard.shareDescriptions,
211               PersistentOperationOfQuestion.column.finalCardLearnMoreTitles -> operationOfQuestion.sequenceCardsConfiguration.finalCard.learnMoreTitles,
212               PersistentOperationOfQuestion.column.finalCardLearnMoreButtons -> operationOfQuestion.sequenceCardsConfiguration.finalCard.learnMoreTextButtons,
213               PersistentOperationOfQuestion.column.finalCardLinkUrl -> operationOfQuestion.sequenceCardsConfiguration.finalCard.linkUrl,
214               PersistentOperationOfQuestion.column.aboutUrls -> operationOfQuestion.aboutUrls,
215               PersistentOperationOfQuestion.column.metaTitles -> operationOfQuestion.metas.titles,
216               PersistentOperationOfQuestion.column.metaDescriptions -> operationOfQuestion.metas.descriptions,
217               PersistentOperationOfQuestion.column.metaPicture -> operationOfQuestion.metas.picture,
218               PersistentOperationOfQuestion.column.color -> operationOfQuestion.theme.color,
219               PersistentOperationOfQuestion.column.fontColor -> operationOfQuestion.theme.fontColor,
220               PersistentOperationOfQuestion.column.descriptions -> operationOfQuestion.descriptions,
221               PersistentOperationOfQuestion.column.consultationImages -> operationOfQuestion.consultationImages,
222               PersistentOperationOfQuestion.column.consultationImageAlts -> operationOfQuestion.consultationImageAlts
223                 .map(_.mapTranslations(_.value)),
224               PersistentOperationOfQuestion.column.descriptionImages -> operationOfQuestion.descriptionImages,
225               PersistentOperationOfQuestion.column.descriptionImageAlts -> operationOfQuestion.descriptionImageAlts
226                 .map(_.mapTranslations(_.value)),
227               PersistentOperationOfQuestion.column.partnersLogos -> operationOfQuestion.partnersLogos,
228               PersistentOperationOfQuestion.column.partnersLogosAlt -> operationOfQuestion.partnersLogosAlt,
229               PersistentOperationOfQuestion.column.initiatorsLogos -> operationOfQuestion.initiatorsLogos,
230               PersistentOperationOfQuestion.column.initiatorsLogosAlt -> operationOfQuestion.initiatorsLogosAlt,
231               PersistentOperationOfQuestion.column.consultationHeader -> operationOfQuestion.consultationHeader,
232               PersistentOperationOfQuestion.column.consultationHeaderAlts -> operationOfQuestion.consultationHeaderAlts
233                 .map(_.mapTranslations(_.value)),
234               PersistentOperationOfQuestion.column.cobrandingLogo -> operationOfQuestion.cobrandingLogo,
235               PersistentOperationOfQuestion.column.cobrandingLogoAlt -> operationOfQuestion.cobrandingLogoAlt
236                 .map(_.value),
237               PersistentOperationOfQuestion.column.resultsLink -> operationOfQuestion.resultsLink,
238               PersistentOperationOfQuestion.column.proposalsCount -> operationOfQuestion.proposalsCount,
239               PersistentOperationOfQuestion.column.participantsCount -> operationOfQuestion.participantsCount,
240               PersistentOperationOfQuestion.column.actions -> operationOfQuestion.actions,
241               PersistentOperationOfQuestion.column.featured -> operationOfQuestion.featured,
242               PersistentOperationOfQuestion.column.votesCount -> operationOfQuestion.votesCount,
243               PersistentOperationOfQuestion.column.votesTarget -> operationOfQuestion.votesTarget,
244               PersistentOperationOfQuestion.column.actionDate -> operationOfQuestion.timeline.action.map(_.date),
245               PersistentOperationOfQuestion.column.actionDateTexts -> operationOfQuestion.timeline.action
246                 .map(_.dateTexts.mapTranslations(_.value)),
247               PersistentOperationOfQuestion.column.actionDescriptions -> operationOfQuestion.timeline.action
248                 .map(_.descriptions.mapTranslations(_.value)),
249               PersistentOperationOfQuestion.column.resultDate -> operationOfQuestion.timeline.result.map(_.date),
250               PersistentOperationOfQuestion.column.resultDateTexts -> operationOfQuestion.timeline.result
251                 .map(_.dateTexts.mapTranslations(_.value)),
252               PersistentOperationOfQuestion.column.resultDescriptions -> operationOfQuestion.timeline.result
253                 .map(_.descriptions.mapTranslations(_.value)),
254               PersistentOperationOfQuestion.column.workshopDate -> operationOfQuestion.timeline.workshop.map(_.date),
255               PersistentOperationOfQuestion.column.workshopDateTexts -> operationOfQuestion.timeline.workshop
256                 .map(_.dateTexts.mapTranslations(_.value)),
257               PersistentOperationOfQuestion.column.workshopDescriptions -> operationOfQuestion.timeline.workshop
258                 .map(_.descriptions.mapTranslations(_.value)),
259               PersistentOperationOfQuestion.column.sessionBindingMode -> operationOfQuestion.sessionBindingMode,
260               PersistentOperationOfQuestion.column.reportUrl -> operationOfQuestion.reportUrl,
261               PersistentOperationOfQuestion.column.actionsUrl -> operationOfQuestion.actionsUrl
262             )
263             .where(sqls.eq(PersistentOperationOfQuestion.column.questionId, operationOfQuestion.questionId))
264         }.execute()
265       }).as(operationOfQuestion)
266     }
267 
268     override def getById(id: QuestionId): Future[Option[OperationOfQuestion]] = {
269       implicit val context: EC = readExecutionContext
270       Future(NamedDB("READ").retryableTx { implicit session =>
271         withSQL[PersistentOperationOfQuestion] {
272           select
273             .from(PersistentOperationOfQuestion.as(PersistentOperationOfQuestion.alias))
274             .where(sqls.eq(PersistentOperationOfQuestion.column.questionId, id))
275         }.map(PersistentOperationOfQuestion(PersistentOperationOfQuestion.alias.resultName)(_)).single()
276       }).map(_.map(_.toOperationOfQuestion))
277     }
278 
279     override def find(operationId: Option[OperationId]): Future[Seq[OperationOfQuestion]] = {
280       implicit val context: EC = readExecutionContext
281       Future(NamedDB("READ").retryableTx { implicit session =>
282         withSQL[PersistentOperationOfQuestion] {
283           select
284             .from(PersistentOperationOfQuestion.as(PersistentOperationOfQuestion.alias))
285             .where(
286               sqls.toAndConditionOpt(
287                 operationId
288                   .map(operation => sqls.eq(PersistentOperationOfQuestion.column.operationId, operation.value))
289               )
290             )
291         }.map(PersistentOperationOfQuestion(PersistentOperationOfQuestion.alias.resultName)).list()
292       }).map(_.map(_.toOperationOfQuestion))
293     }
294 
295     override def delete(questionId: QuestionId): Future[Unit] = {
296       implicit val context: EC = readExecutionContext
297       Future(NamedDB("WRITE").retryableTx { implicit session =>
298         withSQL {
299           deleteFrom(PersistentOperationOfQuestion)
300             .where(sqls.eq(PersistentOperationOfQuestion.column.questionId, questionId))
301         }.execute()
302       }).void
303     }
304 
305     override def count(
306       questionIds: Option[Seq[QuestionId]],
307       operationIds: Option[Seq[OperationId]],
308       openAt: Option[ZonedDateTime],
309       endAfter: Option[ZonedDateTime],
310       slug: Option[String]
311     ): Future[Int] = {
312       implicit val context: EC = readExecutionContext
313       Future(NamedDB("READ").retryableTx { implicit session =>
314         withSQL[PersistentOperationOfQuestion] {
315           select(sqls.count)
316             .from(PersistentOperationOfQuestion.as(PersistentOperationOfQuestion.alias))
317             .innerJoin(PersistentQuestion.as(PersistentQuestion.alias))
318             .on(operationOfQuestionAlias.questionId, PersistentQuestion.alias.questionId)
319             .where(
320               sqls.toAndConditionOpt(
321                 operationIds
322                   .map(opIds => sqls.in(PersistentOperationOfQuestion.alias.operationId, opIds.map(_.value))),
323                 questionIds
324                   .map(qIds => sqls.in(PersistentOperationOfQuestion.alias.questionId, qIds.map(_.value))),
325                 openAt.map(
326                   openAt =>
327                     sqls
328                       .le(PersistentOperationOfQuestion.alias.startDate, openAt)
329                       .and(sqls.ge(PersistentOperationOfQuestion.alias.endDate, openAt))
330                 ),
331                 endAfter.map(end => sqls.ge(PersistentOperationOfQuestion.alias.endDate, end)),
332                 slug.map(s       => sqls.like(PersistentQuestion.alias.slug, s"%$s%"))
333               )
334             )
335         }.map(_.int(1)).single().getOrElse(0)
336       })
337     }
338   }
339 }
340 
341 object DefaultPersistentOperationOfQuestionServiceComponent {
342 
343   final case class PersistentOperationOfQuestion(
344     questionId: String,
345     operationId: String,
346     startDate: ZonedDateTime,
347     endDate: ZonedDateTime,
348     operationTitles: Multilingual[String],
349     proposalPrefixes: Multilingual[String],
350     createdAt: ZonedDateTime,
351     updatedAt: ZonedDateTime,
352     canPropose: Boolean,
353     introCardEnabled: Boolean,
354     introCardTitles: Option[Multilingual[String]],
355     introCardDescriptions: Option[Multilingual[String]],
356     pushProposalCardEnabled: Boolean,
357     finalCardEnabled: Boolean,
358     finalCardSharingEnabled: Boolean,
359     finalCardTitles: Option[Multilingual[String]],
360     finalCardShareDescriptions: Option[Multilingual[String]],
361     finalCardLearnMoreTitles: Option[Multilingual[String]],
362     finalCardLearnMoreButtons: Option[Multilingual[String]],
363     finalCardLinkUrl: Option[String],
364     aboutUrls: Option[Multilingual[String]],
365     metaTitles: Option[Multilingual[String]],
366     metaDescriptions: Option[Multilingual[String]],
367     metaPicture: Option[String],
368     color: String,
369     fontColor: String,
370     descriptions: Option[Multilingual[String]],
371     consultationImages: Option[Multilingual[String]],
372     consultationImageAlts: Option[Multilingual[String Refined MaxSize[130]]],
373     descriptionImages: Option[Multilingual[String]],
374     descriptionImageAlts: Option[Multilingual[String Refined MaxSize[130]]],
375     partnersLogos: Option[String],
376     partnersLogosAlt: Option[String Refined MaxSize[130]],
377     initiatorsLogos: Option[String],
378     initiatorsLogosAlt: Option[String Refined MaxSize[130]],
379     consultationHeader: Option[String],
380     consultationHeaderAlts: Option[Multilingual[String Refined MaxSize[130]]],
381     cobrandingLogo: Option[String],
382     cobrandingLogoAlt: Option[String Refined MaxSize[130]],
383     resultsLink: Option[ResultsLink],
384     proposalsCount: Int,
385     participantsCount: Int,
386     actions: Option[String],
387     featured: Boolean,
388     votesCount: Int,
389     votesTarget: Int,
390     actionDate: Option[LocalDate],
391     actionDateTexts: Option[Multilingual[String Refined MaxSize[20]]],
392     actionDescriptions: Option[Multilingual[String Refined MaxSize[150]]],
393     resultDate: Option[LocalDate],
394     resultDateTexts: Option[Multilingual[String Refined MaxSize[20]]],
395     resultDescriptions: Option[Multilingual[String Refined MaxSize[150]]],
396     workshopDate: Option[LocalDate],
397     workshopDateTexts: Option[Multilingual[String Refined MaxSize[20]]],
398     workshopDescriptions: Option[Multilingual[String Refined MaxSize[150]]],
399     sessionBindingMode: Boolean,
400     reportUrl: Option[String],
401     actionsUrl: Option[String]
402   ) {
403     def toOperationOfQuestion: OperationOfQuestion = OperationOfQuestion(
404       questionId = QuestionId(this.questionId),
405       operationId = OperationId(this.operationId),
406       startDate = this.startDate,
407       endDate = this.endDate,
408       operationTitles = this.operationTitles,
409       proposalPrefixes = this.proposalPrefixes,
410       canPropose = this.canPropose,
411       sequenceCardsConfiguration = SequenceCardsConfiguration(
412         introCard = IntroCard(
413           enabled = this.introCardEnabled,
414           titles = this.introCardTitles,
415           descriptions = this.introCardDescriptions
416         ),
417         pushProposalCard = PushProposalCard(enabled = this.pushProposalCardEnabled),
418         finalCard = FinalCard(
419           enabled = this.finalCardEnabled,
420           sharingEnabled = this.finalCardSharingEnabled,
421           titles = this.finalCardTitles,
422           shareDescriptions = this.finalCardShareDescriptions,
423           learnMoreTitles = this.finalCardLearnMoreTitles,
424           learnMoreTextButtons = this.finalCardLearnMoreButtons,
425           linkUrl = this.finalCardLinkUrl
426         )
427       ),
428       aboutUrls = this.aboutUrls,
429       metas = Metas(titles = this.metaTitles, descriptions = this.metaDescriptions, picture = this.metaPicture),
430       theme =
431         QuestionTheme(color = Colour.fromStringUnsafe(this.color), fontColor = Colour.fromStringUnsafe(this.fontColor)),
432       descriptions = this.descriptions,
433       consultationImages = this.consultationImages,
434       consultationImageAlts = this.consultationImageAlts,
435       descriptionImages = this.descriptionImages,
436       descriptionImageAlts = this.descriptionImageAlts,
437       partnersLogos = this.partnersLogos,
438       partnersLogosAlt = this.partnersLogosAlt,
439       initiatorsLogos = this.initiatorsLogos,
440       initiatorsLogosAlt = this.initiatorsLogosAlt,
441       consultationHeader = this.consultationHeader,
442       consultationHeaderAlts = this.consultationHeaderAlts,
443       cobrandingLogo = this.cobrandingLogo,
444       cobrandingLogoAlt = this.cobrandingLogoAlt,
445       resultsLink = this.resultsLink,
446       proposalsCount = this.proposalsCount,
447       participantsCount = this.participantsCount,
448       actions = this.actions,
449       featured = this.featured,
450       votesTarget = this.votesTarget,
451       votesCount = this.votesCount,
452       timeline = OperationOfQuestionTimeline(
453         action = (this.actionDate, this.actionDateTexts, this.actionDescriptions)
454           .mapN(TimelineElement(_, _, _)),
455         result = (this.resultDate, this.resultDateTexts, this.resultDescriptions)
456           .mapN(TimelineElement(_, _, _)),
457         workshop = (this.workshopDate, this.workshopDateTexts, this.workshopDescriptions)
458           .mapN(TimelineElement(_, _, _))
459       ),
460       createdAt = this.createdAt,
461       sessionBindingMode = this.sessionBindingMode,
462       reportUrl = this.reportUrl,
463       actionsUrl = this.actionsUrl
464     )
465   }
466 
467   implicit object PersistentOperationOfQuestion
468       extends PersistentCompanion[PersistentOperationOfQuestion, OperationOfQuestion]
469       with ShortenedNames
470       with Logging {
471 
472     @SuppressWarnings(Array("org.wartremover.warts.Null"))
473     implicit val resultsLinkBinders: Binders[Option[ResultsLink]] =
474       Binders.string.xmap(s => Option(s).flatMap(ResultsLink.parse), _.map(Show[ResultsLink].show).orNull)
475 
476     final case class FlatQuestionWithDetails(
477       questionId: String,
478       countries: String,
479       defaultLanguage: String,
480       languages: NonEmptyList[Language],
481       questions: Multilingual[String Refined NonEmpty],
482       shortTitles: Option[Multilingual[String Refined NonEmpty]],
483       slug: String,
484       operationId: String,
485       startDate: ZonedDateTime,
486       endDate: ZonedDateTime,
487       operationTitles: Multilingual[String],
488       proposalPrefixes: Multilingual[String],
489       canPropose: Boolean,
490       introCardEnabled: Boolean,
491       introCardTitles: Option[Multilingual[String]],
492       introCardDescriptions: Option[Multilingual[String]],
493       pushProposalCardEnabled: Boolean,
494       finalCardEnabled: Boolean,
495       finalCardSharingEnabled: Boolean,
496       finalCardTitles: Option[Multilingual[String]],
497       finalCardShareDescriptions: Option[Multilingual[String]],
498       finalCardLearnMoreTitles: Option[Multilingual[String]],
499       finalCardLearnMoreButtons: Option[Multilingual[String]],
500       finalCardLinkUrl: Option[String],
501       aboutUrls: Option[Multilingual[String]],
502       metaTitles: Option[Multilingual[String]],
503       metaDescriptions: Option[Multilingual[String]],
504       metaPicture: Option[String],
505       color: String,
506       fontColor: String,
507       descriptions: Option[Multilingual[String]],
508       consultationImages: Option[Multilingual[String]],
509       consultationImageAlts: Option[Multilingual[String Refined MaxSize[130]]],
510       descriptionImages: Option[Multilingual[String]],
511       descriptionImageAlts: Option[Multilingual[String Refined MaxSize[130]]],
512       partnersLogos: Option[String],
513       partnersLogosAlt: Option[String Refined MaxSize[130]],
514       initiatorsLogos: Option[String],
515       initiatorsLogosAlt: Option[String Refined MaxSize[130]],
516       consultationHeader: Option[String],
517       consultationHeaderAlts: Option[Multilingual[String Refined MaxSize[130]]],
518       cobrandingLogo: Option[String],
519       cobrandingLogoAlt: Option[String Refined MaxSize[130]],
520       resultsLink: Option[ResultsLink],
521       proposalsCount: Int,
522       participantsCount: Int,
523       actions: Option[String],
524       featured: Boolean,
525       votesCount: Int,
526       votesTarget: Int,
527       actionDate: Option[LocalDate],
528       actionDateTexts: Option[Multilingual[String Refined MaxSize[20]]],
529       actionDescriptions: Option[Multilingual[String Refined MaxSize[150]]],
530       resultDate: Option[LocalDate],
531       resultDateTexts: Option[Multilingual[String Refined MaxSize[20]]],
532       resultDescriptions: Option[Multilingual[String Refined MaxSize[150]]],
533       workshopDate: Option[LocalDate],
534       workshopDateTexts: Option[Multilingual[String Refined MaxSize[20]]],
535       workshopDescriptions: Option[Multilingual[String Refined MaxSize[150]]],
536       createdAt: ZonedDateTime,
537       sessionBindingMode: Boolean,
538       reportUrl: Option[String],
539       actionsUrl: Option[String]
540     ) {
541       def toQuestionAndDetails: QuestionWithDetails = {
542         QuestionWithDetails(
543           question = Question(
544             questionId = QuestionId(questionId),
545             countries = NonEmptyList.fromListUnsafe(countries.split(',').map(Country(_)).toList),
546             defaultLanguage = Language(defaultLanguage),
547             languages = languages,
548             slug = slug,
549             questions = questions,
550             shortTitles = shortTitles,
551             operationId = Some(OperationId(operationId))
552           ),
553           details = OperationOfQuestion(
554             questionId = QuestionId(questionId),
555             operationId = OperationId(operationId),
556             startDate = startDate,
557             endDate = endDate,
558             operationTitles = operationTitles,
559             proposalPrefixes = proposalPrefixes,
560             canPropose = canPropose,
561             sequenceCardsConfiguration = SequenceCardsConfiguration(
562               introCard =
563                 IntroCard(enabled = introCardEnabled, titles = introCardTitles, descriptions = introCardDescriptions),
564               pushProposalCard = PushProposalCard(enabled = pushProposalCardEnabled),
565               finalCard = FinalCard(
566                 enabled = finalCardEnabled,
567                 sharingEnabled = finalCardSharingEnabled,
568                 titles = finalCardTitles,
569                 shareDescriptions = finalCardShareDescriptions,
570                 learnMoreTitles = finalCardLearnMoreTitles,
571                 learnMoreTextButtons = finalCardLearnMoreButtons,
572                 linkUrl = finalCardLinkUrl
573               )
574             ),
575             aboutUrls = this.aboutUrls,
576             metas = Metas(titles = metaTitles, descriptions = metaDescriptions, picture = metaPicture),
577             theme = QuestionTheme(
578               color = Colour.fromStringUnsafe(this.color),
579               fontColor = Colour.fromStringUnsafe(this.fontColor)
580             ),
581             descriptions = this.descriptions,
582             consultationImages = this.consultationImages,
583             consultationImageAlts = this.consultationImageAlts,
584             descriptionImages = this.descriptionImages,
585             descriptionImageAlts = this.descriptionImageAlts,
586             partnersLogos = this.partnersLogos,
587             partnersLogosAlt = this.partnersLogosAlt,
588             initiatorsLogos = this.initiatorsLogos,
589             initiatorsLogosAlt = this.initiatorsLogosAlt,
590             consultationHeader = this.consultationHeader,
591             consultationHeaderAlts = this.consultationHeaderAlts,
592             cobrandingLogo = this.cobrandingLogo,
593             cobrandingLogoAlt = this.cobrandingLogoAlt,
594             resultsLink = this.resultsLink,
595             proposalsCount = this.proposalsCount,
596             participantsCount = this.participantsCount,
597             actions = this.actions,
598             featured = this.featured,
599             votesCount = this.votesCount,
600             votesTarget = this.votesTarget,
601             timeline = OperationOfQuestionTimeline(
602               action = (this.actionDate, this.actionDateTexts, this.actionDescriptions)
603                 .mapN(TimelineElement(_, _, _)),
604               result = (this.resultDate, this.resultDateTexts, this.resultDescriptions)
605                 .mapN(TimelineElement(_, _, _)),
606               workshop = (this.workshopDate, this.workshopDateTexts, this.workshopDescriptions)
607                 .mapN(TimelineElement(_, _, _))
608             ),
609             createdAt = this.createdAt,
610             sessionBindingMode = sessionBindingMode,
611             reportUrl = reportUrl,
612             actionsUrl = actionsUrl
613           )
614         )
615 
616       }
617     }
618 
619     @SuppressWarnings(Array("org.wartremover.warts.AsInstanceOf"))
620     def withQuestion(
621       questionAlias: ResultName[PersistentQuestion],
622       operationOfQuestionAlias: ResultName[PersistentOperationOfQuestion]
623     )(resultSet: WrappedResultSet): Option[FlatQuestionWithDetails] = {
624       for {
625         questionId   <- resultSet.stringOpt(operationOfQuestionAlias.questionId)
626         questionSlug <- resultSet.stringOpt(questionAlias.slug)
627         operationId  <- resultSet.stringOpt(operationOfQuestionAlias.operationId)
628         countries    <- resultSet.stringOpt(questionAlias.countries)
629         languages <- resultSet
630           .arrayOpt(questionAlias.languages)
631           .map(_.getArray.asInstanceOf[Array[String]].map(Language(_)))
632       } yield FlatQuestionWithDetails(
633         questionId = questionId,
634         countries = countries,
635         defaultLanguage = resultSet.get[String](questionAlias.defaultLanguage),
636         languages = NonEmptyList.fromListUnsafe(languages.toList),
637         questions = resultSet.get[Multilingual[String Refined NonEmpty]](questionAlias.questions),
638         shortTitles = resultSet.get[Option[Multilingual[String Refined NonEmpty]]](questionAlias.shortTitles),
639         slug = questionSlug,
640         operationId = operationId,
641         startDate = resultSet.zonedDateTime(operationOfQuestionAlias.startDate),
642         endDate = resultSet.zonedDateTime(operationOfQuestionAlias.endDate),
643         operationTitles = resultSet.get[Multilingual[String]](operationOfQuestionAlias.operationTitles),
644         proposalPrefixes = resultSet.get[Multilingual[String]](operationOfQuestionAlias.proposalPrefixes),
645         canPropose = resultSet.boolean(operationOfQuestionAlias.canPropose),
646         introCardEnabled = resultSet.boolean(operationOfQuestionAlias.introCardEnabled),
647         introCardTitles = resultSet.get(operationOfQuestionAlias.introCardTitles),
648         introCardDescriptions = resultSet.get(operationOfQuestionAlias.introCardDescriptions),
649         pushProposalCardEnabled = resultSet.boolean(operationOfQuestionAlias.pushProposalCardEnabled),
650         finalCardEnabled = resultSet.boolean(operationOfQuestionAlias.finalCardEnabled),
651         finalCardSharingEnabled = resultSet.boolean(operationOfQuestionAlias.finalCardSharingEnabled),
652         finalCardTitles = resultSet.get(operationOfQuestionAlias.finalCardTitles),
653         finalCardShareDescriptions = resultSet.get(operationOfQuestionAlias.finalCardShareDescriptions),
654         finalCardLearnMoreTitles =
655           resultSet.get[Option[Multilingual[String]]](operationOfQuestionAlias.finalCardLearnMoreTitles),
656         finalCardLearnMoreButtons = resultSet.get(operationOfQuestionAlias.finalCardLearnMoreButtons),
657         finalCardLinkUrl = resultSet.stringOpt(operationOfQuestionAlias.finalCardLinkUrl),
658         aboutUrls = resultSet.get[Option[Multilingual[String]]](operationOfQuestionAlias.aboutUrls),
659         metaTitles = resultSet.get(operationOfQuestionAlias.metaTitles),
660         metaDescriptions = resultSet.get(operationOfQuestionAlias.metaDescriptions),
661         metaPicture = resultSet.stringOpt(operationOfQuestionAlias.metaPicture),
662         color = resultSet.string(operationOfQuestionAlias.color),
663         fontColor = resultSet.string(operationOfQuestionAlias.fontColor),
664         descriptions = resultSet.get(operationOfQuestionAlias.descriptions),
665         consultationImages = resultSet.get(operationOfQuestionAlias.consultationImages),
666         consultationImageAlts = resultSet.get(operationOfQuestionAlias.consultationImageAlts),
667         descriptionImages = resultSet.get(operationOfQuestionAlias.descriptionImages),
668         descriptionImageAlts = resultSet.get(operationOfQuestionAlias.descriptionImageAlts),
669         partnersLogos = resultSet.stringOpt(operationOfQuestionAlias.partnersLogos),
670         partnersLogosAlt = resultSet.get(operationOfQuestionAlias.partnersLogosAlt),
671         initiatorsLogos = resultSet.stringOpt(operationOfQuestionAlias.initiatorsLogos),
672         initiatorsLogosAlt = resultSet.get(operationOfQuestionAlias.initiatorsLogosAlt),
673         consultationHeader = resultSet.stringOpt(operationOfQuestionAlias.consultationHeader),
674         consultationHeaderAlts = resultSet.get(operationOfQuestionAlias.consultationHeaderAlts),
675         cobrandingLogo = resultSet.stringOpt(operationOfQuestionAlias.cobrandingLogo),
676         cobrandingLogoAlt = resultSet.get(operationOfQuestionAlias.cobrandingLogoAlt),
677         resultsLink = resultSet.get(operationOfQuestionAlias.resultsLink),
678         proposalsCount = resultSet.int(operationOfQuestionAlias.proposalsCount),
679         participantsCount = resultSet.int(operationOfQuestionAlias.participantsCount),
680         actions = resultSet.stringOpt(operationOfQuestionAlias.actions),
681         featured = resultSet.boolean(operationOfQuestionAlias.featured),
682         votesCount = resultSet.int(operationOfQuestionAlias.votesCount),
683         votesTarget = resultSet.int(operationOfQuestionAlias.votesTarget),
684         actionDate = resultSet.localDateOpt(operationOfQuestionAlias.actionDate),
685         actionDateTexts = resultSet.get(operationOfQuestionAlias.actionDateTexts),
686         actionDescriptions = resultSet.get(operationOfQuestionAlias.actionDescriptions),
687         resultDate = resultSet.localDateOpt(operationOfQuestionAlias.resultDate),
688         resultDateTexts = resultSet.get(operationOfQuestionAlias.resultDateTexts),
689         resultDescriptions = resultSet.get(operationOfQuestionAlias.resultDescriptions),
690         workshopDate = resultSet.localDateOpt(operationOfQuestionAlias.workshopDate),
691         workshopDateTexts = resultSet.get(operationOfQuestionAlias.workshopDateTexts),
692         workshopDescriptions = resultSet.get(operationOfQuestionAlias.workshopDescriptions),
693         createdAt = resultSet.zonedDateTime(operationOfQuestionAlias.createdAt),
694         sessionBindingMode = resultSet.boolean(operationOfQuestionAlias.sessionBindingMode),
695         reportUrl = resultSet.get[Option[String]](operationOfQuestionAlias.reportUrl),
696         actionsUrl = resultSet.get[Option[String]](operationOfQuestionAlias.actionsUrl)
697       )
698     }
699 
700     override val columnNames: Seq[String] =
701       Seq(
702         "question_id",
703         "operation_id",
704         "start_date",
705         "end_date",
706         "operation_titles",
707         "proposal_prefixes",
708         "created_at",
709         "updated_at",
710         "can_propose",
711         "intro_card_enabled",
712         "intro_card_titles",
713         "intro_card_descriptions",
714         "push_proposal_card_enabled",
715         "final_card_enabled",
716         "final_card_sharing_enabled",
717         "final_card_titles",
718         "final_card_share_descriptions",
719         "final_card_learn_more_titles",
720         "final_card_learn_more_buttons",
721         "final_card_link_url",
722         "about_urls",
723         "meta_titles",
724         "meta_descriptions",
725         "meta_picture",
726         "color",
727         "font_color",
728         "descriptions",
729         "consultation_images",
730         "consultation_image_alts",
731         "description_images",
732         "description_image_alts",
733         "partners_logos",
734         "partners_logos_alt",
735         "initiators_logos",
736         "initiators_logos_alt",
737         "consultation_header",
738         "consultation_header_alts",
739         "cobranding_logo",
740         "cobranding_logo_alt",
741         "results_link",
742         "proposals_count",
743         "participants_count",
744         "actions",
745         "featured",
746         "votes_count",
747         "votes_target",
748         "action_date",
749         "action_date_texts",
750         "action_descriptions",
751         "result_date",
752         "result_date_texts",
753         "result_descriptions",
754         "workshop_date",
755         "workshop_date_texts",
756         "workshop_descriptions",
757         "session_binding_mode",
758         "report_url",
759         "actions_url"
760       )
761     final val swaggerAllowableValues =
762       "question_id,operation_id,start_date,end_date,operation_titles,created_at,updated_at,can_propose,intro_card_enabled,intro_card_titles,intro_card_descriptions,push_proposal_card_enabled,final_card_enabled,final_card_sharing_enabled,final_card_titles,final_card_share_descriptions,final_card_learn_more_titles,final_card_learn_more_buttons,final_card_link_url,about_urls,meta_titles,meta_descriptions,meta_picture,color,font_color,descriptions,consultation_images,consultation_image_alts,description_images,description_image_alts,results_link,proposals_count,participants_count,actions,featured,votes_count,votes_target,action_date,action_date_texts,action_descriptions,result_date,result_date_texts,result_descriptions,workshop_date,workshop_date_texts,workshop_descriptions,session_binding_mode,report_url"
763 
764     override val tableName: String = "operation_of_question"
765 
766     override lazy val alias: SyntaxProvider[PersistentOperationOfQuestion] = syntax("operationOfquestion")
767 
768     override lazy val defaultSortColumns: NonEmptyList[SQLSyntax] = NonEmptyList.of(alias.questionId)
769 
770     def apply(
771       resultName: ResultName[PersistentOperationOfQuestion] = alias.resultName
772     )(resultSet: WrappedResultSet): PersistentOperationOfQuestion = {
773       PersistentOperationOfQuestion(
774         questionId = resultSet.string(resultName.questionId),
775         operationId = resultSet.string(resultName.operationId),
776         startDate = resultSet.zonedDateTime(resultName.startDate),
777         endDate = resultSet.zonedDateTime(resultName.endDate),
778         operationTitles = resultSet.get[Multilingual[String]](resultName.operationTitles),
779         proposalPrefixes = resultSet.get[Multilingual[String]](resultName.proposalPrefixes),
780         createdAt = resultSet.zonedDateTime(resultName.createdAt),
781         updatedAt = resultSet.zonedDateTime(resultName.updatedAt),
782         canPropose = resultSet.boolean(resultName.canPropose),
783         introCardEnabled = resultSet.boolean(resultName.introCardEnabled),
784         introCardTitles = resultSet.get[Option[Multilingual[String]]](resultName.introCardTitles),
785         introCardDescriptions = resultSet.get[Option[Multilingual[String]]](resultName.introCardDescriptions),
786         pushProposalCardEnabled = resultSet.boolean(resultName.pushProposalCardEnabled),
787         finalCardEnabled = resultSet.boolean(resultName.finalCardEnabled),
788         finalCardSharingEnabled = resultSet.boolean(resultName.finalCardSharingEnabled),
789         finalCardTitles = resultSet.get[Option[Multilingual[String]]](resultName.finalCardTitles),
790         finalCardShareDescriptions = resultSet.get[Option[Multilingual[String]]](resultName.finalCardShareDescriptions),
791         finalCardLearnMoreTitles = resultSet.get[Option[Multilingual[String]]](resultName.finalCardLearnMoreTitles),
792         finalCardLearnMoreButtons = resultSet.get[Option[Multilingual[String]]](resultName.finalCardLearnMoreButtons),
793         finalCardLinkUrl = resultSet.stringOpt(resultName.finalCardLinkUrl),
794         aboutUrls = resultSet.get[Option[Multilingual[String]]](resultName.aboutUrls),
795         metaTitles = resultSet.get[Option[Multilingual[String]]](resultName.metaTitles),
796         metaDescriptions = resultSet.get[Option[Multilingual[String]]](resultName.metaDescriptions),
797         metaPicture = resultSet.stringOpt(resultName.metaPicture),
798         color = resultSet.string(resultName.color),
799         fontColor = resultSet.string(resultName.fontColor),
800         descriptions = resultSet.get[Option[Multilingual[String]]](resultName.descriptions),
801         consultationImages = resultSet.get[Option[Multilingual[String]]](resultName.consultationImages),
802         consultationImageAlts =
803           resultSet.get[Option[Multilingual[String Refined MaxSize[130]]]](resultName.consultationImageAlts),
804         descriptionImages = resultSet.get[Option[Multilingual[String]]](resultName.descriptionImages),
805         descriptionImageAlts =
806           resultSet.get[Option[Multilingual[String Refined MaxSize[130]]]](resultName.descriptionImageAlts),
807         partnersLogos = resultSet.stringOpt(resultName.partnersLogos),
808         partnersLogosAlt = resultSet.get[Option[String Refined MaxSize[130]]](resultName.partnersLogosAlt),
809         initiatorsLogos = resultSet.stringOpt(resultName.initiatorsLogos),
810         initiatorsLogosAlt = resultSet.get[Option[String Refined MaxSize[130]]](resultName.initiatorsLogosAlt),
811         consultationHeader = resultSet.stringOpt(resultName.consultationHeader),
812         consultationHeaderAlts =
813           resultSet.get[Option[Multilingual[String Refined MaxSize[130]]]](resultName.consultationHeaderAlts),
814         cobrandingLogo = resultSet.stringOpt(resultName.cobrandingLogo),
815         cobrandingLogoAlt = resultSet.get[Option[String Refined MaxSize[130]]](resultName.cobrandingLogoAlt),
816         resultsLink = resultSet.get[Option[ResultsLink]](resultName.resultsLink),
817         proposalsCount = resultSet.int(resultName.proposalsCount),
818         participantsCount = resultSet.int(resultName.participantsCount),
819         actions = resultSet.stringOpt(resultName.actions),
820         featured = resultSet.boolean(resultName.featured),
821         votesCount = resultSet.int(resultName.votesCount),
822         votesTarget = resultSet.int(resultName.votesTarget),
823         actionDate = resultSet.localDateOpt(resultName.actionDate),
824         actionDateTexts = resultSet.get[Option[Multilingual[String Refined MaxSize[20]]]](resultName.actionDateTexts),
825         actionDescriptions =
826           resultSet.get[Option[Multilingual[String Refined MaxSize[150]]]](resultName.actionDescriptions),
827         resultDate = resultSet.localDateOpt(resultName.resultDate),
828         resultDateTexts = resultSet.get[Option[Multilingual[String Refined MaxSize[20]]]](resultName.resultDateTexts),
829         resultDescriptions =
830           resultSet.get[Option[Multilingual[String Refined MaxSize[150]]]](resultName.resultDescriptions),
831         workshopDate = resultSet.localDateOpt(resultName.workshopDate),
832         workshopDateTexts =
833           resultSet.get[Option[Multilingual[String Refined MaxSize[20]]]](resultName.workshopDateTexts),
834         workshopDescriptions =
835           resultSet.get[Option[Multilingual[String Refined MaxSize[150]]]](resultName.workshopDescriptions),
836         sessionBindingMode = resultSet.boolean(resultName.sessionBindingMode),
837         reportUrl = resultSet.get[Option[String]](resultName.reportUrl),
838         actionsUrl = resultSet.get[Option[String]](resultName.actionsUrl)
839       )
840     }
841   }
842 }