<?php
defined('BASEPATH') OR exit('No direct script access allowed');

?>

            <div class="content-wrapper">
                <section class="content-header">
                    <?php echo $pagetitle; ?>
                    <?php echo $breadcrumb; ?>
                </section>

                <section class="content">
                    <div class="row">
                        <div class="col-md-12">
                             <div class="box">
                                <div class="box-header with-border">
                                </div>
                                <div class="box-body">
                                    <div style="overflow-x: scroll;">
                                    <table id="tabla_auditoria" class="table table-striped table-hover">
                                        <thead>
                                            <tr>
											    <th><?php echo lang('auditoria_nombre_esquema');?></th>
                                                <th><?php echo lang('auditoria_nombre_tabla');?></th>
                                                <th><?php echo lang('auditoria_relation_oid');?></th>
                                                <th><?php echo lang('auditoria_user_login');?></th>
                                                <th><?php echo lang('auditoria_user_id');?></th>
                                                <th><?php echo lang('auditoria_action_tstamp_tx');?></th>
                                                <th><?php echo lang('auditoria_action_tstamp_stm');?></th>
                                                <th><?php echo lang('auditoria_action_tstamp_clk');?></th>
                                                <th><?php echo lang('auditoria_id_registro');?></th>
                                                <th><?php echo lang('auditoria_nombre_aplcacion');?></th>
                                                <th><?php echo lang('auditoria_client_addr');?></th>
                                                <th><?php echo lang('auditoria_client_port');?></th>
                                                <th><?php echo lang('auditoria_query_principal');?></th>
                                                <th><?php echo lang('auditoria_tipo_dml');?></th>
                                                <th><?php echo lang('auditoria_r_old');?></th>
                                                <th><?php echo lang('auditoria_r_new');?></th>
                                                <th><?php echo lang('auditoria_statement_only');?></th>
                                                <th><?php echo lang('auditoria_action');?></th>
                                            </tr>
                                        </thead>
                                        <tbody> 
                                        
<?php foreach ($auditoria as $values):?>
                                            <tr>
                                                <td><?php echo htmlspecialchars($values->nombre_esquema, ENT_QUOTES, 'UTF-8');      ?></td>												
												<td><?php echo htmlspecialchars($values->nombre_tabla, ENT_QUOTES, 'UTF-8'); ?></td>	
                                                <td><?php echo htmlspecialchars($values->relation_oid, ENT_QUOTES, 'UTF-8'); ?></td>                                                
                                                <td><?php echo htmlspecialchars($values->user_login, ENT_QUOTES, 'UTF-8'); ?></td>
                                                <td><?php echo htmlspecialchars($values->user_id, ENT_QUOTES, 'UTF-8'); ?></td>
                                                <td><?php echo htmlspecialchars($values->action_tstamp_tx, ENT_QUOTES, 'UTF-8'); ?></td>
                                                <td><?php echo htmlspecialchars($values->action_tstamp_stm, ENT_QUOTES, 'UTF-8'); ?></td>
                                                <td><?php echo htmlspecialchars($values->action_tstamp_clk, ENT_QUOTES, 'UTF-8'); ?></td>
                                                <td><?php echo htmlspecialchars($values->id_registro, ENT_QUOTES, 'UTF-8'); ?></td>
                                                <td><?php echo htmlspecialchars($values->nombre_aplcacion, ENT_QUOTES, 'UTF-8'); ?></td>
                                                <td><?php echo htmlspecialchars($values->client_addr, ENT_QUOTES, 'UTF-8'); ?></td>
                                                <td><?php echo htmlspecialchars($values->client_port, ENT_QUOTES, 'UTF-8'); ?></td>
                                                <td><?php echo htmlspecialchars($values->query_principal, ENT_QUOTES, 'UTF-8'); ?></td>
                                                <td><?php echo htmlspecialchars($values->tipo_dml, ENT_QUOTES, 'UTF-8'); ?></td>
                                                <td><?php echo htmlspecialchars($values->r_old, ENT_QUOTES, 'UTF-8'); ?></td>
                                                <td><?php echo htmlspecialchars($values->r_new, ENT_QUOTES, 'UTF-8'); ?></td>
                                                <td><?php echo htmlspecialchars($values->statement_only, ENT_QUOTES, 'UTF-8'); ?></td>
                                                
                                                 <td align="center">
                                                    <?php echo anchor('auditoria/auditoria/mostrar/'.$values->id, lang('actions_see')); ?>
                                                    <?php //echo anchor('auditoria/auditoria/mostrar/'.$values->user_id, lang('actions_see')); ?> 
                                                    <?php echo '&nbsp;';?>

                                                    <?php //echo anchor('auditoria/auditoria/delete/'.$values->user_id, lang('actions_delete')); ?>
                                                </td>

                                            </tr>
<?php endforeach;?>
                                        </tbody>
                                    </table>
                                    </div>
                                    <?php echo $pagination; ?>
                                </div>
                            </div>
                         </div>
                    </div>
                </section>
            </div>


