[RaiParticipant]

I want change orientation page on pdf.
How I do that?

[RaiParticipant]

I found a example with the filename…
$(“#grilla”).jqxGrid(‘exportdata’, ‘xls’, ‘filename’);

My next question is:
the filename has a error when I add a concat

var hoy = new Date();
var dd = hoy.getDate();
var mm = hoy.getMonth() + 1;
var yyyy = hoy.getFullYear();
     if (dd < 10) {
          dd = '0' + dd
     }
     if (mm < 10) {
          mm = '0' + mm
     }
var hoy = dd + '/' + mm + '/' + yyyy;
var a = Date.now();

$("#grid").jqxGrid('exportdata', 'xls', hoy);

ERROR:

Warning: fopen(08/04/2016.xls): failed to open stream: No such file or directory in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 4

Warning: fwrite() expects parameter 1 to be resource, boolean given in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 5

Warning: fclose() expects parameter 1 to be resource, boolean given in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 6

Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/8742704/html/subfolder1/export_server/save-file.php:4) in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 47

Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/8742704/html/subfolder1/export_server/save-file.php:4) in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 48

Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/8742704/html/subfolder1/export_server/save-file.php:4) in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 49

Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/8742704/html/subfolder1/export_server/save-file.php:4) in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 50

Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/8742704/html/subfolder1/export_server/save-file.php:4) in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 51

Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/8742704/html/subfolder1/export_server/save-file.php:4) in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 52

Warning: filesize(): stat failed for 08/04/2016.xls in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 53

Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/8742704/html/subfolder1/export_server/save-file.php:4) in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 53

Warning: readfile(08/04/2016.xls): failed to open stream: No such file or directory in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 54

Warning: unlink(08/04/2016.xls): No such file or directory in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 55

[RaiParticipant]

Can when I export to pdf, change a orientation of the page?

[RaiParticipant]

condition in columnindex, sorry.

[RaiParticipant]

but if I press any cell show the info, it is wrong, I just want in a cell.

[RaiParticipant]

I can !!

The event i need is:
$(“#grillaResultados”).on(“cellclick”, function (event) {

}

[RaiParticipant]

function myFunction(row, column, value) {
// get the clicked row’s data and initialize the input fields.
var offset = $(“#grillaResultados”).offset();
var dataRecord = $(“#grillaResultados”).jqxGrid(‘getrowdata’, row);
var numContrato = dataRecord.NumeroContrato;
alert(“Numero de contrato: [" + dataRecord.NumeroContrato + "]“);
// show the popup window.
$(“#popupWindowLog”).jqxWindow(‘open’);
//$(“#popupWindowLog “).jqxWindow(‘open’, { height: ’100%’, width: ‘auto’, theme: ‘ui-start’, isModal: true });
//Dibujo la grillaResultado2
var origen2 = new $.jqx.dataAdapter
({
type: ‘post’,
datatype: ‘json’,
//Campos que enviaremos a la función para realizar la consulta
data: { ‘numContr’: numContrato },
datafields: [
{ name: 'fechaRegistro', type: 'string' },
{ name: 'pasoProceso', type: 'string' },
{ name: 'usuario', type: 'string' },
{ name: 'descrDetalleLog', type: 'string' }
],
url: ‘@Url.RouteUrl(“ConsultarLogAuditoria_default”, new { area = “ConsultarLogAuditoria”, controller = “LogAuditoria”, action = “ListarDetalle” })’,
sortcolumn: ‘fechaRegistro’,
sortdirection: ‘asc’,
beforeprocessing: function (data) {
},
pager: function (pagenum, pagesize, oldpagenum) {
// callback called when a page or page size is changed.
}
}); //Fin origen2 del jqx.dataAdapter
$(“#grillaResultados2″).jqxGrid(
{
//autoheight: true,
//autorowheight: true,
width: ’100%’,
source: origen2,
theme: ‘default’,
scrollmode: ‘deferred’,
localization: { loadtext: “Cargando” },
columns: [
{ text: 'Fecha de Registro', columngroup: 'InfOpCre', datafield: 'fechaRegistro', width: '16%', editable: false },
{ text: 'Paso del Proceso', columngroup: 'InfOpCre', datafield: 'pasoProceso', width: '14%', editable: false },
{ text: 'Usuario', columngroup: 'InfOpCre', datafield: 'usuario', width: '28%', editable: false },
{ text: 'Descripción Detalle del Log', columngroup: 'InfOpCre', datafield: 'descrDetalleLog', width: '100%', editable: false }
],
columngroups: [
{ text: 'Log de Eventos Proceso de Inyección de Operaciones', align: 'left', name: 'InfOpCre', theme: 'ui-start' }
]
}); //Fin Grilla Resultado2
}
$(function () {
$(‘#btnBuscar’).click(function (evento)
{
evento.preventDefault();
var columnsrenderer = function (value) {
return ‘<div style=”text-align: center; margin-top: 5px;”>’ + value + ‘</div>’;
}
var origen = new $.jqx.dataAdapter
({
type: ‘post’,
datatype: ‘json’,
//Campos que enviaremos a la función para realizar la consulta
data: { ‘fecDesde’: fecDesde, ‘fecHasta’: fecHasta, ‘cmbUsu’: cmbUsu, ‘numContr’: numContr },
datafields: [
{ name: 'FechaRegistro', type: 'string'},
{ name: 'NumeroContrato', type: 'string' },
{ name: 'EstadoFinalOpe', type: 'string' },
{ name: 'TipoUsuario', type: 'string' }
],
url: ‘@Url.RouteUrl(“ConsultarLogAuditoria_default”, new { area = “ConsultarLogAuditoria”, controller = “LogAuditoria”, action = “Listar” })’,
sortcolumn: ‘FechaRegistro’,
sortdirection: ‘asc’,
root: ‘Rows’,
beforeprocessing: function (data) {
}
}); //Fin origen del jqx.dataAdapter
$(“#grillaResultados”).jqxGrid(
{
//autoheight: true,
//autorowheight: true,
width: ’100%’,
height: 300,
source: origen,
theme: ‘default’,
scrollmode: ‘deferred’,
localization: { loadtext: “Cargando” },
columns: [
{ text: 'Fecha de Registro', columngroup: 'InfOpCre', datafield: 'FechaRegistro', width: '20%', editable: false, sortable: true },
{ text: 'N° Contrato', columngroup: 'InfOpCre', datafield: 'NumeroContrato', width: '10%', editable: false },
{ text: 'Estado Final Operación', columngroup: 'InfOpCre', datafield: 'EstadoFinalOpe', width: '20%', editable: false },
{ text: 'Usuario', columngroup: 'InfOpCre', datafield: 'TipoUsuario', width: '35%', editable: false },
{
text: 'Ver Detalle Log', renderer: columnsrenderer, datafield: 'Log', columngroup: 'InfOpCre', width: '13%'/*, columntype: 'button'*/, editable: false,
cellsrenderer: function (row, column, value) {
//return "Log";
return '<button style="width: 100%;background-color:transparent;"></button>';
}, buttonclick: function (row) {
// get the clicked row's data and initialize the input fields.
/*
var offset = $("#grillaResultados").offset();
var dataRecord = $("#grillaResultados").jqxGrid('getrowdata', row);
var numContrato = dataRecord.NumeroContrato;
// show the popup window.
$("#popupWindowLog").jqxWindow('open');
//$("#popupWindowLog ").jqxWindow('open', { height: '100%', width: 'auto', theme: 'ui-start', isModal: true });
//Dibujo la grillaResultado2
var origen2 = new $.jqx.dataAdapter
({
type: 'post',
datatype: 'json',
//Campos que enviaremos a la función para realizar la consulta
data: { 'numContr': numContrato },
datafields: [
{ name: 'fechaRegistro', type: 'string' },
{ name: 'pasoProceso', type: 'string' },
{ name: 'usuario', type: 'string' },
{ name: 'descrDetalleLog', type: 'string' }
],
url: ‘@Url.RouteUrl(“ConsultarLogAuditoria_default”, new { area = “ConsultarLogAuditoria”, controller = “LogAuditoria”, action = “ListarDetalle” })’,
sortcolumn: ‘fechaRegistro’,
sortdirection: ‘asc’,
beforeprocessing: function (data) {
},
pager: function (pagenum, pagesize, oldpagenum) {
// callback called when a page or page size is changed.
}
}); //Fin origen2 del jqx.dataAdapter
$(“#grillaResultados2″).jqxGrid(
{
//autoheight: true,
//autorowheight: true,
width: ’100%’,
source: origen2,
theme: ‘default’,
scrollmode: ‘deferred’,
localization: { loadtext: “Cargando” },
columns: [
{ text: 'Fecha de Registro', columngroup: 'InfOpCre', datafield: 'fechaRegistro', width: '16%', editable: false },
{ text: 'Paso del Proceso', columngroup: 'InfOpCre', datafield: 'pasoProceso', width: '14%', editable: false },
{ text: 'Usuario', columngroup: 'InfOpCre', datafield: 'usuario', width: '28%', editable: false },
{ text: 'Descripción Detalle del Log', columngroup: 'InfOpCre', datafield: 'descrDetalleLog', width: '100%', editable: false }
],
columngroups: [
{ text: 'Log de Eventos Proceso de Inyección de Operaciones', align: 'left', name: 'InfOpCre', theme: 'ui-start' }
]
}); //Fin Grilla Resultado2*/
}
}
],
columngroups: [
{ text: 'Log de Auditoría', align: 'left', name: 'InfOpCre', theme: 'ui-start' }
]
});
});

[RaiParticipant]

thanks man.!

[Author]

Posts