neoTable
SinLios
https://visualneo.com
info@sinlios.com
SinLios Soluciones Digitales 2021
Version: 2021.12.16
Original script from:
https://bootstrap-table-docs3.wenzhixin.net.cn/home/
https://vitalets.github.io/x-editable/
Basado en:
https://bootstrap-table.wenzhixin.net.cn/home/
Last version:
16/12/2021
neoTable-icon20.png
neoTable-icon32.png
C:\Users\sinli\OneDrive\CloudStation\visualneo\VisualNeoWeb\Plugins\bootstrap-table\neotable-new.nabp
yes
function neoTableSetMultiSelectColumn(objId,columnNumber,idField){
columnNumber--;
columnsObj=objId+"Columns";
if(typeof($App[columnsObj])=="undefined"){
$App[columnsObj] = new Array();
};
if(typeof($App.NAB[objId])=="undefined"){
$App.NAB[objId]=new Object();
$App.NAB[objId].idField=idField;
}
$App[columnsObj][columnNumber]=({
field: 'select',
title: '',
sortable: false,
radio: false,
checkbox: true,
editable: false
});
};
function neoTableSetSelectColumn(objId,columnNumber,idField){
columnNumber--;
columnsObj=objId+"Columns";
if(typeof($App[columnsObj])=="undefined"){
$App[columnsObj] = new Array();
};
if(typeof($App.NAB[objId])=="undefined"){
$App.NAB[objId]=new Object();
$App.NAB[objId].idField=idField;
}
$App[columnsObj][columnNumber]=({
field: 'select',
title: '',
sortable: false,
radio: true,
editable: false
});
};
function neoTableResetColumns(objId){
columnsObj=objId+"Columns";
$App[columnsObj] = new Array();
};
function neoTableHideContent(objId){
hSize=parseInt($("#"+objId).css("height"))-125;
hSize=hSize+"px";
$("#"+objId+"neoTable > tbody").css("display","none");
$("#"+objId+"neoTable > thead").css("display","none");
$("#"+objId+"neoTable").css("height",hSize);
};
function neoTableShowContent(objId){
$("#"+objId+"neoTable > tbody").css("display","");
$("#"+objId+"neoTable > thead").css("display","");
$("#"+objId+"neoTable").css("height","");
};
function neoTableSetColumn(objId,columnNumber,dataField,dataName,dataWidth,dataSortable,dataEditable,dataSearchable,dataFormatter){
columnNumber--;
columnsObj=objId+"Columns";
if(typeof($App[columnsObj])=="undefined"){
$App[columnsObj] = new Array();
};
if(dataEditable){
$App[columnsObj][columnNumber]=({
field: dataField,
title: dataName,
sortable: dataSortable,
searchable: dataSearchable,
width:dataWidth,
editable: $App[columnsEditObj][columnNumber],
formatter: ""
});
}else{
$App[columnsObj][columnNumber]=({
field: dataField,
title: dataName,
sortable: dataSortable,
width:dataWidth,
searchable: dataSearchable,
editable: false,
formatter: dataFormatter
});
}
};
function neoTableConfigDB(objId,dbAlias,tableName,idField){
if(typeof($App.NAB[objId])=="undefined"){
$App.NAB[objId]=new Object();
}
$App.NAB[objId].database=dbAlias;
$App.NAB[objId].tableName=tableName;
$App.NAB[objId].idField=idField;
};
function neoTableCheckDB(objId){
if(typeof($App.NAB[objId])=="undefined"){
$App.NAB[objId]=new Object();
$App.NAB[objId].database="";
$App.NAB[objId].tableName="";
$App.NAB[objId].idField="";
}
};
function neoTableEditColumnAsText(objId,columnNumber,editorMode,placement,editorTitle,placeHolder,escapeHTML,validateFunction,sendToServer,callbackFn){
columnNumber--;
columnsEditObj=objId+"EditCols";
if(typeof($App[columnsEditObj])=="undefined"){
$App[columnsEditObj] = new Array();
};
if(sendToServer){
serverURL=$App.NAB.NeoPhpPath;
}else{
serverURL="";
};
neoTableCheckDB(objId);
$App[columnsEditObj][columnNumber]=({
type: 'text',
mode: editorMode,
url: serverURL,
emptytext: '----',
placement: placement,
title: editorTitle,
pk: $App.neoTableRow,
params:{
database: $App.NAB[objId].database,
table: $App.NAB[objId].tableName,
idfield: $App.NAB[objId].idField,
funcname: 'neotableupdate'
},
placeholder: placeHolder,
escape: escapeHTML,
validate: validateFunction,
success:callbackFn
});
};
function neoTableEditColumnAsHTML5Input(objId,html5Type,columnNumber,editorMode,placement,editorTitle,placeHolder,escapeHTML,validateFunction,sendToServer,callbackFn){
columnNumber--;
columnsEditObj=objId+"EditCols";
if(typeof($App[columnsEditObj])=="undefined"){
$App[columnsEditObj] = new Array();
};
if(sendToServer){
serverURL=$App.NAB.NeoPhpPath;
}else{
serverURL="";
};
neoTableCheckDB(objId);
$App[columnsEditObj][columnNumber]=({
type: html5Type,
mode: editorMode,
url: serverURL,
emptytext: '----',
placement: placement,
title: editorTitle,
pk: $App.neoTableRow,
params:{
database: $App.NAB[objId].database,
table: $App.NAB[objId].tableName,
idfield: $App.NAB[objId].idField,
funcname: 'neotableupdate'
},
placeholder: placeHolder,
escape: escapeHTML,
validate: validateFunction,
success:callbackFn
});
};
function neoTableEditColumnAsDate(objId,columnNumber,placement,editorTitle,format,viewFormat,weekFirstDay,language,validateFunction,sendToServer,callbackFn){
columnNumber--;
columnsEditObj=objId+"EditCols";
if(typeof($App[columnsEditObj])=="undefined"){
$App[columnsEditObj] = new Array();
};
if(sendToServer){
serverURL=$App.NAB.NeoPhpPath;
}else{
serverURL="";
};
if(weekFirstDay=="Sunday"){
weekFirstDayNumber=0;
}else{
weekFirstDayNumber=1
}
neoTableCheckDB(objId);
$App[columnsEditObj][columnNumber]=({
type: 'date',
format: format,
viewformat: viewFormat,
mode: 'popup',
emptytext: '----',
url: serverURL,
placement: placement,
title: editorTitle,
pk: $App.neoTableRow,
params:{
database: $App.NAB[objId].database,
table: $App.NAB[objId].tableName,
idfield: $App.NAB[objId].idField,
funcname: 'neotableupdate'
},
datepicker:{
language: language,
weekStart: weekFirstDayNumber
},
escape: true,
validate: validateFunction,
success:callbackFn
});
};
function neoTableEditColumnAsTextArea(objId,columnNumber,editorMode,placement,editorTitle,placeHolder,escapeHTML,validateFunction,sendToServer,callbackFn){
columnNumber--;
columnsEditObj=objId+"EditCols";
if(typeof($App[columnsEditObj])=="undefined"){
$App[columnsEditObj] = new Array();
};
if(sendToServer){
serverURL=$App.NAB.NeoPhpPath;
}else{
serverURL="";
};
$App[columnsEditObj][columnNumber]=({
type: 'textarea',
mode: editorMode,
url: serverURL,
placement: placement,
emptytext: '----',
title: editorTitle,
pk: $App.neoTableRow,
params:{
database: $App.NAB[objId].database,
table: $App.NAB[objId].tableName,
idfield: $App.NAB[objId].idField,
funcname: 'neotableupdate'
},
rows:4,
placeholder: placeHolder,
escape: escapeHTML,
validate: validateFunction,
success:callbackFn
});
};
function neoTableEditColumnAsSelect(objId,columnNumber,editorMode,placement,editorTitle,selectData,validateFunction,sendToServer,callbackFn){
columnNumber--;
columnsEditObj=objId+"EditCols";
if(typeof($App[columnsEditObj])=="undefined"){
$App[columnsEditObj] = new Array();
};
if(sendToServer){
serverURL=$App.NAB.NeoPhpPath;
}else{
serverURL="";
};
var dataArray = selectData.split("\n");
$App[columnsEditObj][columnNumber]=({
type: 'select',
mode: editorMode,
url: serverURL,
emptytext: '----',
placement: placement,
title: editorTitle,
pk: $App.neoTableRow,
params:{
database: $App.NAB[objId].database,
table: $App.NAB[objId].tableName,
idfield: $App.NAB[objId].idField,
funcname: 'neotableupdate'
},
source: dataArray,
validate: validateFunction,
success:callbackFn
});
};
function neoTableEditColumnAsCheckList(objId,columnNumber,editorMode,placement,editorTitle,selectData,validateFunction,sendToServer,callbackFn){
columnNumber--;
columnsEditObj=objId+"EditCols";
if(typeof($App[columnsEditObj])=="undefined"){
$App[columnsEditObj] = new Array();
};
if(sendToServer){
serverURL=$App.NAB.NeoPhpPath;
}else{
serverURL="";
};
var dataArray = selectData.split("\n");
$App[columnsEditObj][columnNumber]=({
type: 'checklist',
mode: editorMode,
url: serverURL,
placement: placement,
emptytext: '----',
title: editorTitle,
pk: $App.neoTableRow,
params:{
database: $App.NAB[objId].database,
table: $App.NAB[objId].tableName,
idfield: $App.NAB[objId].idField,
funcname: 'neotableupdate'
},
source: dataArray,
validate: validateFunction,
success:callbackFn
});
};
function neoTableInitTable(objId,language,pagination,viewmode,exportable,searchable,showcolumns,showtoggle,selectable,eventFunc){
singleselect=!selectable;
columnsObj=objId+"Columns";
if(typeof($App[columnsObj])=="undefined"){
alert("You should use neoTableAddColumn first!");
};
if(typeof($App.NAB[objId])=="undefined"){
$App.NAB[objId]=new Object();
$App.NAB[objId].idField="";
};
if(typeof($App.neoTableRow)=="undefined"){
$App.neoTableRow=new Object();
};
if(viewmode=="Card"){
cardview=true;
}else{
cardview=false;
};
subrutinas = angular.element(document.getElementById("ng-view")).scope();
if(language==""){
language="en-EN";
}
if(pagination==0){
paginacion=false;
}else{
paginacion=true;
}
$("#"+objId).html('<table id="'+objId+'neoTable"></table>');
$("#"+objId+"neoTable").bootstrapTable({
pagination: paginacion,
pageSize: pagination,
pageList: [pagination],
locale: language,
clickToSelect: true,
paginationLoop: false,
showRefresh: false,
maintainSelected: true,
cardView:cardview,
checkboxHeader: selectable,
singleSelect: singleselect,
//Primary key
uniqueId: $App.NAB[objId].idField,
idField: $App.NAB[objId].idField,
striped: true,
sortOrder: 'asc',
showColumns: showcolumns,
showToggle: showtoggle,
search: searchable,
showExport: exportable,
columns: $App[columnsObj]
});
$("#"+objId+'neoTable').bootstrapTable({
exportDataType:"all"
});
$("#"+objId+"neoTable").on('click-row.bs.table', function (e, row, $element, field){
$App.neoTableRow=row;
$App.neoTableEvent="click";
$App.neoTableField=field;
eventFunc();
});
$("#"+objId+"neoTable").on('check.bs.table', function (e, row, $element){
$App.neoTableRow=row;
$App.neoTableEvent="check";
eventFunc();
});
$("#"+objId+"neoTable").on('uncheck.bs.table', function (e, row, $element){
$App.neoTableRow=row;
$App.neoTableEvent="uncheck";
eventFunc();
});
$("#"+objId+"neoTable").on('load-error.bs.table', function (e, status, res){
$App.neoTableEvent="loaderror";
eventFunc();
});
$("#"+objId+"neoTable").on('load-success.bs.table', function (e, data){
$App.neoTableEvent="loadsuccess";
eventFunc();
});
$("#"+objId+"neoTable").on('page-change.bs.table', function (e, number, size){
$App.neoTableEvent="pagechange";
$App.neoTablePage=number;
eventFunc();
});
$("#"+objId+"neoTable").on('search.bs.table', function (e, text){
$App.neoTableEvent="search";
$App.neoTableSearch=text;
eventFunc();
});
};
Object.size = function(obj) {
var size = 0, key;
for (key in obj) {
if (obj.hasOwnProperty(key)) size++;
}
return size;
};
function neoTableHideColumn(objId,columnName){
$("#"+objId+"neoTable").bootstrapTable('hideColumn', columnName);
};
function neoTableShowColumn(objId,columnName){
$("#"+objId+"neoTable").bootstrapTable('showColumn', columnName);
};
function neoTableShowAllColumns(objId){
$("#"+objId+"neoTable").bootstrapTable('showAllColumns');
};
function neoTableHideAllColumns(objId){
$("#"+objId+"neoTable").bootstrapTable('hideAllColumns');
};
function neoTableGetAllData(objId){
return $("#"+objId+"neoTable").bootstrapTable('getData');
};
function neoTableGetRowData(objId,rowId){
return $("#"+objId+"neoTable").bootstrapTable('getRowByUniqueId', rowId);
};
function neoTableInsertRow(objId,rowIndex,rowData){
$("#"+objId+"neoTable").bootstrapTable('insertRow',{
index: rowIndex,
row: rowData
});
};
function getSelectedIds(objId){
var ids = $.map($("#"+objId+"neoTable").bootstrapTable('getSelections'), function (row) {
return row[$App.NAB[objId].idField];
});
return ids;
};
function getSelectedId(objId){
var ids = $.map($("#"+objId+"neoTable").bootstrapTable('getSelections'), function (row) {
return row[$App.NAB[objId].idField];
});
return ids[0];
};
function neoTableDeleteSelectedRows(objId){
ids = getSelectedIds(objId);
$("#"+objId+"neoTable").bootstrapTable('remove', {
field: $App.NAB[objId].idField,
values: ids
})
};
function neoTableDeleteRowsByValue(objId, fieldName, theValue){
$("#"+objId+"neoTable").bootstrapTable('remove', {
field: fieldName,
values: theValue
})
};
function neoTableDeleteRowById(objId,rowId){
$("#"+objId+"neoTable").bootstrapTable('removeByUniqueId', rowId);
};
function neoTableDeleteAll(objId){
$("#"+objId+"neoTable").bootstrapTable('removeAll');
};
function neoTableGetSelectedRowsData(objId){
return $("#"+objId+"neoTable").bootstrapTable('getSelections');
};
function neoTableLoadData(objId,theData){
$("#"+objId+"neoTable").bootstrapTable('load',theData);
$("#"+objId+"neoTable").bootstrapTable('uncheckAll')
};
function neoTableGotoNextPage(objId){
$("#"+objId+"neoTable").bootstrapTable('nextPage');
};
function neoTableGotoPrevPage(objId){
$("#"+objId+"neoTable").bootstrapTable('prevPage');
};
function neoTableGotoPage(objId, pageId){
$("#"+objId+"neoTable").bootstrapTable('selectPage',pageId);
};
function neoTableFilterBy(objId, filter){
$("#"+objId+"neoTable").bootstrapTable('filterBy',filter);
};
function neoTableSetData(theData,theId,theField,theValue){
if(theData==null){
console.log("neoTableSetData: The Array does not exist. Please use CreateEmptyArray");
}
if(theData[theId]==null){
theData[theId]=new Object();
}
theData[theId][theField]=theValue;
};
function neoTableGetData(theData,theId,theField){
if(theData==null){
console.log("neoTableGetData: The Array does not exist.");
}
if(theData[theId]==null){
console.log("neoTableGetData: The field does not exists.");
}
return theData[theId][theField];
};
function neoTableToggleView(objId){
$("#"+objId+"neoTable").bootstrapTable('toggleView');
};
C:\Users\sinli\OneDrive\CloudStation\visualneo\VisualNeoWeb\Plugins\bootstrap-table\bootstrap-table-1.19.1\bootstrap-table-master\dist\bootstrap-table.min.css
C:\Users\sinli\OneDrive\CloudStation\visualneo\VisualNeoWeb\Plugins\bootstrap-table\bootstrap-table-1.19.1\bootstrap-table-master\dist\bootstrap-table.min.js
C:\Users\sinli\OneDrive\CloudStation\visualneo\VisualNeoWeb\Plugins\bootstrap-table\bootstrap-table-1.19.1\bootstrap-table-master\dist\bootstrap-table-locale-all.min.js
C:\Users\sinli\OneDrive\CloudStation\visualneo\VisualNeoWeb\Plugins\bootstrap-table\bootstrap-table-1.19.1\bootstrap-table-master\dist\extensions\editable\bootstrap-table-editable.min.js
C:\Users\sinli\OneDrive\CloudStation\visualneo\VisualNeoWeb\Plugins\bootstrap-table\bootstrap-table-1.19.1\bootstrap-table-master\dist\extensions\export\bootstrap-table-export.min.js
C:\Users\sinli\OneDrive\CloudStation\visualneo\VisualNeoWeb\Plugins\bootstrap-table\bootstrap3-editable\bootstrap3-editable\css\bootstrap-editable.css
C:\Users\sinli\OneDrive\CloudStation\visualneo\VisualNeoWeb\Plugins\bootstrap-table\bootstrap3-editable\bootstrap3-editable\js\bootstrap-editable.min.js
C:\Users\sinli\OneDrive\CloudStation\visualneo\VisualNeoWeb\Plugins\bootstrap-table\tableExport\tableExport.min.js
C:\Users\sinli\OneDrive\CloudStation\visualneo\VisualNeoWeb\Plugins\bootstrap-table\bootstrap3-editable\datepicker-locales\bootstrap-datepicker.es.min.js
C:\Users\sinli\OneDrive\CloudStation\visualneo\VisualNeoWeb\Plugins\bootstrap-table\bootstrap3-editable\datepicker-locales\bootstrap-datepicker.de.min.js
C:\Users\sinli\OneDrive\CloudStation\visualneo\VisualNeoWeb\Plugins\bootstrap-table\bootstrap3-editable\datepicker-locales\bootstrap-datepicker.fr.min.js
C:\Users\sinli\OneDrive\CloudStation\visualneo\VisualNeoWeb\Plugins\bootstrap-table\bootstrap3-editable\datepicker-locales\bootstrap-datepicker.it.min.js
C:\Users\sinli\OneDrive\CloudStation\visualneo\VisualNeoWeb\Plugins\bootstrap-table\bootstrap3-editable\datepicker-locales\bootstrap-datepicker.pt.min.js
C:\Users\sinli\OneDrive\CloudStation\visualneo\VisualNeoWeb\Plugins\bootstrap-table\bootstrap3-editable\datepicker-locales\bootstrap-datepicker.ru.min.js
C:\Users\sinli\OneDrive\CloudStation\visualneo\VisualNeoWeb\Plugins\bootstrap-table\bootstrap3-editable\datepicker-locales\bootstrap-datepicker.ja.min.js
C:\Users\sinli\OneDrive\CloudStation\visualneo\VisualNeoWeb\Plugins\bootstrap-table\bootstrap3-editable\bootstrap3-editable\img\clear.png
C:\Users\sinli\OneDrive\CloudStation\visualneo\VisualNeoWeb\Plugins\bootstrap-table\bootstrap3-editable\bootstrap3-editable\img\loading.gif
Database configuration.
Needs neoPHP plugin.
objId|OBJID|Select neoTable container;dbAlias|STRING|Database alias name (as defined in config.php);tableName|STRING|Database table name;idField|STRING|Id field name (Unique primary key)
neoTableConfigDB(objId,dbAlias,tableName,idField);
Initializes neoTable into a container.
objId|OBJID|Select a container to initialize neoTable;language|ENUMLIST=af-ZA,ar-SA,ca-ES,cs-CZ,da-DK,de-DE,el-GR,en-US,es-AR,es-CL,es-CR,es-ES,es-MX,es-NI,es-SP,et-EE,eu-EU,fa-IR,fi-FI,fr-BE,fr-FR,he-IL,hr-HR,hu-HU,id-ID,it-IT,ja-JP,ka-GE,ko-KR,ms-MY,nb-NO,nl-NL,pl-PL,pt-BR,pt-PT,ro-RO,ru-RU,sk-SK,sv-SE,th-TH,tr-TR,uk-UA,ur-PK,uz-Latn-UZ,vi-VN,zh-CN,zh-TW|Language (i.e. 'es-ES'). Default 'en-US';pagination|INTEGER|Records per page? (0 for no pagination);viewmode|ENUMLIST=Table,Card|View mode;exportable|BOOLEAN|Allow user export data?;searchable|BOOLEAN|Allow user search through data?;showcolums|BOOLEAN|Allow user show and hide colums?;showtoggle|BOOLEAN|Allow user change view mode (table / card);selectable|BOOLEAN|Allow multiple selections? (Use neoTableSetMultiSelectColumn first);eventFunc|FUNCTION|On event subroutine (check, click, uncheck, loaderror, pagechange, search)
neoTableInitTable(objId,language,pagination,viewmode,exportable,searchable,showcolums,showtoggle,selectable,eventFunc);
Sets a new neoTable column
objId|OBJID|Select a container;columnNumber|INTEGER|Column number (1,2,3...);dataField|STRING|Data field name;dataName|STRING|Column header text;dataWidth|STRING|Column width. (Use px, % or empty for auto);dataSortable|BOOLEAN|Make column sortable by user?;dataEditable|BOOLEAN|User editable? (use neoTableEditColumnAs... first);dataSearchable|BOOLEAN|Searchable by user?;dataFormatter|FUNCTION|Subroutine to format the data (optional)
neoTableSetColumn(objId,columnNumber,dataField,dataName,dataWidth,dataSortable,dataEditable,dataSearchable,dataFormatter);
Resets neoTable columns so they can be set again.
objId|OBJID|Select a container object
neoTableResetColumns(objId);
Sets a select column to allow user select rows
objId|OBJID|Select a container;columnNumber|INTEGER|Column number (Usually 1);idField|STRING|Id field name (Unique primary key)
neoTableSetSelectColumn(objId,columnNumber,idField);
Sets a select column to allow user select rows
objId|OBJID|Select a container;columnNumber|INTEGER|Column number (Usually 1);idField|STRING|Id field name (Unique primary key)
neoTableSetMultiSelectColumn(objId,columnNumber,idField);
Settings to allow user edit column content as text
objId|OBJID|Select a container;columnNumber|STRING|Column number (1,2,3...);editorMode|ENUMLIST=popup,inline|Editor mode;placement|ENUMLIST=top,left,right,bottom|Placement (Only for popup mode);editorTitle|STRING|Title (optional and only for popup mode);placeHolder|STRING|Placeholder text. Shown when input is empty.;escapeHTML|BOOLEAN|Escape HTML? (default true);validateFunction|FUNCTION|Data validation subroutine (optional);sendToServer|BOOLEAN|Send data to server? (Needs neoPHP plugin);callbackFn|FUNCTION|Callback subroutine after server response (optional)
neoTableEditColumnAsText(objId,columnNumber,editorMode,placement,editorTitle,placeHolder,escapeHTML,validateFunction,sendToServer,callbackFn);
Settings to allow user edit column content using a Text Area
objId|OBJID|Select a container;columnNumber|STRING|Column number (1,2,3...);editorMode|ENUMLIST=popup,inline|Editor mode;placement|ENUMLIST=top,left,right,bottom|Placement (Only for popup mode);editorTitle|STRING|Title (optional and only for popup mode);placeHolder|STRING|Placeholder text. Shown when input is empty.;escapeHTML|BOOLEAN|Escape HTML? (default true);validateFunction|FUNCTION|Data validation subroutine (optional);sendToServer|BOOLEAN|Send data to server? (Needs neoPHP plugin);callbackFn|FUNCTION|Callback subroutine after server response (optional)
neoTableEditColumnAsTextArea(objId,columnNumber,editorMode,placement,editorTitle,placeHolder,escapeHTML,validateFunction,sendToServer,callbackFn);
Settings to allow user edit column content using a drop down
objId|OBJID|Select a container;columnNumber|STRING|Column number (1,2,3...);editorMode|ENUMLIST=popup,inline|Editor mode;placement|ENUMLIST=top,left,right,bottom|Placement (Only for popup mode);editorTitle|STRING|Title (optional and only for popup mode);selectData|HTML|Data (Each list item in a separate line);validateFunction|FUNCTION|Data validation subroutine (optional);sendToServer|BOOLEAN|Send data to server? (Needs neoPHP plugin);callbackFn|FUNCTION|Callback subroutine after server response (optional)
neoTableEditColumnAsSelect(objId,columnNumber,editorMode,placement,editorTitle,selectData,validateFunction,sendToServer,callbackFn);
Settings to allow user edit column content using a drop down
objId|OBJID|Select a container;columnNumber|STRING|Column number (1,2,3...);editorMode|ENUMLIST=popup,inline|Editor mode;placement|ENUMLIST=top,left,right,bottom|Placement (Only for popup mode);editorTitle|STRING|Title (optional and only for popup mode);selectData|HTML|Data (Each list item in a separate line);validateFunction|FUNCTION|Data validation subroutine (optional);sendToServer|BOOLEAN|Send data to server? (Needs neoPHP plugin);callbackFn|FUNCTION|Callback subroutine after server response (optional)
neoTableEditColumnAsCheckList(objId,columnNumber,editorMode,placement,editorTitle,selectData,validateFunction,sendToServer,callbackFn);
Settings to allow user edit column content using a date picker
objId|OBJID|Select a container;columnNumber|STRING|Column number (1,2,3...);placement|ENUMLIST=top,left,right,bottom|Date picker placement;editorTitle|STRING|Title (optional);format|STRING|Date format for server (ie: yyyy-mm-dd) ;viewFormat|STRING|Date format for displaying (ie: yyyy-mm-dd) ;weekFirstDay|ENUMLIST=Sunday,Monday|Week first day;language|ENUMLIST=en,es,fr,de,ru,it,pt,ja|Language;validateFunction|FUNCTION|Data validation subroutine (optional);sendToServer|BOOLEAN|Send data to server? (Needs neoPHP);callbackFn|FUNCTION|Callback subroutine after server response (optional)
neoTableEditColumnAsDate(objId,columnNumber,placement,editorTitle,format,viewFormat,weekFirstDay,language,validateFunction,sendToServer,callbackFn);
Settings to allow user edit column content as HTML5 input type
objId|OBJID|Select a container;html5Type|ENUMLIST=password,email,url,tel,number,range,time|Select HTML5 native input type;columnNumber|STRING|Column number (1,2,3...);editorMode|ENUMLIST=popup,inline|Editor mode;placement|ENUMLIST=top,left,right,bottom|Placement (Only for popup mode);editorTitle|STRING|Title (optional and only for popup mode);placeHolder|STRING|Placeholder text. Shown when input is empty.;escapeHTML|BOOLEAN|Escape HTML? (default true);validateFunction|FUNCTION|Data validation subroutine (optional);sendToServer|BOOLEAN|Send data to server? (Needs neoPHP plugin);callbackFn|FUNCTION|Callback subroutine after server response (optional)
neoTableEditColumnAsHTML5Input(objId,html5Type,columnNumber,editorMode,placement,editorTitle,placeHolder,escapeHTML,validateFunction,sendToServer,callbackFn);
Load data into neoTable. Previous data will be deleted
objId|OBJID|Select neoTable Container;theData|VARREF|Data object array (JSON)
neoTableLoadData(objId,theData);
Sets the value of a field in a dataset
theData|VARREF|Data object array;theId|INTEGER|Row number (first one is 0);theField|STRING|Field name;theValue|MIXED|Value to store
neoTableSetData(theData,theId,theField,theValue);
Gets the value of a field in a dataset
theData|VARREF|Data object array;theId|INTEGER|Row number (first one is 0);theField|STRING|Field name;theValue|VARREF|Variable to store result value
theValue = neoTableGetData(theData,theId,theField);
Get data from the table row that contains the id passed by parameter.
The result is stored in a JSON object.
objId|OBJID|Select neoTable Container;rowId|INTEGER|Row id;retvar|VARREF|Variable object to store result
retvar = neoTableGetRowData(objId, rowId);
Get data from user selected rows
objId|OBJID|Select neoTable Container;retvar|VARREF|Variable to store result
retvar = neoTableGetSelectedRowsData(objId);
Get the id's of selected rows as an Array
with values from the primary key field.
objId|OBJID|Select neoTable Container;retvar|VARREF|Variable to store result
retvar = getSelectedIds(objId);
Get the id of selected row as value from the primary key field
objId|OBJID|Select neoTable Container;retvar|VARREF|Variable to store result
retvar = getSelectedId(objId);
Get the loaded data of neoTable at the moment that this method is called.
The result is stored in a JSON object.
objId|STRING|Select neoTable Container;retvar|VARREF|Variable object to store result
retvar = neoTableGetAllData(objId);
Insert a new data row
objId|OBJID|Select neoTable Container;rowIndex|INTEGER|Row index (position) to insert new row;rowData|VARREF|Row data (variable object with the appropiate format)
neoTableInsertRow(objId,rowIndex,rowData);
Delete just one row by id
objId|OBJID|Select neoTable Container;rowId|INTEGER|Row Id number
neoTableDeleteRowById(objId,rowId);
Delete rows by field value
objId|OBJID|Select neoTable Container;fieldName|STRING|Field name;theValue|STRING|Value
neoTableDeleteRowsByValue(objId, fieldName, theValue);
Delete user selected rows
objId|OBJID|Select neoTable Container
neoTableDeleteSelectedRows(objId);
Filter content to show on table
objId|OBJID|Select neoTable Container;"filter|FLOAT|Filter to apply ie: {age:10, hairColor: [""blue"", ""red"", ""green""]} "
neoTableFilterBy(objId, filter);
Hides a neoTable column
objId|OBJID|Select neoTable Container;columnName|STRING|Field name to hide
neoTableHideColumn(objId,columnName);
Hide all neoTable columns
objId|OBJID|Select neoTable Container
neoTableHideAllColumns(objId)
objId|STRING|Select neoTable Container;columnName|STRING|Field name to show
neoTableShowColumn(objId,columnName);
Show all neoTable columns
objId|OBJID|Select neoTable Container
neoTableShowAllColumns(objId);
Delete all rows
objId|OBJID|Select neoTable Container
neoTableDeleteAll(objId);
Go to the next page on a paginated neoTable
objId|OBJID|Select neoTable Container
neoTableGotoNextPage(objId);
Go to the previous page on a paginated neoTable
objId|OBJID|Select neoTable Container
neoTableGotoPrevPage(objId);
Go to the specified page number on a paginated neoTable
objId|OBJID|Select neoTable Container;pageId|INTEGER|Page number
neoTableGotoPage(objId,pageId);
Toggle the card/table view.
objId|OBJID|Select neoTable Container
neoTableToggleView(objId);
Hide the neoTable content while keeping user interface elements and data formatting active.
objId|OBJID|Select neoTable Container
neoTableHideContent(objId);
Show a previously hidden neoTable content
objId|OBJID|Select neoTable Container
neoTableShowContent(objId);