You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
144 lines
5.7 KiB
144 lines
5.7 KiB
<?php
|
|
require('../../../includes/prepend.inc.php');
|
|
$intDatabaseIndex = $_POST['intDatabaseIndex'];
|
|
$strProfileData = $_POST['strProfileData'];
|
|
$strReferrer = $_POST['strReferrer'];
|
|
|
|
$objProfileArray = unserialize(base64_decode($strProfileData));
|
|
$objProfileArray = QType::Cast($objProfileArray, QType::ArrayType);
|
|
if ((count($objProfileArray) % 2) != 0)
|
|
throw new Exception('Database Profiling data appears to have been corrupted.');
|
|
?>
|
|
<html>
|
|
<head>
|
|
<title>Qcodo Development Framework - Database Profiling Tool</title>
|
|
<style>
|
|
body { font-family: 'Arial' 'Helvetica' 'sans-serif'; font-size: 14px; }
|
|
a:link, a:visited { text-decoration: none; }
|
|
a:hover { text-decoration: underline; }
|
|
|
|
pre { font-family: 'Lucida Console' 'Courier New' 'Courier' 'monospaced'; font-size: 11px; line-height: 13px; }
|
|
.page { padding: 10px; }
|
|
|
|
.headingLeft {
|
|
background-color: #446644;
|
|
color: #ffffff;
|
|
padding: 10px 0px 10px 10px;
|
|
font-family: 'Verdana' 'Arial' 'Helvetica' 'sans-serif';
|
|
font-size: 18px;
|
|
font-weight: bold;
|
|
width: 70%;
|
|
vertical-align: middle;
|
|
}
|
|
.headingLeftSmall { font-size: 10px; }
|
|
.headingRight {
|
|
background-color: #446644;
|
|
color: #ffffff;
|
|
padding: 0px 10px 10px 10px;
|
|
font-family: 'Verdana' 'Arial' 'Helvetica' 'sans-serif';
|
|
font-size: 10px;
|
|
width: 30%;
|
|
vertical-align: middle;
|
|
text-align: right;
|
|
}
|
|
.title { font-family: 'Verdana' 'Arial' 'Helvetica' 'sans-serif'; font-size: 19px; font-style: italic; color: #330055; }
|
|
.code { background-color: #f4eeff; padding: 1px 10px 1px 10px; }
|
|
|
|
.function { font-family: 'Verdana' 'Arial' 'Helvetica' 'sans-serif'; font-size: 12px; font-weight: bold; }
|
|
.function_details { font-family: 'Verdana' 'Arial' 'Helvetica' 'sans-serif'; font-size: 10px; color: #777777; }
|
|
</style>
|
|
<script type="text/javascript">
|
|
function Toggle(spanId) {
|
|
var obj = document.getElementById(spanId);
|
|
|
|
if (obj) {
|
|
if (obj.style.display == "block") {
|
|
// Make INVISIBLE
|
|
obj.style.display = "none";
|
|
} else {
|
|
// Make VISIBLE
|
|
obj.style.display = "block";
|
|
}
|
|
}
|
|
}
|
|
|
|
function ShowAll() {
|
|
for (var intIndex = 1; intIndex < <?php _p(count($objProfileArray)); ?>; intIndex = intIndex + 2) {
|
|
var obj = document.getElementById('query' + intIndex);
|
|
obj.style.display = "block";
|
|
}
|
|
}
|
|
|
|
function HideAll() {
|
|
for (var intIndex = 1; intIndex < <?php _p(count($objProfileArray)); ?>; intIndex = intIndex + 2) {
|
|
var obj = document.getElementById('query' + intIndex);
|
|
obj.style.display = "none";
|
|
}
|
|
}
|
|
</script>
|
|
</head>
|
|
<body topmargin="0" leftmargin="0" marginheight="0" marginwidth="0">
|
|
|
|
<table border="0" cellspacing="0" width="100%">
|
|
<tr>
|
|
<td nowrap="nowrap" class="headingLeft"><span class="headingLeftSmall">Qcodo Development Framework <?= QCODO_VERSION ?><br /></span>Database Profiling Tool</div></td>
|
|
<td nowrap="nowrap" class="headingRight">
|
|
<b>Database Index:</b> <?php _p($intDatabaseIndex); ?>; <b>Database Type:</b> <?php _p(QApplication::$Database[$intDatabaseIndex]->Adapter); ?><br />
|
|
<b>Database Server:</b> <?php _p(QApplication::$Database[$intDatabaseIndex]->Server); ?>; <b>Database Name:</b> <?php _p(QApplication::$Database[$intDatabaseIndex]->Database); ?><br />
|
|
<b>Profile Generated From:</b> <?php _p($strReferrer); ?>
|
|
</td>
|
|
</tr>
|
|
</table><br />
|
|
|
|
<div class="page">
|
|
<?php
|
|
$intCount = count($objProfileArray) / 2;
|
|
if ($intCount == 0)
|
|
_p('<b>There were no queries that were performed.</b>', false);
|
|
else if ($intCount == 1)
|
|
_p('<b>There was 1 query that was performed.</b>', false);
|
|
else
|
|
printf('<b>There were %s queries that were performed.</b>', $intCount);
|
|
?>
|
|
<br />
|
|
<a href="javascript: ShowAll()" class="function_details">Show All</a>
|
|
|
|
|
<a href="javascript: HideAll()" class="function_details">Hide All</a>
|
|
<br /><br /><br />
|
|
<?php
|
|
for ($intIndex = 0; $intIndex < count($objProfileArray); $intIndex++) {
|
|
if ((count($objProfileArray[$intIndex]) > 3) &&
|
|
(array_key_exists('function', $objProfileArray[$intIndex][2])) &&
|
|
(($objProfileArray[$intIndex][2]['function'] == 'QueryArray') ||
|
|
($objProfileArray[$intIndex][2]['function'] == 'QuerySingle') ||
|
|
($objProfileArray[$intIndex][2]['function'] == 'QueryCount')))
|
|
$objDebugBacktrace = $objProfileArray[$intIndex][3];
|
|
else
|
|
$objDebugBacktrace = $objProfileArray[$intIndex][2];
|
|
$intIndex++;
|
|
$strQuery = $objProfileArray[$intIndex];
|
|
|
|
$objArgs = (array_key_exists('args', $objDebugBacktrace)) ? $objDebugBacktrace['args'] : array();
|
|
$strClass = (array_key_exists('class', $objDebugBacktrace)) ? $objDebugBacktrace['class'] : null;
|
|
$strType = (array_key_exists('type', $objDebugBacktrace)) ? $objDebugBacktrace['type'] : null;
|
|
$strFunction = (array_key_exists('function', $objDebugBacktrace)) ? $objDebugBacktrace['function'] : null;
|
|
$strFile = (array_key_exists('file', $objDebugBacktrace)) ? $objDebugBacktrace['file'] : null;
|
|
$strLine = (array_key_exists('line', $objDebugBacktrace)) ? $objDebugBacktrace['line'] : null;
|
|
?>
|
|
<span class="function">
|
|
Called by <?php _p($strClass . $strType . $strFunction . '(' . implode(', ', $objArgs) . ')'); ?>
|
|
</span>
|
|
|
|
|
<a href="javascript: Toggle('query<?php _p($intIndex); ?>')" class="function_details">Show/Hide</a>
|
|
<br />
|
|
<span class="function_details"><b>File: </b><?php _p($strFile); ?>; <b>Line: </b><?php _p($strLine); ?>
|
|
</span><br />
|
|
<div class="code" id="query<?php _p($intIndex); ?>" style="display: none"><pre><?php _p($strQuery); ?></pre></div>
|
|
<br /><br />
|
|
<?php
|
|
}
|
|
?>
|
|
|
|
</div>
|
|
</body>
|
|
</html>
|