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


// 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 >= 20) {

        // Fetch the mastersubject descr. field
        $mastersubject = lookupField("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 = xx_tryquery($sql);

        // Initialize counter
        $rowcount = 0;

        // Cycle through the result set
        while ( $row = xx_fetch_array ($rs, xx_ASSOC)) {
                $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 (xx_num_rows($rs) == 0) printf("<td class=\"backLight\">(None)</td>\n");
        else printf("<td class=\"backLight\">%d</td>\n", xx_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 = xx_tryquery($sql);

        // Initialize counter
        $rowcount = 0;

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