Statistics - manage queries

1 files changed, 125 insertions, 0 deletions

diff --git a/ishtar_common/templates/blocks/DataTables-stats.html b/ishtar_common/templates/blocks/DataTables-stats.html
new file mode 100644
index 000000000..da3a85179
--- /dev/null
+++ b/ishtar_common/templates/blocks/DataTables-stats.html
@@ -0,0 +1,125 @@
+{% load i18n %}
+<div>
+    <div id="stats-form-{{name}}">
+        <label for="stats_renderer-{{name}}">{% trans "Type" %}</label>
+        <select id="stats_renderer-{{name}}" name="stats_renderer">
+            <option value="line" selected='selected'>{% trans "Line" %}</option>
+            <option value="bar">{% trans "Bar" %}</option>
+            <option value="pie">{% trans "Pie" %}</option>
+            <option value="table">{% trans "Table" %}</option>
+        </select>
+        <label for="stats_modality_1-{{name}}">{% trans "Modality 1" %}</label>
+        <select id="stats_modality_1-{{name}}" name="stats_modality_1">
+            {% for modality, modality_lbl in current_model.STATISTIC_MODALITIES_OPTIONS.items %}
+            <option value="{{modality}}"{% if forloop.first %} selected='selected'{% endif %}>{{modality_lbl}}</option>
+            {% endfor %}
+        </select>
+        <label for="stats_modality_2-{{name}}">{% trans "Modality 2" %}</label>
+        <select id="stats_modality_2-{{name}}" name="stats_modality_2">
+            <option value="" selected='selected'>--</option>
+            {% for modality, modality_lbl in current_model.STATISTIC_MODALITIES_OPTIONS.items %}
+            <option value="{{modality}}">{{modality_lbl}}</option>
+            {% endfor %}
+        </select>
+        <label for="stats_sum-{{name}}">{% trans "Sum" %}</label>
+        <select id="stats_sum-{{name}}" name="stats_sum">
+            {% for sum_var, sum_var_lbl in current_model.STATISTIC_SUM_VARIABLE.items %}
+            <option value="{{sum_var}}"{% if forloop.first %} selected='selected'{% endif %}>{{sum_var_lbl}}</option>
+            {% endfor %}
+        </select>
+    </div>
+    <hr/>
+    <div id="charts-{{name}}">
+        <div id="chart-{{name}}"
+                style="height:400px; width:700px; margin-right:auto; margin-left:auto"></div>
+        <hr/>
+        <p class='alert alert-info' id="stats-zoom-help-{{name}}" style="z-index:-1">
+            <i class="fa fa-info-circle" aria-hidden="true"></i>&nbsp;
+            {% trans 'Draw rectangle on the graph to zoom. Double-click to reinitialize.' %}
+        </p>
+        <div class='form chart-img-form'>
+            <div class="text-center">
+                <button id="chart-img-display-{{name}}"
+                        type='button' class='btn btn-secondary'>
+                    {% trans "Display as an image" %}
+                </button>
+            </div>
+            <br>
+            <div id="chart-img-{{name}}" class='chart-img'>
+                <div class="card">
+                    <div id="img-{{name}}"
+                            class="card-img-top text-center ml-3 mt-3"></div>
+                    <div class="card-body">
+                        <div class='alert alert-info'>
+                            <i class="fa fa-info-circle" aria-hidden="true"></i>&nbsp;
+                            {% trans 'Right-click on this image to save it.' %}
+                        </div>
+                    </div>
+                </div>
+            </div>
+        </div>
+    </div>
+    <div id="stats-table-{{name}}">
+        <div id="stats-table-content-{{name}}"></div>
+        <hr>
+        <div class="text-center">
+            <a id="stats-table-csv-{{name}}" href="#"
+                    type='button' class='btn btn-secondary'>
+                {% trans "Export as CSV" %}
+            </a>
+        </div>
+    </div>
+</div>
+
+<script language="javascript" type="text/javascript">
+
+{% comment %}
+    var plot_{{name}} = $.jqplot('chart_{{name}}',
+        [{% for idx, lbl, values in dashboard.values %}{% if forloop.counter0 > 0 %} {% if forloop.counter0 > 1 %}, {% endif%} values_{{forloop.counter0}}_{{name}} {% endif %} {% endfor%}], {
+        axes:{ {%ifequal slicing 'year'%}
+            xaxis:{
+            label:'{% trans "Year" %}',
+            tickOptions: {
+                formatString: "%d"
+            }
+            },{%endifequal%}{%ifequal slicing 'month'%}
+            xaxis:{
+            label:'{% trans "Month" %}',
+            renderer:$.jqplot.DateAxisRenderer,
+            tickRenderer:$.jqplot.CanvasAxisTickRenderer,
+            tickOptions:{
+                formatString:'%b %Y',
+                angle:-25
+            }
+            },{%endifequal%}
+            yaxis:{
+            label:'{% trans "Number"%}',
+            min:0
+            }
+        },
+        highlighter: {
+            show: true,
+            sizeAdjust: 7.5
+        },
+        series:[{% for label in dashboard.serie_labels %}
+            {%if forloop.counter0%}, {% endif %}{label:"{{label}}", showmarker:showmarker}{% endfor %}
+        ],
+        cursor:{
+            show: true,
+            zoom:true,
+            showTooltip:false
+        },
+        legend: { show:true, location: 'nw' }
+    });
+    }
+
+    $('#search_{{name}}').click(function (){
+        $.post("{% url 'dashboard-main-detail' item_name %}",
+                $("#{{name}}_form").serialize(),
+                function(data){
+                    $("#{{name}}-tab").parent().html(data);
+                });
+        return false;
+    });
+    {% endcomment %}
+</script>
\ No newline at end of file