India Cultural Center and Temple 12005 Highway 64 E., Eads, TN 38028-9314 Phone: (901) 202-6070; E-mail: [email protected] A not-for-profit, section 501(c)(3); Tax Id: 58-1522313

 
2017 Dwiteeya Kumbhabhishekam Account Receivables Report

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

$fi_types = “212,213,214,215,216,217,218,219,220,225,226,227,228,229,230,231,232,233,234,235,236,239,240,241,242”;
$pledged_date = “2015-01-01”;
$receive_date = “2015-01-01″;

global $wpdb;

$result = $wpdb->get_results ( ”

select f.id, f.name, count(*) as count, sum(amount) as pledged
FROM civicrm_pledge a, civicrm_financial_type f
where f.id = a.financial_type_id and `status_id` !=3 and create_date>='” . $pledged_date .”‘
and f.id in(“. $fi_types. “)
group by f.id, f.name
order by FIELD(f.id, 232,219,231,218,241,239,228,226,217,236,235,227,216,234,213,214,225) DESC, f.name

” );

$result2 = $wpdb->get_results ( ”

select f.id, f.name, sum(actual_amount) as total_amount
FROM civicrm_pledge a, civicrm_financial_type f, civicrm_pledge_payment p
where a.id=p.`pledge_id` and a.`financial_type_id`=f.id and p.status_id=1
and f.id in(“. $fi_types. “)
group by f.id, f.name
order by f.id, f.name

” );

$payments = array();
foreach ( $result2 as $page )
{
$payments[$page->id] = $page->total_amount;
}

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

foreach ( $result as $page )
{
if (!array_key_exists($page->id, $payments))
$payments[$page->id] = 0;

echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;

$grand_total_pledge_count += $page->count;
$grand_total_pledged += $page->pledged;
$grand_total_paid += $payments[$page->id];
$grand_total_balance += $page->pledged – $payments[$page->id];

}

echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;