Phase 2 Addendum : May 4th, 2010 (Complete, pushed live on 5/5/2010) 1. Create excel data dump of ProjectView 2. Files -- dsp_projectViewSearchResults.cfm -- model_projectViewSearchResults.cfm -- inc_displayViews.cfm -- act_extractData.cfm -- cfmod_extractData.cfm Phase 2 : Development Begun on March 15, 2010 1. Add capability to quote same item in multiple decorations -- COMPLETE, do additional testing. 2. Add capability to apply same decoration to multiple items -- dsp_QTpatternImage.cfm || ALSO: dsp_QTpatternImage_uss.cfm -- ISSUE: is there an issue where certain cats can't be mixed because of business rules? -- ISSUE: on action page, does uss become a problem/factor? 3. Sample requests default to shipping address of requesting agent -- address should auto-fill in comments section -- COMPLETE 4. Ability to manually enter sku numbers no available in db -- frm_skus (validation) -- ISSUE: if qty value input, was sku provided? -- act_skus.cfm -- ISSUE: normally, we qeury for db sku info : CustomFld_1 as standardCost, CustomFld_3 as QTeligible, CustomFld_5 as sizeCat -- dsp_patterns -- QUESTION: do user supplied skus need to be doctored? -- act_quote.cfm -- ISSUE: normally, we qeury for db sku info : CustomFld_1 as standardCost, CustomFld_3 as QTeligible, CustomFld_5 as sizeCat -- COMPLETE, with issues & questions noted above. 5. Dealer mark-up -- more discreet label 'dm' no Dealer mark up' -- COMPLETE, modified dsp_details.cfm -- ability to change dm on 'quote' page and on 'edit quote' page -- COMPLETE, is validation necessary on the two forms 6. Ability to print summary pdf pages for all projects taht includes key info -- major heading info -- items and quantities -- decoration by item -- colors -- other comments 7. Expand project list -- show all major heading detail -- new info: --- quote, quick turn or custom --- artboard request --- sample request --- status : open/sold/lost/dead --- ability to sort/filter by agent and project Developer Notes 1. Since we are using sku and skuid at various times, are all queries where clauses accounting for this? 2. Does qmd_updLineItem2.cfm need to account for comboId? 3. qmd_getJobLineItem.cfm - modify calls as this no longer YN passed in. -- also qmd_updLineItem.cfm -- also qmd_updJobLineItem.cfm 4. browser testing :) 5. find a way to collapse the two patternImage forms. 6. on both quote and editQuote are the update/dm functions working properly. Set up 2 combos and interrogate. 7. the query on getOthersSkus has been modified, is this correct?? 8. add ability to decorate multiple custom skus, after cleaning up regular code 9. add decoration info when sample request is made