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