Updated YTD summary. Replaced
| elements. Wrote new SQL queries and improved how data is sent to front end.
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 🙂
chartJS / CSS / Flickerbook / HTML5 / javacsript / Logistics Administrator / PHP / Shortage Report
Improved Shortage Report and FlickerbookIn 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. |