Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListThank You to the creators of F&LThank You to the creators of F&L
Previous
 
Next
New Post
8/19/2011 12:13 PM
 
Hello..
Just wanted to write and give a BIG Thank You to the creators of F&L.

With the use of filtering, effective/expiration dates on items, and customizing of XSLT sheets, I was able to create a working layout for the F&L module which took the place of multiple HTML modules on a page with effective / expiration dates.

We're using this for a bids page and we needed to ensure expired bids wouldn't be shown.
Originally, this was done manually a day or two after the bids expiration date.  People complained about the bid listings still being out there after their expired dates so there needed to be an automated way for hiding and showing the different bids according to their effective/expiration dates.
So we started using multiple HTML modules on the page, and copying the code between the different modules (sometimes 3, 4 or 5 modules on a page).  We'd then setup effective/expiration dates of these modules and edit their code to add effective bids and remove the expired bids.  This started giving us issues because the people making the configuration changes would get dates confused, modules not configured correctly, or not edit the HTML code directly.
Then after researching in the forums and other places, configured the F&L module to handle effective/expiration dates of items through filtering.  Used XSLT to either display the data when it was available or show that the other "no data" table when nothing was to be displayed.  The customization of everything made life a whole lot easier.

The person which enters the information into the F&L module loves it too due to the lack of time spent copying, pasting and editing HTML code.  She enters the information into a form, clicks on update and it's there with the proper table layout, colors, background, etc.  An item is not shown until the effective date of a bid and its removed when it's expiration date occurs, all automatically.

Thanks again..  -Jeff

FYI about the module configuration:
Added two date columns; one for the effective date (Effective Date) and one for the expiration date (Deadline).
The F&L module is using the filter statement [Effective Date_udt_Ticks] <= [Ticks:Now] AND [Deadline_udt_Ticks] >= [Ticks:Now]  to only show the items which today's date falls between their effective and deadline dates.

Within the XSLT (see code below), have it configured to test whether there is data in the F&L table (line 29).
If there is data available within the F&L, then add a header line with the data items below that (begins line 30).
If there is no data available within the F&L, then show the same header line, but display that there aren't any records to display (begins on line 52).

The only issue with this configuration is that you need to create another page and reference the existing F&L module on this new page.  When you do this, all the information will be displayed without the filtering so you can remove old items, etc; not a major show stopper.

Hope this may help others which are looking for the same functionality.

XSLT File Information:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:udt="DotNetNuke/UserDefinedTable" exclude-result-prefixes="udt">
  <xsl:output method="xml" indent="yes" omit-xml-declaration="yes" />
  <!--
  This prefix is used to generate module specific query strings
  Each querystring or form value that starts with udt_{ModuleId}_param 
  will be added as parameter starting with param
  -->
  <xsl:variable name="prefix_param">udt_<xsl:value-of select="//udt:Context/udt:ModuleId" />_param</xsl:variable>


  <xsl:template match="udt:Data" mode="list">
    <tr class="Normal">
      <td style="background-color: #e1e8ec;" align="center">
        <xsl:call-template name="EditLink" />
        <xsl:value-of select="udt:Department_x0020_or_x0020_Agency" disable-output-escaping="yes" />
      </td>
      <td style="background-color: #e1e8ec;" align="center">
        <xsl:value-of select="udt:Legal_x0020_Notice" disable-output-escaping="yes" />
      </td>
      <td style="background-color: #e1e8ec;" align="center">
        <xsl:value-of select="udt:Deadline_UDT_Value" disable-output-escaping="yes" />
      </td>
    </tr>
  </xsl:template>


  <xsl:template match="/udt:UserDefinedTable">
    <xsl:variable name="currentData" select="udt:Data" />
    <xsl:choose>
      <xsl:when test="$currentData">
        <table border="1" cellspacing="0" bordercolor="#006699" cellpadding="2" width="95%" align="center">
          <tr>
            <td style="background-image: url(/portals/0/resources/images/backgrounds/com_back_head.jpg);" valign="bottom" align="center">
              <strong>
                <span style="font-size: small; color: #e1e8ec;">Department or Agency</span>
              </strong>
            </td>
            <td style="background-image: url(/portals/0/resources/images/backgrounds/com_back_head.jpg); height: 19px;" valign="bottom" align="center">
              <strong>
                <span style="font-size: small; color: #e1e8ec;">Legal Notice </span>
              </strong>
            </td>
            <td style="background-image: url(/portals/0/resources/images/backgrounds/com_back_head.jpg);" valign="bottom" align="center">
              <strong>
                <span style="font-size: small; color: #e1e8ec;">Deadline</span>
              </strong>
            </td>
          </tr>
          <xsl:apply-templates select="$currentData" mode="list">
          </xsl:apply-templates>
        </table>
      </xsl:when>
      <xsl:otherwise>
        <table border="1" cellspacing="0" bordercolor="#006699" cellpadding="2" width="95%" align="center">
          <tbody>
            <tr>
              <td style="background-image: url(/portals/0/resources/images/backgrounds/com_back_head.jpg);" valign="bottom" align="center">
                <strong>
                  <span style="font-size: small; color: #e1e8ec;">Department or Agency</span>
                </strong>
              </td>
              <td style="background-image: url(/portals/0/resources/images/backgrounds/com_back_head.jpg); height: 19px;" valign="bottom" align="center">
                <strong>
                  <span style="font-size: small; color: #e1e8ec;">Legal Notice </span>
                </strong>
              </td>
              <td style="background-image: url(/portals/0/resources/images/backgrounds/com_back_head.jpg);" valign="bottom" align="center">
                <strong>
                  <span style="font-size: small; color: #e1e8ec;">Deadline</span>
                </strong>
              </td>
            </tr>
            <tr>
              <td style="background-color: #e1e8ec;" colspan="3" align="center">
                <span style="font-size: small;">No projects are currently out for bid.</span>
              </td>
            </tr>
          </tbody>
        </table>
      </xsl:otherwise>
    </xsl:choose>
  </xsl:template>


  <xsl:template name="EditLink">
    <xsl:if test="udt:EditLink">
      <a href="{udt:EditLink}">
        <img border="0" alt="edit" src="{//udt:Context/udt:ApplicationPath}/images/edit.gif" />
      </a>
    </xsl:if>
  </xsl:template>
</xsl:stylesheet>
 
New Post
8/30/2011 9:01 PM
 
Hi Jeff,
we are glad that you like the module. We are aware that there are some challenges, but it is great to see users "surviving" this challenge and implement really cool solutions - congratulation!

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListThank You to the creators of F&LThank You to the creators of F&L


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out