$(document).ready(function () { $('#pluginAppObj_35_02_jtable').jtable({ title: 'Database Viewer', paging: true, pageSize: 10, pageSizeChangeArea: false, sorting: true, actions: { listAction: 'pluginAppObj/pluginAppObj_35_02/dbviewer.php?action=list', }, fields: { 'ID_firms': { key: true, create: true, edit: false, list: true, title: 'ID_firms', }, 'Logo': { key: false, create: true, edit: true, list: true, title: 'Logo', }, 'name': { key: false, create: true, edit: true, list: true, title: 'name', }, 'Menu': { key: false, create: true, edit: true, list: true, title: 'Menu', }, 'shortdesc': { key: false, create: true, edit: true, list: true, title: 'shortdesc', }, 'description': { key: false, create: false, edit: false, list: false, title: 'description', }, 'video1': { key: false, create: true, edit: true, list: true, title: 'video1', }, 'maplink': { key: false, create: true, edit: true, list: true, title: 'maplink', }, 'contact1': { key: false, create: true, edit: true, list: true, title: 'contact1', }, 'contact2': { key: false, create: true, edit: true, list: true, title: 'contact2', }, 'contact3': { key: false, create: true, edit: true, list: true, title: 'contact3', }, 'contact4': { key: false, create: true, edit: true, list: true, title: 'contact4', }, 'contact5': { key: false, create: true, edit: true, list: true, title: 'contact5', }, 'contact6': { key: false, create: true, edit: true, list: true, title: 'contact6', }, 'contact7': { key: false, create: true, edit: true, list: true, title: 'contact7', }, 'contact8': { key: false, create: true, edit: true, list: true, title: 'contact8', }, 'contact9': { key: false, create: true, edit: true, list: true, title: 'contact9', }, 'Description2': { key: false, create: true, edit: true, list: true, title: 'Description2', }, }, formCreated : function(event, data) { if(data.formType == 'error') return; var div = data.form[0].parentElement; if(data.formType != 'delete') div = div.parentElement; $(div).addClass('pluginAppObj_35_02_dialog'); }, messages: { serverCommunicationError: 'An error occured while communicating to the server.', loadingMessage: 'Loading records...', noDataAvailable: 'No data available!', addNewRecord: 'Add new record', editRecord: 'Edit Record', areYouSure: 'Are you sure?', deleteConfirmation: 'This record will be deleted. Are you sure?', save: 'Save', saving: 'Saving', cancel: 'Cancel', deleteText: 'Delete', deleting: 'Deleting', error: 'Error', close: 'Close', cannotLoadOptionsFor: 'Can not load options for field {0}', pagingInfo: 'Showing {0}-{1} of {2}', pageSizeChangeLabel: 'Row count', gotoPageLabel: 'Go to page', canNotDeletedRecords: 'Can not deleted {0} of {1} records!', deleteProggress: 'Deleted {0} of {1} records, processing...' } }); $('#pluginAppObj_35_02_filter_button').click(function (e) { e.preventDefault(); var filter = $('#pluginAppObj_35_02_filter_field').val(); if(filter == undefined || filter == ""){ var params = {}; } else{ var params = {filter : filter}; } $('#pluginAppObj_35_02_jtable').jtable('load', params); }); $('#pluginAppObj_35_02_csv_button').click(function (e) { e.preventDefault(); var filter = $('#pluginAppObj_35_02_filter_field').val(); if(filter == undefined || filter == ""){ filter = ''; } else{ filter = '&filter=' + filter; } location.href = 'pluginAppObj/pluginAppObj_35_02/dbviewer.php?action=export' + filter; }); $('#pluginAppObj_35_02_jtable').jtable('load'); });