function test_insert_dbProfileActivity($profileActivity) { $retVal = insert_ProfileActivity($profileActivity); if ($retVal == true) { echo "</br> Insert succeeded </br>"; } else { echo "</br> Insert failed </br>"; } echo "Profile Activity Request ID: " . $profileActivity->get_profileActivityRequestID(); }
function updateFamilyProfile(Family $familyProfile) { error_log("in updateFamilyProfile will do the actual insert to the database"); $activityType = "Edit"; //retrieves the sw, and gets id, firstname and lastname $currentUser = getUserProfileID(); $swID = ""; $swFirstName = ""; $swLastName = ""; $rmhStaffProfileId = ""; $rmhStaffFirstName = ""; $rmhStaffLastName = ""; $dateSWSubmit = 'NULL'; $dateRMHApproved = 'NULL'; // if the person doing the edit is a social worker, add their name and id to the reservation // activity record if (getUserAccessLevel() == 1) { $rmhStaffProfileId = 'NULL'; $sw = retrieve_UserProfile_SW($currentUser); $swObject = current($sw); // there is only one record in the returned array, so get it // consider changing this code $swID = $swObject->get_swProfileId(); // $swFirstName = $swObject->get_swFirstName(); // $swLastName=$swObject->get_swLastName(); $status = "Unconfirmed"; $dateSWSubmit = date("Y-m-d H:i:s"); } else { if (getUserAccessLevel() == 2) { $rmhStaff = retrieve_UserProfile_RMHApprover_OBJ($currentUser); $rmhStaffProfileId = $rmhStaff->get_rmhStaffProfileId(); // $rmhStaffFirstName = $rmhStaff->get_rmhStaffFirstName(); // $rmhStaffLastName = $rmhStaff->get_rmhStaffLastName(); $status = "Confirmed"; $dateRMHApproved = date("Y-m-d H:i:s"); } } // only if this is an RMH staff approval // insert_FamilyProfile($familyProfile); error_log('in updateFamilyProfile, familyProfileId is ' . $familyProfile->get_familyProfileId()); // only insert an activity record - will insert change into FamilyProfile table only if // approved $currentProfileActivity = new ProfileActivity(0, 0, $familyProfile->get_familyProfileId(), $swID, $rmhStaffProfileId, $dateSWSubmit, $dateRMHApproved, $activityType, $status, $familyProfile->get_parentfname(), $familyProfile->get_parentlname(), $familyProfile->get_parentemail(), $familyProfile->get_parentphone1(), $familyProfile->get_parentphone2(), $familyProfile->get_parentaddress(), $familyProfile->get_parentcity(), $familyProfile->get_parentstate(), $familyProfile->get_parentzip(), $familyProfile->get_parentcountry(), $familyProfile->get_patientfname(), $familyProfile->get_patientlname(), $familyProfile->get_patientrelation(), $familyProfile->get_patientdob(), $familyProfile->get_patientformpdf(), $familyProfile->get_patientnotes(), $familyProfile->get_patientnotes()); $retval = insert_ProfileActivity($currentProfileActivity); return $retval; }
} if ($_POST['text_patientnotes'] != $Profile['patientnotes']) { $patientnotes = sanitize($_POST['text_patientnotes']); $change = true; } else { $patientnotes = $Profile['patientnotes']; } if (isset($_POST['text_swnotes'])) { $profileActityNotes = sanitize($_POST['text_swnotes']); } else { $profileActityNotes = ""; } $current_activity = new ProfileActivity(0, 0, $familyID, $sw_id, $sw_lname, $sw_fname, 0, "", "", $dateSubmit, 0, $activityType, $profileActitivityStatus, $parentfname, $parentlname, $parentemail, $parentphone1, $parentphone2, $parentAddr, $parentcity, $parentstate, $parentzip, $parentcountry, $patientfname, $patientlname, $patientrelation, $patientdob, $patientformpdf, $patientnotes, $profileActityNotes); //if there is a change, insert a new profileActivity object if ($change) { if (insert_ProfileActivity($current_activity)) { echo "Successfully inserted a profile activity request"; //Send email to notify the rmh approvers $RequestKey = $current_activity->get_profileActivityRequestId(); if (newFamilyMod($RequestKey, $familyID, $dateSubmit)) { echo "An email is sent to the RMH Approver"; } echo '<a href="' . BASE_DIR . '/referralForm.php?family=' . $familyID . '">Create Room Reservation</a>'; exit; } } else { if (!$change) { echo "You did not make any changes."; } } } else {