Overview
Comment:Fix queries
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | dev
Files: files | file ages | folders
SHA1: d5683e8d06bffe9687a4f478c06259b295df098c
User & Date: bohwaz on 2020-09-10 00:19:19
Other Links: branch diff | manifest | tags
Context
2020-09-10
00:19
Don't forget the name attribute check-in: cbf952e28c user: bohwaz tags: dev
00:19
Fix queries check-in: d5683e8d06 user: bohwaz tags: dev
2020-09-09
21:17
Advancement on the transaction creation form check-in: 958821f73f user: bohwaz tags: dev
Changes

Modified src/include/lib/Garradin/Accounting/Accounts.php from [93c2de540c] to [5fddbf1ac4].

38
39
40
41
42
43
44
45

46
47
48
49
50
51
52
53
38
39
40
41
42
43
44

45

46
47
48
49
50
51
52







-
+
-







	}

	/**
	 * Return only analytical accounts
	 */
	public function listAnalytical(): array
	{
		return $this->em->all('SELECT * FROM @TABLE WHERE id_chart = ? AND type = ? ORDER BY code COLLATE NOCASE;',
		return $this->em->DB()->getAssoc($this->em->formatQuery('SELECT id, label FROM @TABLE WHERE id_chart = ? AND type = ? ORDER BY code COLLATE NOCASE;'), $this->chart_id, Account::TYPE_ANALYTICAL);
			$this->chart_id, Account::TYPE_ANALYTICAL);
	}

	/**
	 * Return only analytical accounts
	 */
	public function listVolunteering(): array
	{
76
77
78
79
80
81
82
83

84
85
75
76
77
78
79
80
81

82
83
84







-
+


		}

		return $out;
	}

	public function getTypesParents(): array
	{
		return $this->em->DB->getAssoc($this->em->formatQuery('SELECT type, code FROM @TABLE WHERE type_parent = 1 ORDER BY type;'));
		return $this->em->DB()->getAssoc($this->em->formatQuery('SELECT type, code FROM @TABLE WHERE type_parent = 1 ORDER BY type;'));
	}
}