$sugar_smarty->assign('object_id', ''); } if (isset($_REQUEST['date_start'])) { $sugar_smarty->assign('DATE_START', $_REQUEST['date_start']); } else { $sugar_smarty->assign('DATE_START', ''); } if (isset($_REQUEST['date_finish'])) { $sugar_smarty->assign('DATE_FINISH', $_REQUEST['date_finish']); } else { $sugar_smarty->assign('DATE_FINISH', ''); } $sugar_smarty->assign("CALENDAR_DATEFORMAT", $timedate->get_cal_date_format()); $sugar_smarty->assign("DATE_FORMAT", $current_user->getPreference('datef')); $sugar_smarty->assign("CURRENT_USER", $current_user->id); $sugar_smarty->assign("quicksearch_js", js_setup()); } $activities = array(); if (isset($_REQUEST['run_report']) && $_REQUEST['run_report'] == '1' || isset($_REQUEST['export_report']) && $_REQUEST['export_report'] == '1') { $focus = new SugarBean(); $query = ""; if (ACLController::checkAccess('Calls', 'list', true)) { $query = "select 'Calls' as "; if ($focus->db->dbType == 'mysql') { $query .= "'call' "; } else { $query .= "call "; } $query .= ",calls.description,calls.id, calls.name,calls.date_start,calls.status from calls "; if (isset($_REQUEST['parent_type']) && $_REQUEST['parent_type'] == 'Users') { $query .= " INNER JOIN calls_users on calls_users.call_id=calls.id and calls_users.deleted=0 where calls_users.user_id=" . "'" . $_REQUEST['parent_id'] . "'";
function template_reports_tables(&$smarty, &$args) { global $report_modules; global $mod_strings; global $app_list_strings; global $current_user; $reporter = $args['reporter']; $classname = "dataLabel"; $smarty->assign('classname', $classname); global $ACLAllowedModules; uksort($ACLAllowedModules, "juliansort"); $smarty->assign('ACLAllowedModulesjuliansort', $ACLAllowedModules); $smarty->assign('app_list_strings', $app_list_strings); $save_report_as = $mod_strings['LBL_UNTITLED']; if (!empty($reporter->name)) { $save_report_as = $reporter->name; $smarty->assign('save_report_as_template_reports_tables', $save_report_as); } // fn $isAdmin = false; if ($current_user->is_admin) { $isAdmin = true; } // if $smarty->assign('isAdmin', $isAdmin); if (!empty($_REQUEST['show_query']) && $isAdmin) { $smarty->assign('show_query', true); } // if if (!empty($reporter->saved_report)) { $focus =& $reporter->saved_report; } else { $focus = BeanFactory::getBean('Reports'); $focus->assigned_user_name = empty($_REQUEST['assigned_user_name']) ? '' : $_REQUEST['assigned_user_name']; $focus->assigned_user_id = empty($_REQUEST['assigned_user_id']) ? '' : $_REQUEST['assigned_user_id']; $focus->team_name = empty($_REQUEST['team_name']) ? '' : $_REQUEST['team_name']; $focus->team_id = empty($_REQUEST['team_id']) ? '' : $_REQUEST['team_id']; } if (empty($focus->assigned_user_id) && empty($focus->id)) { $focus->assigned_user_id = $current_user->id; } if (empty($focus->assigned_user_name) && empty($focus->id)) { $focus->assigned_user_name = $current_user->user_name; } $assigned_user_html_def = array('parent_id' => 'assigned_user_id', 'parent_id_value' => $focus->assigned_user_id, 'parent_name' => 'assigned_user_name', 'parent_name_value' => $focus->assigned_user_name, 'real_parent_name' => 'user_name', 'module' => 'Users'); $assigned_user_html = get_select_related_html($assigned_user_html_def); $smarty->assign('assigned_user_html', $assigned_user_html); if (empty($focus->id) && empty($_REQUEST['team_name'])) { $focus->team_name = $current_user->default_team_name; $focus->team_id = $current_user->default_team; } // if $team_html_def = array('parent_id' => 'team_id', 'parent_id_value' => $focus->team_id, 'parent_name' => 'team_name', 'parent_name_value' => $focus->team_name, 'real_parent_name' => 'name', 'module' => 'Teams'); $team_html = get_select_related_html($team_html_def); $smarty->assign('team_html', $team_html); if (empty($reporter->report_def['report_type'])) { $reporter->report_def['report_type'] = 'tabular'; } $smarty->assign('reporter_report_def_report_type', $reporter->report_def['report_type']); js_setup($smarty); }
} if (isset($_REQUEST['save_report_as'])) { $sugar_smarty->assign("save_report_as", $_REQUEST['save_report_as']); } else { $sugar_smarty->assign("save_report_as", ""); } if (isset($_REQUEST['id'])) { $sugar_smarty->assign("id", $_REQUEST['id']); } if (isset($_REQUEST['show_query'])) { $sugar_smarty->assign("show_query", $_REQUEST['show_query']); } if (isset($_REQUEST['do_round'])) { $sugar_smarty->assign("do_round", $_REQUEST['do_round']); } js_setup($sugar_smarty); if (isset($_REQUEST['run_query']) && $_REQUEST['run_query'] == 1) { $args = array(); $report_def = array(); if (!empty($_REQUEST['report_def'])) { $report_def = html_entity_decode($_REQUEST['report_def']); $panels_def = html_entity_decode($_REQUEST['panels_def']); $filters_def = html_entity_decode($_REQUEST['filters_defs']); $args['reporter'] = new Report($report_def, $filters_def, $panels_def); $args['reporter']->removeInvalidFilters(); $sugar_smarty->assign('report_def_str', $args['reporter']->report_def_str); } if (isset($_REQUEST['id'])) { $sugar_smarty->assign('record', $_REQUEST['id']); } $assigned_user_html_def = array('parent_id' => 'assigned_user_id', 'parent_id_value' => $_REQUEST['assigned_user_id'], 'parent_name' => 'assigned_user_name', 'parent_name_value' => $_REQUEST['assigned_user_name'], 'real_parent_name' => 'user_name', 'module' => 'Users');