Changeset 559 for trunk/phpbms/common

Timestamp:

06/02/09 17:03:56 (3 years ago)

Author:

brieb

Message:

• fixed saved searches and sorts to use uuids
• fixed snapshot uuid mishaps
• fixed tablecolumns insert/updates not working

Files:

• trunk/phpbms/common/javascript/queryfunctions.js (modified) (49 diffs)

trunk/phpbms/common/javascript/queryfunctions.js

@@ -39 +39 @@
 
         var sqlbttn=getObjectFromID("showSQLButton");;
-        
+
         if(sqlbttn){
                 var sqlDivs = new Array();
                 sqlDivs[sqlDivs.length]=getObjectFromID("sqlstatement");
-        
+
                 var sqlLinks = new Array();
                 sqlLinks[sqlLinks.length]=sqlbttn;
-        
+
                 var sqlAccordion = new fx.Accordion(sqlLinks, sqlDivs, {opacity: true, duration:250, onComplete:function(){switchSqlButtons()}});
         }
@@ -88 +88 @@
                 }
         }
-        
+
         var theID=theTR.id.substr(2,theTR.id.length-1);
 
@@ -98 +98 @@
                 var point1 = null;
                 var point2 = null;
-                
+
                 for(i=0;i<theTable.childNodes.length;i++){
-                        if (theTable.childNodes[i].className){                          
+                        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);
@@ -130 +130 @@
                         }
                 }
-                
+
         } else {
                 // need to find the checkbox that the TR contains
@@ -146 +146 @@
                 }
                 theTR.className=newClass;
-        
+
                 var disabledstatus=(selIDs.length==0);
                 setButtonStatus(disabledstatus);
@@ -158 +158 @@
 
 function chooseOtherCommand(thevalue, thetext, thesource){
-        
+
         if(!thesource.className.match(/Disabled/)){
-                
+
                 switch(thevalue){
                         case "-1":
@@ -168 +168 @@
                                 thediv.style.display = "none";
                                 break;
-                        
+
                         case "-2":
                                 importRecord();
                                 break;
-                        
+
                         default:
                                 var otherField = getObjectFromID("othercommands");
@@ -180 +180 @@
                                 break;
                 }//end switch
-                
+
         }//end if
-        
+
 }
 
@@ -190 +190 @@
                 if(deleteButton.className == "deleteRecordDisabled")
                         return false;
-                
+
                 var howmany=selIDs.length+" selected record";
 
@@ -196 +196 @@
                         howmany+="s"
                 var content="<div>Are you sure you want to "+deletename+" the "+howmany+"?</div>";
-                        content+="<div align=\"right\"><input type=\"button\" class=\"\Buttons\" style=\"width:75px;margin-right:2px;\" value=\"yes\" onclick=\"doDelete()\" /><input type=\"button\" class=\"\Buttons\" style=\"width:75px;\" value=\"no\" onclick=\"closeModal()\" /></div>"  
+                        content+="<div align=\"right\"><input type=\"button\" class=\"\Buttons\" style=\"width:75px;margin-right:2px;\" value=\"yes\" onclick=\"doDelete()\" /><input type=\"button\" class=\"\Buttons\" style=\"width:75px;\" value=\"no\" onclick=\"closeModal()\" /></div>"
                 showModal(content,"Confirm",300) ;
 }
@@ -214 +214 @@
         thedelete.value="delete";
         setSelIDs(thedelete.form);
-        thedelete.form.submit();        
+        thedelete.form.submit();
 }
 
@@ -227 +227 @@
         if(!select.length)
                 var select = getElementsByClassName("needselectDisabled");
-                
+
         if(editButton)
                 editButton.className="editRecord"+((disabledstatus)?"Disabled":"");
-                
+
         if(deleteButton)
                 deleteButton.className = "deleteRecord"+((disabledstatus)?"Disabled":"");
-                        
-        
+
+
         for(i = 0;i < select.length; i++)
                 select[i].className = "needselect"+((disabledstatus)?"Disabled":"");
-        
-        
+
+
         //if(otherCommands) {
         //      otherCommands.className = "otherCommands"+((disabledstatus)?"Disabled":"");
@@ -244 +244 @@
         //      otherDropDown.style.display = "none";
         //}
-                
+
         if(relationship) relationship.disabled=disabledstatus;
 }
@@ -260 +260 @@
 function editThis(therow){
         var connector;
-        
+
         if(therow){
                 // the row is used for doubleclicking
@@ -275 +275 @@
                 if(typeof xtraParamaters != "undefined")
                         editFile+="&"+(xtraParamaters);
-                
+
                 document.location=editFile;
         }
@@ -308 +308 @@
         if(!allornone) newClass="qh";
         selIDs= new Array();
-        
+
         var tbody = getObjectFromID("resultTbody");
         for(var i=0;i<tbody.childNodes.length;i++){
@@ -348 +348 @@
         var otherDD;
         var thediv = getObjectFromID(whatDD);
-        
-        if(whatDD == "searchSelectionDropDown")         
+
+        if(whatDD == "searchSelectionDropDown")
                 otherDD = getObjectFromID("otherDropDown");
         else
                 otherDD = getObjectFromID("searchSelectionDropDown");
-        
+
         if(thediv.style.display == "none")
                 thediv.style.display = "block";
@@ -364 +364 @@
 
 
-function perfromToSelection(option){            
+function perfromToSelection(option){
 
         var thereset=getObjectFromID("reset");
@@ -393 +393 @@
                 break;
         }
-        thediv.style.display = "none";          
-        
+        thediv.style.display = "none";
+
 }
 
@@ -402 +402 @@
         if(taba.parentNode.className=="tabsSel")
                 return false;
-                
+
         var basicTab=getObjectFromID("basicSearchT");
         var advancedTab=getObjectFromID("advancedSearchT");
@@ -408 +408 @@
         var saveTab=getObjectFromID("saveSearchT");
         var sortTab=getObjectFromID("advancedSortT");
-        
+
         basicTab.className="";
         if(advancedTab) advancedTab.className="";
@@ -414 +414 @@
         saveTab.className="";
         sortTab.className="";
-        
+
         taba.parentNode.className="tabsSel";
 
@@ -432 +432 @@
         switch(taba.parentNode.id){
                 case "basicSearchT":
-                        basicTab.style.display="block";                 
+                        basicTab.style.display="block";
                 break;
                 case "advancedSearchT":
@@ -438 +438 @@
                                 var tabledefid=getObjectFromID("tabledefid");
                                 advancedTab.innerHTML="<img src=\""+base+"common/image/spinner.gif\" alt=\"0\" width=\"16\" height=\"16\" align=\"absmiddle\"> <strong>Loading...</strong>";
-                                advancedTab.style.display="block";                      
+                                advancedTab.style.display="block";
                                 theURL=base+"advancedsearch.php?cmd=show&base="+encodeURIComponent(base)+"&tid="+tabledefid.value;
                                 loadXMLDoc(theURL,null,false);
-                                advancedTab.innerHTML=req.responseText;                                         
+                                advancedTab.innerHTML=req.responseText;
                                 ASParams= [1];
                         } else
@@ -450 +450 @@
                                 var tabledefid=getObjectFromID("tabledefid");
                                 loadTab.innerHTML="<img src=\""+base+"common/image/spinner.gif\" alt=\"0\" width=\"16\" height=\"16\" align=\"absmiddle\"> <strong>Loading...</strong>";
-                                loadTab.style.display="block";                  
-                                theURL=base+"loadsearch.php?cmd=show&base="+encodeURIComponent(base)+"&tid="+tabledefid.value;
+                                loadTab.style.display="block";
+                                theURL=base+"loadsearch.php?cmd=show&base="+encodeURIComponent(base)+"&tid="+encodeURIComponent(tabledefid.value);
                                 loadXMLDoc(theURL,null,false);
                                 loadTab.innerHTML=req.responseText;
@@ -460 +460 @@
                         var searchbutton=getObjectFromID("saveSearch");
                         var searchtext=getObjectFromID("saveSearchName");
-                        var searchstatus=getObjectFromID("saveSearchReults");   
+                        var searchstatus=getObjectFromID("saveSearchReults");
                         if(searchstatus.innerHTML!=""){
                                 searchbutton.disabled=true;
@@ -467 +467 @@
                                 searchstatus.innerHTML="";
                         }
-                        saveTab.style.display="block";                  
+                        saveTab.style.display="block";
                 break;
                 case "advancedSortT":
@@ -473 +473 @@
                                 var tabledefid=getObjectFromID("tabledefid");
                                 sortTab.innerHTML="<img src=\""+base+"common/image/spinner.gif\" alt=\"0\" width=\"16\" height=\"16\" align=\"absmiddle\"> <strong>Loading...</strong>";
-                                sortTab.style.display="block";                  
+                                sortTab.style.display="block";
                                 theURL=base+"advancedsort.php?cmd=show&base="+encodeURIComponent(base)+"&tid="+tabledefid.value;
                                 loadXMLDoc(theURL,null,false);
-                                sortTab.innerHTML=req.responseText;                                             
+                                sortTab.innerHTML=req.responseText;
                                 SortParams= [1];
                                 updateSort();
                         } else
-                        sortTab.style.display="block";                  
+                        sortTab.style.display="block";
                 break;
         }
@@ -488 +488 @@
 // Advanced Search Functions ==========================================
 function updateAS(){
-        var tempMinus;  
+        var tempMinus;
         if(ASParams.length>1){
                 tempMinus=getObjectFromID("ASC"+ASParams[0]+"minus")
@@ -511 +511 @@
                 searchButton.disabled=false;
         else
-                searchButton.disabled=true;     
+                searchButton.disabled=true;
         var sqlBox=getObjectFromID("ASSQL");
         sqlBox.value=sqlText;
@@ -521 +521 @@
                 searchButton.disabled=false;
         else
-                searchButton.disabled=true;     
+                searchButton.disabled=true;
 }
 
@@ -533 +533 @@
         var REcriteria = new RegExp("ASC"+ASParams[0],"g")
         tempContent=tempContent.replace(REcriteria,"ASC"+(ASParams[ASParams.length-1]+1))
-                
+
         var newDiv=document.createElement("div");
         newDiv.id="ASC"+(ASParams[ASParams.length-1]+1);
-        newDiv.innerHTML=tempContent;   
-        
+        newDiv.innerHTML=tempContent;
+
         var containerDiv=getObjectFromID("theASCs");
         containerDiv.appendChild(newDiv);
         var tempText=getObjectFromID("ASC"+(ASParams[ASParams.length-1]+1)+"text");
         tempText.value="";
-        
+
         ASParams[ASParams.length]=ASParams[ASParams.length-1]+1;
 }
@@ -549 +549 @@
         if(thebutton.className=="graphicButtons buttonMinusDisabled")
                 return false;
-        
+
         var theDiv=thebutton.parentNode;
-                
+
         var containerDiv=getObjectFromID("theASCs");
         containerDiv.removeChild(theDiv);
@@ -573 +573 @@
         var realSQL=getObjectFromID("advancedsearch");
         realSQL.value=tempsqlBox.value;
-        thebutton.form.submit();        
+        thebutton.form.submit();
 }
 
@@ -604 +604 @@
                         deletebutton.disabled=true;
                 reultbox.innerHTML="";
-        }       
+        }
 }
 
 function LSRunSearch(){
-        var sqlbox=getObjectFromID("LSSQL");    
+        var sqlbox=getObjectFromID("LSSQL");
         var advancedsearch=getObjectFromID("advancedsearch");
         advancedsearch.value=sqlbox.value
@@ -624 +624 @@
                 theselect.options[theselect.selectedIndex]=null;
                 if(theselect.options.length==1){
-                        theselect.options[0].text="No Saved Searches";                  
+                        theselect.options[0].text="No Saved Searches";
                         theselect.disabled=true;
                 }
                 theselect.selectedIndex=0;
                 LSsearchSelect(theselect,base);
-        
+
         }
 }
@@ -641 +641 @@
         else
                 searchbutton.disabled=false;
-} 
+}
 
 function saveMySearch(base){
         var searchtext=getObjectFromID("saveSearchName");
-        var searchstatus=getObjectFromID("saveSearchReults");   
+        var searchstatus=getObjectFromID("saveSearchReults");
         var tabledefid=getObjectFromID("tabledefid");
-        
+
         searchstatus.style.display="block";
         searchstatus.className="";
@@ -654 +654 @@
         loadXMLDoc(theURL,null,false);
         searchstatus.innerHTML=req.responseText;
-        searchstatus.className="standout";      
-        
+        searchstatus.className="standout";
+
         loadTab=getObjectFromID("loadSearchTab");
-        loadTab.innerHTML="";   
+        loadTab.innerHTML="";
 }
 
 // Advanced Sort Functions ==========================================
 function sortEnableButtons(thetextarea){
-        
+
         var buttonRunSort=getObjectFromID("sortRunSort");
         var buttonSaveSort=getObjectFromID("sortSaveSort");
@@ -672 +672 @@
         }
         else{
-                buttonRunSort.disabled=true;            
+                buttonRunSort.disabled=true;
                 buttonSaveSort.disabled=true;
                 buttonClearSort.disabled=true;
@@ -679 +679 @@
 
 function clearSort(){
-        var sqlBox=getObjectFromID("sortSQL");  
+        var sqlBox=getObjectFromID("sortSQL");
         sqlBox.value="";
         var containerDiv=getObjectFromID("theSorts");
@@ -687 +687 @@
                 tempbutton=getObjectFromID("Sort"+SortParams[i]+"Minus");
                 sortRemoveLine(tempbutton);
-        }       
+        }
         containerDiv.style.display="block";
 }
 
 function updateSort(){
-        var tempMinus;  
+        var tempMinus;
         if(SortParams.length>1){
                 tempMinus=getObjectFromID("Sort"+SortParams[0]+"Minus")
@@ -731 +731 @@
         tempDown.className="graphicButtons buttonDown";
         tempUp.className="graphicButtons buttonUpDisabled";
-                
+
         var newDiv=document.createElement("div");
         newDiv.id="Sort"+(SortParams[SortParams.length-1]+1);
-        newDiv.innerHTML=tempContent;   
-        
+        newDiv.innerHTML=tempContent;
+
         var containerDiv=getObjectFromID("theSorts");
         containerDiv.appendChild(newDiv);
-        
+
         SortParams[SortParams.length]=SortParams[SortParams.length-1]+1;
         for(var i=1;i<SortParams.length-1;i++){
@@ -750 +750 @@
         if(thebutton.className=="graphicButtons buttonMinusDisabled")
                 return false;
-        
+
         var theDiv=thebutton.parentNode;
-                
+
         var containerDiv=getObjectFromID("theSorts");
         containerDiv.removeChild(theDiv);
@@ -782 +782 @@
         else
                 direction=1;
-        
+
         var theDiv=thebutton.parentNode;
         var theid=theDiv.id.replace(/Sort/g,"");
-        
+
         var containerDiv=getObjectFromID("theSorts");
         containerDiv.removeChild(theDiv);
-        
+
         for(var i=0;i<SortParams.length;i++)
                 if(SortParams[i]==theid){
@@ -799 +799 @@
         else
                 moveto=movetopos;
-                
+
         var movetodiv=getObjectFromID("Sort"+SortParams[moveto]);
         containerDiv.insertBefore(theDiv,movetodiv);
@@ -805 +805 @@
         SortParams[movetopos]=theid;
         updateSort();
-        
+
         var tempUp=getObjectFromID("Sort"+SortParams[0]+"Up");
         var tempDown=getObjectFromID("Sort"+SortParams[0]+"Down");
         tempUp.className="graphicButtons buttonUpDisabled";
         tempDown.className="graphicButtons buttonDown";
-        
+
         for(var i=1;i<SortParams.length-1;i++){
                 tempUp=getObjectFromID("Sort"+SortParams[i]+"Up");
@@ -817 +817 @@
                 tempDown.className="graphicButtons buttonDown";
         }
-        
+
         tempUp=getObjectFromID("Sort"+SortParams[SortParams.length-1]+"Up");
         tempDown=getObjectFromID("Sort"+SortParams[SortParams.length-1]+"Down");
         tempUp.className="graphicButtons buttonUp";
         tempDown.className="graphicButtons buttonDownDisabled";
-        
+
 }
 
@@ -898 +898 @@
                 loadXMLDoc(theURL,null,false);
                 modalContent.innerHTML=req.responseText;
-        } else 
+        } else
                 modalContent.innerHTML=req.responseText;
 }
 
 function sortSavedLoad(base){
-        var theselect=getObjectFromID("sortSavedList"); 
+        var theselect=getObjectFromID("sortSavedList");
         var modalContent=getObjectFromID("modalContent");
         var theURL=base+"advancedsort.php?cmd=loadSaved&id="+theselect.value;
@@ -910 +910 @@
         loadXMLDoc(theURL,null,false);
         var sortSQL=getObjectFromID("sortSQL");
-        sortSQL.value=req.responseText; 
+        sortSQL.value=req.responseText;
         var containerDiv=getObjectFromID("theSorts");
         containerDiv.style.display="none";