PHP or Calc Element

[PhilippMarx]

Hi there,

I have the follwing code in one custom detials template it bascially gets info from the google location plugin and renders only the Region/Continent out of the Data.

$city = $this->elements['location']->value;
              $url = 'http://maps.googleapis.com/maps/api/geocode/json?language=en&address=' . urlencode( $city );
              $results = file_get_contents($url);
              $results = json_decode($results);
              $results = $results->results[0]->address_components;
             
              $continents = '{"AD":"Europe","AE":"Asia","AF":"Asia","AG":"North America","AI":"North America","AL":"Europe","AM":"Asia","AN":"North America","AO":"Africa","AQ":"Antarctica","AR":"South America","AS":"Australia","AT":"Europe","AU":"Australia","AW":"North America","AZ":"Asia","BA":"Europe","BB":"North America","BD":"Asia","BE":"Europe","BF":"Africa","BG":"Europe","BH":"Asia","BI":"Africa","BJ":"Africa","BM":"North America","BN":"Asia","BO":"South America","BR":"South America","BS":"North America","BT":"Asia","BW":"Africa","BY":"Europe","BZ":"North America","CA":"North America","CC":"Asia","CD":"Africa","CF":"Africa","CG":"Africa","CH":"Europe","CI":"Africa","CK":"Australia","CL":"South America","CM":"Africa","CN":"Asia","CO":"South America","CR":"North America","CU":"North America","CV":"Africa","CX":"Asia","CY":"Asia","CZ":"Europe","DE":"Europe","DJ":"Africa","DK":"Europe","DM":"North America","DO":"North America","DZ":"Africa","EC":"South America","EE":"Europe","EG":"Africa","EH":"Africa","ER":"Africa","ES":"Europe","ET":"Africa","FI":"Europe","FJ":"Australia","FK":"South America","FM":"Australia","FO":"Europe","FR":"Europe","GA":"Africa","GB":"Europe","GD":"North America","GE":"Asia","GF":"South America","GG":"Europe","GH":"Africa","GI":"Europe","GL":"North America","GM":"Africa","GN":"Africa","GP":"North America","GQ":"Africa","GR":"Europe","GS":"Antarctica","GT":"North America","GU":"Australia","GW":"Africa","GY":"South America","HK":"Asia","HN":"North America","HR":"Europe","HT":"North America","HU":"Europe","ID":"Asia","IE":"Europe","IL":"Asia","IM":"Europe","IN":"Asia","IO":"Asia","IQ":"Asia","IR":"Asia","IS":"Europe","IT":"Europe","JE":"Europe","JM":"North America","JO":"Asia","JP":"Asia","KE":"Africa","KG":"Asia","KH":"Asia","KI":"Australia","KM":"Africa","KN":"North America","KP":"Asia","KR":"Asia","KW":"Asia","KY":"North America","KZ":"Asia","LA":"Asia","LB":"Asia","LC":"North America","LI":"Europe","LK":"Asia","LR":"Africa","LS":"Africa","LT":"Europe","LU":"Europe","LV":"Europe","LY":"Africa","MA":"Africa","MC":"Europe","MD":"Europe","ME":"Europe","MG":"Africa","MH":"Australia","MK":"Europe","ML":"Africa","MM":"Asia","MN":"Asia","MO":"Asia","MP":"Australia","MQ":"North America","MR":"Africa","MS":"North America","MT":"Europe","MU":"Africa","MV":"Asia","MW":"Africa","MX":"North America","MY":"Asia","MZ":"Africa","NA":"Africa","NC":"Australia","NE":"Africa","NF":"Australia","NG":"Africa","NI":"North America","NL":"Europe","NO":"Europe","NP":"Asia","NR":"Australia","NU":"Australia","NZ":"Australia","OM":"Asia","PA":"North America","PE":"South America","PF":"Australia","PG":"Australia","PH":"Asia","PK":"Asia","PL":"Europe","PM":"North America","PN":"Australia","PR":"North America","PS":"Asia","PT":"Europe","PW":"Australia","PY":"South America","QA":"Asia","RE":"Africa","RO":"Europe","RS":"Europe","RU":"Europe","RW":"Africa","SA":"Asia","SB":"Australia","SC":"Africa","SD":"Africa","SE":"Europe","SG":"Asia","SH":"Africa","SI":"Europe","SJ":"Europe","SK":"Europe","SL":"Africa","SM":"Europe","SN":"Africa","SO":"Africa","SR":"South America","ST":"Africa","SV":"North America","SY":"Asia","SZ":"Africa","TC":"North America","TD":"Africa","TF":"Antarctica","TG":"Africa","TH":"Asia","TJ":"Asia","TK":"Australia","TM":"Asia","TN":"Africa","TO":"Australia","TR":"Asia","TT":"North America","TV":"Australia","TW":"Asia","TZ":"Africa","UA":"Europe","UG":"Africa","US":"North America","UY":"South America","UZ":"Asia","VC":"North America","VE":"South America","VG":"North America","VI":"North America","VN":"Asia","VU":"Australia","WF":"Australia","WS":"Australia","YE":"Asia","YT":"Africa","ZA":"Africa","ZM":"Africa","ZW":"Africa"}';
             
              $continents = json_decode($continents);

             
              foreach ( $results as $result ) {
                  if (in_array('country', $result->types)) {
                      $country = $result->long_name;
                      if (property_exists( $continents, $result->short_name )) {
                          $continent = $continents->{$result->short_name};
                      }
                  }
              }
             
              echo $continent;

I want the same in an list element which plugin/element i should use and which code please help if you can ?

 

[cheesegrits]

A calc element should do it. Just use a {yourtable___location} placeholder to get your city, and 'return' rather than 'echo' the value.

You have two options for when that gets run. If you set your "Calc on save only" to NO for the calc, it'll run when the list is rendered. Which Google may not like, if you have a large list which is being displayed a lot, as it'll fire off a geocode API call for every row in the display, every time it's loaded, which could run into their usage limits (I note you aren't using an API key, unless you just removed that).

The best option would be to do it only on save, so you calc and save the continent when the form is submitted, rather than evefry time the list is displayed.

But that does mean you'd have to edit and save every existing record, to force it to save the value.

-- hugh

 

[cheesegrits]

Also note that if you do it as a calc element, you wouldn't have to have that custom code in your template.

-- hugh

 

[PhilippMarx]

Like this? I definitely missed something as it does not return me anything?

          $city = $this->elements{item_list___location}->value;
          $url = 'http://maps.googleapis.com/maps/api/geocode/json?language=en&address=' . urlencode( $city );
              $results = file_get_contents($url);
              $results = json_decode($results);
              $results = $results->results[0]->address_components;
             
              $continents = '{"AD":"Europe","AE":"Asia",...................................................................................................
             
              $continents = json_decode($continents);

             
              foreach ( $results as $result ) {
                  if (in_array('country', $result->types)) {
                      $country = $result->long_name;
                      if (property_exists( $continents, $result->short_name )) {
                          $continent = $continents->{$result->short_name};
                      }
                  }
              }
             
              return $continent;

 

[cheesegrits]

As I said:

Just use a {yourtable___location} placeholder to get your city

... as $this->elements only exists in the template.

So ...

$city = '{item_list___location}';

-- hugh