tickets/course_report.php at main · openises/tickets · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
<?php
/*
12/15/11 - initial release
12/19/11 'group' => 'group_name'
*/
error_reporting(E_ALL);
require_once './incs/functions.inc.php';
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<HTML>
<HEAD>
<TITLE>Classes Taken Report</TITLE>
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8">
<META HTTP-EQUIV="Expires" CONTENT="0">
<META HTTP-EQUIV="Cache-Control" CONTENT="NO-CACHE">
<META HTTP-EQUIV="Pragma" CONTENT="NO-CACHE">
<META HTTP-EQUIV="Content-Script-Type"    CONTENT="application/x-javascript">
<LINK REL=StyleSheet HREF="stylesheet.php?version=<?php print time();?>" TYPE="text/css"> <!-- 3/15/11 -->
</HEAD>
<BODY>

<?php
//        dump($_POST);
        $user_id = sanitize_int($_POST['user_id']);
        $where = ($user_id > 0)? " WHERE `t`.`user_id` = ?" : "";
        $params = ($user_id > 0)? [$user_id] : [];


        $query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}courses_taken` `t`
            LEFT JOIN `{$GLOBALS['mysql_prefix']}user` `u` ON `u`.`id`=`t`.`user_id`
            LEFT JOIN `{$GLOBALS['mysql_prefix']}courses` `c` ON `t`.`courses_id`=`c`.`id`
            {$where}
            ORDER BY `u`.`name_l` ASC, `u`.`name_f` ASC, `c`.`group_name` ASC, `c`.`course` ASC";
        $result = db_query($query, $params);

        if ($result->num_rows==0) {        // no results - get selected userid
            $query     = "SELECT * FROM  `{$GLOBALS['mysql_prefix']}user` WHERE `id` = ? LIMIT 1";
            $result    = db_query($query, [$user_id]);
            $the_user_str = "";
            if ($result->num_rows>0) {        // got a name?
                $row = $result ? stripslashes_deep($result->fetch_assoc()) : null;
                $the_user_str = " for {$row['user']}";
                }

            echo "<BR /><BR /><center><H2>No class data{$the_user_str}</H2><BR /><BR /><BR />";
            }
        else {
            $evenodd = array ("even", "odd");    // CLASS names for alternating table row colors
            $i = 0;
            $cum_credits = 0;
            $this_user= 0;
            echo "<BR /><BR /><TABLE BORDER = 1 ALIGN=CENTER CELLPADDING = 2>
                <TR CLASS = 'even'><TH COLSPAN=99>Classes Taken - <i><small>as of " . date('M j, y', time()) . "</small></i></TH></TR>";

            while ($row = stripslashes_deep($result->fetch_assoc()))     {
                if ($row['user_id'] == $this_user ) {$cum_credits += $row['credits'];}
                else                                {$cum_credits = $row['credits']; $this_user = $row['user_id'];}
                echo "<TR CLASS='{$evenodd[($i+1)%2]}' VALIGN='baseline'>\n\t\t
                    <TD>" . e($row['name_l']) . ", " . e($row['name_f']) . " " . e($row['name_mi']) . "</TD>
                    <TD>" . e($row['email']) . "</TD>
                    <TD>" . e($row['group_name']) . "</TD>
                    <TD>" . e($row['course']) . "</TD>
                    <TD>" . e($row['ident']) . "</TD>
                    <TD>" . e($row['credits']) . "</TD>
                    <TD>" . e($cum_credits) . "</TD>
                    <TD>" . e($row['date']) . "</TD>
                    ";
                $i++;
                }
?>
    </TABLE>
<?php
    }            // end if/else
?>

    <FORM NAME = 'course_form' METHOD = 'post' ACTION = '<?php echo basename(__FILE__)?>'>
    <INPUT TYPE = 'hidden' NAME = 'user_id' VALUE = ''>
    </FORM>
    <SPAN STYLE='text-align: center; display: block;'>
    <BR />
    Another &raquo;
        <SELECT NAME='frm_user_id' onChange = "document.course_form.user_id.value=this.options[this.selectedIndex].value; document.course_form.submit();">
            <OPTION VALUE='' selected>Select</OPTION>
            <OPTION VALUE='0' >All users</OPTION>
<?php
            $query     = "SELECT * FROM  `{$GLOBALS['mysql_prefix']}user` WHERE ((`name_l` IS NOT NULL) AND (LENGTH(`name_l`) > 0)) ORDER BY `name_l` ASC, `name_f` ASC";
            $result    = db_query($query);
            while ($row = stripslashes_deep($result->fetch_assoc())) {
                $the_opt = shorten("({$row['user']}) {$row['name_l']}, {$row['name_f']} {$row['name_mi']} ", 48);
                echo "\t\t<OPTION VALUE='{$row['id']}'>{$the_opt}</OPTION>\n";
                }                // end while()
?>
        </SELECT>

    </SPAN>
<SPAN id='fin_but' CLASS='plain text' style='float: none; width: 100px; display: inline-block;' onMouseover='do_hover(this.id);' onMouseout='do_plain(this.id);' onClick="window.close();"><SPAN STYLE='float: left;'><?php print get_text("Cancel");?></SPAN><IMG STYLE='float: right;' SRC='./images/cancel_small.png' BORDER=0></SPAN><BR />
</BODY>
</HTML>