function filteredgrid() { $this->rapyd->load("datafilter", "datagrid"); $this->rapyd->uri->keep_persistence(); $filter = new DataFilter("", 'valores'); $filter->nombre = new inputField("Nombre", "nombre"); $filter->nombre->size = 35; $filter->buttons("reset", "search"); $filter->build(); $uri = anchor('supervisor/valores/dataedit/show/<raencode><#nombre#></raencode>', '<#nombre#>'); $grid = new DataGrid(""); $grid->order_by("nombre", "asc"); $grid->column_orderby("Nombre", $uri, "nombre"); $grid->column_orderby("Valor", "valor", "valor"); $grid->column_orderby("Descripción", "descrip", "descrip", "align='left'NOWRAP"); $grid->add("supervisor/valores/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'] = " Valores "; $data["head"] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function dataedit() { $this->rapyd->load("dataedit"); $edit = new DataEdit("Sucursal", "sucu"); $edit->back_url = site_url("supervisor/sucu/filteredgrid"); $edit->codigo = new inputField("Código", "codigo"); $edit->codigo->rule = "required"; $edit->codigo->mode = "autohide"; $edit->codigo->size = 4; $edit->codigo->maxlength = 2; $edit->sucursal = new inputField("Sucursal", "sucursal"); $edit->sucursal->rule = "strtoupper"; $edit->sucursal->size = 60; $edit->sucursal->maxlength = 45; $edit->url = new inputField("URL", "url"); $edit->url->size = 80; $edit->url->maxlength = 200; $edit->prefijo = new inputField("Prefijo", "prefijo"); $edit->prefijo->size = 5; $edit->prefijo->maxlength = 3; $edit->proteo = new inputField("Proteo", "proteo"); $edit->proteo->maxlength = 50; $edit->proteo->size = 70; $edit->buttons("modify", "save", "undo", "delete", "back"); $edit->build(); $data['content'] = $edit->output; $data['title'] = "<h1>Sucursal</h1>"; $data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function dataedit() { $this->rapyd->load("dataobject", "dataedit"); // $link=site_url('finventario/bi_edificio/ultimo'); // $link2=site_url('finventario/bi_edificio/sugerir'); $edit = new DataEdit("Muebles", "bi_bienes"); $edit->back_url = site_url("bienes/bi_bienes/filteredgrid"); $edit->pre_process('insert', '_valida'); $edit->pre_process('update', '_valida'); $edit->id = new inputField("Id", "id"); $edit->id->mode = "autohide"; $edit->id->when = array('show'); $edit->nombre = new inputField("Nombre", "nombre"); $edit->nombre->size = 30; $edit->nombre->maxlength = 30; $edit->descrip = new textareaField("Descripción", "descrip"); $edit->descrip->rows = 4; $edit->descrip->cols = 50; $edit->modelo = new inputField("Modelo", "modelo"); $edit->modelo->size = 20; $edit->modelo->maxlength = 30; $edit->color = new inputField("Color", "color"); $edit->color->size = 20; $edit->color->maxlength = 30; $edit->buttons("modify", "save", "undo", "delete", "back"); $edit->build(); $data['content'] = $edit->output; $data['title'] = "Muebles"; $data["head"] = script("jquery.pack.js") . $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function filteredgrid() { $this->rapyd->load("datafilter", "datagrid"); $filter = new DataFilter("", 'prof'); $filter->codigo = new inputField("Codigo", "codigo"); $filter->codigo->size = 20; $filter->codigo->maxlength = 8; $filter->profesion = new inputField("Profesion", "profesion"); $filter->profesion->size = 20; $filter->profesion->maxlength = 40; $filter->buttons("reset", "search"); $filter->build(); $uri = anchor('nomina/prof/dataedit/show/<#codigo#>', '<#codigo#>'); $grid = new DataGrid(""); $grid->per_page = 15; $grid->column_orderby("Codigo", $uri, "codigo"); $grid->column_orderby("Profesiones", "profesion", "profesion", "align='left'NOWRAP"); $grid->add("nomina/prof/dataedit/create"); $grid->build(); //$data['content'] = $filter->output.$grid->output; $data['title'] = "Profesiones"; $data['filtro'] = $filter->output; $data['content'] = $grid->output; $data['script'] = script("jquery.js") . "\n"; $data["head"] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function filteredgrid() { $this->rapyd->load('datafilter', 'datagrid'); $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ó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ódigo', "{$uri}", 'codigo', 'align="left"'); $grid->column_orderby('Descripció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); }
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); }
function centinelas() { $this->load->helper('directory'); $this->load->library('table'); $tmpl = array('row_start' => '<tr valign="top">'); $this->table->set_template($tmpl); $map = directory_map('./system/logs/'); $lista = array(); foreach ($map as $file) { if ($file != 'index.html') { $lista[] = anchor("supervisor/mantenimiento/borracentinela/{$file}", 'X') . " <a href='javascript:void(0)' onclick=\"carga('{$file}')\" >{$file}</a>"; } } $copy = "<br><a href='javascript:void(0)' class='mininegro' onclick=\"copiar()\" >Copiar texto</a>"; $tadata = array('name' => 'sql', 'id' => 'log', 'rows' => '20', 'cols' => '60'); $form = form_open('ejecutasql/filteredgrid/process') . form_textarea($tadata) . '<br>' . form_submit('mysubmit', 'Ejecutar como SQL') . form_close(); $this->table->add_row(ul($lista), '<b id="fnom">Seleccione un archivo de centinela</b><br>' . $form); $link = site_url('supervisor/mantenimiento/vercentinela'); $data['script'] = "<script>\n\t\t function carga(arch){\n\t\t link='{$link}'+'/'+arch;\n\t\t //alert(link);\n\t\t \$('#fnom').text(arch);\n\t\t \$('#log').load(link);\n\t\t };\n\t\t function copiar(){\n\t\t \$('#log').copy();\n\t\t };\n\t\t</script>"; $data['content'] = $this->table->generate(); $data['title'] = " Centinelas "; //script('plugins/jquery.clipboard.pack.js') $data["head"] = script("jquery.pack.js") . script('plugins/jquery.copy.min.js') . $this->rapyd->get_head() . style('marcos.css') . style('estilos.css'); $this->load->view('view_ventanas', $data); }
function dataedit() { $this->rapyd->load("dataobject", "dataedit"); $edit = new DataEdit($this->t**s, $this->tabla); $edit->back_url = site_url($this->url . "/filteredgrid"); //$edit->pre_process('insert' ,'_valida'); //$edit->pre_process('update' ,'_valida'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->grupo = new dropdownField("Grupo", "grupo"); $edit->grupo->option(2, "2 Muebles"); $edit->grupo->option(1, "1 Inmuebles"); $edit->codigo = new inputField("Código", "codigo"); $edit->codigo->mode = "autohide"; $edit->codigo->rule = 'required'; $edit->codigo->maxlength = 4; $edit->codigo->size = 4; $edit->descrip = new textareaField("Descripción", "descrip"); $edit->descrip->rows = 4; $edit->descrip->cols = 50; $edit->descrip->rule = "required"; $edit->buttons("modify", "save", "undo", "delete", "back"); $edit->build(); $data['content'] = $edit->output; $data['title'] = $this->t**s; $data["head"] = script("jquery.js") . $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function index() { $this->rapyd->load("datagrid", "datafilter2"); $this->rapyd->uri->keep_persistence(); $filter = new DataFilter2("", 'cpla'); $filter->codigo = new inputField("Código", "codigo"); $filter->codigo->size = 15; //$filter->codigo->clause="likerigth"; $filter->denominacion = new inputField("Denominació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ódigo", $uri, "codigo", "align='left' NOWRAP"); $grid->column_orderby("Denominaó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); }
function filteredgrid() { $this->rapyd->load("datafilter", "datagrid"); $filter = new DataFilter("", 'usuario'); $filter->us_codigo = new inputField("Código Usuario", "us_codigo"); $filter->us_codigo->size = 15; $filter->us_nombre = new inputField("Nombre", "us_nombre"); $filter->us_nombre->size = 15; $filter->buttons("reset", "search"); $filter->build(); $uri = anchor('supervisor/usuarios/dataedit/show/<#us_codigo#>', '<#us_codigo#>'); $uri2 = anchor('supervisor/usuarios/cclave/modify/<#us_codigo#>', 'Cambiar clave'); $uri3 = anchor('accesos/crear/<#us_codigo#>', 'Asignar Accesos'); $grid = new DataGrid(""); $grid->order_by("us_codigo", "asc"); $grid->per_page = 20; $grid->column_ORDERBY("Código", $uri, "us_codigo "); $grid->column_ORDERBY("Nombre", "us_nombre", "us_nombre ", "align='left'NOWRAP"); $grid->column_ORDERBY("Supervisor", "supervisor", "supervisor", 'align="center" '); $grid->column("Cambio clave", $uri2, 'align="center"'); $grid->column("Asignar Accesos", $uri3, 'align="center"'); $grid->add("supervisor/usuarios/dataedit/create"); $grid->build(); //$data['content'] =$filter->output.$grid->output; $data['filtro'] = $filter->output; $data['content'] = $grid->output; $data['script'] = script("jquery.js") . "\n"; $data['title'] = " Usuarios "; $data["head"] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function dataedit() { $this->rapyd->load('dataedit'); $edit = new DataEdit($this->t**s, 'usuario'); $edit->back_url = site_url($this->url . "filteredgrid"); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->us_codigo = new inputField('Codigo', 'us_codigo'); $edit->us_codigo->rule = 'trim'; $edit->us_codigo->size = 14; $edit->us_codigo->maxlength = 12; $edit->us_codigo->mode = 'autohide'; $edit->us_nombre = new inputField('Nombre', 'us_nombre'); $edit->us_nombre->rule = 'trim'; $edit->us_nombre->size = 32; $edit->us_nombre->maxlength = 30; $edit->us_nombre->mode = 'autohide'; $edit->caja = new dropdownField("Caja", "cajas"); $edit->caja->option("", ""); $edit->caja->options("SELECT id,nombre FROM r_caja "); $edit->caja->rule = 'trim'; $edit->caja->size = 13; $edit->caja->maxlength = 11; $edit->caja->db_name = 'caja'; $edit->buttons('modify', 'save', 'undo', 'back'); $edit->build(); $data['content'] = $edit->output; $data['head'] = $this->rapyd->get_head() . script('jquery.js'); $data['title'] = $this->t**s; $this->load->view('view_ventanas', $data); }
function filteredgrid() { $this->rapyd->load('datafilter', 'datagrid'); $filter = new DataFilter($this->titp, 'r_negocio'); $filter->descrip = new inputField('Descripcion', 'descrip'); $filter->descrip->rule = 'max_length[100]'; $filter->descrip->size = 40; $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('Ref', "{$uri}", 'id', 'align="left"'); $grid->column_orderby('Descripcion', "descrip", 'descrip', 'align="left"'); $grid->column_orderby('Monto', "<nformat><#monto#></nformat>", 'monto', 'align="right"'); $grid->column_orderby('Monto2', "<nformat><#monto2#></nformat>", 'monto2', '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); }
function filteredgrid() { $this->rapyd->load('datafilter', 'datagrid'); $filter = new DataFilter($this->titp, 'rv_modelo'); $filter->db->select(array('rv_modelo.id', 'rv_modelo.descrip', 'rv_marca.descrip marca')); $filter->db->join("rv_marca", "rv_modelo.id_marca=rv_marca.id"); $filter->id = new inputField('id', 'id'); $filter->id->rule = 'max_length[11]'; $filter->id->size = 13; $filter->id->maxlength = 11; $filter->id_marca = new dropDownField('id_marca', 'id_marca'); $filter->id_marca->option("", ""); $filter->id_marca->options("SELECT id,descrip FROM rv_marca ORDER BY descrip"); $filter->descrip = new inputField('descrip', 'descrip'); $filter->descrip->rule = 'max_length[100]'; $filter->descrip->size = 40; $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('rv_modelo.id'); $grid->per_page = 40; $grid->column_orderby('Ref.', "{$uri}", 'id', 'align="left"'); $grid->column_orderby('Marca', "marca", 'id_marca', 'align="left"'); $grid->column_orderby('Descripcion', "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); }
function filteredgrid() { $this->rapyd->load('datafilter', 'datagrid'); $filter = new DataFilter($this->titp); $sel = array('a.id', 'a.descripcion', 'b.nombre'); $filter->db->select($sel); $filter->db->from('edifubica AS a '); $filter->db->join('edif AS b', 'a.id_edif=b.id'); $filter->descripcion = new inputField('Descripción', 'descripcion'); $filter->descripcion->rule = 'max_length[50]'; $filter->descripcion->size = 52; $filter->descripcion->maxlength = 50; $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('Edificación', 'nombre', 'nombre'); $grid->column_orderby('Descripcion', 'descripcion', 'descripcion', '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); }
function index() { $this->datasis->modulo_id($this->modulo, 1); $this->rapyd->load("datagrid", "dataform", "fields"); $control = $this->uri->segment(4); $checkbox = '<input type="checkbox" name="genera[]" value="<#modulo#>" CHECKED>'; $grid = new DataGrid('Seleccione los módulos que desea generar'); $grid->db->select('modulo, descripcion'); $grid->db->from('`reglascont`'); $grid->db->groupby('modulo'); $grid->db->orderby('modulo,regla'); $grid->column("Módulo", "modulo"); $grid->column("Descripción", "descripcion"); $grid->column('Generar', $checkbox, 'align="center"'); $grid->build(); $form = new DataForm('contabilidad/generar/procesar'); $form->title('Rango de fecha para la Generación'); $form->fechai = new dateonlyField("Fecha Desde", "fechai", "d/m/Y"); $form->fechaf = new dateonlyField("Fecha Hasta", "fechaf", "d/m/Y"); $form->fechaf->size = $form->fechai->size = 10; $form->fechai->insertValue = $this->input->post('fechai') ? $this->input->post('fechai') : date("Ymd"); $form->fechaf->insertValue = $this->input->post('fechaf') ? $this->input->post('fechaf') : date("Ymd"); $form->tabla = new containerField('tabla', $grid->output); if ($control) { $form->control = new containerField('control', 'Contabilidad Generada'); } //$form->submit("btn_submit","Generar Depurado"); $form->build_form(); $data['script'] = "<script type='text/javascript'>\n\t\tvar handlerFunc = function(t) {\n\t\t\tdocument.getElementById('preloader').style.display='none';\n\t\t\tnew Effect.Opacity('contenido', {duration:0.5, from:0.3, to:1.0});\n\t\t\talert(t.responseText);\n\t\t}\n\n\t\tvar errFunc = function(t) {\n\t\t\tdocument.getElementById('preloader').style.display='none';\n\t\t\tnew Effect.Opacity('contenido', {duration:0.5, from:0.3, to:1.0});\n\t\t\talert('Error ' + t.status + ' -- ' + t.statusText);\n\t\t}\n\n\t\tfunction generar() {\n\t\t\tnew Effect.toggle('preloader', 'appear');\n\t\t\tnew Effect.Opacity('contenido', {duration:0.5, from:1.0, to:0.3});\n\t\t\tnew Ajax.Request('" . site_url('contabilidad/generar/procesar') . "',{\n\t\t\t method: 'post',\n\t\t\t parameters : Form.serialize('df1'),\n\t\t\t onSuccess:handlerFunc,\n\t\t\t onFailure:errFunc});\n\t\t}\n\t\t</script>"; $data['extras'] = "<div id='preloader' style='display: none;\tposition:absolute; left:40%; top:40%; font-family:Verdana, Arial, Helvetica, sans-serif;'>\n\t\t\t<center>" . image("loading4.gif") . "<br>" . image("loadingBarra.gif") . "<br>\n\t\t\t<b>Generando . . . </b>\n\t\t\t</center>\n\t\t</div>"; $data['content'] = $form->output . "<input type=button value='Generar' onclick='generar()'>"; $data["head"] = $this->rapyd->get_head() . script("prototype.js") . script("scriptaculous.js") . script("effects.js"); $data['title'] = "<h1>Generar Contabilidad</h1>"; $this->load->view('view_ventanas', $data); }
function crearpago($sprv) { $mSQL = "SELECT tipo_doc,numero,fecha,monto,abonos FROM sprm WHERE cod_prv='{$sprv}' AND monto>abonos"; $query = $this->db->query($mSQL); $pjson = array(); $aplicables = $pagables = array(); if ($query->num_rows() > 0) { foreach ($query->result_array() as $row) { if (eregi('^(FC|GI|ND)$', $row['tipo_doc'])) { $row['fecha'] = str_replace('-', '', $row['fecha']); $pagables[] = $row; $id = $row['tipo_doc'] . $row['numero'] . $row['fecha']; $pjson[$id] = $row['monto'] - $row['abonos']; } else { $aplicables[] = $row; } } } $ddata = array('pagables' => $pagables, 'aplicables' => $aplicables); $ddata['link'] = site_url('compras/sprm/procesapago'); $ddata['sprv'] = $sprv; $ddata['pjson'] = json_encode($pjson); $proveed = $this->datasis->dameval("SELECT nombre FROM sprv WHERE proveed='{$sprv}'"); $data['title'] = "<h1>Realizar pago a ({$sprv}) {$proveed}</h1>"; $data["head"] = style('proteo/proteo.css') . script('jquery.js') . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . script('jquery-ui.js'); $data['content'] = $this->load->view('view_sprm', $ddata, true); $this->load->view('view_ventanas', $data); }
function dataedit() { $this->datasis->modulo_id(101, 1); $this->rapyd->load("dataedit"); $script = ' $(".inputnum").numeric("."); '; $edit = new DataEdit("Sector", "sectores"); $edit->script($script, "create"); $edit->back_url = site_url("presupuesto/sectores/filteredgrid"); $edit->sect_pres = new inputField("Código", "sect_pres"); $edit->sect_pres->size = 5; $edit->sect_pres->maxlength = 2; $edit->sect_pres->mode = "autohide"; $edit->sect_pres->css_class = 'inputnum'; $edit->nomb_sect = new inputField("Nombre", "nomb_sect"); $edit->nomb_sect->size = 40; $edit->nomb_sect->maxlength = 80; $edit->nomb_sect->rule = 'required'; $edit->buttons("modify", "save", "undo", "delete", "back"); $edit->build(); $data['content'] = $edit->output; $data['title'] = " Sectores "; $data["head"] = script("jquery.pack.js") . $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function departamento() { $this->rapyd->load("datagrid2"); $this->rapyd->load("dataform"); $this->load->helper('openflash'); $script = ' $(function() { $(".inputnum").numeric("."); }); '; if ($this->uri->segment(4)) { $anio = $this->uri->segment(4); } elseif (isset($_POST['anio'])) { $anio = $_POST['anio']; } if (empty($anio)) { $anio = date("Y"); } $fechai = $anio . '0101'; $fechaf = $anio . '1231'; $filter = new DataForm('ventas/ganancias/departamento'); $filter->title('Filtro de Ganancias'); $filter->script($script, "create"); $filter->script($script, "modify"); $filter->anio = new inputField("Año", "anio"); $filter->anio->size = 4; $filter->anio->insertValue = $anio; $filter->anio->maxlength = 4; $filter->anio->rule = "trim"; $filter->anio->css_class = 'inputnum'; $filter->button("btnsubmit", "Buscar", form2uri(site_url('ventas/ganancias/departamento'), array('anio')), $position = "BL"); $filter->build_form(); $grid = new DataGrid2(); $select = array("a.fecha", "e.depto", "e.descrip as nombre", "SUM(a.promedio*a.cantidad) AS costo", "SUM(a.venta) AS ventas", "SUM(a.venta)/COUNT(*)AS porcentaje", "SUM(a.venta)-SUM(a.promedio*a.cantidad) AS ganancias", "COUNT(*) AS numfac"); $grid->db->select($select); $grid->db->from($this->from); foreach ($this->join as $valor) { $grid->db->join($valor[0], $valor[1], $valor[2]); } $grid->db->where('e.tipo', "I"); $grid->db->where("a.origen IN ('3I','3M')"); $grid->db->where('fecha >= ', $fechai); $grid->db->where('fecha <= ', $fechaf); $grid->db->groupby("d.depto"); $grid->db->orderby("ganancias DESC"); $grid->column("Departamento", "nombre", "align='left'"); $grid->column("Costo", "<number_format><#costo#>|2|,|.</number_format>", 'align=right'); $grid->column("Ventas", "<number_format><#ventas#>|2|,|.</number_format>", 'align=right'); $grid->column("Ganancias", "<number_format><#ganancias#>|2|,|.</number_format>", 'align=right'); $grid->column("% Ventas", "<number_format><#porcentaje#>|2|,|.</number_format>", 'align=right'); $grid->column("Cant. Fact", "numfac", 'align=right'); $grid->totalizar('ventas', 'ganancias', 'costo'); $grid->build(); $grafico = open_flash_chart_object(680, 400, site_url("ventas/ganancias/gdepartamento/{$anio}")); $data['content'] = $grafico; $data['content'] .= $filter->output . $grid->output; $data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head(); $data['title'] = $this->rapyd->get_head() . "<h1>Ganancias por Departamentos</h1>"; $this->load->view('view_ventanas', $data); }
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ó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); }
function dataedit() { $this->rapyd->load("dataedit"); $edit = new DataEdit("", "prueba"); $edit->id = new inputField("Código", "id"); $edit->id->rule = "trim|required"; $edit->id->size = 16; $edit->id->maxlength = 15; $edit->html = new editorField("Contenido", "html"); $edit->html->rule = "required"; $edit->html->rows = 20; //$edit->contenido->upload_path = $this->upload_path; $edit->html->cols = 90; $edit->html->when = array("modify"); // //$edit->html2 = new htmlField("Codice HTML", "html"); //$edit->html2->cols = 70; //$edit->html2->rows = 10; $edit->iframe = new iframeField("related", "mpru/a", "500"); $edit->iframe->when = array("show"); //$edit->iframe->group = "Related Records"; //$edit->container = new containerField("alert","html"); //$edit->container->when = array("show"); // //$edit->free = new freeField("Free Field","html","html"); $edit->buttons("modify", "save", "undo", "delete", "back"); $edit->build(); $data['content'] = $edit->output; $data["head"] = script("tabber.js") . script("prototype.js") . $this->rapyd->get_head() . script("scriptaculous.js") . script("effects.js"); $data['title'] = '<h1>Catalogos de Inventarios</h1>'; $this->load->view('view_ventanas', $data); }
function jqdatag() { $grid = $this->defgrid(); $grid->setHeight('185'); $param['grids'][] = $grid->deploy(); $grid1 = $this->defgridit(); $grid1->setHeight('190'); $param['grids'][] = $grid1->deploy(); // Configura los Paneles $readyLayout = $grid->readyLayout2(212, 220, $param['grids'][0]['gridname'], $param['grids'][1]['gridname']); //Funciones que ejecutan los botones $bodyscript = $this->bodyscript($param['grids'][0]['gridname'], $param['grids'][1]['gridname']); //Botones Panel Izq //$grid->wbotonadd(array('id'=>'imprime', 'img'=>'assets/default/images/print.png','alt' => 'Reimprimir', 'label'=>'Informe')); $grid->wbotonadd(array('id' => 'finaliza', 'img' => 'assets/default/images/34.png', 'alt' => 'Finalizar', 'label' => 'Finalizar')); $WestPanel = $grid->deploywestp(); //Panel Central $centerpanel = $grid->centerpanel($id = "radicional", $param['grids'][0]['gridname'], $param['grids'][1]['gridname']); $adic = array(array('id' => 'fedita', 'title' => 'Agregar/Editar Registro'), array('id' => 'fshow', 'title' => 'Mostrar Registro'), array('id' => 'fborra', 'title' => 'Eliminar Registro')); $SouthPanel = $grid->SouthPanel($this->datasis->traevalor('TITULO1'), $adic); $param['WestPanel'] = $WestPanel; $param['script'] = script('plugins/jquery.ui.autocomplete.autoSelectOne.js'); $param['readyLayout'] = $readyLayout; $param['SouthPanel'] = $SouthPanel; $param['listados'] = $this->datasis->listados('SINVAUDIT', 'JQ'); $param['otros'] = $this->datasis->otros('SINVAUDIT', 'JQ'); $param['centerpanel'] = $centerpanel; $param['temas'] = array('proteo', 'darkness', 'anexos1'); $param['bodyscript'] = $bodyscript; $param['tabs'] = false; $param['encabeza'] = $this->titp; $param['tamano'] = $this->datasis->getintramenu(substr($this->url, 0, -1)); $this->load->view('jqgrid/crud2', $param); }
function filteredgrid() { $this->rapyd->load('datafilter', 'datagrid'); $filter = new DataFilter($this->titp, 'ri_clase'); $filter->id = new inputField('Id', 'id'); $filter->id->rule = 'trim'; $filter->id->size = 13; $filter->id->maxlength = 11; $filter->nombre = new inputField('Nombre', 'nombre'); $filter->nombre->rule = 'trim'; $filter->nombre->size = 40; $filter->nombre->maxlength = 255; $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><#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->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); }
function dataedit() { $this->datasis->modulo_id(102, 1); $this->rapyd->load("dataedit"); $script = ' $(".inputnum").numeric("."); '; $edit = new DataEdit("Programas", "programas"); $edit->script($script, "create"); $edit->back_url = site_url("presupuesto/programas/filteredgrid"); $edit->sect_pres = new dropdownField("Sector", "sect_pres"); $edit->sect_pres->options("SELECT sect_pres, CONCAT_WS(' ',sect_pres,nomb_sect)AS nomb_sect FROM sectores ORDER BY sect_pres"); $edit->sect_pres->style = 'width:300px;'; $filter->id_prog = new inputField("Identificador", "id_prog"); $filter->id_prog->size = 5; $edit->prog_pres = new inputField("Código Programa", "prog_pres"); $edit->prog_pres->size = 5; $edit->prog_pres->maxlength = 2; $edit->prog_pres->mode = "autohide"; $edit->prog_pres->css_class = 'inputnum'; $edit->prog_pres->rule = 'required'; $edit->nomb_prog = new inputField("Nombre Programa", "nomb_prog"); $edit->nomb_prog->size = 40; $edit->nomb_prog->maxlength = 80; $edit->nomb_prog->rule = 'required'; $edit->buttons("modify", "save", "undo", "delete", "back"); $edit->build(); $data['content'] = $edit->output; $data['title'] = " Programas "; $data["head"] = script("jquery.pack.js") . $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function dataedit() { $this->rapyd->load("dataedit"); $script = ' $(function() { $(".inputnum").numeric("."); }); '; $edit = new DataEdit("Cargos", "carg"); $edit->back_url = "nomina/carg/filteredgrid"; $edit->script($script, "create"); $edit->script($script, "modify"); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->cargo = new inputField("Cargo", "cargo"); $edit->cargo->rule = "required|callback_chexiste"; $edit->cargo->mode = "autohide"; $edit->cargo->maxlength = 8; $edit->cargo->size = 10; $edit->descrip = new inputField("Descripción", "descrip"); $edit->descrip->size = 40; $edit->descrip->maxlength = 30; $edit->descrip->rule = "strtoupper|required"; $edit->sueldo = new inputField("Sueldo", "sueldo"); $edit->sueldo->size = 20; $edit->sueldo->rule = "required|callback_positivo"; $edit->sueldo->css_class = 'inputnum'; $edit->buttons("modify", "save", "undo", "delete", "back"); $edit->build(); $data['content'] = $edit->output; $data['title'] = "<h1>Cargos</h1>"; $data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function filteredgrid() { $this->rapyd->uri->keep_persistence(); $this->rapyd->load('datafilter', 'datagrid'); $filter = new DataFilter('', 'gpt_pro'); $filter->parr = new inputField('Pará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ó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); }
function imprimir() { $this->rapyd->load("dataform"); $scli = array('tabla' => 'scli', 'columnas' => array('cliente' => 'Código Cliente', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('cliente' => 'Código Cliente', 'nombre' => 'Nombre'), 'retornar' => array('cliente' => 'cliente'), 'titulo' => 'Buscar Cliente'); $cboton = $this->datasis->modbus($scli); $filter = new DataForm('/tiketimp/index'); $filter->title('Filtro de Impresion de Tiket'); $filter->fechad = new dateonlyField("Desde", "fechad", 'Ymd'); $filter->fechah = new dateonlyField("Hasta", "fechah", 'Ymd'); $filter->fechad->clause = $filter->fechah->clause = "where"; $filter->fechad->db_name = $filter->fechah->db_name = "fecha"; //$filter->fechad->insertValue = $fechad; //$filter->fechah->insertValue = $fechah; $filter->fechah->size = $filter->fechad->size = 10; $filter->fechad->operator = ">="; $filter->fechah->operator = "<="; $filter->cliente = new inputField("Cliente", "cliente"); $filter->cliente->size = 10; //$filter->cliente->insertValue=$cliente; $filter->cliente->maxlength = 10; $filter->cliente->append($cboton); $filter->button("btnsubmit", "Buscar", form2uri(site_url("/formatos/ver/TIKET/"), array('cliente', 'fechad', 'fechah')), $position = "BL"); // $filter->build_form(); $data['content'] = $filter->output; $data['title'] = "<h1>Imprimir</h1>"; $data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function filteredgrid() { $this->rapyd->load('datafilter', 'datagrid'); $filter = new DataFilter($this->titp, 'parroquia'); $filter->id = new inputField('id', 'id'); $filter->id->rule = 'max_length[11]'; $filter->id->size = 13; $filter->id->maxlength = 11; $filter->nombre = new inputField('nombre', 'nombre'); $filter->nombre->rule = 'max_length[255]'; $filter->nombre->size = 257; $filter->nombre->maxlength = 255; $filter->buttons('reset', 'search'); $filter->build(); $uri = anchor($this->url . 'dataedit/show/<raencode><#id#></raencode>', '<#id#>'); $grid = new DataGrid(''); $grid->order_by('id'); $grid->per_page = 40; $grid->column_orderby('id', "{$uri}", 'id', 'align="left"'); $grid->column_orderby('nombre', "nombre", 'nombre', 'align="left"'); $grid->add($this->url . 'dataedit/create'); $grid->build(); $data['filtro'] = $filter->output; $data['content'] = $grid->output; $data['head'] = $this->rapyd->get_head() . script('jquery.js'); $data['title'] = $this->titp; $this->load->view('view_ventanas', $data); }
function filteredgrid() { $this->rapyd->load("datafilter", "datagrid"); $this->rapyd->uri->keep_persistence(); $filter = new DataFilter("", '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ón", $uri, "division"); $grid->column_orderby("Descripción", "descrip", "descrip", "align='left'NOWRAP"); $grid->column_orderby("Departamento", "departa", "departa", "align='left'NOWRAP"); $grid->column_orderby("Descripció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); }
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); }
function filteredgrid() { $this->rapyd->load('datafilter', 'datagrid'); $filter = new DataFilter($this->titp); $filter->db->from("casise a"); $filter->ano = new inputField('Año', 'ano'); $filter->ano->size = 4; $filter->ano->maxlength = 2; $filter->mes = new inputField('mes', 'mes'); $filter->mes->rule = 'max_length[2]'; $filter->mes->size = 4; $filter->mes->maxlength = 2; $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('Referencia', $uri, 'id', 'align="left"'); $grid->column_orderby("Año", "ano", "ano", "align='left'"); $grid->column_orderby('Mes', "mes", 'mes', '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); }