function getGridDatosESOP($pagina = -1, $codactividad = 0, $codigo = 0, $descripcion = '', $inFiltroRiesgos = '') { validarSessionServer(isset($_SESSION["isCliente"])); if ($pagina == -1) { $pagina = 1; } if (isset($_REQUEST["pagina"])) { $pagina = $_REQUEST["pagina"]; } $ob = ''; if (isset($_REQUEST["ob"])) { $ob = $_REQUEST["ob"]; } $showProcessMsg = false; $result = ''; if ($inFiltroRiesgos != '') { $inFiltroRiesgos = StringToArray($inFiltroRiesgos); foreach ($inFiltroRiesgos as $key => $value) { if ($result != '') { $result .= ", "; } $result .= " '" . $value . "' "; } } $sql = ObtenerDatosESOP($descripcion, $codigo, $result); $params = array(); if (isset($_SESSION["IDACTIVIDAD"]) and $_SESSION["IDACTIVIDAD"] != '') { $params[":codactividad"] = $_SESSION["IDACTIVIDAD"]; } else { $params[":codactividad"] = 0; } if ($codigo != '') { $params[":ESOP"] = '%' . $codigo . '%'; } else { if ($descripcion != '') { $params[":descripcion"] = '%' . $descripcion . '%'; } } $grilla = new gridAjax(10, 10); /* $title; $width = 0; $visible = true; $deletedRow = false; $colHint = -1; $buttonClass = ""; $actionButton = ""; $cellClass = ""; $maxChars = -1; $useStyleForTitle = true; $numCellHide = -1; $titleHint = ""; $mostrarEspera = false; $msgEspera = ""; $inputType = "button"; $colChecked = -1; $colButtonClass = -1; */ $grilla->addColumn(new columnAjax("Seleccionar", 90, true, false, -1, "XbtnSeleccionar", "", "gridColAlignCenter", -1, false, -1, "", false, "", "checkbox", 2)); $grilla->addColumn(new columnAjax("Codigo", 75, true, false, -1, "", "", "gridColAlignCenter", -1, false, -1, "", false, "")); $grilla->addColumn(new columnAjax("Descripcion", 300, true, false, -1, "", "", "gridColAlignLeft", -1, false)); $grilla->addColumn(new columnAjax("Grupo", 150, true, false, -1, "", "", "gridColAlignLeft", -1, false)); //----------------------------- $columnDetalle = new columnAjax("Detalle", 0, true, false, -1, "btnDetalleRiesgo", "", "gridColAlignLeft", -1, false); $columnDetalle->setFunctionAjax("showDetalleRiesgo"); $grilla->addColumn($columnDetalle); //----------------------------- $grilla->setOrderBy($ob); $grilla->setPageNumber($pagina); $grilla->setParams($params); $grilla->setShowProcessMessage(true); $grilla->setShowTotalRegistros(true); $grilla->setSql($sql); $grilla->setTableStyle("GridTableCiiu"); $grilla->setUseTmpIframe(false); //funciones gridajax $grilla->setFuncionAjaxJS("BuscarGridDatosESOP"); $arrayCodigos = Array_DatosESOPsoloActivos($_SESSION["IDACTIVIDAD"]); $grilla->setBackGroundColumns($arrayCodigos, '#3F4C6B', 1); $grilla->Draw(); }