Created
December 6, 2018 18:14
-
-
Save oscaremmanuel/363271082dd6a2aeb3dc6b91fd17289b to your computer and use it in GitHub Desktop.
grid source code
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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 | |
*/ | |
error_reporting(E_ALL); | |
//include_once("auth.php"); | |
$db_conf = array(); | |
$db_conf["type"] = "pdo"; | |
$db_conf["server"] = "firebird:host=localhost/30500;dbname=X:/Data/REDSEGURO.fdb"; | |
$db_conf["user"] = "SYSDBA"; | |
$db_conf["password"] = "masterkey"; | |
$db_conf["database"] = ""; | |
include("/lib/inc/jqgrid_dist.php"); | |
$g = new jqgrid($db_conf); | |
$g->debug = 0; | |
// set few params | |
$grid["caption"] = "Afiliados Discapacidad"; | |
$grid["rowList"] = array(10,20,30,'All'); | |
$opt["responsive"] = true; | |
$opt["globalsearch"] = true; | |
$opt["altRows"] = true; | |
$opt["rowNum"] = 10; | |
$opt["rowheight"] = 30; | |
$opt["add_options"]["width"] = "500"; | |
$opt["edit_options"]["width"] = "500"; | |
$opt["view_options"]["width"] = "500"; | |
$opt["height"] = "100%"; | |
$opt["resizable"] = true; // defaults to false | |
$g->set_options($grid); | |
$g->set_actions(array( | |
"add"=>true, // allow/disallow add | |
"edit"=>true, // allow/disallow edit | |
"delete"=>true, // allow/disallow delete | |
"showhidecolumns"=>true, | |
"rowactions"=>true, // show/hide row wise edit/del/save option | |
"autofilter" => true, // show/hide autofilter for search | |
"search" => "group", // show/hide autofilter for search | |
) | |
); | |
// set database table for CRUD operations | |
$g->table = "SUCURSALES"; | |
$g->select_command = "SELECT * FROM SUCURSALES"; | |
// 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> | |
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"> | |
<title>PHP Grid Framework Demos | www.phpgrid.org</title> | |
<meta name="viewport" content="width=device-width, initial-scale=1.0"> | |
<meta name="description" content=""> | |
<meta name="author" content=""> | |
<!-- Le styles --> | |
<link href="bootstrap/css/bootstrap.min.css" rel="stylesheet"> | |
<style type="text/css"> | |
body { | |
padding-top: 60px; | |
padding-bottom: 0px; | |
} | |
.sidebar-nav { | |
padding: 9px 0; | |
} | |
.nav | |
{ | |
margin-bottom:10px; | |
} | |
.accordion-inner a { | |
font-size: 13px; | |
font-family:tahoma; | |
} | |
.alert { | |
padding:8px 14px 8px 14px; | |
} | |
</style> | |
<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/jquery.jqGrid.min.js" type="text/javascript"></script> | |
<script src="lib/js/themes/jquery-ui.custom.min.js" type="text/javascript"></script> | |
<!-- to enable spanish --> | |
<script src="lib/js/jqgrid/js/i18n/grid.locale-es.js" type="text/javascript"></script> | |
</head> | |
<body> | |
<div style="margin:100px"> | |
<?php echo $out?> | |
</div> | |
</body> | |
</html> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment