{"action":"created","issue":{"url":"https://api.github.com/repos/eumati/res-node/issues/76","labels_url":"https://api.github.com/repos/eumati/res-node/issues/76/labels{/name}","comments_url":"https://api.github.com/repos/eumati/res-node/issues/76/comments","events_url":"https://api.github.com/repos/eumati/res-node/issues/76/events","html_url":"https://github.com/eumati/res-node/issues/76","id":60558415,"number":76,"title":"Validacion de baja de alumnos","user":{"login":"eumati","id":8921806,"avatar_url":"https://avatars.githubusercontent.com/u/8921806?v=3","gravatar_id":"","url":"https://api.github.com/users/eumati","html_url":"https://github.com/eumati","followers_url":"https://api.github.com/users/eumati/followers","following_url":"https://api.github.com/users/eumati/following{/other_user}","gists_url":"https://api.github.com/users/eumati/gists{/gist_id}","starred_url":"https://api.github.com/users/eumati/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/eumati/subscriptions","organizations_url":"https://api.github.com/users/eumati/orgs","repos_url":"https://api.github.com/users/eumati/repos","events_url":"https://api.github.com/users/eumati/events{/privacy}","received_events_url":"https://api.github.com/users/eumati/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"VanessaDelAngel","id":8921831,"avatar_url":"https://avatars.githubusercontent.com/u/8921831?v=3","gravatar_id":"","url":"https://api.github.com/users/VanessaDelAngel","html_url":"https://github.com/VanessaDelAngel","followers_url":"https://api.github.com/users/VanessaDelAngel/followers","following_url":"https://api.github.com/users/VanessaDelAngel/following{/other_user}","gists_url":"https://api.github.com/users/VanessaDelAngel/gists{/gist_id}","starred_url":"https://api.github.com/users/VanessaDelAngel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/VanessaDelAngel/subscriptions","organizations_url":"https://api.github.com/users/VanessaDelAngel/orgs","repos_url":"https://api.github.com/users/VanessaDelAngel/repos","events_url":"https://api.github.com/users/VanessaDelAngel/events{/privacy}","received_events_url":"https://api.github.com/users/VanessaDelAngel/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2015-03-10T19:50:45Z","updated_at":"2015-03-12T20:38:09Z","closed_at":null,"body":"- Alumnos [UPDATE] [BACKEND]\r\nDROP [motivoBaja, tipoBaja, orientacionEducativa]\r\n** Modificar los campos en la vista y tabla de alumnos, y los \"SP\" relacionados\r\n\r\n- Notificaciones [CREATE]\r\n[idNotificacion INT, idPlantel INT, idUsuario INT]\r\n\r\n- Bajas [CREATE]\r\n[idBaja INT, idPlantel INT, idUsuario INT, idAlumno INT, motivoBaja VARCHAR(1000), tipoBaja INT, orientacionEducativa INT, activo INT]\r\n * tipoBaja: 1.-Personal, 2.-Institucional\r\n\r\n- Validaciones [CREATE]\r\n[idValidacion INT, idBaja INT, idUsuario INT, status INT]\r\nstatus: 0.- no validado, 1.- validado, 2.- rechazado\r\n\r\n- Baja:\r\nAl dar de baja a un alumno, se creara un registro en la tabla de \"Bajas\" guardando los datos de la baja, y en la tabla de \"Validaciones\" se crearan registros segun el numero de usuarios registrados en la tabla de \"Notificaciones\"\r\n\r\n- Validacion de la baja:\r\nAl dar de baja a un alumno, se mandara una notificacion a los usuarios registrados en la tabla de \"Validaciones\", posteriormente si todos los usuarios validan la baja, el \"activo\" del alumno y de la notificacion pasa a ser 0, y se da por cerrado el proceso de baja, si todos los usuarios rechazan la baja, el proceso se cierra y se descarta la baja, limpiando los campos de la tabla de \"Alumnos\" [motivoBaja, tipoBaja, orientacionEducativa, tipo], mientras que no todos los usuarios validen o rechacen la notificacion, esta sigue abierta (activo = 1).\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/eumati/res-node/issues/comments/78606223","html_url":"https://github.com/eumati/res-node/issues/76#issuecomment-78606223","issue_url":"https://api.github.com/repos/eumati/res-node/issues/76","id":78606223,"user":{"login":"VanessaDelAngel","id":8921831,"avatar_url":"https://avatars.githubusercontent.com/u/8921831?v=3","gravatar_id":"","url":"https://api.github.com/users/VanessaDelAngel","html_url":"https://github.com/VanessaDelAngel","followers_url":"https://api.github.com/users/VanessaDelAngel/followers","following_url":"https://api.github.com/users/VanessaDelAngel/following{/other_user}","gists_url":"https://api.github.com/users/VanessaDelAngel/gists{/gist_id}","starred_url":"https://api.github.com/users/VanessaDelAngel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/VanessaDelAngel/subscriptions","organizations_url":"https://api.github.com/users/VanessaDelAngel/orgs","repos_url":"https://api.github.com/users/VanessaDelAngel/repos","events_url":"https://api.github.com/users/VanessaDelAngel/events{/privacy}","received_events_url":"https://api.github.com/users/VanessaDelAngel/received_events","type":"User","site_admin":false},"created_at":"2015-03-12T20:38:09Z","updated_at":"2015-03-12T20:38:09Z","body":"VDA - Notificaciones  [✓]"}}