}
$result->MoveNext();
$last_fy->MoveNext();
$next_fy->MoveNext();
}
$result = $db->Execute("select id, period, budget from " . TABLE_CHART_OF_ACCOUNTS_HISTORY . " \n\twhere account_id = '" . $gl_acct . "' and period in (" . implode(',', array_keys($periods)) . ")");
if ($gl_acct && sizeof($lf_per) > 0) {
$last_fy = $db->Execute("select budget from " . TABLE_CHART_OF_ACCOUNTS_HISTORY . " \n\twhere account_id = '" . $gl_acct . "' and period in (" . implode(',', array_keys($lf_per)) . ")");
} else {
$next_fy = new objectInfo();
}
if ($gl_acct && sizeof($nf_per) > 0) {
$next_fy = $db->Execute("select budget from " . TABLE_CHART_OF_ACCOUNTS_HISTORY . " \n\twhere account_id = '" . $gl_acct . "' and period in (" . implode(',', array_keys($nf_per)) . ")");
} else {
$next_fy = new objectInfo();
}
$fy_array = array();
while (!$result->EOF) {
$fy_array[] = array('id' => $result->fields['id'], 'period' => $periods[$result->fields['period']], 'prior' => $last_fy->fields['budget'], 'budget' => $result->fields['budget'], 'next' => $next_fy->fields['budget']);
$result->MoveNext();
if (sizeof($lf_per) > 0) {
$last_fy->MoveNext();
}
if (sizeof($nf_per) > 0) {
$next_fy->MoveNext();
}
}
$include_header = true;
$include_footer = true;
$include_template = 'template_main.php';
define('PAGE_TITLE', GL_BUDGET_HEADING_TITLE);