1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
<?php
namespace Garradin;
class Compta_Stats
{
protected function _byType($type)
{
return $this->getStats('SELECT strftime(\'%Y%m\', date) AS date,
SUM(montant) FROM compta_journal
WHERE id_categorie IN (SELECT id FROM compta_categories WHERE type = '.$type.')
AND id_exercice = (SELECT id FROM compta_exercices WHERE cloture = 0)
GROUP BY strftime(\'%Y-%m\', date) ORDER BY date;');
}
public function recettes()
{
return $this->_byType(Compta_Categories::RECETTES);
}
public function depenses()
{
return $this->_byType(Compta_Categories::DEPENSES);
}
public function soldeCompte($compte, $augmente = 'debit', $diminue = 'credit')
{
$db = DB::getInstance();
if (strpos($compte, '%') !== false)
|
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
|
|
|
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
|
<?php
namespace Garradin;
class Compta_Stats
{
protected function _parRepartitionCategorie($type)
{
$db = DB::getInstance();
return $db->simpleStatementFetch('SELECT COUNT(*) AS nb, id_categorie
FROM compta_journal
WHERE id_categorie IN (SELECT id FROM compta_categories WHERE type = ?)
AND id_exercice = (SELECT id FROM compta_exercices WHERE cloture = 0)
GROUP BY id_categorie ORDER BY nb DESC;', SQLITE3_ASSOC, $type);
}
public function repartitionRecettes()
{
return $this->_parRepartitionCategorie(Compta_Categories::RECETTES);
}
public function repartitionDepenses()
{
return $this->_parRepartitionCategorie(Compta_Categories::DEPENSES);
}
protected function _parType($type)
{
return $this->getStats('SELECT strftime(\'%Y%m\', date) AS date,
SUM(montant) FROM compta_journal
WHERE id_categorie IN (SELECT id FROM compta_categories WHERE type = '.$type.')
AND id_exercice = (SELECT id FROM compta_exercices WHERE cloture = 0)
GROUP BY strftime(\'%Y-%m\', date) ORDER BY date;');
}
public function recettes()
{
return $this->_parType(Compta_Categories::RECETTES);
}
public function depenses()
{
return $this->_parType(Compta_Categories::DEPENSES);
}
public function soldeCompte($compte, $augmente = 'debit', $diminue = 'credit')
{
$db = DB::getInstance();
if (strpos($compte, '%') !== false)
|