Track Casino Revenue Reports through Google App Engine

Categories : All, Media and Entertainment

Client Requirement


The purpose of this application is to help the client to track revenues at each of his casino centre located in geographically diverse areas. The application is a centralized system for calculating revenue generated through each activity in the casinos.

Client already possessed a domain with Google. He developed using Google App Engine and to be authentication to hosting and report generation, throughout the system. The application users are as demanded a Google-centric application to be hosted on Google Cloud SQL. From user Google technologies are used successfully below:

Admin: The Admin type of user’s will create role and assign access to each role. They will manage and keep an eye on the activities carried out throughout the system.

Input provider: Input providers are basically those users who have the authority to track the revenues at each casino centre. Users can choose the centre for which they wish to add information and proceed to fill in details in the required fields. Each field is programmed (assigned calculations) to yield a right output.

Report viewers: This group of users can only view the reports based on the data provided by the input providers. The system also allows choosing from a varied report types.

The application is comprehensive as it stores the details about every property (casino centre) and games played in each casino. The games are well defined, categorized and calculations are applied to each category. The category has a revenue type and each revenue type has a different formula for calculation. The application is made scalable which means Admin can add more games to a particular centre, categorize them and can also activate and deactivate the games in the centre. The non-functioning games are deactivated for a particular day or record.

The system by default allows input entry to be done only for last three days and then auto-locks the database for entries for days earlier than three from present.

The application allows auto-report generation as well and while generating report the data is used from the application while the actual report generation is performed through Google Drive.

Project Challenges

Team faced the following challenges:
  • Date-wise addition of records. Allowing access and modification to transactions pertaining to last 3 days only and auto-locking rest of the past dates.
  • Applying different calculation to each field and providing varied report generation option.
  • Authenticating with Google account.
  • Generating reports with Google Drive.
  • Dynamic reports generation based on statistics and formulas.
  • Calculating adhoc average of the revenue.

Technologies Used

Operating System & Server Management Red Hat Linux, Multi-Server Architecture with Staging & Production Environment through Version Controlling releases, Server Optimization, Security & SSL Implementation, Scheduler for Back-ups, Alert Monitoring System Integration, Server Performance Tuning at regular intervals, Software Firewall Configuration & Maintenance
Development Tools & Environments JSP Servlet, Google Apps Script, Google App Engine, Google Cloud SQL, Google Spreadsheet, Google Drive API, Apache POI, AJAX, HTML, CSS etc.
Database MYSQL Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Scheduler for Backups


Project Leader 1
Developers 2
Designers 1


Keeping in mind the structure of the website and the challenges involved, a four-tier
development approach was adopted consisting of:
  • The Database layer containing MYSQL Server Database, Tables, Stored Procedures and so on.
  • The Business Logic layer consisting of all the business logic procedures for interactive modules.
  • The Interface layer and Database Abstraction layer for converting data between incompatible type systems in databases and accessing data from the database respectively.
  • The User Interface layer which forms the Graphical User Interface of the website.


cas 3

Development Highlights

The site offered a centralized access to multiple users. Developed using robust architecture the system allowed personalization to the users. Customizable viewing options were designed to enhance the user experience. Access control and other security measures were applied. The entire application was reliant on varied Google technologies and was built according to the latest standards.

The web application was developed keeping in mind the SEO activities for the site. For timely delivery of the solution, Google App Engine was used. The system made use of Google POI for reading excels files as well as Google spreadsheet and Google Drive was used for reporting purpose. Web usability guidelines were strictly followed during development and the interface was made easily navigable through judicious use of HTML and CSS controls. The site was developed and fully functional within a span of 1 month.

[Total: 0    Average: 0/5]

Client Saying

BIG THANK YOU to Brainvire team for all their smart work and fantastic services. We are very pleased with the...
Mr. Greg Pietsch
We have dealt with a lot of web development firms and other tech support companies, none come close to Brainvire....
Mr. Matthew
I just want to say it's truly worth investing in services of Brainvire. They gave me what I required and...
Mr. Vinay Saini
The best thing about Brainvire is Compatibility. Whenever we have a query Brainvire is always ready (24*7) to take care...
Mr Craig Agranoff
Just wanted to say massive thanks for all the help from the Brainvire team. After years of having a website...
Mr. Rohit Singla

Latest Happenings

  • 04 Oct 2016
    Brainvire Making great Strides with Symfony Development Services [ + ]
  • 29 Sep 2016
    Brainvire augments its List of Offerings with Magento Sears Integration Services [ + ]