include_once("../php/include.php");
function printGroup($id, $name, $expense, $exclude, $system, $existing) {
?>
|
→
|
">
=($system ? "disabled readonly" : "")?> autocomplete="off" />=insertExpenseText(1, true)?>
|
autocomplete="off" />Exclude
|
disabled readonly autocomplete="off" />Default
|
|
if($existing && !$system) { ?>
} ?>
|
}
function printCategory($id, $categoryGroupId, $name, $system, $records, $rules, $existing) {
?>
|
⤷
if($records !== null) { ?>
=$records?> records,
=$rules?> rules
} ?>
|
|
if($existing && !$system) { ?>
} ?>
|
}
?>
initDatabaseConnection();
$groups = dbQuery("SELECT * FROM category_group WHERE household_id = ? ORDER BY name", getHouseholdId());
foreach($groups as $group) {
printGroup($group['id'], $group['name'], $group['expense'], $group['exclude'], $group['system'], true);
$categories = dbQuery("SELECT * FROM category_ext WHERE category_group_id = ?", $group['id']);
foreach($categories as $category) {
printCategory($category['id'], $group['id'], $category['name'], $group['system'], $category['record_count'], $category['rule_count'], true);
}
if(!$group['system']) {
printCategory("null", $group['id'], "", false, null, null, false);
}
}
printGroup("null", "", 1, 0, 0, false);
closeDatabaseConnection();
?>