Hi Monks

I am new to perl and just recently started working on a tool using Html Template & CGI Application. One of my requirements is extracting rows of data from Oracle table and display it in columns! Let me give an example of data-

Name        Date From   Date To          Work Days
RP          01/03/2004 02/03/2004           2
RP          16/03/2004 17/03/2004           2
RP          08/04/2004 13/04/2004           2
GC          18/03/2004 25/03/2004           6
GC          08/04/2004 13/04/2004           2
GC          08/03/2004 09/03/2004           2
----
----
---

[download]

When user clicks on 'View Holiday Plan' Link, above details should be extracted, monthly total for each user is derived and displayed in following format- 

Name                          Months
     Jan Feb Mar  Apr May  Jun  Jul  Aug  Sep Oct  Nov  Dec    
RP            4    2             1                  10
GC            8    2
XX        2                  3                  1

[download]

Further when user clicks on a month name and if there are holidays booked in that month, it should display calander of the month with holiday dates highlighted. Each holiday dates are stored in a saperate table.

Any help/guidance will be greatly appreciated. Please remember I am cutting my teeth in CA & HT so some examples will really help me.

Thanks

jdporter - retitled

In reply to Creating reports with HTML::Template and CGI::Application by bar10der

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.