" . $SQL . "

"; $oNRS = new nRS($SQL); return $oNRS; } function & ZipProximality_WarehousesFromList(&$ZipList, $maxToReturn = 500, $table = ZIPPROXIMALITY_TABLE_TEMP, $bDebug = false) { if (substr($table, 0, 1) != "_") $table = '_' . $table; $SQL = " SELECT " . $table . ".distance, warehouse.* FROM warehouse LEFT JOIN " . $table . " ON warehouse.pickupZip=" . $table . ".zip WHERE warehouse.pickupZip IN(" . $ZipList . ") ORDER BY distance LIMIT " . $maxToReturn . " "; if ($bDebug === true) echo "

" . $SQL . "

"; $oNRS = new nRS($SQL); return $oNRS; } function & ZipProximality_GetZipList($zip, $radius = 500, $maxToCheck = 2500, $table = ZIPPROXIMALITY_TABLE_TEMP, $temporary = true, $bDebug = false) { global $g_oNDB; $rOrigin = $g_oNDB->getRow("SELECT * FROM zipcode WHERE zipcode='" . addslashes($zip) . "'"); if ($bDebug === true) echo "

" . print_r($rOrigin, true) . "

";if (substr($table, 0, 1) != "_") $table = '_' . $table; $SQL = "DROP TABLE IF EXISTS " . $table; if ($bDebug === true) echo "

" . $SQL . "

"; $g_oNDB->execute($SQL); $SQL = " create " . ($temporary ? "TEMPORARY " : "") . "table " . $table . "( zip char(10) NOT NULL default '', latitude double NOT NULL default 0.00, longitude double NOT NULL default 0.00, distance double NOT NULL default 0.00, primary key(zip) ) engine=MEMORY "; if ($bDebug === true) echo "

" . $SQL . "

"; $g_oNDB->execute($SQL); $SQL = " INSERT INTO " . $table . "(zip,latitude,longitude,distance) SELECT zipcode, latitude,longitude, DEGREES( ACOS( SIN(RADIANS(" . $rOrigin['latitude'] . ")) * SIN(RADIANS(latitude)) + COS(RADIANS(latitude)) * COS(RADIANS(" . $rOrigin['latitude'] . ")) * COS(RADIANS(" . $rOrigin['longitude'] . " - longitude)) ) )*60*1.1515 as calc_distance FROM zipcode WHERE " . $radius . " > DEGREES( ACOS( SIN(RADIANS(" . $rOrigin['latitude'] . ")) * SIN(RADIANS(latitude)) + COS(RADIANS(latitude)) * COS(RADIANS(" . $rOrigin['latitude'] . ")) * COS(RADIANS(" . $rOrigin['longitude'] . " - longitude)) ) )*60*1.1515 "; if ($bDebug === true) echo "

" . $SQL . "

"; $g_oNDB->execute($SQL); $SQL = "SELECT zip, distance FROM " . $table . " WHERE distance < " . $radius . " ORDER BY distance LIMIT " . $maxToCheck; if ($bDebug === true) echo "

" . $SQL . "

"; $oNRS = new nRS($SQL); for ($i = 0; $i < mysql_num_rows($oNRS->hData); $i++) { $zips .= "'" . mysql_result($oNRS->hData, $i, "zip") . "',"; } if ($zips != "") $zips = substr($zips, 0, strlen($zips) - 1); return $zips; } ?> getRow("SELECT * FROM zipcode WHERE zipcode='".addslashes($zip)."'"); $SQL = " create temporary table _zipsearchprefix( zip char(10) NOT NULL default '', latitude double NOT NULL default 0.00, longitude double NOT NULL default 0.00, distance double NOT NULL default 0.00, primary key(zip) ) engine=MEMORY "; $g_oNDB->execute( $SQL ); $SQL = " INSERT INTO _zipsearchprefix(zip,latitude,longitude,distance) SELECT zipcode, latitude,longitude, DEGREES( ACOS( SIN(RADIANS(".$rOrigin['latitude'].")) * SIN(RADIANS(latitude)) + COS(RADIANS(latitude)) * COS(RADIANS(".$rOrigin['latitude'].")) * COS(RADIANS(".$rOrigin['longitude']." - longitude)) ) )*60*1.1515 as calc_distance FROM zipcode WHERE ".$radius." > DEGREES( ACOS( SIN(RADIANS(".$rOrigin['latitude'].")) * SIN(RADIANS(latitude)) + COS(RADIANS(latitude)) * COS(RADIANS(".$rOrigin['latitude'].")) * COS(RADIANS(".$rOrigin['longitude']." - longitude)) ) )*60*1.1515 "; $g_oNDB->execute( $SQL ); if( $prefixlength < 1 ) $prefixlength = 1; if( $prefixlength > 5 ) $prefixlength = 5; $zips = array(); $SQL = "SELECT Distinct(Mid(zip,1,".$prefixlength.")) as `prefix` FROM _zipsearchprefix LIMIT ".$limit; $oNRS = new nRS($SQL); while( $rData = $oNRS->read() ) { $zips[] = $rData['prefix']; } return $zips; } ?>