PHP/Laravel中“尝试获取非对象属性”错误的深度解析与解决方案

use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Mail;
// ... 其他use声明

// 假设这是你的控制器方法
public function sendDailyReports()
{
    $emailRecipients = DB::select("
        select 
            e.ID empID,
            e.lname lname,
            e.fname fname,
            e.email email,
            e.teamID,
            e.agencyID,
            e.accessProfileID, 
            e.accessTeams,
            c.ID coID,
            c.dDesc companyName,
            c.product,
            c.modules
        from 
            emailrecipient_tb er
                left join employee_tb e on er.empID = e.ID
                left join company_tb c on er.coID = c.ID
        where 
            er.isDAR = 1 and 
            er.isActive = 1 and
            c.isActive = 1
    ");

    foreach ($emailRecipients as $rowRecipient) {
        // 在这里，如果 $rowRecipient 意外地是 null 或非对象，
        // 那么在 Mail::to($rowRecipient->email) 之前，
        // 或者在 DailyActivityReport2 构造函数内部访问 $rowRecipient->coID 时就会报错。

        // **排查点：** 
        // 1. 在这里使用 dd($rowRecipient) 检查其类型和内容。
        // dd($rowRecipient); 

        // 防御性检查
        if (is_object($rowRecipient)) {
            Mail::to($rowRecipient->email)->send(new DailyActivityReport2($rowRecipient));
        } else {
            // 记录日志或跳过，处理非对象情况
            \Log::warning('Skipping non-object recipient: ' . json_encode($rowRecipient));
        }
    }
}

class DailyActivityReport2 extends Mailable
{
    // ... 声明公共属性
    public $coID;
    public $companyName;
    // ... 其他属性声明

    public function __construct($rowRecipient)
    {
        // 错误：这里将值赋给了局部变量 $coID，而非类的成员属性 $this->coID
        $coID = $rowRecipient->coID; 
        $companyName = $rowRecipient->companyName;
        // ... 其他属性赋值

        // 即使 $rowRecipient 是一个有效的对象，
        // 这里的赋值操作也只是创建了局部变量，类的成员属性 $this->coID 依然是 null。
        // 后续在 Mailable 的 build() 方法中如果访问 $this->coID->someProperty 就会报错。
    }

    // ... build 方法或其他使用类属性的地方
}

class DailyActivityReport2 extends Mailable
{
    use Queueable, SerializesModels;

    // 声明公共属性，这些属性将在视图中可用
    public $coID;
    public $companyName;
    public $product;
    public $rEmpID;
    public $rLname;
    public $rFname;
    public $rEmail;
    public $rAccessTeamID;
    public $rAccessAgencyID;
    public $rAccessProfileID;
    public $rAccessTeams;
    public $rModules; // 注意这里可能需要进一步处理，例如 json_decode

    /**
     * Create a new message instance.
     *
     * @param object $rowRecipient 从数据库查询获取的行对象
     * @return void
     */
    public function __construct(object $rowRecipient)
    {
        // 确保 $rowRecipient 是一个对象
        if (!is_object($rowRecipient)) {
            // 抛出异常或记录错误，不应继续执行
            throw new \InvalidArgumentException("Expected an object for rowRecipient, but received " . gettype($rowRecipient));
        }

        // 正确：使用 $this-> 关键字将值赋给类的成员属性
        $this->coID = $rowRecipient->coID ?? null; // 使用 null 合并运算符提供默认值
        $this->companyName = $rowRecipient->companyName ?? null;
        $this->product = $rowRecipient->product ?? null;
        $this->rEmpID = $rowRecipient->empID ?? null;
        $this->rLname = $rowRecipient->lname ?? null;
        $this->rFname = $rowRecipient->fname ?? null;
        $this->rEmail = $rowRecipient->email ?? null;
        $this->rAccessTeamID = $rowRecipient->teamID ?? null;
        $this->rAccessAgencyID = $rowRecipient->agencyID ?? null;
        $this->rAccessProfileID = $rowRecipient->accessProfileID ?? null;
        $this->rAccessTeams = $rowRecipient->accessTeams ?? null;

        // 对于需要特殊处理的属性，例如 JSON 解码
        $this->rModules = isset($rowRecipient->modules) ? json_decode($rowRecipient->modules) : null;
    }

    /**
     * Build the message.
     *
     * @return $this
     */
    public function build()
    {
        return $this->view('emails.daily-activity-report')
                    ->with([
                        'companyName' => $this->companyName,
                        'product' => $this->product,
                        // ... 其他属性
                    ]);
    }
}