all data is live and searchable
|
Basic Assignments
|
Options & Settings
|
Main Time Information
|
||||||||||||||||||||||
|
|
|
Yellow
|
|
|||
|
|||
|
|
|
Notes:
|
|
Project: Adding the driver’s license field to the customers table 1. We need to add the field to the database a. Name = driver’s license b. Datatype = varchar c. Size = 100 d. Default = Null 2. We need to script that change… this allows us to update all of the other systems a. Show Steve how to do this… 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 out to the action file – 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 those methods to see if we cascade i. We also need to search for all instances of “INSERT INTO Customers (“ 5. We need to check eCommerce land… adds, edits, validation, actions… 6. We need to the driver license to the customer log cfm 7. We need the same field (showing it or outputting it) on the customer gallery, customer history 8. We need to add it to the quick search a. Tying it underneath the normal customer search field for quick searches i. New or clause 9. We need to add the field to the advanced customer search cfm 10. We need to add the same field to the output or search results page – advanced customer search results cfm 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 11. We need to check other places where customer gets exported to excel 12. Get a sign-off on new code changes 13. Clean-up – we need to modify help files and push all new code to all servers 14. Billing for the project - $400 Sketch – Testing protocol flow & testing from different sources: (see sketches on scan in photo gallery) D – Delegate I – Inspect A – Approve ADILAS: A – Acquire, Accepts, Approve Requests D – Delegate to our team, Determine the scope, goals, budgets (internal project management), planning, timelines, assignments, expectations, testing, validations, multi-source or access, non-linear & special cases, future proofing I – Inspect – details, microscope, inspect what we expect, iterations (going through the testing and processes), develop, local, test local, simulate live, get sign-offs (project managers & supervisors lead) L – Love (use, them, you), logging and communication, love (feedback, customer, developer, encouragement), logistics, learning. A – Approve – clean-up, upload, feedback S – Submit – close out project, push code, bill, etc. Water – snow – ice Project: WA State API 1. Jeremy has a java class (functions) written and mostly done 2. He was going to be converting those classes into a CFC 3. I have an assignment to create a holding container for the username, password, license number, and use WA API (yes/no). This is a 3rd party piece and will end up storing a JSON object. 2 hours 4. Test and run it…. 5. Cascade code around the adilas site for usage… Project: Swipe a driver’s license to see if person exists: 1. What is the scope of the project… a. We have to have a swiper b. Customer page to accept this date – new interface page tied to the chooser c. Trying to key off of the license field – tearing apart the scan i. From FORM scope to the variables scope (drawers 3 to 1) 1. We need first and last name, driver’s license, all of the raw data d. From variables scope (drawer 1) to session scope for temp storage (drawer 4) e. If we find a match, go to that page or customer log f. If no, we need to have other options… i. Flip to a first name and last name search 1. Truncate to the first 3 of the first and first 3 of the last name a. Check for a match on both first and mini last (3 chars each) b. Check for a match just on mini last name c. Check for a match just on mini first name |