/admin/view_answpaper1.php
PHP | 69 lines | 55 code | 9 blank | 5 comment | 6 complexity | bc6da0e19cd2264931f9b599c64f5bd0 MD5 | raw file
- <?php
-
- /**
- * @Alex Ai swallow13@163.com
- * @copyright 2009
- */
- require_once("../include/auth_t.php");
- require_once("../include/config.php");
- require_once("../include/funs.php");
- include_once("../include/head.htm");
-
- $paperid = $_POST['allpaper'];
-
- if ((!isset($_POST['begin'])) OR (!isset($_POST['end']))) {
- $TODAY = date('Y-m-d',time());$TODAY = explode('-',$TODAY);
- $begin = mktime(0,0,0,$TODAY[1],$TODAY[2],$TODAY[0]);
- $end = mktime(23,59,59,$TODAY[1],$TODAY[2],$TODAY[0]);
- } else {
- $b_d_arr = explode('-',$_POST['begin']);
- $begin = mktime(0,0,0,$b_d_arr[1],$b_d_arr[2],$b_d_arr[0]);
- $e_d_arr = explode('-',$_POST['end']);
- $end = mktime(23,59,59,$e_d_arr[1],$e_d_arr[2],$e_d_arr[0]);
- }
-
- $qr1 = mysql_query("SELECT * FROM `gb_answer_papers` WHERE `paper_id` = '$paperid' AND `status` = '1' AND `time` >= '$begin' AND `time` <= '$end';");
- //$qr1 = mysql_query("SELECT * FROM `gb_answer_papers` WHERE `paper_id` = '$paperid' AND `status` = '1';");
- $qr2 = mysql_query("SELECT * FROM `gb_papers_warehouse` WHERE `paper_id` = '$paperid';");
- $papertitle = mysql_result($qr2,0,1);
- $fullscore = mysql_result($qr2,0,5);
-
- if (mysql_num_rows($qr1) == 0) {
- echo '<script>alert("没有符合条件的答卷");window.close();</script>';
- } else {
- echo '<table width="90%" align="center" cellspacing="1" cellpadding="5" bgcolor="black">';
- echo '<tr bgcolor="white"><td align="center" colspan="7"><b>'.$_POST['birthday'].' 进行的 '.$papertitle.' 考试结果统计表</td></tr>';
- echo '<tr bgcolor="white"><td colspan="7">共有 '.mysql_num_rows($qr1).' 份答卷,满分 '.$fullscore.' 分。</td></tr>';
- echo '<tr bgcolor="white">
- <td>姓名</td>
- <td>身份证号</td>
- <td>联系电话</td>
- <td>毕业院校</td>
- <td>专业</td>
- <td>毕业时间</td>
- <td><b>得分</b></td></tr>';
-
- while ($answ = mysql_fetch_array($qr1)) {
- $SCORE = mysql_result(mysql_query("SELECT `total` FROM `gb_answ_score` WHERE `id` = '$answ[0]';"),0,0);
- $shuzu[$answ[0]] = $SCORE;
- }
- arsort($shuzu);
-
- foreach ($shuzu as $key=>$sc) {
- $stu_id = mysql_result(mysql_query("SELECT `stu_id` FROM `gb_answer_papers` WHERE `id` = '$key';"),0,0);
- $info = mysql_query("SELECT * FROM `gb_students_tb` WHERE `stu_id` = '$stu_id';");
-
- echo '<tr bgcolor="white">';
- echo '<td><a href="view_stu_info.php?stuid='.$stu_id.'" target="_blank">'.mysql_result($info,0,1).'</a></td>';
- echo '<td>'.mysql_result($info,0,12).'</td>';
- echo '<td>'.mysql_result($info,0,7).'</td>';
- echo '<td>'.mysql_result($info,0,10).'</td>';
- echo '<td>'.mysql_result($info,0,11).'</td>';
- echo '<td>'.mysql_result($info,0,4).'</td>';
- echo '<td><b><a href="view_stu_answpaper.php?anpid='.$key.'" target="_blank">'.$sc.'</a></b></td></tr>';
- }
- echo '<tr bgcolor="white"><td colspan="7"><input type="button" value="打印" onclick="javascript:window.print()" /></td></tr>';
- echo '</table>';
-
- }
- ?>