<?php
/**********************************************************************
	Copyright (C) NotrinosERP.
	Released under the terms of the GNU General Public License, GPL,
	as published by the Free Software Foundation, either version 3
	of the License, or (at your option) any later version.
	This program is distributed in the hope that it will be useful,
	but WITHOUT ANY WARRANTY; without even the implied warranty of
	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
	See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
/**
 * CRM Dashboard Widget 1002 — Pipeline by Stage (chart).
 */
$pg = new graph();
$result = dashboard_crm_pipeline_by_stage();
$title = _('Pipeline by Stage');
$i = 0;

if ($result) {
	while ($myrow = db_fetch($result)) {
		if ($pg != null) {
			$pg->x[$i] = $myrow['stage_name'];
			$pg->y[$i] = abs($myrow['total']);
		}
		$i++;
	}
}

$widget = new Widget();
$widget->setTitle($title);
$widget->Start();

if ($widget->checkSecurity('SA_CRM_PIPELINE')) {
	if ($i > 0)
		source_graphic($title, _('Stage'), $pg, _('Deals'), null, 6);
	else
		display_note(_('No pipeline data to display.'));
}

$widget->End();
