PHP admin_get_releases примеры использования

Пример #1

Файл: requirement_edit_page.php Проект: nourchene-benslimane/rth_backup

$rows = project_get_req_doc_types($project_id);
foreach ($rows as $row) {
    $list_box[$row[REQ_DOC_TYPE_ID]] = $row[REQ_DOC_TYPE_NAME];
}
$list_box[""] = "";
html_print_list_box_from_key_array($list_box, session_validate_form_get_field('req_type', $req_doc_type));
print "</select>" . NEWLINE;
print "</td>" . NEWLINE;
print "</tr>" . NEWLINE;
# ASSIGNED TO RELEASE
print "<tr>" . NEWLINE;
print "<td class=form-lbl-r nowrap>" . lang_get('assigned_to_release') . "</td>" . NEWLINE;
print "<td class=form-data-l>" . NEWLINE;
print "<select name=assigned_release size=1>" . NEWLINE;
$list_box = array();
$rows_rel = admin_get_releases($project_id);
foreach ($rows_rel as $row_rel) {
    $list_box[$row_rel[RELEASE_ID]] = $row_rel[RELEASE_NAME];
}
$list_box[""] = "";
html_print_list_box_from_key_array($list_box, session_validate_form_get_field('req_area', $selected_release));
print "</select>" . NEWLINE;
print "</td>" . NEWLINE;
print "</tr>" . NEWLINE;
# SUBMIT BUTTON
print "<tr>" . NEWLINE;
print "<td colspan='2' class=center><input type='submit' value='" . lang_get('submit_btn') . "'></td>" . NEWLINE;
print "</tr>" . NEWLINE;
print "</table>" . NEWLINE;
print "</td>" . NEWLINE;
print "</tr>" . NEWLINE;

Пример #2

Файл: requirement_api.php Проект: nourchene-benslimane/rth_backup

function requirement_edit_assoc_releases($req_id, $assoc_releases)
{
    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;
    $tbl_req_ver_assoc_rel = REQ_VERS_ASSOC_REL;
    $f_req_ver_assoc_rel_id = $tbl_req_ver_assoc_rel . "." . REQ_VERS_ASSOC_REL_ID;
    $f_req_ver_assoc_rel_req_id = $tbl_req_ver_assoc_rel . "." . REQ_VERS_ASSOC_REL_REQ_ID;
    $f_req_ver_assoc_rel_rel_id = $tbl_req_ver_assoc_rel . "." . REQ_VERS_ASSOC_REL_REL_ID;
    $tbl_release = RELEASE_TBL;
    $f_release_id = $tbl_release . "." . RELEASE_ID;
    $f_release_project_id = $tbl_release . "." . PROJECT_ID;
    $f_release_name = $tbl_release . "." . RELEASE_NAME;
    $f_release_archive = $tbl_release . "." . RELEASE_ARCHIVE;
    $s_project_properties = session_get_project_properties();
    $project_id = $s_project_properties['project_id'];
    $release_ids = admin_get_releases($project_id);
    foreach ($release_ids as $row) {
        $q = "\tSELECT {$f_req_ver_assoc_rel_id}\n\t\t\t\tFROM {$tbl_req_ver_assoc_rel}\n\t\t\t\tWHERE {$f_req_ver_assoc_rel_req_id} = {$req_id}\n\t\t\t\t\tAND\t{$f_req_ver_assoc_rel_rel_id} = " . $row[RELEASE_ID];
        $rs = db_query($db, $q);
        $record_exists = db_num_rows($db, $rs);
        if (util_array_key_search($row[RELEASE_ID], $assoc_releases)) {
            if (!$record_exists) {
                $q = "\tINSERT INTO {$tbl_req_ver_assoc_rel}\n\t\t\t\t\t\t\t({$f_req_ver_assoc_rel_req_id}, {$f_req_ver_assoc_rel_rel_id})\n\t\t\t\t\t\tVALUES\n\t\t\t\t\t\t\t({$req_id}, " . $row[RELEASE_ID] . ")";
            }
        } else {
            if ($record_exists) {
                $q = "\tDELETE FROM {$tbl_req_ver_assoc_rel}\n\t\t\t\t\t\tWHERE {$f_req_ver_assoc_rel_req_id} = {$req_id}\n\t\t\t\t\t\t\tAND\t{$f_req_ver_assoc_rel_rel_id} = " . $row[RELEASE_ID];
            }
        }
        db_query($db, $q);
    }
}