Table date formatting help

[mclisa81]

Hi,

 

I'm trying to generate a table for particular calendar months and ran into an issue. Since we are only allowing for 5 weeks, some dates need to be combined on the 5th row (see circled dates on p2 of the template for an example). I believe there would only be 3 different occurrences, 23/30, 24/31 or 23/30 and 24/31.

 

I'm sure there is a way to do this but I'm stumped. I've uploaded the collected files.

 

Thanks in advance for any help.

Lisa

cal.zip

[Dan Korn]

You're using some table attributes that aren't supported in FusionPro. I think it's easier to use the table API instead. With that in mind, I came up with this function, which I would put into the JavaScript Globals:

function MakeCalendar(Month, Year) // (month 1 for January, 2 for February, etc.; year four digits)
{
   var JSMonth = (Month-1)%12; // zero-based
   var theDate = new Date(Year, JSMonth, 1);

   var MonthName = FormatDate(theDate, "lm yyyy") ;

   // Initialize to the first Sunday of the week containing the first day of this month.
   theDate.setDate(theDate.getDate() - theDate.getDay());

   var table = new FPTable;
   for (var day = 1; day <= 7; day++)
       table.AddColumn(12230);

   var row;
   do
   {
       if (table.Rows.length < 5)
           row = table.AddRow();

       for (var day = 0; day < 7; day++)
       {
           if (theDate.getMonth() == JSMonth)
           {
               var existingContent = row.Cells[day].Content;
               if (!existingContent)
               {
                   row.Cells[day].PointSize = 60;
                   row.Cells[day].Content = theDate.getDate();
               }
               else
               {
                   row.Cells[day].PointSize = 30;
                   row.Cells[day].Content = '<p br=false superratio=100 superoffset=50 subratio=100 suboffset=0>' +
                       '<superscript>' + existingContent + '</superscript>/<subscript>' + theDate.getDate() + '</subscript>';
               }
           }

           theDate.setDate(theDate.getDate() + 1);
       }
   }
   while (theDate.getMonth() != (JSMonth+1)%12)

   var title = "<p br=false quad=C><z newsize=58>" + MonthName + "<br><br>\n";
   return title + table.MakeTags();;
}

Then each rule can be just this (varying the month in each):

return MakeCalendar(12, 2018);

It's basically the same logic you had, just converted to use the table API, and with two extra things: one, don't add more than five rows, and two, if the cell already has a number in it, combine that with the number for the day we're adding. I used a bit of markup with superscript and subscript to get something close to the effect you're after; you can tweak this as needed.

[mclisa81]

Exactly what I was looking for. Thanks for the help Dan!

 

Lisa