Gravity Support Forums Topic: count of approved entries with get_lead

Gravity Support Forums Topic: count of approved entries with get_lead_count ?? https://legacy.forums.gravityhelp.com/topic/count-of-approved-entries-with-get_lead_count Gravity Support Forums Topic: count of approved entries with get_lead_count ?? en-US Thu, 30 Apr 2026 05:31:19 +0000 http://bbpress.org/?v=1.0.1 <![CDATA[Search]]> q https://legacy.forums.gravityhelp.com/search.php boodcode on "count of approved entries with get_lead_count ??" https://legacy.forums.gravityhelp.com/topic/count-of-approved-entries-with-get_lead_count#post-67865 Wed, 25 Jul 2012 10:33:24 +0000 boodcode 67865@https://legacy.forums.gravityhelp.com/ the complete function is : function get_lead_count($form_id, $search, $star=null, $read=null, $column, $approved = false, $leads = array(), $start_date = null, $end_date = null, $limituser = false){ global $wpdb, $current_user; if(!is_numeric($form_id)) return ""; $detail_table_name = RGFormsModel::get_lead_details_table_name(); $lead_table_name = RGFormsModel::get_lead_table_name(); $star_filter = $star !== null ? $wpdb->prepare("AND is_starred=%d ", $star) : ""; $read_filter = $read !== null ? $wpdb->prepare("AND is_read=%d ", $read) : ""; if(function_exists('gform_get_meta')) { $status_filter = $wpdb->prepare(" AND status=%s ", 'active'); } else { $status_filter = ''; } $start_date_filter = empty($start_date) ? "" : " AND datediff(date_created, '$start_date') >=0"; $end_date_filter = empty($end_date) ? "" : " AND datediff(date_created, '$end_date') <=0"; $search_term = "%$search%"; $search_filter = empty($search) ? "" : $wpdb->prepare("AND ld.value LIKE %s", $search_term); $user_filter = ''; if($limituser) { get_currentuserinfo(); if((int)$current_user->ID !== 0 || ($current_user->ID === 0 && apply_filters('kws_gf_show_entries_if_not_logged_in', apply_filters('kws_gf_treat_not_logged_in_as_user', true)))) { if(!empty($current_user->ID)) { $user_filter = $wpdb->prepare(" AND l.created_by=%d ", $current_user->ID); } else { $user_filter = $wpdb->prepare(" AND (created_by IS NULL OR created_by=%d)", $current_user->ID); } } else { return false; } } $in_filter = ""; if($approved) { $in_filter = $wpdb->prepare("l.id IN (SELECT lead_id from $detail_table_name WHERE field_number BETWEEN %f AND %f) AND", $column - 0.001, $column + 0.001); // This will work once all the fields are converted to the meta_key after 1.6 #$search_filter .= $wpdb->prepare(" AND m.meta_key = 'is_approved' AND m.meta_value = %s", 1); } $sql = "SELECT count(distinct l.id) FROM $lead_table_name as l, $detail_table_name as ld"; # $sql .= function_exists('gform_get_meta') ? " INNER JOIN wp_rg_lead_meta m ON l.id = m.lead_id " : ""; // After 1.6 $sql .= " WHERE $in_filter l.form_id=$form_id AND ld.form_id=$form_id AND l.id = ld.lead_id $star_filter $read_filter $status_filter $user_filter $start_date_filter $end_date_filter $search_filter"; return $wpdb->get_var($sql); } boodcode on "count of approved entries with get_lead_count ??" https://legacy.forums.gravityhelp.com/topic/count-of-approved-entries-with-get_lead_count#post-67864 Wed, 25 Jul 2012 10:27:30 +0000 boodcode 67864@https://legacy.forums.gravityhelp.com/ when you install gravity forms addons, you'll get a function 'get_lead_count' that is defined in the gravity-forms-addons.php: function get_lead_count($form_id, $search, $star=null, $read=null, $column, $approved = false, $leads = array(), $start_date = null, $end_date = null, $limituser = false){.....} with GF addons you can approve or not an entries to show or not it in your website. Chris Hajer on "count of approved entries with get_lead_count ??" https://legacy.forums.gravityhelp.com/topic/count-of-approved-entries-with-get_lead_count#post-67767 Tue, 24 Jul 2012 16:26:02 +0000 Chris Hajer 67767@https://legacy.forums.gravityhelp.com/ What is an "approved" entry? I'm familiar with read, unread, starred, maybe spam and trash. What do you consider approved? Is that an additional field you're added to your entries? boodcode on "count of approved entries with get_lead_count ??" https://legacy.forums.gravityhelp.com/topic/count-of-approved-entries-with-get_lead_count#post-67728 Tue, 24 Jul 2012 11:17:33 +0000 boodcode 67728@https://legacy.forums.gravityhelp.com/ How show count of just approved entries with get_lead_count ?? i tried this : <pre><code>$entry_count = RGFormsModel::get_lead_count(1, "", null, null, null, null);</code></pre> but it's all the entries (approved and not approved) and if i try <pre><code>$entry_count = RGFormsModel::get_lead_count(1, "", null, null, null, true);</code></pre> but it's return 0 entry what's the solution???