start(); } private function start(){ $day = date('Y-m-d',time()+86400*10); $book = DB::table('book_configs')->where('is_on_shelf',2) ->where('copyright_limit_data','<=',$day) ->where('copyright_limit_data','>=',date('Y-m-d')) ->select('bid','book_name','copyright_limit_data') ->get(); $off_shelf_book = []; $alert_book = []; if($book){ foreach ($book as $item){ if($item->copyright_limit_data <= date('Y-m-d')){ $off_shelf_book[] = ['bid'=>$item->bid,'book_name'=>$item->book_name]; } if($item->copyright_limit_data == $day){ $alert_book[] = ['bid'=>$item->bid,'book_name'=>$item->book_name]; } } } //《陆先生的情之所至》将于2020.10.29日下架，请尽快确认！ if($alert_book){ $content = ''; foreach ($alert_book as $item_book){ $content .= sprintf('

《%s》将于%s日下架，请尽快确认！

',$item_book['book_name'],$day); } $this->warning('[网读]书籍下架提醒',$content); } if($off_shelf_book){ $to_insert = []; $bid = []; foreach ($off_shelf_book as $item){ $bid[] = $item['bid']; $to_insert[] = [ 'bid' => $item['bid'],'book_name'=>$item['book_name'],'channel_name'=>'', 'update_date' => date('Y-m-d'),'update_chapter_count'=>2,'update_words'=>1, 'update_type' => 'onshelfstatus','operator'=>'command-Book:BookAutoOffShelf', 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s') ]; } DB::table('book_updates')->insert($to_insert); DB::table('book_configs')->whereIn('bid',$bid)->update([ 'is_on_shelf'=>4,'updated_at'=>date('Y-m-d H:i:s') ]); } } private function warning($subject,$msg){ $notify = MessageNotify::mail([ 'to_emails' => implode(",", $this->emails), 'subject' => $subject, 'body' =>$msg, 'delay_times' => 0, ]); $notify->notify(); return ; } }