wangdu_public_api/app/Console/Commands/SendOrder/SendStatsEmail.php

<?php

namespace App\Console\Commands\SendOrder;

use App\Modules\Book\Services\BookTagsService;
use App\Modules\Statistic\Services\SendStatsEmailService;
use Illuminate\Console\Command;
use App\Modules\Message\MessageNotify;
class SendStatsEmail extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'sendOrderEmail';

    /**
     * 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()
    {
        //
        $this->getSuperiorBooks();
        return ;
        $beginLastweek = date('Y-m-d',mktime(0,0,0,date('m'),date('d')-date('w')+1-7,date('Y')));
        $endLastweek   = date('Y-m-d',mktime(23,59,59,date('m'),date('d')-date('w')+7-7,date('Y')));

        $data = SendStatsEmailService::getOrderStats($beginLastweek,$endLastweek);

        $page = view('email.weekOrderStats',['datas'=>$data]);
        $html = response($page)->getContent();
        //\Log::info($html);
        $data_temp = array();
        $header = ['书籍ID','书籍名称','UV','注册用户数','注册/UV','强关粉','强关率（强关/注册）','充值金额','付费人数','充值/UV','强关付费率（付费/强关）','UV付费率（付费/UV）','派单数','男女频'];
        foreach ($data as $k=>$item) {
            $title='';
            switch ($k){
                case 0:$title='注册UV比高于85%';break;
                case 1:$title='注册UV比介于30%到85%';break;
                case 2:$title='注册UV比低于30%';break;
            }
            $temp = array('header'=>$header,'title'=>$title,'data'=>array());
            foreach ($item as $key=>$value) {
                $temp['data'][] = array(
                    $value['bid'],
                    $value['book_name'],
                    $value['UV'],
                    $value['register_user_sum'],
                    $value['UV']>0?(round($value['register_user_sum']/$value['UV'],4)*100).'%':0,
                    $value['force_user_sum'],
                    $value['register_user_sum']>0?(round($value['force_user_sum']/$value['register_user_sum'],4)*100).'%':0,
                    $value['recharge_sum'],
                    $value['pay_user_num'],
                    $value['UV']>0?round($value['recharge_sum']/ $value['UV'],2):0,
                    $value['force_user_sum']>0?(round($value['pay_user_num']/$value['force_user_sum'],4)*100).'%':0,
                    $value['UV']>0?(round($value['pay_user_num']/$value['UV'],4)*100).'%':0,
                    $value['send_orders_num'],
                    $value['pid']
                );
            }
            $data_temp[] = $temp;
        }
        $storage_file = 'app/last_week_send_order.xlsx';
       saveExcelDataToMultiSheet($data_temp,storage_path($storage_file));

        $to_user = array(
            ['address'=>'songdb@iqiyoo.com','name'=>'songdb'],
            ['address'=>'zhaojp@yqsd.net','name'=>'赵君平'],
            ['address' => 'zhoulj@iqiyoo.com', 'name' => '周灵杰'],
        );

        $to_users = '';
        foreach ($to_user as $item){
            $to_users .= $item['address'].";";
        }


        $notify = MessageNotify::mail([
            'to_emails' => $to_users,
            'subject' => "上周（ $beginLastweek 至 $endLastweek ）外部派单作品分析报表",
            'body' => $html,
            'delay_times' => 0,
        ]);
        $notify->addAttach($storage_file);
        $notify->notify();
        //SendStatsEmailService::SendHtmlEmailWithAcce($to_user,['subject'=>"上周（ $beginLastweek 至 $endLastweek ）外部派单作品分析报表",'body'=>$html],storage_path('app/last_week_send_order.xlsx'));
    }

    private function getSuperiorBooks() {
        $data = SendStatsEmailService::getOrderStatsNew();

        $page = view('email.daySendOrderStats',['datas'=>$data]);
        $html = response($page)->getContent();
        //\Log::info($html);
        $data_temp = array();
        $header = ['书籍ID','书籍名称','是否下架','篇幅','24小时uv','24小时充值总额','72小时uv','72小时充值总额','uv','24~72小时充值增长','24小时充值比24小时UV','72小时充值比24小时UV','强关率'];
        foreach ($data as $k=>$item) {
            $title='';
            switch ($k){
                case 0:$title='注册UV比高于85%';break;
                //case 1:$title='注册UV比介于30%到85%';break;
                case 1:$title='注册UV比低于30%';break;
            }
            $temp = array('header'=>$header,'title'=>$title,'data'=>array());
            foreach ($item as $key=>$value) {
                $temp['data'][] = array(
                    $value['bid'],
                    $value['book_name'],
                    $value['is_on_shelf']==1?'内部上架':'外部上架',
                    $value['charge_type']=='BOOK'?'短篇':'长篇',
                    $value['uv_one_day_sum'],
                    $value['recharge_amount_in_one_day'],
                    $value['uv_three_day_sum'],
                    $value['recharge_amount_in_three_days'],
                    $value['UV'],
                    $value['recharge_amount_in_one_day']>0?round(($value['recharge_amount_in_three_days']-$value['recharge_amount_in_one_day'])/$value['recharge_amount_in_one_day'],2):0,
                    $value['uv_one_day_sum']>0?round(($value['recharge_amount_in_one_day']/$value['uv_one_day_sum']),2):0,
                    //$value['uv_three_day_sum']>0?round(($value['recharge_amount_in_three_days']/$value['uv_three_day_sum']),2):0,
                    $value['uv_one_day_sum']>0?round(($value['recharge_amount_in_three_days']/$value['uv_one_day_sum']),2):0,
                    $value['register_user_sum']>0?(round(($value['force_user_sum']/$value['register_user_sum']),4)*100).'%':0,

                );
            }
            $data_temp[] = $temp;
        }
        $storage_file = 'app/last_week_send_order.xlsx';
        saveExcelDataToMultiSheet($data_temp,storage_path($storage_file));

        $to_user = array(
            ['address'=>'zhangzg@iqiyoo.com','name'=>'张总'],
            ['address'=>'chensj@zw88.net','name'=>'陈帅君'],
            ['address'=>'zhaojp@yqsd.net','name'=>'赵君平'],
            ['address'=>'liur@iqiyoo.com','name'=>'刘嵘'],
            ['address'=>'panxp@zw88.net','name'=>'潘霞萍'],
            ['address'=>'2711046732@qq.com','name'=>'樊柯'],
//            ['address'=>'lisy@zw88.net','name'=>'test'],

        );


        $to_users = '';
        foreach ($to_user as $item){
            $to_users .= $item['address'].";";
        }


        $notify = MessageNotify::mail([
            'to_emails' => $to_users,
            'subject' => '追书云'.date('Y-m-d',strtotime('-1 day'))."优质书外部派单分析报表",
            'body' => $html,
            'delay_times' => 0,
        ]);
        $notify->addAttach($storage_file);
        $notify->notify();
        //SendStatsEmailService::SendHtmlEmailWithAcce($to_user,['subject'=>'追书云'.date('Y-m-d',strtotime('-1 day'))."优质书外部派单分析报表",'body'=>$html],storage_path('app/last_week_send_order.xlsx'));
    }
}