tqExpert Help


For eCommerce, implementing an orderInformation tqTag returns a list of information from the current order.

orderInformation - Syntax

<tqtag name="order0type="orderInformation" >

orderInformation - Parameters

Parameter Name Type Mandatory Strict | Transitional Case Sensitive Description
type Text + S + must be orderInformation
name Text + S + should be unique tqtag name in the template. no spaces/commas/single quote/double quotes allowed

orderInformation - Local Variables

Name Type Size Description
addDate dateimte   The datetime the order was created. can be formated using @addDate@df:[format]!
addToMailList text 3 Returns on if customer assigned to a mailing list and off the customer does not
address text 180 Customer's streed adress
agentAddDate datetime   Not functional yet
agentComission number Not functional yet
agentID number 3 Not functional yet
birthDate date   Customer's birth date. can be formated using @addDate@df:[format]!
bsnsName text 150 Customer's company name
chargeFail text 3 Indicate if charge failed. Values: charge fail - on, chrage succeed or system didn't recive charge request - off
city text 100 Customer's city 
commuSign text 65535 The customer signature in the forum and other community services
counter int 5 Running number from 1 to n.
countryID number 16 The country id that the user is belogned to.
creditCardID number 12 The customer credit card id from the database
customerType text 1 Define the customer type. R - for retail customer, W - for wholesale customer
discount number 4 The discount percent that the customers have
email text 150 Customer's email 
fName text 30 Customer's first name 
fax text 20 Customer's fax number
gender text 1 Returns m - Male , or f - Female 
idNum text 15 Customer's id (social security or similar) number
itemsCount number 3 Number of items in the order 
lName text 30 Customer's last name
mainPic text 150 Url for the customer picture 
payments number 3 Number of payments carge was splitted to
phone text 20 Customer's main phone number
phone1 text 20 Additional customer phone number
phone2 text 20 Customer's main cellular phone number
phone3 text 20 Additional customer cellular phone number
postalCode number 10 Customers postal code
registerIP text 30 Customer's ip address while proccessing the order
rowsCount number 3 Number of rows in the order
stateID number The state dtabase id number user belongs to 
status text 16 Order status. c - closed, o - opened, d - deleted
totalPrice number 3 The order total price in user currency 

orderInformation - Examples

Example 1 - basic use of orderInformation tqtag to view order details
<tqtag name="order0type="orderInformation" >
    Customer Name: @fName@ @lName@<br />
    Address: @address@<br />
    Phone: @phone@<br />
    [note - you can use any of the customer information detail you would like to show]

Example 2 - view order details and the items in it
<tqtag name="order0type="orderInformation" >
    Customer Name: @fName@ @lName@<br />
    Address: @address@<br />
    Phone: @phone@<br />
    Products in order:<br />
    <table align="center" cellpadding="0" cellspacing="3">
        <tr><th>picture</th><th>{roduct name</th><th>unit price</th><th>quantity</th><th>Total Price</th>
        <tqtag name="items0type="orderItems" >
                <td><a href="/?product=@id@&lineItem=@lineItemID@"><img src="@productSmallImage@" alt="@title@" width="75" height="75" /><span>@catalogID@</span></a></td>
                    <a href="/?product=@id@&lineItem=@lineItemID@" target="_blank"><span>@productName@</span></a><br />
             <span>@shortDescription@<br /><b>vendor:</b>@vendor@ <br />@productProperties@<br />@stockAffectingProperties@</span>

                <td colspan="4" align="left">Toal Order price</td>

orderInformation - tqOptions

With the orderInformation tqtag, you can use the following tqoptions: if.

orderInformation - Templates

The templates below implement this tqTag. After you click a link, use your browser commands to view the page source.

User Notes

  Add Note

Topic: orderInformation