function getGrid($idUsuario, $CodCaratula, $NroExpediente, $NroCarpeta, $tipoJuicio)
{
$idCheque = "0";
if (isset($_REQUEST["id"])) {
$idCheque = $_REQUEST["id"];
}
$pagina = 1;
if (isset($_REQUEST["pagina"])) {
$pagina = $_REQUEST["pagina"];
}
$showProcessMsg = false;
$idAbogado = $idUsuario;
$params = array();
$params[":idAbogado"] = $idAbogado;
$where = "";
$ob = " ORDER BY jt_numerocarpeta ";
if ($CodCaratula != "") {
$params[":CodCaratula"] = str_replace("-", "", $CodCaratula);
$where .= " AND NVL(jt_demandante, '') || 'C/' || NVL(jt_demandado, '') || ' ' || jt_caratula\n LIKE '%' || UPPER(:CodCaratula) ||'%' ";
}
if ($NroExpediente != "") {
$params[":NroExpediente"] = str_replace("-", "", $NroExpediente);
$where .= " AND JT_NROEXPEDIENTE = :NroExpediente ";
}
if ($NroCarpeta != "") {
$params[":NroCarpeta"] = str_replace("-", "", $NroCarpeta);
$where .= " AND JT_NUMEROCARPETA = :NroCarpeta ";
}
if (is_numeric($tipoJuicio)) {
if ($tipoJuicio != "" and $tipoJuicio > "0") {
$params[":tipoJuicio"] = str_replace("-", "", $tipoJuicio);
$where .= " AND JT_IDTIPO = :tipoJuicio ";
}
}
$sql = ObtenerListaJuiciosEnTramite($idAbogado, $where, $ob);
$grilla = new Grid(1, 15);
$grilla->addColumn(new Column("Carpeta ", 0, true, false, -1, "", "", "", -1, false - 1));
$grilla->addColumn(new Column("Caratula ", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("Expediente ", 0, true, false, -1, "", "", "", -1, false));
//$grilla->addColumn(new Column("ID", 0, true, false, -1, "", "", "", -1, false));
//$grilla->addColumn(new Column("ESTADO", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("", 0, true, false, -1, "btnPdf ", "/Admin-Web-Form", "", -1, true, -1, "Juicio"));
$grilla->addColumn(new Column("", 0, true, false, -1, "btnPdf", "/Admin-Web-Form", "", -1, true, -1, "Pericias"));
$grilla->addColumn(new Column("", 0, true, false, -1, "btnPdf ", "/Admin-Web-Form", "", -1, true, -1, "Eventos"));
$grilla->addColumn(new Column("", 0, true, false, -1, "btnPdf", "/Admin-Web-Form", "", -1, true, -1, "Sentencia"));
$grilla->setColsSeparator(false);
$grilla->setPageNumber($pagina);
$grilla->setParams($params);
$grilla->setRowsSeparator(true);
$grilla->setRowsSeparatorColor("#c0c0c0");
$grilla->setShowTotalRegistros(true);
$grilla->setSql($sql);
$grilla->setUseTmpIframe(true);
$grilla->addColOpenExtWindows("CR");
$grilla->addColOpenExtWindows("TEX");
return $grilla->Draw(false);
}
function getGrid($idUsuario, $CodCaratula, $NroExpediente, $NroCarpeta, $tipoJuicio)
{
$idCheque = "0";
if (isset($_REQUEST["id"])) {
$idCheque = $_REQUEST["id"];
}
$pagina = 1;
if (isset($_REQUEST["pagina"])) {
$pagina = $_REQUEST["pagina"];
}
$showProcessMsg = false;
$idAbogado = $idUsuario;
$params = array();
$params[":idAbogado"] = $idAbogado;
$where = "";
$ob = " ORDER BY jt_numerocarpeta ";
if ($CodCaratula != "") {
$params[":CodCaratula"] = str_replace("-", "", $CodCaratula);
$where .= " AND NVL(jt_demandante, '') || 'C/' || NVL(jt_demandado, '') || ' ' || jt_caratula\n LIKE '%' || UPPER(:CodCaratula) ||'%' ";
}
if ($NroExpediente != "") {
$params[":NroExpediente"] = str_replace("-", "", $NroExpediente);
$where .= " AND JT_NROEXPEDIENTE = :NroExpediente ";
}
if ($NroCarpeta != "") {
$params[":NroCarpeta"] = str_replace("-", "", $NroCarpeta);
$where .= " AND JT_NUMEROCARPETA = :NroCarpeta ";
}
if (is_numeric($tipoJuicio)) {
if ($tipoJuicio != "" and $tipoJuicio > "0") {
$params[":tipoJuicio"] = str_replace("-", "", $tipoJuicio);
$where .= " AND JT_IDTIPO = :tipoJuicio ";
}
}
$sql = ObtenerListaJuiciosEnTramite($idAbogado, $where, $ob);
$grilla = new GridDos(1, 15);
//titulo an vis delet colhi but act cls mx ust
$grilla->addColumn(new Column("Carpeta", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("Caratula", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("Expediente", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("J", 0, true, false, -1, "btnpdf", "/index.php?pageid=99", "", -1, true, -1, "Juicio"));
$grilla->addColumn(new Column("P", 0, true, false, -1, "btnPdf", "/index.php?pageid=104", "", -1, true, -1, "Pericias"));
$grilla->addColumn(new Column("E", 0, true, false, -1, "btnPdf", "/EventosWebForm", "", -1, true, -1, "Eventos"));
$grilla->addColumn(new Column("S", 0, true, false, -1, "btnPdf", "/SentenciaWebForm", "", -1, true, -1, "Sentencia"));
$grilla->setColsSeparator(false);
$grilla->setPageNumber($pagina);
$grilla->setParams($params);
$grilla->setRowsSeparator(true);
$grilla->setRowsSeparatorColor("#c0c0c0");
$grilla->setShowTotalRegistros(true);
$grilla->setSql($sql);
$grilla->setUseTmpIframe(false);
$grilla->setTableStyle("GridTableCiiu");
$grilla->setNameParamGET("NroJuicio");
return $grilla->Draw(false);
}
