[comment] ui_template: Yes ui_template_name: leftonly ui_template_layout: LEFTONLY_TOP, UI_CONTENT, LEFTONLY_BOTTOM ui_template_description: Page with top/left areas. page_title: description: Page title page_banner: description: Page banner help: Defaults to page title members_only: options: 1=Yes,0=No* widget: radio description: Members only component_before: options: =none, specials=Specials, random=Random items widget: select description: Component before content component_after: options: =none, specials=Specials, random=Random items widget: select description: Component after content bgcolor: options: #FFFFFF=White,pink=Pink widget: select description: Background color [/comment] [set page_title]__COMPANY__ -- Order History[/set] [set page_banner]Order History[/set] __LEFTONLY_TOP__ [query st=db arrayref=orders sql="SELECT code,status,nitems,subtotal,shipping,handling,total_cost,payment_method,order_date FROM transactions WHERE username = '[data base=session field=username filter=sql]' ORDER by code "][/query] [mvasp tables=transactions] <% my $uid = $Session->{username}; if (! $uid) { $Document->write ("
DATE | ORDER ID |
QTY TOTAL |
PAYMENT METHOD |
SUBTOTAL |
SHIPPING HANDLING |
TOTAL | STATUS |
$order_date | $order_number | $nitems | $payment_method | $subtotal | $shipping$handling | $total_cost | $status |