|
<?php |
|
/** |
|
* PHP Grid Component |
|
* |
|
* @author Abu Ghufran <gridphp@gmail.com> - http://www.phpgrid.org |
|
* @version 2.0.0 |
|
* @license: see license.txt included in package |
|
*/ |
|
|
|
include_once("../../config.php"); |
|
|
|
include(PHPGRID_LIBPATH."inc/jqgrid_dist.php"); |
|
|
|
// Database config file to be passed in phpgrid constructor |
|
$db_conf = array( |
|
"type" => PHPGRID_DBTYPE, |
|
"server" => PHPGRID_DBHOST, |
|
"user" => PHPGRID_DBUSER, |
|
"password" => PHPGRID_DBPASS, |
|
"database" => PHPGRID_DBNAME |
|
); |
|
|
|
$g = new jqgrid($db_conf); |
|
|
|
$opt["caption"] = "Sample Grid"; |
|
$opt["multiselect"] = true; |
|
$opt["rowNum"] = 10; |
|
$g->set_options($opt); |
|
|
|
$g->table = "clients"; |
|
|
|
$col = array(); |
|
$col["title"] = ""; |
|
$col["name"] = "del"; |
|
$col["search"] = false; |
|
$col["sortable"] = false; |
|
$col["width"] = 30; |
|
$col["template"] = '<span style="vertical-align:middle; font-size:18px; margin-top:5px; padding:0px 15px 0px 10px;display:inline;cursor:hand; cursor:pointer;" class="ui-icon ui-icon-cancel" onclick="post_custom({client_id})"></span>'; |
|
$cols[] = $col; |
|
|
|
$g->set_columns($cols,true); |
|
|
|
$out = $g->render("list1"); |
|
?> |
|
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> |
|
<html> |
|
<head> |
|
<meta name="viewport" content="width=device-width, initial-scale=1"> |
|
<link rel="stylesheet" type="text/css" media="screen" href="../../lib/js/themes/redmond/jquery-ui.custom.css" /> |
|
<link rel="stylesheet" type="text/css" media="screen" href="../../lib/js/jqgrid/css/ui.jqgrid.css" /> |
|
|
|
<script src="../../lib/js/jquery.min.js" type="text/javascript"></script> |
|
<script src="../../lib/js/jqgrid/js/i18n/grid.locale-en.js" type="text/javascript"></script> |
|
<script src="../../lib/js/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script> |
|
<script src="../../lib/js/themes/jquery-ui.custom.min.js" type="text/javascript"></script> |
|
|
|
</head> |
|
<body> |
|
<div> |
|
<?php echo $out?> |
|
</div> |
|
|
|
<script> |
|
function post_custom(id) |
|
{ |
|
var request = {}; |
|
request['oper'] = 'del'; |
|
request['id'] = id; |
|
|
|
var grid = jQuery('#list1'); |
|
jQuery.ajax({ |
|
url: grid.jqGrid('getGridParam','url'), |
|
dataType: 'html', |
|
data: request, |
|
type: 'POST', |
|
error: function(res, status) { |
|
jQuery.jgrid.info_dialog(jQuery.jgrid.errors.errcap,'<div class=\"ui-state-error\">'+ res.responseText +'</div>', |
|
jQuery.jgrid.edit.bClose,{buttonalign:'right'}); |
|
}, |
|
success: function( data ) { |
|
grid.jqGrid().trigger('reloadGrid',[{jqgrid_page:1}]); |
|
} |
|
}); |
|
} |
|
</script> |
|
</body> |
|
</html> |
