function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'proveed'), 'titulo' => 'Buscar Beneficiario');
$bSPRV = $this->datasis->modbus($mSPRV);
$filter = new DataFilter2("Filtro por Producto", 'sinv');
$filter->codigo = new inputField("Código", "codigo");
$filter->descrip = new inputField("Descripción", "descrip");
$filter->descrip->db_name = 'CONCAT_WS(" ",descrip,descrip2)';
$filter->clave = new inputField("Clave", "clave");
$filter->proveed = new inputField("Beneficiario", "proveed");
$filter->proveed->append($bSPRV);
$filter->proveed->clause = "in";
$filter->proveed->db_name = '( prov1, prov2, prov3 )';
$filter->marca = new dropdownField("Marca", "marca");
$filter->marca->option("", "Todas");
$filter->marca->options("SELECT TRIM(marca) AS clave, TRIM(marca) AS valor FROM marc ORDER BY marca");
$filter->buttons("reset", "search");
$filter->build();
$link = anchor('/inventario/barras/dataedit/modify/<#id#>', '<#codigo#>');
$grid = new DataGrid("Lista de Artículos");
$grid->order_by("codigo", "asc");
$grid->per_page = 20;
$grid->use_function('str_replace');
$grid->column("Código", $link);
$grid->column("Descripción", "descrip");
$grid->column("Precio 1", "precio1");
$grid->column("Barras", "barras");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = " Lista de Artículos ";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load('datafilter2', 'datagrid');
$filter = new DataFilter2('', 'tban');
$filter->codbanc = new inputField('Código', 'cod_banc');
$filter->codbanc->size = 5;
$filter->codbanc->clause = 'likerigth';
$filter->banco = new inputField('Nombre de Banco', 'nomb_banc');
$filter->banco->size = 30;
$filter->banco->clause = 'likerigth';
$filter->buttons('reset', 'search');
$filter->build();
$uri = anchor('tesoreria/tban/dataedit/show/<#cod_banc#>', '<#cod_banc#>');
$grid = new DataGrid("");
$grid->per_page = 20;
$grid->column_orderby('Código', $uri, 'cod_banc');
$grid->column_orderby('Banco', 'nomb_banc', 'nomb_banc', "align='left' NOWRAP");
//$grid->column_orderby("Tipo" ,"tipotra" ,"tipotra" );
//$grid->column_orderby("Formaca","formaca" ,"formaca" );
$grid->add('tesoreria/tban/dataedit/create');
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = 'Tabla de Bancos';
$data['head'] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->bSINV = $this->datasis->modbus($this->sinv);
$this->rapyd->load("datafilter2", "datagrid");
//$this->rapyd->uri->keep_persistence();
rapydlib("prototype");
$filter = new DataFilter2("Filtro por Producto", 'catalogo');
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 15;
$filter->codigo->append($this->bSINV);
$filter->buttons("reset", "search");
$filter->build();
$grid = new DataGrid("Lista de Artículos");
$grid->add("inventario/catalogo/dataedit/create");
$grid->order_by("codigo", "asc");
$grid->per_page = 20;
$link = anchor('/inventario/catalogo/dataedit/show/<#id#>', '<#codigo#>');
$grid->use_function('str_replace');
$grid->column("Código", $link);
$grid->column("Fecha", "<dbdate_to_human><#estampa#></dbdate_to_human>");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data["head"] = script("tabber.js") . script("prototype.js") . $this->rapyd->get_head() . script("scriptaculous.js") . script("effects.js");
$data['title'] = ' Lista de Artículos ';
$this->load->view('view_ventanas', $data);
}
function index()
{
$this->rapyd->load("datagrid", "datafilter2");
$filter = new DataFilter2("Filtro de " . $this->titp, 'horarios');
$filter->id = new inputField("Id", "id");
$filter->id->size = 10;
$filter->id->clause = "likerigth";
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 10;
$filter->codigo->clause = "likerigth";
$filter->denomi = new inputField("Denominación", "denomi");
$filter->denomi->size = 10;
$filter->denomi->clause = "likerigth";
$filter->turno = new inputField("Turno", "turno");
$filter->turno->size = 10;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . 'dataedit/show/<#id#>', '<#id#>');
$grid = new DataGrid();
$grid->order_by("codigo", "asc");
$grid->per_page = 15;
$grid->column("Id", $uri);
$grid->column("Cóndigo", "codigo");
$grid->column("Denominaón", "denomi");
$grid->column("Turno", "turno", "align='left'");
$grid->column("Entrada", "entrada", "align='left'");
$grid->column("Salida", "salida", "align='left'");
$grid->add($this->url . "dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data["head"] = $this->rapyd->get_head();
$data['title'] = "<h1>{$this->titp}</h1>";
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$script = '';
$filter = new DataFilter2("");
$filter->db->from("view_sumi_saldo");
$filter->script($script);
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 15;
$filter->descrip = new inputField("Descripción", "descrip");
$filter->descrip->size = 40;
$filter->unidad = new inputField("Unidad", "unidad");
$filter->unidad->size = 40;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . 'redi/<raencode><#codigo#></raencode>', '<#codigo#>');
$grid = new DataGrid("");
$grid->order_by("codigo", "asc");
$grid->per_page = 100;
$grid->use_function('substr', 'str_pad', 'sta');
$grid->column_orderby("Código", $uri, "codigo");
$grid->column_orderby("Descripción", "descrip", "descrip", "align='left' ");
$grid->column_orderby("Unidad", "unidad", "unidad", "align='left' ");
$grid->column_orderby("Cantidad", "cantidad", "cantidad", "align='left' NOWRAP");
//$grid->add($this->url."/dataedit/create");
$grid->build();
//$data['content'] = $filter->output.$grid->output;
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['title'] = $this->t**s;
$data['script'] = script("jquery.js") . "\n";
$data["head"] = script("jquery.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$this->rapyd->uri->keep_persistence();
$filter = new DataFilter2("Filtro por Cargo", 'carg');
$filter->cargo = new inputField("Código", "cargo");
$filter->cargo->size = 3;
$filter->cargo->clause = "likerigth";
$filter->descrip = new inputField("Descripción", "descrip");
$filter->cargo->clause = "likerigth";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('nomina/carg/dataedit/show/<#cargo#>', '<#cargo#>');
$grid = new DataGrid("Lista de Cargos");
$grid->order_by("cargo", "asc");
$grid->per_page = 10;
$grid->column("Cargo", $uri);
$grid->column("Descripción", "descrip");
$grid->column("Sueldo", "<number_format><#sueldo#>|2|,|.</number_format>", "align='right'");
$grid->add("nomina/carg/dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = "<h1>Cargos</h1>";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
//
$filter = new DataFilter2("", "clasevehi");
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 5;
//$filter->codigo->clause="likerigth";
$filter->nombre = new inputField("Nombre", "nombre");
$filter->nombre->size = 40;
$filter->nombre->clause = "likerigth";
$filter->buttons("reset", "search");
$filter->build();
$grid = new DataGrid("");
$grid->order_by("codigo", "asc");
$grid->column_orderby("Código", "codigo", "codigo", "align='left' ");
$grid->column_orderby("Nombre", "nombre", "nombre", "align='left'NOWRAP");
$grid->add("ingresos/clasevehi/dataedit/create");
$grid->build();
$data['content'] = $grid->output;
$data['filtro'] = $filter->output;
$data['title'] = "Clase de Vehiculo";
//" ";
$data["script"] = script("jquery.js") . "\n";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->datasis->modulo_id(61, 1);
$this->rapyd->load("datafilter2", "datagrid");
//
$filter = new DataFilter2("", "fondo");
$filter->fondo = new inputField("F. Financiamiento", "fondo");
$filter->fondo->size = 20;
$filter->fondo->clause = "likerigth";
$filter->descrip = new inputField("Descripción", "descrip");
$filter->descrip->size = 20;
$filter->descrip->clause = "likerigth";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('presupuesto/fondo/dataedit/show/<raencode><#fondo#></raencode>', '<#fondo#>');
$grid = new DataGrid("");
$grid->order_by("fondo", "asc");
$grid->column_orderby("Fondo", $uri, "fondo", "align='left' ");
$grid->column_orderby("Descripción", "descrip", "descrip", "align='left'NOWRAP");
$grid->add("presupuesto/fondo/dataedit/create");
$grid->build();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "{$this->titp}";
//" ";
//$data['content'] = $filter->output.$grid->output;
//$data['title'] = " $this->titp ";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function index()
{
$this->rapyd->load("datagrid", "datafilter2");
$this->rapyd->uri->keep_persistence();
$filter = new DataFilter2("", 'cpla');
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 15;
//$filter->codigo->clause="likerigth";
$filter->denominacion = new inputField("Denominación", "denominacion");
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('contabilidad/cpla/dataedit/show/<#codigo#>', '<#codigo#>');
$grid = new DataGrid();
$grid->order_by("codigo", "asc");
$grid->per_page = 20;
$grid->column_orderby("Código", $uri, "codigo", "align='left' NOWRAP");
$grid->column_orderby("Denominaón", "denominacion", "denominacion", "align='left' NOWRAP");
//$grid->column("Usa Departamento" ,"departa" ,"align='center'");
//$grid->column("Cuenta Monetaria" ,"moneta" ,"align='center'");
$grid->add("contabilidad/cpla/dataedit/create");
$grid->build();
//$data['content'] =$filter->output.$grid->output;
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data["head"] = $this->rapyd->get_head();
$data['script'] = script("jquery.js") . "\n";
$data['title'] = 'Plan Patrimonial';
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$this->rapyd->uri->keep_persistence();
$filter = new DataFilter2("", 'carg');
$filter->cargo = new inputField("Código", "cargo");
$filter->cargo->size = 3;
$filter->cargo->clause = "likerigth";
$filter->descrip = new inputField("Descripción", "descrip");
$filter->cargo->clause = "likerigth";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('nomina/carg/dataedit/show/<raencode><#cargo#></raencode>', '<#cargo#>');
$grid = new DataGrid("");
$grid->order_by("cargo", "asc");
$grid->per_page = 20;
$grid->column_orderby("Cargo", $uri, "cargo");
$grid->column_orderby("Descripción", "descrip", "descrip", "align='left'NOWRAP");
$grid->column_orderby("Sueldo", "<number_format><#sueldo#>|2|,|.</number_format>", "sueldo", "align='right' ");
$grid->column_orderby("Estructura Administrativa", "codigoadm", "codigoadm", "align='left' ");
$grid->column_orderby("Codigo Presupuestario", "codigopres", "codigopres", "align='left' ");
$grid->column_orderby("F. Financiamiento", "fondo", "fondo", "align='left' ");
$grid->add("nomina/carg/dataedit/create");
$grid->build();
//$data['content'] = $filter->output.$grid->output;
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "Cargos";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$this->rapyd->uri->keep_persistence();
$pers = array('tabla' => 'pers', 'columnas' => array('codigo' => 'Codigo', 'cedula' => 'Cedula', 'nombre' => 'Nombre', 'apellido' => 'Apellido'), 'filtro' => array('codigo' => 'Código', 'cedula' => 'Cedula'), 'retornar' => array('codigo' => 'codigo'), 'titulo' => 'Buscar Personal');
$boton = $this->datasis->modbus($pers);
$filter = new DataFilter2("Filtro por Código", 'ausu');
$filter->codigo = new inputField("Codigo", "codigo");
$filter->codigo->size = 15;
$filter->codigo->append($boton);
$filter->codigo->clause = "likerigth";
$filter->fecha = new DateonlyField("Fecha", "fecha");
$filter->fecha->size = 12;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('nomina/aumentosueldo/dataedit/show/<#codigo#>/<raencode><#fecha#></raencode>', '<#codigo#>');
$grid = new DataGrid("Lista de Aumentos de Sueldo");
$grid->order_by("codigo", "asc");
$grid->per_page = 20;
$grid->column("Código", $uri);
$grid->column("Nombre", "nombre");
$grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "align='center'");
$grid->column("Sueldo anterior", "<number_format><#sueldoa#>|2|,|.</number_format>", "align='right'");
$grid->column("Sueldo nuevo", "<number_format><#sueldo#>|2|,|.</number_format>", "align='right'");
$grid->column("Observaciones", "observ1");
$grid->column("..", "oberv2");
$grid->add("nomina/aumentosueldo/dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = "<h1>Aumentos de Sueldo</h1>";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function index()
{
$this->rapyd->load("datagrid", "datafilter2");
$filter = new DataFilter2("", 'bcta');
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 15;
$filter->codigo->clause = "likerigth";
$filter->denominacion = new inputField("Denominación", "denominacion");
$filter->cuenta = new inputField("Cuenta", "cuenta");
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . 'dataedit/show/<#codigo#>', '<#codigo#>');
$grid = new DataGrid();
$grid->order_by("codigo", "asc");
$grid->per_page = 20;
$grid->column_orderby("Código", $uri, "codigo");
$grid->column_orderby("Denominación", "denominacion", "denominacion", "aling='left'NOWRAP");
$grid->column_orderby("Cuenta Contable", "cuenta", "cuenta", "align='left'NOWRAP");
$grid->column_orderby("Descripción", "descrip", "descrip");
$grid->add($this->url . "dataedit/create");
$grid->build();
//$data['content'] =$filter->output.$grid->output;
$data["head"] = $this->rapyd->get_head();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "{$this->titp}";
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->datasis->modulo_id(40, 1);
$this->rapyd->load("datafilter2", "datagrid");
//
$filter = new DataFilter2("", "uejecutora");
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 5;
//$filter->codigo->clause="likerigth";
$filter->nombre = new inputField("Nombre", "nombre");
$filter->nombre->size = 40;
$filter->nombre->clause = "likerigth";
//$filter->director = new inputField("Director", "director");
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('presupuesto/uejecuta/dataedit/show/<#codigo#>', '<#codigo#>');
$grid = new DataGrid("");
$grid->order_by("codigo", "asc");
$grid->column_orderby("Unidades Ejecutoras", $uri, "codigo", "align='left' ");
//$grid->column_orderby("Codigo administrativo","codigoadm" ,"codigoadm" ,"align='left'NOWRAP");
$grid->column_orderby("Nombre", "nombre", "nombre", "align='left'NOWRAP");
$grid->column_orderby("Director", "director", "director", "align='left'NOWRAP");
$grid->add("presupuesto/uejecuta/dataedit/create");
$grid->build();
$data['content'] = $grid->output;
$data['filtro'] = $filter->output;
$data['title'] = "Unidades Ejecutoras";
//" ";
$data["script"] = script("jquery.js") . "\n";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid2()
{
$this->rapyd->load("datafilter2", "datagrid");
$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 Beneficiario');
$bSPRV = $this->datasis->p_modbus($mSPRV, "sprv");
$filter = new DataFilter2($this->titp);
$filter->nomi = new inputField("Número", "nomina");
$filter->nomi->size = 15;
//$filter->numero->clause="likerigth";
$filter->cod_prov = new inputField("Proveedor", "cod_prov");
$filter->cod_prov->rule = 'required';
$filter->cod_prov->size = 5;
$filter->cod_prov->append($bSPRV);
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . '/dataedit/show/<#nomina#>', '<str_pad><#nomina#>|8|0|STR_PAD_LEFT</str_pad>');
$grid = new DataGrid("Lista de Deducciones de Nómina");
$grid->db->select(array("nomina", "b.nombre", "SUM(monto)total"));
$grid->db->from('retenomi');
$grid->db->join('sprv b', 'retenomi.cod_prov = b.proveed', 'LEFT');
$grid->db->groupby('nomina');
$grid->db->orderby('nomina', 'desc');
$grid->use_function('substr', 'str_pad');
$grid->per_page = 20;
$grid->column("Número", $uri);
$grid->column("Proveedor", "nombre", 'align="left"');
$grid->column("Total", "<number_format><#total#>|2|,|.</number_format>", 'align="right"');
$grid->add($this->url . "dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = " {$this->titp} ";
$data["head"] = script("jquery.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
//$this->datasis->modulo_id(83,1);
$this->rapyd->load("datafilter2", "datagrid");
$filter = new DataFilter2("");
$filter->db->select(array("a.codvehiculo codvehi", "a.codclase codclase", "a.codmarca codmarca", "a.asocia asocia", "a.tipo tipo", "a.modelo modelo", "a.color color", "a.capaci capaci", "a.monto monto", "a.ultanio ultanio", "a.serialmot serialmot", "a.panterior placant", "a.pactual placact", "a.anio anio", "a.peso peso", "a.serialcar serialcar", "a.deudant deudant", "b.nombre nomclase", "c.marca nommarca", "d.nombre nomaso"));
$filter->db->from("invehiculo a");
$filter->db->join("clasevehi b", "a.codclase=b.codigo", "left");
$filter->db->join("marcavehi c", "a.codmarca=c.codigo", "left");
$filter->db->join("asovehi d", "a.asocia=d.codigo", "left");
$filter->codigo = new inputField("Código", "codvehi");
$filter->codigo->clause = "likerigth";
$filter->codigo->maxlength = 6;
$filter->codigo->size = 6;
$filter->placa = new inputField("Placa", "placact");
$filter->placa->clause = "likerigth";
$filter->placa->maxlength = 20;
$filter->placa->size = 20;
$filter->codigoclase = new dropdownField("Marca", "codclase");
$filter->codigoclase->option("", "");
$filter->codigoclase->options("SELECT codigo, CONCAT_WS(' ',codigo,marca)as a FROM marcavehi ORDER BY codigo");
$filter->codigomarca = new dropdownField("Clase", "codmarca");
$filter->codigomarca->option("", "");
$filter->codigomarca->options("SELECT codigo, CONCAT_WS(' ',codigo,nombre)as a FROM clasevehi ORDER BY codigo");
$filter->asocia = new dropdownField("Asociación", "asocia");
$filter->asocia->option("", "");
$filter->asocia->options("SELECT codigo, CONCAT_WS(' ',codigo,nombre)as a FROM asovehi ORDER BY codigo");
$filter->buttons("reset", "search");
$filter->build();
$grid = new DataGrid("");
$grid->order_by("codvehiculo", "asc");
$grid->column_orderby("Código", "codvehi", "codvehi", "align='center' ");
$grid->column_orderby("Clase", "nomclase", "nomclase", "align='left'NOWRAP");
$grid->column_orderby("Marca", "nommarca", "nommarca", "align='left'NOWRAP");
$grid->column_orderby("Tipo", "tipo", "tipo", "align='center' ");
$grid->column_orderby("Modelo", "modelo", "modelo", "align='left'NOWRAP");
$grid->column_orderby("Color", "color", "color", "align='center' ");
$grid->column_orderby("Capacidad", "capaci", "capaci", "align='center' ");
$grid->column_orderby("Monto", "monto", "monto", "align='right' ");
$grid->column_orderby("Ultimo A.", "ultanio", "ultanio", "align='center' ");
$grid->column_orderby("Serial Motor", "serialmot", "serialmot", "align='left'NOWRAP");
$grid->column_orderby("P.Anterior", "placant", "placant", "align='left'NOWRAP");
$grid->column_orderby("P.Actual", "placact", "placact", "align='left'NOWRAP");
$grid->column_orderby("Año", "anio", "anio", "align='center' ");
$grid->column_orderby("Asociación", "nomaso", "nomaso", "align='left'NOWRAP");
$grid->column_orderby("Peso", "peso", "peso", "align='center' ");
$grid->column_orderby("Serial Carroceria", "serialcar", "serialcar", "align='left'NOWRAP");
$grid->column_orderby("Deuda Ant.", "deudant", "deudant", "align='right' ");
$grid->column_orderby("Placa", "placact", "placact", "align='left'");
$grid->add("ingresos/invehiculo/dataedit/create");
$grid->build();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "Vehiculo";
//" $this->titp ";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
//$this->datasis->modulo_id(40,1);
$this->rapyd->load("datafilter2", "datagrid");
//
$filter = new DataFilter2("", "ttributo");
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 5;
//$filter->codigo->clause="likerigth";
$filter->nombre = new inputField("Nombre", "nombre");
$filter->nombre->size = 40;
$filter->nombre->clause = "likerigth";
$filter->cancelado = new dropdownField("Cancelado", "cancelado");
//$filter->codigoejec->rule='required';
$filter->cancelado->option("", "");
$filter->cancelado->option("s", "Si");
$filter->cancelado->option("n", "No");
$filter->mensaje = new inputField("Mensaje", "mensaje");
$filter->mensaje->size = 20;
$filter->mensaje->clause = "likerigth";
$filter->momto = new inputField("Monto", "monto");
$filter->momto->size = 10;
$filter->momto->clause = "likerigth";
$filter->emireci = new dropdownField("Emitio Recivo", "emireci");
//$filter->codigoejec->rule='required';
$filter->emireci->option("", "");
$filter->emireci->option("s", "Si");
$filter->emireci->option("n", "No");
$filter->deudante = new dropdownField("Deuda Anterior", "deudante");
//$filter->codigoejec->rule='required';
$filter->deudante->option("", "");
$filter->deudante->option("s", "Si");
$filter->deudante->option("n", "No");
$filter->agua = new inputField("Agua", "agua");
$filter->agua->size = 10;
$filter->agua->clause = "likerigth";
$filter->buttons("reset", "search");
$filter->build();
$grid = new DataGrid("");
$grid->order_by("codigo", "asc");
$grid->column_orderby("Código", "codigo", "codigo", "align='left' ");
$grid->column_orderby("Nombre", "nombre", "nombre", "align='left' NOWRAP");
$grid->column_orderby("Cancelado", "cancelado", "cancelado", "align='left' NOWRAP");
$grid->column_orderby("Mensaje", "mensaje", "mensaje", "align='left' NOWRAP");
$grid->column_orderby("Monto", "monto", "monto", "align='right'NOWRAP");
$grid->column_orderby("E.Recibo", "emireci", "emireci", "align='left' NOWRAP");
$grid->column_orderby("D.Anterior", "deudante", "deudante", "align='left' NOWRAP");
$grid->column_orderby("Agua", "agua", "agua", "align='right'NOWRAP");
$grid->add("ingresos/ttributo/dataedit/create");
$grid->build();
$data['content'] = $grid->output;
$data['filtro'] = $filter->output;
$data['title'] = "Tributos o Impuestos";
//" ";
$data["script"] = script("jquery.js") . "\n";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
//$this->datasis->modulo_id(75,1);
$this->rapyd->load("datafilter2", "datagrid");
$filter = new DataFilter2("", "su_trasla");
$filter->numero = new inputField("Número", "numero");
$filter->numero->size = 15;
$filter->fecha = new dateonlyField("Fecha", "fecha");
$filter->fecha->dbformat = "Y-m-d";
$filter->fecha->size = 12;
$filter->de = new dropdownField("De", "de");
$filter->de->option("", "");
$filter->de->options("SELECT codigo,descrip FROM su_caub");
$filter->para = new dropdownField("Para", "para");
$filter->para->option("", "");
$filter->para->options("SELECT codigo,descrip FROM su_caub");
$filter->concepto = new inputField("Concepto", "concepto");
$filter->concepto->size = 40;
$filter->status = new dropdownField("Estado", "status");
$filter->status->option("", "");
$filter->status->option("P", "Sin Ejecutar");
$filter->status->option("C", "Ejecutado");
$filter->status->style = "width:100px";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . 'dataedit/show/<#numero#>', '<str_pad><#numero#>|8|0|STR_PAD_LEFT</str_pad>');
function sta($status)
{
switch ($status) {
case "P":
return "Sin Ejecutar";
break;
case "C":
return "Ejecutado";
break;
}
}
$grid = new DataGrid("");
$grid->order_by("numero", "desc");
$grid->per_page = 20;
$grid->use_function('substr', 'str_pad');
$grid->use_function('sta');
$grid->column_orderby("Número", $uri, "numero");
$grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center'");
$grid->column_orderby("De", "de", "de", "align='right'");
$grid->column_orderby("Para", "para", "para", "align='right'");
$grid->column_orderby("Concepto", "concepto", "concepto", "align='left' NOWRAP");
$grid->column_orderby("Total", "total", "total", "align='right'");
$grid->column_orderby("Estado", "<sta><#status#></sta>", "status", "align='center'NOWRAP");
$grid->add($this->url . "dataedit/create");
$grid->build();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = $this->titp;
$data["head"] = script("jquery.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$script = '
$(function() {
});
';
$filter = new DataFilter2("", "bi_trasla");
$filter->script($script);
$filter->numero = new inputField("Número", "numero");
$filter->numero->size = 15;
$filter->fecha = new dateonlyField("Fecha", "fecha");
$filter->fecha->dbformat = "Y-m-d";
$filter->fecha->size = 12;
$filter->concepto = new inputField("Concepto", "concepto");
$filter->concepto->size = 40;
$filter->status = new dropdownField("Estado", "status");
$filter->status->option("", "");
$filter->status->option("P", "Sin Ejecutar");
$filter->status->option("C", "Ejecutado");
$filter->status->style = "width:100px";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . '/dataedit/show/<#numero#>', '<str_pad><#numero#>|8|0|STR_PAD_LEFT</str_pad>');
function sta($status)
{
switch ($status) {
case "P":
return "Sin Ejecutar";
break;
case "C":
return "Ejecutado";
break;
//case "O":return "Ordenado Pago";break;
//case "A":return "Anulado";break;
}
}
$grid = new DataGrid("");
$grid->order_by("numero", "desc");
$grid->per_page = 20;
$grid->use_function('substr', 'str_pad');
$grid->use_function('sta');
$grid->column_orderby("Número", $uri, "numero");
$grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha");
$grid->column_orderby("Concepto", "concepto", "concepto");
$grid->column_orderby("Estado", "<sta><#status#></sta>", "status");
$grid->add($this->url . "/dataedit/create");
$grid->build();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = $this->t**s;
$data["head"] = script("jquery.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$filter = new DataFilter2("", "relch");
$filter->db->select(array("relch.status status2", "relch.id", "relch.numero", "relch.usuario", "relch.fecha", "IF(relch.destino='C','Caja','Interno') destino", "mbanc.cheque"));
$filter->db->join("mbanc", "relch.id=mbanc.relch");
$filter->db->groupby("relch.numero");
$filter->id = new inputField("Ref. Relacion", "id");
$filter->id->db_name = "relch.id";
$filter->numero = new inputField("Numero", "numero");
$filter->numero->db_name = "relch.numero";
$filter->usuario = new dropdownField("Usuario", "usuario");
$filter->usuario->db_name = "relch.usuario";
$filter->usuario->option("", "");
$filter->usuario->options("SELECT us_codigo,CONCAT_WS(' ',us_codigo,us_nombre) FROM usuario");
$filter->usuario->style = "width:200px;";
$filter->fecha = new dateonlyField("Fecha", 'fecha', 'd/m/Y');
$filter->fecha->db_name = "mbanc.fecha";
$filter->fecha->dbformat = 'Y-m-d';
$filter->cheque = new inputField("Cheque", "cheque");
$filter->cheque->db_name = "mbanc.cheque";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('tesoreria/relch/dataedit/modify/<#id#>', '<#id#>');
$uri2 = anchor('tesoreria/relch/busca/<#id#>', 'Modificar');
$grid = new DataGrid("");
$grid->per_page = 20;
$grid->order_by("relch.id", "desc");
$grid->column_orderby("id", $uri, "relch.id");
$grid->column_orderby("Numero", "numero", "numero");
$grid->column_orderby("Cheque", "cheque", "cheque");
$grid->column_orderby("Usuario", "usuario", "usuario");
$grid->column_orderby("Fecha", "fecha", "fecha");
$grid->column_orderby("Destino", "destino", "destino");
$grid->column_orderby("Fondo", "fondo", "fondo");
$grid->column_orderby("Estado", "status2", "status2");
$grid->column("Modificar Cheques", $uri2);
$grid->build();
//$grid->db->last_query();
$atts3 = array('width' => '640', 'height' => '480', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '5', 'screeny' => '5', 'id' => 'recibo');
$salida = anchor('tesoreria/relch/busca/', "Crear Relacion");
$salida .= '</br>';
$salida .= anchor_popup('reportes/ver/relch/', "Ordenes Pagadas", $atts3);
$salida .= '</br>';
$salida .= anchor_popup('reportes/ver/relch2/', "Cheques Emitidos", $atts3);
$salida .= '</br>';
$salida .= anchor_popup('reportes/ver/relch3/', "Anulacion y Reposicion", $atts3);
$data['content'] = $filter->output . $salida . $grid->output;
$data['title'] = "Relaciones de Ordenes Pagadas";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$this->rapyd->uri->keep_persistence();
$filter = new DataFilter2("", 'asig');
$filter->codigo = new inputField("Codigo", "codigo");
$filter->codigo->size = 15;
$filter->codigo->clause = "likerigth";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('nomina/asig/dataedit/show/<#codigo#>', '<#codigo#>');
function sta($status)
{
switch ($status) {
case "A":
return "Asignación";
break;
case "O":
return "Otros";
break;
case "D":
return "Devoluciones";
break;
}
}
$grid = new DataGrid("");
$grid->order_by("codigo", "asc");
$grid->per_page = 20;
$grid->use_function('sta');
$grid->column_orderby("Código", $uri, "codigo");
$grid->column_orderby("Nombre", "nombre", "nombre", "align='left'NOWRAP ");
$grid->column_orderby("Concepto", "concepto", "concepto", "align='left'NOWRAP ");
$grid->column_orderby("Tipo", "<sta><#tipo#></sta>", "tipo", "align='center'NOWRAP");
$grid->column_orderby("Descripción", "descrip", "descrip", "align='left'NOWRAP ");
$grid->column_orderby("Fórmula", "formula", "formula", "align='left'NOWRAP ");
$grid->column_orderby("Monto", "<number_format><#monto#>|2|,|.</number_format>", "monto", "align='right'");
$grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center'");
$grid->column_orderby("Cuota", "<number_format><#cuota#>|2|,|.</number_format>", "cuota", "align='right'");
$grid->column_orderby("Cuota Total", "<number_format><#cuotat#>|2|,|.</number_format>", "cuotat", "align='right'");
$grid->add("nomina/asig/dataedit/create");
$grid->build();
//$data['content'] = $filter->output.$grid->output;
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "Asignaciones";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$this->rapyd->uri->keep_persistence();
$script = '
$(function() {
$(".inputnum").numeric(".");
});
';
$filter = new DataFilter2("", "pers");
$filter->script($script, "create");
$filter->script($script, "modify");
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 10;
$filter->codigo->css_class = 'inputnum';
$filter->cedula = new inputField("Cédula", "cedula");
$filter->cedula->size = 10;
$filter->cedula->css_class = 'inputnum';
$filter->nombre = new inputField("Nombre", "nombre");
$filter->nombre->size = 35;
$filter->apellido = new inputField("Apellido", "apellido");
$filter->apellido->size = 35;
$filter->contrato = new dropdownField("Contrato", "contrato");
$filter->contrato->option("", "");
$filter->contrato->options('SELECT codigo, CONCAT_WS(" * ",codigo,nombre) a FROM noco ORDER BY nombre');
$filter->contrato->style = "width:300px;";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('forma/ver/RECIBO/2/<#codigo#>', 'Imprimir');
$grid = new DataGrid("");
$grid->order_by("codigo", "asc");
$grid->per_page = 20;
$grid->column_orderby("Código", "codigo", "codigo", "align='center'");
$grid->column_orderby("Cédula", "cedula", "cedula", "align='center'");
$grid->column_orderby("Nombre", "nombre", "nombre", "align='left'NOWRAP");
$grid->column_orderby("Apellidos", "apellido", "apellido", "align='left'NOWRAP");
$grid->column_orderby("Contrato", "contrato", "contrato");
$grid->column_orderby("Recibo", $uri, "codigo");
$grid->build();
//$data['content'] = $filter->output.$grid->output;
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "Recibos de Pago";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->datasis->modulo_id(79, 1);
$this->rapyd->load("datafilter2", "datagrid");
$this->rapyd->uri->keep_persistence();
function blanco($num)
{
if (empty($num) || $num == 0) {
return '';
} else {
return number_format($num, 2, ',', '.');
}
}
$filter = new DataFilter2("", "bienes");
//$filter->codigo = new inputField("Código","codigo");
//$filter->codigo->size=20;
//
//$filter->nombre = new inputField("Nombre","nombre");
//$filter->nombre->size=20;
//
//$filter->grupo =new dropdownField("Grupo","grupo");
//$filter->grupo->option("","");
//$filter->grupo->options("SELECT grupo,CONCAT_WS(' ',grupo,nombre) FROM grbi");
$filter->barras = new inputField("Cod. Barras", "barras");
$filter->barras->size = 20;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('bienes/bienes/dataedit/show/<raencode><#codigo#></raencode>', '<#codigo#>');
$uri_2 = anchor('bienes/bienes/dataedit/create/<raencode><#codigo#></raencode>', 'Duplicar');
$grid = new DataGrid("");
//$grid->order_by("codigo","asc");
$grid->per_page = 20;
$grid->column_orderby("Código", $uri, "codigo", "align='center' ");
$grid->column_orderby("Grupo", "grupo", "grupo", "align='center' ");
$grid->column_orderby("Nombre", "nombre", "nombre", "align='left'NOWRAP");
$grid->column_orderby("Costo", "costo", "costo", "align='rigth'");
$grid->column("Duplicar", $uri_2, "align='center'");
$grid->add("bienes/bienes/dataedit/create");
$grid->build();
//$data['content'] = $filter->output.$grid->output;
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "Bienes Nacionales";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$this->rapyd->uri->keep_persistence();
$filter = new DataFilter2("Filtro de Asignaciones", 'asig');
$filter->fecha = new DateField("Fecha", "fecha");
$filter->fecha->size = 12;
$filter->codigo = new inputField("Codigo de Trabajador", "codigo");
$filter->codigo->size = 10;
$filter->descrip = new inputField("Descripción de Concepto", "descrip");
$filter->descrip->size = 25;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('nomina/asig/dataedit/show/<#codigo#>', '<#codigo#>');
function sta($status)
{
switch ($status) {
case "A":
return "Asignación";
break;
case "O":
return "Otros";
break;
case "D":
return "Devoluciones";
break;
}
}
$grid = new DataGrid("Lista de Asignaciones");
$grid->order_by("codigo", "asc");
$grid->per_page = 10;
$grid->use_function('sta');
$grid->column("Código", $uri);
$grid->column("Nombre", "nombre");
$grid->column("Concepto", "concepto");
$grid->column("Descripción", "descrip");
$grid->column("Monto", "<nformat><#monto#></nformat>", "align='right'");
$grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "align='center'");
$grid->add("nomina/asig/dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = "<h1>Asignaciones</h1>";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$this->rapyd->uri->keep_persistence();
function blanco($num)
{
if (empty($num) || $num == 0) {
return '';
} else {
return number_format($num, 2, ',', '.');
}
}
$filter = new DataFilter2("Filtro de Grupo de Inventario");
$filter->db->select("a.grupo AS grupo, a.nom_grup AS nom_grup, a.cu_cost AS cu_cos,b.descrip AS linea");
$filter->db->from("grup AS a");
$filter->db->join("line AS b", "a.linea=b.linea", "LEFT");
$filter->grupo = new inputField("Grupo", "grupo");
$filter->grupo->size = 20;
$filter->nombre = new inputField("Descripción", "nom_grup");
$filter->nombre->size = 20;
$filter->linea = new inputField("Linea", "linea");
$filter->linea->size = 20;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('suministros/grup/dataedit/show/<raencode><#grupo#></raencode>', '<#grupo#>');
$uri_2 = anchor('suministros/grup/dataedit/create/<raencode><#grupo#></raencode>', 'Duplicar');
$grid = new DataGrid("Lista de Grupos de Inventario");
$grid->order_by("grupo", "asc");
$grid->per_page = 20;
$grid->use_function('blanco');
$grid->column_orderby("Grupo", $uri, "grupo", "align='center' ");
$grid->column_orderby("Descripción", "nom_grup", "nom_grup", "align='left' NOWRAP");
$grid->column_orderby("Linea", "linea", "linea", "align='center'NOWRAP");
$grid->column("Duplicar", $uri_2, "align='center'");
$grid->add("suministros/grup/dataedit/create");
$grid->build();
//$data['content'] = $filter->output.$grid->output;
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "Grupos de Inventario";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->datasis->modulo_id(83, 1);
$this->rapyd->load("datafilter2", "datagrid");
//
$filter = new DataFilter2("");
//"Filtro por ".$this->titp,"uadministra");
$filter->db->select(array("a.codigoejec codigoejec", "a.codigo codigo", "a.nombre nombre", "a.director director", "b.nombre ejecutor"));
$filter->db->from("uadministra a");
$filter->db->join("uejecutora b", "a.codigoejec=b.codigo");
$filter->codigoejec = new dropdownField("Unidad Ejecutora", "codigoejec");
$filter->codigoejec->rule = 'required';
$filter->codigoejec->option("", "");
$filter->codigoejec->options("SELECT codigo, CONCAT_WS(' ',codigo,nombre)as a FROM uejecutora ORDER BY nombre");
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 5;
$filter->codigo->clause = "likerigth";
$filter->nombre = new inputField("Nombre", "nombre");
$filter->nombre->size = 40;
$filter->nombre->clause = "likerigth";
$filter->director = new inputField("Director", "a.director");
$filter->director->size = 40;
$filter->director->clause = "likerigth";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('presupuesto/uadministra/dataedit/show/<raencode><#codigoejec#></raencode>/<raencode><#codigo#></raencode>', '<#codigo#>');
$grid = new DataGrid("");
$grid->order_by("codigo", "asc");
$grid->column_orderby("Unidades Administrativas", $uri, "codigo", "align='left'");
$grid->column_orderby("Unidades Ejecutoras", "ejecutor", "ejecutor", "align='left'");
$grid->column_orderby("Nombre", "nombre", "nombre", "align='left'");
$grid->column_orderby("Director", "director", "director", "align='left'");
$grid->add("presupuesto/uadministra/dataedit/create");
$grid->build();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "{$this->titp}";
//" $this->titp ";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->datasis->modulo_id(85, 1);
$this->rapyd->load("datafilter2", "datagrid");
$this->rapyd->uri->keep_persistence();
function blanco($num)
{
if (empty($num) || $num == 0) {
return '';
} else {
return number_format($num, 2, ',', '.');
}
}
$filter = new DataFilter2("", "grbi");
$filter->id_grbi = new inputField("Grupo", "grupo");
$filter->id_grbi->size = 20;
$filter->grbi_nombre = new inputField("Nombre", "nombre");
$filter->grbi_nombre->size = 20;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('inventario/grbi/dataedit/show/<raencode><#grupo#></raencode>', '<#grupo#>');
$uri_2 = anchor('inventario/grbi/dataedit/create/<raencode><#grupo#></raencode>', 'Duplicar');
$grid = new DataGrid("Lista de Grupos de Inventario");
$grid->order_by("grupo", "asc");
$grid->per_page = 20;
$grid->use_function('blanco');
$grid->column_orderby("Grupo", $uri, "grupo", "align='center' ");
$grid->column_orderby("Descripción", "nombre", "nombre", "align='left'NOWRAP");
$grid->column_orderby("Cuenta Costo", "cuenta", "cuenta", "align='center'");
$grid->column("Duplicar", $uri_2, "align='center'");
$grid->add("inventario/grbi/dataedit/create");
$grid->build();
//$data['content'] = $filter->output.$grid->output;
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "Grupos de Bienes";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->datasis->modulo_id(128, 1);
$this->rapyd->load("datafilter2", "datagrid");
//
$filter = new DataFilter2("", "ordinal");
$filter->codigoadm = new inputField("Estructura Administrativa", "codigoadm");
$filter->fondo = new inputField("F. Financiamiento", "fondo");
$filter->codigopres = new inputField("Clasificador Presupuestario", "codigopres");
$filter->ordinal = new inputField("Ordinal", "ordinal");
$filter->ordinal->size = 5;
$filter->ordinal->maxlenght = 2;
$filter->ordinal->clause = "likerigth";
$filter->denominacion = new inputField("Descripción", "denominacion");
$filter->denominacion->size = 50;
$filter->denominacion->maxlenght = 100;
$filter->denominacion->clause = "likerigth";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . '/dataedit/show/<#codigoadm#>/<#fondo#>/<#codigopres#>/<#ordinal#>', '<#codigoadm#><#fondo#><#codigopres#><#ordinal#>');
$grid = new DataGrid("");
$grid->order_by("codigopres", "asc");
$grid->column_orderby("", $uri, "codigoadm", "align='left'");
$grid->column_orderby("Estructura Administrativa", "codigoadm", "codigoadm", "align='left'");
$grid->column_orderby("Fondo", "fondo", "fondo", "align='left'");
$grid->column_orderby("Clasificador Presupuestario", "codigopres", "codigopres", "align='left'");
$grid->column_orderby("Ordinal", "ordinal", "ordinal", "align='left'");
$grid->column_orderby("Descripción", "denominacion", "denominacion", "align='left' NOWRAP");
$grid->add($this->url . "dataedit/create");
$grid->build();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "{$this->titp}";
//$data['content'] = $filter->output.$grid->output;
//$data['title'] = " $this->titp ";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function index()
{
$this->rapyd->load("datagrid", "datafilter2");
//$this->rapyd->uri->keep_persistence();
$filter = new DataFilter2("");
$filter->db->select(array("a.codigo", "a.denominacion", "b.nombre", "b.codigo eje"));
$filter->db->from("estruadm a");
$filter->db->join("uejecutora b", "a.uejecutora=b.codigo", "LEFT");
$filter->cod_ppla = new inputField("Código", "codigo");
$filter->cod_ppla->size = 15;
//$filter->cod_ppla->clause="likerigth";
$filter->cod_ppla->db_name = 'a.codigo';
$filter->titulo = new inputField("Denominación", "denominacion");
$filter->titulo->clause = "likerigth";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . '/dataedit/show/<#codigo#>', '<#codigo#>');
$grid = new DataGrid();
$veje = $this->input->post('veje');
//if($veje)
//$grid->db->();
$grid->order_by("codigo", "asc");
$grid->per_page = 20;
$grid->column_orderby("Código", $uri, "codigo");
$grid->column_orderby("Denominación", "denominacion", "denominacion", "align='left' NOWRAP");
$grid->column_orderby("Cod", "eje", "eje");
$grid->column_orderby("U. Ejecutora", "nombre", "nombre");
$grid->add($this->url . "/dataedit/create");
$grid->build();
//echo $grid->db->last_query();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "{$this->titp}";
//$data['content'] =$filter->output.$grid->output;
$data["head"] = $this->rapyd->get_head();
//$data['title'] =' Estructura Administrativa ';
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
//$this->rapyd->uri->keep_persistence();
$filter = new DataFilter2("", "sprv");
$filter->proveed = new inputField("Código", "proveed");
$filter->proveed->size = 13;
$filter->proveed->maxlength = 5;
$filter->nombre = new inputField("Nombre", "nombre");
$filter->nombre->size = 13;
$filter->nombre->maxlength = 40;
$filter->rif = new inputField("Rif", "rif");
$filter->rif->size = 13;
$filter->rif->maxlength = 12;
$filter->grupo = new dropdownField("Grupo", "grupo");
$filter->grupo->option("", "");
$filter->grupo->options("SELECT grupo,gr_desc,grupo FROM grpr ORDER BY gr_desc='01'");
$filter->grupo->style = "width:290px";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('presupuesto/sprv/dataedit/show/<#proveed#>', '<#proveed#>');
$grid = new DataGrid("");
$grid->order_by("proveed", "asc");
$grid->per_page = 20;
$grid->column_orderby("Código", $uri, "proveed", "align='center'");
$grid->column_orderby("Nombre", "nombre", "nombre", "align='left'NOWRAP");
$grid->column_orderby("R.I.F.", "rif", "rif", "align='center'");
$grid->add("presupuesto/sprv/dataedit/create");
$grid->build();
//$data['content'] = $filter->output.$grid->output;
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "Beneficiarios";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$this->rapyd->uri->keep_persistence();
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'cod_prov'), 'titulo' => 'Buscar Beneficiario');
$bSPRV = $this->datasis->p_modbus($mSPRV, "proveed");
$filter = new DataFilter2("Filtro de {$this->titp}", "pacom");
//$filter->db->where('status !=','F2');
//$filter->db->where('status !=','F3');
//$filter->db->where('status !=','F1');
$filter->id = new inputField("Número", "id");
$filter->id->size = 12;
$filter->id->clause = "likerigth";
$filter->cod_prov = new inputField("Beneficiario", 'cod_prov');
$filter->cod_prov->size = 6;
$filter->cod_prov->append($bSPRV);
$filter->cod_prov->rule = "required";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . 'dataedit/show/<#id#>', '<str_pad><#id#>|8|0|STR_PAD_LEFT</str_pad>');
$grid = new DataGrid("Lista de " . $this->titp);
$grid->order_by("id", "desc");
$grid->per_page = 20;
$grid->use_function('substr', 'str_pad', 'sta');
$grid->column("Número", $uri);
$grid->column("Beneficiario", "cod_prov");
$grid->column("O.Compra", "<number_format><#total2#>|2|,|.</number_format>", "align='right'");
$grid->column("Pago", "<number_format><#total2#>|2|,|.</number_format>", "align='right'");
//echo $grid->db->last_query();
$grid->add($this->url . "dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = " {$this->titp} ";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
