I have this script. I dont know whyd data grid can load data from my query.Please help me..
BR
- dearsh-
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="keywords" content="jquery,ui,easy,easyui,web">
<meta name="description" content="easyui help you build your web page easily!">
<title>Group Rows in DataGrid - jQuery EasyUI Demo</title>
<link rel="stylesheet" type="text/css" href="
http://www.jeasyui.com/easyui/themes/default/easyui.css">
<link rel="stylesheet" type="text/css" href="
http://www.jeasyui.com/easyui/themes/icon.css">
<link rel="stylesheet" type="text/css" href="
http://www.jeasyui.com/easyui/demo/demo.css">
<script type="text/javascript" src="../../library/jquery-1.7.2.min.js"></script>
<script type="text/javascript" src="../../library/jquery.easyui.min.js"></script>
<script type="text/javascript" src="
http://www.jeasyui.com/easyui/datagrid-groupview.js"></script>
</head>
<body>
<h2>Group Rows in DataGrid</h2>
<div class="demo-info" style="margin-bottom:10px">
<div class="demo-tip icon-tip"> </div>
<div>This sample shows how to group rows via specified column.</div>
</div>
<table class="easyui-datagrid" title="Group Rows in DataGrid" style="width:700px;height:250px"
data-options="
singleSelect:true,
collapsible:true,
rownumbers:true,
fitColumns:true,
data:data,
view:groupview,
groupField:'lokasi_awal',
groupFormatter:function(value,rows){
return value + ' - ' + rows.length + ' Item(s)';
}
">
<thead>
<tr>
<th data-options="field:'lokasi_awal',width:80">Lokasi Awal</th>
<th data-options="field:'lokasi_tujuan',width:100">Lokasi Tujuan</th>
<th data-options="field:'status',width:80,align:'right'">Status</th>
<th data-options="field:'waktu',width:80,align:'right'">Waktu</th>
<th data-options="field:'no_pengirim',width:250">No. Pengirim</th>
</tr>
</thead>
</table>
<script type="text/javascript">
var data = json_encode($result);
/*
var data = [{"lokasi_awal":"RAGUNAN","lokasi_tujuan":"MAMPANG","status":"LANCAR","waktu":"2013-09-02 21:58:15","no_pengirim":"085655443242"},{"lokasi_awal":"RAGUNAN","lokasi_tujuan":"MAMPANG","status":"MACET","waktu":"2013-08-30 22:04:38","no_pengirim":"+6285655443242"},{"lokasi_awal":"SLIPI","lokasi_tujuan":"RAWAMANGUN","status":"LANCAR","waktu":"2013-08-30 22:04:29","no_pengirim":"+6285655443242"},{"lokasi_awal":"CAWANG","lokasi_tujuan":"SLIPI","status":"MACET","waktu":"2013-09-02 21:58:51","no_pengirim":"085655443242"},{"lokasi_awal":"CAWANG","lokasi_tujuan":"SLIPI","status":"LANCAR","waktu":"2013-08-30 22:04:33","no_pengirim":"+6285655443242"},{"lokasi_awal":"PANCORAN","lokasi_tujuan":"TEBET","status":"LANCAR","waktu":"2013-08-30 22:04:41","no_pengirim":"+6285655443242"},{"lokasi_awal":"PANCORAN","lokasi_tujuan":"TEBET","status":"MACET","waktu":"2013-09-02 21:57:42","no_pengirim":"085655443242"},{"lokasi_awal":"LENTENG AGUNG","lokasi_tujuan":"MARGONDA","status":"LANCAR","waktu":"2013-08-30 22:04:44","no_pengirim":"+6285655443242"},{"lokasi_awal":"KALIDERES","lokasi_tujuan":"CENGKARENG","status":"MACET","waktu":"2013-09-02 21:57:05","no_pengirim":"085655443242"},{"lokasi_awal":"KALIDERES","lokasi_tujuan":"CENGKARENG","status":"LANCAR","waktu":"2013-08-30 22:04:47","no_pengirim":"+6285655443242"},{"lokasi_awal":"RAGUNAN","lokasi_tujuan":"BUNCIT","status":"LANCAR","waktu":"2013-09-02 21:58:15","no_pengirim":"085655443242"}];
*/
</script>
<?php
include '../../library/conn.php';
$rs = mysql_query("SELECT
A.nama_lokasi AS lokasi_awal,
B.nama_lokasi AS lokasi_tujuan,
C.nama_status_lalin AS status,
D.waktu AS waktu,
D.no_pengirim AS no_pengirim
FROM tbl_info_lalin D
INNER JOIN v_lokasi_awal A ON D.id_lokasi_awal = A.id
INNER JOIN v_lokasi_tujuan B ON D.id_lokasi_tujuan = B.id
INNER JOIN tbl_status_lalin C ON D.id_status_lalin = C.id");
$items = array();
while($row = mysql_fetch_object($rs)){
array_push($items, $row);
}
$result["data"] = $items;
echo json_encode($result);
?>
</body>
</html>
