function getUserList()
{
try {
$personDAO = new PersonDAO();
$userList = $personDAO->getAllUsers();
return $userList;
} catch (PDOException $pdoe) {
throw $pdoe;
} catch (UserNotAuthenticatedExceptionDTO $authExp) {
throw $authExp;
} catch (Exception $e) {
throw $e;
}
}
public static function loadPerson($con, $person_id)
{
$sql = "select * from person where person.person_id = {$person_id};";
$stmt = $con->query($sql);
$stmt->execute();
$row = $stmt->fetch(PDO::FETCH_ASSOC);
$tempPersonDTO = PersonDAO::getPersonDTO($row['person_id'], $row['l_name'], $row['f_name'], $row['email_addr']);
return $tempPersonDTO;
}
function updatePersonRecord($personDTO)
{
self::openConn();
$this->con->beginTransaction();
try {
AddressDAO::updateAddress($this->con, $personDTO->getAddrDTO());
PhoneDAO::updatePhone($this->con, $personDTO->getPhoneDTO());
$person_id = PersonDAO::updatePerson($this->con, $personDTO);
$return = new ResultDTO($person_id, "UPDATED");
$json = json_encode($return);
echo $json;
$this->con->commit();
self::closeConn();
} catch (PDOException $e) {
$person_id = "person insert Error: " . $e->getMessage();
$this->con->rollBack();
}
}
function handlePERSON($srcBase, $uttrekkMySQLBase, $tableName, $logger)
{
echo "\t handling PERSON ... ";
$logger->log("PERSON.XML", "Started processing PERSON(" . $tableName . ")", Constants::LOG_PROCESSINGINFO);
$personDAO = new PersonDAO($srcBase, $uttrekkMySQLBase, $tableName, $logger);
$personDAO->processTable();
$issues = $personDAO->getIssues();
if ($issues == "") {
$logger->log("PERSON.XML", "Finished processing PERSON. No issues reported", Constants::LOG_PROCESSINGINFO);
} else {
$logger->log("PERSON.XML", "Finished processing PERSON. " . $issues, Constants::LOG_PROCESSINGINFO);
}
echo $issues . " ... processed PERSON " . $personDAO->countRowsInTableAfter() . " rows handled\n";
return $personDAO;
}
include "DTO/PersonDTO.php";
include "DAO/PersonDAO.php";
include "DTO/PhoneDTO.php";
include "DAO/PhoneDAO.php";
include "DAO/AddressDAO.php";
include "DTO/AddressDTO.php";
include "DAO/StateDAO.php";
include "DTO/StateDTO.php";
include 'DTO/ResultDTO.php';
$data_back = json_decode(file_get_contents('php://input'));
$phone = $data_back->{"phoneDTO"};
$address = $data_back->{"addrDTO"};
$phone_number = $phone->{"phone_number"};
$phone_type_id = $phone->{"phone_type_id"};
$phone_id = $phone->{"phone_id"};
$phone_type = $phone->{"phone_type"};
$f_name = $data_back->{"f_name"};
$l_name = $data_back->{"l_name"};
$email_addr = $data_back->{"email_addr"};
$person_id = $data_back->{"person_id"};
$street1 = $address->{"street1"};
$street2 = $address->{"street2"};
$city = $address->{"city"};
$state_id = $address->{"state_id"};
$zip = $address->{"zip"};
$address_id = $address->{"address_id"};
$tempPhoneDTO = PhoneDAO::getPhoneDTO($phone_id, $person_id, $phone_type_id, $phone_number, $phone_type);
$tempAddressDTO = AddressDAO::getAddressDTO($street1, $street2, $city, $state_id, $zip, $address_id, $person_id);
$tempPersonDTO = PersonDAO::getPersonDTO($person_id, $l_name, $f_name, $email_addr, $tempPhoneDTO, $tempAddressDTO);
$progrManager = new programManager();
$progrManager->updatePersonRecord($tempPersonDTO);
function changeUserProfileInfoModel($infoForm, $userId = NULL)
{
$formObjRaw = new FormDTO(CHANGE_SETTINGS_FORM, $infoForm);
$responseDTO = new ResponseDTO(CHANGE_SETTINGS_FORM);
try {
$formDataObj = $formObjRaw->getFormData();
$validator = new FormValidator(CHANGE_SETTINGS_FORM, $formDataObj);
$validationError = $validator->checkAll();
if (sizeof($validationError) == 0) {
$birthday = $formDataObj[CHANGE_SETTINGS_FORM . YEAR];
$userLogged = SessionUtils::getUserLogged();
if (!is_null($birthday)) {
$birthday = $formDataObj[CHANGE_SETTINGS_FORM . YEAR] . "-" . $formDataObj[CHANGE_SETTINGS_FORM . MONTH] . "-" . $formDataObj[CHANGE_SETTINGS_FORM . DAY];
}
$personDAO = new PersonDAO();
$userDAO = new UserDAO();
if (is_null($userId)) {
$userId = $userLogged->getUserId();
}
$userDTO = $userDAO->getUserInfo($userId);
$updateUserInfo = new PersonDTO($userDTO->getPersonId(), $formDataObj[CHANGE_SETTINGS_FORM . NAME], $formDataObj[CHANGE_SETTINGS_FORM . SURNAME], $formDataObj[CHANGE_SETTINGS_FORM . GENDER], $birthday, $formDataObj[CHANGE_SETTINGS_FORM . EDUCATION], $formDataObj[CHANGE_SETTINGS_FORM . JOB], $formDataObj[CHANGE_SETTINGS_FORM . DESCRIPTION], $formDataObj[CHANGE_SETTINGS_FORM . RELATIONSHIP], $formDataObj[CHANGE_SETTINGS_FORM . ORIENTATION]);
$personDTO = $personDAO->updateProfileInfo($updateUserInfo);
DataModelUtils::notifyAction(NULL, CHANGE_SETTINGS_FORM);
return $personDTO;
} else {
if (array_key_exists(EDUCATION, $validationError)) {
$responseDTO->setErrField(EDUCATION, $validationError[EDUCATION]);
}
if (array_key_exists(DESCRIPTION, $validationError)) {
$responseDTO->setErrField(DESCRIPTION, $validationError[DESCRIPTION]);
}
if (array_key_exists(JOB, $validationError)) {
$responseDTO->setErrField(JOB, $validationError[JOB]);
}
if (array_key_exists(NAME, $validationError)) {
$responseDTO->setErrField(NAME, $validationError[NAME]);
}
if (array_key_exists(SURNAME, $validationError)) {
$responseDTO->setErrField(SURNAME, $validationError[SURNAME]);
}
}
return $responseDTO;
} catch (PDOException $pdoe) {
throw $pdoe;
} catch (UserNotAuthenticatedExceptionDTO $authExp) {
throw $authExp;
} catch (Exception $e) {
throw $e;
}
}
public function signUpModel($registrationForm)
{
$formObjRaw = new FormDTO(REGISTRATION_FORM, $registrationForm);
$responseDTO = new ResponseDTO(REGISTRATION_FORM);
try {
$formDataObj = $formObjRaw->getFormData();
$validator = new FormValidator(REGISTRATION_FORM, $formDataObj);
$validationError = $validator->checkAll();
if (sizeof($validationError) == 0) {
$hashedPwd = PasswordUtils::getPassword($formDataObj[REGISTRATION_FORM . PASSWORD]);
$userDTO = new UserDTO(NULL, $formDataObj[REGISTRATION_FORM . USERNAME], $hashedPwd, NULL, USER, NULL, $formDataObj[REGISTRATION_FORM . EMAIL], NULL);
$userDAO = new UserDAO();
$existingUser = $userDAO->checkIfUserExist($userDTO);
if (!is_null($existingUser)) {
$responseDTO->setErrField(ERROR_RESPONSE, "Utente già presente con questa mail: " . $userDTO->getEmail() . " o con questo username: "******"Verrà inviata una mail a questo indirizzo: " . $userDTO->getEmail());
// } else {
// $responseDTO->setErrField(ERROR_RESPONSE, "Errore durante l'invio della mail");
// }
} else {
$responseDTO->setErrField(ERROR_RESPONSE, "Errore durante l'inserimento dell'album");
}
} else {
$responseDTO->setErrField(ERROR_RESPONSE, "Errore durante l'inserimento dello user");
}
}
} else {
if (array_key_exists(USERNAME, $validationError)) {
$responseDTO->setErrField(USERNAME, $validationError[USERNAME]);
}
if (array_key_exists(PASSWORD, $validationError)) {
$responseDTO->setErrField(PASSWORD, $validationError[PASSWORD]);
}
if (array_key_exists(CONFIRM_PASSWORD, $validationError)) {
$responseDTO->setErrField(CONFIRM_PASSWORD, $validationError[CONFIRM_PASSWORD]);
}
if (array_key_exists(EMAIL, $validationError)) {
$responseDTO->setErrField(EMAIL, $validationError[EMAIL]);
}
SessionUtils::setFormValue($formDataObj);
}
return $responseDTO;
} catch (PDOException $pdoe) {
throw $pdoe;
} catch (Exception $e) {
throw $e;
}
}
