PolarLava CycleLog V2.2.0 (I'iwi) Completed

My additional enhancements for PolarLava CycleLog V2.2.0 (I'iwi) are complete.  The following are the changes that were completed:

  • Minor Name Change - Henceforth instead of just calling it "CycleLog", it will be known as "PolarLava CycleLog".  This is in anticipation that I may publically release this project in the future.  Although it's not currently packaged and documented for public consumption, if you're a PHP hacker, a cyclist and are interested, just ask.
  • Search Improvements - A lot of changes were made to the search page.
    1. Searches no longer are required to be date bounded.
    2. Added minimum and maximum distance bounding.
    3. Added minimum and maximum average speed bounding.
    4. Added the ability to do ad hoc searches of the notes field.
    5. Added some basic search help on the page.
  • Sleep Time/Quality - Added "hours of sleep" and "sleep quality" fields to the ride Personal Data section.
  • Yearly Summary Page - Similar to the home pages "Year-To-Date" display, a page that displays this same information, on a year by year basis has been added.
  • Security Upgrades - A full security analysis of all SQL queries was performed and all queries now use SafeSQL.
  • Miscellaneous Bug Fixes - As always there were handful of small bugs to fix!.
  • Calendar View - A monthly calendar view that shows basic ride info for the days that I've ridden in a month.  This includes a weekly summary on each Saturday and monthly summary below the calendar.  This component allows you to navigate to any month year which you might want to view..
Based on my current needs in PolarLava CycleLog and my desire move again to other things, the following were not implemented in this release:
  • Search Improvements - The ability to search based on a bounded temperature range similar to the distance bounding.  This is a little more involved because of the temperature data is not readily available in the same place as the ride data.
  • Bike Page - A page to display information about each bike along with a picture.
  • Records Page - A new page to list some extremes: longest ride distance, longest/shortest ride by time, fastest average speed ride, maximum speed, extremes of weather, etc.
  • Summary Update - Make some of the elements clickable to the rides they relate too.
  • Bike Maintenance - A sub-component of the Bike Page to allow for maintenance records for each bike.