"
var gridPaging = "
"
////var gridPaging = "
"
//The old paging
//var gridPaging = "
"
//Information
var gridInfo = "
";
/*****************************
//Output
*****************************/
//Build display according to output mode
output = gridHeader + gridSearch + gridAdvancedSearch + gridColumnToggler /*+ gridFilter*/ + "
" + obj + "
" + gridAutoFilter + gridPaging + gridInfo;
//alert (gridSearch);
}
else {
//This should be a grid search eventually if the non load mode is still applicable.
//output = "Load data was false. No load done.";
output = gridHeader + gridSearch + gridAdvancedSearch;
}
//if (!(isModal)){
output = "
" + output + "
";
//}
//alert(output);
document.getElementById(div).innerHTML = output;
//Post load functions
if (searchMode == "advanced") {
//Add first advanced search row
fillAdvancedSearchRows(gridID,isModal);
}
else if (searchMode == "standard"){
//Set focus to search box
setSearchFocus(standardSearchInputName + gridID.toString());
}
else {
alert("Error : Invalid search mode was requested.");
}
}
function setSearchFocus(elementid){
if (document.getElementById(elementid)){
try {
document.getElementById(elementid).focus();
document.getElementById(elementid).select();
}
catch (ex) {
//alert ("Error occured setting focus on \"" + elementid + "\":\n" + ex.message);
}
}
}
//////////////////////////////////////////////////////////////////////////////////////////////
//SEARCHING/FILTERING/PAGING FUNCTIONS
//////////////////////////////////////////////////////////////////////////////////////////////
/*
This function is used to check when a search should be executed.
Either on click of the search button or on enter press inside the input box.
*/
function checkSearch(gridID,isModal,evt){
var display = false;
if (evt) {
if (isEnterKey(evt)) {
display = true;
}
}
else {
display = true;
}
if (display){
if (isModal){
//If there has been a filter, clear it for the grid
if (array_of_gridfilterindices[gridID]){
array_of_gridfilterindices[gridID] = [];
}
searchGrid(gridID,isModal);
}
else {
showLoading();
//If there has been a filter, clear it for the grid
if (array_of_gridfilterindices[gridID]){
array_of_gridfilterindices[gridID] = [];
}
window.setTimeout(function(){
searchGrid(gridID,isModal);
},0);
}
}
}
/*
The database driven search function
*/
function searchGrid(gridID,isModal){
if (!(array_of_searchstoppers[gridID])) {
//Disable multi clicked searching for this grid;
array_of_searchstoppers[gridID] = true;
//Define outputs
var searchValue = "";
//Process searchmode
var searchMode = array_of_gridsearchmodestatus[gridID];
var searchfix = /('|"|\||;)+/g;
if (searchMode == "standard"){
if (document.getElementById(standardSearchInputName + gridID.toString())) {
searchValue = document.getElementById(standardSearchInputName + gridID.toString()).value;
//Replace volatile characters with search string seperators
searchValue = searchValue.replace(searchfix," ");
array_of_gridlaststandardsearchstring[gridID] = searchValue;
array_of_gridlastsearchmodestatus[gridID] = "standard";
}
}
else if (searchMode == "advanced"){
//A function to build a data string of all advanced search fields
searchValue = getAdvancedSearchData(gridID,searchfix);
if (searchValue) {
array_of_gridlastadvancedsearchstring[gridID] = searchValue;
array_of_gridlastsearchmodestatus[gridID] = "advanced";
}
else {
hideLoading();
array_of_searchstoppers[gridID] = false;
return;
}
}
else {
alert("Error : Invalid search mode was requested.");
}
searchMode = null;
//Load grid with needed data
loadGrid(gridID,array_of_gridurls[gridID],true,isModal,1);
searchValue = null;
}
else {
//Search aborted, already busy.
}
}
/*
Function to add current data to the data store for later use and reference in filtering
*/
function fetchData(gridID){
//If no data exists force load
var overrideLoad = false;
if (!(array_of_gridfilterdata[gridID])) {
overrideLoad = true;
}
if (overrideLoad){
loadNewData(gridID);
}
return array_of_gridfilterdata[gridID];
}
function loadNewData(gridID){
array_of_gridfilterdata[gridID] = extractData(gridID);
}
//Function to extract data from a grid object
function extractData(gridID){
var obj = array_of_grids[gridID];
var returnData = [];
if (obj) {
//var columnIndex = obj.getColumnProperty("count");
//var rowIndex = obj.getRowProperty("count");
var columnCount = obj.getColumnCount();
var rowCount = obj.getRowCount();
//Pull data displayed in grid into array
for (var row = 0; row < rowCount; row++){
var rowArray = [];
for (var column = 0; column < columnCount; column++){
//rowArray.push(obj.getDataProperty("text",row,column));
//rowArray.push(obj.getCellText(column,row));
rowArray.push(obj.getCellText(array_of_colorders[gridID][column],row));
}
returnData.push(rowArray);
}
}
return returnData;
}
/*
This function is used to check when a search should be executed.
Either on click of the search button or on enter press inside the input box.
*/
/*
function checkFilter(objname,source,evt){
var filter = false;
if (evt) {
if (isEnterKey(evt)) {
filter = true;
}
}
if (filter){
showLoading();
window.setTimeout(function(){
filterGrid(objname,source)
},0);
}
}
*/
/*
The filter function
*/
/*
function filterGrid(objname,source){
var gid = getGrid(objname,true);
var obj = array_of_grids[gid];
if (obj){
showLoading();
var myData = fetchData(gid);
var columnNames = array_of_columnnames[gid];
var rowidValues = [];
var searchvaluesaver = [];
var res = 0;
var remover = /\^|\||\\/g;
var dosearch = false;
for (var i = 0; i < columnNames.length; i++){
//Check if any textbox is non-empty
if (document.getElementById(columnNames[i] + "_filter").value.toLowerCase().replace(remover,"") != ""){
dosearch = true;
}
//Save the search values in array
searchvaluesaver.push(document.getElementById(columnNames[i] + "_filter").value);
}
//If non-empty filter
if (dosearch){
try {
for (var x = 0; x < myData.length; x++){
var addrow = true;
//Check all columns to see if the row matches criteria
for (var i = 0; i < columnNames.length; i++){
//Set up search text from search value
var searchtext = searchvaluesaver[i].toLowerCase().replace(remover,"");
//If blank search for this column skip it
if (!(searchtext == "")){
//Set up regex
var checker = new RegExp(searchtext);
//If a single criteria is not matched, don't display row.
if (!(myData[x][i].toLowerCase().match(checker))){
addrow = false;
break;
}
}
}
//Add row to display list if needed
if (addrow) {
rowidValues.push(x);
res++;
}
}
}
catch (ex) {
alert("Error was caught during a filter :\n" + ex.message);
}
}
//Else show everything
else {
for (var x = 0; x < myData.length; x++){
rowidValues.push(x);
res++;
}
}
//Reset scroll
obj.setScrollLeft(0);
obj.setScrollTop(0);
//Reset sorting
obj.sort("");
//Load the correct rows found by filter
obj.setRowCount(res);
obj.setRowIndices(rowidValues);
array_of_gridfilterindices[gid] = rowidValues;
}
}
*/
/********
NEW FILTER
***************************/
/*
The new filter function
filterMode : "matchall" use negative filtering on all filer values(look for reasons not to include the row)
"matchany" use positive filtering on a single text value (look for reasons to include the row)
"clear" does what it says on the box
customFilterText : text used in "matchany" mode
*/
function filterGridNew(gridID,filterMode,customFilterText){
var obj = array_of_grids[gridID];
if (obj){
showLoading();
var myData = fetchData(gridID);
var rowidValues = [];
var res = 0;
var searchvalues = array_of_gridfiltervalues[gridID];
var autosearchvalues = array_of_gridautofiltervalues[gridID];
var clearFilterOverride = false;
var dosearch = null;
var initialRowAddValue = null;
var onMatchCheckRowAddValue = null;
var removerForRegEx = /\^|\|/g;
var selectedColumn = getVisibleIDOfColumn(gridID,obj.getSortColumn());
var doReSort = false;
if (filterMode == "matchall"){
dosearch = false;
//Switch to positive searching
initialRowAddValue = true;
onMatchCheckRowAddValue = false;
}
else if (filterMode == "matchany") {
dosearch = true;
doReSort = true;
//Switch to positive searching
initialRowAddValue = false;
onMatchCheckRowAddValue = true;
//clearFilterInputs(gridID);
}
else if (filterMode == "clear"){
clearFilterOverride = true;
}
else {
alert("Invalid filter mode requsted.");
return;
}
if (!clearFilterOverride){
//Check/Manipulate text filter values
for (var i = 0; i < searchvalues.length; i++){
if (filterMode == "matchall"){
clearAutoFilterValues(gridID);
//Get the filter input values
try {
searchvalues[i] = obj.getHeaderTemplate(i,1).getControlText();
}
catch (ex) {
alert(ex.message);
}
//Check if any flterbox is non-empty
if (searchvalues[i] != "" || autosearchvalues[i] != ""){
dosearch = true;
}
}
if (filterMode == "matchany"){
clearFilterValues(gridID);
clearFilterInputs(gridID);
if (selectedColumn == -1 || selectedColumn == i){
if (customFilterText == "#") {
autosearchvalues[i] = "^\\d+";
}
else if (customFilterText != ""){
autosearchvalues[i] = "^" + customFilterText;
}
else {
alert("Blank value for auto filter found.");
return;
}
}
else {
autosearchvalues[i] = "^^garbage not to match^^";
}
}
}
}
//If non-empty filter and not clearing
//alert("regular : " + searchvalues);
//alert("auto :" + autosearchvalues);
//alert(myData);
if (dosearch && !(clearFilterOverride)){
try {
for (var x = 0; x < myData.length; x++){
var addrow = initialRowAddValue;
//Check all columns to see if the row matches criteria
for (var i = 0; i < myData[x].length; i++){
//Set up search text from search value
var searchtext = searchvalues[array_of_colorders[gridID][i]];
//Set up auto search text from auto search value
var autosearchtext = autosearchvalues[array_of_colorders[gridID][i]];
//If blank search for this column skip it
if (autosearchtext != "" || searchtext != ""){
//Create the search text
var inputtext = "";
//Case 1 : No autofilter applied present
if (filterMode == "matchall"){
inputtext = searchtext;
}
//Case 2 : No manual filter applied
else if (filterMode == "matchany"){
inputtext = autosearchtext;
}
//Case 3 : Both applied - No column for autofilter selected or column selected and it is current column
/*else if(selectedColumn == -1 || selectedColumn == i){
inputtext = autosearchtext + "(.)*" + searchtext
}
//Case 4 : Both applied - Column selected for autofilter selected, but not current column.
else if(selectedColumn != i){
inputtext = autosearchtext + "|" + searchtext
}*/
//Case 5 : ??
else {
//Unknown state. Somethings broken.
alert("unknown filter text state");
break;
}
//alert(inputtext);
checker = new RegExp(inputtext,"ig");
if (myData[x][i]){
//alert("search : " + inputtext + "\ndata : ||" + myData[x][i] + "||\nfiltermode : ||" + filterMode + "||\nmatch : ||" + myData[x][i].toLowerCase().match(checker) + "||");
if (/*i != 0 &&*/ ((filterMode == "matchany" && myData[x][i].toLowerCase().match(checker)) || (filterMode == "matchall" && !(myData[x][i].toLowerCase().match(checker))))){
addrow = onMatchCheckRowAddValue;
//alert(addrow + "for col : " + i + " and row : " + x);
break;
}
}
}
else {
//alert("blank filter values found in col :" + i);
}
}
//Add row to display list if needed
if (addrow) {
rowidValues.push(x);
res++;
}
}
}
catch (ex) {
alert("Error was caught during a filter :\n" + ex.message);
}
}
//Else show everything (clear filter)
else {
//alert("clearing");
//Add all rows
for (var x = 0; x < myData.length; x++){
rowidValues.push(x);
res++;
}
//Clear all filter inputs
clearFilterInputs(gridID);
//Clear all filter text values
clearFilterValues(gridID);
//if (clearFilterOverride) {
//Clear all auto filter text values
clearAutoFilterValues(gridID);
//alert("Clearing auto filter");
//}
}
//Reset scroll
obj.setScrollLeft(0);
obj.setScrollTop(0);
//Reset sorting
if (!(doReSort)){
obj.clearSortModel();
}//Load the correct rows found by filter
//obj.clearRowModel();
obj.setRowCount(res);
obj.setRowIndices(rowidValues);
array_of_gridfilterindices[gridID] = rowidValues;
//Restore sorting
if (doReSort){
resortGrid(gridID);
}
}
}
function resortGrid(gridID){
var obj = array_of_grids[gridID];
var sortColumn = obj.getSortColumn();
if(sortColumn != -1){
//alert("resorting")
obj.sort(sortColumn,obj.getSortDirection(sortColumn));
}
}
function clearFilterInputs(gridID){
var obj = array_of_grids[gridID];
//Clear filter text values
for (var l = 0; l < array_of_gridfiltervalues[gridID].length;l++){
try {
obj.getHeaderTemplate(l,1).setControlText("");
}
catch (ex) {
alert(ex.message);
}
}
}
function clearFilterValues(gridID){
//Clear filter text values
var length = array_of_gridfiltervalues[gridID].length;
array_of_gridfiltervalues[gridID] = new Array();
for (var k = 0;k < length;k++){array_of_gridfiltervalues[gridID].push("")}
}
function clearAutoFilterValues(gridID){
//Clear filter text values
var length = array_of_gridautofiltervalues[gridID].length;
array_of_gridautofiltervalues[gridID] = new Array();
for (var k = 0;k < length;k++){array_of_gridautofiltervalues[gridID].push("")}
}
/*
Paging function using custom extended properties in Expert.Text.Table for paging info.
*/
function changePage(gridID,direction,specificPage,isModal,evt){
var change = true;
if (evt) {
if (isEnterKey(evt)) {
//Nothing
}
else {
change = false;
}
}
//Fetch paging info
var currentpage,maxpage,recordsetsize;
var table = array_of_gridtables[gridID];
if (table){
currentpage = table.getProperty("currentPage");
maxpage = table.getProperty("maxPage");
recordsetsize = table.getProperty("rowLimit");
}
//Else just fail paging call.
else {
alert("Error : Paging information was not found in the Table object. Paging was aborted.");
return;
}
//If successful; Load object and process page change.
var obj = array_of_grids[gridID];
if (obj && change) {
if (!(specificPage)) {
if (direction == "next") {
if (currentpage < maxpage) {
currentpage += 1;
}
else {
return;
}
}
else {
if (currentpage != 1){
currentpage -= 1;
}
else {
return;
}
}
}
else {
if (isInteger(specificPage)) {
if ((specificPage <= maxpage) && (specificPage >= 1)) {
currentpage = specificPage;
}
else {
alert("The specified page value is out of range.");
return;
}
}
else {
alert("A non-integer page value was supplied.");
return;
}
}
//Ensure loading is displayed
showLoading();
window.setTimeout(function(){
loadGrid(gridID,array_of_gridurls[gridID],true,isModal,currentpage);
},0);
}
}
![](\"images/right_click_arrow.gif\"){kind=icon}
![](\"images/right_click_line.gif\")
![](\"images/kumon_form_arrow_1.gif\"){kind=icon}
![](\"images/but_left.gif\")
![](\"images/but_right.gif\")