Get JetEngine Related Items programmatically / Update related items / Get/Update relation meta

get-related.md

Methods

All these are to be called on 'init' action with the priority of 12 or later
Before init 12 there are no relations registered

Get relation object

This is to get Relation object by its ID (https://prnt.sc/zCOroTie86bL)
(object of this class \jet-engine\includes\components\relations\relation.php)

Necessary to work with relation

   $relation = jet_engine()->relations->get_active_relations( $rel_id ); 

Get related items

These are to get parents/children of the Post/CCT/Term/User from above-mentioned relation object
$object_id - ID of the object for which you need to get parents/children;
$field - 'ids' to return array of related items IDs, 'all' to return array of rows from database

   $field = 'ids';
   $related_ids = $relation->get_parents( $object_id, $field );
   $related_ids = $relation->get_children( $object_id, $field );

Returns related items for given object. Automatically detects - we need to get children or parent items by object.
pass object as a first argument, not object id

   $related_ids = $relation->get_related_items_for_object( $object );

Update related items

Set relation update context - 'parent' or 'child'

   $relation->set_update_context( 'parent' );

Update relation

   $relation->update( $parent_object_id, $child_object_id );

Delete parents / children

if $parent_object_id is empty - delete all rows for current relations which have $child_object_id
if $child_object_id is empty - delete all rows for current relations which have $parent_object_id
CAUTION: if both empty - all rows for the relation will be deleted
$clear_meta - true / false, whether to delete associated meta; default true

   $relation->delete_rows( $parent_object_id, $child_object_id, $clear_meta )

---

Get meta value by key for parent+child pair

   $relation->get_meta( $parent_object_id, $child_object_id, $meta_key );

Update meta for parent+child pair

   $relation->update_meta( $parent_object_id, $child_object_id, $meta_key, $meta_value );

Delete meta for parent+child pair

   $relation->delete_meta( $parent_object_id, $child_object_id, $meta_key );

Hooks

Before connection items

add_action( 'jet-engine/relation/update/before', function( $parent_object_id, $child_object_id, $relation ) {

}, 0, 3 );

runs before connecting items with relation
$parent_object_id, $child_object_id - IDs of items
$relation - object of Relation class

After connecting items

add_action( 'jet-engine/relation/update/after', function( $parent_object_id, $child_object_id, $item_id, $relation ) {

}, 0, 4 );

runs after connecting items with relation
$parent_object_id, $child_object_id - IDs of items
$item_id - ID of inserted record
$relation - object of Relation class

So helpful!

Very helpful. Thanks.

I use the last action. It works for the initial connecting but not if I change the meta field value of a existing relation.

My usecase is:

I have a "Job CCT". The relation is one to many between Job CCT and user. There is one job and many people can apply for it. The relation has got a meta field called "status" where I select "applied", "meeting", "canceled" etc.

I want to fire actions if this meta field value changes. If the status changes from applied to canceld, I want to send an e-mail.

Which hook can I use for this?

Thank you very much.

EDIT:

I think I found a solution:

add_action('jet-engine/relation/update-all-meta/after', function ($parent_object, $child_object, $new_meta, $old_meta) {
    write_log('jet-engine/relation/update-all-meta/after');

    if (is_array($new_meta) && isset($new_meta['status'])) {

        $relation = jet_engine()->relations->get_active_relations(13);
        $user_rows = $relation->get_children($parent_object, 'all');
        $user_id = 0;
        if (is_array($user_rows) && count($user_rows) > 0)
            $user_id = (int)$user_rows[0]['child_object_id'];

        if ($user_id > 0):
            $user = get_user_by('ID', $user_id);
            if ($user instanceof WP_User):
                $user_email = $user->user_email;
                $user_name = $user->display_name;
                $user_first_name = $user->first_name;
                $user_last_name = $user->last_name;

                switch ($new_meta['status']):
                    case 'in planning':

                        break;
                    case 'planned':

                        wp_mail($user_email, 'Planned', 'Planned');
                        break;

                    case 'canceled':

                        break;

                    case 'realized':

                        break;
                endswitch;
            endif;
        endif;

    }
}, 12, 4);

Very helpful, i was building a CRM in which the client need to upload leads from excel and assign it directly to agents. The assignment is relation but not to make agent as post author; thus this 3 lines of codes help a lot.

Thanks

Very Helpful, Is it possible to append multiple items in same parent object or isnerted psot id using loop. I ahve multiple ods in array but update method connect only last one...

Hi folks,
I'm using the jet-engine/relation/update/after action to add an ID to a meta field when a relation is connected. However, when the relation is disconnected, the ID doesn't get removed.

Is there any JetEngine action hook that runs specifically when a relation is disconnected?

Yo estuve ayer analizando términos y condiciones de diferentes operadores y comparando estrategias de conversión de bonos, y terminé con la cabeza tan saturada de porcentajes y letras pequeñas que necesitaba un respiro total. Un colega me recomendó entrar en casoola casino y aproveché los bonos para España que tienen ahora. Empecé con mala racha, pero en la última jugada gané un premio que me cambió el ánimo. ¡Es ideal para desconectar tras descifrar la letra pequeña de las promociones!