for ($i = 0; $i < $numRows; $i++) { $problemQ->delete($array[$i]->getIdProblem()); } $problemQ->close(); unset($problemQ); unset($array); } /** * Afterwards: closed problems */ $problemQ = new Query_Page_Problem(); $numRows = $problemQ->selectProblems($idPatient, true); if ($numRows) { $array = array(); for ($i = 0; $i < $numRows; $i++) { $array[$i] = $problemQ->fetch(); } $problemQ->freeResult(); $problemQ->close(); unset($problemQ); $delProblemQ = new Query_DelProblem(); for ($i = 0; $i < $numRows; $i++) { $delProblemQ->insert($array[$i], $_SESSION['auth']['user_id'], $_SESSION['auth']['login_session']); } $delProblemQ->close(); unset($delProblemQ); $problemQ = new Query_Page_Problem(); /** * Record log process (before deleting process) */ $recordQ = new Query_Page_Record();
} $connQ->close(); unset($connQ); unset($conn); /** * Delete problem */ $problemQ = new Query_Page_Problem(); if (defined("OPEN_DEMO") && !OPEN_DEMO) { if (!$problemQ->select($idProblem)) { $problemQ->close(); FlashMsg::add(_("That medical problem does not exist."), OPEN_MSG_ERROR); header("Location: " . $returnLocation); exit; } $problem = $problemQ->fetch(); if (!$problem) { $problemQ->close(); Error::fetch($problemQ); } $wording = $problem->getWording(); $delProblemQ = new Query_DelProblem(); $delProblemQ->insert($problem, $_SESSION['auth']['user_id'], $_SESSION['auth']['login_session']); unset($delProblemQ); unset($problem); } /** * Record log process (before deleting process) */ $recordQ = new Query_Page_Record(); $recordQ->log("Query_Page_Problem", "DELETE", array($idProblem));
} if ($history->getFamilyIllness()) { echo HTML::section(3, _("Family Illness")); echo HTML::para(nl2br($history->getFamilyIllness())); } echo HTML::rule(); /** * Show closed medical problems */ echo HTML::section(2, _("Closed Medical Problems List:")); $problemQ = new Query_Page_Problem(); if (!$problemQ->selectProblems($idPatient, true)) { echo Msg::info(_("No closed medical problems defined for this patient.")); echo HTML::rule(); } while ($problem = $problemQ->fetch()) { echo HTML::section(3, _("Order Number")); echo HTML::para($problem->getOrderNumber()); 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);
/** * mixed Problem(int $id = 0) * * Constructor * * @param int $id (optional) * @return mixed void if not argument, null if not exists problem, object otherwise * @access public */ function Problem($id = 0) { $this->_trans = array_flip(get_html_translation_table(HTML_SPECIALCHARS)); if ($id) { $_problemQ = new Query_Page_Problem(); if (!$_problemQ->select($id)) { return null; } foreach (get_object_vars($_problemQ->fetch()) as $key => $value) { $this->{$key} = $value; } $_problemQ->freeResult(); $_problemQ->close(); } }