master-detail-fancy

<?php

include("../lib/php/conexion_total.php");

include("../phpgrid-full-v2.0/lib/inc/jqgrid_dist.php");

// master grid
$grid = new jqgrid($db_conf);

$opt["caption"] = "Donantes";
// following params will enable subgrid -- by default first column (PK) of parent is passed as param 'id'
$opt["detail_grid_id"] = "list2";

// extra params passed to detail grid, column name comma separated PARA PDF
$opt["subgridparams"] = "id_don,nombre,apellidos,identificador";
$opt["export"] = array("filename"=>"my-file", "sheetname"=>"test", "format"=>"pdf");
$opt["export"]["range"] = "filtered";
$grid->set_options($opt);
$grid->table = "donantes";


// id beneficiario
$col = array();
$col["title"] = "id_don"; // caption of column
$col["name"] = "id_don";
$col["width"] = "50";
$col["hidden"] = true;
$col["sortable"] = true; // this column is not sortable
$col["search"] = true; // this column is not searchable
$col["editable"] =true;
$col["export"] = true; // this column will not be exported
$cols[] = $col;


// identificador beneficiario
$col = array();
$col["title"] = "identificador"; // caption of column
$col["name"] = "identificador";
$col["width"] = "40";
$col["hidden"] = false;
$col["sortable"] = true; // this column is not sortable
$col["search"] = true; // this column is not searchable
$col["editable"] =false;
$col["export"] = true; // this column will not be exported
$col["link"] = "./f_ver_listas.php?id_don={id_don}";
$col["linkoptions"] = "target='_blank'"; // extra params with <a> tag
$cols[] = $col;

// id beneficiario
$col = array();
$col["title"] = "nombre"; // caption of column
$col["name"] = "nombre";
$col["width"] = "50";
$col["hidden"] = false;
$col["sortable"] = true; // this column is not sortable
$col["search"] = true; // this column is not searchable
$col["editable"] =true;
$col["export"] = true; // this column will not be exported
$cols[] = $col;

// id beneficiario
$col = array();
$col["title"] = "apellidos"; // caption of column
$col["name"] = "apellidos";
$col["width"] = "100";
$col["hidden"] = false;
$col["sortable"] = true; // this column is not sortable
$col["search"] = true; // this column is not searchable
$col["editable"] =true;
$col["export"] = true; // this column will not be exported
$cols[] = $col;

//codigo
$col = array();
$col["title"] = "tipo_donacion"; // caption of column
$col["name"] = "tipo_donacion";
$col["width"] = "40";
$col["hidden"] = false;
$col["sortable"] = true; // this column is not sortable
$col["search"] = true; // this column is not searchable
$col["editable"] =true;
$col["export"] = true; // this column will not be exported
$cols[] = $col;

$col = array();
$col["title"] = "importe";
$col["name"] = "donacion";
$col["width"] = "50"; // not specifying width will expand to fill space
$col["align"] = "right"; // this column is not editable
$col["sortable"] = true; // this column is not sortable
$col["search"] = true; // this column is not searchable
//$col["linkoptions"] = "target='_blank'"; // extra params with <a> tag
$col["editable"] = true;
$col["export"] = true; // this column will not be exported
$cols[] = $col;

$col = array();
$col["title"] = "incidencia";
$col["name"] = "detail";
$col["default"] = "<a class='fancybox' onclick='jQuery(\"#list1\").setSelection({id_don});' href='#box_detail_grid' stylt='width: 500px'>incidencia</a>";
$col["width"] = "40";
$col["editable"] = true;
$col["search"] = false;
$col["export"] = false;
$cols[] = $col;

$grid->set_columns($cols);

$grid->set_actions(array(
						"add"=>false, // allow/disallow add
						"edit"=>false, // allow/disallow edit
						"delete"=>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" => "advance" // show single/multi field search condition (e.g. simple or advance)
					)
				);

$out_master = $grid->render("list1");

// detail grid
$grid = new jqgrid($db_conf);

$opt = array();
$opt["sortname"] = 'id_incid'; // by default sort grid by this field
$opt["sortorder"] = "desc"; // ASC or DESC
$opt["height"] = ""; // autofit height of subgrid
$opt["caption"] = "INCIDENCIAS"; // caption of grid
$opt["multiselect"] = true; // allow you to multi-select through checkboxes

// fill detail add form, with parent id
$opt["add_options"]["afterShowForm"] = "function(formid){ var selr = jQuery('#list1').jqGrid('getGridParam','selrow'); $('#id_don').val(jQuery('#list1').jqGrid('getCell', selr, 'id_don'));  }";

// Check if master record is selected before detail addition
$opt["add_options"]["beforeInitData"] = "function(formid){ var selr = jQuery('#list1').jqGrid('getGridParam','selrow'); if (!selr) { alert('Please select master record first'); return false; } }";
$grid->set_options($opt);

$grid->set_actions(array(
						"add"=>true, // allow/disallow add
						"edit"=>true, // allow/disallow edit
						"delete"=>true, // allow/disallow delete
						"rowactions"=>false, // show/hide row wise edit/del/save option
						"autofilter" => true, // show/hide autofilter for search
						"search" => false, // show single/multi field search condition (e.g. simple or advance)
						"export"=>true // show/hide export to excel option
					)
				);


// receive id, selected row of parent grid
$id = intval($_GET["rowid"]);
$nombre = $_GET["nombre"];
$apellidos = $_GET["apellidos"];
$identificador = $_GET["identificador"];
$cid = intval($_GET["id_don"]);

// for non-int fields as PK
// $id = (empty($_GET["rowid"])?0:$_GET["rowid"]);

// and use in sql for filteration
$grid->select_command = "SELECT id_incid, id_don, codigo, incidencia, fecha, fecha_cierre, '$nombre'  as 'nombre', '$apellidos' as 'apellidos' FROM incidencias WHERE id_incid = $cid";
// this db table will be used for add,edit,delete
$grid->table = "incidencias";

$cols = array();

$col = array();
$col["title"] = "id_don"; // caption of column
$col["name"] = "id_don"; // field name, must be exactly same as with SQL prefix or db field
$col["editable"] = false;
$col["width"] = "10";
$col["hidden"] = true;
$cols[] = $col;

$col = array();
$col["title"] = "id_incid";
$col["name"] = "id_incid";
$col["width"] = "10";
$col["editable"] = false;
/* set detail form client_id as readonly and for add dialog only
$col["editoptions"] = array("readonly"=>"readonly", "style"=>"border:0");*/
$col["hidden"] = true;
$cols[] = $col;

$col = array();
$col["title"] = "nombre";
$col["name"] = "nombre";
$col["width"] = "40'";
$col["editable"] = false;
/* set detail form client_id as readonly and for add dialog only
$col["editoptions"] = array("readonly"=>"readonly", "style"=>"border:0");*/
$col["show"]["edit"] = false;
$cols[] = $col;

$col = array();
$col["title"] = "apellidos";
$col["name"] = "apellidos";
$col["width"] = "50'";
$col["editable"] = false;
/* set detail form client_id as readonly and for add dialog only
$col["editoptions"] = array("readonly"=>"readonly", "style"=>"border:0");*/
$col["show"]["edit"] = false;
$cols[] = $col;

$col = array();
$col["title"] = "fecha";
$col["name"] = "fecha";
$col["width"] = "15";
$col["editable"] = true; // this column is editable
# format as date
$col["formatter"] = "date";
# opts array can have these options: http://api.jqueryui.com/datepicker/
$col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'d-m-Y', "opts" => array("changeYear" => true, "dateFormat"=>'yy-mm-dd', "minDate"=>"15-07-08"));
$cols[] = $col;

$col = array();
$col["title"] = "incidencia";
$col["name"] = "incidencia";
$col["width"] = "100";
$col["editable"] = true; // this column is editable
$col["edittype"] = "textarea"; // render as textarea on edit
$col["editoptions"] = array("rows"=>20, "cols"=>32); // with these attributes
$cols[] = $col;

$col = array();
$col["title"] = "fecha cierre";
$col["name"] = "fecha_cierre";
$col["width"] = "15";
$col["editable"] = true; // this column is editable
# format as date
$col["formatter"] = "date";
# opts array can have these options: http://api.jqueryui.com/datepicker/
$col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'d-m-Y', "opts" => array("changeYear" => true, "dateFormat"=>'yy-mm-dd', "minDate"=>"15-07-08"));
$cols[] = $col;

$grid->set_columns($cols);
$e["on_insert"] = array("add_incidencia", null, true);
$grid->set_events($e);

function add_incidencia(&$data)
{
	$id = intval($_GET["rowid"]);
	$data["params"]["id_incid"] = $id;
}

// set few params
$opt["caption"] = "Sample Grid";
$opt["multiselect"] = true;
$opt["export"]["range"] = "filtered"; // or "all"
$opt["form"]["position"] = "center"; // or "all"

// # set add/edit dialog width ... to apply css (see below)

$opt["add_options"] = array("recreateForm" => true, "closeAfterEdit"=>true, 'width'=>'600');
$opt["edit_options"] = array("recreateForm" => true, "closeAfterEdit"=>true, 'width'=>'600');
$opt["add_options"]["topinfo"] = "Add New Client Information. Enter client name, gender and company name.<br />&nbsp;";
$opt["add_options"]["bottominfo"] = "This text is dialog footer text";


// generate grid output, with unique grid name as 'list1'
$out_detail = $grid->render("list2");
?>
<!doctype html>
<html>
<head>
	<meta charset="utf-8">

    <link rel="stylesheet" type="text/css" href="../phpgrid-full-v2.0/lib/js/themes/flick/jquery-ui.custom.css">
	<link rel="stylesheet" type="text/css" href="../phpgrid-full-v2.0/lib/js/jqgrid/css/ui.jqgrid.css">

    <script src="../phpgrid-full-v2.0/lib/js/jquery.min.js"></script>
    <script src="../phpgrid-full-v2.0/lib/js/jqgrid/js/i18n/grid.locale-en.js"></script>
    <script src="../phpgrid-full-v2.0/lib/js/jqgrid/js/i18n/grid.locale-es.js"></script>
    <script src="../phpgrid-full-v2.0/lib/js/jqgrid/js/jquery.jqGrid.min.js"></script>
	<script src="../phpgrid-full-v2.0/lib/js/themes/jquery-ui.custom.min.js"></script></script>


	<!-- Add fancyBox main JS and CSS files -->
	<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>
	<style>
	/* required for add/edit dialog overlapping */
	.fancybox-overlay {
		z-index:940;
	}
	</style>

	<div style="margin:10px">
	<?php echo $out_master ?>
	</div>

	<div id='box_detail_grid' style='display:none'>
	<?php echo $out_detail?>
	</div>

	<script>
	$(document).ready(function() {
		$('.fancybox').fancybox({
			afterClose : function() { $('#list1').trigger("reloadGrid"); }
		});
	});
	</script>

</body>
</html>