Guriddo » Topic: Wrong? Help with jqGrid

Wrong? Help with jqGrid

Guriddo
Wrong? Help with jqGrid

This topic has 3 replies, 2 voices, and was last updated 10 years, 7 months ago by tony.

Creator

Topic

October 7, 2015 at 7:41 am #124427

sean.nay

Participant

Data Output (small samples):

{&quot;DaNoob0&quot;:{
&quot;Argiculture&quot;:{&quot;Level&quot;:9,&quot;StartTime&quot;:0,&quot;EndTime&quot;:0},
&quot;Lumbering&quot;:{&quot;Level&quot;:9,&quot;StartTime&quot;:0,&quot;EndTime&quot;:0},
&quot;Masonry&quot;:{&quot;Level&quot;:9,&quot;StartTime&quot;:0,&quot;EndTime&quot;:0},
&quot;Mining&quot;:{&quot;Level&quot;:9,&quot;StartTime&quot;:0,&quot;EndTime&quot;:0},
&quot;Metal_Casting&quot;:{&quot;Level&quot;:9,&quot;StartTime&quot;:0,&quot;EndTime&quot;:0},
&quot;Informatics&quot;:{&quot;Level&quot;:9,&quot;StartTime&quot;:0,&quot;EndTime&quot;:0},
&quot;Military_Science&quot;:{&quot;Level&quot;:9,&quot;StartTime&quot;:0,&quot;EndTime&quot;:0},
&quot;Military_Tradition&quot;:{&quot;Level&quot;:9,&quot;StartTime&quot;:0,&quot;EndTime&quot;:0},
&quot;Iron_Working&quot;:{&quot;Level&quot;:9,&quot;StartTime&quot;:0,&quot;EndTime&quot;:0},
&quot;Logistics&quot;:{&quot;Level&quot;:8,&quot;StartTime&quot;:1444159222,&quot;EndTime&quot;:1444372703},
&quot;Compass&quot;:{&quot;Level&quot;:8,&quot;StartTime&quot;:0,&quot;EndTime&quot;:0},
&quot;Horseback_Riding&quot;:{&quot;Level&quot;:9,&quot;StartTime&quot;:0,&quot;EndTime&quot;:0},
&quot;Archery&quot;:{&quot;Level&quot;:8,&quot;StartTime&quot;:0,&quot;EndTime&quot;:0},
&quot;Stockpile&quot;:{&quot;Level&quot;:9,&quot;StartTime&quot;:0,&quot;EndTime&quot;:0},
&quot;Medicine&quot;:{&quot;Level&quot;:8,&quot;StartTime&quot;:0,&quot;EndTime&quot;:0},
&quot;Construction&quot;:{&quot;Level&quot;:8,&quot;StartTime&quot;:0,&quot;EndTime&quot;:0},
&quot;Engineering&quot;:{&quot;Level&quot;:8,&quot;StartTime&quot;:0,&quot;EndTime&quot;:0},
&quot;Machinery&quot;:{&quot;Level&quot;:8,&quot;StartTime&quot;:0,&quot;EndTime&quot;:0},
&quot;Privateering&quot;:{&quot;Level&quot;:7,&quot;StartTime&quot;:0,&quot;EndTime&quot;:0}
}

{"DaNoob0":{

"Argiculture":{"Level":9,"StartTime":0,"EndTime":0},

"Lumbering":{"Level":9,"StartTime":0,"EndTime":0},

"Masonry":{"Level":9,"StartTime":0,"EndTime":0},

"Mining":{"Level":9,"StartTime":0,"EndTime":0},

"Metal_Casting":{"Level":9,"StartTime":0,"EndTime":0},

"Informatics":{"Level":9,"StartTime":0,"EndTime":0},

"Military_Science":{"Level":9,"StartTime":0,"EndTime":0},

"Military_Tradition":{"Level":9,"StartTime":0,"EndTime":0},

"Iron_Working":{"Level":9,"StartTime":0,"EndTime":0},

"Logistics":{"Level":8,"StartTime":1444159222,"EndTime":1444372703},

"Compass":{"Level":8,"StartTime":0,"EndTime":0},

"Horseback_Riding":{"Level":9,"StartTime":0,"EndTime":0},

"Archery":{"Level":8,"StartTime":0,"EndTime":0},

"Stockpile":{"Level":9,"StartTime":0,"EndTime":0},

"Medicine":{"Level":8,"StartTime":0,"EndTime":0},

"Construction":{"Level":8,"StartTime":0,"EndTime":0},

"Engineering":{"Level":8,"StartTime":0,"EndTime":0},

"Machinery":{"Level":8,"StartTime":0,"EndTime":0},

"Privateering":{"Level":7,"StartTime":0,"EndTime":0}

}

PHP:

$Re = $ZP -&gt; query(&#039;SELECT nPlayer.Player,TypeID,Level,StartTime,EndTime FROM nResearch LEFT JOIN nPlayer ON nPlayer.PlayerID = nResearch.PlayerID AND nPlayer.mID = nResearch.mID LEFT JOIN nMains ON nMains.mID = nResearch.mID WHERE Main = &quot;&#039;.$M.&#039;&quot; AND Server = &quot;&#039;.$S.&#039;&quot; AND Pass = &quot;&#039;.md5($P).&#039;&quot; ORDER BY nPlayer.Player&#039;);

while($Ro = $ZP -&gt; fetch_assoc($Re)){ 
   $ResearchList[$Ro[&#039;Player&#039;]][str_replace(&quot; &quot;,&quot;_&quot;, Research($Ro[&#039;TypeID&#039;]))] = array(&#039;Level&#039; =&gt; (int)$Ro[&#039;Level&#039;],&#039;StartTime&#039; =&gt; (int)$Ro[&#039;StartTime&#039;], &#039;EndTime&#039; =&gt; (int)$Ro[&#039;EndTime&#039;]); 
}
if(!empty($ResearchList)){  
   echo json_encode($ResearchList); 
} else { 
   exit; 
}

$Re = $ZP -> query('SELECT nPlayer.Player,TypeID,Level,StartTime,EndTime FROM nResearch LEFT JOIN nPlayer ON nPlayer.PlayerID = nResearch.PlayerID AND nPlayer.mID = nResearch.mID LEFT JOIN nMains ON nMains.mID = nResearch.mID WHERE Main = "'.$M.'" AND Server = "'.$S.'" AND Pass = "'.md5($P).'" ORDER BY nPlayer.Player');

while($Ro = $ZP -> fetch_assoc($Re)){

$ResearchList[$Ro['Player']][str_replace(" ","_", Research($Ro['TypeID']))] = array('Level' => (int)$Ro['Level'],'StartTime' => (int)$Ro['StartTime'], 'EndTime' => (int)$Ro['EndTime']);

}

if(!empty($ResearchList)){

echo json_encode($ResearchList);

} else {

exit;

}

JQuery:

$(&#039;#ResearchViewTest&#039;).jqGrid({
url:&#039;PlayerD.php?G=ResearchViewTest&amp;M=&#039;+$(&#039;#MainLogin&#039;).val()+&#039;&amp;P=&#039;+$(&#039;#PassLogin&#039;).val()+&#039;&amp;S=&#039;+$(&#039;#ServerLogin&#039;).val(),
datatype:&#039;json&#039;,altRows:true,hoverrows:false,rowNum:2000,height:635,repeatitems:false,
colModel:[
{label:&#039;Player&#039;,name:&#039;Player&#039;,width:112,sortable:true},
{label:&#039;Argi&#039;,name:&#039;Argiculture.Level&#039;,width:52,sortable:true},
{label:&#039;Lumb&#039;,name:&#039;Lumbering.Level&#039;,width:52,sortable:true},
{label:&#039;Maso&#039;,name:&#039;Masonry&#039;,width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return cellvalue; }},
{label:&#039;Mini&#039;,name:&#039;Mining&#039;,width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},
{label:&#039;MetC&#039;,name:&#039;Metal_Casting&#039;,width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},
{label:&#039;Info&#039;,name:&#039;Informatics&#039;,width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},
{label:&#039;MSci&#039;,name:&#039;Military_Science&#039;,width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},
{label:&#039;MTra&#039;,name:&#039;Military_Tradition&#039;,width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},
{label:&#039;Iron&#039;,name:&#039;Iron_Working&#039;,width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},
{label:&#039;Logi&#039;,name:&#039;Logistics&#039;,width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},
{label:&#039;Comp&#039;,name:&#039;Compass&#039;,width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},
{label:&#039;HRid&#039;,name:&#039;Horseback_Riding&#039;,width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},
{label:&#039;Arch&#039;,name:&#039;Archery&#039;,width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},
{label:&#039;Stoc&#039;,name:&#039;Stockpile&#039;,width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},
{label:&#039;Medi&#039;,name:&#039;Medicine&#039;,width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},
{label:&#039;Cons&#039;,name:&#039;Construction&#039;,width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},
{label:&#039;Engi&#039;,name:&#039;Engineering&#039;,width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},
{label:&#039;Mach&#039;,name:&#039;Machinery&#039;,width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},
{label:&#039;Priv&#039;,name:&#039;Privateering&#039;,width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }}
]
});

$('#ResearchViewTest').jqGrid({

url:'PlayerD.php?G=ResearchViewTest&M='+$('#MainLogin').val()+'&P='+$('#PassLogin').val()+'&S='+$('#ServerLogin').val(),

datatype:'json',altRows:true,hoverrows:false,rowNum:2000,height:635,repeatitems:false,

colModel:[

{label:'Player',name:'Player',width:112,sortable:true},

{label:'Argi',name:'Argiculture.Level',width:52,sortable:true},

{label:'Lumb',name:'Lumbering.Level',width:52,sortable:true},

{label:'Maso',name:'Masonry',width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return cellvalue; }},

{label:'Mini',name:'Mining',width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},

{label:'MetC',name:'Metal_Casting',width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},

{label:'Info',name:'Informatics',width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},

{label:'MSci',name:'Military_Science',width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},

{label:'MTra',name:'Military_Tradition',width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},

{label:'Iron',name:'Iron_Working',width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},

{label:'Logi',name:'Logistics',width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},

{label:'Comp',name:'Compass',width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},

{label:'HRid',name:'Horseback_Riding',width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},

{label:'Arch',name:'Archery',width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},

{label:'Stoc',name:'Stockpile',width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},

{label:'Medi',name:'Medicine',width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},

{label:'Cons',name:'Construction',width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},

{label:'Engi',name:'Engineering',width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},

{label:'Mach',name:'Machinery',width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }},

{label:'Priv',name:'Privateering',width:52,sortable:true,formatter:function (cellvalue,options,rowObject){ return rowObject.Level; }}

]

});

Result keep coming up blank. What am I doing wrong here?

This topic was modified 10 years, 7 months ago by tony. Reason: formatting code
This topic was modified 10 years, 7 months ago by tony.
This topic was modified 10 years, 7 months ago by tony.
This topic was modified 10 years, 7 months ago by tony.

Creator

Topic

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

Author

Replies
October 7, 2015 at 1:46 pm #124433
tony
Keymaster
Hello,

I highly recommend you to read basics jqGrid datatypes and responses.

You will need to configure your josonReader.

Please take a look here

Kind Regards,
- This reply was modified 10 years, 7 months ago by tony.
October 7, 2015 at 7:46 pm #124435

sean.nay
Participant

I read thru this document and don’t see which one applies to me since I don’t use “Unique” name for the array, each array would be different but with revelant information inside the object. In this case, how would I use jsonReader in this?

Thanks

October 8, 2015 at 1:00 pm #124440

tony
Keymaster

Hello,

Please read it carefully.
Is this one row from the response (in the example)?
If this is the case, you may need to use jsonmap property in colModel.

By example in colMode you have set name = Privateering,

but in the response, this property has a value object with another properties = StartTime End Time and etc – which one should be displayed in the grid?

Please provide two or more rows from the response as described in the documentatuion link – rows property in reader.

Regards,
Author

Replies