-
Notifications
You must be signed in to change notification settings - Fork 0
/
readsearchtable.php
54 lines (44 loc) · 2.1 KB
/
readsearchtable.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
<?php
//include the database
include 'functions.php';
use Medoo\Medoo;
$selector = getWhere(getTimeFrom($_POST['timefrom']),
getTimeTo($_POST['timefrom'], $_POST['timeto']),
$_POST['callfrom'],
$_POST['callto'],
$_POST['callduration'],
$_POST['talkduration'],
$_POST['status'],
$_POST['drunk'],
$_POST['communicationtype'],
$_POST['pincode']);
$selector['LIMIT'] = [0,50];
$data = $database->select("cdr", ["datetime","clid","dst","billable","duration","disposition"], $selector);
$index = 1;
if (count($data)) {
// output data of each row
foreach($data as $row) {
// var_dump($row['clid']);
$billhours = floor($row['billable'] / 3600);
$billmins = floor($row['billable'] / 60 % 60);
$billsecs = floor($row['billable'] % 60);
$billtimeFormat = sprintf('%02d:%02d:%02d', $billhours, $billmins, $billsecs);
$talkhours = floor($row['duration'] / 3600);
$talkmins = floor($row['duration'] / 60 % 60);
$talksecs = floor($row['duration'] % 60);
$talktimeFormat = sprintf('%02d:%02d:%02d', $talkhours, $talkmins, $talksecs);
echo "<tr>";
echo "<td style='width: 5%'>".($index++)."</td>";
echo "<td style='width: 10%' data-toggle='tooltip' title='".$row['datetime']."'>".$row['datetime']."</td>";
echo "<td style='width: 10%' data-toggle='tooltip' title='".$row['clid']."'>".$row['clid']."</td>";
echo "<td style='width: 10%' data-toggle='tooltip' title='".$row['dst']."'>".$row['dst']."</td>";
echo "<td style='width: 10%' data-toggle='tooltip' title='".$billtimeFormat."'>".$billtimeFormat."</td>";
echo "<td style='width: 10%' data-toggle='tooltip' title='".$talktimeFormat."'>".$talktimeFormat."</td>";
echo "<td style='width: 10%' data-toggle='tooltip' title='".$row['disposition']."'>".$row['disposition']."</td>";
echo "</tr>";
}
} else {
echo "<div class='col-sm-6'><h3>0 results</h3></div>";
}
// echo json_encode($data);
?>