Files
crm.clientright.ru/languages/ar_ae/ITS4YouReports.php
Fedor ac7467f0b4 Major CRM updates: AI Assistant, Court Status API, S3 integration improvements, and extensive file storage system
- Added comprehensive AI Assistant system (aiassist/ directory):
  * Vector search and embedding capabilities
  * Typebot proxy integration
  * Elastic search functionality
  * Message classification and chat history
  * MCP proxy for external integrations

- Implemented Court Status API (GetCourtStatus.php):
  * Real-time court document status checking
  * Integration with external court systems
  * Comprehensive error handling and logging

- Enhanced S3 integration:
  * Improved file backup system with metadata
  * Batch processing capabilities
  * Enhanced error logging and recovery
  * Copy operations with URL fixing

- Added Telegram contact creation API
- Improved error logging across all modules
- Enhanced callback system for AI responses
- Extensive backup file storage with timestamps
- Updated documentation and README files

- File storage improvements:
  * Thousands of backup files with proper metadata
  * Fix operations for broken file references
  * Project-specific backup and recovery systems
  * Comprehensive file integrity checking

Total: 26,461+ files added/modified including AWS SDK, vendor dependencies, and extensive backup system.
2025-10-16 11:17:21 +03:00

915 lines
43 KiB
PHP

<?php
/* * *******************************************************************************
* The content of this file is subject to the Reports 4 You license.
* ("License"); You may not use this file except in compliance with the License
* The Initial Developer of the Original Code is IT-Solutions4You s.r.o.
* Portions created by IT-Solutions4You s.r.o. are Copyright(C) IT-Solutions4You s.r.o.
* All Rights Reserved.
* ****************************************************************************** */
$languageStrings = Array (
"SINGLE_ITS4YouReports"=>"Report",
"ITS4YouReports"=>"Reports 4 You",
"LBL_MODULE_NAME"=>"Reports 4 You",
'MyExtension' => 'My Extension',
"LBL_TEMPLATE_GENERATOR"=>"Reports 4 You",
"LBL_DELETE"=>"Delete",
"LBL_ADD_TEMPLATE"=>"Add Report",
"LBL_LIST_SELECT"=>"Select",
"LBL_REPORT_NAME"=>"Report name",
"LBL_FOLDERNAMES"=>"Folder",
"LBL_MODULENAMES"=>"Module",
"LBL_DESCRIPTION"=>"Description",
"LBL_ACTION"=>"Action",
"LBL_TEMPLATE"=>"Report",
"LBL_EDIT"=>"Edit",
"LBL_NEW_TEMPLATE"=>"New Report",
"LBL_PROPERTIES"=>"Properties",
"LBL_PLS_SELECT"=>"Please select ...",
"LBL_COMPANY_USER_INFO"=>"Company and User information",
"LBL_OTHER_INFO"=>"Other information",
"LBL_INSERT_TO_TEXT"=>"Insert into report",
"LBL_INSERT_BARCODE_TO_TEXT"=>"Insert code into report",
"LBL_COMPANY_INFO"=>"Company information",
"LBL_USER_INFO"=>"Assigned to User",
"LBL_LOGGED_USER_INFO"=>"Logged in User",
"LBL_DUPLICATE"=>"Duplicate",
'LBL_REP_FOLDER_BUTTON'=>'Create New Report Folder',
'LBL_REP_FOLDER'=>'Report Folder',
'LBL_PRODUCT_SERVICE_NAME'=>'Name of product/service',
'LBL_REP_FOLDER_SUCCESS'=>'Report Folder was seccessfully created.',
'LBL_REP_FOLDER_EXIST'=>'Report Folder allready exist.',
'LBL_REP_FOLDER_PROBLEM'=>'Report Folder was not created.',
//installation
"LBL_INSTALL"=>"installation",
"LBL_EXPRESS"=>"Express",
"LBL_CUSTOM"=>"Custom",
"LBL_EXPRESS_DESC"=>"Standard vtiger installation is required.",
"LBL_CUSTOM_DESC"=>"In case of some changes have been made in files mentioned above of standard vtiger installation.",
"LBL_FINISH"=>"Finish",
"LBL_NEXT"=>"Next",
"LNK_LIST_NEXT"=>"Next",
"LBL_ADD_ITEM"=>"Add",
"LBL_INSTRUCTIONS"=>"Follow these instructions in order to install Reports 4 You.",
"LBL_FILE"=>"file",
"LBL_AROUND_LINE"=>"Around line",
"LBL_BEFORE"=>'<font color="green">before</font>',
"LBL_AFTER"=>'<font color="red">after</font>',
"LBL_ADD_FOLLOWING"=>"add the following",
"LBL_INSTAL_ERROR"=>"Error occured during installation of Reports 4 You.",
"LBL_ERROR_TBL"=>"Following tasks failed to finish",
"LBL_ERROR_COPY_FILE"=>"copy file",
"LBL_CHANGE_PERMISSION"=>"Please change file permission to 777.",
"LBL_RELOAD"=>"Retry",
"LBL_INSERT_KEY"=>"Please insert the license key you received in purchase confirmation email.",
"LBL_VALIDATE"=>"Validate",
"LBL_INVALID_KEY"=>"Invalid license key! Please contact the vendor of Reports 4 You.",
"LBL_ONLINE_ASSURE"=>"Please make sure that your server has an internet access in order to run validation.",
"LBL_ORDER_NOW"=>"Order now",
"LBL_DOWNLOAD_SRC" => "In order to generate Report Charts it's necessary to download and install HighCharts script.",
"LBL_DOWNLOAD_SRC_DESC" => 'Click on Download button to download <strong><a href="http://www.highcharts.com/" target="_blank">HighCharts</a></strong> package OEM License ID: 100028434001400.</pre>',
"LBL_DOWNLOAD"=>"Download",
"LBL_DOWNLOAD_STEP"=>"Download HighCharts",
"LBL_VALIDATION"=>"Validation",
"LBL_CUSTOMIZATION"=>"Customization",
"LBL_INSTALL_SELECTION"=>"Installation mode selection",
"DOWNLOAD_ERROR"=>"downloading mPDF from remote server",
"UNZIP_ERROR"=>"unzipping mpdf.zip",
"LBL_WELCOME"=>"Welcome to the Reports 4 You Installation Wizard",
"LBL_WELCOME_DESC"=>"This will install Reports 4 You into your vtiger CRM.",
"LBL_WELCOME_FINISH"=>"It is highly recommended to finish the installation without any interruption.",
"LBL_TRY_AGAIN"=>"Try Again",
"LBL_MB_STRING_ERROR"=>"mPdf script requires <strong>mb_string</strong> extension to be enabled in your PHP installation. Please enable this extension for correct working of Reports 4 You.",
"LBL_PROFILES_DESC"=>"Manage user-specific Reports 4 You access to different Roles.",
"LBL_SETPRIVILEGIES"=>"Define Reports 4 You privilegies for all profiles",
"LBL_PROFILES"=>"Profiles",
"LBL_CREATE_EDIT"=>"Create/Edit",
"LBL_VIEW"=>"View",
"LBL_DELETE"=>"Delete",
"LBL_SHARING_TAB"=>"Sharing",
"LBL_TEMPLATE_OWNER"=>"Report owner",
"LBL_SHARING_ERROR"=>"Select at least one entity that is allowed to share the report.",
"LBL_ORDER"=>"Order",
"LBL_SAVE_ORDER"=>"Save order of reports",
"LBL_ORDER_ERROR"=>"Please insert the valid order of reports.",
"LBL_ORDER_SAVE_OK"=>"Reports order has been saved successfully.",
"LBL_ORDER_SAVE_ERROR"=>"Error occured while saving the reports order.",
"LBL_DONT_DISPLAY_HEADER_ON_FIRST_PAGE"=>"Don't display header on first page",
"LBL_DONT_DISPLAY_FOOTER_ON_LAST_PAGE"=>"Don't display footer on last page",
"LBL_DISPLAY_FOOTER_ONLY_ON_LAST_PAGE"=>"Display footer only on last page",
"LBL_LISTVIEWBLOCK"=>"ListView block",
"LBL_COUNTER"=>"Counter",
"LBL_HEADER_FOOTER_VARIABLES"=>"Header/Footer variables",
"LBL_INSTALL_SUCCESS"=>"Reports 4 You has been installed successfully.",
'LBL_NONE'=>'None',
'LBL_CREATE_REPORT'=>'Create Report',
'LBL_REPORT_DETAILS'=>'Report Details',
'LBL_PRIMARY_MODULE'=>'Primary Module',
'LBL_RELATIVE_MODULE'=>'Related Module',
'LBL_RELATIVE_MODULES'=>'Related Modules',
'LBL_REPORT_TYPE'=>'Report Type',
'LBL_SELECT_REPORT_TYPE_BELOW'=>'Select Report type Below',
'LBL_TYPE_THE_NAME'=>'Type the Name',
'LBL_DESCRIPTION_FOR_REPORT'=>'Description for the report',
'LBL_SPECIFY_GROUPING'=>'Grouping',
'LBL_SPECIFY_REPORT_TYPE'=>'Specify Report Type',
'LBL_GROUPING_TOTALS'=>'Totals',
'LBL_SELECT_COLUMNS'=>'Columns',
'LBL_CALCULATIONS'=>'Calculations',
'LBL_FILTERS'=>'Filters',
'LBL_SHARING'=>'Sharing',
'LBL_LIMIT' => 'Limit',
'SET_LIMIT' => 'Max entries ',
'LBL_LIMITED' => 'Limited to',
'SET_EMPTY_FOR_ALL' => '(empty for show all entries)',
'LBL_LIMIT_SCHEDULER' => 'Scheduler',
'LBL_QUICK_FILTERS' => 'Quick filters',
'LBL_GROUP_FILTER' => 'Summaries filters',
'LBL_MOVE_TO'=>'Move to',
'LBL_RENAME_FOLDER'=>'Rename Folder',
'LBL_DELETE_FOLDER'=>'Delete Folder',
'LBL_LABELS'=>'Labels',
'LBL_TOTAL' => 'Total',
// ITS4YOU-CR SlOl | 19.8.2015 15:40
'LBL_REPORT_SQL' => 'Report SQL',
// ITS4YOU-CR SlOl | 1.7.2014 15:57
'LBL_GRAPHS'=>'Graphs & Tables',
'LBL_CHART_horizontal'=>'Bar',
'LBL_CHART_vertical'=>'Column',
'LBL_CHART_horizontalstacked'=>'Stacked bar',
'LBL_CHART_verticalstacked'=>'Stacked column',
'LBL_CHART_pie'=>'Pie',
'LBL_CHART_piepercentage'=>'Pie percentage',
'LBL_CHART_pie3D'=>'Pie 3D',
'LBL_CHART_pie3d'=>'Pie 3D',
'LBL_CHART_linechart'=>'Line',
'LBL_CHART_funnel'=>'Funnel',
'LBL_CHART_Title'=>'Chart title',
'LBL_CHART_Type'=>'Chart type',
'LBL_CHART_DataSeries'=>'Data Series',
'LBL_SELECT_CHARTTYPE'=>'Select chart type please.',
'LBL_GRAPHS_GENERATE'=>'Generate graph ...',
'LBL_GRAPHS_GENERATE_FAILED'=>'Generate graph failed! Contact vendor please.',
'LBL_CHART'=>'Chart',
'LBL_CHART_INFO'=>'Chart Info',
'ChartStyle'=>'Chart Style',
'Graph1'=>'Chart 1',
'Graph2'=>'Chart 2',
'Graph3'=>'Chart 3',
'Chart Progress Line'=>'Progress line',
'LBL_CALCULATION_DISPLAY'=>'Calculations displayed',
'LBL_DISPLAY_OVER'=>'Display over Report',
'LBL_DISPLAY_UNDER'=>'Display under Report',
'SELECT_FILTER_TYPE'=>'Select Report Type',
'LBL_USERS'=>'Users',
'LBL_GROUPS'=>'Groups',
'LBL_SELECT_FIELDS'=>'Select Fields',
'LBL_MEMBERS'=>'Members',
'LBL_RELATED_FIELDS'=>'Related Fields',
'LBL_NO_ACCESS'=>' Access Denied for module(s) ',
'LBL_NOT_ACTIVE'=>' Access Denied for module(s) ',
'LBL_PERM_DENIED'=>' Permission Denied for Report(s): ',
'LBL_FLDR_NOT_EMPTY'=>'Folder you are trying to delete is not Empty, Move or Delete the Reports in it.',
'NO_REL_MODULES'=>'No Related Modules for the Selected Module',
'NO_REL_FIELDS'=>'No Related Fields for the Selected Modules',
'LBL_REPORT_GENERATION_FAILED'=>'Report generation failed!',
'LBL_SORT_FIELD' => 'Sort by',
'LBL_SORT_ORDER' => 'Sort order',
// REPORT TYPES
'LBL_TABULAR_FORMAT'=>'Tabular Format',
'LBL_TABULAR_REPORTS_ARE_SIMPLEST'=>'Tabular Reports are the simplest and fastest way of getting your data',
'LBL_SUMMARY_REPORT'=>'Summary Report',
'LBL_SUMMARY_REPORT_VIEW_DATA_WITH_SUBTOTALS'=>'Summary reports allow you to view your data along with subtotals and other summary information',
'LBL_GROUPING_REPORT' => 'Grouping Summary Report',
'LBL_GROUPING_REPORT_VIEW_DATA_WITH_SUBTOTALS' => 'Grouping summary reports allow you to view your data along with subtotals and other summary information',
'LBL_COLUMNS'=>'Columns',
'LBL_COLUMNS_SUM'=>'Sum',
'LBL_COLUMNS_AVERAGE'=>'Average',
'LBL_COLUMNS_LOW_VALUE'=>'Lowest Value',
'LBL_COLUMNS_LARGE_VALUE'=>'Largest Value',
'LBL_COLUMNS_COUNT'=>'Count',
'LBL_GROUPING_SORT'=>'Sort Order:',
'LBL_GROUPING_SUMMARIZE'=>'Group by',
'LBL_GROUPING_THEN_BY'=>'and then by:',
'LBL_GROUPING_FINALLY_BY'=>'and finally by:',
'LBL_ADVANCED_FILTER'=>'Filters',
'LBL_STANDARD_FILTER'=>'Standard Filters',
'LBL_SF_COLUMNS'=>'Column',
'LBL_SF_STARTDATE'=>'Start Date',
'LBL_SF_ENDDATE'=>'End Date',
'LBL_AF_HDR1'=>'Set the search conditions to further restrict the list.',
'LBL_AF_HDR2'=>'You can use &quot;or&quot; filters by entering multiple items in the third column.',
'LBL_AF_HDR3'=>'You can enter up to 10 items, separated by commas. For example: CA, NY, TX, FL searches for CA or NY or TX or FL.',
'LBL_FILTER_OPTIONS'=>'Filter Options',
'LBL_CUSTOMIZE_BUTTON'=>'Customize',
'LBL_EXPORTPDF_BUTTON'=>'Export To PDF',
'LBL_PRINT_REPORT'=>'Print Report',
'LBL_SAVE_CHARTIMG'=>'Save Chart Image',
'LBL_APPLYFILTER_BUTTON'=>'Apply Filter',
'LBL_GENERATED_REPORT'=>'Generated Report',
'LBL_GRAND_TOTAL'=>'Grand Total',
'LBL_AVAILABLE_FIELDS'=>'Available Fields',
'LBL_SELECT_MODULE'=>'Select Module',
'LBL_PRIMARY_FIELDS'=>'Primary Module Fields',
'LBL_SELECTED_FIELDS'=>'Selected Fields',
'Custom'=>'Custom',
'Previous FY'=>'Previous FY',
'Current FY'=>'Current FY',
'Next FY'=>'Next FY',
'Previous FQ'=>'Previous FQ',
'Current FQ'=>'Current FQ',
'Next FQ'=>'Next FQ',
'Yesterday'=>'Yesterday',
'Today'=>'Today',
'Tomorrow'=>'Tomorrow',
'Last Week'=>'Last Week',
'Current Week'=>'Current Week',
'Next Week'=>'Next Week',
'Last Month'=>'Last Month',
'Current Month'=>'Current Month',
'Next Month'=>'Next Month',
'Last 7 Days'=>'Last 7 Days',
'Last 15 Days'=>'Last 15 Days',
'Last 30 Days'=>'Last 30 Days',
'Last 60 Days'=>'Last 60 Days',
'Last 90 Days'=>'Last 90 Days',
'Last 120 Days'=>'Last 120 Days',
'Next 7 Days'=>'Next 7 Days',
'Next 15 Days'=>'Next 15 Days',
'Next 30 Days'=>'Next 30 Days',
'Next 60 Days'=>'Next 60 Days',
'Next 90 Days'=>'Next 90 Days',
'Next 120 Days'=>'Next 120 Days',
"Less than today" => "Less than today",
"More than today" => "More than today",
"Older than 1 day" => "Older than 1 day",
"Older than 7 day" => "Older than 7 day",
"Older than 15 day" => "Older than 15 day",
"Older than 30 day" => "Older than 30 day",
"Older than 90 day" => "Older than 90 day",
"Older than 120 day" => "Older than 120 day",
'TITLE_VTIGERCRM_CREATE_REPORT' => 'vtiger CRM - Create Report',
'TITLE_VTIGERCRM_PRINT_REPORT' => 'vtiger - Print Report',
'NO_FILTER_SELECTED' => 'No filter Selected',
'BETWEEN' => 'between',
'LBL_IS' => 'is',
'LBL_AND'=>'and',
'LBL_BY'=>'by',
'LBL_OR'=>'or',
'LBL_NEW_GROUP'=>'Add Group',
'LBL_DELETE_GROUP'=>'Delete Group',
'LBL_NEW_CONDITION'=>'Add Condition',
'LBL_SHARING_TYPE'=>'Sharing Type',
'LBL_SELECT_REPORT_TYPE_TO_CONTROL_ACCESS'=>'Select Sharing Type to Control Access to the Report',
'LBL_VIEW_DETAILS' => 'View Details',
'LBL_SHOW_STANDARD_FILTERS' => 'Show Standard Filters',
// SCHEDULER
'LBL_ROLES'=>'Roles',
'LBL_ROLES_SUBORDINATES'=>'Roles and Subordinates',
'LBL_SCHEDULE_EMAIL'=>'Schedule Email',
'LBL_SCHEDULE_ACTIVE'=>'Scheduling Active',
'LBL_SCHEDULE_EMAIL_DESCRIPTION'=>'Schedule Report to be sent to the selected Recipients at regular intervals through email',
'LBL_USERS_AVAILABEL'=> 'Recipients',
'LBL_REPORT_FORMAT_PDF'=> 'PDF',
'pdf'=> 'PDF',
'LBL_REPORT_FORMAT_EXCEL'=> 'EXCEL',
'xls'=> 'EXCEL',
'LBL_REPORT_FORMAT_CSV'=> 'CSV',
'csv'=> 'CSV',
'LBL_REPORT_CSV_PATH'=> 'CSV path',
'LBL_REPORT_CSV_NAME'=> 'CSV filename',
'LBL_CSV_DIRECTORY_NOT_WRITABLE'=> 'Directory can not be created, path is not writable',
'LBL_REPORT_FORMAT_XML'=> 'XML',
'xml'=> 'XML',
'LBL_REPORT_FORMAT_EVERY'=> 'ALL',
'LBL_REPORT_FORMAT'=> 'Report Format',
'LBL_SELECT_USERS'=>'Available Recipients',
'LBL_USERS_SELECTED'=>'Selected Recipients',
'LBL_SELECT'=>'Select',
'Hourly'=>'Hourly',
'Daily'=>'Daily',
'Weekly'=>'Weekly',
'BiWeekly'=>'BiWeekly',
'Monthly'=>'Monthly',
'Annually'=>'Annually',
'HOURLY'=>'Hourly',
'DAILY'=>'Daily',
'WEEKLY'=>'Weekly',
'BIWEEKLY'=>'BiWeekly',
'MONTHLY'=>'Monthly',
'ANNUALLY'=>'Annually',
'LBL_SCHEDULE_REPORT'=>'Schedule Report',
'LBL_SCHEDULE_FREQUENCY'=>'Frequency',
'OPTION_SCHEDULE_EMAIL_CHOOSE'=>'Choose ..... ',
'LBL_SCHEDULE_EMAIL_TIME'=>'Time',
'LBL_SCHEDULE_EMAIL_DOW'=>'DOW',
'LBL_SCHEDULE_EMAIL_DAY'=>'Day',
'LBL_SCHEDULE_EMAIL_MONTH'=>'Month',
'WEEKDAY_STRINGS' => array('Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday'),
'MONTH_STRINGS' => array('January','February','March','April','May','June','July','August','September','October','November','December'),
'LBL_AUTO_GENERATED_REPORT_EMAIL' => 'This is an auto-generated email sent on behalf of a scheduled report.',
'LBL_TIME_FORMAT_MSG' => 'hh:mm (24 hour format)',
'LBL_SCH_AT' => 'at',
'LBL_SCH_ON' => 'on',
'LBL_SCH_IN' => 'in',
//Added while moving Groups file from User to Setting Module
'LBL_GROUP_NAME'=>'Group Name',
'LBL_MEMBER_AVLBL'=>'Available Entities & Members',
'LBL_MEMBER_SELECTED'=>'Selected Members',
'LBL_ENTITY'=>'Entity',
'LBL_OF'=>'of',
'LBL_CREATE_NEW_GROUP'=>'Create New Group',
'LBL_ADD_GROUP_BUTTON'=>'Add Group',
'LBL_GROUP_MESG1'=>'Groups are a flexible way to assign access rights, when complex access rights has to be defined. You can combine multiple entities like Roles, Users, profiles etc into a single group.',
'LBL_GROUP_MESG2'=>'To add, select the Entity members from left and click the ">>" button.',
'LBL_GROUP_MESG3'=>'To remove, select the group members from the right and click the "<<" button.',
'LBL_MEMBER'=>'Members',
'LBL_TIME_LINE_REPORT' => 'Time-line Report',
'LBL_TIME_LINE_REPORT_VIEW_DATA_WITH_SUBTOTALS' => 'Time-line reports allow you to view your data along time lines',
'LBL_TIME_LINE_FIELDS' => 'Time-line Fields',
'LBL_TIME_LINE_AXES' => 'X Axes',
'TL_DAYS' => 'Days',
'TL_WEEKS' => 'Weeks',
'TL_WEEK' => 'Weeks',
'TL_MONTHS' => 'Months',
'TL_MONTH' => 'Months',
'TL_QUARTERS' => 'Quarters',
'TL_QUARTER' => 'Quarters',
'TL_HALF_YEARS' => 'Half Years',
'TL_HALFYEAR' => 'Half Years',
'TL_YEARS' => 'Years',
'TL_YEAR' => 'Years',
// INFORMATIONS 4You START
'LBL_INFORMATIONS_4YOU' => 'Informations 4You',
// STEP NAMES
'LBL_STEP1' => 'Step 1',
'LBL_STEP2' => '',
'LBL_STEP3' => '',
'LBL_STEP4' => 'Step 2',
'LBL_STEP5' => 'Step 3',
'LBL_STEP6' => 'Step 4',
'LBL_STEP7' => 'Step 5',
'LBL_STEP8' => 'Step 6',
'LBL_STEP9' => 'Step 7',
'LBL_STEP10' => 'Step 8',
'LBL_STEP11' => '',
'LBL_STEP12' => 'Step 9',
// STEPS INFORMATIONS 4You
'LBL_STEP1_INFO' => 'In this Step you have to provide basic Report informations:<br />
Report name, Primary Module, Report Folder and Description.<br /><br />
<b>Attention:</b> After first module selection you will be not allowed to change it!',
'LBL_STEP2_INFO' => '',
'LBL_STEP3_INFO' => '',
// height="42" width="42"
'LBL_STEP4_INFO' => '
This is very important step where you will define what type of Report you will generate. Pay special attention to this step please!<br /><br />
<b>1/ Tabular Report:</b> - records displayed in standard tabular structure (mostly Activity report), skip this step and go to "Select Columns" step.<br />
<div style="width:100%;"><img src="modules/ITS4YouReports/chart_types/ch1.png" style="width:100%;" alt="Activity (Tabular) Report"></div><br />
<b>2/ Summaries Report:</b> - Please define Group by fields from first block. In this Report type it\'s necessary to define "Summaries Fields" which you want to report.<br />
Based on Rows or Columns structure you can get this two types of tables:<br />
<b>2a/ Summaries report:</b> - Group data choosing rows values by one of combination (rows-rows) or (rows-rows-rows),
<div style="width:100%;"><img src="modules/ITS4YouReports/chart_types/ch2R.png" style="width:100%;" alt="Summaries Report"></div>
<b>2b/ Summaries report with columns :</b> - In second selectbox choose columns as value and you will get rows-columns structure.
<div style="width:100%;"><img src="modules/ITS4YouReports/chart_types/ch2C.png" style="width:100%;" alt="Summaries Report with Columns"></div><br />
<b>3/ Summaries Report with details:</b> - Define ONE group by field, additionally you can select "summaries fields".<br />
<div style="width:100%;"><img src="modules/ITS4YouReports/chart_types/ch3.png" style="width:100%;" alt="Summaries Report with Details"></div><br />
Limit and Sort order block allows you to limits and order grouping records.<br />
',
'LBL_STEP5_INFO' => '
Here you can select the fields to display in report with details.<br />
These fields can be selected from the Report module selected in Step 1 and its related modules.<br />
Please choose one of available module from "Select Module" options and for easy navigation write part of field name in search input box.<br />
Limit and Sort order block allows you to limits and order detailed records.',
'LBL_STEP6_INFO' => 'Here you can define the calculations for the fields available across the Report modules. <br />
You can select the calculations like SUM, AVG, MIN and MAX values across the Report result records.',
'LBL_STEP7_INFO' => 'Labels Step gives you the flexibility to customize selected field labels.',
'LBL_STEP8_INFO' => '
In Filters you can specify the conditions to filter the results in a report.<br />
We can specify conditions in Filters and Summaries Filters.<br />
Filters have all the fields from the selected module and its related modules where the comparator and condition can be choosed based on type of field selected. <br />
You are allowed to provide unlimited number of conditions, recommender into 5 conditions.',
'LBL_STEP9_INFO' => '
Also you can specify the security of the report. Here you can select report Owner and the type of report Sharing Rules(Public, Private or Share) across users in role hierarchy.<br />
Report can only be edited by Owner and other users whose roles is higher to the role of Owner.
',
/*
Public - Report can be viewed by all the users but can only be edited by users with higher Role (than report owner),
Private - Report can only be viewed and edited by Owner and users with higher Role (than report owner),
Share - Owner of the report can share report with selected users, groups, roles or roles and subordinates. But, the report can only be edited by Owner and other users whose roles is higher to the role of Owner.
*/
'LBL_STEP10_INFO' => '
Scheduler gives you possibility to Send Reports at regular intervals to specific users through email without logging in to the CRM.<br />
Do not forget to check "Scheduling Active" to run this report using workflow scheduler.<br />
<br />
<b>Attention:</b> Schedule Report data will be generated for report owner! Be carefull, because you can send data generated for Report owner to not permitted Users!',
'LBL_STEP11_INFO' => '',
'LBL_STEP12_INFO' => '
In this step you can select and define Charts for your Reports.<br />
- "Chart title" of your Chart, <br />
- "Chart Style" means data values populated in charts <br />
- and finaly Chart definition contains chart type and series column.
',
// ITS4YOU-CR SlOl | 19.8.2015 15:03
'LBL_CUSTOMSTEP1_INFO' => 'In this Step you have to provide basic Report informations:<br />
Report name, Report Folder and Description.<br /><br />',
'LBL_CUSTOMSTEP12_INFO' => 'In this Step you have to provide Custom SQL Report Query!<br />
Custom report have to be programmed by skilled user with programming experiences. <br />Take care to be really careful with custom report sql definitions.<br /><br />
',
// INFORMATIONS 4You END
// ADD NEW FOLDER
'LBL_REP_FOLDER_DTLS'=>'Folder Details',
'LBL_REP_FOLDER_NAME'=>'Folder Name:',
'LBL_REP_FOLDER_DESC'=>'Folder Description:',
'LBL_ADD_NEW_GROUP'=>'Add New Folder',
'LBL_ADD'=>'Add',
'LBL_BACK_TO_REPORTS_LIST'=>'Back to Reports list',
'LBL_SELECT_ANOTHER_REPORT'=>'Select Another Report',
'LBL_CUSTOMIZE_REPORT'=>'Customize Report',
'LBL_SELECT_COLUMN'=>'Select Column',
'LBL_SELECT_TIME'=>'Select Time',
'LBL_GENERATE_NOW'=>'Generate Now',
'Totals'=>'Field Names',
'SUM'=>'SUM',
'AVG'=>'AVG',
'MAX'=>'MAX',
'MIN'=>'MIN',
"COUNT" => "COUNT",
'LBL_CUSTOM_REPORTS'=>'Custom Reports',
'LBL_UNCHECK_ALL' => 'Uncheck All',
'LBL_CHECK_ALL' => 'Check All',
// ITS4YOU-CR SlOl 20. 2. 2014 10:25:55
'LBL_Search_column'=>'Search column...',
// ITS4YOU-CR SlOl 30. 1. 2017 13:50:29
'LBL_Search_recipient'=>'Search recipients...',
// ITS4YOU-CR SlOl 27. 2. 2014 9:21:43
'NO_COLUMN'=>'No columns available for quick filters',
'NO_CALCULATION_COLUMN'=>'No columns available for calculations',
'IS_NULL'=>'NULL',
// ITS4YOU-CR SlOl 4. 3. 2014 15:47:39
'LBL_SAVE_RUN_BUTTON_LABEL'=>'Save & Run',
'LBL_SAVE_BUTTON_LABEL' => 'Save',
'LBL_CANCEL_BUTTON_LABEL' => 'Cancel',
// ITS4YOU-CR SlOl 6. 3. 2014 14:29:51
'NO_SUMMARIES_COLUMNS'=>'There are no summaries columns for selected module.',
'AVAILABLE_SUMMARIES_COLUMNS'=>'Available Summaries Fields',
'SELECTED_SUMMARIES_COLUMNS'=>'Selected Summaries Fields',
'COUNT_GROUP'=>'Count',
// ITS4YOU-CR SlOl 12. 3. 2014 10:29:18
"LBL_SC_LABELS"=>"Selected Columns",
"LBL_SM_LABELS"=>"Summary Columns",
"LBL_CT_LABELS"=>"Calculate Total Columns",
// ITS4YOU-CR SlOl 19. 3. 2014 15:36:31
"AVAILABLE_TIMELINE_COLUMNS"=>"Available Timeline Columns",
"EMPTY_Frequency"=>"Time line frequency can not be empty",
// ITS4YOU-CR SlOl 25. 3. 2014 11:50:16
"SELECT_SUMMARIES_ORDER_BY"=>"Select order by summaries field",
// ITS4YOU-CR SlOl | 14.5.2014 11:57
// ITS4YOU-CR SlOl 25. 3. 2014 11:50:16
"SUMMARIES_ORDER_BY"=>"Summaries Select order",
"SUMMARIES_LIMIT"=>"Summaries Max entries",
// ITS4YOU-CR SlOl | 14.5.2014 11:57
"LBL_ROWS"=>"Rows",
"LBL_COLS"=>"Columns",
// ITS4YOU-CR SlOl | 23.6.2014 11:24
// REPORT INFO HEADER LABELS
"LBL_Name"=>"Name",
"LBL_Module"=>"Module",
"LBL_Columns"=>"Columns",
"LBL_GroupBy"=>"Group By",
"LBL_Schedule"=>"Schedule",
"LBL_Filters"=>"Filters",
"LBL_Type"=>"Type",
"LBL_Sharing"=>"Sharing",
"PUBLIC_FILTER"=>"Public",
"PRIVATE_FILTER"=>"Private",
"SHARE_FILTER"=>"Share",
"LBL_SummariesColumns"=>"Summaries Columns",
// ITS4YOU-CR SlOl 24.6.2014 8:42
"LBL_NUMBER_OF_RECORDS"=>"Number of records",
"LBL_RECORDS"=>"Records",
"LBL_RECORD"=>"Record",
// ITS4YOU-CR SlOl | 16.7.2014 16:44
"LBL_ALL"=>"All",
"LBL_CHARE"=>"No Charts",
"LBL_NOT_A"=>"Not",
"LBL_DETAILDINFO"=>"Detail of records is ",
"LBL_IGNORED"=>"available for this report",
"LBL_NO_CHARTS"=>"No charts available",
// ITS4YOU-CR SlOl | 26.6.2014 9:06
"LBL_PDFMAKER_ERROR"=>"Please Install PDF Maker extension to use pdf export.",
// ITS4YOU-CR SlOl | 29.7.2014 9:18
"LBL_COLUMNS_ERROR"=>"You are not permitted to view some of Report columns. Please contact administrator.",
"LBL_FVALUES_ERROR"=>"You are not permitted to view some of Report condition values. Please contact administrator.",
"LBL_OWNER"=>"Owner",
"LBL_NO_DATA_TO_DISPLAY"=>"No Records Found !",
"campaignrelstatus" => "Campaign Status",
"Group by" => "Group by",
"LBL_COUNT" => "Count",
"LBL_Filter_SelectedColumnsGroup" => "Other columns",
"LBL_Summaries" => "Summaries",
"LBL_Details" => "Details",
"Please_Install_PDFMaker" => 'Please install PDF Maker extension for Exporting Reports to PDF.<br> Visit <a href="http://www.its4you.sk/en/vtiger-shop" target="_blank">IT-Solutions 4You s.r.o.</a> website to download free or advanced PDF Maker extension.',
"Test_Not_WriteAble" => 'PDF and Charts files could not be generated for a reason of NOT writeable "/Test" folder!',
// License Labels
"COPYRIGHT" => ":: IT-Solutions4You",
"LBL_LICENSE" => "License settings",
"LBL_LICENSE_DESC" => "Manage all settings related to your license.",
"LBL_LICENSE_KEY" => "License key",
"LBL_ACTIVATE_KEY" => "Activate license",
"LBL_REACTIVATE"=>"Reactivate license",
"LBL_REACTIVATE_DESC"=>"In case problem with license key occures while generating Report.",
"REACTIVATE_SUCCESS"=>"You have successfuly reactivated your Reports 4 You.",
"REACTIVATE_ERROR" => "Some error occured while (re)activating the license key.",
"LBL_DEACTIVATE_SUCCESS" => "License key has been deactivated successfully.",
"LBL_DEACTIVATE"=>"Deactivate license",
"LBL_DEACTIVATE_TITLE"=>"Deactivate license",
"LBL_DEACTIVATE_QUESTION"=>"Do You realy want to deactivate Your license key?",
"LBL_DEACTIVATE_DESC"=>"After deactivation You will be not allowed to generate Reports.<br /> After reactivation You will get the standard functionality.",
"LBL_DEACTIVATE_ERROR"=>"Deactivate the license key failed.",
"LBL_UPGRADE" => "Upgrade Reports 4 You",
"LBL_UNINSTALL" => "Uninstall Reports 4 You",
"LBL_UNINSTALL_DESC" => "Remove Reports 4 You completely from your vTiger.",
"LBL_UNINSTALL_CONFIRM" => "Are you sure to completely remove Reports 4 You from your vTiger and deactivate your Reports 4 You license?",
// Import Labels
"LBL_IMPORT_STEP" => "Import Reports 4 You",
"LBL_ANY_TO_IMPORT" => "Any new reports for import !",
"LBL_COPPY_FAILED" => "Failed to copy",
"LBL_IMPORT_SUCCESS" => "Report successfully imported, file copied to",
"LBL_FILE_NOT_SUPPORTED" => "Not supported file for Reports 4 You Import",
"LBL_DOTS" => "...",
"LBL_DOUBLEDOT" => ":",
"LBL_DONE" => "Done",
"LBL_ONLY_ADMIN" => "Only Administrator should delete Reports4You Cache Files",
"LBL_IMPORT_SKIP_1" => "Use ",
"LBL_IMPORT_SKIP_2" => " button to import ITS4You Reports (should take about 1 minute) or ",
"LBL_IMPORT_SKIP_3" => " to skip this process.",
"Email Information"=>"Email Information",
// from vtiger 6.x Reports
'LBL_REPORTS' => 'Reports List',
'LBL_ALL_REPORTS' => 'All Reports',
'LBL_ADD_FOLDER' => 'Add Folder',
'LBL_ADD_NEW_FOLDER' => 'Add New Folder',
'LBL_FOLDER_CAN_NOT_BE_DELETED' => 'This folder can not be deleted',
'LBL_FOLDER_DESCRIPTION' => 'Folder Description',
'LBL_FOLDER_NAME' => 'Folder Name',
'LBL_FOLDER_NOT_EMPTY' => 'Folder is not empty',
'LBL_FOLDERS' => 'Folders',
'LBL_FOLDERS_LIST' => 'Folders List',
'LBL_MOVE_REPORT' => 'Move Reports',
'LBL_WRITE_YOUR_DESCRIPTION_HERE' => 'Enter Description',
'LBL_DUPLICATES_EXIST' => 'Report Name already Exists',
'LBL_CUSTOMIZE' => 'Customize',
'LBL_REPORT_PRINT' => 'Print',
'LBL_REPORT_EXPORT_EXCEL' => 'Export Excel',
'LBL_REPORT_CSV' => 'Export CSV',
'LBL_NO_OF_RECORDS' => 'Total records : ',
'LBL_ADD_WIDGET' => 'Add Widget to Home Page',
'LBL_ADD_WIDGET_ERROR' => 'Error occured during adding Widget to Home Page',
'LBL_ADD_WIDGET_SUCCESS' => 'Widget successfully added to your Home Page',
'LBL_ADD_WIDGET_ERROR_EXIST' => 'Widget already exist on your Home Page',
// Report Types LABELS
'REPORT_TYPE' => 'Report Type',
'LBL_SELECT_REPORT_TYPE' => 'Select Report Type',
'LBL_TABULAR_REPORT' => 'Tabular Report',
'tabular' => 'Tabular Report',
'LBL_SUMMARIES_REPORT' => 'Summaries Report',
'summaries' => 'Summaries Report',
'LBL_SUMMARIES_WITH_DETAILS_REPORT' => 'Summaries Report with Details',
'summaries_w_details' => 'Summaries Report with Details',
'LBL_SUMMARIES_MATRIX_REPORT' => 'Matrix Report',
'summaries_matrix' => 'Matrix Report',
'LBL_PLEASE_SELECT_REPORTTYPE' => 'Please select type of Report you want to create.',
'LBL_SELECT_TYPE_VIEW' => 'Select type view',
'LBL_CUSTOM_REPORT' => 'Custom Report',
'custom_report' => 'Custom Report',
// Create Report Type Info
// Right Create Block Report Type Info
'LBL_REPORTTYPE1_INFO' => 'Tabular report is very simple type of report, with a columns heading row followed by table data information. See example report image below:',
'LBL_STEP4_tabular' => 'Tabular report is very simple type of report, with a columns heading row followed by table data information.',
'LBL_REPORTTYPE2_INFO' => 'Summaries report is intended to use when performing data calculations grouped by selected columns. See example report image below:',
'LBL_STEP4_summaries' => 'Summaries report is intended to use when performing data calculations grouped by selected columns. ',
'LBL_REPORTTYPE3_INFO' => 'Summaries report with Details is intended to use when performing data calculations grouped by one selected column with displayed record details. <br />You can define calculations for all report datas and define limited/unlimited count of displayed record details. See example report image below:',
'LBL_STEP4_summaries_w_details' => 'Summaries report with Details is intended to use when performing data calculations grouped by one selected column with displayed record details. <br />You can define calculations for all report datas and define limited/unlimited count of displayed record details.',
'LBL_REPORTTYPE4_INFO' => 'Matrix report is a summaries report with one group column displayed in columns structure. <br />For example COUNT, SUM, AVG, MIN, MAX columns summaries calculated and displayed by date intervals, status, or other column values. See example report image below:',
'LBL_STEP4_summaries_matrix' => 'Matrix report is a summaries report with one group column displayed in columns structure. <br />For example COUNT, SUM, AVG, MIN, MAX columns summaries calculated and displayed by date intervals, status, or other column values.',
'LBL_REPORTTYPE5_INFO' => '<font color="red"><b>Custom SQL Query is not additionally modified !</b></font><br/>
<font color="red">Custom report have to be programmed by skilled user with programming experiences. <br/>
Do not forget that custom SQL Report display Records based on defined SQL query. Keep in your mind to use user permissions queries and share with permitted users only!</font><br/>
Take care to be really careful with custom report sql definitions.',
'LBL_STEP5_custom_report' => 'Custom report is a report programmed by skilled user with programming experiences. Take care to be really careful with custom report sql definitions.',
//installation
"LBL_INSTALL" => "installation",
"LBL_VALIDATION" => "Validation",
"LBL_FINISH" => "Finish",
"LBL_WELCOME" => "Welcome to the Reports 4 You Installation Wizard",
"LBL_WELCOME_DESC" => "This will install Reports 4 You into your vtiger CRM.",
"LBL_WELCOME_FINISH" => "It is highly recommended to finish the installation without any interruption.",
"LBL_INSERT_KEY" => "Please insert a license key you received in purchase confirmation email.",
"LBL_LICENSE_KEY" => "License key",
"LBL_ACTIVATE_KEY" => "Activate license",
"LBL_VALIDATE" => "Validate",
"LBL_ONLINE_ASSURE" => "Please make sure that your server has an internet access in order to run validation.",
"LBL_ORDER_NOW" => "Order now",
"LBL_INVALID_KEY" => "Invalid license key! Please contact the vendor of Reports 4 You.",
"LBL_INSTALL_SUCCESS" => "Reports 4 You has been installed successfully.",
"LBL_LICENSE" => "License settings",
"LBL_LICENSE_DESC" => "Manage all settings related to your license",
"LBL_REACTIVATE" => "Reactivate license",
"REACTIVATE_SUCCESS" => "You have successfuly reactivated your Reports 4 You.",
"LBL_DEACTIVATE" => "Deactivate license",
"LBL_DEACTIVATE_TITLE" => "Deactivate license",
'LICENSE_SETTINGS' => 'License',
'LICENSE_SETTINGS_INFO' => 'Manage your License Key',
'LBL_COMPANY_LICENSE_INFO' => 'Your Company Information',
'LBL_CHECK_COMPANY' => 'Please check your Company information.',
"LBL_CHANGE_COMPANY_INFORMATION" => "Change Company Information",
"LBL_INACTIVE" => "Reports 4 You is inactive. Please insert a license key.",
"LBL_DEACTIVATE_SUCCESS" => "License key has been deactivated successfully.",
"LBL_REACTIVATE_DESC" => "In case problem with license key.",
"LBL_MISMATCH" => "Welcome to the Reports 4 Yous 4 You reactivate license Wizard",
"LBL_MISMATCH_DESC" => "Your URL installation has been changed. To activate the license please confirm the following form.",
"LBL_MISMATCH_SUCCESS" => "Reports 4 Yous 4 You has been reactivate license successfully.",
"LBL_URL" => "Your vtiger url",
'LBL_LICENSE_CONDITIONS' => 'Note:</br>
This license gives the holder right to install Reports 4 You on ONE productive vtiger CRM installation and ONE develop vtiger CRM installation for unlimited users.',
// ITS4YOU-CR SlOl | 20.8.2015 14:09
"LBL_TOO_MANY_SQL" => "Too many queries defined! Custom Report allows you to define only 1 select query.",
"LBL_WRONG_QUERY_STRINGS_SQL" => 'It is allowed to use only "Select" query as custom sql report!',
// ITS4YOU-CR SlOl | 25.8.2015 13:28
"LBL_PRODUCT_TOTAL" => "Total price",
"LBL_PRODUCTTOTALAFTERDISCOUNT" => "Total after discount",
"LBL_PRODUCT_VAT_SUM" => "TAX",
"LBL_PRODUCT_TOTAL_VAT" => "Total price with TAX",
"LBL_ITEM_CATEGORY" => "Product/Service Category",
"LBL_ITEM_NO" => "Product/Service Number",
// filter options
'None' => 'none',
'EQUALS' => 'equals',
'NOT_EQUALS_TO' => 'not equals to',
'STARTS_WITH' => 'starts with',
'ENDS_WITH' => 'ends with',
'CONTAINS' => 'contains',
'DOES_NOT_CONTAINS' => 'do not contains',
'LESS_THAN' => 'less than',
'GREATER_THAN' => 'greater than',
'LESS_OR_EQUALS' => 'less or equals',
'GREATER_OR_EQUALS' => 'greater or equals',
'BETWEEN' => 'between',
'BEFORE' => 'before',
'AFTER' => 'after',
'IS_NULL' => 'is null',
'IS_NOT_NULL' => 'is not null',
// ITS4YOU-CR SlOl 8. 6. 2016 12:16:17
'EQUALS_FLD' => 'Equals field',
'NOT_EQUALS_TO_FLD' => 'Not equals to field',
'LESS_THAN_FLD' => 'Less than field',
'GREATER_THAN_FLD' => 'Greater than field',
'LESS_OR_EQUALS_FLD' => 'Less or equals than field',
'GREATER_OR_EQUALS_FLD' => 'Greater or equals than field',
"Ascending" => "Ascending",
"Descending" => "Descending",
// ITS4YOU-CR SlOl 24. 11. 2015 14:51:15
'Last N days' => 'Last N days',
'Next N days' => 'Next N days',
'Less than N days' => 'Less than N days',
'More than N days' => 'More than N days',
'Days ago' => 'Days ago',
'Days ahead' => 'Days ahead',
// ITS4YOU-END
// ITS4YOU-CR SlOl 12. 1. 2016 8:34:18
'LBL_KEY_METRICS' => 'Key Metrics',
'LBL_KEY_METRICS_WIDGETS' => 'Key Metrics List',
'LBL_WIDGET_NAME' => 'Widget Name',
'LBL_ADD_NEW_KEY_METRICS' => 'Widget Name',
'LBL_ADD_NEW_KEY_METRICS_ROW' => 'Add Key Metrics Row',
'LBL_KEY_METRICS_NAME' => 'Key Metrics Name',
'LBL_KEY_METRICS_TYPE' => 'Type',
'LBL_KEY_METRICS_COLUMN' => 'Column Name',
'LBL_KEY_METRICS_SEQUENCE' => 'Sequence',
'LBL_CREATE_NEW_KEY_METRICS' => 'Creating New Key Metrics Row',
'LBL_EDIT_NEW_KEY_METRICS' => 'Edit Key Metrics Row',
'LBL_KEY_METRICS_INFORMATION' => 'Key Metrics Information',
'LBL_NO_KEY_METRICS' => 'No Key Metrics Created',
'LBL_KeyMetrics_SAVED' => 'Key Metrics successfully saved',
'LBL_KeyMetricsRow_SAVED' => 'Key Metrics Row successfully saved',
'LBL_KeyMetricsRow_DELETED' => 'Key Metrics Row successfully deleted',
// ITS4YOU-CR SlOl 13. 1. 2016 9:24:36
'label' => 'Label',
'calculation_type' => 'Calculation Type',
'column_str' => 'Column',
'LBL_ADD_KEYMETRICSROW_ERROR' => 'Error occured during adding Key Metrics Row',
'LBL_ADD_KEYMETRICSROW_SUCCESS' => 'Key Metrics Row successfully created',
'LBL_KeyMetricsRow_SeqDone' => 'Sequence saved',
'for_report' => 'for report',
'LBL_WIDGET_DESCRIPTION' => 'Description',
'LBL_WIDGET_SMCREATORID' => 'Created by',
// ITS4YOU-CR SlOl 18. 3. 2016 12:18:00
'LBL_REPORT_DASHBOARDS'=>'Dashboard',
'LBL_STEP13_INFO'=>'In this Step you can define dashboard parameters:<br />
Primary search column.<br />',
'PrimarySearchBy'=>'Primary search column',
'AllowInModules'=>'Allow in Modules',
// ITS4YOU-CR SlOl 4. 4. 2016 9:45:26
'LBL_GENERATE_PLACEHOLDER'=>'Autogenerated if empty...',
'LBL_GENERATE_OTHER'=>'Other Emails (separate by semicolon ; )...',
'LBL_GENERATE_SUBJECT'=>'Subject',
'LBL_GENERATE_TEXT'=>'Text',
'LBL_GENERATE_FOR'=>'Generate For',
'LBL_SCHEDULE_ALL_RECORDS'=>'Generate without limit',
'LBL_USERS_AVAILABEL_INFO'=>"Selected users will receive copy of Report based on 'Report owner' user privileges defined in sharing tab",
'LBL_GENERATE_FOR_INFO'=>'Selected users will receive separately Report based on their own user privileges',
// ITS4YOU-CR SlOl 10. 5. 2016 8:29:11
'LBL_FOR_DETAILS_CLICK'=>'For details click here',
// ITS4YOU-CR SlOl 16. 5. 2016 8:42:03
'LBL_CUSTOM_CALCULATION'=>'Custom Calculation',
'LBL_CUSTOM_CALCULATION_NAME'=>'Calculation Label',
'LBL_CUSTOM_CALCULATION_EXPRESSION'=>'Calculation Expression',
'LBL_CANCEL' => 'Cancel',
'LBL_NEW_CUSTOM_CALCULATION' => 'Add Calculation',
'LBL_CC_INFORMATION' => 'Calculation Information',
'LBL_STEP61_INFO' => "Here you can define expression of custom calculations based on fields available across the Report modules. <br />
You can define basic mathematical operations like: <br />
+ , - , * , /<br />
or some other expressions:<br />
if ... then ... else ... end (==,<=,>=,<,>)<br />
concat( ... , ... )<br />
Examples:<br />
if amount>50 then amount-10 else amount-20 end<br />
if account_type == 'Analyst' then account_type else 'Other' end<br />
concat(potentialname ,potential_no)<br />",
'LBL_CALCULATION_LIMITED_TO' => 'Calculation limited to',
// ITS4YOU-CR SlOl 27. 5. 2016 9:22:53
'LBL_SET_VALUE' => 'Set Value',
// ITS4YOU-CR SlOl 05.04.2018 8:34:23
'LBL_QUICK_FILTER' => 'Quick Filter',
'SQL_COLUMN_NOT_PREPARED' => 'SQL for column was not prepared',
'LBL_IS_NOT' => 'is not',
'LBL_NO_DATA_FOR_COLUMN' => 'No data found for this column',
'NULL' => 'Null',
'LBL_SEARCH_FOR_FOLDERS' => 'Search for folders',
'LBL_REPORTS_DELETED_SUCCESSFULLY' => 'Reports Deleted Successfully',
'LBL_SHARE_WITH' => 'Share With',
'LBL_SAME_SOURCE_AND_TARGET_FOLDER'=>'Target Folder Is Same As Source Folder.',
'LBL_REPORTS_MOVED_SUCCESSFULLY'=>'Reports Moved Successfully.',
'LBL_DENIED_REPORTS' => 'Denied Reports',
'LBL_EXPRESSION_ERROR' => 'VTExpressionParser failed',
'LBL_MODIFY_CONDITION' => 'Modify Conditions',
'LBL_HEADER_INFO_BLOCK' => 'Report Information Block',
// ITS4YOU-CR SlOl 24.04.2018 9:23:23
'LBL_DATA_INFO_BLOCK'=>'Data',
'LBL_CHART_CollapseDataBlock'=>'Collapse data area',
'LBL_CHART_Position'=>'Chart position',
'LBL_TOP'=>'Top',
'LBL_BOTTOM'=>'Bottom',
'LBL_EDIT_WIDGET'=>'Edit widget',
'Edit'=>'Edit',
'Duplicate'=>'Duplicate',
'Detail'=>'Detail',
'KeyMetricsList'=>'Key metrics list',
'KeyMetricsRows'=>'Key metric rows',
'EditKeyMetricsRow'=>'Edit key metric row',
'LBL_DUPLICATES_WIDGET_EXIST'=>'Name already in use. Try again.',
'LBL_ADD_RECORD'=>'Add Report',
'UsedInKeyMetricsRows'=>'This Report is used in Key Metrics',
'LBL_USER_API_KEY_SETTINGS' => 'API Key Settings',
'LBL_REPORT_MAPS'=>'Maps',
'LBL_REPORT_MAPS_DISPLAY'=>'Display Map',
'LBL_REPORT_MAPS_PIN_TITLE' => 'Pin title',
'LBL_REPORT_MAPS_PIN_DESCRIPTION' => 'Pin description',
'LBL_REPORT_MAPS_STREET'=>'Street',
'LBL_REPORT_MAPS_CITY'=>'City',
'LBL_REPORT_MAPS_STATE'=>'State',
'LBL_REPORT_MAPS_ZIP'=>'Zip',
'LBL_REPORT_MAPS_COUNTRY'=>'Country',
'LBL_REPORT_MAPS_ZOOM' => 'Zoom',
'API_KEY_BING' => 'Bing API Key',
'LBL_DEFINE_API_KEY_DESC_BING' => 'Place your API key or create new one by following: <a href="https://docs.microsoft.com/en-us/bingmaps/getting-started/bing-maps-dev-center-help/getting-a-bing-maps-key" target="_blank">Getting a Bing Maps Key <i class="fa fa-external-link"></i></a>',
'LBL_USER_DEFINED' => 'User defined',
'LBL_USER_DEFINED_KEY_PLACEHOLDER' => 'paste User defined key',
'LBL_DEFAULT_KEY_PLACEHOLDER' => 'paste Default key',
'LBL_GENERATE_MAP' => 'Display Map',
'LBL_EMPTY_API_KEY' => 'API Key can not be empty, <a href="index.php?module=ITS4YouReports&view=UserMapsKeySettings&mode=Edit">click here</a> to set it.',
'LBL_DEFAULT' => 'Default',
'LBL_DISPLAYING_RESULTS' => 'Displaying Results',
'REPORT_DASHBOARD_CHART'=> 'Chart',
'REPORT_DASHBOARD_TABLE'=> 'Table',
'LBL_EXPORT_REPORTED_RECORDS' => 'Report data',
'LBL_BACKGROUND_EXPORT' => 'In the background',
'LBL_SCHEDULE_SKIP_EMPTY' => 'Do not send empty files',
// ITS4YOU-END
);
$jsLanguageStrings = array(
'MISSING_REPORT_NAME' => 'Missing Report Name',
'RECIPIENTS_CANNOT_BE_EMPTY' => 'Selected Recipients cannot be empty',
'COLUMNS_CANNOT_BE_EMPTY' => 'Selected Columns cannot be empty',
'CANNOT_BE_NONE' => ' cannot be none',
'CANNOT_BE_EMPTY' => ' cannot be empty',
'VAL_CANNOT_BE_EMPTY' => ' value cannot be empty',
'Graph1'=>'Chart 1',
'Graph2'=>'Chart 2',
'Graph3'=>'Chart 3',
'LBL_CHART_DataSeries'=>'Data Series',
// filter options
'EQUALS' => 'equals',
'NOT_EQUALS_TO' => 'not equal to',
'STARTS_WITH' => 'starts with',
'ENDS_WITH' => 'ends with',
'CONTAINS' => 'contains',
'DOES_NOT_CONTAINS' => 'does not contains',
'LESS_THAN' => 'less than',
'GREATER_THAN' => 'greater than',
'LESS_OR_EQUALS' => 'less or equal',
'GREATER_OR_EQUALS' => 'greater or equal',
'BETWEEN' => 'between',
'BEFORE' => 'before',
'AFTER' => 'after',
'IS_NULL' => 'is empty',
'IS_NOT_NULL' => 'is not empty',
"ARE_YOU_SURE"=>"Are you sure?",
"LBL_OTHER_VALS" => "Other values",
"LBL_DEACTIVATE_QUESTION" => "Do you really want to deactivate your license key?",
"LBL_DUPLICATE_TEMPLATE_CREATION_CONFIRMATION" => "Template name already exists.Do you want to create a duplicate template?",
// ITS4YOU-CR SlOl 13. 1. 2016 9:24:36
'label' => 'Label',
'calculation_type' => 'Calculation Type',
'column_str' => 'Column',
'reportname' => 'Report Name',
// ITS4YOU SlOl 11. 3. 2016 7:08:44
'Loading' => 'Loading',
// ITS4YOU-CR SlOl 17. 5. 2016 14:11:00
'CalcNameEmptyErr' => 'Calculation Name cannot be empty',
'CalcExpEmptyErr' => 'Calculation Expression cannot be empty',
// ITS4YOU-CR SlOl 30. 1. 2017 11:17:35
'JS_SCHEDULER_VALIDATION_TITLE' => 'Scheduler validation',
'JS_AND' => 'and',
'JS_SCHEDULEDTIME_CANNOT_BE_EMPTY' => 'Frequency',
'JS_SCHEDULEDFORMAT_CANNOT_BE_EMPTY' => 'Report Format',
'JS_RECIPIENTS_CANNOT_BE_EMPTY' => 'Selected Recipients',
'LBL_UNINSTALL_CONFIRM' => 'Are you sure to completely remove Reports 4 You from your vTiger?',
'JS_STEPS_VALIDATION_TITLE' => 'Steps validation',
'JS_LBL_GroupBy'=>'Group',
'JS_CAN_NOT_BE_EMPTY' => 'can not be empty',
'JS_EMPTY_API_KEY' => 'API Key can not be empty!',
'JS_MSG_SAVED' => 'API Key saved successfully',
'JS_SAVED' => 'Data saved successfully',
// ITS4YOU-END
);