当前位置: 首页>>代码示例>>PHP>>正文

PHP Grid::getSqlFinal方法代码示例

本文整理汇总了PHP中Grid::getSqlFinal方法的典型用法代码示例。如果您正苦于以下问题：PHP Grid::getSqlFinal方法的具体用法？PHP Grid::getSqlFinal怎么用？PHP Grid::getSqlFinal使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Grid的用法示例。


在下文中一共展示了Grid::getSqlFinal方法的9个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: IN

					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>
开发者ID:javierlov，项目名称:FuentesWeb，代码行数:31，代码来源:index_busqueda.php

示例2: Column

$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>
开发者ID:javierlov，项目名称:FuentesWeb，代码行数:31，代码来源:cargar_retenciones.php

示例3: Column

$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>
开发者ID:javierlov，项目名称:FuentesWeb，代码行数:31，代码来源:index_busqueda.php

示例4: Grid

	$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) {
			//
开发者ID:javierlov，项目名称:FuentesWeb，代码行数:31，代码来源:administracion_de_estadisticas.php

示例5: Column

$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';
<?
开发者ID:javierlov，项目名称:FuentesWeb，代码行数:31，代码来源:cargar_pendientes.php

示例6: Column

	$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 {
开发者ID:javierlov，项目名称:FuentesWeb，代码行数:31，代码来源:facturas.php

示例7: Column

$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';
开发者ID:javierlov，项目名称:FuentesWeb，代码行数:31，代码来源:cargar_movimientos.php

示例8: Column

$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';
<?
}
?>
	}
开发者ID:javierlov，项目名称:FuentesWeb，代码行数:31，代码来源:index_busqueda.php

示例9: Column

$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>
开发者ID:javierlov，项目名称:FuentesWeb，代码行数:31，代码来源:cargar_vendedores.php


注：本文中的Grid::getSqlFinal方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。