Esempi di codice in PHP per DataGrid::column

Esempio n. 1

0

Mostra file

File: tablas.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter("Filtro de Tablas");
     $filter->db->from('doc_tablas');
     $filter->db->join('doc_campos', 'doc_tablas.nombre=doc_campos.tabla');
     $filter->db->groupby('doc_tablas.nombre');
     $filter->nombre = new inputField("Nombre", "nombre");
     $filter->nombre->size = 20;
     $filter->campo = new inputField("Campo", "campo");
     $filter->campo->size = 20;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('doc/tablas/dataedit/show/<#nombre#>', '<#nombre#>');
     $grid = new DataGrid("Lista de Tablas");
     $grid->order_by("nombre", "asc");
     $grid->per_page = 15;
     $grid->column("Nombre", $uri);
     $grid->column("Campo", "campo");
     $grid->column("Descripci&oacute;n", "referen");
     $grid->column("Comentario campo", "dcomment");
     $grid->add($this->url . "dataedit/create");
     $grid->build();
     //echo $grid->db->last_query();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = "Documentaci&oacute;n de Tablas";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 2

0

Mostra file

File: sucu.php Progetto: codethics/proteoerp

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $filter = new DataFilter("Filtro de Sucursales", 'sucu');
     $filter->codigo = new inputField("C&oacute;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);
 }

Esempio n. 3

0

Mostra file

File: barras.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->rapyd->load("datafilter2", "datagrid");
     $mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'C&oacute;odigo', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'C&oacute;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&oacute;digo", "codigo");
     $filter->descrip = new inputField("Descripci&oacute;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&iacute;culos");
     $grid->order_by("codigo", "asc");
     $grid->per_page = 20;
     $grid->use_function('str_replace');
     $grid->column("C&oacute;digo", $link);
     $grid->column("Descripci&oacute;n", "descrip");
     $grid->column("Precio 1", "precio1");
     $grid->column("Barras", "barras");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = " Lista de Art&iacute;culos ";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 4

0

Mostra file

File: programas.php Progetto: enderochoa/tortuga

 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&oacute;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);
 }

Esempio n. 5

0

Mostra file

File: agregarped.php Progetto: codethics/proteoerp

 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&oacute;digo", $uri);
     $grid->column("Descripci&oacute;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&iacute;culos</h1>';
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 6

0

Mostra file

File: cpla.php Progetto: codethics/proteoerp

 function index()
 {
     $this->rapyd->load("datagrid", "datafilter");
     $filter = new DataFilter("Filtro de Plan de cuentas", 'cpla');
     $filter->codigo = new inputField("C&oacute;digo", "codigo");
     $filter->codigo->like_side = 'after';
     $filter->codigo->size = 15;
     $filter->descrip = new inputField("Descripci&oacute;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&oacute;digo", $uri);
     $grid->column("Descripci&oacute;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);
 }

Esempio n. 7

0

Mostra file

File: tipos.php Progetto: codethics/proteoerp

 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&Oacute;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&oacute;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);
 }

Esempio n. 8

0

Mostra file

File: civa.php Progetto: codethics/proteoerp

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter("Filtro de Cambio de IVA", 'civa');
     $filter->fecha = new dateonlyField("Fecha", "fecha", 'd/m/Y');
     $filter->fecha->clause = $filter->fecha->clause = "where";
     $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('finanzas/civa/dataedit/show/<#fecha#>', '<dbdate_to_human><#fecha#></dbdate_to_human>');
     $grid = new DataGrid("Lista de Cambio de IVA");
     $grid->order_by("fecha", "asc");
     $grid->per_page = 20;
     $grid->column("Fecha", $uri);
     $grid->column("Tasa", "tasa");
     $grid->column("Tasa Reducida", "redutasa");
     $grid->column("Tasa Adicional", "sobretasa");
     $grid->add("finanzas/civa/dataedit/create");
     $grid->build();
     //echo $grid->db->last_query();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = "<h1>Cambio de Iva</h1>";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 9

0

Mostra file

File: trabajo.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->rapyd->load("dataform", "datagrid");
     $modbus = array('tabla' => 'usuario', 'columnas' => array('us_codigo' => 'C&oacute;digo', 'us_nombre' => 'Nombre'), 'filtro' => array('us_nombre' => 'nombre'), 'retornar' => array('us_codigo' => 'usuario'), 'titulo' => 'Buscar Usuario');
     $filter = new DataForm('/supervisor/trabajo/filteredgrid/search/osp');
     $filter->mes = new dateonlyField("Mes", "mes", 'm/Y');
     $filter->mes->clause = "where";
     $filter->mes->operator = "=";
     $filter->mes->size = 8;
     $filter->mes->dbformat = 'Ym';
     $filter->mes->insertValue = date("Y-m-d");
     $filter->usuario = new inputField("C&oacute;digo de usuario", "usuario");
     $filter->usuario->size = 11;
     $filter->usuario->append($this->datasis->modbus($modbus));
     $filter->submit('manda', 'Buscar');
     $filter->build_form();
     /*
     $mSQL="(SELECT fecha, count(*) AS cant FROM bitacora WHERE usuario='DAVID' GROUP BY fecha ) UNION
     (SELECT a.fecha, 0 AS cant FROM dim_tiempo AS a LEFT JOIN  bitacora as b ON a.fecha=b.fecha AND b.usuario='DAVID'
     WHERE a.fecha BETWEEN (SELECT MIN(fecha) FROM bitacora) AND (SELECT MAX(fecha) FROM bitacora) AND b.fecha IS NULL) ORDER BY fecha";
     */
     $content = '';
     if ($this->input->post('manda')) {
         $usr = $this->input->post('usuario') ? ' AND b.usuario="' . $this->input->post('usuario') . '"' : '';
         $fechad = '(SELECT MIN(fecha) FROM bitacora)';
         $fechah = '(SELECT MAX(fecha) FROM bitacora)';
         if ($this->input->post('mes')) {
             $acum = explode('/', $filter->mes->value);
             $fechad = $acum[1] . $acum[0] . '01';
             $fechah = $acum[1] . $acum[0] . '31';
         }
         $mSQL = "SELECT a.fecha, semana FROM dim_tiempo AS a LEFT JOIN  bitacora as b ON a.fecha=b.fecha {$usr} WHERE a.fecha BETWEEN {$fechad} AND {$fechah} AND b.fecha IS NULL";
         //echo $mSQL;
         $sema = array('Lunes', 'Martes', 'Miercoles', 'Jueves', 'Viernes', 'Sabado', 'Domingo');
         $query = $this->db->query($mSQL);
         $data = array();
         foreach ($query->result() as $row) {
             $pasa = array();
             $pasa['fecha'] = $row->fecha;
             if ($row->semana > 5) {
                 $pasa['cant'] = $sema[$row->semana - 1];
             } else {
                 $pasa['cant'] = '<b>' . $sema[$row->semana - 1] . '</b>';
             }
             $data[] = $pasa;
         }
         $query->free_result();
         //grid
         $grid = new DataGrid("Lista de Bitacora", $data);
         $grid->per_page = 31;
         $grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>");
         $grid->column("Semana", "<#cant#>");
         $grid->build();
         $content = $grid->output;
     }
     $data['content'] = $filter->output . $content;
     $data["head"] = $this->rapyd->get_head();
     $data['title'] = ' Dias NO trabajados ';
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 10

0

Mostra file

File: sectores.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->datasis->modulo_id(101, 1);
     $this->rapyd->load("datafilter", "datagrid");
     //
     $filter = new DataFilter("Filtro por Sectores", "sectores");
     $filter->id_sect = new inputField("Identificador", "id_sect");
     $filter->id_sect->size = 5;
     $filter->sect_pres = new inputField("C&oacute;digo Sector", "sect_pres");
     $filter->sect_pres->size = 5;
     $filter->nomb_sect = new inputField("Nombre", "nomb_sect");
     $filter->nomb_sect->size = 40;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('presupuesto/sectores/dataedit/show/<#id_sect#>', '<#id_sect#>');
     $grid = new DataGrid("Lista de Sectores");
     $grid->order_by("sect_pres", "asc");
     $grid->column("Identificador", $uri, "align='left'");
     $grid->column("Sector", "sect_pres", "align='left'");
     $grid->column("Nombre", "nomb_sect", "align='left'");
     $grid->add("presupuesto/sectores/dataedit/create");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = " Sectores ";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 11

0

Mostra file

File: catalogo.php Progetto: enderochoa/tortuga

 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&oacute;digo", "codigo");
     $filter->codigo->size = 15;
     $filter->codigo->append($this->bSINV);
     $filter->buttons("reset", "search");
     $filter->build();
     $grid = new DataGrid("Lista de Art&iacute;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&oacute;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&iacute;culos ';
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 12

0

Mostra file

File: generar.php Progetto: codethics/proteoerp

 function index()
 {
     $this->datasis->modulo_id($this->modulo, 1);
     $this->rapyd->load("datagrid", "dataform", "fields");
     $control = $this->uri->segment(4);
     $checkbox = '<input type="checkbox" name="genera[]" value="<#modulo#>" CHECKED>';
     $grid = new DataGrid('Seleccione los m&oacute;dulos que desea generar');
     $grid->db->select('modulo, descripcion');
     $grid->db->from('`reglascont`');
     $grid->db->groupby('modulo');
     $grid->db->orderby('modulo,regla');
     $grid->column("M&oacute;dulo", "modulo");
     $grid->column("Descripci&oacute;n", "descripcion");
     $grid->column('Generar', $checkbox, 'align="center"');
     $grid->build();
     $form = new DataForm('contabilidad/generar/procesar');
     $form->title('Rango de fecha para la Generaci&oacute;n');
     $form->fechai = new dateonlyField("Fecha Desde", "fechai", "d/m/Y");
     $form->fechaf = new dateonlyField("Fecha Hasta", "fechaf", "d/m/Y");
     $form->fechaf->size = $form->fechai->size = 10;
     $form->fechai->insertValue = $this->input->post('fechai') ? $this->input->post('fechai') : date("Ymd");
     $form->fechaf->insertValue = $this->input->post('fechaf') ? $this->input->post('fechaf') : date("Ymd");
     $form->tabla = new containerField('tabla', $grid->output);
     if ($control) {
         $form->control = new containerField('control', 'Contabilidad Generada');
     }
     //$form->submit("btn_submit","Generar Depurado");
     $form->build_form();
     $data['script'] = "<script type='text/javascript'>\n\t\tvar handlerFunc = function(t) {\n\t\t\tdocument.getElementById('preloader').style.display='none';\n\t\t\tnew Effect.Opacity('contenido', {duration:0.5, from:0.3, to:1.0});\n\t\t\talert(t.responseText);\n\t\t}\n\n\t\tvar errFunc = function(t) {\n\t\t\tdocument.getElementById('preloader').style.display='none';\n\t\t\tnew Effect.Opacity('contenido', {duration:0.5, from:0.3, to:1.0});\n\t\t\talert('Error ' + t.status + ' -- ' + t.statusText);\n\t\t}\n\n\t\tfunction generar() {\n\t\t\tnew Effect.toggle('preloader', 'appear');\n\t\t\tnew Effect.Opacity('contenido', {duration:0.5, from:1.0, to:0.3});\n\t\t\tnew Ajax.Request('" . site_url('contabilidad/generar/procesar') . "',{\n\t\t\t method: 'post',\n\t\t\t parameters : Form.serialize('df1'),\n\t\t\t onSuccess:handlerFunc,\n\t\t\t onFailure:errFunc});\n\t\t}\n\t\t</script>";
     $data['extras'] = "<div id='preloader' style='display: none;\tposition:absolute; left:40%; top:40%; font-family:Verdana, Arial, Helvetica, sans-serif;'>\n\t\t\t<center>" . image("loading4.gif") . "<br>" . image("loadingBarra.gif") . "<br>\n\t\t\t<b>Generando . . . </b>\n\t\t\t</center>\n\t\t</div>";
     $data['content'] = $form->output . "<input type=button value='Generar' onclick='generar()'>";
     $data["head"] = $this->rapyd->get_head() . script("prototype.js") . script("scriptaculous.js") . script("effects.js");
     $data['title'] = "<h1>Generar Contabilidad</h1>";
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 13

0

Mostra file

File: conversiones.php Progetto: codethics/proteoerp

 function datafilter()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter("Filtro de Conversiones", 'conv');
     $filter->fecha = new dateonlyField("Fecha", "fecha");
     $filter->fecha->size = 15;
     $filter->fecha->maxlength = 15;
     $filter->fecha->rule = "trim";
     $filter->numero = new inputField("N&uacute;mero", "numero");
     $filter->numero->size = 15;
     $filter->almacen = new inputField("Almacen", "almacen");
     $filter->almacen->size = 15;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('inventario/conversiones/dataedit/show/<#numero#>', '<#numero#>');
     $grid = new DataGrid("Lista de Conversiones");
     $grid->use_function('dbdate_to_human');
     $grid->order_by("numero", "asc");
     $grid->per_page = 10;
     $grid->column("N&uacute;mero", $uri);
     $grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>");
     $grid->column("Almacen", "almacen");
     $grid->column("Usuario", "usuario");
     $grid->add("inventario/conversiones/dataedit/create");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = "<h1>Conversiones</h1>";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 14

0

Mostra file

File: carg.php Progetto: codethics/proteoerp

 function filteredgrid()
 {
     $this->rapyd->load("datafilter2", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter2("Filtro por Cargo", 'carg');
     $filter->cargo = new inputField("C&oacute;digo", "cargo");
     $filter->cargo->size = 3;
     $filter->cargo->clause = "likerigth";
     $filter->descrip = new inputField("Descripci&oacute;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&oacute;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);
 }

Esempio n. 15

0

Mostra file

File: agregar.php Progetto: codethics/proteoerp

 function detalles($control = NULL)
 {
     $this->rapyd->load("datagrid");
     $mSQL = "SELECT * FROM scst WHERE control='{$control}'";
     $query = $this->db->query($mSQL);
     if ($query->num_rows() > 0) {
         $pdata = $query->row_array();
     }
     $grid = new DataGrid();
     $grid->db->select = array('codigo', 'descrip', 'cantidad', 'costo', 'importe');
     $grid->db->from('itscst');
     $grid->db->where('control', $control);
     $grid->order_by("codigo", "desc");
     //$grid->per_page = 15;
     $uri = anchor("/compras/agregar/mdetalle/{$control}/modify/<#id#>", '<#codigo#>');
     $grid->column("C&oacute;digo", $uri);
     $grid->column("Descripci&oacute;n", "descrip");
     $grid->column("Cantidad", "cantidad", "align='right'");
     $grid->column("Precio", "costo", "align='right'");
     $grid->column("Importe", "importe", "align='right'");
     $grid->add("compras/agregar/mdetalle/{$control}/create");
     $grid->add("compras/agregar/encab/modify/{$control}/", 'Modificar encabezado');
     $grid->build();
     $pdata['items'] = $grid->output;
     $data['content'] = $this->load->view('view_agcompras', $pdata, true);
     $data["head"] = $this->rapyd->get_head();
     $data['title'] = '<h1>Agregar Art&iacute;culos</h1>';
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 16

0

Mostra file

File: agregarnd.php Progetto: codethics/proteoerp

 function detalles($numero = NULL)
 {
     $this->rapyd->load("datagrid");
     $mSQL = "SELECT DATE_FORMAT(fecha, '%d/%m/%Y')as fecha,factura,numero,cod_cli,nombre,DATE_FORMAT(fechafa, '%d/%m/%Y')as fechafa FROM snot WHERE numero='{$numero}'";
     $query = $this->db->query($mSQL);
     if ($query->num_rows() > 0) {
         $pdata = $query->row_array();
     }
     $grid = new DataGrid();
     $grid->db->select = array('codigo', 'descrip', 'cant', 'saldo', 'entrega');
     $grid->db->from('itsnot');
     $grid->db->where('numero', $numero);
     $grid->order_by("codigo", "desc");
     //$grid->per_page = 15;
     $uri = anchor("/ventas/agregarnd/mdetalle/{$numero}/modify/<#id#>", '<#codigo#>');
     $grid->column("C&oacute;digo", $uri);
     $grid->column("Descripci&oacute;n", "descrip");
     $grid->column("Cantidad", "cant", "align='right'");
     $grid->column("Precio", "saldo", "align='right'");
     $grid->column("Importe", "entrega", "align='right'");
     $grid->add("ventas/agregarnd/mdetalle/{$numero}/create");
     $grid->build();
     $pdata['items'] = $grid->output;
     $data['content'] = $this->load->view('view_agnotadespacho', $pdata, true);
     $data["head"] = $this->rapyd->get_head();
     $data['title'] = '<h1>Agregar Art&iacute;culos</h1>';
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 17

0

Mostra file

File: seriales.php Progetto: codethics/proteoerp

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter("Filtro de Seriales", 'seri');
     $filter->codigo = new inputField("C&oacute;digo", "codigo");
     $filter->codigo->size = 20;
     $filter->serial = new inputField("Serial", "serial");
     $filter->serial->size = 20;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('inventario/seriales/dataedit/show/<raencode><#codigo#></raencode>', '<#codigo#>');
     $uri_2 = anchor('inventario/seriales/dataedit/create/<raencode><#codigo#></raencode>/<raencode><#serial#></raencode>', 'Duplicar');
     $grid = new DataGrid("Lista de Seriales");
     $grid->order_by("codigo", "asc");
     $grid->per_page = 20;
     $grid->column("C&oacute;digo", $uri);
     $grid->column("Serial", "serial");
     $grid->column("Descripci&oacute;n", "descrip");
     $grid->column("Fecha C.", "<dbdate_to_human><#fechac#></dbdate_to_human>", "align='center'");
     $grid->column("Compra", "compra");
     $grid->column("Proveedor", "proveed");
     $grid->column("Fecha V.", "<dbdate_to_human><#fechav#></dbdate_to_human>", "align='center'");
     $grid->column("Venta", "venta");
     $grid->column("Cliente", "cliente");
     $grid->column("Duplicar", $uri_2, "align='center'");
     $grid->add("inventario/seriales/dataedit/create");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = "<h1>Seriales</h1>";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 18

0

Mostra file

File: bi_moto.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter("Filtro por Expediente", "bi_moto");
     $filter->espediente = new inputField("Numero expediente", "expediente");
     $filter->espediente->size = 20;
     $filter->marca = new inputField("Marca", "marca");
     $filter->marca->size = 20;
     $filter->modelo = new inputField("Modelo", "modelo");
     $filter->modelo->size = 20;
     $filter->placa = new inputField("Placa", "placa");
     $filter->placa->size = 20;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('bienes/bi_moto/dataedit/show/<#id#>', '<#id#>');
     $grid = new DataGrid("Lista de Motos");
     $grid->order_by("expediente", "asc");
     $grid->per_page = 20;
     $grid->column("Id", $uri, "align='center'");
     $grid->column("Expediente", "expediente", "align='center'");
     $grid->column_orderby("Marca", "marca", "marca", "align='left'");
     $grid->column_orderby("Modelo", "modelo", "modelo", "align='center'");
     $grid->column_orderby("A&ntilde;o", "anio", "anio", "align='center'");
     $grid->column_orderby("Color", "color", "color", "align='center'");
     $grid->column_orderby("Placa", "placa", "placa", "align='center'");
     $grid->column_orderby("Tipo", "tipo", "tipo", "align='left'");
     //		$grid->column_orderby("Duplicar"             ,$uri_2                        ,"align='center'");
     $grid->add("bienes/bi_moto/dataedit/create");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = "Motos";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 19

0

Mostra file

File: nomina.php Progetto: codethics/proteoerp

 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&oacute;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&uacute;mero", $uri);
     $grid->column("Nombre", "nombre");
     $grid->column("Descripci&oacute;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);
 }

Esempio n. 20

0

Mostra file

File: usuarios.php Progetto: codethics/proteoerp

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $filter = new DataFilter("Filtro de Usuarios", 'usuario');
     $filter->us_codigo = new inputField("C&oacute;digo Usuario", "us_codigo");
     $filter->us_codigo->size = 15;
     $filter->us_nombre = new inputField("Nombre", "us_nombre");
     $filter->us_nombre->size = 15;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('supervisor/usuarios/dataedit/show/<#us_codigo#>', '<#us_codigo#>');
     $uri2 = anchor('supervisor/usuarios/cclave/modify/<#us_codigo#>', 'Cambiar clave');
     $uri3 = anchor('supervisor/usuarios/accesos/<#us_codigo#>', 'Asignar Accesos');
     $grid = new DataGrid("Lista de Usuarios");
     $grid->order_by("us_codigo", "asc");
     $grid->per_page = 10;
     $grid->column("C&oacute;digo", $uri);
     $grid->column("Nombre", "us_nombre");
     $grid->column("Supervisor", "supervisor", 'align="center"');
     $grid->column("Cambio clave", $uri2, 'align="center"');
     $grid->column("Asignar Accesos", $uri3, 'align="center"');
     $grid->add("supervisor/usuarios/dataedit/create");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = "<h1>Usuarios</h1>";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 21

0

Mostra file

File: club.php Progetto: codethics/proteoerp

 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&eacute;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&eacute;dula", "cedula");
     $grid->column("Tarjeta", "cod_tar");
     $grid->column("Direcci&oacute;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);
 }

Esempio n. 22

0

Mostra file

File: muro.php Progetto: codethics/proteoerp

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $filter = new DataFilter("Filtro de Muro", 'muro');
     $filter->envia = new inputField("Envia", "envia");
     $filter->envia->size = 20;
     $filter->envia->maxlength = 15;
     $filter->recibe = new inputField("Recibe", "recibe");
     $filter->recibe->size = 20;
     $filter->recibe->maxlength = 15;
     $filter->mensaje = new inputField("Mensaje", "mensaje");
     $filter->mensaje->size = 50;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('supervisor/muro/dataedit/show/<#codigo#>', '<#codigo#>');
     $grid = new DataGrid("Lista de Muro");
     $grid->per_page = 15;
     $grid->column("Codigo", $uri);
     $grid->column("Envia", "envia");
     $grid->column("Recibe", "recibe");
     $grid->column("Mensaje", "mensaje");
     $grid->add("supervisor/muro/dataedit/create");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = "<h1>Muro</h1>";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 23

0

Mostra file

File: sopor.php Progetto: enderochoa/tortuga

 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&oacute;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);
 }

Esempio n. 24

0

Mostra file

File: invgasto.php Progetto: codethics/proteoerp

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter("Filtro de Inventario de Gastos", 'mgas');
     $filter->codigo = new inputField("C&oacute;digo", "codigo");
     $filter->codigo->size = 15;
     $filter->descrip = new inputField("Descripci&oacute;n", "descrip");
     $filter->descrip->size = 35;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('finanzas/invgasto/dataedit/show/<#codigo#>', '<#codigo#>');
     $grid = new DataGrid("Inventario de Gastos");
     $grid->order_by("descrip", "asc");
     $grid->per_page = 7;
     $grid->column("C&oacute;digo", $uri);
     $grid->column("Descripci&oacute;n", "descrip", "descrip");
     $grid->column("Tipo", "tipo");
     $grid->column("Grupo", "grupo");
     $grid->column("Nombre", "nom_grup");
     $grid->add("finanzas/invgasto/dataedit/create");
     $grid->build();
     $data["crud"] = $filter->output . $grid->output;
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = "<h1>Inventario de Gastos</h1>";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 25

0

Mostra file

File: efisico.php Progetto: codethics/proteoerp

 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&oacute;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&iacute;sico Express</h1>";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 26

0

Mostra file

File: bi_terreno.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     //		$this->rapyd->uri->keep_persistence();
     $filter = new DataFilter("Filtro por Expediente", "bi_terreno");
     $filter->expediente = new inputField("Numero expediente", "expediente");
     $filter->expediente->size = 20;
     $filter->denominacion = new inputField("Denominaci&oacute;n", "denominacion");
     $filter->denominacion->size = 20;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('bienes/bi_terreno/dataedit/show/<#id#>', '<#id#>');
     $grid = new DataGrid("Lista de terrenos");
     $grid->order_by("expediente", "asc");
     $grid->per_page = 20;
     $grid->column("Id", $uri, "align='center'");
     $grid->column("Expediente", "expediente", "align='center'");
     $grid->column_orderby("Est.Propietario", "est_propietario", "est_propietario", "align='left'");
     $grid->column_orderby("Denominaci&oacute;n", "denominacion", "denominacion");
     //		$grid->column_orderby("Uso","uso" ,"uso"                    ,"align='center'");
     //		$grid->column_orderby("Estado"          ,"estado","estado"                     ,"align='center'");
     $grid->column_orderby("Municipio", "municipio", "municipio", "align='center'");
     $grid->column_orderby("Direccion", "direccion", "direccion", "align='left'");
     $grid->add("bienes/bi_terreno/dataedit/create");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = "Terrenos";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 27

0

Mostra file

File: conc.php Progetto: codethics/proteoerp

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter("Filtro por Descripci&oacute;n", 'conc');
     $filter->concepto = new inputField("Concepto", "concepto");
     $filter->concepto->size = 5;
     $filter->descrip = new inputField("Descripci&oacute;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&oacute;n", "descrip");
     $grid->column("Tipoa", "tipoa");
     //$grid->column("F&oacute;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);
 }

Esempio n. 28

0

Mostra file

File: grupomenu.php Progetto: codethics/proteoerp

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter("Filtro de Grupo Menu", 'grme');
     $filter->grupo = new inputField("Grupo", "grupo");
     $filter->grupo->size = 5;
     $filter->descrip = new dropdownField("Descripci&oacute;n", "descri1");
     $filter->descrip->option("", "");
     $filter->descrip->options("SELECT grupo,descri1 FROM grme ORDER BY grupo ");
     $filter->descrip->style = "width:180px";
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('hospitalidad/grupomenu/dataedit/show/<#grupo#>', '<#grupo#>');
     $grid = new DataGrid("Lista de Grupo Menu");
     $grid->order_by("grupo", "asc");
     $grid->per_page = 10;
     $grid->column("Grupo", $uri);
     $grid->column("Descripci&oacute;n", "descri1");
     $grid->column("Cuenta", "cuenta");
     $grid->add("hospitalidad/grupomenu/dataedit/create");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = "<h1>Grupo Menu</h1>";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 29

0

Mostra file

File: tarjeta.php Progetto: codethics/proteoerp

 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&oacute;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);
 }

Esempio n. 30

0

Mostra file

File: dpbi.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter("Filtro de Departamentos", "dpbi");
     $filter->codigo = new inputField("C&oacute;digo Departamento", "codigo");
     $filter->codigo->size = 20;
     $filter->nombre = new inputField("Nombre Departamento", "nombre");
     $filter->nombre->size = 20;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor($this->url . 'dataedit/show/<#id#>', '<#codigo#>');
     $uri_2 = anchor($this->url . 'dataedit/create/<#id#>', 'Duplicar');
     $grid = new DataGrid("Lista de Departamentos");
     $grid->order_by("codigo", "asc");
     $grid->per_page = 20;
     $grid->column("C&oacute;digo Departamento", $uri, "align='center'");
     $grid->column("Nombre", "nombre", "align='left'");
     $grid->column("Descripci&oacute;n", "descrip", "align='left'");
     $grid->column("Cuenta", "cuenta", "align='center'");
     $grid->column("Duplicar", $uri_2, "align='center'");
     $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);
 }

Esempi in PHP per DataGrid::column