コード例 #1
0
function ExportSelectResultByUserIDPaperID($userID, $paperID)
{
    $letter = array('A', 'B', 'C', 'D', 'E', 'F', 'F', 'G');
    $tableheader = array('选则结果编号', '用户编号', '试卷编号', '试题编号', '用户选项', '该题得分');
    for ($i = 0; $i < count($tableheader); $i++) {
        $GLOBALS['excel']->getActiveSheet()->setCellValue("{$letter[$i]}1", "{$tableheader[$i]}");
    }
    $datas = FindSelectResultByUserPaper($userID, $paperID);
    /*填充表格内部的信息 因为第一行被表头占用了 所以数据都从第二行开始  */
    for ($i = 2; $i <= count($datas) + 1; $i++) {
        $j = 0;
        foreach ($datas[$i - 2] as $data) {
            $GLOBALS['excel']->getActiveSheet()->setCellValue("{$letter[$j]}{$i}", "{$data}");
            $j++;
        }
    }
    //创建Excel输入对象
    CreateExcel();
}
コード例 #2
0
    echo '<!-- MEDIA TOP 0.5in -->';
    echo '<!-- MEDIA BOTTOM 0.25in -->';
    echo '<!-- MEDIA LEFT 0.25in -->';
    echo '<!-- MEDIA RIGHT 0.25in -->';
    echo '<!-- FOOTER RIGHT "" -->';
    echo '<!-- FOOTER LEFT "" -->';
    echo '<!-- FOOTER CENTER "" -->';
    echo '<!-- HEADER RIGHT "" -->';
    echo '<!-- HEADER LEFT "" -->';
    echo '<!-- HEADER CENTER "" -->';
    echo CreateList($_REQUEST['degree_level_id'], $_REQUEST['prog_level_id'], $_REQUEST['subject_id'], $_REQUEST['course_id'], $_REQUEST['marking_period_id'], $_REQUEST['mp_name']);
    PDFStop($handle, 'sis.pdf');
    exit;
}
if (clean_param($_REQUEST['create_excel'], PARAM_ALPHAMOD) == 'true') {
    echo CreateExcel($_REQUEST['degree_level_id'], $_REQUEST['prog_level_id'], $_REQUEST['subject_id'], $_REQUEST['course_id'], $_REQUEST['marking_period_id'], $_REQUEST['mp_name']);
}
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'choose_course') {
    DrawBC("Courses -> " . $_REQUEST['draw_header']);
    $sql = "SELECT PARENT_ID,TITLE,SHORT_NAME,PERIOD_ID,DAYS,\r\n                                MP,MARKING_PERIOD_ID,TEACHER_ID,CALENDAR_ID,\r\n                                ROOM,TOTAL_SEATS,DOES_ATTENDANCE,\r\n                                GRADE_SCALE_ID,DOES_HONOR_ROLL,DOES_CLASS_RANK,\r\n                                GENDER_RESTRICTION,HOUSE_RESTRICTION,CREDITS,\r\n                                HALF_DAY,DOES_BREAKOFF\r\n                        FROM COURSE_PERIODS\r\n                        WHERE COURSE_PERIOD_ID='{$_REQUEST['course_period_id']}'";
    $QI = DBQuery($sql);
    $RET = DBGet($QI);
    $RET = $RET[1];
    $title = $RET['TITLE'] . " , <b>Course:</b> " . $C_RET[1]['TITLE'] . ", <b>Number of Credits:</b> " . $C_RET[1]['NUMBER_OF_CREDITS'];
    $new = false;
    //print_r($RET);
    if (count($RET)) {
        $header .= '<TABLE cellpadding=3 width=100%>';
        $header .= '<TR>';
        $header .= '<TD><b>' . $RET['SHORT_NAME'] . '</b><br>Short Name</TD>';
        $teachers_RET = DBGet(DBQuery("SELECT concat((COALESCE(LAST_NAME,' '), ', ', COALESCE(FIRST_NAME,' '), ' ', COALESCE(MIDDLE_NAME,' '))) as Teacher FROM STAFF WHERE (SCHOOLS IS NULL OR strpos(SCHOOLS,'," . UserSchool() . ",')>0) AND SYEAR='" . UserSyear() . "' AND PROFILE='teacher' and STAFF_ID='" . $RET['TEACHER_ID'] . "' ORDER BY LAST_NAME,FIRST_NAME"));