-
Notifications
You must be signed in to change notification settings - Fork 0
/
logbook.inc.php
111 lines (90 loc) · 1.73 KB
/
logbook.inc.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
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
<?php
include('db.inc.php');
$DB_NAME = "dbname";
function getUniqueCalls($params = array())
{
global $db;
$sql = "select distinct(COL_CALL) from TABLE_HRD_CONTACTS_V01";
if($params)
{
$sql .= " WHERE ";
$firstCond = 1;
# Step through parameters and build the query
foreach ($params as $k => $v)
{
if($firstCond != 1)
{
$sql .= " AND ";
}
else
{
$firstCond = 0;
}
$sql .= $k . " LIKE '" . $v . "'";
}
}
$rs = $db->Execute($sql);
if($rs->_numOfRows > 0)
{
$UniqueCalls = $rs->GetArray();
return $UniqueCalls;
}
else
{
return -1;
}
}
function countQSO()
{
global $db;
$sql = "select * from TABLE_HRD_CONTACTS_V01";
$rs = $db->Execute($sql);
return $rs->_numOfRows;
}
function getQSOList($params = array(), $orderBy = "COL_TIME_ON", $orderDir = "DESC", $limit = null)
{
global $db;
$sql = "select * from TABLE_HRD_CONTACTS_V01";
$csql = "SELECT COUNT(*) AS RECORD_COUNT FROM TABLE_HRD_CONTACTS_V01";
if($params)
{
$sql .= " WHERE ";
$csql .= " WHERE ";
$firstCond = 1;
# Step through parameters and build the query
foreach ($params as $val)
# $k => $v)
{
if($firstCond != 1)
{
$sql .= " AND ";
$csql .= " AND ";
}
else
{
$firstCond = 0;
}
$sql .= key($val) . " LIKE '%" . $val[key($val)] . "%'";
$csql .= key($val) . " LIKE '%" . $val[key($val)] . "%'";
}
}
$sql .= " ORDER BY ".$orderBy." ".$orderDir;
$csql .= " ORDER BY ".$orderBy." ".$orderDir;
if($limit)
{
$sql .= " LIMIT ".$limit;
}
$rs = $db->Execute($sql);
if($rs->_numOfRows > 0)
{
$QSOList['qso'] = $rs->GetArray();
$crs = $db->Execute($csql);
$c = $crs->FetchRow();
$QSOList['count'] = $c['RECORD_COUNT'];
return $QSOList;
}
else
{
return -1;
}
}