CiviCRM Community Forums (archive)

Two newbie questions:

a) I need all my Organization contacts to be automatically added to a specific group. I used the civicrm_post hook to do this, rather straighforward and it works well, however when I open the organization contact and go to the groups tab, it is added to the right group (yay) but the Status just says: Added (by ) instead of Added (by Admin) or something similar.

Where in the db is the AddedBy stored?

[code below, is it ok]?


b) Is CRM_Core_DAO:: (and other CRM objects and classes) thoroughly documented anywhere, explaining what attributes each one takes, and which methods are available? I'm not experienced with OOP, this would be very helpful, if it exists somewhere. Not having any luck finding it. Thanks


function foocivihooks_civicrm_post( $op, $objectName, $objectId, &$objectRef ) {

if ( ($op == 'create') && ($objectName == 'Organization') ) {

$q = "INSERT INTO civicrm_group_contact(group_id, contact_id, status) VALUES (9, '$objectId', 'Added')";

CRM_Core_DAO::executeQuery($q);

} elseif ( ($op == 'create') && ($objectName == 'Relationship') ) {

$q = "SELECT contact_id_b, relationship_type_id FROM civicrm_relationship WHERE id='$objectId'";
$dao = CRM_Core_DAO::executeQuery($q);

while ($dao->fetch()) {

if ($dao->relationship_type_id == 4) { // Is employee relationship

$q = "INSERT INTO civicrm_group_contact(group_id, contact_id, status) VALUES (9, '$dao->contact_id_b', 'Added')";
CRM_Core_DAO::executeQuery($q);

}

} // End while

}

}

Good point colemanw! Why didn't I think of that?!