How to get sorted one to many field with respect to max of a column in Laravel?

I am using Laravel 5.1 and want to get items sorted with respect to one column of the many field.

I have members and subscriptions. Each member has multiple subscriptions with end date as one of the column. I want to sort members with respect to subscriptions with maximum end dates.

I am using the code below but it selects first subscriptions and sort members with respect to first subscriptions.

Member::join('trn_subscriptions as subs', 'subs.member_id', '=', 'mst_members.id')
            ->select('mst_members.*', DB::raw('max(subs.end_date) latest_sub'))
            ->groupBy('mst_members.id')
            ->orderBy('latest_sub','desc')
            ->where('subs.end_date', '<', Carbon::today());

How can I achive sorting with respect to subscriptions for each member having maximum end dates below certain date?

Thank you in advance.

via Chebli Mohamed

How to Count Data from Another Function

I have a trouble from my controller. When i want to count the array from another function in controller is get a error cannot to count

I get this error

Call to a member function get() on array

This my controller :

Function A
public function detailFees(){
$dataArray = array(
    'datapayment' => $datapayment,
    'countafter' => $countafter,
    'countbefore' => $countbefore
  );
}

Function B
public function data(){
$data = count($this->detailFees($market)->get(datapayment))
}

I want to count just array data in datapayment with result in number

Thanks for help!

via Chebli Mohamed

Enable tls for phpredis configuration in laravel 5.6 application

the error shows that something like

[2023-06-27 13:51:56] dev.ERROR: read error on connection to {"exception":"[object] (RedisException(code: 0): read error on connection to /var/www/adflow2/webapp/vendor/laravel/framework/src/Illuminate/Redis/Connectors/PhpRedisConnector.php:69)

am currently using this configuration in config/database.php file. but it doesn't enable tls in aws.

    'redis' => [
        'client' => 'phpredis',

        'default' => [
            'scheme' => 'tls',
            'host' => env('REDIS_HOST', '127.0.0.1'),
            'password' => env('REDIS_PASSWORD', null),
            'port' => env('REDIS_PORT', 6379),
            'database' => env('REDIS_DB', 0),
         
        ],
        'session' => [
            'scheme' => 'tls',
            'host' => env('REDIS_HOST', '127.0.0.1'),
            'password' => env('REDIS_PASSWORD', null),
            'port' => env('REDIS_PORT', 6379),
            'database' => env('REDIS_SESSION_DB', 1), // Use a different Redis database for session
         
        ],
    ],

also restart the server after making changes.

via Chebli Mohamed

Property ... does not exist on this collection instance [duplicate]

I have 3 table :

• Table Grade :

  // MIGRATION
  Schema::create('grade', function (Blueprint $table) {
              $table->id();
              $table->string('grade');
              $table->timestamps();
          });
  
  // MODEL
  public function relationToBobot(){
  return $this->belongsToMany(Bobot::class, 'gradebobot', 'grade_id', 'bobot_id');
  }
  

• Table Bobot :

  // MIGRATION
  Schema::create('bobot', function (Blueprint $table) {
              $table->id();
              $table->string('bobot');
              $table->integer('harga');
              $table->timestamps();
          });
  
  // MODEL
  public function relationToGrade(){
  return $this->belongsToMany(Grade::class, 'gradebobot', 'bobot_id', 'grade_id');
  }
  

• Table Grade Bobot (Pivot)

  // MIGRATION
  Schema::create('gradebobot', function (Blueprint $table) {
              $table->id();
              $table->bigInteger('grade_id')->unsigned();
              $table->bigInteger('bobot_id')->unsigned();
              $table->timestamps();
              $table->foreign('grade_id')->references('id')->on('grade')->onDelete('cascade');
              $table->foreign('bobot_id')->references('id')->on('bobot')->onDelete('cascade');
          });
  

I want to show "grade" where have "bobot". This is my Controller :

public function test(){
        $grade = Grade::all();
    return view('welcome', compact('grade'));
    }

And this is my Blade View :

@foreach ($grade as $item)
    <h1></h1>
    @foreach ($grade->relationToBobot->where('grade_id', $item->id) as $item)
        <p></p>
    @endforeach
@endforeach

Can someone help me.. Thanks

Expectation :

A

100

200

300

400

B

500

600

700

800

C

900

1000

1100

1200

via Chebli Mohamed

file_exists(): open_basedir restriction in effect

I am develope a laravel app. I go to the route folder myapp/routes/web.php on serve and register a new route as follows:

Route::get('/linkstorage', function () {
    Artisan::call('storage:link');
});

when i enter https://chanvay.store/linkstorage and hit enter. Error appeared

ErrorException (E_WARNING) file_exists(): open_basedir restriction in effect. File(/home/chanvays/domains/chanvay.store/public_html/public/storage) is not within the allowed path(s): (/home/chanvays/:/tmp:/var/tmp:/opt/alt/php81/usr/share/pear/:/dev/urandom:/usr/local/lib/php/:/usr/local/php81/lib/php/) Anybody help me ?

Anybody help me fix this issue ? I can not comman php artisan storage:link on serve.

via Chebli Mohamed

Firebase Push Notification with Laravel 5.6

I am asking for help in push notification (especially Firebase Cloud Messaging : FCM). I already have checked the official documentation about it and it was pretty clear but i just wanna know how to have a simple summary of implementation of it using PHP Laravel 5.6 and what's the best practices on it . Thank you in advance for your help. I checked the official documentation of Firebase Cloud Messaging

via Chebli Mohamed

I Need to translate custom request validation Laravel

I Need to translate custom request validation laravel like extras.*.id.required

I Need to translate custom request validation laravel like extras.*.id.required i need to translate it without using messages() method i need the result get from translation files ,validation laravel

via Chebli Mohamed