/[libdata]/trunk/admin/rqscip_crosswalk.phtml
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Contents of /trunk/admin/rqscip_crosswalk.phtml

Parent Directory Parent Directory | Revision Log Revision Log


Revision 72 - (show annotations)
Thu Mar 18 20:33:37 2004 UTC (20 years ago) by dpavlin
File size: 3516 byte(s)
changes made in version 2.00

1 <?php
2 // Load globals
3 require_once ("global_vars.php");
4
5 // Includes
6 require_once ($GLOBAL_ADMIN_INC."sessionClass.php");
7 require_once ($GLOBAL_ADMIN_INC."accessClass.php");
8 require_once ($GLOBAL_ADMIN_INC."db_connect.php");
9 require_once ($GLOBAL_ADMIN_INC."app_controls.php");
10
11
12 // HTML header
13 printf("<HTML>\n");
14 printf("<HEAD>\n");
15 printf("<title>RQS Subject <-> CIP Code Crosswalk</title>\n");
16 printf("<link rel=\"stylesheet\" href=\"%s\" type=\"text/css\">\n", $GLOBAL_ADMIN_CSS);
17 printf("</HEAD>\n");
18
19
20 // Default access settings
21 $sess_time_human = "";
22 $sess_staff_account = "";
23 $sess_staff_id = 0;
24 $sess_access_level = 0;
25 $sess_access = "";
26 $sess_last_name = "";
27 $sess_first_name = "";
28
29
30 // Page header
31 require_once ($GLOBAL_ADMIN_HEADER);
32
33
34 // Collect access information
35 if(isset($libsession)) {
36
37 // Fetch session information
38 $sessionClass = new sessionClass("", $libsession, "", "");
39 $accessClass = new accessClass($sessionClass);
40
41 // Load user session variables
42 $sess_time_human = $sessionClass->time_human;
43 $sess_staff_account = $sessionClass->staff_account;
44 $sess_access_level = $accessClass->access_level;
45 $sess_access = $accessClass->access;
46 $sess_last_name = $accessClass->last_name;
47 $sess_first_name = $accessClass->first_name;
48
49 }
50
51
52
53
54 // If the cookie is set and access level is appropriate
55 if(isset($libsession) && $sess_access_level == 1000) {
56 ?>
57
58
59
60 <body>
61
62 <h3>RQS Subject <-> CIP Code Crosswalk</h3>
63 <br><br>
64
65
66 <center>
67 <table border="1" width="80%">
68 <tr>
69 <td class="cellPlain">RQS Subject</td>
70 <td class="cellPlain">Associated Course Subjects / CIP Code(s)</td>
71 </tr>
72
73
74
75 <?php
76
77
78
79
80 $rowcount = 0;
81 $sql = "SELECT s.subject_id, s.subject, c.coursesub_id, c.coursesub, c.coursesub_descr, c.cip_code
82 FROM subject s
83 LEFT JOIN sub_coursesub sc on s.subject_id = sc.subject_id
84 LEFT JOIN coursesub c on sc.coursesub_id = c.coursesub_id
85 WHERE s.subject_id > 1
86 ORDER BY s.subject";
87
88 $rs = xx_tryquery($sql);
89
90 while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
91
92 // Increment counter
93 $rowcount++;
94
95 // Make every other third row colored
96 if ($rowcount % 3 == 0) $color = " class=\"backLight\" ";
97 else $color = "";
98
99 $subject = $row["subject"];
100 $coursesub = $row["coursesub"];
101 $subject_id = $row["subject_id"];
102 $coursesub_id = $row["coursesub_id"];
103 $coursesub_descr = $row["coursesub_descr"];
104 $cip_code = $row["cip_code"];
105
106 $subject_link = "<a href=\"operation.phtml?operation=Edit&table=subject&key_id="
107 . $subject_id
108 . "\"><b>"
109 . $subject
110 ."</b></a>";
111
112 $coursesub_link = "<a href=\"operation.phtml?operation=Edit&table=coursesub&coursesub_id="
113 . $coursesub_id
114 . "\"><b>"
115 . $coursesub
116 ."</b></a>";
117
118 printf("<tr>\n");
119
120 if ($subject_id != $last_subject_id) printf("<td>%s</td>\n", $subject_link);
121 else printf("<td>&nbsp;</td>\n");
122
123 if (strlen($cip_code) > 0) printf("<td>%s | %s [%s]</td>\n", $coursesub_link, $coursesub_descr, $cip_code);
124 else printf("<td>(none)</td>\n");
125
126
127 printf("</tr>\n");
128
129 $last_subject_id = $subject_id;
130
131
132 };
133
134 printf("<tr><td colspan=\"2\" class=\"backLight\" align=\"center\"><br><br><b>Total Maps: %d</b><br><br></td></tr>\n", $rowcount);
135 printf("</table>");
136
137 // Link to return to admin console
138 adminReturn($sess_access_level);
139
140 } // logged in
141
142 // No access page
143 else require_once ($GLOBAL_NO_ACCESS);
144
145
146 // Page footer
147 require_once ($GLOBAL_ADMIN_FOOTER);
148 ?>
149
150 </body>
151 </html>

  ViewVC Help
Powered by ViewVC 1.1.26