php 发送邮件【示例场景:发送订单保险运单邮件给第三方平台】

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'
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值