php - 如何仅检索子模型中的过滤记录？

Question

我有一个表，我想用它来显示时间表日志的记录，我已经能够使用 whereHas 进行过滤，但是当我尝试按员工过滤时，我仍然会得到所有员工的日志而不是我正在寻找的那个。

我的控制器：

$request = json_decode(json_encode($request->all(), true))->params;

$jobs = Job::whereHas('timesheets', function($query) use ($request) {
    if (count($request->selected_employees) > 0) {
        $query->wherein('employee_id', $request->selected_employees);
    }
    if (count($request->selected_clients) > 0) {
        $query->wherein('client_id', $request->selected_clients);
    }
    if (!empty($request->start_date)) {
        $query->where('date','>=',$request->start_date);
    }
    if (!empty($request->end_date)) {
        $query->where('date','<=',$request->end_date);
    }
});

$jobs = (new Job)->generateReport($jobs->get(), $request->selected_employees);

$result = array_merge_recursive($jobs);

return $result;

我的模型迭代工作。到目前为止，除了称为“时间表”的子关系之外，一切都是准确的，它没有在这里定义，但是 laravel 会自动填充它，我无法用该属性覆盖/替换任何东西。有任何想法吗？

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Job extends Model

{
    use HasFactory;

/**
 * The attributes that are mass assignable.
 *
 * @var array
 */
protected $fillable = ["client_id", "job_number", "job_date", "payment_type", "rate", "description"];

public $totalHoursArray = array();
/**
 * @var array|mixed
 */
private $report_totals;

public function client() {
    return $this->belongsTo(Client::class);
}

public function timesheets() {
    return $this->hasMany(TimesheetLog::class);
}


public function creator(){
    return $this->belongsTo(User::class,'created_by');
}

public function editor(){
    return $this->belongsTo(User::class,'edited_by');
}


/**
 *
 * Returns a count of Employee Hours per job for timesheet entries
 * currently selected in the Job model
 *
 * @return array
 */
public function getEmployeeHoursPerJob($employee_ids){

    $i = 0;
    $hours_per_job = array();
    $timesheets = empty($employee_ids) ? $this->timesheets : $this->timesheets->whereIn('employee_id',$employee_ids);

    foreach ( $timesheets as $trow) {
        $trow->employee_code = Employee::find($trow->employee_id)->code;
        $date = new \DateTime($trow->date);
        $trow->date = date_format($date, 'd-m-Y');

        //find if the employee exists in the hours per job array if not, push a new row
        $found = array_search($trow->employee_id,array_column($hours_per_job, 'employee_id', isset($hours_per_job['employee_id']) ? 'employee_id' : null));

        if($i > 0 && $found !== false){
            $hours_per_job[$found]['total_time'] += $trow->total_time;
        } else {
            array_push($hours_per_job, ['employee_id' => $trow->employee_id, 'employee_code' => $trow->employee_code, 'total_time' => ($trow->total_time)]);
        }

        $i++;
    }

    return $hours_per_job;
}

public function generateReport($jobs, Array $employee_ids){

    $report_totals = array();
    $filtered_timesheets = array();

    foreach ($jobs AS $jobrow) {
        $i = 0;

        $jobrow->client_name = Client::find($jobrow->client_id)->name;
        $jobrow->attention = Client::find($jobrow->client_id)->attention;
        $jobrow->rate = "$".$jobrow->rate ." ". $jobrow->payment_type;

        $dateT = new \DateTime($jobrow->job_date);
        $jobrow->job_date = date_format($dateT, 'd-m-Y');

        $hours = $jobrow->getEmployeeHoursPerJob($employee_ids);
        $jobrow->employee_hours = $hours;


        foreach ($filtered_timesheets as $timesheetf){
            array_push($timesheets_filtered, $timesheetf);
        }

        foreach($hours AS $hoursRow){

            $found = array_search($hoursRow['employee_id'],array_column($report_totals, 'employee_id',
                                        isset($report_totals['employee_id']) ? 'employee_id' : null));


            if($found !== false){
                $report_totals[$found]['total_time'] += $hoursRow['total_time'];
            } else {
                array_push($report_totals, $hoursRow);
                $i++;
            }
        }
    }
    return compact('jobs','report_totals');
}



}

在 foreach 循环中，我将行的新属性分配给 where 查询，这是准确的，也是我想要的。但同样，我无法替换或分配要发送到视图的原始属性。

$jobrow->timesheets_filtered = $jobrow->timesheets->wherein('employee_id',$employee_ids)->toArray();

标签： phplaravel