<?php $base_process_uri = $this->rapyd->uri->implode_uri("base_uri", "gfid", "orderby"); $mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'rif' => 'Rif', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Có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;