I am looking to extend the functionality of the existing application. It currently handles only a single service type (i.e. internet). I want to now include a second service type with a different set of data:
• Plan Name (text)
• Total Cap Value ($)
• Any Network Cap ($)
• Same Network Cap ($)
• Included Data (MBs)
• Excess Data Rate ($)
• App (text, auto populated)
• Updated By (text, auto populated)
• Last Access (date, auto populated)
The current method of calling the app would need to change from [url removed, login to view]
[url removed, login to view]
If service=internet, there would be no change to what happens now. If service=mobile, no change to the program logic but we need to return a different set of results from a different table within the same database.
These results should look something like:
Plan information found.
T=Total Cap Value ($) from table
A= Any Network Cap ($) from table
S= Same Network Cap ($) from table
D= Included Data (MBs) from table
E= Excess Data Rate ($) from table
If the plan isn’t found it’s automatically added and flagged in the table like it currently does with the other table. The management functionality should remain the same as before with this table being integrated into the one admin interface.
I want to be able to make a call to a php script on my website that performs a search and returns a response based on what was supplied. If the search item doesn't exist, it should be added to the database. The url will be encoded.
For example (in my app):
var uri = "[url removed, login to view]"+encodeURIComponent(planName);
If the planName exists, the script should return the values in the table row relating to that plan seperated by a newline (\n):
R=Result (will be "FAIL" or "SUCCESS")
P=Peak Quota (amount shown in MB)
O=Off-Peak Quota (amount shown in MB)
U=Uploads Included (will be "TRUE" or "FALSE")
V=VoIP URL (will be the URL for VoIP usage)
If planName doesn't exist, it should be added and flagged for admin action. Result should be FAIL and email sent to admin
Admins should have a login that views the database contents and enables them to adjust values in each row and save.