Projects – QR Code based Work Order Completion – Construction

<-Previous || Table of Contents – QR Code based Work Order Completion || Next->

 QR Codes on the new work order ticket format

On the current work schedule page, users select Print QR Code (selected by default)

qrcodeselect

The QR Code is printed on the right side of the new ticket format.

qrcodeticket

QR Code reader

The reader reads QR Codes into Shadow database. The user needs to be authenticated by CAS. Only after a work order has been loaded completely, the reader allows to read the next code.

Login Screen displays first; username and password are saved and displayed in the next login. Javascript runs on UIWebView and gets username/password from UITextField then programmatically puts username/password in the HTML Input in UIWebView and programmatically “click” submit button in UIWebView.

Stand-by screen waits for users’ touch on the camera icon to scan, or on the note icon for report.

Scan screen captures the QR Code and sends a request to PHP (with wo_number to mobile/fac_wo_complete_json.php). PHP saves date_record, user_id, wo_number, last_mod_date, wo_status. Need to wait each time pressing buttons UIWebView object needs to finish the loading to avoid losing information. Buttons are disabled during the waits to make sure the webview finishes loading.

Report display work order numbers which were scanned but not loaded, together with names of scan staff and NetIDs, scan date; users can search by keywords

IMG_7790IMG_7783IMG_7784IMG_7785IMG_7787

Recorded Work Orders to Complete Report (fac-wo-complete.php)

Shows the work orders that have recorded, recorded date, recording user and work order status.

Work orders that were CANCELED, CLOSED are not going to be read.

The system returns a message “Work order xxx was either CLOSED or CANCELED previously” if a work order was in those status.

The system returns a message “Work order xxx was recorded previously” if a work order was recorded before.

The system returns a message “Work order ticket xxx has been recorded” if a work order is recorded successfully.

These messages can also be sent back to the QR Code reader theoretically if needed.

qrcodewo

Work order for completion loader

Written in Java, theoretically can run on any computer and platform.

FAMIS Work Order Closing form needs to be opened before running the loader. After starting the loader, the user then logs in CAS using NETID/password. To load data from FAMIS_REQ_COMPLETED, the user needs to click the button Load, then switch to the Work Order Closing form window. The loader then reads work orders that have been recorded using QR Code readers into the table FAMIS_REQ_COMPLETED in SHADOW but are not in “CLOSED”, “CANCELED”, “COMPLETED” in FAMIS Proper. During the load, the computer should be left untouched (mouse + keyboard).

WQRLoaderLogin

WQRLoaderMouseLocation

Java files

Java files are in SVN

https://svn0.uits.uconn.edu/webdev/famis/WQRLoader

PHP file lists

api/japi.php

api/japipost.php

mobile/fac_wo_complete_json.php

mobile/fac_header_json.php

report/fac-wo-complete.php

direct/fac_wo_current_schedule.php

direct/fac_wo_ticket_u.php

In Dev/Test SVN Branches

Objective-C

https://svn0.uits.uconn.edu/webdev/famis/QRCodeReaderNew

Database tables, views

Created in FAMISD.FAMIS_SHADOW and FAMIST.FAMIS_SHADOW

Tables:

FAMIS_REQ_COMPLETED: storing scanned work order tickets

FAMIS_LOADER_SETTINGS: storing loader settings

FAMIS_SCANNER_IP: storing IP address of scanning devices

Views:

FAMIS_REQ_COMPLETED_VW: showing only scanned but unloaded work order tickets, by joining with FAMIS.REQ in STORTST (or STORPRD later)

Other usage (direct usage) of the ticket

Look-up using WO numbers
Without attachments
+ HTML View
http://famis.test.uconn.edu/direct/fac_wo_ticket_u.php?work_order=M447474&htmlview

+ PDF Inline View
http://famis.test.uconn.edu/direct/fac_wo_ticket_u.php?work_order=M447474&inline

+ PDF File Download
http://famis.test.uconn.edu/direct/fac_wo_ticket_u.php?work_order=M447474

+ Multiple WOs HTML View
http://famis.test.uconn.edu/direct/fac_wo_ticket_u.php?work_order=M447474,M167997&htmlview

+ Multiple WOs Inline View
http://famis.test.uconn.edu/direct/fac_wo_ticket_u.php?work_order=M447474,M167997&inline

+ Multiple WOs PDF File Download
http://famis.test.uconn.edu/direct/fac_wo_ticket_u.php?work_order=M447474,M167997

Look-up using WO numbers with attachments
+ Multiple WOs HTML View for WO Control does not provide attachments.
http://famis.test.uconn.edu/direct/fac_wo_ticket_u.php?work_order=M447474,M167997&htmlview

+ Multiple WOs with Attachment Inline View
http://famis.test.uconn.edu/direct/fac_wo_ticket_u.php?work_order=M447474,M167997&note_attach=M447474,M167997&mail_attach=M447474,M167997&doc_attach=M447474,M167997&inline

+ Multiple WOs with Attachment File Download
http://famis.test.uconn.edu/direct/fac_wo_ticket_u.php?work_order=M447474,M167997&note_attach=M447474,M167997&mail_attach=M447474,M167997&doc_attach=M447474,M167997

Look-up using SR numbers
Without attachments
+ HTML View
http://famis.test.uconn.edu/direct/fac_wo_ticket_u.php?service_request=SR262974&htmlview

+ PDF Inline View
http://famis.test.uconn.edu/direct/fac_wo_ticket_u.php?service_request=SR262974&inline

+ PDF File Download
http://famis.test.uconn.edu/direct/fac_wo_ticket_u.php?service_request=SR262974

+ Multiple SRs HTML View
http://famis.test.uconn.edu/direct/fac_wo_ticket_u.php?service_request=SR262974,SR330806&htmlview

+ Multiple WOs Inline View
http://famis.test.uconn.edu/direct/fac_wo_ticket_u.php?service_request=SR262974,SR330806&inline

+ Multiple WOs PDF File Download
http://famis.test.uconn.edu/direct/fac_wo_ticket_u.php?service_request=SR262974,SR330806

Look-up using SR numbers with attachments
+ Multiple SRs HTML View for WO Control does not provide attachments.
http://famis.test.uconn.edu/direct/fac_wo_ticket_u.php?service_request=SR262974,SR330806&htmlview

+ Multiple SRs with Attachment Inline View
http://famis.test.uconn.edu/direct/fac_wo_ticket_u.php?service_request=SR262974,SR322672&note_attach=SR262974,SR322672&mail_attach=SR262974,SR322672&doc_attach=SR262974,SR322672&inline

+ Multiple WOs with Attachment File Download
http://famis.test.uconn.edu/direct/fac_wo_ticket_u.php?service_request=SR262974,SR322672&note_attach=SR262974,SR322672&mail_attach=SR262974,SR322672&doc_attach=SR262974,SR322672

QR Code
In all the examples above (PDF & Inline, not HTMLView), in order to print QR Code, you need to add the URL parameter qrcode, for example
http://famis.test.uconn.edu/direct/fac_wo_ticket_u.php?work_order=M447474&qrcode
or
http://famis.test.uconn.edu/direct/fac_wo_ticket_u.php?work_order=M447474&inline&qrcode