[Ils-source] r1339 - in trunk: db/mssql webapp

[scribe at crosswire.org]

Author: scribe
Date: 2015-07-27 07:26:26 -0700 (Mon, 27 Jul 2015)
New Revision: 1339

Added:
   trunk/db/mssql/upgrade181.1.sql
Modified:
   trunk/webapp/admin_coursenew.jsp
Log:
ILS-11 increased course description length to 500 and added a counter to field user interface.


Added: trunk/db/mssql/upgrade181.1.sql
===================================================================
--- trunk/db/mssql/upgrade181.1.sql	                        (rev 0)
+++ trunk/db/mssql/upgrade181.1.sql	2015-07-27 14:26:26 UTC (rev 1339)
@@ -0,0 +1 @@
+ALTER TABLE COURSE ALTER COLUMN COURSDESC VARCHAR(500);

Modified: trunk/webapp/admin_coursenew.jsp
===================================================================
--- trunk/webapp/admin_coursenew.jsp	2015-06-30 09:56:13 UTC (rev 1338)
+++ trunk/webapp/admin_coursenew.jsp	2015-07-27 14:26:26 UTC (rev 1339)
@@ -231,6 +231,7 @@
     <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/>
     <script type="text/javascript" src="crosswire.js"></script>
     <link href="lms_style.css" rel="stylesheet" type="text/css"/>
+    <script type="text/javascript" src="js/jquery/jquery.min.js"></script>
     <script type="text/javascript" language="JavaScript">
 //<!--
 function rD(val) {
@@ -247,8 +248,18 @@
     }
 }
 
+function updateRemainingDescription() {
+	var d = $('#courseDescription').val();
+	if (d.length > 500) { d = d.substring(0,500); $('#courseDescription').val(d); }
+	$('#remainingDescription').html((500-d.length) + ' Remaining&nbsp;&nbsp;');
+}
 
+$(document).ready(function() {
+	updateRemainingDescription();
+	$('#courseDescription').on('change keyup paste', updateRemainingDescription);
+})
 
+
 // -->
 
 
@@ -285,8 +296,8 @@
                         <td><input name="name" type="text" value="<%=current.getCourseName()%>" size="40"/>                        </td>
                       </tr>
                       <tr>
-                        <td class="formHeadings">Course Description :</td>
-                        <td><textarea style="width:100%" name="desc" rows="7" cols="40"><%=current.getCourseDesc()%></textarea></td>
+                        <td class="formHeadings">Course Description :<br/><span id="remainingDescription">500 Remaining&nbsp;&nbsp;</span></td>
+                        <td><textarea id="courseDescription" style="width:100%" name="desc" rows="7" cols="40"><%=current.getCourseDesc()%></textarea></td>
                       </tr>
                       <tr>
                         <td class="formHeadings">Active Date : </td>