Notes

{% fetchxml appDetailsQuery %}
<fetch mapping='logical'>
<entity name='crff0_appdetail'>
<attribute name='crff0_name' />
<attribute name='crff0_description' />
<filter type='and'>
<condition attribute='crff0_appdetailid' operator='eq' value='f45c424a-7cc5-ee11-a81c-6045bd6ca1b2' /> <!-- Replace with your actual App Details GUID -->
</filter>
</entity>
</fetchxml>
{% endfetchxml %}

{% fetchxml ratingsQuery %}
<fetch mapping='logical'>
<entity name='crff0_apprating'>
<attribute name='crff0_ratings' />
<filter type='and'>
<condition attribute='crff0_appratingid' operator='eq' value='f45c424a-7cc5-ee11-a81c-6045bd6ca1b2' /> <!-- Replace with your actual App Details GUID -->
</filter>
</entity>
</fetchxml>
{% endfetchxml %}

{% fetchxml locationsQuery %}
<fetch mapping='logical'>
<entity name='annotation'>
<attribute name='filename' />
<attribute name='documentbody' />
<attribute name='mimetype' />
<filter type='and'>
<condition attribute='objectid' operator='eq' value='f45c424a-7cc5-ee11-a81c-6045bd6ca1b2' /> <!-- Replace with your actual App Details GUID -->
</filter>
</entity>
</fetchxml>
{% endfetchxml %}

<h2>{{ title | default: "Locations" }}</h2>

{% assign totalRating = 0 %}
{% assign ratingCount = 0 %}
{% assign interval = interval | integer %}
{% assign count = count | integer %}
{% assign height = height | integer %}

<div class="container">
<div class="row">
<div class="col-md-6">
<!-- Display Name and Description -->
{% if appDetailsQuery.results.entities.size > 0 %}
<h3>{{ appDetailsQuery.results.entities[0]["crff0_name"] }}</h3>
<p>{{ appDetailsQuery.results.entities[0]["crff0_description"] }}</p>

{% if ratingsQuery.results.entities.size > 0 %}
{% for rating in ratingsQuery.results.entities %}
{% assign totalRating = totalRating | plus: rating["your_rating_point_attribute"] %}
{% assign ratingCount = ratingCount | plus: 1 %}
{% endfor %}
{% endif %}

{% if ratingCount > 0 %}
{% assign averageRating = totalRating | divided_by: ratingCount %}
<p>Average Rating: {{ averageRating }}</p>
<!-- Display Rating Stars -->
<div class="rating">
{% for i in (1..5) %}
{% if i <= averageRating %}
<span class="glyphicon glyphicon-star"></span>
{% else %}
<span class="glyphicon glyphicon-star-empty"></span>
{% endif %}
{% endfor %}
</div>
{% else %}
<p>No ratings found for the provided App Details GUID.</p>
{% endif %}
{% endif %}
</div>
<div class="col-md-6">
<span>Showing {{ count }} out of {{ locationsQuery.results.entities.size }}</span>
{% if locationsQuery.results.entities.size > 0 %}
<div id="carousel-example-generic" class="carousel slide" data-ride="carousel" data-interval="{{ interval }}">
<!-- Indicators -->
<ol class="carousel-indicators">
{% for location in locationsQuery.results.entities limit: count %}
<li data-target="#carousel-example-generic" data-slide-to="{{ forloop.index0 }}" class="{% if forloop.first %}active{% endif %}"></li>
{% endfor %}
</ol>
<!-- Wrapper for slides -->
<div class="carousel-inner" role="listbox">
{% for loc in locationsQuery.results.entities limit: count %}
<div class="item {% if forloop.first %}active{% endif %}" >
<img src='data:{{ loc["mimetype"] }};base64,{{ loc["documentbody"] }}'>
<div class="carousel-caption" style="background:white">
<h3>{{ loc["filename"] }}</h3>
</div>
</div>
{% endfor %}
</div>
<!-- Controls -->
<a class="left carousel-control" href="#carousel-example-generic" role="button" data-slide="prev">
<span class="glyphicon glyphicon-chevron-left" aria-hidden="true"></span>
<span class="sr-only">Previous</span>
</a>
<a class="right carousel-control" href="#carousel-example-generic" role="button" data-slide="next">
<span class="glyphicon glyphicon-chevron-right" aria-hidden="true"></span>
<span class="sr-only">Next</span>
</a>
</div>
{% else %}
<p>No images found for the provided App Details GUID.</p>
{% endif %}
</div>
</div>
</div>

<style>
.carousel .item {
background-size: cover;
background-repeat: no-repeat;
}
</style>

{% manifest %}
{
"type": "Functional",
"displayName": "Locations Slider",
"description": "Locations slider using the table 'Place' as the data source",
"tables": ["cr50f_place"],
"params": [
{
"id": "title",
"displayName": "Title",
"description": ""
},
{
"id": "interval",
"displayName": "Interval",
"description": "The amount of time to delay between automatically cycling an item. If false, carousel will not automatically cycle. Default: 5000ms"
},
{
"id": "count",
"displayName": "Count",
"description": "The number of locations to display"
},
{
"id": "height",
"displayName": "Slide's height",
"description": "In px, default: 500px"
}
]
}
{% endmanifest %}