Updated YTD summary. Replaced
| elements. Wrote new SQL queries and improved how data is sent to front end.
chartJS / Data Analytics / Flickerbook / SQL / Web development
Added new charts to Flickerbook YOY sectionAdded 6 new charts to Flickerbooks YOY charts page. For the time being I believe this will be the last charts for this page.
Data Analytics / Flickerbook / PHP / SQL / Web development
Adding new column to Flickerbooks payments DB and generating values for it from existing dataA quick example of how I filled a newly created column in database table, using already existing data and PHP to calculate and insert new values into new column.
chartJS / Data Analytics / Flickerbook / HTML5 / javacsript / jQuery / PHP / SQL / Web development
Still Working On FlickerbookFor the last two months was continuing work on Flickerbook. Have done a lot of changes! Wont go trough all the code and queries I have written, but in this post I showcase new tables and charts I have created for my work related data 😉
Flickerbook / PHP / SQL / Web development
Still Working On Flickerbooks Totals CalculatorI used SQL temp tables and UNION ALL for the first time. With the help of SQL temp tables I was able to use a GROUP BY statement on payments, that are stored in multiple columns, but have identical names.
Bootstrap / CSS / Flickerbook / HTML5 / javacsript / PHP / SQL
More work on Flickerbook’s total’s calculatorHave done some more work on Flickerbooks totals calculator. Used Left and INNER joins to retrieve data from 3 different tables. Also wrote a new function that creates html elements for table and charts and helps me avoid repetitive HTML code.
Bootstrap / chartJS / CSS / Flickerbook / HTML5 / javacsript / PHP / SQL / Web development
Improving Flickerbooks Totals CalculatorI have added 9 new tables and charts to totals calculator, that are listed below: Below is an example of earnings by employer table and pie chart: HTML […]
Flickerbook / PHP / SQL
Work On Flickerbook Holiday Summary Part 2Holiday summary is finished! it now concatenates consecutive holiday days into one date value, that shows start and end of holidays. It makes this tabel a lot more easier to read.
Bootstrap / CSS / Flickerbook / HTML5 / PHP / SQL / Web development
Adding Holiday Summary Feature To FlickerbookI started developing holiday summary table that appears inside a Boostrap modal. I have done HTML, CSS, PHP and SQL coding. In this post I showcase what has been done.
Flickerbook / PHP / SQL
Work to improve FlickerbookIn this post I write a list of work that I would like to do on my Flickerbook web app. And there seems to be quite a lot of work ahead for me 🙂 |