Esempi di codice in PHP per DataGrid::column_orderby

Esempio n. 1

0

Mostra file

File: itfac.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "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' => '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&uacute;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&uacute;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&oacute;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);
 }

Esempio n. 2

0

Mostra file

File: r_interes.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->rapyd->load('datafilter', 'datagrid');
     $filter = new DataFilter($this->titp, 'r_interes');
     $filter->ano = new inputField('Ano', 'ano');
     $filter->ano->rule = 'trim';
     $filter->ano->size = 13;
     $filter->ano->maxlength = 11;
     $filter->mes = new inputField('Mes', 'mes');
     $filter->mes->rule = 'trim';
     $filter->mes->size = 13;
     $filter->mes->maxlength = 11;
     $filter->monto = new inputField('Monto', 'monto');
     $filter->monto->rule = 'trim|numeric';
     $filter->monto->css_class = 'inputnum';
     $filter->monto->size = 21;
     $filter->monto->maxlength = 19;
     $filter->buttons('reset', 'search');
     $filter->build();
     $uri = anchor($this->url . 'dataedit/show/<raencode><#ano#></raencode>/<raencode><#mes#></raencode>', '<#ano#>-<#mes#>');
     $grid = new DataGrid('');
     $grid->order_by(' ano desc, mes desc', '');
     $grid->per_page = 40;
     $grid->column_orderby('Ano', "{$uri}", 'ano', 'align="left"');
     $grid->column_orderby('Mes', "<nformat><#mes#></nformat>", 'mes', 'align="right"');
     $grid->column_orderby('Monto', "<nformat><#monto#></nformat>", 'monto', 'align="right"');
     $grid->add($this->url . 'dataedit/create');
     $grid->build();
     $data['filtro'] = $filter->output;
     $data['content'] = $grid->output;
     $data['head'] = $this->rapyd->get_head() . script('jquery.js');
     $data['title'] = $this->titp;
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 3

0

Mostra file

File: bi_bienes.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter("Filtro por Expediente", "bi_bienes");
     $filter->id = new inputField("C&oacute;digo", "id");
     $filter->id->size = 10;
     $filter->nombre = new inputField("Nombre", "nombre");
     $filter->nombre->size = 20;
     $filter->descrip = new inputField("Descripci&oacute;n", "descrip");
     $filter->descrip->size = 20;
     $filter->modelo = new inputField("Modelo", "modelo");
     $filter->modelo->size = 20;
     $filter->color = new inputField("Color", "color");
     $filter->color->size = 20;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('bienes/bi_bienes/dataedit/show/<#id#>', '<#id#>');
     $grid = new DataGrid("Lista de muebles");
     $grid->order_by("id", "asc");
     $grid->per_page = 20;
     $grid->column_orderby("Codigo", $uri, "id", "align='center'");
     $grid->column_orderby("Nombren", "nombre", "nombre", "align='center'");
     $grid->column_orderby("Color", "color", "color", "align='center'");
     $grid->column_orderby("Modelo", "modelo", "moldelo", "align='center'");
     $grid->column_orderby("Descripci&oacute;n", "descrip", "descrip", "align='left'");
     //              $grid->column_orderby("Duplicar"             ,$uri_2                        ,"align='center'");
     $grid->add("bienes/bi_bienes/dataedit/create");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = "Bienes Muebles";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 4

0

Mostra file

File: cheque.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->datasis->modulo_id(138, 1);
     $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' => '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&oacute;odigo', 'banco' => 'Banco', 'numcuent' => 'Cuenta', 'saldo' => 'Saldo'), 'filtro' => array('codbanc' => 'C&oacute;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);
 }

Esempio n. 5

0

Mostra file

File: pres.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter("", 'pres');
     $filter->numero = new inputField("N&uacute;mero", "numero");
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('nomina/pres/dataedit/show/<#cod_cli#>/<#tipo_doc#>/<#numero#>', '<#numero#>');
     $grid = new DataGrid("");
     $grid->order_by("numero", "asc");
     $grid->per_page = 20;
     $grid->column_orderby("N&uacute;mero", $uri, "numero");
     $grid->column_orderby("Nombre", "nombre", "nombre", "align='left'NOWRAP");
     $grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center'    ");
     $grid->column_orderby("Tipo", "tipo_doc", "tipo_doc", "align='center'    ");
     $grid->column_orderby("Monto", "monto", "monto", "align='right'     ");
     //		$grid->column("Observaciones","observ1");
     //		$grid->column(".","oberv2");
     $grid->add("nomina/pres/dataedit/create");
     $grid->build();
     //$data['content'] = $filter->output.$grid->output;
     $data['filtro'] = $filter->output;
     $data['content'] = $grid->output;
     $data['script'] = script("jquery.js") . "\n";
     $data['title'] = " Adelantos de Prestaciones ";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 6

0

Mostra file

File: tingresos.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->rapyd->load('datafilter', 'datagrid');
     $filter = new DataFilter($this->titp, 'tingresos');
     $filter->codigo = new inputField('Codigo', 'codigo');
     $filter->codigo->rule = 'max_length[2]';
     $filter->codigo->size = 4;
     $filter->codigo->maxlength = 2;
     $filter->descrip = new inputField('Descripci&oacute;n', 'descrip');
     $filter->descrip->rule = 'max_length[100]';
     $filter->descrip->size = 102;
     $filter->descrip->maxlength = 100;
     $filter->grupo = new inputField('Grupo', 'grupo');
     $filter->grupo->rule = 'max_length[1]';
     $filter->grupo->size = 3;
     $filter->grupo->maxlength = 1;
     $filter->buttons('reset', 'search');
     $filter->build();
     $uri = anchor($this->url . 'dataedit/show/<raencode><#codigo#></raencode>', '<#codigo#>');
     $grid = new DataGrid('');
     $grid->order_by('codigo');
     $grid->per_page = 40;
     $grid->column_orderby('C&oacute;digo', "{$uri}", 'codigo', 'align="left"');
     $grid->column_orderby('Descripci&oacute;n', "descrip", 'descrip', 'align="left"');
     $grid->column_orderby('Grupo', "grupo", 'grupo', 'align="left"');
     $grid->add($this->url . 'dataedit/create');
     $grid->build();
     $data['filtro'] = $filter->output;
     $data['content'] = $grid->output;
     $data['head'] = $this->rapyd->get_head() . script('jquery.js');
     $data['title'] = $this->titp;
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 7

0

Mostra file

File: uejecuta.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->datasis->modulo_id(40, 1);
     $this->rapyd->load("datafilter2", "datagrid");
     //
     $filter = new DataFilter2("", "uejecutora");
     $filter->codigo = new inputField("C&oacute;digo", "codigo");
     $filter->codigo->size = 5;
     //$filter->codigo->clause="likerigth";
     $filter->nombre = new inputField("Nombre", "nombre");
     $filter->nombre->size = 40;
     $filter->nombre->clause = "likerigth";
     //$filter->director = new inputField("Director", "director");
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('presupuesto/uejecuta/dataedit/show/<#codigo#>', '<#codigo#>');
     $grid = new DataGrid("");
     $grid->order_by("codigo", "asc");
     $grid->column_orderby("Unidades Ejecutoras", $uri, "codigo", "align='left'      ");
     //$grid->column_orderby("Codigo administrativo","codigoadm"    ,"codigoadm"     ,"align='left'NOWRAP");
     $grid->column_orderby("Nombre", "nombre", "nombre", "align='left'NOWRAP");
     $grid->column_orderby("Director", "director", "director", "align='left'NOWRAP");
     $grid->add("presupuesto/uejecuta/dataedit/create");
     $grid->build();
     $data['content'] = $grid->output;
     $data['filtro'] = $filter->output;
     $data['title'] = "Unidades Ejecutoras";
     //"  ";
     $data["script"] = script("jquery.js") . "\n";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 8

0

Mostra file

File: tsprv.php Progetto: codethics/proteoerp

 function filteredgrid()
 {
     $this->rapyd->load('datafilter', 'datagrid');
     $filter = new DataFilter($this->titp, 'tsprv');
     $filter->codigo = new inputField('codigo', 'codigo');
     $filter->codigo->rule = 'max_length[5]';
     $filter->codigo->size = 7;
     $filter->codigo->maxlength = 5;
     $filter->nombre = new textareaField('nombre', 'nombre');
     $filter->nombre->rule = 'max_length[8]';
     $filter->nombre->cols = 70;
     $filter->nombre->rows = 4;
     $filter->buttons('reset', 'search');
     $filter->build();
     $uri = anchor($this->url . 'dataedit/show/<raencode><#codigo#></raencode>', '<#codigo#>');
     $grid = new DataGrid('');
     $grid->order_by('codigo');
     $grid->per_page = 40;
     $grid->column_orderby('C&oacute;digo', "{$uri}", 'codigo', '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'] = heading($this->titp);
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 9

0

Mostra file

File: divi.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter("", 'divi');
     $filter->division = new inputField("Divisi&oacute;n", "division");
     $filter->division->size = 8;
     $filter->descrip = new inputField("Descripcion", "descrip");
     $filter->descrip->size = 30;
     $filter->codigoadm = new inputField("Est. Admin", "codigoadm");
     $filter->fondo = new inputField("Fondo", "fondo");
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('nomina/divi/dataedit/show/<#division#>', '<#division#>');
     $grid = new DataGrid("");
     $grid->order_by("division", "asc");
     $grid->per_page = 20;
     $grid->column_orderby("Divisi&oacute;n", $uri, "division", "alingn='left'NOWRAP");
     $grid->column_orderby("Descripci&oacute;n", "descrip", "descrip", "alingn='left'NOWRAP");
     $grid->column_orderby("Estructura Administrativo", "codigoadm", "codigoadm", "alingn='left'NOWRAP");
     $grid->column_orderby("F. Financiamiento", "fondo", "fondo", "alingn='left'NOWRAP");
     $grid->add("nomina/divi/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'] = "Divisiones";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 10

0

Mostra file

File: bi_linea.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $filter = new DataFilter("Filtro de " . $this->titp, $this->tabla);
     $filter->grupo = new dropdownField("Grupo", "grupo");
     $filter->grupo->option("", "");
     $filter->grupo->option(2, "2 Muebles");
     $filter->grupo->option(1, "1 Inmuebles");
     $filter->codigo = new inputField("C&oacute;digo", "codigo");
     $filter->codigo->size = 10;
     $filter->descrip = new inputField("Descripci&oacute;n", "descrip");
     $filter->descrip->size = 20;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor($this->url . '/dataedit/show/<raencode><#codigo#></raencode>', '<#codigo#>');
     $grid = new DataGrid("Lista de " . $this->titp);
     $grid->order_by("codigo", "asc");
     $grid->per_page = 20;
     $grid->column_orderby("C&oacute;digo", $uri, "codigo");
     $grid->column_orderby("Descripci&oacute;n", "descrip", "descrip");
     $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);
 }

Esempio n. 11

0

Mostra file

File: negocio.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->rapyd->load('datafilter', 'datagrid');
     $filter = new DataFilter($this->titp, 'negocio');
     $filter->codigo = new inputField('Codigo', 'codigo');
     $filter->codigo->rule = 'max_length[5]';
     $filter->codigo->size = 7;
     $filter->codigo->maxlength = 5;
     $filter->nombre = new inputField('Nombre', 'nombre');
     $filter->nombre->rule = 'max_length[20]';
     $filter->nombre->size = 22;
     $filter->nombre->maxlength = 20;
     $filter->monto = new inputField('Monto', 'monto');
     $filter->monto->rule = 'max_length[8]';
     $filter->monto->size = 10;
     $filter->monto->maxlength = 8;
     $filter->buttons('reset', 'search');
     $filter->build();
     $uri = anchor($this->url . 'dataedit/show/<raencode><#codigo#></raencode>', '<#codigo#>');
     $grid = new DataGrid('');
     $grid->order_by('codigo');
     $grid->per_page = 40;
     $grid->column_orderby('Codigo', "{$uri}", 'codigo', 'align="left"');
     $grid->column_orderby('Nombre', "nombre", 'nombre', 'align="left"');
     $grid->column_orderby('Monto', "<nformat><#monto#></nformat>", 'monto', 'align="right"');
     $grid->add($this->url . 'dataedit/create');
     $grid->build();
     $data['filtro'] = $filter->output;
     $data['content'] = $grid->output;
     $data['head'] = $this->rapyd->get_head() . script('jquery.js');
     $data['title'] = $this->titp;
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 12

0

Mostra file

File: sprv.php Progetto: codethics/proteoerp

 function filteredgrid()
 {
     $this->rapyd->load('datafilter', 'datagrid');
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter('Filtro de Proveedores', 'sprv');
     $filter->proveed = new inputField('C&oacute;digo', 'proveed');
     $filter->proveed->size = 13;
     $filter->proveed->maxlength = 5;
     $filter->nombre = new inputField('Nombre', 'nombre');
     $filter->nombre->maxlength = 40;
     $filter->rif = new inputField('Rif', 'rif');
     $filter->rif->size = 13;
     $filter->rif->maxlength = 12;
     $filter->cuenta = new inputField('Cuenta contable', 'cuenta');
     $filter->cuenta->size = 13;
     $filter->cuenta->like_side = 'after';
     $filter->buttons('reset', 'search');
     $filter->build();
     $uri = anchor('compras/sprv/dataedit/show/<#id#>', '<#proveed#>');
     $grid = new DataGrid('Lista de Proveedores');
     $grid->order_by('proveed', 'asc');
     $grid->per_page = 10;
     $grid->column_orderby('C&oacute;digo', $uri, 'codigo');
     $grid->column_orderby('Nombre', 'nombre', 'nombre');
     $grid->column_orderby('R.I.F.', 'rif', 'rif');
     $grid->column_orderby('% Ret.', 'reteiva', 'reteiva', 'align=\'right\'');
     $grid->column_orderby('Cuenta', 'cuenta', 'cuenta', 'align=\'right\'');
     $grid->add('compras/sprv/dataedit/create', 'Agregar un proveedor');
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = '<h1>Proveedores</h1>';
     $data['head'] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 13

0

Mostra file

File: depa.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter("", 'depa');
     $filter->division = new inputField("Departamento", "departa");
     $filter->division->size = 8;
     $filter->depadesc = new inputField("Descripcion", "depadesc");
     $filter->depadesc->size = 30;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('nomina/depa/dataedit/show/<#division#>/<#departa#>', '<#division#>');
     $grid = new DataGrid("");
     $grid->order_by("division", "asc");
     $grid->per_page = 20;
     $grid->column_orderby("Divisi&oacute;n", $uri, "division");
     $grid->column_orderby("Descripci&oacute;n", "descrip", "descrip", "align='left'NOWRAP");
     $grid->column_orderby("Departamento", "departa", "departa", "align='left'NOWRAP");
     $grid->column_orderby("Descripci&oacute;n", "depadesc", "depadesc", "align='left'NOWRAP");
     $grid->add("nomina/depa/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'] = "Departamentos";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 14

0

Mostra file

File: fondo.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->datasis->modulo_id(61, 1);
     $this->rapyd->load("datafilter2", "datagrid");
     //
     $filter = new DataFilter2("", "fondo");
     $filter->fondo = new inputField("F. Financiamiento", "fondo");
     $filter->fondo->size = 20;
     $filter->fondo->clause = "likerigth";
     $filter->descrip = new inputField("Descripci&oacute;n", "descrip");
     $filter->descrip->size = 20;
     $filter->descrip->clause = "likerigth";
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('presupuesto/fondo/dataedit/show/<raencode><#fondo#></raencode>', '<#fondo#>');
     $grid = new DataGrid("");
     $grid->order_by("fondo", "asc");
     $grid->column_orderby("Fondo", $uri, "fondo", "align='left'      ");
     $grid->column_orderby("Descripci&oacute;n", "descrip", "descrip", "align='left'NOWRAP");
     $grid->add("presupuesto/fondo/dataedit/create");
     $grid->build();
     $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);
 }

Esempio n. 15

0

Mostra file

File: prof.php Progetto: enderochoa/tortuga

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

Esempio n. 16

0

Mostra file

File: grpr.php Progetto: codethics/proteoerp

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter('Filtro de Grupos de Provedores', 'grpr');
     $filter->grupo = new inputField('Grupo', 'grupo');
     $filter->grupo->size = 5;
     $filter->nombre = new inputField('Nombre', 'gr_desc');
     $filter->nombre->size = 25;
     $filter->nombre->maxlength = 25;
     $filter->buttons('reset', 'search');
     $filter->build();
     $uri = anchor('compras/grpr/dataedit/show/<#grupo#>', '<#grupo#>');
     $grid = new DataGrid('Lista de Grupos de Provedores');
     $grid->order_by('gr_desc', 'asc');
     $grid->per_page = 7;
     $grid->column_orderby('Grupo', $uri, 'grupo');
     $grid->column_orderby('Nombre', 'gr_desc', 'gr_desc');
     $grid->column_orderby('Cuenta', 'cuenta', 'cuenta');
     $grid->add('compras/grpr/dataedit/create' . 'Agregar un grupo');
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = '<h1>Grupos de Proveedores</h1>';
     $data['head'] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 17

0

Mostra file

File: i18n.php Progetto: codethics/proteoerp

 function filteredgrid()
 {
     $this->pi18n->cargar('i18n', 'dataedit');
     $this->rapyd->load('datafilter', 'datagrid');
     $this->rapyd->uri->keep_persistence();
     $this->pi18n->msj('rifci', 'RIF o C.I.');
     $filter = new DataFilter('Filtro', 'i18n');
     $filter->modulo = new inputField('M&oacute;dulo', 'modulo');
     $filter->modulo->size = 20;
     $filter->buttons('reset', 'search');
     $filter->build();
     $uri = anchor('supervisor/i18n/dataedit/modify/<#id#>', '<#id#>');
     $grid = new DataGrid('Internacionalizaci&oacute;n');
     $grid->order_by('id', 'asc');
     $grid->per_page = 20;
     $grid->column_orderby('ID', $uri, 'id');
     $grid->column_orderby('Modulo', 'modulo', 'modulo');
     $grid->column_orderby('M&eacute;todo', 'metodo', 'metodo');
     $grid->column_orderby('Pa&iacute;s', 'pais', 'pais');
     $grid->column_orderby('Campo', 'campo', 'campo');
     $grid->add('supervisor/i18n/dataedit/create');
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['content'] .= $this->pi18n->fallas();
     $data['title'] = heading('Internacionalizaci&oacute;n');
     $data['head'] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 18

0

Mostra file

File: bcta.php Progetto: enderochoa/tortuga

 function index()
 {
     $this->rapyd->load("datagrid", "datafilter2");
     $filter = new DataFilter2("", 'bcta');
     $filter->codigo = new inputField("C&oacute;digo", "codigo");
     $filter->codigo->size = 15;
     $filter->codigo->clause = "likerigth";
     $filter->denominacion = new inputField("Denominaci&oacute;n", "denominacion");
     $filter->cuenta = new inputField("Cuenta", "cuenta");
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor($this->url . 'dataedit/show/<#codigo#>', '<#codigo#>');
     $grid = new DataGrid();
     $grid->order_by("codigo", "asc");
     $grid->per_page = 20;
     $grid->column_orderby("C&oacute;digo", $uri, "codigo");
     $grid->column_orderby("Denominaci&oacute;n", "denominacion", "denominacion", "aling='left'NOWRAP");
     $grid->column_orderby("Cuenta Contable", "cuenta", "cuenta", "align='left'NOWRAP");
     $grid->column_orderby("Descripci&oacute;n", "descrip", "descrip");
     $grid->add($this->url . "dataedit/create");
     $grid->build();
     //$data['content'] =$filter->output.$grid->output;
     $data["head"] = $this->rapyd->get_head();
     $data['filtro'] = $filter->output;
     $data['content'] = $grid->output;
     $data['script'] = script("jquery.js") . "\n";
     $data['title'] = "{$this->titp}";
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 19

0

Mostra file

File: mgas.php Progetto: codethics/proteoerp

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $modbus = array('tabla' => 'grcl', 'columnas' => array('grupo' => 'Codigo', 'gr_desc' => 'Descripci&oacute;n'), 'filtro' => array('grupo' => 'C&oacute;digo', 'gr_desc' => 'Descripci&oacute;n'), 'retornar' => array('grupo' => 'grupo'), 'titulo' => 'Buscar Grupo');
     $boton = $this->datasis->modbus($modbus);
     $filter = new DataFilter("Filtro Maestro de Gastos", 'mgas');
     $filter->codigo = new inputField("C&oacute;digo", "codigo");
     $filter->codigo->size = 20;
     $filter->cuenta = new inputField('Cuenta contable', 'cuenta');
     $filter->cuenta->like_side = 'after';
     $filter->descrip = new inputField("Descripci&oacute;n", "descrip");
     $filter->descrip->size = 20;
     $filter->grupo = new inputField("Grupo", "grupo");
     $filter->grupo->size = 20;
     $filter->grupo->append($boton);
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('finanzas/mgas/dataedit/show/<#codigo#>', '<#codigo#>');
     $grid = new DataGrid("Lista de Maestro de Gastos");
     $grid->order_by("codigo", "asc");
     $grid->per_page = 15;
     $grid->column_orderby("C&oacute;digo", $uri, 'codigo');
     $grid->column("Tipo", "tipo");
     $grid->column_orderby("Descripci&oacute;n", "descrip", 'descrip');
     $grid->column_orderby("Grupo", "grupo", 'grupo');
     $grid->column_orderby('Nombre del Grupo', 'nom_grup', 'nom_grup');
     $grid->add("finanzas/mgas/dataedit/create");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = "<h1>Maestro de Gastos</h1>";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 20

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. 21

0

Mostra file

File: gpt_pro.php Progetto: codethics/proteoerp

 function filteredgrid()
 {
     $this->rapyd->uri->keep_persistence();
     $this->rapyd->load('datafilter', 'datagrid');
     $filter = new DataFilter('', 'gpt_pro');
     $filter->parr = new inputField('Par&aacute;metro', 'parr');
     $filter->parr->rule = 'trim|required';
     $filter->parr->clause = '';
     //$filter->submit = new submitField('Buscar', 'submitbtn');
     //$filter->submit->in='parr';
     $filter->buttons('reset', 'search');
     $filter->build();
     $uri = anchor($this->url . 'dataedit/show/<raencode><#id_pro#></raencode>', '<#nom_pro#>', 'target="framedetrepo" onclick="$(\'#cajafiltro\').hide();"');
     //$uri = anchor($this->url.'dataedit/show/<raencode><#id_pro#></raencode>','<#nom_pro#>');
     $grid = new DataGrid('Especialidades farmaceuticas');
     if (strlen($filter->parr->newValue) > 0) {
         $dbparr = $this->db->escape($filter->parr->newValue);
         $grid->db->where('MATCH(nom_pro,pres_pro,lab_pro,gen_pro,mono_pro) AGAINST (' . $dbparr . ')');
     }
     $grid->order_by('nom_pro');
     $grid->per_page = 15;
     $grid->column_orderby('Nombre', $uri, 'nom_pro', 'align="left"');
     $grid->column_orderby('Presentaci&oacute;n', 'pres_pro', 'pres_pro', 'align="left"');
     $grid->column_orderby('Laboratorio', 'lab_pro', 'lab_pro', 'align="left"');
     //$grid->column_orderby('Cod. Pro','cod_pro','cod_pro','align="left"');
     //$grid->column_orderby('Gen. Pro','gen_pro','gen_pro','align="left"');
     $grid->build();
     $data['filtro'] = $filter->output . $grid->output;
     $data['content'] = '<script type="text/javascript"> $(function(){ $("#cajafiltro").show(); }); </script>';
     //$data['content'].= $acti->output;
     $data['content'] .= '<IFRAME src="' . site_url('farmacia/gpt_pro/dummy') . '" width="100%" height="500" scrolling="auto" frameborder="0" name="framedetrepo">iframe no son soportados</IFRAME>';
     $data['head'] = $this->rapyd->get_head() . script('jquery.js') . script('jquery.highlight.js');
     $data['title'] = heading($this->titp);
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 22

0

Mostra file

File: provoca.php Progetto: codethics/proteoerp

 function filteredgrid()
 {
     $this->rapyd->load('datafilter', 'datagrid');
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter('Filtro de proveedores ocasionales', 'provoca');
     $filter->rif = new inputField('RIF', 'rif');
     $filter->rif->maxlength = 13;
     $filter->rif->size = 14;
     $filter->nombre = new inputField('Nombre', 'nombre');
     $filter->buttons('reset', 'search');
     $filter->build();
     $uri = anchor('finanzas/provoca/dataedit/show/<#rif#>', '<#rif#>');
     $grid = new DataGrid("Filtro de Proveedores Ocasionales");
     $grid->order_by("nombre", "asc");
     $grid->per_page = 10;
     $grid->column_orderby('RIF', $uri, 'rif');
     $grid->column_orderby('Nombre', 'nombre', 'nombre');
     $grid->column_orderby('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human>', 'fecha', "align='center'");
     $grid->add('finanzas/provoca/dataedit/create', 'Agregar un proveedor ocasional');
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = "<h1>Proveedores Ocasionales</h1>";
     $data['head'] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 23

0

Mostra file

File: civa.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter("", 'civa');
     $filter->fecha = new dateonlyField("Fecha", "fecha", 'd/m/Y');
     $filter->fecha->clause = $filter->fecha->clause = "where";
     $filter->fecha->dbformat = "Y-m-d";
     $filter->fecha->size = 12;
     $filter->tasa = new inputField("Tasa", "Tasa");
     $filter->tasa->size = 12;
     $filter->tasa->maxlength = 6;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('tesoreria/civa/dataedit/show/<#fecha#>', '<dbdate_to_human><#fecha#></dbdate_to_human>');
     $grid = new DataGrid("");
     $grid->order_by("fecha", "asc");
     $grid->per_page = 20;
     $grid->column_orderby("Fecha", $uri, "fecha", "align='center'");
     $grid->column_orderby("Tasa", "tasa", "tasa", "align='right' ");
     $grid->column_orderby("Tasa Reducida ", "redutasa", "redutasa", "align='right' ");
     $grid->column_orderby("Tasa Adicional", "sobretasa", "sobretasa", "align='right' ");
     $grid->add("tesoreria/civa/dataedit/create");
     $grid->build();
     //echo $grid->db->last_query();
     //$data['content'] = $filter->output.$grid->output;
     $data['filtro'] = $filter->output;
     $data['content'] = $grid->output;
     $data['script'] = script("jquery.js") . "\n";
     $data['title'] = "Tasa de IVA";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 24

0

Mostra file

File: vend.php Progetto: codethics/proteoerp

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

Esempio n. 25

0

Mostra file

File: parroquia.php Progetto: enderochoa/tortuga

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

Esempio n. 26

0

Mostra file

File: conc.php Progetto: enderochoa/tortuga

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

Esempio n. 27

0

Mostra file

File: nomina.php Progetto: enderochoa/tortuga

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

Esempio n. 28

0

Mostra file

File: tban.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->rapyd->load('datafilter2', 'datagrid');
     $filter = new DataFilter2('', 'tban');
     $filter->codbanc = new inputField('C&oacute;digo', 'cod_banc');
     $filter->codbanc->size = 5;
     $filter->codbanc->clause = 'likerigth';
     $filter->banco = new inputField('Nombre de Banco', 'nomb_banc');
     $filter->banco->size = 30;
     $filter->banco->clause = 'likerigth';
     $filter->buttons('reset', 'search');
     $filter->build();
     $uri = anchor('tesoreria/tban/dataedit/show/<#cod_banc#>', '<#cod_banc#>');
     $grid = new DataGrid("");
     $grid->per_page = 20;
     $grid->column_orderby('C&oacute;digo', $uri, 'cod_banc');
     $grid->column_orderby('Banco', 'nomb_banc', 'nomb_banc', "align='left' NOWRAP");
     //$grid->column_orderby("Tipo"   ,"tipotra"  ,"tipotra"  );
     //$grid->column_orderby("Formaca","formaca"  ,"formaca"  );
     $grid->add('tesoreria/tban/dataedit/create');
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = 'Tabla de Bancos';
     $data['head'] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 29

0

Mostra file

File: r_sector.php Progetto: enderochoa/tortuga

 function filteredgrid()
 {
     $this->rapyd->load('datafilter', 'datagrid');
     $filter = new DataFilter($this->titp, 'r_sector');
     $filter->id = new inputField('Id', 'id');
     $filter->id->rule = 'trim';
     $filter->id->size = 13;
     $filter->id->maxlength = 11;
     $filter->descrip = new inputField('Descrip', 'descrip');
     $filter->descrip->rule = 'trim';
     $filter->descrip->size = 102;
     $filter->descrip->maxlength = 100;
     $filter->buttons('reset', 'search');
     $filter->build();
     $uri = anchor($this->url . 'dataedit/show/<raencode><#id#></raencode>', '<#id#>');
     $grid = new DataGrid('');
     $grid->order_by('id');
     $grid->per_page = 40;
     $grid->column_orderby('Id', "{$uri}", 'id', 'align="left"');
     $grid->column_orderby('Descrip', "descrip", 'descrip', 'align="left"');
     $grid->add($this->url . 'dataedit/create');
     $grid->build();
     $data['filtro'] = $filter->output;
     $data['content'] = $grid->output;
     $data['head'] = $this->rapyd->get_head() . script('jquery.js');
     $data['title'] = $this->titp;
     $this->load->view('view_ventanas', $data);
 }

Esempio n. 30

0

Mostra file

File: cpla.php Progetto: enderochoa/tortuga

 function index()
 {
     $this->rapyd->load("datagrid", "datafilter2");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter2("", 'cpla');
     $filter->codigo = new inputField("C&oacute;digo", "codigo");
     $filter->codigo->size = 15;
     //$filter->codigo->clause="likerigth";
     $filter->denominacion = new inputField("Denominaci&oacute;n", "denominacion");
     $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 = 20;
     $grid->column_orderby("C&oacute;digo", $uri, "codigo", "align='left'  NOWRAP");
     $grid->column_orderby("Denomina&oacute;n", "denominacion", "denominacion", "align='left'  NOWRAP");
     //$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['filtro'] = $filter->output;
     $data['content'] = $grid->output;
     $data["head"] = $this->rapyd->get_head();
     $data['script'] = script("jquery.js") . "\n";
     $data['title'] = 'Plan Patrimonial';
     $this->load->view('view_ventanas', $data);
 }

Esempi in PHP per DataGrid::column_orderby