[OGo-Discuss] phone call information to contacts in ogo

[Sebastian Reitenbach]

Hi,

I know this was discussed several times earlier, and the end was there 
should be sth. like a general journal application, sth. like that.

well, I won't go and write such a complete yournal, but I'd like to do the 
following:

first, enhance the database layout with a new table, to contain the call 
detail records, taken from the asterisk:


CREATE TABLE `cdr` ( 
`calldate` datetime NOT NULL default '0000-00-00 00:00:00', 
`clid` varchar(80) NOT NULL default '', 
`src` varchar(80) NOT NULL default '', 
`dst` varchar(80) NOT NULL default '', 
`dcontext` varchar(80) NOT NULL default '',  
`channel` varchar(80) NOT NULL default '', 
`dstchannel` varchar(80) NOT NULL default '', 
`lastapp` varchar(80) NOT NULL default '', 
`lastdata` varchar(80) NOT NULL default '', 
`duration` int(11) NOT NULL default '0', 
`billsec` int(11) NOT NULL default '0', 
`disposition` varchar(45) NOT NULL default '',  
`amaflags` int(11) NOT NULL default '0', 
`accountcode` varchar(20) NOT NULL default '', 
`userfield` varchar(255) NOT NULL default '' 
); 
 
ALTER TABLE `cdr` ADD INDEX ( `calldate` ); 
ALTER TABLE `cdr` ADD INDEX ( `dst` ); 
ALTER TABLE `cdr` ADD INDEX ( `accountcode` ); 

Either the asterisk/callweaver is writing the information directly into the 
ogo database then, or is using an own database, and the info is synced to 
the ogo database. At least that would be sth. I think I could implement, as 
I have no idea how to deal with two different databases at the same time, as 
the telephone numbers have to be compared between these two.


Then I'd create a new tab to the AsteriskUI:
http://docs.opengroupware.org/Members/buzzdee/asterisk/AsteriskUI/view?searchterm=AsteriskUI

where people, belonging to a special ogo group, are allowed to search and 
create report, e.g. all calls within a given month, to or from a given 
extension/external number, ... stuff like that, I'm open for suggestions.

further I'd like to add a new tab to the personUI, where the call logs are 
shown either in a list, or like the appointments tab, as a calendar, sth. 
like that. Or just add a checkbox to the appointment view, that allows 
to "show me the phone call records" to this persons telephones.

Well, as phone calls records can be seen as sensitive information, I think, 
some access rights or additional filters would be needed later.


Any comments on this are welcome.

Sebastian