Reading over some advanced invoice sub inventory search and report code. Making a plan and working on a new solution. The old solution took to long and was taxing on the database (multiple trips back and forth between database and loop iterations). The new solution will query the database, join certain tables, and then group and filter, group and filter. The end goal is to get to smaller and smaller sub results. Those sub results will then be used to display and provide data back to the user. A series of smaller funnels will help in the grouping and filtering process. The process also includes a scratch list and a clean list. The scratch list will hold all possible pieces based on the sub filtering. We will then loop over the scratch list and populate only unique entries into the clean list. This clean list will then be used to do a query of a query to limit the final results.

Lots of planning and rewriting and restricting code. The main pages being altered are the advanced_sub_invoice_line_search and advanced_sub_invoice_line_results pages. Lots of changes on both the forms (hidden values and visible values) and lots more work on the logic on the results page to show the values.