<?php 
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);

session_start();

$d_tec_id = $_SESSION['tec_id'];
$d_etapa  = $_SESSION['etapa'];
$d_codigo = $_SESSION['codigo'];
$d_tpr    = $_SESSION['tpr'];
$d_tpt    = $_SESSION['tpt'];
$d_tipo   = $_SESSION['tipo'];
$d_id     = $_SESSION['d_id'];

$msg_notice='';
include_once ('conexion.inc.php');
include_once ('settings.php');

$arr_label[740]= 'nombre';
$arr_label[741]= 'ver';
$arr_label[742]= 'cargar';
$arr_label[743]= 'descargar';
$arr_label[744]= 'regresar';
$arr_label[745]= 'select_imagen';
$arr_label[1538]= 'adm_cod_sr_file_desc';
$arr_label[1539]= 'adm_con_sr_date';
$arr_label[1540]= 'adm_con_sr_file_name';
$arr_label[1718]= 'nra_tecnico';
$arr_label[1726]= 'file_info1';
$arr_label[1727]= 'file_info2';
$arr_label[1728]= 'file_info3';
$arr_label[1729]= 'file_info4';
$arr_label[1756]= 'email_enviar';
$arr_label[110] = 'notice'; 
$arr_label[1731] = 'notice1'; 
$arr_label[1732] = 'notice2'; 
$arr_label[1733] = 'notice3'; 
$arr_label[1734] = 'notice4'; 
$arr_label[1791] = 'notice5'; 
$arr_label[1777] = 'procesing'; 
$arr_label[1911] = 'doc_title1'; //M2

$arr_lang = "740,741,742,743,744,745,1538,1539,1540,1718,1726,1727,1728,1729,1756,110,1731,1732,1733,1734,1791,1777,1911";

include('form_language.php');

iniciarConexionVUS();
$est_id=0;
$sql = "SELECT vus_{$d_tipo}_fec_cre, vus_{$d_tipo}_numreg, vus_{$d_tipo}_est_id, vus_{$d_tipo}_numsol  FROM vus_tramites_{$d_tipo}2 WHERE vus_{$d_tipo}_numsol='{$d_codigo}'";
// echo "(".$sql.")";
$ret=$connectionVUS->Execute($sql);
if ($ret->fields["vus_{$d_tipo}_fec_cre"]) {
    list($fecha,$hora) = explode(" ",$ret->fields["vus_{$d_tipo}_fec_cre"]);
    list($anio,$mes,$dia) = explode("-",$fecha);
    $est_id=intval($ret->fields["vus_{$d_tipo}_est_id"]);
    if ($est_id==9){
        $numreg=$ret->fields["vus_{$d_tipo}_numreg"];
    } else {
        $numreg=$ret->fields["vus_{$d_tipo}_numsol"];        
    }

}
$local_directory = "";
$ruta2= "";

// if ($est_id==9){
    $ruta2 .= "/var/www/html/siverc".$location_adm;
    $ruta2 .= "/docs"; 
    $ruta2 .= "/{$d_tipo}"; 
    $ruta21 = $ruta2."/{$numreg}"; 
    mkdir($ruta21,7777);
    shell_exec("chmod 7777 $ruta21");
    
    $ruta21 = $ruta2."/{$numreg}/0"; 
    mkdir($ruta21,7777);
    shell_exec("chmod 7777 $ruta21");
    
    $ruta2 .= "/{$numreg}/0/"; 

    if ($ip_ext==$ip_int){
        $ruta3 = "adm";
    } else {
        $ruta3 = $location_adm;
    }
    $ruta3 .= "/docs"; 
    $ruta3 .= "/{$d_tipo}"; 
    $ruta3 .= "/{$numreg}/0/"; 
    // echo "(".$ruta21.")";
    
// } else {
//     $ruta2 .= "/var/www/html/siverc".$location_adm;
//     $ruta2 .= "/docs"; 
//     $ruta2 .= "/{$d_tipo}"; 
//     $ruta21 = $ruta2."/{$numreg}/0"; 
//     mkdir($ruta21,7777);
//     shell_exec("chmod 7777 $ruta21");
    
//     $ruta21 = $ruta2."/{$numreg}"; 
//     mkdir($ruta21,7777);
//     shell_exec("chmod 7777 $ruta21");
    
//     $ruta2 .= "/{$numreg}/"; 
    
//     if ($ip_ext==$ip_int){
//         $ruta3 = "adm";
//     } else {
//         $ruta3 = $location_adm;
//     }
//     $ruta3 .= "/docs"; 
//     $ruta3 .= "/{$d_tipo}"; 
//     $ruta3 .= "/{$numreg}/0/"; 
    // echo "(".$ruta21.")";
// }



switch($_POST['action']){
case 1:
    if (isset($_FILES['adm_con_sr_file_name'])){

        $operador = 0;

        if ($_FILES['adm_con_sr_file_name']['error'] == 0){
            $siglas="DR-00";
            $sqla="SELECT * FROM ctg_tipo_formatos WHERE ctg_fmt_id ='{$_POST['tpf']}' AND ctg_tpr_id='{$d_tpr}'"; 
            $resulta = $connection->Execute ($sqla);
            if (!$resulta->EOF) {
                $siglas=$resulta->fields["ctg_fmt_sig"];
                $tmf_id=$resulta->fields["ctg_fmt_id"];
                $tmp_file_desc=$resulta->fields['ctg_fmt_desc'];
            }

            $upload_file = $d_tipo."_".$numreg."_".date("Y")."_".$siglas.".pdf";
            			
            $sql= "SELECT * FROM adm_control_".$d_tipo."1_docs WHERE 
            adm_cod_numsol = '".$d_codigo."' AND 
            adm_cod_tpt_id='AO' AND adm_cod_tpr_id='{$d_tpr}' AND 
            adm_cod_ttc_id='DR' AND adm_cod_tmf_id='".$tmf_id."' "; 
            $result=$connection->Execute($sql);
            if ($result->EOF){ //si no existe
				$operador = 1;
            } else {
				$operador = 2;
            }
            // echo "(".$ruta2.$upload_file.")";
            $uploaded=0;
            if ($operador > 0){
                if($_FILES['adm_con_sr_file_name']['tmp_name'] != "" && $_FILES['adm_con_sr_file_name']['tmp_name'] != "none"){
                    
                    $max_size = "5000000000";
                    
                    if($_FILES['adm_con_sr_file_name']['type'] != 'application/pdf' && $_FILES['adm_con_sr_file_name']['type'] != 'image/jpeg' && $_FILES['adm_con_sr_file_name']['type'] != "image/png"){

                        $operador = 0;
                        echo "<font color=white>".$arr_label['file_info1']."</font>";

                    }else{
                        
                        if($_FILES['adm_con_sr_file_name']['size'] > $max_size){
                            $operador = 0;
                            $msg_notice= "<font color=white>".$arr_label['file_info3']."</font>";
                        }else{                        	
                            if (move_uploaded_file($_FILES['adm_con_sr_file_name']['tmp_name'], $ruta2.$upload_file)) {
                               $msg_notice= "<font color=white> ".$arr_label['file_info2']." </font>";
                               $uploaded=1;
                            } else {
                               $msg_notice= "<font color=white>".$arr_label['file_info4']."</font>";
                               echo "br>Not uploaded because of error #".$_FILES["adm_con_sr_file_name"]["error"];
                                $operador = 0;

                            }            

                        }
                    }
                } //else $file_status = $arr_label['no_file'];
                
            }

            if ($operador == 1) {
                $ctg_fmt_cor=1;
                $ctg_fmt_siglas="";
                $sql91 = "SELECT coalesce(ctg_fmt_cor,0)+1 as ctg_fmt_cor, ctg_fmt_sig FROM ctg_tipo_formatos WHERE ctg_fmt_id='".$tmf_id."' AND ctg_tpr_id='".$d_tpr."'";
                $qTMP91 = $connection->Execute ($sql91);
                if (!$qTMP91->EOF){
                    $ctg_fmt_cor=$qTMP91->fields["ctg_fmt_cor"];
                    $ctg_fmt_siglas=$qTMP91->fields["ctg_fmt_sig"];
                }
                if ($ctg_fmt_cor <10)
                    $ctg_fmt_cor="000".$ctg_fmt_cor;
                else
                    if ($ctg_fmt_cor<100)
                        $ctg_fmt_cor="00".$ctg_fmt_cor;
                    else
                        if ($ctg_fmt_cor<1000)
                            $ctg_fmt_cor="0".$ctg_fmt_cor;
            
                $ctg_fmt_cor=$ctg_fmt_siglas.$ctg_fmt_cor."-".date("Y");
                if ($d_tec_id=='')
                    $d_tec_id=$_SESSION['ADMusuario_id'];

                $sql_doc="INSERT INTO adm_control_{$d_tipo}1_docs (
                adm_cod_sr_id,
                adm_cod_numsol,
                adm_cod_tpr_id,
                adm_cod_tpt_id,
                adm_cod_ttc_id,
                adm_cod_tec_id,
                adm_cod_date,
                adm_cod_tmf_id,                
                adm_cod_part,
                adm_cod_file_desc,
                adm_cod_file_name,
                adm_cod_file_loca,
                adm_cod_file,
                adm_cod_path,
                adm_cod_numreg,
                adm_cod_tmf_cor,        
                adm_cod_sta,
                adm_cod_usr,
                adm_cod_dt,
                adm_cod_file_type
                ) VALUES ( 
                nextval('adm_control_ef1_docs_adm_cod_sr_id_seq'),
                '".$d_codigo."',
                '".$d_tpr."',
                'AO',
                'DR',
                '".$d_tec_id."',
                now(),
                '".$tmf_id."',
                '1',
                '".$tmp_file_desc."',
                '".$upload_file."',
                '".$ruta2."',
                '".$upload_file."',
                '/docs/".$d_tipo."/".$numreg."/0/', 
                '".$numreg."',
                '".$ctg_fmt_cor."',
                '1',
                '".$d_tec_id."',
                now(),
                '".$_FILES['adm_con_sr_file_name']['type']."'
                );";
                $result_doc = $connection->Execute ($sql_doc);
                
                $sql93 = "UPDATE ctg_tipo_formatos SET ctg_fmt_cor=coalesce(ctg_fmt_cor,0)+1 WHERE ctg_fmt_id='01' AND ctg_tpr_id='".$d_tpr."'";
                $qTMP93 = $connection->Execute ($sql93);

                $catalogo_prefijo="\"adm_".$d_tipo."DOC_";

                $num_id='0';
                $sql= "SELECT adm_{$d_tipo}_id FROM ctg_productos_{$d_tipo} WHERE adm_{$d_tipo}_numreg='".$numreg."' AND adm_{$d_tipo}_tpr_id='".$d_tpr."' ";
                // echo $sql."<br><br>";
                $result=$connection->Execute($sql);
                if(!$result->EOF) {				
                    $num_id=$result->fields[0];
                }

                $sql= "SELECT \"adm_".$d_tipo."DOC_part\" FROM \"ctg_productos_".$d_tipo."_DOCs\" WHERE \"adm_".$d_tipo."DOC_id\"='".$tmf_id."' 
                AND  \"adm_".$d_tipo."DOC_ttc_id\"='DR' AND \"adm_".$d_tipo."DOC_numreg\"='".$numreg."' 
                AND \"adm_".$d_tipo."DOC_numsol\"='0' AND \"adm_".$d_tipo."DOC_tpt_id\"='AO' 
                AND \"adm_".$d_tipo."DOC_tpr_id\"='".$d_tpr."'";
                $result=$connection->Execute($sql);
                if($result->EOF) {
    
                    $sq60="INSERT INTO \"ctg_productos_".$d_tipo."_DOCs\" (
                    ".$catalogo_prefijo."idr\",
                    ".$catalogo_prefijo."numreg\",
                    ".$catalogo_prefijo."numsol\",
                    ".$catalogo_prefijo."tpt_id\",
                    ".$catalogo_prefijo."tpr_id\",
                    ".$catalogo_prefijo."ttc_id\",
                    ".$catalogo_prefijo."id\",
                    ".$catalogo_prefijo."part\",
                    ".$catalogo_prefijo."doc_name\",
                    ".$catalogo_prefijo."doc_desc\",
                    ".$catalogo_prefijo."docubi\",
                    ".$catalogo_prefijo."size\",
                    ".$catalogo_prefijo."sta\",
                    ".$catalogo_prefijo."usr\",
                    ".$catalogo_prefijo."dt\"
                    ) VALUES (
                    '$num_id',
                    '$numreg',
                    '0',
                    'AO',
                    '$d_tpr',
                    'DR',
                    '$tmf_id',
                    '1',
                    '$upload_file',
                    '$tmp_file_desc',
                    '$ruta2',
                    '0',
                    '1',
                    '$d_tec_id',
                    'now()');";
                    // echo "<br>sql 60 (".$sq60;
                    $result = $connection->Execute ( $sq60 );
                }
            } 

            if ($operador == 2) {
                unlink($ruta2.$_POST['adm_cod_sr_file_name2']);

                $sql="UPDATE adm_control_{$d_tipo}_docs SET 
                adm_cod_date = now(), 
                adm_cod_file_desc = '".$tmp_file_desc."', 
                adm_cod_file_name = '".$upload_file."', 
                adm_cod_file_loca = '".'/docs/{$d_tipo}/{$numreg}/0/'."', 
                adm_cod_sta = '2', 
                adm_cod_usr = '".$d_tec_id."', 
                adm_cod_dt = now(), 
                adm_cod_file_type = '".$_FILES['adm_con_sr_file_name']['type']."' 
                WHERE adm_cod_numsol = '".$d_codigo."' AND 
                adm_cod_tpr_id = '".$d_tpr."' AND
                adm_cod_tpt_id = 'AO' AND
                adm_cod_ttc_id = 'DR' AND
                adm_cod_tmf_id='".$tmf_id."' AND 
                adm_cod_file_name = '".$upload_file."'
                ";
                
            }
            if ($operador > 0) {
                $result = $connection->Execute ($sql);
                $error = $connection->ErrorMsg();
                if ($error) {
                    $msg_notice= "<font color=white>".$error."</font>";
                    unlink($ruta2.$upload_file);
                }
            }
            $_POST['adm_cod_sr_file_desc']="";
        } else {

            $msg_notice= "<font color=white align=\"center\" >".$arr_label['notice5']."</font>".$_FILES['adm_con_sr_file_name']['error'];
        }
    }
    $_POST['sr_file_desc']="";
    
    break;


case 4: //edit
    $sql= "SELECT * FROM adm_control_".$d_tipo."1_docs WHERE adm_cod_sr_id='".$_POST['adm_cod_sr_id']."' AND adm_cod_tpt_id='AO' AND adm_cod_ttc_id='DR'";
    // echo $sql;
    $result=$connection->Execute($sql);
    if (!$result->EOF){
        $_POST['adm_cod_sr_file_desc'] = $result->fields['adm_cod_file_desc'];
        $_POST['adm_cod_sr_file'] = $result->fields['adm_cod_file_name'];  
        $_POST['adm_cod_sr_file_name2'] = $result->fields['adm_cod_file_name'];
        $_POST['adm_cod_sr_file_loca2'] = $result->fields['adm_cod_file_loca'];
    }
    break;

case 2: //delete
    $sql="DELETE FROM adm_control_".$d_tipo."1_docs WHERE adm_cod_sr_id='".$_POST['adm_cod_sr_id']."'";
    $result=$connection->Execute($sql);    

    unlink($ruta2.$_POST['sr_file_desc']);

    $_POST['adm_cod_sr_file_desc'] = "";
    $_POST['adm_cod_sr_file'] ="";
    $_POST['adm_cod_sr_file_name2'] ="";
    $_POST['adm_cod_sr_file_loca2'] ="";
    $msg_notice= "<font color=white> ARCHIVO BORRADO CON EXITO !!! </font>";
    break;
} 


?>

<link rel="stylesheet" href="../images/style.css" type="text/css" media="screen">

<script type="text/javascript">

function asigna_nombre(valor){
    document.getElementById('adm_cod_sr_file_desc').value = valor;
    return
}

function checkform_standar(action,form,id) {
    var errorCount = 0;
    var campo;

    title = '<?=$arr_label['notice']?>';
    switch (action){
        case 1: // insert update
            if( form.adm_cod_sr_file_desc.value == ''){errorCount++;if (errorCount == 1) {etiqueta = '<?php echo $arr_label['adm_cod_sr_file_desc']?>';campo = 'adm_cod_sr_file_desc';}}
            if( form.adm_con_sr_file_name.value == ''){errorCount++;if (errorCount == 1) {etiqueta = '<?php echo $arr_label['adm_con_sr_file_name']?>';campo = 'adm_con_sr_file_name';}}
            if( form.tpf.value == '00'){errorCount++;if (errorCount == 1) {etiqueta = 'NO HA SELECCIONADO EL TIPO DE DOCUMENTO';campo = 'adm_con_sr_file_name';}}
            if (errorCount == 0) {
                document.getElementById('action').value = 1;

                msg = '<?=$arr_label['notice1'] ?>';                
                $('#dialog-confirmar').dialog('option', 'title', '<?php echo $arr_label['notice']?>');
            
                //botones
                var buttons = $('#dialog-confirmar').dialog('option', 'buttons');
                $('#dialog-confirmar').dialog('option', 'buttons', { 
                    "<?php echo $arr_label['no']?>": function() { $(this).dialog('close');

                    },
                    "<?php echo $arr_label['si']?>": function() { $(this).dialog('close');

                        var waitmsg='<br><br><?=$arr_label['procesing'] ?>';
                        var title = $('#dialog-msg').dialog('option', '<?php echo $arr_label['notice']?>');
                        $('#dialog-msg').dialog('option', 'title', '<?php echo $arr_label['notice']?>');
                        $('#dialog-msg').html(waitmsg);
                        $('#dialog-msg').dialog('open');
                        form.submit();                        
                    } 
                });
                $('#dialog-confirmar').dialog('open');
                document.getElementById('dialog-confirmar-conteiner').innerHTML = "<div class=\"dialog_center\">"+msg+"</div>";
            }
            break;

        case 2: //delete
            if (document.getElementById('adm_cod_sr_id').value == ''){
                msg = '<?=$arr_label['notice3'] ?>';
                call_dialog_msg(msg);
                return false;
            }
            document.getElementById('action').value = 2;

                msg = '<?=$arr_label['notice2'] ?>';
                alert(msg);
                var title = $('#dialog-confirmar').dialog('option', title);
                $('#dialog-confirmar').dialog('option', 'title', '<?php echo $arr_label['notice']?>');
            
                //botones
                var buttons = $('#dialog-confirmar').dialog('option', 'buttons');
                $('#dialog-confirmar').dialog('option', 'buttons', { 
                    "<?php echo $arr_label['no']?>": function() { $(this).dialog('close');

                    },
                    "<?php echo $arr_label['si']?>": function() { $(this).dialog('close');

                        var waitmsg='<br><br><?=$arr_label['procesing'] ?>';
                        var title = $('#dialog-msg').dialog('option', 'title');
                        $('#dialog-msg').dialog('option', 'title', '<?php echo $arr_label['notice']?>');
                        $('#dialog-msg').html(waitmsg);
                        $('#dialog-msg').dialog('open');
                        form.submit();                        
                    } 
                });
                $('#dialog-confirmar').dialog('open');
                document.getElementById('dialog-confirmar-conteiner').innerHTML = "<div class=\"dialog_center\">"+msg+"</div>";
            
            break;

        case 4: //edit 
            document.getElementById('adm_cod_sr_id').value = id;
            document.getElementById('action').value = 4;
                form.submit()
            break;
    }

    if (errorCount) {
        call_dialog_msg(etiqueta);
        return false;
    }  


    return false;
}

</script>


<table border="0" align=center style="margin-top:20px" class="marco_table ui-corner-all" width="75%" >
<tr>
    <td>

        <form name='form_standar' id='form_standar' action="<?=$_SERVER['PHP_SELF']?>" method="post" enctype="multipart/form-data">

        <table border="0" align=center class="marco_table ui-corner-all" width="100%">

            <h3 align="center" style="color:yellow;"><?php echo $arr_label['doc_title1'];?></h3>

            <td class=form_standar_cap ><?=$arr_label['adm_cod_sr_file_desc']?></td> 
            <td>
	            <textarea  id="adm_cod_sr_file_desc" name="adm_cod_sr_file_desc" rows=1 cols=60><?php echo $_POST['adm_cod_sr_file_desc']?></textarea>
	        <td>
				<input type=text  class="text-view" name="sr_file_desc" id="sr_file_desc" accept="application/pdf" value="<?=$_POST['adm_cod_sr_file']?>" size=50> 
			</td>

            </td>
        </table>
    </td>
</tr>
<tr>
        <td width="10%">
            <select class="text-input" id="tpf" name="tpf">

            <option value="00">Seleccione</option>              

            <?php                    
            $sqla="SELECT * FROM ctg_tipo_formatos WHERE ctg_tpr_id ='{$d_tpr}' ORDER BY ctg_fmt_id "; 
            $resulta = $connection->Execute ($sqla);
            while (!$resulta->EOF) {
                $id_fmt=$resulta->fields['ctg_fmt_id'];
                $de_fmt=$resulta->fields['ctg_fmt_desc'];
                ?>
                <option onclick="return asigna_nombre('<?php echo $de_fmt?>')" value="<?php echo $id_fmt?>"><?php echo  $id_fmt." ".$de_fmt?></option>              
                <?php
                $resulta->MoveNext();
            }?>
            
            </select>
        </td>
</tr>
    <td>    
        <table border="0" align=center class="marco_table ui-corner-all" width="100%">
            <td valign=top align=left>
                <input type="file" class="examinar" id="adm_con_sr_file_name" Accept="application/pdf" size=55 name="adm_con_sr_file_name">
            </td>  
            <td valign=top align=right width="120px;">
                <button class="button" onclick="return checkform_standar(1,this.form,0)"><?php echo $arr_label['cargar']?></button>
            </td>
            <td valign=top align=right width="120px;">
                <button class="button" onclick="return checkform_standar(2,this.form,0)"><?php echo $arr_label['descargar']?></button>
            </td>
        </table>

        <input type=hidden name=opcion id=opcion value="<?=$_POST['opcion']?>">
        <input type=hidden name=id id=id value="<?=$_POST['id']?>">
        <input type=hidden name=nivel id=nivel value="<?=$_POST['nivel']?>">
        <input type=hidden name=adm_cod_sr_id id=adm_cod_sr_id value="<?=$_POST['adm_cod_sr_id']?>">
        <input type=hidden name=action id=action value="">
        <input type=hidden name=adm_cod_sr_file_name2 id=adm_cod_sr_file_name2 value="<?=$adm_cod_file_name?>">
        <input type=hidden name=adm_cod_sr_file_loca2 id=adm_cod_sr_file_loca2 value="<?=$adm_cod_file_loca?>">

        </form>
    	

    </td>
  </tr> 
          <tr><td  align=center width=100% ><?php echo $msg_notice?></td></tr>

  <tr>
    <td>
        <div style="width:99%; height:400px; overflow-y:scroll;">

        <table width="98%" align="center" class="light_grid ui-corner-top">
        <thead>
            <td width="5%" align=center></td>
            <td class=form_standar_cap width=50% ><?php echo $arr_label['adm_cod_sr_file_desc']?></td>
            <td class=form_standar_cap width=10% ><?php echo $arr_label['adm_con_sr_date']?></td>
            <td class=form_standar_cap width=30% ><?php echo $arr_label['nar_tecnico']?></td>
            <td class=form_standar_cap width=10% ><?php echo $arr_label['preview']?></td>
        </thead>
        <tbody>
<?php
    $sql="SELECT * FROM adm_control_".$d_tipo."1_docs WHERE 
    adm_cod_numsol = '".$d_codigo."'  AND 
    adm_cod_tpr_id = '".$d_tpr."'  AND 
    adm_cod_tpt_id = 'AO'  AND 
    adm_cod_ttc_id = 'DR' ORDER BY adm_cod_tmf_id ";
    // echo $sql;
    $result=$connection->Execute($sql);
    $c = 0;
    if ( !$result->EOF){
        while (!$result->EOF){
            $operador = $result->fields;    

            if ($ip_ext==$ip_int){
                $url = $ip_ext.$location_adm."/".$ruta3.$operador['adm_cod_file_name'];
                $onclick = " href='https://".$url."' target='_blank' ";
            } else {
                $url = $ip_ext.$location_adm."/".str_replace("/var/www/html/siverc/adm/","",$ruta2).$operador['adm_cod_file_name'];
                $onclick = " href='https://".$url."' target='_blank' ";
            }
            $img = "<a $onclick><img src='../includes/images/acroread.png' width='30' height='30' border=0></a>";
            $nom_evaluator="";
            $sqlusr="SELECT adm_usr_nombre FROM adm_usuarios WHERE adm_usr_ci ='".$operador['adm_cod_tec_id']."'";
            $resulusr=$connection->Execute($sqlusr);
		    if ( !$resulusr->EOF){
		    	$nom_evaluator=$resulusr->fields[0];
        	}
            $datetime=substr($operador['adm_cod_date'],8,2).substr($operador['adm_cod_date'],4,4).substr($operador['adm_cod_date'],0,4)." ".substr($operador['adm_cod_date'],10,9);

    		if ($operador['adm_cod_tec_id']==$_SESSION['ADMusuario_id']) {
		            echo "<tr>";
		            echo "<td align=center>
		                <input onclick='if (this.checked) checkform_standar(4,document.getElementById(\"form_standar\"),".$operador['adm_cod_sr_id'].");' type=checkbox name=\"numre\" id=\"numre\" value=\"".$c."\">
		                </td>";
		            echo "<td>".$operador['adm_cod_file_desc']."</td>";
		            echo "<td>".$datetime."</td>";
		            echo "<td>".$nom_evaluator."</td>";
		            echo "<td align=center>".$img."</td>";
		            echo "</tr>";}
            else {

                    echo "<tr>";
                    echo "<td align=center>                 
                        </td>";
                    echo "<td>".$operador['adm_cod_file_desc']."</td>";
                    echo "<td>".$operador['adm_cod_date']."</td>";
                    echo "<td>".$nom_evaluator."</td>";
                    echo "<td align=center>".$img."</td>";
                    echo "</tr>";
            }
           $c++;
            $result->MoveNext();
        }
    }
?>
        </tbody>    

        </table>
        </div>
    </td>
  </tr>

</table>