break;
case 'delete_by_id':
$db_delete_success = BudgetManager::deleteRecurringRecord($id);
break;
}
$page_title = 'Recurring | Budget';
$alt_menu = getAddButton() . getBackButton();
$addModel = new AddModel('Add', 'add_budget_item');
$addModel->addRow('amount', 'Amount');
$addModel->addRow('category', 'Category');
$addModel->addRow('store', 'Store');
$addModel->addRow('items', 'Items');
$addModel->addRow('startdate', 'Start Date', 'CURRENT_TIMESTAMP');
$addModel->addRow('enddate', 'End Date', '2037-12-31 23:59:59');
// build recurring table model
$recurringModel = new TableModel('Recurring items', 'recurring');
$recurringModel->addRow(array(TableView2::createCell('amount', 'Amount', 'th'), TableView2::createCell('category', 'Category', 'th'), TableView2::createCell('store', 'Store', 'th'), TableView2::createCell('items', 'Items', 'th'), TableView2::createCell()));
$recurring_items_data = BudgetManager::getAllRecurring();
while (($recurring_items_row = mysql_fetch_array($recurring_items_data)) != null) {
$amount = $recurring_items_row['amount'];
$category = $recurring_items_row['category'];
$recurringModel->addRow(array(TableView2::createCell('amount', format_currency($amount)), TableView2::createCell('category', $category), TableView2::createCell('store', $recurring_items_row['store']), TableView2::createCell('items', $recurring_items_row['items']), TableView2::createEdit($recurring_items_row['RECURRING_ID'], 'editRecurring.php')));
$total_spent += $amount;
$category_normalized = strtolower($category);
$totals[$category_normalized] = isset($totals[$category_normalized]) ? $totals[$category_normalized] + $amount : $amount;
}
$views_to_load = array();
$views_to_load[] = ' ' . AddView2::render($addModel);
$views_to_load[] = ' ' . TableView2::render($recurringModel);
include $relative_base_path . 'views/_generic.php';
}
