CommunityBuilder - Code Snippets

function array_find($needle, $haystack)

{

  foreach ($haystack as $key => $item)

  {

      if (strpos($item, $needle) !== FALSE)

      {

        return $key;

        break;

      }

  }

  return false;

}

$formData = $formModel->formData;

// Get the list of interests and which ones are additionsadditions

$interests = json_decode($formData['member_interests___member_interests']);

$additions = json_decode($formData['member_interests___member_interests_additions']);

// If there are no additions just return

if ( !is_array($additions) | count($additions) == 0)

  return true;

 

// get the list of existing interests

$db  = JFactory::getDBO();

$query = $db->getQuery(true);

$query

  ->select("params")

  ->from("#__fabrik_elements")

    ->where("name='member_interests'");

$db->setQuery($query);

$params = json_decode(htmlspecialchars_decode($db->loadResult()));

$existing = $params->sub_options->sub_values;

asort($existing);

 

// Go through each addition, change to uppercase words and set the value to a single

// word by replacing spaces, dashes and slashes with underscores. While we are at it

// remove the additions from the interests so we can ensure no duplications

foreach ($additions as $key => $addition) {

  unset($interests[array_search($additions[$key]->val, $interests)]);

  $additions[$key]->val = str_replace(array(" ", "-", "/"), "_", ucwords($additions[$key]->val));

  $additions[$key]->label = ucwords($additions[$key]->label);

}

 

// Now go again to ensure the addition isn't using a name that already exists

// and that the member hasn't tried to add the addition twice

// a name exists when the new name is the same as a part of an exiting name

// examples are a new interest of Golf when Golfing is already an interest

// or new Games when Board Games exists

$failures = array();

foreach ($additions as $key => $addition) {

  if (array_find($addition->val, $existing) !== false ) {

        // The interest word is already in an existing interest

        $failures[] = $addition;    // Add it to the failures list

        unset($additions[$key]);    // Remove it from the additions list

        continue;

  }

  // It isn't in the existing list, check that the name is not used twice in the additions

  foreach ($additions as $aKey => $add) {

    if ($aKey == $key) continue;    // Don't check against itself

    if (strpos($add->val, $addition->val) !== false) {

        // The interest word is already in an existing addition

        $failures[] = $addition;    // Add it to the failures list

        unset($additions[$key]);    // Remove it from the additions list

        continue;

    }

  }

}

// And one last test, make sure that the new interest doesn't clash with an existing interest

// in this case we check against a new value of Board Games when Games already exists

foreach ($existing as $exists) {

    foreach ($additions as $key => $addition) {

        if ( strpos($addition->val, $exists ) !== false ) {

            // an existing interest contains the new addition word

            $failures[] = $addition;    // Add it to the failures list

            unset($additions[$key]);    // Remove it from the additions list

            continue;

        }

    }

}

// For failures

if ( count($failures) > 0 ) {

    $text = "";

 

    foreach ($failures as $key => $failure) {

        if ($key>0)

            $text .= ", ";

        $text .= $failure->label;

    }

 

    if (count($failures) == 1 )

        $message = "Your addition $text is invalid.";

    else

        $message = "Your additions $text are invalid.";

    $message .= " The name exists as part of an existing interest or an existing interest is contained in this addition.<br>Please select another name";

    $this->setMessage($message);

    return false;

}

return true;

/* code to take the picklist and save it to CB */

$formData = $formModel->formData;

/* Convert things like & to correct characters, decode into an array and drop empty Elements */

$interests = $formData['member_interests___member_interests'];

$additions = json_decode(htmlspecialchars_decode($formData['member_interests___member_interests_additions']));

// If there are no additions just return

if ( !is_array($additions) | count($additions) == 0)

  return true;

 

// Go through each addition, change to uppercase words and set the value to a single

// word by replacing spaces, dashes and slashes with underscores.

foreach ($additions as $key => $addition) {

  // find the addition in the interests array

  $iKey = array_search($addition->val, $interests);

  // set the value to a ucword unique string, and ucword the label

  $additions[$key]->val = str_replace(array(" ", "-", "/"), "_", ucwords($additions[$key]->val));

  $additions[$key]->label = ucwords($additions[$key]->label);

  // ucword the interest

  $interests[$iKey] = $additions[$key]->val;

}

// sort alphanumerically

sort($interests, SORT_STRING | SORT_FLAG_CASE);

 

// First, make sure the addition is not in twice

foreach ($interests as $key =>$interest) {

  $tmp = $interests;

  unset($tmp[$key]);

    if (in_array($interest, $tmp))

        unset($interests[$key]);    // Duplicate

}

/* The following validates whether an interest is leftover in the formData as a result

* of an addition Validation failure. There is a bug in the picklist that leaves the

* addition in the interests list. Fabrik knows about it but it is a big job to

* correct. I can dix it simply here by validating that the interest exists either

* in the list of existing interests or in the additions.

*/

// get the list of existing interests

$db    = JFactory::getDBO();

$query = $db->getQuery(true);

$query

    ->select("params")

    ->from("#__fabrik_elements")

    ->where("name='member_interests'");

$db->setQuery($query);

$params = json_decode(htmlspecialchars_decode($db->loadResult()));

$existing = $params->sub_options->sub_values;

asort($existing);

foreach ($interests as $key => $interest ) {

  if ( strlen($interest) == 0 ) continue;

  if (!in_array($interest, $existing) ) {

    foreach($additions as $addition) {

        if ($interest == $addition->val)

            continue 2;

    }

    unset($interests[$key]);    // didn't find it, drop it

  }

}

// encode the both

$interests_raw = json_encode(array_values($interests));

$additions = json_encode($additions);

// Put the values back into the form

$formModel->updateFormData('member_interests___member_interests', array_values($interests));

$formModel->updateFormData('member_interests___member_interests_raw', $interests_raw);

$formModel->updateFormData('member_interests___member_interests_additions', $additions);

{source}<?php

$jinput = JFactory::getApplication()->input;

$id = $jinput->get('member_interests___id');

 

$db = JFactory::getDBO();

$user = JFactory::getUser();

$query = $db->getQuery(true);

$query

->select('mi.member_interests')

->from('member_interests AS mi')

->where("mi.id=$id");

$db->setQuery($query);

/* Convert things like &amp; to correct characters, decode into an array and drop empty Elements */

$values = array_filter(json_decode(htmlspecialchars_decode ($db->loadResult())));

// sort alphanumerically

sort($values, SORT_STRING | SORT_FLAG_CASE);

 

/* Now get the labels associated with these values */

$query = $db->getQuery(true);

$query

->select("params")

->from("#__fabrik_elements")

->where("name='member_interests'");

$db->setQuery($query);

$Options = json_decode($db->loadResult())->sub_options;

$labels = array();

foreach($values as $value) {

$labels[] = $Options->sub_labels[array_search($value, $Options->sub_values)];

}

 

// Get labels and values back into strings

$labels = implode(", ", $labels);

$values = implode(", ", $values);

 

// now update the cb database, it uses the values for searching

$query = $db->getQuery(true);

$query

->update('#__comprofiler')

->set('cb_member_interests = ' . $db->quote($values))

->where('user_id=' . $user->id);

$db->setQuery($query);

$db->execute();

 

// Now update the form data,

// cb_member_interests is the cb data and is the values and is hidden

// cb_member_interests_disp is what the user sees and is the labels

echo '<script language="Javascript" type="text/Javascript">'

. 'el = window.parent.document.getElementById("cb_member_interests");'

. 'el.value = "' . $values . '";'

. 'el = window.parent.document.getElementById("cb_member_interests_disp");'

. 'el.value = "' . $labels . '";'

. 'parent.jQuery.colorbox.close();'

. '</script>';

?>{/source}