没有任何搜索条件的datagrid报表:
数据库:
参考代码:
前台展示:
<script type="text/javascript" charset="utf-8">
$(function(){
/***************************日志列表*********************************/
$('#process_efficiency_table').datagrid({
url:'./user/eGetEfficiency.php',
border:false,
fitColumns:true,
singleSelect:true,
pagination:true,
pageSize:10,
pageList:[10,15,20,25,100],
columns:[[
{field:'id',title:'序号'},
{field:'month',title:'月份'},
{field:'flow_sum',title:'当月流程总数(个)'},
{field:'note_sum',title:'当月流程节点数(个)'},
{field:'flow_duration',title:'当月流程总耗时(小时)'},
{field:'average_note',title:'流程平均节点数(个)'},
{field:'average_note_duration',title:'平均节点耗时(小时)'},
{field:'average_flow_duration',title:'平均流程耗时(小时)'}
]]
});
});
</script>
<table id="process_efficiency_table"></table>
后台代码:
<?php
//构造json对象,因为javascript处理类型为json
require_once '../../class/c_mysql.class.php';
if(isset($_POST['page']) && isset($_POST['rows'])){
$page = $_POST['page'];
$rows = $_POST['rows'];
$limit_begain = ($page - 1) * $rows;
$sql = "select * from efficiency order by `id` desc limit $limit_begain,$rows";
$sql_count = "select count(*) from efficiency";
//获取json格式数据
get_json($sql,$sql_count);
}
function get_json($sql,$sql_count){
$db = new c_mysql();
$db->connect();
$db->query($sql);
$db->close();
$count = 1;
while($row = $db->fetch_array()){
$row['id'] = $count;
$grid_data[] = $row;
$count++;
}
//计算总数
$db->connect();
$db->query($sql_count);
$db->close();
$row = $db->fetch_row();
$total = $row[0];
//合并json
$json = new json_data();
$json->total = $total;
$json->rows = $grid_data;
echo json_encode($json);
}
class json_data{
public $total = 10;
public $rows = array();
}
?>