1<#--
2 eCTRL Solutions
3 EROGATORE feeds per integrazione visitpiemonte
4 ver: 1.8.2
5 data: 28/05/2021
6
7 DEBUG
8 Freemarker online: http://freemarker-online.kenshoo.com/
9 esempio:
10https://atlcuneo.d40.it/piemontefeed?p_p_id=Configurable&p_p_lifecycle=2&p_p_resource_id=json&_Configurable_jsonParams={}
11
12ESPERIENZE:
13https://www.visitcuneese.it/piemontefeed?p_p_id=Configurable&p_p_lifecycle=2&p_p_resource_id=json&_Configurable_jsonParams={%22structureKey%22:1365076}
14
15
16 -->
17
18 <#compress>
19 <#setting url_escaping_charset="UTF-8">
20 <#assign SuggestoMarketspaceAPI = serviceLocator.findService("eu.suggesto.marketspace.service.SmkspDataLocalService")>
21 <#assign suggestoMkspAPI = serviceLocator.findService("eu.suggesto.suggestogui.service.SuggestoGuiLocalService")>
22 <#assign SuggestoRecommenderServiceAPI = serviceLocator.findService("eu.suggesto.servicecs.service.SuggestoRecommenderLocalService")>
23 <#assign SuggestoCSServiceAPI = serviceLocator.findService("eu.suggesto.servicecs.service.SuggestoCSLocalService")>
24 <#assign d40Service = serviceLocator.findService("eu.suggesto.d40.builder.d40.service.TourismItemLocalService")>
25 <#assign dlFileEntryService = serviceLocator.findService("com.liferay.document.library.kernel.service.DLFileEntryLocalService")>
26 <#assign journalServiceAPI = serviceLocator.findService("com.liferay.journal.service.JournalArticleLocalService") />
27
28
29 <#assign ddmStructureKey = "*" >
30 <#assign structureKey1 = "1365076"> <#-- ESPERIENZE -->
31 <#assign structureKey2 = "1332941"> <#-- PUNTO DI INTERESSE-->
32 <#assign structureKey3 = "1332945"> <#-- LOCALITA -->
33 <#assign structureKey4 = "1332909"> <#-- ITINEARIO -->
34 <#assign structureKey5 = "1332933"> <#-- EVENTO -->
35 <#assign structureKey6 = "1332937"> <#-- OFFERTA -->
36 <#assign exportVisitPiemonteCategory="6748880">
37 <#assign szLocDef="it_IT">
38 <#assign locDef=localeUtil.fromLanguageId(szLocDef)>
39 <#assign JSONFactoryUtil = staticUtil["com.liferay.portal.kernel.json.JSONFactoryUtil"]>
40 <#assign serviceName = "0:esatlcuneo" >
41 <#assign serverName="">
42 <#assign srvGroupId = groupId?string >
43 <#assign numPag = 1 >
44 <#assign numItems = 100 >
45 <#assign szJsonParams = result.getNamespacedParameters().getString("jsonParams") >
46 <#if szJsonParams != "">
47 <#assign jsonParams = jsonFactoryUtil.createJSONObject(szJsonParams) >
48 <#else>
49 <#assign jsonParams = jsonFactoryUtil.createJSONObject() >
50 </#if>
51 <#if jsonParams.getString("pag")?has_content>
52 <#assign numPag = jsonParams.getString("pag")?number >
53 </#if>
54
55 <#if jsonParams.getString("num")?has_content>
56 <#assign numItems = jsonParams.getString("num")?number >
57 </#if>
58 <#assign skipItems = (numPag-1)*numItems >
59 <#assign query = jsonParams.getString("qry") >
60 <#assign structureKey = jsonParams.getString("structureKey",structureKey1) >
61 <#assign p1 = exportVisitPiemonteCategory >
62 <#assign today=dateUtil.parseDate(.now?string('dd')+"/"+.now?string('MM')+"/"+.now?string('yyyy'),locDef) >
63 <#assign todayLong=today?long>
64 <#assign szExpDate=.now?string('yyyy')+.now?string('MM')+.now?string('dd')+.now?string('hh') +.now?string('mm') +.now?string('ss') >
65 <#assign szToday=.now?string('yyyy')+"-"+.now?string('MM')+"-"+.now?string('dd') >
66
67 <#assign querySlr = "head:true AND status:0 AND expirationDate:[${szExpDate} TO *] AND ddmStructureKey:${structureKey} AND groupId:${groupId?string}">
68 <#assign queryEs>
69 {
70 "query": {
71 "bool": {
72 "must": [{
73 "query_string": {
74 "query": "${getJsonString(querySlr)}"
75 }
76 }, {
77 "query_string": {
78 "query": "assetCategoryIds:${p1}"
79 }
80 }
81 ]
82 }
83 }
84 }
85 </#assign>
86 <#assign resultQry = SuggestoRecommenderServiceAPI.search("0",serviceName,"",queryEs,sortOrder,skipItems,numItems)>
87 <#if ! resultQry?has_content>
88 {
89 "metadata":{"numFound":0,"start":0},
90 "docs":[],
91 "service":"${serviceName}",
92 "queryEs":"${getJsonString(queryEs)}",
93 "sortOrder2":"${getJsonString(sortOrder)}"
94 }
95 <#else>
96 <#assign numFound =resultQry.getJSONObject("data").getJSONObject("response").getString("numFound")?number>
97 <#assign start =resultQry.getJSONObject("data").getJSONObject("response").getString("start")?number>
98 <#if numFound gt 0 && start lt numFound>
99 <@writeItems/>
100<#-- ${resultQry.toString()} -->
101 <#else>
102 {
103 "metadata":{"numFound":${numFound},"start":${start}},
104 "docs":[],
105 "queryEs":"${getJsonString(queryEs)}"
106 }
107 </#if>
108 </#if>
109
110
111
112
113 <#macro writeItems>
114 <#assign start =resultQry.getJSONObject("data").getJSONObject("response").getString("start")>
115 <#assign items =resultQry.getJSONObject("data").getJSONObject("response").getJSONArray("docs")>
116 {
117<#-- "metadata":{"numFound":${numFound},"start":${start},"querySlr":"${getJsonString(querySlr)}","c1":"${c1}","orderByColumn1":"${orderByColumn1}","orderByType1":"${orderByType1}","fields":"${fields}", -->
118 "metadata":{"numFound":${numFound},"start":${start},"queryEs":"${getJsonString(queryEs)}"},
119 "docs":[
120 <#list 0..items.length()-1 as i>
121 <#assign doc = items.getJSONObject(i)>
122 <@jsonoutput />
123 <#if i !=items.length()-1>,</#if>
124 </#list>
125 ]
126 }
127 </#macro>
128
129 <#macro jsonoutput>
130 <#assign articleId=doc.getString("articleId")>
131 <#assign articleGroupId=doc.getString("groupId")?number>
132 <#assign jaarticle=journalServiceAPI.getArticle(groupId,articleId)>
133 <#assign xmlarticle=jaarticle.getContent()>
134 <#assign viewUrl = suggestoMkspAPI.getArticleUrl(articleGroupId,"", articleId,locDef,locDef,'/det')>
135 <#assign jsonArticle=JSONFactoryUtil.convertXMLtoJSONMLObject(xmlarticle)>
136 {
137 "localid":"${articleGroupId?string}-${articleId}",
138 "last_update":"${jaarticle.getModifiedDate()?date?iso_utc}T${jaarticle.getModifiedDate()?time?iso_utc}",
139 "autore":"${jaarticle.getUserName()}",
140 "canonical":"https://www.visitcuneese.it/${viewUrl}",
141 "assetCategoryIds":${doc.assetCategoryIds},
142 "assetCategoryTitles_it_IT":${doc.assetCategoryTitles_it_IT},
143 "content":${jsonArticle.toString()}
144 }
145 </#macro>
146
147 <#function getJsonString str>
148 <#return str?js_string?replace("\\'", "'")?replace("\\>",">")>
149 </#function>
150
151 </#compress>