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	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	dpavlin	73	require_once ("db_connect.php");
9	dpavlin	1	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	dpavlin	72	// 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	dpavlin	1	// 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	dpavlin	72	$rs = xx_tryquery($sql);
104	dpavlin	1
105	dpavlin	72	while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
106	dpavlin	1
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	dpavlin	72	printf("<tr><td colspan=\"5\" align=\"center\"><br><b>Total Rows: %d</b><br><br></td></tr>\n", $rowcount);
186	dpavlin	1	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>