object(PDOStatement)#1101 (1) { ["queryString"]=> string(1199) "SELECT orf.org_id,orf.award_cycle_id,ap.project_id,orf.project_goals,orf.meet_goals,orf.project_outcomes,orf.project_evaluation,orf.project_revenue_expenses,awc.award_cycle_name,orf.project_report_date, app_info.uuid AS theuuid,app_info.org_name,ap.project_name,ap.project_id,Date_Format(due_date,"%M %e, %Y") as due_date, Date_Format(report_due_date,"%M %e, %Y") as report_due_date,ap.awarded_amount,ap.requested_amount,ap.id,CASE WHEN app_info.contact_title IS NOT NULL THEN app_info.contact_title ELSE "Executive Director" END AS contact_title, CASE WHEN app_info.contact_person_f_name IS NOT NULL THEN app_info.contact_person_f_name ELSE app_info.ed_f_name END AS ed_f_name, CASE WHEN app_info.contact_person_l_name IS NOT NULL THEN app_info.contact_person_l_name ELSE app_info.ed_l_name END AS ed_l_name, CASE WHEN app_info.contact_person_email IS NOT NULL THEN app_info.contact_person_email ELSE app_info.ed_email END AS email FROM org_reporting_form orf INNER JOIN award_cycles awc ON awc.award_cycle_id = orf.award_cycle_id JOIN applicant_info app_info ON orf.org_id = app_info.id JOIN applicant_projects ap ON ap.project_id = orf.pid GROUP BY orf.id ORDER BY awc.award_cycle_id" }
Notice: Undefined variable: award_cycle_name in /home/colefdewrt43/wordpress/wp-content/plugins/project_reports/project_reports.php on line 84
object(PDOStatement)#1101 (1) { ["queryString"]=> string(1199) "SELECT orf.org_id,orf.award_cycle_id,ap.project_id,orf.project_goals,orf.meet_goals,orf.project_outcomes,orf.project_evaluation,orf.project_revenue_expenses,awc.award_cycle_name,orf.project_report_date, app_info.uuid AS theuuid,app_info.org_name,ap.project_name,ap.project_id,Date_Format(due_date,"%M %e, %Y") as due_date, Date_Format(report_due_date,"%M %e, %Y") as report_due_date,ap.awarded_amount,ap.requested_amount,ap.id,CASE WHEN app_info.contact_title IS NOT NULL THEN app_info.contact_title ELSE "Executive Director" END AS contact_title, CASE WHEN app_info.contact_person_f_name IS NOT NULL THEN app_info.contact_person_f_name ELSE app_info.ed_f_name END AS ed_f_name, CASE WHEN app_info.contact_person_l_name IS NOT NULL THEN app_info.contact_person_l_name ELSE app_info.ed_l_name END AS ed_l_name, CASE WHEN app_info.contact_person_email IS NOT NULL THEN app_info.contact_person_email ELSE app_info.ed_email END AS email FROM org_reporting_form orf INNER JOIN award_cycles awc ON awc.award_cycle_id = orf.award_cycle_id JOIN applicant_info app_info ON orf.org_id = app_info.id JOIN applicant_projects ap ON ap.project_id = orf.pid GROUP BY orf.id ORDER BY awc.award_cycle_id" }

Colef Fund Grant Reports