/**
* bool insert(Problem $problem, int $idUser, string $login)
*
* Inserts a new medical problem into the deleted problems table.
*
* @param Problem $problem medical problem 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($problem, $idUser, $login)
{
$sql = "INSERT INTO " . $this->_table;
$sql .= " (id_problem, last_update_date, id_patient, id_member, collegiate_number, order_number, ";
$sql .= "opening_date, closing_date, meeting_place, wording, subjective, objective, ";
$sql .= "appreciation, action_plan, prescription, create_date, id_user, login) VALUES (";
$sql .= "?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW(), ?, ?);";
$params = array($problem->getIdProblem(), $problem->getLastUpdateDate(), $problem->getIdPatient(), $problem->getIdMember(), urlencode($problem->getCollegiateNumber()), $problem->getOrderNumber(), $problem->getOpeningDate(), $problem->getClosingDate(), urlencode($problem->getMeetingPlace()), $problem->getWording(), urlencode($problem->getSubjective()), urlencode($problem->getObjective()), urlencode($problem->getAppreciation()), urlencode($problem->getActionPlan()), urlencode($problem->getPrescription()), intval($idUser), urlencode($login));
return $this->exec($sql, $params);
}
header("Location: ../medical/patient_search_form.php");
exit;
}
$problem = new Problem($idProblem);
if (!$problem) {
FlashMsg::add(_("Nenhum atendimento foi realizado até o momento."), OPEN_MSG_ERROR);
header("Location: ../medical/patient_search_form.php");
exit;
}
$formVar["id_problem"] = $idProblem;
$formVar["id_patient"] = $idPatient;
$formVar["order_number"] = $problem->getOrderNumber();
$formVar["opening_date"] = $problem->getOpeningDate();
if (!isset($formError)) {
$formVar["last_update_date"] = $problem->getLastUpdateDate();
$formVar["id_member"] = $problem->getIdMember();
$formVar["closed_problem"] = $problem->getClosingDate() != "" && $problem->getClosingDate() != "0000-00-00" ? "checked" : "";
$formVar["meeting_place"] = $problem->getMeetingPlace();
$formVar["wording"] = $problem->getWording();
$formVar["subjective"] = $problem->getSubjective();
$formVar["objective"] = $problem->getObjective();
$formVar["appreciation"] = $problem->getAppreciation();
$formVar["action_plan"] = $problem->getActionPlan();
$formVar["prescription"] = $problem->getPrescription();
}
/**
* Show page
*/
$title = _("Editar Atendimento");
$titlePage = $patient->getName() . ' [' . $problem->getWordingPreview() . '] (' . $title . ')';
$focusFormField = "wording";
echo $patient->getHeader();
$relatedLinks = "";
if ($_SESSION['auth']['is_administrative']) {
if ($problem->getClosingDate() == "" || $problem->getClosingDate() == '0000-00-00') {
$relatedLinks .= HTML::link(_("Edit Medical Problem Data"), '../medical/problem_edit_form.php', array('id_problem' => $idProblem, 'id_patient' => $idPatient));
$relatedLinks .= ' | ';
}
$relatedLinks .= HTML::link(_("Delete Medical Problem"), '../medical/problem_del_confirm.php', array('id_problem' => $idProblem, 'id_patient' => $idPatient));
$relatedLinks .= ' | ';
}
$relatedLinks .= HTML::link(_("View Connection Problems"), '../medical/connection_list.php', array('id_problem' => $idProblem, 'id_patient' => $idPatient));
$relatedLinks .= ' | ';
$relatedLinks .= HTML::link(_("View Medical Tests"), '../medical/test_list.php', array('id_problem' => $idProblem, 'id_patient' => $idPatient));
echo HTML::para($relatedLinks);
echo HTML::section(2, _("Medical Problem Data"));
if ($problem->getIdMember()) {
$staffQ = new Query_Staff();
if ($staffQ->select($problem->getIdMember())) {
$staff = $staffQ->fetch();
if ($staff) {
echo HTML::section(3, _("Attending Physician"));
echo HTML::para($staff->getSurname1() . ' ' . $staff->getSurname2() . ', ' . $staff->getFirstName());
}
$staffQ->freeResult();
}
$staffQ->close();
unset($staffQ);
unset($staff);
}
echo HTML::section(3, _("Opening Date"));
echo HTML::para(I18n::localDate($problem->getOpeningDate()));
/**
* bool update(Problem $problem)
*
* Update a medical problem in the problems table.
*
* @param Problem $problem medical problem to update
* @return boolean returns false, if error occurs
* @access public
*/
function update($problem)
{
if (!$problem instanceof Problem) {
$this->_error = "Argument is an inappropriate object.";
return false;
}
$sql = "UPDATE " . $this->_table . " SET " . "last_update_date=CURDATE(), " . "id_member=?, " . "closing_date=?, " . "meeting_place=?, " . "wording=?, " . "subjective=?, " . "objective=?, " . "appreciation=?, " . "action_plan=?, " . "prescription=? " . "WHERE id_problem=?;";
$params = array($problem->getIdMember(), urlencode($problem->getClosingDate(false)), urlencode($problem->getMeetingPlace()), urlencode($problem->getWording()), urlencode($problem->getSubjective()), urlencode($problem->getObjective()), urlencode($problem->getAppreciation()), urlencode($problem->getActionPlan()), urlencode($problem->getPrescription()), $problem->getIdProblem());
return $this->exec($sql, $params);
}
