wangdu_wechat/app/Console/Commands/Tool/ContinueReadTool.php

<?php
/**
 * Created by PhpStorm.
 * User: z-yang
 * Date: 2020/5/11
 * Time: 10:51
 */

namespace pp\Console\Commands\ToolA;


use Illuminate\Console\Command;

class ContinueReadTool extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'Tool:ContinueReadTool';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = '继续阅读推送表迁移';

    /**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * Execute the console command.
     *
     * @return mixed
     */
    public function handle()
    {
    }

    //寻找custom_push_keep_continue表距离当前一天的记录id
    private function findId(){
        $id = 0;
        while (true){
            if($id){
                $result = DB::connection('api_mysql')
                    ->table('custom_push_keep_continue')
                    ->where('id','<',$id)
                    ->select('id','created_at')->orderBy('id','desc')->first();
            }else{
                $result = DB::connection('api_mysql')->table('custom_push_keep_continue')->select('id','created_at')->orderBy('id','desc')->first();
            }
            if($result){
                foreach ($result as $item){
                    $id = $item->id;
                    if(strtotime($item->created_at) <= time()-86400*1.5){
                        return $item->id;
                    }
                }
            }else{
                break;
            }
        }
        return $id;
    }


}