Prueba de concepto para recuperar registros insertados en los formularios de Liferay desde una plantilla ADT con freemaker.
<#assign PAGE_SIZE = 10 />
<#-- Servicios -->
<#assign formInstanceService = serviceLocator.findService("com.liferay.dynamic.data.mapping.service.DDMFormInstanceLocalService") />
<#assign formRecordService = serviceLocator.findService("com.liferay.dynamic.data.mapping.service.DDMFormInstanceRecordLocalService") />
<#-- Variables -->
<#assign selectedForm = "" />
<#assign formName = "" />
<#assign records = [] />
<#assign fieldNames = [] />
<#assign fieldLabels = [] />
<#-- Recupera todos los formularios definidos -->
<#assign allForms = formInstanceService.getDDMFormInstances(-1, -1) />
<#assign selectedFormId = 0 />
<#assign selectedFormIdParam = request.getParameter("formInstanceId")!"" />
<#if selectedFormIdParam?has_content>
<#attempt>
<#assign selectedFormId = selectedFormIdParam?number />
<#recover>
<#assign selectedFormId = 0 />
</#attempt>
</#if>
<#if selectedFormId gt 0>
<#assign selectedForm = formInstanceService.fetchDDMFormInstance(selectedFormId)!"" />
<#if selectedForm?has_content>
<#assign formName = selectedForm.getName(locale) />
<#assign records = formRecordService.getFormInstanceRecords(selectedFormId) />
<#assign records = records?reverse />
<#assign formDefinition = selectedForm.getDDMForm() />
<#assign fieldDefinitions = formDefinition.getDDMFormFieldsMap(true) />
<#list fieldDefinitions?keys as definitionKey>
<#assign fieldDefinition = fieldDefinitions[definitionKey] />
<#assign fieldName = fieldDefinition.getName() />
<#assign fieldLabel = fieldDefinition.getLabel().getString(locale)!fieldName />
<#if !fieldNames?seq_contains(fieldName)>
<#assign fieldNames = fieldNames + [fieldName] />
<#assign fieldLabels = fieldLabels + [fieldLabel] />
</#if>
</#list>
</#if>
</#if>
<#assign tableId = "form-entries-dynamic" />
<#assign pagerId = "form-pager-dynamic" />
<#assign infoId = "form-info-dynamic" />
<div class="container-fluid">
<h3 class="mb-3">Entradas de formularios</h3>
<#-- Selector de formularios -->
<div class="form-group mb-4">
<label for="formInstanceSelector">Selecciona un formulario</label>
<form id="formSelectorForm" method="get" action="${themeDisplay.getURLCurrent()?html}">
<select id="formInstanceSelector" name="formInstanceId" class="form-control" onchange="this.form.submit()">
<option value="">-- Selecciona un formulario --</option>
<#list allForms as availableForm>
<#assign availableFormId = availableForm.getFormInstanceId() />
<#assign availableFormName = availableForm.getName(locale) />
<option
value="${availableFormId}"
<#if selectedFormId == availableFormId>
selected="selected"
</#if>>
${availableFormName?html}
(ID: ${availableFormId})
</option>
</#list>
</select>
</form>
</div>
<#if selectedForm?has_content>
<div class="d-flex justify-content-between align-items-center mb-3 flex-wrap">
<h4>
<strong>${formName?html}</strong>
</h4>
<#if records?has_content>
<button type="button" class="btn btn-primary" onclick="descargarCSV()">
<span class="inline-item inline-item-before">
<svg aria-hidden="true" class="lexicon-icon lexicon-icon-download" viewBox="0 0 512 512" width="16" height="16">
<path fill="currentColor" d="M256 352 128 224l32-32 64 64V32h64v224l64-64 32 32zM64 384h384v64H64z"/>
</svg>
</span>
Descargar CSV
</button>
</#if>
</div>
<#if records?has_content>
<div class="table-responsive">
<table id="${tableId}" class="table table-striped table-hover table-bordered">
<thead>
<tr>
<th>ID de entrada</th>
<#list fieldLabels as fieldLabel>
<th>${fieldLabel?html}</th>
</#list>
</tr>
</thead>
<tbody>
<#list records as record>
<#assign formValues = record.getDDMFormValues() />
<#assign recordFieldValuesMap = formValues.getDDMFormFieldValuesMap(true) />
<tr>
<td>${record.getFormInstanceRecordId()}</td>
<#list fieldNames as fieldName>
<#assign cellValue = "" />
<#assign valuesList = [] />
<#if recordFieldValuesMap?? && recordFieldValuesMap[fieldName]??>
<#assign fieldValuesForName = recordFieldValuesMap[fieldName] />
<#assign availableOptions = {} />
<#if fieldDefinitions[fieldName]??>
<#assign fieldDefinition = fieldDefinitions[fieldName] />
<#assign fieldOptions = fieldDefinition.getDDMFormFieldOptions() />
<#if fieldOptions??>
<#assign availableOptions = fieldOptions.getOptions() />
</#if>
</#if>
<#list fieldValuesForName as fieldValue>
<#if fieldValue.getValue()??>
<#assign currentValue = fieldValue.getValue().getString(locale)!"" />
<#if currentValue?has_content && currentValue != "{}">
<#assign optionValues = [] />
<#-- Interpretar los valores de selección múltiple -->
<#if currentValue?starts_with("[") && currentValue?ends_with("]")>
<#attempt>
<#assign jsonValues = currentValue?eval />
<#list jsonValues as jsonValue>
<#assign optionValues = optionValues + [jsonValue?string] />
</#list>
<#recover>
<#assign optionValues = [currentValue] />
</#attempt>
<#else>
<#assign optionValues = [currentValue] />
</#if>
<#list optionValues as optionValue>
<#assign optionLabel = optionValue />
<#-- Buscar la etiqueta localizada por la clave de la opción -->
<#if availableOptions[optionValue]??>
<#assign localizedValue = availableOptions[optionValue] />
<#assign optionLabel = localizedValue.getString(locale)!optionValue />
</#if>
<#assign valuesList = valuesList + [optionLabel] />
</#list>
</#if>
</#if>
</#list>
<#assign cellValue = valuesList?join(", ") />
</#if>
<td>${cellValue?html}</td>
</#list>
</tr>
</#list>
</tbody>
</table>
</div>
<div id="${infoId}" class="d-flex justify-content-between align-items-center flex-wrap mt-3 mb-2">
<p class="text-muted mb-2">
Total de entradas: ${records?size}
</p>
<p class="text-muted mb-2" data-page-info></p>
</div>
<nav id="${pagerId}" aria-label="Paginación de entradas" class="mt-2 mb-4">
<ul class="pagination d-flex justify-content-center flex-wrap mb-0">
<li class="page-item" data-prev>
<button type="button" class="page-link" data-page-action="prev">
Anterior
</button>
</li>
<li class="page-item d-flex" data-page-numbers></li>
<li class="page-item" data-next>
<button type="button" class="page-link" data-page-action="next">
Siguiente
</button>
</li>
</ul>
</nav>
<#else>
<div class="alert alert-info">
Este formulario aún no tiene entradas.
</div>
</#if>
<#elseif selectedFormId gt 0>
<div class="alert alert-warning">
No se ha encontrado el formulario seleccionado.
</div>
<#else>
<div class="alert alert-info">
Selecciona un formulario para consultar sus entradas.
</div>
</#if>
</div>
<script>
(function() {
var table = document.getElementById("${tableId}");
var pager = document.getElementById("${pagerId}");
var info = document.getElementById("${infoId}");
if (!table || !pager || !info || table.dataset.paginationInitialized) {
return;
}
table.dataset.paginationInitialized = "true";
var rows = Array.from(table.tBodies[0].rows);
var pageSize = ${PAGE_SIZE};
var totalRows = rows.length;
var totalPages = Math.max(1, Math.ceil(totalRows / pageSize));
var currentPage = 1;
var prevItem = pager.querySelector("[data-prev]");
var nextItem = pager.querySelector("[data-next]");
var pageNumbers = pager.querySelector("[data-page-numbers]");
var pageInfo = info.querySelector("[data-page-info]");
function createPageButton(page) {
var li = document.createElement("li");
li.className = "page-item";
var button = document.createElement("button");
button.type = "button";
button.className = "page-link";
button.textContent = page;
button.addEventListener("click", function() {
currentPage = page;
renderPage();
});
li.appendChild(button);
return li;
}
function renderPage() {
var start = (currentPage - 1) * pageSize;
var end = Math.min(start + pageSize, totalRows);
rows.forEach(function(row, index) {
row.style.display =
(index >= start && index < end) ? "" : "none";
});
prevItem.classList.toggle("disabled", currentPage === 1);
nextItem.classList.toggle("disabled", currentPage === totalPages);
prevItem.querySelector("button").disabled = currentPage === 1;
nextItem.querySelector("button").disabled = currentPage === totalPages;
pageNumbers.replaceChildren();
var firstPage = Math.max(1, currentPage - 2);
var lastPage = Math.min(totalPages, firstPage + 4);
firstPage = Math.max(1, lastPage - 4);
if (firstPage > 1) {
pageNumbers.appendChild(createPageButton(1));
if (firstPage > 2) {
var dotsStart = document.createElement("li");
dotsStart.className = "page-item disabled";
dotsStart.innerHTML = '<span class="page-link">…</span>';
pageNumbers.appendChild(dotsStart);
}
}
for (var page = firstPage; page <= lastPage; page++) {
var li = createPageButton(page);
if (page === currentPage) {
li.classList.add("active");
li.querySelector("button").setAttribute("aria-current", "page");
}
pageNumbers.appendChild(li);
}
if (lastPage < totalPages) {
if (lastPage < totalPages - 1) {
var dotsEnd = document.createElement("li");
dotsEnd.className = "page-item disabled";
dotsEnd.innerHTML = '<span class="page-link">…</span>';
pageNumbers.appendChild(dotsEnd);
}
pageNumbers.appendChild(createPageButton(totalPages));
}
pageInfo.textContent =
"Mostrando " + (start + 1) + "–" + end + " de " + totalRows;
}
pager.querySelector('[data-page-action="prev"]').addEventListener("click", function() {
if (currentPage > 1) {
currentPage--;
renderPage();
}
});
pager.querySelector('[data-page-action="next"]').addEventListener("click", function() {
if (currentPage < totalPages) {
currentPage++;
renderPage();
}
});
renderPage();
})();
/* Descargar datos en CSV */
function descargarCSV() {
var tabla = document.getElementById("${tableId}");
if (!tabla) {
return;
}
var filas = tabla.querySelectorAll("thead tr, tbody tr");
var csv = Array.from(filas).map(function(fila) {
return Array.from(fila.querySelectorAll("th, td")).map(function(celda) {
var valor = celda.innerText || celda.textContent || "";
return '"' + valor.replace(/"/g, '""') + '"';
}).join(";");
}).join("\r\n");
var blob = new Blob(
["\uFEFF" + csv],
{ type: "text/csv;charset=utf-8;" }
);
var url = URL.createObjectURL(blob);
var enlace = document.createElement("a");
enlace.href = url;
enlace.download = "entradas_formulario_${selectedFormId}.csv";
document.body.appendChild(enlace);
enlace.click();
document.body.removeChild(enlace);
setTimeout(function() {
URL.revokeObjectURL(url);
}, 1000);
}
</script>