qr code inventory system

read QR codes to:

- add to inventory/location db

- indicate vehicle is being dispatched

- driver can scan when "on the job" to start billing client

- vehicle has returned from job (returning to yard).

- read data stored in db ... ex : last tuneup

Web Application

online browser tools

web based console can be used to manage service/deployment

ex: (send a pumper to job in Hinton) shows all pumper trucks

"this part/vehicle is scheduled for service"

Passing information from dispatch to yard:

Person managing console
sets up a "trip" for pumper truck 15:

- job:  NAL HZ COCHRANE 1-7-27-3

00/01-07-027-03W5/00  S   92.5M  E  115.1M    MIDNAPORE           

Start: July 23rd 2013

Other Instructions: _phone  Sue  403-555-1212___

This shows up when driver or yard person scans vehicle

Setup an item

screen to allow person to add item to inventory

FLOW is

1. QR Code is scanned

2. (lat,long) is read and attached

3. date/time is attached

4. item saved in remote DB as "newly deployed"

Query Item

"What is this doing here?"

1. Not deployed

2. part of build #1733 to Hinton, waiting for pumper

3. in for service, oil, filter, tires

4. waiting for driver 27 to start #1222 to Hinton

5. Back from well completion

6. Here to refill fluid tanks

Delete Item

to take out of inventory

Update Item

change something in the build

attach a trailer

add a mechanical device

Driver Functions

(using gps location)

1. Leaving yard

2. mechanical breakdown

3. checking in with the boss (I made it this far)

4. On site, begin billing

5. Problem on site, send replacement

6. All is going well on site

7. returning from job

8. Back in yard