'".$sqlMonth."01-000000-0000' AND cart_order_id<'".$sqlMonth."31-999999-9999' AND `status` = 3 ORDER BY cart_order_id ASC;"; $month = $db->select($query); $daysInCurMonth = cal_days_in_month(CAL_GREGORIAN, substr($sqlMonth,2,2), "20".substr($sqlMonth,0,2)); // set all months incase some days didn't have sales for($i=1;$i<=$daysInCurMonth;$i++){ $day[substr($sqlMonth,2,2).sprintf("%02d",$i)] = 0; } for($i=0;$i $value){ $i++; $chartData[] = array($i,round($value)); } $imageNo++; $filename = md5(CC_ROOT_DIR.$glob['license_key'].$imageNo).".png"; $graph = new PHPlot; $graph->SetDataValues($chartData); $graph->SetIsInline(true); $graph->PHPlot(550,300,"cache".CC_DS.$filename); $graph->SetPlotType("bars"); $graph->skip_right_tick = TRUE; $graph->SetNumXTicks(1); $graph->SetTitle(sprintf($lang['admin']['stats_daily_sales_chart'],$monthsArray[substr($sqlMonth,2,2)]."'".substr($sqlMonth,0,2))); $graph->SetXTitle($lang['admin']['stats_days_of_month']); $graph->SetYTitle(sprintf($lang['admin']['stats_sales_vol'],$config['defaultCurrency'])); $graph->DrawGraph(); unset($month,$chartData,$dayInt,$day); echo ""; ?>