jQuery Grid Plugin - jqGrid - Topic: Can't retrive data from the script http://www.trirand.com/blog/?page_id=393/help/cant-retrive-data-from-the-script Simple:Press Version 5.7.5.3 Casufi on Can't retrive data from the script http://www.trirand.com/blog/?page_id=393/help/cant-retrive-data-from-the-script#p14694 Help http://www.trirand.com/blog/?page_id=393/help/cant-retrive-data-from-the-script#p14694 Topic is closed I had to redefine JSONReader

]]> Wed, 10 Feb 2010 15:37:30 +0200 Casufi on Can't retrive data from the script http://www.trirand.com/blog/?page_id=393/help/cant-retrive-data-from-the-script#p14545 Help http://www.trirand.com/blog/?page_id=393/help/cant-retrive-data-from-the-script#p14545 I created Grid using the following Js

function OpenTables(){

  var colDaysNames = new Array();
  var colDaysModels = new Array();
  var DefaultGridParams = new Array();
  var DefaultColModel = new Array();
  DefaultGridParams = {
    url:'data.php',
    datatype: 'json',
    mtype: 'POST',
    height:'100%',
    rowNum:-1,
    rowList:[5,10,30],
    viewrecords: true,
    sortorder: "asc"
  };
  DefaultColModel = {
    align:'left',
    editable:true,
    edittype:'sring',
    sortable:false,
    resizable:false
  };

  colDaysNames = ['Затрата'];
  DefaultColModel['name']='cost';
  DefaultColModel['index']='cost';
  DefaultColModel['width']=100;
  colDaysModels = [DefaultColModel];
  colArrays(29, colDaysNames, colDaysModels);
  DefaultGridParams['url']='data_costs.php';
  DefaultGridParams['colNames']=colDaysNames;
  DefaultGridParams['colModel']=colDaysModels;
  DefaultGridParams['colModel']=colDaysModels;
  DefaultGridParams['caption']='Затраты';
  $("#list_cost").jqGrid(DefaultGridParams);
  $("#list_cost").jqGrid('setGridParam',{postData:{grid_type:'cost',date:'01.02.1999'},search:true});
  $("#list_cost").trigger("reloadGrid");

 }

function colArrays(days, colDaysNames, colDaysModels){
  DayInMons = days;
  for (i=1;i<=DayInMons;i++)
  {
    colDayModel = new Array();
    colDayModel['name']='day'+i;
    colDayModel['index']='day'+i;
    colDayModel['align']='right';
    colDayModel['editable']=true;
    colDayModel['edittype']='sring';
    colDayModel['sortable']=false;
    colDayModel['resizable']=false;
    colDayModel['width']=20;
    colDaysModels.push(colDayModel);
    colDaysNames.push(String(i));
  }
  return;
}

Here is the data_costs.php

<?php
require_once('setup.php');
$rowsitem = array();
$rowitem = array();
$rowarray = array();
$rowsitem['total']=1;
$rowsitem['page']=1;
$rowsitem['records']=20;
if (isset($_POST['grid_type'])) {
  if ($_POST['grid_type']=='cost') {
    if (($defaultNamespace->authenticated == 1) AND ($defaultNamespace->username != ''))
    {
      $TimeSheet = new TimeSheet();
      $TimeSheetLine = new TimeSheetLine();

      //$_POST['date']=2;

      $rowitem['id']=1;
      $rowaray['cost']='Fake title';
      for ($i = 1; $i <= 29; $i++) {
        $rowaray['day'.$i]=$i+2;
      }
      $rowitem['cell']=$rowaray;
      $rowsitem['rows']=$rowitem;
    }
  }
}

echo json_encode($rowsitem);

?>

Here is the answer on the POST request. I can se it using FireBug debugger plugin for the Firefox web browser

{"total":1,"page":1,"records":20,"rows":{"id":1,"cell":{"cost":"\u0425\u0440\u0435\u043d\u044c","day1":3,"day2":4,"day3":5,"day4":6,"day5":7,"day6":8,"day7":9,"day8":10,"day9":11,"day10":12,"day11":13,"day12":14,"day13":15,"day14":16,"day15":17,"day16":18,"day17":19,"day18":20,"day19":21,"day20":22,"day21":23,"day22":24,"day23":25}}}

But this data do not appear on the page.

]]> Thu, 04 Feb 2010 15:25:44 +0200