Subversion Repositories general

Compare Revisions

Ignore whitespace Rev 1401 → Rev 1402

/asterisk-stats/trunk/cdr_list.php
107,9 → 107,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"
. $query . " order by calldate desc" . $query_limit;
119,9 → 119,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"
. $query . " order by calldate desc" . $query_limit;