Is it possible to get all the leads for which the payment status is approved?
I am currently using the following function to retrive all leads to display them on the front end.
RGFormsModel::get_leads();
But that does not support filtering results by payment status.
Any help?
RGFormsModel::get_leads(); will return an array of leads and in that array is the payment status. Here is an example of one lead or all the leads returned for one for with get_leads():
[3] => Array
(
[id] => 1478
[form_id] => 89
[date_created] => 2013-01-05 15:34:53
[is_starred] => 0
[is_read] => 1
[ip] => 67.111.123.108
[source_url] => http://example.com/category/outings/
[post_id] =>
[currency] => USD
[payment_status] =>
[payment_date] =>
[transaction_id] =>
[payment_amount] =>
[is_fulfilled] =>
[created_by] =>
[transaction_type] =>
[user_agent] => Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0; BOIE9;ENUS)
[status] => active
[1.3] => Will
[1.6] => Brimley
[4] => none
[11] => none
[21] => 708-555-1212
[23] => 312-555-1212
[15.1] => I agree
[8.3] => Sandy
[8.6] => Bottoms
[24] => sandyb@sbcglobal.net
[3] =>
[22] =>
[10] =>
)In the function you are using to display the leads, test for the existence of $lead['payment_status'] = 'Approved' before echoing the lead. If you show us how you are displaying the leads currently, we can help you with the conditional test of the payment before you display the lead.