=20 GROUP BY bid ORDER BY total_register_user_num desc LIMIT 10"; $outside_result = DB::select(sprintf($outside_sql, $date_begin, $date_end)); $to_user = array( ['address' => 'songdb@iqiyoo.com', 'name' => 'songdb'], ['address' => 'zhaojp@yqsd.net', 'name' => '赵君平'], ['address' => 'zhoulj@iqiyoo.com', 'name' => '周灵杰'], ); $content =''; if ($inside_result) { $content .= ""; foreach ($inside_result as $item) { $content .= ""; } $content .= "

类型	书本id	书名	总UV	总注册用户数
内部派单	{$item->bid}	{$item->book_name}	{$item->total_uv}	{$item->total_register_user_num}

"; } $content.=''; if ($outside_result) { $content .= ""; foreach ($outside_result as $item) { $content .= ""; } $content .= "

类型	书本id	书名	总UV	总注册用户数
外部派单	{$item->bid}	{$item->book_name}	{$item->total_uv}	{$item->total_register_user_num}

"; } SendStatsEmailService::SendHtmlEmailWithAcce($to_user, ['subject' => '网读云'.date("Y-m-d", time()) . "内外部派单按书统计数据", 'body' => $content]); } }