[comment] ui_template: Yes ui_template_name: leftonly [/comment] [tmp members_only]1[/tmp] [tmp page_title]__COMPANY__ -- [L]Order History[/L][/tmp] [control reset=1] [control-set] [component]search_box_small[/component] [/control-set] [control-set] [component]product_tree[/component] [/control-set] [control-set] [component]cart_tiny[/component] [/control-set] [control reset=1] @_LEFTONLY_TOP_@ [warnings auto=1]
[query list=1 sql="select * from transactions where username = '[data session username]' order by order_date"] [/query]
[L]Date[/L] [L]Order ID[/L] [L]Qty Total[/L] [L]Payment Method[/L] [L]Subtotal[/L] [L]Shipping/Handling[/L] [L]TOTAL[/L] [L]Status[/L]
[convert-date fmt="%B %e, %Y %H:%M"][sql-param order_date][/convert-date] [sql-param order_number] [sql-param nitems] [sql-param payment_method] [currency][sql-param subtotal][/currency] [sql-param shipping] [if-sql-param handling > 0]
(handling [sql-param handling]) [/if-sql-param]
[currency][sql-param total_cost][/currency] [display table=transactions type=display col=status key="[sql-code]"]
@_LEFTONLY_BOTTOM_@