PHP Query_Page_Problem::fetch Examples

Example #1

File: patient_del.php Project: edubort/openclinic-1

    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();

Example #2

File: problem_del.php Project: edubort/openclinic-1

}
$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));

Example #3

File: print_medical_record.php Project: edubort/openclinic-1

}
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);

Example #4

File: Problem.php Project: edubort/openclinic-1

 /**
  * 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();
     }
 }