<\/p>\n
<\/p>\n
In all templates, m-Power uses the Freemarker template engine to create your Java Servlet Applications. While Freemarker itself is not a "complete" coding language, it is quite powerful and rich with many customizable options.<\/p>\n
When you generate any m-Power application, you will see code similar to this in the source of your HTML:<\/p>\n
The first and last lines of the code #list and \/#list dictate to your Java Servlet to repeat this section of code for as many records as are requested to be displayed on the screen.<\/p>\n Within m-Power, fields are noted: ${row.CMPNO?html} where CMPNO is the name of your Field. The $ denotes that a Substitution is about to occur. {row. Indicates the location the field is to come from. Alternatives to the {row. Syntax would be row0.FIELDNAME for Single Record Templates, and ${grandTotal, ${subTotal1, ${subTotal2 for Reports. The CMPNO indicates the name of the Field from your Database. Lastly, the ?html indicates the field's encoding.<\/p>\n Note:<\/strong> Any code outside of the <#list> and <\/#list> tags will only be preformed once.<\/p>\n Basic Coding with Freemarker within Presentation (HTML) Layer<\/strong><\/p>\n Creating New Variables<\/em><\/p>\n Freemarker structure is fully customizable to include some coding placed directly within the presentation (HTML) layer. To assign a variable, use the following syntax:<\/p>\n Note:<\/strong> For computability reasons within m-Painter, you must wrap all #assign tags within HTML comment tags.<\/p>\n Examples of the #assign tag.<\/p>\n To use these variables, simply use the following text: ${counter} where counter is your newly created variable name. Note:<\/strong> There is no "row." logic.<\/p>\n If you wish to create a variable and assign a value from your database, please use the following syntax:<\/p>\n If & If\/Else Looping<\/em><\/p>\n You can also utilize looping within the HTML layer as well. The syntax is as follows:<\/p>\n Code inside If statement<\/p>\n Valid relationships include all standard relationships, including:<\/p>\n == — Equals<\/p>\n > — Greater than<\/p>\n >= — Greater than or Equal to<\/p>\n < — Less than<\/p>\n < — Less than or Equal to<\/p>\n != — Not equal to<\/p>\n You can also use Else logic as well:<\/p>\n Variable is equal to 7<\/p>\n Variable is equal to 0<\/p>\n If you wish to use a Database value within your IF statement, please use the following syntax:<\/p>\n Common Variables<\/em><\/p>\n ${visitor.user} — Only available when mrc Security has been activated. Will display the User's Sign on name.<\/p>\n ${visitor.library} — Will return the name of the Current Data Dictionary.<\/p>\n ${visitor.appName} — Will return the Application name. For instance, Report 10 would return R00010, unless specifically changed within the Application Defaults screen.<\/p>\n ${visitor.sessionID} — Will return the 32 character Session ID. This ID is unique by Browser Session, thus no two browsers can have the same session ID.<\/p>\n ${visitor.remoteIp} — This variable will return the IP address of the Client's browser.<\/p>\n ${visitor.loginDate} — This variable will return the Date of the Initial login. It is in the format YYYY-MM-DD. In the absence of mrc Security, it will display the time the application was first accessed.<\/p>\n ${visitor.loginTime} — This variable will return the Time of the Initial login. It is in the format HH:MM:SS. In the absence of mrc Security, it will display the time the application was first accessed.<\/p>\n ${visitor.userAgent} — This variable will return the full User Agent string from the client's browser.<\/p>\n Common Date Variables<\/em> Assuming the current date is 2018-01-10, the date variables would return the following values:<\/p>\n ${visitor.today} — Current date (2018-01-10) How to Implement your own Freemarker Custom Changes<\/strong><\/p>\n To make Freemarker changes, compile your application and enter m-Painter. Click the "Source" button and find your Links to Useful Freemarker Resources<\/strong><\/p>\n — Useful Freemarker String Functions<\/a><\/p>\n — Useful Freemarker Numeric Functions<\/a><\/p>\n<!-- <#list table_rows as row> --><\/code><\/p>\n<tr> <td nowrap class=\"${rowClass(row_index)}\" align=\"right\"><\/code><\/p>\n${row.CUSNO?html}<\/code><\/p>\n<\/td><td nowrap class=\"${rowClass(row_index)}\" align=\"right\"><\/code><\/p>\n${row.CMPNO?html}<\/code><\/p>\n<\/td><td nowrap class=\"${rowClass(row_index)}\" align=\"left\"><\/code><\/p>\n${row.CNAME?html}<\/code><\/p>\n<\/td> <\/tr><\/code><\/p>\n<!-- <\/#list> --><\/code><\/p>\n<!--<#assign variablename=value>--><\/code><\/p>\n<!--<#assign counter=0>--><\/code><\/p>\n<!--<#assign counter=counter+1>--><\/code><\/p>\n<!--<#assign sometext=\"Sample Text\">--><\/code><\/p>\n<!--<#assign sometext= row.FIELDNAME>--><\/code> Note:<\/strong> Using ${row.FIELDNAME} will cause a Run-Time Error.<\/p>\n<!--<#if variable RELATIONSHIP value>--><\/code> Note:<\/strong> For computability reasons within m-Painter, you must wrap all #if tags within HTML comment tags.<\/p>\n<!--<\/#if>--><\/code><\/p>\n<!--<#if variable == 0>--><\/code><\/p>\n<!--<#assign variable=7>--><\/code><\/p>\n<!--<#else>--><\/code> Note:<\/strong> For computability reasons within m-Painter, you must wrap all #else tags within HTML comment tags.<\/p>\n<!--<\/#if>--><\/code><\/p>\n<!--#if sometext== row.FIELDNAME>--><\/code> Note:<\/strong> Using ${row.FIELDNAME} will cause a Run-Time Error.<\/p>\n
\nAll values are returned in the YYYY-MM-DD format. Variables that return a range are separated by a space. Fiscal dates are determined from the 'fiscal_month' setting in the mrcjava\/WEB-INF\/classes\/mrc_runtime.properties file (i.e. fiscal_month=5).<\/p>\n
\n${visitor.tomorrow} — Tomorrow's date (2018-01-10)
\n${visitor.yesterday} — Yesterday's date (2018-01-09)
\n${visitor.thisweek} — Sunday to Saturday of the current week (2018-01-07 2018-01-13)
\n${visitor.thisweektodate} — Sunday of the current week to the current date (2018-01-07 2018-01-10)
\n${visitor.lastweektodate} — Sunday of the previous week to the current week day of the previous week (2017-12-31 2018-01-03)
\n${visitor.lastweek} — Sunday and Saturday of the previous week (2017-12-31 2018-01-06)
\n${visitor.nextweek} — Sunday to Saturday of the following week (2018-01-14 2018-01-20)
\n${visitor.thismonth} — First day of the current month to the last day of the current month (2018-01-01 2018-01-31)
\n${visitor.thismonthtodate} — First day of the current month to the current day of the current month (2018-01-01 2018-01-10)
\n${visitor.nextmonth} — First day of the following month to the last day of the following month (2018-02-01 2018-02-28)
\n${visitor.lastmonth} — First day of the previous month to the last day of the previous month (2017-12-01 2017-12-31)
\n${visitor.lastmonthtodate} — First day of the previous month to the current day of the previous month (2017-12-01 2017-12-10)
\n${visitor.thisquarter} — First day of the current quarter to the last day of the current quarter (2018-01-01 2018-03-31)
\n${visitor.lastquarter} — First day of the previous quarter to the last day of the previous quarter (2017-10-01 2017-12-31)
\n${visitor.thisyear} — First day of the current year to the last day of the current year (2018-01-01 2018-12-31)
\n${visitor.nextyear} — First day of the following year to the last day of the following year (2019-01-01 2019-12-31)
\n${visitor.lastyear} — First day of the previous year to the last day of the previous year (2017-01-01 2017-12-31)
\n${visitor.thisyeartodate} — First day of the current year to the current date (2018-01-01 2018-01-10)
\n${visitor.lastyeartodate} — First day of the previous year to the current day of the previous year (2017-01-01 2017-01-10)
\n${visitor.thisquarterfiscal} — First day of the current fiscal quarter to the last day of the current fiscal quarter (2017-11-01 2018-01-31)
\n${visitor.lastquarterfiscal} — First day of the previous fiscal quarter to the last day of the previous fiscal quarter (2017-08-01 2017-10-31)
\n${visitor.thisyearfiscal} — First day of the current fiscal year to the last day of the current fiscal year (2017-05-01 2018-04-30)
\n${visitor.lastyearfiscal} — First day of the previous fiscal year to the last day of the previous fiscal year (2016-05-01 2017-04-30)
\n${visitor.thisyearfiscaltodate} — First day of the current fiscal year to the current date (2017-05-01 2018-01-10)
\n${visitor.lastyearfiscaltodate} — First day of the previous fiscal year to the current day of the previous fiscal year (2016-05-01 2017-01-10)<\/p>\n<#list><\/code> section using m-Painter's Binoculars. It is at this location within the code that you can make all necessary changes.<\/p>\n