! Monthly Statistics
{DIV(class="monthly-stats")}
    {CUSTOMSEARCH(tpl="themes/templates/monthly_statistics_search_form.tpl" searchfadediv="customsearch_0_results" recalllastsearch="0" searchonload="1" requireinput="0" forcesortmode="0" searchfadediv="customsearch_0_form" customsearchjs="1")}
      {filter field=tracker_id content="3"}
      {facet name="tracker_field_projectCompany" operator="or" count="200" order="_term_asc" min="0"}
      {pagination max="300"}
      {tablesorter server="n" sortable="y" sortList="[0,0]" tsortcolumns="type:n|type:digit|type:digit|type:digit|type:digit|type:digit|type:digit|type:digit" tsfilters="y" tstotals="type:none|type:col;formula:sum;filter:visible;label:Totals|type:col;formula:sum;filter:visible;label:Totals|type:col;formula:sum;filter:visible;label:Totals|type:col;formula:sum;filter:visible;label:Totals|type:col;formula:sum;filter:visible;label:Totals|type:col;formula:sum;filter:visible;label:Totals|type:col;formula:sum;filter:visible;label:Totals"}
      {output template="themes/templates/monthly_statistics_list.tpl"}
    {CUSTOMSEARCH}
{DIV}

{literal}

    {* add dropdown for months and year from May 1st*}
    
        
        {tr}Financial Year To Date{/tr}
        {tr}January{/tr}
        {tr}February{/tr}
        {tr}March{/tr}
        {tr}April{/tr}
        {tr}May{/tr}
        {tr}June{/tr}
        {tr}July{/tr}
        {tr}August{/tr}
        {tr}September{/tr}
        {tr}October{/tr}
        {tr}November{/tr}
        {tr}December{/tr}
    

    {daterange _field="tracker_field_projectDate" id="date" _to="now" _from="first day of this month"}

    {input type="Submit" value="Search" id="button" class="btn btn-default btn-sm"}

{/literal}

{* PluginCusrtomSearch send the request data in the AJAX call in a JSON encoded parameter called "adddata" *}
{$adddata = $smarty.request.adddata|json_decode:true}

{* a couple of handy debug blocks to see what's being send trom the server *}
{$adddata|var_dump}
{$facets|var_dump}

{if isset($adddata.date.value)}
    {* date range is sent as two unix timestamps "xxxxxx,yyyyyy" *}
    {$projectDate = ','|explode:$smarty.request.adddata.date.value}
    {$projectDate = '{filter range="tracker_field_projectDate" from="'|cat:$projectDate[0]|cat:'" to="'|cat:$projectDate[1]|cat:'"}'}
{/if}


        {foreach $facets['tracker_field_projectCompanyName'].options as $id => $name}
            
{$row|var_dump}
            {* facet labels get sent in the form "Label Text (count)" so use a regular expression here to split it into an array *}
            {$r = preg_match('/(.*)\((\d+)\)/', $name, $m)}
            {wikiplugin _name='list'}{literal}
                {filter field="tracker_id" content="3"}
                {filter field="tracker_field_projectCompanyName" content="{/literal}{$id}{literal}"}
                {pagination max="1"}
                {facet name="tracker_field_projectCurrentStatus" operator="or"}
                {facet name="tracker_field_projectPriorityLevel" operator="or"}
                {/literal}{$projectDate}{literal}
                {output template="themes/templates/monthly_statistics_inner_row.tpl"}
                {ALTERNATE()}{ALTERNATE}
                {FORMAT(name="distributorName")}{/literal}{$m[1]}{literal}{FORMAT}
                {FORMAT(name="projectCount")}{/literal}{$m[2]}{literal}{FORMAT}
            {/literal}{/wikiplugin}
        {/foreach}
    

    

        

            
{tr}Company Name{/tr}
            
{tr}New Projects{/tr}
            
{tr}Live Projects{/tr}
            
{tr}High Priority Status{/tr}
            
{tr}Medium Priority Status{/tr}
            
{tr}Low Priority Status{/tr}
            
{tr}Ordered PP{/tr}
            
{tr}Ordered MP{/tr}
        
    
    
{/literal}{$m[1]}{literal}
0
0
0
0
0
0
0
    

        

            
{tr}Company Name{/tr}
            
{tr}New Projects{/tr}
            
{tr}Live Projects{/tr}
            
{tr}High Priority Status{/tr}
            
{tr}Medium Priority Status{/tr}
            
{tr}Low Priority Status{/tr}
            
{tr}Ordered PP{/tr}
            
{tr}Ordered MP{/tr}
        
    

{$row = $results[0]}

$(document).ready( function() {
    // set up month selector dropdown
    $("#daterange-presets").change(function () {
        var val = $(this).val(),
            $from = $("#date_from_dptxt"),
            $to = $("#date_to_dptxt"),
            now = new Date(),
            year = now.getFullYear();

        if (val === "year") {
            $from.datepicker("setDate", "1/05/" + year).change();
            $to.datepicker("setDate", now).change();
        } else {
            val = parseInt(val);

            $from.datepicker("setDate", "1/" + val + "/" + year).change();
            if (val === 12) {
                val = 0;
                year++;
            }
            $to.datepicker("setDate", "1/" + (val + 1) + "/" + year).change();
        }
        $("table#wpcs-0").find("th:first-child").trigger("sort");
        $csForm.submit();
    });
});