0) {
$sql = "$sql AND ";
} else {
$sql = "$sql WHERE ";
}
$sql = "$sql $fld";
if (array_key_exists($fld.'type', $_POST)) {
$dType = $_POST[$fld.'type'];
switch ($dType) {
case 1:
$sql = "$sql='$_POST[$fld]'";
break;
case 2:
$sql = "$sql LIKE '$_POST[$fld]%'";
break;
case 3:
$sql = "$sql LIKE '%$_POST[$fld]%'";
break;
case 4:
$sql = "$sql LIKE '%$_POST[$fld]'";
}
} else {
$sql = "$sql LIKE '%$_POST[$fld]%'";
}
}
return $sql;
}
mysql_connect($dhost, $duser, $dpass) or
die("mySQL service unavailable please try again later");
mysql_select_db($dname) or
die("Database $dname unreachable, contact an administrator");
# Construct Query Here
$query = 'SELECT * from cdr';
$SQLcmd = '';
if ($_POST['before']) {
if (strpos($SQLcmd, 'WHERE') > 0) {
$SQLcmd = "$SQLcmd AND ";
} else {
$SQLcmd = "$SQLcmd WHERE ";
}
$SQLcmd = "$SQLcmd calldate<'".$_POST['before']."'";
}
if ($_POST['after']) {
if (strpos($SQLcmd, 'WHERE') > 0) {
$SQLcmd = "$SQLcmd AND ";
} else {
$SQLcmd = "$SQLcmd WHERE ";
}
$SQLcmd = "$SQLcmd calldate>'".$_POST['after']."'";
}
$SQLcmd = do_field($SQLcmd, 'clid');
$SQLcmd = do_field($SQLcmd, 'src');
$SQLcmd = do_field($SQLcmd, 'dst');
$SQLcmd = do_field($SQLcmd, 'channel');
#echo 'Executing SQL: ' .$query.$SQLcmd. '
';
$result = mysql_query($query.$SQLcmd) or die('Query failed : ' .mysql_error());
echo 'Returned ' .mysql_num_rows($result). ' records from CDR.
';
echo '';
for ($hdr=0;$hdr' .ucfirst(mysql_field_name($result,$hdr)). '';
}
echo '
';
while ($line = mysql_fetch_row($result)) {
echo '';
foreach ($line as $col_value) {
echo "| $col_value | ";
}
echo '
';
}
echo '
';
$query = "SELECT sum(duration), sum(billsec) from cdr";
$result = mysql_query($query.$SQLcmd) or die('Query failed : ' .mysql_error());
$line = mysql_fetch_row($result);
function FormatTime($time)
{
// Format the time to human readable format
$diff = $time;
$hrsDiff = floor($diff/60/60);
$diff -= $hrsDiff*60*60;
$minsDiff = floor($diff/60);
$diff -= $minsDiff*60;
$secsDiff = $diff;
return (' ( '.$hrsDiff.'h '.$minsDiff.'m '.$secsDiff.'s )');
}
?>
Total Call Seconds:
Total Billable Seconds:
Designed by
Jazz Inc.
Copyright © 2003 Jazz Inc.