Presentation Layer Design question to display multi header / detail html tables

Greenhorn

Posts: 5

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi all.. I've having a little bit of a design problem ultimately my html needs to appear like this. (please excuse any formatting problems)

Html Header Table 1
Col1 Col 2 Col 3
Html Detail Table 2
Col 1 Col 2 Col 3
Col 1 Col 2 Col 3
etc..etc.
Html Header Table 2 (Chile of Parent Table 1
Col 1 Col 2 Col 3
Html Detail Table 2
Col 1 Col 2 Col 3
etc.etc. to the 4th level.

So basically there are 4 levels of data with the html being indented to the right.

Currently I'm using Struts / an Arraylist of Plain Old Java Beans returned back to my JSP. in the JSP i'm iterating through the arraylist with the struts itereate tag lib.. my issue. is to how to perform control breaking / grouping with multiple levels of data.. ie..

Group 1
Details
Group 1a
Details
Group 2
Detail

or
PO # PO Desc
10000 PO Desc 1
PO Line Po Line Desc
1 Po line desc 1
Asset Serial Asset Desc
123434 Test Desc
123321 Test Desc 2

I just can't figure out how to filter the arraylist of beans using simple struts tags and easily format the html.. I'm I crazy?

Marc Peabody

pie sneak

Posts: 4727

I like...

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

From what I can see, it shouldn't be too difficult.

Would it be possible for you to provide either:
A) A link to a sample html of the table layout or
B) the tables with TRs and TDs written in your post

Also some more information about what your beans hold would help.

That would be much easier for me to write up a solution.

A good workman is known by his tools.

Rick Nendza

Greenhorn

Posts: 5

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Thanks mark

To keep it simple.. lets say at the domain level I have an AssetBean with fields orgSid, orgName, poNum, poHeaderDesc, poHeaderContact,poLineNum, poLineDesc, assetID, serialNum,assetDesc
(we will leave the asset (final nest out for simplication purposes)

After running the query I am populating an ArrayList with AssetBeans.
I want this

Org Group 1
Po Header 1
Po line1
po line2
Po header 2
po line1
po line2
po line 3
 
<html>
<body>
<table width="600">
  <tr> 
      <td>Org Sid col Header</td>
      <td>Org Desc col header</td>
  <tr>
  <tr> (1 to N rows with orgsid as key)
      <td>Org Sid col value</td>
      <td>Org Desc col value</td>
  </tr>
  <tr>
       <td colpan=2>
           <table width=600>
              <tr>
                 <td width=20>(spacer) </td>
                 <td width=180>po num col header</td>
                 <td width=200>po desc col header</td>
                 <td width=200>po header contact col header</td>
              </tr>
              <tr>  (1 to n rows breaking on orgSid)
                 <td width=20>(spacer) </td>
                 <td width=180>po header num col value</td>
                 <td width=200>po po header desc col value</td>
                 <td width=200>po header contact col value</td>
              </tr>
              <tr>
                 <td colspan=4>
                      <table width=600>
                         <tr>
                             <td width="40">(spacer_  </td>
     <td width=280>po line num num col header</td>
                             <td width=300>po line desc col header</td>
                         </tr>
                         <tr> (1 to n rows breaking on po header num
                             <td width="40">(spacer_  </td>
     <td width=280>po line num col value </td>
                             <td width=300>po line desc col value</td>
                         </tr>
                      </table>
                 </td>
              </tr>
           </table>
             
        </td>
  </tr>
  <tr>
      <td colspan="2"
</table>
</body>
</html>

Marc Peabody

pie sneak

Posts: 4727

I like...

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Is it correct to say that the database results are not normalized (by that I mean that you could end up with two or more AssetBeans with the same orgSid)???

If so.... a little OOAD refactoring should help out a ton.
It would be much easier in Struts tags to iterate if you had collections within collections.
For example, we'll start by changing the name AssetBean to OrgBean and
each OrgBean would contain a unique:
* orgSid String,
* orgName String,
* and ArrayList of POBeans (or whatever you want to call them).

That way you can iterate through the OrgBeans and then within each iteration grab its ArrayList of POBeans and iterate through it. Further, each POBean would probably have a collection of AssetBeans, where each AssetBean is composed of assetID, serialNum, and assetDesc.

I hope this is of some assistance to you.

A good workman is known by his tools.

Rick Nendza

Greenhorn

Posts: 5

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

That is true.. that is one method that I considered.. However I'm currently using a sql mapping tool called iBatis to map the sql call to a an object of my choice. (in this case bean). why I know I can probably tweak it so map to many beans i was a little worried about possible overhead and memory usuage involved.. ie.. just returning the entire query back into a "flat" bean seemed as if it would be the fastest!!! But thanks for your help!