Problem with perch_collection raw output

ewe agency · Dec 12th 2019

Hi,

I have a perch collection which contains a perch map that i'm using 'raw'=>true, to get the long and lat values to use as an XML feed to display on a map.

But I also have some categories in the collection that I need to get the title or slug to use on the page as well. But the raw option is changing the categories from their title/slugs to ID values.

Is there anyway to get both the long/lat values and the category names? Maybe using the 'each'=> function option?

I'll post my templates below.

Thanks!

PHP

<?php
header('Content-type: application/xml');
include($_SERVER['DOCUMENT_ROOT'] . '/perch/runtime.php');
$properties = perch_collection('Properties', array(
'skip-template'=>true,
'raw'=>true,
));
$xml_out = '<?xml version="1.0" encoding="utf-8"?><markers>';
foreach($properties as $loc) {
$xml_out .= '
<marker
title="'. $loc['title'].'"
loc="' . $loc['loc_title'].'"
lat="' . $loc['map']['lat'].'"
lng="' . $loc['map']['lng'].'"
slug="' . $loc['propertyslug'].'"
build="' . $loc['catBuild'].'"
/>';
}
$xml_out .= '</markers>';
echo $xml_out;
?>

Display More

Byron Fitzgerald · Dec 17th 2019

Rather than skipping the template and returning raw, you can just make a perch template to output the XML.

Code

<perch:before>
<?xml version="1.0" encoding="utf-8"?>
<markers>
</perch:before>
<marker
title="<perch:content id='title' />"
loc="<perch:content id='loc_title' />"
lat="<perch:content id='map' type="map" output="lat" />"
lng="<perch:content id='map' type="map" output="lng" />"
slug="<perch:content id='propertySlug' type="slug" />"
build="<perch:categories id="build"><perch:category id="catTitle"/></categories>"
/>'
<perch:after>
</markers>
</perch:after>

Display More

Haven't seen your template but here is a best guess for a possible solution

ellimondo · Dec 17th 2019

Just to add to this excellent advice from Byron Fitzgerald – hus_hmd has also released some functions that work around this anomaly.

https://grabapipit.com/news/pipit-v0-3-categories-functions

ewe agency · Jan 31st 2020

Hi Guys,

Thanks for this. I've taken your advice and output the collection as xml which is working fine. However I still need to get the lat and lng values from the map which are only available if you return as raw.

I've amended the collection code to include an each function to get each items set of lat/lng values but when you set them as variables to pass into the template it just returns the first items values everytime. Ive checked with perch:showall and they definitely show up correct for each item but just not setting as vars properly.

I've tried looping through them with another each function and a foreach but can't get it to work properly. Am I missing something obvious?

Thanks

XML:

PHP

<?php include($_SERVER['DOCUMENT_ROOT'] . '/perch/runtime.php');
header('Content-Type: application/xml; charset=utf-8');
echo '<?xml version="1.0" encoding="utf-8"?><markers>';
$properties = perch_collection('Properties', [
'template'=>'property_xml.html',
'each' => function($item) {
$item['location'] = perch_collection('Properties', [
'_id' => $item['_id'],
'skip-template'=>true,
'raw'=>true,
]);
PerchSystem::set_var('lat', $item['map']['lat']);
PerchSystem::set_var('lng', $item['map']['lng']);
return $item;
},
]);
echo '</markers>';
?>

Display More

Template:

Code

<marker
title="<perch:content id="title" />"
lat="<perch:content id="lat" />"
lng="<perch:content id="lng" />"
slug="<perch:content id="propertyslug" />"
build="<perch:categories id="catBuild"><perch:category id="catTitle" />, </perch:categories>"
country="<perch:categories id="catLoc"><perch:category id="catTitle" />, </perch:categories>"
space="<perch:categories id="catSpace"><perch:category id="catTitle" />, </perch:categories>"
status="<perch:categories id="catStatus"><perch:category id="catTitle" />, </perch:categories>"
image="<perch:content id="banner_image" />"
/>

Display More

drewm Dec 16th 2019