Example webview section jssp script
From Lianjapedia
Revision as of 04:36, 29 June 2016 by Yvonne.milne (Talk | contribs)
Description
Example JavaScript Server Page (.jssp) report from WebView Section and WebView Gadget guide.
See Also
Developing Custom WebViews in JavaScript
Code
<%@ Language=JavaScript %> <html> <head> <style> .tablecaption { background: gray; font-weight: bold; color: white; height:26px; } .smallfont { font-size:small; } body { padding: 0px; margin: 0px; border: 1px solid lightgray; border-top: 1px solid white;} </style> </head> <body> <% db = Lianja.openDatabase("southwind"); // Open a recordset rs = db.openRecordSet("select * from example"); // main table print("<table cellpadding=\"5\">"); print("<caption class=\"tablecaption\">Example JavaScript Report</caption>"); // print table headings rs.moveFirst(); print("<tr bgcolor=\"lightgray\" class=\"smallfont\">"); for (j=0; j < rs.fieldcount; ++j) { print("<th><font color=\"white\">" + rs.fields(j).name + "</font></th>"); } print("</tr>"); // Traverse the recordset and write the output into the Webview section. for (i=0; i < rs.reccount; ++i) { if ((i%2) == 0) { rowcolor = "#f1f6fe"; altcolor = "#FFFFFF"; } else { rowcolor = "#FFFFFF"; altcolor = "#f1f6fe"; } print("<tr bgcolor=\"" + rowcolor + "\" color=\"darkgray\" class=\"smallfont\" valign=top>"); for (j=0; j<rs.fieldcount; ++j) { name = rs.fields(j).name; value = rs.fields(j).value; if (['LIMIT', 'AVAILABLE', 'BALANCE'].indexOf(name) >= 0) { print("<td align=right>$" + value.toFixed(2) + "</td>"); } else { print("<td>" + value + "</td>"); } } print("</tr>"); rs.moveNext(); } // end of table print("</table>"); // Close the recordset rs.close(); // end of report print("<hr>Report complete at <b>" + new Date() + "</b>"); %> </body> </html>