Exemplo n.º 1
0
<?php

$base_process_uri = $this->rapyd->uri->implode_uri("base_uri", "gfid", "orderby");
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'C&oacute;odigo', 'nombre' => 'Nombre', 'rif' => 'Rif', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'C&oacute;digo', 'nombre' => 'Nombre', 'rif' => 'Rif'), 'retornar' => array('proveed' => 'cod_prov'), 'titulo' => 'Buscar Proveedor');
$bSPRV = $this->datasis->p_modbus($mSPRV, "proveed");
$script = '
		$(function() {
				$("#estadmin").change(function(){
					$.post("' . site_url('presupuesto/presupuesto/get_tipo') . '",{ codigoadm:$("#estadmin").val() },function(data){$("#fondo").html(data);})
				});
		});
		';
$filter = new DataFilter2($this->rapyd->uri->add_clause($base_process_uri, "search"));
$filter->db->from('view_pres');
$filter->script($script);
$filter->title('');
$filter->attributes = array('onsubmit' => 'is_loaded()');
$ng1 = 'CAMPOS A FILTRAR';
$filter->fechah = new dateonlyField("Hasta", "fechah", 'd/m/Y');
$filter->fechah->clause = " ";
$filter->fechah->insertValue = date("Y-m-d");
$filter->fechah->db_name = "fecha";
$filter->fechah->operator = " ";
$filter->fechah->dbformat = 'Y-m-d';
$filter->fechah->group = $ng1;
$filter->estadmin = new dropdownField("Estructura Administrativa", "estadmin");
$filter->estadmin->db_name = 'codigoadm';
$filter->estadmin->option("", "Seleccione");
$filter->estadmin->options("SELECT b.codigo, CONCAT_WS(' ',b.codigo,b.denominacion) AS val FROM presupuesto AS a JOIN estruadm AS b ON a.codigoadm=b.codigo  GROUP BY b.codigo");
//$filter->estadmin->style="width:600px";
$filter->estadmin->group = $ng1;