$(document).ready(function () {
    $('#pluginAppObj_166_01_jtable').jtable({
    	title: 'Database Viewer',
        paging: true,
        pageSize: 10,
        pageSizeChangeArea: false,
        sorting: true,
        actions: {
            listAction: 'pluginAppObj/pluginAppObj_166_01/dbviewer.php?action=list',
			createAction: 'pluginAppObj/pluginAppObj_166_01/dbviewer.php?action=create',updateAction: 'pluginAppObj/pluginAppObj_166_01/dbviewer.php?action=update',deleteAction: 'pluginAppObj/pluginAppObj_166_01/dbviewer.php?action=delete',
        },
        fields: {
			'Id': {
				key: false,
				create: true,
				edit: true,
				list: true,
				title: 'Id',
				
			},
			'order_id': {
				key: false,
				create: false,
				edit: false,
				list: false,
				title: 'order_id',
				
			},
			'Nombre': {
				key: false,
				create: true,
				edit: true,
				list: true,
				title: 'Nombre',
				
			},
			'Apellidos': {
				key: false,
				create: true,
				edit: true,
				list: true,
				title: 'Apellidos',
				
			},
			'Dirección': {
				key: false,
				create: true,
				edit: true,
				list: true,
				title: 'Dirección',
				
			},
			'CódigoPostal': {
				key: false,
				create: true,
				edit: true,
				list: true,
				title: 'CódigoPostal',
				
			},
			'Ciudad': {
				key: false,
				create: true,
				edit: true,
				list: true,
				title: 'Ciudad',
				
			},
			'Provincia': {
				key: false,
				create: true,
				edit: true,
				list: true,
				title: 'Provincia',
				
			},
			'Teléfono': {
				key: false,
				create: true,
				edit: true,
				list: true,
				title: 'Teléfono',
				
			},
			'Correo E': {
				key: false,
				create: true,
				edit: true,
				list: true,
				title: 'Correo E',
				
			},
			'Fecha': {
				key: false,
				create: true,
				edit: true,
				list: true,
				title: 'Fecha',
				
			},
        },
        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_166_01_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_166_01_filter_button').click(function (e) {
        e.preventDefault();
        var filter = $('#pluginAppObj_166_01_filter_field').val();
        if(filter == undefined || filter == ""){
        	var params = {};
        }
        else{
        	var params = {filter : filter};
        }
        $('#pluginAppObj_166_01_jtable').jtable('load', params);
    });

    $('#pluginAppObj_166_01_csv_button').click(function (e) {
        e.preventDefault();
        var filter = $('#pluginAppObj_166_01_filter_field').val();
        if(filter == undefined || filter == ""){
        	filter = '';
        }
        else{
        	filter = '&filter=' + filter;
        }
        location.href = 'pluginAppObj/pluginAppObj_166_01/dbviewer.php?action=export' + filter;
    });

    $('#pluginAppObj_166_01_jtable').jtable('load');
});