I 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 calculator
Have 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 Calculator
I 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 2
Holiday 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 / Flickerbook / HTML5 / javacsript / Web development
Work On Flickerbook Holiday Summary
I have written JavaScript functions that fetch data from back end, generate holiday summary table and reduces the need for repetitive code. I have also added a “Copy Table” button and wrote a JavaScript function that works with it.
Bootstrap / CSS / Flickerbook / HTML5 / PHP / SQL / Web development
Adding Holiday Summary Feature To Flickerbook
I 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 Flickerbook
In 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 🙂
chartJS / CSS / Flickerbook / HTML5 / javacsript / Logistics Administrator / PHP / Shortage Report
Improved Shortage Report and Flickerbook
In this post I discuss work done on shortage report and Flickerbook. Coded a feature that inserts location/order name to shortage report and added two charts to Flickerbooks YOY section that display average daily and hourly pay.