display_all();
}
-function display_customer_topten()
+function display_title($title, $colspan=2)
{
- $pg = new graph();
-
- echo "<table width='100%'>";
- echo "<tr valign=top><td style='width:50%'>\n"; // outer table
- $today = Today();
- $title = customer_top($today, 10, 66, $pg);
- customer_trans($today);
- echo "</td><td style='width:50%'>\n";
- source_graphic($today, $title, _("Customer"), $pg);
- customer_recurrent_invoices($today);
- echo "</td></tr></table>\n";
-}
+ echo "<tr><td colspan=$colspan class='headingtext' style='text-align:center;border:0;height:40px;'>$title</td></tr>\n";
+}
function table_one()
{
echo "</td></tr></table>\n";
}
+function display_customer_topten()
+{
+ $pg = new graph();
+
+ table_one();
+ $today = Today();
+ $title = customer_top($today, 10, 66, $pg);
+ customer_trans($today);
+ table_two();
+ source_graphic($today, $title, _("Customer"), $pg, _("Sales"));
+ customer_recurrent_invoices($today);
+ table_end();
+}
+
function display_supplier_topten()
{
$pg = new graph();
$title = supplier_top($today, 10, 66, $pg);
supplier_trans($today);
table_two();
- source_graphic($today, $title, _("Supplier"), $pg);
+ source_graphic($today, $title, _("Supplier"), $pg, _("Purchase"));
table_end();
}
$source = _("Manufacturing");
else
$source = _("Items");
- source_graphic($today, $title, $source, $pg);
+ source_graphic($today, $title, $source, $pg, ($type == 0 ? _("Sales") : _("Amount")),
+ ($type == 0 ? _("Costs") : null));
table_end();
}
$today = Today();
$title = dimension_top($today, 10, 66, $pg);
table_two();
- source_graphic($today, $title, _("Dimension"), $pg, 5);
+ source_graphic($today, $title, _("Dimension"), $pg, _("Performance"), null, 5);
table_end();
}
$title = gl_top($today, 66, $pg);
bank_balance($today, 66);
table_two();
- source_graphic($today, $title, _("Class"), $pg, 5);
+ source_graphic($today, $title, _("Class"), $pg, _("Amount"), null, 5);
+ gl_performance($today, 66, 5);
table_end();
}
table_one();
$title = customer_top($today, 3, 66, $pg);
- source_graphic($today, $title, _("Customer"), $pg);
+ source_graphic($today, $title, _("Customer"), $pg, _("Sales"));
$title = supplier_top($today, 3, 66, $pg);
- source_graphic($today, $title, _("Supplier"), $pg);
+ source_graphic($today, $title, _("Supplier"), $pg, _("Purchases"));
$title = stock_top($today, 3, 66, 0, $pg);
- source_graphic($today, $title, _("Stock"), $pg);
+ source_graphic($today, $title, _("Stock"), $pg, _("Sales"));
table_two();
dimension_top($today, 3, 66);
$title = gl_top($today, 66, $pg);
- source_graphic($today, $title, _("Class"), $pg, 5);
+ source_graphic($today, $title, _("Class"), $pg, _("Amount"), null, 5);
stock_top($today, 3, 66, 2);
stock_top($today, 3, 66, 1);
table_end();
}
-function display_title($title, $colspan=2)
-{
- echo "<tr><td colspan=$colspan class='headingtext' style='text-align:center;border:0;height:40px;'>$title</td></tr>\n";
-}
-
function customer_top($today, $limit=10, $width="33", &$pg=null)
{
$begin = begin_fiscalyear();
if ($type == 0)
{
$sql = "SELECT SUM((trans.unit_price * trans.quantity) * d.rate) AS total, s.stock_id, s.description,
- SUM(trans.quantity) AS qty FROM
+ SUM(trans.quantity) AS qty, SUM((s.material_cost + s.overhead_cost + s.labour_cost) * trans.quantity) AS costs FROM
".TB_PREF."debtor_trans_details AS trans, ".TB_PREF."stock_master AS s, ".TB_PREF."debtor_trans AS d
WHERE trans.stock_id=s.stock_id AND trans.debtor_trans_type=d.type AND trans.debtor_trans_no=d.trans_no
AND (d.type = ".ST_SALESINVOICE." OR d.type = ".ST_CUSTCREDIT.") ";
$title = _("Top $limit Fixed Assets in fiscal year");
else
$title = _("Top $limit Sold Items in fiscal year");
- $th = array(_("Item"), _("Amount"), _("Quantity"));
+ if ($type == 0)
+ $th = array(_("Item"), _("Sales"), _("Costs"), _("Quantity"));
+ else
+ $th = array(_("Item"), _("Amount"), _("Quantity"));
start_table(TABLESTYLE, "width='$width%'");
display_title($title, count($th));
table_header($th);
$name = $myrow["description"];
label_cell($name);
amount_cell($myrow['total']);
+ if ($type == 0)
+ amount_cell($myrow['costs']);
qty_cell($myrow['qty']);
if ($pg != NULL)
{
$pg->x[$i] = $name;
$pg->y[$i] = $myrow['total'];
+ if ($type == 0)
+ $pg->z[$i] = $myrow['costs'];
}
$i++;
end_row();
}
end_table(2);
+ return $title;
}
function dimension_top($today, $limit=10, $width="33", &$pg=null)
end_row();
}
end_table(2);
+ return $title;
}
function gl_top($today, $width="33", &$pg=null)
$pg->y[$i] = -$total;
}
end_table(2);
+ return $title;
+}
+
+function gl_performance($today, $width="33", $weeks=5)
+{
+ $pg = new graph();
+
+ $begin = begin_fiscalyear();
+ $begin1 = date2sql($begin);
+ $today1 = date2sql($today);
+ $sql = "SELECT CONCAT(YEAR(tran_date), '/', WEEK(tran_date)) AS week_name,
+ 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 IF(c.ctype > 3, tran_date >= '$begin1', tran_date >= '0000-00-00')
+ AND tran_date <= '$today1'
+ GROUP BY week_name
+ ORDER BY YEAR(tran_date) DESC, WEEK(tran_date) DESC limit 0, $weeks";
+ $result = db_query($sql, "Transactions could not be calculated");
+ $title = _("Last $weeks weeks Performance");
+ check_page_security('SA_GLANALYTIC');
+ $i = 0;
+ while ($myrow = db_fetch($result))
+ {
+ $pg->x[$i] = $myrow['week_name'];
+ $pg->y[$i] = $myrow['sales'];
+ $pg->z[$i] = $myrow['costs'];
+ $i++;
+ }
+ $pg->x = array_reverse($pg->x);
+ $pg->y = array_reverse($pg->y);
+ $pg->z = array_reverse($pg->z);
+
+ source_graphic($today, $title, _("Week"), $pg, _("Sales"), _("Costs"), 1);
}
-function source_graphic($today, $title, $source, $pg, $type=2)
+function source_graphic($today, $title, $x_axis, $pg, $graphic1, $graphic2=null, $type=2)
{
- $pg->title = $title;
- $pg->axis_x = $source;
+ if (count($pg->y) ==0 || (count($pg->y) == 1 && $pg->y[0] == 0))
+ return;
+ $pg->title = $title . " - " . $today;
+ $pg->axis_x = $x_axis;
$pg->axis_y = _("Amount");
- $pg->graphic_1 = $today;
+ $pg->graphic_1 = $graphic1;
+ if ($graphic2 != null)
+ $pg->graphic_2 = $graphic2;
$pg->type = $type;
$pg->skin = 1;
$pg->built_in = false;