Untitled

<?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_DBNAME2
                );

$g = new jqgrid($db_conf);

$opt["caption"] = "PUEBA";
$opt["toolbar"] = "bottom";
$opt["rowNum"] = 12;
$opt["add_options"] = array("recreateForm" => true, "closeAfterEdit"=>true, 'width'=>'780');
$opt["edit_options"] = array("recreateForm" => true, "closeAfterEdit"=>true, 'width'=>'780');
$g->set_options($opt);


$g->set_actions(array("add"=>true, "edit"=>true, "bulkedit"=>false, "delete"=>true, "rowactions"=>false, "autofilter" => true, "search" => "simple"));

$g->select_command = "SELECT pr.codPrueba, pr.codPatologia, pa.patologia, pr.codDiagnostico, di.diagnostico
						FROM prueba pr
						INNER JOIN gen_patologia pa ON pr.codPatologia=pa.codPatologia
						INNER JOIN gen_diagnostico di ON pr.codDiagnostico=di.codDiagnostico";

// set table for CRUD operations
$g->table = "prueba";

// Id
$col = array();
$col["title"] = "Id";
$col["name"] = "codPrueba";
$col["hidden"] = true;
$cols[] = $col;

$col = array();
$col["title"] = "Patologia";
$col["name"] = "codPatologia";
$col["editable"] = true;
$col["editrules"] = array("required"=>true);
$col["hidden"] = true;
$cols[] = $col;

$col = array();
$col["title"] = "Diagnostico";
$col["name"] = "codDiagnostico";
$col["editable"] = true;
$col["hidden"] = true;
$col["editrules"] = array("required"=>true);
$cols[] = $col;

$col = array();
$col["title"] = "Patologia";
$col["name"] = "patologia";
$col["editable"] = true;
$col["width"] = "130";
$col["editoptions"] = array("size"=>70, "maxlength"=>"70", "onchange"=>array("sql"=>"SELECT codDiagnostico AS k, concat(diagnostico,codPatologia) AS v FROM gen_diagnostico WHERE codPatologia='{codPatologia}' ORDER BY diagnostico", "update_field"=>"diagnostico"));
$col["formatter"] = "autocomplete"; // autocomplete
$col["formatoptions"] = array("sql"=>"SELECT codPatologia AS k, patologia AS v FROM gen_patologia ORDER BY patologia", "search_on"=>"patologia", "update_field"=>"codPatologia");
$cols[] = $col;

$col = array();
$col["title"] = "Diagnostico";
$col["name"] = "diagnostico";
$col["editable"] = true;
$col["width"] = "150";
$col["editoptions"] = array("size"=>90, "maxlength" => "90");
$col["formatter"] = "autocomplete"; // autocomplete
$col["formatoptions"] = array("sql"=>"SELECT codDiagnostico AS k, diagnostico AS v FROM gen_diagnostico WHERE codPatologia = '{codPatologia}' ORDER BY diagnostico", "search_on"=>"diagnostico", "update_field"=>"codDiagnostico");
$cols[] = $col;

$g->set_columns($cols);

// 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/base/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>
    <script src="../../lib/js/ckeditor/ckeditor.js" type="text/javascript"></script>
</head>
<body>

    <div>
    <?php echo $out?>
    </div>
</body>
</html>