|
Server : Apache System : Linux srv.rainic.com 4.18.0-553.47.1.el8_10.x86_64 #1 SMP Wed Apr 2 05:45:37 EDT 2025 x86_64 User : rainic ( 1014) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/akaindir/www/crm/layouts/vlayout/modules/Reports/ |
Upload File : |
{*<!--
/*********************************************************************************
** The contents of this file are subject to the vtiger CRM Public License Version 1.0
* ("License"); You may not use this file except in compliance with the License
* The Original Code is: vtiger CRM Open Source
* The Initial Developer of the Original Code is vtiger.
* Portions created by vtiger are Copyright (C) vtiger.
* All Rights Reserved.
*
********************************************************************************/
-->*}
{strip}
<div class="contents-topscroll">
<div class="topscroll-div container-fluid">
</div>
</div>
<div id="reportDetails" class="contents-bottomscroll">
<div class="bottomscroll-div">
<input type="hidden" id="updatedCount" value="{$NEW_COUNT}" />
{if !empty($CALCULATION_FIELDS)}
<table class=" table-bordered table-condensed marginBottom10px" width="100%">
<thead>
<tr class="blockHeader">
<th>{vtranslate('LBL_FIELD_NAMES',$MODULE)}</th>
<th>{vtranslate('LBL_SUM',$MODULE)}</th>
<th>{vtranslate('LBL_AVG',$MODULE)}</th>
<th>{vtranslate('LBL_MIN',$MODULE)}</th>
<th>{vtranslate('LBL_MAX',$MODULE)}</th>
</tr>
</thead>
{assign var=ESCAPE_CHAR value=array('_SUM','_AVG','_MIN','_MAX')}
{foreach from=$CALCULATION_FIELDS item=CALCULATION_FIELD key=index}
<tr>
{assign var=CALCULATION_FIELD_KEYS value=array_keys($CALCULATION_FIELD)}
{assign var=CALCULATION_FIELD_KEYS value=$CALCULATION_FIELD_KEYS|replace:$ESCAPE_CHAR:''}
{assign var=FIELD_IMPLODE value=explode('_',$CALCULATION_FIELD_KEYS['0'])}
{assign var=MODULE_NAME value=$FIELD_IMPLODE['0']}
{assign var=FIELD_LABEL value=" "|implode:$FIELD_IMPLODE}
{assign var=FIELD_LABEL value=$FIELD_LABEL|replace:$MODULE_NAME:''}
<td>{vtranslate($MODULE_NAME,$MODULE)} {vtranslate($FIELD_LABEL, $MODULE)}</td>
{foreach from=$CALCULATION_FIELD item=CALCULATION_VALUE}
<td width="15%">{$CALCULATION_VALUE}</td>
{/foreach}
</tr>
{/foreach}
</table>
{if $PRIMARY_MODULE eq 'Invoice' || $PRIMARY_MODULE eq 'Quotes' || $PRIMARY_MODULE eq 'SalesOrder' || $PRIMARY_MODULE eq 'PurchaseOrder'}
{assign var=BASE_CURRENCY_INFO value=Vtiger_Util_Helper::getCurrentInfoOfUser()}
<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>
{/if}
{/if}
{if $DATA neq ''}
{assign var=HEADERS value=$DATA[0]}
<table class="table table-bordered table-striped">
<thead>
<tr class="blockHeader">
{foreach from=$HEADERS item=HEADER key=NAME}
<th nowrap>{vtranslate($NAME,$MODULE)}</th>
{/foreach}
</tr>
</thead>
{assign var=REPORTRUN value=$REPORT_RUN_INSTANCE}
{assign var=GROUPBYFIELDS value=array_keys($REPORTRUN->getGroupingList($RECORD_ID))}
{assign var=GROUPBYFIELDSCOUNT value=count($GROUPBYFIELDS)}
{if $GROUPBYFIELDSCOUNT > 0}
{assign var=FIELDNAMES value=array()}
{for $i=0 to $GROUPBYFIELDSCOUNT-1}
{assign var=FIELD value=explode(':',$GROUPBYFIELDS[$i])}
{assign var=FIELD_EXPLODE value=explode('_',$FIELD[2])}
{for $j=1 to count($FIELD_EXPLODE)-1}
{$FIELDNAMES.$i = $FIELDNAMES.$i|cat:$FIELD_EXPLODE[$j]|cat:" "}
{/for}
{/for}
{if $GROUPBYFIELDSCOUNT eq 1}
{assign var=FIRST_FIELD value=vtranslate(trim($FIELDNAMES[0]), $MODULE)}
{else if $GROUPBYFIELDSCOUNT eq 2}
{assign var=FIRST_FIELD value=vtranslate(trim($FIELDNAMES[0]),$MODULE)}
{assign var=SECOND_FIELD value=vtranslate(trim($FIELDNAMES[1]),$MODULE)}
{else if $GROUPBYFIELDSCOUNT eq 3}
{assign var=FIRST_FIELD value=vtranslate(trim($FIELDNAMES[0]),$MODULE)}
{assign var=SECOND_FIELD value=vtranslate(trim($FIELDNAMES[1]),$MODULE)}
{assign var=THIRD_FIELD value=vtranslate(trim($FIELDNAMES[2]),$MODULE)}
{/if}
{assign var=FIRST_VALUE value=" "}
{assign var=SECOND_VALUE value=" "}
{assign var=THIRD_VALUE value=" "}
{foreach from=$DATA item=VALUES}
<tr>
{foreach from=$VALUES item=VALUE key=NAME}
{if ($NAME eq $FIRST_FIELD || $NAME|strstr:{$FIRST_FIELD}) && ($FIRST_VALUE eq $VALUE || $FIRST_VALUE eq " ")}
{if $FIRST_VALUE eq " " || $VALUE eq "-"}
<td>{$VALUE}</td>
{else}
<td class="summary">{" "}</td>
{/if}
{if $VALUE neq " " }
{$FIRST_VALUE = $VALUE}
{/if}
{else if ( $NAME eq $SECOND_FIELD || $NAME|strstr:$SECOND_FIELD) && ($SECOND_VALUE eq $VALUE || $SECOND_VALUE eq " ")}
{if $SECOND_VALUE eq " " || $VALUE eq "-"}
<td>{$VALUE}</td>
{else}
<td class="summary">{" "}</td>
{/if}
{if $VALUE neq " " }
{$SECOND_VALUE = $VALUE}
{/if}
{else if ($NAME eq $THIRD_FIELD || $NAME|strstr:$THIRD_FIELD) && ($THIRD_VALUE eq $VALUE || $THIRD_VALUE eq " ")}
{if $THIRD_VALUE eq " " || $VALUE eq "-"}
<td>{$VALUE}</td>
{else}
<td class="summary">{" "}</td>
{/if}
{if $VALUE neq " " }
{$THIRD_VALUE = $VALUE}
{/if}
{else}
<td>{$VALUE}</td>
{if $NAME eq $FIRST_FIELD || $NAME|strstr:$FIRST_FIELD}
{$FIRST_VALUE = $VALUE}
{else if $NAME eq $SECOND_FIELD || $NAME|strstr:$SECOND_FIELD}
{$SECOND_VALUE = $VALUE}
{else if $NAME eq $THIRD_FIELD || $NAME|strstr:$THIRD_FIELD}
{$THIRD_VALUE = $VALUE}
{/if}
{/if}
{/foreach}
</tr>
{/foreach}
{else}
{foreach from=$DATA item=VALUES}
<tr>
{foreach from=$VALUES item=VALUE key=NAME}
<td>{$VALUE}</td>
{/foreach}
</tr>
{/foreach}
{/if}
</table>
{if $LIMIT_EXCEEDED}
<center>{vtranslate('LBL_LIMIT_EXCEEDED',$MODULE)} <span class="pull-right"><a href="#top" >{vtranslate('LBL_TOP',$MODULE)}</a></span></center>
{/if}
{else}
{vtranslate('LBL_NO_DATA_AVAILABLE',$MODULE)}
{/if}
</div>
</div>
<br>
</div>
</div>
{/strip}