Presage/Recent Application Changes

CrystalReportsExtension:

• Changed: (Case 10612) if the user prints a report with 'advanced options', the printer dialog that pops up now has a quantity field on it, which will be used to override the number of copies to print.

Database:

• Added: the sample table now has an optional reference to the product table for when samples begin to be collected for products.
• Added: the analysisoptionchoice can now have a reference to a product, allowing thresholds to be product specific.
• Changed: products are now global, except there is the ability to specify which plants each product is "In Use" at.
• Changed: p_get_location_subtree has been generalized into p_get_subtree, which can return a group_concat of primary keys of any simple hierarchical table.
• Added: support for product attachments.
• Added: permission for modifying products.

Products:

• Added: "Show inactive products" checkbox, which filters the product tree to just active products.
• Added: add/delete buttons to the bottom of the screen similar to the add/delete buttons on the location interface.
• Added: Similar to deleting analyses and locations, the system now checks to see if deleting a product is 'safe' (IE if its currently in use on saved samples or analyses). 'Unsafe' deletes require a permission to complete.
• Added: the product detail page now fills data out as the user selects products, and changing values is updated in the tree immediately.
• Added: there is now a "Show this product at the current plant" checkbox, which is a per-plant setting controlling whether a specific plant wishes to see the specified product in its product list.
• Added: saving products now properly updates, creates, and deletes products.
• Fixed: hitting the refresh/reset button now correctly reloads data from the database, discarding changes.
• Added: there is now a column for whether each product is in use at the current plant. This will switch automatically as the user switches plants.
• Added: The "show inactive products" now remembers the user's last choice.
• Added: permission for whether user can modify products. The user must have global permission to add/edit/delete products.
• Added: product attachments are now functional. The attachments tab now displays the number of attachments loaded for the currently selected product.
• Added: adding and removing products now works as expected.
• Added: new products inherit many options from the parent Product.
• Added: the category dropdown now shows all previously entered product categories.
• Fixed: an issue where deleting a product would delete all child products, no matter what the user chose.

CommonResources:

• Fixed: an issue where the WO screen might show the wrong analysis options if more than one analysis shared the same name.

Analysis:

• Fixed: (case 10522) an issue where changing plant in the analysis screen wouldn't refresh the options in the severity class dropdown for thresholds.
• Added: there are 2 new columns in the analysis list which allow the user to control how many copies of the sample tag and testing tag get printed out when printing WOs. These settings are plant-specific so each plant can have different quantities for the same analysis.
• Changed: the apply and reset buttons have been re-arranged to match the apply and cancel button order in most windows applications.
• Changed: the pop-ups that happen when the user is going to delete an analysis are now more consistent and show the number of samples and scheduled locations that will be deleted always.

CommonResources:

• Added: (case 10609) the user can now print a quantity of tags other than 1. The last reprint quantity is remembered, so reprinting the same number of tags in the future is easy.

Database:

• Removed: some (now) unused fields from the analysis table.
• Fixed: the version of f_get_next_day_of_week that was released previously was out of date.
• Added: a new permission for allowing access to the product management screen.
• Added: (case 10551) table for storing product information.

Product:

• Added: (case 10551) a new 'product management' screen, wherein the user can manage products, ingredients, and recipes.
• Changed: the attachments button has been removed and replaced with an attachments page.
• Added: the plant dropdown is now filled with plants.
• Added: opening the screen now properly loads all products into the product tree, but the user cannot edit them yet.

Sampling:

• Added: (case 10187) the plant auto-complete dropdown now only shows the user options for the set of plants that are selected.
• Changed: this screen is now called "Sampling History" in the main menu.

WorkOrders:

• Fixed: an issue where new work orders were saving the date, but not the time they were created.