Posts by Glen

Glen · Aug 27th 2021

tonyastley you sir are an absolute superstar - works perfectly

Glen · Aug 7th 2021

Quote from Gareth S

Hi All,

Firstly, the major item - at this link you will find an update, and documentation, for Perch Shop. This is to facilitate SCA compliance, obviously we would recommend testing this first, any issues please let me know so I can pass them to the developers.

Well, that went well. when visiting domain.com/perch I get an HTTP 500 error after uploading the Perch Shop v1.2.7 files

Glen · Jul 29th 2021

Well spotted Byron Fitzgerald

Thank you

Glen · Jul 29th 2021

Hi montlewis many thanks for your kind reply.

Debug after subscribe form is submitted below...

Code

Debug Message - Perch Runway 3.2
[35]SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch3_pages p LEFT JOIN perch3_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch3_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM perch3_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
Matched page: /weekly-updates, so not using routes.
Using master page: /templates/pages/mailchimp_signup.php
[50]SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[1]SELECT * FROM perch3_mailchimp_lists WHERE listMailChimpID='49b08ce110' LIMIT 1
Subscribing to: Town and Around
[1]SELECT * FROM perch3_pages WHERE pagePath='/weekly-updates' LIMIT 1
Using template: /templates/pages/attributes/seo.html
Using template: /templates/pages/attributes/facebook.html
Using template: /templates/pages/attributes/twitter.html
[1]SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/weekly-updates' OR pageSortPath='/weekly-updates' LIMIT 1
[1]SELECT * FROM perch3_pages WHERE pageHidden=0 AND pageNew=0 AND pageTreePosition IN ('000-007', '000') ORDER BY pageTreePosition
[1]Using template: /templates/navigation/breadcrumbs_schema.html
[1]SELECT collectionID, collectionTemplate FROM perch3_collections WHERE collectionKey='Previous Issues'
[1]SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch3_collection_index idx JOIN perch3_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID JOIN perch3_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID JOIN perch3_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='issueDate' WHERE (idx.collectionID=1) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval DESC LIMIT 0, 1
[1]Using template: /templates/content/home/current_issue.html
[1]SELECT groupID FROM perch3_navigation WHERE groupSlug='main-nav' LIMIT 1
[5]SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=1 AND p.pageNew=0 ORDER BY np.pageTreePosition ASC
[0]SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=1 AND p.pagePath='/weekly-updates' LIMIT 1
[5]Using template: /templates/navigation/main_nav.html
[5]SELECT regionKey, regionHTML FROM perch3_content_regions WHERE regionPage='/weekly-updates' OR regionPage='*' ORDER BY regionPage DESC
Using template: /templates/mailchimp/forms/subscribe.html
[8]SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_blog_index idx JOIN perch3_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch3_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='postDateTime' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2021-07-29 13:56:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 8
[1]SELECT FOUND_ROWS() AS `count`
[8]Using template: /templates/blog/post_banner.html
[1]SELECT * FROM perch3_blog_sections ORDER BY sectionTitle ASC
[1]SELECT * FROM perch3_blogs ORDER BY blogTitle ASC
[1]SELECT * FROM perch3_categories ORDER BY catTreePosition ASC
[1]SELECT groupID FROM perch3_navigation WHERE groupSlug='footer-nav' LIMIT 1
[6]SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=2 AND p.pageNew=0 ORDER BY np.pageTreePosition ASC
[0]SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=2 AND p.pagePath='/weekly-updates' LIMIT 1
[6]Using template: /templates/navigation/footer_nav.html
[3]SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_blog_index idx JOIN perch3_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch3_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='postDateTime' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2021-07-29 13:56:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 3
[1]SELECT FOUND_ROWS() AS `count`
[3]Using template: /templates/blog/footer_posts.html
Request time: 0.9815
Process time: 0.9798
Memory: 1.4617

Display More

Glen · Jul 24th 2021

Me again

I trying to display a simple navigation tab style using perch_categories(), which in itself works fine. However, so the user knows which category they are currently viewing I'm wanting to dynamically set the class class="active" on the active category link.

I have successfully set the category slug within the URL, retrieved the category slug and passed it into the template. The problem I am having is getting perch to create the class if the 2 match.

So for example, if the URL is domain.com?cat=outdoor the links would look like this...

Code

<ul>
<li><a href="#">Indoor</a></li>
<li><a href="#" class="active">Outdoor</a></li>
</ul>

Here's what I've got so far...

Page:

Code

$cat = $_GET['cat'];
PerchSystem::set_var('active', $cat);
perch_categories([
'set' => 'attractions',
'template' => 'category_nav_pills.html',
]);

Template:

Code

<perch:before>
<div class="bg-light py-3">
<div class="container">
<ul class="nav nav-pills nav-fill">
<li class="nav-item">
<a class="nav-link mr-3" href="?cat=">Show All</a>
</li>
</perch:before>
<li class="nav-item">
<a class="nav-link mr-3<perch:if id="active" match="eg" value="{catSlug}"> active</perch:if>" href="?cat=<perch:category id="catSlug">"><perch:category id="catTitle"></a>
</li>
<perch:after>
</ul>
</div>
</div>
</perch:after>

Display More

Many thanks

Glen

Glen · Jul 23rd 2021

Hi Mxkert

Thank you for your help.

So sorry for the delay, I have had to spend more time on other projects.

Quote from Mxkert

Sorry Glen, I forgot about this thread.

What happens if you change it to

Code

$item['exVAT'] = perch_shop_product('', [

'template' => 'products/ex_vat.html',

'filter' => 'slug',

'match' => 'eq',

'value' => $item['slug'],

], true);

...unfortunately, no data is displayed / passed to the template.

Glen

Glen · Jul 23rd 2021

HI all.

I hope someone can help.

I have installed and set up the Mailchimp addon and have successfully added the API and sync'd the lists and existing contacts etc.

However, when I try to add a contact to the list via a perch form, the contact isn't being added to Mailchimp.

Debug shows no errors, webhooks URL is correct etc etc.

Any pointers would be much appreciated.

Form code...

Code

<perch:form id="subscribe" app="perch_mailchimp">
<div class="form-row">
<div class="form-group col-lg-6">
<perch:label for="firstname" class="sr-only">First Name*</perch:label>
<perch:input id="firstname" required type="text" mailer="FNAME" placeholder="First name" class="form-control form-control-lg">
</div>
<div class="form-group col-lg-6">
<perch:label for="lastname" class="sr-only">Surname</perch:label>
<perch:input id="lastname" required type="text" mailer="LNAME" placeholder="Surname" class="form-control form-control-lg">
</div>
</div>
<div class="form-group">
<perch:label for="email" class="sr-only">Email*</perch:label>
<perch:input id="email" required type="email" mailer="EMAIL" placeholder="Email" class="form-control form-control-lg">
</div>
<div class="form-group">
<p class="text-muted"><small><i class="fas fa-lock"></i> By submitting this form you agree to the use of your data in accordance with our <a href="/privacy">privacy policy</a>.</small></p>
</div>
<div class="form-group text-right">
<button type="submit" class="btn btn-orange btn-lg btn-block">Sign Up</button>
<perch:input type="hidden" value="1" id="confirm" mailer="confirm_subscribe">
<perch:input type="hidden" id="list" value="49b08ce110" mailer="list">
<perch:input type="cms">
</div>
<perch:success>
<div class="container">
<div class="bg-success text-white my-4 p-3" role="alert">
<p><i class="fas fa-check-circle fa-lg mr-2"></i>Thank you for subscribing to our weekly news emails.</p>
<p>A confirmation email has been sent to the email address submitted, please click on the link to confirm your subscription.</p>
<p>If you do not receive a confirmation email, please check your spam folder.</p>
</div>
</div>
</perch:success>
</perch:form>

Display More

Diagnostics...

PHP

Perch Runway: 3.2, PHP: 7.3.29, MySQL: mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $, with PDO
Server OS: Linux, apache2handler
Installed apps: content (3.2), assets (3.2), categories (3.2), perch_blog (5.6.1), perch_forms (1.12), perch_mailchimp (3.1), pipit_sharing (2.1)
App runtimes: <?php $apps_list = [ 'perch_blog', 'pipit_sharing', 'perch_forms', 'perch_mailchimp' ];
PERCH_LOGINPATH: /cms
PERCH_PATH: /home2/townandaround/8L9R51AW/htdocs/cms
PERCH_CORE: /home2/townandaround/8L9R51AW/htdocs/cms/core
PERCH_RESFILEPATH: /home2/townandaround/8L9R51AW/htdocs/cms/resources
Image manipulation: GD Imagick
PHP limits: Max upload 128M, Max POST 128M, Memory: 384M, Total max file upload: 128M
F1: 3b606135b33e6a102526838f4152a807
Resource folder writeable: Yes
HTTP_HOST: townandaround.net
DOCUMENT_ROOT: /home/townandaround/8L9R51AW/htdocs/
REQUEST_URI: /cms/core/settings/diagnostics/
SCRIPT_NAME: /cms/core/settings/diagnostics/index.php

Display More

Glen · Jul 6th 2021

Quote from Mxkert

And what do you see on the page when you use the following:

Code

'each' => function($item) {

$item['exVAT'] = perch_shop_product($item['slug'], [

'template' => 'products/ex_vat.html'

], true);

$VAT = '1.20';

$item['incVAT'] = number_format($item['exVAT'] * $VAT, 2);

            print_r($item['exVAT']);

            echo '<br>';

            echo $item['incVAT'];

echo '<br><br>';

// return $item;

},

Display More

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35

6.79

Glen · Jul 6th 2021

Quote from Mxkert

What does your ex_vat.html look like?

Code

<perch:shop id="price">

Glen · Jul 6th 2021

Quote from Mxkert

If you change $exVAT to $item['exVAT'] everywhere?

I get the same result unfortunately...

Code

'each' => function($item) {
$item['exVAT'] = perch_shop_product($item['slug'], [
'template' => 'products/ex_vat.html'
], true);
$VAT = '1.20';
$item['incVAT'] = number_format($item['exVAT'] * $VAT, 2);
return $item;
},

Glen · Jul 6th 2021

Thank you so much Mxkert for your help so far, we're getting there.

I am now getting just one amount but I'm getting the same amount on each product listed... £6.79 inc VAT.

Code

perch_shop_products([
'category' => 'products/'.perch_get('path').'/',
'template' => 'products/list-category.html',
'each' => function($item) {
$exVAT = perch_shop_product($item['slug'], [
'template' => 'products/ex_vat.html'
], true);
$VAT = '1.20';
$item['incVAT'] = number_format($exVAT * $VAT, 2);
return $item;
},
]);

Display More

Glen · Jul 6th 2021

Quote from Mxkert

What does your list-category.html template looks like?

Code

<perch:before>
<div class="container">
<div class="row row-cols-1 row-cols-md-4 g-4">
</perch:before>
<div class="col">
<div class="card h-100 text-center">
<div class="card-body">
<img src="<perch:shop id="image" type="image" label="Image" width="350" height="350" crop="true">" class="card-img-top" alt="<perch:shop id="title">">
<h5 class="card-title mt-3"><a href="/product/<perch:shop id="slug" type="slug">" class="stretched-link"><perch:shop id="title"></a></h5>
</div>
<div class="card-footer">
<p class="card-text h5 mb-1"><perch:shop id="price" type="shop_currency_value"></p>
<p class="small text-muted mb-1">£<perch:shop id="incVAT"> inc VAT</p>
</div>
</div>
</div>
<perch:after>
</div>
</div>
</perch:after>

Display More

Glen · Jul 6th 2021

Hi Mxkert many thanks for your help.

Unfortunately, I am still getting all the ex VAT prices listed like so...

£5.656.255.757.506.256.257.506.255.9997.993.4946.997.958.35 inc VAT

Glen

Glen · Jul 6th 2021

Hi All

I'm currently building a full online shop for trade customers only, so it shows all prices as ex VAT but I also wish to include the inc VAT price too for those not VAT registered.

I've got it to work perfectly on a single product page but am having problems displaying it on a product list page, this is what I've got so far to display the product listing...

Code

perch_shop_products([
'category' => 'products/'.perch_get('path').'/',
'template' => 'products/list-category.html',
'each' => function($item) {
$item['incVAT'] = perch_shop_products([
'template' => 'products/ex_vat.html',
$VAT = '1.20',
$incVAT = number_format($exVAT * $VAT, 2),
], true);
return $item;
},
]);

Display More

...this is basically listing all the ex VAT prices for all products in one string... £6.255.757.506.256.257.506.255.655.9997.993.4946.997.958.35 inc VAT.

Any help to get this to work out the inc VAT price for each product individually would be much appreciated.

Glen

Glen · Jul 6th 2021

Thank you Byron Fitzgerald I'll give that a go.

GLen

Glen · Jul 5th 2021

Hi All

Quick question, is there a way of automatically adding a discount in Perch Shop when a customer buys more than 5 of the same product?

This needs to be on selected products only.

I could set up a discount code but would prefer the discount to be applied automatically.

Many thanks

Glen

Glen · Jun 17th 2021

Hi all

I am using subcategories to structure my Perch Shop products and as such, I am trying to create a breadcrumb using the category structure, like so...

Home > Cat Title > Subcat Ttile > Product Name

So far I have got it to work but it only displays the subcategory (Subcat Title) and not the top category as well.

Code

<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="/">Home</a></li>
<li class="breadcrumb-item"><perch:categories id="category" set="products"><a href="/<perch:category id="catPath">"><perch:category id="catTitle"></a></perch:categories></li>
<li class="breadcrumb-item active" aria-current="page"><perch:shop id="title" type="text" /></li>
</ol>

..how do I get it to display the full category path, please?

Many thanks as always.

Glen

Glen · May 22nd 2021

Quote from SixTillNine

I think the updating of first-party add-ons is just as important now.

Agreed. I would rather see this first before Perch 4

Glen · May 20th 2021

Hi Clive Walker, many thanks for your help as always.

Unfortunately, using perch_first_in_set etc I can't seem to get that to output anything?

Glen

Glen · May 18th 2021

Hi All

Quick one, is there a way to set the pagination template so that it doesn't show the first page and last page numbers. So for example, it currently displays as...

1 ... 4 5 6 7 ... 10

...I'm trying to display it as simply as...

4 5 6 7

...so just the 'middle' page numbers.

Many thanks as always

Glen

Posts by Glen

Perch Shop: Displaying ex VAT & inc VAT on Product Listing

Perch V4 (and future) Megathread

Display class="active" when viewing matched category in categories list

Subscribe form not adding contacts to Mailchimp

Display class="active" when viewing matched category in categories list

Perch Shop: Displaying ex VAT & inc VAT on Product Listing

Subscribe form not adding contacts to Mailchimp

Perch Shop: Displaying ex VAT & inc VAT on Product Listing

Perch Shop: Displaying ex VAT & inc VAT on Product Listing

Perch Shop: Displaying ex VAT & inc VAT on Product Listing

Perch Shop: Displaying ex VAT & inc VAT on Product Listing

Perch Shop: Displaying ex VAT & inc VAT on Product Listing

Perch Shop: Displaying ex VAT & inc VAT on Product Listing

Perch Shop: Displaying ex VAT & inc VAT on Product Listing

Perch Shop Quantity Discount

Perch Shop Quantity Discount

Categories Breadcrumb

Perch Update 3.2

Setting Pagination Not To show First and Last Page Numbers

Setting Pagination Not To show First and Last Page Numbers