PHP DataFilter::build方法代码示例

 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&oacute;digo', $uri, 'vendedor');
     $grid->column_orderby('Nombre', 'nombre', 'nombre');
     $grid->column_orderby('Tipo', 'tipo', 'tipo');
     $grid->column_orderby('Direcci&oacute;n', 'direc1', 'direc1');
     $grid->column_orderby('Tel&eacute;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&oacute;n de Anticipos");
     $grid->order_by("numero", "asc");
     $grid->per_page = 20;
     $grid->column("N&uacute;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&oacute;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&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);
 }

 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&uacute;mero", $uri, "numero");
     $grid->column_orderby("Nombre", "nombre", "nombre", "align='left'NOWRAP  ");
     $grid->column_orderby("Descripci&oacute;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&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);
 }

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

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

 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&oacute;n", "descrip", "descrip", "align='left'NOWRAP");
     $grid->column_orderby("Tipoa", "tipoa", "tipoa");
     //$grid->column("F&oacute;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&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);
 }

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

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