function getGrid()
{
$Contrato = $_SESSION["idUsuario"];
$idCheque = "0";
if (isset($_REQUEST["idCheque"])) {
$idCheque = $_REQUEST["idCheque"];
}
//echo "<br> cont ".$Contrato."<br> che ".$idCheque."<br>";
$pagina = 1;
if (isset($_REQUEST["pagina"])) {
$pagina = $_REQUEST["pagina"];
}
$showProcessMsg = false;
$params = array();
$where = "";
$sql = ObtenerChequeDetalle($idCheque);
$grilla = new GridDos(10, 15);
$grilla->addColumn(new Column("tipo", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("numero", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("conpago", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("demandante", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("demandado", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("importe", 0, true, false, -1, "", "", "", -1, false));
$grilla->setColsSeparator(false);
$grilla->setPageNumber($pagina);
$grilla->setParams($params);
$grilla->setRowsSeparator(true);
$grilla->setRowsSeparatorColor("#c0c0c0");
$grilla->setShowTotalRegistros(true);
$grilla->setSql($sql);
$grilla->setUseTmpIframe(true);
return $grilla->Draw(false);
}
function getGrid($NroJuicio)
{
$pagina = 1;
if (isset($_REQUEST["pagina"])) {
$pagina = $_REQUEST["pagina"];
}
$showProcessMsg = false;
$params = array();
$params[":NroJuicio"] = $NroJuicio;
$sql = ObtenerPeritajes();
$grilla = new GridDos(10, 10);
$grilla->addColumn(new Column("Pericia", 0, true, false, -1, "", "", "", -1, false - 1));
$grilla->addColumn(new Column("F. Notificacion", 0, true, false, -1, "", "", "", -1, false - 1));
$grilla->addColumn(new Column("F. Pericia", 0, true, false, -1, "", "", "", -1, false - 1));
$grilla->addColumn(new Column("F. Venc. Impugnacion", 0, true, false, -1, "", "", "", -1, false - 1));
$grilla->addColumn(new Column("Impugnacion", 0, true, false, -1, "", "", "", -1, false - 1));
$grilla->addColumn(new Column("Accion", 0, true, false, -1, "", "", "", -1, false - 1));
$grilla->addColumn(new Column("idjuicioentramite", 0, true, false, -1, "", "", "", -1, false - 1));
$grilla->addColumn(new Column("Edit", 0, true, false, -1, "btnPdf", "/index.php?pageid=105&EDIT", "", -1, true, -1, "Edita"));
$grilla->addColumn(new Column("Del", 0, true, false, -1, "btnPdf", "/index.php?pageid=105&DELETE", "", -1, true, -1, "Elimina"));
$grilla->setColsSeparator(true);
$grilla->setPageNumber($pagina);
$grilla->setParams($params);
$grilla->setRowsSeparator(true);
$grilla->setRowsSeparatorColor("#c0c0c0");
$grilla->setShowTotalRegistros(true);
$grilla->setSql($sql);
$grilla->setUseTmpIframe(false);
$grilla->setTableStyle("GridTableCiiu");
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);
}
function getGrid()
{
$Contrato = $_SESSION["usuario"];
$ob = "2";
if (isset($_REQUEST["ob"])) {
$ob = $_REQUEST["ob"];
}
$pagina = 1;
if (isset($_REQUEST["pagina"])) {
$pagina = $_REQUEST["pagina"];
}
$showProcessMsg = false;
$params = array();
$where = "";
$sql = ObtenerChequesDisponible($Contrato);
$grilla = new GridDos(1, 15);
$grilla->addColumn(new Column("", 0, true, false, -1, "btnLupa ", "/index.php?pageid=96", "", -1, true, -1, "Mostrar Detalle"));
$grilla->addColumn(new Column("fecha", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("cheque", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("importe", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("beneficiario", 0, true, false, -1, "", "", "", -1, false));
$pdfCertificado = "/PDFCertificadoRetencionReport";
// http://legales.provinciart.com.ar:8080/CertificadoRetencionReport.aspx
$grilla->addColumn(new Column("CR", 0, true, false, -1, "btnPdf", $pdfCertificado, "", -1, true, -1, "Detalle"));
$pdfOrdenPago = "/PDFOrdenPagoReport";
//"http://legales.provinciart.com.ar:8080/OrdenPagoReport.aspx";
$grilla->addColumn(new Column("OP", 0, true, false, -1, "btnPdf", $pdfOrdenPago, "", -1, true, -1, "Detalle"));
//$grilla->addColumn(new Column("ordenpago", 0, true, false, -1, "", "", "", -1, false));
$grilla->setColsSeparator(false);
$grilla->setPageNumber($pagina);
$grilla->setParams($params);
$grilla->setRowsSeparatorColor("#c0c0c0");
$grilla->setShowTotalRegistros(true);
$grilla->setSql($sql);
$grilla->setUseTmpIframe(false);
$grilla->setTableStyle("GridTableCiiu");
///////METODOS NUEVOS///////
$grilla->setNameParamGET("idCheque");
$grilla->addColOpenExtWindows("CR");
$grilla->addColOpenExtWindows("OP");
return $grilla->Draw(false);
}
function getGrid($pj_idjuicioentramite)
{
$showProcessMsg = false;
$pagina = 1;
if (isset($_REQUEST["pagina"])) {
$pagina = $_REQUEST["pagina"];
}
$sql = ObtenerInstancias();
$params = array();
$params[":pj_idjuicioentramite"] = $pj_idjuicioentramite;
$grilla = new GridDos(1, 15);
$grilla->addColumn(new Column("Instancia", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("Expediente", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("Fuero", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("Juzgado", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("Secretaria", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("Motivo", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("F. Ingreso", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("F. Sentencia", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("F. Notificacion", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("Observaciones", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("Importe Sentencia", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("Importe Capital", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("Importe Honorarios", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("Importe Intereses", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("Tasa Justicia", 0, true, false, -1, "", "", "", -1, false));
//$grilla->addColumn(new Column("CJ", 0, true, false, -1, "", "", "", -1, false));
//$grilla->addColumn(new Column("M", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("CJ", 0, true, false, -1, "btnPdf", "/index.php?pageid=103&accion=nuevo", "", -1, true, -1, "Nuevo"));
$grilla->addColumn(new Column("M", 0, true, false, -1, "btnPdf", "/index.php?pageid=103&accion=modif", "", -1, true, -1, "Modificar"));
$grilla->setColsSeparator(false);
$grilla->setPageNumber($pagina);
$grilla->setParams($params);
$grilla->setRowsSeparatorColor("#c0c0c0");
$grilla->setShowTotalRegistros(true);
$grilla->setSql($sql);
$grilla->setUseTmpIframe(false);
$grilla->setTableStyle("GridTableCiiu");
return $grilla->Draw(false);
}
function getGridReclamos($nrojuicio)
{
$showProcessMsg = false;
$pagina = 1;
if (isset($_REQUEST["pagina"])) {
$pagina = $_REQUEST["pagina"];
}
$sql = ObtenerReclamos();
$params = array();
$params[":nrojuicio"] = $nrojuicio;
$grilla = new GridDos(1, 15);
$grilla->addColumn(new Column("Descripcion", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("M.Demandado", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("Inc.Demanda", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("M.Sentencia", 0, true, false, -1, "", "", "", -1, false));
$grilla->addColumn(new Column("Porc.Sentencia", 0, true, false, -1, "", "", "", -1, false));
$grilla->setColsSeparator(false);
$grilla->setPageNumber($pagina);
$grilla->setParams($params);
$grilla->setRowsSeparatorColor("#c0c0c0");
$grilla->setShowTotalRegistros(true);
$grilla->setSql($sql);
$grilla->setUseTmpIframe(false);
$grilla->setTableStyle("GridTableCiiu");
return $grilla->Draw(false);
}