all data is live and searchable



« Back . [new search - developer's notebook] . [new search - adilas community funded projects]
Basic Assignments
 
Options & Settings
 
Main Time Information
Color Code: Pink
Assigned To: Stephen Berkenkotter
Created By: Cory Warden
Created Date/Time: 3/18/2020 12:17 pm
 
Action Status: Completed
Show On The Web: Yes - (public)
Priority: 1
Finished/Done: Yes - 5/1/2020 1:16 pm
Finished/Done By: Cory Warden
Budgeted/Estimated Value: 1,950.00  
Actual/Real Value: 3,000.00   [donate]
Invoice/Quote Status: Blank (n/a)
General Amount: $0.00
 
Time Id: 1682
Template/Type: Community Funded Projects
Title/Caption: NJ DOH Gram Control
Start Date: 3/18/2020
End Date: Unknown... (open or blank)
Total Time: Unknown... (open or blank)
Target/Due Date: 3/18/2020
Main Status: Active
Sorry, no photos available for this element of time.

Uploaded Media/Content & Other Files (2)
Media Name   File Type Date Description
NJDOH Portal_Adding a Purchase.pdf   Doc/PDF 4/7/2020 NJ Patient Purchasing Information
nj gram control settings.xlsx   Doc/Spreadsheet 3/23/2020


Notes:

3/17/20: 1)Need a gram control that converts to oz's. 1/8th of an oz, 1/4 of an oz etc.
-Dynamic in recommended allotment (physician)= Patient(customer)
-Dynamic in available allotment (what can be purchased now)- another field in the gram control to the right of the +/-.
-Dynamic in output of reporting Qty, Conversion Chart (changing words from grams to oz's)

The gram control will need to consider THC by sub but will need to total into Ounces for reporting. 

4. ATCs shall only dispense oil in equivalencies of one-eighth-ounce and one-quarter-ounce of dried flower. Those equivalencies are:

  • 1/8 ounce – 354 mg of THC
  • ¼ ounce - 708.75 mg of THC

Additional Comments/Notes - Subs (3)
Title/Caption Date Time Done By Comment/Note
View 4/23/2020 8:05 am Stephen Berkenkotter
query
RESULTSET
query
 QUEUE_NOTES
12.0 Started new cart - 8:49:13 am. Started new cart - 8:50:02 am. Started new cart - 9:32:13 am.
CACHEDfalse
EXECUTIONTIME0
SQLSELECT queue_notes FROM customer_queue_1333 WHERE customer_id = 664992 AND corp_id = 1333 AND customer_queue_id = 6

2.0

 
Building the Logic 4/23/2020 8:04 am Stephen Berkenkotter

4/13 to 417 10 hours

4/20 to 4/23 5.5 hours - adding in the remaining grams. added to the queue notes and then pulled in as useRemaining 
Building Interface 4/7/2020 6:35 am Stephen Berkenkotter

4/4 & 4/5 - 3.5 hours on layout and connections to data. Corp 1333