Guriddo » dfr's Replies

dfr

Guriddo

Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)

Author

Replies

April 22, 2017 at 12:31 am in reply to: grid as subgrid #126005

dfr

Participant

Hi,

I have resolve my problem, it was simply a wrong column name in sort in sql (php file).
The php file return good when not use with grid but there is wrong parameter sidx when use with grid and return wrong json (empty). I hope can help somebody …

April 21, 2017 at 6:52 pm in reply to: grid as subgrid #126002

dfr

Participant

the json

{
	&quot;rows&quot;: [
		{
			&quot;id&quot;: &quot;7&quot;,
			&quot;cell&quot;: [
				&quot;7&quot;,
				&quot;2017-03-23 00:00:00&quot;,
				&quot;Erreur&quot;,
				&quot;Impossible d&#039;identifier la source du fichier&quot;
			]
		},
		{
			&quot;id&quot;: &quot;9&quot;,
			&quot;cell&quot;: [
				&quot;9&quot;,
				&quot;2017-03-23 00:00:00&quot;,
				&quot;Erreur&quot;,
				&quot;Impossible d&#039;identifier la source du fichier&quot;
			]
		}
	],
	&quot;page&quot;: 1,
	&quot;total&quot;: 1,
	&quot;records&quot;: &quot;2&quot;
}

{

"rows": [

{

"id": "7",

"cell": [

"7",

"2017-03-23 00:00:00",

"Erreur",

"Impossible d'identifier la source du fichier"

]

{

"id": "9",

"cell": [

"9",

"2017-03-23 00:00:00",

"Erreur",

"Impossible d'identifier la source du fichier"

]

}

"page": 1,

"total": 1,

"records": "2"

}

April 21, 2017 at 6:48 pm in reply to: grid as subgrid #126000

dfr

Participant

sorry i cant put my code good

var mygrid = jQuery(&quot;#filesLst&quot;).jqGrid({        
	   	url:&#039;../api/fichiers/lstFiles.php&#039;,
		datatype: &quot;json&quot;,
	   	colNames:[&#039;id&#039;, &#039;date trait.&#039;, &#039;Source&#039;,&#039;Etat&#039;, &#039;Nom&#039;, &#039;Evenement&#039;, &#039;Message&#039;],
	   	colModel:[
	   		{name:&#039;id&#039;,index:&#039;idFichier&#039;, width:80, 
		   		searchoptions:{
	   				sopt:[&#039;eq&#039;,&#039;ne&#039;,&#039;lt&#039;,&#039;le&#039;,&#039;gt&#039;,&#039;ge&#039;],
			   		clearSearch:false
		   		},
		   		searchrules:{
		   			integer:true
		   		}
	   		},
	   		{name:&#039;dateTraitement&#039;,index:&#039;datePECFichier&#039;, width:90, formatter:&#039;date&#039;, 

	   			formatoptions:{
	   				srcformat: &#039;ISO8601Long&#039;,
	                newformat: &#039;d-m-Y&#039;,
	                defaultValue:null
	   			},
	   			searchoptions:{
		   			dataInit:function(el){
			   			$(el).datepicker({dateFormat:&#039;dd-mm-yy&#039;});
			   		}, 
			   		sopt:[&#039;ge&#039;,&#039;gt&#039;,&#039;eq&#039;,&#039;ne&#039;,&#039;lt&#039;,&#039;le&#039;],
			   		defaultValue:&#039;&lt;?php echo date(&quot;d-m-Y&quot;, strtotime(&quot;-1 year&quot;, strtotime(date(&quot;d-m-Y&quot;))));?&gt;&#039;,
			   		clearSearch:false
	   			},
		   		searchrules:{
		   			date:true
		   		}
		   	},
	   		{name:&#039;source&#039;,index:&#039;libelleSource&#039;, width:90, 
		   		stype:&quot;select&quot;, 
		   		searchoptions:{
	   				dataUrl:&quot;../api/sources/selectSource.php&quot;,
	   				sopt:[&#039;eq&#039;,&#039;ne&#039;],
			   		clearSearch:false
		   		}
	   		},
	   		{name:&#039;etat&#039;,index:&#039;libelleEtat&#039;, width:90, 
		   		stype:&quot;select&quot;, 
		   		searchoptions:{
	   				dataUrl:&quot;../api/etats/selectEtat.php&quot;,
	   				sopt:[&#039;eq&#039;,&#039;ne&#039;],
			   		clearSearch:false
		   		}
	   		},
	   		{name:&#039;nom&#039;,index:&#039;nomFichier&#039;, width:350, 
		   		searchoptions:{
	   				sopt:[&#039;eq&#039;,&#039;ne&#039;,&#039;bw&#039;,&#039;bn&#039;,&#039;in&#039;,&#039;ni&#039;,&#039;ew&#039;,&#039;en&#039;,&#039;cn&#039;,&#039;nc&#039;],
			   		clearSearch:false
		   		}
	   		},
	   		{name:&#039;evenement&#039;,index:&#039;evenementFichier&#039;, width:350, 
		   		searchoptions:{
	   				sopt:[&#039;eq&#039;,&#039;ne&#039;,&#039;bw&#039;,&#039;bn&#039;,&#039;in&#039;,&#039;ni&#039;,&#039;ew&#039;,&#039;en&#039;,&#039;cn&#039;,&#039;nc&#039;],
			   		clearSearch:false
		   		}
	   		},
	   		{name:&#039;message&#039;,index:&#039;messageFichier&#039;, width:350, 
		   		searchoptions:{
	   				sopt:[&#039;eq&#039;,&#039;ne&#039;,&#039;bw&#039;,&#039;bn&#039;,&#039;in&#039;,&#039;ni&#039;,&#039;ew&#039;,&#039;en&#039;,&#039;cn&#039;,&#039;nc&#039;],
			   		clearSearch:false
		   		}
	   		}		
	   	],
	   	rowNum:15,
	   	rowList:[15,30,60],
	   	pager: &#039;#filesListBut&#039;,
	   	sortname: &#039;idFichier&#039;,
	    viewrecords: true,
	    sortorder: &quot;desc&quot;,
	    autowidth: true,
	    height:	&#039;350px&#039;,
	    subGrid : true,
	    subGridRowExpanded: showChildGrid,		
	    caption:&quot;Liste des fichiers d&#039;interface trait&amp;eacute;s&quot;
	    
	});

var mygrid = jQuery("#filesLst").jqGrid({

url:'../api/fichiers/lstFiles.php',

datatype: "json",

colNames:['id', 'date trait.', 'Source','Etat', 'Nom', 'Evenement', 'Message'],

colModel:[

{name:'id',index:'idFichier', width:80,

searchoptions:{

sopt:['eq','ne','lt','le','gt','ge'],

clearSearch:false

searchrules:{

integer:true

}

{name:'dateTraitement',index:'datePECFichier', width:90, formatter:'date',

formatoptions:{

srcformat: 'ISO8601Long',

newformat: 'd-m-Y',

defaultValue:null

searchoptions:{

dataInit:function(el){

$(el).datepicker({dateFormat:'dd-mm-yy'});

sopt:['ge','gt','eq','ne','lt','le'],

defaultValue:'<?php echo date("d-m-Y", strtotime("-1 year", strtotime(date("d-m-Y"))));?>',

clearSearch:false

searchrules:{

date:true

}

{name:'source',index:'libelleSource', width:90,

stype:"select",

searchoptions:{

dataUrl:"../api/sources/selectSource.php",

sopt:['eq','ne'],

clearSearch:false

}

{name:'etat',index:'libelleEtat', width:90,

stype:"select",

searchoptions:{

dataUrl:"../api/etats/selectEtat.php",

sopt:['eq','ne'],

clearSearch:false

}

{name:'nom',index:'nomFichier', width:350,

searchoptions:{

sopt:['eq','ne','bw','bn','in','ni','ew','en','cn','nc'],

clearSearch:false

}

{name:'evenement',index:'evenementFichier', width:350,

searchoptions:{

sopt:['eq','ne','bw','bn','in','ni','ew','en','cn','nc'],

clearSearch:false

}

{name:'message',index:'messageFichier', width:350,

searchoptions:{

sopt:['eq','ne','bw','bn','in','ni','ew','en','cn','nc'],

clearSearch:false

}

rowNum:15,

rowList:[15,30,60],

pager: '#filesListBut',

sortname: 'idFichier',

viewrecords: true,

sortorder: "desc",

autowidth: true,

height: '350px',

subGrid : true,

subGridRowExpanded: showChildGrid,

caption:"Liste des fichiers d'interface trait&eacute;s"

});

… other code to nav, filter search and title …

function showChildGrid(parentRowID, parentRowKey) {
	//alert(&#039;http://localhost/xdemat-siig/api/traitements/lstTraitements.php?id=&#039; + parentRowKey);
    // create unique table and pager
    var childGridID = parentRowID + &quot;_table&quot;;
    var childGridPagerID = parentRowID + &quot;_pager&quot;;
    
    // add a table and pager HTML elements to the parent grid row - we will render the child grid here
    $(&#039;#&#039; + parentRowID).append(&#039;&lt;table id=&#039; + childGridID + &#039;&gt;&lt;/table&gt;&lt;div&gt;&lt;/div&gt;&#039;);

    $(&quot;#&quot; + childGridID).jqGrid({
        url: &#039;../api/traitements/lstTraitements.php?id=&#039; + parentRowKey,
        mtype: &quot;GET&quot;,
        datatype: &quot;json&quot;,
	   	colNames:[&#039;idTrait&#039;, &#039;DeteTraite&#039;, &#039;EtatTrait&#039;, &#039;MessageTrait&#039;],
        colModel: [
            { name : &#039;idTrait&#039; , index : &#039;idTrait&#039; , width: 25, key: true },
            { name : &#039;DeteTraite&#039; , index : &#039;DeteTraite&#039; , width: 100 },
            { name : &#039;EtatTrait&#039; , index : &#039;EtatTrait&#039; , width: 100 },
            { name : &#039;MessageTrait&#039; , index : &#039;MessageTrait&#039; , width: 100 }
        ],
        page:1,
        rows:10,
        height: &#039;150px&#039;,
	   	sortname: &#039;idTrait&#039;,
	    sortorder: &quot;desc&quot;,
	    pager: &quot;#&quot; + childGridPagerID
    });
}

function showChildGrid(parentRowID, parentRowKey) {

//alert('http://localhost/xdemat-siig/api/traitements/lstTraitements.php?id=' + parentRowKey);

// create unique table and pager

var childGridID = parentRowID + "_table";

var childGridPagerID = parentRowID + "_pager";

// add a table and pager HTML elements to the parent grid row - we will render the child grid here

$('#' + parentRowID).append('<table id=' + childGridID + '></table><div></div>');

$("#" + childGridID).jqGrid({

url: '../api/traitements/lstTraitements.php?id=' + parentRowKey,

mtype: "GET",

datatype: "json",

colNames:['idTrait', 'DeteTraite', 'EtatTrait', 'MessageTrait'],

colModel: [

{ name : 'idTrait' , index : 'idTrait' , width: 25, key: true },

{ name : 'DeteTraite' , index : 'DeteTraite' , width: 100 },

{ name : 'EtatTrait' , index : 'EtatTrait' , width: 100 },

{ name : 'MessageTrait' , index : 'MessageTrait' , width: 100 }

page:1,

rows:10,

height: '150px',

sortname: 'idTrait',

sortorder: "desc",

pager: "#" + childGridPagerID

});

}

This reply was modified 9 years ago by dfr.
This reply was modified 9 years ago by dfr.

Author

Replies

Viewing 3 replies - 1 through 3 (of 3 total)