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