找到Model.php
vendor\topthink\think-orm\src\Model.php
添加
* @method Query where(mixed
$field
, string
$op
= null, mixed
$condition
= null)
static
查询条件
* @method Query whereTime(string
$field
, string
$op
, mixed
$range
= null)
static
查询日期和时间
* @method Query whereBetweenTime(string
$field
, mixed
$startTime
, mixed
$endTime
)
static
查询日期或者时间范围
* @method Query whereBetweenTimeField(string
$startField
, string
$endField
)
static
查询当前时间在两个时间字段范围
* @method Query whereYear(string
$field
, string
$year
=
'this year'
)
static
查询某年
* @method Query whereMonth(string
$field
, string
$month
=
'this month'
)
static
查询某月
* @method Query whereDay(string
$field
, string
$day
=
'today'
)
static
查询某日
* @method Query whereRaw(string
$where
,
array
$bind
= [])
static
表达式查询
* @method Query whereExp(string
$field
, string
$condition
,
array
$bind
= [])
static
字段表达式查询
* @method Query when(mixed
$condition
, mixed
$query
, mixed
$otherwise
= null)
static
条件查询
* @method Query join(mixed
$join
, mixed
$condition
= null, string
$type
=
'INNER'
)
static
JOIN查询
* @method Query view(mixed
$join
, mixed
$field
= null, mixed
$on
= null, string
$type
=
'INNER'
)
static
视图查询
* @method Query with(mixed
$with
)
static
关联预载入
* @method Query
count
(string
$field
)
static
Count
统计查询
* @method Query min(string
$field
)
static
Min统计查询
* @method Query max(string
$field
)
static
Max统计查询
* @method Query sum(string
$field
)
static
SUM统计查询
* @method Query avg(string
$field
)
static
Avg统计查询
* @method Query field(mixed
$field
, boolean
$except
= false)
static
指定查询字段
* @method Query fieldRaw(string
$field
,
array
$bind
= [])
static
指定查询字段
* @method Query union(mixed
$union
, boolean
$all
= false)
static
UNION查询
* @method Query limit(mixed
$offset
, integer
$length
= null)
static
查询LIMIT
* @method Query order(mixed
$field
, string
$order
= null)
static
查询ORDER
* @method Query orderRaw(string
$field
,
array
$bind
= [])
static
查询ORDER
* @method Query cache(mixed
$key
= null, integer
$expire
= null)
static
设置查询缓存
* @method mixed value(string
$field
)
static
获取某个字段的值
* @method
array
column(string
$field
, string
$key
=
''
)
static
获取某个列的值
* @method Model find(mixed
$data
= null)
static
查询单个记录 不存在返回Null
* @method Model findOrEmpty(mixed
$data
= null)
static
查询单个记录 不存在返回空模型
* @method \think\model\Collection select(mixed
$data
= null)
static
查询多个记录
* @method Model withAttr(
array
$name
, \Closure
$closure) 动态定义获取器
找到DbManager.php
vendor\topthink\think-orm\src\DbManager.php
添加* Class DbManager
* @package think
* @mixin BaseQuery
* @mixin Query
* @method \think\db\Query master()
static
从主服务器读取数据
* @method \think\db\Query readMaster(bool
$all
= false)
static
后续从主服务器读取数据
* @method \think\db\Query table(string
$table
)
static
指定数据表(含前缀)
* @method \think\db\Query name(string
$name
)
static
指定数据表(不含前缀)
* @method \think\db\Query where(mixed
$field
, string
$op
= null, mixed
$condition
= null)
static
查询条件
* @method \think\db\Query whereRaw(string
$where
,
array
$bind
= [])
static
表达式查询
* @method \think\db\Query whereExp(string
$field
, string
$condition
,
array
$bind
= [])
static
字段表达式查询
* @method \think\db\Query when(mixed
$condition
, mixed
$query
, mixed
$otherwise
= null)
static
条件查询
* @method \think\db\Query join(mixed
$join
, mixed
$condition
= null, string
$type
=
'INNER'
)
static
JOIN查询
* @method \think\db\Query view(mixed
$join
, mixed
$field
= null, mixed
$on
= null, string
$type
=
'INNER'
)
static
视图查询
* @method \think\db\Query field(mixed
$field
, boolean
$except
= false)
static
指定查询字段
* @method \think\db\Query fieldRaw(string
$field
,
array
$bind
= [])
static
指定查询字段
* @method \think\db\Query union(mixed
$union
, boolean
$all
= false)
static
UNION查询
* @method \think\db\Query limit(mixed
$offset
, integer
$length
= null)
static
查询LIMIT
* @method \think\db\Query order(mixed
$field
, string
$order
= null)
static
查询ORDER
* @method \think\db\Query orderRaw(string
$field
,
array
$bind
= [])
static
查询ORDER
* @method \think\db\Query cache(mixed
$key
= null , integer
$expire
= null)
static
设置查询缓存
* @method \think\db\Query withAttr(string
$name
,callable
$callback
= null)
static
使用获取器获取数据
* @method mixed value(string
$field
)
static
获取某个字段的值
* @method
array
column(string
$field
, string
$key
=
''
)
static
获取某个列的值
* @method mixed find(mixed
$data
= null)
static
查询单个记录
* @method mixed select(mixed
$data
= null)
static
查询多个记录
* @method integer insert(
array
$data
, boolean
$replace
= false, boolean
$getLastInsID
= false, string
$sequence
= null)
static
插入一条记录
* @method integer insertGetId(
array
$data
, boolean
$replace
= false, string
$sequence
= null)
static
插入一条记录并返回自增ID
* @method integer insertAll(
array
$dataSet
)
static
插入多条记录
* @method integer update(
array
$data
)
static
更新记录
* @method integer
delete
(mixed
$data
= null)
static
删除记录
* @method boolean chunk(integer
$count
, callable
$callback
, string
$column
= null)
static
分块获取数据
* @method \Generator cursor(mixed
$data
= null)
static
使用游标查找记录
* @method mixed query(string
$sql
,
array
$bind
= [], boolean
$master
= false, bool
$pdo
= false)
static
SQL查询
* @method integer execute(string
$sql
,
array
$bind
= [], boolean
$fetch
= false, boolean
$getLastInsID
= false, string
$sequence
= null)
static
SQL执行
* @method \think\Paginator paginate(integer
$listRows
= 15, mixed
$simple
= null,
array
$config
= [])
static
分页查询
* @method mixed transaction(callable
$callback
)
static
执行数据库事务
* @method void startTrans()
static
启动事务
* @method void commit()
static
用于非自动提交状态下面的查询提交
* @method void rollback()
static
事务回滚
* @method boolean batchQuery(
array
$sqlArray
)
static
批处理执行SQL语句
* @method string getLastInsID(string
$sequence
= null)
static
获取最近插入的ID
暂无评论内容