Snippet: ClickCartPro: Extracting VAT Exempt orders

February 21st, 2009 by Richy C. No comments »

If you are looking for a way of listing all orders in Greenbarnweb/Kryptonic’s ClickCartPro software that is exempt from European/UK VAT, then you may find the following SQL query useful:
SELECT `id` , `dateday` , `datemonth` , `dateyear` , `ordertotal`, `eutaxrefundtotal` , `country` FROM `gbu0_orders` WHERE STATUS = 'C' AND (eutaxrefundtotal >0) ORDER BY dateyear DESC , datemonth DESC

No comments »

Posted in Life: Work and Techy, Snippet

Tags:

Snippet: Parallel Processing in PHP

February 20th, 2009 by Richy C. No comments »

*snippet* This is just a quick “bookmark” style post to remind me to look at the potential for utilising Parallel Processing in PHP using the “divide and conquer” method which may help in compiling/comparing stats in an application I’m working on.

No comments »

Posted in Net: Techy: PHP, Snippet

Tags:

Techy: IE8 incompatible list: What isn’t listed?

February 20th, 2009 by Richy C. No comments »

Zdnet has just pointed me towards Microsoft’s Internet Explorer 8 Compatibility View List for Windows Vista which lists all the websites IE 8 is known to have problems with: and it’s extensive (see this Zdnet list for a human-readable display). I did a quick search for most of the major sites and they all seem to be listed: From Microsoft.com (if they can’t get their own site working in their own software it doesn’t bode well), all Amazon sites (.com and .de, .cn and .co.uk etc), all major social networking sites (Facebook.com, MySpace.com, LinkedIn.com and Twitter.com are all listed), to all of Google, bbc.co.uk, Paypal.com , all of eBay and many many more. And this is only the 2,400 major sites that Microsoft have found to have problems with IE8 (or should that be: sites that Microsoft have found that IE8 is broken on).

All the more reason to drop Internet Explorer and try Firefox, Safari, Opera or another browser of your choice (mine’s Firefox)

No comments »

Posted in Life: Work and Techy

Tags:

Dojo Javascript: Changing a FilteringSelect SELECT menu when another changes

February 17th, 2009 by Richy C. No comments »

Here’s a bit of Dojo Javascript which will allow you to dynamically change a SELECT sub menu (technically a “FilteringSelect” menu with an id of “secondFilteringSelectId”) when the first SELECT menu is changed (another FilteringSelect menu with an id of “firstFilteringSelectId”). It uses the Dojo’s ItemFileReadStore method to fetch an ajax page (called ajax) before populating the menu. It also has some caching built in to reduce the number of calls to the server and associated network traffic.

dojo.require("dojo.data.ItemFileReadStore");
aSecondFilteringCache=Array();
dojo.addOnLoad(function() {
    dijit.byId('firstFilteringSelectId').onChange=function() {
        fFirstFilteringSelectIdChanged(dijit.byId('firstFilteringSelectId').value);
    }
    fFirstFilteringSelectIdChanged('defaultSetting');
});
function fFirstFilteringSelectIdChanged(thisValue) {
    secondSelect=dijit.byId('secondFilteringSelectId');
    if (aSecondFilteringCache[thisValue]==undefined) {
        var myStore=new dojo.data.ItemFileReadStore({url:'ajax?setting='+thisValue});
        var gotList = function(items, request) {
            aSecondFilteringCache[thisValue]=myStore;
            secondSelect.store=myStore;
            secondSelect.setValue(items[0].id);
        }
        var gotErrors=function(error,request) {
            alert('Request failed:'+error);
        }
        var request=myStore.fetch({onComplete:gotList,onError:gotErrors});
    } else {
        secondSelect.store=aEducationsCached[thisValue];
        secondSelect.setValue(secondSelect.store._arrayOfAllItems[0].id);
    }
}

I am just learning Dojo though, so there could be a much better/sensible way of doing this: let me know if you know/find it!

No comments »

Posted in Life: Work and Techy

Tags:

Techy: Cross Browser Testing

February 17th, 2009 by Richy C. 1 comment »

For a while now, I’ve been a great fan of Browser Shots to test websites in Firefox, Internet Explorer, Safari and Opera without having to install all of those web browsers (and previous versions) on my machine. However, it does have a snag: you can only test “static pages”: you can’t interact with the page in anyway (so if you wanted to see if a drop down menu worked well in IE 5.5, you’re out of luck).

However Keyboardface has just blogged about a service I hadn’t heard of before called Cross Browser Testing.com which gives you practically a VNC/remote desktop/LogMeIn style connection to a remote computer (which seem to be Virtual Machine images) which has a selection of browsers installed for you to interactively test on. It’s pretty cheap: there’s a free option, $1 for 5 minutes option (with discounts) or a “pay per month” option. It’ll be worth considering when I’m needing to test the site I’m working on on multi-platform and multi-browser scenerios.

1 comment »

Posted in Life: Work and Techy

Tags:

gamy-dance