Putback Report - Prep for PA2 Release
Clayton Carter
part of the run up to a new version, PreAlpha2, hopefully to be out
later this morning.
CropPlan and CropDB
* improved display of filtering components
HSQLDB
* implmented new static calculation for the coalesced/calculated queries
* added maturity_adjust to those calculations
* fixed columns to sort the most important up to the top of the list
* fragmented the resultSetAs... methods so that, when a column isn't
found, most data will still be returned
* created a couple new static methods to retrieve ints and floats from
ResultSets while nicely detecting when they are null
* fixed text filtering to properly AND phrases together
* added var_name as secondary sort column when sorting on crop_name,
crop_name as secondary on all others
* nulls should show up at the end of sorted lists now
* fixed some problems with common info queries
* major fix to SELECT of crops and varieties: simulating a FULL OUTER
JOIN by creating a UNION of a LEFT and RIGHT JOIN
* moved planting SELECT from a standard INNER JOIN to a LEFT JOIN
* the two above changes should make records less funky: blank records
will now be displayed and duplicate records will now be displayed the
correct number of times (instead of double that)
CPS-Spec
* created the idea of "DataOutput" and "DocOutput" dirs, both point to
same place, for now
* created a new "search field" that sort of mimics the iTunes search field
* improved calculated: added new calcs for rowfeet/beds/plants from
desired yeild, maturity adjust is now taken into account, global
default bed length from settings is now used
* added static methods to the complex filter class to retrieve
"common" filters: just DS and TP for now
* added +/- parsing to the date validator class
* date +/- also supports 'd','w' and 'm' at the end of the +/-
expression, causing it to read the figure to add or sub as a day, week
or month
* disabled some calculations when a Planting represents common info
* added util method for simple testing of whether a planting/crop is a
single record or reps a number of records
* misc changes to support some numbers that can legitimately be
negative (mat adjust, for one)
* numerous changes to the GlobalSettings class to turn it into a
mostly static-ly accessed class
* also, conflated the old CropPlanning.GlobalSettings with the CPSGlobalSettings
Clayton