PHP Patient::getInsuranceCompany方法代码示例

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

    $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);
    unset($patient);
} else {
    $patName = $formVar["first_name"] . ' ' . $formVar["surname1"] . ' ' . $formVar["surname2"];
}
/**
 * Show page
 */
$title = _("Edit Patient Social Data");
$titlePage = $patName . ' (' . $title . ')';
$focusFormField = "nif";
// to avoid JavaScript mistakes in demo version
require_once "../layout/header.php";
//$returnLocation = "../medical/patient_view.php?id_patient=" . $idPatient;
$returnLocation = "../medical/patient_view.php";

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

    echo HTML::section(3, _("CPF"));
    echo HTML::para($patient->getNSS());
}
if ($patient->getFamilySituation()) {
    echo HTML::section(3, _("Situação da família"));
    echo HTML::para(nl2br($patient->getFamilySituation()));
}
if ($patient->getLabourSituation()) {
    echo HTML::section(3, _("Condição de trabalho"));
    echo HTML::para(nl2br($patient->getLabourSituation()));
}
if ($patient->getEducation()) {
    echo HTML::section(3, _("Formação"));
    echo HTML::para(nl2br($patient->getEducation()));
}
if ($patient->getInsuranceCompany()) {
    echo HTML::section(3, _("Situação inicial"));
    echo HTML::para($patient->getInsuranceCompany());
}
if ($patient->getIdMember()) {
    $staffQ = new Query_Staff();
    if ($staffQ->select($patient->getIdMember())) {
        $staff = $staffQ->fetch();
        if ($staff) {
            echo HTML::section(3, _("Atendente"));
            echo HTML::para($staff->getSurname1() . ' ' . $staff->getSurname2() . ', ' . $staff->getFirstName());
        }
        $staffQ->freeResult();
    }
    $staffQ->close();
    unset($staffQ);