Osclass forums
Development => Development => Topic started by: Sophia_OS on April 03, 2019, 12:11:42 pm
-
Please someone explain me about osclass search result list ordering system! I want to know more about this! For example when we search for something, and it orders the result, ordering is based on what? Based on old post to new post? Or exactly what? For example if there is 2 items with the same title but different published date, which one listed first on search result list?
Where is the code exactly? The code that shows the result list order on loop on search.php after we push the apply button!
Not the code for searching and finding the items. the code for ordering the result list on search.php.
Thanks
-
Not the code for searching and finding the items. the code for ordering the result list on search.php.
These are two contradicting statements, to me at least. Search is always about 'finding', regardless of input.
In any case, by default, ordering is by date from latest (newest) to oldest.
For example if there is 2 items with the same title but different published date, which one listed first on search result list?
By default, again, they will be sorted by date, newer one first. You can easily verify this by yourself.
-
By default, again, they will be sorted by date, newer one first. You can easily verify this by yourself.
Yes i know that! But i just asked this question to find out where this exactly happens by code!
Please address me the code exactly this happens!
Not the whole script! Just the line of code that this happens!
Thanks,
-
Look in search model and controller, it's not exactly 'one line', you have to understand the code flow.
-
osclass / Osclass
Code Issues 84 Pull requests 20 Projects 0 Wiki Pulse
oc-includes/osclass/model/Search.php
<?php if ( !defined('ABS_PATH') ) exit('ABS_PATH is not loaded. Direct access is not allowed.');
/*
* Copyright 2014 Osclass
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
/**
*
*/
class Search extends DAO
{
/**
*
* @var type
*/
private $conditions;
private $itemConditions;
private $tables;
private $tables_join; // ?
private $sql;
private $order_column;
private $order_direction;
private $limit_init;
private $results_per_page;
private $cities;
private $city_areas;
private $regions;
private $countries;
private $categories;
private $search_fields;
private $total_results;
private $total_results_table;
private $sPattern;
private $sEmail;
private $groupBy;
private $having;
private $locale_code;
private $withPattern;
private $withPicture;
private $withLocations;
private $withCategoryId;
private $withUserId;
private $withItemId;
private $withNoUserEmail;
private $onlyPremium;
private $price_min;
private $price_max;
private $user_ids;
private $itemId;
private $userTableLoaded;
private static $instance;
public static function newInstance()
{
if( !self::$instance instanceof self ) {
self::$instance = new self;
}
return self::$instance;
}
/**
*
*/
function __construct($expired = false)
{
parent::__construct();
$this->setTableName('t_item');
$this->setFields( array('pk_i_id') );
$this->withPattern = false;
$this->withLocations = false;
$this->withCategoryId = false;
$this->withUserId = false;
$this->withPicture = false;
$this->withNoUserEmail = false;
$this->onlyPremium = false;
$this->price_min = null;
$this->price_max = null;
$this->user_ids = null;
$this->itemId = null;
$this->userTableLoaded = false;
$this->city_areas = array();
$this->cities = array();
$this->regions = array();
$this->countries = array();
$this->categories = array();
$this->conditions = array();
$this->tables = array();
$this->tables_join = array();
$this->search_fields = array();
$this->itemConditions = array();
$this->locale_code = array();
$this->groupBy = '';
$this->having = '';
$this->order();
$this->limit();
$this->results_per_page = 10;
if(!$expired) {
// t_item
$this->addItemConditions(sprintf("%st_item.b_enabled = 1 ", DB_TABLE_PREFIX));
$this->addItemConditions(sprintf("%st_item.b_active = 1 ", DB_TABLE_PREFIX));
$this->addItemConditions(sprintf("%st_item.b_spam = 0", DB_TABLE_PREFIX));
$this->addItemConditions(sprintf("(%st_item.b_premium = 1 || %st_item.dt_expiration >= '%s')", DB_TABLE_PREFIX, DB_TABLE_PREFIX, date('Y-m-d H:i:s')) );
}
$this->total_results = null;
$this->total_results_table = null;
// get all item_location data
if(OC_ADMIN) {
$this->addField(sprintf('%st_item_location.*', DB_TABLE_PREFIX) );
}
}
/**
* Return an array with columns allowed for sorting
*
* @return array
*/
public static function getAllowedColumnsForSorting()
{
return( array('i_price', 'dt_pub_date', 'dt_expiration') );
}
/**
* Return an array with type of sorting
*
* @return array
*/
public static function getAllowedTypesForSorting()
{
return ( array (0 => 'asc', 1 => 'desc') );
}
// juanramon: little hack to get alerts work in search layout
public function reconnect()
{
// $this->conn = getConnection();
}
/**
* Add conditions to the search
*
* @access public
* @since unknown
* @param mixed $conditions
*/
public function addConditions($conditions)
{
if(is_array($conditions)) {
foreach($conditions as $condition) {
$condition = trim($condition);
if($condition!='') {
if(!in_array($condition, $this->conditions)) {
$this->conditions[] = $condition;
}
}
}
} else {
$conditions = trim($conditions);
if($conditions!='') {
if(!in_array($conditions, $this->conditions)) {
$this->conditions[] = $conditions;
}
}
}
}
/**
* Add item conditions to the search
*
* @access public
* @since unknown
* @param mixed $conditions
*/
public function addItemConditions($conditions)
{
if(is_array($conditions)) {
foreach($conditions as $condition) {
$condition = trim($condition);
if($condition!='') {
if(!in_array($condition, $this->itemConditions)) {
$this->itemConditions[] = $condition;
}
}
}
} else {
$conditions = trim($conditions);
if($conditions!='') {
if(!in_array($conditions, $this->itemConditions)) {
$this->itemConditions[] = $conditions;
}
}
}
}
/**
* Add locale conditions to the search
*
* @access public
* @since 3.2
* @param string $locale
*/
public function addLocale($locale)
{
if(is_array($locale)) {
foreach($locale as $l) {
if($l!='') {
$this->locale_code[$l] = $l;
}
}
} else {
if($locale!='') {
$this->locale_code[$locale] = $locale;
}
}
}
/**
* Add new fields to the search
*
* @access public
* @since unknown
* @param mixed $fields
*/
public function addField($fields)
{
if(is_array($fields)) {
foreach($fields as $field) {
$field = trim($field);
if($field!='') {
if(!in_array($field, $this->fields)) {
$this->search_fields[] = $field;
}
}
}
} else {
$fields = trim($fields);
if($fields!='') {
if(!in_array($fields, $this->fields)) {
$this->search_fields[] = $fields;
}
}
}
}
/**
* Add extra table to the search
*
* @access public
* @since unknown
* @param mixed $tables
*/
public function addTable($tables)
{
if(is_array($tables)) {
foreach($tables as $table) {
$table = trim($table);
if($table!='') {
if(!in_array($table, $this->tables)) {
$this->tables[] = $table;
}
}
}
} else {
$tables = trim($tables);
if($tables!='') {
if(!in_array($tables, $this->tables)) {
$this->tables[] = $tables;
-
Look in search model and controller, it's not exactly 'one line', you have to understand the code flow.
I didn't say one line! I said all the lines related to this purpose!
-
osclass / Osclass
Code Issues 84 Pull requests 20 Projects 0 Wiki Pulse
oc-includes/osclass/model/Search.php
<?php if ( !defined('ABS_PATH') ) exit('ABS_PATH is not loaded. Direct access is not allowed.');
/*
* Copyright 2014 Osclass
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
/**
*
*/
class Search extends DAO
{
/**
*
* @var type
*/
private $conditions;
private $itemConditions;
private $tables;
private $tables_join; // ?
private $sql;
private $order_column;
private $order_direction;
private $limit_init;
private $results_per_page;
private $cities;
private $city_areas;
private $regions;
private $countries;
private $categories;
private $search_fields;
private $total_results;
private $total_results_table;
private $sPattern;
private $sEmail;
private $groupBy;
private $having;
private $locale_code;
private $withPattern;
private $withPicture;
private $withLocations;
private $withCategoryId;
private $withUserId;
private $withItemId;
private $withNoUserEmail;
private $onlyPremium;
private $price_min;
private $price_max;
private $user_ids;
private $itemId;
private $userTableLoaded;
private static $instance;
public static function newInstance()
{
if( !self::$instance instanceof self ) {
self::$instance = new self;
}
return self::$instance;
}
/**
*
*/
function __construct($expired = false)
{
parent::__construct();
$this->setTableName('t_item');
$this->setFields( array('pk_i_id') );
$this->withPattern = false;
$this->withLocations = false;
$this->withCategoryId = false;
$this->withUserId = false;
$this->withPicture = false;
$this->withNoUserEmail = false;
$this->onlyPremium = false;
$this->price_min = null;
$this->price_max = null;
$this->user_ids = null;
$this->itemId = null;
$this->userTableLoaded = false;
$this->city_areas = array();
$this->cities = array();
$this->regions = array();
$this->countries = array();
$this->categories = array();
$this->conditions = array();
$this->tables = array();
$this->tables_join = array();
$this->search_fields = array();
$this->itemConditions = array();
$this->locale_code = array();
$this->groupBy = '';
$this->having = '';
$this->order();
$this->limit();
$this->results_per_page = 10;
if(!$expired) {
// t_item
$this->addItemConditions(sprintf("%st_item.b_enabled = 1 ", DB_TABLE_PREFIX));
$this->addItemConditions(sprintf("%st_item.b_active = 1 ", DB_TABLE_PREFIX));
$this->addItemConditions(sprintf("%st_item.b_spam = 0", DB_TABLE_PREFIX));
$this->addItemConditions(sprintf("(%st_item.b_premium = 1 || %st_item.dt_expiration >= '%s')", DB_TABLE_PREFIX, DB_TABLE_PREFIX, date('Y-m-d H:i:s')) );
}
$this->total_results = null;
$this->total_results_table = null;
// get all item_location data
if(OC_ADMIN) {
$this->addField(sprintf('%st_item_location.*', DB_TABLE_PREFIX) );
}
}
/**
* Return an array with columns allowed for sorting
*
* @return array
*/
public static function getAllowedColumnsForSorting()
{
return( array('i_price', 'dt_pub_date', 'dt_expiration') );
}
/**
* Return an array with type of sorting
*
* @return array
*/
public static function getAllowedTypesForSorting()
{
return ( array (0 => 'asc', 1 => 'desc') );
}
// juanramon: little hack to get alerts work in search layout
public function reconnect()
{
// $this->conn = getConnection();
}
/**
* Add conditions to the search
*
* @access public
* @since unknown
* @param mixed $conditions
*/
public function addConditions($conditions)
{
if(is_array($conditions)) {
foreach($conditions as $condition) {
$condition = trim($condition);
if($condition!='') {
if(!in_array($condition, $this->conditions)) {
$this->conditions[] = $condition;
}
}
}
} else {
$conditions = trim($conditions);
if($conditions!='') {
if(!in_array($conditions, $this->conditions)) {
$this->conditions[] = $conditions;
}
}
}
}
/**
* Add item conditions to the search
*
* @access public
* @since unknown
* @param mixed $conditions
*/
public function addItemConditions($conditions)
{
if(is_array($conditions)) {
foreach($conditions as $condition) {
$condition = trim($condition);
if($condition!='') {
if(!in_array($condition, $this->itemConditions)) {
$this->itemConditions[] = $condition;
}
}
}
} else {
$conditions = trim($conditions);
if($conditions!='') {
if(!in_array($conditions, $this->itemConditions)) {
$this->itemConditions[] = $conditions;
}
}
}
}
/**
* Add locale conditions to the search
*
* @access public
* @since 3.2
* @param string $locale
*/
public function addLocale($locale)
{
if(is_array($locale)) {
foreach($locale as $l) {
if($l!='') {
$this->locale_code[$l] = $l;
}
}
} else {
if($locale!='') {
$this->locale_code[$locale] = $locale;
}
}
}
/**
* Add new fields to the search
*
* @access public
* @since unknown
* @param mixed $fields
*/
public function addField($fields)
{
if(is_array($fields)) {
foreach($fields as $field) {
$field = trim($field);
if($field!='') {
if(!in_array($field, $this->fields)) {
$this->search_fields[] = $field;
}
}
}
} else {
$fields = trim($fields);
if($fields!='') {
if(!in_array($fields, $this->fields)) {
$this->search_fields[] = $fields;
}
}
}
}
/**
* Add extra table to the search
*
* @access public
* @since unknown
* @param mixed $tables
*/
public function addTable($tables)
{
if(is_array($tables)) {
foreach($tables as $table) {
$table = trim($table);
if($table!='') {
if(!in_array($table, $this->tables)) {
$this->tables[] = $table;
}
}
}
} else {
$tables = trim($tables);
if($tables!='') {
if(!in_array($tables, $this->tables)) {
$this->tables[] = $tables;
This is the code for whole search!
I just need the part that orders listing in loop after search!
-
the reason that I'm looking for this is to change the search result list order!
I don't want to order the result by date!
I want the result order be randomized! Each time user push the Apply button to search, it shows the result list completely different than before! Each time be different! Shows the result list randomly each time for user!
If we find that part of the code, then we could put (randomized function) instead!
-
Please Help to solve this topic! Thanks!
-
Like i've told before .
https://www.freelancer.com/job-search/osclass/#
Customizations to your tailored needs done fast and at a good price
-
@Web-Media Thank you very much for recommendation!
This idea is something that i want to share with others!
Would you please tell me where is exactly (listing the result) code? I want to find that code and replace with my randomized function!
Thanks,
-
Look in search model and controller, it's not exactly 'one line', you have to understand the code flow.
Would you please help me to find this part of code? I want to find that and put my randomized function instead!