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.
branch = BWM-45




- 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.
			**** needs help - as a side note, we ran into a problem with the scratch list and the clean list
				we were able to get the list cleaned up, but it was not applying all of the filters.
				we need to rework the code so that it is exclusive and gets matches from more than one of the sub filters.

		- 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

		- plug into the source

		- loop with start and end values in mind (pagination for different reports)

		- use arrays, indexes, query current row #'s to mix data

		- setup and use blank values as defaults. use 0 (zero) lengths as defaults for show/hide columns.

		- fill in data

		- add up length sums to figure out show/hide columns. figure out column counts.

		- show output, light formatting and light logic on the display

		

		- 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

	- test the web output pagination. we are filling arrays with missing indexes (pagination and next n records). make sure it all works.

	- on the pagination, make sure we pass the dynamics

	- we also need to be able to pass data back to the search page as a refine my search option.

	- check the *'s above for problems.