paul/admin/infotype_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>Information Type 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 information type descr. field
        $infotype = lookupField("infotype", "infotype_id", $infotype_id, "infotype");

        printf("<center>\n");
        printf("<h3>Information Type '%s' (#%d) used on the following RQS Pages:</h3>", $infotype, $infotype_id);

        /*************************
        ** RQS Usage Drilldowns **
        *************************/
        
        printf("<table width = \"75%%\" border=\"1\"><tr>\n");
        printf("<td width=\"40%%\" class=\"cellPlain\">RQS Subject Page(s)</td>\n");
        printf("<td width=\"20%%\" class=\"cellPlain\">Resource</td>\n");       
        printf("<td width=\"20%%\" class=\"cellPlain\">Edit</td>\n");   
        printf("</tr>\n");

        // Build the query
        $sql = "SELECT DISTINCT
                i.infotype,
                s.subject,
                s.subject_id,
                r.title

                FROM
                infotype i
                LEFT JOIN res_sub_infotype rsi using (infotype_id)
                LEFT JOIN subject s on rsi.subject_id = s.subject_id            
                LEFT JOIN resource r on rsi.resource_id = r.resource_id

                WHERE s.subject_id > 0 AND i.infotype_id = "
                . $infotype_id
                . " ORDER BY s.subject";

        // Initialize counter
        $rowcount = 0;

        $rs = mysql_tryquery($sql);

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

                // Make every other row colored
                if ($rowcount % 2 == 0) $color = " class=\"backLight\" ";
                else $color = "";

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

        /*****************************
        ** Summary of Resource uses **
        *****************************/
        
        printf("<tr><td colspan=\"2\" align=\"right\" class=\"backLight\">Total RQS Uses:</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");

        // Resources with this base infotype
        printf("<h3>Information Type '%s' (#%d) is associated with the following Resources:</h3>", $infotype, $infotype_id);
        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
                r.resource_id,
                r.title

                FROM
                resource r

                WHERE r.infotype_id = "
                . $infotype_id
                . " ORDER BY r.title";

        // Initialize counter
        $rowcount = 0;

        $rs = mysql_tryquery($sql);

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

                // Make every other row colored
                if ($rowcount % 2 == 0) $color = " class=\"backLight\" ";
                else $color = "";

                // New row
                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 occurences in resources
        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	<?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>Information Type 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
55	// Fetch the information type descr. field
56	$infotype = lookupField("infotype", "infotype_id", $infotype_id, "infotype");
57
58	printf("<center>\n");
59	printf("<h3>Information Type '%s' (#%d) used on the following RQS Pages:</h3>", $infotype, $infotype_id);
60
61	/*************************
62	RQS Usage Drilldowns
63	*************************/
64
65	printf("<table width = \"75%%\" border=\"1\"><tr>\n");
66	printf("<td width=\"40%%\" class=\"cellPlain\">RQS Subject Page(s)</td>\n");
67	printf("<td width=\"20%%\" class=\"cellPlain\">Resource</td>\n");
68	printf("<td width=\"20%%\" class=\"cellPlain\">Edit</td>\n");
69	printf("</tr>\n");
70
71	// Build the query
72	$sql = "SELECT DISTINCT
73	i.infotype,
74	s.subject,
75	s.subject_id,
76	r.title
77
78	FROM
79	infotype i
80	LEFT JOIN res_sub_infotype rsi using (infotype_id)
81	LEFT JOIN subject s on rsi.subject_id = s.subject_id
82	LEFT JOIN resource r on rsi.resource_id = r.resource_id
83
84	WHERE s.subject_id > 0 AND i.infotype_id = "
85	. $infotype_id
86	. " ORDER BY s.subject";
87
88	// Initialize counter
89	$rowcount = 0;
90
91	$rs = mysql_tryquery($sql);
92
93	// Cycle through the result set
94	while ( $row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
95	$subject = Trim($row["subject"]);
96	$subject_id = Trim($row["subject_id"]);
97	$title = Trim($row["title"]);
98
99	// Make every other row colored
100	if ($rowcount % 2 == 0) $color = " class=\"backLight\" ";
101	else $color = "";
102
103	// New row
104	printf("<tr>\n");
105	printf("<td %s>%s</td>\n", $color, $subject);
106	printf("<td %s>%s</td>\n", $color, $title);
107	printf("<td %s><a href=\"subject_builder.phtml?subject_id=%d\">Edit</a></td>\n", $color, $subject_id);
108	printf("</tr>\n");
109
110	// Increment counter
111	$rowcount++;
112	}
113
114	/*****************************
115	Summary of Resource uses
116	*****************************/
117
118	printf("<tr><td colspan=\"2\" align=\"right\" class=\"backLight\">Total RQS Uses:</td>\n");
119	if (mysql_num_rows($rs) == 0) printf("<td class=\"backLight\">(None)</td>\n");
120	else printf("<td class=\"backLight\">%d</td>\n", mysql_num_rows($rs));
121	printf("</tr>\n");
122
123	// Close table
124	printf("</table><br><br>\n");
125
126	// Resources with this base infotype
127	printf("<h3>Information Type '%s' (#%d) is associated with the following Resources:</h3>", $infotype, $infotype_id);
128	printf("<table width = \"75%%\" border=\"1\"><tr>\n");
129	printf("<td width=\"80%%\" class=\"cellPlain\">Resource</td>\n");
130	printf("<td width=\"20%%\" class=\"cellPlain\">Edit</td>\n");
131	printf("</tr>\n");
132
133	// Build the query
134	$sql = "SELECT
135	r.resource_id,
136	r.title
137
138	FROM
139	resource r
140
141	WHERE r.infotype_id = "
142	. $infotype_id
143	. " ORDER BY r.title";
144
145	// Initialize counter
146	$rowcount = 0;
147
148	$rs = mysql_tryquery($sql);
149
150	// Cycle through the result set
151	while ( $row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
152	$resource_id = Trim($row["resource_id"]);
153	$title = Trim($row["title"]);
154
155	// Make every other row colored
156	if ($rowcount % 2 == 0) $color = " class=\"backLight\" ";
157	else $color = "";
158
159	// New row
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 occurences in resources
170	printf("<tr><td align=\"right\" class=\"backLight\">Total associated Resources:</td>\n");
171	if (mysql_num_rows($rs) == 0) printf("<td class=\"backLight\">(None)</td>\n");
172	else printf("<td class=\"backLight\">%d</td>\n", mysql_num_rows($rs));
173	printf("</tr>\n");
174
175	// Close table
176	printf("</table><br><br>\n");
177
178	// Link to return to admin console
179	adminReturn($sess_access_level);
180
181	} // logged in
182
183	// No access page
184	else require_once ($GLOBAL_NO_ACCESS);
185
186
187	// Page footer
188	require_once ($GLOBAL_ADMIN_FOOTER);
189	?>
190
191	</body>
192	</html>
193