Two page list and detail with other listings appearing in the sidebar of the detail page.

richythomas · Jul 14th 2020

I have a jobs page on my website.

I followed the instructions here: https://docs.grabaperch.com/pe…two-page-list-and-detail/

I have a sub folder called opportunities. Within the sub folder I have two pages

index.php which shows all of the listings and contains the following code:

PHP

<?php
perch_content_create('Jobs', array(
'template' => 'opportunities/job_detail.html',
'multiple' => true,
'edit-mode' => 'listdetail',
));
perch_content_custom('Jobs', array(
'template' => 'opportunities/job_listing.html',
));
?>

Display More

I then have a job.php that just displays a single job post that is clicked through from the index.php page. It contains the following code:

PHP

<?php
// create the form region
perch_content_create('Apply For Job Form', [
'template' => 'forms/apply_for_job.html'
]);
// get the job and the rendered template
$result = perch_content_custom('Jobs', array(
'skip-template' => true,
'return-html' => true,
'page' => '/opportunities/index.php',
'template' => 'opportunities/job_detail.html',
'filter' => 'slug',
'match' => 'eq',
'value' => perch_get('s'),
'count' => 1,
));
if(!isset($result[0])) {
// no job found; respond with 404
}
$job = $result[0];
$job_html = $result['html'];
// get the job title
$title = '';
if(isset($job['jobTitle'])) {
$title = $job['jobTitle'];
}
// page output starts here
// output your <!doctype html>, <html>, <head>, <body> etc
// output the rendered template
echo $job_html;
// pass the job title variable and output the form region
PerchSystem::set_var('jobFormTitle', $title);
perch_content_custom('Apply For Job Form');
?>

Display More

Also on this page I would like to contain the latest three other jobs in a sidebar.

Code

<div class="col-sm-4">
</div>

I thought I would be able to use the code from the index.php page. So it would be like this:

PHP

<div class="col-sm-4">
<?php
perch_content_create('Jobs', array(
'template' => 'opportunities/job_detail.html',
'multiple' => true,
'edit-mode' => 'listdetail',
));
perch_content_custom('Jobs', array(
'template' => 'opportunities/job_listing.html',
));
?>
</div>

Display More

But it doesn't display anything at all?

Could someone let me know where I'm going wrong please?

ellimondo · Jul 15th 2020

Hi

You don't need to create a new region here as it's already created on the index page. You just need to tell Perch where to get the details from:

Code

perch_content_custom('Jobs', [
'path' => '/opportunities/index.php',
'template' => 'opportunities/job_listing.html',
'sort' => 'date', // Put the field ID you want to sort by here
'sort-order' => 'DESC',
'count' => 3,
]);

richythomas · Jul 15th 2020

Hi,

I've tried your code but it's still not displaying anything at all as I would expect.

So in my job.php I have added the following:

PHP

<div class="col-sm-4">
<?php
perch_content_custom('Jobs', [
'path' => '/opportunities/index.php',
'template' => 'opportunities/job_listing.html',
'sort' => 'closingDate', // Put the field ID you want to sort by here
'sort-order' => 'DESC',
'count' => 3,
]);
?>
</div>

Display More

and in opportunities/job_listing.html I have

Code

<perch:content id="closingDate" type="date" format="%d/%m/%Y" label="Closing Date" />

ellimondo · Jul 15th 2020

What do you get when you take out the 2 sort-related lines?

Have you got debug turned on? Are there any errors showing?

richythomas · Jul 15th 2020

I'm getting the following error with or without the sort options:

Code

Debug Message - Perch 3.1.5
[32]SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[1]SELECT * FROM perch3_pages WHERE pagePath='/opportunities/job.php' LIMIT 1
Using template: /templates/pages/attributes/default.html
Using sub-template: /templates/pages/attributes/seo.html
[6]SELECT regionKey, regionHTML FROM perch3_content_regions WHERE regionPage='/opportunities/job.php' OR regionPage='*' ORDER BY regionPage DESC
[1]SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Jobs' AND (regionPage='/opportunities/index.php' OR regionPage='*')
[1]SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=114 AND idx.itemRev=67)) AND ((idx.indexKey='slug' AND idx.indexValue='job-1')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC LIMIT 0, 1
[1]Using template: /templates/content/opportunities/job_detail.html
[1]SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Apply For Job Form' AND (regionPage='/opportunities/job.php' OR regionPage='*')
[1]SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=118 AND idx.itemRev=2)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1]Using template: /templates/content/forms/apply_for_job.html
[nil]SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Jobs' AND (regionPage='/opportunities/job.php' OR regionPage='*')
No matching content regions found. Check region name (Jobs) and page path options.
[nil]SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='closingDate' WHERE idx.regionID IS NULL AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval DESC LIMIT 0, 3
Using template: /templates/content/opportunities/job_listing.html
Array
(
[type] => 8192
[message] => Function get_magic_quotes_runtime() is deprecated
[file] => /Users/richythomas/Dropbox/Current Clients/Coopman/coopman.ie/cms/core/lib/PerchDB_MySQL.class.php
[line] => 375
)

Display More

So it's basically saying it can't find the Region 'Jobs'

But in my opportunities/index.php I have:

PHP

<?php
perch_content_create('Jobs', array(
'template' => 'opportunities/job_detail.html',
'multiple' => true,
'edit-mode' => 'listdetail',
));
perch_content_custom('Jobs', array(
'template' => 'opportunities/job_listing.html',
));
?>

Display More

ellimondo · Jul 15th 2020

The debug output looks like it's looking for /opportunities/job.php [line 13] - are you sure you've got the page path right in your code? I thought it's…/index.php

richythomas · Jul 15th 2020

I think I'm asking it to look in the correct page yes.

So on my opportunities/job.php page I have:

PHP

<?php
// create the form region
perch_content_create('Apply For Job Form', [
'template' => 'forms/apply_for_job.html'
]);
// get the job and the rendered template
$result = perch_content_custom('Jobs', array(
'skip-template' => true,
'return-html' => true,
'page' => '/opportunities/index.php',
'template' => 'opportunities/job_detail.html',
'filter' => 'slug',
'match' => 'eq',
'value' => perch_get('s'),
'count' => 1,
));
if(!isset($result[0])) {
// no job found; respond with 404
}
$job = $result[0];
$job_html = $result['html'];
// get the job title
$title = '';
if(isset($job['jobTitle'])) {
$title = $job['jobTitle'];
}
// page output starts here
// output your <!doctype html>, <html>, <head>, <body> etc
// output the rendered template
echo $job_html;
// pass the job title variable and output the form region
PerchSystem::set_var('jobFormTitle', $title);
perch_content_custom('Apply For Job Form');
?>
<div class="col-sm-4">
<?php
perch_content_custom('Jobs', [
'path' => '/opportunities/index.php',
'template' => 'opportunities/job_listing.html',
'sort' => 'closingDate', // Put the field ID you want to sort by here
'sort-order' => 'DESC',
'count' => 3,
]);
?>

Display More

and in my opportunities/index.php I have:

PHP

<?php
perch_content_create('Jobs', array(
'template' => 'opportunities/job_detail.html',
'multiple' => true,
'edit-mode' => 'listdetail',
));
perch_content_custom('Jobs', array(
'template' => 'opportunities/job_listing.html',
));
?>

Display More

ellimondo · Jul 15th 2020

Sorry my bad – in my hastily typed example the option should be 'page' not 'path'

richythomas · Jul 16th 2020

No need to apologise. I owe you more than one beer.

Thanks for your patience.