Overview
Comment:Reverse order of other years, makes more sense
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk | stable
Files: files | file ages | folders
SHA3-256: 4a89f01f47e2211b02dfc658e233cdb3d9e462e14b45b3180bf9d08ecb75fbef
User & Date: bohwaz on 2021-12-09 02:23:17
Other Links: manifest | tags
Context
2021-12-09
02:38
Fix sum change between two years check-in: 5d3d4ea90f user: bohwaz tags: trunk, stable
02:23
Reverse order of other years, makes more sense check-in: 4a89f01f47 user: bohwaz tags: trunk, stable
02:22
Only show comparison form when there's a year list check-in: e57ad5533b user: bohwaz tags: trunk, stable
Changes

Modified src/include/lib/Garradin/Accounting/Years.php from [6820d984ce] to [d161a36703].

45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
	static public function listClosedAssoc()
	{
		return DB::getInstance()->getAssoc('SELECT id, label FROM acc_years WHERE closed = 1 ORDER BY end_date;');
	}

	static public function listClosedAssocExcept(int $id)
	{
		return DB::getInstance()->getAssoc('SELECT id, label FROM acc_years WHERE closed = 1 AND id != ? ORDER BY end_date;', $id);
	}

	static public function listClosed()
	{
		$em = EntityManager::getInstance(Year::class);
		return $em->all('SELECT * FROM @TABLE WHERE closed = 1 ORDER BY end_date;');
	}







|







45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
	static public function listClosedAssoc()
	{
		return DB::getInstance()->getAssoc('SELECT id, label FROM acc_years WHERE closed = 1 ORDER BY end_date;');
	}

	static public function listClosedAssocExcept(int $id)
	{
		return DB::getInstance()->getAssoc('SELECT id, label FROM acc_years WHERE closed = 1 AND id != ? ORDER BY end_date DESC;', $id);
	}

	static public function listClosed()
	{
		$em = EntityManager::getInstance(Year::class);
		return $em->all('SELECT * FROM @TABLE WHERE closed = 1 ORDER BY end_date;');
	}