[Summary view] [Print] [Text view]

   1  {*<!--
   2  /*********************************************************************************
   3    ** The contents of this file are subject to the vtiger CRM Public License Version 1.0
   4     * ("License"); You may not use this file except in compliance with the License
   5     * The Original Code is:  vtiger CRM Open Source
   6     * The Initial Developer of the Original Code is vtiger.
   7     * Portions created by vtiger are Copyright (C) vtiger.
   8     * All Rights Reserved.
   9    *
  10   ********************************************************************************/
  11  -->*}
  12  {strip}
  13      <div class="contents-topscroll">
  14          <div class="topscroll-div container-fluid">
  15              &nbsp;
  16           </div>
  17      </div>
  18      <div id="reportDetails" class="contents-bottomscroll">
  19          <div class="bottomscroll-div">
  20              <input type="hidden" id="updatedCount" value="{$NEW_COUNT}" />
  21              {if !empty($CALCULATION_FIELDS)}
  22              <table class=" table-bordered table-condensed marginBottom10px" width="100%">
  23                  <thead>
  24                      <tr class="blockHeader">
  25                          <th>{vtranslate('LBL_FIELD_NAMES',$MODULE)}</th>
  26                          <th>{vtranslate('LBL_SUM',$MODULE)}</th>
  27                          <th>{vtranslate('LBL_AVG',$MODULE)}</th>
  28                          <th>{vtranslate('LBL_MIN',$MODULE)}</th>
  29                          <th>{vtranslate('LBL_MAX',$MODULE)}</th>
  30                      </tr>
  31                  </thead>
  32                  {assign var=ESCAPE_CHAR value=array('_SUM','_AVG','_MIN','_MAX')}
  33                  {foreach from=$CALCULATION_FIELDS item=CALCULATION_FIELD key=index}
  34                      <tr>
  35                          {assign var=CALCULATION_FIELD_KEYS value=array_keys($CALCULATION_FIELD)}
  36                          {assign var=CALCULATION_FIELD_KEYS value=$CALCULATION_FIELD_KEYS|replace:$ESCAPE_CHAR:''}
  37                          {assign var=FIELD_IMPLODE value=explode('_',$CALCULATION_FIELD_KEYS['0'])}
  38                          {assign var=MODULE_NAME value=$FIELD_IMPLODE['0']}
  39                          {assign var=FIELD_LABEL value=" "|implode:$FIELD_IMPLODE}
  40                          {assign var=FIELD_LABEL value=$FIELD_LABEL|replace:$MODULE_NAME:''}
  41                          <td>{vtranslate($MODULE_NAME,$MODULE)} {vtranslate($FIELD_LABEL, $MODULE)}</td>
  42                          {foreach from=$CALCULATION_FIELD item=CALCULATION_VALUE}
  43                              <td width="15%">{$CALCULATION_VALUE}</td>
  44                          {/foreach}
  45                      </tr>
  46                  {/foreach}
  47              </table>
  48              {if $PRIMARY_MODULE eq 'Invoice' || $PRIMARY_MODULE eq 'Quotes' || $PRIMARY_MODULE eq 'SalesOrder' || $PRIMARY_MODULE eq 'PurchaseOrder'}
  49                  {assign var=BASE_CURRENCY_INFO value=Vtiger_Util_Helper::getCurrentInfoOfUser()}
  50                  <div class="alert alert-info">{vtranslate('LBL_NOTE', 'Vtiger')} : {vtranslate('LBL_CALCULATION_CONVERSION_MESSAGE', 'Reports')} - {$BASE_CURRENCY_INFO['currency_name']} ({$BASE_CURRENCY_INFO['currency_code']})</div>
  51              {/if}
  52          {/if}
  53  
  54          {if $DATA neq ''}
  55              {assign var=HEADERS value=$DATA[0]}
  56              <table class="table table-bordered table-striped">
  57                  <thead>
  58                      <tr class="blockHeader">
  59                          {foreach from=$HEADERS item=HEADER key=NAME}
  60                              <th nowrap>{vtranslate($NAME,$MODULE)}</th>
  61                          {/foreach}
  62                      </tr>
  63                  </thead>
  64                  {assign var=REPORTRUN value=$REPORT_RUN_INSTANCE}
  65                  {assign var=GROUPBYFIELDS value=array_keys($REPORTRUN->getGroupingList($RECORD_ID))}
  66                  {assign var=GROUPBYFIELDSCOUNT value=count($GROUPBYFIELDS)}
  67                  {if $GROUPBYFIELDSCOUNT > 0}
  68                      {assign var=FIELDNAMES value=array()}
  69                      {for $i=0 to $GROUPBYFIELDSCOUNT-1}
  70                          {assign var=FIELD value=explode(':',$GROUPBYFIELDS[$i])}
  71                          {assign var=FIELD_EXPLODE value=explode('_',$FIELD[2])}
  72                          {for $j=1 to count($FIELD_EXPLODE)-1}
  73                              {$FIELDNAMES.$i = $FIELDNAMES.$i|cat:$FIELD_EXPLODE[$j]|cat:" "}
  74                          {/for}
  75                      {/for}
  76                      
  77                      {if $GROUPBYFIELDSCOUNT eq 1}
  78                          {assign var=FIRST_FIELD value=vtranslate(trim($FIELDNAMES[0]), $MODULE)}
  79                      {else if $GROUPBYFIELDSCOUNT eq 2}    
  80                          {assign var=FIRST_FIELD value=vtranslate(trim($FIELDNAMES[0]),$MODULE)}
  81                          {assign var=SECOND_FIELD value=vtranslate(trim($FIELDNAMES[1]),$MODULE)}
  82                      {else if $GROUPBYFIELDSCOUNT eq 3}    
  83                          {assign var=FIRST_FIELD value=vtranslate(trim($FIELDNAMES[0]),$MODULE)}
  84                          {assign var=SECOND_FIELD value=vtranslate(trim($FIELDNAMES[1]),$MODULE)}
  85                          {assign var=THIRD_FIELD value=vtranslate(trim($FIELDNAMES[2]),$MODULE)}
  86                      {/if}    
  87  
  88                      {assign var=FIRST_VALUE value=" "}
  89                      {assign var=SECOND_VALUE value=" "}
  90                      {assign var=THIRD_VALUE value=" "}
  91                      {foreach from=$DATA item=VALUES}
  92                          <tr>
  93                              {foreach from=$VALUES item=VALUE key=NAME}
  94                                  {if ($NAME eq $FIRST_FIELD || $NAME|strstr:{$FIRST_FIELD}) && ($FIRST_VALUE eq $VALUE || $FIRST_VALUE eq " ")}
  95                                      {if $FIRST_VALUE eq " " || $VALUE eq "-"}
  96                                          <td>{$VALUE}</td>
  97                                      {else}    
  98                                          <td class="summary">{" "}</td>
  99                                      {/if}   
 100                                      {if $VALUE neq " " }
 101                                          {$FIRST_VALUE = $VALUE}
 102                                      {/if}   
 103                                  {else if ( $NAME eq $SECOND_FIELD || $NAME|strstr:$SECOND_FIELD) && ($SECOND_VALUE eq $VALUE || $SECOND_VALUE eq " ")}
 104                                       {if $SECOND_VALUE eq " " || $VALUE eq "-"}
 105                                          <td>{$VALUE}</td>
 106                                      {else}    
 107                                          <td class="summary">{" "}</td>
 108                                      {/if}   
 109                                      {if $VALUE neq " " }
 110                                          {$SECOND_VALUE = $VALUE}
 111                                      {/if}   
 112                                  {else if ($NAME eq $THIRD_FIELD || $NAME|strstr:$THIRD_FIELD) && ($THIRD_VALUE eq $VALUE || $THIRD_VALUE eq " ")}
 113                                      {if $THIRD_VALUE eq " " || $VALUE eq "-"}
 114                                          <td>{$VALUE}</td>
 115                                      {else}    
 116                                          <td class="summary">{" "}</td>
 117                                      {/if}   
 118                                      {if $VALUE neq " " }
 119                                          {$THIRD_VALUE = $VALUE}
 120                                      {/if}
 121                                  {else}
 122                                      <td>{$VALUE}</td>
 123                                      {if $NAME eq $FIRST_FIELD || $NAME|strstr:$FIRST_FIELD}
 124                                          {$FIRST_VALUE = $VALUE}
 125                                      {else if $NAME eq $SECOND_FIELD || $NAME|strstr:$SECOND_FIELD}
 126                                          {$SECOND_VALUE = $VALUE}
 127                                      {else if $NAME eq $THIRD_FIELD || $NAME|strstr:$THIRD_FIELD}
 128                                          {$THIRD_VALUE = $VALUE}
 129                                      {/if}    
 130                                  {/if}   
 131                              {/foreach}
 132                          </tr>
 133                      {/foreach}
 134                  {else}    
 135                      {foreach from=$DATA item=VALUES}
 136                          <tr>
 137                              {foreach from=$VALUES item=VALUE key=NAME}
 138                                  <td>{$VALUE}</td>
 139                              {/foreach}
 140                          </tr>
 141                      {/foreach}
 142                  {/if}
 143              </table>
 144              {if $LIMIT_EXCEEDED}
 145                  <center>{vtranslate('LBL_LIMIT_EXCEEDED',$MODULE)} <span class="pull-right"><a href="#top" >{vtranslate('LBL_TOP',$MODULE)}</a></span></center>
 146              {/if}
 147          {else}
 148              {vtranslate('LBL_NO_DATA_AVAILABLE',$MODULE)}
 149          {/if}
 150          </div>
 151      </div>
 152      <br>    
 153     </div>
 154  </div>
 155  {/strip}