Find Jobs
Hire Freelancers

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
Kitambulisho cha mradi: 3592701

Kuhusu mradi

9 mapendekezo
Mradi wa mbali
Inatumika 13 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
See private message.
$101 USD ndani ya siku 19
5.0 (2 hakiki)
2.3
2.3
9 wafanyakazi huru wana zabuni kwa wastani $110 USD kwa kazi hii
Picha ya Mtumiaji
See private message.
$119 USD ndani ya siku 19
4.9 (72 hakiki)
4.8
4.8
Picha ya Mtumiaji
See private message.
$125.80 USD ndani ya siku 19
5.0 (9 hakiki)
4.1
4.1
Picha ya Mtumiaji
See private message.
$110.50 USD ndani ya siku 19
5.0 (44 hakiki)
3.9
3.9
Picha ya Mtumiaji
See private message.
$107.95 USD ndani ya siku 19
5.0 (1 hakiki)
2.1
2.1
Picha ya Mtumiaji
See private message.
$127.50 USD ndani ya siku 19
5.0 (1 hakiki)
1.8
1.8
Picha ya Mtumiaji
See private message.
$100.30 USD ndani ya siku 19
5.0 (3 hakiki)
1.7
1.7
Picha ya Mtumiaji
See private message.
$100.30 USD ndani ya siku 19
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
See private message.
$100.30 USD ndani ya siku 19
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya NORWAY
Sandnessjøen, Norway
4.9
77
Njia ya malipo imethibitishwa
Mwanachama tangu Sep 24, 2011

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.