PHP category_get_all_rows函数代码示例

/**
 * Get all categories of a project.
 *
 * @param string $p_username  The name of the user trying to access the categories.
 * @param string $p_password  The password of the user.
 * @param integer $p_project_id  The id of the project to retrieve the categories for.
 * @return Array  of categorie names
 */
function mc_project_get_categories($p_username, $p_password, $p_project_id)
{
    $t_user_id = mci_check_login($p_username, $p_password);
    if ($t_user_id === false) {
        return mci_soap_fault_login_failed();
    }
    if (!project_exists($p_project_id)) {
        return new soap_fault('Client', '', "Project '{$p_project_id}' does not exist.");
    }
    if (!mci_has_readonly_access($t_user_id, $p_project_id)) {
        return mci_soap_fault_access_denied($t_user_id);
    }
    $t_result = array();
    $t_cat_array = category_get_all_rows($p_project_id);
    foreach ($t_cat_array as $t_category_row) {
        $t_result[] = $t_category_row['name'];
    }
    return $t_result;
}

<!-- GLOBAL CATEGORIES -->
<a name="categories" />
<div align="center">
<table class="width75" cellspacing="1">

<!-- Title -->
<tr>
	<td class="form-title" colspan="3">
		<?php 
echo lang_get('global_categories');
?>
	</td>
</tr>
<?php 
$t_categories = category_get_all_rows(ALL_PROJECTS);
$t_can_update_global_cat = access_has_global_level(config_get('manage_site_threshold'));
if (count($t_categories) > 0) {
    ?>
		<tr class="row-category">
			<td>
				<?php 
    echo lang_get('category');
    ?>
			</td>
			<td>
				<?php 
    echo lang_get('assign_to');
    ?>
			</td>
<?php 

function print_category_option_list($p_category_id = 0, $p_project_id = null)
{
    $t_category_table = db_get_table('category');
    $t_project_table = db_get_table('project');
    if (null === $p_project_id) {
        $t_project_id = helper_get_current_project();
    } else {
        $t_project_id = $p_project_id;
    }
    if (config_get('allow_no_category')) {
        echo "<option value=\"0\"", check_selected($p_category_id, 0), '>';
        echo category_full_name(0, false), '</option>';
    } else {
        if (0 == $p_category_id) {
            echo "<option value=\"0\"", check_selected($p_category_id, 0), '>';
            echo string_attribute(lang_get('select_option')), '</option>';
        }
    }
    $cat_arr = category_get_all_rows($t_project_id, null, true);
    foreach ($cat_arr as $t_category_row) {
        $t_category_id = (int) $t_category_row['id'];
        echo "<option value=\"{$t_category_id}\"";
        check_selected($p_category_id, $t_category_id);
        echo '>' . string_attribute(category_full_name($t_category_id, $t_category_row['project_id'] != $t_project_id)) . '</option>';
    }
}

/**
 * Since categories can be orphaned we need to grab all unique instances of category
 * We check in the project category table and in the bug table
 * We put them all in one array and make sure the entries are unique
 *
 * @param integer $p_category_id A category identifier.
 * @param integer $p_project_id  A project identifier.
 * @return void
 */
function print_category_option_list($p_category_id = 0, $p_project_id = null)
{
    if (null === $p_project_id) {
        $t_project_id = helper_get_current_project();
    } else {
        $t_project_id = $p_project_id;
    }
    $t_cat_arr = category_get_all_rows($t_project_id, null, true);
    if (config_get('allow_no_category')) {
        echo '<option value="0"';
        check_selected($p_category_id, 0);
        echo '>';
        echo category_full_name(0, false), '</option>';
    } else {
        if (0 == $p_category_id) {
            if (count($t_cat_arr) == 1) {
                $p_category_id = (int) $t_cat_arr[0]['id'];
            } else {
                echo '<option value="0"';
                echo check_selected($p_category_id, 0);
                echo '>';
                echo string_attribute(lang_get('select_option')) . '</option>';
            }
        }
    }
    foreach ($t_cat_arr as $t_category_row) {
        $t_category_id = (int) $t_category_row['id'];
        echo '<option value="' . $t_category_id . '"';
        check_selected($p_category_id, $t_category_id);
        echo '>' . string_attribute(category_full_name($t_category_id, $t_category_row['project_id'] != $t_project_id)) . '</option>';
    }
}

<br />

<!-- PROJECT CATEGORIES -->
<div align="center" id="categories">
<table class="width75" cellspacing="1">

<!-- Title -->
<tr>
	<td class="form-title" colspan="3">
		<?php 
echo lang_get('categories');
?>
	</td>
</tr>
<?php 
$t_categories = category_get_all_rows($f_project_id);
if (count($t_categories) > 0) {
    ?>
		<tr class="row-category">
			<td>
				<?php 
    echo lang_get('category');
    ?>
			</td>
			<td>
				<?php 
    echo lang_get('assign_to');
    ?>
			</td>
			<td class="center">
				<?php 

/**
 * Construct an enumeration for all categories for the current project.
 * The enumeration will be empty if current project is ALL PROJECTS.
 * Enumerations format is: "abc|lmn|xyz"
 * To use this in a custom field type "=categories" in the possible values field.
 * @return string
 */
function custom_function_default_enum_categories()
{
    $t_categories = category_get_all_rows(helper_get_current_project());
    $t_enum = array();
    foreach ($t_categories as $t_category) {
        $t_enum[] = $t_category['name'];
    }
    $t_possible_values = implode('|', $t_enum);
    return $t_possible_values;
}

# --------------------------------------------------------
# $Id: manage_proj_cat_copy.php,v 1.21 2005/02/27 15:33:01 jlatour Exp $
# --------------------------------------------------------
require_once 'core.php';
$t_core_path = config_get('core_path');
require_once $t_core_path . 'category_api.php';
$f_project_id = gpc_get_int('project_id');
$f_other_project_id = gpc_get_int('other_project_id');
$f_copy_from = gpc_get_bool('copy_from');
$f_copy_to = gpc_get_bool('copy_to');
access_ensure_project_level(config_get('manage_project_threshold'), $f_project_id);
access_ensure_project_level(config_get('manage_project_threshold'), $f_other_project_id);
if ($f_copy_from) {
    $t_src_project_id = $f_other_project_id;
    $t_dst_project_id = $f_project_id;
} else {
    if ($f_copy_to) {
        $t_src_project_id = $f_project_id;
        $t_dst_project_id = $f_other_project_id;
    } else {
        trigger_error(ERROR_CATEGORY_NO_ACTION, ERROR);
    }
}
$rows = category_get_all_rows($t_src_project_id);
foreach ($rows as $row) {
    $t_category = $row['category'];
    if (category_is_unique($t_dst_project_id, $t_category)) {
        category_add($t_dst_project_id, $t_category);
    }
}
print_header_redirect('manage_proj_edit_page.php?project_id=' . $f_project_id);

/**
 * Convert a category name to a category id for a given project
 * @param string  $p_category_name Category name.
 * @param integer $p_project_id    Project id.
 * @return integer category id or 0 if not found
 */
function translate_category_name_to_id($p_category_name, $p_project_id)
{
    if (!isset($p_category_name)) {
        return 0;
    }
    $t_cat_array = category_get_all_rows($p_project_id);
    foreach ($t_cat_array as $t_category_row) {
        if ($t_category_row['name'] == $p_category_name) {
            return $t_category_row['id'];
        }
    }
    return 0;
}

}
$t_project_index = 0;
version_cache_array_rows($t_project_ids);
category_cache_array_rows_by_project($t_project_ids);
foreach ($t_project_ids as $t_project_id) {
    $t_project_name = project_get_field($t_project_id, 'name');
    $t_can_view_private = access_has_project_level(config_get('private_bug_threshold'), $t_project_id);
    $t_limit_reporters = config_get('limit_reporters');
    $t_user_access_level_is_reporter = REPORTER == access_get_project_level($t_project_id);
    $t_resolved = config_get('bug_resolved_status_threshold');
    $t_bug_table = db_get_table('mantis_bug_table');
    $t_relation_table = db_get_table('mantis_bug_relationship_table');
    # grab version info for later use
    $t_version_rows = version_get_all_rows($t_project_id, null, false);
    # cache category info, but ignore the results for now
    category_get_all_rows($t_project_id);
    $t_project_header_printed = false;
    foreach ($t_version_rows as $t_version_row) {
        $t_version_header_printed = false;
        $t_version = $t_version_row['version'];
        $t_version_id = $t_version_row['id'];
        # Skip all versions except the specified one (if any).
        if ($f_version_id != -1 && $f_version_id != $t_version_id) {
            continue;
        }
        $query = "SELECT sbt.*, dbt.fixed_in_version AS parent_version, rt.source_bug_id\n      FROM {$t_bug_table} AS sbt\n      LEFT JOIN {$t_relation_table} AS rt\n        ON sbt.id=rt.destination_bug_id AND rt.relationship_type=" . BUG_DEPENDANT . "\n      LEFT JOIN {$t_bug_table} AS dbt ON dbt.id=rt.source_bug_id\n      WHERE sbt.project_id=" . db_param() . "\n        AND sbt.fixed_in_version=" . db_param() . "\n      ORDER BY sbt.status ASC, sbt.last_updated DESC";
        $t_description = version_get_field($t_version_id, 'description');
        $t_first_entry = true;
        $t_issue_ids = array();
        $t_issue_parents = array();
        $t_issue_handlers = array();

#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with MantisBT.  If not, see <http://www.gnu.org/licenses/>.
require_once 'core.php';
require_once 'compress_api.php';
require_once 'filter_api.php';
require_once 'last_visited_api.php';
auth_ensure_user_authenticated();
$t_current_user_id = auth_get_current_user_id();
# Improve performance by caching category data in one pass
category_get_all_rows(helper_get_current_project());
compress_enable();
# don't index my view page
html_robots_noindex();
html_page_top1(plugin_lang_get('title'));
if (current_user_get_pref('refresh_delay') > 0) {
    html_meta_redirect(plugin_page('dashboard', true), current_user_get_pref('refresh_delay') * 60);
}
html_page_top2();
print_recently_visited();
$f_page_number = gpc_get_int('page_number', 1);
$t_per_page = config_get('my_view_bug_count');
$t_bug_count = null;
$t_page_count = null;
$t_filters = filter_db_get_available_queries();
$t_config_boxes = plugin_config_get('boxes');

/**
 * Get all categories of a project.
 *
 * @param string  $p_username   The name of the user trying to access the categories.
 * @param string  $p_password   The password of the user.
 * @param integer $p_project_id The id of the project to retrieve the categories for.
 * @return array An array of category names
 */
function mc_project_get_categories($p_username, $p_password, $p_project_id)
{
    global $g_project_override;
    $t_user_id = mci_check_login($p_username, $p_password);
    if ($t_user_id === false) {
        return mci_soap_fault_login_failed();
    }
    if (!project_exists($p_project_id)) {
        return SoapObjectsFactory::newSoapFault('Client', 'Project \'' . $p_project_id . '\' does not exist.');
    }
    $g_project_override = $p_project_id;
    if (!mci_has_readonly_access($t_user_id, $p_project_id)) {
        return mci_soap_fault_access_denied($t_user_id);
    }
    $t_result = array();
    $t_cat_array = category_get_all_rows($p_project_id);
    foreach ($t_cat_array as $t_category_row) {
        $t_result[] = $t_category_row['name'];
    }
    return $t_result;
}

/**
 *	Get a distinct array of categories accessible to the current user for
 *	the specified projects.  If no project is specified, use the current project.
 *	If the current project is ALL_PROJECTS get all categories for all accessible projects.
 *	For all cases, get global categories and subproject categories according to configured inheritance settings.
 *	@param mixed $p_project_id A specific project or null
 *	@return array A unique array of category names
 */
function category_get_filter_list( $p_project_id = null ) {
	if( null === $p_project_id ) {
		$t_project_id = helper_get_current_project();
	} else {
		$t_project_id = $p_project_id;
	}

	if( $t_project_id == ALL_PROJECTS ) {
		$t_project_ids = current_user_get_accessible_projects();
	} else {
		$t_project_ids = array( $t_project_id );
	}

	$t_subproject_ids = array();
	foreach( $t_project_ids as $t_project_id ) {
		$t_subproject_ids = array_merge( $t_subproject_ids, current_user_get_all_accessible_subprojects( $t_project_id ) );
	}

	$t_project_ids = array_merge( $t_project_ids, $t_subproject_ids );

	$t_categories = array();
	foreach( $t_project_ids AS $t_id ) {
		$t_categories = array_merge( $t_categories, category_get_all_rows( $t_id ) );
	}

	$t_unique = array();
	foreach( $t_categories AS $t_category ) {
		if( !in_array( $t_category['name'], $t_unique ) ) {
			$t_unique[] = $t_category['name'];
		}
	}

	return $t_unique;
}

/**
 * Remove all categories associated with a project
 * @param int $p_project_id Project ID
 * @param int $p_new_category_id new category id (to replace existing category)
 * @return bool
 * @access public
 */
function category_remove_all($p_project_id, $p_new_category_id = 0)
{
    project_ensure_exists($p_project_id);
    if (0 != $p_new_category_id) {
        category_ensure_exists($p_new_category_id);
    }
    # cache category names
    category_get_all_rows($p_project_id);
    $t_category_table = db_get_table('category');
    $t_bug_table = db_get_table('bug');
    # get a list of affected categories
    $t_query = "SELECT id FROM {$t_category_table} WHERE project_id=" . db_param();
    $t_result = db_query_bound($t_query, array($p_project_id));
    $t_category_ids = array();
    while ($t_row = db_fetch_array($t_result)) {
        $t_category_ids[] = $t_row['id'];
    }
    # Handle projects with no categories
    if (count($t_category_ids) < 1) {
        return true;
    }
    $t_category_ids = join(',', $t_category_ids);
    # update bug history entries
    $t_query = "SELECT id, category_id FROM {$t_bug_table} WHERE category_id IN ( {$t_category_ids} )";
    $t_result = db_query_bound($t_query);
    while ($t_bug_row = db_fetch_array($t_result)) {
        history_log_event_direct($t_bug_row['id'], 'category', category_full_name($t_bug_row['category_id'], false), category_full_name($p_new_category_id, false));
    }
    # update bug data
    $t_query = "UPDATE {$t_bug_table} SET category_id=" . db_param() . " WHERE category_id IN ( {$t_category_ids} )";
    db_query_bound($t_query, array($p_new_category_id));
    # delete categories
    $t_query = "DELETE FROM {$t_category_table} WHERE project_id=" . db_param();
    db_query_bound($t_query, array($p_project_id));
    return true;
}

/**
 * Update Issue in database
 *
 * Created By KGB
 * @param string $p_username The name of the user trying to add the issue.
 * @param string $p_password The password of the user.
 * @param Array $p_issue A IssueData structure containing information about the new issue.
 * @return integer The id of the created issue.
 */
function mc_issue_update($p_username, $p_password, $p_issue_id, $p_issue)
{
    $t_user_id = mci_check_login($p_username, $p_password);
    if ($t_user_id === false) {
        return new soap_fault('Client', '', 'Access Denied');
    }
    if (!bug_exists($p_issue_id)) {
        return new soap_fault('Server', '', "Issue '{$p_issue_id}' does not exist.");
    }
    $t_project_id = bug_get_field($p_issue_id, 'project_id');
    if (!mci_has_readwrite_access($t_user_id, $t_project_id)) {
        return new soap_fault('Client', '', 'Access Denied');
    }
    extract($p_issue, EXTR_PREFIX_ALL, 'v');
    $t_project_id = mci_get_project_id($v_project);
    $t_handler_id = mci_get_user_id($v_handler);
    $t_priority_id = mci_get_priority_id($v_priority);
    $t_severity_id = mci_get_severity_id($v_severity);
    $t_status_id = mci_get_status_id($v_status);
    $t_reproducibility_id = mci_get_reproducibility_id($v_reproducibility);
    $t_resolution_id = mci_get_resolution_id($v_resolution);
    $t_projection_id = mci_get_projection_id($v_projection);
    $t_eta_id = mci_get_eta_id($v_eta);
    $t_view_state_id = mci_get_view_state_id($v_view_state);
    $t_reporter_id = mci_get_user_id($v_reporter);
    if ($t_reporter_id == 0) {
        $t_reporter_id = $t_user_id;
    }
    if ($t_project_id == 0 || !project_exists($t_project_id)) {
        if ($t_project_id == 0) {
            return new soap_fault('Client', '', "Project '" . $v_project['name'] . "' does not exist.");
        } else {
            return new soap_fault('Client', '', "Project '{$t_project_id}' does not exist.");
        }
    }
    if (!access_has_bug_level(config_get('update_bug_threshold'), $p_issue_id, $t_user_id)) {
        return new soap_fault('Client', '', "User '{$t_user_id}' does not have access right to report issues.");
    }
    if ($t_handler_id != 0 && !user_exists($t_handler_id)) {
        return new soap_fault('Client', '', "User '{$t_handler_id}' does not exist.");
    }
    if (!in_array($v_category, mci_category_get_all_rows($t_project_id, $t_user_id))) {
        $t_error_when_category_not_found = config_get('mc_error_when_category_not_found');
        if ($t_error_when_category_not_found == ON) {
            if (is_blank($v_category) && count(category_get_all_rows($t_project_id)) == 0) {
                $v_category = '';
                // it is ok to have category as empty if project has no categories
            } else {
                return new soap_fault('Client', '', "Category '{$v_category}' does not exist in project '{$t_project_id}'.");
            }
        } else {
            $t_category_when_not_found = config_get('mc_category_when_not_found');
            $v_category = $t_category_when_not_found;
        }
    }
    if (isset($v_version) && !is_blank($v_version) && !version_get_id($v_version, $t_project_id)) {
        $t_error_when_version_not_found = config_get('mc_error_when_version_not_found');
        if ($t_error_when_version_not_found == ON) {
            $t_project_name = project_get_name($t_project_id);
            return new soap_fault('Client', '', "Version '{$v_version}' does not exist in project '{$t_project_name}'.");
        } else {
            $t_version_when_not_found = config_get('mc_version_when_not_found');
            $v_version = $t_version_when_not_found;
        }
    }
    if (is_blank($v_summary)) {
        return new soap_fault('Client', '', "Mandatory field 'summary' is missing.");
    }
    if (is_blank($v_description)) {
        return new soap_fault('Client', '', "Mandatory field 'description' is missing.");
    }
    if ($v_priority == 0) {
        $v_priority = config_get('default_bug_priority');
    }
    if ($v_severity == 0) {
        $v_severity = config_get('default_bug_severity');
    }
    if ($v_view_state == 0) {
        $v_view_state = config_get('default_bug_view_status');
    }
    if ($v_reproducibility == 0) {
        $v_reproducibility = 10;
    }
    $t_bug_data = new BugData();
    $t_bug_data->project_id = $t_project_id;
    $t_bug_data->reporter_id = $t_reporter_id;
    $t_bug_data->handler_id = $t_handler_id;
    $t_bug_data->priority = $t_priority_id;
    $t_bug_data->severity = $t_severity_id;
    $t_bug_data->reproducibility = $t_reproducibility_id;
    $t_bug_data->status = $t_status_id;
//.........这里部分代码省略.........

</a> |
                <a href="plugin.php?page=MantisKanban/kanban_page&pdisplay=splitted"><?php 
    echo lang_get('project_groups');
    ?>
</a>            
            <?php 
}
?>
        </td>
    </tr>
<tr>
<?php 
$t_per_page = -1;
# Improve performance by caching category data in one pass
if (helper_get_current_project() == 0) {
    $rows = category_get_all_rows(0);
    $t_categories = array();
    foreach ($rows as $t_row) {
        $t_categories[] = $t_row->category_id;
    }
    category_cache_array_rows(array_unique($t_categories));
}
// get all user set filters
$t_filter = current_user_get_bug_filter();
// if viewing all projects, allow to switch between combined and splitted view
// (all projects mixed together or separated into rows)
$f_default_pdisplay = "combined";
$pdisplay = gpc_get_string('pdisplay', $f_default_pdisplay);
// only one project to display?
if ($t_project_id || $pdisplay == "combined") {
    $all_project_ids = array($t_project_id);