talking with bryan about ideas for this report - end of august, first part of september 2019

numerous sections... some questions, some plans, some just scratch paper.




- maybe shawn and I work on back filling data

- what about joins...

- what do we have?

- where do we still need help?

- brandon had some questions
	- which table do we start with (required data)
	part cats
	sub inv attributes
	parts
	time sub inventoy
	custom dates
	custom numerics
	custom text
	po invoice lines

- what is our filtering process and/or funnels?

- what about older black box clean-up...?



/////////////////////////////////////////////////////////////////////
process: branch BWM-45 (created on 9/5/19)
	- go to advanced_invoice_search.cfm
		- at the very bottom, choose a part cat (real or all)

	- this goes to the advanced_sub_invoice_line_search.cfm
		- the FORM field is part_category_id
		- select=0, all=1 and other cat=real id
		- i've got a ton of page params...
			- are they all there and good? fixed
			- i may need to add in some dynamics - not sure - fixed

		- what do i need as far as dynamics?
			lc_attribute_name_[x] >> lower case
			attribute_category_list_[x] >> what part categories does it belong to (list)
			attribute_data_type_table_[x] >> this will be the string custom_text, custom_numerics, custom_dates
			attribute_search_value_[x] >> what to filter by
			attribute_search_value_from_[x] >> from value for dates
			attribute_search_value_to_[x] >> to value for dates

	- on to the advanced_sub_invoice_line_results.cfm page
		- i setup some holding vars called:
			showColumn[x] = show/hide (string) - default is hide
			column[x]TotalLength = 0 >> this will hold the total length of the results >> we will use this to flip the show/hide value

		- i have a list called activeSubAttributeFilter_list >> it will only show attributes that need to be filtered

		- i have a general query called qryGetAllSubAttributes that has basic sub attribute info in memory
		
		- i have two lists to help with the first round filtering and grouping.
			scratchSubIdFilter_list >> everything that matches
			cleanSubIdFilter_list >> eventually will only hold matching records.

		- once everything is filtered, i have a query called qryGetSubInvoiceLinesFiltered

		- the final round of grouping creates a list called finalRoundSubIdGroup_list

		- the unsorted sub attribute values are in three queries
			qryGetUnsortedTextValues, qryGetUnsortedNumericValues, qryGetUnsortedDateValues

		

		- looking for the following values (output)
			customer name >> business or first/last combo >> our counter sale
			customer tax id >> needs dynamic naming
			sub id
			invoice number
			vendor name >> business or first/last combo
			date
			category name
			category id
			part number
			part id
			location
			quantity
			cost
			price
			rfid tag
			time id
			sub barcode
			description
			attributes >> dynamic


	- for testing
		Corp: 741, payee: 41350, data8 server