Discussion:
[ic] showing items in order reports - solved
Davideth
2018-05-18 16:45:55 UTC
Permalink
    <TD VALIGN=top>
    <table width="10%" border=0 cellpadding=0 cellspacing=1>
[query list=1 table=orderline sql="select * from orderline where
order_number = '$line->{order_number}'" ignore_undefined=1]
            <tr class="[sql-alternate
2]rowalt[else]rownorm[/else][/sql-alternate]" valign=top>
               <td>[sql-param sku]</td>
            </tr>
[/query]
         </table>

    </TD>


The above code was added to the pending orders report to show the items
in each order.

html code for resulting table below:


<TABLE width="90%" border=5 cellpadding=0 cellspacing=0><tr
class=rborder height=1><td colspan=7></td></tr><TR class=rmarq><TD
VALIGN=top >Order </TD><TD VALIGN=top>Affiliate </TD><TD
VALIGN=top>Items </TD><TD VALIGN=top>Name </TD><TD VALIGN=top>Address
</TD><TD VALIGN=top>Date/Time </TD><TD ALIGN=right VALIGN=top>Amount
</TD><TD ALIGN=right VALIGN=top>Status </TD></TR><tr class=rborder
height=1><td colspan=7></td></tr><TR class=rnorm BORDER=4><TD
VALIGN=top><A
HREF="https://huldaclarkparazapper.com/cgi-bin/cart.cgi/admin/order_view?order=HCPZ55370&id=fBLKERzq&mv_pc=168">HC15300</A></TD><TD
VALIGN=top>paradevi&nbsp; </TD><TD VALIGN=top><table width="10%"
border=0 cellpadding=0 cellspacing=1><tr class="rownorm"
valign=top><td>pz40066</td></tr></table></TD><TD
VALIGN=top>Hullsby&nbsp; </TD><TD VALIGN=top>Clinton, MA </TD><TD
VALIGN=top>20180430 03:09:31 </TD><TD ALIGN=right VALIGN=top>$479.15
</TD><TD ALIGN="right" VALIGN=top >pending </TD></TR><TR class=rnorm
BORDER=4><TD VALIGN=top><A
HREF="https://huldaclarkparazapper.com/cgi-bin/cart.cgi/admin/order_view?order=HCPZ55371&id=fBLKERzq&mv_pc=169">HC15301</A></TD><TD
VALIGN=top>pzcom&nbsp; </TD><TD VALIGN=top><table width="10%" border=0
cellpadding=0 cellspacing=1><tr class="rownorm"
valign=top><td>pz00024</td></tr><tr class="rowalt"
valign=top><td>pz40066</td></tr></table></TD><TD
VALIGN=top>Youngoos&nbsp; </TD><TD VALIGN=top>Thomas, CA </TD><TD
VALIGN=top>20180430 10:44:22 </TD><TD ALIGN=right VALIGN=top>$571.00
</TD><TD ALIGN="right" VALIGN=top >pending </TD></TR><tr class=rborder
height=1><td colspan=8></td></tr><TR class=rnorm><TD VALIGN=top>GRAND
TOTAL </TD><TD VALIGN=top>&nbsp; </TD><TD VALIGN=top>&nbsp; </TD><TD
VALIGN=top>&nbsp; </TD><TD ALIGN=right VALIGN=top>&nbsp; </TD><TD
ALIGN=right VALIGN=top>&nbsp; </TD><TD ALIGN=right VALIGN=top>$1,050.15
</TD><TD ALIGN=right VALIGN=top>&nbsp; </TD></TR><tr class=rborder
height=1><td colspan=8></td></tr></TABLE>

Loading...