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);
*/
}
