/** * reports_quick_graph() - Show a quick graph of data. * * @param string Graph title * @param int First query resource ID * @param int Second query resource ID * @param string The bar colors */ function reports_quick_graph($title, $sql1, $sql2, $bar_colors) { $result1 = db_query($sql1); $result2 = db_query($sql2); if ($result1 && $result2 && db_numrows($result2) > 0) { $assoc_open = util_result_columns_to_assoc($result1); $assoc_all = util_result_columns_to_assoc($result2); while (list($key, $val) = each($assoc_all)) { $titles[] = $key; $all[] = $val; if ($assoc_open[$key]) { $open[] = $assoc_open[$key]; } else { $open[] = 0; } } /* for ($i=0; $i<db_numrows($result1); $i++) { echo "$titles[$i]=>$opened[$i]/$all[$i]<br />"; } */ $scale = graph_calculate_scale(array($opened, $all), 400); $props["scale"] = $scale; $props["cellspacing"] = 5; $props = hv_graph_defaults($props); start_graph($props, $titles); horizontal_multisection_graph($titles, array($open, $all), $bar_colors, $props); end_graph(); print '<p /><br />'; print '<table cellspacing="0" border="0"><tr align="center"><td width="15%">' . _('Key') . ':</td><td width="5%">(</td><td width="35%" style="background-color:' . $bar_colors[0] . '">' . _('Open') . '</td>' . '<td width="5%">/</td><td width="35%" style="background-color:' . $bar_colors[1] . '">' . _('All') . ' </td><td width="5%">)</td></tr></table>'; print '<p />'; // GraphResult($result,$title); } else { echo "<h2>" . _('No data found to report') . "</h2>"; } }
/** * vote_show_user_rate_box() - Show user rating box * * @param int The user ID * @param int The user ID of the user who is rating $user_id */ function vote_show_user_rate_box($user_id, $by_id = 0) { if ($by_id) { $res = db_query("\n\t\t\tSELECT rate_field,rating FROM user_ratings\n\t\t\tWHERE rated_by='{$by_id}'\n\t\t\tAND user_id='{$user_id}'\n\t\t"); $prev_vote = util_result_columns_to_assoc($res); while (list($k, $v) = each($prev_vote)) { if ($v == 0) { $prev_vote[$k] = 0.1; } } } global $USER_RATING_VALUES, $USER_RATING_QUESTIONS, $USER_RATING_POPUP1, $USER_RATING_POPUP2, $USER_RATING_POPUP3, $USER_RATING_POPUP4, $USER_RATING_POPUP5; echo ' <table border="0"> <form action="/developer/rate.php" method="post"> <input type="hidden" name="rated_user" value="' . $user_id . '" />'; for ($i = 1; $i <= count($USER_RATING_QUESTIONS); $i++) { $popup = "USER_RATING_POPUP{$i}"; if (!isset($prev_vote[$i])) { $prev_vote[$i] = ''; } echo '<tr> <td colspan="2"><strong>' . $USER_RATING_QUESTIONS[$i] . ':</strong><br /> ' . html_build_select_box_from_arrays($USER_RATING_VALUES, ${$popup}, "Q_{$i}", $prev_vote[$i], true, 'Unrated') . '</td></tr>'; } echo ' <tr><td colspan="2"><input type="submit" name="submit" value="Rate User" /></td></tr> </table> </form>'; }