$pg = new graph();
$begin = begin_fiscalyear();
$begin1 = date2sql($begin);
$today1 = date2sql($today);
$pg = new graph();
$begin = begin_fiscalyear();
$begin1 = date2sql($begin);
$today1 = date2sql($today);
SUM(IF(c.ctype = 4, amount * -1, 0)) AS sales,
SUM(IF(c.ctype = 6, amount, 0)) AS costs FROM
".TB_PREF."gl_trans, ".TB_PREF."chart_master AS a, ".TB_PREF."chart_types AS t,
".TB_PREF."chart_class AS c WHERE(c.ctype = 4 OR c.ctype = 6)
AND account = a.account_code AND a.account_type = t.id AND t.class_id = c.cid
AND tran_date >= '$begin1' AND tran_date <= '$today1'
SUM(IF(c.ctype = 4, amount * -1, 0)) AS sales,
SUM(IF(c.ctype = 6, amount, 0)) AS costs FROM
".TB_PREF."gl_trans, ".TB_PREF."chart_master AS a, ".TB_PREF."chart_types AS t,
".TB_PREF."chart_class AS c WHERE(c.ctype = 4 OR c.ctype = 6)
AND account = a.account_code AND a.account_type = t.id AND t.class_id = c.cid
AND tran_date >= '$begin1' AND tran_date <= '$today1'
GROUP BY week_name ORDER BY week_name ASC";
$result = db_query($sql, "Transactions could not be calculated");
$title = _("Last $weeks weeks Performance");
GROUP BY week_name ORDER BY week_name ASC";
$result = db_query($sql, "Transactions could not be calculated");
$title = _("Last $weeks weeks Performance");