Projects


City of Bathurst – Sending system (Email and text)

by Many students participated in the project



Project Description

During the third year of the Focus Innovation project, the students created a sending system for the city of Bathurst.
This system will send an email and/or a text to the appropriate customers.
The message will specify which garbage bin is scheduled for a specific week (blue or black).

Technology

  • Programming languages: HTML, CSS, PHP and BootStrap.

Screen capture example:


Customer inscription

A web form is used to subscribe to the project.

Languages used: HTML, CSS, PHP and BootStrap


Customer cancellation

A web form is used to cancel a customer inscription.

Languages used: HTML, CSS, PHP and BootStrap


Database

The zones and dates are accessible from the Bathurst web site.



A database has been created to keep that information.

Microsoft Access was used to analyse the project.

The final database was created with phpMyAdmin.

Microsoft Access example:



Php MyAdmin example


Calendar

A C# program was created to enter the calendar information into a database.

You can select a specific date, the desired zones and the garbage bin color. A button is used to save that information into a text file.

A button is used to start a new year.


Text File example

The data represents the year, the week, the day of week, the zone and the garbage bin color.


Task scheduler

The Microsoft Windows Task Scheduler can activate a specific task at a specific time.

The goal is to verify the calendar and send an email or a text to the appropriate customers indicating which garbage bin color is scheduled for a specific date (blue or black).

The Task Scheduler execute a PHP file.

This file passes through the calendar and the customers to send an email or a text in order to advise the customers of the selected garbage bin color.


Students


Many students participated in the project’s analyze phase:

  • Mathieu Comeau
  • Maxime Comeau
  • Denis Lanteigne
  • Jason Gauthier

© Focus Innovation. 2019 - All rights reserved.
Top