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->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->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, '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"); //$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(); $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->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("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", "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 $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 detalles($numero = NULL) { $this->rapyd->load("datagrid"); $mSQL = "SELECT numero,DATE_FORMAT(fecha, '%d/%m/%Y')as fecha,vd,cod_cli,rifci,nombre,direc,dire1,presup, anticipo,iva,totals,referen,totalg,DATE_FORMAT(vence, '%d/%m/%Y')as vence FROM pfac WHERE numero='{$numero}'"; $query = $this->db->query($mSQL); if ($query->num_rows() > 0) { $pdata = $query->row_array(); } $grid = new DataGrid(); $grid->db->select = array('codigoa', 'desca', 'cana', 'preca', 'tota'); $grid->db->from('itpfac'); $grid->db->where('numa', $numero); $grid->order_by("codigoa", "desc"); //$grid->per_page = 15; $uri = anchor("/ventas/agregarnd/mdetalle/<#id#>/modify/", '<#codigoa#>'); $grid->column("Código", $uri); $grid->column("Descripción", "desca"); $grid->column("Cantidad", "cana", "align='right'"); $grid->column("Precio", "preca", "align='right'"); $grid->column("Importe", "tota", "align='right'"); $grid->add("ventas/agregarped/mdetalle/{$numero}/create"); $grid->build(); $pdata['items'] = $grid->output; $data['content'] = $this->load->view('view_agpedidos', $pdata, true); $data["head"] = $this->rapyd->get_head(); $data['title'] = '<h1>Agregar Artículos</h1>'; $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"); $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"); $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"); $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"); $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->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("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->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, '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"); $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("", '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"); $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 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->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 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->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 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 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); }