DROP VIEW v_stats_calls_old;
CREATE VIEW v_stats_calls_old AS
SELECT
 astium_cdr_old.uniqueid, astium_cdr_old.calldate, date_part('hour', astium_cdr_old.calldate) as hour, date_part('minute',
astium_cdr_old.calldate) as minute,
 astium_cdr_old.src as from_number, fromperson.firstname || ' ' || fromperson.lastname as from_person,
                         fromdepartment.name as from_department, fromcompany.name as from_company,
 astium_cdr_old.dst as to_number,   toperson.firstname || ' ' || toperson.lastname as to_person,
                         todepartment.name as to_department, tocompany.name as to_company,
 astium_cdr_old.duration as totaltime, astium_cdr_old.billsec as calltime, astium_cdr_old.ddi
FROM
 astium_cdr_old,
 contact as fromperson, contact as toperson,
 department as fromdepartment, department as todepartment,
 company as fromcompany, company as tocompany,
 contact, contact_company
WHERE
     contact.id=contact_company.contact
 AND contact.username ilike USER
 AND astium_cdr_old.src_contact=fromperson.id AND astium_cdr_old.dst_contact=toperson.id
 AND astium_cdr_old.src_department=fromdepartment.id AND astium_cdr_old.dst_department=todepartment.id
 AND astium_cdr_old.src_company=fromcompany.id AND astium_cdr_old.dst_company=tocompany.id
 AND ( astium_cdr_old.src_company=contact_company.company OR astium_cdr_old.dst_company=contact_company.company )
 ORDER BY calldate DESC;
GRANT SELECT ON v_stats_calls_old TO GROUP astium_users;

