CiviCRM Community Forums (archive)

I'm setting up a membership directory using CiviCRM.  Current progress has been fine, although I don't like the display. 
Here's where I'm at currently:  http://test.azmuseums.org/civicrm/profile?force=1&gid=10

I'd like to combine the name and website into one cell of the display, and combine the address, city, and zip into another cell. 

I think this should be possible, right? 

I've looked at the instructions at http://wiki.civicrm.org/confluence/display/CRMDOC/Customize+Built-in%2C+Profile%2C+Contribution+and+Event+Registration+Screens and I just feel very lost. I'm new to Smarty, and their page didn't help me at all.  I think I understand the concept, but I'm obviously missing something between the concept, and the execution. 

Is there somewhere I can find a bit more detailed walkthrough of what I need to change?  I think I need to create a custom Listings.tpl, but from there I'm a bit lost.
It looks like this is the chunk of code I need to edit:
<table>
      <tr class="columnheader">
      {foreach from=$columnHeaders item=header}
        <th scope="col">
        {if $header.sort}
          {assign var='key' value=$header.sort}
          {$sort->_response.$key.link}
        {else}
          {$header.name}
        {/if}
         </th>
      {/foreach}
      </tr>
   
      {counter start=0 skip=1 print=false}
      {foreach from=$rows item=row name=listings}
      <tr id="row-{$smarty.foreach.listings.iteration}" class="{cycle values="odd-row,even-row"}">
      {foreach from=$row item=value}
        <td>{$value}</td>
      {/foreach}
      </tr>
      {/foreach}
    </table>
Where do I get the tokens to change this table?
Help!?

Yeah, that was this morning's attempt 

The image did present an issue, and so it started to look like this might be easier solved within CiviCRM.

You save me every time!  Now I have a gameplan for how to resolve this next weekend. Thanks!

Okay, so this is failing miserably.
I went through part of the Smarty handbook, and still couldn't figure this out.  No matter I what I do, it won't actually print the required information to the screen. It might put in space for that information, but that's as close as I can get.
Help?

Hello ~

I was wondering mhm if you ever got this working?  I have been trying to do the same (almost exact same thing) for some time now.  After 2 days of researching, reading and trying different things I am still at a loss.

I am trying to have my directory look something like this:

Company Name
Address
city, state, zip

I know I can turn debuggin on and use smartyDebug=1 to show me the field names i need to grab.  The problem is the syntax and what steps need to be taken to diplay the data on the listings.tpl page.

I have tried different things, but the latest I have tried is this:

1) Added the lines of code to Dynamic.php as suggested in this thread: :
 http://forum.civicrm.org/index.php?action=printpage;topic=9037.0

CRM_Core_BAO_UFGroup::getValues( $this->_id, $fields, $values );

 // $profileFields_$gid array can be used for customized display of field labels and values in Profile/View.tpl

            $profileFields = array( );
            $labels = array( );

            foreach ( $fields as $name => $field ) {
                $labels[$field['title']] = preg_replace('/\s+|\W+/', '_', $name);
            }

            foreach ( $values as $title => $value ) {
                $profileFields[$labels[$title]] = array( 'label' => $title,
                                                    'value' => $value );

            }

            $template->assign_by_ref( 'profileFields_' . $this->_gid, $profileFields );

            $template->assign_by_ref( 'row', $values );


I have tried commenting out the last line and also leaving in with the same result for both:
 $template->assign_by_ref( 'row', $values );

Because I wasn't sure if it was supposed to stay in place or not with the added code.




2) Modified the code in Listings.tpl just to see if I could get any value to spit out on the screen

so I added the line:
{$profileFields_19.last_name.value}

{counter start=0 skip=1 print=false}
      {foreach from=$rows item=row name=listings}
      <tr id="row-{$smarty.foreach.listings.iteration}" class="{cycle values="odd-row,even-row"}">
      {foreach from=$row item=value name=listings}        
        {if $smarty.foreach.listings.iteration EQ 6}
         <td><a href='mailto:{$value}'>{$value}</a><br>{$profileFields_19.last_name.value}</td>
        {else}
        <td>{$value}</td>
        {/if}
      {/foreach}
      </tr>
      {/foreach}

The other code you see in there for the email address was somethign Dave helped me with some time ago in this thread: http://forum.civicrm.org/index.php/topic,3145.0.html

So Im not sure if that will need to be changed too or if its good to stay that way (since it does work).


Thats pretty much it.  I just need to find out how to get those variable values into the Listings.tpl page so that i can format them in a table or however i want it to appear in the directory.

HELP!

Any advice or direction would be much appreciated!

Hello Dave,

Thanks for the reply.

As I mention above, I have done the debugging and seen the pop up window with all of the variable / field names / etc.

The question is, is it possible to get those variable values in my listings template to show up without having the hack mentioned here: http://forum.civicrm.org/index.php?action=printpage;topic=9037.0

In IRC, dlobo said the hack is to be included in version 3.x.

With me using 2.2 can it be done?  If so whats the syntax I use in listings.tpl to get them to show up

This will not work for me:

{$profileFields_19.last_name.value}

Thanks again Dave, really hoping to figure this out!

I know this has to be possible and shouldn't be as hard as it seems.

I have tried using this code insde Listings.php

$fields = CRM_Core_BAO_UFGroup::getListingFields( CRM_Core_Action::VIEW,
                                                          CRM_Core_BAO_UFGroup::PUBLIC_VISIBILITY |
                                                          CRM_Core_BAO_UFGroup::LISTINGS_VISIBILITY,
                                                          false, $gid );  
// been trying the code right here in this file - also this next line I have tried with and also commenting out

//CRM_Core_BAO_UFGroup::getValues( $gid, $fields, $values );

 // $profileFields_$gid array can be used for customized display of field labels and values in Profile/View.tpl

            $profileFields = array( );
            $labels = array( );

            foreach ( $fields as $name => $field ) {
                $labels[$field['title']] = preg_replace('/\s+|\W+/', '_', $name);
            }

            foreach ( $values as $title => $value ) {
                $profileFields[$labels[$title]] = array( 'label' => $title, 'value' => $value );

            }

$template->assign_by_ref( 'row', $values );
$template->assign_by_ref( 'profileFields_' . $gid, $profileFields );



// this is where the code I added stops

        $returnProperties =& CRM_Contact_BAO_Contact::makeHierReturnProperties( $fields );
        $returnProperties['contact_type'] = 1;
        $returnProperties['sort_name'   ] = 1;

And I have tried multiple different things in Listings.tpl to get any of these variables to spit out their values but none are working in this syntax

{$profileFields_19.last_name.value}

{$profileFields_19.custom_15.value}

etc.

Can anyone help me out here?

thanks again

The easy way to do this is to basically hard-code the table elements in Listings.tpl. Again, use your smarty debug window to check the contents of the $rows variable (which has all your results data in some arrays). Then you can comment out the inner foreach loop, and replace with hardcoded set of columns. Quick example of hard-coding the first cell with sort_name, city ($row.1 in my profile), and country ($row.2). For the table column headers, you'll need to do something similar (or use some {if} statements to skip header columns you don't need).

HTH

      {counter start=0 skip=1 print=false}
      {foreach from=$rows item=row name=listings}
      <tr id="row-{$smarty.foreach.listings.iteration}" class="{cycle values="odd-row,even-row"}">
      {* (skip this inner looping ) foreach from=$row item=value}
        <td>{$value}</td>
      {/foreach*}
        <td>{$row.sort_name}<br />{$row.1}, {$row.2}</td>
      </tr>
      {/foreach}