I feel like this project is finished. In this post I discuss last work done on this project, show an example of how it did what it was designed to, and write a summary of what I learned and what I could have done better 😉
canvasJS / CHEP Pallets / CSS / Data Analytics / github / HTML5 / javacsript / Logistics Administrator / PHP / SQL
CHEP Pallets Monitoring And Report. Step 20 – Rendering chart 2 and chart 3
I finish coding Chart 2 and Chart 3 for my project. Also fixed a few bugs and did some changes to styling. I can feel this project reaching it’s final shape! 😉
CHEP Pallets / Data Analytics / Excel / github / Logistics Administrator / PHP / SQL
CHEP Pallets Monitoring And Report. Step 11
After running some queries against the database I decided to change what second chart is going to show and also came up with idea for a one more chart (so there will be a total of 4 charts).
CHEP Pallets / Data Analytics / github / Logistics Administrator / PHP / SQL
CHEP Pallets Monitoring And Report. Step 10
In this post I show how I orginize data for my third chart. As I tried a different approch of forming and array, I noticed that I need to reorder my chart 1 data as well.
CHEP Pallets / Data Analytics / github / javacsript / Logistics Administrator / PHP / SQL
CHEP Pallets Monitoring And Report. Step 9
I queried database to get sum of pallets that were transferred in and sum of pallets returned, as these are the quantities I need for my second chart. Also added some security against SQL injection.
CHEP Pallets / Data Analytics / github / Logistics Administrator / PHP / SQL / Uncategorized
CHEP Pallets Monitoring And Report. Step 7
I managed to achieve the array structure layed out in previuos post, and it can be sent over to front end. I also learn some new things about arrays and updated my previuos PHP code.
CHEP Pallets / Data Analytics / github / Logistics Administrator / PHP / SQL
CHEP Pallets Monitoring And Report. Step 6
Start to SQL querie database in back end with PHP in order to retrieve the data I need for charts. Will also start to arrange data in a manner that will enable me to send it to front end for the charts to be drawn.
CHEP Pallets / Data Analytics / Logistics Administrator / PHP / Protean / SQL
CHEP Pallets Monitoring And Report. Step 5
After uploading data to database I started running SQL queries and my concerns that it will be difficult to monitos CHEP pallets are confirmed.
CHEP Pallets / CSS / Data Analytics / Excel / github / HTML5 / javacsript / Logistics Administrator / PHP / SQL
CHEP Pallets Monitoring And Report. Step 4
Started coding CHEP pallets report. Already created a website where you upload the transaction report and then upload the chosen columns to database for SQL querying.