Hey there, I'm diving into Silver Stripe development and PHP/MySQL for the first time. So bear with me as I navigate through this new territory.
I've got a project that demands a pricing page showcasing various plans on both the pricing page and homepage. My aim is to retrieve data from my Pricing.php page type using my HomePage.ss.
To make this setup future-proof, I decided to create a ServicePlan.php. This file extends DataObject and utilizes a FieldList to establish pricing records linked to the Pricing page type via a $has_many and $has_one relationship. Based on my current knowledge, this seems like the most effective approach.
Below is the code snippet I've written:
ServicePlan.php
class ServicePlan extends DataObject {
private static $db = array (
'PlanColor' => 'Varchar',
'PlanName' => 'Varchar',
'PlanPrice' => 'Varchar',
'PlanRenewal' => 'Varchar',
);
private static $has_one = array (
'Pricing' => 'Pricing'
);
private static $summary_fields = array (
'PlanName' => 'Name of Plan',
'PlanPrice' => 'Price',
'PlanRenewal' => 'Renewal Period',
);
public function getCMSFields() {
$fields = FieldList::create(
TextField::create('PlanName'),
TextField::create('PlanRenewal'),
TextField::create('PlanPrice'),
TextField::create('PlanColor')
);
return $fields;
}
public function getServicePlans() {
return $this->Pricing();
}
Pricing.php
class Pricing extends Page {
private static $has_many = array (
'ServicePlans' => 'ServicePlan',
);
public function getCMSFields() {
$fields = parent::getCMSFields();
$fields->addFieldsToTab('Root.Plans', GridField::create(
'ServicePlans',
'Orenda Force Service Plan Information',
$this->ServicePlans(),
GridFieldConfig_RecordEditor::create()
));
return $fields;
}
}
class Pricing_Controller extends Page_Controller {
}
HomePage.php
class HomePage extends Page {
}
class HomePage_Controller extends Page_Controller {
public function ServiceTeasers($count = 2) {
$holder = ServicesHolder::get()->First();
return ($holder) ? ServicesPage::get()->limit($count) : false;
}
public function MembershipPlans() {
$Pricing = Pricing::get();
return $plan;
}
}
Layout/HomePage.ss
...//
<% loop $MembershipPlans %>
<div class="col-1-3 card pricing">
<div class="pricing__header primary $PlanColor">
<p class="pricing__plan-name">$PlanName</p>
<p class="pricing__price">$PlanPrice<sub>$PlanRenewal</sub></p>
</div>
<div class="card__contents">
<h3 class="title-06">Plan details</h3>
<ul>
<li>unlimited training</li>
<li>individual nutrition/meal plans</li>
</ul>
</div>
</div>
$Content
<% end_loop %>
...//
Currently, I have no trouble accessing the content.
Layout/Pricing.ss
<section class="body pricing">
<div class="content">
<h2 class="title-02 text-monochrome">Pricing</h2>
<% loop $ServicePlans %>
<div class="col-1-3 card pricing">
<div class="pricing__header $PlanColor">
<p class="pricing__plan-name">$PlanName</p>
<p class="pricing__price">$PlanPrice<sub>$PlanRenewal</sub></p>
</div>
<div class="card__contents">
<h3 class="title-06">Plan details</h3>
<ul>
<li>unlimited training</li>
<li>individual nutrition/meal plans</li>
</ul>
</div>
</div>
<% end_loop %>
</div>
</section>
Your guidance means the world to me. I've been wrestling with this challenge for days now, but I keep hitting roadblocks. Any insights on where I might be going wrong?
This question sheds some light on similar issues, but it didn't quite solve mine. Do you think moving the FieldList to the Pricing.php page could be a solution?