function index() { $this->rapyd->load('dataform'); $filter = new dataForm('buscador/index/procesar'); $filter->valor = new inputField('Valor', 'valor'); $filter->valor->rule = 'required'; $filter->valor->size = 20; $filter->submit('btnsubmit', 'Buscar'); $filter->build_form(); $sal = ''; if ($filter->on_success()) { $this->load->library('table'); $this->table->set_heading('Tabla', 'Campo', 'Coincidencias'); $valor = $this->db->escape($filter->valor->newValue); $tables = $this->db->list_tables(); foreach ($tables as $table) { $fields = $this->db->list_fields($table); foreach ($fields as $field) { $mSQL = "SELECT COUNT(*) AS cana FROM `{$table}` WHERE `" . $field . "` = {$valor}"; $cana = $this->datasis->dameval($mSQL); if ($cana > 0) { $this->table->add_row($table, $field, $cana); } } } $sal = $this->table->generate(); } $data['content'] = $filter->output . $sal; $data['title'] = heading('Busca un valor en toda la base de datos'); $data['head'] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function sel() { $this->rapyd->load("dataform"); $tipo = $this->input->post('tipo'); $form = new dataForm('presupuesto/selpres/sel'); if ($tipo !== false) { $this->session->set_userdata(array("tipo" => $tipo)); } $form->pres = new freeField("Presupuesto Activo", "tipò", $this->session->userdata('tipo')); $form->tipo = new dropdownField('Presupuesto', 'tipo'); $form->tipo->options("SELECT tipo,tipo as valor FROM tipopres ORDER BY tipo"); $form->submit("btnsubmit", "Seleccionar"); $form->build_form(); $data['content'] = $form->output; $data['title'] = " Presupuesto Activo "; $data["head"] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function seleccion($ban = '0') { $this->rapyd->load("dataform", "datagrid"); $form = new dataForm('presupuesto/presupgenera/carga'); if ($ban == 0) { $form->msj = new freeField("", "tipò", "Cargo"); } $form->estruadm = new dropdownField("Estructura Administrativa", "estruadm"); $form->estruadm->options("SELECT codigo,CONCAT_WS(' ',codigo,denominacion) FROM estruadm WHERE LENGTH(codigo)=(SELECT LENGTH(valor) from valores WHERE nombre='FORMATOESTRU') ORDER BY codigo"); $form->tipo = new dropdownField("Tipo de presupuesto", "tipo"); $form->tipo->option("G", "Gasto"); $form->tipo->option("T", "Gasto e Ingreso"); $form->tipo->option("I", "Ingreso"); $form->tipo->style = 'width:150px;'; $form->fondo = new dropdownField("Origen de Fondo", "fondo"); $form->fondo->options("SELECT fondo, fondo AS val FROM fondo"); $form->fondo->style = 'width:150px;'; $form->submit("btnsubmit", "Generar"); $form->build_form(); $grid = new DataGrid(""); $grid->db->select(array("codigoadm", "tipo")); $grid->db->from('presupuesto'); $grid->db->orderby('codigoadm', 'desc'); $grid->db->groupby(array("codigoadm", " tipo")); //$grid->db->query("SELECT codigoadm, tipo FROM presupuesto GROUP BY codigoadm, tipo"); //$grid->order_by("sect_pres","asc"); $grid->column_orderby("Estructura Administrativa", "codigoadm", "codigoadm", "align='left'"); $grid->column_orderby("Tipo", "tipo", "tipo", "align='left'"); $grid->build(); //$data['filtro'] = $form->output; $data['content'] = $form->output . $grid->output; $data['script'] = script("jquery.js") . "\n"; $data['title'] = "Presupuestos Generados"; //$data['content'] = $form->output.$grid->output; //$data['title'] = " Generar Presupuesto "; $data["head"] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function imppago() { // Si manda el valor en el uri if ($this->uri->total_segments() == 6) { $tt = $this->uri->segment($this->uri->total_segments()); if ($this->uri->segment(5) == 'procesar') { $_POST['valor'] = $tt; } } else { $tt = 'procesar'; } $this->rapyd->load('datagrid', 'dataform'); $filter = new dataForm('contabilidad/casi/localizador/' . $tipo . '/procesar'); $filter->valor = new inputField($tit, 'valor'); $filter->valor->rule = 'required' . $rul; $filter->valor->autocomplete = false; $filter->valor->maxlength = $maxlen; $filter->valor->size = 15; if ($tt != 'procesar') { $filter->valor->insertValue = $tt; } $action = "javascript:window.location='" . site_url('contabilidad/casi/auditoria') . "'"; $filter->button('btn_regresa', 'Regresar', $action, 'BL'); $filter->submit('btnsubmit', 'Buscar'); $filter->build_form(); $sal = ''; /* $verdad = ($filter->on_success() && $filter->is_valid()); if ( $tt <> 'procesar') { $verdad = true; } */ if ($filter->on_success() && $filter->is_valid()) { $this->load->library('table'); $this->table->set_heading('Tabla', 'Campo', 'Coincidencias'); //$valor = str_pad($filter->valor->newValue,8,'0', STR_PAD_LEFT); if ($valor == '00000000') { $valor = $tt; } $valor = $this->db->escape($valor); $tables = $this->db->list_tables(); foreach ($tables as $table) { if (preg_match("/^view_.*\$|^sp_.*\$|^viemovinxventas\$/i", $table)) { continue; } $fields = $this->db->list_fields($table); if (in_array($cc, $fields)) { $mSQL = "SELECT COUNT(*) AS cana FROM `{$table}` WHERE {$cc} = {$valor}"; $cana = $this->datasis->dameval($mSQL); if ($cana > 0) { $grid = new DataGrid("{$table}: {$cana}"); //$grid->per_page = $cana; $grid->db->from($table); $grid->db->where("{$cc} = {$valor}"); $grid->db->limit(200); if (in_array('id', $fields)) { $grid->db->orderby('id', 'desc'); } foreach ($fields as $ff) { $grid->column($ff, $ff); } $grid->build(); $sal .= $grid->output; } } } } $data['content'] = $filter->output . $sal; $data['title'] = heading('Localizador de Transacciones'); $data['head'] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function localizador($tipo) { if ($tipo == 'cuenta') { $cc = 'cuenta'; $tit = 'Número de cuenta'; $rul = ''; $maxlen = '20'; } else { $cc = 'transac'; $tit = 'Número de transacción'; $rul = '|callback_chvalidt'; $maxlen = '8'; } // Si manda el valor en el uri if ($this->uri->total_segments() == 6) { $tt = $this->uri->segment($this->uri->total_segments()); if ($this->uri->segment(5) == 'procesar') { $_POST['valor'] = $tt; } } else { $tt = 'procesar'; } $this->rapyd->load('datagrid', 'dataform'); $filter = new dataForm('contabilidad/casi/localizador/' . $tipo . '/procesar'); $filter->valor = new inputField($tit, 'valor'); $filter->valor->rule = 'required' . $rul; $filter->valor->autocomplete = false; $filter->valor->maxlength = $maxlen; $filter->valor->size = 10; if ($tt != 'procesar') { $filter->valor->insertValue = $tt; } $action = "javascript:window.location='" . site_url('contabilidad/casi/auditoria') . "'"; $filter->button('btn_regresa', 'Regresar', $action, 'BL'); $filter->submit('btnsubmit', 'Buscar'); $filter->build_form(); $sal = ''; $verdad = $filter->on_success() && $filter->is_valid(); if ($tt != 'procesar') { $verdad = true; } if ($verdad) { $valor = str_pad($filter->valor->newValue, 8, '0', STR_PAD_LEFT); if ($valor == '00000000') { $valor = $tt; } $valor = $this->db->escape($valor); $tables = $this->db->list_tables(); foreach ($tables as $table) { if (preg_match("/^view_.*\$|^sp_.*\$|^viemovinxventas\$|^vietodife\$/i", $table)) { continue; } if ($cc == 'cuenta' && $table == 'itcasi') { continue; } $valasi = $cc == 'transac' && ($table == 'casi' || $table == 'itcasi'); $fields = $this->db->list_fields($table); if (in_array($cc, $fields) || $valasi) { if ($valasi) { $ccc = 'comprob'; } else { $ccc = $cc; } $mSQL = "SELECT COUNT(*) AS cana FROM `{$table}` WHERE {$ccc} = {$valor}"; $cana = intval($this->datasis->dameval($mSQL)); if ($cana > 0) { $grid = new DataGrid("{$table}: {$cana}"); //$grid->per_page = $cana; $grid->db->from($table); $grid->db->where("{$ccc} = {$valor}"); $grid->db->limit(200); if (in_array('id', $fields)) { $grid->db->orderby('id', 'desc'); } foreach ($fields as $ff) { $grid->column($ff, $ff); } $grid->build(); //echo $grid->db->last_query(); $sal .= $grid->output; } } } } $data['content'] = $filter->output . $sal; $data['title'] = heading('Localizador de Transacciones'); $data['head'] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }