PageRenderTime 37ms CodeModel.GetById 10ms RepoModel.GetById 0ms app.codeStats 0ms

/admin/view_answpaper1.php

https://bitbucket.org/swallow13/online_exam_system
PHP | 69 lines | 55 code | 9 blank | 5 comment | 6 complexity | bc6da0e19cd2264931f9b599c64f5bd0 MD5 | raw file
  1. <?php
  2. /**
  3. * @Alex Ai swallow13@163.com
  4. * @copyright 2009
  5. */
  6. require_once("../include/auth_t.php");
  7. require_once("../include/config.php");
  8. require_once("../include/funs.php");
  9. include_once("../include/head.htm");
  10. $paperid = $_POST['allpaper'];
  11. if ((!isset($_POST['begin'])) OR (!isset($_POST['end']))) {
  12. $TODAY = date('Y-m-d',time());$TODAY = explode('-',$TODAY);
  13. $begin = mktime(0,0,0,$TODAY[1],$TODAY[2],$TODAY[0]);
  14. $end = mktime(23,59,59,$TODAY[1],$TODAY[2],$TODAY[0]);
  15. } else {
  16. $b_d_arr = explode('-',$_POST['begin']);
  17. $begin = mktime(0,0,0,$b_d_arr[1],$b_d_arr[2],$b_d_arr[0]);
  18. $e_d_arr = explode('-',$_POST['end']);
  19. $end = mktime(23,59,59,$e_d_arr[1],$e_d_arr[2],$e_d_arr[0]);
  20. }
  21. $qr1 = mysql_query("SELECT * FROM `gb_answer_papers` WHERE `paper_id` = '$paperid' AND `status` = '1' AND `time` >= '$begin' AND `time` <= '$end';");
  22. //$qr1 = mysql_query("SELECT * FROM `gb_answer_papers` WHERE `paper_id` = '$paperid' AND `status` = '1';");
  23. $qr2 = mysql_query("SELECT * FROM `gb_papers_warehouse` WHERE `paper_id` = '$paperid';");
  24. $papertitle = mysql_result($qr2,0,1);
  25. $fullscore = mysql_result($qr2,0,5);
  26. if (mysql_num_rows($qr1) == 0) {
  27. echo '<script>alert("没有符合条件的答卷");window.close();</script>';
  28. } else {
  29. echo '<table width="90%" align="center" cellspacing="1" cellpadding="5" bgcolor="black">';
  30. echo '<tr bgcolor="white"><td align="center" colspan="7"><b>'.$_POST['birthday'].' 进行的 '.$papertitle.' 考试结果统计表</td></tr>';
  31. echo '<tr bgcolor="white"><td colspan="7">共有 '.mysql_num_rows($qr1).' 份答卷,满分 '.$fullscore.' 分。</td></tr>';
  32. echo '<tr bgcolor="white">
  33. <td>姓名</td>
  34. <td>身份证号</td>
  35. <td>联系电话</td>
  36. <td>毕业院校</td>
  37. <td>专业</td>
  38. <td>毕业时间</td>
  39. <td><b>得分</b></td></tr>';
  40. while ($answ = mysql_fetch_array($qr1)) {
  41. $SCORE = mysql_result(mysql_query("SELECT `total` FROM `gb_answ_score` WHERE `id` = '$answ[0]';"),0,0);
  42. $shuzu[$answ[0]] = $SCORE;
  43. }
  44. arsort($shuzu);
  45. foreach ($shuzu as $key=>$sc) {
  46. $stu_id = mysql_result(mysql_query("SELECT `stu_id` FROM `gb_answer_papers` WHERE `id` = '$key';"),0,0);
  47. $info = mysql_query("SELECT * FROM `gb_students_tb` WHERE `stu_id` = '$stu_id';");
  48. echo '<tr bgcolor="white">';
  49. echo '<td><a href="view_stu_info.php?stuid='.$stu_id.'" target="_blank">'.mysql_result($info,0,1).'</a></td>';
  50. echo '<td>'.mysql_result($info,0,12).'</td>';
  51. echo '<td>'.mysql_result($info,0,7).'</td>';
  52. echo '<td>'.mysql_result($info,0,10).'</td>';
  53. echo '<td>'.mysql_result($info,0,11).'</td>';
  54. echo '<td>'.mysql_result($info,0,4).'</td>';
  55. echo '<td><b><a href="view_stu_answpaper.php?anpid='.$key.'" target="_blank">'.$sc.'</a></b></td></tr>';
  56. }
  57. echo '<tr bgcolor="white"><td colspan="7"><input type="button" value="打印" onclick="javascript:window.print()" /></td></tr>';
  58. echo '</table>';
  59. }
  60. ?>