protected function createTutor($category)
{
$t = new Tutor();
$t->setOccupationCategoryId($category->getId());
$t->save();
return $t;
}
public function createUsedOccupation($name)
{
$occ = $this->createOccupation($name);
$t = new Tutor();
$t->setOccupationId($occ->getId());
$t->save();
return $occ;
}
public static function createUser($first_name, $last_name, $email, $user_type, $majorId, $coursesIds, $termId)
{
self::validateName($first_name);
self::validateName($last_name);
self::validateNewEmail($email, self::DB_TABLE);
self::validateUserType($user_type);
//$this->validate_teaching_course($teaching_courses);
try {
$queryInsertUser = "******" . App::getDbName() . "`.`" . User::DB_TABLE . "` (`" . User::DB_COLUMN_EMAIL . "`,\n\t\t\t`" . User::DB_COLUMN_FIRST_NAME . "`, `" . User::DB_COLUMN_LAST_NAME . "`, `" . User::DB_COLUMN_USER_TYPES_ID . "`)\n\t\t\t\tVALUES(\n\t\t\t\t\t:email,\n\t\t\t\t\t:first_name,\n\t\t\t\t\t:last_name,\n\t\t\t\t\t(SELECT `" . UserTypesFetcher::DB_COLUMN_ID . "` FROM `" . UserTypesFetcher::DB_TABLE . "` WHERE `" . UserTypesFetcher::DB_COLUMN_TYPE . "`=:user_type )\n\t\t\t\t)";
$dbConnection = DatabaseManager::getConnection();
$dbConnection->beginTransaction();
$queryInsertUser = $dbConnection->prepare($queryInsertUser);
$queryInsertUser->bindParam(':email', $email, PDO::PARAM_STR);
$queryInsertUser->bindParam(':first_name', $first_name, PDO::PARAM_STR);
$queryInsertUser->bindParam(':last_name', $last_name, PDO::PARAM_STR);
$queryInsertUser->bindParam(':user_type', $user_type, PDO::PARAM_STR);
$queryInsertUser->execute();
// last inserted if of THIS connection
$userId = $dbConnection->lastInsertId();
if (strcmp($user_type, User::TUTOR) === 0) {
Major::validateId($majorId);
Tutor::insertMajor($userId, $majorId);
if ($coursesIds !== NULL) {
Tutor_has_course_has_schedule::addCourses($userId, $coursesIds, $termId);
}
}
$dbConnection->commit();
return $userId;
} catch (Exception $e) {
$dbConnection->rollback();
throw new Exception("Could not insert user into database.");
}
}
function update()
{
$disciplina = new Disciplina();
$disciplina->setNome($_POST['nome']);
//$disciplina->setTutor($tutor->getById());
$curso = new Curso();
$curso->setId($_POST['curso']);
$disciplina->setCurso($curso->getById());
$disciplina->setId($_POST['id']);
$disciplina->update();
if (isset($_POST['tutor']) && $_POST['tutor']) {
$tutor = new Tutor();
$tutor->setId($_POST['tutor']);
$tutor->addTutorDisciplina($tutor->getId(), $disciplina->getId());
}
header("location: ../view/index.php");
}
/**
* @param int $filledOutDate The date the timesheet was filled out as a int UNIX timestamp, if no value is passed in
* today's date is set as the date
* @param Tutor $tutor The tutor that is associated with this timesheet
* @param PayPeriod $payPeriod The payperiod that relates to this timesheet.
* @param array $timesWorked The hours the tutor worked for this time period
*/
public function __construct(Tutor $tutor, PayPeriod $payPeriod, array $timesWorked, $filledOutDate = null)
{
// Auto set to today's date. Can be changed manually by method call
$this->dateFilledOut = $filledOutDate == null ? date("Y-m-d", time()) : date("Y-m-d", $filledOutDate);
$this->tutorName = $tutor->getName();
$this->tutorID = $tutor->getID();
$this->tutorPhone = $tutor->getPhone();
$timesheetHours = new TimesheetHours($payPeriod, $timesWorked);
//
$this->timeWorkedInPeriod = $timesheetHours->getPayPeriodSchedule();
$this->totalHoursWorked = $timesheetHours->getTotalHoursWorked();
$this->periodStart = date("l n/j/y", $this->timeWorkedInPeriod[0]->getDate());
$this->periodEnd = date("l n/j/y", $this->timeWorkedInPeriod[count($timesWorked) - 1]->getDate());
$this->filename = "Timesheet_" . $this->tutorID . "_" . date("mdy") . "_" . date("Gis");
$this->HTML = self::setTimesheetHTML();
$this->PDFgenerator = new DOMPDF();
}
/**
* Modify a session by deleting it, creating a new session, and transferring over tutors and attenders.
*/
public function modifySession($sessionID, $date, $time, $subject, $gradeLevel)
{
$oldSession = new Session($sessionID);
$attenders = $oldSession->getSessionAttenders();
$tutors = $oldSession->getSessionTutors();
$this->cancelSession($sessionID);
$newID = $this->createSession($date, $time, $subject, $gradeLevel);
/* Add attenders to new session: */
while ($row = $attenders->fetch_assoc()) {
$attender = new Attender($row['userID'], $this->connection);
$attender->willAttend($newID);
}
/* Add tutors to new session: */
while ($row = $tutors->fetch_assoc()) {
$tutor = new Tutor($row['tutorID'], $this->connection);
$tutor->signUpToTutor($newID);
}
}
private function tutor()
{
$email = Request::getUser();
$password = Request::getPassword();
$userAuth = Input::get('userAuth', false);
if (isset($email) && isset($password) && !$userAuth) {
$tutor = Tutor::where('email', $email)->first();
return $tutor && Hash::check($password, $tutor->password) ? $tutor : null;
} else {
return false;
}
}
public function updateScript()
{
$tutors = Tutor::all();
foreach ($tutors as $tutor) {
if ($tutor->districts != null) {
$districts = explode(',', $tutor->districts);
foreach ($districts as $district) {
TutorDistrict::firstOrCreate(['tutor_id' => $tutor->id, 'district_id' => $district]);
}
}
}
return "Done";
}
function findTutor($clave_prof)
{
$result = obtenerTutor($clave_prof);
if ($result and $result->num_rows > 0) {
$temp = mysqli_fetch_array($result, MYSQLI_ASSOC);
$tutor = new Tutor();
$tutor->setClaveprof($temp["clave_prof"]);
$tutor->setApellidoP($temp["apellido_p"]);
$tutor->setApellidoM($temp["apellido_m"]);
$tutor->setGenero($temp["genero"]);
$tutor->setArea($temp["area"]);
$tutor->setCorreo($temp["email"]);
return $tutor;
} else {
echo "<br/> No hay tutor cuya clave sea: " . $clave_prof;
}
}
/**
* Displays a particular model.
* @param integer $id the ID of the model to be displayed
*/
public function actionView($id)
{
if (isset($_POST['idStudent']) && isset($_POST['idProfile'])) {
if (!empty($_POST['idStudent']) && !empty($_POST['idProfile'])) {
$model = Students::model()->find('id=' . $_POST['idStudent']);
$model->tutor_id = Tutor::model()->find('profile_id=' . $_POST['idProfile'])->id_tutor;
if ($model->save()) {
Yii::app()->user->setFlash('save', 'El Tutor se ha asignado correctamente.');
$this->redirect(array('view', 'id' => $model->id));
}
}
Yii::app()->user->setFlash('error', 'Debe seleccionar un Tutor.');
$this->redirect(array('view', 'id' => $_POST['idStudent']));
}
$this->render('view', array('model' => $this->loadModel($id)));
}
public function index($offset = 0)
{
$this->load->library('pagination');
$config['base_url'] = site_url('tutores/index');
$config['total_rows'] = Tutor::count();
$config['per_page'] = '10';
$config['num_links'] = '1';
$config['first_link'] = '← primero';
$config['last_link'] = 'último →';
$this->pagination->initialize($config);
$a = Tutor::find('all', array('limit' => $config['per_page'], 'offset' => $offset));
$this->table->set_heading('Nombre', 'Apellido', 'Telefono', 'Celular', 'Acciones');
foreach ($a as $al) {
$this->table->add_row($al->nombre, $al->apellido, $al->telefono, $al->celular, anchor('tutores/editar/' . $al->id, img('static/img/icon/notepad_2.png'), 'class="tipwe" title="Editar tutor"') . ' ' . anchor('tutores/eliminar/' . $al->id, img('static/img/icon/trash.png'), 'class="tipwe eliminar" title="Eliminar tutor"'));
}
$data['tutores'] = $this->table->generate();
$data['pagination'] = $this->pagination->create_links();
$this->template->write_view('content', 'tutores/index', $data);
$this->template->render();
}
<?php
require __DIR__ . '/../app/init.php';
$general->loggedOutProtect();
$section = "appointments";
/**
* @param $studentsAppointmentData
*
* @return bool
*/
function reportsHaveBeenCrtd($studentsAppointmentData)
{
return $studentsAppointmentData[0][AppointmentHasStudentFetcher::DB_COLUMN_REPORT_ID] !== null;
}
try {
if (!isUrlValid() || $user->isTutor() && !Tutor::hasAppointmentWithId($user->getId(), $_GET['appointmentId'])) {
header('Location: ' . BASE_URL . "error-403");
exit;
}
date_default_timezone_set('Europe/Athens');
$pageTitle = "Single Appointment";
$appointmentId = $_GET['appointmentId'];
$studentsAppointmentData = Appointment::getAllStudentsWithAppointment($appointmentId);
$terms = TermFetcher::retrieveCurrTerm();
$students = StudentFetcher::retrieveAll();
$courses = CourseFetcher::retrieveForTerm($studentsAppointmentData[0][AppointmentFetcher::DB_COLUMN_TERM_ID]);
$instructors = InstructorFetcher::retrieveAll();
$tutors = TutorFetcher::retrieveAll();
$startDateTime = new DateTime($studentsAppointmentData[0][AppointmentFetcher::DB_COLUMN_START_TIME]);
$endDateTime = new DateTime($studentsAppointmentData[0][AppointmentFetcher::DB_COLUMN_END_TIME]);
$nowDateTime = new DateTime();
<?php require_once 'classes/Tutor.php'; $tutor = new Tutor(); $email = $_POST['email']; $list = $tutor->is_email_exists($email); echo $list;
<?php
session_start();
define("CONST_FILE_PATH", "includes/constants.php");
define("CURRENT_PAGE", "members");
require 'classes/WebPage.php';
//Set up page as a web page
$thisPage = new WebPage();
//Create new instance of webPage class
$dbObj = new Database();
//Instantiate database
$thisPage->dbObj = $dbObj;
$courseObj = new Course($dbObj);
$categoryObj = new CourseCategory($dbObj);
$quoteObj = new Quote($dbObj);
$memberObj = new Tutor($dbObj);
include 'includes/other-settings.php';
require 'includes/page-properties.php';
?>
<!DOCTYPE html>
<html lang="en-US">
<head>
<?php
include 'includes/meta-tags.php';
?>
<style type="text/css">img.wp-smiley,img.emoji {display: inline !important;border: none !important;box-shadow: none !important;height: 1em !important;width: 1em !important;margin: 0 .07em !important;vertical-align: -0.1em !important;background: none !important;padding: 0 !important; }</style>
<link rel='stylesheet' id='rs-plugin-settings-css' href='<?php
echo SITE_URL;
?>
plugins/revslider/rs-plugin/css/settings1dc6.css?ver=4.6.5' type='text/css' media='all' />
<style id='rs-plugin-settings-inline-css' type='text/css'>.tp-caption a{color:#e05100;text-shadow:none; text-decoration:none;-webkit-transition:all 0.2s ease-out;-moz-transition:all 0.2s ease-out;-o-transition:all 0.2s ease-out;-ms-transition:all 0.2s ease-out}.tp-caption a:hover{color:#ffa902}</style>
<?php require_once './classes/Tutor.php'; $t = new Tutor(); $email = $_POST['email']; $url = $_POST['url']; $list = $t->test_page($email, $url); echo $list;
<?php require_once 'classes/Tutor.php'; $tutor = new Tutor(); $user = $_POST['user']; $list = $tutor->tutor_signup($user); echo $list;
<?php
session_start();
define("CONST_FILE_PATH", "../includes/constants.php");
include '../classes/WebPage.php';
//Set up page as a web page
$thisPage = new WebPage();
//Create new instance of webPage class
$dbObj = new Database();
//Instantiate database
$tutorObj = new Tutor($dbObj);
// Create an object of Tutor class
$errorArr = array();
//Array of errors
$oldPicture = "";
$newPicture = "";
$tutorPictureFil = "";
if (!isset($_SESSION['ITCLoggedInAdmin']) || !isset($_SESSION["ITCadminEmail"])) {
$json = array("status" => 0, "msg" => "You are not logged in.");
header('Content-type: application/json');
echo json_encode($json);
} else {
if (filter_input(INPUT_POST, "fetchTutors") != NULL) {
$requestData = $_REQUEST;
$columns = array(0 => 'id', 1 => 'id', 2 => 'visible', 3 => 'picture', 4 => 'name', 5 => 'qualification', 6 => 'field', 7 => 'bio', 8 => 'email', 9 => 'website');
// getting total number records without any search
$query = $dbObj->query("SELECT * FROM tutor ");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData;
// when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT * FROM tutor WHERE 1=1 ";
public static function getSingleTutorOnTerm($tutorId, $termId)
{
Tutor::validateId($tutorId);
Term::validateId($termId);
return ScheduleFetcher::retrieveSingleTutorOnTerm($tutorId, $termId);
}
public function getNombre($id)
{
if (!empty($id)) {
$tutor = Tutor::model()->findByPk($id);
return Profile::model()->nombreApellido($tutor->profile->firstname, $tutor->profile->secondname, $tutor->profile->lastname1, $tutor->profile->lastname2);
}
return TbHtml::labelTb("Sin asignar", array('color' => TbHtml::LABEL_COLOR_IMPORTANT));
}
require __DIR__ . '/../app/init.php';
$general->loggedOutProtect();
$pageTitle = "Personnel";
$section = "staff";
try {
// protect again any sql injections on url
if (isset($_GET['id']) && preg_match("/^[0-9]+\$/", $_GET['id'])) {
$userId = $_GET['id'];
$pageTitle = "Profile";
if (($data = User::getSingle($userId)) === false) {
header('Location: ' . BASE_URL . 'error-404');
exit;
}
if (strcmp($data['type'], 'tutor') === 0) {
$tutor = TutorFetcher::retrieveSingle($userId);
$curUser = new Tutor($data['id'], $data['f_name'], $data['l_name'], $data['email'], $data['mobile'], $data['img_loc'], $data['profile_description'], $data['date'], $data['type'], $data['active'], $tutor[MajorFetcher::DB_COLUMN_NAME]);
$schedules = ScheduleFetcher::retrieveCurrWorkingHours($curUser->getId());
$teachingCourses = TutorFetcher::retrieveCurrTermTeachingCourses($curUser->getId());
} else {
if (strcmp($data['type'], 'secretary') === 0) {
$curUser = new Secretary($data['id'], $data['f_name'], $data['l_name'], $data['email'], $data['mobile'], $data['img_loc'], $data['profile_description'], $data['date'], $data['type'], $data['active']);
} else {
if (strcmp($data['type'], 'admin') === 0) {
$curUser = new Admin($data['id'], $data['f_name'], $data['l_name'], $data['email'], $data['mobile'], $data['img_loc'], $data['profile_description'], $data['date'], $data['type'], $data['active']);
} else {
throw new Exception("Something terrible has happened with the database. <br/>The software developers will tremble with fear.");
}
}
}
} else {
if (isBtnInactivePrsd()) {
public static function replaceMajorId($id, $newMajorId, $oldMajorId)
{
// no changes made. no need to do any work.
if (strcmp($newMajorId, $oldMajorId) === 0) {
return false;
}
Tutor::validateId($id);
Major::validateId($newMajorId);
Major::validateId($oldMajorId);
TutorFetcher::replaceMajorId($id, $newMajorId);
return true;
}
<?php
session_start();
define("CONST_FILE_PATH", "../includes/constants.php");
include '../classes/WebPage.php';
//Set up page as a web page
$thisPage = new WebPage();
//Create new instance of webPage class
$dbObj = new Database();
//Instantiate database
$tutorObj = new Tutor($dbObj);
// Create an object of Tutor class
$errorArr = array();
//Array of errors
$tutorImgFil = "";
if (!isset($_SESSION['TSILoggedInAdmin']) || !isset($_SESSION["TSIadminEmail"])) {
$json = array("status" => 0, "msg" => "You are not logged in.");
header('Content-type: application/json');
echo json_encode($json);
} else {
if (filter_input(INPUT_POST, "addNewTutor") != NULL) {
$postVars = array('name', 'qualification', 'field', 'bio', 'email', 'website', 'picture');
// Form fields names
//Validate the POST variables and add up to error message if empty
foreach ($postVars as $postVar) {
switch ($postVar) {
case 'picture':
$tutorObj->{$postVar} = basename($_FILES["picture"]["name"]) ? rand(100000, 1000000) . "_" . strtolower(str_replace(" ", "_", filter_input(INPUT_POST, 'name'))) . "." . pathinfo(basename($_FILES["picture"]["name"]), PATHINFO_EXTENSION) : "";
$tutorImgFil = $tutorObj->{$postVar};
if ($tutorObj->{$postVar} == "") {
array_push($errorArr, "Please enter {$postVar} ");
private static function makeTutor($linha)
{
$nome = $linha['nome'];
$pessoaId = $linha['id_pessoa'];
$sobrenome = $linha['sobrenome'];
$cpf = $linha['cpf'];
$email = $linha['email'];
$formacaoId = $linha['id_formacao'];
$formacaoDescricao = $linha['d_formacao'];
$formacao = array("descricao" => $formacaoDescricao, "id" => $formacaoId);
$titulacaoId = $linha['id_titulacao'];
$titulacaoDescricao = $linha['d_titulacao'];
$titulacao = array("descricao" => $titulacaoDescricao, "id" => $titulacaoId);
$tutorId = $linha['id_tutor'];
$tutor = new Tutor();
$tutor->setCpf($cpf);
$tutor->setEmail($email);
$tutor->setFormacao($formacao);
$tutor->setId($pessoaId);
$tutor->setSobrenome($sobrenome);
$tutor->setNome($nome);
$tutor->setTitulacao($titulacao);
$tutor->setTutorId($tutorId);
$tutor->setId($pessoaId);
return $tutor;
}
public function createRelatedObject($obj)
{
$r = new Tutor();
$r->setStudyId($obj->getId());
$r->save();
}
<?php
$this->widget('yiiwheels.widgets.grid.WhGridView', array('fixedHeader' => true, 'headerOffset' => 40, 'type' => 'striped', 'dataProvider' => $dataStudents, 'responsiveTable' => true, 'template' => "{items}", 'columns' => array(array('header' => 'ID', 'value' => '$data->id'), array('header' => 'Nombre', 'type' => 'raw', 'value' => function ($data, $row) {
return Profile::model()->nombreApellido($data->profile->firstname, $data->profile->secondname, $data->profile->lastname1, $data->profile->lastname2);
}), array('header' => 'Sexo', 'value' => function ($data, $row) {
return Profile::model()->validarSexo($data->profile->sex);
}, 'type' => 'raw'), array('header' => 'Correo', 'value' => '$data->profile->email'), array('header' => 'Tutor', 'value' => function ($data, $row) {
return Tutor::model()->getNombre($data->tutor_id);
}, 'type' => 'raw'), array('header' => 'Registrado', 'value' => function ($data, $row) {
return Yii::app()->dateFormatter->formatDateTime($data->profile->user->regdate, 'medium', false);
}, 'type' => 'raw'), array('header' => 'Status', 'type' => 'raw', 'value' => function ($data, $row) {
return Profile::model()->validarStatus($data->profile->cruge_user_iduser);
}), array('header' => '', 'type' => 'raw', 'value' => function ($data, $row) {
return Profile::model()->botonStatus($data->profile->cruge_user_iduser);
}), array('name' => '', 'type' => 'raw', 'value' => function ($data, $row) {
return Tutor::model()->botonAsignar($data->tutor_id, $data->id);
}))));
$this->endWidget();
?>
<!-- End Box de Estudiantes VC -->
<!-- Box de Tutors VC -->
<?php
$this->beginWidget('yiiwheels.widgets.box.WhBox', array('title' => 'Tutores VC', 'headerIcon' => 'icon-th-list', 'headerButtons' => array(TbHtml::buttonGroup(array(array('label' => 'Gestionar Tutor', 'submit' => array('tutor/admin')))))));
?>
<?php
$this->widget('yiiwheels.widgets.grid.WhGridView', array('fixedHeader' => true, 'headerOffset' => 40, 'type' => 'striped', 'dataProvider' => $dataTutor, 'responsiveTable' => true, 'template' => "{items}", 'columns' => array(array('header' => 'ID', 'value' => '$data->id_tutor'), array('header' => 'Nombre', 'type' => 'raw', 'value' => function ($data, $row) {
return Profile::model()->nombreApellido($data->profile->firstname, $data->profile->secondname, $data->profile->lastname1, $data->profile->lastname2);
}), array('header' => 'Sexo', 'value' => function ($data, $row) {
return Profile::model()->validarSexo($data->profile->sex);
public function executeConfirmStudent(sfWebRequest $request)
{
sfContext::getInstance()->set("user", new FakeUser());
//tomo las intancias de las librerias.
$i_identification_type = BaseCustomOptionsHolder::getInstance('IdentificationType');
$i_sex_type = BaseCustomOptionsHolder::getInstance('SexType');
$i_nationality = BaseCustomOptionsHolder::getInstance('Nationality');
$s_lastname = $this->getRequestParameter('apellido');
// Es obligatorio
$s_firstname = $this->getRequestParameter('nombres');
// Es obligatorio
$s_identification_type = $i_identification_type->getIdentificationType($this->getRequestParameter('tipo_documento_id'));
$s_identification_number = $this->getRequestParameter('nro_documento');
$s_sex = $i_sex_type->getSexType($this->getRequestParameter('sexo'));
//Es obligatorio
$s_phone = $this->getRequestParameter('telefono_fijo');
$s_birthdate = $this->getRequestParameter('fecha_nacimiento');
$s_birth_city = $this->getRequestParameter('ciudad_nacimiento_id');
$s_health_coverage_id = $this->getRequestParameter('obra_social_id');
$s_origin_school_id = $request->getParameter('escuela_procedencia_numero');
//domicilio
$s_city = $this->getRequestParameter('domicilio_ciudad_id');
$s_street = $this->getRequestParameter('domicilio_calle');
$s_number = $this->getRequestParameter('domicilio_numero');
$s_floor = $this->getRequestParameter('domicilio_piso');
$s_flat = $this->getRequestParameter('domicilio_departamento');
//Chequeo tutor (madre)
$m_identification_type = $i_identification_type->getIdentificationType($this->getRequestParameter('madre_tipo_documento_id'));
$m_identification_number = $this->getRequestParameter('madre_nro_documento');
$m_firstname = $this->getRequestParameter('madre_nombres');
$m_lastname = $this->getRequestParameter('madre_apellido');
$m_occupation = $this->getRequestParameter('madre_actividad_id');
$m_occupation_category = $this->getRequestParameter('madre_ocupacion_id');
$m_study = $this->getRequestParameter('madre_estudios_id');
$m_email = $this->getRequestParameter('madre_email');
$m_phone = $this->getRequestParameter('madre_telefono_celular');
$m_birthdate = $this->getRequestParameter('madre_fecha_nacimiento');
$m_birth_city = $this->getRequestParameter('madre_ciudad_nacimiento_id');
$m_nationality = $i_nationality->getNationality($this->getRequestParameter('madre_nacionalidad_id'));
$m_is_alive = $this->getRequestParameter('madre_vive');
//chequeo is_alive
if ($m_is_alive == 'S') {
$m_is_alive = true;
} elseif ($m_is_alive == 'N') {
$m_is_alive = false;
}
//domicilio
$m_city = $this->getRequestParameter('madre_domicilio_ciudad_id');
$m_street = $this->getRequestParameter('madre_domicilio_calle');
$m_number = $this->getRequestParameter('madre_domicilio_numero');
$m_floor = $this->getRequestParameter('madre_domicilio_piso');
$m_flat = $this->getRequestParameter('madre_domicilio_departamento');
//Chequeo tutor (padre)
$p_identification_type = $i_identification_type->getIdentificationType($this->getRequestParameter('padre_tipo_documento_id'));
$p_identification_number = $this->getRequestParameter('padre_nro_documento');
$p_firstname = $this->getRequestParameter('padre_nombres');
$p_lastname = $this->getRequestParameter('padre_apellido');
$p_occupation = $this->getRequestParameter('padre_actividad_id');
$p_occupation_category = $this->getRequestParameter('padre_ocupacion_id');
$p_study = $this->getRequestParameter('padre_estudios_id');
$p_email = $this->getRequestParameter('padre_email');
$p_phone = $this->getRequestParameter('padre_telefono_celular');
$p_birthdate = $this->getRequestParameter('padre_fecha_nacimiento');
$p_birth_city = $this->getRequestParameter('padre_ciudad_nacimiento_id');
$p_nationality = $i_nationality->getNationality($this->getRequestParameter('padre_nacionalidad_id'));
$p_is_alive = $this->getRequestParameter('padre_vive');
//chequeo is_alive
if ($p_is_alive == 'S') {
$p_is_alive = true;
} elseif ($p_is_alive == 'N') {
$p_is_alive = false;
}
//domicilio
$p_city = $this->getRequestParameter('padre_domicilio_ciudad_id');
$p_street = $this->getRequestParameter('padre_domicilio_calle');
$p_number = $this->getRequestParameter('padre_domicilio_numero');
$p_floor = $this->getRequestParameter('padre_domicilio_piso');
$p_flat = $this->getRequestParameter('padre_domicilio_departamento');
$data = array();
//chequeo campos obligatorios
if (is_null($s_identification_type) || is_null($s_identification_number) || is_null($s_lastname) || trim($s_lastname) == "" || is_null($s_firstname) || trim($s_firstname) == "" || is_null($s_sex)) {
throw new Exception('Missing data');
} else {
$con = Propel::getConnection();
try {
//chequeo que el alumno no haya sido ingresado en un año anterior (por lista de espera)
$student = StudentPeer::retrieveByDocumentTypeAndNumber($s_identification_type, $s_identification_number);
$con->beginTransaction();
if (is_null($student)) {
//el alumno no existe. Creo la persona y el alumno
$s_person = new Person();
$s_person->setLastname($s_lastname);
$s_person->setFirstname($s_firstname);
$s_person->setSex($s_sex);
$s_person->setIdentificationType($s_identification_type);
$s_person->setIdentificationNumber($s_identification_number);
$s_person->setPhone($s_phone);
$s_person->setBirthdate($s_birthdate);
$s_person->setIsActive(true);
$s_person->setBirthCity($s_birth_city);
$s_person->save(Propel::getConnection());
$student = new Student();
$student->setPerson($s_person);
$student->setGlobalFileNumber('888888');
//Nro de legajo??
$student->setOriginSchoolId($s_origin_school_id);
$student->setHealthCoverageId($s_health_coverage_id);
$student->save(Propel::getConnection());
/* Recupero department, state ,country*/
if (!is_null($s_birth_city)) {
$city = CityPeer::retrieveByPk($s_birth_city);
$student->getPerson()->setBirthCountry($city->getDepartment()->getState()->getCountry()->getId());
$student->getPerson()->setBirthState($city->getDepartment()->getState()->getId());
$student->getPerson()->setBirthDepartment($city->getDepartment()->getId());
}
//chequeo domicilio
if (!is_null($s_city) || !is_null($s_street) || !is_null($s_number) || !is_null($s_floor) || is_null($s_flat)) {
$a = new Address();
$a->setCityId($s_city);
$a->setStreet($s_street);
$a->setNumber($s_number);
$a->setFloor($s_floor);
$a->setFlat($s_flat);
$student->getPerson()->setAddress($a);
$student->getPerson()->save(Propel::getConnection());
$data['message'] = "El alumno ha sido confirmado.";
}
} else {
//seteo isActive
$student->getPerson()->setIsActive(true);
$student->save(Propel::getConnection());
$data['message'] = "El alumno fue actualizado correctamente.";
}
//chequeo campos obligatorios
if (!is_null($m_identification_type) && !is_null($m_identification_number) && !is_null($m_lastname) && trim($m_lastname) != "" && !is_null($m_firstname) && trim($m_firstname) != "") {
//busco si ya existe.
$m_tutor = TutorPeer::findByDocumentTypeAndNumber($m_identification_type, $m_identification_number);
if (is_null($m_tutor)) {
//el tutor no existe. Lo creo
$m_person = new Person();
$m_person->setLastname($m_lastname);
$m_person->setFirstname($m_firstname);
$m_person->setIdentificationType($m_identification_type);
$m_person->setIdentificationNumber($m_identification_number);
$m_person->setSex(SexType::FEMALE);
$m_person->setPhone($m_phone);
$m_person->setEmail($m_email);
$m_person->setBirthdate($m_birthdate);
$m_person->setIsActive(true);
$m_person->setBirthCity($m_birth_city);
$m_person->save(Propel::getConnection());
$m_tutor = new Tutor();
$m_tutor->setPerson($m_person);
$m_tutor->setOccupationId($m_occupation);
$m_tutor->setOccupationCategoryId($m_occupation_category);
$m_tutor->setStudyId($m_study);
//coincide con la tabla sga_tipos_est_cur
$m_tutor->setNationality($m_nationality);
$m_tutor->setIsAlive($m_is_alive);
$m_tutor->save(Propel::getConnection());
/* Recupero department, state ,country*/
if (!is_null($m_birth_city)) {
$m_city = CityPeer::retrieveByPk($m_birth_city);
$m_tutor->getPerson()->setBirthCountry($m_city->getDepartment()->getState()->getCountry()->getId());
$m_tutor->getPerson()->setBirthState($m_city->getDepartment()->getState()->getId());
$m_tutor->getPerson()->setBirthDepartment($m_city->getDepartment()->getId());
}
//chequeo domicilio
if (!is_null($m_city) || !is_null($m_street) || !is_null($m_number) || !is_null($m_floor) || is_null($m_flat)) {
$a = new Address();
$a->setCityId($m_birth_city);
$a->setStreet($m_street);
$a->setNumber($m_number);
$a->setFloor($m_floor);
$a->setFlat($m_flat);
$m_tutor->getPerson()->setAddress($a);
$m_tutor->getPerson()->save(Propel::getConnection());
}
} else {
$data['info'] = "El tutor con " . $i_identification_type->getStringFor($m_identification_type) . " " . $m_identification_number;
}
$st = StudentTutorPeer::retrieveByStudentAndTutor($student, $m_tutor);
if (is_null($st)) {
//datos de tutor(madre)
$student_tutor = new StudentTutor();
$student_tutor->setStudent($student);
$student_tutor->setTutor($m_tutor);
$student_tutor->save(Propel::getConnection());
$m_tutor->addStudentTutor($student_tutor);
$m_tutor->save(Propel::getConnection());
}
}
//chequeo campos obligatorios
if (!is_null($p_identification_type) && !is_null($p_identification_number) && !is_null($p_lastname) && trim($p_lastname) != "" && !is_null($p_firstname) && trim($p_firstname) != "") {
//busco si ya existe.
$tutor = TutorPeer::findByDocumentTypeAndNumber($p_identification_type, $p_identification_number);
if (is_null($tutor)) {
//el tutor no existe. Lo creo
$p_person = new Person();
$p_person->setLastname($p_lastname);
$p_person->setFirstname($p_firstname);
$p_person->setIdentificationType($p_identification_type);
$p_person->setIdentificationNumber($p_identification_number);
$p_person->setSex(SexType::MALE);
$p_person->setPhone($p_phone);
$p_person->setEmail($p_email);
$p_person->setBirthdate($p_birthdate);
$p_person->setIsActive(true);
$p_person->setBirthCity($p_birth_city);
$p_person->save(Propel::getConnection());
$tutor = new Tutor();
$tutor->setPerson($p_person);
$tutor->setOccupationId($p_occupation);
$tutor->setOccupationCategoryId($p_occupation_category);
$tutor->setStudyId($p_study);
//coincide con la tabla sga_tipos_est_cur
$tutor->setNationality($p_nationality);
$tutor->save(Propel::getConnection());
/* Recupero department, state ,country*/
if (!is_null($p_birth_city)) {
$p_city = CityPeer::retrieveByPk($p_birth_city);
$tutor->getPerson()->setBirthCountry($p_city->getDepartment()->getState()->getCountry()->getId());
$tutor->getPerson()->setBirthState($p_city->getDepartment()->getState()->getId());
$tutor->getPerson()->setBirthDepartment($p_city->getDepartment()->getId());
}
//chequeo domicilio
if (!is_null($p_city) || !is_null($p_street) || !is_null($p_number) || !is_null($p_floor) || is_null($p_flat)) {
$a = new Address();
$a->setCityId($p_birth_city);
$a->setStreet($p_street);
$a->setNumber($p_number);
$a->setFloor($p_floor);
$a->setFlat($p_flat);
$tutor->getPerson()->setAddress($a);
$tutor->getPerson()->save(Propel::getConnection());
}
if (!is_null($data['info'])) {
$data['info'] = $data['info'] . " ya existe en el sistema. Por favor actualice los datos.";
}
} else {
if (!is_null($data['info'])) {
$data['info'] = "Los tutores con " . $i_identification_type->getStringFor($m_identification_type) . " " . $m_identification_number . " y " . $i_identification_type->getStringFor($p_identification_type) . " " . $p_identification_number . " ya existen en el sistema. Por favor actualice los datos.";
} else {
$data['info'] = "El tutor con " . $i_identification_type->getStringFor($p_identification_type) . " " . $p_identification_number . " ya existe en el sistema. Por favor actualice los datos.";
}
}
//datos de tutor(padre)
$st = StudentTutorPeer::retrieveByStudentAndTutor($student, $tutor);
if (is_null($st)) {
$student_tutor = new StudentTutor();
$student_tutor->setStudent($student);
$student_tutor->setTutor($tutor);
$student_tutor->save(Propel::getConnection());
$tutor->addStudentTutor($student_tutor);
$tutor->save(Propel::getConnection());
}
}
$con->commit();
} catch (PropelException $e) {
$con->rollBack();
throw $e;
}
}
$this->data = $data;
$this->getResponse()->setHttpHeader('Content-type', 'application/json');
$this->getResponse()->setContent(json_encode($data));
$this->setLayout(false);
}
<?php
// Inicio la sesión
@session_start();
// Load user
require_once __DIR__ . '/../oop/manager/UserManager.php';
$userManager = new UserManager();
$USER = $userManager->loadSession();
// Check the login
if ($USER != null && $USER instanceof Supervisor) {
$ID = $_POST['ID'];
if ($userManager->userExists($ID)) {
echo 'userAlreadyExists';
} else {
$PIN = $_POST['PIN'];
$name = $_POST['name'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$tutor = new Tutor($ID, null, $name, $email, $phone);
$tutor->setPIN($PIN);
$userManager->register($tutor);
echo 'true';
}
} else {
echo 'false';
}
function getFormacoes()
{
$tutor = new Tutor();
return $tutor->getFormacoes();
}
function register(Tutor $tutor)
{
if (!$this->userExists($tutor->getID())) {
$this->saveDatabase($tutor);
}
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer $id the ID of the model to be loaded
* @return Tutor the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = Tutor::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
