trunk/admin/rqs_staff.phtml

<?php
// Load globals
require_once ("global_vars.php");

// Includes
require_once ($GLOBAL_ADMIN_INC."sessionClass.php");
require_once ($GLOBAL_ADMIN_INC."accessClass.php");
require_once ($GLOBAL_ADMIN_INC."db_connect.php");
require_once ($GLOBAL_ADMIN_INC."app_controls.php");


// HTML header
printf("<HTML>\n");
printf("<HEAD>\n");
printf("<title>RQS Staff Assignments</title>\n");
printf("<link rel=\"stylesheet\" href=\"%s\" type=\"text/css\">\n", $GLOBAL_ADMIN_CSS);
printf("</HEAD>\n");


// Page header
require_once ($GLOBAL_ADMIN_HEADER);


// Collect access information
if(isset($libsession)) {

        // Fetch session information
        $sessionClass = new sessionClass("", $libsession, "", "");
        $accessClass = new accessClass($sessionClass);

        // Load user session variables
        $sess_time_human = $sessionClass->time_human;   
        $sess_staff_account = $sessionClass->staff_account;
        $sess_access_level = $accessClass->access_level;
        $sess_access = $accessClass->access;
        $sess_last_name = $accessClass->last_name;
        $sess_first_name = $accessClass->first_name;

}


// If the cookie is set and access level is appropriate
if(isset($libsession) && $sess_access_level >= 100) {
?>

        <body>

        <h3>RQS Staff Assignments</h3>
        <br><br>


        <center>
        <table border="1" width="95%">
                <tr>
                        <td class="cellPlain">RQS Subject</td>
                        <td class="cellPlain">Created</td>
                        <td class="cellPlain">Updated</td>
                        <td class="cellPlain">Public?</td>
                        <td class="cellPlain">Assigned Staff</td>
                </tr>


<?php
        // Initialize
        $rowcount = 0;

        // Build the SQL
        $sql = "SELECT
        s.subject_id,
        s.subject,
        s.rqs_date_created,
        s.rqs_date_modified,
        s.rqs_account_created,
        s.rqs_account_modified,
        s.rqs_published,
        f.staff_id,
        f.last_name,
        f.first_name,
        f.staff_account
        FROM
        subject s
        LEFT JOIN sub_staff ss using (subject_id)
        LEFT JOIN staff f on ss.staff_id = f.staff_id
        WHERE s.subject_id > 1
        ORDER BY
        s.subject,
        f.last_name,
        f.first_name";

        // printf("sql was: %s<BR>", $sql);

        $rs = mysql_query($sql, $con);
        
        while ($row = mysql_fetch_array ($rs)) {

                // Increment counter
                $rowcount++;
                
                // Make every other third row colored
                if ($rowcount % 3 == 0) $color = " class=\"backLight\" ";
                else $color = "";               
                
                $subject = $row["subject"];
                $subject_id = $row["subject_id"];
                $rqs_date_created = $row["rqs_date_created"];
                $rqs_date_modified = $row["rqs_date_modified"];
                $rqs_account_created = $row["rqs_account_created"];
                $rqs_account_modified = $row["rqs_account_modified"];
                $rqs_published = $row["rqs_published"];

                $staff_id = $row["staff_id"];
                $staff_account = $row["staff_account"];
                $last_name = $row["last_name"];
                $first_name = $row["first_name"];               

                // Cleanup.  Don't display hours, minutes, etc. on this summary page
                if (strlen($rqs_date_created) > 10) $rqs_date_created = substr($rqs_date_created, 0, 10);
                if (strlen($rqs_date_modified) > 10) $rqs_date_modified = substr($rqs_date_modified, 0, 10);


                $subject_link = "<a href=\"operation.phtml?operation=Edit&table=subject&key_id="
                                . $subject_id
                                . "\"><b>"
                                . $subject
                                ."</b></a>";

                $staff_link = "<a href=\"operation.phtml?operation=Edit&table=staff&staff_id="
                                . $staff_id
                                . "\"><b>"
                                . $last_name . ", " . $first_name . " (" . $staff_account . ")"
                                ."</b></a>";

                printf("<tr>\n");
                
                
                // Check flag
                if ($subject_id != $last_subject_id) $new_sub = 1;
                else $new_sub = 0;
                
                
                // Subject
                if ($new_sub) printf("<td>%s</td>\n", $subject_link);
                else printf("<td>&nbsp;</td>\n");
                
                // Created
                if ($new_sub) printf("<td>%s (%s)</td>\n", $rqs_date_created, $rqs_account_created);
                else printf("<td>&nbsp;</td>\n");
                
                // Updated
                if ($new_sub) printf("<td>%s (%s)</td>\n", $rqs_date_modified, $rqs_account_modified);
                else printf("<td>&nbsp;</td>\n");
                
                // Published
                if ($new_sub) {
                        printf("<td>");
                        if ($rqs_published == "1") printf("Y");
                        else printf("N");
                        printf("</td>\n");
                }
                else printf("<td>&nbsp;</td>\n");
                
                // Assigned staff
                if ($staff_id > 0) printf("<td>%s</td>\n", $staff_link);
                else printf("<td>(none)</td>\n");
                
                
                printf("</tr>\n");
                
                $last_subject_id = $subject_id;


        };
        
        printf("<tr><td colspan=\"5\" class=\"cellPlain\" align=\"center\"><br><b>Total Rows: %d</b><br><br></td></tr>\n", $rowcount);
        printf("</table>");
        
        // Link to return to admin console
        adminReturn($sess_access_level);

} // logged in

// No access page
else require_once ($GLOBAL_NO_ACCESS);


// Page footer
require_once ($GLOBAL_ADMIN_FOOTER);
?>

</body>
</html>
1	dpavlin	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 Staff Assignments</title>\n");
16			printf("<link rel=\"stylesheet\" href=\"%s\" type=\"text/css\">\n", $GLOBAL_ADMIN_CSS);
17			printf("</HEAD>\n");
18
19
20			// Page header
21			require_once ($GLOBAL_ADMIN_HEADER);
22
23
24			// Collect access information
25			if(isset($libsession)) {
26
27			// Fetch session information
28			$sessionClass = new sessionClass("", $libsession, "", "");
29			$accessClass = new accessClass($sessionClass);
30
31			// Load user session variables
32			$sess_time_human = $sessionClass->time_human;
33			$sess_staff_account = $sessionClass->staff_account;
34			$sess_access_level = $accessClass->access_level;
35			$sess_access = $accessClass->access;
36			$sess_last_name = $accessClass->last_name;
37			$sess_first_name = $accessClass->first_name;
38
39			}
40
41
42
43
44			// If the cookie is set and access level is appropriate
45			if(isset($libsession) && $sess_access_level >= 100) {
46			?>
47
48			<body>
49
50			<h3>RQS Staff Assignments</h3>
51			<br><br>
52
53
54			<center>
55			<table border="1" width="95%">
56			<tr>
57			<td class="cellPlain">RQS Subject</td>
58			<td class="cellPlain">Created</td>
59			<td class="cellPlain">Updated</td>
60			<td class="cellPlain">Public?</td>
61			<td class="cellPlain">Assigned Staff</td>
62			</tr>
63
64
65
66			<?php
67			// Initialize
68			$rowcount = 0;
69
70			// Build the SQL
71			$sql = "SELECT
72			s.subject_id,
73			s.subject,
74			s.rqs_date_created,
75			s.rqs_date_modified,
76			s.rqs_account_created,
77			s.rqs_account_modified,
78			s.rqs_published,
79			f.staff_id,
80			f.last_name,
81			f.first_name,
82			f.staff_account
83			FROM
84			subject s
85			LEFT JOIN sub_staff ss using (subject_id)
86			LEFT JOIN staff f on ss.staff_id = f.staff_id
87			WHERE s.subject_id > 1
88			ORDER BY
89			s.subject,
90			f.last_name,
91			f.first_name";
92
93			// printf("sql was: %s<BR>", $sql);
94
95			$rs = mysql_query($sql, $con);
96
97			while ($row = mysql_fetch_array ($rs)) {
98
99			// Increment counter
100			$rowcount++;
101
102			// Make every other third row colored
103			if ($rowcount % 3 == 0) $color = " class=\"backLight\" ";
104			else $color = "";
105
106			$subject = $row["subject"];
107			$subject_id = $row["subject_id"];
108			$rqs_date_created = $row["rqs_date_created"];
109			$rqs_date_modified = $row["rqs_date_modified"];
110			$rqs_account_created = $row["rqs_account_created"];
111			$rqs_account_modified = $row["rqs_account_modified"];
112			$rqs_published = $row["rqs_published"];
113
114			$staff_id = $row["staff_id"];
115			$staff_account = $row["staff_account"];
116			$last_name = $row["last_name"];
117			$first_name = $row["first_name"];
118
119			// Cleanup. Don't display hours, minutes, etc. on this summary page
120			if (strlen($rqs_date_created) > 10) $rqs_date_created = substr($rqs_date_created, 0, 10);
121			if (strlen($rqs_date_modified) > 10) $rqs_date_modified = substr($rqs_date_modified, 0, 10);
122
123
124			$subject_link = "<a href=\"operation.phtml?operation=Edit&table=subject&key_id="
125			. $subject_id
126			. "\"><b>"
127			. $subject
128			."</b></a>";
129
130			$staff_link = "<a href=\"operation.phtml?operation=Edit&table=staff&staff_id="
131			. $staff_id
132			. "\"><b>"
133			. $last_name . ", " . $first_name . " (" . $staff_account . ")"
134			."</b></a>";
135
136			printf("<tr>\n");
137
138
139			// Check flag
140			if ($subject_id != $last_subject_id) $new_sub = 1;
141			else $new_sub = 0;
142
143
144			// Subject
145			if ($new_sub) printf("<td>%s</td>\n", $subject_link);
146			else printf("<td> </td>\n");
147
148			// Created
149			if ($new_sub) printf("<td>%s (%s)</td>\n", $rqs_date_created, $rqs_account_created);
150			else printf("<td> </td>\n");
151
152			// Updated
153			if ($new_sub) printf("<td>%s (%s)</td>\n", $rqs_date_modified, $rqs_account_modified);
154			else printf("<td> </td>\n");
155
156			// Published
157			if ($new_sub) {
158			printf("<td>");
159			if ($rqs_published == "1") printf("Y");
160			else printf("N");
161			printf("</td>\n");
162			}
163			else printf("<td> </td>\n");
164
165			// Assigned staff
166			if ($staff_id > 0) printf("<td>%s</td>\n", $staff_link);
167			else printf("<td>(none)</td>\n");
168
169
170			printf("</tr>\n");
171
172			$last_subject_id = $subject_id;
173
174
175			};
176
177			printf("<tr><td colspan=\"5\" class=\"cellPlain\" align=\"center\"><br><b>Total Rows: %d</b><br><br></td></tr>\n", $rowcount);
178			printf("</table>");
179
180			// Link to return to admin console
181			adminReturn($sess_access_level);
182
183			} // logged in
184
185			// No access page
186			else require_once ($GLOBAL_NO_ACCESS);
187
188
189			// Page footer
190			require_once ($GLOBAL_ADMIN_FOOTER);
191			?>
192
193			</body>
194			</html>