Subversion Repositories general

Compare Revisions

Ignore whitespace Rev 1395 → Rev 1396

/asterisk-stats/trunk/telbook_list.php
1,7 → 1,7
<?php
 
include_once('includes/common.php');
Prolog();
Prolog('Tel. Book Persons');
 
$db->query("select person_id, person_name, person_comment, category_name,"
. " category_comment, entry_title, entry_value, entry_comment"
/asterisk-stats/trunk/telbook_export_list.php
1,7 → 1,7
<?php
 
include_once('includes/common.php');
Prolog();
Prolog('Tel. Book Export Targets');
 
$db->query("select export_id, export_name, export_type, export_comment"
. " from telbook_export order by upper(export_name), export_name");
/asterisk-stats/trunk/cdr_search.php
1,7 → 1,7
<?php
 
include_once('includes/common.php');
Prolog();
Prolog('Search Calls');
 
$g_display->add_template('cdr_search');
 
/asterisk-stats/trunk/telbook_categories_list.php
1,7 → 1,7
<?php
 
include_once('includes/common.php');
Prolog();
Prolog('Tel. Book Categories');
 
$db->query("select category_id, category_name, category_comment"
. " from telbook_categories order by upper(category_name), category_name");
/asterisk-stats/trunk/style.css
9,7 → 9,6
 
table.menu {
background-color: #6876F8;
position: fixed;
left: 0;
top: 0;
width: 100%;
26,23 → 25,15
}
 
div.copyright {
color: #FFFFFF;
font: 8pt Verdana;
text-align: center;
position: fixed;
bottom: 0;
left: 0;
width: 100%;
background-color: #6876F8;
color: #AAAAAA;
font: 6pt Verdana;
}
 
div.copyright a {
color: #FFFFFF;
color: #AAAAAA;
}
 
div.main {
margin-top: 50px;
margin-bottom: 50px;
}
 
table.calls a {
/asterisk-stats/trunk/telbook_update.php
1,7 → 1,7
<?php
 
include_once('includes/common.php');
Prolog();
Prolog('Tel. Book Person');
 
if(array_key_exists('delete', $_POST)) {
$id = $_POST['id'];
/asterisk-stats/trunk/telbook_export_update.php
1,7 → 1,7
<?php
 
include_once('includes/common.php');
Prolog();
Prolog('Tel. Book Export Target');
 
if(array_key_exists('delete', $_POST)) {
$id = $_POST['id'];
/asterisk-stats/trunk/cdr_list.php
65,19 → 65,40
$query_limit = '';
if(array_key_exists('list',$_GET)) {
switch($_GET['list']) {
case 'year': $query .= do_date_compare('year'); break;
case 'month': $query .= do_date_compare('month'); break;
case 'week': $query .= do_date_compare('week'); break;
case 'lastweek': $query .= do_date_compare('week', 1); break;
case 'today': $query .= do_date_compare('day'); break;
case 'year':
SetPageTitle("This Year Calls");
$query .= do_date_compare('year');
break;
case 'month':
SetPageTitle("This Month Calls");
$query .= do_date_compare('month');
break;
case 'week':
SetPageTitle("This Week Calls");
$query .= do_date_compare('week');
break;
case 'lastweek':
SetPageTitle("Last Week Calls");
$query .= do_date_compare('week', 1);
break;
case 'today':
SetPageTitle("Today Calls");
$query .= do_date_compare('day');
break;
case 'active':
SetPageTitle("Active Calls");
$active = true;
$query .= " and duration is null";
break;
 
default: $query_limit .= " limit 1000";
default:
SetPageTitle("Calls");
$query_limit .= " limit 1000";
}
}
else {
SetPageTitle("Calls Search Result");
}
 
if($active) {
$list_query = "select acctid,calldate,src,dst,"
/asterisk-stats/trunk/originate_form.php
1,7 → 1,7
<?php
 
include_once('includes/common.php');
Prolog();
Prolog('Originate Call');
 
$src = $_GET['src'];
$dst = $_GET['dst'];
/asterisk-stats/trunk/telbook_details.php
1,7 → 1,7
<?php
 
include_once('includes/common.php');
Prolog();
Prolog('Tel. Book Person');
 
$id = $_GET['id'];
 
/asterisk-stats/trunk/telbook_export_details.php
2,7 → 2,7
 
include_once('includes/common.php');
include_once('includes/export_types.php');
Prolog();
Prolog('Tel. Book Export Target');
 
$id = $_GET['id'];
$export = array();
/asterisk-stats/trunk/telbook_categories_update.php
1,7 → 1,7
<?php
 
include_once('includes/common.php');
Prolog();
Prolog('Tel. Book Category');
 
if(array_key_exists('delete', $_POST)) {
$id = $_POST['id'];
/asterisk-stats/trunk/index.php
1,7 → 1,7
<?php
 
include_once('includes/common.php');
Prolog();
Prolog('Summary');
 
function add_summary($count_name, $dur_name, $interval, $diff = NULL)
{
/asterisk-stats/trunk/telbook_categories_details.php
1,7 → 1,7
<?php
 
include_once('includes/common.php');
Prolog();
Prolog('Tel. Book Category');
 
$id = $_GET['id'];
$category = array();
/asterisk-stats/trunk/originate_call.php
1,7 → 1,7
<?php
 
include_once('includes/common.php');
Prolog();
Prolog('Originate Call');
 
include_once('includes/AsteriskManager/AsteriskManager.php');
 
/asterisk-stats/trunk/cdr_details.php
4,6 → 4,7
Prolog();
 
if(array_key_exists('active', $_GET)) {
SetPageTitle("Active Call Details");
$db->query_params("select acctid, calldate, linkdate, clid, src, dst, dcontext,"
. " channel, dstchannel, lastapp, lastdata,"
. " extract(epoch from date_trunc('second',current_timestamp-calldate)) as duration,"
19,6 → 20,7
. " where acctid=$1 and duration is null", array($_GET['active']));
}
elseif(array_key_exists('detail', $_GET)) {
SetPageTitle("History Call Details");
$cdr_detail = array();
$db->query_params("select r.*,"
. " p1.person_name as src_name, e1.entry_title as src_title,"
/asterisk-stats/trunk/includes/common.php
8,7 → 8,7
 
$g_display = NULL;
 
function Prolog()
function Prolog($page_title = NULL)
{
global $g_display;
 
15,6 → 15,7
$g_display = new template_handler('template');
$g_display->add_template('header');
ShowMenu($g_display);
SetPageTitle($page_title);
}
 
function ShowMenu($display)
38,4 → 39,11
echo $g_display;
}
 
function SetPageTitle($page_title)
{
global $g_display;
 
$g_display->add_variables(array('PAGE_TITLE' => $page_title));
}
 
?>
/asterisk-stats/trunk/template/index.tpl
5,39 → 5,39
<th>Duration</th>
</tr>
<tr>
<td class="t"><a href=cdr_list?list=active>Active</a></td>
<td class="d"><a href=cdr_list?list=active>${CS_ACTIVE}</a></td>
<td class="di"><a href=cdr_list?list=active>${CS_ACTIVE_DUR}</a></td>
<td class="t"><a href=cdr_list.php?list=active>Active</a></td>
<td class="d"><a href=cdr_list.php?list=active>${CS_ACTIVE}</a></td>
<td class="di"><a href=cdr_list.php?list=active>${CS_ACTIVE_DUR}</a></td>
</tr>
<tr>
<td class="t"><a href=cdr_list?list=today>Today</a></td>
<td class="d"><a href=cdr_list?list=today>${CS_TODAY}</a></td>
<td class="di"><a href=cdr_list?list=today>${CS_TODAY_DUR}</a></td>
<td class="t"><a href=cdr_list.php?list=today>Today</a></td>
<td class="d"><a href=cdr_list.php?list=today>${CS_TODAY}</a></td>
<td class="di"><a href=cdr_list.php?list=today>${CS_TODAY_DUR}</a></td>
</tr>
<tr>
<td class="t"><a href=cdr_list?list=week>This Week</a></td>
<td class="d"><a href=cdr_list?list=week>${CS_WEEK}</a></td>
<td class="di"><a href=cdr_list?list=week>${CS_WEEK_DUR}</a></td>
<td class="t"><a href=cdr_list.php?list=week>This Week</a></td>
<td class="d"><a href=cdr_list.php?list=week>${CS_WEEK}</a></td>
<td class="di"><a href=cdr_list.php?list=week>${CS_WEEK_DUR}</a></td>
</tr>
<tr>
<td class="t"><a href=cdr_list?list=lastweek>Last Week</a></td>
<td class="d"><a href=cdr_list?list=lastweek>${CS_LAST_WEEK}</a></td>
<td class="di"><a href=cdr_list?list=lastweek>${CS_LAST_WEEK_DUR}</a></td>
<td class="t"><a href=cdr_list.php?list=lastweek>Last Week</a></td>
<td class="d"><a href=cdr_list.php?list=lastweek>${CS_LAST_WEEK}</a></td>
<td class="di"><a href=cdr_list.php?list=lastweek>${CS_LAST_WEEK_DUR}</a></td>
</tr>
<tr>
<td class="t"><a href=cdr_list?list=month>This Month</a></td>
<td class="d"><a href=cdr_list?list=month>${CS_MONTH}</a></td>
<td class="di"><a href=cdr_list?list=month>${CS_MONTH_DUR}</a></td>
<td class="t"><a href=cdr_list.php?list=month>This Month</a></td>
<td class="d"><a href=cdr_list.php?list=month>${CS_MONTH}</a></td>
<td class="di"><a href=cdr_list.php?list=month>${CS_MONTH_DUR}</a></td>
</tr>
<tr>
<td class="t"><a href=cdr_list?list=year>This Year</a></td>
<td class="d"><a href=cdr_list?list=year>${CS_YEAR}</a></td>
<td class="di"><a href=cdr_list?list=year>${CS_YEAR_DUR}</a></td>
<td class="t"><a href=cdr_list.php?list=year>This Year</a></td>
<td class="d"><a href=cdr_list.php?list=year>${CS_YEAR}</a></td>
<td class="di"><a href=cdr_list.php?list=year>${CS_YEAR_DUR}</a></td>
</tr>
<tr class="total">
<td class="t"><a href=cdr_list?list>Total</a></td>
<td class="d"><a href=cdr_list?list>${CS_TOTAL}</a></td>
<td class="di"><a href=cdr_list?list>${CS_TOTAL_DUR}</a></td>
<td class="t"><a href=cdr_list.php?list>Total</a></td>
<td class="d"><a href=cdr_list.php?list>${CS_TOTAL}</a></td>
<td class="di"><a href=cdr_list.php?list>${CS_TOTAL_DUR}</a></td>
</tr>
</table>
 
/asterisk-stats/trunk/template/header.tpl
1,5 → 1,5
<html>
<title>${AST_SITETITLE}</title>
<title>${PAGE_TITLE} - ${AST_SITETITLE}</title>
<link rel=stylesheet href=${AST_STYLESHEET} type=text/css>
</head>
<body>
/asterisk-stats/trunk/template/menu.tpl
1,6 → 1,6
<table class="menu">
<tr>
<td><a href=..>Up</a></td>
<td><a href=/>Top</a></td>
<td><a href="index.php">Summary</a></td>
<td><a href="cdr_search.php">Search</a></td>
<td><a href="telbook_list.php">Tel. Book</a></td>
7,3 → 7,6
<td><a href="originate_form.php">Call</a></td>
</tr>
</table>
 
<h1>${PAGE_TITLE}</h1>