Overview
Comment:Un peu de graph
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 0ff55cbdb8396853edcfd70d4bc846f0ce70d466
User & Date: bohwaz on 2012-08-13 01:55:17
Other Links: manifest | tags
Context
2012-08-13
02:12
Un peu mieux comme ça mais ça manque toujours de factorisation/simplification check-in: 5df6776537 user: bohwaz tags: trunk
01:55
Un peu de graph check-in: 0ff55cbdb8 user: bohwaz tags: trunk
2012-08-12
14:19
Ne gérons pas de catégorie "autre" pour le moment (genre dettes), mais gérons le virement interne d'un compte à l'autre check-in: 95145db12b user: bohwaz tags: trunk
Changes

Modified include/class.compta_journal.php from [030e0a36f3] to [bbab7273ab].

195
196
197
198
199
200
201
202

203




























204
            $data['id_categorie'] = NULL;
        }

        $data['id_auteur'] = (int)$data['id_auteur'];

        return true;
    }
}






























?>







|
>
|
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>

195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
            $data['id_categorie'] = NULL;
        }

        $data['id_auteur'] = (int)$data['id_auteur'];

        return true;
    }

    public function getStatsRecettes()
    {
        $db = Garradin_DB::getInstance();

        $start = strtotime('1 month ago');

        $data = $db->simpleStatementFetchAssoc('SELECT date, SUM(compte_debit) FROM compta_journal
            WHERE id_categorie IN (SELECT id FROM compta_categories WHERE type = -1)
            AND date > ?
            GROUP BY date ORDER BY date;', date('Y-m-d', $start));

        $now = $start;
        $today = time();

        while ($now < $today)
        {
            $day = date('Y-m-d', $now);

            if (!array_key_exists($day, $data))
            {
                $data[$day] = 0;
            }

            $now = strtotime('+1 day', $now);
        }

        return $data;
    }
}

?>

Modified setup_dependencies.sh from [e7aef380cc] to [4ab145fd27].

17
18
19
20
21
22
23



svn ${KEYWORD} https://svn.kd2.org/svn/misc/libs/garbage2xhtml/ include/libs/garbage2xhtml/

# MiniSkel
svn ${KEYWORD} https://svn.kd2.org/svn/misc/libs/miniskel/ include/libs/miniskel/

# Diff
svn ${KEYWORD} https://svn.kd2.org/svn/misc/libs/diff/ include/libs/diff/










>
>
>
17
18
19
20
21
22
23
24
25
26
svn ${KEYWORD} https://svn.kd2.org/svn/misc/libs/garbage2xhtml/ include/libs/garbage2xhtml/

# MiniSkel
svn ${KEYWORD} https://svn.kd2.org/svn/misc/libs/miniskel/ include/libs/miniskel/

# Diff
svn ${KEYWORD} https://svn.kd2.org/svn/misc/libs/diff/ include/libs/diff/

# SVGPlot
svn ${KEYWORD} https://svn.kd2.org/svn/misc/libs/svgplot/ include/libs/svgplot

Added templates/admin/compta/index.tpl version [b1f5e75083].















>
>
>
>
>
>
>
1
2
3
4
5
6
7
{include file="admin/_head.tpl" title="Comptabilité" current="compta"}

<p>
    <img src="{$www_url}admin/compta/graph.php?g=recettes_depenses" />
</p>

{include file="admin/_foot.tpl"}

Added www/admin/compta/graph.php version [c78b6fde99].





























































>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
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

require_once __DIR__ . '/_inc.php';

require_once GARRADIN_ROOT . '/include/class.compta_journal.php';
$journal = new Garradin_Compta_Journal;

require_once GARRADIN_ROOT . '/include/libs/svgplot/lib.svgplot.php';

$plot = new SVGPlot(400, 300);

if (utils::get('g') == 'recettes_depenses')
{
	$data = array(
		$journal->getStatsRecettes(),
		//$journal->getStatsDepenses(),
	);
}

foreach ($data as $line)
{
	$line = new SVGPlot_Data($line);
	$line->color = '#d98628';
	$line->width = 5;
	$plot->add($line);
}

$plot->display();

?>