[12/31/2016 5:02:27 PM] wassim s: so those tables are fed through another php web application
they are custom named tables where their info are being ulled to the wordpress site using wpdb and shortcodes
[12/31/2016 5:05:58 PM] wassim s: search terms would be for anything that the user might think of while the search results template would have a similar look and feel tot he rest of the pages on the site and provide results similar to common search engine, title and text excerpt showing the text

Here is the site the search will need to be implemented on
p2.stagingcheck.com
the data being pulled from custom tables that will need to be queried in the search results along with the wordpress content is
p2.stagingcheck.com/events
and
p2.stagingcheck.com/tech-mentors
for instance if I searched for the word "Design" I am supposed to get a result from the the Events page above and from a wordpress page https://p2.stagingcheck.com/in5-design/

Now given the fact that the events page loads multiple events on to the same page we will need an events details page to display only the event that has the word design in it. I have mock up for this
Let me know if all is clear


[12/31/2016 5:13:44 PM] Max Sharlaev: ok, I see.
If an event or mentor appears in search results, then when user clicks on result preview to open a details page, it has to be made on custom template (there is no such at the moment, only general pages for all events/mentors).
Should results be sorted by relevancy and/or by date?
[12/31/2016 5:22:15 PM] wassim s: yes to the details page, the mentors detail page will follow generic UI of the site and will display a mentor photo if available or an icon + the details shown on the the general mentor page in addition to couple extra fields from the mentor table
The events details page should be implemented this like the following mockup
https://collaborate.uxpin.com/3e6565f3a66807a759fe8eacdef872c2dd45e404#/pages/64902508/nosidebar

So other than the mentors tables and the events table there are 3 other tables used to pull information into the eventsdetails above (Session,speaker,company)
An event might have sessions associated to it, a session would have one or more speakers and a speaker would belong to a company,
So in a case a user typed a speaker name in the serach query if that speaker was linked to a session which in turn was associated to an event then we should show the link to that event in the search result. Some speakers might not be tied to sessions and thus no events in that case no results would come back.

yes search by relevancy and or date would be good
[12/31/2016 5:28:41 PM] Max Sharlaev: To sum up, the task is to
1. develop a custom search on back-end in specific tables as well as in wp_posts
2. develop a front-end template for search results
3. develop a front-end template for event
4. develop a front-end template for mentor
are mentors table and speakers tables the same? what about companies table, should there be a details page for company too?
[12/31/2016 5:32:46 PM] Max Sharlaev: I'd ask slightly more for this job, 175$ and 3-4 days to do and properly test it.
I can work on my dev server provided a copy of the production website (database and files backup)
[12/31/2016 5:36:29 PM] wassim s: Yes to all point above except that mentors and speakers aren't the same. The companies associated with the events through speakers would not have a details page but another custom table named companies will we might change the naming after. For that page I don't have mockups yet but we can discuss the details.
Is it possible for you to work directly on the server?
I am fine with the 175$ but wondering if it can be done faster?
[12/31/2016 5:41:18 PM] Max Sharlaev: yes, I can work on your server too.
I am afraid not, 3-4 days starting from Monday if that's ok
[12/31/2016 5:49:20 PM] wassim s: Ok I will reward you the project and provide you with the credentials for the server wp-admin and ftp credentials. So Thursday the 5th would be the max delivery date with fully functional search implementation as per above?
Do you have a Skype?
[12/31/2016 5:51:36 PM] Max Sharlaev: yes, provided accesses and mock-ups for pages - January, 5th the deadline.
my skype is rainyday_away
sorry, I've got to go out for 2-3 hours, will be back soon
[12/31/2016 5:53:23 PM] Max Sharlaev: I'm usually available both here and in skype
[12/31/2016 6:09:22 PM] wassim s: Excellent will send you the access info in couple hours and I will award you the project
[12/31/2016 6:27:30 PM] wassim s: Just to reiterate the mock up for mentors will be similar to the vents details where relevant
https://collaborate.uxpin.com/3e6565f3a66807a759fe8eacdef872c2dd45e404#/pages/64902508/nosidebar

As for the search result we will have to come up with the layout following the website general layout and fonts
[12/31/2016 10:13:10 PM] wassim s: I have a WordPress site with a custom theme that is work in progress. I need to support Search on the website the search bar will be in the header of the website. Some content on the website is being pulled from custom database tables (not custom posts) and some fields within those tables will need to be queried.
In short I need a search functionality that combines searches from wp_post table along with couple of custom tables, any result retrieved from the custom tables will link to a specific page relevant to the searched table to display the result.
I search result page will have to be implemented following the genral look and feel of the rest of the pages. Couple other pages will need to be developed (mockup available) to present search results from the custom tables.



[22:45:40] Max Sharlaev: [22:13:47] Wassim Sleiman: hello
ftp: stagingcheck.com
user:p2@stagingcheck.com
pass: *Q7,cx&yD4oc

WORDPRESS admin
admin:frqsef
pass:w2Ho$rjkAJHzJVZ^5(1CEZzP

the fields that should be searched for events table
condition to check against:Event status active and the startdatetime>Current datetime
Table name:
in5_ci_events(event_name,event_from,event_till,event_location,event_description,event_url,registration_url,key_discussion_points,target_audience,location_url)
The below fields are only supposed to show if there is an events linked to them, the concept is as follows
an event might have sessions, sessions would have speakers assigned to them, and  speakers will be associated to companies.
in5_ci_speakers (speaker_name,speaker_title,speaker_designation,speaker_overview,speaker_linkedin_url)
in5_ci_sessions (event_session_description,event_session_from,event_session_till,event_session_location)
in5_ci_companies(company_name,company_url,company_linkedin_url,company_phone,company_address,company_description).

As for Mentors
Mentors (Seearchable only if publish_to_in5=1 and status=1)
in5_ci_mentors(
mentor_name,company,job_position,profile,company_website,linkedin,expertise,expertise_other)
Let me know if you have any questions or you think something should work differently

<<<