'; echo ''; echo '
'.$Language->getText('project_admin_utils','menu_config').' '.$Language->getText('project_admin_utils','edit_public_info').' | '.$Language->getText('project_admin_editservice','s_conf').' | '.$Language->getText('project_admin_utils','references').''; $em = EventManager::instance(); $em->processEvent('admin_toolbar_configuration', array('group_id' => $group_id)); echo ''; if (isset($params['help'])) { echo help_button($params['help'],false,$Language->getText('global','help')); } echo '
'.$Language->getText('project_admin_utils','menu_permissions').' '.$Language->getText('project_admin_utils','user_perms').' | '.$Language->getText('project_admin_utils','ug_admin').' | '.$Language->getText('project_admin_ugroup','permission_request').''; echo '
'.$Language->getText('project_admin_utils','menu_data').' '.$Language->getText('project_admin_utils','project_data_export').' | '.$Language->getText('project_admin_utils','tracker_import').' | '.$Language->getText('project_admin_history','proj_history').' | '.$Language->getText('project_admin_utils','access_logs').''; //Call hook that can be displayed in this area $em->processEvent('admin_toolbar_data', array('group_id' => $group_id)); //Tracker Import echo '
'; echo '

'; } /* Standard footer to be used on all /project/admin/* pages */ function project_admin_footer($params) { site_project_footer($params); } /* The following functions are for group audit trail When changes like adduser/rmuser/change status are made to a group, a row is added to audit trail using group_add_history() */ /** * @deprecated * * handle the insertion of history for corresponding parameters * $args is an array containing a list of parameters to use when * the message is to be displayed by the history.php script * The array is stored as a string at the end of the field_name * with the following format: * field_name %% [arg1, arg2...] * * @param String $fieldName Event category * @param String $oldValue Event value * @param Integer $groupId Project ID * @param Array $args list of parameters used for message display * * @return DataAccessResult */ function group_add_history ($field_name,$old_value,$group_id, $args=false) { $dao = new ProjectHistoryDao(CodendiDataAccess::instance()); return $dao->groupAddHistory($field_name,$old_value,$group_id, $args); } /** * Builds the group history filter * * @param String $event Events category used to filter results * @param String $subEventsBox Event used to filter results * @param String $value Value used to filter results * @param Integer $startDate Start date used to filter results * @param Integer $endDate End date used to filter results * @param String $by User name used to filter results * * @return String */ function build_grouphistory_filter ($event = null, $subEventsBox = null, $value = null, $startDate = null, $endDate = null, $by = null) { $filter = ''; if (!empty($by)) { $uh = UserHelper::instance(); $filter .= $uh->getUserFilter($by); } if(!empty($startDate)) { list($timestamp,) = util_date_to_unixtime($startDate); $filter .= " AND group_history.date > '".$timestamp."'"; } if(!empty($endDate)) { list($timestamp,) = util_date_to_unixtime($endDate); // Add 23:59:59 to timestamp $timestamp = $timestamp + 86399; $filter .= " AND group_history.date < '".$timestamp."'"; } if(!empty($value)) { //all_users need specific treatement if(stristr($value, $GLOBALS["Language"]->getText('project_ugroup', 'ugroup_anonymous_users_name_key'))) { $value = 'ugroup_anonymous_users_name_key'; } $filter .= " AND group_history.old_value LIKE '%".$value."%'"; } if(!empty($event) && strcmp($event, 'any')) { $filter .= " AND ( 0 "; if(!empty($subEventsBox)) { foreach ($subEventsBox as $key => $value) { $filter .= " OR group_history.field_name LIKE '".$key."%'"; } } else { $subEventsList = get_history_entries(); foreach ($subEventsList[$event] as $key => $value) { $filter .= " OR group_history.field_name LIKE '".$value."%'"; } } $filter .= " ) "; } return $filter; } /** * Returns the events used in project history grouped by category * * @return Array */ function get_history_entries() { $subEvents = array('event_permission' => array('perm_reset_for_field', 'perm_granted_for_field', 'perm_reset_for_tracker', 'perm_granted_for_tracker', 'perm_reset_for_package', 'perm_granted_for_package', 'perm_reset_for_release', 'perm_granted_for_release', 'perm_reset_for_wiki', 'perm_granted_for_wiki', 'perm_reset_for_wikipage', 'perm_granted_for_wikipage', 'perm_reset_for_wikiattachment', 'perm_granted_for_wikiattachment', 'perm_reset_for_object', 'perm_granted_for_object', 'perm_reset_for_docgroup', 'perm_granted_for_docgroup'), 'event_project' => array('rename_done', 'rename_with_error', 'add_custom_quota', 'restore_default_quota', 'approved', 'deleted', 'rename_request', 'is_public', 'group_type', 'http_domain', 'unix_box', 'changed_public_info', 'changed_trove', 'membership_request_updated', 'import', 'mass_change', 'status', 'frs_self_add_monitor_package', 'frs_add_monitor_package', 'frs_stop_monitor_package'), 'event_ug' => array('upd_ug', 'del_ug', 'changed_member_perm', 'ugroup_add_binding', 'ugroup_remove_binding'), 'event_user' => array('changed_personal_email_notif', 'added_user', 'removed_user'), 'event_others' => array('changed_bts_form_message', 'changed_bts_allow_anon', 'changed_patch_mgr_settings', 'changed_task_mgr_other_settings', 'changed_sr_settings'), 'choose' => array('choose_event')); //Plugins related events should be filled using the hook $params = array('subEvents' => &$subEvents); $em = EventManager::instance(); $em->processEvent('fill_project_history_sub_events', $params); return $subEvents; } /** * Convert a php array to JS for project history subevents * It keeps the initial array as keys for the JS array * Values are retrieved from i18n file * * @param Array $array Array containing the items * @param Boolean $subevents Convert events array if false, convert subevents otherwise * * @return String */ function convert_project_history_events($array, $subevents) { $hp = Codendi_HTMLPurifier::instance(); $output = '{ }'; if (is_array($array)) { if (count($array)) { $output = '{'; reset($array); $comma = ''; do { if ($subevents) { if(list($key, $value) = each($array)) { if (is_string($value) && !empty($value)) { $value = $hp->purify($value, CODENDI_PURIFIER_JS_QUOTE); $translated_value = $hp->purify($GLOBALS['Language']->getText('project_admin_utils', $value), CODENDI_PURIFIER_JS_QUOTE); $output .= $comma . "'$value': '$translated_value'"; $comma = ', '; } } } else { if(list($key, $value) = each($array)) { if (is_string($key)) { $key = $hp->purify($key, CODENDI_PURIFIER_JS_QUOTE); $value = convert_project_history_events($value, true); $output .= $comma . "'$key': $value"; $comma = ', '; } } } } while($value); $output .= '}'; } } return $output; } /** * Display the retrieved reult set * * @param Integer $group_id Id of the project * @param Array $res Contains the retrieved results * @param Boolean $export Switch CSV export mode or HTML display * @param unknown_type $i Line number indicator * * @return void */ function displayProjectHistoryResults($group_id, $res, $export = false, &$i = 1) { global $Language; $hp = Codendi_HTMLPurifier::instance(); while ($row = $res['history']->getRow()) { $field = $row['field_name']; // see if there are any arguments after the message key // format is "msg_key ## arg1||arg2||... // If msg_key cannot be found in the localized message // catalog then display the msg has is because this is very // likely a legacy message (pre-localization version) if (strpos($field," %% ") !== false) { list($msg_key, $args) = explode(" %% ",$field); if ($args) { $arr_args = explode('||',$args); } } else { $msg_key=$field; $arr_args=""; } $msg = $Language->getText('project_admin_utils', $msg_key, $arr_args); if (!(strpos($msg,"*** Unkown msg") === false)) { $msg = $field; } if (!$export) { echo ''. $hp->purify($msg, CODENDI_PURIFIER_BASIC, $group_id).''; } $val = $row['old_value']; //Translate dynamic ugroup name for permission entries if (strstr($msg_key, "perm_granted_for_") || strstr($msg_key, "perm_reset_for_") || strstr($msg_key, "membership_request_updated")) { $ugroupList = explode(",", $val); $val =''; foreach ($ugroupList as $ugroup) { if ($val) { $val.=', '; } $val .= util_translate_name_ugroup($ugroup); } } else if ($msg_key == "group_type") { $template =& TemplateSingleton::instance(); $val = $template->getLabel($val); } if ($export) { $documents_body = array ('event' => $hp->purify($msg, CODENDI_PURIFIER_BASIC, $group_id), 'val' => $hp->purify($val), 'date' => format_date($GLOBALS['Language']->getText('system', 'datefmt'),$row['date']), 'by' => UserHelper::instance()->getDisplayNameFromUserName($row['user_name'])); echo build_csv_record(array('event', 'val', 'date', 'by'), $documents_body)."\n"; } else { echo $hp->purify($val); $user = UserManager::instance()->getUserByUserName($row['user_name']); echo ''.format_date($GLOBALS['Language']->getText('system', 'datefmt'),$row['date']). ''.UserHelper::instance()->getLinkOnUser($user).''; } } } /** * Nicely html-formatted output of this group's audit trail * * @param Integer $group_id Id of the project * @param Integer $offset Offset used for pagination * @param Integer $limit Number of events by page * @param String $event Events category used to filter results * @param String $subEventsBox Event used to filter results * @param String $value Value used to filter results * @param Integer $startDate Start date used to filter results * @param Integer $endDate End date used to filter results * @param String $by User name used to filter results * * @return void */ function show_grouphistory ($group_id, $offset, $limit, $event = null, $subEventsBox = null, $value = null, $startDate = null, $endDate = null, $by = null) { /* show the group_history rows that are relevant to this group_id */ global $Language; $dao = new ProjectHistoryDao(CodendiDataAccess::instance()); $history_filter = build_grouphistory_filter($event, $subEventsBox, $value, $startDate, $endDate, $by); $res = $dao->groupGetHistory($offset, $limit, $group_id, $history_filter); if (isset($subEventsBox)) { $subEventsString = implode(",", array_keys($subEventsBox)); $forwardSubEvents = '&event='.$event.'&subEventsBox='.$subEventsString; } else { $forwardSubEvents = '&event='.$event; } echo '

'.$Language->getText('project_admin_utils','g_change_history').'

'; echo '
'; echo '
'; echo''.$Language->getText('project_admin_utils','history_search_title').''; echo ''; echo ''; echo ''; echo ''; echo '
'; echo'

'; if ($res['numrows'] > 0) { $title_arr=array(); $title_arr[]=$Language->getText('project_admin_utils','event'); $title_arr[]=$Language->getText('project_admin_utils','val'); $title_arr[]=$Language->getText('project_admin_utils','date'); $title_arr[]=$Language->getText('global','by'); echo html_build_list_table_top ($title_arr); $i=1; displayProjectHistoryResults($group_id, $res, false, $i); echo ''; echo '

'; if ($offset > 0) { echo '[ '.$Language->getText('project_admin_utils', 'previous').' ]'; echo ' '; } if (($offset + $limit) < $res['numrows']) { echo ' '; echo '[ '.$Language->getText('project_admin_utils', 'next').' ]'; } echo '
'; echo '
'; echo ($offset+$i-3).'/'.$res['numrows']; echo '
'; echo '

'; } else { echo '

'.$Language->getText('project_admin_utils','no_g_change').'

'; } $translatedEvents = convert_project_history_events(get_history_entries(), false); if(isset($subEventsString)) { $selectedSubEvents = explode(",", $subEventsString); foreach ($selectedSubEvents as $element) { $subEventsBox[] = $element; } } $translatedSelectedEvents = convert_project_history_events($subEventsBox, true); $js = "options = new Array(); options['defaultValueActsAsHint'] = false; new UserAutoCompleter('by', '".util_get_dir_image_theme()."', true, options); new ProjectHistory(".$translatedEvents.", ".$translatedSelectedEvents.");"; $GLOBALS['HTML']->includeFooterJavascriptFile('/scripts/codendi/ProjectHistory.js'); $GLOBALS['Response']->includeFooterJavascriptSnippet($js); } /** * Export project history to a csv file * * @param Integer $group_id Id of the project * @param String $event Events category used to filter results * @param String $subEventsBox Event used to filter results * @param String $value Value used to filter results * @param Integer $startDate Start date used to filter results * @param Integer $endDate End date used to filter results * @param String $by User name used to filter results * * @return void */ function export_grouphistory ($group_id, $event = null, $subEventsBox = null, $value = null, $startDate = null, $endDate = null, $by = null) { global $Language; header ('Content-Type: text/csv'); header ('Content-Disposition: filename=project_history.csv'); $eol = "\n"; $col_list = array('event', 'val', 'date', 'by'); $documents_title = array ('event' => $Language->getText('project_admin_utils','event'), 'val' => $Language->getText('project_admin_utils','val'), 'date' => $Language->getText('project_admin_utils','date'), 'by' => $Language->getText('global','by')); echo build_csv_header($col_list, $documents_title).$eol; $dao = new ProjectHistoryDao(CodendiDataAccess::instance()); $history_filter = build_grouphistory_filter($event, $subEventsBox, $value, $startDate, $endDate, $by); $res = $dao->groupGetHistory(0, 0, $group_id, $history_filter); if ($res['numrows'] > 0) { displayProjectHistoryResults($group_id, $res, true); } echo build_csv_header($col_list, array()).$eol; } function project_admin_display_bullet_user($user_id, $action, $url = null) { if ($action == 'add') { $icon = '/ic/add.png'; } else { $icon = '/ic/cross.png'; } if (!$url) { $url = $_SERVER['REQUEST_URI'] .'&user['. $user_id .']='. $action; } echo ''; echo ''. $action .''; echo ''; } ?>