thinkphp6 定时任务

  php think xsync:bill $output->info(json_encode($data)); p();打印文件 $this->app->log->notice(json_encode($params));打印日志文件 $this->app->log->info('下单', );
thinkphp6 定时任务

管理后台操作

SystemBase::mForm('form'); public function state() { ShopGoods::mSave($this->_vali(), 'code'); } SystemBase::mDelete(); WareInfo::mDelete('ware_id');//ware_id为主键 DataUserBalance::mDelete('', ]); public function remove() { ShopGoods::mSave($this->_vali(), 'code'); } protected function _delete_result() { $this->_form_result(true); }  
管理后台操作

thinkPHP6 CURD

//增 DataUserTransfer::mk()->insertGetId($data) SystemNode::mk()->insertAll($data); DataUserAddress::mk()->insert($data); 删 按条件删除 SystemNode::mk()->where($map)->delete(); 清空数据 SystemOplog::mQuery()->empty(); //改 BasePostageCompany::mUpdate( , 'code_1' => $vo, 'code_2' => $vo, 'code_3' => $vo, 'deleted' => 0, ], 'code_1') BaseUserMessage::mk()->where()->inc('num_read')->update(); ShopOrder::mk()->where($map)->update() $data = DataUserAddress::mk()->where($map)->find(); if (empty($data)) $this->error('需要删除的地址不存在！'); if ($data->save() !== 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 = , 'is_deleted' => 0]; $user = SystemUser::mk()->where($map)->findOrEmpty(); $user->inc('login_num')->update(); $user = SystemUser::mk()->find($data); if (!empty($user) && $user->save())])) { sysoplog('系统用户管理', "修改用户}]密码成功"); $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); });  
thinkPHP6 CURD

column()使用

应用 $users = SystemUser::mk()->column('nickname,username', 'id'); $this->success('获取成功', $users); { "code": 1, "info": "获取成功", "data": { "10000": { "nickname": "系统管理员", "username": "admin", "id": 10000 }, "10001": { "nickname": "aass", "username": "assa", "id": 10001 } } } $users = SystemUser::mk()->column('nickname,username'); $this->success('获取成功', $users); { "code": 1, "info": "获取成功", "data": } $users = SystemUser::mk()->column('nickname,username'); $user = array_unique(array_column($users, 'username')); $this->success('获取成功', $user); { "code": 1, "info": "获取成功", "data": } $a = ; $this->success('获取成功', arr2str($a)); "data": ",语文,属性," $a = '1,2,3,4'; $this->success('获取成功', str2arr($a)); { "code": 1, "info": "获取成功", "data": }      
column()使用

thinkPHP6多表查询

  thinkphp 跨表查询   //多表查询 public function index() { $this->title = '用户提现管理'; $this->transfer = UserTransferService::instance()->amount(0); // 创建查询对象 $query = DataUserTransfer::mQuery()->order('id desc'); // 用户条件搜索 $db = DataUser::mQuery()->like('phone,username|nickname#nickname')->db(); if ($db->getOptions('where')) $query->whereRaw("uuid in {$db->field('id')->buildSql()}"); // 数据列表处理 $query->equal('type,status')->dateBetween('create_at')->page(); }   生成的sql语句 SELECT * FROM `data_user_transfer` WHERE ( uuid in ( SELECT `id` FROM `data_user` WHERE ( `username` LIKE '%小白%' OR `nickname` LIKE '%小白%' ) ) ) ORDER BY `id` DESC LIMIT 0,20    
thinkPHP6多表查询

thinkPHP6使用

$vo = $vo ?? input('pid', '0'); $this->type = ltrim(input('type', 'ta'), 't'); $query->equal('status,usertype')->dateBetween('login_at,create_at'); $query->like('username,nickname,contact_phone#phone,contact_mail#mail'); $query->dateBetween('create_at')->like('title,desc')->equal('status,utype'); $query->like('name,code_1|code_3#code')->equal('status')->dateBetween('create_at'); 创建时间区间查询 create_at 模糊查询 title,desc 等于查询 status,utype $query->timeBetween('enter_time') 查询条件，并且校验 $map = $this->_vali(); 查询添加拼接 $map = ; $map = ; $map = ]; $map = ]; if (isset($data)) $map = ]; $map = , 'is_deleted' => 0]; $map = ; $data = str2arr($data ?? ''); $data = CodeExtend::uniqidNumber(20, 'A'); $this->usersTotal = DataUser::mk()->cache(true, 60)->count(); $this->days = $this->app->cache->get('portals', ); $this->app->cache->set('portals', $this->days, 60); DataUser::mk()->field('count(1) count,vip_code level')->group('vip_code')->cursor() SystemUser public function index() { //接受URL中的type。 admin/user.html?page=1&limit=20&type=index&output=layui.table&_order_=desc&_field_=sort+desc id $this->type = input('get.type', 'index'); // 创建快捷查询工具 SystemUser::mQuery()->layTable(function () { $this->title = '系统用户管理'; //$this->bases = SystemBase::items('身份权限'); }, function (QueryHelper $query) { // 加载对应数据列表 intval($this->type === 'index') =1 否则等于0 $query->where(); // 关联用户身份资料 $query->with(); // 数据列表搜索过滤 $query->equal('status,usertype')->dateBetween('login_at,create_at'); $query->like('username,nickname,contact_phone#phone,contact_mail#mail'); }); } /** * 关联身份权限 在model中定义的函数 * @return HasOne */ public function userinfo(): HasOne { return $this->hasOne(SystemBase::class, 'code', 'usertype')->where(); } public function index() { SystemOplog::mQuery()->layTable(function () { $this->title = '系统日志管理'; $columns = SystemOplog::mk()->column('action,username', 'id'); //效率不是很好 $this->users = array_unique(array_column($columns, 'username'));
thinkPHP6使用