$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');
