public static function getFieldsPanelHtml($database, $selectedModule, $isDynamicTable, $auditedReport, $autoRefresh, $disabledGeneralData)
{
global $mod_strings;
$moduleFields = self::getFieldsSelectHtml($database, $selectedModule, null, $auditedReport);
$moduleRelatedFields = self::getRelatedFieldsSelectHtml($database, $selectedModule, null, null, '', true, null, $auditedReport);
//***********************//
//***AlineaSol Premium***//
//***********************//
$breadcrumbTrailLink = asol_ReportsUtils::managePremiumFeature("multipleLinks", "reportFunctions.php", "getBreadcrumbTrailLink", null);
$breadCrumbLinkBtn = $breadcrumbTrailLink !== false ? $breadcrumbTrailLink : '';
//***********************//
//***AlineaSol Premium***//
//***********************//
return '<table>
<tr>
<td>
<h4>' . $mod_strings['LBL_REPORT_MODULE_HEADER_LABEL'] . ' <span id="reportModulesTablesSpan">' . asol_ReportsManagementFunctions::getReportModuleTablesHtml($database, false, $selectedModule, $isDynamicTable, $auditedReport, $autoRefresh, true, $disabledGeneralData) . '</span></h4>
</td>
</tr>
<tr>
<td>
<h4>' . $mod_strings['LBL_REPORT_FIELDS'] . '</h4>
</td>
</tr>
<tr>
<td>
<div id="reportTableFieldsDiv">
' . $moduleFields['html'] . '
</div>
</td>
</tr>
<tr>
<td>
<input disabled type="button" title="' . $mod_strings['LBL_REPORT_ADD_FIELDS'] . '" class="button" id="addFieldsButton" name="addFieldsButton" value="' . $mod_strings['LBL_REPORT_ADD_FIELDS'] . '" onClick="' . $moduleFields['javascript'] . '">
<input type="button" title="' . $mod_strings['LBL_REPORT_SHOW_RELATED'] . '" class="button" style="visibility: hidden" id="show_related_button" name="show_related_button" value="' . $mod_strings['LBL_REPORT_SHOW_RELATED'] . '" onClick="getRelatedFields(false, null, null, null)">
</td>
</tr>
<tr>
<td>
<h4>
' . $mod_strings['LBL_REPORT_RELATED_FIELDS'] . $breadCrumbLinkBtn . '
</h4>
</td>
</tr>
<tr>
<td>
<div id="reportTableRelatedFieldsDiv">
' . $moduleRelatedFields['html'] . '
</div>
</td>
</tr>
<tr>
<td>
<input type="button" title="' . $mod_strings['LBL_REPORT_ADD_RELATED_FIELDS'] . '" class="button" id="addRelatedFieldsButton" name="addRelatedFieldsButton" value="' . $mod_strings['LBL_REPORT_ADD_RELATED_FIELDS'] . '" onClick="' . $moduleRelatedFields['javascript'] . '">
<input type="button" title="' . $mod_strings['LBL_REPORT_SHOW_SECOND_RELATED'] . '" class="button" style="visibility: hidden" id="show_second_related_button" name="show_second_related_button" value="' . $mod_strings['LBL_REPORT_SHOW_SECOND_RELATED'] . '" onClick="getRelatedFields(true, null, null, null)">
</td>
</tr>
</table>';
}
require_once "modules/asol_Reports/include_basic/manageReportsFunctions.php";
$htmlTarget = $_REQUEST['htmlTarget'];
$returnedHtml = "";
global $db, $mod_strings, $sugar_config, $current_user, $current_language, $timedate;
$mod_strings = return_module_language($current_language, "asol_Reports");
$breadCrumbNavigation = isset($sugar_config['asolReportsBreadCrumbNavigation']) ? $sugar_config['asolReportsBreadCrumbNavigation'] : false;
if ($htmlTarget == 'reportModuleTables') {
$selectedDb = $_REQUEST['selectedDb'];
$isSubQuery = $_REQUEST['isSubQuery'] == 'true' ? true : false;
$selectedTable = isset($_REQUEST['selectedTable']) ? $_REQUEST['selectedTable'] : null;
$isEditViewMode = isset($_REQUEST['isEditViewMode']) ? $_REQUEST['isEditViewMode'] == 'true' ? true : false : true;
$noRestrictions = isset($_REQUEST['noRestrictions']) ? $_REQUEST['noRestrictions'] == 'true' ? true : false : false;
$isDisabled = isset($_REQUEST['isDisabled']) ? $_REQUEST['isDisabled'] == 'true' ? true : false : false;
$onChangeFunction = isset($_REQUEST['onChangeFunction']) ? $_REQUEST['onChangeFunction'] : null;
$returnedHtml = asol_ReportsManagementFunctions::getReportModuleTablesHtml($selectedDb, $isSubQuery, $selectedTable, false, 0, 0, $isEditViewMode, $isDisabled, $noRestrictions, $onChangeFunction);
} else {
if ($htmlTarget == 'reportTableFields') {
$selectedDb = $_REQUEST['selectedDb'];
$selectedModule = $_REQUEST['selectedModule'];
$selectedField = isset($_REQUEST['selectedField']) ? $_REQUEST['selectedField'] : null;
$isEditViewMode = isset($_REQUEST['isEditViewMode']) ? $_REQUEST['isEditViewMode'] == 'true' ? true : false : true;
$auditedReport = isset($_REQUEST['isAudited']) ? $_REQUEST['isAudited'] : 0;
$isDisabled = isset($_REQUEST['isDisabled']) ? $_REQUEST['isDisabled'] == 'true' ? true : false : false;
$treeMode = isset($_REQUEST['treeMode']) && $_REQUEST['treeMode'] == 'true' ? !$breadCrumbNavigation && true : false;
$subQueryMode = isset($_REQUEST['subQueryMode']) ? $_REQUEST['subQueryMode'] == 'true' ? true : false : false;
$moduleFields = asol_ReportsManagementFunctions::getFieldsSelectHtml($selectedDb, $selectedModule, $selectedField, $auditedReport, $isEditViewMode, $isDisabled, $treeMode, $subQueryMode);
$returnedHtml = $moduleFields['html'];
if ($isEditViewMode) {
$returnedHtml .= '<script>$("#' . ($subQueryMode ? 'addSubFieldsButton' : 'addFieldsButton') . '").attr("onClick", "' . $moduleFields['javascript'] . '");</script>';
if ($selectedDb === '-1') {
