本文整理汇总了PHP中DataGrid::use_function方法的典型用法代码示例。如果您正苦于以下问题:PHP DataGrid::use_function方法的具体用法?PHP DataGrid::use_function怎么用?PHP DataGrid::use_function使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DataGrid
的用法示例。
在下文中一共展示了DataGrid::use_function方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: filteredgrid
function filteredgrid()
{
//$this->datasis->modulo_id(75,1);
$this->rapyd->load("datafilter2", "datagrid");
$filter = new DataFilter2("", "su_trasla");
$filter->numero = new inputField("Número", "numero");
$filter->numero->size = 15;
$filter->fecha = new dateonlyField("Fecha", "fecha");
$filter->fecha->dbformat = "Y-m-d";
$filter->fecha->size = 12;
$filter->de = new dropdownField("De", "de");
$filter->de->option("", "");
$filter->de->options("SELECT codigo,descrip FROM su_caub");
$filter->para = new dropdownField("Para", "para");
$filter->para->option("", "");
$filter->para->options("SELECT codigo,descrip FROM su_caub");
$filter->concepto = new inputField("Concepto", "concepto");
$filter->concepto->size = 40;
$filter->status = new dropdownField("Estado", "status");
$filter->status->option("", "");
$filter->status->option("P", "Sin Ejecutar");
$filter->status->option("C", "Ejecutado");
$filter->status->style = "width:100px";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . 'dataedit/show/<#numero#>', '<str_pad><#numero#>|8|0|STR_PAD_LEFT</str_pad>');
function sta($status)
{
switch ($status) {
case "P":
return "Sin Ejecutar";
break;
case "C":
return "Ejecutado";
break;
}
}
$grid = new DataGrid("");
$grid->order_by("numero", "desc");
$grid->per_page = 20;
$grid->use_function('substr', 'str_pad');
$grid->use_function('sta');
$grid->column_orderby("Número", $uri, "numero");
$grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center'");
$grid->column_orderby("De", "de", "de", "align='right'");
$grid->column_orderby("Para", "para", "para", "align='right'");
$grid->column_orderby("Concepto", "concepto", "concepto", "align='left' NOWRAP");
$grid->column_orderby("Total", "total", "total", "align='right'");
$grid->column_orderby("Estado", "<sta><#status#></sta>", "status", "align='center'NOWRAP");
$grid->add($this->url . "dataedit/create");
$grid->build();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = $this->titp;
$data["head"] = script("jquery.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
示例2: filteredgrid
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$script = '
$(function() {
});
';
$filter = new DataFilter2("", "bi_trasla");
$filter->script($script);
$filter->numero = new inputField("Número", "numero");
$filter->numero->size = 15;
$filter->fecha = new dateonlyField("Fecha", "fecha");
$filter->fecha->dbformat = "Y-m-d";
$filter->fecha->size = 12;
$filter->concepto = new inputField("Concepto", "concepto");
$filter->concepto->size = 40;
$filter->status = new dropdownField("Estado", "status");
$filter->status->option("", "");
$filter->status->option("P", "Sin Ejecutar");
$filter->status->option("C", "Ejecutado");
$filter->status->style = "width:100px";
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . '/dataedit/show/<#numero#>', '<str_pad><#numero#>|8|0|STR_PAD_LEFT</str_pad>');
function sta($status)
{
switch ($status) {
case "P":
return "Sin Ejecutar";
break;
case "C":
return "Ejecutado";
break;
//case "O":return "Ordenado Pago";break;
//case "A":return "Anulado";break;
}
}
$grid = new DataGrid("");
$grid->order_by("numero", "desc");
$grid->per_page = 20;
$grid->use_function('substr', 'str_pad');
$grid->use_function('sta');
$grid->column_orderby("Número", $uri, "numero");
$grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha");
$grid->column_orderby("Concepto", "concepto", "concepto");
$grid->column_orderby("Estado", "<sta><#status#></sta>", "status");
$grid->add($this->url . "/dataedit/create");
$grid->build();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = $this->tits;
$data["head"] = script("jquery.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
示例3: filteredgrid
function filteredgrid()
{
//filteredgrid//
$this->rapyd->load("datafilter", "datagrid");
$this->rapyd->uri->keep_persistence();
//filter
$filter = new DataFilter("Filtro de Facturas");
$filter->db->select("fmay.*, scli.*");
$filter->db->from("fmay");
$filter->db->join("scli", "scli.cliente=fmay.cod_cli", "LEFT");
$filter->numero = new inputField("Numero", "numero");
$filter->fecha = new dateField("Fecha", "fecha", "d/m/Y");
// $filter->cod_cli = new inputField("Numero", "numero");
// $filter->title = new inputField("Numero", "numero");
$filter->cod_cli = new dropdownField("Cliente", "cod_cli");
$filter->cod_cli->option("", "");
$filter->cod_cli->options("SELECT cliente, nombre FROM scli ORDER BY nombre");
$filter->buttons("reset", "search");
$filter->build();
$uri = "import/crudsamples/dataedit/show/<#numero#>";
//grid
$grid = new DataGrid("Article List");
$grid->use_function("callback_test");
$grid->order_by("numero", "desc");
$grid->per_page = 5;
$grid->use_function("substr");
$grid->column_detail("Numero", "numero", $uri, "size=14");
$grid->column_orderby("fecha", "fecha", "fecha");
$grid->column("Nombre", "nombre");
$grid->column("stotal", "<number_format><#stotal#>|2</number_format>", "align=right");
$grid->column("impuesto", "<number_format><#impuesto#>|2</number_format>", "align=right");
$grid->column("gtotal", "<number_format><#gtotal#>|2</number_format>", "align=right");
$grid->column("callback test", "<callback_test><#numero#>|3</callback_test>");
$grid->add("import/crudsamples/dataedit/create");
$grid->build();
$data["crud"] = $filter->output . $grid->output;
//endfilteredgrid//
//$this->_session_dump();
$content["content"] = $this->load->view('rapyd/crud', $data, true);
$content["rapyd_head"] = $this->rapyd->get_head();
$content["code"] = '';
/*
$content["code"] = highlight_code_file(THISFILE, "//filteredgrid//", "//endfilteredgrid//");
$content["code"] .= '<br/><br/> <span style="color: #FF8000">//callback test function<br /></span><br/>';
$content["code"] .= highlight_code_file(THISFILE, "//callbacktest//", "//endcallbacktest//");
*/
$this->load->view('rapyd/template', $content);
}
示例4: array
function filteredgrid2()
{
$this->rapyd->load("datafilter2", "datagrid");
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'rif' => 'Rif', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre', 'rif' => 'Rif'), 'retornar' => array('proveed' => 'cod_prov'), 'titulo' => 'Buscar Beneficiario');
$bSPRV = $this->datasis->p_modbus($mSPRV, "sprv");
$filter = new DataFilter2($this->titp);
$filter->nomi = new inputField("Número", "nomina");
$filter->nomi->size = 15;
//$filter->numero->clause="likerigth";
$filter->cod_prov = new inputField("Proveedor", "cod_prov");
$filter->cod_prov->rule = 'required';
$filter->cod_prov->size = 5;
$filter->cod_prov->append($bSPRV);
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . '/dataedit/show/<#nomina#>', '<str_pad><#nomina#>|8|0|STR_PAD_LEFT</str_pad>');
$grid = new DataGrid("Lista de Deducciones de Nómina");
$grid->db->select(array("nomina", "b.nombre", "SUM(monto)total"));
$grid->db->from('retenomi');
$grid->db->join('sprv b', 'retenomi.cod_prov = b.proveed', 'LEFT');
$grid->db->groupby('nomina');
$grid->db->orderby('nomina', 'desc');
$grid->use_function('substr', 'str_pad');
$grid->per_page = 20;
$grid->column("Número", $uri);
$grid->column("Proveedor", "nombre", 'align="left"');
$grid->column("Total", "<number_format><#total#>|2|,|.</number_format>", 'align="right"');
$grid->add($this->url . "dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = " {$this->titp} ";
$data["head"] = script("jquery.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
示例5: filteredgrid
function filteredgrid()
{
//$this->datasis->modulo_id(101,1);
$this->rapyd->load("datafilter", "datagrid");
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'cod_prov'), 'titulo' => 'Buscar Beneficiario');
$bSPRV = $this->datasis->p_modbus($mSPRV, "proveed");
$filter = new DataFilter("", "rendi");
$filter->db->where('MID(status,1,1) ', 'R');
$filter->fecha = new dateonlyField("Fecha", "fecha");
$filter->fecha->dbformat = "Y-m-d";
$filter->fecha->size = 12;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . 'dataedit/show/<#numero#>', '<str_pad><#numero#>|8|0|STR_PAD_LEFT</str_pad>');
$grid = new DataGrid("");
$grid->order_by("numero", "desc");
$grid->per_page = 20;
$grid->use_function('substr', 'str_pad');
$grid->column_orderby("Número", $uri, "numero");
$grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center'");
$grid->column_orderby("Pago", "<number_format><#total#>|2|,|.</number_format>", "total", "align='right'");
$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);
}
示例6: filteredgrid
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$filter = new DataFilter("Filtro de Transferencias", "stra");
$filter->numero = new inputField("Número", "numero");
$filter->numero->size = 15;
$filter->fecha = new dateonlyField("Fecha", "fecha");
$filter->fecha->size = 12;
$filter->envia = new inputField("Envia", "envia");
$filter->envia->size = 12;
$filter->recibe = new inputField("Recibe", "recibe");
$filter->recibe->size = 12;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('inventario/stra/dataedit/show/<#numero#>', '<#numero#>');
$grid = new DataGrid("Lista de transferencias");
$grid->order_by("numero", "desc");
$grid->per_page = 20;
$grid->use_function("substr");
$grid->column("N�mero", $uri);
$grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "align='center'");
$grid->column("Env�a", "envia", "envia");
$grid->column("Recibe", "recibe");
$grid->column("Observaci�n", "observ1");
//echo $grid->db->last_query();
$grid->add("inventario/stra/dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = " Transferencias ";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
示例7: filteredgrid
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);
}
示例8: index
function index()
{
$this->rapyd->load('datafilter', 'datagrid');
$this->rapyd->uri->keep_persistence();
$filter = new DataFilter('Contenedor', $this->prefijo . 'contenedor');
$filter->descripcion = new inputField('Descripción', 'descripcion');
$filter->titulo = new inputField('Titulo', 'titulo');
$filter->buttons('reset', 'search');
$filter->build();
$uri = anchor('crm/contenedor/dataedit/show/<#id#>', '<str_pad><#id#>|8|0|0</str_pad>');
$curl = anchor('crm/contenedor/comentario/<#id#>/create', 'Comentario');
$grid = new DataGrid('Lista de Contenedores');
$grid->use_function('str_pad');
//$grid->order_by('caja','asc');
$grid->per_page = 7;
$grid->column('Número', $uri);
$grid->column_orderby('Derivado', 'derivado', 'derivado');
$grid->column_orderby('Tipo', 'tipo', 'tipo');
$grid->column_orderby('Estatus', 'status', 'status');
$grid->column_orderby('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human>', 'fecha');
$grid->column_orderby('Cierre', '<dbdate_to_human><#cierre#></dbdate_to_human>', 'cierre');
$grid->column_orderby('Titulo', 'titulo', 'titulo');
$grid->column_orderby('Cliente', 'cliente', 'cliente');
$grid->column_orderby('Proveed', 'proveed', 'proveed');
$grid->column_orderby('Resumen', 'resumen', 'resumen');
$grid->column_orderby('Condiciones', 'condiciones', 'condiciones');
//$grid->column('Accion',$curl);
$grid->add('crm/contenedor/dataedit/create');
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = '<h1>Contenedor</h1>';
$data['head'] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
示例9: filteredgrid
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$filter = new DataFilter("Filtro", "ocompra");
$filter->numero = new inputField("Número", "numero");
$filter->numero->size = 15;
$filter->fecha = new dateonlyField("Fecha", "fecha");
$filter->fecha->size = 12;
$filter->uejecutora = new inputField("Unidad Ejecutora", "uejecutora");
$filter->uejecutora->size = 40;
$filter->beneficiario = new inputField("Beneficiario", "beneficiario");
$filter->beneficiario->size = 40;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor('presupuesto/ocompra/dataedit/show/<#numero#>', '<str_pad><#numero#>|8|0|STR_PAD_LEFT</str_pad>');
$grid = new DataGrid("Ordenes de compras");
$grid->order_by("numero", "desc");
$grid->per_page = 20;
$grid->use_function('substr', 'str_pad');
$grid->column("Número", $uri);
$grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "align='center'");
$grid->column("Unidad Ejecutora", "uejecutora");
$grid->column("Beneficiario", "beneficiario");
//echo $grid->db->last_query();
$grid->add("presupuesto/ocompra/dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = " Ordenes de Compra ";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
示例10: filteredgrid
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'cod_prov'), 'titulo' => 'Buscar Beneficiario');
//$bSPRV=$this->datasis->p_modbus($mSPRV,"proveed");
$filter = new DataFilter("");
$filter->db->select(array("a.numero", "a.fecha", "a.tipo", "a.uejecutora", "a.estadmin", "a.fondo", "a.cod_prov", "a.pago", "a.total2", "a.status", "b.nombre nombre1", "c.nombre nombre2"));
$filter->db->from("odirect a");
$filter->db->join("uejecutora b", "a.uejecutora=b.codigo");
$filter->db->join("sprv c", "c.proveed =a.cod_prov");
$filter->db->where('MID(status,1,1) ', 'B');
$filter->db->where('multiple =', 'S');
$filter->numero = new inputField("Número", "numero");
$filter->numero->size = 12;
$filter->tipo = new dropdownField("Orden de ", "tipo");
$filter->tipo->option("", "");
$filter->tipo->option("Compra", "Compra");
$filter->tipo->option("Servicio", "Servicio");
$filter->tipo->style = "width:100px;";
$filter->fecha = new dateonlyField("Fecha", "fecha");
$filter->fecha->size = 12;
//$filter->uejecutora = new inputField("Unidad Ejecutora", "uejecutora");
//$filter->uejecutora->size=12;
$filter->uejecutora = new dropdownField("U.Ejecutora", "uejecutora");
$filter->uejecutora->option("", "Seccionar");
$filter->uejecutora->options("SELECT codigo,nombre FROM uejecutora ORDER BY nombre");
$filter->uejecutora->onchange = "get_uadmin();";
$filter->cod_prov = new inputField("Beneficiario", 'cod_prov');
$filter->cod_prov->size = 6;
//$filter->cod_prov->append($bSPRV);
$filter->cod_prov->rule = "required";
$filter->beneficiario = new inputField("Beneficiario", "beneficiario");
$filter->beneficiario->size = 60;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . 'dataedit/modify/<#numero#>', '<str_pad><#numero#>|8|0|STR_PAD_LEFT</str_pad>');
$grid = new DataGrid("");
$grid->order_by("numero", "desc");
$grid->per_page = 20;
$grid->use_function('substr', 'str_pad');
$grid->column_orderby("Número", $uri, "numero");
$grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center'");
$grid->column_orderby("Unidad Ejecutora", "nombre1", "uejecutora", "NOWRAP");
$grid->column_orderby("Beneficiario", "nombre2", "c.nombre", "NOWRAP");
$grid->column_orderby("Pago", "<number_format><#total2#>|2|,|.</number_format>", "total", "align='right'");
//$grid->column("Beneficiario" ,"cod_prov" ,"cod_prov" );
//$grid->column("Tipo" ,"tipo" ,"align='center'");
// $grid->column("Devolución","<number_format><#devo#>|2|,|.</number_format>","align='rigth'");
$grid->build();
//echo $grid->db->last_query();
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "{$this->titp}";
//"";
//$data['content'] = $filter->output.$grid->output;
//$data['title'] = " $this->titp ";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
示例11: filteredgrid
function filteredgrid()
{
$this->bSINV = $this->datasis->modbus($this->sinv);
$this->rapyd->load("datafilter2", "datagrid");
//$this->rapyd->uri->keep_persistence();
rapydlib("prototype");
$filter = new DataFilter2("Filtro por Producto", 'catalogo');
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 15;
$filter->codigo->append($this->bSINV);
$filter->buttons("reset", "search");
$filter->build();
$grid = new DataGrid("Lista de Artículos");
$grid->add("inventario/catalogo/dataedit/create");
$grid->order_by("codigo", "asc");
$grid->per_page = 20;
$link = anchor('/inventario/catalogo/dataedit/show/<#id#>', '<#codigo#>');
$grid->use_function('str_replace');
$grid->column("Código", $link);
$grid->column("Fecha", "<dbdate_to_human><#estampa#></dbdate_to_human>");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data["head"] = script("tabber.js") . script("prototype.js") . $this->rapyd->get_head() . script("scriptaculous.js") . script("effects.js");
$data['title'] = ' Lista de Artículos ';
$this->load->view('view_ventanas', $data);
}
示例12: filteredgrid
function filteredgrid()
{
//$this->datasis->modulo_id(101,1);
$this->rapyd->load("datafilter", "datagrid");
$filter = new DataFilter("Filtro de {$this->titp}", "oreinte");
$filter->fecha = new dateonlyField("Fecha", "fecha");
$filter->fecha->size = 12;
$filter->odirect = new dropdownField("Pago Directo", "odirect");
$filter->odirect->option("", "");
$filter->odirect->options("SELECT numero,numero a FROM odirect ORDER BY numero");
$filter->observa = new inputField("Observación", "observa");
$filter->observa->size = 60;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . 'dataedit/show/<#numero#>', '<str_pad><#numero#>|8|0|STR_PAD_LEFT</str_pad>');
$grid = new DataGrid("Lista de " . $this->titp);
$grid->order_by("numero", "desc");
$grid->per_page = 20;
$grid->use_function('substr', 'str_pad');
$grid->column("Número", $uri);
$grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "align='center'");
$grid->column("Pago Directo", "odirect");
//$grid->column("Monto" ,"<number_format><#total#>|2|,|.</number_format>","align='rigth'");
$grid->column("Observación", "observa");
//echo $grid->db->last_query();
$grid->add($this->url . "dataedit/create");
$grid->build();
$data['content'] = $filter->output . $grid->output;
$data['title'] = " {$this->titp} ";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
示例13: filteredgrid
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);
}
示例14: datafilter
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ú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ú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);
}
示例15: filteredgrid
function filteredgrid()
{
$this->rapyd->load("datafilter2", "datagrid");
$script = '';
$filter = new DataFilter2("");
$filter->db->from("view_sumi_saldo");
$filter->script($script);
$filter->codigo = new inputField("Código", "codigo");
$filter->codigo->size = 15;
$filter->descrip = new inputField("Descripción", "descrip");
$filter->descrip->size = 40;
$filter->unidad = new inputField("Unidad", "unidad");
$filter->unidad->size = 40;
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . 'redi/<raencode><#codigo#></raencode>', '<#codigo#>');
$grid = new DataGrid("");
$grid->order_by("codigo", "asc");
$grid->per_page = 100;
$grid->use_function('substr', 'str_pad', 'sta');
$grid->column_orderby("Código", $uri, "codigo");
$grid->column_orderby("Descripción", "descrip", "descrip", "align='left' ");
$grid->column_orderby("Unidad", "unidad", "unidad", "align='left' ");
$grid->column_orderby("Cantidad", "cantidad", "cantidad", "align='left' NOWRAP");
//$grid->add($this->url."/dataedit/create");
$grid->build();
//$data['content'] = $filter->output.$grid->output;
$data['filtro'] = $filter->output;
$data['content'] = $grid->output;
$data['title'] = $this->tits;
$data['script'] = script("jquery.js") . "\n";
$data["head"] = script("jquery.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}