$tz = $value['timezone']; $location = $value['location']; if ($invitedQueue->isInvitedIdExistToTheQueue($iId, $database) == FALSE) { if (!empty($tz)) { //set and get the time plus days $invitedLocation->__setLocationByName($location, $database); Time::setTimeZoneDateTime($tz); Time::__setDateAddDays(Time::getTimezoneDate(), "+ 1 day"); $date1 = Time::getDateAddDays__(); Time::__setDateAddDays(Time::getTimezoneDate(), "+ 3 days"); $date2 = Time::getDateAddDays__(); Time::__setDateAddDays(Time::getTimezoneDate(), "+ 5 days"); $date3 = Time::getDateAddDays__(); echo "\n date1 {$date1} , date2 {$date2}, date3 {$date3} <br>\n"; //insert new queue invited_id, location_id, date1, date2 and date3 if ($invitedQueue->addInvitedToTheQueue($iId, $invitedLocation->getLocationId(), $date1, $date2, $date3, $database)) { echo "fs_invited_id_fk = {$iId} updated <br>\n"; if ($database->update('fs_invited', array('invited_status' => 12), "invited_id = {$iId}")) { //set value to get the qid $invitedQueue->setInvitedQueueByIid($iId, $database); echo "Successfully updated invited_status = 12 <br>\n"; if ($invitedActivity->addActivityLog($invitedQueue->getQid(), $invitedActivity->getMessageAddToQueue(), $database)) { echo "successfully added new activity log <br>\n"; } } } else { echo " iId = {$iId} failed to add <br>\n"; } } else { echo "\n iId = {$iId} timezone is empty not added <br>\n"; // UPDATE LOCATION TO DEFAILT New York