/**
* bool insert(Patient $patient, History $historyP, History $historyF, int $idUser, string $login)
*
* Inserts a new deleted patient into the database.
*
* @param Patient $patient patient to insert
* @param History $historyP patient's personal antecedents to insert
* @param History $historyF patient's family antecedents to insert
* @param int $idUser key of user that makes deletion
* @param string $login login session of user that makes deletion
* @return boolean returns false, if error occurs
* @access public
*/
function insert($patient, $historyP, $historyF, $idUser, $login)
{
$sql = "INSERT INTO " . $this->_table;
$sql .= " (id_patient, nif, first_name, surname1, surname2, address, phone_contact, ";
$sql .= "sex, race, birth_date, birth_place, decease_date, nts, nss, ";
$sql .= "family_situation, labour_situation, education, insurance_company, ";
$sql .= "id_member, collegiate_number, birth_growth, growth_sexuality, feed, habits, ";
$sql .= "peristaltic_conditions, psychological, children_complaint, venereal_disease, ";
$sql .= "accident_surgical_operation, medicinal_intolerance, mental_illness, ";
$sql .= "parents_status_health, brothers_status_health, spouse_childs_status_health, ";
$sql .= "family_illness, create_date, id_user, login) VALUES (";
$sql .= "?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ";
$sql .= "?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ";
$sql .= "?, ?, ?, ?, NOW(), ?, ?);";
$params = array($patient->getIdPatient(), urlencode($patient->getNIF()), urlencode($patient->getFirstName()), urlencode($patient->getSurname1()), urlencode($patient->getSurname2()), urlencode($patient->getAddress()), urlencode($patient->getPhone()), $patient->getSex(), urlencode($patient->getRace()), $patient->getBirthDate(), urlencode($patient->getBirthPlace()), $patient->getDeceaseDate(), urlencode($patient->getNTS()), urlencode($patient->getNSS()), urlencode($patient->getFamilySituation()), urlencode($patient->getLabourSituation()), urlencode($patient->getEducation()), urlencode($patient->getInsuranceCompany()), $patient->getIdMember(), urlencode($patient->getCollegiateNumber()), urlencode($historyP->getBirthGrowth()), urlencode($historyP->getGrowthSexuality()), urlencode($historyP->getFeed()), urlencode($historyP->getHabits()), urlencode($historyP->getPeristalticConditions()), urlencode($historyP->getPsychological()), urlencode($historyP->getChildrenComplaint()), urlencode($historyP->getVenerealDisease()), urlencode($historyP->getAccidentSurgicalOperation()), urlencode($historyP->getMedicinalIntolerance()), urlencode($historyP->getMentalIllness()), urlencode($historyF->getParentsStatusHealth()), urlencode($historyF->getBrothersStatusHealth()), urlencode($historyF->getSpouseChildsStatusHealth()), urlencode($historyF->getFamilyIllness()), intval($idUser), urlencode($login));
return $this->exec($sql, $params);
}
//$returnLocation = "../medical/patient_view.php?id_patient=" . $idPatient; // controlling var
$returnLocation = "../medical/patient_view.php";
// controlling var
/**
* Destroy form values and errors
*/
Form::unsetSession();
/**
* Prevent user from aborting script
*/
$oldAbort = ignore_user_abort(true);
/**
* Update patient
*/
$patQ = new Query_Page_Patient();
if ($patQ->existName($pat->getFirstName(), $pat->getSurname1(), $pat->getSurname2(), $pat->getIdPatient())) {
$patQ->close();
FlashMsg::add(sprintf(_("O nome do beneficiário, %s, está em uso. As mudanças não terão efeito."), $patName), OPEN_MSG_WARNING);
header("Location: " . $returnLocation);
exit;
}
$patQ->update($pat);
$patQ->close();
unset($patQ);
unset($pat);
/**
* Record log process
*/
$recordQ = new Query_Page_Record();
$recordQ->log("Query_Page_Patient", "UPDATE", array($idPatient));
$recordQ->close();
header("Location: " . $errorLocation);
exit;
}
/**
* Checking permissions
*/
require_once "../auth/login_check.php";
loginCheck(OPEN_PROFILE_ADMINISTRATIVE);
require_once "../model/Query/Page/Patient.php";
require_once "../model/Query/Page/Record.php";
/**
* Validate data
*/
$pat = new Patient();
require_once "../medical/patient_validate_post.php";
$patName = $pat->getFirstName() . ' ' . $pat->getSurname1() . ' ' . $pat->getSurname2();
/**
* Destroy form values and errors
*/
Form::unsetSession();
/**
* Prevent user from aborting script
*/
$oldAbort = ignore_user_abort(true);
/**
* Insert new patient
*/
$patQ = new Query_Page_Patient();
if ($patQ->existName($pat->getFirstName(), $pat->getSurname1(), $pat->getSurname2())) {
$patQ->close();
FlashMsg::add(sprintf(_("Beneficiário %s, está em uso. As mudanças não serão realizadas."), $patName), OPEN_MSG_WARNING);
/**
* bool update(Patient $patient)
*
* Update a patient in the database.
*
* @param Patient $patient patient to update
* @return boolean returns false, if error occurs
* @access public
*/
function update($patient)
{
if (!$patient instanceof Patient) {
$this->_error = "Argument is an inappropriate object.";
return false;
}
/*if ($this->existName($patient->getFirstName(), $patient->getSurname1(), $patient->getSurname2(), $patient->getIdPatient()))
{
$this->_isError = true;
$this->_error = "Patient name, " . $patient->getFirstName();
$this->_error .= " " . $patient->getSurname1();
$this->_error .= " " . $patient->getSurname2() . ", is already in use.";
return false;
}*/
$sql = "UPDATE " . $this->_table . " SET " . "nif=?, " . "first_name=?, " . "surname1=?, " . "surname2=?, " . "address=?, " . "phone_contact=?, " . "sex=?, " . "race=?, " . "birth_date=?, " . "birth_place=?, " . "decease_date=?, " . "nts=?, " . "nss=?, " . "family_situation=?, " . "labour_situation=?, " . "education=?, " . "insurance_company=?, " . "id_member=? " . "WHERE id_patient=?;";
$params = array(urlencode($patient->getNIF()), urlencode($patient->getFirstName()), urlencode($patient->getSurname1()), urlencode($patient->getSurname2()), urlencode($patient->getAddress()), urlencode($patient->getPhone()), $patient->getSex(), urlencode($patient->getRace()), $patient->getBirthDate(), urlencode($patient->getBirthPlace()), $patient->getDeceaseDate(), urlencode($patient->getNTS()), urlencode($patient->getNSS()), urlencode($patient->getFamilySituation()), urlencode($patient->getLabourSituation()), urlencode($patient->getEducation()), urlencode($patient->getInsuranceCompany()), $patient->getIdMember(), $patient->getIdPatient());
return $this->exec($sql, $params);
}
$patient = new Patient($idPatient);
$patName = $patient->getName();
if ($patName == '') {
FlashMsg::add(_("That patient does not exist."), OPEN_MSG_ERROR);
header("Location: ../medical/patient_search_form.php");
exit;
}
/**
* load up post vars
*/
$formVar["id_patient"] = $idPatient;
//$formVar["last_update_date"] = date("Y-m-d"); // automatic date (ISO format)
$formVar["id_member"] = $patient->getIdMember();
$formVar["nif"] = $patient->getNIF();
$formVar["first_name"] = $patient->getFirstName();
$formVar["surname1"] = $patient->getSurname1();
$formVar["surname2"] = $patient->getSurname2();
$formVar["address"] = $patient->getAddress();
$formVar["phone_contact"] = $patient->getPhone();
$formVar["sex"] = $patient->getSex();
$formVar["race"] = $patient->getRace();
$formVar["birth_date"] = $patient->getBirthDate();
$formVar["birth_place"] = $patient->getBirthPlace();
$formVar["decease_date"] = $patient->getDeceaseDate();
$formVar["nts"] = $patient->getNTS();
$formVar["nss"] = $patient->getNSS();
$formVar["family_situation"] = $patient->getFamilySituation();
$formVar["labour_situation"] = $patient->getLabourSituation();
$formVar["education"] = $patient->getEducation();
$formVar["insurance_company"] = $patient->getInsuranceCompany();
Form::setSession($formVar);
$relatedLinks .= HTML::link(_("Editar dados"), '../medical/patient_edit_form.php', array('id_patient' => $idPatient));
$relatedLinks .= ' | ';
$relatedLinks .= HTML::link(_("Excluir beneficiário"), '../medical/patient_del_confirm.php', array('id_patient' => $idPatient));
}
echo HTML::para($relatedLinks);
$relatedLinks = HTML::link(_("Visualizar Relações"), '../medical/relative_list.php', array('id_patient' => $idPatient));
$relatedLinks .= ' | ';
$relatedLinks .= HTML::link(_("Histórico"), '../medical/history_list.php', array('id_patient' => $idPatient));
$relatedLinks .= ' | ';
$relatedLinks .= HTML::link(_("Registros clínicos"), '../medical/problem_list.php', array('id_patient' => $idPatient));
$relatedLinks .= ' | ';
$relatedLinks .= HTML::link(_("Imprimir"), '../medical/print_medical_record.php', array('id_patient' => $idPatient), array('class' => 'popup'));
echo HTML::para($relatedLinks);
echo HTML::rule();
echo HTML::section(3, _("Beneficiário"));
echo HTML::para($patient->getSurname1() . ' ' . $patient->getSurname2() . ', ' . $patient->getFirstName());
//echo HTML::section(3, _("Last Update Date"));
//echo HTML::para(I18n::localDate($patient->getLastUpdateDate()));
if ($patient->getNIF()) {
echo HTML::section(3, _("Protocolo Atendimento"));
echo HTML::para($patient->getNIF());
}
if ($patient->getAddress()) {
echo HTML::section(3, _("Endereço"));
echo HTML::para(nl2br($patient->getAddress()));
}
if ($patient->getPhone()) {
echo HTML::section(3, _("Telefone de contato"));
echo HTML::para(nl2br($patient->getPhone()));
}
echo HTML::section(3, _("Sexo"));