PHP org\rhaco\store\db Q::date_format 예제들

예제 #1

파일: date_format_distinct.php 프로젝트: tokushima/rhaco3

<?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')));

예제 #2

파일: date_format.php 프로젝트: tokushima/rhaco3

$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);
}