Bootstrap on Bluetrait!
Michael Dale | Sat, 27 Apr 2013 12:50 AM
About time is all I can say!
Still needs some work but yeah it works :D
Responsive too.
Tickets
Michael Dale | Tue, 18 Sep 2012 9:56 AM
I've been working on it for the last few months and it is now pretty awesome.
Password Manager
Michael Dale | Mon, 30 Apr 2012 10:35 AM
I've never found a password manager that I like (the story of my life)!
I've never been a fan of hosting my personal data with other companies.
So I spent two days writing my own.
Mr Password is awesome. It does almost everything a Password Manager should do. I'm selling it cheap on codecanyon and once purchased you get free upgrades and access to the code.
Features include:
Go get it, only $US8-10 (depending on the way you purchase it).
Link: http://codecanyon.net/item/password-manager/2145518
Demo
URL : http://www.onlinecompanyportal.com/mrp/
Username: admin
Password: 1234
IPManager Invoicing
Michael Dale | Sun, 19 Feb 2012 10:56 PM
Invoicing is just about complete! There are two more things that are not finished yet, PDF invoices and emailing the invoicing. Both will be pretty easy.
There were a few complex SQL queries to handle the tax calculations (and to have the total on the view all invoices page).
Here is what it looks like (click to see full size).
Fun with JQuery
Michael Dale | Sat, 11 Feb 2012 10:44 PM
I am in the process of writing in invoicing support for IPManager (need to change the name of this app!). I've looked at Xero and Saasu but I'd still need to work out their API, and I don't like the idea of companies having access to my data, so I'm doing it myself :)
To do it nicely I need to use a bunch of JQuery so that you can easily add new line items on the fly (and calculate tax etc).
I've got it working just the way I want it, using a very long JQuery command!
Here are a couple of screen shots:

And here is the basic design that the clients will see:

I am pretty happy with it so far, lots of work to go though.
New IPManager Design
Michael Dale | Wed, 18 Jan 2012 10:40 PM
This theme will be out for version 2.6 (no time frame for this release yet).
Bluetrait Money
Michael Dale | Thu, 11 Aug 2011 11:49 AM
New version of Bluetrait Money is finally out!
You can purchase it from here:
codecanyon.net/item/bluetrait-money/458252
IPManager 2.2 tickets sql improvements.
Michael Dale | Tue, 21 Jun 2011 11:33 AM
Primary tickets query in IPManager, working very nicely (110,000 tickets in a slow VM).
SQL result
Host: localhost
Database: ipm_test
Generation Time: Jun 21, 2011 at 01:10 AM
Generated by: phpMyAdmin 3.2.0.1 / MySQL 5.1.36-community-log
SQL query: EXPLAIN SELECT tickets.* , c.id AS `source_client_id`, c.client_name AS `source_client_name`, c.email AS `source_client_email`, c2.client_name AS `assigned_user_name`, c2.email AS `assigned_user_email`, comp.name AS `source_company_name`, p.name AS `priority_name`, t.name AS `ticket_state_name` FROM tickets LEFT JOIN clients c ON c.id = tickets.source_client_id LEFT JOIN clients c2 ON c2.id = tickets.assigned_user_id LEFT JOIN priorities p ON p.id = tickets.priority_id LEFT JOIN ticket_state t ON t.id = tickets.ticket_state_id LEFT JOIN companies comp ON comp.id = tickets.source_company_id WHERE 1 = 1 AND tickets.ticket_state_id = 1 ORDER BY last_modified DESC LIMIT 50 OFFSET 0;
Rows: 6
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | tickets | index | ticket_state_id | last_modified | 8 | NULL | 50 | Using where |
| 1 | SIMPLE | c | eq_ref | PRIMARY | PRIMARY | 4 | ipm_test.tickets.source_client_id | 1 | |
| 1 | SIMPLE | c2 | eq_ref | PRIMARY | PRIMARY | 4 | ipm_test.tickets.assigned_user_id | 1 | |
| 1 | SIMPLE | p | eq_ref | PRIMARY | PRIMARY | 4 | ipm_test.tickets.priority_id | 1 | |
| 1 | SIMPLE | t | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | comp | eq_ref | PRIMARY | PRIMARY | 4 | ipm_test.tickets.source_company_id | 1 |
Bluetrait Event Viewer 1.9.2
Michael Dale | Fri, 29 Apr 2011 10:22 AM
I've just released a new version of Bluetrait Event Viewer for WordPress.
The main new feature is an email alert option on Successful/Failed Logins. I've also updated some of the HTML to improve the display of the events widget.
This plugin has been downloaded almost 7000 times, which I think is pretty cool 
From going over the WordPress stats I think there are about 2000 active copies of the plugin running around the world.
IPManager Augmented Reality
Michael Dale | Mon, 07 Feb 2011 9:16 AM
I spend a couple of hours yesterday adding a barcode scanner into IPManager.
The results are sent off to the IPManager server and then displayed as an overlay on the camera interface back on the iPhone.
It works surprisingly well for the amount of work I needed to do (not much).
I'll need to add a scanner log but it is pretty cool :)