thinkPHP6 CURD

//增
DataUserTransfer::mk()->insertGetId($data)
SystemNode::mk()->insertAll($data);
DataUserAddress::mk()->insert($data);


删

按条件删除
SystemNode::mk()->where($map)->delete();
清空数据
SystemOplog::mQuery()->empty();


//改
BasePostageCompany::mUpdate(
[
    'name'    => $vo['title'],
    'code_1'  => $vo['code_1'],
    'code_2'  => $vo['code_2'],
    'code_3'  => $vo['code_3'],
    'deleted' => 0,
], 'code_1')

BaseUserMessage::mk()->where(['id' => $id])->inc('num_read')->update([]);
ShopOrder::mk()->where($map)->update([
    'status'           => 0,
    'deleted_status'   => 1,
    'deleted_remark'   => '用户主动删除订单',
    'deleted_datetime' => date('Y-m-d H:i:s'),
])

$data = DataUserAddress::mk()->where($map)->find();
if (empty($data)) $this->error('需要删除的地址不存在！');
if ($data->save(['deleted' => 1]) !== false) {
    $this->success('删除地址成功！');
} else {
    $this->error('删除地址失败！');
}


//查
BaseUserUpgrade::mk()->where($map)->value('rebate_rule', '');
SystemNode::mk()->where($map)->column('node');
SystemMenu::mk()->order('sort desc,id asc')->column('id,pid,icon,url,node,title,params', 'id');

$map = ['username' => $data['username'], 'is_deleted' => 0];
$user = SystemUser::mk()->where($map)->findOrEmpty();
$user->inc('login_num')->update([
    'login_at' => date('Y-m-d H:i:s'),
    'login_ip' => $this->app->request->ip(),
]);


$user = SystemUser::mk()->find($data['id']);
if (!empty($user) && $user->save(['password' => md5(md5($data['password']))])) {
    sysoplog('系统用户管理', "修改用户[{$data['id']}]密码成功");
    $this->success('密码修改成功，请使用新密码登录！', '');
} else {
    $this->error('密码修改失败，请稍候再试！');
}

$query = ShopOrder::mk()->alias('a')->field('b.goods_code,b.goods_spec,ifnull(sum(b.stock_sales),0) stock_sales');
$query->leftJoin('shop_order_item b', 'a.order_no=b.order_no')->where("b.goods_code='{$code}' and a.status>0 and a.deleted_status<1");
$salesList = $query->group('b.goods_code,b.goods_spec')->select()->toArray();
//统计

DataUserTransfer::mk()->where($map)->count();

//事务

$this->app->db->transaction(function () use ($order, $items) {
    ShopOrder::mk()->insert($order);
    ShopOrderItem::mk()->insertAll($items);
});


管理后台操作

SystemBase::mForm('form');

public function state()
{
    ShopGoods::mSave($this->_vali([
        'status.in:0,1'  => '状态值范围异常！',
        'status.require' => '状态值不能为空！',
    ]), 'code');
}

SystemBase::mDelete();
WareInfo::mDelete('ware_id');//ware_id为主键
DataUserBalance::mDelete('', [['code', 'like', 'B%']]);

public function remove()
{
    ShopGoods::mSave($this->_vali([
        'deleted.in:0,1'  => '状态值范围异常！',
        'deleted.require' => '状态值不能为空！',
    ]), 'code');
}

protected function _delete_result()
{
    $this->_form_result(true);
}