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).
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.
Automatically patch 250+ computers with all the latest apps in a couple of clicks. The wonders of having remote scripting control over all computers we look after (Windows, Mac and Linux). Although Kaseya is a very heavy program (my server has 5gb of ram just for it!) it does so much useful stuff. Handles windows event log collection, patch management, application deployment, alerting, remote control, silent scripting, remote command line, registry editor, reporting, anti-virus and malware and a bunch of other things. Basically means I can manage any machine from a web browser without needing to login to the actual computer (also no VPN needed). Yay! Only issue is that I cannot remote control from an iPad.
I take my recommendation back. Ninite are now charging much much more per month than before. I have yet to work out what the new cost gives me, so at this stage I cannot recommend it.
Primary tickets query in IPManager, working very nicely (110,000 tickets in a slow VM).
Generation Time: Jun 21, 2011 at 01:10 AM
Generated by: phpMyAdmin 22.214.171.124 / 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;
You can purchase some really cheap computers these days. Makes me wonder why cloud computing is so popular (hint people are lazy).
Xeon 2.5GHz Quad
2x500TB Raid 1 HDDs (SATA so not great, but should be fine)
24gb Ram (yeah sweet)
Windows SBS 2011
3 year onsite warranty.
1gb ethernet link with unlimited transfer between server and workstations :p
24gb Ram and SBS for less than $3k, seriously nice.
It has been interesting to see my clients thoughts on cloud computing. Some are all for it, while others won't touch it. Long term it seems like the only solution, but for many customers they simply don't trust these cloud providers (and I'm mostly in agreement).
So after upgrading my Core2Duo 2.4GHz MBP to have an SSD, my i7 iMac is basically unusable now....
Sure having an i7 chip is nice (I run a bunch of VMs, xcode, bloated iTunes and the famous ram hog Safari) but 8gb isn't enough ram and the slow HDD just kills it.
Basically I need at least 16gb of ram or an SSD (both would be nice!).
Same issue with the MacBook Air (not that I own one), just needs 8gb of ram and it would be sweet, 4gb isn't enough at all.