136 lines
7.9 KiB
Smarty
136 lines
7.9 KiB
Smarty
{*<!--
|
|
/*********************************************************************************
|
|
** 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}
|
|
<form class="form-horizontal recordEditView" id="report_step2" method="post" action="index.php">
|
|
<input type="hidden" name="module" value="{$MODULE}" />
|
|
<input type="hidden" name="view" value="Edit" />
|
|
<input type="hidden" name="mode" value="step3" />
|
|
<input type="hidden" name="record" value="{$RECORD_ID}" />
|
|
<input type="hidden" name="reportname" value="{$REPORT_MODEL->get('reportname')}" />
|
|
<input type="hidden" name="folderid" value="{$REPORT_MODEL->get('folderid')}" />
|
|
<input type="hidden" name="description" value="{$REPORT_MODEL->get('description')}" />
|
|
<input type="hidden" name="primary_module" value="{$PRIMARY_MODULE}" />
|
|
<input type="hidden" name="secondary_modules" value={ZEND_JSON::encode($SECONDARY_MODULES)} />
|
|
<input type="hidden" name="selected_fields" id="seleted_fields" value='{ZEND_JSON::encode($SELECTED_FIELDS)}' />
|
|
<input type="hidden" name="selected_sort_fields" id="selected_sort_fields" value="" />
|
|
<input type="hidden" name="calculation_fields" id="calculation_fields" value="" />
|
|
<input type="hidden" name="isDuplicate" value="{$IS_DUPLICATE}" />
|
|
|
|
<input type="hidden" name="enable_schedule" value="{$REPORT_MODEL->get('enable_schedule')}">
|
|
<input type="hidden" name="schtime" value="{$REPORT_MODEL->get('schtime')}">
|
|
<input type="hidden" name="schdate" value="{$REPORT_MODEL->get('schdate')}">
|
|
<input type="hidden" name="schdayoftheweek" value={ZEND_JSON::encode($REPORT_MODEL->get('schdayoftheweek'))}>
|
|
<input type="hidden" name="schdayofthemonth" value={ZEND_JSON::encode($REPORT_MODEL->get('schdayofthemonth'))}>
|
|
<input type="hidden" name="schannualdates" value={ZEND_JSON::encode($REPORT_MODEL->get('schannualdates'))}>
|
|
<input type="hidden" name="recipients" value={ZEND_JSON::encode($REPORT_MODEL->get('recipients'))}>
|
|
<input type="hidden" name="specificemails" value={ZEND_JSON::encode($REPORT_MODEL->get('specificemails'))}>
|
|
<input type="hidden" name="schtypeid" value="{$REPORT_MODEL->get('schtypeid')}">
|
|
|
|
<input type="hidden" class="step" value="2" />
|
|
<div class="well padding1per contentsBackground">
|
|
<div class="row-fluid block padding1per">
|
|
<div class="row-fluid padding1per"><strong>{vtranslate('LBL_SELECT_COLUMNS',$MODULE)}({vtranslate('LBL_MAX',$MODULE)} 25)</strong></div>
|
|
<div class="row-fluid padding1per">
|
|
<select data-placeholder="{vtranslate('LBL_ADD_MORE_COLUMNS',$MODULE)}" id="reportsColumnsList" class="select2-container span11 columns" multiple="">
|
|
{foreach key=PRIMARY_MODULE_NAME item=PRIMARY_MODULE from=$PRIMARY_MODULE_FIELDS}
|
|
{foreach key=BLOCK_LABEL item=BLOCK from=$PRIMARY_MODULE}
|
|
<optgroup label='{vtranslate($PRIMARY_MODULE_NAME,$MODULE)}-{vtranslate($BLOCK_LABEL,$PRIMARY_MODULE_NAME)}'>
|
|
{foreach key=FIELD_KEY item=FIELD_LABEL from=$BLOCK}
|
|
<option value="{$FIELD_KEY}" {if !empty($SELECTED_FIELDS) && in_array($FIELD_KEY,array_map('decode_html',$SELECTED_FIELDS))}selected=""{/if}>{vtranslate($PRIMARY_MODULE_NAME, $PRIMARY_MODULE_NAME)} {vtranslate($FIELD_LABEL, $PRIMARY_MODULE_NAME)}</option>
|
|
{/foreach}
|
|
</optgroup>
|
|
{/foreach}
|
|
{/foreach}
|
|
{foreach key=SECONDARY_MODULE_NAME item=SECONDARY_MODULE from=$SECONDARY_MODULE_FIELDS}
|
|
{foreach key=BLOCK_LABEL item=BLOCK from=$SECONDARY_MODULE}
|
|
<optgroup label='{vtranslate($SECONDARY_MODULE_NAME,$MODULE)}-{vtranslate($BLOCK_LABEL,$SECONDARY_MODULE_NAME)}'>
|
|
{foreach key=FIELD_KEY item=FIELD_LABEL from=$BLOCK}
|
|
<option value="{$FIELD_KEY}"{if !empty($SELECTED_FIELDS) && in_array($FIELD_KEY,array_map('decode_html',$SELECTED_FIELDS))}selected=""{/if}>{vtranslate($SECONDARY_MODULE_NAME, $SECONDARY_MODULE_NAME)} {vtranslate($FIELD_LABEL, $SECONDARY_MODULE_NAME)}</option>
|
|
{/foreach}
|
|
</optgroup>
|
|
{/foreach}
|
|
{/foreach}
|
|
</select>
|
|
</div>
|
|
</div>
|
|
<div class="row-fluid block padding1per">
|
|
<div class="row-fluid padding1per">
|
|
<span class="span6">
|
|
<strong>{vtranslate('LBL_GROUP_BY',$MODULE)}</strong>
|
|
</span>
|
|
<span class="span6">
|
|
<strong>{vtranslate('LBL_SORT_ORDER',$MODULE)}</strong>
|
|
</span>
|
|
</div>
|
|
{assign var=ROW_VAL value=1}
|
|
{foreach key=SELECTED_SORT_FIELD_KEY item=SELECTED_SORT_FIELD_VALUE from=$SELECTED_SORT_FIELDS}
|
|
<div class="row-fluid padding1per sortFieldRow">
|
|
{include file='RelatedFields.tpl'|@vtemplate_path:$MODULE ROW_VAL=$ROW_VAL}
|
|
{assign var=ROW_VAL value=($ROW_VAL+1)}
|
|
</div>
|
|
{/foreach}
|
|
{assign var=SELECTED_SORT_FEILDS_ARRAY value=$SELECTED_SORT_FIELDS}
|
|
{assign var=SELECTED_SORT_FIELDS_COUNT value=count($SELECTED_SORT_FEILDS_ARRAY)}
|
|
{while $SELECTED_SORT_FIELDS_COUNT lt 3 }
|
|
<div class="row-fluid padding1per sortFieldRow">
|
|
{include file='RelatedFields.tpl'|@vtemplate_path:$MODULE ROW_VAL=$ROW_VAL}
|
|
{assign var=ROW_VAL value=($ROW_VAL+1)}
|
|
{assign var=SELECTED_SORT_FIELDS_COUNT value=($SELECTED_SORT_FIELDS_COUNT+1)}
|
|
</div>
|
|
{/while}
|
|
</div>
|
|
<div class="row-fluid block padding1per">
|
|
<div class="padding1per"><strong>{vtranslate('LBL_CALCULATIONS',$MODULE)}</strong></div>
|
|
<div class="padding1per">
|
|
<table class="table table-bordered CalculationFields" width="100%">
|
|
<thead>
|
|
<tr class="calculationHeaders">
|
|
<th>{vtranslate('LBL_COLUMNS',$MODULE)}</th>
|
|
<th>{vtranslate('LBL_SUM_VALUE',$MODULE)}</th>
|
|
<th>{vtranslate('LBL_AVERAGE',$MODULE)}</th>
|
|
<th>{vtranslate('LBL_LOWEST_VALUE',$MODULE)}</th>
|
|
<th>{vtranslate('LBL_HIGHEST_VALUE',$MODULE)}</th>
|
|
</tr>
|
|
</thead>
|
|
{assign var=FIELD_OPERATION_VALUES value=','|explode:'SUM:2,AVG:3,MIN:4,MAX:5'}
|
|
{foreach key=CALCULATION_FIELDS_MODULE_LABEL item=CALCULATION_FIELDS_MODULE from=$CALCULATION_FIELDS}
|
|
{foreach key=CALCULATION_FIELD_KEY item=CALCULATION_FIELD from=$CALCULATION_FIELDS_MODULE}
|
|
{assign var=FIELD_EXPLODE value=explode(':',$CALCULATION_FIELD_KEY)}
|
|
{assign var=tableName value=$FIELD_EXPLODE['0']}
|
|
{assign var=columnName value=$FIELD_EXPLODE['1']}
|
|
{assign var=FIELDNAME_EXPLODE value=explode('_',$FIELD_EXPLODE['2'])}
|
|
{assign var=fieldNameArray value=array_slice($FIELDNAME_EXPLODE, 1)}
|
|
{assign var=fieldName value=implode('_',$fieldNameArray)}
|
|
<tr class="calculationFieldRow">
|
|
<td>{vtranslate($CALCULATION_FIELDS_MODULE_LABEL,$MODULE)}-{vtranslate($CALCULATION_FIELD,$CALCULATION_FIELDS_MODULE_LABEL)}</td>
|
|
{foreach item=FIELD_OPERATION_VALUE from=$FIELD_OPERATION_VALUES}
|
|
{assign var=FIELD_CALCULATION_VALUE value="cb:$tableName:$columnName:$fieldName"|cat:'_'|cat:$FIELD_OPERATION_VALUE}
|
|
<td width="15%">
|
|
<input class="calculationType" type="checkbox" value="{$FIELD_CALCULATION_VALUE}" {if !empty($SELECTED_CALCULATION_FIELDS) && in_array($FIELD_CALCULATION_VALUE,$SELECTED_CALCULATION_FIELDS)} checked=""{/if} />
|
|
</td>
|
|
{/foreach}
|
|
</tr>
|
|
{/foreach}
|
|
{/foreach}
|
|
</table>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="pull-right block">
|
|
<button type="button" class="btn btn-danger backStep"><strong>{vtranslate('LBL_BACK',$MODULE)}</strong></button>
|
|
<button type="submit" class="btn btn-success nextStep"><strong>{vtranslate('LBL_NEXT',$MODULE)}</strong></button>
|
|
<a class="cancelLink" onclick="window.history.back()">{vtranslate('LBL_CANCEL',$MODULE)}</a>
|
|
<br>
|
|
</div>
|
|
<br><br>
|
|
</form>
|
|
{/strip} |