By Scott Gottreu on August 26th, 2010
So a large portion of the code I write is to output data in table format. When you have hundreds of rows, it becomes hard to decipher all the data. Plus, the end users are use to Excel, which allows them to sort and filter their data.
I originally tried to implement sorting on the server side, but the down side was that would cause the entire page to reload. I had been working with jQuery but wasn’t sure if it was possible. After a minute of searching I came across Tablesorter. Set up is very straight forward.
Continue reading Sorting & Filtering Tables →
By Scott Gottreu on June 11th, 2010
A few years ago I installed OpenBiblio on one of my websites to keep tab of all my books. I wrote a Perl script that uses a book’s ISBN number to retrieve the bibliographic information from Amazon and then enter the book into my library. I can now search all my books as well my DVDs and I have a complete list for insurance purposes. Also, now if someone wants to borrow a book, I can check it out and know who borrowed what and when.
Continue reading The Lengths I Go to Organize My Books →
By Scott Gottreu on April 30th, 2010
I was given the task a few weeks ago of finding point of sale software for our clinic. I started by looking at all the open source options. Two likely candidates were PHP Point of Sale and Lemon POS. Since this point of sale would be put on either a stand-alone system or be placed on a server I decided I would set up a system for testing. I’ve been using Linux for the last 5 years or so but I’m more of a distro and windowing user. That’s why I like Ubuntu so much. It just works out of the box. I don’t have to compile code to get an application working.
Continue reading Linux from Scratch →
By Scott Gottreu on April 29th, 2010
I’m not really sure why it happened but beginning around the 1st of March I just went dark on the internet. I would occasionally check in on Facebook but I stopped blogging, tweeting and all that other outward focused internet type stuff. One, I didn’t think I had that much to say and two, I just hit a rough patch personally and didn’t have the energy to write. Continue reading Spring Cleaning & Going Dark →
By Scott Gottreu on March 5th, 2010
I’ve been creating several charts using jqPlot and several of them have been bar graphs. One issue I ran into early on was how to I determine which bar someone clicked on without actually clicking on the data point at the top of the bar.
Updated – Clicking on the image will take you a live example.
Continue reading jqPlot – Clickable Bar Graphs →
By Scott Gottreu on February 12th, 2010
My supervisor mentioned to me about a month ago that the doctors want a dashboard on our website to track various data points.
- How many patients were seen in a week.
- How many patients did each doctor see.
- What were type of visit were the patients coming in for.
- The wish list could go on…
Things were slow for a couple of days so I dove back into my research into Javascript graphing plugins. I came across jqPlot and gRaphaël as two good candidates. I liked the wide variety of graphing possibilities with jqPlot. gRaphaël looked really pretty. But all of this was judging the book by its cover.
Continue reading Visualizing Data – jqPlot & gRaphaël →
By Scott Gottreu on January 22nd, 2010
I am currently developing an inventory system for my company. I wanted to create a category listing but I have always struggled with creating hierarchy and storing it in a database. I created a CMS package at my last place of employment. I remember spending a great deal of time working out how to create hierarchy and then adding to and updating the hierarchy.
Continue reading Updating Stored Hierarchical Data in a Database →
By Scott Gottreu on January 22nd, 2010
I’ve been blogging off and on for the last 5 years. I’ve written about technology and programming as well as my personal life and my faith. I’ve often refrained from geeking out too much on my blog because I didn’t want to go over people’s heads and most of my readers are not coders. However, I’ve toyed with the idea of writing a purely programming blog for the last couple of years. Each time I failed to have the passion and I didn’t feel I had a lot to offer.
Well whether I do or not I leave up to you. Here goes nothing.
