public static function getInstance()
{
if (!self::$instance) {
self::$instance = new AddressDAO();
}
return self::$instance;
}
/**
* Override default validation
* @see Phreezable::Validate()
*/
public function Validate()
{
// example of custom validation
// $this->ResetValidationErrors();
// $errors = $this->GetValidationErrors();
// if ($error == true) $this->AddValidationError('FieldName', 'Error Information');
// return !$this->HasValidationErrors();
return parent::Validate();
}
public static function loadAddress($con, $person_id)
{
$sql = "select * from address where person_id = {$person_id};";
$stmt = $con->query($sql);
$stmt->execute();
$row = $stmt->fetch(PDO::FETCH_ASSOC);
$tempAddrDTO = AddressDAO::getAddressDTO($row['street1'], $row['street2'], $row['city'], $row['state_id'], $row['zip'], $row['address_id'], $row['person_id']);
return $tempAddrDTO;
}
public static function saveAddressModel($latitude, $longitude, $formType)
{
$responseDTO = new ResponseDTO($formType);
try {
if (!is_null($longitude) && !is_null($latitude)) {
$addressDTO = new AddressDTO($latitude, $longitude);
$addressDAO = new AddressDAO();
$existingAddress = $addressDAO->checkIfAddressExist($addressDTO);
if (!is_null($existingAddress)) {
return $existingAddress;
} else {
$addressComponents = FileUtils::callGoogleReverseGeocodingService($addressDTO);
$addressDTO->setStreet(isset($addressComponents[STREET]) ? $addressComponents[STREET] : NULL);
$addressDTO->setNumber(isset($addressComponents[NUMBER]) ? $addressComponents[NUMBER] : NULL);
$addressDTO->setCap(isset($addressComponents[CAP]) ? $addressComponents[CAP] : NULL);
$addressDTO->setCity(isset($addressComponents[CITY]) ? $addressComponents[CITY] : NULL);
$addressDTO->setCountry(isset($addressComponents[COUNTRY]) ? $addressComponents[COUNTRY] : NULL);
$result = $addressDAO->insertNewAddress($addressDTO);
if ($result != 0) {
$responseDTO->setErrField(ADDRESS, "Errore durante l'inserimento di questo indirizzo LONGITUDE: " . $addressDTO->getLongitude());
} else {
$result = $addressDAO->insertNewUserAddressVisited($addressDTO);
return $addressDTO;
}
}
return $responseDTO;
} else {
$addressDTO = new AddressDTO();
return $addressDTO;
}
} catch (PDOException $pdoe) {
throw $pdoe;
} catch (UserNotAuthenticatedExceptionDTO $authExp) {
throw $authExp;
} catch (Exception $e) {
throw $e;
}
}
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();
}
}
/**
* inicia interaliasnte a DAO
* @return void
*/
public function startDAO()
{
$this->DAO = AddressDAO::getInstance();
}
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);
public function deleteAddress()
{
$ReturnResultVO = new ReturnResultVO();
$ReturnResultVO->success = FALSE;
if (DataHandler::getValueByArrayIndex($this->arrayVariable, "address_id") != NULL && DataHandler::getValueByArrayIndex($this->arrayVariable, "user_id") != NULL) {
$user_id = DataHandler::getValueByArrayIndex($this->arrayVariable, "user_id");
$address_id = DataHandler::getValueByArrayIndex($this->arrayVariable, "address_id");
$UserAddressDAO = UserAddressDAO::getInstance();
$ReturnDataVO = $UserAddressDAO->deleteByUserAndAddress($user_id, $address_id);
if ($ReturnDataVO->success) {
$AddressDAO = AddressDAO::getInstance();
$ReturnDataVO = $AddressDAO->delete($address_id);
}
$ReturnResultVO->success = $ReturnDataVO->success;
$ReturnResultVO->result = $ReturnDataVO->result;
}
echo $ReturnResultVO->toJson();
exit;
}
/**
* @param $id number
* @return class ReturnDataVO
*/
public function selectByUserId($typeOfReturn = NULL, $id)
{
$typeOfReturn = DbInterface::RETURN_STD_OBJECT;
$query = "SELECT \r\n\t\t\t\t\t\t\taddress.*,\r\n\t\t\t\t\t\t\tstate.name as state_name,\r\n\t\t\t\t\t\t\tcountry.name as country_name\r\n\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\tuser_address\r\n\t\t\t\t\t\t\t\tINNER JOIN\r\n\t\t\t\t\t\t\t\t\taddress \r\n\t\t\t\t\t\t\t\t\t\tON address.id = user_address.address_id\r\n\t\t\t\t\t\t\t\tLEFT JOIN\r\n\t\t\t\t\t\t\t\t\tstate\r\n\t\t\t\t\t\t\t\t\t\tON address.state_id = state.id \r\n\t\t\t\t\t\t\t\tLEFT JOIN\r\n\t\t\t\t\t\t\t\t\tcountry\r\n\t\t\t\t\t\t\t\t\t\tON country.id = state.country_id \r\n\t\t\t\t\t\tWHERE user_address.user_id = " . $id;
$AddressDAO = new AddressDAO();
//executa a query
$ReturnDataVO = $AddressDAO->query($query);
//echo $query;
if ($ReturnDataVO->success) {
switch ($typeOfReturn) {
case DbInterface::RETURN_ARRAY:
$ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_ARRAY);
break;
case DbInterface::RETURN_VO:
$ReturnDataVO->fetchAllVO($ReturnDataVO);
break;
case DbInterface::RETURN_STD_OBJECT:
default:
//retornar tudo em objeto
$ReturnDataVO->fetchAll(ReturnDataVO::TYPE_FETCH_OBJECT);
break;
}
return $ReturnDataVO;
} else {
return $ReturnDataVO;
}
}
