- This topic has 3 replies, 2 voices, and was last updated 5 years, 7 months ago by
abdul billoo.
Viewing 3 reply threads
-
AuthorPosts
-
-
June 23, 2019 at 7:39 pm #43021
abdul billoo
ParticipantI would like to know the following.
1. Get current employee meta fields especially the fields created using the paid custom fields.
2. How to sort contacts with custom fields –erp_get_peoples(['type' => 'contact', 'number' => '-1', 'custom_field' => 'value' ])
doesnt work.
-
June 24, 2019 at 12:01 pm #43053
Jay
ParticipantHello @Abdul
You can pass the meta_key through [meta_query]. I’d recommend you to follow the codes on the file
..../wp-erp/includes/functions-people.php
line number: 84.Following codes:
if ( $meta_query ) { $sql['join'][] = "LEFT JOIN $pepmeta_tb as people_meta on people.id = people_meta.<code>erp_people_id</code>"; $meta_key = isset( $meta_query['meta_key'] ) ? $meta_query['meta_key'] : ''; $meta_value = isset( $meta_query['meta_value'] ) ? $meta_query['meta_value'] : ''; $compare = isset( $meta_query['compare'] ) ? $meta_query['compare'] : '='; $sql['where'][] = "AND people_meta.meta_key='$meta_key' and people_meta.meta_value='$meta_value'"; }
Thanks
-
June 26, 2019 at 8:48 pm #43892
abdul billoo
ParticipantYour inital code says we can do it via arguments in erp\includes\functions-people.php
$defaults = [ 'type' => 'all', 'number' => 20, 'offset' => 0, 'orderby' => 'id', 'order' => 'DESC', 'trashed' => false, 'meta_query' => [], 'count' => false, 'life_stage' => '', 'include' => [], 'exclude' => [], 's' => '', 'no_object' => false ];
Can u give an example with what i wish to achieve using $defaults or any example that is closer and works with multiple meta values?
-
This reply was modified 5 years, 8 months ago by
abdul billoo.
-
This reply was modified 5 years, 8 months ago by
-
July 2, 2019 at 8:52 pm #44164
abdul billoo
ParticipantAny updates for this? I wouldn’t want to use the SQL but instead use the query instead
-
-
AuthorPosts
Viewing 3 reply threads
- The forum ‘HRM’ is closed to new topics and replies.