Simple JS Function Question
Out of context: Reply #6
- Started
- Last post
- 16 Responses
- esko0
yes the activities are linked to the jobID.
For this example I am making use of these tables.
Billings (tracks progress)
Activities
ChangeRequestsBillings holds information about how much of the project is finished. So whenever a user updates this page I am making it so that the progress for each Activity is tracked in the billings table.
Activities holds all of the information about the activity, like the description, start date, end date, how much it's going to cost, how much it gets billed.
ChangeRequests holds info about any changes that were made to an activity, this can make the cost of an activity go up and down but that is calculated on the page I am asking about, they do not directly affect the field in the activities table for the cost of the activity.
So this page is allowing the user to put in the percent complete for a given month, and it will grab that information without reloading the page etc., using an invisible iframe that updates the database when they click out of the text box for inputting the percent complete.
I grab some information out of the fields, do some calculations and store that, and grab some more info from some hidden fields and send it to the update page. Which creates a new record in the billings table with that days date input also.