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