Yagnam 2018 Account Receivables Report

 [insert_php]echo date(“F j, Y”);[/insert_php]

global $wpdb;

$result = $wpdb->get_results ( ”

select
(select last_name from civicrm_contact c where p.contact_id = c.id) as LastName,
(select first_name from civicrm_contact c where p.contact_id = c.id) as FirstName,
(select email from civicrm_email e where p.contact_id = e.contact_id and e.is_primary=1) as Email,
(select phone from civicrm_phone ph where p.contact_id = ph.contact_id and ph.is_primary=1) as Phone,
p.amount as Pledged,
(select sum(total_amount) from civicrm_contribution b where p.contact_id = b.contact_id and financial_type_id=p.financial_type_id and contribution_status_id=1) as Paid,
(select p.amount – (select sum(total_amount) from civicrm_contribution b where p.contact_id = b.contact_id and financial_type_id=p.financial_type_id and contribution_status_id=1)) as Balance
from civicrm_pledge p
where financial_type_id=265
order by pledged desc,lastname,firstname

” );

$grand_total_pledge_count = 0;
$grand_total_pledged = 0;
$grand_total_paid = 0;
$grand_total_balance = 0;

foreach ( $result as $page )
{
$paid = 0;
$balance = $page->Pledged;
if($page->Paid >=0) $paid = $page->Paid;
if($page->Balance >=0) $balance = $page->Balance;

echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;

$grand_total_pledge_count += $page->count;
$grand_total_pledged += $page->Pledged;
$grand_total_paid += $paid;
$grand_total_balance += ($page->Pledged- $paid);

}

echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;