trunk/admin/mastersubject_drill.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>Master Subject Drilldown</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 >= 20) {

        // Fetch the mastersubject descr. field
        $mastersubject = lookupField($con, "mastersubject", "mastersubject_id", $mastersubject_id, "mastersubject");

        printf("<center>\n");
        printf("<h3>Master Subject '%s' (#%d) contains the following Subjects:</h3>", $mastersubject, $mastersubject_id);


        /*************************
        ** Subject dependencies **
        *************************/
        
        printf("<table width = \"75%%\" border=\"1\"><tr>\n");
        printf("<td width=\"80%%\" class=\"cellPlain\">Subject</td>\n");        
        printf("<td width=\"20%%\" class=\"cellPlain\">Edit</td>\n");   
        printf("</tr>\n");

        // Build the query
        $sql = "SELECT DISTINCT
                s.subject_id,
                s.subject,
                sm.mastersubject_id

                FROM
                subject s
                
                LEFT JOIN sub_mastersubject sm using (subject_id)

                WHERE s.subject_id > 0 AND sm.mastersubject_id = "
                . $mastersubject_id
                . " ORDER BY s.subject";

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

        $rs = mysql_query($sql, $con);

        // Initialize counter
        $rowcount = 0;

        // Cycle through the result set
        while ( $row = mysql_fetch_array ( $rs ) ) {
                $subject_id = Trim($row["subject_id"]);
                $subject = Trim($row["subject"]);

                // New row
                if ($rowcount % 2 == 0) $color = " class=\"backLight\" ";
                else $color ="";

                printf("<tr>\n");
                printf("<td %s>%s</td>\n", $color, $subject);
                printf("<td %s><a href=\"operation.phtml?operation=Edit&table=subject&key_id=%d\">Edit</a></td>\n", $color, $subject_id);
                printf("</tr>\n");
                
                // Increment counter
                $rowcount++;            
        }

        // Summary of RQS page uses
        printf("<tr><td align=\"right\" class=\"backLight\">Total contained Subjects:</td>\n");
        if (mysql_num_rows($rs) == 0) printf("<td class=\"backLight\">(None)</td>\n");
        else printf("<td class=\"backLight\">%d</td>\n", mysql_num_rows($rs));
        printf("</tr>\n");

        // Close table
        printf("</table><br><br>\n");


        printf("<h3>Master Subject '%s' (#%d) is associated with the following Resources:</h3>", $mastersubject, $mastersubject_id);


        // Resource dependencies
        printf("<table width = \"75%%\" border=\"1\"><tr>\n");
        printf("<td width=\"80%%\" class=\"cellPlain\">Resource</td>\n");       
        printf("<td width=\"20%%\" class=\"cellPlain\">Edit</td>\n");   
        printf("</tr>\n");

        // Build the query
        $sql = "SELECT DISTINCT
                r.resource_id,
                r.title,
                rm.mastersubject_id

                FROM
                resource r
                
                LEFT JOIN res_mastersubject rm using (resource_id)

                WHERE r.resource_id > 0 AND rm.mastersubject_id = "
                . $mastersubject_id
                . " ORDER BY r.title";

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

        $rs = mysql_query($sql, $con);

        // Initialize counter
        $rowcount = 0;

        // Cycle through the result set
        while ( $row = mysql_fetch_array ( $rs ) ) {
                $resource_id = Trim($row["resource_id"]);
                $title = Trim($row["title"]);

                // New row
                if ($rowcount % 2 == 0) $color = " class=\"backLight\" ";
                else $color ="";

                printf("<tr>\n");
                printf("<td %s>%s</td>\n", $color, $title);
                printf("<td %s><a href=\"operation.phtml?operation=Edit&table=resource&key_id=%d\">Edit</a></td>\n", $color, $resource_id);
                printf("</tr>\n");
                
                // Increment counter
                $rowcount++;            
        }

        // Summary of RQS page uses
        printf("<tr><td align=\"right\" class=\"backLight\">Total associated Resources:</td>\n");
        if (mysql_num_rows($rs) == 0) printf("<td class=\"backLight\">(None)</td>\n");
        else printf("<td class=\"backLight\">%d</td>\n", mysql_num_rows($rs));
        printf("</tr>\n");

        // Close table
        printf("</table><br><br>\n");


        // 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>Master Subject Drilldown</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			// If the cookie is set and access level is appropriate
42			if(isset($libsession) && $sess_access_level >= 20) {
43
44			// Fetch the mastersubject descr. field
45			$mastersubject = lookupField($con, "mastersubject", "mastersubject_id", $mastersubject_id, "mastersubject");
46
47			printf("<center>\n");
48			printf("<h3>Master Subject '%s' (#%d) contains the following Subjects:</h3>", $mastersubject, $mastersubject_id);
49
50
51			/*************************
52			Subject dependencies
53			*************************/
54
55			printf("<table width = \"75%%\" border=\"1\"><tr>\n");
56			printf("<td width=\"80%%\" class=\"cellPlain\">Subject</td>\n");
57			printf("<td width=\"20%%\" class=\"cellPlain\">Edit</td>\n");
58			printf("</tr>\n");
59
60			// Build the query
61			$sql = "SELECT DISTINCT
62			s.subject_id,
63			s.subject,
64			sm.mastersubject_id
65
66			FROM
67			subject s
68
69			LEFT JOIN sub_mastersubject sm using (subject_id)
70
71			WHERE s.subject_id > 0 AND sm.mastersubject_id = "
72			. $mastersubject_id
73			. " ORDER BY s.subject";
74
75			// printf("sql was: %s<BR>\n", $sql);
76
77			$rs = mysql_query($sql, $con);
78
79			// Initialize counter
80			$rowcount = 0;
81
82			// Cycle through the result set
83			while ( $row = mysql_fetch_array ( $rs ) ) {
84			$subject_id = Trim($row["subject_id"]);
85			$subject = Trim($row["subject"]);
86
87			// New row
88			if ($rowcount % 2 == 0) $color = " class=\"backLight\" ";
89			else $color ="";
90
91			printf("<tr>\n");
92			printf("<td %s>%s</td>\n", $color, $subject);
93			printf("<td %s><a href=\"operation.phtml?operation=Edit&table=subject&key_id=%d\">Edit</a></td>\n", $color, $subject_id);
94			printf("</tr>\n");
95
96			// Increment counter
97			$rowcount++;
98			}
99
100			// Summary of RQS page uses
101			printf("<tr><td align=\"right\" class=\"backLight\">Total contained Subjects:</td>\n");
102			if (mysql_num_rows($rs) == 0) printf("<td class=\"backLight\">(None)</td>\n");
103			else printf("<td class=\"backLight\">%d</td>\n", mysql_num_rows($rs));
104			printf("</tr>\n");
105
106			// Close table
107			printf("</table><br><br>\n");
108
109
110			printf("<h3>Master Subject '%s' (#%d) is associated with the following Resources:</h3>", $mastersubject, $mastersubject_id);
111
112
113			// Resource dependencies
114			printf("<table width = \"75%%\" border=\"1\"><tr>\n");
115			printf("<td width=\"80%%\" class=\"cellPlain\">Resource</td>\n");
116			printf("<td width=\"20%%\" class=\"cellPlain\">Edit</td>\n");
117			printf("</tr>\n");
118
119			// Build the query
120			$sql = "SELECT DISTINCT
121			r.resource_id,
122			r.title,
123			rm.mastersubject_id
124
125			FROM
126			resource r
127
128			LEFT JOIN res_mastersubject rm using (resource_id)
129
130			WHERE r.resource_id > 0 AND rm.mastersubject_id = "
131			. $mastersubject_id
132			. " ORDER BY r.title";
133
134			// printf("sql was: %s<BR>\n", $sql);
135
136			$rs = mysql_query($sql, $con);
137
138			// Initialize counter
139			$rowcount = 0;
140
141			// Cycle through the result set
142			while ( $row = mysql_fetch_array ( $rs ) ) {
143			$resource_id = Trim($row["resource_id"]);
144			$title = Trim($row["title"]);
145
146			// New row
147			if ($rowcount % 2 == 0) $color = " class=\"backLight\" ";
148			else $color ="";
149
150			printf("<tr>\n");
151			printf("<td %s>%s</td>\n", $color, $title);
152			printf("<td %s><a href=\"operation.phtml?operation=Edit&table=resource&key_id=%d\">Edit</a></td>\n", $color, $resource_id);
153			printf("</tr>\n");
154
155			// Increment counter
156			$rowcount++;
157			}
158
159			// Summary of RQS page uses
160			printf("<tr><td align=\"right\" class=\"backLight\">Total associated Resources:</td>\n");
161			if (mysql_num_rows($rs) == 0) printf("<td class=\"backLight\">(None)</td>\n");
162			else printf("<td class=\"backLight\">%d</td>\n", mysql_num_rows($rs));
163			printf("</tr>\n");
164
165			// Close table
166			printf("</table><br><br>\n");
167
168
169			// Link to return to admin console
170			adminReturn($sess_access_level);
171
172			} // logged in
173
174			// No access page
175			else require_once ($GLOBAL_NO_ACCESS);
176
177
178			// Page footer
179			require_once ($GLOBAL_ADMIN_FOOTER);
180			?>
181
182			</body>
183			</html>
184