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 ("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");


// Default access settings
$sess_time_human = "";
$sess_staff_account = "";
$sess_staff_id = 0;
$sess_access_level = 0;
$sess_access = "";
$sess_last_name = "";
$sess_first_name = "";


// 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";

        $rs = xx_tryquery($sql);
        
        while ($row = xx_fetch_array ($rs, xx_ASSOC)) {

                // 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\" 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	<?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 ("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	// 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 >= 100) {
56	?>
57
58	<body>
59
60	<h3>RQS Staff Assignments</h3>
61	<br><br>
62
63
64	<center>
65	<table border="1" width="95%">
66	<tr>
67	<td class="cellPlain">RQS Subject</td>
68	<td class="cellPlain">Created</td>
69	<td class="cellPlain">Updated</td>
70	<td class="cellPlain">Public?</td>
71	<td class="cellPlain">Assigned Staff</td>
72	</tr>
73
74
75
76	<?php
77	// Initialize
78	$rowcount = 0;
79
80	// Build the SQL
81	$sql = "SELECT
82	s.subject_id,
83	s.subject,
84	s.rqs_date_created,
85	s.rqs_date_modified,
86	s.rqs_account_created,
87	s.rqs_account_modified,
88	s.rqs_published,
89	f.staff_id,
90	f.last_name,
91	f.first_name,
92	f.staff_account
93	FROM
94	subject s
95	LEFT JOIN sub_staff ss using (subject_id)
96	LEFT JOIN staff f on ss.staff_id = f.staff_id
97	WHERE s.subject_id > 1
98	ORDER BY
99	s.subject,
100	f.last_name,
101	f.first_name";
102
103	$rs = xx_tryquery($sql);
104
105	while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
106
107	// Increment counter
108	$rowcount++;
109
110	// Make every other third row colored
111	if ($rowcount % 3 == 0) $color = " class=\"backLight\" ";
112	else $color = "";
113
114	$subject = $row["subject"];
115	$subject_id = $row["subject_id"];
116	$rqs_date_created = $row["rqs_date_created"];
117	$rqs_date_modified = $row["rqs_date_modified"];
118	$rqs_account_created = $row["rqs_account_created"];
119	$rqs_account_modified = $row["rqs_account_modified"];
120	$rqs_published = $row["rqs_published"];
121
122	$staff_id = $row["staff_id"];
123	$staff_account = $row["staff_account"];
124	$last_name = $row["last_name"];
125	$first_name = $row["first_name"];
126
127	// Cleanup. Don't display hours, minutes, etc. on this summary page
128	if (strlen($rqs_date_created) > 10) $rqs_date_created = substr($rqs_date_created, 0, 10);
129	if (strlen($rqs_date_modified) > 10) $rqs_date_modified = substr($rqs_date_modified, 0, 10);
130
131
132	$subject_link = "<a href=\"operation.phtml?operation=Edit&table=subject&key_id="
133	. $subject_id
134	. "\"><b>"
135	. $subject
136	."</b></a>";
137
138	$staff_link = "<a href=\"operation.phtml?operation=Edit&table=staff&staff_id="
139	. $staff_id
140	. "\"><b>"
141	. $last_name . ", " . $first_name . " (" . $staff_account . ")"
142	."</b></a>";
143
144	printf("<tr>\n");
145
146
147	// Check flag
148	if ($subject_id != $last_subject_id) $new_sub = 1;
149	else $new_sub = 0;
150
151
152	// Subject
153	if ($new_sub) printf("<td>%s</td>\n", $subject_link);
154	else printf("<td> </td>\n");
155
156	// Created
157	if ($new_sub) printf("<td>%s (%s)</td>\n", $rqs_date_created, $rqs_account_created);
158	else printf("<td> </td>\n");
159
160	// Updated
161	if ($new_sub) printf("<td>%s (%s)</td>\n", $rqs_date_modified, $rqs_account_modified);
162	else printf("<td> </td>\n");
163
164	// Published
165	if ($new_sub) {
166	printf("<td>");
167	if ($rqs_published == "1") printf("Y");
168	else printf("N");
169	printf("</td>\n");
170	}
171	else printf("<td> </td>\n");
172
173	// Assigned staff
174	if ($staff_id > 0) printf("<td>%s</td>\n", $staff_link);
175	else printf("<td>(none)</td>\n");
176
177
178	printf("</tr>\n");
179
180	$last_subject_id = $subject_id;
181
182
183	};
184
185	printf("<tr><td colspan=\"5\" align=\"center\"><br><b>Total Rows: %d</b><br><br></td></tr>\n", $rowcount);
186	printf("</table>");
187
188	// Link to return to admin console
189	adminReturn($sess_access_level);
190
191	} // logged in
192
193	// No access page
194	else require_once ($GLOBAL_NO_ACCESS);
195
196
197	// Page footer
198	require_once ($GLOBAL_ADMIN_FOOTER);
199	?>
200
201	</body>
202	</html>