ThinkAdmin基本操作

验证接收值以及值的格式

$data = $this->_vali([
   'contact_phone.require' => '请填写手机号码',
   'contact_phone.mobile' => '手机号码格式错误！',
   'password.require' => '请填写登录密码',
   'type.value'    => 4,   //默认值 
   'password.min:4' => '登录密码不能少于4位字符!',
]);

操作：添加

$this->app->db->name($this->table)->insert($data)   //$this->table表名  //$data 验证后的数据

操作：删除

$this->app->db->name('表名')->where($data)->delete()

操作：修改

  $this->app->db->name('SystemUser')->where(['id' => $user['id']])->update([
                'login_ip' => $this->app->request->ip(),
                'login_at' => $this->app->db->raw('now()'),
                'login_num' => $this->app->db->raw('login_num+1'),
            ]);

操作：查询

$query = $this->_query($this->table)->where(['uuid' => $this->uuid, 'type' => 4]);
$result = $query->whereIn('status', [1, 2])->order('id desc')->page(true, false, false, 15);   //page 分页