[ic] about order.html

Alma Nuker interchange-users@interchange.redhat.com
Tue Apr 16 02:09:01 2002


>How to modify order.html if i want to display more column "paid"?

>Thanks,

>Grace


Are you talking about order.html in

/interchange/lib/UI/pages/admin???

Normaly all you have to do is:
[search-region more=1 arg="
                fi=transactions
                ml=__UI_SZ_LIST_ORDER__
                md=1
                st=db
                [if cgi mv_like_spec]
                        [cgi ui_text_qualification]
                [elsif cgi ui_text_qualification]
                        se=[cgi ui_text_qualification]
..................................

rf=code,order_date,total_cost,nitems,status,city,state,country,fname,lname,username,paid"]

** this paid adds return field

Then add following:

<TABLE border=0 CELLSPACING=0 width="90%">
<tr bgcolor=000000 height=1><td colspan=8></td></tr>
<TR BGCOLOR="__UI_C_TITLEBARBG__">
<th>&nbsp;</th>
<TH ALIGN=LEFT><FONT COLOR="__UI_C_TITLEBARTXT__">
[page href=@@MV_PAGE@@ form=`
        return "ui_sort_field=code\n" . sortrev('code');
        `][L]Order[/L]</A>
</TH>
<TH ALIGN=LEFT><FONT COLOR="__UI_C_TITLEBARTXT__">
[page href=@@MV_PAGE@@ form=`
        return "ui_sort_field=lname,fname\n" . sortrev('lname');
        `][L]User[/L]</A>
</TH>
<TH ALIGN=LEFT><FONT COLOR="__UI_C_TITLEBARTXT__">
[page href=@@MV_PAGE@@ form=`
        return "ui_sort_field=country,state,city\n" .
sortrev('country');
        `][L]Location[/L]</A>
.............

<TH ALIGN=RIGHT><FONT SIZE=-1 COLOR="__UI_C_TITLEBARTXT__">
[page href=@@MV_PAGE@@ form=`
        return "ui_sort_field=paid\n" . sortrev('paid');
`][L]Paid[/L]</A>
</TH>
</tr>

And then add:
.....................
<TD ALIGN=LEFT>[convert-date][item-param order_date][/convert-date]</TD>

<TD ALIGN=CENTER>[item-param nitems]</TD>
<TD ALIGN=Right>[currency][item-param total_cost][/currency]</TD>
<TD ALIGN=Right>[page href="__UI_BASE__/order_status"
form="order=[item-code]"][loc][item-param
status][/loc]</A></TD>..............


<TD ALIGN=Right>[item-param paid]</TD>
</tr>
[/search-list]
[no-match]..........

This is all done assuming that your "paid" column exists.

Hope it helps.

Alma