Project Detail

Description

Mysql db
apache we server

db looks like

Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------------------+-------+
| calldate | datetime | NO | | 0000-00-00 00:00:00 | |
| clid | varchar(80) | NO | | NULL | |
| src | varchar(80) | NO | | NULL | |
| dst | varchar(80) | NO | | NULL | |
| dcontext | varchar(80) | NO | | NULL | |
| channel | varchar(80) | NO | | NULL | |
| dstchannel | varchar(80) | NO | | NULL | |
| lastapp | varchar(80) | NO | | NULL | |
| lastdata | varchar(80) | NO | | NULL | |
| duration | int(11) | NO | | 0 | |
| billsec | int(11) | NO | | 0 | |
| disposition | varchar(45) | NO | | NULL | |
| amaflags | int(11) | NO | | 0 | |
| accountcode | varchar(20) | NO | | NULL | |
| uniqueid | varchar(32) | NO | | NULL | |
| userfield | varchar(255) | NO | | NULL | |
+-------------+--------------+------+-----+---------------------+-------+


create an ajax or javascript page that refresh every few seconds

page will have

calldate clid src userfield, duration, billsec, disposition etc with the ability to choose current or search a specific, date (calldate) or dst

bottom of page will have 2 buttons, 1 to reboot linux server, one to shutdown