where('date', $date)->orderBy('created_at')->get(); if ($result && count($result) > 0) { Log::info('check_official_account_forbidden_status need sendEmail'); $this->sendEmail($result); } else { Log::info('check_official_account_forbidden_status not need sendEmail'); } } function sendEmail($result) { Log::info('check_official_account_forbidden_status start sendEmail'); $to_user = array( ['address' => 'songdb@iqiyoo.com', 'name' => '宋栋波'], ['address' => 'zhaojp@yqsd.net', 'name' => '赵君平'], ['address' => 'zhoulj@iqiyoo.com', 'name' => '周灵杰'], ); $content = ""; $index = 0; foreach ($result as $item) { $index++; $content .= ""; } $content .= "

日期	站点id	appid	服务号名称	公司名称	封号时间
{$item->date}	{$item->distribution_channel_id}	{$item->appid}	{$item->nickname}	{$item->company_name}	{$item->forbbidden_time}

"; SendStatsEmailService::SendHtmlEmailWithAcce($to_user, ['subject' => date("Y-m-d", time()) . "网读昨天封号" . $index . "个", 'body' => $content]); } }