Forum


15:25

03/02/2010

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
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.
Most Users Ever Online: 715
Currently Online:
81 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66