<?php use org\rhaco\store\db\Q; \test\model\DateTime::find_delete(); $obj = new \test\model\DateTime(); $obj->ts('2015/07/21 12:13:14')->save(); $obj = new \test\model\DateTime(); $obj->ts('2015/07/22 12:13:14')->save(); $obj = new \test\model\DateTime(); $obj->ts('2015/07/23 13:13:14')->save(); $obj = new \test\model\DateTime(); $obj->ts('2015/07/21 14:13:14')->save(); eq(array('2015/07/21 00:00:00', '2015/07/22 00:00:00', '2015/07/23 00:00:00'), \test\model\DateTime::find_distinct('ts', Q::date_format('ts', 'Ymd'))); eq(array('2000/01/01 12:00:00', '2000/01/01 13:00:00', '2000/01/01 14:00:00'), \test\model\DateTime::find_distinct('ts', Q::date_format('ts', 'H')));
$obj->ts($date); $obj->num(20); $obj->save(); $date = strtotime('2015/07/30 12:34:56'); $obj = new \test\model\DateFormat(); $obj->ts($date); $obj->num(30); $obj->save(); foreach (\test\model\DateFormat::find(Q::date_format('ts', 'Ym')) as $o) { eq(date('Y/m/01 00:00:00', $date), $o->fm_ts()); } $date = strtotime('2015/08/30 12:34:56'); $obj = new \test\model\DateFormat(); $obj->ts($date); $obj->num(40); $obj->save(); $date = strtotime('2015/08/30 12:34:56'); $obj = new \test\model\DateFormat(); $obj->ts($date); $obj->num(20); $obj->save(); eq(4, sizeof(\test\model\DateFormat::find_sum_by('num', 'ts'))); eq(2, sizeof(\test\model\DateFormat::find_sum_by('num', 'ts', Q::date_format('ts', 'Ym')))); foreach (\test\model\DateFormat::find_sum_by('num', 'ts', Q::date_format('ts', 'Ym')) as $k => $num) { eq('2015', date('Y', $k)); eq(60, $num); } foreach (\test\model\DateFormat::find_sum_by('num', 'ts', Q::date_format('ts', 'm')) as $k => $num) { eq('2000', date('Y', $k)); eq(60, $num); }