field('id') ->whereOr(['daypaynum'=>['neq',0]]) ->whereOr(['dayregnum'=>['neq',0]]) ->whereOr(['daymoney'=>['neq',0]]) ->select(); $a=0; $b=0; foreach($data as $k=>$v){ $r = db('tuiguang')->where('id',$v['id'])->update([ 'daypaynum'=>0, 'dayregnum'=>0, 'daymoney'=>0 ]); if($r){ $a++; }else{ $b++; } } db('applets_api')->where('wxid',0)->update(['number'=>1]); $c = Cache::store('redis')->set('info-30',$info); echo '成功推广链接:'.$a.' 失败条数:'.$b; echo '更新30天数据成功:'.$c; } }