[ic] Still seeking solution to bug in interchange reports

[Davideth]

To facilitate the handling of orders, we needed a menu type system that 
helped us track orders, sort of like McDonalds, etc.

So, I have modified the order detail reports so that we can separate the 
shipped and cancelled orders from the pending order reports and they 
seem to work fine.

First, we need at least the user's last name in the reports so we added 
to Detail.html :
     <TD VALIGN=top>
     [L]Order[/L]
     </TD>
     <TD VALIGN=top>
         [L]Affiliate[/L]
     </TD>
     <TD VALIGN=top>
         [L]Campaign[/L]
     </TD>
     <TD VALIGN=top>
         [L]Name[/L]
     </TD>
_____________AND________________

[query    hashref=main
     st=db
     ml=100000
     table=transactions
     sql="
     select order_number, affiliate, campaign, total_cost, 
payment_method, state, city, status, order_date, lname
         from  transactions
         WHERE deleted <> '1'

_____________AND________________

     <TR class=rnorm>
     <TD VALIGN=top>
     <A HREF="$url">$line->{order_number}</A>
     </TD>
     <TD VALIGN=top>
     $line->{affiliate} 
     </TD>
     <TD VALIGN=top>
     $line->{campaign} 
     </TD>
     <TD VALIGN=top>
     $line->{lname} 
     </TD>

_____________________________

We also need the invoice number but could not find it saved anywhere in 
the orderline or transaction files. That is the only information that 
the customers get and they call up asking for a status on invoice number.

To get the pending, shipped, and cancelled order reports, we copied and 
modified the Detail.html

_____________pending orders________________ >>Pending.html

     foreach $line (@$mary) {
         if ( $line->{status} eq 'pending') {  ### pending orders only

         $total_sales    += $line->{total_cost};
         $amount = $Tag->currency({}, $line->{total_cost});
             $line->{status} = $Tag->loc('', $line->{status});

         $url = $Tag->area({     href => '__UI_BASE__/order_view',
                     form => "order=$line->{order_number}", });


         $out .= <<EOF;

....

}

_____________shipped orders________________  Shipped.html

     foreach $line (@$mary) {
         if ( $line->{status} eq 'shipped') {  ### shipped orders only

         $total_sales    += $line->{total_cost};
         $amount = $Tag->currency({}, $line->{total_cost});
             $line->{status} = $Tag->loc('', $line->{status});

         $url = $Tag->area({     href => '__UI_BASE__/order_view',
                     form => "order=$line->{order_number}", });


         $out .= <<EOF;

______________cancelled orders_______________ Cancelled.html

For canceled orders, we modified:

     foreach $line (@$mary) {
         if ( $line->{status} eq 'canceled') {  ### canceled orders only

         $total_sales    += $line->{total_cost};
         $amount = $Tag->currency({}, $line->{total_cost});
             $line->{status} = $Tag->loc('', $line->{status});

         $url = $Tag->area({     href => '__UI_BASE__/order_view',
                     form => "order=$line->{order_number}", });


         $out .= <<EOF;
_____________________________


Also modified interchange/lib/UI/pages/include/menus/OrderStats.txt

code    mgroup    msort    next_line    indicator    exclude_on 
depends_on    page    form    name    super    inactive description    
help_name    img_dn    img_up    img_sel img_icon    url
001    OrderReports    x001                    admin/orderstats     
Order Reports Menu        0
002    OrderReports    x002 admin/reports/order/ByAffiliate        
Overall by month 0
003    OrderReports    x003 admin/reports/order/Monthly        This 
month        0     For this month
004    OrderReports    x004 admin/reports/order/Detail        Individual 
orders        0  For this month
005    OrderReports    x005 admin/reports/order/BySKU        By SKU    
     0     For this month
006    OrderReports    x006 admin/reports/order/Pending        Pending 
orders        0     For this month
007    OrderReports    x007 admin/reports/order/Shipped        Shipped 
orders        0     For this month
008    OrderReports    x008 admin/reports/order/Canceled        Canceled 
orders        0  For this month

_____________________________

And modified interchange/lib/UI/pages/admin/orderstats.html

<TD COLSPAN=2 class=rnorm>
     [set [L]List individual orders[/L]]
     mv_nextpage=__UI_BASE__/reports/order/Detail
     [/set]
     [set [L]List pending orders[/L]]
     mv_nextpage=__UI_BASE__/reports/order/Pending
     [/set]
     [set [L]List shipped orders[/L]]
     mv_nextpage=__UI_BASE__/reports/order/Shipped
     [/set]
     [set [L]List canceled orders[/L]]
     mv_nextpage=__UI_BASE__/reports/order/Canceled
     [/set]
     [set [L]By day[/L]]
     mv_nextpage=__UI_BASE__/reports/order/Monthly
     [/set]
     <BLOCKQUOTE>
     <INPUT TYPE=submit VALUE="[L]By 
month[/L]">    <INPUT TYPE=submit NAME=mv_click 
VALUE="[L]By day[/L]">    <INPUT TYPE=submit 
NAME=mv_click VALUE="[L]List individual 
orders[/L]">    <INPUT TYPE=submit NAME=mv_click 
VALUE="[L]List pending orders[/L]">    <INPUT 
TYPE=submit NAME=mv_click VALUE="[L]List shipped 
orders[/L]">    <INPUT TYPE=submit NAME=mv_click 
VALUE="[L]List canceled orders[/L]">
     </BLOCKQUOTE>
</TD>


_____________________________

I am happy to contribute and will be glad to upload the full files if 
anyone requests so.


Also, My greatest appreciation to those who helped with suggestions.

David Etheredge