Restock Tablet App

This project is a bespoke android app that was developed for DT Vending to manage their machine stock and other aspects of their company.

Restock - Android App Cordova Framework

Project Overview

This is a bespoke application for android tablets, which uses SQLite database as a backend and the Cordova Framework for the front end of the application. This project uses external Cordova plugins for scanning bar codes and SQLite database interaction with Javascript which was outsourced. This application works locally on the tablet but is capable to be a web-based service using MySQL or similar database. The application allows the user to record machine stock levels, mange expenses, produce reports over a period and keep track of when services are due, where machines are allocated and manage regular pay outs.

  • Keep a record of machines and sites they belong to
  • Track Machine stock levels when a machine has been serviced
  • Create Expenses reports and view statistical reports
  • Calculate commission, sales when servicing a machine
  • Each machine is allocated a bar code, which can be scanned by the app
  • View graphs show sales, commission for sites, machines or contracts.
  • Email commission receipts to clients.
  • Keep track of regular pay outs.
Screenshots

Techincal Details

SVG - Custom Graphs

The graphs in the application use SVG images produced from javascript code which use a framework I developed. Graphs include pie charts, line graphs and a bar charts. The charts are interactive and respond to users tapping entries, data is collected from javascript using JavaScript’s object notation. The code for the charts works with web-based technologies therefore can be used on modern web browsers.

Custom Cordova Plugins

This app uses custom android plugins for printing reports and receipts using Android’s Printer Services and for emailing from the app all of which are written in java. I also implemented a plugin that queries the website at intervals to check for new applications made through the website. See my Cordova Android Plugin tutorial for details how to implement plugins.

CSV export

The application can export data into an CSV file format which can be opened by MS Excel or other office applications, this was implemented for the expenses reports.