function _isLastMonth() { App::import('Helper', 'Time'); $time = new TimeHelper(); $last_month[0] = date('Y-m-01', strtotime('-1 month')); $last_month[1] = date(DATE_W3C, mktime(0, 0, 0, date('m'), 0, date('y'))); $q = $time->daysAsSql($last_month[0], $last_month[1], 'modified'); $res = false; if ($this->SbmRanking->hasAny($q)) { $res = true; } return $res; }
function admin_order_report() { $time = new TimeHelper(); if (!empty($this->data)) { //pr($this->data); if (@$this->data['Order']['option'] == 'today') { $todayStart = mktime(0, 0, 0, date('m'), date('d'), date('Y')); $this->paginate = array('conditions' => array($time->daysAsSql($todayStart, time(), 'Order.od_date'))); $orders = $this->paginate(); $countNum = count($orders); $this->set('orders', $orders); $this->set('totalNum', $countNum); if ($countNum == 0) { $totalSum = 0.0; } else { $totalSum = $this->Order->get_total_payed_orders_sum($orders); } $this->set('totalSum', $totalSum); } elseif (@$this->data['Order']['option'] == 'yesterday') { $yesterdayStart = mktime(0, 0, 0, date('m'), date('d') - 1, date('Y')); $yesterdayEnd = mktime(23, 59, 0, date('m'), date('d') - 1, date('Y')); //pr(date('Y-m-d H:i:s',$yesterdayStart)); //die; $this->paginate = array('conditions' => array('Order.od_date >' => date('Y-m-d H:i:s', $yesterdayStart), 'Order.od_date <' => date('Y-m-d H:i:s', $yesterdayEnd))); //$this->paginate = array('conditions' => array($time->daysAsSql($yesterdayStart, $yesterdayEnd, 'Order.od_date'))); $orders = $this->paginate(); $countNum = count($orders); if ($countNum == 0) { $totalSum = 0.0; } else { $totalSum = $this->Order->get_total_payed_orders_sum($orders); } $this->set('totalSum', $totalSum); $this->set('orders', $orders); $this->set('totalNum', $countNum); } elseif ($this->data['Order']['option'] == 'last week') { } else { $hour = $this->data['Order']['startDate']['hour']; $minute = $this->data['Order']['startDate']['min']; $year = $this->data['Order']['startDate']['year']; $month = $this->data['Order']['startDate']['month']; $day = $this->data['Order']['startDate']['day']; $start = @mktime($hour, $minute, 0, $month, $day, $year); $hour = $this->data['Order']['endDate']['hour']; $minute = $this->data['Order']['endDate']['min']; $year = $this->data['Order']['endDate']['year']; $month = $this->data['Order']['endDate']['month']; $day = $this->data['Order']['endDate']['day']; $end = @mktime($hour, $minute, 0, $month, $day, $year); $this->paginate = array('conditions' => array($time->daysAsSql($start, $end, 'Order.od_date'), 'Order.od_status' => 'Completed')); $orders = $this->paginate(); $countNum = count($orders); $this->set('orders', $orders); $this->set('totalNum', $countNum); $totalSum = $this->Order->get_total_payed_orders_sum($orders); $this->set('totalSum', $totalSum); } } //Y-m-d H:i:s mktime(); $beginningDay = mktime(0, 0, 0, 8, 2, 2011); /* pr($now); pr($time->format('Y-m-d H:i:s',$now)); pr($beginningDay); pr($time->format('Y-m-d H:i:s',$beginningDay)); $timeElapsed = time() - $beginningDay; pr(date('H:i:s', $timeElapsed)); pr($timeElapsed/60/60); //die; $orders = $this->Order->find('all', array('conditions' => array($time->daysAsSql($beginningDay, time(), 'Order.od_date')))); $totalSum = $this->Order->get_total_payed_orders_sum($orders); $this->set('orders', $orders); */ }