Paginator->sort('id') ?>	Paginator->sort('name') ?>	Paginator->sort('token') ?>	Paginator->sort('created') ?>	Paginator->sort('modified') ?>
Number->format($user->id) ?>	name) ?>	token) ?>	created) ?>	modified) ?>	+ Html->link(__('Calendar'), ['action' => 'showCalendar', $user->id]) ?> + Html->link(__('View'), ['action' => 'view', $user->id]) ?> + + Form->postLink(__('Delete'), ['action' => 'delete', $user->id], ['confirm' => __('Are you sure you want to delete # {0}?', $user->id)]) ?> + Html->link(__('Revoke'), ['action' => 'revoke', $user->id], ['confirm' => __('Are you SURE you want to revoke authorization # {0}? This will totally drop that authorization, which you cannot re-add unless you are the original user that stored it.', $user->id)]) ?> +

+ + + + + + + + ./src/ + ./plugins/*/src/ + + + diff --git a/production/example_apps/zippy_maps/readme.txt b/production/example_apps/zippy_maps/readme.txt new file mode 100644 index 00000000..6231a9e4 --- /dev/null +++ b/production/example_apps/zippy_maps/readme.txt @@ -0,0 +1,42 @@ + +steps to bringing up this maps demo site... + +* need to configure a database in app.php. see default version: config/app.default.php + +* need an api key from google to have separate hit quotas on mapping API. + * refer to: https://developers.google.com/maps/documentation/distance-matrix/get-api-key + * see default version: config/config_google.default.php + * example of using api key: + * https://maps.googleapis.com/maps/api/distancematrix/json?origins=Seattle&destinations=San+Francisco&key=YOUR_API_KEY + +* need to install the cake geo code. + * more details at: https://github.com/dereuromark/cakephp-geo/blob/master/docs/Install.md + +* need to have jquery available and loaded someplace. i got a recent minified version of it and stored it in webroot/js and then added this to default.ctp before the fetch('script') call: + + +* need to load the marker clusterer code for map marker clustering to work. see ClusterMapHelper.php for more info. + +* a bunch of icons for map markers can be found here: https://code.google.com/archive/p/google-maps-icons/downloads + +* need to make links for the plugins: + from: https://book.cakephp.org/3.0/en/deployment.html#symlink-assets + run: bin/cake plugin assets symlink + +--- + +assorted reference notes: + +mysql and php using javascript api with maps: +https://developers.google.com/maps/documentation/javascript/mysql-to-maps + +how to show things in a form with checkboxes: +https://book.cakephp.org/3.0/en/views/helpers/form.html#creating-inputs-for-associated-data + +tagList above is computed this way: +https://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html#finding-key-value-pairs + +events that can be hooked are listed here: +https://developers.google.com/maps/documentation/javascript/reference + + diff --git a/production/example_apps/zippy_maps/reference/zipcode.php b/production/example_apps/zippy_maps/reference/zipcode.php new file mode 100644 index 00000000..1bfe72f3 --- /dev/null +++ b/production/example_apps/zippy_maps/reference/zipcode.php @@ -0,0 +1,829 @@ +get_zips_in_range($this->zipPageConditions['zip'], $this->zipPageConditions['range'], $this->zipPageConditions['sort']); + $page_data = array(); + //loop through page data + + + return $this->zipInRangeData; + } + + function paginateCount($conditions = null, $recursive = 0) { + return count($this->zipInRangeData); + } + + + + /* + * TAKEN FROM MICCAH CODE + */ + + var $last_error = ""; // last error message set by this class + var $units = _UNIT_MILES; // miles or kilometers + var $decimals = 2; // decimal places for returned distance + + function get_distance($zip1, $zip2) { + + // returns the distance between to zip codes. If there is an error, the + // function will return false and set the $last_error variable. + + if ($zip1 == $zip2) + return 0; // same zip code means 0 miles between. :) + + + // get details from database about each zip and exit if there is an error + + $details1 = $this->get_zip_point($zip1); + $details2 = $this->get_zip_point($zip2); + if ($details1 == false) { + $this->last_error = "No details found for zip code: $zip1"; + return false; + } + if ($details2 == false) { + $this->last_error = "No details found for zip code: $zip2"; + return false; + } + + + // calculate the distance between the two points based on the lattitude + // and longitude pulled out of the database. + + $miles = $this->calculate_mileage($details1['lat'], $details2['lat'], $details1['lon'], $details2['lon']); + + + + if ($this->units == _UNIT_KILOMETERS) return round($miles * _M2KM_FACTOR, $this->decimals); + else return round($miles, $this->decimals); // must be miles + + } + + + /** + * + * Lookups up a zip code and returns single array or multi-array based on sending multiple zip codes in array or just a string + * @param $zip + */ + function lookup($zip, $options = array()) { + $default_options = + array( + 'bare' => false, //set to true to strip outer Zipcode dimension + ); + $options = am($default_options, $options); + + if(is_array($zip)) { + // find all + $data = $this->find('all', array('conditions'=>array('Zipcode.zip_code'=>$zip), 'recursive' => -1)); + } else { + // find first + $data = $this->find('first', array('conditions'=>array('Zipcode.zip_code'=>$zip), 'recursive' => -1)); + } + + if($options['bare']) { + $data = $data['Zipcode']; + } + return $data; + } + + /** + * + * This returns all zip codes (even if one sent) + * @param $zip + */ + function get_zip_details($zip) { + if (!$data = $this->find('all',array('conditions'=>array('zip_code'=>$zip)))){ + return false; + } else { + return $data; + } + } + + function get_details_by_city($cityname) { + + if (!$data = $this->find('all', array('conditions'=>array('city LIKE'=>$cityname),'recursive'=>-1))) { + return false; + } else { + return $data; + } + } + + function get_details_by_lat_lon($geolocation) { + if (!$data = $this->find('all', array('conditions'=>array('lat'=>$geolocation['latitude'],'lon'=>$geolocation['longitude']),'recursive'=>-1))) { + return false; + } else { + return $data; + } + } + function get_details_by_location($locationtext) { + + if (!$data = $this->find('all', array('conditions'=>array('locationtext LIKE'=>$locationtext),'recursive'=>-1))) { + return false; + } else { + return $data; + } + } + + function get_details_by_county($county, $state_id){ + if (!$data = $this->find('all', array('conditions'=>array('county LIKE'=>$county, 'state_prefix LIKE'=>$state_id),'recursive'=>-1))) { + return false; + } else { + return $data; + } + + } + + + function get_locations_by_state($stateprefix) { + if (!$data = $this->find('all', array('conditions'=>array('state_prefix LIKE'=>$stateprefix),'recursive'=>-1,'order'=>array('zip_code'=>'asc')))){ + return false; + } else { + return $data; + } + } + + function get_locations_by_county($county) { + + if (!$data = $this->find('all', array('conditions'=>array('county LIKE'=>$county),'recursive'=>-1))){ + + return false; + } else { + return $data; + } + } + + function get_counties_by_state($stateprefix) { + + if (!$data = $this->find('all', array('fields'=>array('DISTINCT county'),'conditions'=>array('state_prefix LIKE'=>$stateprefix),'recursive'=>-1,'order'=>array('county'=>'asc')))){ + return false; + } else { + return $data; + } + } + + function get_zip_point($zip) { + + // This function pulls just the lattitude and longitude from the + // database for a given zip code. + //$sql = "SELECT lat, lon from {$this->tablePrefix}zip_code WHERE zip_code='$zip'"; + //$r = mysql_query($sql); + + if (!$data = $this->find(array('zip_code'=>$zip), array('lat', 'lon'))) { + //$this->last_error = mysql_error(); + return false; + } else { + //$row = mysql_fetch_array($r); + //mysql_free_result($r); + //var_dump($data['Zipcode']); + //return $row; + return $data['Zipcode']; + } + } + + + function calculate_mileage($lat1, $lat2, $lon1, $lon2) { + + // used internally, this function actually performs that calculation to + // determine the mileage between 2 points defined by lattitude and + // longitude coordinates. This calculation is based on the code found + // at http://www.cryptnet.net/fsp/zipdy/ + + // Convert lattitude/longitude (degrees) to radians for calculations + $lat1 = deg2rad($lat1); + $lon1 = deg2rad($lon1); + $lat2 = deg2rad($lat2); + $lon2 = deg2rad($lon2); + + // Find the deltas + $delta_lat = $lat2 - $lat1; + $delta_lon = $lon2 - $lon1; + + // Find the Great Circle distance + $temp = pow(sin($delta_lat/2.0),2) + cos($lat1) * cos($lat2) * pow(sin($delta_lon/2.0),2); + $distance = 3956 * 2 * atan2(sqrt($temp),sqrt(1-$temp)); + + return $distance; + } + + function get_zips_in_range($zip, $range, $sort=1, $include_base = true, $options = array()) { + $default_options = array('datasource' => null, 'conditions' => array()); + $options = Set::merge($default_options, $options); + + //echo 'kevin'; + // returns an array of the zip codes within $range of $zip. Returns + // an array with keys as zip codes and values as the distance from + // the zipcode defined in $zip. + //var_dump($zip,$range); + + if(is_array($zip)) { + //passing an array with zip code detail(s) known, don't need to lookup + if(isset($zip['latitude'])) { + $zip['lat'] = $zip['latitude']; + unset($zip['latitude']); + } + if(isset($zip['longitude'])) { + $zip['lon'] = $zip['longitude']; + unset($zip['longitude']); + } + $details = $zip; + } else { + $details = $this->get_zip_point($zip); // base zip details + } + + if ($details == false) return false; + + // This portion of the routine calculates the minimum and maximum lat and + // long within a given range. This portion of the code was written + // by Jeff Bearer (http://www.jeffbearer.com). This significanly decreases + // the time it takes to execute a query. My demo took 3.2 seconds in + // v1.0.0 and now executes in 0.4 seconds! Greate job Jeff! + + // Find Max - Min Lat / Long for Radius and zero point and query + // only zips in that range. + + + $lat_range = $range/69.172; + $lon_range = abs($range/(cos($details['lat']) * 69.172)); + $min_lat = number_format($details['lat'] - $lat_range, "4", ".", ""); + $max_lat = number_format($details['lat'] + $lat_range, "4", ".", ""); + $min_lon = number_format($details['lon'] - $lon_range, "4", ".", ""); + $max_lon = number_format($details['lon'] + $lon_range, "4", ".", ""); + + $return = array(); // declared here for scope + + /* $sql = "SELECT zip_code, lat, lon FROM zip_code "; + if (!$include_base) $sql .= "WHERE zip_code <> '$zip' AND "; + else $sql .= "WHERE "; + $sql .= "lat BETWEEN '$min_lat' AND '$max_lat' + AND lon BETWEEN '$min_lon' AND '$max_lon'"; */ + + $conditions = array(); + if($range === 'all') { + // don't want to have a range + // $conditions = array() + } else { + if(!$include_base) { + $conditions['zip_code'] = "<> $zip"; + } else { + $conditions['lat BETWEEN ? AND ?'] = array($min_lat, $max_lat); + $conditions['lon BETWEEN ? AND ?'] = array($min_lon, $max_lon); + } + } + + if($options['conditions']) { + $conditions = Set::merge($options['conditions'], $conditions); + } + + if($options['datasource']) { + $datasource =& ClassRegistry::init($options['datasource'], 'model'); + $data = $datasource->find('all', array('conditions' =>$conditions, 'recursive' => -1)); + + list($pluginName, $modelName) = pluginSplit($options['datasource']); + + } else { + $data = $this->find('all', array('conditions' =>$conditions)); + $pluginName = null; + $modelName = 'Zipcode'; + } + + if (!$data) { // sql error + //var_dump($data); + //$this->last_error = mysql_error(); + return false; + + } else { + //return; + /*while ($row = mysql_fetch_row($r)) { + + // loop through all 40 some thousand zip codes and determine whether + // or not it's within the specified range. + + $dist = $this->calculate_mileage($details[0],$row[1],$details[1],$row[2]); + if ($this->units == _UNIT_KILOMETERS) $dist = $dist * _M2KM_FACTOR; + if ($dist <= $range) { + $return[str_pad($row[0], 5, "0", STR_PAD_LEFT)] = round($dist, $this->decimals); + } + } + mysql_free_result($r);*/ + $zip1VarName = 'zip_code'; + $zip1 = null; + if(isset($details['zip'])) { + $zip1 = $details['zip']; + $zip1VarName = 'zip'; + } else if (isset($details['zipcode'])) { + $zip1 = $details['zipcode']; + $zip1VarName = 'zipcode'; + } else if (isset($details['zip_code'])) { + $zip1 = $details['zip_code']; + $zip1VarName = 'zip_code'; + } + + $zip2VarName = 'zip_code'; + + $dataByZip = array(); + foreach($data as $row) { + if(isset($row[$modelName]['lat']) and isset($row[$modelName]['lon'])) { + $dist = $this->calculate_mileage($details['lat'],$row[$modelName]['lat'],$details['lon'],$row[$modelName]['lon']); + } else { + $zip2 = null; + if(isset($row[$modelName]['zip'])) { + $zip2 = $row[$modelName]['zip']; + $zip2VarName = 'zip'; + } else if (isset($row[$modelName]['zipcode'])) { + $zip2 = $row[$modelName]['zipcode']; + $zip2VarName = 'zipcode'; + } else if (isset($row[$modelName]['zip_code'])) { + $zip2 = $row[$modelName]['zip_code']; + $zip2VarName = 'zip_code'; + } + + $dist = $this->get_distance($zip1, $zip2); + } + + if ($this->units == _UNIT_KILOMETERS) $dist = $dist * _M2KM_FACTOR; + if ($range === 'all' or $dist <= $range) { + $return[str_pad($row[$modelName][$zip2VarName], 5, "0", STR_PAD_LEFT)] = round($dist, $this->decimals); + $dataByZip[str_pad($row[$modelName][$zip2VarName], 5, "0", STR_PAD_LEFT)] = $row; + } + } + } + + // sort array + switch($sort) + { + case _ZIPS_SORT_BY_DISTANCE_ASC: + asort($return); + break; + + case _ZIPS_SORT_BY_DISTANCE_DESC: + arsort($return); + break; + + case _ZIPS_SORT_BY_ZIP_ASC: + ksort($return); + break; + + case _ZIPS_SORT_BY_ZIP_DESC: + krsort($return); + break; + } + + $this->zipInRangeData = $return; + + if($options['datasource']) { + //merge database results back into return (with distance calculated) + $newReturn = array(); + foreach($return as $zip => $distance) { + if(isset($dataByZip[$zip])) { + $tmp = $dataByZip[$zip]; + $tmp['distance'] = $distance; + $newReturn[] = $tmp; + + } + } + $return = $newReturn; + } + + if (empty($return)) return false; + return $return; + } + + function get_detailed_zips_in_range($zip, $range, $sort=1, $include_base = true) { + // returns an array of the zip codes within $range of $zip with their details + //var_dump($zip,$range); + + $details = $this->get_zip_point($zip); // base zip details + + if ($details == false) return false; + + // This portion of the routine calculates the minimum and maximum lat and + // long within a given range. This portion of the code was written + // by Jeff Bearer (http://www.jeffbearer.com). This significanly decreases + // the time it takes to execute a query. My demo took 3.2 seconds in + // v1.0.0 and now executes in 0.4 seconds! Greate job Jeff! + + // Find Max - Min Lat / Long for Radius and zero point and query + // only zips in that range. + $lat_range = $range/69.172; + $lon_range = abs($range/(cos($details['lat']) * 69.172)); + $min_lat = number_format($details['lat'] - $lat_range, "4", ".", ""); + $max_lat = number_format($details['lat'] + $lat_range, "4", ".", ""); + $min_lon = number_format($details['lon'] - $lon_range, "4", ".", ""); + $max_lon = number_format($details['lon'] + $lon_range, "4", ".", ""); + + $return = array(); // declared here for scope + + $conditions = array(); + $conditions['z_primary'] = 'PRIMARY'; + if(!$include_base) { + $conditions['zip_code'] = "<> $zip"; + } else { + $conditions['lat BETWEEN ? AND ?'] = array($min_lat, $max_lat); + $conditions['lon BETWEEN ? AND ?'] = array($min_lon, $max_lon); + } + + if (!$data = $this->find('all', array('conditions' =>$conditions))) { // sql error + + return false; + + } else { + foreach($data as $row) { + + $dist = $this->calculate_mileage($details['lat'],$row['Zipcode']['lat'],$details['lon'],$row['Zipcode']['lon']); + //$return['locationdetails'] = $this->find('all',array('conditions'=>array('zip_code'=>$zip))); + if ($this->units == _UNIT_KILOMETERS) $dist = $dist * _M2KM_FACTOR; + if ($dist <= $range) { + $row['Zipcode']['distance'] = round($dist, $this->decimals); + $return[] = $row; + } + } + } + + // sort array + function dist_sort($a,$b) { + //var_dump($a['Zipcode']['distance']); + if($a['Zipcode']['distance'] > $b['Zipcode']['distance']) + return 1;//here,if you return -1,return 1 below,the result will be descending + if($a['Zipcode']['distance'] < $b['Zipcode']['distance']) + return -1; + if($a['Zipcode']['distance'] == $b['Zipcode']['distance']) + return 0; + } + switch ($sort) { + case '_ZIPS_SORT_BY_DISTANCE_ASC': + //asort($return); + //var_dump('test'); + uasort($return, 'dist_sort'); + + break; + + case '_ZIPS_SORT_BY_DISTANCE_DESC': + arsort($return); + break; + } + + $this->zipInRangeData = $return; + //var_dump($return); + if (empty($return)) return false; + return $return; + } + + + /** + * Returns a flat array (e.g. 04072,03801, etc.) for SQL IN statements + * + * @return array + */ + function getZipsInRangeFlat() { + return array_keys($this->zipInRangeData); + } + + + function zipRangeOrderCase($zips = array(), $column_name = 'zip') { + + /*Order by (CASE City + WHEN 'Paris' THEN 1 + WHEN 'Chicago' THEN 2 + WHEN 'Boston' THEN 3 + WHEN 'New York' THEN 4 + WHEN 'Berkeley' THEN 5 + WHEN 'Dallas' THEN 6 + ELSE 100 END) ASC */ + $order_by = ''; + $zip_count = count($zips); + for($x=0; $x < $zip_count; $x++) { + $order_by .= " WHEN {$zips[$x]} THEN ". ($x + 1); + } + + if(!empty($order_by)) { + $order_by = "(CASE $column_name". $order_by ." ELSE 100 END) ASC"; + return $order_by; + } else { + return false; + } + + } + + /** + * + * Takes a string [from a form] + * @param $search string + * @param $options array + * return false if no zip found; or text if a single zip code or an array if multiple zip codes + */ + function findZipFromText($search, $options = array()) { + App::import('Sanitize'); + + $default_options = + array( + 'distance' => 0, + 'stateList' => array(), //supply list of states, array('SN' => 'State Name');, to use instead of full geography helper list... will increase performance if you supply a small list + 'defaultState' => Configure::read('avorders.avengerDefaultState'), //array('ME'), //an array of state abbreviations to use by default when a state isn't found + 'firstMatch' => true, //will return first zip code that matches if distance is 0 (otherwise, returns all zipcodes) + 'primary' => true, // set to false to return all zip codes, not just primary zip codes + ); + $options = am($default_options, $options); + + if(is_numeric($search)) { + //assume it's a zip code + $zip = trim($search); + $zip = substr($zip, 0, 5); //make sure it's only 5 numbers + + } else { + // searching by a string + // 1. clean/sanitize data + // 2a. see if preg_match finds a zip code in user-entered text, if so use it + // 2b. otherwise, explode on spaces, b/c each word needs can be matched, then find unique zip codes + // 3. create conditions, add in distance condition and zips in range if specified + // 4. append to join conditions + + $location_array = array(); + $location = Sanitize::paranoid($search, array(' ', ',', '.')); + $location = trim($location); + + if(preg_match("/([0-9]{5})(-[0-9]{4})?/i", $location, $match)) { + //zip code entered with text, use it + $zip = $match[0]; + } else { + App::import('Helper', 'Geography'); + $geography = new GeographyHelper(); + + $terms = array(); + $stateFound = false; + + // zip code not in text, so try to find zipcode using city, state if known + // check to see if there is a comma, if so explode on that: portsmouth, new hampshire + if(strpos($location, ',') !== false) { + $location_array = explode(',', $location); + } else { + //look for state names (not abbreviations) contained within search term + $stateAbbr = $geography->isAState($location, array('search' => true, 'list' => $options['stateList'])); // looking to see if a state is buried in this query + if($stateAbbr) { + // state found, set to state_prefix and remove from search terms (for down-the-line processing) + $stateFound = true; + $terms['Zipcode.state_prefix'] = $stateAbbr['state']; + $location = str_ireplace($stateAbbr['term'], '', $location); + $location = trim($location); + } + + // explode remaining search terms on spaces + $location_array = explode(' ', $location); + } + + $cityTerms = array(); + foreach($location_array as $term) { + + if(!$stateFound) { + $stateAbbr = $geography->isAState($term); + if($stateAbbr) { + //we know this is a state, and the 2 letter abbreviation + $terms['Zipcode.state_prefix'] = $stateAbbr; + $stateFound = true; + } else { + //not a state, must be a city, eliminated everything else + $cityTerm = $term .'%'; + if(!empty($cityTerms)) { + $cityTerm = '%'. $cityTerm; // if it's not the first word, need to allow double-sided wild card + } + $cityTerms[] = $cityTerm; + } + } else { + //state already found, these terms must be a city + $cityTerm = $term .'%'; + if(!empty($cityTerms)) { + $cityTerm = '%'. $cityTerm; // if it's not the first word, need to allow double-sided wild card + } + $cityTerms[] = $cityTerm; + } + } + + if(!empty($cityTerms)) { + if(count($cityTerms) == 1) { + $terms['Zipcode.city LIKE'] = bootArrayFirstValue($cityTerms); + } else { + $terms['AND'] = array(); + foreach($cityTerms as $term) { + $terms['AND'][] = array('Zipcode.city LIKE' => $term); + } + } + } + + //default state to ME, b/c this is originally for MyMaineTherapist + if(!isset($terms['Zipcode.state_prefix'])) { + $terms['Zipcode.state_prefix'] = $options['defaultState']; + } + + // see if we are checking for primary-only zip codes + if($options['primary']) { + $terms['Zipcode.z_primary'] = 'PRIMARY'; + } + + $zips = $this->find('all', array('conditions' => $terms, 'fields' => 'Zipcode.city, Zipcode.state_prefix, Zipcode.zip_code, Zipcode.z_primary', 'group' => 'zip_code', 'recursive' => -1)); + if($zips) { + if($options['firstMatch'] or !empty($options['distance'])) { + // only want the first zip code (if distance is specified, firstMatch is implied) + $zip = bootArrayFirstValue($zips); + $zip = isset($zip['Zipcode']['zip_code']) ? $zip['Zipcode']['zip_code'] : false; + } else { + // for multiple zip codes, you should show a list of available zip codes and allow user to pick zip code in calling function + $zip = Set::extract('/Zipcode/zip_code', $zips); + } + } + } + } + + // ADD IN DISTANCE-BASED SEARCHING + if(!empty($options['distance']) and isset($zip) and $zip) { + + if($options['distance'] == 'all') { + $distance = 'all'; + } else { + $distance = (int) $options['distance']; + $distance = ($distance > 100) ? 100 : $distance; //cap it at 100, that's a lot of zipcodes + } + + $zipsInRange = $this->get_zips_in_range($zip, $distance); + if($zipsInRange) { + $zip = array_keys($zipsInRange); + } + } + + + + if(!isset($zip) or !$zip) { + // basically, turning zipcode off, so no results will be found... + return false; + } + + return $zip; + + } + + + /** + * Performs a Web Service call to FreeGeoIP.net to get IP Whois Information + * @param string $ipaddress + * @return array $location zip, lat, long, etc. of ip address + */ + function fetchFreeGeoIpLocation($ipaddress) { + //http://freegeoip.net/{format}/{ip_or_hostname} + // create curl resource + $location = array(); + + + $ipurl = 'http://freegeoip.net/json/'.$ipaddress; + + $ch = curl_init(); + // set url + curl_setopt( $ch, CURLOPT_TIMEOUT_MS, 1500 ); + curl_setopt( $ch, CURLOPT_CONNECTTIMEOUT_MS, 1500 ); + + curl_setopt($ch, CURLOPT_URL, $ipurl); + //return the transfer as a string + curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); + // $output contains the output string + $output = curl_exec($ch); + // close curl resource to free up system resources + curl_close($ch); + if(is_string($output) and !empty($output)){ + $location = json_decode($output, true); + + if(!isset($location['zipcode']) or empty($location['zipcode'])){ + //need to find zip code based on geocoded lat/long + if(isset($location['latitude']) and !empty($location['latitude']) and isset($location['longitude']) and !empty($location['longitude'])) { + $zipcode = $this->get_zips_in_range($location, 10); //no zip code supplied, grab the one that is closest within 10 miles + if(is_array($zipcode) and !empty($zipcode)){ + $location['zipcode'] = bootArrayFirstValue(array_keys($zipcode)); + }else{ + $location['zipcode'] = '10001'; + } + } + } + + if(is_array($location) and !empty($location)) { + // change to match format from ZipCode table column names + $location['zip_code'] = $location['zipcode']; + unset($location['zipcode']); + + $location['lat'] = $location['latitude']; + unset($location['latitude']); + + $location['lon'] = $location['longitude']; + unset($location['longitude']); + + $location['state_prefix'] = $location['region_code']; + unset($location['region_code']); + + $location['country'] = $location['country_code']; + unset($location['country_code']); + + $location['locationtext'] = $location['city'].', '.$location['state_prefix']; + } + + } else { + $location = false; + } + + + return $location; + + } + + function getClosestLocation($location, $options = array()) { + $default_options = array('range' => 50); + $options = Set::merge($default_options, $options); + + if($this->hasField('active')) { + $params['conditions'] = array('AvordersStore.active'=>1); + } + return bootArrayFirstValue($this->get_zips_in_range($location, $options['range'], 1, true, null)); + } + +} \ No newline at end of file diff --git a/production/example_apps/zippy_maps/scripts/clean_mapsdemo.sh b/production/example_apps/zippy_maps/scripts/clean_mapsdemo.sh new file mode 100644 index 00000000..e2c8755e --- /dev/null +++ b/production/example_apps/zippy_maps/scripts/clean_mapsdemo.sh @@ -0,0 +1,42 @@ +#!/bin/bash + +# some code i wrote to add to revamp that turned out to be unsuitable. +# but it corrects a problem in cakelampvm v002 release that i find annoying, +# so here it is as its own file. + +# clean out some old files that were not checked in in mapsdemo. +echo Doing some git repository maintenance in fred account. +# +# change over to fred folder +pushd /home/fred +exit_on_error "changing dir to fred's home; what have you done with fred?" + +pushd apps/mapsdemo/avenger5 +exit_on_error "changing dir to mapsdemo app" + +rpuffer . &>/dev/null +if [ $? -ne 0 ]; then + # it seems our old files are still conflicting this. + if [ -f config/config_google.php ]; then + \rm -f config/config_google.php + exit_on_error "removing old config for google" + fi + if [ -f config/app.php ]; then + \rm -f config/app.php + exit_on_error "removing old config for app" + fi + + git reset --hard HEAD + exit_on_error "resetting git's hard head" + + rpuffer . +#hmmm: use output saver thing when that exists. + exit_on_error "puffing out mapsdemo app after inadequate corrective action was taken" +fi + +popd + +popd +#...coolness, if we got to here. + + diff --git a/production/example_apps/zippy_maps/scripts/launch_local_cake.sh b/production/example_apps/zippy_maps/scripts/launch_local_cake.sh new file mode 100644 index 00000000..09e2cb51 --- /dev/null +++ b/production/example_apps/zippy_maps/scripts/launch_local_cake.sh @@ -0,0 +1,13 @@ +#!/bin/bash + +THIS_FOLDER="$( \cd "$(\dirname "$0")" && /bin/pwd )" +pushd $THIS_FOLDER/.. + +# does this help? +export DEBUG=true + +./bin/cake server -p 8765 + +popd + + diff --git a/production/example_apps/zippy_maps/scripts/launch_serene_cake.sh b/production/example_apps/zippy_maps/scripts/launch_serene_cake.sh new file mode 100644 index 00000000..c5c79a84 --- /dev/null +++ b/production/example_apps/zippy_maps/scripts/launch_serene_cake.sh @@ -0,0 +1,13 @@ +#!/bin/bash + +THIS_FOLDER="$( \cd "$(\dirname "$0")" && /bin/pwd )" +pushd $THIS_FOLDER/.. + +# does this help? +export DEBUG=true + +./bin/cake server -H 192.241.191.154 -p 12738 + +popd + + diff --git a/production/example_apps/zippy_maps/scripts/prepare_project.sh b/production/example_apps/zippy_maps/scripts/prepare_project.sh new file mode 100644 index 00000000..dfaf24ad --- /dev/null +++ b/production/example_apps/zippy_maps/scripts/prepare_project.sh @@ -0,0 +1,42 @@ +#!/bin/bash + +#hmmm: test this and make sure it's still right. +#hmmm: also test that it's inclusive of all the necessary steps for success. + +#hmmm: aha, this is definitely missing the necessary link creations still. + + +# bails if any step fails. +function check_result() { + if [ $? -ne 0 ]; then + echo -e "failed on: $*" + error_sound + exit 1 + fi +} + +THIS_FOLDER="$( \cd "$(\dirname "$0")" && /bin/pwd )" +pushd $THIS_FOLDER/.. + +echo running composer update process... +composer update +check_result "updating project with composer" + +echo -e "\n\nHave the two config files app.php and config_google.php been configured yet AND has the database for the app been added to mysql? (y/N)" +read line + +if [ $line != 'y' -a $line != 'Y' -a $line != 'yes' -a $line != 'YES' ]; then + echo "Please configure the two config files using their default versions as templates (see the config directory for app.default.php and config_google.default.php)" + exit 1 +fi + +echo running migration code to build the database... +./bin/cake migrations migrate +check_result "running the database migrations" + +echo making asset symlinks +./bin/cake plugin assets symlink +check_result "symlinking web assets" + + + diff --git a/production/example_apps/zippy_maps/src/Application.php b/production/example_apps/zippy_maps/src/Application.php new file mode 100644 index 00000000..9c5999b8 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Application.php @@ -0,0 +1,52 @@ +add(ErrorHandlerMiddleware::class) + + // Handle plugin/theme assets like CakePHP normally does. + ->add(AssetMiddleware::class) + + // Apply routing + ->add(RoutingMiddleware::class); + + return $middleware; + } +} diff --git a/production/example_apps/zippy_maps/src/Console/Installer.php b/production/example_apps/zippy_maps/src/Console/Installer.php new file mode 100644 index 00000000..0756096c --- /dev/null +++ b/production/example_apps/zippy_maps/src/Console/Installer.php @@ -0,0 +1,195 @@ +getIO(); + + $rootDir = dirname(dirname(__DIR__)); + + static::createAppConfig($rootDir, $io); + static::createWritableDirectories($rootDir, $io); + + // ask if the permissions should be changed + if ($io->isInteractive()) { + $validator = function ($arg) { + if (in_array($arg, ['Y', 'y', 'N', 'n'])) { + return $arg; + } + throw new Exception('This is not a valid answer. Please choose Y or n.'); + }; + $setFolderPermissions = $io->askAndValidate( + 'Set Folder Permissions ? (Default to Y) [Y,n]? ', + $validator, + 10, + 'Y' + ); + + if (in_array($setFolderPermissions, ['Y', 'y'])) { + static::setFolderPermissions($rootDir, $io); + } + } else { + static::setFolderPermissions($rootDir, $io); + } + + static::setSecuritySalt($rootDir, $io); + + if (class_exists('\Cake\Codeception\Console\Installer')) { + \Cake\Codeception\Console\Installer::customizeCodeceptionBinary($event); + } + } + + /** + * Create the config/app.php file if it does not exist. + * + * @param string $dir The application's root directory. + * @param \Composer\IO\IOInterface $io IO interface to write to console. + * @return void + */ + public static function createAppConfig($dir, $io) + { + $appConfig = $dir . '/config/app.php'; + $defaultConfig = $dir . '/config/app.default.php'; + if (!file_exists($appConfig)) { + copy($defaultConfig, $appConfig); + $io->write('Created `config/app.php` file'); + } + } + + /** + * Create the `logs` and `tmp` directories. + * + * @param string $dir The application's root directory. + * @param \Composer\IO\IOInterface $io IO interface to write to console. + * @return void + */ + public static function createWritableDirectories($dir, $io) + { + $paths = [ + 'logs', + 'tmp', + 'tmp/cache', + 'tmp/cache/models', + 'tmp/cache/persistent', + 'tmp/cache/views', + 'tmp/sessions', + 'tmp/tests' + ]; + + foreach ($paths as $path) { + $path = $dir . '/' . $path; + if (!file_exists($path)) { + mkdir($path); + $io->write('Created `' . $path . '` directory'); + } + } + } + + /** + * Set globally writable permissions on the "tmp" and "logs" directory. + * + * This is not the most secure default, but it gets people up and running quickly. + * + * @param string $dir The application's root directory. + * @param \Composer\IO\IOInterface $io IO interface to write to console. + * @return void + */ + public static function setFolderPermissions($dir, $io) + { + // Change the permissions on a path and output the results. + $changePerms = function ($path, $perms, $io) { + // Get permission bits from stat(2) result. + $currentPerms = fileperms($path) & 0777; + if (($currentPerms & $perms) == $perms) { + return; + } + + $res = chmod($path, $currentPerms | $perms); + if ($res) { + $io->write('Permissions set on ' . $path); + } else { + $io->write('Failed to set permissions on ' . $path); + } + }; + + $walker = function ($dir, $perms, $io) use (&$walker, $changePerms) { + $files = array_diff(scandir($dir), ['.', '..']); + foreach ($files as $file) { + $path = $dir . '/' . $file; + + if (!is_dir($path)) { + continue; + } + + $changePerms($path, $perms, $io); + $walker($path, $perms, $io); + } + }; + + $worldWritable = bindec('0000000111'); + $walker($dir . '/tmp', $worldWritable, $io); + $changePerms($dir . '/tmp', $worldWritable, $io); + $changePerms($dir . '/logs', $worldWritable, $io); + } + + /** + * Set the security.salt value in the application's config file. + * + * @param string $dir The application's root directory. + * @param \Composer\IO\IOInterface $io IO interface to write to console. + * @return void + */ + public static function setSecuritySalt($dir, $io) + { + $config = $dir . '/config/app.php'; + $content = file_get_contents($config); + + $newKey = hash('sha256', Security::randomBytes(64)); + $content = str_replace('__SALT__', $newKey, $content, $count); + + if ($count == 0) { + $io->write('No Security.salt placeholder to replace.'); + + return; + } + + $result = file_put_contents($config, $content); + if ($result) { + $io->write('Updated Security.salt value in config/app.php'); + + return; + } + $io->write('Unable to update Security.salt value.'); + } +} diff --git a/production/example_apps/zippy_maps/src/Controller/AppController.php b/production/example_apps/zippy_maps/src/Controller/AppController.php new file mode 100644 index 00000000..7483724e --- /dev/null +++ b/production/example_apps/zippy_maps/src/Controller/AppController.php @@ -0,0 +1,71 @@ +loadComponent('Security');` + * + * @return void + */ + public function initialize() + { + parent::initialize(); + + $this->loadComponent('RequestHandler'); + $this->loadComponent('Flash'); + + /* + * Enable the following components for recommended CakePHP security settings. + * see http://book.cakephp.org/3.0/en/controllers/components/security.html + */ + //$this->loadComponent('Security'); + //$this->loadComponent('Csrf'); + } + + /** + * Before render callback. + * + * @param \Cake\Event\Event $event The beforeRender event. + * @return \Cake\Network\Response|null|void + */ + public function beforeRender(Event $event) + { + if (!array_key_exists('_serialize', $this->viewVars) && + in_array($this->response->type(), ['application/json', 'application/xml']) + ) { + $this->set('_serialize', true); + } + } + + + +} diff --git a/production/example_apps/zippy_maps/src/Controller/CategoriesController.php b/production/example_apps/zippy_maps/src/Controller/CategoriesController.php new file mode 100644 index 00000000..eeacbad8 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Controller/CategoriesController.php @@ -0,0 +1,423 @@ +loadComponent('RequestHandler'); + + // configure the request handler to deal with json encoding. + $this->RequestHandler->config('inputTypeMap.json', ['json_decode', true]); + + $this->api_key = SimpleMapsComponent::getGoogleAPIKey(); + + // allow simple access to location db. + $this->loadModel ( 'Locations' ); + + } + + + + /** + * Index method + * + * @return \Cake\Network\Response|null + */ + public function index() + { + $categories = $this->paginate($this->Categories); + + $this->set(compact('categories')); + $this->set('_serialize', ['categories']); + } + + /** + * View method + * + * @param string|null $id Category id. + * @return \Cake\Network\Response|null + * @throws \Cake\Datasource\Exception\RecordNotFoundException When record not found. + */ + public function view($id = null) + { + $category = $this->Categories->get($id, [ + 'contain' => ['Locations'] + ]); + + $this->set('category', $category); + $this->set('_serialize', ['category']); + + // query all the locations belonging to this category but only retrieve part of the info. + $locationBits = $this->Categories->CategoriesLocations->find('list', [ + 'conditions' => [ 'category_id' => $id ], + 'contain' => ['Locations'], + 'valueField' => function ($row) { + return $row->location->get('lat') + . ',' . $row->location->get('lng') + . ' ' . $row->location->get('location'); + } + ]); + $this->set('locationBits', $locationBits); + } + + /** + * queries the locations to display on a map given an "id" to lookup in categories table. + */ + public function map($id = null) + { + $category = $this->Categories->get($id, [ + 'contain' => ['Locations'] + ]); + + $locationsFound = $this->Categories->getLocationsInCategory($id); + $this->set('locationsInCategory', $locationsFound); + + // grab the flags in requests. + $parms = $this->request->getQueryParams(); + + // we will cluster by default, but they can also pass the clustering flag with 0 or 1. + $clustering = (array_key_exists('clustering', $parms) && ($parms['clustering'] == '1')) + || !array_key_exists('clustering', $parms); + //Log::Debug('clustering is: ' . var_export($clustering, true)); + + // set up the selected items in our config chooser. + $selectedList = []; + if ($clustering) { + array_push($selectedList, 'clustering'); + } + $this->set('selectedList', $selectedList); + + // pass the pre-loading function in for the map element. + $this->set('dbProcessor', $this); + $this->set('preloader', '$this->MapDisplay->addMarkers($dbProcessor, $locationsInCategory, $category );'); + + if ($this->request->is(['post', 'put'])) { + //, 'patch'])) { + $postData = $this->request->getData('view_options')['_ids']; + + $new_clustering = is_array($postData) && in_array('clustering', $postData); + + if ($clustering != $new_clustering) { + $this->redirect(['action' => 'map', + '0' => $id, + '?' => [ + 'clustering' => $new_clustering, + ] + ]); + } + } + + $this->set('category', $category); + +// $this->set('_serialize', ['category']); + } + + /** + * processes a location row by extracting the important information into an array. + * separates the db structure from the pieces needed for google maps. + */ + public function processRow(& $location_row) + { + return [ + 'lat' => $location_row ['location'] ['lat'], + 'lng' => $location_row ['location'] ['lng'], + 'title' => $location_row ['location'] ['name'], + // kludge below adds extra space on content, since someone is not left justifying these. + 'content' => h ( $location_row ['location'] ['location'] ) . ' ', + ]; + } + + public function extractCategoryImage(& $category) + { + return $category->image; + } + + + /** + * attempts to jump to the center of the category, given a particular interpretation of the + * category. if possible we will decide that the category is a state name, and then attempt + * to jump to the center of that state. + * will also show markers in the category. + */ + public function center($id = null) + { + $category = $this->Categories->get($id, [ + 'contain' => ['Locations'] + ]); + + // grab the flags in requests. + $parms = $this->request->getQueryParams(); + + // we will cluster by default, but they can also pass the clustering flag with 0 or 1. + $clustering = (array_key_exists('clustering', $parms) && ($parms['clustering'] == '1')) + || !array_key_exists('clustering', $parms); + //Log::Debug('clustering is: ' . var_export($clustering, true)); + + // set up the selected items in our config chooser. + $selectedList = []; + if ($clustering) { + array_push($selectedList, 'clustering'); + } + $this->set('selectedList', $selectedList); + + $state = null; + // interpret the category name as a state if possible. + if (substr($category->name, 0, 3) == 'US-') { + // bingo, we have a US prefix on the string, so decide what state they mean. + $state = substr($category->name, 3, 2); + + } + // perform the lookup to get the readable name. otherwise a state like indiana (IN) will + // not get geocoded properly. probably others as well. + $state = SimpleMapsComponent::lookupStateFromAbbreviation($state); + + $this->set('state', $state); + + Log::debug('state was found as: ' . $state); + + if ($state !== null) { + $centeredPoint = SimpleMapsComponent::geocode($state . " USA", [ + 'key' => $this->api_key + ]); + $mapCenter = [ 'lat' => $centeredPoint[0], 'lng' => $centeredPoint[1] ] ; + $this->set('mapCenter', $mapCenter); + Log::Debug('computed a map center of: ' . var_export($mapCenter, true)); + } + + + // thoughts on algorithm: is the center of the state according to google what we want to rely on? + // we could at least start there, record the lat/longs and then edit them later as we decide. + + $radius = null; + $lat = null; + $long = null; + if ($mapCenter) { + $radius = 40; // miles from center to show markers. + $lat = $mapCenter['lat']; + $long = $mapCenter['lng']; + } + + Log::Debug('given lat=' . $lat . ' long='. $long . ' radius=' . $radius); + + Log::Debug('loading locations in category within radius'); + + // compute the lat/long bounding box for our search. + $bounds = SimpleMapsComponent::calculateLatLongBoundingBox ( $lat, $long, $radius ); + + if (! $bounds) { + Log::Debug("failed to calculate the bounding box!"); + } else { + Log::Debug("bounding box: " . var_export($bounds, true)); + } + + // query all the locations belonging to this category within the box. + $locationsInCategory = $this->Categories->getLocationsInCategoryInBox($id, + $bounds [0], $bounds [1], $bounds [2], $bounds [3] ); + + $this->set('locationsInCategory', $locationsInCategory); + + $this->set('dbProcessor', $this); + $this->set('preloader', '$this->MapDisplay->addMarkers($dbProcessor, $locationsInCategory, $category );'); + + if ($this->request->is(['post', 'put'])) { + //, 'patch'])) { + $postData = $this->request->getData('view_options')['_ids']; + + $new_clustering = is_array($postData) && in_array('clustering', $postData); + + if ($clustering != $new_clustering) { + $this->redirect(['action' => 'map', + '0' => $id, + '?' => [ + 'clustering' => $new_clustering, + ] + ]); + } + } + + $this->set('category', $category); +// $this->set('_serialize', ['category','selectedList']); + } + + /** + * Add method + * + * @return \Cake\Network\Response|null Redirects on successful add, renders view otherwise. + */ + public function add() + { + $category = $this->Categories->newEntity(); + if ($this->request->is('post')) { + $category = $this->Categories->patchEntity($category, $this->request->getData()); + if ($this->Categories->save($category)) { + $this->Flash->success(__('The category has been saved.')); + + return $this->redirect(['action' => 'index']); + } + $this->Flash->error(__('The category could not be saved. Please, try again.')); + } + $this->set(compact('category')); + $this->set('_serialize', ['category']); + } + + /** + * Edit method + * + * @param string|null $id Category id. + * @return \Cake\Network\Response|null Redirects on successful edit, renders view otherwise. + * @throws \Cake\Network\Exception\NotFoundException When record not found. + */ + public function edit($id = null) + { + $category = $this->Categories->get($id, [ + 'contain' => [] + ]); + if ($this->request->is(['patch', 'post', 'put'])) { + $category = $this->Categories->patchEntity($category, $this->request->getData()); + if ($this->Categories->save($category)) { + $this->Flash->success(__('The category has been saved.')); + + return $this->redirect(['action' => 'index']); + } + $this->Flash->error(__('The category could not be saved. Please, try again.')); + } + $this->set(compact('category')); + $this->set('_serialize', ['category']); + } + + /** + * Delete method + * + * @param string|null $id Category id. + * @return \Cake\Network\Response|null Redirects to index. + * @throws \Cake\Datasource\Exception\RecordNotFoundException When record not found. + */ + public function delete($id = null) + { + $this->request->allowMethod(['post', 'delete']); + $category = $this->Categories->get($id); + if ($this->Categories->delete($category)) { + $this->Flash->success(__('The category has been deleted.')); + } else { + $this->Flash->error(__('The category could not be deleted. Please, try again.')); + } + + return $this->redirect(['action' => 'index']); + } + + /** + * provides ajax friendly responses. expects to be passed 'category' in post data. + * requires bounding box for lookup be passed as 'sw_lat', 'sw_lng', 'ne_lat', 'ne_lng'. + */ + public function lookupajax() + { + $reqData = $this->request->getData(); + + Log::Debug('got to lookup with data: ' . var_export($reqData, true)); + + // check that this is a post method, since we don't support anything else. + if (! $this->request->is(['post'])) { + die('this is a post method'); + } + + if (array_key_exists('action', $reqData)) { + $action = $reqData['action']; + + if (strcasecmp($action, 'lookupBox') == 0) { + $this->findLocationsInCategoryWithinBounds($reqData); + } else if (strcasecmp($action, 'getInfo') == 0) { + $this->getInfoOnLocation($reqData); + } else { + die('lookupajax call was given unknown action: ' . $action); + } + + } else { + die('lookupajax call has no action specified'); + } + } + + public function findLocationsInCategoryWithinBounds($reqData) + { + if (array_key_exists('category', $reqData)) { + $id = $reqData['category']; + } else { + // throw an exception here? + $message = 'failed to find category id in request data'; + Log::Debug($message); + die($message); + } + + $category = $this->Categories->get($id, [ + 'contain' => ['Locations'] + ]); + $this->set('category', $category); + + if (array_key_exists('sw_lat', $reqData)) { + $sw_lat = $reqData['sw_lat']; + } + if (array_key_exists('sw_lng', $reqData)) { + $sw_lng = $reqData['sw_lng']; + } + if (array_key_exists('ne_lat', $reqData)) { + $ne_lat = $reqData['ne_lat']; + } + if (array_key_exists('ne_lng', $reqData)) { + $ne_lng = $reqData['ne_lng']; + } + + //temp! fails over to using whole range. + if ($sw_lat === null) { $sw_lat = -90; } + if ($sw_lng === null) { $sw_lng = -180; } + if ($ne_lat === null) { $ne_lat = 90; } + if ($ne_lng === null) { $ne_lng = 180; } + + $start = null; + if (array_key_exists('start', $reqData)) { + $start = $reqData['start']; + } + $end = null; + if (array_key_exists('end', $reqData)) { + $end = $reqData['end']; + } + + // lookup the locations inside that box and store for view. + $locationsToSerialize = $this->Categories->getChewedLocationsInCategoryInBox($id, $sw_lat, $sw_lng, $ne_lat, $ne_lng, $start, $end); + //Log::debug('before encoding, php array looks like: ' . var_export($locationsToSerialize, true)); + Log::Debug("returning json now..."); + $encoded = json_encode($locationsToSerialize); + // Log::debug('encoded json is: ' . var_export($encoded, true)); + die($encoded); + } + + public function getInfoOnLocation($reqData) + { + if (array_key_exists('id', $reqData)) { + $id = $reqData['id']; + } else { + // throw an exception here? + $message = 'failed to find location id in request data'; + Log::Debug($message); + die($message); + } + + $location = $this->Locations->get($id, [ + ]); + return die(json_encode($location)); + } +} diff --git a/production/example_apps/zippy_maps/src/Controller/Component/empty b/production/example_apps/zippy_maps/src/Controller/Component/empty new file mode 100644 index 00000000..e69de29b diff --git a/production/example_apps/zippy_maps/src/Controller/ErrorController.php b/production/example_apps/zippy_maps/src/Controller/ErrorController.php new file mode 100644 index 00000000..cf0ebd5b --- /dev/null +++ b/production/example_apps/zippy_maps/src/Controller/ErrorController.php @@ -0,0 +1,68 @@ +loadComponent('RequestHandler'); + } + + /** + * beforeFilter callback. + * + * @param \Cake\Event\Event $event Event. + * @return \Cake\Network\Response|null|void + */ + public function beforeFilter(Event $event) + { + } + + /** + * beforeRender callback. + * + * @param \Cake\Event\Event $event Event. + * @return \Cake\Network\Response|null|void + */ + public function beforeRender(Event $event) + { + parent::beforeRender($event); + + $this->viewBuilder()->setTemplatePath('Error'); + } + + /** + * afterFilter callback. + * + * @param \Cake\Event\Event $event Event. + * @return \Cake\Network\Response|null|void + */ + public function afterFilter(Event $event) + { + } +} diff --git a/production/example_apps/zippy_maps/src/Controller/LocationsController.php b/production/example_apps/zippy_maps/src/Controller/LocationsController.php new file mode 100644 index 00000000..4068be31 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Controller/LocationsController.php @@ -0,0 +1,530 @@ +loadComponent ( 'Avmaps.SimpleMaps' ); + $this->loadModel ( 'Categories' ); + + $this->api_key = SimpleMapsComponent::getGoogleAPIKey (); + } + + /** + * Index method + * + * @return \Cake\Network\Response|null + */ + public function index() { + $locations = $this->paginate ( $this->Locations, [ + 'contain' => 'Categories' + ] ); + $this->set ( compact ( 'locations' ) ); + $this->set ( '_serialize', [ + 'locations' + ] ); + } + + /** + * sets two variables for the view: 'categoriesList' with *all* the category names that exist and + * 'selectedList' with the categories associated with the location 'id'. + * + * @param int $id + */ + public function loadAssociatedCategories($id) { + // find all of the categories available. + $this->set ( 'categoriesList', $this->Categories->getAllCategories()); + + // turn the chosen categories into a list of category ids for the multi-select. + $selectedCategories = $this->Locations->getSelectedCategories($id); + $selectedList = array_keys ( $selectedCategories->toArray () ); + $this->set ( 'selectedList', $selectedList ); + } + + /** + * calculates the set of locations within a certain range from a starting point and returns the + * full set. + */ + public function loadLocationsInRange($lat, $long, $radius) { + Log::debug ( 'into ranged locations calculator' ); + + // compute the lat/long bounding box for our search. + $bounds = SimpleMapsComponent::calculateLatLongBoundingBox ( $lat, $long, $radius ); + + if (! $bounds) { + Log::debug ( "failed to calculate the bounding box!" ); + } else { + Log::debug ( "bounding box: " . var_export ( $bounds, true ) ); + } + + // use the boundaries to restrict the lookup so we aren't crushed. + // order: min_lat, min_long, max_lat, max_long. + $locationsInRange = $this->Locations->getLocationsInBox($bounds [0], $bounds [1], $bounds [2], $bounds [3]); + + // heavy! + // Log::debug('got a list of locations: ' + var_export($locationsInRange->toArray(), true)); + + $this->set ( 'locationsInRange', $locationsInRange ); + } + + /** + * View method + * + * @param string|null $id + * Location id. + * @return \Cake\Network\Response|null + * @throws \Cake\Datasource\Exception\RecordNotFoundException When record not found. + */ + public function view($id = null) { + $location = $this->Locations->get ( $id, [ + 'contain' => [ + 'Categories' + ] + ] ); + + $this->loadAssociatedCategories ( $id ); + + $this->set ( 'api_key', $this->api_key ); + + $this->set ( 'location', $location ); + $this->set ( '_serialize', [ + 'location' + ] ); + } + + /** + * Add method + * + * @return \Cake\Network\Response|null Redirects on successful add, renders view otherwise. + */ + public function add() { + $location = $this->Locations->newEntity (); + + $categoriesList = $this->Categories->find ( 'list', [ + 'keyField' => 'id', + 'valueField' => 'name' + ] ); + $this->set ( 'categoriesList', $categoriesList ); + + if ($this->request->is ( 'post' )) { + $location = $this->Locations->patchEntity ( $location, $this->request->getData () ); + + Log::debug ("patching with " . var_export($location, true) ); + + $location = $this->SimpleMaps->fillInGeoPosition ( $location, [ + 'key' => $this->api_key + ] ); + + if ($location !== false && $this->Locations->save ( $location )) { + $this->Flash->success ( __ ( 'The location has been saved.' ) ); + + return $this->redirect ( [ + 'action' => 'index' + ] ); + } + $this->Flash->error ( __ ( 'The location could not be saved. Please, try again.' ) ); + } + + $this->set ( compact ( 'location' ) ); + $this->set ( '_serialize', [ + 'location' + ] ); + } + + /** + * Edit method + * + * @param string|null $id + * Location id. + * @return \Cake\Network\Response|null Redirects on successful edit, renders view otherwise. + * @throws \Cake\Network\Exception\NotFoundException When record not found. + */ + public function edit($id = null) { + $location = $this->Locations->get ( $id, [ + 'contain' => [ + 'Categories' + ] + ] ); + + $this->loadAssociatedCategories ( $id ); + + if ($this->request->is ( [ + 'patch', + 'post', + 'put' + ] )) { + $location = $this->Locations->patchEntity ( $location, $this->request->getData () ); + + $new_location = $this->SimpleMaps->fillInGeoPosition ( $location, [ + 'key' => $this->api_key + ] ); + if ($new_location === false) { + $this->Flash->error ( __ ( 'The location could not be geocoded. Please, try again.' ) ); + } else { + $location = $new_location; + if ($this->Locations->save ( $location )) { + $this->Flash->success ( __ ( 'The location has been saved.' ) ); + return $this->redirect ( [ + 'action' => 'index' + ] ); + } + $this->Flash->error ( __ ( 'The location could not be saved. Please, try again.' ) ); + } + } + $this->set ( compact ( 'location' ) ); + $this->set ( '_serialize', [ + 'location' + ] ); + } + + /** + * Delete method + * + * @param string|null $id + * Location id. + * @return \Cake\Network\Response|null Redirects to index. + * @throws \Cake\Datasource\Exception\RecordNotFoundException When record not found. + */ + public function delete($id = null) { + $this->request->allowMethod ( [ + 'post', + 'delete' + ] ); + $location = $this->Locations->get ( $id ); + if ($this->Locations->delete ( $location )) { + $this->Flash->success ( __ ( 'The location has been deleted.' ) ); + } else { + $this->Flash->error ( __ ( 'The location could not be deleted. Please, try again.' ) ); + } + + return $this->redirect ( [ + 'action' => 'index' + ] ); + } + + + // global locations list, loaded once per object creation. + private $locationsListGlobal = null; + + /** + * generates a random list of locations with a limited number of items. + */ + public function grabLocationsList() + { + if ($this->locationsListGlobal) + return $this->locationsListGlobal; + + /* + * load up a list of randomly chosen locations for the selection lists. we will keep this + * around if possible, rather than reloading per page view. + */ + $this->locationsListGlobal = $this->Locations->find ( 'list', [ + 'keyField' => 'id', + 'valueField' => 'name' + ] )->limit ( 1000 )->order ( 'rand()' )->toArray (); + + // $Log::debug('got a result array: ' . var_export($this->locationsListGlobal, true)); + + return $this->locationsListGlobal; + } + + /** + * adds an item to the location list to ensure a user will not see their previous choice disappear. + */ + public function addLocationToHeldList($id, $entry) { + $this->locationsListGlobal [$id1] = $entry; + } + + + /** + * calculate the distance between two locations in the db. + * will allow picking if one or both + * location ids are missing. + */ + public function distance($id1 = null, $id2 = null) { + // pretty kludgy approach here; don't yet know how to make the form refresh + // without reloading it, but reloading it clears the selections. so we're redirecting + // the form to itself but with the id parameters filled in. + + // process the parameters, if any were provided. + $this->set ( 'fromId', $id1 ); + $this->set ( 'toId', $id2 ); + + // load the actual location info if they specified the ids already. + if ($id1 !== null) { + $this->set ( 'fromAddress', $this->Locations->get ( $id1 ) ['location'] ); + $fromGeoCoord = $this->Locations->get ( $id1 ) ['lat'] . ',' . $this->Locations->get ( $id1 ) ['lng']; + // ensure it's in our global list also, or it won't get selected. + $this->addLocationToHeldList($id1, $this->Locations->get ( $id1 ) ['name']); + } else { + $this->set ( 'fromAddress', null ); + } + if ($id2 !== null) { + $this->set ( 'toAddress', $this->Locations->get ( $id2 ) ['location'] ); + $toGeoCoord = $this->Locations->get ( $id2 ) ['lat'] . ',' . $this->Locations->get ( $id2 ) ['lng']; + ; + // add to our global list for selection. + $this->addLocationToHeldList($id2, $this->Locations->get ( $id2 ) ['name']); + } else { + $this->set ( 'toAddress', null ); + } + + if ($id1 === null || $id2 === null) { + // set default value for distance. + $distance = 'unknown'; + } else { + // calculate distance between locations. + $distance = $this->SimpleMaps->calculateDrivingDistance ( $fromGeoCoord, $toGeoCoord, [ + 'key' => $this->api_key + ] ); + // $this->Flash->log ( 'distance calculated is ' . $distance ); + if ($distance === false) { + // failed to calculate this, so we let the user know. + $distance = "Unable to calculate a route using Google Maps Distance Matrix"; + } + } + // store in distance calculated variable. + $this->set ( 'distanceCalculated', $distance ); + + // load up the selection lists for from and to addresses. + $this->set ( 'locationsFrom', $this->grabLocationsList()); + $this->set ( 'locationsTo', $this->grabLocationsList() ); + + if ($this->request->is ( 'post' )) { + $datapack = $this->request->getData (); + + $fromId = $datapack ['from'] ['_ids']; + $this->Flash->log ( h ( 'from id is ' . $fromId ) ); + $toId = $datapack ['to'] ['_ids']; + $this->Flash->log ( h ( 'to id is ' . $toId ) ); + + $fromGeoCoord = $this->Locations->get ( $fromId ) ['lat'] . ',' . $this->Locations->get ( $fromId ) ['lng']; + + $this->Flash->log ( 'from coord is ' . $fromGeoCoord ); + $toGeoCoord = $this->Locations->get ( $toId ) ['lat'] . ',' . $this->Locations->get ( $toId ) ['lng']; + ; + $this->Flash->log ( 'to coord is ' . $toGeoCoord ); + + // how to make the form show the same data but with updated distance? + // currently kludged... + return $this->redirect ( [ + 'action' => 'distance', + $fromId, + $toId + ] ); + } + } + + /** + * finds all the locations within a given radius (in miles) from the location with 'id'. + */ + public function radius($id = null, $radius = 20) { + Log::debug ( 'into the radius method in controller...' ); + + $this->set ( 'id', $id ); + if ($id != null) { + $this->set ( 'fromAddress', $this->Locations->get ( $id ) ['location'] ); + $fromLat = $this->Locations->get ( $id ) ['lat']; + $this->set ( 'fromLat', $fromLat ); + $fromLong = $this->Locations->get ( $id ) ['lng']; + $this->set ( 'fromLong', $fromLong ); + } + + if ($this->request->is ( 'post' )) { + + $datapack = $this->request->getData (); + + // look for approximate array index. + Log::debug ( 'got datapack: ' . var_export ( $datapack, true ) ); + foreach ( $datapack as $key => $value ) { + if ("radius" == substr ( $key, 0, 6 )) { + $radius = $value; + } + } + } + + $this->set ( 'radius', $radius ); + + $this->set('dbProcessor', $this); + $this->set('preloader', '$this->MapDisplay->addMarkers($dbProcessor, $locationsInRange, null, $radius, $fromLat . \',\'. $fromLong);'); + + $this->loadLocationsInRange ( $fromLat, $fromLong, $radius ); + } + +//hmmm: the below should be listed in an interface. + /** + * processes a location row by extracting the important information into an array. + * separates the db structure from the pieces needed for google maps. + */ + public function processRow(& $location_row) + { + return [ + 'lat' => $location_row ['lat'], + 'lng' => $location_row ['lng'], + 'title' => $location_row ['name'], + // kludge below adds extra space on content, since someone is not left justifying these. + 'content' => h ( $location_row ['location'] ) . ' ', + ]; + } + + public function extractCategoryImage(& $category) + { + return $category->image; + } + + + /** + * jumps to a particular location as the center of the map and shows locations nearby. + */ + public function jump($id) { + Log::debug ( 'into the jump method in locations controller...' ); + + $this->set ( 'id', $id ); + if ($id != null) { + $fromLat = $this->Locations->get ( $id ) ['lat']; + $this->set ( 'fromLat', $fromLat ); + $fromLong = $this->Locations->get ( $id ) ['lng']; + $this->set ( 'fromLong', $fromLong ); + } + + $locationsInRange = $this->Locations->find ( 'all', [ + 'conditions' => [ + 'id' => $id + ] + ] ); + + // we were handed a list of locations that match our query, so we can now add them as markers. + $this->set('dbProcessor', $this); + $this->set('preloader', '$this->MapDisplay->addMarkers($dbProcessor, $locationsInRange, null, 1000, $fromLat . \',\'. $fromLong);'); + + + // heavy! + // Log::debug('got a list of locations: ' + var_export($locationsInRange->toArray(), true)); + + $this->set ( 'locationsInRange', $locationsInRange ); + } + + /** + * provides restful api for looking up locations within two lat/long boundaries. + */ + public function lookupajax() { + Log::debug ( 'into lookupajax method in locations controller...' ); + + $reqData = $this->request->getData (); + + Log::Debug ( 'got to locations lookup with data: ' . var_export ( $reqData, true ) ); + + // check that this is a post method, since we don't support anything else. + if (! $this->request->is ( [ + 'post' + ] )) { + die ( 'this is a post method' ); + } + + + if (array_key_exists('action', $reqData)) { + $action = $reqData['action']; + + if (strcasecmp($action, 'lookupBox') == 0) { + $this->findLocationsWithinBounds($reqData); + } else if (strcasecmp($action, 'getInfo') == 0) { + $this->getInfoOnLocation($reqData); + } else { + die('lookupajax call was given unknown action: ' . $action); + } + + } else { + die('lookupajax call has no action specified'); + } + } + + public function findLocationsWithinBounds($reqData) + { + if (array_key_exists ( 'sw_lat', $reqData )) { + $sw_lat = $reqData ['sw_lat']; + } + if (array_key_exists ( 'sw_lng', $reqData )) { + $sw_lng = $reqData ['sw_lng']; + } + if (array_key_exists ( 'ne_lat', $reqData )) { + $ne_lat = $reqData ['ne_lat']; + } + if (array_key_exists ( 'ne_lng', $reqData )) { + $ne_lng = $reqData ['ne_lng']; + } + + if (array_key_exists ( 'radius', $reqData )) { + $radius = $reqData ['radius']; + } + + $start = null; + if (array_key_exists('start', $reqData)) { + $start = $reqData['start']; + } + $end = null; + if (array_key_exists('end', $reqData)) { + $end = $reqData['end']; + } + + // temp! fails over to using whole range. + if ($sw_lat === null) { + $sw_lat = - 90; + } + if ($sw_lng === null) { + $sw_lng = - 180; + } + if ($ne_lat === null) { + $ne_lat = 90; + } + if ($ne_lng === null) { + $ne_lng = 180; + } + + // lookup the locations inside that box and store for view. + $locationsToSerialize = $this->Locations->getChewedLocationsInBox($sw_lat, $sw_lng, $ne_lat, $ne_lng, $start, $end); + Log::debug('db found ' . sizeof($locationsToSerialize) . ' rows for query (' . $start . '-' . $end . ')'); + + // simple implementation here since cakephp v3.4 was doing weird stuff instead of returning object we chose to serialize. + // ajax method would consistently return the name of the variable and 'undefined' as the only value, rather than properly + // serializing. + $encoded = json_encode ( $locationsToSerialize ); + // Log::debug('encoded json is: ' . var_export($encoded, true)); + + die ( $encoded ); + } + + public function getInfoOnLocation($reqData) + { + if (array_key_exists('id', $reqData)) { + $id = $reqData['id']; + } else { + // throw an exception here? + $message = 'failed to find location id in request data'; + Log::Debug($message); + die($message); + } + + $location = $this->Locations->get($id, [ + ]); + return die(json_encode($location)); + } + +} diff --git a/production/example_apps/zippy_maps/src/Controller/PagesController.php b/production/example_apps/zippy_maps/src/Controller/PagesController.php new file mode 100644 index 00000000..55792c8e --- /dev/null +++ b/production/example_apps/zippy_maps/src/Controller/PagesController.php @@ -0,0 +1,69 @@ +redirect('/'); + } + if (in_array('..', $path, true) || in_array('.', $path, true)) { + throw new ForbiddenException(); + } + $page = $subpage = null; + + if (!empty($path[0])) { + $page = $path[0]; + } + if (!empty($path[1])) { + $subpage = $path[1]; + } + $this->set(compact('page', 'subpage')); + + try { + $this->render(implode('/', $path)); + } catch (MissingTemplateException $e) { + if (Configure::read('debug')) { + throw $e; + } + throw new NotFoundException(); + } + } +} diff --git a/production/example_apps/zippy_maps/src/Model/Behavior/empty b/production/example_apps/zippy_maps/src/Model/Behavior/empty new file mode 100644 index 00000000..e69de29b diff --git a/production/example_apps/zippy_maps/src/Model/Entity/CategoriesLocation.php b/production/example_apps/zippy_maps/src/Model/Entity/CategoriesLocation.php new file mode 100644 index 00000000..f21e91d6 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Model/Entity/CategoriesLocation.php @@ -0,0 +1,34 @@ + true, + 'id' => false + ]; +} diff --git a/production/example_apps/zippy_maps/src/Model/Entity/Category.php b/production/example_apps/zippy_maps/src/Model/Entity/Category.php new file mode 100644 index 00000000..a2d97ec8 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Model/Entity/Category.php @@ -0,0 +1,31 @@ + true, + 'id' => false + ]; +} diff --git a/production/example_apps/zippy_maps/src/Model/Entity/Location.php b/production/example_apps/zippy_maps/src/Model/Entity/Location.php new file mode 100644 index 00000000..83d5bbb6 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Model/Entity/Location.php @@ -0,0 +1,33 @@ + true, + 'id' => false + ]; +} diff --git a/production/example_apps/zippy_maps/src/Model/Table/CategoriesLocationsTable.php b/production/example_apps/zippy_maps/src/Model/Table/CategoriesLocationsTable.php new file mode 100644 index 00000000..f47763c2 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Model/Table/CategoriesLocationsTable.php @@ -0,0 +1,83 @@ +setTable('categories_locations'); + $this->setDisplayField('id'); + $this->setPrimaryKey('id'); + + $this->addBehavior('Timestamp'); + + $this->belongsTo('Locations', [ + 'foreignKey' => 'location_id', + 'joinType' => 'INNER' + ]); + $this->belongsTo('Categories', [ + 'foreignKey' => 'category_id', + 'joinType' => 'INNER' + ]); + } + + /** + * Default validation rules. + * + * @param \Cake\Validation\Validator $validator Validator instance. + * @return \Cake\Validation\Validator + */ + public function validationDefault(Validator $validator) + { + $validator + ->integer('id') + ->allowEmpty('id', 'create'); + + return $validator; + } + + /** + * Returns a rules checker object that will be used for validating + * application integrity. + * + * @param \Cake\ORM\RulesChecker $rules The rules object to be modified. + * @return \Cake\ORM\RulesChecker + */ + public function buildRules(RulesChecker $rules) + { + $rules->add($rules->existsIn(['location_id'], 'Locations')); + $rules->add($rules->existsIn(['category_id'], 'Categories')); + + return $rules; + } +} diff --git a/production/example_apps/zippy_maps/src/Model/Table/CategoriesTable.php b/production/example_apps/zippy_maps/src/Model/Table/CategoriesTable.php new file mode 100644 index 00000000..4d6af560 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Model/Table/CategoriesTable.php @@ -0,0 +1,186 @@ +setTable('categories'); + $this->setDisplayField('name'); + $this->setPrimaryKey('id'); + + $this->addBehavior('Timestamp'); + + $this->belongsToMany('Locations', + [ + 'targetForeignKey' => 'location_id', + 'foreignKey' => 'category_id', + 'joinTable' => 'categories_locations', + 'through' => 'CategoriesLocations', + ]); + + } + + /** + * Default validation rules. + * + * @param \Cake\Validation\Validator $validator Validator instance. + * @return \Cake\Validation\Validator + */ + public function validationDefault(Validator $validator) + { + $validator + ->integer('id') + ->allowEmpty('id', 'create'); + + $validator + ->requirePresence('name', 'create') + ->notEmpty('name') + ->add('name', 'unique', ['rule' => 'validateUnique', 'provider' => 'table']); + + $validator + ->integer('parent') + ->allowEmpty('parent'); + + return $validator; + } + + /** + * Returns a rules checker object that will be used for validating + * application integrity. + * + * @param \Cake\ORM\RulesChecker $rules The rules object to be modified. + * @return \Cake\ORM\RulesChecker + */ + public function buildRules(RulesChecker $rules) + { + $rules->add($rules->isUnique(['name'])); + + return $rules; + } + + /** + * returns a query that will find all the categories as a list. + */ + public function getAllCategories() { + // find the full list of categories to show the user. + $categoriesList = $this->find ( 'list', [ + 'keyField' => 'id', + 'valueField' => 'name', + 'order' => [ + 'name' => 'asc' + ] + ] ); + return $categoriesList; + } + + /** + * returns a query that will locate all of the locations in the specified category with 'id'. + */ + public function getLocationsInCategory($id) + { + // query all the locations belonging to this category. + $locationsInCategory = $this->CategoriesLocations->find('all', [ + 'conditions' => [ 'category_id' => $id ], + 'contain' => ['Locations'] + ]); + return $locationsInCategory; + } + + /** + * returns a query that finds all locations in the category that fit within the southwest and northeast + * corners specified. + */ + public function getLocationsInCategoryInBox($id, $sw_lat, $sw_long, $ne_lat, $ne_long, $start = null, $end = null) + { + // query all the locations belonging to this category. + $locationsInCategory = $this->CategoriesLocations->find('all', [ + 'conditions' => [ 'category_id' => $id ], + 'contain' => ['Locations', 'Categories'] + ]); + + Log::Debug('bounds=' . $sw_lat . ', '. $sw_long . ' to ' . $ne_lat . ', ' . $ne_long); + + $bounds = [ $sw_lat , $sw_long , $ne_lat , $ne_long ]; + + if (! $bounds) { + Log::Debug("failed to calculate the bounding box!"); + } else { + Log::Debug("bounding box: " . var_export($bounds, true)); + } + + // use the boundaries to restrict the lookup. + // order: min_lat, min_long, max_lat, max_long. + $locationsInCategory = $locationsInCategory->where ( + function ($exp) use ($bounds) { + return $exp->gte ( 'lat', $bounds [0] )->gte ( 'lng', $bounds [1] )->lte ( 'lat', $bounds [2] )->lte ( 'lng', $bounds [3] ); + } + ); + + if (($start !== null) && ($end !== null)) { + Log::debug('start of range = ' . $start . ' and end = ' . $end); + $locationsInCategory= $locationsInCategory->order(['lat desc', 'lng desc']); + $chunk = $end - $start + 1; + $locationsInCategory= $locationsInCategory->limit($chunk); + $page = 1 + (int)($start / $chunk); + $locationsInCategory= $locationsInCategory->page($page); + Log::debug('page = ' . $page . ' and chunk = ' . $chunk); + } + + return $locationsInCategory; + } + + public function getChewedLocationsInCategoryInBox($id, $sw_lat, $sw_long, $ne_lat, $ne_long, $start = null, $end = null) + { + $locationsInCategory = $this->getLocationsInCategoryInBox($id, $sw_lat, $sw_long, $ne_lat, $ne_long, $start, $end); + + $locationsToSerialize = []; + + // make an array with the useful parts of the location data. + foreach ($locationsInCategory as $location) { + $lat_and_long = $location->location->lat. ',' . $location->location->lng; + if (array_key_exists ( $lat_and_long, $locationsToSerialize)) { + continue; // already got it. + } + +//Log::debug('got an icon value of: ' . $location->category->image); + + // we don't include lat and lng below since they are encoded as array key. + $locationsToSerialize[$lat_and_long] = ['name' => $location->location->name, + 'loc' => $location->location->location, + 'icon' => $location->category->image, + 'id' => $location->location_id, + ]; + } + + return $locationsToSerialize; + } +} diff --git a/production/example_apps/zippy_maps/src/Model/Table/LocationsTable.php b/production/example_apps/zippy_maps/src/Model/Table/LocationsTable.php new file mode 100644 index 00000000..57d43f73 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Model/Table/LocationsTable.php @@ -0,0 +1,191 @@ +setTable('locations'); + $this->setDisplayField('name'); + $this->setPrimaryKey('id'); + + $this->addBehavior('Timestamp'); + + $this->belongsToMany('Categories', + [ + 'targetForeignKey' => 'category_id', + 'foreignKey' => 'location_id', + 'joinTable' => 'categories_locations', + 'through' => 'CategoriesLocations', + ]); + + + } + + /** + * Default validation rules. + * + * @param \Cake\Validation\Validator $validator Validator instance. + * @return \Cake\Validation\Validator + */ + public function validationDefault(Validator $validator) + { + $validator + ->integer('id') + ->allowEmpty('id', 'create'); + + $validator + ->requirePresence('name', 'create') + ->notEmpty('name') + ->add('name', 'unique', ['rule' => 'validateUnique', 'provider' => 'table']); + + $validator->requirePresence ( 'location', 'create' )->notEmpty ( 'location' ); + + $validator + ->allowEmpty('lat'); + $validator + ->allowEmpty('lng'); + + return $validator; + } + + /** + * Returns a rules checker object that will be used for validating + * application integrity. + * + * @param \Cake\ORM\RulesChecker $rules The rules object to be modified. + * @return \Cake\ORM\RulesChecker + */ + public function buildRules(RulesChecker $rules) + { + $rules->add($rules->isUnique(['name'])); + + return $rules; + } + + + /** + * returns a query that will find the category records associated with a location 'id' + * as a list. + */ + public function getSelectedCategories($id) + { + // find the categories that are chosen for this item, if any. + $selectedCategories = $this->CategoriesLocations->find ( 'list', [ + 'keyField' => 'category_id', + 'valueField' => 'location_id', + 'conditions' => [ + 'location_id' => $id + ], + 'contain' => [ + 'Categories' + ] + ] ); + return $selectedCategories; + } + + /** + * returns a query that will find all of the locations within the bounding box. + */ + public function getLocationsInBox($sw_lat, $sw_long, $ne_lat, $ne_long, $start = null, $end = null) { + $locationsInRange = $this->find ( 'all', [ + 'contain' => ['Categories'], + ] ); + + Log::Debug ( 'bounds=' . $sw_lat . ', ' . $sw_long . ' to ' . $ne_lat . ', ' . $ne_long ); + + $bounds = [ + $sw_lat, + $sw_long, + $ne_lat, + $ne_long + ]; + + if (! $bounds) { + Log::Debug ( "failed to calculate the bounding box!" ); + } else { + Log::Debug ( "bounding box: " . var_export ( $bounds, true ) ); + } + + // use the boundaries to restrict the lookup so we aren't crushed. + // order: min_lat, min_long, max_lat, max_long. + $locationsInRange = $locationsInRange->where ( function ($exp) use ($bounds) { + return $exp->gte ( 'lat', $bounds [0] )->gte ( 'lng', $bounds [1] )->lte ( 'lat', $bounds [2] )->lte ( 'lng', $bounds [3] ); + } ); + + if (($start !== null) && ($end !== null)) { + Log::debug('start of range = ' . $start . ' and end = ' . $end); + $locationsInRange = $locationsInRange->order(['lat desc', 'lng desc']); + $chunk = $end - $start + 1; + $locationsInRange = $locationsInRange->limit($chunk); + $page = 1 + (int)($start / $chunk); + $locationsInRange = $locationsInRange->page($page); + Log::debug('page = ' . $page . ' and chunk = ' . $chunk); + } + + return $locationsInRange; + } + + /** + * retrieves all of the locations within the bounding box as a list of partial location data. + */ + public function getChewedLocationsInBox($sw_lat, $sw_long, $ne_lat, $ne_long, $start = null, $end = null) { + $locationsInRange = $this->getLocationsInBox($sw_lat, $sw_long, $ne_lat, $ne_long, $start, $end); + + // track locations we've already added and do not add ones at exactly the same lat/long. + // if we did add these, google maps screws up in representing them. + $locationsToSerialize = [ ]; + + foreach ( $locationsInRange as $location ) { + $lat_and_long = $location->lat . ',' . $location->lng; + if (array_key_exists ( $lat_and_long, $locationsToSerialize )) { + continue; // already got it. + } + +// Log::debug('dumping location row: ' . var_export($location, true)); + + // we don't include lat and lng below since they are encoded as array key. + $locationsToSerialize [$lat_and_long] = [ + 'name' => $location->name, + 'loc' => $location->location, + 'id' => $location->id + ]; + + // only try to add the image if the location actually has a category membership (at least one). + if ($location->categories) { + $locationsToSerialize [$lat_and_long]['icon'] = $location->categories[0]->image; + } + } + + return $locationsToSerialize; + } + +} diff --git a/production/example_apps/zippy_maps/src/Shell/ConsoleShell.php b/production/example_apps/zippy_maps/src/Shell/ConsoleShell.php new file mode 100644 index 00000000..c84bd97a --- /dev/null +++ b/production/example_apps/zippy_maps/src/Shell/ConsoleShell.php @@ -0,0 +1,81 @@ +err('Unable to load Psy\Shell.'); + $this->err(''); + $this->err('Make sure you have installed psysh as a dependency,'); + $this->err('and that Psy\Shell is registered in your autoloader.'); + $this->err(''); + $this->err('If you are using composer run'); + $this->err(''); + $this->err('$ php composer.phar require --dev psy/psysh'); + $this->err(''); + + return self::CODE_ERROR; + } + + $this->out("You can exit with `CTRL-C` or `exit`"); + $this->out(''); + + Log::drop('debug'); + Log::drop('error'); + $this->_io->setLoggers(false); + restore_error_handler(); + restore_exception_handler(); + + $psy = new PsyShell(); + $psy->run(); + } + + /** + * Display help for this console. + * + * @return \Cake\Console\ConsoleOptionParser + */ + public function getOptionParser() + { + $parser = new ConsoleOptionParser('console'); + $parser->setDescription( + 'This shell provides a REPL that you can use to interact ' . + 'with your application in an interactive fashion. You can use ' . + 'it to run adhoc queries with your models, or experiment ' . + 'and explore the features of CakePHP and your application.' . + "\n\n" . + 'You will need to have psysh installed for this Shell to work.' + ); + + return $parser; + } +} diff --git a/production/example_apps/zippy_maps/src/Template/Categories/add.ctp b/production/example_apps/zippy_maps/src/Template/Categories/add.ctp new file mode 100644 index 00000000..3aaada7a --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Categories/add.ctp @@ -0,0 +1,27 @@ + + +

+ Form->create($category) ?> +

+ + Form->control('name'); + echo $this->Form->control('image'); + ?> +

+ Form->button(__('Submit')) ?> + Form->end() ?> +

diff --git a/production/example_apps/zippy_maps/src/Template/Categories/center.ctp b/production/example_apps/zippy_maps/src/Template/Categories/center.ctp new file mode 100644 index 00000000..ede0b27f --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Categories/center.ctp @@ -0,0 +1,133 @@ + + +

name) ?>

+ + + + + + + + + + + + + + + +

	name) ?>
	+log("state is: " . $state); + + // kludgey attempt to focus a little better, based on state size. + $small_state = false; + $medium_state = false; + // is the state small? + $small_state = ($state == 'DE' \|\| $state == 'RI' \|\| $state == 'NH'); +// $this->log('small_state=' . var_export($small_state, true)); + // if not small, we assume medium until told otherwise. + if (! $small_state) $medium_state = true; +// $this->log('medium_state=' . var_export($medium_state, true)); + // if certain known fat states, then not medium sized. + if ($state == 'TX' \|\| $state == 'CA' \|\| $state == 'AK') $medium_state = false; + $zoomFactor = $small_state? 8 : ( $medium_state? 7 : 5 ); + $this->log('zooming at ' . $zoomFactor); + //question: how to pick a more useful zoom factor? maybe record in db a starting zoom factor per state? + + // list options we want to override or add for the map. + $map_options = [ + // automatically encompass markers and auto-center if they haven't told us where to start. + 'autoCenter' => ($mapCenter === null)? true : false, + 'clustering' => $clustering, + 'zoom' => $zoomFactor, + ]; + + // start at a specified center if one is given. + if ($mapCenter) { + $map_options = array_merge($map_options, $mapCenter); + } + + //$this->log('new options set: ' . var_export($map_options, true)); + + + // provide the element with all the info it needs to set up the map. + $element_options = + [ + 'map_options' => $map_options, + 'map_colors' => 'avmaps/js/sg2_map_colors.js', + 'the_map' => $this->GoogleMap, + // no options to pass to ajax so far... + 'ajax_options' => '{ + }', + 'default_options' => '{ + json_provider: "/categories.json", + iconColor: "' . $this->MapDisplay->defaultIconColor() . '", + }', + ]; + + echo $this->element('Avmaps.google_map', $element_options); + + /* + // create the basic map framework using google maps api. + $this->MapDisplay->setupMap ( $map_options, $this->GoogleMap ); + + // plug in our chosen color scheme for land, roads, etc. + $this->MapDisplay->applyColors ( 'avmaps/js/sg2_map_colors.js' ); + + // after the intial configuration items are done, we can emit the map code. + // we can still add markers after this point, and do so below. + $this->MapDisplay->emitMap ( false ); + + // we were handed a list of locations that match our query, so we can now add them as markers. + $this->MapDisplay->addMarkersInCategory ( $locationsInCategory, $category ); + + // set up our event handler for this view. +// $this->MapDisplay->injectJSFile('avmaps/js/event_trappers.js'); + + // now we think we are ready to go. let's get the map displayed. + $this->MapDisplay->finallyDisplayMap (); + */ + + // end of dynamic map preparation. +?> +
	+ Form->create($category) ?> + Form->control ( 'view_options._ids', [ + 'type' => 'select', + 'multiple' => true, + 'val' => $selectedList, + 'options' => [ + 'clustering' => 'clustering' + ] + ] ); + ?> + + Form->button(__('Modify View')) ?> + Form->end() ?> + +

diff --git a/production/example_apps/zippy_maps/src/Template/Categories/edit.ctp b/production/example_apps/zippy_maps/src/Template/Categories/edit.ctp new file mode 100644 index 00000000..9161c952 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Categories/edit.ctp @@ -0,0 +1,32 @@ + + +

+ Form->create($category) ?> +

+ + Form->control('name'); + echo $this->Form->control('image'); + ?> +

+ Form->button(__('Submit')) ?> + Form->end() ?> +

diff --git a/production/example_apps/zippy_maps/src/Template/Categories/index.ctp b/production/example_apps/zippy_maps/src/Template/Categories/index.ctp new file mode 100644 index 00000000..1a0381b0 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Categories/index.ctp @@ -0,0 +1,56 @@ + + +

+ + + + + + + + + + + + + + + + + + + + + + + +

Paginator->sort('id') ?>	Paginator->sort('name') ?>	Paginator->sort('image') ?>	Paginator->sort('created') ?>	Paginator->sort('modified') ?>
Number->format($category->id) ?>	name) ?>	image) ?>	created) ?>	modified) ?>	+ Html->link(__('Map'), ['action' => 'map', $category->id]) ?> + Html->link(__('Center'), ['action' => 'center', $category->id]) ?> + Html->link(__('View'), ['action' => 'view', $category->id]) ?> + Html->link(__('Edit'), ['action' => 'edit', $category->id]) ?> + Form->postLink(__('Delete'), ['action' => 'delete', $category->id], ['confirm' => __('Are you sure you want to delete # {0}?', $category->id)]) ?> +

+ Paginator->first('<< ' . __('first')) ?> + Paginator->prev('< ' . __('previous')) ?> + Paginator->numbers() ?> + Paginator->next(__('next') . ' >') ?> + Paginator->last(__('last') . ' >>') ?> + +

Paginator->counter(['format' => __('Page {{page}} of {{pages}}, showing {{current}} record(s) out of {{count}} total')]) ?>

diff --git a/production/example_apps/zippy_maps/src/Template/Categories/map.ctp b/production/example_apps/zippy_maps/src/Template/Categories/map.ctp new file mode 100644 index 00000000..03a3cc53 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Categories/map.ctp @@ -0,0 +1,85 @@ + + +

name) ?>

+ + + + + + + + + + + + + + + +

	name) ?>
	+ true, // automatically encompass markers. + 'clustering' => $clustering, + ]; + + // provide the element with all the info it needs to set up the map. + $element_options = [ + 'map_options' => $map_options, + 'map_colors' => 'avmaps/js/sg2_map_colors.js', + 'the_map' => $this->GoogleMap, + // we want to include the category ID when making ajax calls. + 'ajax_options' => '{ category: "' . $category->id . '"}', + 'default_options' => '{ + iconColor: "' . $this->MapDisplay->defaultIconColor() . '", + json_provider: "/categories.json", + }', + ]; + + echo $this->element('Avmaps.google_map', $element_options); + + // end of dynamic map preparation. + +?> +
	+ Form->create($category) ?> + Form->control ( 'view_options._ids', [ + 'type' => 'select', + 'multiple' => true, + 'val' => $selectedList, + 'options' => [ + 'clustering' => 'clustering' + ] + ] ); + ?> + + Form->button(__('Modify View')) ?> + Form->end() ?> + +

diff --git a/production/example_apps/zippy_maps/src/Template/Categories/view.ctp b/production/example_apps/zippy_maps/src/Template/Categories/view.ctp new file mode 100644 index 00000000..8eec91d5 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Categories/view.ctp @@ -0,0 +1,56 @@ + + +

name) ?>

+ + + + + + + + + + + + + + + + + + + + + + + + + + +

	name) ?>
	Number->format($category->id) ?>
	image) ?>
	created) ?>
	modified) ?>
	+ Form->control('locations._ids', [ + 'type' => 'select', + 'multiple' => true, + 'disabled' => true, + 'options' => $locationBits, + ]); + ?> +

diff --git a/production/example_apps/zippy_maps/src/Template/Element/Flash/default.ctp b/production/example_apps/zippy_maps/src/Template/Element/Flash/default.ctp new file mode 100644 index 00000000..736b27db --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Element/Flash/default.ctp @@ -0,0 +1,10 @@ + +

diff --git a/production/example_apps/zippy_maps/src/Template/Element/Flash/error.ctp b/production/example_apps/zippy_maps/src/Template/Element/Flash/error.ctp new file mode 100644 index 00000000..e7c4af10 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Element/Flash/error.ctp @@ -0,0 +1,6 @@ + +

diff --git a/production/example_apps/zippy_maps/src/Template/Element/Flash/success.ctp b/production/example_apps/zippy_maps/src/Template/Element/Flash/success.ctp new file mode 100644 index 00000000..becd5a1f --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Element/Flash/success.ctp @@ -0,0 +1,6 @@ + +

diff --git a/production/example_apps/zippy_maps/src/Template/Email/html/default.ctp b/production/example_apps/zippy_maps/src/Template/Email/html/default.ctp new file mode 100644 index 00000000..386674a1 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Email/html/default.ctp @@ -0,0 +1,22 @@ + + ' . $line . "

\n"; +endforeach; +?> diff --git a/production/example_apps/zippy_maps/src/Template/Email/text/default.ctp b/production/example_apps/zippy_maps/src/Template/Email/text/default.ctp new file mode 100644 index 00000000..704b46f0 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Email/text/default.ctp @@ -0,0 +1,16 @@ + + diff --git a/production/example_apps/zippy_maps/src/Template/Error/error400.ctp b/production/example_apps/zippy_maps/src/Template/Error/error400.ctp new file mode 100644 index 00000000..2aebac6c --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Error/error400.ctp @@ -0,0 +1,38 @@ +layout = 'error'; + +if (Configure::read('debug')): + $this->layout = 'dev_error'; + + $this->assign('title', $message); + $this->assign('templateName', 'error400.ctp'); + + $this->start('file'); +?> +queryString)) : ?> +

+ SQL Query: + queryString) ?> +

+ +params)) : ?> + SQL Query Params: + params) ?> + +element('auto_table_warning') ?> +end(); +endif; +?> +

+ : + '{$url}'") ?> +

diff --git a/production/example_apps/zippy_maps/src/Template/Error/error500.ctp b/production/example_apps/zippy_maps/src/Template/Error/error500.ctp new file mode 100644 index 00000000..d8014f84 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Error/error500.ctp @@ -0,0 +1,43 @@ +layout = 'error'; + +if (Configure::read('debug')): + $this->layout = 'dev_error'; + + $this->assign('title', $message); + $this->assign('templateName', 'error500.ctp'); + + $this->start('file'); +?> +queryString)) : ?> +

+ SQL Query: + queryString) ?> +

+ +params)) : ?> + SQL Query Params: + params) ?> + + + Error in: + getFile()), $error->getLine()) ?> + +element('auto_table_warning'); + + if (extension_loaded('xdebug')): + xdebug_print_function_stack(); + endif; + + $this->end(); +endif; +?> +

+ : + +

diff --git a/production/example_apps/zippy_maps/src/Template/Layout/Email/html/default.ctp b/production/example_apps/zippy_maps/src/Template/Layout/Email/html/default.ctp new file mode 100644 index 00000000..2b439700 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Layout/Email/html/default.ctp @@ -0,0 +1,24 @@ + + + + + <?= $this->fetch('title') ?> + + + fetch('content') ?> + + diff --git a/production/example_apps/zippy_maps/src/Template/Layout/Email/text/default.ctp b/production/example_apps/zippy_maps/src/Template/Layout/Email/text/default.ctp new file mode 100644 index 00000000..871dcfb4 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Layout/Email/text/default.ctp @@ -0,0 +1,16 @@ + +fetch('content') ?> diff --git a/production/example_apps/zippy_maps/src/Template/Layout/ajax.ctp b/production/example_apps/zippy_maps/src/Template/Layout/ajax.ctp new file mode 100644 index 00000000..871dcfb4 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Layout/ajax.ctp @@ -0,0 +1,16 @@ + +fetch('content') ?> diff --git a/production/example_apps/zippy_maps/src/Template/Layout/default.ctp b/production/example_apps/zippy_maps/src/Template/Layout/default.ctp new file mode 100644 index 00000000..24a4dd0b --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Layout/default.ctp @@ -0,0 +1,66 @@ + + + + + Html->charset() ?> + + + <?= $pageDescription ?>: + <?= $this->fetch('title') ?> + + Html->meta('icon') ?> + + Html->css('base.css') ?> + Html->css('cake.css') ?> + + fetch('meta') ?> + fetch('css') ?> + + + + + + + + fetch('script') ?> + + + + + Flash->render() ?> +

+ fetch('content') ?> +

+ + + diff --git a/production/example_apps/zippy_maps/src/Template/Layout/error.ctp b/production/example_apps/zippy_maps/src/Template/Layout/error.ctp new file mode 100644 index 00000000..5304ec43 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Layout/error.ctp @@ -0,0 +1,47 @@ + + + + + Html->charset() ?> + + <?= $this->fetch('title') ?> + + Html->meta('icon') ?> + + Html->css('base.css') ?> + Html->css('cake.css') ?> + + fetch('meta') ?> + fetch('css') ?> + fetch('script') ?> + + +

+ +

+ Flash->render() ?> + + fetch('content') ?> +

+ +

+ + diff --git a/production/example_apps/zippy_maps/src/Template/Layout/rss/default.ctp b/production/example_apps/zippy_maps/src/Template/Layout/rss/default.ctp new file mode 100644 index 00000000..5c15a198 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Layout/rss/default.ctp @@ -0,0 +1,14 @@ +fetch('title'); +endif; + +echo $this->Rss->document( + $this->Rss->channel( + [], $channel, $this->fetch('content') + ) +); +?> diff --git a/production/example_apps/zippy_maps/src/Template/Locations/add.ctp b/production/example_apps/zippy_maps/src/Template/Locations/add.ctp new file mode 100644 index 00000000..e50d32c7 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Locations/add.ctp @@ -0,0 +1,30 @@ + + +

+ Form->create($location) ?> +

+ + Form->control('name'); + echo $this->Form->control('location'); + + echo $this->Form->control('categories._ids', [ + 'type' => 'select', + 'multiple' => true, + 'options' => $categoriesList, + ]); + + ?> +

+ Form->button(__('Submit')) ?> + Form->end() ?> +

diff --git a/production/example_apps/zippy_maps/src/Template/Locations/distance.ctp b/production/example_apps/zippy_maps/src/Template/Locations/distance.ctp new file mode 100644 index 00000000..76f7b125 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Locations/distance.ctp @@ -0,0 +1,58 @@ + + +

+ Form->create('DistanceCalculator') ?> +

+ + Form->control('from._ids', [ + 'type' => 'select', + 'options' => $locationsFrom, + 'value' => $fromId, + ]); + + if ($fromAddress !== null) { + echo $this->Form->control('from-address', [ + 'type' => 'textarea', + 'rows' => 1, + 'default' => $fromAddress, + 'disabled' => 'disabled' + ]); + } + + echo $this->Form->control('to._ids', [ + 'type' => 'select', + 'options' => $locationsTo, + 'value' => $toId, + ]); + + if ($toAddress !== null) { + echo $this->Form->control('to-address', [ + 'type' => 'textarea', + 'rows' => 1, + 'default' => $toAddress, + 'disabled' => 'disabled' + ]); + } + + echo $this->Form->control('distance', [ + 'type' => 'textarea', + 'rows' => 1, + 'default' => $distanceCalculated, + 'disabled' => 'disabled' + ]); + + ?> +

+ Form->button(__('Calculate')) ?> + Form->end() ?> +

diff --git a/production/example_apps/zippy_maps/src/Template/Locations/edit.ctp b/production/example_apps/zippy_maps/src/Template/Locations/edit.ctp new file mode 100644 index 00000000..2a1e2580 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Locations/edit.ctp @@ -0,0 +1,37 @@ + + +

+ Form->create($location) ?> +

+ + Form->control('name'); + echo $this->Form->control('location'); + + echo $this->Form->control('categories._ids', [ + 'type' => 'select', + 'multiple' => true, + 'val' => $selectedList, + 'options' => $categoriesList, + ]); + + ?> +

+ Form->button(__('Submit')) ?> + Form->end() ?> +

diff --git a/production/example_apps/zippy_maps/src/Template/Locations/index.ctp b/production/example_apps/zippy_maps/src/Template/Locations/index.ctp new file mode 100644 index 00000000..ac967333 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Locations/index.ctp @@ -0,0 +1,55 @@ + + +

+ + + + + + + + + + + + + + + + + + + + + + + +

Paginator->sort('id') ?>	Paginator->sort('name') ?>	Paginator->sort('location') ?>	Paginator->sort('lat') ?>	Paginator->sort('lng') ?>
Number->format($location->id) ?>	name) ?>	location) ?>	lat) ?>	lng) ?>	+ Html->link(__('Jump'), ['action' => 'jump', $location->id]) ?> + Html->link(__('Radius'), ['action' => 'radius', $location->id]) ?> + Html->link(__('View'), ['action' => 'view', $location->id]) ?> + Html->link(__('Edit'), ['action' => 'edit', $location->id]) ?> + Form->postLink(__('Delete'), ['action' => 'delete', $location->id], ['confirm' => __('Are you sure you want to delete # {0}?', $location->id)]) ?> +

+ Paginator->first('<< ' . __('first')) ?> + Paginator->prev('< ' . __('previous')) ?> + Paginator->numbers() ?> + Paginator->next(__('next') . ' >') ?> + Paginator->last(__('last') . ' >>') ?> + +

Paginator->counter(['format' => __('Page {{page}} of {{pages}}, showing {{current}} record(s) out of {{count}} total')]) ?>

diff --git a/production/example_apps/zippy_maps/src/Template/Locations/jump.ctp b/production/example_apps/zippy_maps/src/Template/Locations/jump.ctp new file mode 100644 index 00000000..a4631bdc --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Locations/jump.ctp @@ -0,0 +1,53 @@ + + +

+ Form->create('Jump') ?> +

+ + true, // automatically encompass markers. + 'clustering' => true, // cluster the markers. + 'zoom' => 12, // zoom in pretty far but not as a microscope. + 'lat' => $fromLat, + 'lng' => $fromLong, + ]; + + // provide the element with all the info it needs to set up the map. + $element_options = + [ + 'map_options' => $map_options, + 'map_colors' => 'avmaps/js/sg2_map_colors.js', + 'the_map' => $this->GoogleMap, + // no options to pass to ajax so far... + 'ajax_options' => '{ + }', + 'default_options' => '{ + iconColor: "' . $this->MapDisplay->defaultIconColor() . '", + json_provider: "/locations.json", + }', + ]; + + echo $this->element('Avmaps.google_map', $element_options); + } + ?> +

+ + Form->end() ?> +

diff --git a/production/example_apps/zippy_maps/src/Template/Locations/radius.ctp b/production/example_apps/zippy_maps/src/Template/Locations/radius.ctp new file mode 100644 index 00000000..11b483e4 --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Locations/radius.ctp @@ -0,0 +1,56 @@ + + +

+ Form->create('RadiusFinder') ?> +

+ + Form->control ( 'from-address', [ + 'type' => 'textarea', + 'rows' => 1, + 'default' => $fromAddress, + 'disabled' => 'disabled' + ] ); + + echo $this->Form->control ( 'radius (in miles)' , ['default' => $radius]); + + // list options we want to override or add for the map. + $map_options = [ + 'autoCenter' => true, // automatically encompass markers. + 'clustering' => true, // cluster the markers. + ]; + + // provide the element with all the info it needs to set up the map. + $element_options = + [ + 'map_options' => $map_options, + 'map_colors' => 'avmaps/js/sg2_map_colors.js', + 'the_map' => $this->GoogleMap, + // no options to pass to ajax so far... + 'ajax_options' => '{ + }', + // not passing json provider, since we are doing a special radius thing here. so no updates. + 'default_options' => '{ + iconColor: "' . $this->MapDisplay->defaultIconColor() . '", + }', + ]; + + echo $this->element('Avmaps.google_map', $element_options); + } + ?> +

+ Form->button(__('Calculate')) ?> + Form->end() ?> +

diff --git a/production/example_apps/zippy_maps/src/Template/Locations/view.ctp b/production/example_apps/zippy_maps/src/Template/Locations/view.ctp new file mode 100644 index 00000000..855df52f --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Locations/view.ctp @@ -0,0 +1,97 @@ + + +

name) ?>

+ + + + + + + + + + + + + + + + + + + + + + + + +

	name) ?>
	location) ?>	+ $location->lat + . ',' . $location->lng + ], + ]; + + $marker_options = [ + 'color' => $this->MapDisplay->defaultIconColor(), + 'shadow' => 'false' + ]; + + $markers = $this->GoogleMap->staticMarkers($addresses, $marker_options); + + $map_options = [ + 'center' => $location->lat + . ',' . $location->lng, + 'markers' => $markers, + 'zoom' => 8, + ]; + + $map = $this->GoogleMap->staticMap($map_options); + + echo $map; + + $this->GoogleMap->finalize(); + + //end static map junk. + ?> + +
	lat . ',' . $location->lng) ?>
	+ lat, $location->lng, [ + 'key' => $api_key + ]); + if ($results) { + echo h($results[0]); + } else { + echo h('failed to reverse geocode'); + } + + ?> +

	+ Form->control('categories._ids', [ + 'type' => 'select', + 'multiple' => true, + 'val' => $selectedList, + 'options' => $categoriesList, + ]); + ?> +

diff --git a/production/example_apps/zippy_maps/src/Template/Pages/home.ctp b/production/example_apps/zippy_maps/src/Template/Pages/home.ctp new file mode 100644 index 00000000..b495ee8a --- /dev/null +++ b/production/example_apps/zippy_maps/src/Template/Pages/home.ctp @@ -0,0 +1,290 @@ +layout = false; + +if (!Configure::read('debug')): + throw new NotFoundException('Please replace src/Template/Pages/home.ctp with your own version.'); +endif; + +$cakeDescription = 'Maps Demo - showing what we can do to google maps'; +?> + + + + Html->charset() ?> + + + <?= $cakeDescription ?> + + + Html->meta('icon') ?> + Html->css('base.css') ?> + Html->css('cake.css') ?> + Html->css('home.css') ?> + + + + +

Html->image('/img/charlottesville_minimap.png') ?>

Maps are not the territory.

+ +

Locations Manager: Map + Locations +
Categories Manager: Map + Categories +

+ +

Based on CakePHP Red Velvet.

Please be aware that this page will not be shown if you turn off debug mode unless you replace src/Template/Pages/home.ctp with your own version.

+ URL rewriting is not properly configured on your server.
+ 1) Help me configure it
+ 2) I don't / can't use URL rewriting +

+ +

Environment

Your version of PHP is 5.6.0 or higher (detected ).
Your version of PHP is too low. You need PHP 5.6.0 or higher to use CakePHP (detected ).
Your version of PHP has the mbstring extension loaded.
Your version of PHP does NOT have the mbstring extension loaded.
Your version of PHP has the openssl extension loaded.
Your version of PHP has the mcrypt extension loaded.
Your version of PHP does NOT have the openssl or mcrypt extension loaded.
Your version of PHP has the intl extension loaded.
Your version of PHP does NOT have the intl extension loaded.

Filesystem

Your tmp directory is writable.
Your tmp directory is NOT writable.
Your logs directory is writable.
Your logs directory is NOT writable.
The Engine is being used for core caching. To change the config edit config/app.php
Your cache is NOT working. Please check the settings in config/app.php

+ +

Database

+ connect(); + } catch (Exception $connectionError) { + $connected = false; + $errorMsg = $connectionError->getMessage(); + if (method_exists($connectionError, 'getAttributes')): + $attributes = $connectionError->getAttributes(); + if (isset($errorMsg['message'])): + $errorMsg .= '
' . $attributes['message']; + endif; + endif; + } + ?> +

CakePHP is able to connect to the database.
CakePHP is NOT able to connect to the database.

DebugKit

DebugKit is loaded.
DebugKit is NOT loaded. You need to either install pdo_sqlite, or define the "debug_kit" connection name.

+ +

Editing this Page

To change the content of this page, edit: src/Template/Pages/home.ctp.
You can also add some CSS styles for your pages at: webroot/css/.

Getting Started

+ +

More about Cake

+ CakePHP is a rapid development framework for PHP which uses commonly known design patterns like Front Controller and MVC.
+ Our primary goal is to provide a structured framework that enables PHP users at all levels to rapidly develop robust web applications, without any loss to flexibility. +

+ +

Help and Bug Reports

+ irc.freenode.net #cakephp +
- Live chat about CakePHP
+
+ CakePHP Issues +
- CakePHP issues and pull requests
+
+ CakePHP Forum +
- CakePHP official discussion forum
+
+ CakePHP Google Group +
- Community mailing list
+

+ +

Docs and Downloads

+ CakePHP API +
- Quick Reference
+
+ CakePHP Documentation +
- Your Rapid Development Cookbook
+
+ The Bakery +
- Everything CakePHP
+
+ CakePHP plugins repo +
- A comprehensive list of all CakePHP plugins created by the community
+
+ CakePHP Code +
- For the Development of CakePHP Git repository, Downloads
+
+ CakePHP Awesome List +
- A curated list of amazingly awesome CakePHP plugins, resources and shiny things.
+
+ CakePHP +
- The Rapid Development Framework
+

+ +

Training and Certification

+ Cake Software Foundation +
- Promoting development related to CakePHP
+
+ CakePHP Training +
- Learn to use the CakePHP framework
+
+ CakePHP Certification +
- Become a certified CakePHP developer
+

"],col:[2,"","

"],tr:[2,"","

"],td:[3,"","

"],_default:[0,"",""]};ma.optgroup=ma.option,ma.tbody=ma.tfoot=ma.colgroup=ma.caption=ma.thead,ma.th=ma.td;function na(a,b){var c;return c="undefined"!=typeof a.getElementsByTagName?a.getElementsByTagName(b||"*"):"undefined"!=typeof a.querySelectorAll?a.querySelectorAll(b||"*"):[],void 0===b||b&&B(a,b)?r.merge([a],c):c}function oa(a,b){for(var c=0,d=a.length;c-1)e&&e.push(f);else if(j=r.contains(f.ownerDocument,f),g=na(l.appendChild(f),"script"),j&&oa(g),c){k=0;while(f=g[k++])la.test(f.type||"")&&c.push(f)}return l}!function(){var a=d.createDocumentFragment(),b=a.appendChild(d.createElement("div")),c=d.createElement("input");c.setAttribute("type","radio"),c.setAttribute("checked","checked"),c.setAttribute("name","t"),b.appendChild(c),o.checkClone=b.cloneNode(!0).cloneNode(!0).lastChild.checked,b.innerHTML="",o.noCloneChecked=!!b.cloneNode(!0).lastChild.defaultValue}();var ra=d.documentElement,sa=/^key/,ta=/^(?:mouse|pointer|contextmenu|drag|drop)|click/,ua=/^([^.]*)(?:\.(.+)|)/;function va(){return!0}function wa(){return!1}function xa(){try{return d.activeElement}catch(a){}}function ya(a,b,c,d,e,f){var g,h;if("object"==typeof b){"string"!=typeof c&&(d=d||c,c=void 0);for(h in b)ya(a,h,c,d,b[h],f);return a}if(null==d&&null==e?(e=c,d=c=void 0):null==e&&("string"==typeof c?(e=d,d=void 0):(e=d,d=c,c=void 0)),e===!1)e=wa;else if(!e)return a;return 1===f&&(g=e,e=function(a){return r().off(a),g.apply(this,arguments)},e.guid=g.guid||(g.guid=r.guid++)),a.each(function(){r.event.add(this,b,e,d,c)})}r.event={global:{},add:function(a,b,c,d,e){var f,g,h,i,j,k,l,m,n,o,p,q=W.get(a);if(q){c.handler&&(f=c,c=f.handler,e=f.selector),e&&r.find.matchesSelector(ra,e),c.guid||(c.guid=r.guid++),(i=q.events)||(i=q.events={}),(g=q.handle)||(g=q.handle=function(b){return"undefined"!=typeof r&&r.event.triggered!==b.type?r.event.dispatch.apply(a,arguments):void 0}),b=(b||"").match(L)||[""],j=b.length;while(j--)h=ua.exec(b[j])||[],n=p=h[1],o=(h[2]||"").split(".").sort(),n&&(l=r.event.special[n]||{},n=(e?l.delegateType:l.bindType)||n,l=r.event.special[n]||{},k=r.extend({type:n,origType:p,data:d,handler:c,guid:c.guid,selector:e,needsContext:e&&r.expr.match.needsContext.test(e),namespace:o.join(".")},f),(m=i[n])||(m=i[n]=[],m.delegateCount=0,l.setup&&l.setup.call(a,d,o,g)!==!1||a.addEventListener&&a.addEventListener(n,g)),l.add&&(l.add.call(a,k),k.handler.guid||(k.handler.guid=c.guid)),e?m.splice(m.delegateCount++,0,k):m.push(k),r.event.global[n]=!0)}},remove:function(a,b,c,d,e){var f,g,h,i,j,k,l,m,n,o,p,q=W.hasData(a)&&W.get(a);if(q&&(i=q.events)){b=(b||"").match(L)||[""],j=b.length;while(j--)if(h=ua.exec(b[j])||[],n=p=h[1],o=(h[2]||"").split(".").sort(),n){l=r.event.special[n]||{},n=(d?l.delegateType:l.bindType)||n,m=i[n]||[],h=h[2]&&new RegExp("(^|\\.)"+o.join("\\.(?:.*\\.|)")+"(\\.|$)"),g=f=m.length;while(f--)k=m[f],!e&&p!==k.origType||c&&c.guid!==k.guid||h&&!h.test(k.namespace)||d&&d!==k.selector&&("**"!==d||!k.selector)||(m.splice(f,1),k.selector&&m.delegateCount--,l.remove&&l.remove.call(a,k));g&&!m.length&&(l.teardown&&l.teardown.call(a,o,q.handle)!==!1||r.removeEvent(a,n,q.handle),delete i[n])}else for(n in i)r.event.remove(a,n+b[j],c,d,!0);r.isEmptyObject(i)&&W.remove(a,"handle events")}},dispatch:function(a){var b=r.event.fix(a),c,d,e,f,g,h,i=new Array(arguments.length),j=(W.get(this,"events")||{})[b.type]||[],k=r.event.special[b.type]||{};for(i[0]=b,c=1;c=1))for(;j!==this;j=j.parentNode||this)if(1===j.nodeType&&("click"!==a.type||j.disabled!==!0)){for(f=[],g={},c=0;c-1:r.find(e,this,null,[j]).length),g[e]&&f.push(d);f.length&&h.push({elem:j,handlers:f})}return j=this,i\x20\t\r\n\f]*)[^>]*)\/>/gi,Aa=/\s*$/g;function Ea(a,b){return B(a,"table")&&B(11!==b.nodeType?b:b.firstChild,"tr")?r(">tbody",a)[0]||a:a}function Fa(a){return a.type=(null!==a.getAttribute("type"))+"/"+a.type,a}function Ga(a){var b=Ca.exec(a.type);return b?a.type=b[1]:a.removeAttribute("type"),a}function Ha(a,b){var c,d,e,f,g,h,i,j;if(1===b.nodeType){if(W.hasData(a)&&(f=W.access(a),g=W.set(b,f),j=f.events)){delete g.handle,g.events={};for(e in j)for(c=0,d=j[e].length;c1&&"string"==typeof q&&!o.checkClone&&Ba.test(q))return a.each(function(e){var f=a.eq(e);s&&(b[0]=q.call(this,e,f.html())),Ja(f,b,c,d)});if(m&&(e=qa(b,a[0].ownerDocument,!1,a,d),f=e.firstChild,1===e.childNodes.length&&(e=f),f||d)){for(h=r.map(na(e,"script"),Fa),i=h.length;l")},clone:function(a,b,c){var d,e,f,g,h=a.cloneNode(!0),i=r.contains(a.ownerDocument,a);if(!(o.noCloneChecked||1!==a.nodeType&&11!==a.nodeType||r.isXMLDoc(a)))for(g=na(h),f=na(a),d=0,e=f.length;d0&&oa(g,!i&&na(a,"script")),h},cleanData:function(a){for(var b,c,d,e=r.event.special,f=0;void 0!==(c=a[f]);f++)if(U(c)){if(b=c[W.expando]){if(b.events)for(d in b.events)e[d]?r.event.remove(c,d):r.removeEvent(c,d,b.handle);c[W.expando]=void 0}c[X.expando]&&(c[X.expando]=void 0)}}}),r.fn.extend({detach:function(a){return Ka(this,a,!0)},remove:function(a){return Ka(this,a)},text:function(a){return T(this,function(a){return void 0===a?r.text(this):this.empty().each(function(){1!==this.nodeType&&11!==this.nodeType&&9!==this.nodeType||(this.textContent=a)})},null,a,arguments.length)},append:function(){return Ja(this,arguments,function(a){if(1===this.nodeType||11===this.nodeType||9===this.nodeType){var b=Ea(this,a);b.appendChild(a)}})},prepend:function(){return Ja(this,arguments,function(a){if(1===this.nodeType||11===this.nodeType||9===this.nodeType){var b=Ea(this,a);b.insertBefore(a,b.firstChild)}})},before:function(){return Ja(this,arguments,function(a){this.parentNode&&this.parentNode.insertBefore(a,this)})},after:function(){return Ja(this,arguments,function(a){this.parentNode&&this.parentNode.insertBefore(a,this.nextSibling)})},empty:function(){for(var a,b=0;null!=(a=this[b]);b++)1===a.nodeType&&(r.cleanData(na(a,!1)),a.textContent="");return this},clone:function(a,b){return a=null!=a&&a,b=null==b?a:b,this.map(function(){return r.clone(this,a,b)})},html:function(a){return T(this,function(a){var b=this[0]||{},c=0,d=this.length;if(void 0===a&&1===b.nodeType)return b.innerHTML;if("string"==typeof a&&!Aa.test(a)&&!ma[(ka.exec(a)||["",""])[1].toLowerCase()]){a=r.htmlPrefilter(a);try{for(;c1)}});function _a(a,b,c,d,e){return new _a.prototype.init(a,b,c,d,e)}r.Tween=_a,_a.prototype={constructor:_a,init:function(a,b,c,d,e,f){this.elem=a,this.prop=c,this.easing=e||r.easing._default,this.options=b,this.start=this.now=this.cur(),this.end=d,this.unit=f||(r.cssNumber[c]?"":"px")},cur:function(){var a=_a.propHooks[this.prop];return a&&a.get?a.get(this):_a.propHooks._default.get(this)},run:function(a){var b,c=_a.propHooks[this.prop];return this.options.duration?this.pos=b=r.easing[this.easing](a,this.options.duration*a,0,1,this.options.duration):this.pos=b=a,this.now=(this.end-this.start)*b+this.start,this.options.step&&this.options.step.call(this.elem,this.now,this),c&&c.set?c.set(this):_a.propHooks._default.set(this),this}},_a.prototype.init.prototype=_a.prototype,_a.propHooks={_default:{get:function(a){var b;return 1!==a.elem.nodeType||null!=a.elem[a.prop]&&null==a.elem.style[a.prop]?a.elem[a.prop]:(b=r.css(a.elem,a.prop,""),b&&"auto"!==b?b:0)},set:function(a){r.fx.step[a.prop]?r.fx.step[a.prop](a):1!==a.elem.nodeType||null==a.elem.style[r.cssProps[a.prop]]&&!r.cssHooks[a.prop]?a.elem[a.prop]=a.now:r.style(a.elem,a.prop,a.now+a.unit)}}},_a.propHooks.scrollTop=_a.propHooks.scrollLeft={set:function(a){a.elem.nodeType&&a.elem.parentNode&&(a.elem[a.prop]=a.now)}},r.easing={linear:function(a){return a},swing:function(a){return.5-Math.cos(a*Math.PI)/2},_default:"swing"},r.fx=_a.prototype.init,r.fx.step={};var ab,bb,cb=/^(?:toggle|show|hide)$/,db=/queueHooks$/;function eb(){bb&&(d.hidden===!1&&a.requestAnimationFrame?a.requestAnimationFrame(eb):a.setTimeout(eb,r.fx.interval),r.fx.tick())}function fb(){return a.setTimeout(function(){ab=void 0}),ab=r.now()}function gb(a,b){var c,d=0,e={height:a};for(b=b?1:0;d<4;d+=2-b)c=ca[d],e["margin"+c]=e["padding"+c]=a;return b&&(e.opacity=e.width=a),e}function hb(a,b,c){for(var d,e=(kb.tweeners[b]||[]).concat(kb.tweeners["*"]),f=0,g=e.length;f1)},removeAttr:function(a){return this.each(function(){r.removeAttr(this,a)})}}),r.extend({attr:function(a,b,c){var d,e,f=a.nodeType;if(3!==f&&8!==f&&2!==f)return"undefined"==typeof a.getAttribute?r.prop(a,b,c):(1===f&&r.isXMLDoc(a)||(e=r.attrHooks[b.toLowerCase()]||(r.expr.match.bool.test(b)?lb:void 0)),void 0!==c?null===c?void r.removeAttr(a,b):e&&"set"in e&&void 0!==(d=e.set(a,c,b))?d:(a.setAttribute(b,c+""),c):e&&"get"in e&&null!==(d=e.get(a,b))?d:(d=r.find.attr(a,b), +null==d?void 0:d))},attrHooks:{type:{set:function(a,b){if(!o.radioValue&&"radio"===b&&B(a,"input")){var c=a.value;return a.setAttribute("type",b),c&&(a.value=c),b}}}},removeAttr:function(a,b){var c,d=0,e=b&&b.match(L);if(e&&1===a.nodeType)while(c=e[d++])a.removeAttribute(c)}}),lb={set:function(a,b,c){return b===!1?r.removeAttr(a,c):a.setAttribute(c,c),c}},r.each(r.expr.match.bool.source.match(/\w+/g),function(a,b){var c=mb[b]||r.find.attr;mb[b]=function(a,b,d){var e,f,g=b.toLowerCase();return d||(f=mb[g],mb[g]=e,e=null!=c(a,b,d)?g:null,mb[g]=f),e}});var nb=/^(?:input|select|textarea|button)$/i,ob=/^(?:a|area)$/i;r.fn.extend({prop:function(a,b){return T(this,r.prop,a,b,arguments.length>1)},removeProp:function(a){return this.each(function(){delete this[r.propFix[a]||a]})}}),r.extend({prop:function(a,b,c){var d,e,f=a.nodeType;if(3!==f&&8!==f&&2!==f)return 1===f&&r.isXMLDoc(a)||(b=r.propFix[b]||b,e=r.propHooks[b]),void 0!==c?e&&"set"in e&&void 0!==(d=e.set(a,c,b))?d:a[b]=c:e&&"get"in e&&null!==(d=e.get(a,b))?d:a[b]},propHooks:{tabIndex:{get:function(a){var b=r.find.attr(a,"tabindex");return b?parseInt(b,10):nb.test(a.nodeName)||ob.test(a.nodeName)&&a.href?0:-1}}},propFix:{"for":"htmlFor","class":"className"}}),o.optSelected||(r.propHooks.selected={get:function(a){var b=a.parentNode;return b&&b.parentNode&&b.parentNode.selectedIndex,null},set:function(a){var b=a.parentNode;b&&(b.selectedIndex,b.parentNode&&b.parentNode.selectedIndex)}}),r.each(["tabIndex","readOnly","maxLength","cellSpacing","cellPadding","rowSpan","colSpan","useMap","frameBorder","contentEditable"],function(){r.propFix[this.toLowerCase()]=this});function pb(a){var b=a.match(L)||[];return b.join(" ")}function qb(a){return a.getAttribute&&a.getAttribute("class")||""}r.fn.extend({addClass:function(a){var b,c,d,e,f,g,h,i=0;if(r.isFunction(a))return this.each(function(b){r(this).addClass(a.call(this,b,qb(this)))});if("string"==typeof a&&a){b=a.match(L)||[];while(c=this[i++])if(e=qb(c),d=1===c.nodeType&&" "+pb(e)+" "){g=0;while(f=b[g++])d.indexOf(" "+f+" ")<0&&(d+=f+" ");h=pb(d),e!==h&&c.setAttribute("class",h)}}return this},removeClass:function(a){var b,c,d,e,f,g,h,i=0;if(r.isFunction(a))return this.each(function(b){r(this).removeClass(a.call(this,b,qb(this)))});if(!arguments.length)return this.attr("class","");if("string"==typeof a&&a){b=a.match(L)||[];while(c=this[i++])if(e=qb(c),d=1===c.nodeType&&" "+pb(e)+" "){g=0;while(f=b[g++])while(d.indexOf(" "+f+" ")>-1)d=d.replace(" "+f+" "," ");h=pb(d),e!==h&&c.setAttribute("class",h)}}return this},toggleClass:function(a,b){var c=typeof a;return"boolean"==typeof b&&"string"===c?b?this.addClass(a):this.removeClass(a):r.isFunction(a)?this.each(function(c){r(this).toggleClass(a.call(this,c,qb(this),b),b)}):this.each(function(){var b,d,e,f;if("string"===c){d=0,e=r(this),f=a.match(L)||[];while(b=f[d++])e.hasClass(b)?e.removeClass(b):e.addClass(b)}else void 0!==a&&"boolean"!==c||(b=qb(this),b&&W.set(this,"__className__",b),this.setAttribute&&this.setAttribute("class",b||a===!1?"":W.get(this,"__className__")||""))})},hasClass:function(a){var b,c,d=0;b=" "+a+" ";while(c=this[d++])if(1===c.nodeType&&(" "+pb(qb(c))+" ").indexOf(b)>-1)return!0;return!1}});var rb=/\r/g;r.fn.extend({val:function(a){var b,c,d,e=this[0];{if(arguments.length)return d=r.isFunction(a),this.each(function(c){var e;1===this.nodeType&&(e=d?a.call(this,c,r(this).val()):a,null==e?e="":"number"==typeof e?e+="":Array.isArray(e)&&(e=r.map(e,function(a){return null==a?"":a+""})),b=r.valHooks[this.type]||r.valHooks[this.nodeName.toLowerCase()],b&&"set"in b&&void 0!==b.set(this,e,"value")||(this.value=e))});if(e)return b=r.valHooks[e.type]||r.valHooks[e.nodeName.toLowerCase()],b&&"get"in b&&void 0!==(c=b.get(e,"value"))?c:(c=e.value,"string"==typeof c?c.replace(rb,""):null==c?"":c)}}}),r.extend({valHooks:{option:{get:function(a){var b=r.find.attr(a,"value");return null!=b?b:pb(r.text(a))}},select:{get:function(a){var b,c,d,e=a.options,f=a.selectedIndex,g="select-one"===a.type,h=g?null:[],i=g?f+1:e.length;for(d=f<0?i:g?f:0;d-1)&&(c=!0);return c||(a.selectedIndex=-1),f}}}}),r.each(["radio","checkbox"],function(){r.valHooks[this]={set:function(a,b){if(Array.isArray(b))return a.checked=r.inArray(r(a).val(),b)>-1}},o.checkOn||(r.valHooks[this].get=function(a){return null===a.getAttribute("value")?"on":a.value})});var sb=/^(?:focusinfocus|focusoutblur)$/;r.extend(r.event,{trigger:function(b,c,e,f){var g,h,i,j,k,m,n,o=[e||d],p=l.call(b,"type")?b.type:b,q=l.call(b,"namespace")?b.namespace.split("."):[];if(h=i=e=e||d,3!==e.nodeType&&8!==e.nodeType&&!sb.test(p+r.event.triggered)&&(p.indexOf(".")>-1&&(q=p.split("."),p=q.shift(),q.sort()),k=p.indexOf(":")<0&&"on"+p,b=b[r.expando]?b:new r.Event(p,"object"==typeof b&&b),b.isTrigger=f?2:3,b.namespace=q.join("."),b.rnamespace=b.namespace?new RegExp("(^|\\.)"+q.join("\\.(?:.*\\.|)")+"(\\.|$)"):null,b.result=void 0,b.target||(b.target=e),c=null==c?[b]:r.makeArray(c,[b]),n=r.event.special[p]||{},f||!n.trigger||n.trigger.apply(e,c)!==!1)){if(!f&&!n.noBubble&&!r.isWindow(e)){for(j=n.delegateType||p,sb.test(j+p)||(h=h.parentNode);h;h=h.parentNode)o.push(h),i=h;i===(e.ownerDocument||d)&&o.push(i.defaultView||i.parentWindow||a)}g=0;while((h=o[g++])&&!b.isPropagationStopped())b.type=g>1?j:n.bindType||p,m=(W.get(h,"events")||{})[b.type]&&W.get(h,"handle"),m&&m.apply(h,c),m=k&&h[k],m&&m.apply&&U(h)&&(b.result=m.apply(h,c),b.result===!1&&b.preventDefault());return b.type=p,f||b.isDefaultPrevented()||n._default&&n._default.apply(o.pop(),c)!==!1||!U(e)||k&&r.isFunction(e[p])&&!r.isWindow(e)&&(i=e[k],i&&(e[k]=null),r.event.triggered=p,e[p](),r.event.triggered=void 0,i&&(e[k]=i)),b.result}},simulate:function(a,b,c){var d=r.extend(new r.Event,c,{type:a,isSimulated:!0});r.event.trigger(d,null,b)}}),r.fn.extend({trigger:function(a,b){return this.each(function(){r.event.trigger(a,b,this)})},triggerHandler:function(a,b){var c=this[0];if(c)return r.event.trigger(a,b,c,!0)}}),r.each("blur focus focusin focusout resize scroll click dblclick mousedown mouseup mousemove mouseover mouseout mouseenter mouseleave change select submit keydown keypress keyup contextmenu".split(" "),function(a,b){r.fn[b]=function(a,c){return arguments.length>0?this.on(b,null,a,c):this.trigger(b)}}),r.fn.extend({hover:function(a,b){return this.mouseenter(a).mouseleave(b||a)}}),o.focusin="onfocusin"in a,o.focusin||r.each({focus:"focusin",blur:"focusout"},function(a,b){var c=function(a){r.event.simulate(b,a.target,r.event.fix(a))};r.event.special[b]={setup:function(){var d=this.ownerDocument||this,e=W.access(d,b);e||d.addEventListener(a,c,!0),W.access(d,b,(e||0)+1)},teardown:function(){var d=this.ownerDocument||this,e=W.access(d,b)-1;e?W.access(d,b,e):(d.removeEventListener(a,c,!0),W.remove(d,b))}}});var tb=a.location,ub=r.now(),vb=/\?/;r.parseXML=function(b){var c;if(!b||"string"!=typeof b)return null;try{c=(new a.DOMParser).parseFromString(b,"text/xml")}catch(d){c=void 0}return c&&!c.getElementsByTagName("parsererror").length||r.error("Invalid XML: "+b),c};var wb=/\[\]$/,xb=/\r?\n/g,yb=/^(?:submit|button|image|reset|file)$/i,zb=/^(?:input|select|textarea|keygen)/i;function Ab(a,b,c,d){var e;if(Array.isArray(b))r.each(b,function(b,e){c||wb.test(a)?d(a,e):Ab(a+"["+("object"==typeof e&&null!=e?b:"")+"]",e,c,d)});else if(c||"object"!==r.type(b))d(a,b);else for(e in b)Ab(a+"["+e+"]",b[e],c,d)}r.param=function(a,b){var c,d=[],e=function(a,b){var c=r.isFunction(b)?b():b;d[d.length]=encodeURIComponent(a)+"="+encodeURIComponent(null==c?"":c)};if(Array.isArray(a)||a.jquery&&!r.isPlainObject(a))r.each(a,function(){e(this.name,this.value)});else for(c in a)Ab(c,a[c],b,e);return d.join("&")},r.fn.extend({serialize:function(){return r.param(this.serializeArray())},serializeArray:function(){return this.map(function(){var a=r.prop(this,"elements");return a?r.makeArray(a):this}).filter(function(){var a=this.type;return this.name&&!r(this).is(":disabled")&&zb.test(this.nodeName)&&!yb.test(a)&&(this.checked||!ja.test(a))}).map(function(a,b){var c=r(this).val();return null==c?null:Array.isArray(c)?r.map(c,function(a){return{name:b.name,value:a.replace(xb,"\r\n")}}):{name:b.name,value:c.replace(xb,"\r\n")}}).get()}});var Bb=/%20/g,Cb=/#.*$/,Db=/([?&])_=[^&]*/,Eb=/^(.*?):[ \t]*([^\r\n]*)$/gm,Fb=/^(?:about|app|app-storage|.+-extension|file|res|widget):$/,Gb=/^(?:GET|HEAD)$/,Hb=/^\/\//,Ib={},Jb={},Kb="*/".concat("*"),Lb=d.createElement("a");Lb.href=tb.href;function Mb(a){return function(b,c){"string"!=typeof b&&(c=b,b="*");var d,e=0,f=b.toLowerCase().match(L)||[];if(r.isFunction(c))while(d=f[e++])"+"===d[0]?(d=d.slice(1)||"*",(a[d]=a[d]||[]).unshift(c)):(a[d]=a[d]||[]).push(c)}}function Nb(a,b,c,d){var e={},f=a===Jb;function g(h){var i;return e[h]=!0,r.each(a[h]||[],function(a,h){var j=h(b,c,d);return"string"!=typeof j||f||e[j]?f?!(i=j):void 0:(b.dataTypes.unshift(j),g(j),!1)}),i}return g(b.dataTypes[0])||!e["*"]&&g("*")}function Ob(a,b){var c,d,e=r.ajaxSettings.flatOptions||{};for(c in b)void 0!==b[c]&&((e[c]?a:d||(d={}))[c]=b[c]);return d&&r.extend(!0,a,d),a}function Pb(a,b,c){var d,e,f,g,h=a.contents,i=a.dataTypes;while("*"===i[0])i.shift(),void 0===d&&(d=a.mimeType||b.getResponseHeader("Content-Type"));if(d)for(e in h)if(h[e]&&h[e].test(d)){i.unshift(e);break}if(i[0]in c)f=i[0];else{for(e in c){if(!i[0]||a.converters[e+" "+i[0]]){f=e;break}g||(g=e)}f=f||g}if(f)return f!==i[0]&&i.unshift(f),c[f]}function Qb(a,b,c,d){var e,f,g,h,i,j={},k=a.dataTypes.slice();if(k[1])for(g in a.converters)j[g.toLowerCase()]=a.converters[g];f=k.shift();while(f)if(a.responseFields[f]&&(c[a.responseFields[f]]=b),!i&&d&&a.dataFilter&&(b=a.dataFilter(b,a.dataType)),i=f,f=k.shift())if("*"===f)f=i;else if("*"!==i&&i!==f){if(g=j[i+" "+f]||j["* "+f],!g)for(e in j)if(h=e.split(" "),h[1]===f&&(g=j[i+" "+h[0]]||j["* "+h[0]])){g===!0?g=j[e]:j[e]!==!0&&(f=h[0],k.unshift(h[1]));break}if(g!==!0)if(g&&a["throws"])b=g(b);else try{b=g(b)}catch(l){return{state:"parsererror",error:g?l:"No conversion from "+i+" to "+f}}}return{state:"success",data:b}}r.extend({active:0,lastModified:{},etag:{},ajaxSettings:{url:tb.href,type:"GET",isLocal:Fb.test(tb.protocol),global:!0,processData:!0,async:!0,contentType:"application/x-www-form-urlencoded; charset=UTF-8",accepts:{"*":Kb,text:"text/plain",html:"text/html",xml:"application/xml, text/xml",json:"application/json, text/javascript"},contents:{xml:/\bxml\b/,html:/\bhtml/,json:/\bjson\b/},responseFields:{xml:"responseXML",text:"responseText",json:"responseJSON"},converters:{"* text":String,"text html":!0,"text json":JSON.parse,"text xml":r.parseXML},flatOptions:{url:!0,context:!0}},ajaxSetup:function(a,b){return b?Ob(Ob(a,r.ajaxSettings),b):Ob(r.ajaxSettings,a)},ajaxPrefilter:Mb(Ib),ajaxTransport:Mb(Jb),ajax:function(b,c){"object"==typeof b&&(c=b,b=void 0),c=c||{};var e,f,g,h,i,j,k,l,m,n,o=r.ajaxSetup({},c),p=o.context||o,q=o.context&&(p.nodeType||p.jquery)?r(p):r.event,s=r.Deferred(),t=r.Callbacks("once memory"),u=o.statusCode||{},v={},w={},x="canceled",y={readyState:0,getResponseHeader:function(a){var b;if(k){if(!h){h={};while(b=Eb.exec(g))h[b[1].toLowerCase()]=b[2]}b=h[a.toLowerCase()]}return null==b?null:b},getAllResponseHeaders:function(){return k?g:null},setRequestHeader:function(a,b){return null==k&&(a=w[a.toLowerCase()]=w[a.toLowerCase()]||a,v[a]=b),this},overrideMimeType:function(a){return null==k&&(o.mimeType=a),this},statusCode:function(a){var b;if(a)if(k)y.always(a[y.status]);else for(b in a)u[b]=[u[b],a[b]];return this},abort:function(a){var b=a||x;return e&&e.abort(b),A(0,b),this}};if(s.promise(y),o.url=((b||o.url||tb.href)+"").replace(Hb,tb.protocol+"//"),o.type=c.method||c.type||o.method||o.type,o.dataTypes=(o.dataType||"*").toLowerCase().match(L)||[""],null==o.crossDomain){j=d.createElement("a");try{j.href=o.url,j.href=j.href,o.crossDomain=Lb.protocol+"//"+Lb.host!=j.protocol+"//"+j.host}catch(z){o.crossDomain=!0}}if(o.data&&o.processData&&"string"!=typeof o.data&&(o.data=r.param(o.data,o.traditional)),Nb(Ib,o,c,y),k)return y;l=r.event&&o.global,l&&0===r.active++&&r.event.trigger("ajaxStart"),o.type=o.type.toUpperCase(),o.hasContent=!Gb.test(o.type),f=o.url.replace(Cb,""),o.hasContent?o.data&&o.processData&&0===(o.contentType||"").indexOf("application/x-www-form-urlencoded")&&(o.data=o.data.replace(Bb,"+")):(n=o.url.slice(f.length),o.data&&(f+=(vb.test(f)?"&":"?")+o.data,delete o.data),o.cache===!1&&(f=f.replace(Db,"$1"),n=(vb.test(f)?"&":"?")+"_="+ub++ +n),o.url=f+n),o.ifModified&&(r.lastModified[f]&&y.setRequestHeader("If-Modified-Since",r.lastModified[f]),r.etag[f]&&y.setRequestHeader("If-None-Match",r.etag[f])),(o.data&&o.hasContent&&o.contentType!==!1||c.contentType)&&y.setRequestHeader("Content-Type",o.contentType),y.setRequestHeader("Accept",o.dataTypes[0]&&o.accepts[o.dataTypes[0]]?o.accepts[o.dataTypes[0]]+("*"!==o.dataTypes[0]?", "+Kb+"; q=0.01":""):o.accepts["*"]);for(m in o.headers)y.setRequestHeader(m,o.headers[m]);if(o.beforeSend&&(o.beforeSend.call(p,y,o)===!1||k))return y.abort();if(x="abort",t.add(o.complete),y.done(o.success),y.fail(o.error),e=Nb(Jb,o,c,y)){if(y.readyState=1,l&&q.trigger("ajaxSend",[y,o]),k)return y;o.async&&o.timeout>0&&(i=a.setTimeout(function(){y.abort("timeout")},o.timeout));try{k=!1,e.send(v,A)}catch(z){if(k)throw z;A(-1,z)}}else A(-1,"No Transport");function A(b,c,d,h){var j,m,n,v,w,x=c;k||(k=!0,i&&a.clearTimeout(i),e=void 0,g=h||"",y.readyState=b>0?4:0,j=b>=200&&b<300||304===b,d&&(v=Pb(o,y,d)),v=Qb(o,v,y,j),j?(o.ifModified&&(w=y.getResponseHeader("Last-Modified"),w&&(r.lastModified[f]=w),w=y.getResponseHeader("etag"),w&&(r.etag[f]=w)),204===b||"HEAD"===o.type?x="nocontent":304===b?x="notmodified":(x=v.state,m=v.data,n=v.error,j=!n)):(n=x,!b&&x||(x="error",b<0&&(b=0))),y.status=b,y.statusText=(c||x)+"",j?s.resolveWith(p,[m,x,y]):s.rejectWith(p,[y,x,n]),y.statusCode(u),u=void 0,l&&q.trigger(j?"ajaxSuccess":"ajaxError",[y,o,j?m:n]),t.fireWith(p,[y,x]),l&&(q.trigger("ajaxComplete",[y,o]),--r.active||r.event.trigger("ajaxStop")))}return y},getJSON:function(a,b,c){return r.get(a,b,c,"json")},getScript:function(a,b){return r.get(a,void 0,b,"script")}}),r.each(["get","post"],function(a,b){r[b]=function(a,c,d,e){return r.isFunction(c)&&(e=e||d,d=c,c=void 0),r.ajax(r.extend({url:a,type:b,dataType:e,data:c,success:d},r.isPlainObject(a)&&a))}}),r._evalUrl=function(a){return r.ajax({url:a,type:"GET",dataType:"script",cache:!0,async:!1,global:!1,"throws":!0})},r.fn.extend({wrapAll:function(a){var b;return this[0]&&(r.isFunction(a)&&(a=a.call(this[0])),b=r(a,this[0].ownerDocument).eq(0).clone(!0),this[0].parentNode&&b.insertBefore(this[0]),b.map(function(){var a=this;while(a.firstElementChild)a=a.firstElementChild;return a}).append(this)),this},wrapInner:function(a){return r.isFunction(a)?this.each(function(b){r(this).wrapInner(a.call(this,b))}):this.each(function(){var b=r(this),c=b.contents();c.length?c.wrapAll(a):b.append(a)})},wrap:function(a){var b=r.isFunction(a);return this.each(function(c){r(this).wrapAll(b?a.call(this,c):a)})},unwrap:function(a){return this.parent(a).not("body").each(function(){r(this).replaceWith(this.childNodes)}),this}}),r.expr.pseudos.hidden=function(a){return!r.expr.pseudos.visible(a)},r.expr.pseudos.visible=function(a){return!!(a.offsetWidth||a.offsetHeight||a.getClientRects().length)},r.ajaxSettings.xhr=function(){try{return new a.XMLHttpRequest}catch(b){}};var Rb={0:200,1223:204},Sb=r.ajaxSettings.xhr();o.cors=!!Sb&&"withCredentials"in Sb,o.ajax=Sb=!!Sb,r.ajaxTransport(function(b){var c,d;if(o.cors||Sb&&!b.crossDomain)return{send:function(e,f){var g,h=b.xhr();if(h.open(b.type,b.url,b.async,b.username,b.password),b.xhrFields)for(g in b.xhrFields)h[g]=b.xhrFields[g];b.mimeType&&h.overrideMimeType&&h.overrideMimeType(b.mimeType),b.crossDomain||e["X-Requested-With"]||(e["X-Requested-With"]="XMLHttpRequest");for(g in e)h.setRequestHeader(g,e[g]);c=function(a){return function(){c&&(c=d=h.onload=h.onerror=h.onabort=h.onreadystatechange=null,"abort"===a?h.abort():"error"===a?"number"!=typeof h.status?f(0,"error"):f(h.status,h.statusText):f(Rb[h.status]||h.status,h.statusText,"text"!==(h.responseType||"text")||"string"!=typeof h.responseText?{binary:h.response}:{text:h.responseText},h.getAllResponseHeaders()))}},h.onload=c(),d=h.onerror=c("error"),void 0!==h.onabort?h.onabort=d:h.onreadystatechange=function(){4===h.readyState&&a.setTimeout(function(){c&&d()})},c=c("abort");try{h.send(b.hasContent&&b.data||null)}catch(i){if(c)throw i}},abort:function(){c&&c()}}}),r.ajaxPrefilter(function(a){a.crossDomain&&(a.contents.script=!1)}),r.ajaxSetup({accepts:{script:"text/javascript, application/javascript, application/ecmascript, application/x-ecmascript"},contents:{script:/\b(?:java|ecma)script\b/},converters:{"text script":function(a){return r.globalEval(a),a}}}),r.ajaxPrefilter("script",function(a){void 0===a.cache&&(a.cache=!1),a.crossDomain&&(a.type="GET")}),r.ajaxTransport("script",function(a){if(a.crossDomain){var b,c;return{send:function(e,f){b=r("

Welcome to CakePHP Red Velvet. Build fast. Grow solid.

Environment

Filesystem

Database

DebugKit

Editing this Page

Getting Started

More about Cake

Help and Bug Reports

Docs and Downloads

Training and Certification

+ token? 'Authorization successful for ' . $user->name + : 'Failed authorization for ' . $user->name ) ?> +

name) ?>

upcoming appointments

name) ?>

name) ?>

name) ?>

name) ?>

name) ?>

Maps are not the territory.

Based on CakePHP Red Velvet.

Environment

Filesystem

Database

DebugKit

Editing this Page

Getting Started

More about Cake

Help and Bug Reports

Docs and Downloads

Training and Certification