Custom field search

[marius-ciclistu]

Are you sure that item has custom fields?

[Sophia_OS]

Are you sure that item has custom fields?

Yes!

[Sophia_OS]

@marius-ciclistu
now i added mc_hide_metas() before main function in functions.php and it worked!
and in item-post.php i put this: <?php ItemForm::description_textarea('description',osc_current_user_locale(), osc_esc_html( mc_hide_metas(bender_item_description(), osc_item_id()) )); ?>
but now there is a few problems,
1. what should i do to put only custom-fields that has value! because it put all the custom-fields in description!
2. it doesn't remove custom-fields when i see a listing or edit a listing!
3. when i edit the item, and edit custom-fields, it does not update custom-fields in description!
Thanks,

[marius-ciclistu]

Use just like in item post, the hide metas in the other 2 places.

You see? If you want you can do it yourself:)

To remove the empty metas, search in google how to test array value or any other question you have, and you will learn to do it your self:)

Follow removeunderline from my ft min word len solution to find the places where you should hide metas.

[Sophia_OS]

@marius-ciclistu
I have a question about your second solution!
Can i ask?

[marius-ciclistu]

Can you?

[Sophia_OS]

@marius-ciclistu
Thank you very much!
With your second solution everything work good. It has only one problem. When i search for example ( android phone ), it shows the results of all title and description and also custom-fields. which is good. But when i search ( "android phone" ), it only shows the results of title and description. But dosnt include the custom-fields search in the result.
How can i fix this to include also custom-fields search in the result when i use double quotation marks?
By the way, double quotation marks is for searching the exact phrase.
And also let you know that i'm using Teseo's (wildcard) and (search in all languages) functions.
Thank you!

[marius-ciclistu]

Those work or worked in google. I think osclass searches for "android and phone" , so the quotes are included in the word. If there is that functionality in your code maybe you don't have andoid phone as a custom field value.

[Sophia_OS]

@marius-ciclistu
Osclass has this functionality! Like google.
I tried also on osclass general demo and worked:

( have for sale ):
https://demo.osclass.org/general/search/pattern,have+for+sale

( "have for sale" ):
https://demo.osclass.org/general/search/pattern,%22have+for+sale%22

Please try these url above and see that is working.

I do have (android phone) in my custom-fields. And it shows in my search results if i search without double quotes.

[marius-ciclistu]

https://dev.mysql.com/doc/refman/5.5/en/fulltext-boolean.html

In the bottom of the page.
That means that maybe the custom fields are searched with the words containing the " characters, as they are not full text search columns (https://doc.osclass.org/Fine-Tuning_MySQL_Full-Text_Search_-_Improving_search)

[Sophia_OS]

@marius-ciclistu
If you test your solution number2, you can see that search method for both (title, description) and (custom-fields) are the same. Check the core file.
I think we could fix this by editing the _makeSQL function!
Please take a look at this code that you gave us. And see if you could fix by editing the _makeSQL function:

https://forums.osclass.org/development/please-help-to-do-this/msg163268/#msg163268

[marius-ciclistu]

I updated the solution from theme.

mods are

Code: [Select]

                    $customfieldCond = '';
                    $trimmedSPattern = trim($this->sPattern);
                    if (!(substr($trimmedSPattern, 0, 1) === '"' && substr($trimmedSPattern, strlen($trimmedSPattern)-1, 1) === '"')) {
                      $explodePattern = explode(' ', str_replace('+', '', str_replace('*', '', $trimmedSPattern)));

                      foreach ($explodePattern as $word) {
                        if ($word) $customfieldCond .= " OR u.s_value LIKE '%" . $word . "%'";
                      }
                    } else {
                       $customfieldCond .= " OR u.s_value LIKE '%" . trim($trimmedSPattern, '"') . "%'";
                    }

[Sophia_OS]

Sorry i didn't understand. Where should i put this code? Please explain. Thanks

[marius-ciclistu]

https://forums.osclass.org/development/please-help-to-do-this/msg163268/#msg163268

[Sophia_OS]

https://forums.osclass.org/development/please-help-to-do-this/msg163268/#msg163268

Did you update this code? If yes, i replaced this code with mine but didn't work!