report_traspasonotasexam/accion.php

55 lines
1.5 KiB
PHP

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