php 发送邮件【示例场景:发送订单保险运单邮件给第三方平台】
<?php
namespace app\index\controller;
use think\Db;
use service\ApiReturn;
use service\EmailSend;
class TimedTask extends Base
{
/**
* Notes:发送邮件
* @param $data
* @param $user
*/
public function index(){
// 创建一个PHPExcel对象
//excel数据
$excelData = $_excelData = [];
$condition = [] ;
$condition[] = [ 'order.status' , '=' , '9' ] ;
$condition[] = [ 'order.is_del' , '=' , '0' ] ;
$data = Db::name('order')
->alias('order')
->leftJoin('order_address start_address','start_address.order_id=order.aid and start_address.type=1')
->leftJoin('order_address end_address','end_address.order_id=order.aid and end_address.type=3')
->where($condition)
->whereTime('order.end_time','yesterday')
->field('order.order_sn,order.order_type,order.order_source,order.user_id,order.user_name,order.userMobile,order.cityName,order.start_time,order.end_time,order.receive_time,order.create_time')
->field('start_address.name startaddress_name,start_address.subDetailAddress startaddress_detail')
->field('end_address.name endaddress_name,end_address.subDetailAddress endaddress_detail')
->select();
foreach ($data as $key=>$value){
$data[$key]['create_time'] = date('Y-m-d H:i:s',$value['create_time']) ;
$data[$key]['receive_time'