cpr.ca_fax ¿fax? FROM art.cpr_prestador cpr, art.mtp_tipoprestador mtp WHERE cpr.ca_cartillaweb IN('S', 'A') AND mtp.tp_codigo = cpr.ca_especialidad AND NVL(cpr.ca_visible, 'S') = 'S' AND cpr.ca_fechabaja IS NULL _EXC1_"; $grilla = new Grid(); $grilla->addColumn(new Column("Prestador")); $grilla->addColumn(new Column("Tipo de Prestación")); $grilla->addColumn(new Column("Domicilio")); $grilla->addColumn(new Column("Localidad")); $grilla->addColumn(new Column("Teléfono")); $grilla->addColumn(new Column("Fax")); $grilla->setExtraConditions(array($where)); $grilla->setOrderBy($ob); $grilla->setPageNumber($pagina); $grilla->setParams($params); $grilla->setSql($sql); $grilla->setTableStyle("GridTableCiiu"); $grilla->Draw(); $_SESSION["sqlCartillaPrestadores"] = $grilla->getSqlFinal(true); ?> <script type="text/javascript"> with (window.parent.document) { getElementById('divProcesando').style.display = 'none'; getElementById('btnExportar').style.display = 'inline'; getElementById('divContentGrid').innerHTML = document.getElementById('originalGrid').innerHTML; getElementById('divContentGrid').style.display = 'block'; } </script>
$grilla->addColumn(new Column("Tipo")); $grilla->addColumn(new Column("Provincia")); $grilla->addColumn(new Column("Comprobante", -1, true, false, -1, "", "", "gridColAlignRight", -1, false)); $grilla->addColumn(new Column("Retención", -1, true, false, -1, "", "", "gridColAlignRight", -1, false)); $grilla->addColumn(new Column("", 0, false)); $grilla->setExtraConditions(array($where)); $grilla->setOrderBy($ob); $grilla->setPageNumber($pagina); $grilla->setParams($params); $grilla->setSql($sql); $grilla->setTableStyle("GridTableCiiu"); $grilla->setUseTmpIframe(true); $grilla->Draw(); $_SESSION["fieldsAlignment"] = array("left", "left", "right", "right"); $_SESSION["sqlLiquidacionesRetenciones"] = $grilla->getSqlFinal(true); ?> </div> <script type="text/javascript"> with (window.parent.document) { getElementById('tituloRetenciones').innerHTML = '<?php echo $titulo; ?> '; getElementById('divContentGridRetenciones').innerHTML = document.getElementById('divContentGrid').innerHTML; getElementById('btnExportarRetenciones').style.display = 'inline'; getElementById('originalGrid').style.display = 'block'; getElementById('divProcesando').style.display = 'none'; } </script> </body>
$grilla->addColumn(new Column("Deuda Total", -1, true, false, -1, "", "", "gridColAlignRight", -1, false)); $grilla->addColumn(new Column("Holding", 0, false)); $grilla->addColumn(new Column("Ejecutivo Comercial Empresa", 0, false)); $grilla->addColumn(new Column("Fecha Última Visita Ejecutivo Comercial", 0, false)); $grilla->addColumn(new Column("Gestor Cobranzas", 0, false)); $grilla->addColumn(new Column("Preventor", 0, false)); $grilla->addColumn(new Column("Asesor Emisión", 0, false)); $grilla->addColumn(new Column("Cantidad Siniestros Denunciados", 0, false)); $grilla->addColumn(new Column("Cantidad Siniestros Rechazados", 0, false)); $grilla->addColumn(new Column("Cantidad Demandas Judiciales Iniciadas", 0, false)); $grilla->setColsSeparator(true); $grilla->setExtraConditions(array($where2, $where)); $grilla->setOrderBy($ob); $grilla->setPageNumber($pagina); $grilla->setParams($params); $grilla->setRowsSeparator(true); $grilla->setShowProcessMessage(true); $grilla->setSql($sql); $grilla->Draw(); $_SESSION["contratosActivosHeader"] = "<table border=0><tr><td style='font-family:Verdana; font-size:16px;' valign=top><b>Contratos Activos<br /><span style='font-family:Verdana; font-size:12px;'>Filtros:</span></b></td></tr>".$filtros."</table>"; $_SESSION["sqlContratos"] = str_replace("CO_CONTRATO ID,", "", $grilla->getSqlFinal(true)); ?> <script type="text/javascript"> with (window.parent.document) { getElementById('btnExportar').style.display = 'inline'; getElementById('divProcesando').style.display = 'none'; getElementById('divContentGrid').innerHTML = document.getElementById('originalGrid').innerHTML; getElementById('divContentGrid').style.display = 'block'; } </script>
$grilla = new Grid(); $grilla->addColumn(new Column("Fecha")); $grilla->addColumn(new Column("Tema")); $grilla->addColumn(new Column("Título")); $grilla->addColumn(new Column("Usuario")); $grilla->setColsSeparator(true); $grilla->setExtraConditions(array($where)); $grilla->setOrderBy($ob); $grilla->setPageNumber($pagina); $grilla->setRowsSeparator(true); $grilla->setSql($sql); $grilla->Draw(); echo "<script>"; echo "document.getElementById('divTopGrilla').style.display = 'block';"; echo "document.getElementById('total').innerHTML = '".$grilla->recordCount()."';"; echo "document.getElementById('LinkToExcel').href = '/modules/control_gestion/informes_de_gestion/exportar_a_excel.php?sql=".rawurlencode($grilla->getSqlFinal())."';"; echo "</script>"; } ?> </div> <div align="center" id="divProcesando" name="divProcesando" <?php echo $showProcessMsg ? "show='ok'" : ""; ?> style="display:none"><img src="/images/waiting.gif" title="Espere por favor..."></div> <script> function CopyContent() { try { window.parent.document.getElementById('divContent').innerHTML = document.getElementById('divContent').innerHTML; } catch(err) { //
$grilla->addColumn(new Column("", 0, false)); $grilla->addColumn(new Column("V", 0, true, false, -1, "btnLink ", "/modules/usuarios_registrados/agentes_comerciales/comisiones/cambiar_solapa.php?s=v", "", -1, true, -1, "Detalle de Vendedores")); $grilla->addColumn(new Column("R", 0, true, false, -1, "btnLink ", "/modules/usuarios_registrados/agentes_comerciales/comisiones/cambiar_solapa.php?s=r", "", -1, true, -1, "Detalle de Retenciones")); $grilla->addColumn(new Column("", 0, false)); $grilla->setExtraConditions(array($where)); $grilla->setOrderBy($ob); $grilla->setPageNumber($pagina); $grilla->setParams($params); $grilla->setShowMessageNoResults(false); $grilla->setSql($sql); $grilla->setTableStyle("GridTableCiiu"); $grilla->setUseTmpIframe(true); $grilla->Draw(); $_SESSION["fieldsAlignment"] = array("", "right", "center", "right", "right", "right", "right", "right", "right", "right", "right", "right"); $_SESSION["sqlLiquidacionesPendientes"] = $grilla->getSqlFinal(true); ?> </div> <script type="text/javascript"> window.parent.document.getElementById('divContentGridPendientes').innerHTML = document.getElementById('divContentGrid').innerHTML; <? if ($grilla->recordCount() > 0) { ?> window.parent.document.getElementById('btnExportarPendientes').style.display = 'inline'; <? } ?> if (window.parent.document.getElementById('originalGrid') != null) window.parent.document.getElementById('originalGrid').style.display = 'block'; window.parent.document.getElementById('divProcesando').style.display = 'none'; <?
$grilla->addColumn(new Column("Orden Pago", -1, true, false, -1, "", "", "gridColAlignRight", -1, false)); $grilla->addColumn(new Column("Fecha OP", -1, true, false, -1, "", "", "gridColAlignCenter", -1, false)); $grilla->addColumn(new Column("Situación")); $grilla->addColumn(new Column("Fecha Situación", -1, true, false, -1, "", "", "gridColAlignCenter", -1, false)); $grilla->addColumn(new Column("", 0, false)); $grilla->setExtraConditions(array($where1, $where2, $where3)); $grilla->setOrderBy($ob); $grilla->setPageNumber($pagina); $grilla->setParams($params); $grilla->setSql($sql); $grilla->setTableStyle("GridTableCiiu"); $grilla->setUseTmpIframe(true); $grilla->Draw(); $_SESSION["fieldsAlignment"] = array("left", "center", "center", "right", "right", "center", "left", "center"); $_SESSION["sqlFacturas"] = $grilla->getSqlFinal(true); echo "<script type='text/javascript'>"; echo "document.getElementById('btnExportar').style.display = 'inline';"; echo "</script>"; } ?> </div> <div align="left" id="divProcesando" name="divProcesando" <?php echo $showProcessMsg ? "show='ok'" : ""; ?> style="display:none"><img border="0" src="/images/waiting.gif" title="Espere por favor..."></div> <a href="/index.php?pageid=85"><input class="btnVolver" type="button" value="" /></a> </form> <script type="text/javascript"> function CopyContent() { try {
$grilla->addColumn(new Column("Período", -1, true, false, -1, "", "", "gridColAlignCenter", -1, false)); $grilla->addColumn(new Column("Cobrado Neto de Impuestos", -1, true, false, -1, "", "", "gridColAlignRight", -1, false)); $grilla->addColumn(new Column("Monto Liquidado", -1, true, false, -1, "", "", "gridColAlignRight", -1, false)); $grilla->addColumn(new Column("Concepto")); $grilla->addColumn(new Column("", 0, false)); $grilla->setExtraConditions(array($where)); $grilla->setOrderBy($ob); $grilla->setPageNumber($pagina); $grilla->setParams($params); $grilla->setSql($sql); $grilla->setTableStyle("GridTableCiiu"); $grilla->setUseTmpIframe(true); $grilla->Draw(); $_SESSION["fieldsAlignment"] = array("right", "center", "left", "center", "right", "right", "left"); $_SESSION["sqlLiquidacionesMovimientos"] = $grilla->getSqlFinal(true); ?> </div> <script type="text/javascript"> window.parent.document.getElementById('tituloMovimientos').innerHTML = '<?php echo $titulo; ?> '; window.parent.document.getElementById('tituloMovimientosVendedor').innerHTML = '<?php echo $vendedor; ?> '; window.parent.document.getElementById('divContentGridMovimientos').innerHTML = document.getElementById('divContentGrid').innerHTML; window.parent.document.getElementById('btnExportarMovimientos').style.display = 'inline'; window.parent.document.getElementById('originalGrid').style.display = 'block'; window.parent.document.getElementById('divProcesando').style.display = 'none';
$grilla->addColumn(new Column("Motivo Rechazo")); $grilla->addColumn(new Column("% Incapacidad")); $grilla->addColumn(new Column("Fecha Recepción")); $grilla->addColumn(new Column("Observaciones")); $grilla->addColumn(new Column("Domicilio Denuncia")); $grilla->addColumn(new Column("Gravedad")); $grilla->setExtraConditions(array($where)); $grilla->setOrderBy($ob); $grilla->setPageNumber($pagina); $grilla->setParams($params); $grilla->setShowProcessMessage(true); $grilla->setSql($sql); $grilla->setTableStyle("GridTableCiiu"); $grilla->Draw(); $_SESSION["sqlConsultaSiniestros"] = $grilla->getSqlFinal(true); ?> <script type="text/javascript"> with (window.parent.document) { getElementById('divProcesando').style.display = 'none'; getElementById('btnExportar').style.display = 'inline'; getElementById('divContentGrid').innerHTML = document.getElementById('originalGrid').innerHTML; getElementById('divContentGrid').style.display = 'block'; <? if ($grilla->recordCount() > 0) { ?> getElementById('divObservacion').style.display = 'block'; <? } ?> }
$grilla->addColumn(new Column("", 0, false)); $grilla->addColumn(new Column("Total Cobrado", -1, true, false, -1, "", "", "gridColAlignRight", -1, false)); $grilla->addColumn(new Column("Cobrado Neto", -1, true, false, -1, "", "", "gridColAlignRight", -1, false)); $grilla->addColumn(new Column("Monto Liquidado", -1, true, false, -1, "", "", "gridColAlignRight", -1, false)); $grilla->addColumn(new Column("Concepto")); $grilla->addColumn(new Column("", 0, false)); $grilla->setExtraConditions(array($where)); $grilla->setOrderBy($ob); $grilla->setPageNumber($pagina); $grilla->setParams($params); $grilla->setSql($sql); $grilla->setTableStyle("GridTableCiiu"); $grilla->setUseTmpIframe(true); $grilla->Draw(); $_SESSION["fieldsAlignment"] = array("", "left", "left", "right", "right", "right", "left"); $_SESSION["sqlLiquidacionesVendedores"] = $grilla->getSqlFinal(true); ?> </div> <script type="text/javascript"> window.parent.document.getElementById('tituloVendedores').innerHTML = '<?php echo $titulo; ?> '; window.parent.document.getElementById('divContentGridVendedores').innerHTML = document.getElementById('divContentGrid').innerHTML; window.parent.document.getElementById('btnExportarVendedores').style.display = 'inline'; window.parent.document.getElementById('originalGrid').style.display = 'block'; window.parent.document.getElementById('divProcesando').style.display = 'none'; </script> </body> </html>