Make with PHP, Bootstrap, MySQL and AJAX so it auto refreshes every 30 seconds.
Database structure attached.
1) Make array, array will contain numbers like 2050, 2051 etc. Each number should also have another value attached, the name.
2) Your script will find data in table for each array entry matching field "src" for the last day
3) Then sum their "billsecs" and number of records. Then divide total billsecs by number of records
4) Display data for each in a box with the name above from the array. If four entries in array at start, should be four boxes with bill secs, number of records and average.
For layout, just simple grid. If there are up to 5 boxes, it should be one row, up to 5 columns and expand to fit page. If more than 5, it should split page into two rows.
Need this done in 1-2 hours.
Only want people who understand this, if you do in your bid say "need no clarification, can start now, finish in max 2 hours, will work on my own server"
need no clarification, can start now, finish in max 2 hours, will work on my own server
Hello,
So array would be like this :-
$arr = array(2005 => 'First', 2006 => 'second' ..... ); and we will iterate through each entry of array.
Then there would be two tables , in first table array field should be matched against src column and then relevant billsec entries would be pulled from second table and mathematical operation would be performed to calculate values ?
Thanks
"need no clarification, can start now, finish in max 2 hours,
I did not find database structure attached.
Please provide that so we can check and start work now.
Thanks
Hi! I have 6+ years of web developing experience, I can promise quality and responsibility. If it will take less than 5 hours it will cost 30$, if more than 5 hours than 11$/hour
Hello,I can complete your project on time and within your budget.I read through the job details extremely carefully and I am absolutely sure that I can do the project very well.
I will give you our best work with our best support.i will complete all tasks which you need ..
Please provide me more details of project i will start your project very soon.
Thank you!
Hello,
I am Akil khatri i am really interested to work on this project, I can start the work now , and can provide the best services from my end.
Please come on chat to discuss more about the project.
Regards,
Akil Khatri
need no clarification, can start now, finish in max 2 hours, will work on my own server.
Even tho, i know it;s about an asterisk report, and i can do things for you for asterisk because i have VOIP skills next to the development skils. I can do this very fast.
P.S. You didn't attached the database schema.
Thanks
need no clarification, can start now, finish in max 2 hours, will work on my own server.
I understand your requirement but I need more information about fields and table to extract the data.