[ Index ] |
PHP Cross Reference of vtigercrm-6.1.0 |
[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 <form class="form-horizontal recordEditView" id="report_step2" method="post" action="index.php"> 14 <input type="hidden" name="module" value="{$MODULE}" /> 15 <input type="hidden" name="view" value="Edit" /> 16 <input type="hidden" name="mode" value="step3" /> 17 <input type="hidden" name="record" value="{$RECORD_ID}" /> 18 <input type="hidden" name="reportname" value="{$REPORT_MODEL->get('reportname')}" /> 19 <input type="hidden" name="folderid" value="{$REPORT_MODEL->get('folderid')}" /> 20 <input type="hidden" name="description" value="{$REPORT_MODEL->get('description')}" /> 21 <input type="hidden" name="primary_module" value="{$PRIMARY_MODULE}" /> 22 <input type="hidden" name="secondary_modules" value={ZEND_JSON::encode($SECONDARY_MODULES)} /> 23 <input type="hidden" name="selected_fields" id="seleted_fields" value='{ZEND_JSON::encode($SELECTED_FIELDS)}' /> 24 <input type="hidden" name="selected_sort_fields" id="selected_sort_fields" value="" /> 25 <input type="hidden" name="calculation_fields" id="calculation_fields" value="" /> 26 <input type="hidden" name="isDuplicate" value="{$IS_DUPLICATE}" /> 27 28 <input type="hidden" name="enable_schedule" value="{$REPORT_MODEL->get('enable_schedule')}"> 29 <input type="hidden" name="schtime" value="{$REPORT_MODEL->get('schtime')}"> 30 <input type="hidden" name="schdate" value="{$REPORT_MODEL->get('schdate')}"> 31 <input type="hidden" name="schdayoftheweek" value={ZEND_JSON::encode($REPORT_MODEL->get('schdayoftheweek'))}> 32 <input type="hidden" name="schdayofthemonth" value={ZEND_JSON::encode($REPORT_MODEL->get('schdayofthemonth'))}> 33 <input type="hidden" name="schannualdates" value={ZEND_JSON::encode($REPORT_MODEL->get('schannualdates'))}> 34 <input type="hidden" name="recipients" value={ZEND_JSON::encode($REPORT_MODEL->get('recipients'))}> 35 <input type="hidden" name="specificemails" value={ZEND_JSON::encode($REPORT_MODEL->get('specificemails'))}> 36 <input type="hidden" name="schtypeid" value="{$REPORT_MODEL->get('schtypeid')}"> 37 38 <input type="hidden" class="step" value="2" /> 39 <div class="well padding1per contentsBackground"> 40 <div class="row-fluid block padding1per"> 41 <div class="row-fluid padding1per"><strong>{vtranslate('LBL_SELECT_COLUMNS',$MODULE)}({vtranslate('LBL_MAX',$MODULE)} 25)</strong></div> 42 <div class="row-fluid padding1per"> 43 <select data-placeholder="{vtranslate('LBL_ADD_MORE_COLUMNS',$MODULE)}" id="reportsColumnsList" class="select2-container span11 columns" multiple=""> 44 {foreach key=PRIMARY_MODULE_NAME item=PRIMARY_MODULE from=$PRIMARY_MODULE_FIELDS} 45 {foreach key=BLOCK_LABEL item=BLOCK from=$PRIMARY_MODULE} 46 <optgroup label='{vtranslate($PRIMARY_MODULE_NAME,$MODULE)}-{vtranslate($BLOCK_LABEL,$PRIMARY_MODULE_NAME)}'> 47 {foreach key=FIELD_KEY item=FIELD_LABEL from=$BLOCK} 48 <option value="{$FIELD_KEY}" {if !empty($SELECTED_FIELDS) && in_array($FIELD_KEY,array_map('decode_html',$SELECTED_FIELDS))}selected=""{/if}>{vtranslate($FIELD_LABEL, $PRIMARY_MODULE_NAME)}</option> 49 {/foreach} 50 </optgroup> 51 {/foreach} 52 {/foreach} 53 {foreach key=SECONDARY_MODULE_NAME item=SECONDARY_MODULE from=$SECONDARY_MODULE_FIELDS} 54 {foreach key=BLOCK_LABEL item=BLOCK from=$SECONDARY_MODULE} 55 <optgroup label='{vtranslate($SECONDARY_MODULE_NAME,$MODULE)}-{vtranslate($BLOCK_LABEL,$SECONDARY_MODULE_NAME)}'> 56 {foreach key=FIELD_KEY item=FIELD_LABEL from=$BLOCK} 57 <option value="{$FIELD_KEY}"{if !empty($SELECTED_FIELDS) && in_array($FIELD_KEY,array_map('decode_html',$SELECTED_FIELDS))}selected=""{/if}>{vtranslate($FIELD_LABEL, $SECONDARY_MODULE_NAME)}</option> 58 {/foreach} 59 </optgroup> 60 {/foreach} 61 {/foreach} 62 </select> 63 </div> 64 </div> 65 <div class="row-fluid block padding1per"> 66 <div class="row-fluid padding1per"> 67 <span class="span6"> 68 <strong>{vtranslate('LBL_GROUP_BY',$MODULE)}</strong> 69 </span> 70 <span class="span6"> 71 <strong>{vtranslate('LBL_SORT_ORDER',$MODULE)}</strong> 72 </span> 73 </div> 74 {assign var=ROW_VAL value=1} 75 {foreach key=SELECTED_SORT_FIELD_KEY item=SELECTED_SORT_FIELD_VALUE from=$SELECTED_SORT_FIELDS} 76 <div class="row-fluid padding1per sortFieldRow"> 77 {include file='RelatedFields.tpl'|@vtemplate_path:$MODULE ROW_VAL=$ROW_VAL} 78 {assign var=ROW_VAL value=($ROW_VAL+1)} 79 </div> 80 {/foreach} 81 {assign var=SELECTED_SORT_FEILDS_ARRAY value=$SELECTED_SORT_FIELDS} 82 {assign var=SELECTED_SORT_FIELDS_COUNT value=count($SELECTED_SORT_FEILDS_ARRAY)} 83 {while $SELECTED_SORT_FIELDS_COUNT lt 3 } 84 <div class="row-fluid padding1per sortFieldRow"> 85 {include file='RelatedFields.tpl'|@vtemplate_path:$MODULE ROW_VAL=$ROW_VAL} 86 {assign var=ROW_VAL value=($ROW_VAL+1)} 87 {assign var=SELECTED_SORT_FIELDS_COUNT value=($SELECTED_SORT_FIELDS_COUNT+1)} 88 </div> 89 {/while} 90 </div> 91 <div class="row-fluid block padding1per"> 92 <div class="padding1per"><strong>{vtranslate('LBL_CALCULATIONS',$MODULE)}</strong></div> 93 <div class="padding1per"> 94 <table class="table table-bordered CalculationFields" width="100%"> 95 <thead> 96 <tr class="calculationHeaders"> 97 <th>{vtranslate('LBL_COLUMNS',$MODULE)}</th> 98 <th>{vtranslate('LBL_SUM_VALUE',$MODULE)}</th> 99 <th>{vtranslate('LBL_AVERAGE',$MODULE)}</th> 100 <th>{vtranslate('LBL_LOWEST_VALUE',$MODULE)}</th> 101 <th>{vtranslate('LBL_HIGHEST_VALUE',$MODULE)}</th> 102 </tr> 103 </thead> 104 {assign var=FIELD_OPERATION_VALUES value=','|explode:'SUM:2,AVG:3,MIN:4,MAX:5'} 105 {foreach key=CALCULATION_FIELDS_MODULE_LABEL item=CALCULATION_FIELDS_MODULE from=$CALCULATION_FIELDS} 106 {foreach key=CALCULATION_FIELD_KEY item=CALCULATION_FIELD from=$CALCULATION_FIELDS_MODULE} 107 {assign var=FIELD_EXPLODE value=explode(':',$CALCULATION_FIELD_KEY)} 108 {assign var=tableName value=$FIELD_EXPLODE['0']} 109 {assign var=columnName value=$FIELD_EXPLODE['1']} 110 {assign var=FIELDNAME_EXPLODE value=explode('_',$FIELD_EXPLODE['2'])} 111 {assign var=fieldNameArray value=array_slice($FIELDNAME_EXPLODE, 1)} 112 {assign var=fieldName value=implode('_',$fieldNameArray)} 113 <tr class="calculationFieldRow"> 114 <td>{vtranslate($CALCULATION_FIELDS_MODULE_LABEL,$MODULE)}-{vtranslate($CALCULATION_FIELD,$CALCULATION_FIELDS_MODULE_LABEL)}</td> 115 {foreach item=FIELD_OPERATION_VALUE from=$FIELD_OPERATION_VALUES} 116 {assign var=FIELD_CALCULATION_VALUE value="cb:$tableName:$columnName:$fieldName"|cat:'_'|cat:$FIELD_OPERATION_VALUE} 117 <td width="15%"> 118 <input class="calculationType" type="checkbox" value="{$FIELD_CALCULATION_VALUE}" {if !empty($SELECTED_CALCULATION_FIELDS) && in_array($FIELD_CALCULATION_VALUE,$SELECTED_CALCULATION_FIELDS)} checked=""{/if} /> 119 </td> 120 {/foreach} 121 </tr> 122 {/foreach} 123 {/foreach} 124 </table> 125 </div> 126 </div> 127 </div> 128 <div class="pull-right block"> 129 <button type="button" class="btn btn-danger backStep"><strong>{vtranslate('LBL_BACK',$MODULE)}</strong></button> 130 <button type="submit" class="btn btn-success nextStep"><strong>{vtranslate('LBL_NEXT',$MODULE)}</strong></button> 131 <a class="cancelLink" onclick="window.history.back()">{vtranslate('LBL_CANCEL',$MODULE)}</a> 132 <br> 133 </div> 134 <br><br> 135 </form> 136 {/strip}
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
Generated: Fri Nov 28 20:08:37 2014 | Cross-referenced by PHPXref 0.7.1 |