+ // DONT consider NAN values (which is returned by rad2deg php function)
+ // for checking BETWEEN geo_code's criteria as it throws obvious 'NAN' field not found DB: Error
+ $geoCodeWhere = array();
+ if (!is_nan($minLatitude)) {
+ $geoCodeWhere[] = "{$tablePrefix}.geo_code_1 >= $minLatitude ";
+ }
+ if (!is_nan($maxLatitude)) {
+ $geoCodeWhere[] = "{$tablePrefix}.geo_code_1 <= $maxLatitude ";
+ }
+ if (!is_nan($minLongitude)) {
+ $geoCodeWhere[] = "{$tablePrefix}.geo_code_2 >= $minLongitude ";
+ }
+ if (!is_nan($maxLongitude)) {
+ $geoCodeWhere[] = "{$tablePrefix}.geo_code_2 <= $maxLongitude ";
+ }
+ $geoCodeWhereClause = implode(' AND ', $geoCodeWhere);
+