示例#1
0
     $up_projectid = $_GET['up_projectid'];
     $can_see_this_uber = TRUE;
     if (!$can_see_this_uber) {
         $UP_ok_qry = mysql_query("\n            SELECT * FROM uber_projects up, usersettings us\n            WHERE us.username = '******' AND\n                us.setting  = 'up_manager' AND\n                us.value = up.up_projectid AND\n                up.up_projectid > 0\n            ");
         $can_see_this_uber = mysql_num_rows($UP_ok_qry);
     }
     if ($can_see_this_uber) {
         $condition .= " AND up_projectid = '{$up_projectid}' ";
     }
 }
 $n_results_per_page = @$_GET['n_results_per_page'];
 if ($n_results_per_page == 0) {
     $n_results_per_page = DEFAULT_N_RESULTS_PER_PAGE;
 }
 $results_offset = intval(@$_GET['results_offset']);
 $state_collater = sql_collater_for_project_state('state');
 $sql = "\n        SELECT SQL_CALC_FOUND_ROWS *\n        FROM projects\n        WHERE {$condition}\n        ORDER BY {$state_collater}, nameofwork asc\n        LIMIT {$n_results_per_page} OFFSET {$results_offset}\n    ";
 // echo "<pre>\n$sql\n</pre>\n";
 $result = mysql_query($sql) or die(mysql_error());
 $numrows = mysql_num_rows($result);
 $res_found = mysql_query("SELECT FOUND_ROWS()");
 $num_found_rows = mysql_result($res_found, 0);
 echo "<h1>", _("Search Results"), "</h1>\n";
 if ($numrows == 0) {
     echo _("<b>No projects matched the search criteria.</b>");
     return;
 }
 // -------------------------------------------------------------
 function option_to_move($curr_state, $new_state)
 {
     global $result;
示例#2
0
    echo "<td align='center'>";
    echo $row->round_id;
    echo "</td>\n";
    */
    echo "<td nowrap>";
    echo strftime('%Y-%m-%d %H:%M:%S', $row->max_timestamp);
    echo "</td>\n";
    echo "</tr>\n";
    $n_rows_displayed++;
}
echo "</table>\n";
echo sprintf(_("(%d projects)"), $n_rows_displayed);
echo "<br>\n";
// -----------------------------------------------------------------------------
unset($colspecs);
$colspecs = array('title' => array('label' => _('Title'), 'sql' => 'nameofwork'), 'manager' => array('label' => _('Project Manager'), 'sql' => 'username'), 'state' => array('label' => _('Current State'), 'sql' => sql_collater_for_project_state('state')));
// By default, order by state, descending.
$default_order_col = $order_col = 'state';
$default_order_dir = $order_dir = 'D';
if ($sorting == 'reserved') {
    list($order_col, $order_dir) = get_sort_col_and_dir();
}
$sql_order = sql_order_spec($order_col, $order_dir);
if ($order_col != $default_order_col) {
    // Add the default ordering as a secondary ordering.
    $sql_order .= ", " . sql_order_spec($default_order_col, $default_order_dir);
}
// We're interested in projects that have been created, but haven't *finished*
// being proofread.
$psd = get_project_status_descriptor('created');
$antipsd = get_project_status_descriptor('proofed');