templates/CRM/Report/Form/Criteria.tpl

   1 {*
   2  +--------------------------------------------------------------------+
   3  | CiviCRM version 4.3                                                |
   4  +--------------------------------------------------------------------+
   5  | Copyright CiviCRM LLC (c) 2004-2013                                |
   6  +--------------------------------------------------------------------+
   7  | This file is a part of CiviCRM.                                    |
   8  |                                                                    |
   9  | CiviCRM is free software; you can copy, modify, and distribute it  |
  10  | under the terms of the GNU Affero General Public License           |
  11  | Version 3, 19 November 2007 and the CiviCRM Licensing Exception.   |
  12  |                                                                    |
  13  | CiviCRM is distributed in the hope that it will be useful, but     |
  14  | WITHOUT ANY WARRANTY; without even the implied warranty of         |
  15  | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.               |
  16  | See the GNU Affero General Public License for more details.        |
  17  |                                                                    |
  18  | You should have received a copy of the GNU Affero General Public   |
  19  | License and the CiviCRM Licensing Exception along                  |
  20  | with this program; if not, contact CiviCRM LLC                     |
  21  | at info[AT]civicrm[DOT]org. If you have questions about the        |
  22  | GNU Affero General Public License or the licensing of CiviCRM,     |
  23  | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
  24  +--------------------------------------------------------------------+
  25 *}
  26 {* Report form criteria section *}
  27     {if $colGroups}
  28       <div id="col-groups" class="civireport-criteria" >
  29         {if $componentName eq 'Grant'}
  30             <h3>{ts}Include these Statistics{/ts}</h3>
  31         {else}
  32             <h3>Display Columns</h3>
  33         {/if}
  34         {foreach from=$colGroups item=grpFields key=dnc}
  35             {assign  var="count" value="0"}
  36             {* Wrap custom field sets in collapsed accordion pane. *}
  37             {if $grpFields.group_title}
  38                 <div class="crm-accordion-wrapper crm-accordion collapsed">
  39                     <div class="crm-accordion-header">
  40                                     {$grpFields.group_title}
  41                     </div><!-- /.crm-accordion-header -->
  42                     <div class="crm-accordion-body">
  43             {/if}
  44             <table class="criteria-group">
  45                 <tr class="crm-report crm-report-criteria-field crm-report-criteria-field-{$dnc}">
  46                     {foreach from=$grpFields.fields item=title key=field}
  47                         {assign var="count" value=`$count+1`}
  48                         <td width="25%">{$form.fields.$field.html}</td>
  49                         {if $count is div by 4}
  50                             </tr><tr class="crm-report crm-report-criteria-field crm-report-criteria-field_{$dnc}">
  51                         {/if}
  52                     {/foreach}
  53                     {if $count is not div by 4}
  54                         <td colspan="4 - ($count % 4)"></td>
  55                     {/if}
  56                 </tr>
  57             </table>
  58             {if $grpFields.group_title}
  59                     </div><!-- /.crm-accordion-body -->
  60                 </div><!-- /.crm-accordion-wrapper -->
  61             {/if}
  62         {/foreach}
  63         </div>
  64     {/if}
  65
  66     {if $groupByElements}
  67         <div id="group-by-elements" class="civireport-criteria" >
  68         <h3>Group by Columns</h3>
  69         {assign  var="count" value="0"}
  70         <table class="report-layout">
  71             <tr class="crm-report crm-report-criteria-groupby">
  72                 {foreach from=$groupByElements item=gbElem key=dnc}
  73                     {assign var="count" value=`$count+1`}
  74                     <td width="25%" {if $form.fields.$gbElem} onClick="selectGroupByFields('{$gbElem}');"{/if}>
  75                         {$form.group_bys[$gbElem].html}
  76                         {if $form.group_bys_freq[$gbElem].html}:<br>
  77                             &nbsp;&nbsp;{$form.group_bys_freq[$gbElem].label}&nbsp;{$form.group_bys_freq[$gbElem].html}
  78                         {/if}
  79                     </td>
  80                     {if $count is div by 4}
  81                         </tr><tr class="crm-report crm-report-criteria-groupby">
  82                     {/if}
  83                 {/foreach}
  84                 {if $count is not div by 4}
  85                     <td colspan="4 - ($count % 4)"></td>
  86                 {/if}
  87             </tr>
  88         </table>
  89      </div>
  90     {/if}
  91
  92     {if $orderByOptions}
  93       <div id="order-by-elements" class="civireport-criteria" >
  94         <h3>Order by Columns</h3>
  95
  96   <table id="optionField">
  97         <tr>
  98         <th>&nbsp;</th>
  99         <th> Column</th>
 100         <th> Order</th>
 101         <th> Section Header / Group By</th>
 102         </tr>
 103
 104   {section name=rowLoop start=1 loop=6}
 105   {assign var=index value=$smarty.section.rowLoop.index}
 106   <tr id="optionField_{$index}" class="form-item {cycle values="odd-row,even-row"}">
 107         <td>
 108         {if $index GT 1}
 109             <a onclick="hideRow({$index}); return false;" name="orderBy_{$index}" href="#" class="form-link"><img src="{$config->resourceBase}i/TreeMinus.gif" class="action-icon" alt="{ts}hide field or section{/ts}"/></a>
 110         {/if}
 111         </td>
 112         <td> {$form.order_bys.$index.column.html}</td>
 113         <td> {$form.order_bys.$index.order.html}</td>
 114         <td> {$form.order_bys.$index.section.html}</td>
 115   </tr>
 116         {/section}
 117         </table>
 118             <div id="optionFieldLink" class="add-remove-link">
 119             <a onclick="showHideRow(); return false;" name="optionFieldLink" href="#" class="form-link"><img src="{$config->resourceBase}i/TreePlus.gif" class="action-icon" alt="{ts}show field or section{/ts}"/>{ts}another column{/ts}</a>
 120         </div>
 121         <script type="text/javascript">
 122             var showRows   = new Array({$showBlocks});
 123             var hideBlocks = new Array({$hideBlocks});
 124             var rowcounter = 0;
 125             {literal}
 126             if (navigator.appName == "Microsoft Internet Explorer") {
 127                 for ( var count = 0; count < hideBlocks.length; count++ ) {
 128                     var r = document.getElementById(hideBlocks[count]);
 129                     r.style.display = 'none';
 130                 }
 131             }
 132
 133             // hide and display the appropriate blocks as directed by the php code
 134             on_load_init_blocks( showRows, hideBlocks, '' );
 135
 136             function hideRow(i) {
 137                 showHideRow(i);
 138                 // clear values on hidden field, so they're not saved
 139                 cj('select#order_by_column_'+ i).val('');
 140                 cj('select#order_by_order_'+ i).val('ASC');
 141                 cj('input#order_by_section_'+ i).attr('checked', false);
 142             }
 143
 144             {/literal}
 145         </script>
 146       </div>
 147     {/if}
 148
 149     {if $form.options.html || $form.options.html}
 150         <div id="other-options" class="civireport-criteria" >
 151         <h3>Other Options</h3>
 152         <table class="report-layout">
 153             <tr class="crm-report crm-report-criteria-groupby">
 154           <td>{$form.options.html}</td>
 155           {if $form.blank_column_end}
 156               <td>{$form.blank_column_end.label}&nbsp;&nbsp;{$form.blank_column_end.html}</td>
 157                 {/if}
 158             </tr>
 159         </table>
 160         </div>
 161     {/if}
 162
 163     {if $filters}
 164   <div id="set-filters" class="civireport-criteria" >
 165         <h3>Set Filters</h3>
 166         <table class="report-layout">
 167       {assign var="counter" value=1}
 168             {foreach from=$filters     item=table key=tableName}
 169            {assign  var="filterCount" value=$table|@count}
 170             {* Wrap custom field sets in collapsed accordion pane. *}
 171           {if $colGroups.$tableName.group_title and $filterCount gte 1}
 172         {* we should close table that contains other filter elements before we start building custom group accordian  *}
 173         {if $counter eq 1}
 174                 </table>
 175       {assign var="counter" value=0}
 176         {/if}
 177                     <div class="crm-accordion-wrapper crm-accordion collapsed">
 178                     <div class="crm-accordion-header">
 179                                     {$colGroups.$tableName.group_title}
 180                     </div><!-- /.crm-accordion-header -->
 181                     <div class="crm-accordion-body">
 182                     <table class="report-layout">
 183                {/if}
 184                 {foreach from=$table       item=field key=fieldName}
 185                     {assign var=fieldOp     value=$fieldName|cat:"_op"}
 186                     {assign var=filterVal   value=$fieldName|cat:"_value"}
 187                     {assign var=filterMin   value=$fieldName|cat:"_min"}
 188                     {assign var=filterMax   value=$fieldName|cat:"_max"}
 189                     {if $field.operatorType & 4}
 190                         <tr class="report-contents crm-report crm-report-criteria-filter crm-report-criteria-filter-{$tableName}">
 191                             <td class="label report-contents">{$field.title}</td>
 192                             {include file="CRM/Core/DateRange.tpl" fieldName=$fieldName from='_from' to='_to'}
 193                         </tr>
 194                     {elseif $form.$fieldOp.html}
 195                         <tr class="report-contents crm-report crm-report-criteria-filter crm-report-criteria-filter-{$tableName}" {if $field.no_display} style="display: none;"{/if}>
 196                             <td class="label report-contents">{$field.title}</td>
 197                             <td class="report-contents">{$form.$fieldOp.html}</td>
 198                             <td>
 199                                <span id="{$filterVal}_cell">{$form.$filterVal.label}&nbsp;{$form.$filterVal.html}</span>
 200                                <span id="{$filterMin}_max_cell">{$form.$filterMin.label}&nbsp;{$form.$filterMin.html}&nbsp;&nbsp;{$form.$filterMax.label}&nbsp;{$form.$filterMax.html}</span>
 201                             </td>
 202                         </tr>
 203                     {/if}
 204                 {/foreach}
 205                 {if $colGroups.$tableName.group_title}
 206                         </table>
 207                         </div><!-- /.crm-accordion-body -->
 208                     </div><!-- /.crm-accordion-wrapper -->
 209                     {assign var=closed     value=1"} {*-- ie table tags are closed-- *}
 210                 {else}
 211                      {assign var=closed     value=0"} {*-- ie table tags are not closed-- *}
 212                 {/if}
 213
 214             {/foreach}
 215             {if $closed eq 0 }</table>{/if}
 216         </div>
 217     {/if}
 218
 219     {literal}
 220     <script type="text/javascript">
 221     {/literal}
 222         {foreach from=$filters item=table key=tableName}
 223             {foreach from=$table item=field key=fieldName}
 224     {literal}var val = "dnc";{/literal}
 225                 {assign var=fieldOp     value=$fieldName|cat:"_op"}
 226                 {if !($field.operatorType & 4) && !$field.no_display && $form.$fieldOp.html}
 227                     {literal}var val = document.getElementById("{/literal}{$fieldOp}{literal}").value;{/literal}
 228     {/if}
 229                 {literal}showHideMaxMinVal( "{/literal}{$fieldName}{literal}", val );{/literal}
 230             {/foreach}
 231         {/foreach}
 232
 233         {literal}
 234         function showHideMaxMinVal( field, val ) {
 235             var fldVal    = field + "_value_cell";
 236             var fldMinMax = field + "_min_max_cell";
 237             if ( val == "bw" || val == "nbw" ) {
 238                 cj('#' + fldVal ).hide();
 239                 cj('#' + fldMinMax ).show();
 240             } else if (val =="nll" || val == "nnll") {
 241                 cj('#' + fldVal).hide() ;
 242                 cj('#' + field + '_value').val('');
 243                 cj('#' + fldMinMax ).hide();
 244             } else {
 245                 cj('#' + fldVal ).show();
 246                 cj('#' + fldMinMax ).hide();
 247             }
 248         }
 249
 250   function selectGroupByFields(id) {
 251       var field = 'fields\['+ id+'\]';
 252       var group = 'group_bys\['+ id+'\]';
 253       var groups = document.getElementById( group ).checked;
 254       if ( groups == 1 ) {
 255           document.getElementById( field ).checked = true;
 256       } else {
 257           document.getElementById( field ).checked = false;
 258       }
 259   }
 260     </script>
 261     {/literal}
 262
 263     <div>{$form.buttons.html}</div>