API tools faq
paste
Advertisement
Guest User

codigovalorar.phpp

a guest
Jun 18th, 2018
556
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.36 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. session_start();
  3. include_once "../php_conexion.php";
  4. include_once "class/class.php";
  5. include_once "../funciones.php";
  6. include_once "../class_buscar.php";
  7.  
  8. if(!empty($_GET['cod'])){
  9. $id_alumno=$_GET['cod'];
  10. $oAlumno=new Consultar_Alumno($id_alumno);
  11. $nombre_alumno=$oAlumno->consultar('nombre');
  12. }else{
  13. header('Location:error.php');
  14. }
  15. function contar_nota($materia,$periodo,$alumno){
  16. $pa=mysql_query("SELECT COUNT(nombre)as numero FROM actividad WHERE estado='s'");
  17. if($row=mysql_fetch_array($pa)){
  18. $act=$row['numero'];
  19. }
  20.  
  21. $pa=mysql_query("SELECT COUNT(alumno)as numero FROM notas WHERE alumno='$alumno' and materia='$materia' and periodo='$periodo'");
  22. if($row=mysql_fetch_array($pa)){
  23. return $row['numero'].' / '.$act;
  24. }
  25. }
  26. function promedio($materia,$periodo,$alumno){
  27. $promedio=0;
  28. $pa=mysql_query("SELECT COUNT(nombre)as numero FROM actividad WHERE estado='s'");
  29. if($row=mysql_fetch_array($pa)){
  30. $act=$row['numero'];
  31. }
  32. $pa=mysql_query("SELECT * FROM notas WHERE alumno='$alumno' and materia='$materia' and periodo='$periodo'");
  33. while($row=mysql_fetch_array($pa)){
  34. $promedio=$promedio+$row['valor'];
  35. }
  36. return $promedio/$act;
  37. }
  38. ?>
  39. <!DOCTYPE html>
  40. <html lang="es">
  41. <head>
  42. <meta charset="utf-8">
  43. <title>.: <?php echo $nombre_alumno; ?> :.</title>
  44. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  45. <meta name="description" content="">
  46. <meta name="author" content="">
  47.  
  48. <!-- Le styles -->
  49. <link href="../../css/bootstrap.css" rel="stylesheet">
  50. <style type="text/css">
  51. body {
  52. padding-top: 90px;
  53. padding-bottom: 40px;
  54. }
  55. </style>
  56. <link href="../../css/bootstrap-responsive.css" rel="stylesheet">
  57. <link rel="apple-touch-icon-precomposed" sizes="144x144" href="../../ico/apple-touch-icon-144-precomposed.png">
  58. <link rel="apple-touch-icon-precomposed" sizes="114x114" href="../../ico/apple-touch-icon-114-precomposed.png">
  59. <link rel="apple-touch-icon-precomposed" sizes="72x72" href="../../ico/apple-touch-icon-72-precomposed.png">
  60. <link rel="apple-touch-icon-precomposed" href="../../ico/apple-touch-icon-57-precomposed.png">
  61. <link rel="shortcut icon" href="../../ico/favicon.png">
  62. </head>
  63. <!-- FACEBOOK COMENTARIOS -->
  64. <div id="fb-root"></div>
  65. <script>(function(d, s, id) {
  66. var js, fjs = d.getElementsByTagName(s)[0];
  67. if (d.getElementById(id)) return;
  68. js = d.createElement(s); js.id = id;
  69. js.src = "//connect.facebook.net/es_LA/all.js#xfbml=1";
  70. fjs.parentNode.insertBefore(js, fjs);
  71. }(document, 'script', 'facebook-jssdk'));</script>
  72. <!-- FIN CODIGO FACEBOOK -->
  73. <body>
  74.  
  75. <?php include_once "../../menu/m_valorar.php"; ?>
  76. <div align="center">
  77. <table width="90%">
  78. <tr>
  79. <td>
  80. <?php
  81. if(!empty($_POST['nota'])){
  82. $materia=limpiar($_POST['materia']);
  83. $nota=limpiar($_POST['nota']);
  84. $periodo=limpiar($_POST['periodo']);
  85. $actividad=limpiar($_POST['actividad']);
  86. $fecha=date('Y-m-d');
  87.  
  88. $oActividad=new Consultar_Actividad($actividad);
  89. $oMateria=new Consultar_Materias($materia);
  90. $nactividad=$oActividad->consultar('nombre');
  91. $nmateria=$oMateria->consultar('nombre');
  92. if(empty($_POST['id'])){
  93.  
  94. $pa=mysql_query("SELECT * FROM notas
  95. WHERE alumno='$id_alumno' and materia='$materia' and periodo='$periodo' and actividad='$actividad'");
  96. if($row=mysql_fetch_array($pa)){
  97. echo mensajes('Este estudiante ya fue evaluado para la materia "'.$nmateria.'" en el examen "'.$nactividad.'"','rojo');
  98. }else{
  99. $oGuardar=new Proceso_Calificar('',$materia,$id_alumno,$actividad,$nota,$periodo,$fecha);
  100. $oGuardar->guardar();
  101. echo mensajes('Nota Registrada con Exito al Alumno "'.$nombre_alumno.'"<br>
  102. "'.$nmateria.'" Calificacion '.$nota.' En "'.$nactividad.'"','verde');
  103. }
  104. }
  105. }
  106. ?>
  107. <table class="table table-bordered">
  108. <tr class="info">
  109. <td><h2><img src="img/alumno.png" width="80" height="80"> <?php echo $id_alumno.' | '.$nombre_alumno; ?></h2></td>
  110. </tr>
  111. </table>
  112. <div class="row-fluid">
  113. <div class="span4">
  114. </div>
  115. <div class="span4" align="center">
  116. <strong>CONSULTADO</strong><br>
  117. <strong>TODOS LOS PERIODOS</strong>
  118. </div>
  119. <div class="span4" align="right">
  120. <a href="#nueva" role="button" class="btn btn-primary" data-toggle="modal">
  121. <strong><i class="fa fa-navicon" style="font-size:20px;color:white"></i> INGRESAR NUEVA CALIFICACIÓN</strong>
  122. </a>
  123. </div>
  124. </div>
  125. <br>
  126.  
  127. </td>
  128. </tr>
  129. </table>
  130. </div>
  131.  
  132.  
  133.  
  134.  
  135.  
  136.  
  137.  
  138.  
  139.  
  140.  
  141.  
  142.  
  143. <div id="nueva" class="modal hide fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
  144. <form name="form1" method="post" action="">
  145. <div class="modal-header">
  146. <button type="btn" class="close" data-dismiss="modal" aria-hidden="true">X</button>
  147. <h3 id="myModalLabel" align="center">INGRESAR NUEVA CALIFICACIÓN<br>"<?php echo $nombre_alumno; ?>"</h3>
  148. </div>
  149. <div class="modal-body">
  150. <div class="row-fluid">
  151. <div class="span6">
  152. <strong>EVALUACIÓN</strong><br>
  153. <select name="actividad">
  154. <?php
  155. $pa=mysql_query("SELECT * FROM actividad WHERE estado='s'");
  156. while($row=mysql_fetch_array($pa)){
  157. echo '<option value="'.$row['id'].'">'.$row['nombre'].'</option>';
  158. }
  159. ?>
  160. </select><br>
  161. <strong>PERIODO</strong><br>
  162. <select name="periodo">
  163. <?php
  164. $pa=mysql_query("SELECT * FROM periodo WHERE estado='s'");
  165. while($row=mysql_fetch_array($pa)){
  166. echo '<option value="'.$row['id'].'">'.$row['nombre'].'</option>';
  167. }
  168. ?>
  169. </select>
  170. </div>
  171. <div class="span6">
  172. <strong>MATERIA</strong><br>
  173. <select name="materia">
  174. <?php
  175. $pa=mysql_query("SELECT * FROM materia WHERE estado='s'");
  176. while($row=mysql_fetch_array($pa)){
  177. echo '<option value="'.$row['id'].'">'.$row['nombre'].'</option>';
  178. }
  179. ?>
  180. </select><br>
  181. <strong>CALIFICACIÓN</strong><br>
  182. <input type="number" min="<?php echo $minima_nota; ?>" max="<?php echo $maxima_nota; ?>" value="1" name="nota" autocomplete="off" required>
  183. </div>
  184. </div>
  185. </div>
  186. <div class="modal-footer">
  187. <button class="btn btn-danger" data-dismiss="modal" aria-hidden="true"><i class="fa fa-close" style="font-size:17px;"></i> <strong>CERRAR</strong></button>
  188. <button type="submit" class="btn btn-success"><i class="fa fa-cloud-upload" style="font-size:20px;color:blue"></i> <strong>SUBIR NOTA</strong></button>
  189. </div>
  190. </form>
  191. </div>
  192.  
  193.  
  194. <!-- Le javascript ../../js/jquery.js
  195. ================================================== -->
  196. <!-- Placed at the end of the document so the pages load faster -->
  197. <script src="../../js/jquery.js"></script>
  198. <script src="../../js/bootstrap-transition.js"></script>
  199. <script src="../../js/bootstrap-alert.js"></script>
  200. <script src="../../js/bootstrap-modal.js"></script>
  201. <script src="../../js/bootstrap-dropdown.js"></script>
  202. <script src="../../js/bootstrap-scrollspy.js"></script>
  203. <script src="../../js/bootstrap-tab.js"></script>
  204. <script src="../../js/bootstrap-tooltip.js"></script>
  205. <script src="../../js/bootstrap-popover.js"></script>
  206. <script src="../../js/bootstrap-button.js"></script>
  207. <script src="../../js/bootstrap-collapse.js"></script>
  208. <script src="../../js/bootstrap-carousel.js"></script>
  209. <script src="../../js/bootstrap-typeahead.js"></script>
  210. <script src="https://code.jquery.com/jquery-3.2.1.min.js"></script>
  211. <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
  212. <script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-confirmation/1.0.5/bootstrap-confirmation.min.js"></script>
  213.  
  214.  
  215.  
  216.  
  217.  
  218.  
  219. <div>
  220. <table class="table table-bordered table table-hover">
  221. <tr class="info">
  222. <td width="45%"><center><p align="left"><strong>MATERIA</strong></center></p></td>
  223. <td width="5%"><center><strong>PRIMER PERIODO</strong></center></td>
  224. <td width="5%"><center><strong>SEGUNDO PERIODO</strong></center></td>
  225. <td width="5%"><center><strong>TERCER PERIODO</strong></center></td>
  226. <td width="15%"><center><strong>PROMEDIO</strong></center></td>
  227. <td width="0%"><center><strong>NOTA FINAL</strong></center></td>
  228. <!-- <td width="6%">&nbsp;</td>-->
  229. </tr>
  230.  
  231.  
  232.  
  233. <?php
  234. if(!empty($_GET['periodo'])){
  235. $id_periodo=limpiar($_GET['periodo']);
  236. //$pa=mysql_query("SELECT * FROM notas WHERE alumno='$id_alumno' and periodo='$id_periodo' group by alumno, materia");
  237. $cont = 0;
  238. $pa=mysql_query("SELECT * FROM notas WHERE alumno='$id_alumno' group by alumno, periodo, materia");
  239. }else{
  240. $cont = 0;
  241. $pa=mysql_query("SELECT * FROM notas WHERE alumno='$id_alumno' group by alumno, periodo, materia");
  242. }
  243. while($row=mysql_fetch_array($pa)){
  244. $oMateria=new Consultar_Materias($row['materia']);
  245. $oPeriodo=new Consultar_Periodo($row['periodo']);
  246. ?>
  247. <td><center><p align="left">
  248. <?php
  249. echo $oMateria->consultar('nombre');
  250. ?>
  251. </center>
  252. </p>
  253. </td>
  254. <td><center><a href="#m<?php echo $row['periodo'].$row['materia']; ?>" title="Detalle de Calificaciones" data-toggle="modal"><?php
  255. echo formato(promedio($row['materia'],$row['periodo'],$row['alumno']));?>
  256. </center>
  257. </td>
  258. <!--<td><center><?php echo $oPeriodo->consultar('nombre'); ?></center></td>-->
  259. <!-- <td><center><?php echo contar_nota($row['materia'],$row['periodo'],$row['alumno']); ?></center></td>-->
  260. <td>
  261. <center>
  262. </center>
  263. <div id="m<?php echo $row['periodo'].$row['materia']; ?>" class="modal hide fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true" >
  264. <div class="modal-header">
  265. <button type="btn" class="close" data-dismiss="modal" aria-hidden="true"><i class="fa fa-window-close" style="font-size:30px;color:white"></i></button>
  266. <h3 style="background-color:#424A5D;" id="myModalLabel" align="center">
  267. <span style="font-size:18px;color:#FFFFFF">NOTAS PARCIALES </span>
  268. <span style="font-size:18px;color:#FFFFFF"><?php echo $oPeriodo->consultar('nombre');?></span>
  269. <span style="font-size:18px;color:#FFFFFF">PERIODO</span>
  270. <BR>
  271. <span style="font-size:18px;color:#FFFFFF"><?php echo $oMateria->consultar('nombre');?></span>
  272. </h3>
  273. </div>
  274.  
  275. <div class="modal-body">
  276. <table class="table table-bordered table table-hover">
  277. <tr class="well">
  278.  
  279. <td><strong><center>Eva. 01</center></strong></td>
  280. <td><strong><center>Eva. 02</center></strong></td>
  281. <td><strong><center>Eva. 03</center></strong></td>
  282. <td><strong><center>Eva. 04</center></strong></td>
  283. <td><strong><center>Eva. 05</center></strong></td>
  284. <td><strong><center>Parcial</center></strong></td>
  285. <td><strong><center>Asistencia</center></strong></td>
  286. </tr>
  287. <?php
  288. $paa=mysql_query("SELECT * FROM notas
  289. WHERE alumno='".$row['alumno']."' and periodo='".$row['periodo']."' and materia='".$row['materia']."'");
  290. while($dato=mysql_fetch_array($paa)){
  291. $oAct=new Consultar_Actividad($dato['actividad']);
  292. ?>
  293.  
  294. <td><center><?php echo $dato['valor']; ?></center></td>
  295. <?php } ?>
  296.  
  297. </table>
  298. </div>
  299. <div class="modal-footer">
  300. <button class="btn btn-danger" data-dismiss="modal" aria-hidden="true"><i class="fa fa-close" style="font-size:17px;"></i> <strong>CERRAR</strong></button>
  301. </div>
  302. </div>
  303. </td>
  304. </tr>
  305. <!-- </td> -->
  306. <?php } ?>
  307. </table>
  308. </div>
  309.  
  310.  
  311. </body>
  312. </html>
  313.  
  314.  
  315. <span style="font-size:23px;color:#FFFFFF"></span>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!