<?php

$now = date('Y-m-d');

	$dbhost = '192.168.1.2';
	$db_name = 'asterisk';
	$dbuser = 'dave';
	$dbpass = '1234';
mysql_connect("$dbhost", "$dbuser", "$dbpass")
	         or die(mysql_error());
	//echo "Connected to MySQL<br />";
mysql_select_db("$db_name")
	        or die("cannot select DB");
	//echo "Connected to asterisk database<br />";
	//$query  = "SELECT * FROM vicidial_agent_log WHERE status='SALE' AND user='$sales'";
	$query  = "SELECT * FROM vicidial_agent_log WHERE status='SALE' AND event_time  BETWEEN '$now 00:00:01' AND '$now 23:59:59'";
	$result = mysql_query($query);
	$number_of_sales=mysql_num_rows($result);
mysql_close();
if($number_of_sales == 0){

$number_of_sales=1;
}

$dbhost = '192.168.1.3';
$db_name = 'asteriskcdrdb';
$dbuser = 'dave';
$dbpass = '1234';
mysql_connect("$dbhost", "$dbuser", "$dbpass")
         or die(mysql_error());
//echo "Connected to MySQL<br />";
mysql_select_db("$db_name")
        or die("cannot select DB");
//echo "Connected to database<br />";
$query  = "SELECT sum(callcost) as total_cost FROM cdr WHERE calldate BETWEEN '$now 00:00:01' AND '$now 23:59:59' ";

$result = mysql_query($query);
if (!$result) echo mysql_error();

while ($row = mysql_fetch_assoc($result)) {

$cost2sale=$row[total_cost];

$final=round($cost2sale/$number_of_sales);

echo "R $final";

mysql_close();

}

?>