function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$this->rapyd->uri->keep_persistence();
$filter = new DataFilter("Filtro de Vendedores Y Cobradores", 'vend');
$filter->vendedor = new inputField("Codigo", "vendedor");
$filter->vendedor->size = 5;
$filter->nombre = new inputField("Nombre", "nombre");
$filter->nombre->size = 25;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('ventas/vend/dataedit/show/<#vendedor#>', '<#vendedor#>');
$grid = new DataGrid("Lista de Vendedores y Cobradores");
$grid->order_by("nombre", "asc");
$grid->per_page = 10;
$grid->column_orderby('Código', $uri, 'vendedor');
$grid->column_orderby('Nombre', 'nombre', 'nombre');
$grid->column_orderby('Tipo', 'tipo', 'tipo');
$grid->column_orderby('Dirección', 'direc1', 'direc1');
$grid->column_orderby('Teléfono', 'telefono', 'telefono');
$grid->add('ventas/vend/dataedit/create', 'Agregar Vendedor o Cobrador');
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = "<h1>Vendedores y Cobradores</h1>";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$this->rapyd->uri->keep_persistence();
$filter = new DataFilter("Filtro por Número", 'apan');
$filter->tipo = new inputField("Número", "numero");
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('inventario/anticipos/dataedit/show/<#numero#>', '<#numero#>');
$grid = new DataGrid("Lista de Aplicación de Anticipos");
$grid->order_by("numero", "asc");
$grid->per_page = 20;
$grid->column("Número", $uri);
$grid->column("Fecha", "fecha");
$grid->column("Tipo", "tipo");
$grid->column("Clipro", "clipro");
$grid->column("Nombre", "nombre");
$grid->column("Monto", "monto");
$grid->column("Reintegro", "reinte");
$grid->column("Observaciones", "observa1");
$grid->column(".", "observa2");
$grid->column("Transacc", "transac");
$grid->column("Estampa", "estampa");
$grid->column("Hora", "hora");
$grid->column("Usuario", "usuario");
$grid->add("inventario/anticipos/dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = "<h1>Aplicación de Anticipos</h1>";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$this->rapyd->uri->keep_persistence();
$filter = new DataFilter("Buscar", 'tarjeta');
$filter->tipo = new dropdownField("Tipo", "tipo");
$filter->tipo->options("SELECT tipo, nombre from tarjeta ORDER BY tipo");
$filter->tipo->style = "width:180px";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('ventas/tarjeta/dataedit/show/<#tipo#>', '<#tipo#>');
$grid = new DataGrid("Lista de Formas de Pago");
$grid->order_by("nombre", "asc");
$grid->per_page = 10;
$grid->column("Tipo", $uri);
$grid->column("Nombre", "nombre", "nombre");
$grid->column("Comisión", "comision");
$grid->column("Impuesto", "impuesto");
$grid->column("Mensaje", "mensaje");
$grid->add("ventas/tarjeta/dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = "<h1>Formas de Pago</h1>";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load('datafilter', 'datagrid');
$filter = new DataFilter($this->titp, 'parroquia');
$filter->id = new inputField('id', 'id');
$filter->id->rule = 'max_length[11]';
$filter->id->size = 13;
$filter->id->maxlength = 11;
$filter->nombre = new inputField('nombre', 'nombre');
$filter->nombre->rule = 'max_length[255]';
$filter->nombre->size = 257;
$filter->nombre->maxlength = 255;
$filter->buttons('reset', 'search');
$filter->build();
$uri = anchor($this->url . 'dataedit/show/<raencode><#id#></raencode>', '<#id#>');
$grid = new DataGrid('');
$grid->order_by('id');
$grid->per_page = 40;
$grid->column_orderby('id', "{$uri}", 'id', 'align="left"');
$grid->column_orderby('nombre', "nombre", 'nombre', 'align="left"');
$grid->add($this->url . 'dataedit/create');
$grid->build();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['head'] = $this->rapyd->get_head() . script('jquery.js');
$data['title'] = $this->titp;
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$this->rapyd->uri->keep_persistence();
$filter = new DataFilter("", 'nomina');
$filter->nombre = new inputField("Nombre", "nombre");
$filter->descrip = new inputField("Descripción", "descrip");
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('nomina/nomina/dataedit/show/<#numero#>/<#codigo#>/<#concepto#>/<#fecha#>', '<#numero#>');
$grid = new DataGrid("");
$grid->order_by("numero", "asc");
$grid->per_page = 20;
$grid->column_orderby("Número", $uri, "numero");
$grid->column_orderby("Nombre", "nombre", "nombre", "align='left'NOWRAP ");
$grid->column_orderby("Descripción", "descrip", "descrip", "align='left'NOWRAP ");
$grid->column_orderby("Formula", "formula", "formula", "align='left'NOWRAP ");
$grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center'NOWRAP");
$grid->add("nomina/nomina/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'] = " Nomina ";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$filter = new DataFilter("Filtro de Sucursales", 'sucu');
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 10;
$filter->sucursal = new inputField("Sucursal", "sucursal");
$filter->sucursal->size = 20;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('supervisor/sucu/dataedit/show/<#codigo#>', '<#codigo#>');
$grid = new DataGrid("Lista de Sucursales");
$grid->order_by("codigo", "asc");
$grid->per_page = 15;
$grid->column("Sucursal", $uri);
$grid->column("Nombre", "sucursal");
$grid->column("URL", "url");
$grid->column("Prefijo", "prefijo");
$grid->column("Proteo", "proteo");
$grid->add("supervisor/sucu/dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = "<h1>Sucursal</h1>";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$this->rapyd->uri->keep_persistence();
$filter = new DataFilter("Filtro por Descripción", 'conc');
$filter->concepto = new inputField("Concepto", "concepto");
$filter->concepto->size = 5;
$filter->descrip = new inputField("Descripción", "descrip");
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('nomina/conc/dataedit/show/<#concepto#>', '<#concepto#>');
$grid = new DataGrid("Lista de Conceptos");
$grid->order_by("concepto", "asc");
$grid->per_page = 20;
$grid->column_orderby("Concepto", $uri, 'concepto');
$grid->column("Tipo", "tipo");
$grid->column("Descripción", "descrip");
$grid->column("Tipoa", "tipoa");
//$grid->column("Fórmula","formula");
$grid->add("nomina/conc/dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = "<h1>Conceptos</h1>";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->datasis->modulo_id(102, 1);
$this->rapyd->load("datafilter", "datagrid");
$filter = new DataFilter("Filtro por Programas", "programas");
$filter->sect_pres = new dropdownField("Sector", "sect_pres");
$filter->sect_pres->option("", "");
$filter->sect_pres->options("SELECT sect_pres, CONCAT_WS(' ',sect_pres,nomb_sect) AS nomb_sect FROM sectores ORDER BY sect_pres");
$filter->sect_pres->style = 'width:300px;';
$filter->id_prog = new inputField("Identificador", "id_prog");
$filter->id_prog->size = 5;
$filter->prog_pres = new inputField("Código Programa", "prog_pres");
$filter->prog_pres->size = 5;
$filter->prog_pres->maxlength = 2;
$filter->nomb_prog = new inputField("Nombre Programa", "nomb_prog");
$filter->nomb_prog->size = 40;
$filter->nomb_prog->maxlength = 80;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('presupuesto/programas/dataedit/show/<#id_prog#>', '<#id_prog#>');
$grid = new DataGrid("Lista de Programas");
$grid->order_by("prog_pres", "asc");
$grid->column("Identificador", $uri, "align='left'");
$grid->column("Sector", "sect_pres", "align='left'");
$grid->column("Programa ", "prog_pres", "align='left'");
$grid->column("Nombre", "nomb_prog", "align='left'");
$grid->add("presupuesto/programas/dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = " Programas ";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$this->rapyd->uri->keep_persistence();
//filter
$filter = new DataFilter("Filtro de soporte", 'soporte');
$filter->usuario = new inputField("Usuario", "usuario");
$filter->estampa = new inputField("Estampa", "estampa");
$filter->titulo = new inputField("Titulo", "titulo");
$filter->comentario = new inputField("Comentario", "comentario");
$filter->buttons("reset", "search");
$filter->build();
$uri = "supervisor/sopor/dataedit/show/<#id#>";
$grid = new DataGrid("Filtro de soporte");
//$grid->order_by("nombre","asc");
$grid->per_page = 20;
$grid->column_detail("Usuario", "usuario", $uri);
$grid->column("Estampa", "estampa");
$grid->column("Titulo", "titulo");
$grid->column("Comentario", "comentario");
$grid->add("supervisor/soporte/dataedit/create");
$grid->build();
//grid
$data["crud"] = $filter->output . $grid->output;
$data["titulo"] = 'Soporte';
$content["content"] = $this->load->view('rapyd/crud', $data, true);
$content["rapyd_head"] = $this->rapyd->get_head();
$content["code"] = '';
$content["lista"] = "\r\n\t\t\t<h3>Editar o Agregar</h3>\r\n\t\t\t<div>Con esta pantalla se puede editar o agregar datos a la tabla scli del Modulo de Nómina</div>\r\n\t\t\t<div class='line'></div>\r\n\t\t\t<a href='#' onclick='window.close()'>Cerrar</a>\r\n\t\t\t<div class='line'></div>\n<br><br><br>\n";
$this->load->view('rapyd/tmpsolo', $content);
}
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$filter = new DataFilter("Filtro de Club de Compras");
$select = array("cedula", "cod_tar", "CONCAT_WS(' ',nombres,apellidos) AS nombre", "direc1");
$filter->db->select($select);
$filter->db->from('club');
$filter->nombre = new inputField("Nombre", "nombre");
$filter->nombre->size = 30;
$filter->nombre->db_name = "CONCAT_WS(' ',nombres,apellidos)";
$filter->cod_tar = new inputField("Tarjeta", "cod_tar");
$filter->cod_tar->size = 30;
$filter->cedula = new inputField("Cédula", "cedula");
$filter->cedula->size = 15;
$filter->buttons("reset", "search");
$filter->build();
$link = anchor("supermercado/club/dataedit/show/<#cod_tar#>", '<#nombre#>');
$grid = new DataGrid("Lista de Usuarios");
$grid->order_by("nombre", "asc");
$grid->per_page = 10;
$grid->column_orderby("Nombres", $link, "nombres");
$grid->column("Cédula", "cedula");
$grid->column("Tarjeta", "cod_tar");
$grid->column("Dirección", "direc1");
$grid->add("supermercado/club/dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data["head"] = $this->rapyd->get_head();
$data['title'] = '<h1>Modulo de Club de Compras</h1>';
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$filter = new DataFilter("", 'prof');
$filter->codigo = new inputField("Codigo", "codigo");
$filter->codigo->size = 20;
$filter->codigo->maxlength = 8;
$filter->profesion = new inputField("Profesion", "profesion");
$filter->profesion->size = 20;
$filter->profesion->maxlength = 40;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('nomina/prof/dataedit/show/<#codigo#>', '<#codigo#>');
$grid = new DataGrid("");
$grid->per_page = 15;
$grid->column_orderby("Codigo", $uri, "codigo");
$grid->column_orderby("Profesiones", "profesion", "profesion", "align='left'NOWRAP");
$grid->add("nomina/prof/dataedit/create");
$grid->build();
//$data['content'] = $filter->output.$grid->output;
$data['title'] = "Profesiones";
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$this->rapyd->uri->keep_persistence();
$filter = new DataFilter("", 'conc');
$filter->concepto = new inputField("Concepto", "concepto");
$filter->concepto->size = 5;
$filter->descrip = new inputField("Descripción", "descrip");
$filter->formula = new inputField("Formula", "formula");
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('nomina/conc/dataedit/show/<raencode><#concepto#></raencode>', '<#concepto#>');
$grid = new DataGrid("");
$grid->order_by("concepto", "asc");
$grid->per_page = 20;
$grid->column_orderby("Concepto", $uri, "concepto");
$grid->column_orderby("Tipo", "tipo", "tipo");
$grid->column_orderby("Descripción", "descrip", "descrip", "align='left'NOWRAP");
$grid->column_orderby("Tipoa", "tipoa", "tipoa");
//$grid->column("Fórmula","formula");
$grid->add("nomina/conc/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'] = "Conceptos";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function index()
{
$this->rapyd->load("datafilter", "datagrid");
$this->rapyd->uri->keep_persistence();
$filter = new DataFilter('Filtro');
$select = array("a.definicion", "b.nombre", "a.descrip", "a.id");
$filter->db->select($select);
$filter->db->from('crm_tipos AS a');
$filter->db->join('crm_definiciones AS b', 'a.definicion=b.id');
$filter->definicion = new dropdownField("DefiniciÓn", "definicion");
$filter->definicion->option("", "Seleccione");
$filter->definicion->options("SELECT id,nombre FROM crm_definiciones ORDER BY nombre");
$filter->definicion->rule = 'required';
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('crm/tipos/dataedit/show/<#id#>', '<#id#>');
$grid = new DataGrid('Lista');
$grid->order_by('a.id', 'asc');
$grid->per_page = 7;
$grid->column('id', $uri);
$grid->column_orderby('Definición', 'nombre', 'nombre');
$grid->column('Descripción', 'descrip');
$grid->add('crm/tipos/dataedit/create');
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = '<h1>Tipos</h1>';
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$this->rapyd->uri->keep_persistence();
$filter = new DataFilter("Filtro de Nomina", 'nomina');
$filter->nombre = new inputField("Nombre", "nombre");
$filter->descrip = new inputField("Descripción", "descrip");
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('nomina/nomina/dataedit/show/<#numero#>/<#codigo#>/<#concepto#>/<#fecha#>', '<#numero#>');
$grid = new DataGrid("Lista de Nomina");
$grid->order_by("numero", "asc");
$grid->per_page = 10;
$grid->column("Número", $uri);
$grid->column("Nombre", "nombre");
$grid->column("Descripción", "descrip");
$grid->column("Formula", "formula");
$grid->column("Fecha", "fecha");
$grid->add("nomina/nomina/dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = "<h1>Nomina</h1>";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->datasis->modulo_id(138, 1);
$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');
$this->rapyd->load("datafilter", "datagrid");
$bSPRV = $this->datasis->p_modbus($mSPRV, "proveed");
$mBANC = array('tabla' => 'banc', 'columnas' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'numcuent' => 'Cuenta', 'saldo' => 'Saldo'), 'filtro' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'numcuent' => 'Cuenta', 'saldo' => 'Saldo'), 'retornar' => array('codbanc' => 'codbanc'), 'where' => 'activo = "S"', 'titulo' => 'Buscar Bancos');
$bBANC = $this->datasis->p_modbus($mBANC, "banc");
$filter = new DataFilter("");
// $filter->db->select(array("fecha","a.tipo tipo","a.cod_prov cod_prov","a.codbanc codbanc1","cheque","a.id id","a.monto","a.observa observa","a.benefi benefi"));
$filter->db->from("mbanc");
//$filter->db->join("banc b" ,"a.codbanc=b.codbanc","left");
//$filter->db->join("sprv c" ,"a.cod_prov=c.proveed","left");
$filter->db->where("(status = 'A' OR status='AN' OR status='A2' OR status='NC' OR status='AN') ");
$filter->db->_escape_char = '';
$filter->db->_protect_identifiers = false;
$filter->id = new inputField("Ref.", 'id');
$filter->fecha = new dateonlyField("Fecha", "fecha");
$filter->fecha->dbformat = "Y-m-d";
$filter->fecha->size = 12;
$filter->cod_prov = new inputField("Beneficiario", 'cod_prov');
// $filter->cod_prov->db_name = "a.cod_prov";
$filter->cod_prov->size = 6;
$filter->cod_prov->append($bSPRV);
$filter->cod_prov->rule = "required";
$filter->codbanc = new inputField("Banco", 'codbanc');
// $filter->codbanc->db_name = "a.codbanc";
$filter->codbanc->size = 5;
$filter->codbanc->append($bBANC);
$filter->cheque = new inputField("Cheque", "cheque");
// $filter->cheque->size = 60;
// $filter->cheque->db_name = "a.cheque";
$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("");
$grid->db->_escape_char = '';
$grid->db->_protect_identifiers = false;
$grid->order_by("numero", "asc");
$grid->per_page = 20;
$grid->use_function('substr', 'str_pad');
$grid->column_orderby("Número", $uri, "id");
$grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center' ");
// $grid->column_orderby("Banco" ,"nombanco" ,"nombanco","align='left'NOWRAP");
$grid->column_orderby("Cheque", "cheque", "cheque");
$grid->column_orderby("Monto", "<number_format><#monto#>|2|,|.</number_format>", "monto", "align='right' ");
// $grid->column_orderby("Beneficiario" ,"proveed1" ,"proveed1" ,"align='left'NOWRAP");
$grid->column_orderby("Observasion", "observa", "observa", "align='left'NOWRAP");
//$grid->column("Tipo" ,"tipo" ,"align='center'");
//$grid->column("Estado" ,"status" ,"align='center'");
$grid->add($this->url . "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'] = "{$this->titp}";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function index()
{
$this->rapyd->load("datagrid", "datafilter");
$filter = new DataFilter("Filtro de Recetas", 'rece');
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 10;
$filter->descri1 = new inputField("Descripción", "descri1");
$filter->descri1->size = 30;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('hospitalidad/recetas/dataedit/show/<#codigo#>/', '<#codigo#>');
$grid = new DataGrid();
$grid->order_by("fecha", "desc");
$grid->per_page = 15;
$grid->column("Código", $uri);
$grid->column("Descripción", "descri1");
$grid->column("Precio", "<number_format><#precio#>|2</number_format>", "align=right");
$grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "align='center'");
$grid->column("Costo", "<number_format><#costo#>|2</number_format>", "align=right");
$grid->column("Rela", "rela", "align='center'");
$grid->add("hospitalidad/agregarrec");
$grid->build();
//echo $grid->db->last_query();
$data['content'] = $filter->output . $grid->output;
$data["head"] = $this->rapyd->get_head();
$data['title'] = '<h1>Recetas</h1>';
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$this->rapyd->uri->keep_persistence();
$filter = new DataFilter("Filtro de Conceptos", 'icon');
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 20;
$filter->cedula = new inputField("Concepto", "concepto");
$filter->cedula->size = 20;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('inventario/concepto/dataedit/show/<#codigo#>', '<#codigo#>');
$grid = new DataGrid("Lista de Conceptos");
$grid->order_by("codigo", "asc");
$grid->per_page = 20;
$grid->column("Código", $uri);
$grid->column("Concepto ", "concepto");
$grid->column("Gasto", "gasto");
$grid->column("Gastos de:", "gastode");
$grid->column("Ingreso", "ingreso");
$grid->column("Ingresos de:", "ingresod");
$grid->add("hospitalidad/concepto/dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = " Otros Conceptos ";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
//$this->datasis->modulo_id(101,1);
$this->rapyd->load("datafilter", "datagrid");
$filter = new DataFilter("", "presusol");
$filter->fondo = new inputField("Tipo", "tipo");
$filter->fondo->size = 20;
$filter->codigoadm = new inputField("Estructura Administrativa", "codigoadm");
$filter->codigoadm->size = 20;
$filter->codigopres = new inputField("Código Presupuesto", "codigopres");
$filter->codigopres->size = 20;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . '/dataedit/show/<#tipo#>/<#codigoadm#>/<#codigopres#>', '<#tipo#><#codigoadm#><#codigopres#>');
$uri_2 = anchor($this->url . '/dataedit/create/<raencode><#tipo#></raencode>/<#codigoadm#>/<#codigopres#>', 'Duplicar');
$grid = new DataGrid("Lista de Sectores");
$grid->order_by("codigoadm", "asc");
$grid->per_page = 20;
$grid->column("Tipo", $uri, "align='left'");
$grid->column("Estructura Adm.", "codigoadm", "align='left'");
$grid->column("Código Presup.", "codigopres", "align='left'");
$grid->column("Denominació", "denominacion", "align='left'");
$grid->column("Solicitado", "solicitado", "align='left'");
$grid->column("Asignado", "asignacion", "align='left'");
$grid->column("Duplicar", $uri_2, "align='center'");
$grid->add($this->url . "/dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = "Formulacion de Presupuesto";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$this->rapyd->uri->keep_persistence();
$filter = new DataFilter("", 'civa');
$filter->fecha = new dateonlyField("Fecha", "fecha", 'd/m/Y');
$filter->fecha->clause = $filter->fecha->clause = "where";
$filter->fecha->dbformat = "Y-m-d";
$filter->fecha->size = 12;
$filter->tasa = new inputField("Tasa", "Tasa");
$filter->tasa->size = 12;
$filter->tasa->maxlength = 6;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('tesoreria/civa/dataedit/show/<#fecha#>', '<dbdate_to_human><#fecha#></dbdate_to_human>');
$grid = new DataGrid("");
$grid->order_by("fecha", "asc");
$grid->per_page = 20;
$grid->column_orderby("Fecha", $uri, "fecha", "align='center'");
$grid->column_orderby("Tasa", "tasa", "tasa", "align='right' ");
$grid->column_orderby("Tasa Reducida ", "redutasa", "redutasa", "align='right' ");
$grid->column_orderby("Tasa Adicional", "sobretasa", "sobretasa", "align='right' ");
$grid->add("tesoreria/civa/dataedit/create");
$grid->build();
//echo $grid->db->last_query();
//$data['content'] = $filter->output.$grid->output;
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "Tasa de IVA";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->pi18n->cargar('i18n', 'dataedit');
$this->rapyd->load('datafilter', 'datagrid');
$this->rapyd->uri->keep_persistence();
$this->pi18n->msj('rifci', 'RIF o C.I.');
$filter = new DataFilter('Filtro', 'i18n');
$filter->modulo = new inputField('Módulo', 'modulo');
$filter->modulo->size = 20;
$filter->buttons('reset', 'search');
$filter->build();
$uri = anchor('supervisor/i18n/dataedit/modify/<#id#>', '<#id#>');
$grid = new DataGrid('Internacionalización');
$grid->order_by('id', 'asc');
$grid->per_page = 20;
$grid->column_orderby('ID', $uri, 'id');
$grid->column_orderby('Modulo', 'modulo', 'modulo');
$grid->column_orderby('Método', 'metodo', 'metodo');
$grid->column_orderby('País', 'pais', 'pais');
$grid->column_orderby('Campo', 'campo', 'campo');
$grid->add('supervisor/i18n/dataedit/create');
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['content'] .= $this->pi18n->fallas();
$data['title'] = heading('Internacionalización');
$data['head'] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$this->rapyd->uri->keep_persistence();
$filter = new DataFilter("", 'pres');
$filter->numero = new inputField("Número", "numero");
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('nomina/pres/dataedit/show/<#cod_cli#>/<#tipo_doc#>/<#numero#>', '<#numero#>');
$grid = new DataGrid("");
$grid->order_by("numero", "asc");
$grid->per_page = 20;
$grid->column_orderby("Número", $uri, "numero");
$grid->column_orderby("Nombre", "nombre", "nombre", "align='left'NOWRAP");
$grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center' ");
$grid->column_orderby("Tipo", "tipo_doc", "tipo_doc", "align='center' ");
$grid->column_orderby("Monto", "monto", "monto", "align='right' ");
// $grid->column("Observaciones","observ1");
// $grid->column(".","oberv2");
$grid->add("nomina/pres/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'] = " Adelantos de Prestaciones ";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load('datafilter', 'datagrid');
$filter = new DataFilter($this->titp, 'tingresos');
$filter->codigo = new inputField('Codigo', 'codigo');
$filter->codigo->rule = 'max_length[2]';
$filter->codigo->size = 4;
$filter->codigo->maxlength = 2;
$filter->descrip = new inputField('Descripción', 'descrip');
$filter->descrip->rule = 'max_length[100]';
$filter->descrip->size = 102;
$filter->descrip->maxlength = 100;
$filter->grupo = new inputField('Grupo', 'grupo');
$filter->grupo->rule = 'max_length[1]';
$filter->grupo->size = 3;
$filter->grupo->maxlength = 1;
$filter->buttons('reset', 'search');
$filter->build();
$uri = anchor($this->url . 'dataedit/show/<raencode><#codigo#></raencode>', '<#codigo#>');
$grid = new DataGrid('');
$grid->order_by('codigo');
$grid->per_page = 40;
$grid->column_orderby('Código', "{$uri}", 'codigo', 'align="left"');
$grid->column_orderby('Descripción', "descrip", 'descrip', 'align="left"');
$grid->column_orderby('Grupo', "grupo", 'grupo', 'align="left"');
$grid->add($this->url . 'dataedit/create');
$grid->build();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['head'] = $this->rapyd->get_head() . script('jquery.js');
$data['title'] = $this->titp;
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load('datafilter', 'datagrid');
$filter = new DataFilter($this->titp, 'r_interes');
$filter->ano = new inputField('Ano', 'ano');
$filter->ano->rule = 'trim';
$filter->ano->size = 13;
$filter->ano->maxlength = 11;
$filter->mes = new inputField('Mes', 'mes');
$filter->mes->rule = 'trim';
$filter->mes->size = 13;
$filter->mes->maxlength = 11;
$filter->monto = new inputField('Monto', 'monto');
$filter->monto->rule = 'trim|numeric';
$filter->monto->css_class = 'inputnum';
$filter->monto->size = 21;
$filter->monto->maxlength = 19;
$filter->buttons('reset', 'search');
$filter->build();
$uri = anchor($this->url . 'dataedit/show/<raencode><#ano#></raencode>/<raencode><#mes#></raencode>', '<#ano#>-<#mes#>');
$grid = new DataGrid('');
$grid->order_by(' ano desc, mes desc', '');
$grid->per_page = 40;
$grid->column_orderby('Ano', "{$uri}", 'ano', 'align="left"');
$grid->column_orderby('Mes', "<nformat><#mes#></nformat>", 'mes', 'align="right"');
$grid->column_orderby('Monto', "<nformat><#monto#></nformat>", 'monto', 'align="right"');
$grid->add($this->url . 'dataedit/create');
$grid->build();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['head'] = $this->rapyd->get_head() . script('jquery.js');
$data['title'] = $this->titp;
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$filter = new DataFilter("Filtro inventario fisico", 'maesfisico');
$filter->fechad = new dateonlyField("Desde", "fechad", 'd/m/Y');
$filter->fechad->clause = "where";
$filter->fechad->db_name = "fecha";
$filter->fechad->insertValue = date("Y-m-d", mktime(0, 0, 0, date("m"), date("d") - 30, date("Y")));
$filter->fechad->operator = ">=";
$filter->fechad->group = 'Fecha';
$filter->fechah = new dateonlyField("Hasta", "fechah", 'd/m/Y');
$filter->fechah->clause = "where";
$filter->fechah->db_name = "fecha";
$filter->fechah->insertValue = date("Y-m-d");
$filter->fechah->operator = "<=";
$filter->fechah->group = 'Fecha';
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('supermercado/efisico/dataedit/show/<#codigo#>/<#ubica#>/<#fecha#>', '<#codigo#>');
$grid = new DataGrid("Lista de productos inventariados");
//$grid->order_by("serial","asc");
$grid->per_page = 15;
$grid->column("Codigo", $uri);
$grid->column("Ubicación", "ubica");
$grid->column("Cantidad", "cantidad");
$grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "align='center'");
$grid->column("Usuario", "usuario");
$grid->add("supermercado/efisico/dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = "<h1>Inventario Físico Express</h1>";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
//$this->rapyd->uri->keep_persistence();
$filter = new DataFilter("Filtro de Carta", 'menu');
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 15;
$filter->descri1 = new inputField("Descripción", "descri1");
$filter->descri1->size = 35;
$filter->grupo = new dropdownField("Grupo", "grupo");
$filter->grupo->option("", "");
$filter->grupo->options("SELECT grupo,descri1 FROM grme ORDER BY grupo ");
$filter->grupo->style = "width:180px";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('hospitalidad/carta/dataedit/show/<#codigo#>', '<#codigo#>');
$grid = new DataGrid("Lista de Carta");
$grid->order_by("codigo", "asc");
$grid->per_page = 10;
$grid->column("Código", $uri);
$grid->column("Descripción ", "descri1");
$grid->column("Grupo", "descgru");
$grid->column("Base", "base");
$grid->column("Impuesto", "impuesto");
$grid->column("Precio", "precio");
$grid->column("Servicio", "servicio");
$grid->add("hospitalidad/carta/dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = "<h1>Carta</h1>";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$this->rapyd->uri->keep_persistence();
$modbus = array('tabla' => 'grcl', 'columnas' => array('grupo' => 'Codigo', 'gr_desc' => 'Descripción'), 'filtro' => array('grupo' => 'Código', 'gr_desc' => 'Descripción'), 'retornar' => array('grupo' => 'grupo'), 'titulo' => 'Buscar Grupo');
$boton = $this->datasis->modbus($modbus);
$filter = new DataFilter("Filtro Maestro de Gastos", 'mgas');
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 20;
$filter->cuenta = new inputField('Cuenta contable', 'cuenta');
$filter->cuenta->like_side = 'after';
$filter->descrip = new inputField("Descripción", "descrip");
$filter->descrip->size = 20;
$filter->grupo = new inputField("Grupo", "grupo");
$filter->grupo->size = 20;
$filter->grupo->append($boton);
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('finanzas/mgas/dataedit/show/<#codigo#>', '<#codigo#>');
$grid = new DataGrid("Lista de Maestro de Gastos");
$grid->order_by("codigo", "asc");
$grid->per_page = 15;
$grid->column_orderby("Código", $uri, 'codigo');
$grid->column("Tipo", "tipo");
$grid->column_orderby("Descripción", "descrip", 'descrip');
$grid->column_orderby("Grupo", "grupo", 'grupo');
$grid->column_orderby('Nombre del Grupo', 'nom_grup', 'nom_grup');
$grid->add("finanzas/mgas/dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = "<h1>Maestro de Gastos</h1>";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$this->rapyd->uri->keep_persistence();
$filter = new DataFilter("Filtro por Expediente", "bi_bienes");
$filter->id = new inputField("Código", "id");
$filter->id->size = 10;
$filter->nombre = new inputField("Nombre", "nombre");
$filter->nombre->size = 20;
$filter->descrip = new inputField("Descripción", "descrip");
$filter->descrip->size = 20;
$filter->modelo = new inputField("Modelo", "modelo");
$filter->modelo->size = 20;
$filter->color = new inputField("Color", "color");
$filter->color->size = 20;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('bienes/bi_bienes/dataedit/show/<#id#>', '<#id#>');
$grid = new DataGrid("Lista de muebles");
$grid->order_by("id", "asc");
$grid->per_page = 20;
$grid->column_orderby("Codigo", $uri, "id", "align='center'");
$grid->column_orderby("Nombren", "nombre", "nombre", "align='center'");
$grid->column_orderby("Color", "color", "color", "align='center'");
$grid->column_orderby("Modelo", "modelo", "moldelo", "align='center'");
$grid->column_orderby("Descripción", "descrip", "descrip", "align='left'");
// $grid->column_orderby("Duplicar" ,$uri_2 ,"align='center'");
$grid->add("bienes/bi_bienes/dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = "Bienes Muebles";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->uri->keep_persistence();
$this->rapyd->load('datafilter', 'datagrid');
$filter = new DataFilter('', 'gpt_pro');
$filter->parr = new inputField('Parámetro', 'parr');
$filter->parr->rule = 'trim|required';
$filter->parr->clause = '';
//$filter->submit = new submitField('Buscar', 'submitbtn');
//$filter->submit->in='parr';
$filter->buttons('reset', 'search');
$filter->build();
$uri = anchor($this->url . 'dataedit/show/<raencode><#id_pro#></raencode>', '<#nom_pro#>', 'target="framedetrepo" onclick="$(\'#cajafiltro\').hide();"');
//$uri = anchor($this->url.'dataedit/show/<raencode><#id_pro#></raencode>','<#nom_pro#>');
$grid = new DataGrid('Especialidades farmaceuticas');
if (strlen($filter->parr->newValue) > 0) {
$dbparr = $this->db->escape($filter->parr->newValue);
$grid->db->where('MATCH(nom_pro,pres_pro,lab_pro,gen_pro,mono_pro) AGAINST (' . $dbparr . ')');
}
$grid->order_by('nom_pro');
$grid->per_page = 15;
$grid->column_orderby('Nombre', $uri, 'nom_pro', 'align="left"');
$grid->column_orderby('Presentación', 'pres_pro', 'pres_pro', 'align="left"');
$grid->column_orderby('Laboratorio', 'lab_pro', 'lab_pro', 'align="left"');
//$grid->column_orderby('Cod. Pro','cod_pro','cod_pro','align="left"');
//$grid->column_orderby('Gen. Pro','gen_pro','gen_pro','align="left"');
$grid->build();
$data['filtro'] = $filter->output . $grid->output;
$data['content'] = '<script type="text/javascript"> $(function(){ $("#cajafiltro").show(); }); </script>';
//$data['content'].= $acti->output;
$data['content'] .= '<IFRAME src="' . site_url('farmacia/gpt_pro/dummy') . '" width="100%" height="500" scrolling="auto" frameborder="0" name="framedetrepo">iframe no son soportados</IFRAME>';
$data['head'] = $this->rapyd->get_head() . script('jquery.js') . script('jquery.highlight.js');
$data['title'] = heading($this->titp);
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load('datafilter', 'datagrid');
$filter = new DataFilter($this->titp, 'r_sector');
$filter->id = new inputField('Id', 'id');
$filter->id->rule = 'trim';
$filter->id->size = 13;
$filter->id->maxlength = 11;
$filter->descrip = new inputField('Descrip', 'descrip');
$filter->descrip->rule = 'trim';
$filter->descrip->size = 102;
$filter->descrip->maxlength = 100;
$filter->buttons('reset', 'search');
$filter->build();
$uri = anchor($this->url . 'dataedit/show/<raencode><#id#></raencode>', '<#id#>');
$grid = new DataGrid('');
$grid->order_by('id');
$grid->per_page = 40;
$grid->column_orderby('Id', "{$uri}", 'id', 'align="left"');
$grid->column_orderby('Descrip', "descrip", 'descrip', 'align="left"');
$grid->add($this->url . 'dataedit/create');
$grid->build();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['head'] = $this->rapyd->get_head() . script('jquery.js');
$data['title'] = $this->titp;
$this->load->view('view_ventanas', $data);
}
function index()
{
$this->rapyd->load("datagrid", "datafilter");
$filter = new DataFilter("Filtro de Plan de cuentas", 'cpla');
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->like_side = 'after';
$filter->codigo->size = 15;
$filter->descrip = new inputField("Descripción", "descrip");
$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 = 15;
$grid->column("Código", $uri);
$grid->column("Descripción", "descrip");
$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["head"] = $this->rapyd->get_head();
$data['title'] = '<h1>Plan de Cuentas</h1>';
$this->load->view('view_ventanas', $data);
}