/LANG_www/vicidial_el/AST_timeoncall.php

https://github.com/inktel/Vicidial · PHP · 180 lines · 149 code · 26 blank · 5 comment · 24 complexity · f4dafa08a8d40f981dce3abf65eceda9 MD5 · raw file 

    

  1. <? 
    2. 

  2. ### AST_timeoncall.php
    3. 

  3. ### 
    4. 

  4. ### Copyright (C) 2006  Matt Florell <vicidial@gmail.com>    LICENSE: GPLv2
    5. 

  5. ###
    6. 

  6. 

  7. require("dbconnect.php");
    8. 

  8. 

  9. $PHP_AUTH_USER=$_SERVER['PHP_AUTH_USER'];
    10. 

  10. $PHP_AUTH_PW=$_SERVER['PHP_AUTH_PW'];
    11. 

  11. $PHP_SELF=$_SERVER['PHP_SELF'];
    12. 

  12. if (isset($_GET["server_ip"]))				{$server_ip=$_GET["server_ip"];}
    13. 

  13. 	elseif (isset($_POST["server_ip"]))		{$server_ip=$_POST["server_ip"];}
    14. 

  14. if (isset($_GET["reset_counter"]))				{$reset_counter=$_GET["reset_counter"];}
    15. 

  15. 	elseif (isset($_POST["reset_counter"]))		{$reset_counter=$_POST["reset_counter"];}
    16. 

  16. if (isset($_GET["submit"]))				{$submit=$_GET["submit"];}
    17. 

  17. 	elseif (isset($_POST["submit"]))		{$submit=$_POST["submit"];}
    18. 

  18. if (isset($_GET["ΕΠΙΒΕΒΑΙΩΣΗ"]))				{$ΕΠΙΒΕΒΑΙΩΣΗ=$_GET["ΕΠΙΒΕΒΑΙΩΣΗ"];}
    19. 

  19. 	elseif (isset($_POST["ΕΠΙΒΕΒΑΙΩΣΗ"]))		{$ΕΠΙΒΕΒΑΙΩΣΗ=$_POST["ΕΠΙΒΕΒΑΙΩΣΗ"];}
    20. 

  20. 

  21. $NOW_TIME = date("Y-m-d H:i:s");
    22. 

  22. $STARTtime = date("U");
    23. 

  23. 

  24. ?>
    25. 

  25. 

  26. <HTML>
    27. 

  27. <HEAD>
    28. 

  28. <STYLE type="text/css">
    29. 

  29. <!--
    30. 

  30.    .green {color: white; background-color: green}
    31. 

  31.    .red {color: white; background-color: red}
    32. 

  32. -->
    33. 

  33.  </STYLE>
    34. 

  34. 

  35. <? 
    36. 

  36. echo "<META HTTP-EQUIV=\"Content-Type\" CONTENT=\"text/html; charset=utf-8\">\n";
    37. 

  37. echo"<META HTTP-EQUIV=Refresh CONTENT=\"15; URL=$PHP_SELF?server_ip=$server_ip&DB=$DB\">\n";
    38. 

  38. echo "<TITLE>VICIDIAL: Time On Call</TITLE></HEAD><BODY BGCOLOR=WHITE>\n";
    39. 

  39. echo "<PRE>\n\n";
    40. 

  40. 

  41. echo "VICIDIAL: Time On Call                                          $NOW_TIME\n\n";
    42. 

  42. echo "+------------+-----------+-----------+------------------+---------------------+---------+\n";
    43. 

  43. echo "| STATION    | SESSIONID | CHANNEL   | NUMBER DIALED    | START TIME          | MINUTES |\n";
    44. 

  44. echo "+------------+-----------+-----------+------------------+---------------------+---------+\n";
    45. 

  45. 

  46. $stmt="SELECT count(*) from live_sip_channels where server_ip='$server_ip';";
    47. 

  47. $rslt=mysql_query($stmt, $link);
    48. 

  48. if ($DB) {echo "$stmt\n";}
    49. 

  49. $row=mysql_fetch_row($rslt);
    50. 

  50. $parked_count = $row[0];
    51. 

  51. 	if ($parked_count > 0)
    52. 

  52. 	{
    53. 

  53. 	$stmt="select extension from live_channels where server_ip='$server_ip';";
    54. 

  54. 	$rslt=mysql_query($stmt, $link);
    55. 

  55. 	if ($DB) {echo "$stmt\n";}
    56. 

  56. 	$ext_to_print = mysql_num_rows($rslt);
    57. 

  57. 	$i=0;
    58. 

  58. 	$live_zap_counter=0;
    59. 

  59. 	$sessions = '';
    60. 

  60. 	while ($i < $ext_to_print)
    61. 

  61. 		{
    62. 

  62. 		$row=mysql_fetch_row($rslt);
    63. 

  63. 		if (preg_match("/^8600/i",$row[0]))
    64. 

  64. 			{
    65. 

  65. 			$sessions .= "$row[0]|";
    66. 

  66. 			}
    67. 

  67. 		$i++;
    68. 

  68. 		}
    69. 

  69. 	$sessions = preg_replace("/\|$/",'',$sessions);
    70. 

  70. 

  71. 	if ($DB) {echo "SESSIONS: -$sessions-\n";}
    72. 

  72. 

  73. 	$stmt="select * from live_sip_channels where server_ip='$server_ip' order by channel;";
    74. 

  74. 	$rslt=mysql_query($stmt, $link);
    75. 

  75. 	if ($DB) {echo "$stmt\n";}
    76. 

  76. 	$parked_to_print = mysql_num_rows($rslt);
    77. 

  77. 	$i=0;
    78. 

  78. 	$live_calls_counter=0;
    79. 

  79. 	while ($i < $parked_to_print)
    80. 

  80. 		{
    81. 

  81. 		$row=mysql_fetch_row($rslt);
    82. 

  82. 		if ( (preg_match("/Zap\/|internal|ring/i",$row[3])) or (preg_match("/Local\//i",$row[0])) )
    83. 

  83. 			{
    84. 

  84. 			if ($DB) {echo "NOT STATION |$row[0]|$row[3]|\n";}
    85. 

  85. 			$session_id = '';
    86. 

  86. 			}
    87. 

  87. 		else 
    88. 

  88. 			{
    89. 

  89. 			if (preg_match("/$row[3]/i",$sessions))
    90. 

  90. 				{
    91. 

  91. 				if ($DB) {echo "LIVE STATION|$row[0]|$row[3]|\n";}
    92. 

  92. 				$session_id = $row[3];
    93. 

  93. 				$station = preg_replace("/SIP\//",'',$row[0]);
    94. 

  94. 				$station = preg_replace("/-.*/",'',$station);
    95. 

  95. 			
    96. 

  96. 				$LIVE_sessions[$live_calls_counter] =			"$session_id";
    97. 

  97. 				$LIVE_sessions_FORMAT[$live_calls_counter] =	sprintf("%-9s", $session_id);
    98. 

  98. 				$LIVE_stations[$live_calls_counter] =			"$station";
    99. 

  99. 				$LIVE_stations_FORMAT[$live_calls_counter] =	sprintf("%-10s", $station);
    100. 

  100. 

  101. 		#		echo "| $station | $session_id | \n";
    102. 

  102. 

  103. 				$live_calls_counter++;
    104. 

  104. 				}
    105. 

  105. 			else
    106. 

  106. 				{
    107. 

  107. 				if ($DB) {echo "NOT STATIONZ|$row[0]|$row[3]|\n";}
    108. 

  108. 				$session_id = '';
    109. 

  109. 				}
    110. 

  110. 			}
    111. 

  111. 

  112. 		$i++;
    113. 

  113. 		}
    114. 

  114. 

  115. 		if ($live_calls_counter > 0)
    116. 

  116. 		{
    117. 

  117. 		$i=0;
    118. 

  118. 		$LC_counter = $live_calls_counter;
    119. 

  119. 

  120. 		while ($i < $live_calls_counter)
    121. 

  121. 			{
    122. 

  122. 			$stmt="select channel,extension,number_dialed,start_time,start_epoch from call_log where extension='$LIVE_stations[$i]' and server_ip='$server_ip' order by uniqueid desc LIMIT 1;";
    123. 

  123. 			$rslt=mysql_query($stmt, $link);
    124. 

  124. 			if ($DB) {echo "$stmt\n";}
    125. 

  125. 			$parked_to_print = mysql_num_rows($rslt);
    126. 

  126. 			$row=mysql_fetch_row($rslt);
    127. 

  127. 

  128. 			$channel =			sprintf("%-9s", $row[0]);
    129. 

  129. 			$number_dialed =	sprintf("%-16s", $row[2]);
    130. 

  130. 			$start_time =		sprintf("%-19s", $row[3]);
    131. 

  131. 			$call_time_S = ($STARTtime - $row[4]);
    132. 

  132. 

  133. 			$call_time_M = ($call_time_S / 60);
    134. 

  134. 			$call_time_M = round($call_time_M, 2);
    135. 

  135. 			$call_time_M_int = intval("$call_time_M");
    136. 

  136. 			$call_time_SEC = ($call_time_M - $call_time_M_int);
    137. 

  137. 			$call_time_SEC = ($call_time_SEC * 60);
    138. 

  138. 			$call_time_SEC = round($call_time_SEC, 0);
    139. 

  139. 			if ($call_time_SEC < 10) {$call_time_SEC = "0$call_time_SEC";}
    140. 

  140. 			$call_time_MS = "$call_time_M_int:$call_time_SEC";
    141. 

  141. 			$call_time_MS =		sprintf("%7s", $call_time_MS);
    142. 

  142. 			$G = '';		$EG = '';
    143. 

  143. 			if ($call_time_M_int >= 12) {$G='<SPAN class="green"><B>'; $EG='</B></SPAN>';}
    144. 

  144. 			if ($call_time_M_int >= 31) {$G='<SPAN class="red"><B>'; $EG='</B></SPAN>';}
    145. 

  145. 

  146. 			echo "| $G$LIVE_stations_FORMAT[$i]$EG | $G$LIVE_sessions_FORMAT[$i]$EG | $G$channel$EG | $G$number_dialed$EG | $G$start_time$EG | $G$call_time_MS$EG |\n";
    147. 

  147. 

  148. 			$i++;
    149. 

  149. 			}
    150. 

  150. 

  151. 		echo "+------------+-----------+-----------+------------------+---------------------+---------+\n";
    152. 

  152. 		echo "  $i stations on live calls on server $server_ip\n\n";
    153. 

  153. 

  154. 		echo "  <SPAN class=\"green\"><B>          </SPAN> - 12 minutes or more on live call\n";
    155. 

  155. 		echo "  <SPAN class=\"red\"><B>          </SPAN> - Over 30 minutes on live call\n";
    156. 

  156. 

  157. 		}
    158. 

  158. 		else
    159. 

  159. 		{
    160. 

  160. 		echo "*****************************************************************************************\n";
    161. 

  161. 		echo "*****************************************************************************************\n";
    162. 

  162. 		echo "*************************************** NO LIVE STATIONS ********************************\n";
    163. 

  163. 		echo "*****************************************************************************************\n";
    164. 

  164. 		echo "*****************************************************************************************\n";
    165. 

  165. 		}
    166. 

  166. 

  167. 	}
    168. 

  168. 	else
    169. 

  169. 	{
    170. 

  170. 	echo "*****************************************************************************************\n";
    171. 

  171. 	echo "*****************************************************************************************\n";
    172. 

  172. 	echo "*************************************** NO LIVE STATIONS ********************************\n";
    173. 

  173. 	echo "*****************************************************************************************\n";
    174. 

  174. 	echo "*****************************************************************************************\n";
    175. 

  175. 	}
    176. 

  176. 

  177. ?>
    178. 

  178. </PRE>
    179. 

  179. 

  180. </BODY></HTML>
    181.