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);
}
Exemplo n.º 6
0
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);
}