/**
* Pilots::create_line_graph()
*
* @param mixed $title
* @param mixed $data
* @return
*/
protected function create_line_graph($title, $data)
{
if (!$data) {
$data = array();
}
$bar_values = array();
$bar_titles = array();
foreach ($data as $val) {
$bar_titles[] = $val->ym;
$bar_values[] = floatval($val->total);
}
OFCharts::add_data_set($bar_titles, $bar_values);
echo OFCharts::create_area_graph($title);
}
public function viewmonthchart()
{
$params = $this->formfilter();
/**
* Check the first letter in the type
* m#### - month
* y#### - year
*
* No type indicates to view the 'overall'
*/
$type = $this->get->type;
if ($type[0] == 'y') {
$type = str_replace('y', '', $type);
$year = date('Y', $type);
$finance_data = $this->getyearly($year);
$title = 'Activity for ' . $year;
} else {
// This should be the last 3 months overview
# Get the last 3 months
$months = 3;
$params['p.accepted'] = PIREP_ACCEPTED;
$finance_data = PIREPData::getIntervalDataByMonth($params, $months);
$title = 'Recent Activity';
}
$titles = array();
$gross_data = array();
$fuel_data = array();
$expense_data = array();
foreach ($finance_data as $month) {
$titles[] = $month->ym;
$gross_data[] = intval($month->revenue);
$fuel_data[] = intval($month->fuelprice);
$expense_data[] = intval($month->expenses_total);
}
// Add each set
OFCharts::add_data_set($titles, $gross_data, 'Total Revenue', '#FF6633');
OFCharts::add_data_set($titles, $expense_data, 'Expenses', '#2EB800');
OFCharts::add_data_set($titles, $fuel_data, 'Fuel Costs', '#008AB8');
//echo OFCharts::create_line_graph('Months Balance Data');
echo OFCharts::create_area_graph($title);
}