ucdavis/anlab

Order and results management system for http://anlab.ucdavis.edu/

Anlab

Order and results management system for http://anlab.ucdavis.edu/

Build + Run

Have a recent version of NodeJS installed (https://nodejs.org/)

Have latest version of .Net Core installed, current v1.1 (https://www.microsoft.com/net/core)

Get the app settings from Box and put them in your secrets location (on MacOSx, ~/.microsoft/usersecrets/f3c999a5-2304-44e0-a49e-f43333bf9ccf)

[If you don't have visual studio]

// Go to the Anlab.Mvc website directory

// first time, or when modules change

npm install --legacy-peer-deps

dotnet restore

// when you are ready to debug locally

npm run debug

[If you have visual studio]

// Just open it up and run the project!

anlab's Issues

Test sloth lookup

$ 505 - 5048969607636377803523
$606 - 5048977758306400003525
$707 - 5048978537866588703527

pull clientID from labworks as part of order

[ValidateAntiForgeryToken]

Add where missing

Regex

https://github.com/ucdavis/Anlab/blob/master/Anlab.Core/Domain/TestItem.cs#L13

I don't think we can filter it like this. There is a test with a code of () in the data we are pulling.
This is probably not a public test, but we have to allow what Labworks allows.

For a request id

Look up all the codes for the order and their prices/costs and over-write/update our json order details. (When they post the results excel?)

Filter test items on admin screen by category

Test Items Key

I think the key must be made up of the id (code) and the Category. Otherwise we will have issues with Grind and Wrap

Getting completed tests from Labworks

Maybe we should only return tests that have a $ amount. Then throw an exception if it isn't in our DB.
Otherwise our totals may/will be off if our db's test items are not synced with labworks.

Place Order vs Update Order

Change "Place Order" to "Save & Review

Remove lab component from react.

Instead on the receive page, add fields for Lab comments and adjustment amount

Partial scripts

Do cdn's like the dataTable

Pacific Time

Need to do this.

Meeting Note LabWorks Walk through 2017/08/24

• Hundreds of orders per year
  -# means group
  -() is used internally to mark a order as complete. We should filter it out of our queries.
  -Need a date Sampled field for the client
  -Rush can affect final price as a multiplier
  -RequestNum should be entered when received. We should do a duplicate check as it must be unique. (Maybe just our DB)
  -They can have Partial Results. These would be over-written when order is complete, but we need a way to upload and display to client.
  -Historical Prices...

1. We need to save these when the order is completed and not re-query the database as they will change each year.
2. At change over we may have an issue with KFS. The old prices are not (maybe) available, but KFS currently is shown a breakdown for each test in the scrubber. If we generate the scrubber, we will need a way to get the old price, not just use an adjustment (Maybe)

Davis will prove us with

1. the place we will pull the setup cost (currently does not exist)
2. A couple requestNumber (LogBatch) along with the final price so we can test (Internal/external, rush, no rush)

Change "Place Order" to "Save & Review"

since it doesn't actually place the order

Not showing what the error is

/Lab/Orders should sort by most recently updated

NumberInput Component validation not working

Can enter a zero
type in letters, error appears and stays but clears out values.
Need a required validation.

Setup Cost

If this isn't in the DB somewhere, use a config setting.

Receipt page

Can't check creator Id as anyone may have paid it.

Quantity Validation

Need to make sure quantity is a positive whole number

Editing Orders

Decide what we want to do about editing an order past the received status. (Push an update to lab works? Doesn't allow edit once received?)

pull quantity as part of order update/finalize

UC Account field needs to be bigger to hold sub account

3-BG13DOE
L-727ST30
L-727VR17
L-727STN3
3-APSV016/FJHL2
3-CETLPG7
3-APSPT31/FPHB2

Change TestItems Key

Make the id a string and set it to the code value

Move order mods out of the admin controller.

Maybe LabController

Column for test item icon

When a test item has notes associated with it, have an icon in the test items table to indicate that.
Maybe a null able int that we can have associated with a font awesome icon

/Lab/Confirmation needs comments and adjustment amount/total

In the email we sent someone after their order has been received, we need to send along the comments and adjustment info so they know why the amount changed.

Error Page?

Store all tests and processing fee along with order when received

After order is logged in, prices should reflect price at the time the order was received by the lab

Lab/UpdateFromCompletedTests

only allow excel uploads (*.xls, *.xlsx), and maybe only allow only filenames which contain the request number for the current order

client email entry for anlab's "copy-to"

Once we decide we want to allow multiple, let's go with something like http://prakhar1989.github.io/react-tags/example/.

Rename projectId on create form

Project Title, name, etc

Results Excel Upload

All the things:

1. Blob storage for the attachment.

KFS API for looking up account numbers

Tooltips!

Add tooltips to fee/price/total section

Add bootstrap tips

Get info from the db.

/Lab/Details should be removed

All they can do is confirm receipt. If we want to keep the details on that page, that's fine, though maybe we want to hide them under a collapse (in the future).

Pull updated quantity/client id/etc from labworks

we need to also pull any info that might have been updated before finalizing now that there is no lab edit

Figure out how to order the test items

might need one ordering for clients (alpha?), and one for labworks

Stackify Logging?

Real setup cost is Multiplier * SetupCost

Adjustment Amount

Need to default the Adjust Final Total: amount when the finalize page is opened.
And/Or, need a validation that a blank value isn't allowed.

Otherwise, if they go in and finalize without entering anything it zeros out the grand total.

On lab receive make sure requestNum is not already used

make sure there are no existing orders w/ that request number already used, and update the model to make that property in order.cs a unique field.

Kill the ID columns that use our PK

KFS Account Lookup

An attempt to have them verify the account they enter is the correct one

Intellisense for css

Resharper needs the css file to exist in the project for Intellisense.
Consider having the webpack build for dev, use cdn for prod, but fall back if not found.

Processing Fee

Processing Fee needs to be added into the total for the order

Fix Display of adjustment amount

e72cf08

Adjustment amounts can be negative as well

If ClientID is unknown, enter necessary new client info

TBD