Print Page - Group View Unload Data

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>

EasyUI Forum

General Category => EasyUI for jQuery => Topic started by: dearsh on September 02, 2013, 09:49:02 AM