Exemplo n.º 1
0
 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&iacute;culos");
     $grid->order_by("codigo", "asc");
     $grid->per_page = 20;
     $grid->use_function('str_replace');
     $grid->column("C&oacute;digo", $link);
     $grid->column("Descripci&oacute;n", "descrip");
     $grid->column("Precio 1", "precio1");
     $grid->column("Barras", "barras");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = " Lista de Art&iacute;culos ";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Exemplo n.º 2
0
 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);
 }
Exemplo n.º 3
0
 function filteredgrid()
 {
     $this->bSINV = $this->datasis->modbus($this->sinv);
     $this->rapyd->load("datafilter2", "datagrid");
     //$this->rapyd->uri->keep_persistence();
     rapydlib("prototype");
     $filter = new DataFilter2("Filtro por Producto", 'catalogo');
     $filter->codigo = new inputField("C&oacute;digo", "codigo");
     $filter->codigo->size = 15;
     $filter->codigo->append($this->bSINV);
     $filter->buttons("reset", "search");
     $filter->build();
     $grid = new DataGrid("Lista de Art&iacute;culos");
     $grid->add("inventario/catalogo/dataedit/create");
     $grid->order_by("codigo", "asc");
     $grid->per_page = 20;
     $link = anchor('/inventario/catalogo/dataedit/show/<#id#>', '<#codigo#>');
     $grid->use_function('str_replace');
     $grid->column("C&oacute;digo", $link);
     $grid->column("Fecha", "<dbdate_to_human><#estampa#></dbdate_to_human>");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data["head"] = script("tabber.js") . script("prototype.js") . $this->rapyd->get_head() . script("scriptaculous.js") . script("effects.js");
     $data['title'] = ' Lista de Art&iacute;culos ';
     $this->load->view('view_ventanas', $data);
 }
Exemplo n.º 4
0
 function index()
 {
     $this->rapyd->load("datagrid", "datafilter2");
     $filter = new DataFilter2("Filtro de " . $this->titp, 'horarios');
     $filter->id = new inputField("Id", "id");
     $filter->id->size = 10;
     $filter->id->clause = "likerigth";
     $filter->codigo = new inputField("C&oacute;digo", "codigo");
     $filter->codigo->size = 10;
     $filter->codigo->clause = "likerigth";
     $filter->denomi = new inputField("Denominaci&oacute;n", "denomi");
     $filter->denomi->size = 10;
     $filter->denomi->clause = "likerigth";
     $filter->turno = new inputField("Turno", "turno");
     $filter->turno->size = 10;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor($this->url . 'dataedit/show/<#id#>', '<#id#>');
     $grid = new DataGrid();
     $grid->order_by("codigo", "asc");
     $grid->per_page = 15;
     $grid->column("Id", $uri);
     $grid->column("C&oacute;ndigo", "codigo");
     $grid->column("Denomina&oacute;n", "denomi");
     $grid->column("Turno", "turno", "align='left'");
     $grid->column("Entrada", "entrada", "align='left'");
     $grid->column("Salida", "salida", "align='left'");
     $grid->add($this->url . "dataedit/create");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data["head"] = $this->rapyd->get_head();
     $data['title'] = "<h1>{$this->titp}</h1>";
     $this->load->view('view_ventanas', $data);
 }
Exemplo n.º 5
0
 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&oacute;digo", "codigo");
     $filter->codigo->size = 15;
     $filter->descrip = new inputField("Descripci&oacute;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&oacute;digo", $uri, "codigo");
     $grid->column_orderby("Descripci&oacute;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->t**s;
     $data['script'] = script("jquery.js") . "\n";
     $data["head"] = script("jquery.js") . $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Exemplo n.º 6
0
 function filteredgrid()
 {
     $this->rapyd->load("datafilter2", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter2("Filtro por Cargo", 'carg');
     $filter->cargo = new inputField("C&oacute;digo", "cargo");
     $filter->cargo->size = 3;
     $filter->cargo->clause = "likerigth";
     $filter->descrip = new inputField("Descripci&oacute;n", "descrip");
     $filter->cargo->clause = "likerigth";
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('nomina/carg/dataedit/show/<#cargo#>', '<#cargo#>');
     $grid = new DataGrid("Lista de Cargos");
     $grid->order_by("cargo", "asc");
     $grid->per_page = 10;
     $grid->column("Cargo", $uri);
     $grid->column("Descripci&oacute;n", "descrip");
     $grid->column("Sueldo", "<number_format><#sueldo#>|2|,|.</number_format>", "align='right'");
     $grid->add("nomina/carg/dataedit/create");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = "<h1>Cargos</h1>";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Exemplo n.º 7
0
 function filteredgrid()
 {
     $this->rapyd->load("datafilter2", "datagrid");
     //
     $filter = new DataFilter2("", "clasevehi");
     $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->buttons("reset", "search");
     $filter->build();
     $grid = new DataGrid("");
     $grid->order_by("codigo", "asc");
     $grid->column_orderby("C&oacute;digo", "codigo", "codigo", "align='left'      ");
     $grid->column_orderby("Nombre", "nombre", "nombre", "align='left'NOWRAP");
     $grid->add("ingresos/clasevehi/dataedit/create");
     $grid->build();
     $data['content'] = $grid->output;
     $data['filtro'] = $filter->output;
     $data['title'] = "Clase de Vehiculo";
     //"  ";
     $data["script"] = script("jquery.js") . "\n";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Exemplo n.º 8
0
 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);
 }
Exemplo n.º 9
0
 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);
 }
Exemplo n.º 10
0
 function filteredgrid()
 {
     $this->rapyd->load("datafilter2", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter2("", 'carg');
     $filter->cargo = new inputField("C&oacute;digo", "cargo");
     $filter->cargo->size = 3;
     $filter->cargo->clause = "likerigth";
     $filter->descrip = new inputField("Descripci&oacute;n", "descrip");
     $filter->cargo->clause = "likerigth";
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('nomina/carg/dataedit/show/<raencode><#cargo#></raencode>', '<#cargo#>');
     $grid = new DataGrid("");
     $grid->order_by("cargo", "asc");
     $grid->per_page = 20;
     $grid->column_orderby("Cargo", $uri, "cargo");
     $grid->column_orderby("Descripci&oacute;n", "descrip", "descrip", "align='left'NOWRAP");
     $grid->column_orderby("Sueldo", "<number_format><#sueldo#>|2|,|.</number_format>", "sueldo", "align='right'     ");
     $grid->column_orderby("Estructura Administrativa", "codigoadm", "codigoadm", "align='left'      ");
     $grid->column_orderby("Codigo Presupuestario", "codigopres", "codigopres", "align='left'      ");
     $grid->column_orderby("F. Financiamiento", "fondo", "fondo", "align='left'      ");
     $grid->add("nomina/carg/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'] = "Cargos";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Exemplo n.º 11
0
 function filteredgrid()
 {
     $this->rapyd->load("datafilter2", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $pers = array('tabla' => 'pers', 'columnas' => array('codigo' => 'Codigo', 'cedula' => 'Cedula', 'nombre' => 'Nombre', 'apellido' => 'Apellido'), 'filtro' => array('codigo' => 'C&oacute;digo', 'cedula' => 'Cedula'), 'retornar' => array('codigo' => 'codigo'), 'titulo' => 'Buscar Personal');
     $boton = $this->datasis->modbus($pers);
     $filter = new DataFilter2("Filtro por C&oacute;digo", 'ausu');
     $filter->codigo = new inputField("Codigo", "codigo");
     $filter->codigo->size = 15;
     $filter->codigo->append($boton);
     $filter->codigo->clause = "likerigth";
     $filter->fecha = new DateonlyField("Fecha", "fecha");
     $filter->fecha->size = 12;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('nomina/aumentosueldo/dataedit/show/<#codigo#>/<raencode><#fecha#></raencode>', '<#codigo#>');
     $grid = new DataGrid("Lista de Aumentos de Sueldo");
     $grid->order_by("codigo", "asc");
     $grid->per_page = 20;
     $grid->column("C&oacute;digo", $uri);
     $grid->column("Nombre", "nombre");
     $grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "align='center'");
     $grid->column("Sueldo anterior", "<number_format><#sueldoa#>|2|,|.</number_format>", "align='right'");
     $grid->column("Sueldo nuevo", "<number_format><#sueldo#>|2|,|.</number_format>", "align='right'");
     $grid->column("Observaciones", "observ1");
     $grid->column("..", "oberv2");
     $grid->add("nomina/aumentosueldo/dataedit/create");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = "<h1>Aumentos de Sueldo</h1>";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Exemplo n.º 12
0
 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);
 }
Exemplo n.º 13
0
 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);
 }
Exemplo n.º 14
0
 function filteredgrid2()
 {
     $this->rapyd->load("datafilter2", "datagrid");
     $mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'C&oacute;odigo', 'nombre' => 'Nombre', 'rif' => 'Rif', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'C&oacute;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&uacute;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&oacute;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&uacute;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);
 }
Exemplo n.º 15
0
 function filteredgrid()
 {
     //$this->datasis->modulo_id(83,1);
     $this->rapyd->load("datafilter2", "datagrid");
     $filter = new DataFilter2("");
     $filter->db->select(array("a.codvehiculo codvehi", "a.codclase codclase", "a.codmarca codmarca", "a.asocia asocia", "a.tipo tipo", "a.modelo modelo", "a.color color", "a.capaci capaci", "a.monto monto", "a.ultanio ultanio", "a.serialmot serialmot", "a.panterior placant", "a.pactual placact", "a.anio anio", "a.peso peso", "a.serialcar serialcar", "a.deudant deudant", "b.nombre nomclase", "c.marca nommarca", "d.nombre nomaso"));
     $filter->db->from("invehiculo a");
     $filter->db->join("clasevehi b", "a.codclase=b.codigo", "left");
     $filter->db->join("marcavehi c", "a.codmarca=c.codigo", "left");
     $filter->db->join("asovehi d", "a.asocia=d.codigo", "left");
     $filter->codigo = new inputField("C&oacute;digo", "codvehi");
     $filter->codigo->clause = "likerigth";
     $filter->codigo->maxlength = 6;
     $filter->codigo->size = 6;
     $filter->placa = new inputField("Placa", "placact");
     $filter->placa->clause = "likerigth";
     $filter->placa->maxlength = 20;
     $filter->placa->size = 20;
     $filter->codigoclase = new dropdownField("Marca", "codclase");
     $filter->codigoclase->option("", "");
     $filter->codigoclase->options("SELECT codigo, CONCAT_WS(' ',codigo,marca)as a FROM marcavehi ORDER BY codigo");
     $filter->codigomarca = new dropdownField("Clase", "codmarca");
     $filter->codigomarca->option("", "");
     $filter->codigomarca->options("SELECT codigo, CONCAT_WS(' ',codigo,nombre)as a FROM clasevehi ORDER BY codigo");
     $filter->asocia = new dropdownField("Asociaci&oacute;n", "asocia");
     $filter->asocia->option("", "");
     $filter->asocia->options("SELECT codigo, CONCAT_WS(' ',codigo,nombre)as a FROM asovehi ORDER BY codigo");
     $filter->buttons("reset", "search");
     $filter->build();
     $grid = new DataGrid("");
     $grid->order_by("codvehiculo", "asc");
     $grid->column_orderby("C&oacute;digo", "codvehi", "codvehi", "align='center'    ");
     $grid->column_orderby("Clase", "nomclase", "nomclase", "align='left'NOWRAP");
     $grid->column_orderby("Marca", "nommarca", "nommarca", "align='left'NOWRAP");
     $grid->column_orderby("Tipo", "tipo", "tipo", "align='center'    ");
     $grid->column_orderby("Modelo", "modelo", "modelo", "align='left'NOWRAP");
     $grid->column_orderby("Color", "color", "color", "align='center'    ");
     $grid->column_orderby("Capacidad", "capaci", "capaci", "align='center'    ");
     $grid->column_orderby("Monto", "monto", "monto", "align='right'     ");
     $grid->column_orderby("Ultimo A.", "ultanio", "ultanio", "align='center'    ");
     $grid->column_orderby("Serial Motor", "serialmot", "serialmot", "align='left'NOWRAP");
     $grid->column_orderby("P.Anterior", "placant", "placant", "align='left'NOWRAP");
     $grid->column_orderby("P.Actual", "placact", "placact", "align='left'NOWRAP");
     $grid->column_orderby("A&ntilde;o", "anio", "anio", "align='center'    ");
     $grid->column_orderby("Asociaci&oacute;n", "nomaso", "nomaso", "align='left'NOWRAP");
     $grid->column_orderby("Peso", "peso", "peso", "align='center'    ");
     $grid->column_orderby("Serial Carroceria", "serialcar", "serialcar", "align='left'NOWRAP");
     $grid->column_orderby("Deuda Ant.", "deudant", "deudant", "align='right'     ");
     $grid->column_orderby("Placa", "placact", "placact", "align='left'");
     $grid->add("ingresos/invehiculo/dataedit/create");
     $grid->build();
     $data['filtro'] = $filter->output;
     $data['content'] = $grid->output;
     $data['script'] = script("jquery.js") . "\n";
     $data['title'] = "Vehiculo";
     //" $this->titp ";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Exemplo n.º 16
0
 function filteredgrid()
 {
     //$this->datasis->modulo_id(40,1);
     $this->rapyd->load("datafilter2", "datagrid");
     //
     $filter = new DataFilter2("", "ttributo");
     $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->cancelado = new dropdownField("Cancelado", "cancelado");
     //$filter->codigoejec->rule='required';
     $filter->cancelado->option("", "");
     $filter->cancelado->option("s", "Si");
     $filter->cancelado->option("n", "No");
     $filter->mensaje = new inputField("Mensaje", "mensaje");
     $filter->mensaje->size = 20;
     $filter->mensaje->clause = "likerigth";
     $filter->momto = new inputField("Monto", "monto");
     $filter->momto->size = 10;
     $filter->momto->clause = "likerigth";
     $filter->emireci = new dropdownField("Emitio Recivo", "emireci");
     //$filter->codigoejec->rule='required';
     $filter->emireci->option("", "");
     $filter->emireci->option("s", "Si");
     $filter->emireci->option("n", "No");
     $filter->deudante = new dropdownField("Deuda Anterior", "deudante");
     //$filter->codigoejec->rule='required';
     $filter->deudante->option("", "");
     $filter->deudante->option("s", "Si");
     $filter->deudante->option("n", "No");
     $filter->agua = new inputField("Agua", "agua");
     $filter->agua->size = 10;
     $filter->agua->clause = "likerigth";
     $filter->buttons("reset", "search");
     $filter->build();
     $grid = new DataGrid("");
     $grid->order_by("codigo", "asc");
     $grid->column_orderby("C&oacute;digo", "codigo", "codigo", "align='left'       ");
     $grid->column_orderby("Nombre", "nombre", "nombre", "align='left' NOWRAP");
     $grid->column_orderby("Cancelado", "cancelado", "cancelado", "align='left' NOWRAP");
     $grid->column_orderby("Mensaje", "mensaje", "mensaje", "align='left' NOWRAP");
     $grid->column_orderby("Monto", "monto", "monto", "align='right'NOWRAP");
     $grid->column_orderby("E.Recibo", "emireci", "emireci", "align='left' NOWRAP");
     $grid->column_orderby("D.Anterior", "deudante", "deudante", "align='left' NOWRAP");
     $grid->column_orderby("Agua", "agua", "agua", "align='right'NOWRAP");
     $grid->add("ingresos/ttributo/dataedit/create");
     $grid->build();
     $data['content'] = $grid->output;
     $data['filtro'] = $filter->output;
     $data['title'] = "Tributos o Impuestos";
     //"  ";
     $data["script"] = script("jquery.js") . "\n";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Exemplo n.º 17
0
 function filteredgrid()
 {
     //$this->datasis->modulo_id(75,1);
     $this->rapyd->load("datafilter2", "datagrid");
     $filter = new DataFilter2("", "su_trasla");
     $filter->numero = new inputField("N&uacute;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&uacute;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);
 }
Exemplo n.º 18
0
    function filteredgrid()
    {
        $this->rapyd->load("datafilter2", "datagrid");
        $script = '
		$(function() {
		
		});
		';
        $filter = new DataFilter2("", "bi_trasla");
        $filter->script($script);
        $filter->numero = new inputField("N&uacute;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&uacute;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->t**s;
        $data["head"] = script("jquery.js") . $this->rapyd->get_head();
        $this->load->view('view_ventanas', $data);
    }
Exemplo n.º 19
0
 function filteredgrid()
 {
     $this->rapyd->load("datafilter2", "datagrid");
     $filter = new DataFilter2("", "relch");
     $filter->db->select(array("relch.status status2", "relch.id", "relch.numero", "relch.usuario", "relch.fecha", "IF(relch.destino='C','Caja','Interno') destino", "mbanc.cheque"));
     $filter->db->join("mbanc", "relch.id=mbanc.relch");
     $filter->db->groupby("relch.numero");
     $filter->id = new inputField("Ref. Relacion", "id");
     $filter->id->db_name = "relch.id";
     $filter->numero = new inputField("Numero", "numero");
     $filter->numero->db_name = "relch.numero";
     $filter->usuario = new dropdownField("Usuario", "usuario");
     $filter->usuario->db_name = "relch.usuario";
     $filter->usuario->option("", "");
     $filter->usuario->options("SELECT us_codigo,CONCAT_WS(' ',us_codigo,us_nombre) FROM usuario");
     $filter->usuario->style = "width:200px;";
     $filter->fecha = new dateonlyField("Fecha", 'fecha', 'd/m/Y');
     $filter->fecha->db_name = "mbanc.fecha";
     $filter->fecha->dbformat = 'Y-m-d';
     $filter->cheque = new inputField("Cheque", "cheque");
     $filter->cheque->db_name = "mbanc.cheque";
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('tesoreria/relch/dataedit/modify/<#id#>', '<#id#>');
     $uri2 = anchor('tesoreria/relch/busca/<#id#>', 'Modificar');
     $grid = new DataGrid("");
     $grid->per_page = 20;
     $grid->order_by("relch.id", "desc");
     $grid->column_orderby("id", $uri, "relch.id");
     $grid->column_orderby("Numero", "numero", "numero");
     $grid->column_orderby("Cheque", "cheque", "cheque");
     $grid->column_orderby("Usuario", "usuario", "usuario");
     $grid->column_orderby("Fecha", "fecha", "fecha");
     $grid->column_orderby("Destino", "destino", "destino");
     $grid->column_orderby("Fondo", "fondo", "fondo");
     $grid->column_orderby("Estado", "status2", "status2");
     $grid->column("Modificar Cheques", $uri2);
     $grid->build();
     //$grid->db->last_query();
     $atts3 = array('width' => '640', 'height' => '480', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '5', 'screeny' => '5', 'id' => 'recibo');
     $salida = anchor('tesoreria/relch/busca/', "Crear Relacion");
     $salida .= '</br>';
     $salida .= anchor_popup('reportes/ver/relch/', "Ordenes Pagadas", $atts3);
     $salida .= '</br>';
     $salida .= anchor_popup('reportes/ver/relch2/', "Cheques Emitidos", $atts3);
     $salida .= '</br>';
     $salida .= anchor_popup('reportes/ver/relch3/', "Anulacion y Reposicion", $atts3);
     $data['content'] = $filter->output . $salida . $grid->output;
     $data['title'] = "Relaciones de Ordenes Pagadas";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Exemplo n.º 20
0
 function filteredgrid()
 {
     $this->rapyd->load("datafilter2", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter2("", 'asig');
     $filter->codigo = new inputField("Codigo", "codigo");
     $filter->codigo->size = 15;
     $filter->codigo->clause = "likerigth";
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('nomina/asig/dataedit/show/<#codigo#>', '<#codigo#>');
     function sta($status)
     {
         switch ($status) {
             case "A":
                 return "Asignaci&oacute;n";
                 break;
             case "O":
                 return "Otros";
                 break;
             case "D":
                 return "Devoluciones";
                 break;
         }
     }
     $grid = new DataGrid("");
     $grid->order_by("codigo", "asc");
     $grid->per_page = 20;
     $grid->use_function('sta');
     $grid->column_orderby("C&oacute;digo", $uri, "codigo");
     $grid->column_orderby("Nombre", "nombre", "nombre", "align='left'NOWRAP  ");
     $grid->column_orderby("Concepto", "concepto", "concepto", "align='left'NOWRAP  ");
     $grid->column_orderby("Tipo", "<sta><#tipo#></sta>", "tipo", "align='center'NOWRAP");
     $grid->column_orderby("Descripci&oacute;n", "descrip", "descrip", "align='left'NOWRAP  ");
     $grid->column_orderby("F&oacute;rmula", "formula", "formula", "align='left'NOWRAP  ");
     $grid->column_orderby("Monto", "<number_format><#monto#>|2|,|.</number_format>", "monto", "align='right'");
     $grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center'");
     $grid->column_orderby("Cuota", "<number_format><#cuota#>|2|,|.</number_format>", "cuota", "align='right'");
     $grid->column_orderby("Cuota Total", "<number_format><#cuotat#>|2|,|.</number_format>", "cuotat", "align='right'");
     $grid->add("nomina/asig/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'] = "Asignaciones";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Exemplo n.º 21
0
    function filteredgrid()
    {
        $this->rapyd->load("datafilter2", "datagrid");
        $this->rapyd->uri->keep_persistence();
        $script = '
		$(function() {
			$(".inputnum").numeric(".");
		});
		';
        $filter = new DataFilter2("", "pers");
        $filter->script($script, "create");
        $filter->script($script, "modify");
        $filter->codigo = new inputField("C&oacute;digo", "codigo");
        $filter->codigo->size = 10;
        $filter->codigo->css_class = 'inputnum';
        $filter->cedula = new inputField("C&eacute;dula", "cedula");
        $filter->cedula->size = 10;
        $filter->cedula->css_class = 'inputnum';
        $filter->nombre = new inputField("Nombre", "nombre");
        $filter->nombre->size = 35;
        $filter->apellido = new inputField("Apellido", "apellido");
        $filter->apellido->size = 35;
        $filter->contrato = new dropdownField("Contrato", "contrato");
        $filter->contrato->option("", "");
        $filter->contrato->options('SELECT codigo, CONCAT_WS(" * ",codigo,nombre) a FROM noco ORDER BY nombre');
        $filter->contrato->style = "width:300px;";
        $filter->buttons("reset", "search");
        $filter->build();
        $uri = anchor('forma/ver/RECIBO/2/<#codigo#>', 'Imprimir');
        $grid = new DataGrid("");
        $grid->order_by("codigo", "asc");
        $grid->per_page = 20;
        $grid->column_orderby("C&oacute;digo", "codigo", "codigo", "align='center'");
        $grid->column_orderby("C&eacute;dula", "cedula", "cedula", "align='center'");
        $grid->column_orderby("Nombre", "nombre", "nombre", "align='left'NOWRAP");
        $grid->column_orderby("Apellidos", "apellido", "apellido", "align='left'NOWRAP");
        $grid->column_orderby("Contrato", "contrato", "contrato");
        $grid->column_orderby("Recibo", $uri, "codigo");
        $grid->build();
        //$data['content'] = $filter->output.$grid->output;
        $data['filtro'] = $filter->output;
        $data['content'] = $grid->output;
        $data['script'] = script("jquery.js") . "\n";
        $data['title'] = "Recibos de Pago";
        $data["head"] = $this->rapyd->get_head();
        $this->load->view('view_ventanas', $data);
    }
Exemplo n.º 22
0
 function filteredgrid()
 {
     $this->datasis->modulo_id(79, 1);
     $this->rapyd->load("datafilter2", "datagrid");
     $this->rapyd->uri->keep_persistence();
     function blanco($num)
     {
         if (empty($num) || $num == 0) {
             return '';
         } else {
             return number_format($num, 2, ',', '.');
         }
     }
     $filter = new DataFilter2("", "bienes");
     //$filter->codigo = new inputField("C&oacute;digo","codigo");
     //$filter->codigo->size=20;
     //
     //$filter->nombre = new inputField("Nombre","nombre");
     //$filter->nombre->size=20;
     //
     //$filter->grupo =new dropdownField("Grupo","grupo");
     //$filter->grupo->option("","");
     //$filter->grupo->options("SELECT grupo,CONCAT_WS(' ',grupo,nombre) FROM grbi");
     $filter->barras = new inputField("Cod. Barras", "barras");
     $filter->barras->size = 20;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('bienes/bienes/dataedit/show/<raencode><#codigo#></raencode>', '<#codigo#>');
     $uri_2 = anchor('bienes/bienes/dataedit/create/<raencode><#codigo#></raencode>', 'Duplicar');
     $grid = new DataGrid("");
     //$grid->order_by("codigo","asc");
     $grid->per_page = 20;
     $grid->column_orderby("C&oacute;digo", $uri, "codigo", "align='center'    ");
     $grid->column_orderby("Grupo", "grupo", "grupo", "align='center'    ");
     $grid->column_orderby("Nombre", "nombre", "nombre", "align='left'NOWRAP");
     $grid->column_orderby("Costo", "costo", "costo", "align='rigth'");
     $grid->column("Duplicar", $uri_2, "align='center'");
     $grid->add("bienes/bienes/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'] = "Bienes Nacionales";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Exemplo n.º 23
0
 function filteredgrid()
 {
     $this->rapyd->load("datafilter2", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter2("Filtro de Asignaciones", 'asig');
     $filter->fecha = new DateField("Fecha", "fecha");
     $filter->fecha->size = 12;
     $filter->codigo = new inputField("Codigo de Trabajador", "codigo");
     $filter->codigo->size = 10;
     $filter->descrip = new inputField("Descripci&oacute;n de Concepto", "descrip");
     $filter->descrip->size = 25;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('nomina/asig/dataedit/show/<#codigo#>', '<#codigo#>');
     function sta($status)
     {
         switch ($status) {
             case "A":
                 return "Asignaci&oacute;n";
                 break;
             case "O":
                 return "Otros";
                 break;
             case "D":
                 return "Devoluciones";
                 break;
         }
     }
     $grid = new DataGrid("Lista de Asignaciones");
     $grid->order_by("codigo", "asc");
     $grid->per_page = 10;
     $grid->use_function('sta');
     $grid->column("C&oacute;digo", $uri);
     $grid->column("Nombre", "nombre");
     $grid->column("Concepto", "concepto");
     $grid->column("Descripci&oacute;n", "descrip");
     $grid->column("Monto", "<nformat><#monto#></nformat>", "align='right'");
     $grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "align='center'");
     $grid->add("nomina/asig/dataedit/create");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = "<h1>Asignaciones</h1>";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Exemplo n.º 24
0
 function filteredgrid()
 {
     $this->rapyd->load("datafilter2", "datagrid");
     $this->rapyd->uri->keep_persistence();
     function blanco($num)
     {
         if (empty($num) || $num == 0) {
             return '';
         } else {
             return number_format($num, 2, ',', '.');
         }
     }
     $filter = new DataFilter2("Filtro de Grupo de Inventario");
     $filter->db->select("a.grupo AS grupo, a.nom_grup AS nom_grup, a.cu_cost AS cu_cos,b.descrip AS linea");
     $filter->db->from("grup AS a");
     $filter->db->join("line AS b", "a.linea=b.linea", "LEFT");
     $filter->grupo = new inputField("Grupo", "grupo");
     $filter->grupo->size = 20;
     $filter->nombre = new inputField("Descripci&oacute;n", "nom_grup");
     $filter->nombre->size = 20;
     $filter->linea = new inputField("Linea", "linea");
     $filter->linea->size = 20;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('suministros/grup/dataedit/show/<raencode><#grupo#></raencode>', '<#grupo#>');
     $uri_2 = anchor('suministros/grup/dataedit/create/<raencode><#grupo#></raencode>', 'Duplicar');
     $grid = new DataGrid("Lista de Grupos de Inventario");
     $grid->order_by("grupo", "asc");
     $grid->per_page = 20;
     $grid->use_function('blanco');
     $grid->column_orderby("Grupo", $uri, "grupo", "align='center'      ");
     $grid->column_orderby("Descripci&oacute;n", "nom_grup", "nom_grup", "align='left'  NOWRAP");
     $grid->column_orderby("Linea", "linea", "linea", "align='center'NOWRAP");
     $grid->column("Duplicar", $uri_2, "align='center'");
     $grid->add("suministros/grup/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'] = "Grupos de Inventario";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Exemplo n.º 25
0
 function filteredgrid()
 {
     $this->datasis->modulo_id(83, 1);
     $this->rapyd->load("datafilter2", "datagrid");
     //
     $filter = new DataFilter2("");
     //"Filtro por ".$this->titp,"uadministra");
     $filter->db->select(array("a.codigoejec codigoejec", "a.codigo codigo", "a.nombre nombre", "a.director director", "b.nombre ejecutor"));
     $filter->db->from("uadministra a");
     $filter->db->join("uejecutora b", "a.codigoejec=b.codigo");
     $filter->codigoejec = new dropdownField("Unidad Ejecutora", "codigoejec");
     $filter->codigoejec->rule = 'required';
     $filter->codigoejec->option("", "");
     $filter->codigoejec->options("SELECT codigo, CONCAT_WS(' ',codigo,nombre)as a FROM uejecutora ORDER BY nombre");
     $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", "a.director");
     $filter->director->size = 40;
     $filter->director->clause = "likerigth";
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('presupuesto/uadministra/dataedit/show/<raencode><#codigoejec#></raencode>/<raencode><#codigo#></raencode>', '<#codigo#>');
     $grid = new DataGrid("");
     $grid->order_by("codigo", "asc");
     $grid->column_orderby("Unidades Administrativas", $uri, "codigo", "align='left'");
     $grid->column_orderby("Unidades Ejecutoras", "ejecutor", "ejecutor", "align='left'");
     $grid->column_orderby("Nombre", "nombre", "nombre", "align='left'");
     $grid->column_orderby("Director", "director", "director", "align='left'");
     $grid->add("presupuesto/uadministra/dataedit/create");
     $grid->build();
     $data['filtro'] = $filter->output;
     $data['content'] = $grid->output;
     $data['script'] = script("jquery.js") . "\n";
     $data['title'] = "{$this->titp}";
     //" $this->titp ";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Exemplo n.º 26
0
 function filteredgrid()
 {
     $this->datasis->modulo_id(85, 1);
     $this->rapyd->load("datafilter2", "datagrid");
     $this->rapyd->uri->keep_persistence();
     function blanco($num)
     {
         if (empty($num) || $num == 0) {
             return '';
         } else {
             return number_format($num, 2, ',', '.');
         }
     }
     $filter = new DataFilter2("", "grbi");
     $filter->id_grbi = new inputField("Grupo", "grupo");
     $filter->id_grbi->size = 20;
     $filter->grbi_nombre = new inputField("Nombre", "nombre");
     $filter->grbi_nombre->size = 20;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('inventario/grbi/dataedit/show/<raencode><#grupo#></raencode>', '<#grupo#>');
     $uri_2 = anchor('inventario/grbi/dataedit/create/<raencode><#grupo#></raencode>', 'Duplicar');
     $grid = new DataGrid("Lista de Grupos de Inventario");
     $grid->order_by("grupo", "asc");
     $grid->per_page = 20;
     $grid->use_function('blanco');
     $grid->column_orderby("Grupo", $uri, "grupo", "align='center'    ");
     $grid->column_orderby("Descripci&oacute;n", "nombre", "nombre", "align='left'NOWRAP");
     $grid->column_orderby("Cuenta Costo", "cuenta", "cuenta", "align='center'");
     $grid->column("Duplicar", $uri_2, "align='center'");
     $grid->add("inventario/grbi/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'] = "Grupos de Bienes";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Exemplo n.º 27
0
 function filteredgrid()
 {
     $this->datasis->modulo_id(128, 1);
     $this->rapyd->load("datafilter2", "datagrid");
     //
     $filter = new DataFilter2("", "ordinal");
     $filter->codigoadm = new inputField("Estructura Administrativa", "codigoadm");
     $filter->fondo = new inputField("F. Financiamiento", "fondo");
     $filter->codigopres = new inputField("Clasificador Presupuestario", "codigopres");
     $filter->ordinal = new inputField("Ordinal", "ordinal");
     $filter->ordinal->size = 5;
     $filter->ordinal->maxlenght = 2;
     $filter->ordinal->clause = "likerigth";
     $filter->denominacion = new inputField("Descripci&oacute;n", "denominacion");
     $filter->denominacion->size = 50;
     $filter->denominacion->maxlenght = 100;
     $filter->denominacion->clause = "likerigth";
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor($this->url . '/dataedit/show/<#codigoadm#>/<#fondo#>/<#codigopres#>/<#ordinal#>', '<#codigoadm#><#fondo#><#codigopres#><#ordinal#>');
     $grid = new DataGrid("");
     $grid->order_by("codigopres", "asc");
     $grid->column_orderby("", $uri, "codigoadm", "align='left'");
     $grid->column_orderby("Estructura Administrativa", "codigoadm", "codigoadm", "align='left'");
     $grid->column_orderby("Fondo", "fondo", "fondo", "align='left'");
     $grid->column_orderby("Clasificador Presupuestario", "codigopres", "codigopres", "align='left'");
     $grid->column_orderby("Ordinal", "ordinal", "ordinal", "align='left'");
     $grid->column_orderby("Descripci&oacute;n", "denominacion", "denominacion", "align='left' 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['content'] = $filter->output.$grid->output;
     //$data['title']   = " $this->titp ";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Exemplo n.º 28
0
 function index()
 {
     $this->rapyd->load("datagrid", "datafilter2");
     //$this->rapyd->uri->keep_persistence();
     $filter = new DataFilter2("");
     $filter->db->select(array("a.codigo", "a.denominacion", "b.nombre", "b.codigo eje"));
     $filter->db->from("estruadm a");
     $filter->db->join("uejecutora b", "a.uejecutora=b.codigo", "LEFT");
     $filter->cod_ppla = new inputField("C&oacute;digo", "codigo");
     $filter->cod_ppla->size = 15;
     //$filter->cod_ppla->clause="likerigth";
     $filter->cod_ppla->db_name = 'a.codigo';
     $filter->titulo = new inputField("Denominaci&oacute;n", "denominacion");
     $filter->titulo->clause = "likerigth";
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor($this->url . '/dataedit/show/<#codigo#>', '<#codigo#>');
     $grid = new DataGrid();
     $veje = $this->input->post('veje');
     //if($veje)
     //$grid->db->();
     $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", "align='left' NOWRAP");
     $grid->column_orderby("Cod", "eje", "eje");
     $grid->column_orderby("U. Ejecutora", "nombre", "nombre");
     $grid->add($this->url . "/dataedit/create");
     $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["head"] = $this->rapyd->get_head();
     //$data['title']   =' Estructura Administrativa ';
     $this->load->view('view_ventanas', $data);
 }
Exemplo n.º 29
0
 function filteredgrid()
 {
     $this->rapyd->load("datafilter2", "datagrid");
     //$this->rapyd->uri->keep_persistence();
     $filter = new DataFilter2("", "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->size = 13;
     $filter->nombre->maxlength = 40;
     $filter->rif = new inputField("Rif", "rif");
     $filter->rif->size = 13;
     $filter->rif->maxlength = 12;
     $filter->grupo = new dropdownField("Grupo", "grupo");
     $filter->grupo->option("", "");
     $filter->grupo->options("SELECT grupo,gr_desc,grupo FROM grpr ORDER BY gr_desc='01'");
     $filter->grupo->style = "width:290px";
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('presupuesto/sprv/dataedit/show/<#proveed#>', '<#proveed#>');
     $grid = new DataGrid("");
     $grid->order_by("proveed", "asc");
     $grid->per_page = 20;
     $grid->column_orderby("C&oacute;digo", $uri, "proveed", "align='center'");
     $grid->column_orderby("Nombre", "nombre", "nombre", "align='left'NOWRAP");
     $grid->column_orderby("R.I.F.", "rif", "rif", "align='center'");
     $grid->add("presupuesto/sprv/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'] = "Beneficiarios";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Exemplo n.º 30
0
 function filteredgrid()
 {
     $this->rapyd->load("datafilter2", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $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 DataFilter2("Filtro de {$this->titp}", "pacom");
     //$filter->db->where('status !=','F2');
     //$filter->db->where('status !=','F3');
     //$filter->db->where('status !=','F1');
     $filter->id = new inputField("N&uacute;mero", "id");
     $filter->id->size = 12;
     $filter->id->clause = "likerigth";
     $filter->cod_prov = new inputField("Beneficiario", 'cod_prov');
     $filter->cod_prov->size = 6;
     $filter->cod_prov->append($bSPRV);
     $filter->cod_prov->rule = "required";
     $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("Lista de " . $this->titp);
     $grid->order_by("id", "desc");
     $grid->per_page = 20;
     $grid->use_function('substr', 'str_pad', 'sta');
     $grid->column("N&uacute;mero", $uri);
     $grid->column("Beneficiario", "cod_prov");
     $grid->column("O.Compra", "<number_format><#total2#>|2|,|.</number_format>", "align='right'");
     $grid->column("Pago", "<number_format><#total2#>|2|,|.</number_format>", "align='right'");
     //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);
 }