all data is live and searchable
|
Basic Assignments
|
Options & Settings
|
Main Time Information
|
||||||||||||||||||||||||||||||||||||||||||||
|
|
|
White
|
|
|
Sorry, no photos available for this element of time.
|
|
|
|
Notes:
|
|
Notes on completed project. Project - Add a new drivers_license field to the customer table - blum - emerald green Steps 1.Add the field to the database a. Name = drivers_license b. Data Type = varchar c. Size = 100 d. Defult = null 2. We need to script that change ... this allows us to update all the other systems. a. Brandon do and show 3. We start at the add process. a. Add a new field to add_edit_customer.cfm 4. We need to cascade that field all the way out to the action field. add_edit_ customer_action.cfm a. Add validation b. Add to the add method c. Add to the update or edit method d. Unknown - Search other methods to see if we need to add to other methods. also search for INSERT INTO customers (" also check eCommerce land .... adds, edits, validations and actions. 5. We need the drivers license to the customer_log.cfm 6. We need the same field (showing it or outputting it) on the customer gallery, customer history 7. We need to add it to the quick search - search_action.cfm or is it the customer_search_action.cfm a. Tying it underneath the normal customer search field for quick searches i. this is just another or clause 8. We need to add the field to the advanced_customer_search.cfm 9. We need to add the same field to the output or search results page - advanced_customer_search_results.cfm - cfcSearch13? a. WE also need to make sure that we pass the correct values to all other including refine search, pagination (next page of n) as well as exports to excel 10. We need to check other places where customer gets exported to excel 11. Get a sign-off on new code changes 12. Clean-up we need to modify help files and push all new code to all servers. a. Pages to upload data0 - x data1 - x data2 - x update_20150126.cfm - 0x 1x 2x assets.cfc - 0x 1x 2x search_13.cfc - 0x 1x 2x search.cfc - 0x 1x 2x add_edit_customer.cfm - 0x 1x 2x add_edit_customer_action.cfm - 0x 1x 2x 3 customer_log.cfm - 0x 1x 2x customer_gallery.cfm - 0x 1x 2x customer_history.cfm - 0x 1x 2x advanced_customer_search.cfm - 0x 1x 2x advanced_customer_search_results.cfm - 0x 1x 2x custom/full_customer_list.cfm 0x 1x 2x 13. Bill for the project - 400 |