PHP Grid::getSqlFinal示例

					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>

示例#2

显示文件

文件： cargar_retenciones.php 项目： javierlov/FuentesWeb

$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>

示例#3

显示文件

文件： index_busqueda.php 项目： javierlov/FuentesWeb

$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>

示例#4

显示文件

文件： administracion_de_estadisticas.php 项目： javierlov/FuentesWeb

	$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) {
			//

示例#5

显示文件

文件： cargar_pendientes.php 项目： javierlov/FuentesWeb

$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';
<?

示例#6

显示文件

文件： facturas.php 项目： javierlov/FuentesWeb

	$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 {

示例#7

显示文件

文件： cargar_movimientos.php 项目： javierlov/FuentesWeb

$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';

示例#8

显示文件

文件： index_busqueda.php 项目： javierlov/FuentesWeb

$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';
<?
}
?>
	}

示例#9

显示文件

文件： cargar_vendedores.php 项目： javierlov/FuentesWeb

$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>