project - adding in a due date for invoices

started on 12/13/17 with brandon and russell

branch BWM-33

- we need to add a new column to all invoice tables. this is corp-specific.

- we talked about populating all older invoices with a due date of today's date plus 14 days.

- we may need to add a setting to help set the default due date - aka - how many days to push the original date forward.

- we may need a setting to see if the corp wants to even use a due date

- add/edit on the settings

- add/edit in the shopping cart

- edit main on invoices

- question - what about transitional invoices? technically, they aren't really hitting accounts receivable until they get flipped into real customer invoices...

- all of the view cart pages need a new possible field to change (there are tons of custom carts)

- ecommerce invoice will also need to be able to auto generate the due date based off of the settings.

- we'll need to run database updates on servers. this will be corp-specific due to number of invoices.

- we may need to pre-load the cart session scope in order to make sure that the value exists. secure cart and ecommerce carts.

- we need to show the due date (if used) on the invoice line items, edit main, and all printable invoices (mini, printable with nav, pdf, limited, printer friendly, ecommerce, afb, etc.)

- reports... what reports need to show the due date? invoice homepage, advanced invoice reports, receivables reports, make payments, invoices owed per customer, etc.

- help files to update

- steve to do a news an update on the new settings and feature

- exports to excel or csv...

- what about any api sockets that search or touch that table?

- what about duplicating an invoice to the cart? do we auto adjust the new due date?

- rough time budget... 6-10 hours

- what do we want to call the variables, session stuff, FORM stuff, and database fields?
	- on invoices_[53] table
		invoice_due_date date 0000-00-00
	- on corporations table
		use_invoice_due_date tiny int(1) 0
		default_days_to_invoice_due_date int(10) 15
	- on the session shopping cart
		session.myCart_st.myInvoiceInfo_st.invoice_due_date
		session.myCart_st.myInvoiceInfo_st.use_invoice_due_date
		session.myCart_st.myInvoiceInfo_st.days_to_invoice_due_date

- what pages will this project hit?
	database_updates/update_home.cfm
	datebase_updates/update_20171213.cfm
	cfc/maintenance.cfc
		- add the new values to the add corp methods
		- both corp-wide settings and invoice stuff
	secure/corp_wide_settings.cfm
		- add new page counting vars
		- looking at spot # 33
		- pull new values into the page through method call
		- add the two new corp-wide settings and display current choices
		- update help file and verbage
	secure/corp_wide_settings_action.cfm
		- new params
		- validation
		- code to hit add and edit methods
	secure/add_to_cart.cfm
		- pass in corp-wide settings for the use invoice due date and the days to invoice due date
		- these values will be dealing with setting up a new cart
	secure/view_cart.cfm
		- be able to show/hide the due date based on settings.
		- if showing... allow to edit
	secure/update_cart.cfm
		- be able to update the due date if it is different or force it every time. if the date changes, we need
		  to auto cascade the due date forward. otherwise we keep it what it was incase the user has hardcoded the date.
	secure/printable_cart.cfm
		- just be able to show the due date if used
	secure/review_cart.cfm
		- just be able to show the due date if used
	secure/printable_invoice.cfm
		- just be able to show the due date if used
	secure/print_simple_invoices.cfm
		- just be able to show the due date if used (as a note, this one allows multiple invoices)
	secure/print_limited_invoices.cfm
		- just be able to show the due date if used (as a note, this one allows multiple invoices)
	secure/mini_invoice.cfm
		- just be able to show the due date if used
	secure/apply_payments.cfm
		- just be able to show the due date if used
	secure/invoice_line_items.cfm
		- just be able to show the due date if used
	secure/add_edit_invoice.cfm
		- show or allow the date to be flipped based on settings.
	secure/add_edit_invoice_action.cfm
		- new params
		- validation
		- add to methods
	pdf/show_printable_invoice.cfm (it will show as pdf/printable_invoice.cfm but it is really show_printable_invoice.cfm)
		- just be able to show the due date if used
	secure/invoice_home.cfm
		- just be able to show the due date if used
	secure/advanced_invoice_search.cfm
		- add to the date type selection
	secure/advanced_invoice_search_results.cfm
		- show the due date if used
		- this one also has an export to excel
	secure/customer_invoice_report.cfm
		- just be able to show the due date if used
	secure/view_transition_dates.cfm
		- this is for transition invoices... not sure here. maybe just show it or allow it to be set manually
		- this page has an action page... do we auto calculate the due date or get it physically passed from the prior page? not sure.
	secure/submit_cart.cfm
		- make sure and stamp the due date on the main invoice
	shop/web_payments.cfm
		- just be able to show the due date if used
	shop/web_view_history.cfm
		- just be able to show the due date if used
		- this page does toggle between invoices and quotes
	shop/web_invoice.cfm
		- just be able to show the due date if used
	shop/web_submit_cart_final_[fill in].cfm (invoice, paypal)
		- we need to stamp the due date when adding the main invoice