public function earningsajaxAction()
{
$this->setInvokeArg('noViewRenderer', true);
if ($this->getRequest()->getPost('ajax')) {
$month = $this->getRequest()->getRequest('earningsajax');
$year = $this->getRequest()->getRequest($month);
$text = '';
$sales = Model_Orders::getAll2(" paid_datetime > '" . date('Y-m-d 23:59:59', mktime(0, 0, 0, $month - 1, date('t', mktime(0, 0, 0, $month - 1, 1, $year)), $year)) . "' AND paid_datetime < '" . date('Y-m-d 00:00:00', mktime(0, 0, 0, $month + 1, 1, $year)) . "' AND paid = 'true' AND type = 'buy' AND owner_id = '" . intval(JO_Session::get('user_id')) . "' ", "paid_datetime ASC");
if (is_array($sales)) {
$buff = array();
foreach ($sales as $s) {
$day = explode(' ', $s['paid_datetime']);
$day = explode('-', $day[0]);
if (!isset($buff[$day[2]])) {
$buff[$day[2]]['sale'] = 1;
$buff[$day[2]]['earning'] = $s['receive'];
} else {
$buff[$day[2]]['sale']++;
$buff[$day[2]]['earning'] += $s['receive'];
}
}
foreach ($buff as $day => $r) {
$text .= '<tr><td>' . $day . '</td><td>' . $r['sale'] . ' ' . $this->translate('Sales') . '</td><td>' . WM_Currency::format($r['earning']) . '</td></tr>';
}
}
die('
jQuery("#month_' . $month . '_' . $year . '_details").html(\'' . $text . '\');
jQuery("#month_' . $month . '_' . $year . '_show").hide();
jQuery("#month_' . $month . '_' . $year . '_hide").show();
');
}
}
