$colors[] = docmanpaypal::random_color();
}
$imgUrl = str_replace('%%sales%%', implode(',', $sales), $imgUrl);
$imgUrl = str_replace('%%states%%', implode('|', $states), $imgUrl);
$imgUrl = str_replace('%%colors%%', implode('|', $colors), $imgUrl);
echo '<img src="' . $imgUrl . '" />';
//start stat by product
unset($colors, $sales);
echo '<h3>' . JText::_("COM_DOCMANPAYPAL_DMP_TOPPRODUCTS") . ':</h3>';
$database->setQuery("SELECT o.file_id, (\nSELECT count( order_id )\nFROM #__docmanpaypalorders\nWHERE file_id = o.file_id\n) AS sales, item_name\nFROM #__docmanpaypalorders o\nGROUP BY o.file_id");
$result = $database->loadObjectList();
$imgUrl = 'http://chart.apis.google.com/chart?cht=p3&chs=750x300&chd=t:%%sales%%&chl=%%item_names%%&chco=%%colors%%';
foreach ($result as $obj) {
$sales[] = $obj->sales;
$item_names[] = "({$obj->sales}) " . $obj->item_name;
$colors[] = docmanpaypal::random_color();
}
$imgUrl = str_replace('%%sales%%', implode(',', $sales), $imgUrl);
$imgUrl = str_replace('%%item_names%%', implode('|', $item_names), $imgUrl);
$imgUrl = str_replace('%%colors%%', implode('|', $colors), $imgUrl);
echo '<img src="' . $imgUrl . '" />';
//start stat by started against completed orders
unset($colors, $sales);
echo '<h3>' . JText::_("COM_DOCMANPAYPAL_DMP_STARTEDORDERS") . ' / ' . JText::_("COM_DOCMANPAYPAL_DMP_COMPLETEDORDERS") . ':</h3>';
$database->setQuery("SELECT count(order_id) from #__docmanpaypalorders where 1");
$totalOrders = $database->loadResult();
$database->setQuery("SELECT count(order_id) from #__docmanpaypalorders where completed = 1");
$completedOrders = $database->loadResult();
$imgUrl = 'http://chart.apis.google.com/chart?cht=p3&chs=750x300&chd=t:' . $totalOrders . ',' . $completedOrders . '&chl=' . "({$totalOrders}) " . JText::_("COM_DOCMANPAYPAL_DMP_STARTEDORDERS") . '|' . "({$completedOrders}) " . JText::_("COM_DOCMANPAYPAL_DMP_COMPLETEDORDERS");
echo '<img src="' . $imgUrl . '" />';
break;
