expandAll = $expandAll;
$this->domain = $domain;
$this->datasource = $datasource;
if (strlen($CDRTool['filter']['domain'])) {
$this->allowedDomains = explode(" ", $CDRTool['filter']['domain']);
$allowed_domains_sql="";
$j=0;
foreach ($this->allowedDomains as $_domain) {
if ($j>0) $allowed_domains_sql.=",";
$allowed_domains_sql.="'".addslashes($_domain)."'";
$j++;
}
}
$this->locationDB = new $database;
$this->locationTable = $table;
$this->Registered=array();
$this->countUA=array();
$where = " where (1=1) " ;
if ($allowed_domains_sql) {
$where.= sprintf("and domain in (%s)",addslashes($allowed_domains_sql)) ;
}
$query = sprintf(
"select count(*) as c, domain from %s %s group by domain order by domain ASC",
addslashes($this->locationTable),
$where
);
$this->locationDB->query($query);
$this->domains=$this->locationDB->num_rows();
while ($this->locationDB->next_record()) {
$this->Registered[$this->locationDB->f('domain')]=$this->locationDB->f('c');
$this->total=$this->total+$this->locationDB->f('c');
}
$query = sprintf("select count(*) as c, user_agent from %s %s", addslashes($this->locationTable), $where);
if ($this->domain) {
$query.=sprintf(" and domain = '%s' ", addslashes($this->domain));
}
$query.="
group by user_agent
order by c DESC";
$this->locationDB->query($query);
while ($this->locationDB->next_record()) {
$this->countUA[$this->locationDB->f('user_agent')]=$this->locationDB->f('c');
}
}
function showHeader()
{
print "";
print "
";
if ($this->domain) {
print "
|
User@Domain |
|
SIP UA contact |
NAT address |
User Agent |
Expires |
Remain |
";
} else {
print "
| Users@ |
Domain |
";
}
print "
";
}
function showFooter()
{
print "
|
$this->total users@
| $this->domains domains
|
";
}
function showAll()
{
global $found;
$this->showHeader();
foreach (array_keys($this->Registered) as $ld) {
$onlines=$this->Registered[$ld];
if ($this->expandAll || ($this->domain && $this->domain==$ld)) {
$this->show($ld);
} else {
$found++;
$url = sprintf("%s?datasource=%s&domain=%s",
$_SERVER['PHP_SELF'],
urlencode($this->datasource),
urlencode($ld)
);
print "
| $found |
$onlines users@ |
$ld |
";
if ($this->domain) {
print "
|
|
|
|
";
}
print "
";
}
}
$this->showfooter();
/*
print "";
$this->showUAdistribution();
*/
}
function show()
{
global $found;
$query="SELECT *, SEC_TO_TIME(UNIX_TIMESTAMP(expires)-UNIX_TIMESTAMP(NOW())) AS remain
FROM location
";
if ($this->domain) $query.=sprintf(" where domain = '%s'", addslashes($this->domain));
$query.= " ORDER BY domain ASC, username ASC ";
$this->locationDB->query($query);
while ($this->locationDB->next_record()) {
$found++;
$username = $this->locationDB->f('username');
$domain = $this->locationDB->f('domain');
$contact = $this->locationDB->f('contact');
$received = $this->locationDB->f('received');
$user_agent = $this->locationDB->f('user_agent');
$expires = $this->locationDB->f('expires');
$remain = $this->locationDB->f('remain');
$contact_print=substr($contact,4);
$c_els=explode(";", $contact);
$r_els=explode(";", $received);
$transport="UDP";
if ($c_els[1] && preg_match("/transport=(tcp|tls)/i", $c_els[1], $m)) {
$transport=strtoupper($m[1]);
}
$sip_account=$username."@".$domain;
print "
| $found |
$sip_account |
$transport |
$c_els[0] |
$r_els[0] |
$user_agent |
$expires |
$remain |
";
$seen[$username]++;
$seen[$domain]++;
}
}
function showUAdistribution()
{
print "";
print " ";
print " | ";
print "User agent | ";
print "Users | ";
print "
";
foreach ($this->countUA as $k => $v) {
$users=$users+$v;
$count++;
print " ";
print "| $count | ";
print "$k | ";
print "$v | ";
print "
";
}
print " ";
print " | ";
print "$this->domain | ";
print "$users | ";
print "
";
print "
";
}
}