Button_Items_Search.onClick=function(){
var searchText='';
var found=false;
var count=0;
var searchText = [null,null,null];
if(Input_Items_Search_UPC.getControlText().length>1) {
searchText[0]= new RegExp(Input_Items_Search_UPC.getControlText().replace("\"","''"),"i");
}
if(Input_Items_Search_SKU.getControlText().length>1) {
searchText[1]= new RegExp(Input_Items_Search_SKU.getControlText().replace("\"","''"),"i");
}
if(Input_Items_Search_Description.getControlText().length>1) {
searchText[2]= new RegExp(Input_Items_Search_Description.getControlText().replace("\"","''"),"i");
}
for(var i=0; i<Grid_Items_Items.getRowCount(); i++) {
for(var j=0; j<searchText.length; j++) {
if(searchText[j]!=null) {
var tmp=Grid_Items_Items.getCellData(j,i);
if(searchText[j].test(tmp)) {
Grid_Items_Items.getTemplate("row", i).setStyle("color", "white");
Grid_Items_Items.getTemplate("row", i).setStyle("background", "blue");
found=true;
count++;
}
}
}
}
if(!found) alert('Not Found');
else alert('Found '+count+' entries');
}
Button_Items_Search.onClick=function(){
var count;
var searchText = new Array();
var matchingRows = new Array();
var currentSearchData = Data_Items_Items;
if(Input_Items_Search_UPC.getControlText().length>0) {
searchText.push([0,Input_Items_Search_UPC.getControlText().replace("\"","''")]);
}
if(Input_Items_Search_SKU.getControlText().length>0) {
searchText.push([1,Input_Items_Search_SKU.getControlText().replace("\"","''")]);
}
if(Input_Items_Search_Description.getControlText().length>0) {
searchText.push([2,Input_Items_Search_Description.getControlText().replace("\"","''")]);
}
for(var j=0; j<searchText.length; j++) {
var nextSearchData = new Array();
count=0;
for(var i=0; i<currentSearchData.length; i++) {
var searchTerm= new RegExp(searchText[j][1],"i");
var tmp=currentSearchData[i][searchText[j][0]];
if(searchTerm.test(tmp)) {
nextSearchData.push(currentSearchData[i]);
count++;
}
}
currentSearchData = nextSearchData;
}
if(count==0) {
Grid_Items_Items.setCellData(Data_Items_Items);
Grid_Items_Items.setRowCount(Data_Items_Items.length);
Grid_Items_Items.setRowIndices(getAllRowIndices(Data_Items_Items));
} else {
Grid_Items_Items.setCellData(currentSearchData);
Grid_Items_Items.setRowCount(currentSearchData.length);
Grid_Items_Items.setRowIndices(getAllRowIndices(currentSearchData));
}
Grid_Items_Items.refresh();
Label_Data_Items_Items_Value.setControlText(Grid_Items_Items.getRowCount());
}
This topic is archived.