[set page_banner]Interchange Order List[/set] [set fm_class]Orders[/set] [set help_name]interchange order list[/set] [set page_title]Interchange Order List[/set] [set icon_name]icon_item.gif[/set] @_FM_STD_HEAD_@ [value name=select_order set=""] [value name=custtype set=""] [query sql="SELECT COUNT(*) FROM transactions WHERE status = 'pending' AND archived=0 AND deleted=0" list=1] [seti rowsfound][sql-pos 0][/seti] [/query] [if scratch rowsfound] [query more=1 ml=20 list=1 sql="SELECT order_number AS ordernr, lname||', '||fname AS name FROM transactions WHERE status = 'pending' AND archived=0 AND deleted=0 ORDER BY order_number"] [list] [/list]
[L]Select[/L] [L]Ordernr[/L] [L]Name[/L] ([L]#[/L]: [scratch rowsfound])
 
[sql-param ordernr] [sql-param name]

[more-list] [more] [/more-list] [/query]
[L]All[/L]
[set [L]New[/L]] mv_todo=return mv_action= [/set] [set [L]Update Selected[/L]] mv_todo=return mv_action=Update [/set] [set [L]Remove Selected[/L]] mv_todo=return mv_action=Delete [/set] [set rowsfound][/set] [else]

 
[L]No orders were found.[/L]

[comment] Should we go diretly to the update page w/o needing user input? [/comment] [L]Please press New to add invoices.[/L]

[/else] [/if] @_FM_STD_FOOTER_@