\think\db\concernTimeFieldQuery

时间查询支持

Summary

Methods

Properties

Constants

timeRule()
whereTime()
whereTimeInterval()
whereMonth()
whereWeek()
whereYear()
whereDay()
whereBetweenTime()
whereNotBetweenTime()
whereBetweenTimeField()
whereNotBetweenTimeField()

No public properties found

No constants found

No protected methods found

$timeRule

N/A

No private methods found

No private properties found

N/A

File: vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php
Package: Default
Class hierarchy: \think\db\concern\TimeFieldQuery

Properties

$timeRule

$timeRule : array

日期查询表达式

Type

array

Methods

timeRule()

timeRule(array  $rule) : $this

添加日期或者时间查询规则

Parameters

array

$rule

时间表达式

Returns

$this

whereTime()

whereTime(string  $field, string  $op, string|array  $range = null, string  $logic = 'AND') : $this

查询日期或者时间

Parameters

string	$field	日期字段名
string	$op	比较运算符或者表达式
string\|array	$range	比较范围
string	$logic	AND OR

Returns

$this

whereTimeInterval()

whereTimeInterval(string  $field, string  $start, string  $interval = 'day', integer  $step = 1, string  $logic = 'AND') : $this

查询某个时间间隔数据

Parameters

string	$field	日期字段名
string	$start	开始时间
string	$interval	时间间隔单位 day/month/year/week/hour/minute/second
integer	$step	间隔
string	$logic	AND OR

Returns

$this

whereMonth()

whereMonth(string  $field, string  $month = 'this month', integer  $step = 1, string  $logic = 'AND') : $this

查询月数据 whereMonth('time_field', '2018-1')

Parameters

string	$field	日期字段名
string	$month	月份信息
integer	$step	间隔
string	$logic	AND OR

Returns

$this

whereWeek()

whereWeek(string  $field, string  $week = 'this week', integer  $step = 1, string  $logic = 'AND') : $this

查询周数据 whereWeek('time_field', '2018-1-1') 从2018-1-1开始的一周数据

Parameters

string	$field	日期字段名
string	$week	周信息
integer	$step	间隔
string	$logic	AND OR

Returns

$this

whereYear()

whereYear(string  $field, string  $year = 'this year', integer  $step = 1, string  $logic = 'AND') : $this

查询年数据 whereYear('time_field', '2018')

Parameters

string	$field	日期字段名
string	$year	年份信息
integer	$step	间隔
string	$logic	AND OR

Returns

$this

whereDay()

whereDay(string  $field, string  $day = 'today', integer  $step = 1, string  $logic = 'AND') : $this

查询日数据 whereDay('time_field', '2018-1-1')

Parameters

string	$field	日期字段名
string	$day	日期信息
integer	$step	间隔
string	$logic	AND OR

Returns

$this

whereBetweenTime()

whereBetweenTime(string  $field, string|integer  $startTime, string|integer  $endTime, string  $logic = 'AND') : $this

查询日期或者时间范围 whereBetweenTime('time_field', '2018-1-1','2018-1-15')

Parameters

string	$field	日期字段名
string\|integer	$startTime	开始时间
string\|integer	$endTime	结束时间
string	$logic	AND OR

Returns

$this

whereNotBetweenTime()

whereNotBetweenTime(string  $field, string|integer  $startTime, string|integer  $endTime) : $this

查询日期或者时间范围 whereNotBetweenTime('time_field', '2018-1-1','2018-1-15')

Parameters

string	$field	日期字段名
string\|integer	$startTime	开始时间
string\|integer	$endTime	结束时间

Returns

$this

whereBetweenTimeField()

whereBetweenTimeField(string  $startField, string  $endField) : $this

查询当前时间在两个时间字段范围 whereBetweenTimeField('start_time', 'end_time')

Parameters

string	$startField	开始时间字段
string	$endField	结束时间字段

Returns

$this

whereNotBetweenTimeField()

whereNotBetweenTimeField(string  $startField, string  $endField) : $this

查询当前时间不在两个时间字段范围 whereNotBetweenTimeField('start_time', 'end_time')

Parameters

string	$startField	开始时间字段
string	$endField	结束时间字段

Returns

$this