<?php

AddContent('SNF Statistics by State', 'PAGE_TITLE');

$qry_state = "SELECT * FROM tbl_state_stats ORDER BY state";
$rst_state = DbQuery($qry_state);

$tpl = new HTML_Template_IT(EP_TEMPLATE_DIR);
$tpl->loadTemplatefile('state_statistics.tpl');

$tot_facilities = 0;
$tot_beds       = 0;
$tot_days       = 0;
$tot_rev        = 0;

$tpl->setCurrentBlock('STATE_ROW');

while ($row_state = GetDbRow($rst_state))
{
    $tpl->setVariable([
        'STATE_ABBREV'  => $row_state['state'],
        'STATE_NAME'    => $row_state['state_name'],
        'FACILITIES'    => $row_state['facilities'],
        'BEDS'          => number_format($row_state['beds']),
        'DAYS'          => number_format($row_state['days']),
        'REVENUE'       => number_format($row_state['revenue']),
    ]);
    $tpl->parseCurrentBlock();

    $tot_facilities += $row_state['facilities'];
    $tot_beds       += $row_state['beds'];
    $tot_days       += $row_state['days'];
    $tot_rev        += $row_state['revenue'];
}

$tpl->setCurrentBlock('STATE_STATISTICS');
$tpl->setVariable([
    'TOT_FACILITIES'    => number_format($tot_facilities),
    'TOT_BEDS'          => number_format($tot_beds),
    'TOT_DAYS'          => number_format($tot_days),
    'TOT_REVENUE'       => number_format($tot_rev),
]);
$tpl->parseCurrentBlock();
$tpl->show();