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(); '); } }