At a glance

• 5 Pages: Home (../), Admin Login (../login), Admin Dashboard (../dashboard), Charts-Tables (../chart-tables), Stationwise-Table (../stationwise-table) + 2 other forms (Create and Edit)
• 7 modfified charts, initially collected from Highcharts
• A dashboard that shows latest air quality data for the user's location detected using geolocation
• An admin panel access for overview of computed charts table
• User Authentication for access to admin panel
• Database shown in a user friendly table, where you can perform CRUD operations
• The data that is shown in the charts can be viewed in the "Charts-Table" sidebar option
• Data queried from Database using Laravel Query Builder and SQL

1. Unzip the downloaded archive
2. Copy and paste aqm folder in your htdocs folder
3. In your terminal run composer install
4. Update your .env configurations accordingly (mainly the database configuration)
5. In your terminal run php artisan key:generate
6. Run php artisan migrate to create the database tables
7. Go to mysql and manually import 'stationwises_table_data2' from root folder to populate the the database
8. Test!

• id
• created_at
• aqi - Air Quality Data including all pollutants
• pm2.5 - Main pollutant
• station - Station Number where data is recorded
• district - District where the data was recorded
• season - Season when the data was recorded
• organization - Organization which recorded the data

• id
• district
• temperature
• rain
• windspeed
• humidity
• cloud
• visbility

The daily air quality index (AQI), which represnts the quality of air incliding pollutants today, is shown for all districts

The amount of main pollutant in Bangladesh, known as PM2.5, is collected for each day every year in the seven districts of Bangladesh in the database. The data for each district, each year, is combined and averaged using SQL commands and query builder functions. So the data shows the yearly average data for each year, for each district. The data is then shown in the graph using a line graph, y axis being average PM2.5 and x axis representing the years.

The amount of main pollutant in Bangladesh, known as PM2.5, is collected for each day every year in the seven districts of Bangladesh in the database. The data for each year is combined and averaged using SQL commands and query builder functions. So the data shows the yearly average pm2.5 for each year. The data is then shown in the graph using a line graph where, y axis being average PM2.5 and x axis representing the years.

The amount of main pollutant in Bangladesh, known as PM2.5, is collected for each day every year in the seven districts of Bangladesh in the database. The average, lower quartile, upper quatrile, minimum and maximum of the data is shown in yearly and seasonal box plots.

The amount of main pollutant in Bangladesh, known as PM2.5, is collected for each day every year in the seven districts of Bangladesh in the database. The daily data for each district is queried using SQL commands and query builder functions. The data is then shown in the graph using a line graph, y axis being average PM2.5 and x axis representing the districts.