Employee QR System

by JB Metropolitan Distributors

Equipment

• Tablet (running Android).
• Tablet Mount.
• Tablet Power Cables.
• USB Power Sockets.
• QR Cards.
• Windows / Mac.
• Domain Server.
• Local WIFI.

Installation

• APK (Installer tablet app - Android based).
• Installer File (Windows).
• Java Runtime (Mac).
• mySQL Workbench (SQL server, Database).
• The tablets can be mounted on a desk or wall.
• We had a professional electrician install ours; with USB ports in the wall

Maintenance

• Clean devices daily.
• Reprint missing/lost QR Cards.
• Check devices are currently powered on and app is open.

How it works

App:

• Employees use their personal QR card to sign in/out.
• Signing in or out will write their data(via wifi) to the database installed on the company server. This data includes: Name, Time, Status(in or out) and Date along with an image of themselves.

Viewer:

• Information can be retrieved by using the Employee Viewer software installed on the manager's PC.
• Upon use, all records are pulled from the database and stored locally.
• By clicking on any record listed, you can see records from any employee in any date range.

``` The Main purpose is to replace outdated bundy systems. ``` ``` Activities in operational order. ``` **1.** This activity allows the screen to dim after 5 minutes but doesn’t allow the tablet to ‘sleep’. It will remain idle until a user presses Start. **2.** The barcode activity will look for any type of barcode data (The QR code is the preferred format). This will scan the barcode and search the company database for the corresponding employee. **3.** This activity welcomes the employee. It allows the employee to select whether they would like to sign in or out depending on their current status. If an employee is already signed in, this won't allow them to sign in again until the following morning. **4.** The camera will count down from '3' and as it reaches '0' it will take a photo of the employee as proof of sign in/out. **5.** The Employee will have the option to retake the current photo for any reason. Pressing 'Retry' will start activity 4 again, whilst pressing 'Ok' will send the photo to the database on the company server (This will be accessible via the Employee Viewer). **6.** The Thank You screen confirms all actions are taken correctly and that the employee's time and photo have been logged.

Employee Viewer - Window Based.

Each manager will receive their own log in password. These accounts will only work with active domain users or specified MAC addresses.

Main activity window has many functions to view
and export data.

1. This information shows a tabbed window of all the current employees and their status in real time. This list allows managers to inspect individual re- cords by double clicking an employee. 2. Export: This allows payroll or absent employees to be exported into a text or excel file.

Add: This allows managers to add individual
employees directly into the database.

Delete: This allows managers to remove individual
employees directly from the database.

3. Date Search: The date search function allows managers to search all or individual records between 2 specified dates.

Searching Today's Records.

4. Records list: This screen relays all data related to 'Today'. By changing the 'Search all' radio button, managers can narrow their search to specific individuals.

All information displayed shows all employees that have signed into work today.

All current data is being pulled from the company database.

Note: All employee's times are rounded to the nearest hourly quarter for an easier payroll export.

Searching an Individual Employee.

5. Individual Employee: This function works when a manager double clicks on an employee's name. This will show the employee's entire record.

Search Bar: The manager can also search an employee by name or employee number.

Date Range: Individual employees can be searched by date range.

• Click on an employee's name
• Unselect the 'Search all' feature
• Confirm the start and finish dates
• Click 'Go'

Viewing Employee's Photo.

Viewing the employee's sign in/out photos allows managers to keep track of all employees.

This eliminates employees being able to bundy/clock in or out for other fellow employees that may be away or running late.

This function will clear up any uncertainties as you are able to view exactly who used the system to sign in.

To use this function:

• Search for employee/s
• Double click on the employee's 'Time In' or 'Time Out'

Adding an Employee.

This simple process will add an employee record to
the company's database.

How to Add:

• From the Main screen click 'Add'
• Fill in employee's details
• Click 'Ok'

This is instantly added. So the employee can now
sign in.

Note the employee's 'ID'.
The employee's ID is used to generate a QR or Bar-
code.

System can be used to export these QR cards for
each employee.

The card was designed so that the employee can
place it inside their wallet or pocket. Lanyards are
the perfect inexpensive alternative.

John SMITH

Exporting Payroll.

This section of the software will be used primarily by the payroll officer.

This will export all employee's records for the selected week in the format of tab delimited .txt file. This can be opened by excel.

All hours recorded are calculated and rounded to the employee's 'Expected' start time.

How to export:

• From the Main screen click 'Export'
• Click 'Payroll'
• Select desired week (These dates are set to print the previous weeks payroll. Exporting payroll from the current week isn't allowed)

Public Holidays: These can be adjusted before ex- porting the records.

• Click 'Include Public Holidays'
• Enter hours required

Public holiday hours will automatically be calculated and assigned to all employees that have employment type 'permanent'.