abstract：//model擴展類<?php namespace app\model; use think\Model; use think\model\con
//model擴展類
<?php
namespace app\model;
use think\Model;
use think\model\concern\SoftDelete;
class User extends Model{
use SoftDelete;
protected $pk = 'id';
protected $table = 'reader';
protected $deleteTime = 'delete_time';
protected $defaultSoftDelete = 0;
}
//基于模型控制器方法 User.php
<?php
namespace app\index\controller;
use think\Controller;
use app\model\User as modelUser;
class User extends Controller{
//單條查詢
public function sele(modelUser $user){
$res = $user::get(2);
dump($res);
}
//多條查詢
public function select(modelUser $user){
$res = $user::all(function($query){
$query->where('salary','>','3000')
->where('age','>','32');
});
dump($res);
}
//插入單條數(shù)據(jù)
public function insert(modelUser $user){
$data = [
'name' => 'alice',
'age' => 28,
'tel' => '18956378989',
'email'=> '18956378989@139.com',
'salary'=> '5600'
];
$user::create($data);
}
//插入多條記錄
public function inserAll(modelUser $user){
$data = [
['name' => 'alice','age' => 28,'tel' => '18956378989','email'=> '18956378989@139.com','salary'=> '5600'],
['name' => '陳大益','age' => 36,'tel' => '15986379696','email'=> '15986379696@139.com','salary'=> '3900'],
['name' => '許大上','age' => 42,'tel' => '15236897979','email'=> '15236897979@qq.com','salary'=> '6500']
];
$res = $user->insertAll($data);
echo $res ? '插入成功' : '插入失敗';
}
//更新操作
public function update(modelUser $user){
$user::update(['salary' => \think\Db::raw('salary+500')],function($query){
$query->where('salary < 4000');
});
echo '更新成功';
}
//物理刪除
public function delete(modelUser $user){
//$res = $user::destroy(4);
$res = $user::destroy(function($query){
$query->where('salary > 6000');
});
echo $res ? '刪除成功' : '刪除失敗';
}
//軟刪除
public function softdel(modelUser $user){
$res = $user::destroy(6);
//普通查詢看不到時間戳字段的記錄
//dump($user::all());
//查詢回收站的記錄
//dump($user::onlyTrashed()->all());
//查詢含回收站的全部記錄
dump($user::withTrashed()->all());
}
}
Correcting teacher：天蓬老師Correction time：2019-11-01 14:40:00
Teacher's summary：在實際開發(fā)過程中, 任何用戶數(shù)據(jù)都是重要, 對于不再需要的數(shù)據(jù), 通過設置隱藏標志位來實現(xiàn)刪除是很有用的