Subversion Repositories general

Compare Revisions

Ignore whitespace Rev 1396 → Rev 1402

/asterisk-stats/trunk/cdr_details.php
13,9 → 13,9
. " p1.person_name as src_name, e1.entry_title as src_title,"
. " p2.person_name as dst_name, e2.entry_title as dst_title"
. " from activecalls r"
. " left join telbook_entries e1 on r.src=e1.entry_value"
. " left join telbook_entries e1 on r.src=" . SqlCanonEntryValue("e1.entry_value")
. " left join telbook_persons p1 on p1.person_id=e1.entry_person"
. " left join telbook_entries e2 on r.dst=e2.entry_value"
. " left join telbook_entries e2 on r.dst=" . SqlCanonEntryValue("e2.entry_value")
. " left join telbook_persons p2 on p2.person_id=e2.entry_person"
. " where acctid=$1 and duration is null", array($_GET['active']));
}
26,9 → 26,9
. " p1.person_name as src_name, e1.entry_title as src_title,"
. " p2.person_name as dst_name, e2.entry_title as dst_title"
. " from cdr r"
. " left join telbook_entries e1 on r.src=e1.entry_value"
. " left join telbook_entries e1 on r.src=" . SqlCanonEntryValue("e1.entry_value")
. " left join telbook_persons p1 on p1.person_id=e1.entry_person"
. " left join telbook_entries e2 on r.dst=e2.entry_value"
. " left join telbook_entries e2 on r.dst=" . SqlCanonEntryValue("e2.entry_value")
. " left join telbook_persons p2 on p2.person_id=e2.entry_person"
. " where acctid=$1", array($_GET['detail']));
}