poll_HV_data.php 7.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226
  1. <?php
  2. // include channel list
  3. $adeiChannel = array(
  4. // Voltage monitoring K35 etc. (index 30)
  5. array(
  6. "hv__katrin-hv_rep__7__2", //K35 divided voltage reading
  7. "hv__katrin-hv_rep__7__5", //K65 divided voltage reading
  8. "hv__katrin-hv_rep__7__3", //K35 divided voltage timestamp
  9. "hv__katrin-hv_rep__7__6", //K65 divided voltage timestamp
  10. )
  11. );
  12. // include previous values
  13. //include "ADEI_HV_readings.php";
  14. $username = 'katrin';
  15. $password = 'katrin.Pauli%2020';
  16. $context = stream_context_create(array(
  17. 'http' => array(
  18. 'header' => "Authorization: Basic " . base64_encode("$username:$password"), "Connection: close\r\n"
  19. )
  20. ));
  21. // set time zone to local German time
  22. date_default_timezone_set('Europe/Berlin');
  23. sleep(2);
  24. $counter = 0;
  25. $calltime = time();
  26. $errorcount = 0;
  27. $errormessage = '<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>';
  28. $starttime = $calltime;
  29. $n = 0;
  30. //echo "started ".date("r", $starttime).PHP_EOL;
  31. do {
  32. $n++;
  33. $currenttime = time();
  34. $delaytime = 10 - ($currenttime % 10);
  35. sleep($delaytime);
  36. // echo "start polling ".time().PHP_EOL;
  37. //echo "Polling ADEI data.".PHP_EOL;
  38. for ($id = 0; $id < sizeof($adeiChannel); $id++)
  39. {
  40. $adeiChannels = "";
  41. for ($id2 = 0; $id2 < sizeof($adeiChannel[$id]); $id2++)
  42. {
  43. $adeiChannels = $adeiChannels . $adeiChannel[$id][$id2] . ",";
  44. }
  45. $adeiChannels = substr($adeiChannels, 0, strlen($adeiChannels) - 1);
  46. // new adei-katrin.kaas.kit.edu added and optimized readout parameters
  47. $fileip = file_get_contents("https://adei-katrin.kaas.kit.edu/adei/services/getdata.php?db_server=virtual&db_name=srctree&db_group=-3&control_group=-3&virtual=srctree&srctree=" . $adeiChannels . "&rt=full&window=400&format=csv", false, $context);
  48. sleep(1);
  49. //echo $fileip.PHP_EOL;
  50. $adeiArray = explode("\n", $fileip);
  51. //convert ADEI response into array with all values
  52. $oldTS1 = 0;
  53. $oldTS2 = 0;
  54. $readings1 = array();
  55. $readings2 = array();
  56. foreach ($adeiArray as $key => $element)
  57. {
  58. $adeiLine = explode(",",$element);
  59. //echo $key." ".sizeof($adeiLine).PHP_EOL;
  60. if (sizeof($adeiLine) == 5)
  61. {
  62. $voltage = floatval($adeiLine[1]);
  63. $voltageTS = floatval($adeiLine[3]);
  64. if (($voltageTS > 0) && ($voltageTS > $oldTS1)) { $readings1[] = array($voltageTS, $voltage); $oldTS1 = $voltageTS; }
  65. $voltage = floatval($adeiLine[2]);
  66. $voltageTS = floatval($adeiLine[4]);
  67. if (($voltageTS > 0) && ($voltageTS > $oldTS2)) { $readings2[] = array($voltageTS, $voltage); $oldTS2 = $voltageTS; }
  68. }
  69. }
  70. unset($element);
  71. // filter and extract FlukeA values and calculate mean and deviations for a set of entries
  72. $index = array(-10,-30,-150);
  73. foreach ($index as $slice)
  74. {
  75. if (sizeof($readings1) > abs($slice))
  76. {
  77. $arrayslice = array_slice($readings1,$slice);
  78. $entries = count($arrayslice);
  79. if ($entries > 2)
  80. {
  81. $voltages = array_column($arrayslice,1);
  82. $mean = array_sum($voltages) / $entries;
  83. $carry = 0.0;
  84. foreach ($voltages as $val)
  85. {
  86. $d = ((double) $val) - $mean;
  87. $carry += $d * $d;
  88. }
  89. }
  90. $mean1 = $mean;
  91. $stddev1 = sqrt($carry / $entries);
  92. $stddev1_rel = $stddev1 / abs($mean1);
  93. $endTS = $arrayslice[sizeof($arrayslice)-1][0];
  94. $span = round($endTS-$arrayslice[0][0]);
  95. $time_conversion_factor = 2082844800;
  96. //echo "Number of aquired elements: ".sizeof($arrayslice).PHP_EOL;
  97. //echo "Mean Value: ".sprintf('%.6F', $mean1).PHP_EOL;
  98. //echo "Standard Deviation: ".sprintf('%.2E', $stddev1).PHP_EOL;
  99. //echo "Rel. Standard Deviation: ".sprintf('%.2E', $stddev1_rel).PHP_EOL;
  100. //echo "TS at end: ".date("r", $endTS-$time_conversion_factor).PHP_EOL;
  101. //echo "Timespan: ".$span.PHP_EOL;
  102. //echo PHP_EOL;
  103. $results1[] = array(
  104. "number" => sizeof($arrayslice),
  105. "timespan" => $span,
  106. "timestamp" => $endTS-$time_conversion_factor,
  107. "humantime" => date("r", $endTS-$time_conversion_factor),
  108. "mean" => $mean1,
  109. "stddev" => $stddev1,
  110. "ppmdev" => $stddev1_rel
  111. );
  112. }
  113. }
  114. // filter and extract FlukeE values and calculate mean and deviations for a set of entries
  115. $index = array(-5,-10,-30,-150);
  116. foreach ($index as $slice)
  117. {
  118. if (sizeof($readings2) > abs($slice))
  119. {
  120. $arrayslice = array_slice($readings2,$slice);
  121. $entries = count($arrayslice);
  122. if ($entries > 2)
  123. {
  124. $voltages = array_column($arrayslice,1);
  125. $mean = array_sum($voltages) / $entries;
  126. $carry = 0.0;
  127. foreach ($voltages as $val)
  128. {
  129. $d = ((double) $val) - $mean;
  130. $carry += $d * $d;
  131. }
  132. }
  133. $mean2 = $mean;
  134. $stddev2 = sqrt($carry / $entries);
  135. $stddev2_rel = $stddev2 / abs($mean2);
  136. $endTS = $arrayslice[sizeof($arrayslice)-1][0];
  137. $span = round($endTS-$arrayslice[0][0]);
  138. $time_conversion_factor = 2082844800;
  139. //echo "Number of aquired elements: ".sizeof($arrayslice).PHP_EOL;
  140. //echo "Mean Value: ".sprintf('%.6F', $mean2).PHP_EOL;
  141. //echo "Standard Deviation: ".sprintf('%.2E', $stddev2).PHP_EOL;
  142. //echo "Rel. Standard Deviation: ".sprintf('%.2E', $stddev2_rel).PHP_EOL;
  143. //echo "TS at end: ".date("r", $endTS-$time_conversion_factor).PHP_EOL;
  144. //echo "Timespan: ".$span.PHP_EOL;
  145. //echo PHP_EOL;
  146. $results2[] = array(
  147. "number" => sizeof($arrayslice),
  148. "timespan" => $span,
  149. "timestamp" => $endTS-$time_conversion_factor,
  150. "humantime" => date("r", $endTS-$time_conversion_factor),
  151. "mean" => $mean2,
  152. "stddev" => $stddev2,
  153. "ppmdev" => $stddev2_rel
  154. );
  155. }
  156. }
  157. //var_dump( $results2 );
  158. //var_dump( $results1 );
  159. // error handling
  160. if (substr($fileip,0,5) == "ERROR")
  161. {$errorcount++; $errormessage = $errormessage . "Error loading ADEI channel " . $id . "<br>";}
  162. for ($id2 = sizeof($adeiChannel[$id]) - 1 ; $id2 > -1; $id2--)
  163. {
  164. $pos = strrpos($fileip, ",");
  165. $adeiValue[$id][$id2] = floatval(substr($fileip, $pos + 2));
  166. $fileip = substr($fileip, 0, $pos);
  167. //echo $id . " " . $id2 . " " . $adeiValue[$id][$id2] . PHP_EOL;
  168. }
  169. }
  170. if ($errorcount >0) echo $errormessage;
  171. //echo "Writing data into formatted string.".PHP_EOL;
  172. $strFileContent = "<"."?php".PHP_EOL.PHP_EOL."$"."flukeA = ".var_export($results1, true).";".PHP_EOL.PHP_EOL;
  173. $strFileContent .= "$"."flukeE = ".var_export($results2, true).";".PHP_EOL.PHP_EOL;
  174. $strFileContent .= "$"."extraction_time_HV = '". date(DATE_RFC850) ."';".PHP_EOL.PHP_EOL;
  175. $strFileContent .= "?".">".PHP_EOL;
  176. // write ADEI data to file
  177. //echo "Writing data to file.".PHP_EOL;
  178. $file_w = fopen('ADEI_HV_readings.php', 'w+');
  179. sleep(1);
  180. fwrite($file_w, $strFileContent);
  181. fclose($file_w);
  182. //echo $strFileContent.PHP_EOL;
  183. //echo $n." ".time().PHP_EOL;
  184. } while (time() < $starttime+50);
  185. //echo "stopped".date("r", time()).PHP_EOL;
  186. //echo "Data extraction done.".PHP_EOL;
  187. ?>