/details/data_dynatrace.php

https://github.com/ryandoherty/showslow · PHP · 138 lines · 118 code · 20 blank · 0 comment · 22 complexity · 4fb5f36b1d8c7cc37d5e18a07b2f9490 MD5 · raw file 

    

  1. <?php 
    2. 

  2. require_once(dirname(dirname(__FILE__)).'/global.php');
    3. 

  3. 

  4. if (!array_key_exists('urlid', $_GET) || filter_var($_GET['urlid'], FILTER_VALIDATE_INT) === false) {
    5. 

  5. 	header('HTTP/1.0 400 Bad Request');
    6. 

  6. 

  7. 	?><html>
    8. 

  8. <head>
    9. 

  9. <title>Bad Request: no valid urlid specified</title>
    10. 

  10. </head>
    11. 

  11. <body>
    12. 

  12. <h1>Bad Request: no valid urld specified</h1>
    13. 

  13. <p>You must pass valid URL ID as 'urlid' parameter</p>
    14. 

  14. </body></html>
    15. 

  15. <?php 
    16. 

  16. 	exit;
    17. 

  17. }
    18. 

  18. 

  19. $query = sprintf("SELECT url, id FROM urls WHERE id = %d", mysql_real_escape_string($_GET['urlid']));
    20. 

  20. $result = mysql_query($query);
    21. 

  21. 

  22. if (!$result) {
    23. 

  23. 	error_log(mysql_error());
    24. 

  24. }
    25. 

  25. 

  26. $row = mysql_fetch_assoc($result);
    27. 

  27. $url = $row['url'];
    28. 

  28. $urlid = $row['id'];
    29. 

  29. mysql_free_result($result);
    30. 

  30. 

  31. if (array_key_exists('subset', $_REQUEST)) {
    32. 

  32. 	if ($_REQUEST['subset'] == 'graph')
    33. 

  33. 	{
    34. 

  34. 		$query = sprintf("SELECT UNIX_TIMESTAMP(d.timestamp) as time, rank
    35. 

  35. 			FROM dynatrace d WHERE d.url_id = %d AND d.timestamp > DATE_SUB(now(),INTERVAL 3 MONTH)
    36. 

  36. 			ORDER BY d.timestamp DESC",
    37. 

  37. 			mysql_real_escape_string($urlid)
    38. 

  38. 		);
    39. 

  39. 	}
    40. 

  40. 	else if ($_REQUEST['subset'] == 'table')
    41. 

  41. 	{
    42. 

  42. 		$query = sprintf("SELECT UNIX_TIMESTAMP(d.timestamp) as time,
    43. 

  43. 				pagesize, reqnumber, rank, timetoimpression
    44. 

  44. 			FROM dynatrace d WHERE d.url_id = %d AND d.timestamp > DATE_SUB(now(),INTERVAL 3 MONTH)
    45. 

  45. 			ORDER BY d.timestamp DESC",
    46. 

  46. 			mysql_real_escape_string($urlid)
    47. 

  47. 		);
    48. 

  48. 	}
    49. 

  49. } else {
    50. 

  50. 	$query = sprintf("SELECT UNIX_TIMESTAMP(d.timestamp) as time,
    51. 

  51. 			rank, cache, net, server, js,
    52. 

  52. 			timetoimpression, timetoonload, timetofullload,
    53. 

  53. 			reqnumber, xhrnumber,
    54. 

  54. 			pagesize, cachablesize, noncachablesize,
    55. 

  55. 			timeonnetwork, timeinjs, timeinrendering
    56. 

  56. 		FROM dynatrace d WHERE d.url_id = %d AND d.timestamp > DATE_SUB(now(),INTERVAL 3 MONTH)
    57. 

  57. 		ORDER BY d.timestamp DESC",
    58. 

  58. 		mysql_real_escape_string($urlid)
    59. 

  59. 	);
    60. 

  60. }
    61. 

  61. 

  62. $result = mysql_query($query);
    63. 

  63. 

  64. if (!$result) {
    65. 

  65.         error_log(mysql_error());
    66. 

  66. }
    67. 

  67. 

  68. $data = array();
    69. 

  69. 

  70. header('Content-type: text/plain');
    71. 

  71. if (array_key_exists('ver', $_GET)) {
    72. 

  72. 	header('Expires: '.date('r', time() + 315569260));
    73. 

  73. 	header('Cache-control: max-age=315569260');
    74. 

  74. }
    75. 

  75. 

  76. $rows = array();
    77. 

  77. while ($row = mysql_fetch_assoc($result)) {
    78. 

  78. 	$rows[] = $row;
    79. 

  79. }
    80. 

  80. 

  81. mysql_free_result($result);
    82. 

  82. 

  83. if (array_key_exists('smooth', $_REQUEST)) {
    84. 

  84. 	require_once(dirname(__FILE__).'/smooth.php');
    85. 

  85. 	smooth($rows, array('rank'));
    86. 

  86. }
    87. 

  87. 

  88. if (!array_key_exists('subset', $_REQUEST))
    89. 

  89. {
    90. 

  90. 	header('Content-disposition: attachment;filename=dynatrace.csv');
    91. 

  91. 

  92. 	echo '# Measurement time';
    93. 

  93. 	echo ', Overall Page Rank (Percentage)';
    94. 

  94. 	echo ', Caching Rank (Percentage)';
    95. 

  95. 	echo ', Network Rank (Percentage)';
    96. 

  96. 	echo ', Server-Side Rank (Percentage)';
    97. 

  97. 	echo ', JavaScript Rank (Percentage)';
    98. 

  98. 	echo ', Time to First Impression (ms)';
    99. 

  99. 	echo ', Time to onLoad (ms)';
    100. 

  100. 	echo ', Time to Full Page Load (ms)';
    101. 

  101. 	echo ', Number of Requests';
    102. 

  102. 	echo ', Number of XHR Requests';
    103. 

  103. 	echo ', Total Page Size (bytes)';
    104. 

  104. 	echo ', Total Cachable Size (bytes)';
    105. 

  105. 	echo ', Total Non-Cachable Size (bytes)';
    106. 

  106. 	echo ', Total Time on Network (ms)';
    107. 

  107. 	echo ', Total Time in JavaScript (ms)';
    108. 

  108. 	echo ', Total Time in Rendering (ms)';
    109. 

  109. 	echo "\n";
    110. 

  110. }
    111. 

  111. 

  112. foreach ($rows as $row) {
    113. 

  113. 

  114.         echo date('c', $row['time']).',';
    115. 

  115. 

  116. 	if (array_key_exists('subset', $_REQUEST)) {
    117. 

  117. 		if ($_REQUEST['subset'] == 'graph')
    118. 

  118. 		{
    119. 

  119. 			echo $row['rank'];
    120. 

  120. 		}
    121. 

  121. 		else if ($_REQUEST['subset'] == 'table')
    122. 

  122. 		{
    123. 

  123. 			echo	$row['pagesize'].','.
    124. 

  124. 				$row['reqnumber'].','.
    125. 

  125. 				$row['rank'].','.
    126. 

  126. 				$row['timetoimpression'];
    127. 

  127. 		}
    128. 

  128. 	} else {
    129. 

  129. 		echo $row['rank'].','.$row['cache'].','.$row['net'].','.$row['server'].','.$row['js'].','.
    130. 

  130. 		$row['timetoimpression'].','.$row['timetoonload'].','.$row['timetofullload'].','.
    131. 

  131. 		$row['reqnumber'].','.$row['xhrnumber'].','.
    132. 

  132. 		$row['pagesize'].','.$row['cachablesize'].','.$row['noncachablesize'].','.
    133. 

  133. 		$row['timeonnetwork'].','.$row['timeinjs'].','.$row['timeinrendering'];
    134. 

  134. 	}
    135. 

  135. 

  136. 	echo "\n";
    137. 

  137. }
    138.