public function agregarM1()
{
// $this->pdf($nomb);
$time = time();
$fecha = date("Y-m-d", $time);
$bd = bd::getInstance();
/*$sql = $bd->ejecutar("INSERT INTO correos_alumno
VALUES('',
'{$this->id_destino}',
'{$this->id_modulo}',
'$fecha',
'{$this->mensaje}',
'0','1')");*/
$bd->ejecutar("INSERT INTO correos (id_Tipo,id_ModuloE,id_Envia,id_Destino,id_ModuloD,id_Recibe,fecha_Envio,Contenido,Estatus) \n\t\t\t\tVALUES({$tipo},{$moduloE},{$envia},{$destino},{$moduloD},{$recibe},current_date(),'{$contenido}',{$estatus})");
if ($sql) {
echo " <script type='text/javascript'>\n\t\t alert('Enviado Correctamente');\n\t\t window.location='../vistas/modulo2/paneladmi.php';\n\t\t </script> ";
} else {
echo " <script type='text/javascript'>\n\t\t alert('Error al Enviar');\n\t\t window.location='../vistas/modulo2/paneladmi.php';\n\t\t </script> ";
}
}
<?php
require '../../config/bd/connect.php';
require '../../config/bd/bd.php';
$bd = bd::getInstance();
$mod = $_GET["id_Modulo"];
$proy = $_GET["proy"];
$alum = $_GET["id_Alumno"];
$sql = "SELECT id_Modulo FROM avancemodulo WHERE id_Alumno ={$_GET['id_Alumno']} and id_Proyecto ={$_GET['proy']} and id_Modulo={$_GET['id_Modulo']}";
$activar = "insert into avancemodulo values({$_GET['id_Modulo']},{$_GET['id_Alumno']},{$_GET['proy']})";
$desactivar = "delete FROM avancemodulo WHERE id_Alumno ={$_GET['id_Alumno']} and id_Proyecto ={$_GET['proy']} and id_Modulo={$_GET['id_Modulo']}";
// echo $sql;
$stmt = $bd->ejecutar($sql);
$i = 0;
while ($resp = mysql_fetch_array($stmt)) {
$i = 1;
break;
}
if ($i == 0) {
$bd->ejecutar($activar);
//echo $activar;
} else {
$bd->ejecutar($desactivar);
//echo $desactivar;
}
$sql = "SELECT id_Modulo FROM avancemodulo WHERE id_Alumno ={$_GET['id_Alumno']} and id_Proyecto ={$_GET['proy']} order by id_Modulo asc";
// echo $sql;
$stmt = $bd->ejecutar($sql);
$modulos = "";
while ($row = mysql_fetch_array($stmt)) {
$modulos .= $row["id_Modulo"] . ",";
public function insertar()
{
$id_modulo = $_SESSION['modulo'];
if ($this->asesor == "1") {
$sql = "INSERT INTO alumno\n VALUES ('','{$this->carrera}',\n '{$this->plan}',\n '{$this->depart}',\n '1',\n '{$this->nombre}',\n '{$this->apellido}',\n '{$this->matricula}',\n '{$this->semestre}',\n '{$this->correo}',\n '{$this->pass}',\n '{$this->celular}',\n '{$this->genero}')";
mysql_query($sql);
$sql2 = $bd->ejecutar("INSERT INTO avancemodulo\n VALUES ({$id_modulo},'','0')");
} else {
$sql = "INSERT INTO alumno\n VALUES ('','{$this->carrera}',\n '{$this->plan}',\n '0',\n '{$this->nombre}',\n '{$this->apellido}',\n '{$this->matricula}',\n '{$this->semestre}',\n '{$this->correo}',\n '{$this->pass}',\n '{$this->celular}',\n '{$this->genero}')";
mysql_query($sql);
}
//Funcion que me sirve para obtener el ultimo id que se registro en la tabla alumno
$id = mysql_insert_id();
$bd = bd::getInstance();
$sql2 = $bd->ejecutar("INSERT INTO avancemodulo\n VALUES ({$id_modulo},{$id},'0')");
// mysql_query($sql);
// echo $sql;
// echo mysql_error();
// exit();
$this->insertar2($id);
if ($sql) {
echo " <script type='text/javascript'>\n alert('El registro ha sido guardado correctamente');\n window.location='../vistas/modulo1/sesion.php';\n </script> ";
} else {
echo " <script type='text/javascript'>\n alert('Error al Guardar los datos');\n window.location='../vistas/modulo1/registroAlumno.php';\n </script> ";
}
}
public function mensaje()
{
$id = $_SESSION['id'];
$time = time();
$fecha = date("Y-m-d", $time);
$bd = bd::getInstance();
$sql3 = $bd->ejecutar("INSERT INTO correos_alumno\n \t\t\t\t\t\t\t VALUES ('',{$id},'{$this->modulo}',\n \t\t\t\t\t\t\t \t\t\t'{$fecha}',\n \t\t\t\t\t\t\t \t '{$this->mensaje}',\n \t\t\t\t\t\t\t \t '0',\n \t\t\t\t\t\t\t \t '0')");
//0 para alumno, 1 para administrador
if ($sql3) {
echo " <script type='text/javascript'>\n\t\t\t\t\talert('Mensaje Enviado Correctamente');\n\t\t\t\t\twindow.location='../vistas/modulo1/panelalumno.php';\n\t\t\t\t\t</script> ";
///pendiente de revisar que se corriga este error
} else {
echo " <script type='text/javascript'>\n\t\t\t\t\talert('Mensaje no Enviado');\n\t\t\t\t\twindow.location='../vistas/modulo1/panelalumno.php';\n\t\t\t\t\t</script> ";
}
}
public function loginAsesor()
{
$bd = bd::getInstance();
$consulta = $bd->ejecutar("SELECT * FROM asesor\n\t\t\t\t WHERE correo='{$this->user}' AND password='******';");
$dato = $bd->recorrer($consulta);
$sql = $bd->ejecutar("SELECT * FROM priveligos\n\t\t\t\t WHERE id_Privilegio='{$dato['id_Privilegio']}';");
$pri = $bd->recorrer($sql);
if (strtolower($dato['correo']) == strtolower($this->user) and $dato['password'] == $this->pass) {
session_start();
$_SESSION['nameasesor'] = $dato['nombreA'];
$_SESSION['privi'] = $dato['id_Privilegio'];
$_SESSION['id_A'] = $dato['id_Asesor'];
$_SESSION['pri'] = $pri['nombre'];
$_SESSION["autentificado"] = "SI";
header('location: accesoasesor.php');
} else {
header('location:../vistas/asesor/sesion.php');
// header('location: ../vistas/modulo1/paneladmi.php');
}
}
