PHP session_get_user_properties函数代码示例

function log_activity_log($page_name, $deletion, $creation, $upload, $action)
{
    global $db;
    $s_project_name = session_get_project_name();
    $s_user_properties = session_get_user_properties();
    $s_username = $s_user_properties['username'];
    $s_session = session_get_ID();
    $current_date = date("Y-m-d H:i:s");
    $page_name = $page_name . " - " . $s_project_name;
    $logs_tbl = LOGS_TBL;
    $query = "\tINSERT INTO {$logs_tbl} ( User,\n    \t\t\t\t\t\t\t\t\tPage,\n    \t\t\t\t\t\t\t\t\tTimeStamp,\n    \t\t\t\t\t\t\t\t\tSessionID,\n    \t\t\t\t\t\t\t\t\tDeletion,\n    \t\t\t\t\t\t\t\t\tCreation,\n    \t\t\t\t\t\t\t\t\tUpload,\n    \t\t\t\t\t\t\t\t\tAction )\n\n    \t\t\tVALUES (\t'{$s_username}',\n    \t\t\t\t\t\t'{$page_name}',\n    \t\t\t\t\t\t'{$current_date}',\n    \t\t\t\t\t\t'{$s_session}',\n    \t\t\t\t\t\t'{$deletion}',\n    \t\t\t\t\t\t'{$creation}',\n    \t\t\t\t\t\t'{$upload}',\n    \t\t\t\t\t\t'{$action}' )";
    db_query($db, $query);
}

function user_get_name_by_username($username)
{
    global $db;
    $user_tbl = USER_TBL;
    $f_email = USER_EMAIL;
    $f_firstname = USER_FNAME;
    $f_lastname = USER_LNAME;
    $f_username = USER_UNAME;
    $s_user_properties = session_get_user_properties();
    $user_id = $s_user_properties['user_id'];
    $query = "SELECT {$f_email}, {$f_firstname}, {$f_lastname}\n              FROM {$user_tbl}\n              WHERE {$f_username} = '{$username}'";
    $rs =& db_query($db, $query);
    $row = db_fetch_row($db, $rs);
    return $row;
}

$project_edit_page = 'project_edit_page.php';
$user_manage_page = 'user_manage_page.php';
$user_add_page = 'user_add_page.php';
$project_manage_action = 'project_manage_action.php';
$delete_page = 'delete_page.php';
$s_project_properties = session_get_project_properties();
$project_name = $s_project_properties['project_name'];
$project_id = $s_project_properties['project_id'];
$s_user_properties = session_get_user_properties();
$user_id = $s_user_properties['user_id'];
session_set_properties("project_manage", $_GET);
$selected_project_properties = session_get_properties("project_manage");
$selected_project_id = $selected_project_properties['project_id'];
$project_manager = user_has_rights($selected_project_id, $user_id, MANAGER);
$redirect_url = $page . "?project_id=" . $selected_project_id;
$s_user_properties = session_get_user_properties();
$user_id = $s_user_properties['user_id'];
$row_style = '';
$order_by = MAN_DOC_TYPE_NAME;
$order_dir = "ASC";
$page_number = 1;
util_set_order_by($order_by, $_GET);
util_set_order_dir($order_dir, $_GET);
util_set_page_number($page_number, $_GET);
util_set_order_by($order_by, $_POST);
util_set_order_dir($order_dir, $_POST);
util_set_page_number($page_number, $_POST);
html_window_title();
html_print_body();
html_page_title(project_get_name($selected_project_id) . " - " . lang_get('manage_project_page'));
html_page_header($db, $project_name);

function html_print_menu()
{
    $home_url = RTH_URL . "home_page.php";
    $req_url = RTH_URL . "requirement_page.php";
    $test_url = RTH_URL . "test_page.php";
    $release_url = RTH_URL . "release_page.php";
    $results_url = RTH_URL . "results_page.php";
    $bug_url = BUGTRACKER_URL;
    $reports_url = RTH_URL . "report_page.php";
    $admin_url = RTH_URL . "admin_page.php";
    $user_url = RTH_URL . "user_edit_my_account_page.php";
    $help_url = RTH_URL . "help_index.php";
    $logout_url = RTH_URL . "logout.php";
    # set user url if user has admin rights
    $s_user_properties = session_get_user_properties();
    $user_id = $s_user_properties['user_id'];
    $s_project_properties = session_get_project_properties();
    $project_name = $s_project_properties['project_name'];
    $project_id = $s_project_properties['project_id'];
    if (user_has_rights($project_id, $user_id, ADMIN)) {
        $user_url = RTH_URL . "user_manage_page.php";
    }
    # Get the session variables from the results page and append them on the query string if they are set
    $s_results = session_get_display_options("results");
    if (isset($s_results['release_id'])) {
        $results_url = $results_url . "?release_id=" . $s_results['release_id'];
    }
    if (isset($s_results['build_id'])) {
        $results_url = $results_url . "&build_id=" . $s_results['build_id'];
    }
    if (isset($s_results['testset_id'])) {
        $results_url = $results_url . "&testset_id=" . $s_results['testset_id'];
    }
    if (isset($s_results['test_id'])) {
        $results_url = "results_test_run_page.php?test_id=" . $s_results['test_id'] . "&testset_id=" . $s_results['testset_id'];
    }
    print "<table class=width100 cellspacing=0>" . NEWLINE;
    print "<tr>" . NEWLINE;
    print "<td class=menu>" . NEWLINE;
    print "<a href='{$home_url}'>" . lang_get('home_link') . "</a> | " . NEWLINE;
    print "<a href='{$req_url}'>" . lang_get('req_link') . "</a> | " . NEWLINE;
    print "<a href='{$test_url}'>" . lang_get('test_link') . "</a> | " . NEWLINE;
    print "<a href='{$release_url}'>" . lang_get('release_link') . "</a> | " . NEWLINE;
    print "<a href='{$results_url}'>" . lang_get('results_link') . "</a> | " . NEWLINE;
    print "<a href='{$bug_url}'";
    if (BUGTRACKER != 'rth') {
        print " target='new'";
    }
    print ">" . lang_get('bug_link') . "</a> | " . NEWLINE;
    print "<a href='{$reports_url}'>" . lang_get('reports_link') . "</a> | " . NEWLINE;
    print "<a href='{$admin_url}'>" . lang_get('admin_link') . "</a> | " . NEWLINE;
    print "<a href='{$user_url}'>" . lang_get('user_link') . "</a> | " . NEWLINE;
    print "<a href='{$help_url}' target=_blank>" . lang_get('help_link') . "</a> | " . NEWLINE;
    print "<a href='{$logout_url}'>" . lang_get('logout_link') . "</a>" . NEWLINE;
    print "</td>" . NEWLINE;
    print "</tr>" . NEWLINE;
    print "</table>" . NEWLINE;
    print "<br>" . NEWLINE;
}

function test_change_last_update($test_id)
{
    global $db;
    $test_tbl = TEST_TBL;
    $f_test_id = TEST_ID;
    $f_last_updated = TEST_LAST_UPDATED;
    $f_last_updated_by = TEST_LAST_UPDATED_BY;
    $last_updated_date = date_get_short_dt();
    $s_user_properties = session_get_user_properties();
    $s_user_name = $s_user_properties['username'];
    $last_updated_by = $s_user_name;
    $q = "UPDATE {$test_tbl}\n\t\t  SET\n\t\t  {$f_last_updated} = '{$last_updated_date}',\n\t\t  {$f_last_updated_by} = '{$last_updated_by}'\n\t\t  WHERE {$f_test_id} = '{$test_id}'";
    db_query($db, $q);
}

function error_format($errno, $errstr, $errfile, $errline)
{
    $dt = date("Y-m-d H:i:s (T)");
    $user_details = session_get_user_properties();
    $project_details = session_get_project_properties();
    $user_name = $user_details['username'];
    $project_name = $project_details['project_name'];
    $error_type = error_type_map($errno);
    $err = "{$error_type}" . NEWLINE;
    $err .= "Time: " . $dt . "" . NEWLINE;
    $err .= "Message: " . $errstr . "" . NEWLINE;
    $err .= "File: " . $errfile . "" . NEWLINE;
    $err .= "Line Number: " . $errline . "" . NEWLINE;
    $err .= "User: " . $user_name . "" . NEWLINE;
    $err .= "Project: " . $project_name . "" . NEWLINE;
    $err .= "Server: " . $_SERVER['SERVER_NAME'] . "" . NEWLINE;
    return $err;
}

function file_add_supporting_test_doc_version($file_temp_name, $file_name, $test_id, $manual_test_id, $comments, $file_type)
{
    global $db;
    $project_properties = session_get_project_properties();
    $file_upload_path = $project_properties['test_upload_path'];
    $project_id = $project_properties['project_id'];
    $redirect_page = "test_detail_page.php?test_id={$test_id}&project_id={$project_id}&tab=2";
    $redirect_on_error = "test_add_doc_version_page.php?test_id={$test_id}&manual_test_id={$manual_test_id}";
    $file_db_name = "";
    # Check to make sure the file name is the same as the previous version
    if (IGNORE_VERSION_FILENAME_VALIDATION || file_name_exists($test_id, $file_name)) {
        # create a unique name for the file using the time function
        $file_db_name = "SupportingTestDoc" . time() . "-{$file_name}";
        # Get the current file version and increment it by one
        $current_file_version = test_get_max_file_version($manual_test_id);
        $file_version = util_increment_version($current_file_version);
        # Make sure the temp file was uploaded successfully
        if (move_uploaded_file($file_temp_name, $file_upload_path . $file_db_name)) {
            $current_date = date("Y-m-d H:i:s");
            $s_user = session_get_user_properties();
            $username = $s_user['username'];
            $td_vers_tbl = MAN_TD_VER_TBL;
            $f_man_test_id = MAN_TD_VER_MANUAL_TEST_ID;
            $f_file_name = MAN_TD_VER_FILENAME;
            $f_timestamp = MAN_TD_VER_TIME_STAMP;
            $f_version = MAN_TD_VER_VERSION;
            $f_username = MAN_TD_VER_UPLOADED_BY;
            $f_comments = MAN_TEST_DOCS_VERS_COMMENTS;
            $f_file_type = MAN_TEST_DOCS_VERS_MANUAL_DOC_TYPE_NAME;
            $q = "INSERT INTO {$td_vers_tbl} \n\t\t\t\t({$f_man_test_id}, {$f_file_name}, {$f_timestamp}, {$f_version}, {$f_username}, {$f_comments}, {$f_file_type}) \n\t\t\t\tVALUES ('{$manual_test_id}', '{$file_db_name}', '{$current_date}', '{$file_version}', '{$username}', '{$comments}', '{$file_type}')";
            //print"$q<br>";
            $db->Execute($q);
        } else {
            # The file wasn't uploaded to the temp directory successfully
            error_report_show($redirect_page, FAILED_FILE_UPLOAD);
        }
    } else {
        # The file name of the new version doesn't match the old
        error_report_show($redirect_on_error, NO_MATCHING_FILE_NAME);
    }
}

function requirement_edit($project_id, $req_id, $req_version_id, $req_defect_id, $name, $area_covered, $type, $status, $detail, $reason_for_change, $functionality, $priority, $release_id)
{
    global $db;
    $tbl_req = REQ_TBL;
    $f_req_proj_id = $tbl_req . "." . REQ_PROJECT_ID;
    $f_req_id = $tbl_req . "." . REQ_ID;
    $f_req_filename = $tbl_req . "." . REQ_FILENAME;
    $f_req_area_covered = $tbl_req . "." . REQ_AREA_COVERED;
    $f_req_type = $tbl_req . "." . REQ_TYPE;
    $f_req_parent = $tbl_req . "." . REQ_PARENT;
    $f_req_label = $tbl_req . "." . REQ_LABEL;
    $f_req_unique_id = $tbl_req . "." . REQ_UNIQUE_ID;
    $f_req_functionality = $tbl_req . "." . REQ_FUNCTIONALITY;
    $f_req_locked_by = $tbl_req . "." . REQ_LOCKED_BY;
    $f_req_locked_date = $tbl_req . "." . REQ_LOCKED_DATE;
    $f_req_priority = $tbl_req . "." . REQ_PRIORITY;
    $f_req_last_updated = $tbl_req . "." . REQ_LAST_UPDATED;
    $tbl_req_ver = REQ_VERS_TBL;
    $f_req_ver_uid = $tbl_req_ver . "." . REQ_VERS_UNIQUE_ID;
    $f_req_ver_req_id = $tbl_req_ver . "." . REQ_VERS_REQ_ID;
    $f_req_ver_version = $tbl_req_ver . "." . REQ_VERS_VERSION;
    $f_req_ver_timestamp = $tbl_req_ver . "." . REQ_VERS_TIMESTAMP;
    $f_req_ver_uploaded_by = $tbl_req_ver . "." . REQ_VERS_UPLOADED_BY;
    $f_req_ver_filename = $tbl_req_ver . "." . REQ_VERS_FILENAME;
    $f_req_ver_comments = $tbl_req_ver . "." . REQ_VERS_COMMENTS;
    $f_req_ver_status = $tbl_req_ver . "." . REQ_VERS_STATUS;
    $f_req_ver_shed_release = $tbl_req_ver . "." . REQ_VERS_SCHEDULED_RELEASE_IMP;
    $f_req_ver_shed_build = $tbl_req_ver . "." . REQ_VERS_SCHEDULED_BUILD_IMP;
    $f_req_ver_actual_release = $tbl_req_ver . "." . REQ_VERS_ACTUAL_RELEASE_IMP;
    $f_req_ver_actual_build = $tbl_req_ver . "." . REQ_VERS_ACTUAL_BUILD_IMP;
    $f_req_ver_detail = $tbl_req_ver . "." . REQ_VERS_DETAIL;
    $f_req_ver_release = $tbl_req_ver . "." . REQ_VERS_ASSIGN_RELEASE;
    $f_req_ver_reason_change = $tbl_req_ver . "." . REQ_VERS_REASON_CHANGE;
    $f_req_ver_latest = $tbl_req_ver . "." . REQ_VERS_LATEST;
    $f_req_ver_last_updated = $tbl_req_ver . "." . REQ_VERS_LAST_UPDATED;
    $f_req_ver_last_updated_by = $tbl_req_ver . "." . REQ_VERS_LAST_UPDATED_BY;
    $f_req_ver_defect_id = $tbl_req_ver . "." . REQ_VERS_DEFECT_ID;
    $last_updated = date_get_short_dt();
    $s_user_properties = session_get_user_properties();
    $s_user_name = $s_user_properties['username'];
    $last_updated_by = $s_user_name;
    if ($area_covered == '') {
        $area_covered = 0;
    }
    if ($type == '') {
        $type = 0;
    }
    $q = "\tUPDATE {$tbl_req}\n\t\t\tSET\n\t\t\t\t{$f_req_filename} = '{$name}',\n\t\t\t\t{$f_req_area_covered} = '{$area_covered}',\n\t\t\t\t{$f_req_type} = '{$type}',\n\t\t\t\t{$f_req_priority} = '{$priority}',\n\t\t\t\t{$f_req_last_updated} = '{$last_updated}'\n\t\t\tWHERE\n\t\t\t\t{$f_req_id} = '{$req_id}'\n\t\t\t\tAND {$f_req_proj_id} = {$project_id}";
    db_query($db, $q);
    //print"$q<br>";
    $q = "\tUPDATE {$tbl_req_ver}\n\t\t\tSET\n\t\t\t\t{$f_req_ver_status} \t\t\t= '{$status}',\n\t\t\t\t{$f_req_ver_detail} \t\t\t= '{$detail}',\n\t\t\t\t{$f_req_ver_reason_change}\t= '{$reason_for_change}',\n\t\t\t\t{$f_req_ver_last_updated}\t\t= '{$last_updated}',\n\t\t\t\t{$f_req_ver_last_updated_by}\t= '{$last_updated_by}',\n\t\t\t\t{$f_req_ver_defect_id}\t\t= '{$req_defect_id}'\n\t\t\tWHERE\n\t\t\t\t{$f_req_ver_uid} = '{$req_version_id}'";
    db_query($db, $q);
    //print"$q<br>";
    requirement_edit_functionality($req_id, $functionality);
    requirement_edit_release($req_version_id, $release_id);
}

function bug_email_collect_recipients($bug_id, $notify_type)
{
    global $db;
    $receive_own_email = BUG_EMAIL_ON_OWN_ACTIONS;
    $recipients = "";
    $recipient_ids = array();
    $user_ids = array();
    # Get the current project and user ids
    $project_id = bug_get_field_value($bug_id, BUG_PROJECT_ID);
    $s_user_properties = session_get_user_properties();
    $user_id = $s_user_properties['user_id'];
    $monitor_tbl = BUG_MONITOR_TBL;
    $f_monitor_user_id = BUG_MONITOR_USER_ID;
    $f_monitor_bug_id = BUG_MONITOR_BUG_ID;
    $proj_user_tbl = PROJECT_USER_ASSOC_TBL;
    $f_proj_user_id = PROJ_USER_USER_ID;
    $f_proj_user_proj_id = PROJ_USER_PROJ_ID;
    # Get user_ids for the bug
    $q = "\tSELECT DISTINCT {$f_monitor_user_id}\n\t\t\tFROM {$monitor_tbl}\n\t\t\tWHERE {$f_monitor_bug_id} = {$bug_id}";
    $rs = db_query($db, $q);
    while ($row = db_fetch_row($db, $rs)) {
        # check to see if we should add the user performing the action to the list of recipients
        if ($row[BUG_MONITOR_USER_ID] == $user_id && !$receive_own_email) {
            continue;
        } else {
            $user_ids[] = $row[BUG_MONITOR_USER_ID];
        }
    }
    # Loop through each user_id and find out if the user wants to receive email for the action ($notify_type)
    foreach ($user_ids as $id) {
        switch ($notify_type) {
            case "update_status":
                $f_email_field = PROJ_USER_EMAIL_STATUS_BUG;
                break;
            case "add_bugnote":
                $f_email_field = PROJ_USER_EMAIL_BUGNOTE_BUG;
                break;
            case "assign_bug":
                $f_email_field = PROJ_USER_EMAIL_ASSIGNED_BUG;
                break;
            case "update_bug":
                $f_email_field = PROJ_USER_EMAIL_UPDATE_BUG;
                break;
        }
        # Find out if the user wants email for the specified action
        $q_assoc = "SELECT {$f_email_field}\n\t\t\t\t\tFROM {$proj_user_tbl}\n\t\t\t\t\tWHERE {$f_proj_user_proj_id} = '{$project_id}'\n\t\t\t\t\tAND {$f_proj_user_id} = '{$id}'";
        $rs_assoc = db_query($db, $q_assoc);
        while ($row_assoc = db_fetch_row($db, $rs_assoc)) {
            # If the project_user_assoc preference is Yes, add the user to the list of recipients
            if ($row_assoc[$f_email_field] == 'Y') {
                $recipient_ids[] = $id;
            }
        }
    }
    $recipients = user_get_email_by_user_id($recipient_ids);
    return $recipients;
}

function testset_add_tests_from_session($testset_properties, $f_status, $property_set)
{
    $checked_tests = array();
    $project_id = session_get_project_id();
    $s_user_properties = session_get_user_properties();
    $s_project_properties = session_get_project_properties();
    $testset_id = $testset_properties['testset_id'];
    $testset_name = admin_get_testset_name($testset_id);
    $build_id = $testset_properties['build_id'];
    $build_name = admin_get_build_name($build_id);
    $release_id = $testset_properties['release_id'];
    $release_name = admin_get_release_name($release_id);
    global $db;
    $testsuite_tbl = TEST_TBL;
    $f_test_id = TEST_TBL . "." . TEST_ID;
    $f_project_id = TEST_TBL . "." . PROJECT_ID;
    $f_deleted = TEST_TBL . "." . TEST_DELETED;
    $f_archived = TEST_TBL . "." . TEST_ARCHIVED;
    $ts_assoc_tbl = TEST_TS_ASSOC_TBL;
    $f_ts_assoc_id = TEST_TS_ASSOC_TBL . "." . TEST_TS_ASSOC_ID;
    $f_ts_assoc_test_id = TEST_TS_ASSOC_TBL . "." . TEST_TS_ASSOC_TEST_ID;
    $q = "SELECT {$f_test_id},\n\t\t\t{$f_ts_assoc_id},\n\t\t\t{$f_status}\n\t     FROM {$ts_assoc_tbl}\n\t     RIGHT JOIN {$testsuite_tbl} ON {$f_ts_assoc_test_id} = {$f_test_id}\n\t     WHERE {$f_project_id} = {$project_id}\n\t     AND {$f_archived} = 'N'\n\t     AND {$f_deleted} = 'N'\n\t     GROUP BY {$f_test_id}";
    $rs = db_query($db, $q);
    while ($row = db_fetch_row($db, $rs)) {
        if (isset($row[$f_status])) {
            # If the checkbox is ticked, then form an association between Test/TestSet
            if (session_records_ischecked($property_set, $row[TEST_ID], $row[$f_status])) {
                $checked_tests[$row[TEST_ID]] = "on";
            }
        }
    }
    testset_edit($testset_id, $checked_tests);
}