<?php
require('../../config.php');
require_once($CFG->dirroot.'/lib/tablelib.php');
require_once(dirname(__FILE__) . '/lib.php');


global $DB, $USER;

$v_funcion      = isset($_REQUEST["funcion"]) ? $_REQUEST["funcion"] : "SIN_REGISTRO";	
$v_idtraspaso = isset($_POST['idtraspaso']) ? $_POST['idtraspaso'] : 0;	
$v_idcurso = isset($_POST['curso']) ? $_POST['curso'] : 0;	

switch($v_funcion){

case "traspasar_notas":
     
	 
	 $enrol = enrol_get_plugin('dbinacap');
	 $authdb 	= $enrol->db_init_inacap();

     $sql_traspsoSIGA =" begin TRASPASO_NOTAS_SIGA.INSERTA_NOTAEXAM_SIGA(".$v_idtraspaso.",'".$USER->idnumber."' ); end;"; 
	 
	 $rs = $authdb->Execute(  $sql_traspsoSIGA );
		 if( !$rs  ){
			echo "Error al Insertar Notas Examen a SIGA";
		}else{	 
		    echo "Traspaso realizado...."; 
			// add_to_log($v_idcurso, "traspasoexa_SIGA", "traspasoexa", "trapasa a siga idtraspaso(".$v_idtraspaso.") ", $USER->id, 0, $USER->id);		
			
		}
		$authdb->Close();
	 	 exit;
break;

case "eliminar_notas":  
    
	$enrol = enrol_get_plugin('dbinacap');
	$authdb 	= $enrol->db_init_inacap();
    
	$sql_elimina =" begin TRASPASO_NOTAS.elimina_traspasoexa(".$v_idtraspaso."); end; ";
	
    $Elirs = $authdb->Execute(  $sql_elimina );	
	 if(!$Elirs){
	   echo 'Error al Eliminar...';
	 }else{	 
		// add_to_log($v_idcurso, "traspasoexa_SIGA", "Elimina Traspaso Exa", "Elimina Traspaso Exa(".$v_idtraspaso.") ", $USER->id, 0, $USER->id);
		echo 'Eliminación Realizada....';
	}
     $authdb->Close();		
	 exit;
break;
}


?>