[Virtuemart] Customize Order List – adding extra column
November 16th, 2010
In this post, I am going explain on how to add an extra column in Virtuemart Administrator Order List page.
(Note that, in this example, I’m going to add a new address_1 column).
Note: Please refer to my previous post on “adding search keywords” for the SQL query code for the other fields that you want.
Getting Started.
In /administrator/components/com_virtuemart/html/order.order_list.php
locate this section, around line 27. Then add “address_1″ into the line, as below.
//$list .= "first_name, last_name FROM #__{vm}_orders, #__{vm}_order_user_info WHERE ";// This is the modified line.$list .= "first_name, last_name, address_1 FROM #__{vm}_orders, #__{vm}_order_user_info WHERE ";After that, locate this section, as usual and note that “Address_1″ is already the added column.
$columns = Array( "#" => "width=\"20\"", "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(".$checklimit.")\" />" => "width=\"20\"", $VM_LANG->_('PHPSHOP_ORDER_LIST_ID') => '', $VM_LANG->_('PHPSHOP_ORDER_PRINT_NAME') => '', // This is you "address_1" column header, 'Address_1' => '', $VM_LANG->_('PHPSHOP_ORDER_LIST_PRINT_LABEL') => '', $VM_LANG->_('PHPSHOP_ORDER_LIST_TRACK') => '', $VM_LANG->_('PHPSHOP_ORDER_LIST_VOID_LABEL') => '', $VM_LANG->_('PHPSHOP_CHECK_OUT_THANK_YOU_PRINT_VIEW') => '', $VM_LANG->_('PHPSHOP_ORDER_LIST_CDATE') => '', $VM_LANG->_('PHPSHOP_ORDER_LIST_MDATE') => '', $VM_LANG->_('PHPSHOP_ORDER_LIST_STATUS') => '', $VM_LANG->_('PHPSHOP_UPDATE') => '', $VM_LANG->_('PHPSHOP_ORDER_LIST_TOTAL') => '', $VM_LANG->_('E_REMOVE') => "width=\"5%\"" );$listObj->writeTableHeader( $columns );As you can see, those are the column headers for the table, and the last line is the function to print out all the column headers.
Then, you will need to locate this section of code, and add $db->f(‘address_1′); as below:
$tmp_cell = $db->f('first_name').' '.$db->f('last_name'); if( $perm->check('admin') && defined('_VM_IS_BACKEND')) { $url = $_SERVER['PHP_SELF']."?page=admin.user_form&user_id=". $db->f("user_id"); $tmp_cell = '<a href="'.$sess->url( $url ).'">'.$tmp_cell.'</a>'; } $listObj->addCell( $tmp_cell ); // This will print "address_1" column, which is placed afer the "Name" column $tmp_cell = $db->f('address_1'); $listObj->addCell( $tmp_cell );Note: The ordering of the the print cell function (i.e. the $listObj->addCell( $tmp_cell ); ) is important, as you wouldn’t want to jumble up the different fields.Thats all.
Hope this help 
You can find the original post here : http://blog.gbinghan.com/2010/10/virtuemart-customize-order-list-adding.html
Using jQuery to post an array to a ColdFusion Component
November 15th, 2010
A reader sent in an interesting question today. He was trying to make use of jQuery to post an array of data to a ColdFusion component. His CFC was expecting, and demanding, an array argument. Whenever he fired off the request though he received an error from ColdFusion saying the argument was not a valid array. Let’s look at an example of this so it is more clear.
I’ll start off with my server side component. It handles the incredibly complex task of returning the size of an array.
ColdFISH is developed by Jason Delmore. Source code and license information available at coldfish.riaforge.org
<cfcomponent> <cffunction name="handleArray" access="remote" returnType="numeric"> <cfargument name="data" type="array" required="true"> <cfreturn arrayLen(arguments.data)> </cffunction> </cfcomponent>
1 <cfcomponent>
2
3 <cffunction name=”handleArray” access=”remote” returnType=”numeric”>
4 <cfargument name=”data” type=”array” required=”true”>
5 <cfreturn arrayLen(arguments.data)>
6 </cffunction>
7
8 </cfcomponent>
On the client side, I’m going to use jQuery to post a static query to the CFC. This will happen immediately on document load so I don’t have to bother clicking a button or anything fancy like that. (Note, in the code block below I’ve removed the html, head, and body tags since they are all empty. I do have a script block to load in the jQuery library though.)
ColdFISH is developed by Jason Delmore. Source code and license information available at coldfish.riaforge.org
$(document).ready(function() {
var mydata = [1,2,3,4,5,"Camden,Raymond"];
$.post("test.cfc", {method:"handleArray",data:mydata, returnFormat:"plain"}, function(res) {
alert($.trim(res));
})
})
1 $(document).ready(function() {
2 var mydata = [1,2,3,4,5,"Camden,Raymond"];
3 $.post(“test.cfc”, {method:”handleArray”,data:mydata, returnFormat:”plain”}, function(res) {
4 alert($.trim(res));
5 })
6
7 })
So, what would you expect to happen here? Well first off, it is important to remember that we are talking about an HTTP post here. You cannot send a complex data type of POST. It must be encoded somehow. jQuery does indeed encode the data – just not how you would expect it. Upon running this and examining the POST data in my Chrome dev tools, I see the following:
Not what you expected, right? You can see why ColdFusion complained. The “Data” argument doesn’t exist. Instead we have a lit of things named like Data, but not quite. You can try using toString on the array, but that doesn’t correctly handle the comma in the data. So what to do?
What I recommended was converting the array to JSON. It always surprises me when I remember that jQuery can’t produce JSON on its own, but there are plugins out there that will do it it for you. Because JSON is a string format though I thought I’d write up a quick function to generate the string for me. This function makes the assumption that are array only contains simple values of numbers and strings.
ColdFISH is developed by Jason Delmore. Source code and license information available at coldfish.riaforge.org
$(document).ready(function() {
var mydata = [1,2,3,4,5,"Camden,Raymond"];
var myds = serialize(mydata)
$.post("test.cfc", {method:"handleArray",data:mydata, returnFormat:"plain"}, function(res) {
alert($.trim(res));
})
function serialize(arr) {
var s = "[";
for(var i=0; i<arr.length; i++) {
if(typeof(arr[i]) == "string") s += '"' + arr[i] + '"'
else s += arr[i]
if(i+1 < arr.length) s += ","
}
s += "]"
return s
}
})
1 $(document).ready(function() {
2 var mydata = [1,2,3,4,5,"Camden,Raymond"];
3 var myds = serialize(mydata)
4 $.post(“test.cfc”, {method:”handleArray”,data:mydata, returnFormat:”plain”}, function(res) {
5 alert($.trim(res));
6 })
7
8 function serialize(arr) {
9 var s = “[";
10 for(var i=0; i<arr.length; i++) {
11 if(typeof(arr[i]) == “string”) s += ‘”‘ + arr[i] + ‘”‘
12 else s += arr[i]
13 if(i+1 < arr.length) s += “,”
14 }
15 s += “]”
16 return s
17 }
18 })
As you can see, I wrote a serialize function to handle converting the array into a JSON-encoded array. This isn’t the only change though. We still aren’t sending an array to the CFC. It’s a string. So I rewrote the CFC to handle it a bit better:
ColdFISH is developed by Jason Delmore. Source code and license information available at coldfish.riaforge.org
<cfcomponent> <cffunction name="handleArray" access="remote" returnType="numeric"> <cfargument name="data" type="any" required="true"> <cfif isJSON(arguments.data)> <cfset arguments.data = deserializeJSON(arguments.data)> </cfif> <cfreturn arrayLen(arguments.data)> </cffunction> </cfcomponent>
1 <cfcomponent>
2
3 <cffunction name=”handleArray” access=”remote” returnType=”numeric”>
4 <cfargument name=”data” type=”any” required=”true”>
5 <cfif isJSON(arguments.data)>
6 <cfset arguments.data = deserializeJSON(arguments.data)>
7 </cfif>
8 <cfreturn arrayLen(arguments.data)>
9 </cffunction>
10
11 </cfcomponent>
I normally don’t like to “muck” up my code so that it has outside knowledge like this. However, I’d probably have a remote service component in front of this component anyway and the whole issue would become moot.
There are probably many better ways of handling this. Any suggestions?
you can find original post here : http://www.coldfusionjedi.com/index.cfm/2010/3/23/Using-jQuery-to-post-an-array-to-a-ColdFusion-Component