"Expenses by Segment" graph includes revenues

[deseven]

It makes no sense (likely a bug), so i've added the type of the operation check for SQL query in controllers/DashboardController.php:

SELECT x.`year`, x.`month`, y.desc_category as seg, y.hexcolor_category as colorseg, sum( x.value) as total FROM (
                SELECT category.id_category, category.desc_category, category.parent_id , c.value AS value,
                       year(c.`date`) as `year` , month(c.`date`) AS `month`
                FROM category
                INNER JOIN cashbook AS c ON category.id_category = c.category_id WHERE c.type_id = 2 ) AS x
                INNER JOIN category AS y ON x.parent_id = y.id_category
                INNER JOIN user AS u ON y.user_id = u.id
                WHERE u.id = $user
                GROUP BY y.desc_category, x.`year`, x.`month`
                having x.`year` = year(now())  and x.`month` = month(now());

If you're ok with that i'll create a pull request or you can just change it yourself.

[gugoan]

ok buddy
I'm going to test this weekend.