Mysql making two tables, and generate php reports(repost)
$100-150 USD
Imekamilika
Imechapishwa over 12 years ago
$100-150 USD
Kulipwa wakati wa kufikishwa
make a DB with two tables, import a csv file and generate 4 reports
You can make it as standalone php or within joomla if you prefer.
This is an asteris Call Data record, and I will calculate som prices for the customers.
## Deliverables
DB:
Making the table: master with fields:
clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,start,answer,end,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield
Import the comma seperated file [login to view URL] by clicking a button.
Make a price tabel with the field: priceplan, accountcode, start landline, minute landline, start GSM, minute GSM
This is the field I want to list in the report:
the 'dst' field is a phonenumber. phonenumber that starts with 4 or 9 is cellphones.
src
dst
dstchannel. Modify it to: after "/" before "-" example: SIP/GSM238-0000548 will be GSM238
start= format [login to view URL]
end = format [login to view URL]
billsec
price = IF 'dest' start with 4 or 9 THEN price= 'start gsm' + ('minute GSM * 'billsec)
ELSE price = 'start landline' + ('minute landline' * 'billsec')
NOTE: minute in this case is seconds. For example: $calc= 'minute landline'/60
Reports:
All reports has condition: disposition=answered
1) from date to date with 'accountcode'= <INPUT> and 'priceplan' = <INPUT> (list fields)
2) from date to date with 'src' = <INPUT> and 'priceplan' = <INPUT>(list fields)
3) from date to date with 'accountcode'= <INPUT> and 'priceplan' = <INPUT> (list 'src' with sum 'price' with a total in the end.
4) and I also need a report that will sum up the cellphones and Landlines. Both sum price and how many