Re: [htmltmpl] Can HTML::Template do subtotals?
Brought to you by:
samtregar
Menu
▾
▴
Re: [htmltmpl] Can HTML::Template do subtotals?
|
From: Timm M. <tm...@ag...> - 2003-12-31 14:06:04
|
HTML::Template doesn't like doing any sort of logic beyond simple if statements and loops. You can do it with HTML::Template::Expr, or (preferably) you can calculate the totals in Perl and fill in the template with those values. At 05:27 AM 12/31/03 -0800, LDT wrote: >This is my first project using Perl and HTML::Template, and my first >posting to this users list (after searching ><http://www.bluedot.net/mail/archive/>http://www.bluedot.net/mail/archive/ >for things like "totals" and "total row" and "subtotal"). > >I'm trying to figure out how to insert subtotals periodically and to >calculate differences between two rows. For example, this is a mock up >similar to what I'm doing (mine is more complex): > >accounts curr month year-to-date >10-19 $xxx $xxx >20-29 $xxx $xxx >30-39 $xxx $xxx >sub1 10-39 $xxxxx $xxxxx >40-49 $xxx $xxx >50-59 $xxx $xxx >sub2 40-59 $xxxx $xxxx >grand total $xxxxx $xxxxx >diff b/w sub1 & sub 2 $xxx $xxx > >Right now, I'm using several case statements in my Sybase SQL and several >unions (which I know is pretty ugly)... but if I could get HTML::Template >and Perl to play nicely together and let me generate occasional subtotals >along the way (or differences as the case may be), that would be >great. Does HTML::Template have a way to do this? I have the H:T >documentation printed out (because I refer to it so often), and I'm >wondering if a TMPL_IF might be the answer. But, I can't wrap my brain >around how I could use it for subtotalling and differences. > >Oh, and feel free to dumb it down for me since I'm new to Perl, SQL, >[insert language here]. ;-) > >Thanks! > >Lori > >P.S. I didn't include my Perl code because I wasn't sure if it would be >necessary (and it's 600+ lines), but for the masochists among you, you can >see it here along with the .tmpl >file: ><http://www.perlmonks.org/index.pl?node_id=108949&user=Lori713>http://www.perlmonks.org/index.pl?node_id=108949&user=Lori713. >The .tmpl file is also included below: > ><!-- Begin Summary Report --> ><TMPL_INCLUDE 'nc_start.tmpl'> ><TMPL_INCLUDE 'nc_style.tmpl'> ><TMPL_INCLUDE 'nc_titlebar.tmpl'> ><TMPL_INCLUDE 'nc_rpt_hdr.tmpl'> ><hr> ><form name=frm_summ_rept method=POST >action="<http://www.ncsu.edu>http://www.ncsu.edu"> ><table border=1 cellspacing=0 cellpadding=1 width="100%" summary="Column >Headings and Data Cells"> ><tr valign="bottom"> ><th width="9%">Account Summary</th> ><th width="18%">Description</th> ><th width="4%">Current FTE</th> ><th width="9%">Current Budget</th> ><th width="9%">Current Month Activity</th> ><th width="9%">FYTD Activity</th> ><th width="9%">Pre-Encumbrances</th> ><th width="9%">Encumbrances</th> ><th width="11%">Budget Balance Available</th> ><th width="4%">Future FTE</th> ><th width="9%">Future Budget</th> ></tr> ><TMPL_LOOP NAME=passacts> > <tr class=<TMPL_VAR NAME=trclass> bgcolor=<TMPL_VAR NAME=bgcolor>> > <td align="left" style="cursor:pointer;cursor:hand;" > onmouseover="style.background='<TMPL_VAR > NAME=bgcolor>';" > onmouseout ="style.background='<TMPL_VAR > NAME=bgcolor>';"> > <font color=#000000><TMPL_VAR NAME=col_acct></td> > <td align="left" style="cursor:pointer;cursor:hand;" > title="Account(s) <TMPL_VAR NAME=col_acct>"> > <font color=#000000><TMPL_VAR NAME=col_descr></td> > <td align="right" style="cursor:pointer;cursor:hand;" > title="Click to drill down" > onmouseover="style.background='#CCCCFF';" > onmouseout ="style.background='<TMPL_VAR > NAME=bgcolor>';"> > <TMPL_VAR NAME=col_cfte></td> > <td align="right" style="cursor:pointer;cursor:hand;" > title="Click to drill down" > onmouseover="style.background='#CCCCFF';" > onmouseout ="style.background='<TMPL_VAR > NAME=bgcolor>';"> > <TMPL_VAR NAME=col_cbud></td> > <td align="right" style="cursor:pointer;cursor:hand;" > title="Click to drill down" > onmouseover="style.background='#CCCCFF';" > onmouseout ="style.background='<TMPL_VAR > NAME=bgcolor>';"> > <TMPL_VAR NAME=col_cmo></td> > <td align="right" style="cursor:pointer;cursor:hand;" > title="Click to drill down" > onmouseover="style.background='#CCCCFF';" > onmouseout ="style.background='<TMPL_VAR > NAME=bgcolor>';"> > <TMPL_VAR NAME=col_fytd></td> > <td align="right" style="cursor:pointer;cursor:hand;" > title="Click to drill down" > onmouseover="style.background='#CCCCFF';" > onmouseout ="style.background='<TMPL_VAR > NAME=bgcolor>';"> > <TMPL_VAR NAME=col_pre></td> > <td align="right" style="cursor:pointer;cursor:hand;" > title="Click to drill down" > onmouseover="style.background='#CCCCFF';" > onmouseout ="style.background='<TMPL_VAR > NAME=bgcolor>';"> > <TMPL_VAR NAME=col_enc></td> > <td align="right"><TMPL_VAR NAME=col_bba></td> > <td align="right" style="cursor:pointer;cursor:hand;" > title="Click to drill down" > onmouseover="style.background='#CCCCFF';" > onmouseout ="style.background='<TMPL_VAR > NAME=bgcolor>';"> > <TMPL_VAR NAME=col_ffte></td> > <td align="right" style="cursor:pointer;cursor:hand;" > title="Click to drill down" > onmouseover="style.background='#CCCCFF';" > onmouseout ="style.background='<TMPL_VAR > NAME=bgcolor>';"> > <TMPL_VAR NAME=col_fbud></td> > </tr> ></TMPL_LOOP> ></table> ></form> ><TMPL_INCLUDE 'nc_buttons.tmpl'> ><TMPL_INCLUDE 'nc_end.tmpl'> ><!-- End Summary Report --> > > >Do you Yahoo!? >Yahoo! Photos - ><http://us.rd.yahoo.com/evt=21486/*http://f1.pg.photos.yahoo.com/ph//spsimplenol?.file=ny_ts_splash.html>Get >your photo on the big screen in Times Square |
