Osclass Support Forums
Osclass plugin support => Business Profile Plugin => Topic started by: Cephas on October 24, 2022, 02:54:01 AM
-
Hello,
The business profiles on my home page show the latest business profile first. How can I order them randomly?
-
Go to model/ModelBPR.php and search for "public function getSellers"
You have different order methods here, like:
$this->dao->orderby('uv.i_items DESC');
$this->dao->orderby('b.pk_i_id DESC');
-
What needs to be changed here?
// GET ALL SELLERS
public function getSellers($enabled = -1, $verified = -1, $type = -1, $limit = array(), $pattern = '', $city = '', $category = '', $order = 'RANDOM', $ids = array()) {
$this->dao->select('b.*');
$this->dao->from($this->getTable_bp() . ' as b');
if($enabled <> -1) {
$this->dao->where('b.b_enabled', $enabled);
}
if($verified <> -1) {
$this->dao->where('b.b_verified', $verified);
}
if($type <> -1) {
$this->dao->where('b.i_type', $type);
}
if($order == 'RANDOM' && is_array($ids) && !empty($ids)) {
$ids = implode(',', $ids);
$this->dao->where('b.pk_i_id in (' . $ids . ')');
}
if($order == 'NEW') {
$this->dao->orderby('b.pk_i_id DESC');
}
if($order == 'ITEMS') {
$this->dao->join($this->getTable_user() . ' as uv', '(b.fk_i_user_id = uv.pk_i_id)', 'INNER');
$this->dao->orderby('uv.i_items DESC');
}
-
Change
$this->dao->orderby('b.pk_i_id DESC');
To whatever you need.
-
Strange, the changes are not showing up.
-
Have you cleared the cache and CDN?
-
Have you cleared the cache and CDN?
Yes.
-
Strange, the changes are not showing up.
Thanks for asking this question and Thanks to MB Themes for showing the path.
Even I was thinking this for a while but forgot to ask this question here.
So, if you are using Epsilon theme you can try the following as I am not sure if it works with any other themes.
Replace this code
$this->dao->orderby('b.pk_i_id DESC');
With this code
$this->dao->orderby('rand()','b.pk_i_id');
-
Strange, the changes are not showing up.
Thanks for asking this question and Thanks to MB Themes for showing the path.
Even I was thinking this for a while but forgot to ask this question here.
So, if you are using Epsilon theme you can try the following as I am not sure if it works with any other themes.
Replace this code
$this->dao->orderby('b.pk_i_id DESC');
With this code
$this->dao->orderby('rand()','b.pk_i_id');
This also works in Delta. But only in the widget on the main page. On the company page sorting from old to new.
-
One function in model holds multiple scenarios of plugin.
There are multiple orderby functions based on type
-
Strange, the changes are not showing up.
Thanks for asking this question and Thanks to MB Themes for showing the path.
Even I was thinking this for a while but forgot to ask this question here.
So, if you are using Epsilon theme you can try the following as I am not sure if it works with any other themes.
Replace this code
$this->dao->orderby('b.pk_i_id DESC');
With this code
$this->dao->orderby('rand()','b.pk_i_id');
This also works in Delta. But only in the widget on the main page. On the company page sorting from old to new.
Hi,
What I did is just created a new function
Just Below
if($order == 'NEW') {
$this->dao->orderby('rand()','b.pk_i_id');
}
I created
if($order == '') {
$this->dao->orderby('rand()','b.pk_i_id');
}
In the above code I just removed NEW and kept 'Apostrophe'
It worked for me. But its good that the developers of this plugin confirm if its correct because I am not sure if this will affect the plugins functionality anyhow.
-
It looks good.
It only can affect ordering in front/backoffice.
You can always see current ordering by reviewing SQL queries
-
Strange, the changes are not showing up.
Thanks for asking this question and Thanks to MB Themes for showing the path.
Even I was thinking this for a while but forgot to ask this question here.
So, if you are using Epsilon theme you can try the following as I am not sure if it works with any other themes.
Replace this code
$this->dao->orderby('b.pk_i_id DESC');
With this code
$this->dao->orderby('rand()','b.pk_i_id');
This also works in Delta. But only in the widget on the main page. On the company page sorting from old to new.
Hi,
What I did is just created a new function
Just Below
if($order == 'NEW') {
$this->dao->orderby('rand()','b.pk_i_id');
}
I created
if($order == '') {
$this->dao->orderby('rand()','b.pk_i_id');
}
In the above code I just removed NEW and kept 'Apostrophe'
It worked for me. But its good that the developers of this plugin confirm if its correct because I am not sure if this will affect the plugins functionality anyhow.
Thanks! This is what you need!
-
Hi,
I would also like to change the order (randomize) of the companies on the "/companies" page.
However i can't find the file where you made the above mentioned changes in the code.
Could someone inform me in which file this needs to be changed?
-
Its model/ModelBPR.php, there is general function for profiles search
-
For sorting on mainpage (main.php) use this code (example from Epsilon):
<div class="business-box">
<?php echo bpr_companies_block(eps_param('company_home_count'), 'RANDOM'); ?>
it is usually set to 'NEW'
So it's better for update-ability of BPR Plugin if edited in a child theme.