CiviCRM Community Forums (archive)

I would like to display this search to non-admin users of the website i.e. visitors. and when I attempt to test this I am getting "Accessed Denied errors".

Try granting "access CiviCRM" (only) permission to anonymous user.

I am also getting the Find Contacts, Advanced Search, Search Builder tabs are still visible.

Here is a simple hack to get rid of those tabs. Add the following code to the file CRM/Core/Menu.php (line-326, inside the method - createLocalTasks )
if ( $path == 'civicrm/contact/search/custom' ) {
            return;
}


Would it be better to approach this via a development of a new module as previously mentioned?

If the custom search you are currently trying to build address your needs, i don't think you need to develop any new module.

Event Description => civicrm_event.description
Event Date => civicrm_event.start_date & civicrm_event.end_date
Event Location =>  civicrm_event.loc_block_id (and civicrm_loc_block table will tell you where to get the address / email ..etc from )

These files might be of some help / give some direction :
- api/v2/Event.php
- api/v2/Participant.php
- CRM/Event/Page/ManageEvent.php

You need to select civicrm_event.loc_block_id and join to civicrm_loc_block.address_id

Check out phpMyAdmin (a web-based tool for browsing and interacting w/ MySQL DB's) - it should help w/ creating your queries and seeing the tables, columns etc.

Hi All,

I have managed to successfully use my phpmyadmin interface to get some of the fields out however i am having some issues locating a few:

1) I am looking for the link for users to register for each event i.e. the "register Now" button. The closest i have found is "civicrm_event.registration_link_text" i have successfully made this return in the results however its is as the name suggests... just the text.

2) Also is it possible to return the event type as text and not as _id value. (event civicrm_event.event_type_id) or do you have to write an if statement to return your event type id's as text.

Yeah i would love to share the this code with everybody, but i would wait for one of the more experienced guys to give it the green light before you give it a go

Hi again

With regards to construct the event url code, How do i call it up so it returns the URL.

i.e. how do i make it work or where would i be able to find more information on making it work

thanks again for all the support
-Adam

Hi All,

I have gotten the code to successfully return results but i am still struggling with returning the URL

The search also seems to be returning the same result 5 times and retuning the "event contact type" instead of "event type"

I have attached the latest version of the code so you can get an idea of what i am talking about. I feel it is pretty close to working but there are a few aforementioned issues that i I am struggling to resolve.

-Adam

Adam - If you are simply trying to search on / list Events, then you should eliminate all the references to civicrm_participant and civicrm_contribution in the query you're building.

The best approach is to uncomment line 149 when running the search - so it spits out the entire query you are currently using. Then paste that query into phpMyAdmin and tweak it until it gives you the columns and rows you want / expect.

With regard to the "event registration link" - you need to:
* include civicrm_event.id as event_id in your select (you need the ID for each event in your row)
* then add an alterRow() function below the all() function - which will modify your 'civicrm_reglink' column and make it a URL (your can eliminate the 'url' column)
// this is untested - but should be close
function alterRow( &$row ) {
        $row['civicrm_reglink'] = '<a href="' .
                                           CRM_Utils_System::url( 'civicrm/event/register', "id={$row['event_id']}&reset=1", true, null, true, true ) .
                                           '">' . $row['civicrm_reglink'] . '</a>';
}

Finally, check out the left join around line 160 in EventAggregate.php to see how to include the Event Type in your query. (test in phpMyAdmin...)

That search form is defined at: CRM/Event/Form/SearchEvent.php which is run from CRM/Event/Page/ManageEvent.php browse() function.