| Server IP : 182.53.201.61 / Your IP : 216.73.217.175 Web Server : Apache/2.2.15 (Fedora) System : Linux km10.dyndns.org 2.6.31.5-127.fc12.i686.PAE #1 SMP Sat Nov 7 21:25:57 EST 2009 i686 User : apache ( 48) PHP Version : 5.3.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/phpgrid/demos/loading/ |
Upload File : |
<?php
/**
* PHP Grid Component
*
* @author Abu Ghufran <gridphp@gmail.com> - http://www.phpgrid.org
* @version 1.5.2
* @license: see license.txt included in package
*/
// include db config
include_once("../../config.php");
// include and create object
include(PHPGRID_LIBPATH."inc/jqgrid_dist.php");
$g = new jqgrid();
// set few params
$grid["caption"] = "Loading data from Array";
$grid["multiselect"] = true;
$grid["ignoreCase"] = true; // do case insensitive sorting
$grid["export"] = array("format"=>"pdf", "filename"=>"my-file", "heading"=>"Array Data", "orientation"=>"landscape", "paper"=>"a4");
$g->set_options($grid);
$name = array('Pepsi 1.5 Litre', 'Sprite 1.5 Litre', 'Cocacola 1.5 Litre', 'Dew 1.5 Litre', 'Nestle 1.5 Litre');
for ($i = 0; $i < 200; $i++)
{
$data[$i]['id'] = $i+1;
$data[$i]['code'] = $name[rand(0, 4)][0].($i+5);
$data[$i]['name'] = $name[rand(0, 4)];
// to simulate case insensitive sort
$data[$i]['name'] = ($i%2)?strtoupper($data[$i]['name']):$data[$i]['name'];
$data[$i]['cost'] = rand(0, 100)." USD";
$data[$i]['quantity'] = rand(0, 100);
$data[$i]['discontinued'] = rand(0, 1);
$data[$i]['email'] = 'buyer_'. rand(0, 100) .'@google.com';
$data[$i]['more_options'] = "<a class='fancybox' href='http://upload.wikimedia.org/wikipedia/commons/4/4a/Logo_2013_Google.png'><img height=25 src='http://ssl.gstatic.com/ui/v1/icons/mail/logo_default.png'></a>";
}
// pass data in table param for local array grid display
$g->table = $data; // blank array(); will show no records
// If you want to customize columns params
$col = array();
$col["title"] = "Id"; // caption of column
$col["name"] = "id";
$col["width"] = "10";
$cols[] = $col;
$col = array();
$col["title"] = "Code"; // caption of column
$col["name"] = "code";
$col["width"] = "10";
$cols[] = $col;
$col = array();
$col["title"] = "Name"; // caption of column
$col["name"] = "name";
$col["width"] = "40";
$cols[] = $col;
$col = array();
$col["title"] = "Cost"; // caption of column
$col["name"] = "cost";
$col["width"] = "10";
$cols[] = $col;
$col = array();
$col["title"] = "Quantity"; // caption of column
$col["name"] = "quantity";
$col["width"] = "10";
$cols[] = $col;
$col = array();
$col["title"] = "Email"; // caption of column
$col["name"] = "email";
$col["width"] = "40";
$col["formatter"] = "function(cellvalue, options, rowObject){ return my_custom_link(cellvalue, options, rowObject);}";
$col["unformat"] = "function(cellvalue, options, rowObject){ return cellvalue; }";
$cols[] = $col;
# Custom made column to show link, must have default value as it's not db driven
$col = array();
$col["title"] = "Details";
$col["name"] = "more_options";
$col["width"] = "30";
$col["align"] = "center";
$col["search"] = false;
$col["sortable"] = false;
$cols[] = $col;
$g->set_columns($cols);
$g->set_actions(array(
"add"=>false, // allow/disallow add
"edit"=>false, // allow/disallow edit
"delete"=>false, // allow/disallow delete
"view"=>true, // allow/disallow delete
"rowactions"=>false, // show/hide row wise edit/del/save option
"export"=>true, // show/hide export to excel option
"autofilter" => true, // show/hide autofilter for search
"search" => false // show single/multi field search condition (e.g. simple or advance)
)
);
// render grid
$out = $g->render("list1");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html>
<head>
<link rel="stylesheet" type="text/css" media="screen" href="../../lib/js/themes/redmond/jquery-ui.custom.css"></link>
<link rel="stylesheet" type="text/css" media="screen" href="../../lib/js/jqgrid/css/ui.jqgrid.css"></link>
<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>
<link type="text/css" rel="stylesheet" href="//cdn.jsdelivr.net/fancybox/2.1.4/jquery.fancybox.css" />
<script type="text/javascript" src="//cdn.jsdelivr.net/fancybox/2.1.4/jquery.fancybox.js"></script>
</head>
<body>
<script>
function my_custom_link(cellvalue, options, rowObject)
{
return '<a href="mailto:'+cellvalue+'">'+cellvalue+'</a>';
}
</script>
<div style="margin:10px">
<?php echo $out?>
</div>
<script>
$(document).ready(function() {
$('.fancybox').fancybox();
});
</script>
</body>
</html>