[set page_title]Customer manager: View customer[/set] [set ui_class]Customers[/set] [set page_banner]View customer[/set] [set help_name]customer.view[/set] [set icon_name]admin/icon_people.gif[/set] @_UI_STD_HEAD_@ [calc] delete $Scratch->{ui_bounce}; #Log("got here, customer=$CGI->{customer}, arg=$CGI->{mv_arg}"); return if $CGI->{customer}; $CGI->{customer} = $CGI->{mv_arg} or $Scratch->{ui_bounce} = '__UI_BASE__/customer'; return; [/calc] [if scratch ui_bounce] [bounce page="[scratch ui_bounce]"] [/if] [update values] [loop list="[value-extended customer]"] [query list=1 st=db table=transactions sql="select order_number, order_date, salestax, shipping, total_cost, status FROM transactions WHERE username = '[loop-code]' ORDER BY order_date " ] [/query]
Customer Username: [loop-code]
Customer: [loop-data userdb fname] [loop-data userdb lname]
[if-loop-data userdb project_id] [/if-loop-data] [if-loop-data userdb fax] [/if-loop-data]
Company: [loop-data userdb company]
Home phone: [loop-data userdb phone_night]
Work phone: [loop-data userdb phone_day]
Email: [loop-data userdb email]
Payment type: [display arbitrary=custview table=userdb column=fax_order key="[loop-code]"]
PO Number:  [loop-data userdb project_id]
FAX number:  [loop-data userdb fax]
Dealer:  [display arbitrary=custview table=userdb column=dealer key="[loop-code]"]
Wants email copy:  [display arbitrary=custview table=userdb column=email_copy key="[loop-code]"]
Mail lists:  [loop-data userdb mail_list]
[set bill_address] [loop-data userdb b_fname] [loop-data userdb b_lname]
[loop-data userdb b_address1]
[if-loop-data userdb b_address2] [loop-data userdb b_address2]
[/if-loop-data] [loop-data userdb b_city], [loop-data userdb b_state] [loop-data userdb b_zip]
[/set] [set ship_address] [loop-data userdb fname] [loop-data userdb lname]
[loop-data userdb address1]
[if-loop-data userdb address2] [loop-data userdb address2]
[/if-loop-data] [loop-data userdb city], [loop-data userdb state] [loop-data userdb zip]
[/set]

[if-loop-data userdb username] Bill To: [else] Bill To: [/else] [/if-loop-data]

[if-loop-data userdb b_address1] [scratch bill_address] [else] [scratch ship_address] [/else] [/if-loop-data]
Ship To:
[scratch ship_address]
[set bill_address][/set] [set ship_address][/set]
Order number Order date Order Total Status
[sql-code] [sql-pos 1] [sql-pos 4] [sql-pos 5]
[button text="Back"] viewnext= viewcustomer= [/button] [button text="Enter order"] mv_nextpage=__UI_BASE__/entry mv_todo=return [/button] [if-mm advanced userdb=e] [if-loop-data userdb inactive] [button name="activate" text="Activate customer"][/button] [else] [button name="deactivate" text="Deactivate customer" confirm="Are you sure you want to deactivate this customer?"][/button] [/else] [/if-loop-data] [button text="Change password"] user_id=[loop-code] mv_nextpage=__UI_BASE__/customer_change_pass [/button] [/if-mm] [if-mm advanced userdb=d] [/if-mm]
[/loop] @_UI_STD_FOOTER_@