jscott-simplertimes.frontrunnerpro.comWhat is Simpler Times - Simpler Times Kingston

Warning : fopen(/ims/development/jscott/app_logs/All/daily_20200210.log): failed to open stream: Permission denied in /usr/local/lib/php/Log4php/appenders/LoggerAppenderFile.php on line 77 Notice : Undefined property: FuneralDetails::$AUFDao in /ims/development/jscott/FuneralDetails/lib/FuneralDetails.php on line 253 findPK($id); if($record){ $rtVl = $record; } return $rtVl; } /** * * * */ public function fetchInstitution($id){ $rtVl = null; $inst = SiteQuery::create() ->findPK($id); if($inst){ $rtVl = $inst; } return $rtVl; } /** * Fetch the records for a listing page. * * @param int $page : the currnet page * @param int $rows : the number of rows that should be pulled * @param obj $state : state * @param boolean $countOnly : only return the count, exclude pagination */ public function fetchRecordListing($page,$rows,$state,$countOnly=false){ $rtVl = array(); $city = $state->getValue('city'); $province = $state->getValue('province'); $country = $state->getValue('country'); $firstname = $state->getValue('firstname'); $lastname = $state->getValue('lastname'); $obit = $state->getValue('searchtext'); $dateStart = $state->getValue('start_date'); $dateEnd = $state->getValue('end_date'); $showTodays = $state->getValue('showTodays'); $siteId = $state->getValue("funeralhome"); $rtVl = DeathRecordQuery::create() ->filterByVisible(1); if($siteId){ $rtVl = $rtVl->filterBySiteId($siteId); } if($obit){ $rtVl = $rtVl->filterByObituary("%{$obit}%"); } if($firstname){ $rtVl = $rtVl->filterByGivenName("%$firstname%"); } else{ $rtVl = $rtVl->filterByGivenName('',Criteria::NOT_EQUAL); } if($lastname){ $rtVl = $rtVl->filterByLastName("%$lastname%"); } else{ $rtVl = $rtVl->filterByLastName('',Criteria::NOT_EQUAL); } if($dateStart && $dateEnd){ $rtVl = $rtVl->filterByDateOfDeath(array('min' => $dateStart, 'max' => $dateEnd)); } if($showTodays == "true"){ $today = new DateTime(); $rtVl = $rtVl->filterByDateCreated( $today->format("Y-m-d") ); } if($city || $province || $country){ $rtVl = $rtVl->useExtendedDeathRecordQuery(); if($city){ $rtVl = $rtVl->filterByext_DeceasedCity($city); } if($province){ $rtVl = $rtVl->filterByext_DeceasedProvince($province); } if($country){ $rtVl = $rtVl->filterByext_DeceasedCountry($country); } $rtVl = $rtVl->endUse(); } $rtVl = $rtVl->useSiteQuery() ->filterByfuneralNetwork(1) ->filterByGroupName("ST") ->endUse() ->orderByDateOfDeath("DESC") ->paginate($page,$rows); if($countOnly){ $rtVl = $rtVl->getNbResults(); } return $rtVl; } /** * Fetch the funeral homes for simpler times. * * @return array */ public function fetchFuneralHomes(){ $rtVl = array(); $fhs = SiteQuery::create() ->filterFuneralNetworkST() ->find(); foreach($fhs as $fh){ $rtVl[] = array( "id" => $fh->getSiteId(), "name" => $fh->getNotes(), "city" => $fh->getSiteProfile()->getMailingCity(), "province" => $fh->getSiteProfile()->getMailingProvince(), "country" => $fh->getSiteProfile()->getMailingCountry() ); } return $rtVl; } public function getSitesByLocation($city, $province){ $fhs = SiteQuery::create(); if(isset($city) || isset($province)){ $fhs = $fhs->joinWith("Site.SiteProfile") ->filterCitiesServed($city, $province); } $fhs = $fhs->filterFuneralNetworkST() ->find(); return $fhs; } public function getSitesByCoords($lat, $lng, $radius, $limit){ $con = Propel::getConnection(SitePeer::DATABASE_NAME); $sqlString = "SELECT P.*, S.Notes, M.MembershipType, ( 3959 * acos( cos( radians('%s') ) * cos( radians( MailingLat ) ) * cos( radians( MailingLng ) - radians('%s') ) + sin( radians('%s') ) * sin( radians( MailingLat ) ) ) ) AS distance FROM SiteProfile as P INNER JOIN Site AS S ON P.SiteId = S.SiteId INNER JOIN SiteGroupMember AS M ON S.SiteId = M.SiteId INNER JOIN SiteGroup AS G ON M.GroupId = G.GroupId WHERE G.GroupName = 'ST' AND S.FuneralNetwork = 1"; if($limit == 1){ $sqlString .= " AND M.MembershipType != 'reserved'"; } $sqlString .= " HAVING distance < '%s' ORDER BY distance LIMIT 0 , %s"; $sql = sprintf($sqlString, $lat, $lng, $lat, $radius, $limit); $stmt = $con->prepare($sql); //$stmt->execute(array(':countrycode' => $country, // ':statecode' => $state, // ':city' => $city)); $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_ASSOC); // or FETCH_OBJ return $result; } }...