<?php 

// start of functions

//-----------------------------------------------------------

// get_state	.. gets state prefix eg 02 03 07 08

function	
get_state_prefix()
	{
	$fe=fopen("etc/state","r"); 
	$state=fgets($fe); 
	fclose($fe);
	$state=substr($state,0,2);
	return $state;
	}
//-----------------------------------------------------------

// get_reporting	flag to indicate if reporting active

function
get_reporting()
	{
	$fe=fopen("etc/cdr-feed","r");
	$cdr=fgets($fe);
	fclose($fe);
	$cdr=substr($cdr,0,1);
	return $cdr;
	}
//-----------------------------------------------------------


// create_data_file	create the data file for reporting

function
create_data_file($state)
	{
	exec("hostname -s",$hos);
	$host=$hos[0];
	$l=strlen($host); 
	if ($l==4)
		{
		$b=substr($host,0,2);
		$c=substr($host,2);
		$host=$b."0".$c;
		}
	$l=strlen($host); 
	if ($l==5)
		{
		$b=substr($host,0,2);
		$c=substr($host,2);
		$host=$b."0".$c;
		}
	// database credentials
	$hn="localhost";
	$pw="y3sTe1c0_1";
	$un="root";
	$db="asteriskcdrdb";
	$tb="cdr";
	$da=date("Y-m-d");
	$fn=$da.'-'.$host.".csv";
	$con=mysqli_connect($hn,$un,$pw,$db);
	$nbr=0;
	$fe=fopen("cdr/$fn","w");
	$result = mysqli_query($con,"SELECT * FROM $tb where calldate like '%$da%'");
	while($row = mysqli_fetch_array($result))
		{
		$l=strlen($row['dst']);
		if (($l>5) and ($row['dst']<>'musiconhold') 
   		and ($row['dst']<>"STARTMEETME")
   		and ($row['disposition']=="ANSWERED")
   		and ($row['billsec']>0)
   		and ($row['dstchannel']>""))
			{
			$cd=$row['calldate'];
			$trk=substr($row['dstchannel'],4,10);
			$dest=$row['dst'];
			if(strlen($dest)==8)
				{
				$dest=$state.$dest;
				}
			$sec=$row['billsec'];
			$sec=str_pad($sec,5,"0",STR_PAD_LEFT);
			$a=$cd.",".$trk.",".$dest.",".$sec."\n";
			if(substr($trk,0,1)=="T")
				{
				fputs($fe,$a);
				}
			}
		}
	mysqli_close($con);
	fclose($fe);
	shell_exec("/bin/sh copy-cdr-to-emersion & \n");
	}
//-----------------------------------------------------------

// -- end of functions

// --------------------------------------------------------------

// code

$cdr=get_reporting();
if ($cdr=="N")
	{
	die;
	}
$state=get_state_prefix();
create_data_file($state);