CiviCRM Community Forums (archive)

that was code that still had a few bugs in it and hence that setting was not exposed

if you are a php/mysql/js coder, you can try changing that conditional boolean to 1 and try fixing it

let us know how things go

lobo

I’ve tried to implement some sort of tree in the select box in the basic search screen. This is what I’ve come up width:
Bare in mind that this probably isn’t the best solution, but it works. I’m also not responsible if this breaks your civi crm site.
I’ve created 2 functions in the CRM/Contact/Form/Search/Basic.php file:

function buildTree( $parentGroupID, $numberOfStrips, &$group ) {

        $query = "SELECT id as gid, title as gtitle FROM civicrm_group WHERE parents is NULL order by title";

        if ( $parentGroupID != "NULL" )
        {
                $query = "SELECT id as gid, title as gtitle FROM civicrm_group WHERE parents = ".$parentGroupID." order by title";
        }

        $dao =& CRM_Core_DAO::executeQuery( $query, CRM_Core_DAO::$_nullArray );

        while ( $dao->fetch() ) {

                $strips = "";

                for ( $counter = 1; $counter <= $numberOfStrips; $counter += 1) {
                        $strips = "--".$strips;
}

//              CRM_Core_Error::debug_var('qryJORIS_strips', $strips);

                if ( array_key_exists( $dao->gid, $this->_group ) ) {
                        $group[$dao->gid] = $strips." ".ts($dao->gtitle);
//                      CRM_Core_Error::debug_var('qryJORIS_group', $group);
                }

                if ( $this->hasChildren( $dao->gid ) > 0 )
                {
                        $numberOfStrips = $numberOfStrips + 1;
//                      CRM_Core_Error::debug_var('qryJORIS_children', $dao->gtitle);
                        $this->buildTree( $dao->gid, $numberOfStrips, $group );
                        $numberOfStrips = $numberOfStrips - 1;
                }
                else
                {
//                      CRM_Core_Error::debug_var('qryJORIS_NO_children', $dao->gtitle);
                }
        }
    }

function hasChildren( $groupID ) {

        if ( ! isset($groupID) ) {
//              CRM_Core_Error::debug_var('qryJORIShasChildrenNotSet', $groupID );
                return 0;
        }
        else
        {
//              CRM_Core_Error::debug_var('qryJORIShasChildrenGrpId', $groupID);
                $query = "SELECT id as gidcount FROM civicrm_group WHERE parents = ".$groupID." LIMIT 2";
//              CRM_Core_Error::debug_var('qryJORIShasChildrenQuery', $query);
                $dao =& CRM_Core_DAO::executeQuery( $query, CRM_Core_DAO::$_nullArray );
//              CRM_Core_Error::debug_var('qryJORIShasChildrenCount', $dao->N );
                return $dao->N;
        }
    }

Now in the “buildQuickForm” function you can put this
//                 build tree view
                $groupH=array();
                $this->buildTree( "NULL", 0, $groupH );

//                 add select for groups (new)
                $group = array('' => ts('- any group -')) + $groupH;
                $this->_groupElement =& $this->addElement('select', 'group', ts('in'), $group);

//                 add select for groups (original)
//              $group = array('' => ts('- any group -')) + $this->_group;
//              $this->_groupElement =& $this->addElement('select', 'group', ts('in'), $group);
Instead of
$group = array('' => ts('- any group -')) + $this->_group;
$this->_groupElement =& $this->addElement('select', 'group', ts('in'), $group);

As I’ve said before, this can be improved quite a bit. I’m for instance misusing the original group “$this->_group” to filter out the new values. It would be far better if I create the new group in the same place where “$this->group” is filled (but I can’t seem to find that location).
 
This also doesn’t work for multiple parents, you could get the second item from the db if you change the "=" to a "like" or using the "civicrm_group_nesting" table, but it will not be able to place it in the tree sins the key already exists.

I hope somebody will find this useful somehow or maybe improve this.