Changeset 427 for trunk/phpbms/common

Timestamp:

08/13/08 12:09:00 (4 years ago)

Author:

nate

Message:

• Initial implementation of table imports.
• Tables engine type changed to INNODB to support mysql transactions.
• Tabledefs and tableoptions tables modified with additional columns.
• Permits additional commands to be called without records needing to be selected, provided they have the correct property (found in tableoptions sections of the tabledef add edit).
• Fixes delete button name for tax areas tabledef.

Location:

trunk/phpbms/common

Files:

• javascript/queryfunctions.js (modified) (5 diffs)
• stylesheet/mozilla/pages/imports.css (added)
• stylesheet/mozilla/pages/search.css (modified) (1 diff)

trunk/phpbms/common/javascript/queryfunctions.js

@@ -93 +93 @@
         if(!ctrlkeydown && shiftkeydown){
                 //Need to program shift click in here!
-                var curID=null;
-                var theTable=theTR.parentNode;
-                var searchArray="+"+selIDs.join("+")+"+";
-                var point1=null;
-                var point2=null;
+                var curID = null;
+                var theTable = theTR.parentNode;
+                var searchArray = "+"+selIDs.join("+")+"+";
+                var point1 = null;
+                var point2 = null;
                 
                 for(i=0;i<theTable.childNodes.length;i++){
                         if (theTable.childNodes[i].className){                          
                                 if(theTable.childNodes[i].className != "queryGroup"){
-                                        theTable.childNodes[i].className="qr"+theTable.childNodes[i].className.charAt(theTable.childNodes[i].className.length-1);
-                                        curID=theTable.childNodes[i].id.substr(2);
-                                        if(curID==theID)
-                                                point1=i;
-                                        if(searchArray.indexOf("+"+curID+"+")!=-1 && point2==null) {
-                                                point2=i;
+                                        theTable.childNodes[i].className = "qr"+theTable.childNodes[i].className.charAt(theTable.childNodes[i].className.length-1);
+                                        curID = theTable.childNodes[i].id.substr(2);
+                                        if(curID == theID)
+                                                point1 = i;
+                                        if(searchArray.indexOf("+"+curID+"+") != -1 && point2==null) {
+                                                point2 = i;
                                         }
                                 }
@@ -157 +157 @@
 }
 
-function chooseOtherCommand(thevalue,thetext){
-        var thediv = getObjectFromID("otherDropDown");
-        var otherField = getObjectFromID("othercommands");
-        
-        otherField.value = thevalue;
-        
-        if (thevalue != "-1") {
-                setSelIDs(otherField.form);
-                otherField.form.submit();
-        } else {
-                var confirmcommand=thetext
-                confirmDelete(confirmcommand);
-                thediv.style.display = "none";
-        }
+function chooseOtherCommand(thevalue, thetext, thesource){
+        
+        if(!thesource.className.match(/Disabled/)){
+                
+                switch(thevalue){
+                        case "-1":
+                                var thediv = getObjectFromID("otherDropDown");
+                                var confirmcommand=thetext;
+                                confirmDelete(confirmcommand);
+                                thediv.style.display = "none";
+                                break;
+                        
+                        case "-2":
+                                importRecord();
+                                break;
+                        
+                        default:
+                                var otherField = getObjectFromID("othercommands");
+                                setSelIDs(otherField.form);
+                                otherField.value = thevalue;
+                                otherField.form.submit();
+                                break;
+                }//end switch
+                
+        }//end if
+        
 }
 
@@ -210 +222 @@
         var printButton=getObjectFromID("print");
         var deleteButton=getObjectFromID("deleteRecord");
-        var otherCommands=getObjectFromID("otherCommandButton");
+        //var otherCommands=getObjectFromID("otherCommandButton");
         var relationship=getObjectFromID("relationship");
+        var select = getElementsByClassName("needselect");
+        if(!select.length)
+                var select = getElementsByClassName("needselectDisabled");
                 
         if(editButton)
@@ -218 +233 @@
         if(deleteButton)
                 deleteButton.className = "deleteRecord"+((disabledstatus)?"Disabled":"");
-
-        if(otherCommands) {
-                otherCommands.className = "otherCommands"+((disabledstatus)?"Disabled":"");
-                var otherDropDown = getObjectFromID("otherDropDown");
-                otherDropDown.style.display = "none";           
-        }
+                        
+        
+        for(i = 0;i < select.length; i++)
+                select[i].className = "needselect"+((disabledstatus)?"Disabled":"");
+        
+        
+        //if(otherCommands) {
+        //      otherCommands.className = "otherCommands"+((disabledstatus)?"Disabled":"");
+        //      var otherDropDown = getObjectFromID("otherDropDown");
+        //      otherDropDown.style.display = "none";
+        //}
                 
         if(relationship) relationship.disabled=disabledstatus;
@@ -271 +291 @@
 }
 
+function importRecord(){
+        var connector;
+        if (importFile.indexOf("?")>=0)
+                connector="&";
+        else
+                connector="?";
+        if(typeof xtraParamaters != "undefined")
+                importFile+=connector+(xtraParamaters);
+        document.location=importFile;
+}
 
 // Select All/None Button

trunk/phpbms/common/stylesheet/mozilla/pages/search.css

@@ -40 +40 @@
 .otherCommandsDisabled{background-image: url("../image/search-toolbar-cmd-db.png")}
 .searchSelection{background-image: url("../image/search-toolbar-selection.png")}
-.searchSelectionDisabled{background-image: url("../image/search-toolbar-selection-db.png")}
+.needselectDisabled{background-image: url("../image/search-toolbar-selection-db.png")}
+.needselectDisabled{
+        color:grey;
+}
 .sqlUp{background-image: url("../image/search-toolbar-sql.png")}
 .sqlDn{background-image: url("../image/search-toolbar-sql-dn.png")}