[set page_title][L]Customer manager[/L]: [L]View customer[/L][/set] [set ui_class]Customers[/set] [set page_banner][L]View customer[/L][/set] [set help_name]customer.view[/set] [set icon_name]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]"]
[L]Customer Username[/L]: [loop-code]
[L]Customer[/L]: [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]
[L]Company[/L]: [loop-data userdb company]
[L]Home phone[/L]: [loop-data userdb phone_night]
[L]Work phone[/L]: [loop-data userdb phone_day]
[L]Email[/L]: [loop-data userdb email]
[L]Payment type[/L]: [display arbitrary=custview table=userdb column=fax_order key="[loop-code]"]
[L]PO Number[/L]:  [loop-data userdb project_id]
[L]FAX number[/L]:  [loop-data userdb fax]
[L]Dealer[/L]:  [display arbitrary=custview table=userdb column=dealer key="[loop-code]"]
[L]Wants email copy[/L]:  [display arbitrary=custview table=userdb column=email_copy key="[loop-code]"]
[L]Mail lists[/L]:  [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] [L]Bill To[/L]: [else] [L]Bill To[/L]: [/else] [/if-loop-data]

[if-loop-data userdb b_address1] [scratch bill_address] [else] [scratch ship_address] [/else] [/if-loop-data]
[L]Ship To[/L]:
[scratch ship_address]
[set bill_address][/set] [set ship_address][/set]
[query list=1 st=db table=transactions sql="select order_number, order_date, total_cost, status FROM transactions WHERE username = '[loop-code]' ORDER BY order_date " ] [/query]
[L]Order number[/L]       [L]Order date[/L]       [L]Order Total[/L]       [L]Status[/L]
[sql-code] [sql-param order_date] [currency][sql-param total_cost][/currency] [msg][sql-param status][/msg]
[button text="[L]Back[/L]"] viewnext= viewcustomer= [/button] [button text="[L]Enter order[/L]"] mv_nextpage=__UI_BASE__/entry mv_todo=return [/button] [if-mm advanced userdb=e] [if-loop-data userdb inactive] [button name="activate" text="[L]Activate customer[/L]"][/button] [else] [button name="deactivate" text="[L]Deactivate customer[/L]" confirm="[L]Are you sure you want to deactivate this customer?[/L]"][/button] [/else] [/if-loop-data] [button text="[L]Change password[/L]"] 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_@