Антон Антон

fetch -> API Laravel

return new class extends Migration
{
  /**
   * Run the migrations.
   */
  public function up(): void
  {
    $prefix = DB::getTablePrefix();
    $agreementTypesTable = "agreement_types";
    $profilesTable = "profiles";
    $agreementProfileTable = "agreement_profile";
    $sqlQuery = DB::table($agreementTypesTable)
      ->select([
        "$agreementTypesTable.id as agreement_type_id",
        "$agreementTypesTable.last_agreement_id as last_agreement_id",
        "$profilesTable.id as profile_id",
        DB::raw("!ISNULL($agreementProfileTable.profile_id) as last_agreement_approved"),
      ])
      ->join($profilesTable, DB::raw('1'), '=', DB::raw('1'))
      ->leftJoin($agreementProfileTable, function (JoinClause $join) use ($agreementProfileTable, $agreementTypesTable, $profilesTable) {
        $join->on("$agreementProfileTable.agreement_id", "=", "$agreementTypesTable.last_agreement_id")
          ->on("$agreementProfileTable.profile_id", "=", "$profilesTable.id");
      })
      ->toSql();

    DB::statement("CREATE VIEW ${prefix}agreement_type_profile AS ($sqlQuery)");
  }

  /**
   * Reverse the migrations.
   */
  public function down(): void
  {
    $prefix = DB::getTablePrefix();
    DB::statement("DROP VIEW ${prefix}agreement_type_profile");
  }
};

public function scopeWithLastApprovedByProfile(Builder $query, string $profileId): void
  {
    $query->withExists(['lastApproved as last_agreement_approved' => function ($q) use ($profileId) {
      $q->where('profile_id', $profileId);
    }]);
  }

AgreementType::whereNotNull('last_agreement_id')->withLastApprovedByProfile($profile->id);

* * * * * cd /полный/путь/до/сайта && /usr/bin/php8.3 artisan schedule:run >> /dev/null 2>&1

<link rel="stylesheet" href="{{ Vite::content('resources/css/style.css') }}">

Sometimes a model may have many related models, yet you want to easily retrieve the "latest" or "oldest" related model of the relationship. For example, a User model may be related to many Order models, but you want to define a convenient way to interact with the most recent order the user has placed. You may accomplish this using the hasOne relationship type combined with the ofMany methods: