/** * 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); }
/** * bool updateFamily(History $history) * * Update family antecedents in the history table. * * @param History $history family antecedents to update * @return boolean returns false, if error occurs * @access public */ function updateFamily($history) { if (!$history instanceof History) { $this->_error = "Argument is an inappropriate object."; return false; } $sql = "UPDATE " . $this->_table . " SET " . "parents_status_health=?, " . "brothers_status_health=?, " . "spouse_childs_status_health=?, " . "family_illness=? " . "WHERE id_patient=?;"; $params = array(urlencode($history->getParentsStatusHealth()), urlencode($history->getBrothersStatusHealth()), urlencode($history->getSpouseChildsStatusHealth()), urlencode($history->getFamilyIllness()), $history->getIdPatient()); return $this->exec($sql, $params); }
Form::compareToken('../medical/patient_search_form.php'); require_once "../model/Query/History.php"; require_once "../model/Query/Page/Record.php"; /** * Retrieving post var */ $idPatient = intval($_POST["id_patient"]); /** * Validate data */ $history = new History(); $history->setIdPatient($_POST["id_patient"]); $history->setParentsStatusHealth($_POST["parents_status_health"]); $_POST["parents_status_health"] = $history->getParentsStatusHealth(); $history->setBrothersStatusHealth($_POST["brothers_status_health"]); $_POST["brothers_status_health"] = $history->getBrothersStatusHealth(); $history->setSpouseChildsStatusHealth($_POST["spouse_childs_status_health"]); $_POST["spouse_childs_status_health"] = $history->getSpouseChildsStatusHealth(); $history->setFamilyIllness($_POST["family_illness"]); $_POST["family_illness"] = $history->getFamilyIllness(); if (!$history->validateData()) { //$formError["???"] = $history->get???Error(); //$formError["???"] = $history->get???Error(); Form::setSession($_POST); //header("Location: ../medical/history_family_edit_form.php?id_patient=" . $idPatient); header("Location: ../medical/history_family_edit_form.php"); exit; } /** * Destroy form values and errors */